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

How to export graph from openstudio to excel?

asked 2017-03-07 09:26:57 -0500

sga's avatar

updated 2017-09-25 15:15:35 -0500

I have temperature and humidity graphs in openstudio I would like to export somehow to excel in order to plot a graph in excel. How can I do that?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2017-03-07 11:13:47 -0500

Assuming you are talking about the Tables in the OpenStudio Results HTML file you can just open that in a web-browser outside of OpenStudio and copy the table and paste into Excel.

If you need to do this at scale you can write a measure to create CSV file instead of HTML. Also PAT2 has the ability to write project reporting scripts that can save high level data (runner.registerValues in measures) across all datapoints in an analysis.

edit flag offensive delete link more



I am talking about the graphs I can see when opening the result viewer. I have a temperature graph and a humidity graph for a period of one year. I would like to plot corresponding point (temperature vs. humidity) on a graph in excel. Is there any way I can extract the data to copy it into Excel?

sga's avatar sga  ( 2017-03-07 15:51:15 -0500 )edit

I am trying to figure out the same thing, did you have any luck?

pksmith's avatar pksmith  ( 2018-02-26 12:03:05 -0500 )edit

@pksmith every chart in the report has a table that you can see by clicking on the blue box above the chart with the chart table. If you open the report in a web browser outside of the OpenStuido App or PAT, then . you can just copy and paste the tables from HTML to Excel.

David Goldwasser's avatar David Goldwasser  ( 2018-02-26 13:13:00 -0500 )edit

@David Goldwasser, does this provide the underlying data that was used to create the graphs? I'm after calculating the WBGT for the internal zone conditions, which requires using the hourly data as inputs to an equation.

Edit: What I ended up doing was running the in.idf file created by open studio in energy+, which generated a in.csv file holding the variables I needed.

pksmith's avatar pksmith  ( 2018-02-26 13:50:41 -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: 2017-03-07 09:26:57 -0500

Seen: 600 times

Last updated: Mar 07 '17