Ensure your formulas subtract window and door surface areas from the gross wall area. Forgetting to do this double-counts wall space and skews insulation math.
Typically calculated at 250 Btu/h sensible heat and 200 Btu/h latent heat per occupant.
The fraction of solar radiation admitted through a window. hvac calculation excel sheet 2021
Dropdown menus or lookups linked to R-values for different insulation types, wall assemblies, roofing structures, and window Solar Heat Gain Coefficients (SHGC). Tab 3: Room-by-Room Breakdown The core worksheet where dimensional takeoff data is input.
If you are still using or considering a 2021 HVAC Excel sheet: Ensure your formulas subtract window and door surface
Tailored precisely to your firm's specific workflow; 100% transparent formulas; easy to integrate with custom equipment databases.
Modern buildings are filled with electronics. Your sheet should account for: The number of people and their activity levels. Lighting: LED vs. traditional lighting loads. The fraction of solar radiation admitted through a window
┌───────────────────────────┐ │ Total HVAC Design Load │ └─────────────┬─────────────┘ │ ┌───────────────────────┴───────────────────────┐ ▼ ▼ ┌───────────────────────────┐ ┌───────────────────────────┐ │ Sensible Heat Load │ │ Latent Heat Load │ │ (Changes Temperature) │ │ (Changes Humidity) │ └─────────────┬─────────────┘ └─────────────┬─────────────┘ │ │ ┌─────────────┴─────────────┐ ┌─────────────┴─────────────┐ │ • Envelope Conduction │ │ • Outdoor Infiltration │ │ • Solar Radiation (Glass) │ │ • Occupant Respiration │ │ • People & Lighting │ │ • Equipment / Appliances │ │ • Equipment / Infiltration│ │ │ └───────────────────────────┘ └───────────────────────────┘ 1. Sensible Heat vs. Latent Heat
The final dashboard that totals the heating and cooling loads for the entire building.