Exporting results data from Openstudio

Dear openstudio users and energy modeling professionals,

I was wondering if there is a way to export certain data from the simulation results (specifically i am trying to get gas consumption and operative temperature of my thermal zones) to a format that i can import in Matlab (eg. text file, excel file, etc.)? From the temporary folder i can get the eplusout file, but i cannot find a way to open or manipulate that file into a useful format to get the data i am looking for.

Thanks in advance for your replies.

claudi.alanis

asked 2015-05-27 11:00:55 -0500

4.4k

__AmirRoth__

updated 2015-11-09 20:57:14 -0500

edit flag offensive 0 remove flag close merge delete

Comments

Yes, from Matlab you can connect to the .sql data file that is an output of the E+ simulation that is run in OS. If you have the database toolbox its a line or two of code. Look for the sql driver that comes packaged with OS, that was key when I did it.

Setting up query that results in vectors of simulation data is a bigger step and takes a bit of thought to sort out correctly. The first step is to get connected though.

I find connecting through the sql database to be a bit more robust and easier when you are changing # of outputs etc. Creating a csv file and importing to ML works too

bryane (2015-06-19 22:34:38 -0500) edit

add a comment see more comments

You may want to look at this post on Getting CSV From SQL. If you do want to automate this through a measure we have an example measure that exports schedules to a csv file, and there's an answer here which explains its use. While this specific example exports input data from the OSM, you can use the same approach for tabular or time series sql data. You will have to learn how to do the sql queries to find the data you are looking for. A reporting measure can also inject variable requests ahead of the run if you need it.