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

Is SqlFile the only way used by Open Studio to parse the E+ result? [closed]

asked 2015-09-01 02:42:11 -0500

zhengangzhu's avatar

updated 2017-05-08 18:21:31 -0500

Is SqlFile the only way used by Open Studio in RunManager to get the E+ result? And the only output used is the sql format?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by zhengangzhu
close date 2015-09-06 20:42:46.089347



I'm not sure if it's the only way (you can see the HTML table for example). But I assume you're looking for a way to get CSV data? If so there are a few options here, either by extracting them from the SQL file, or by rerunning the IDF that OpenStudio created directly in EnergyPlus.

Jamie Bull's avatar Jamie Bull  ( 2015-09-01 04:18:35 -0500 )edit

Actually I'd like to understand the way Open Studio dealing with the EnergyPlus results. 1. SqlFile to parse the SQL result and display in Runmanager. Is this the only way in Open Studio? 2. How OpenStudio triggers the EnergyPlus simulation? Is it also use the RunEP.bat in EnergyPlus or call the EnergyPlus.exe directly? Looks OpenStudio uses a lot of code like workflow, job in its RunManager.

zhengangzhu's avatar zhengangzhu  ( 2015-09-01 20:13:12 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2015-09-01 21:36:41 -0500

OpenStudio manages the EnergyPlus simulation process directly, it does not call the RunEP.bat file. OpenStudio does try to use the SqlFile as the only source for EnergyPlus results. This reduces the number of output formats that OpenStudio needs to deal with. One exception is the error file, OpenStudio does read the error file directly. OpenStudio has the ability to run Reporting Measures. These measures take the EnergyPlus simulation results and write out human readable html reports. Does that answer your question?

edit flag offensive delete link more


Yes. Thanks very much. So it will call EPMacro.exe, ExpandObjects.exe energyplus.exe directly? What's the benefit compared with RunEp.bat?

And why Open Studio design a little bit complicated EP run framework like workflow, job? To be generic to support other engines in the future?

zhengangzhu's avatar zhengangzhu  ( 2015-09-01 22:00:31 -0500 )edit

OpenStudio does not support EPMacro (OpenStudio Model Measures and EnergyPlus Measures replace this functionality). OpenStudio does run the ExpandObjects preprocessor but this may be removed in the future, especially if all HVAC templates are implemented as OpenStudio Measures. The standard workflow is defined here

macumber's avatar macumber  ( 2015-09-01 22:29:43 -0500 )edit

OpenStudio's RunManager was designed with a lot of extra requirements that we do not use anymore. We plan to replace RunManager with a wrapper around the simpler OpenStudio Workflow Gem. You can use the workflow gem to run EnergyPlus and OpenStudio Measures now. However, there is no C++ wrapper around the workflow gem yet so if you want to use this from C# you would have to make a system call to Ruby (or write a batch file) yourself.

macumber's avatar macumber  ( 2015-09-01 22:31:51 -0500 )edit

@zhengangzhu - Please mark the question as accepted (the check mark below the upvote and downvote buttons) if you're satisfied so the thread is marked as resolved/closed

Julien Marrec's avatar Julien Marrec  ( 2015-09-02 02:55:50 -0500 )edit

Question Tools

1 follower


Asked: 2015-09-01 02:42:11 -0500

Seen: 331 times

Last updated: Sep 01 '15