Download ASHRAE Heat Load Calculation Excel Sheet


Download residential 
heating and cooling load calculation excel sheet according to - 2001 ASHRAE Fundamentals Handbook.

Cooling load calculations for HVAC:

This spreadsheet calculates the following:
1. Heat load calculations
2. Duct quantities
3. ASHRAE Table 5 -  Shading Coefficients and U-Factors for Residential Windows

This heating system sizing calculator is based on the ASHRAE standards. This calculator will calculate heating loads for air conditioning systems for residential places.

Important notes:

  • Weather and climatic information available Table 1A & 1B, Chp. 27, 2001 ASHRAE Fundamental Handbook
  • SHR = Sensible Load/Total Load Use: 0.65 for Tropic, 0.70 Humid, 0.75 Avg., 0.80 Dry, 0.85 Arid
  • Values curve fit fromTables 7 & 8, Chp. 28, 2001 ASHRAE Fundamental Handbook.
  • See Table 5, Chp. 28, 2001 ASHRAE Fundamental Handbook (reproduced ona another worksheet).
  • Values curve fit from Table 3, Chp. 28, 2001 ASHRAE Fundamental Handbook.
  • Values curve fit from Table 1, Chp. 28, 2001 ASHRAE Fundamental Handbook.
  • See Table 16, Chp. 28, 2001 ASHRAE Fundamental Handbook.

See more  ASHRAE 62.1 Ventilation Calculation Excel Sheet

Post a Comment

2 Comments