Export SQL to CSV files OpenStudio Radiance

asked 2016-06-15 16:39:25 -0600

adityord
151 ●6

updated 2016-10-18 14:34:33 -0600

I am currently do simulation using OpenStudio Radiance 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 program i can use to transform eplusout.sql to the .csv file? . . .

Based on this thread Exporting full (component-level) simulation results to CSV from OpenStudio

Once the OS has been ran, you can turn the eplusout.eso file which contains the hourly results into a .csv by using the ReadVarsEAO.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 ReadVarsEAO.exe file and it will create a file called eplusout.csv.

image description

in my Energyplus Folder there is no ReadVarsEAO.exe. files, so what should i do next? thankyou

edit retag flag offensive close merge delete

Comments

ReadVarsESO.exe should be located in the PostProcess directory, which is a subdirectory/folder of your EnergyPlus-[version] directory, which is a subdir of the sharedresources subdirectory of your OpenStudio[version] directory.

rpg777 ( 2016-06-15 17:10:27 -0600 )edit

sure, i have to search in the PostProcess and also share folder, but still there is no .exe file name ReadVarsEAO.exe. i use the OpenStudio 1.11.5 Version.

adityord ( 2016-06-15 22:34:27 -0600 )edit

add a comment

2

answered 2016-06-16 05:28:47 -0600

Dinosaver
990 ●1 ●7

If you want to export E+ variables in CSV format you can either apply a measure from BCL (haven't tried it but still) or edit and run the exported out.idf file with option to export variables data to CSV file - this works well. If you want to export Radiance daylight simulation results, then you need to deal with .sql file it provides. Use one of SQLIte database browsers (like this) find a table with daylight results (either maps or for sensors) and export it as a CSV file. Be aware that natively SQLite keeps data as lists of values, not separating them through columns as we used to see in CSV files. You probably will need to format data either before or after the export.

edit flag offensive delete link

Comments

yess so i do the export using SQLite database browser. And now i had to learn more about this software. is it possible that we know what the units of data, in CSV files? because the result only number without the unit measure.

adityord ( 2016-06-19 11:27:05 -0600 )edit

Depends on what you export. E+ native CSV contains names of variables in the first row, but not their units, this you should know from E+ documentation. If you export CSV from SQL you can export ReportDataDictionary table as a separate CSV, there you see the units. Anyway if you want to receive a beautifully arranged report to present it on a meeting or whatever, you will definitely need some manual work :)