Energy Plus CSV from PAT
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 data_point.zip 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
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 theeplusout.sql
file, then you can add arunner.registerValue
object to an OpenStudio reporting measure. Then in PAT you can add that value as another column in theresults.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?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.]
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
You need at least one reporting measure to generate the runner.registerValues. This post gives a little more background.
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