ASHRAE Heat Load Calculation Spreadsheet

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.