Output Data in CSV Format

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

Pranav
159 ●6

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

__AmirRoth__

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

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.

Comments

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

JasonGlazer ( 2017-02-02 07:20:02 -0600 )edit

add a comment

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

Adam Hilton

3465 ●1 ●15

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

Julien Marrec

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

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

Comments

@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 ( 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 ( 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.