Excel Modules

The HVAC Engineering Book’s modules are:

Many existing HVAC computer programs conceal their algorithms and interim calculation results, often causing misinterpretation of inputs and outputs. To avoid these shortcomings, the modules are organized in interlinked tabs placed in the order of the design progress. The tabs expose virtually each step of the calculations accompanied by formulae descriptions.

The modules allow for design of air-conditioining systems supplying constant or variable air volume to up to 50 comfort zones.

The modules coded in Inch-Pound units were compared with the examples in the source ASHRAE handbooks and standards and the simulation by software tool HAP-4.3 (Carrier Inc) performed for the sample building. The validation results presented in the guide reveal expected deviations of the calculation outputs against the ASHRAE sources.

Consulting engineers have the option of integrating the modules with their existing spreadsheets in a customized system for time-effective production of HVAC projects. For example, a change in a window area input automatically changes the ductwork pressure loss, the air diffuser throw, etc.

The COMFORT module predicts an “average” feeling of comfort in spaces with radiant heating or cooling panels and other special indoor conditions. It allows for alternative selection of the design comfort parameters: panel radiant temperature, the indoor air's temperature, relative humidity, and velocity. The calculation algorithm adopts the method outlined in Standard 52-2004 “Thermal Environmental Conditions for Human Occupancy.” The first step calculates Mean Room Radiant Temperature and thermal asymmetry.  The second step calculates Predicted Mean Vote to quantify the comfort level at a selected set of comfort parameters. The module validation was based on comparison with the sample calculations provided by the standard.

The DESIGN LOADS module includes the following interlinked tabs:

The AIRFLOW module includes two tabs:

The WATERFLOW module includes three tabs:

 

people