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

ReadVarsEso - exporting to a spreadsheet

asked 2016-01-08 18:30:38 -0500

Wilson's avatar

updated 2016-01-09 07:57:43 -0500

Hi! I need to use OpenStudio output results to create my own graphs using a spreadsheet(Excel). At the moment I need do extract temperature data for each division of my building for one week of my running period with 1 hour time step. I read some similar doubts and it seems that for this purpose ReadVarsEso is used. Can you tell me step by step how can I use ReadVarsEso? I installed EnergyPlus but I’m not figuring out how I can do this. Do I have to re-run the input file created by OpenStudio with EnergyPlus? Is ReadVarsEso the best solution or there are more practical ways to do this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-01-08 18:48:03 -0500

Chandan Sharma's avatar

updated 2016-01-09 08:54:00 -0500

Please refer to InputputOutput Reference (link here) for information about using ReadVarsESO.

If the simulation is run via EP-Launch utility, that automatically runs ReadVarsESO and creates the output csv file provided input file has output:variable object/s in it. *.rvi file ensures that created output csv file has output variables in the order user wants them to be. There are many example files which also have .rvi files.

edit flag offensive delete link more


Thank you for your answer Chandan Sharma. I'm running my project via OpenStudio. I have to make a lot of simulations because my goal is to find my building optimal setpoints, so it won't be very practical to execute my project using OpenStudio and E+. Is there another way to send my OpenStudio output data to a spreadsheet? Thank you

Wilson's avatar Wilson  ( 2016-01-13 12:24:50 -0500 )edit

I haven't used OpenStudio much so far. If it creates eplusout.eso for simulation then double clicking ReadVarsESO would create eplusout.csv provided both are in the same directory.

Chandan Sharma's avatar Chandan Sharma  ( 2016-01-14 01:53:59 -0500 )edit

Thank you! That solved my problem!

Wilson's avatar Wilson  ( 2016-01-15 07:42:06 -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

1 follower


Asked: 2016-01-08 18:30:38 -0500

Seen: 1,027 times

Last updated: Jan 09 '16