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