Help Exporting Parametric Arrays

Hi all,

I am running some parametric studies of a fuel cell-pv system. I am most interested in obtaining time series data that I can process later in MATLAB.

My outputs are all arrays of 87600 (hourly data for 10 years). When I export to Excel, I cannot figure out the pattern of data to organize. It seems that column A has some of the inputs and a lot of clipped data from column B when there is only one input, but it gets even more confusing when there are multiple inputs.

I'm just wondering if you guys know the best way to get the arrays of 87600 into columns or rows representing the outputs. 
I've attached the exported excel file for reference.

Thanks for any help!
John Carroll

Hi John,

SAM exports time series data from the parametric results in an awkward format because it can't use commas to separate the time series data within a cell, so it uses semicolons instead.

One option would be to export the data for the individual variables separately by clicking the value in the parametric results table. That should open a window with a table of data and buttons you can use to export the data.

Another trick that might work is to save the data as CSV instead of XLSX and then use a good text editor to 1) replace commas with tabs (\t) and then 2) replace semicolons with commas. Then save the file to a different name (to preserve the original data, just in case) and try opening it it in Excel.

Best regards,
Paul.

Paul,

Exporting the data by the individual variables worked.

Thanks!
John