First time here? Check our help page!
2

SQL and sizing data

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

ngkhanh's avatar
2.2k
ngkhanh
asked 2016-12-28 06:23:06 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2016-12-28 08:21:50 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

3

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).

Archmage's avatar
7.2k
Archmage
answered 2016-12-28 07:31:46 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments