LEED Reports in OpenStudio

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

hugopft
723 ●1 ●11

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

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

add a comment

8

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

MatthewSteen

10147 ●1 ●19 ●26 https://www.nrel.gov/b...

updated 2021-05-28 11:16:38 -0600

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.

Enhanced LEED Summary Report (BCL)
- Source code = https://github.com/JasonGlazer/LEEDre...

edit flag offensive delete link

Comments

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

Santiago Velez ( 2016-10-05 23:19:21 -0600 )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 ( 2016-10-06 07:00:49 -0600 )edit

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

JasonGlazer ( 2017-11-03 07:10:15 -0600 )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 ( 2022-08-04 23:13:21 -0600 )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 ( 2022-08-05 10:36:24 -0600 )edit

see more comments

6

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

JasonGlazer

6905 ●26 ●12 http://www.gard.com/

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

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.