E+ Output Variable Format Change

asked 2020-09-18 14:32:50 -0600

I want to separate the Annual values from the Monthly values within the Output Variables file. I'd like somehow separate the annual values and transpose them from vertical (column-wise) to horizontal (row-wise).

Attached picture for visual reference of the type of output needed: https://drive.google.com/file/d/17nSw...

It doesn't matter whether its a single output file (with both monthly values and transposed annual values) or two separate output files (one with monthly values and another with transposed annual values).

answered 2020-09-18 16:32:28 -0600

Julien Marrec

29706 ●94 ●76 http://www.effibem.com/

updated 2020-09-18 16:34:40 -0600

You cannot escape post-processing in that case. That falls in your own lap, E+ will not help with it.

As far as how you go about it, that's totally up to you, but personally I would just request the Output:SQLite,SimpleAndTabular; and then query the SQL directly, using Python for eg. It's quite easy then to single output Reporting Frequencies:

SELECT * FROM ReportVariableWithTime WHERE ReportingFrequency = "Hourly"

Or probably better yet;

SELECT EnvironmentPeriodIndex, Month, Day, Hour, Minute, KeyValue, Name, Units, Value
FROM ReportVariableWithTime
WHERE ReportingFrequency = "Hourly"

I'm pretty sure you can also figure out something in Excel directly using a combination of Pivot table and/or VBA, but that's not something I would personally spend time on.