How can I extract my OpenStudio results to excel?
I would like to make my own graphs with the OpenStudio data.
First time here? Check out the Help page!
I would like to make my own graphs with the OpenStudio data.
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.
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?
Please start posting anonymously - your entry will be published after you log in or create a new account.
Asked: 2015-01-16 03:41:24 -0600
Seen: 1,400 times
Last updated: Jan 16 '15
Have a look at this answer