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

SQL and sizing data

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

ngkhanh's avatar

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

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
3

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

Archmage's avatar

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

Training Workshops

Careers

Question Tools

1 follower

Stats

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

Seen: 175 times

Last updated: Dec 28 '16