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

Revision history [back]

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.

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

OutputControl:Table:Style, Comma; 

Comma;

or

OutputControl:Table:Style, CommaAndHTML;  

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.