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

eplusout.eso in excel

asked 2015-07-13 15:42:00 -0500

rkbest gravatar image

updated 2015-07-13 19:40:29 -0500

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 .

edit retag flag offensive close merge delete

5 Answers

Sort by ยป oldest newest most voted
6

answered 2015-07-13 16:05:41 -0500

Waseem gravatar image

updated 2015-07-13 16:06:25 -0500

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.

edit flag offensive delete link more

Comments

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

abdoo13 gravatar imageabdoo13 ( 2016-10-03 11:52:23 -0500 )edit
6

answered 2015-07-13 16:21:26 -0500

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

edit flag offensive delete link more
6

answered 2015-07-14 08:38:06 -0500

updated 2015-07-14 10:35:53 -0500

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.

edit flag offensive delete link more

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 gravatar imagerkbest ( 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 gravatar imageMatthewSteen ( 2015-07-14 19:18:42 -0500 )edit
2

answered 2015-07-13 22:58:02 -0500

Nick N gravatar image

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.)

edit flag offensive delete link more

Comments

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

rkbest gravatar imagerkbest ( 2015-07-14 08:08:44 -0500 )edit
1

answered 2015-07-14 05:12:41 -0500

Jim Dirkes gravatar image

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.

edit flag offensive delete link more

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 gravatar imagerkbest ( 2015-07-14 08:10:57 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

 

Question Tools

2 followers

Stats

Asked: 2015-07-13 15:42:00 -0500

Seen: 863 times

Last updated: Jul 14 '15