Download ASHRAE Heat Load Calculation Excel Sheet XLS

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

Download also:  HVAC Cooling Load Excel Sheet and also ASHRAE 170 tables and calculation spreadsheet

ASHRAE Heat Load Calculation Spreadsheet

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.

Download ASHRAE Heat Load Calculation Spread Sheet