Question-and-Answer Resource for the Building Energy Modeling Community
Get s tarted with the Help page
Ask Your Question

How can I extract my OpenStudio results to excel?

asked 2015-01-16 03:41:24 -0500

tfgjer gravatar image

updated 2015-07-11 19:02:09 -0500

I would like to make my own graphs with the OpenStudio data.

edit retag flag offensive close merge delete


Have a look at this answer

Jamie Bull gravatar image Jamie Bull  ( 2015-01-16 03:49:50 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2015-01-16 09:53:08 -0500

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.

edit flag offensive delete link more


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?

shahin1992 gravatar image shahin1992  ( 2016-04-28 22:04:23 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools



Asked: 2015-01-16 03:41:24 -0500

Seen: 1,056 times

Last updated: Jan 16 '15