How can I extract my OpenStudio results to excel?
I would like to make my own graphs with the OpenStudio data.
1 Answer
- Sort by
oldest newest most voted
6
When OpenStudio runs it produces all of the E+ outputs that you can use in Excel to create graphs. I have found that the easiest way to do this is to copy and paste data from the eplustbl.htlm output file into an Excel spreadsheet. This file is located in the project folder -> run -> 4-EnergyPlus-0 -> eplustbl.htm. The file has tons of data in spreadsheet form and you can find out more about it in the EnergyPlus InputOutputReference document.
If that file doesn't have what you are looking for you can also look into the eplusout.sql file.
Comments
thanks very much for these valuable information, i did exactly what you said to export meter data to CSV and it worked but i don't know where to find the CSV file?
Comments
Have a look at this answer