If you are building your own spreadsheet, use these standard conversions: Basic Heat Load ( Watts to BTU/hr BTU/hr to Tons Rule of Thumb 1 Ton per 400–500 sq. ft (Estimation only) Recommended Resources & Templates
For professional-grade spreadsheets, consider these sources: ASHRAE Templates: ASHRAE store Spreadsheet For Cooling Load Calculation Excel
When it comes to calculating the cooling load of a building, accuracy is crucial to ensure that the HVAC system is properly sized and efficient. One popular method for calculating cooling load is by using a spreadsheet, specifically Microsoft Excel. In this article, we will explore the benefits of using a spreadsheet for cooling load calculation, provide a step-by-step guide on how to create one, and offer a free downloadable template. If you are building your own spreadsheet, use
Let's consider an example of a small office building with the following characteristics: In this article, we will explore the benefits
CFM = Sensible Load (Btu/hr) / (1.08 * ΔT)
Using features like Excel's Goal Seek, you can quickly see how changing insulation or window types impacts the total load.
A comprehensive cooling load spreadsheet must account for both heat gains. 1. External Heat Gains Solar Radiation: Heat from sunlight through windows (glass). Conduction: Heat transfer through walls, roofs, and floors based on Infiltration: Hot outside air entering through cracks or doors. 2. Internal Heat Gains Sensible and latent heat based on activity level. Heat emitted by lamps (typically to get BTU/hr). Equipment: Heat from computers, printers, and kitchen appliances. 3. Ventilation