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

LEED Reports in OpenStudio

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

hugopft's avatar

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
8

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

updated 2021-05-28 11:16:38 -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.


Update

There is now a OpenStudio Reporting measure.

edit flag offensive delete link more

Comments

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

Santiago Velez's avatar Santiago 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's avatar MatthewSteen  ( 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's avatar JasonGlazer  ( 2017-11-03 07:10:15 -0500 )edit

Hi Jason,

The Enhanced LEED Summary Report (BCL) link is not working anymore. I have downloaded the measure from your Github, it has an error message to it when I load it to OpenStudio:

wrong number of arguments (given 1, expected 0)

Any hints what could be wrong?

furtonb's avatar furtonb  ( 2022-08-04 23:13:21 -0500 )edit

@JasonGlazer see above. @furtonb most likely it hasn't been added to the new version of the BCL. https://bcl.nrel.gov/contribute

MatthewSteen's avatar MatthewSteen  ( 2022-08-05 10:36:24 -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

Careers

Question Tools

6 followers

Stats

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

Seen: 2,325 times

Last updated: May 28 '21