Energy Plus CSV from PAT

asked 2022-02-21 00:30:49 -0500

Vishak's avatar

updated 2022-02-23 12:19:28 -0500

I am trying to run multiple buildings using PAT and need to gather some building characteristics from the simulations. My earlier plan was to export those building characteristics through an export variable, however the export variable does not seem to have those listed. Consequently, I planned on using the Energy Plus tables csv from files to parse the results, however surprisingly PAT-OpenStudio-E+ combination do not export csv copy of E+tables. Is there a way to activate this feature and have the PAT simulation export E+ csv results? I am looking for static building characteristics that do not vary over 8760 hours and hence addmeter and addoutputvariable are probably out of the ballpark. Appreciate any help and pointers in this regard. Thanks

edit retag flag offensive close merge delete


If you are looking for data in the tables that make it into the eplustbl.htm report, and is stored in the tabular section fo the eplusout.sql file, then you can add a runner.registerValue object to an OpenStudio reporting measure. Then in PAT you can add that value as another column in the results.csv file, where each row is a datapoint and each column is a different type of value. If you need data from a different file, perhaps there is some datapoint cleanup going on that can be removed. Are you running locally or on cloud service?

David Goldwasser's avatar David Goldwasser  ( 2022-02-21 15:45:52 -0500 )edit

I am indeed looking for the tables feeding into eplustbl.htm; the analysis (manual analysis using multiple design alternatives) is run aternatively on local and cloud machines (AWS using PAT 3.0.0) and I did not see a eplustbl csv in either case. Curiously, I do not get an export of the results.csv file as well. I checked the measures for data_point clean up and the ExportMeterToCSV and AddMeter do not include any clean up commands(?). I am not using the measure ServerDirectoryCleanup, hence may not be a result of clean up due to this measure. [Contd.]

Vishak's avatar Vishak  ( 2022-02-21 20:22:51 -0500 )edit

Is there a separate measure needed to be run to export a results.csv? Not sure if the SimulationOutputReport measure can work here, since it did not have the static outputs

Vishak's avatar Vishak  ( 2022-02-21 20:25:28 -0500 )edit

You need at least one reporting measure to generate the runner.registerValues. This post gives a little more background.

David Goldwasser's avatar David Goldwasser  ( 2022-02-22 09:54:55 -0500 )edit

Thanks @DavidGoldwasser I will give this process a try and update the thread with my review. In the interest of time, I have currently used an R script to parse the eplusout.sql table and gather required data

Vishak's avatar Vishak  ( 2022-02-22 23:18:54 -0500 )edit