Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

E+ Output Variable Format Change

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

electroctopus's avatar

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:

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).

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

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

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

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.

edit flag offensive delete link more


Thanks Julien. Do you mean using Python app (and not Python plugin in E+)?

electroctopus's avatar electroctopus  ( 2020-09-19 02:22:40 -0500 )edit

I do mean using python itself, not the python plugin.

Julien Marrec's avatar Julien Marrec  ( 2020-09-22 04:01:16 -0500 )edit

Thanks a lot for your inputs

electroctopus's avatar electroctopus  ( 2020-09-22 04:03:06 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops

Question Tools

1 follower


Asked: 2020-09-18 14:32:50 -0500

Seen: 233 times

Last updated: Sep 18 '20