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

OpenStudio Export

asked 2016-06-08 07:39:09 -0500

Dustin's avatar

updated 2016-06-08 08:19:05 -0500

Hey all,

I am wondering if there is a way to export the information in the Spaces tab in OpenStudio. My place of employment likes the idea of being able to keep some of the information in these tabs in a spreadsheet that is easy for someone without OpenStudio on their computer to view this information. I am basically wondering if there are any export functions I can use to essentially grab these tables and put them an excel spreadsheet. Not sure if anyone else has ever done this before or if there is an easier way then just manually viewing the tabs in OpenStudio and type all of the entries into a spreadsheet.

Thanks in advance.

edit retag flag offensive close merge delete


Yes, this can be done with a measure. Are you mostly interested in internal load data, zone and story assignments, surface information, or all of the above? The space type summary section of.the standard report gives you an idea of this as an html table. You could do it to spaces ad a csv.

David Goldwasser's avatar David Goldwasser  ( 2016-06-08 07:56:07 -0500 )edit

Thanks for the quick reply! We are interested in the following information for each space: surfaces and the construction applied to them, the loads in the space, the thermal zone of the space, the equipment in the space. That is what I can think of off the top of my head and looking through OpenStudio. I guess I asked to see if anyone had done something similar and I figured it would be easier to write my own measure outputting the information in the exact format I desire. Thanks for the information will have to do a bit of research on measure writing now. Not at all comfortable with coding.

Dustin's avatar Dustin  ( 2016-06-08 08:11:42 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2016-06-08 12:24:42 -0500

updated 2016-06-08 12:25:13 -0500

As a start, running the 'Space Type Report' from the Sketchup plugin (Extensions > OpenStudio User Scripts > Reports > Space Type Report) will get you a csv file with Building-, Story-, Space Type- and Space-level information including areas, Thermal Zones, and internal loads. It doesn't have anything about surfaces or constructions, but could help you get familiar with querying the model and outputting results. You can find the ruby file in C:\Program Files\OpenStudio 1.11.4\Ruby\openstudio\sketchup_plugin\user_scripts\Reports.

edit flag offensive delete link more


Thank you very much Eric. This will be an excellent starting point and I, with a good amount of time, could modify this to output more information if required. Thanks for the file location as well I appreciate it.

Dustin's avatar Dustin  ( 2016-06-08 12:40:32 -0500 )edit

Nice find @Eric Ringold, I forgot about that - the original model input reporting measure. The idea was to check the energy model program vs. the required building program.

@Dustin if you want to convert the use script to a measure the main difference is file management for the CSV file. The Export Schedule CSV measure could be a good example of this. The main reason to switch to a measure vs. a SketchUp Plugin user-script is if you want access to this outside of SketchUp. Maybe you generate it every time you run a simulation, so it is always current.

David Goldwasser's avatar David Goldwasser  ( 2016-06-08 13:06:33 -0500 )edit

David thanks for the input. I will definitely want to use it after I have the SketchUp portion of the model done. Would we to be able to view output information such as the HVAC equipment associated with the space for example. I will definitely be looking into this, or maybe some of my coworker who are well versed in programming. Thanks again to you both for the help and pointing me towards some very helpful documents.

Dustin's avatar Dustin  ( 2016-06-08 13:57:39 -0500 )edit

@Dustin, HVAC equipment would be associated with a zone. But you could ask the space what zone it is in and then list it. But if you have multiple spaces per zone, you will want to manage how this is done, so isn't confusing.

David Goldwasser's avatar David Goldwasser  ( 2016-06-08 16:03:34 -0500 )edit

Your Answer

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

Add Answer

Training Workshops

Question Tools

1 follower


Asked: 2016-06-08 07:39:09 -0500

Seen: 237 times

Last updated: Jun 08 '16