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

Revision history [back]

click to hide/show revision 1
initial version

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 ? Thanks

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 sizing**.csv/.eio files ? Thanks

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