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

eplusout.eso in excel

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

rkbest's avatar

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

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

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

Waseem's avatar

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

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


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 -0600 )edit

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

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

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


@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 -0600 )edit

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 -0600 )edit

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

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

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

Nick N's avatar

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


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

edit flag offensive delete link more


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 -0600 )edit

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

Jim Dirkes's avatar

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


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 -0600 )edit

Your Answer

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

Add Answer

Training Workshops

Question Tools



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

Seen: 2,022 times

Last updated: Jul 14 '15