How can we view the resulting variable in excel for further processing or analysis. I have Openstudio but not able to figure out the way to use the ReadVarESO for this. Is there a tutorial detailing the possibilities. 
I need the breakup in simple form so that I can compare and replicate my model developed in HAP which does not allow custom optimizations .
OpenStudio does not create the eplusout.csv file containing the OutputVariables during a simulation. I've created this file after an OS sim using two methods:
Run the out.idf file produced by OS through EnergyPlus (slower). The IDF can be found in the EnergyPlusPreProcess folder of the OSM directory.
Run ReadVarsESO from a command line/shell/terminal (faster). The instructions below will allow you to simply enter the directory containing the ESO file and type readvarseso into the prompt instead of needing to copy the ReadVarsESO.exe file to the directory you want to run it in.
On a Windows machine copy the path to the ReadVarsESO.exe file to your system path. I find it's helpful to copy the contents of the PATH to a text editor for easier viewing and editing.
For example, paste C:\EnergyPlusV8-3-0\PostProcess into:
Control Panel > System > Advanced System Settings > Environment Variables > System Variables > PATH
(note that paths must be separated by a ;)
For viewing hourly data, try DView.
@MatthewSteen I don't have Eplus as itself, so I added the OS EPlus path as C:\Program Files\OpenStudio 1.7.0\share\openstudio\EnergyPlusV8-2-0\PostProcess. CMD readvarseso gives error as ' readvarseso' is not an internal or external command, operable program or batch file'
I just confirmed that this will work with the the EP installation included with OS. Make sure your changes to the system path were applied and that you closed/re-opened the command prompt. If that doesn't work, Google is your friend. Let us know what the issue was.
xEsoView is another free tool for quickly looking at .ESO output files.
It also allows you to copy results from the viewer and paste in excel.
Available HERE
To directly record all called variables to a CSV (Excel-readable) you can include this line in your idf:
.jpg "abdoo13")
OutputControl:Table:Style,Comma;
(This is also the output that the "variables" button in EP-Launch calls.)
When using the OutputControl object mentioned by Nick, you need OutputVariable: objects as well. It is helpful to also create an .RVI file to maintain the order of variables.
Asked: 2015-07-13 15:42:00 -0500
Seen: 2,328 times
Last updated: Jul 14 '15
