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

SQL and sizing data

asked 2016-12-28 06:23:06 -0500

ngkhanh gravatar image

updated 2016-12-28 08:21:50 -0500

Hi, I am want to export autosized capacities of HVAC system for reviewing then assign them back to idf file. i found the parsing code from sql in OpenStudio fault detection github

"SELECT Value 
          FROM ComponentSizes 
          WHERE CompType='#{object_type}' 
          AND CompName='#{name}' 
          AND Description='#{value_name}' 
          AND Units='#{units}'"

My question is all autosize values (zone, system, plant) are in ComponentSizes table or not ? which sources is better from sql file or sizing**.csv/.eio files ? Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2016-12-28 07:31:46 -0500

Archmage gravatar image

The Component Sizing Summary table report includes all types of HVAC devices and should be complete.

You might find some cases where some details are missing that would be needed to create equivalent hard-sized versions of autosized IDF input objects (if that is your goal). The Engineering Reference documentation for the sizing calculations might need to be checked for some constants. The EIO output file is another important source for sizing information and not all of it is in the SQLite file (though it is being added for 8.7).

edit flag offensive delete link more

Your Answer

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

Add Answer


Question Tools

1 follower


Asked: 2016-12-28 06:23:06 -0500

Seen: 91 times

Last updated: Dec 28 '16