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

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

dsfakianakis

187 ●8 http://www.linkedin.co...

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

__AmirRoth__

4436 ●5 ●17 http://bleedinggreenna...

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 ( 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 ( 2015-08-19 02:17:28 -0600 )edit

add a comment

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

TaylorRoberts

2923 ●1 ●2 ●14 http://www.group14eng.com/

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

Julien Marrec

29716 ●94 ●76 http://www.effibem.com/

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

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 ( 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 ( 2015-08-19 14:12:30 -0600 )edit

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

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

see more comments

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

Comments

1 Answer

Comments

Your Answer

Training Workshops

Careers

Question Tools

Stats

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

Comments

1 Answer

Comments

Your Answer

Training Workshops

Careers

Question Tools

Stats

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