- Posts: 8
How to chart monthly/hourly production data?
- tam.hunt@gmail.com
- Topic Author
Less
More
26 Sep 2017 14:37 #5762
by tam.hunt@gmail.com
How to chart monthly/hourly production data? was created by tam.hunt@gmail.com
I'm not seeing any option for charting (tables) for monthly or hourly production figures. There is an option in the Data Tables tab for Hourly or Monthly data but I'm not seeing a simple generation profile option under these categories. To be specific: I'm looking to populate a bid spreadsheet annual production table that shows hourly production figures averaged over each month. So it's a 288 cell production profile rather than an 8760.
Please Log in or Create an account to join the conversation.
- pgilman
Less
More
- Posts: 5423
28 Sep 2017 12:10 #5763
by pgilman
Replied by pgilman on topic How to chart monthly/hourly production data?
Dear Tam,
I think you are looking for a 12-month-by-24-hour table of values, right? If so, you can generate that data from the profiles tab by right-clicking each graph to copy the data to a spreadsheet. That's a little tedious, but should work.
Here are the steps:
It would also be possible to write an LK script to process the hourly data into daily profiles by month.
Best regards,
Paul.
I think you are looking for a 12-month-by-24-hour table of values, right? If so, you can generate that data from the profiles tab by right-clicking each graph to copy the data to a spreadsheet. That's a little tedious, but should work.
Here are the steps:
- On the Profiles tab, display the data you want to export (check System power generated for production).
- Right-click the January graph, and choose Send data to Excel. Delete the "Time of day (January average)" column from the worksheet.
- Right-click the February graph, and choose Copy data to clipboard, and paste that data into the worksheet with the January data. Repeat that process for all months until you have a worksheet with 12 columns and 24 rows. You'll have to delete the extra Time of Day column for each month.
It would also be possible to write an LK script to process the hourly data into daily profiles by month.
Best regards,
Paul.
Please Log in or Create an account to join the conversation.
- tam.hunt@gmail.com
- Topic Author
Less
More
- Posts: 8
28 Sep 2017 15:31 #5764
by tam.hunt@gmail.com
Replied by tam.hunt@gmail.com on topic How to chart monthly/hourly production data?
Great, thanks Paul. A bit clunky but it works Would be good to add the production profile table as a default feature.
Please Log in or Create an account to join the conversation.
Moderators: pgilman