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

Exporting full (component-level) simulation results to CSV from OpenStudio

asked 2015-08-18 16:01:31 -0600

updated 2017-06-04 10:16:04 -0600

I am currently transitioning from ESP-r to EnergyPlus and would like to know how I can export full EnergyPlus simulation results to a .csv file through OpenStudio? If it's not possible, what would be a straightforward way to obtain these?

By full results I am referring to thermal and component side temperatures and flow rates per time step of the simulation.

edit retag flag offensive close merge delete

Comments

Perhaps these can be of assistance. If so, this should probably be closed as a duplicate question.

MatthewSteen gravatar image MatthewSteen  ( 2015-08-18 18:15:47 -0600 )edit

There's one answer that references the Add Output Variable measure but I wouldn't call this question a duplicate. Also @TaylorRoberts answer here is much more complete.

Jamie Bull gravatar image Jamie Bull  ( 2015-08-19 02:17:28 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
7

answered 2015-08-18 17:56:12 -0600

updated 2016-06-16 00:17:40 -0600

First you need to ask OS for whatever variable you want hourly or sub-hourly reports for. You can use the Add Output Variable script from the BCL and add it to the model in the Always Run Measure area of the measures tab. You can find the available variables in your model from the eplusout.rdd file. Copy in the variable name into the measure:

image description

Once the OS has been ran, you can turn the eplusout.eso file which contains the hourly results into a .csv by using the ReadVarsESO.exe program that comes with E+ located here : C:\EnergyPlusV8-3-0\PostProcess

I usually copy the eplusout.eso file into a empty folder and then also copy in the ReadVarsEAO.exe. Simply double click the ReadVarsESO.exe file and it will create a file called eplusout.csv.

image description

edit flag offensive delete link more

Comments

Thanks Taylor! Looks like that's exactly what I was looking for. Can you define and add more than one "Add output variable" scripts, and print more than one parameters in the .csv file? I will try this, play around a bit and report back.

Thanks again!

dsfakianakis gravatar image dsfakianakis  ( 2015-08-19 08:22:27 -0600 )edit

Worked like a charm!

The only nuisance is that along with the hourly zone temperatures, I get ambient temperature values on a 10 min timestep. This leaves a lot of blank cells in the zone temperature columns and would make a possible copy - paste action more challenging. I suppose I could go in the script and change the reporting interval for ambient temperature? If you have any thoughts on that please share, otherwise you can close this topic.

http://tinypic.com/r/av0ykx/8

Thanks again for your help!

dsfakianakis gravatar image dsfakianakis  ( 2015-08-19 14:12:30 -0600 )edit

You were able to fix the problem of the temperatures that appear every ten minutes?

oagb gravatar image oagb  ( 2017-02-28 11:03:26 -0600 )edit

Awesome. Thank you for your answer! It seems like some kind of script (written in Python or C) could be very helpful with this kind of workflow, especially when using the PAT.

njones gravatar image njones  ( 2017-05-26 16:57:08 -0600 )edit

Hi, I added 3 output variables through the measures as explained above, and I can see the results in the ResultsViewer as a graph, but when I convert the eplusout.eso to a CSV file, I cannot see those 3 variables in the excel spreadsheet. Any ides why? Maybe because I added 3 variables and not one? THANKS!

Yael gravatar image Yael  ( 2017-11-26 02:23:19 -0600 )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

4 followers

Stats

Asked: 2015-08-18 16:01:31 -0600

Seen: 1,892 times

Last updated: Jun 16 '16