First time here? Check our help page!
8

eplusout.eso in excel

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. image description

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 .

rkbest's avatar
1.4k
rkbest
asked 2015-07-13 15:42:00 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2015-07-13 19:40:29 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

5 Answers

7

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:

  1. Run the out.idf file produced by OS through EnergyPlus (slower). The IDF can be found in the EnergyPlusPreProcess folder of the OSM directory.

  2. 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's avatar
10.1k
MatthewSteen
answered 2015-07-14 08:38:06 -0500, updated 2015-07-14 10:35:53 -0500
edit flag offensive 0 remove flag delete link

Comments

@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'

rkbest's avatar rkbest (2015-07-14 10:31:04 -0500) edit
1

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.

MatthewSteen's avatar MatthewSteen (2015-07-14 19:18:42 -0500) edit
add a comment see more comments
6

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

Lyle K's avatar
2.2k
Lyle K
answered 2015-07-13 16:21:26 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments
6

There is a Result Viewer by DesignBuilder that can be downloaded free of charge from HERE. More information about it can be found HERE.

P.S: You have to register before installing it.

Hope this will help.

Waseem's avatar
2.5k
Waseem
answered 2015-07-13 16:05:41 -0500, updated 2015-07-13 16:06:25 -0500
edit flag offensive 0 remove flag delete link

Comments

Thank you very much. This app is more flexible and better than OS results viewer itself. Thanks a lot again.

abdoo13's avatar abdoo13 (2016-10-03 11:52:23 -0500) edit
add a comment see more comments
2

To directly record all called variables to a CSV (Excel-readable) you can include this line in your idf:

OutputControl:Table:Style,Comma;

(This is also the output that the "variables" button in EP-Launch calls.)

Nick N's avatar
177
Nick N
answered 2015-07-13 22:58:02 -0500
edit flag offensive 0 remove flag delete link

Comments

I am using OpenStudio, unfortunately not played with original EP a lot due to the overwhelming amount of input out content.

rkbest's avatar rkbest (2015-07-14 08:08:44 -0500) edit
add a comment see more comments
1

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.

Jim Dirkes's avatar
3.5k
Jim Dirkes
answered 2015-07-14 05:12:41 -0500
edit flag offensive 0 remove flag delete link

Comments

DO not know how to do what you are suggesting. Any examples, tutorials will help. So you suggest to work with EP instead of Openstudio to get the full control of the program. Does OpenStudio lacks all whats suggested here?

rkbest's avatar rkbest (2015-07-14 08:10:57 -0500) edit
add a comment see more comments