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

How to export graph from openstudio to excel?

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

sga gravatar image

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
3

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

Comments

1

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 gravatar image sga  ( 2017-03-07 15:51:15 -0500 )edit

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

pksmith gravatar image 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 gravatar image 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 gravatar image 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

2 followers

Stats

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

Seen: 446 times

Last updated: Mar 07 '17