How to export graph from openstudio to excel?

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

20415 ●94 ●14 http://www.openstudio.net/

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

Comments

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 ( 2017-03-07 15:51:15 -0600 )edit

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

pksmith ( 2018-02-26 12:03:05 -0600 )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 ( 2018-02-26 13:13:00 -0600 )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 ( 2018-02-26 13:50:41 -0600 )edit

add a comment