I am looking for some help with manipulating the SAM results Excel data.
What came out was a pure list of each hourly value from 0100, 1 Jan to 2400,
31 Dec, with no separators or markers at all.
I want to convert it into a table format (24X365) so I can do some calculations comparing the SAM results to our hourly electrical usage data from our distribution company.
Do you know how to convert the SAM list to a table in Excel? I've been pulling my hair out for weeks, referencing many websites and Youtube videos trying to figure this out, to no avail.
I would greatly appreciate any help you can offer.
SAM exports hourly data in a single column of 8,760 values. Unfortunately, SAM does not have a function to export the data to tables with different dimensions.
Perhaps someone else has created a spreadsheet or other tool that can convert the 1x8760 table to a 24x365 table?
Best regards,
Paul.
