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

LEED Reports in OpenStudio

asked 2015-08-18 13:18:40 -0500

hugopft gravatar image

updated 2015-08-18 15:33:05 -0500

After run a simulation on OpenStudio, it is possible to have acess to the entire report of the model. However, to submit the reports to LEED process of certification, we need to take parts of this reports. Anybody Knows how to ask for those reports in separated, for instance: A file with the ANNUAL UTILITY PERFOMANCE SUMMARY; another file with INPUT VERIFICATION AND RESULTS SUMMARY, I mean, the big report broked into small ones.

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
6

answered 2015-08-18 14:56:45 -0500

updated 2015-08-18 15:14:28 -0500

I wouldn't completely trust the LEED Summary report from EnergyPlus, it's somewhat outdated and in need of some improvements (ref: issue #4588). In particular, the peak demand by end use reports the peak relative to the building's peak, not the absolute peak which is what GBCI looks at. For that, reference the Energy Meters report instead.

As far as I know, EnergyPlus doesn't allow the Summary Reports to be written to separate CSV files and I agree that this would be a great feature to have for streamlining workflows. In the past I've copied/pasted the tabular data I wanted from the Summary Reports into Excel and then linked cells to the LEED reports. Once it's set up the only tedious part is the copy/paste, but that can be solved with some creative measure writing and/or scripting.

See @JasonGlazer's Python script epXML2CSV for one solution. Mine involved writing a Python script that's called from a Reporting Measure.

edit flag offensive delete link more

Comments

Mathew, how do you call the Python script from a Reporting Measure?

Santiago Velez gravatar imageSantiago Velez ( 2016-10-05 23:19:21 -0500 )edit

Enclose the Python call in backticks, the exec() command won't work because it stops the current process. Here's an example.

# call Python from Ruby
`python python_file.py python_file_arg`
MatthewSteen gravatar imageMatthewSteen ( 2016-10-06 07:00:49 -0500 )edit

The issue with the demand values that Matt brought up was fixed in 8.8.0, see this pull request.

JasonGlazer gravatar imageJasonGlazer ( 2017-11-03 07:10:15 -0500 )edit
6

answered 2015-08-18 15:32:00 -0500

updated 2015-08-18 15:32:21 -0500

Not a perfect solution but if you put all the summary reports in a single file by doing this:

OutputControl:Table:Style, Comma;

or

OutputControl:Table:Style, CommaAndHTML;

then link the entire CSV file into an Excel spreadsheet. You can do some creative things with MATCH or VLOOKUP to find a specific row containing a report name and then INDEX to pull the lines following that into a new part of the spreadsheet. Painful to set up the first time, but at least is is reusable.

edit flag offensive delete link more

Your Answer

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

Add Answer

 

Question Tools

6 followers

Stats

Asked: 2015-08-18 13:18:40 -0500

Seen: 875 times

Last updated: Aug 18 '15