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

Output Data in CSV Format

asked 2016-03-24 10:29:32 -0600

Pranav's avatar

updated 2017-07-22 10:05:49 -0600

I want to get the OpenStudio output variable values for 8,760 hours in CSV format. I know a couple of discussions have already taken place on this topic.

Based on the discussions, the best option seemed to be to run the out.idf file in the EnergyPlusPreProcess/ directory created by OS using EP-Launch. when I tried that, EP-Launch ran the simulation (4 min 20 sec) and created a couple of CSV files (outSsz and outZsz), but the "Cooling Tower Fan Cycling Ratio,hourly" variable I wanted did not show up in the files, and the eplusout.csv.

The variable DID show up in the out.eso file. I also got the following error:

C:\EnergyPlusV8-4-0\PostProcess\ReadVarsESO.exe is not a valid Win32 application

I have no idea what the error means. I suspect I am not getting the output variable due to this error.

edit retag flag offensive close merge delete


Are you using a 32bit or 64bit version of windows?

JasonGlazer's avatar JasonGlazer  ( 2017-02-02 07:20:02 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2016-03-24 10:52:48 -0600

Adam Hilton's avatar

updated 2017-02-02 01:48:11 -0600

ReadVarsESO is the program that extracts from the eso database and creates the csv file. So if E+ isn't able to run that file, you're not going to be able to get your csv variable output.

To troubleshoot it, you can try creating a folder and copying the files titled ReadVarsESO.exe and RunReadESO.bat into it (both found in the EnergyPlus PostProcess directory).

Then find the eplusout.eso file in the EnergyPlus folder of your simulation output and copy that into the same folder with the executable and the batch file.

Run the batch file and a csv document will be created in the same directory.

If that doesn't work, I'm not sure what to tell you other than reinstall EnergyPlus. Maybe someone else can provide more insight.

edit flag offensive delete link more


@adhilton, thank you the response! I tried to do so, but encountered the same error. Hope to find a resolution on the issue.... xEsoView is a program that allows me to save the output variable data in the csv format, but only for one variable at a time, and I need to export 40+ variables.

Pranav's avatar Pranav  ( 2016-03-24 11:18:12 -0600 )edit

Actually I was able to generate the csv file by running the "eplusout.eso" file with the "RunReadESO.bat" batch file from the EnergyPlusV8-3-0 documentation. My EnergyPlusV8-4-0 probably has an issue.

Pranav's avatar Pranav  ( 2016-03-24 11:33:24 -0600 )edit

Interesting. You can open up the batch files in a text editor and see what the difference is. Unless it was a change in the executable. My guess is that your read vars executable for 8-4 is corrupt.

Glad that worked out for you though.

Adam Hilton's avatar Adam Hilton  ( 2016-03-24 11:38:27 -0600 )edit

@adhilton the 2 batch files are identical.

Pranav's avatar Pranav  ( 2016-03-24 12:11:03 -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

1 follower


Asked: 2016-03-24 10:29:32 -0600

Seen: 1,937 times

Last updated: Feb 02 '17