We will be performing a major infrastructure and web site ugprades on Friday, September 27th 8:00 am - 5:00 pm MST (UTC -7).

The website will be down during that time.

System Advisor Model (SAM)

How to chart monthly/hourly production data?

Start
Prev
1
Next
End

tam.hunt@gmail.com
Topic Author

26 Sep 2017 20: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

28 Sep 2017 18: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:

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.