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

Revision history [back]

This hasn't been "officially released" yet as part of OpenStudio, but it's available and we appreciate feedback from folks.

https://github.com/NREL/OpenStudio-analysis-spreadsheet

This is a link with install and rudimentary usage instructions for more direct and unfettered access to OpenStudio's EC-2 capability. It goes far beyond what PAT can do, and includes Latin Hypercube Sampling and multiple Optimization algorithms. The basic interface is a spreadsheet for specifying an analysis, and Ruby scripts that parse the spreadsheet to create an analysis. Once you're running in the cloud, the master server contains a pretty nice set of visualizations that allow you to explore data, download results in the form of csv, R data frames, or individual models with SQL output.

A few additional notes that are relevant at the time of this posting:

There is a linkage between PAT and this spreadsheet workflow. This allows PAT to be used locally to sanity check an analysis, then export it for expansion via the spreadsheet. We'll have more detailed documentation once the feature is hardened and we have better workflows, but it's useful in its current state.

The Ruby scripts that convert the spreadsheet to the JSON and related files that the master EC-2 server consumes are a good starting point for anyone wanting to create their own applications that leverage EC-2.

The EC-2 worker images include OpenStudio, EnergyPlus, AND Radiance. We have yet to build examples that leverage the cloud for integrated E+/Radiance analysis, but it's in there.

This hasn't been "officially released" yet as part of OpenStudio, but it's available and we appreciate feedback from folks.

https://github.com/NREL/OpenStudio-analysis-spreadsheet

This is a link with install and rudimentary usage instructions for more direct and unfettered access to OpenStudio's EC-2 capability. It goes far beyond what PAT can do, and includes Latin Hypercube Sampling and multiple Optimization algorithms. The basic interface is a spreadsheet for specifying an analysis, and Ruby scripts that parse the spreadsheet to create an analysis. Once you're running in the cloud, the master server contains a pretty nice set of visualizations that allow you to explore data, download results in the form of csv, R data frames, or individual models with SQL output.

A few additional notes that are relevant at the time of this posting:

  • There is a linkage between PAT and this spreadsheet workflow. This allows PAT to be used locally to sanity check an analysis, then export it for expansion via the spreadsheet. We'll have more detailed documentation once the feature is hardened and we have better workflows, but it's useful in its current state.

  • The Ruby scripts that convert the spreadsheet to the JSON and related files that the master EC-2 server consumes are a good starting point for anyone wanting to create their own applications that leverage EC-2.

  • The master server utilizes a combination of Ruby on Rails, R, MongoDB, and light web interface to interact with results. R is used to manage worker assignments and related algorithms. A handful of algorithms are currently supported, and it's fairly easy to add new ones, assuming they support R parallelization.

  • The EC-2 worker images include OpenStudio, EnergyPlus, AND Radiance. We have yet to build examples that leverage the cloud for integrated E+/Radiance analysis, but it's in there.

This hasn't been "officially released" yet as part of OpenStudio, but it's available and we appreciate feedback from folks.

https://github.com/NREL/OpenStudio-analysis-spreadsheet

This is a link with install and rudimentary usage instructions for more direct and unfettered access to OpenStudio's EC-2 capability. It goes far beyond what PAT can do, and includes Latin Hypercube Sampling and multiple Optimization algorithms. The basic interface is a spreadsheet for specifying an analysis, and Ruby scripts that parse the spreadsheet to create an analysis. Once you're running in the cloud, the master server contains a pretty nice set of visualizations that allow you to explore data, download results in the form of csv, R data frames, or individual models with SQL output.

A few additional notes that are relevant at the time of this posting:

  • There is a linkage between PAT and this spreadsheet workflow. This allows PAT to be used locally to sanity check an analysis, then export it for expansion via the spreadsheet. We'll have more detailed documentation once the feature is hardened and we have better workflows, but it's useful in its current state.

  • The Ruby scripts that convert the spreadsheet to the JSON and related files that the master EC-2 server consumes are a good starting point for anyone wanting to create their own applications that leverage EC-2.

  • The master server utilizes a combination of Ruby on Rails, R, MongoDB, and light web interface to interact with results. R is used to manage worker assignments and related algorithms. A handful of algorithms are currently supported, and it's fairly easy to add new ones, assuming they support R parallelization.

  • The EC-2 worker images include OpenStudio, EnergyPlus, AND Radiance. We have yet to build examples that leverage the cloud for integrated E+/Radiance analysis, but it's in there.

  • This framework can also be made to run on local clusters (via Vagrant) or other cloud services. We've not really packaged those as turnkey solutions yet. We plan to expose the image repo soon, so that clever people can port it to other services.