Building Thermal Analysis

Building Thermal Analysis & HVAC Sizing Tool - Cooling Load + AC Sizing + Thermal Comfort + Dynamic Simulation

Stop guessing when sizing an air conditioner. This Excel workbook gives you a structured, formula-driven workflow to calculate cooling loads, select the right AC unit, and verify that your indoor environment actually meets comfort standards — all without specialist software.

Four analyses in one file:

1. Cooling Load Calculation — Quantifies heat gain from walls, roof, windows (solar + conduction), occupants, lighting, equipment, and air infiltration using standard heat transfer formulas.
2. AC Sizing — Converts total load into practical capacity values: kW, BTU/h, PK (horsepower), and Tons of Refrigeration — with a configurable safety factor.
3. Thermal Comfort (PMV/PPD) — Implements the Fanger model per ISO 7730 and ASHRAE 55. Enter air temperature, humidity, air velocity, metabolic rate, and clothing insulation to get a Predicted Mean Vote and Predicted Percentage Dissatisfied.
4. Dynamic 24-Hour Simulation — See how indoor temperature evolves throughout the day as the AC cycles on and off, including a built-in chart.

Key features:

• Dual unit system: SI (°C, m) or Imperial (°F, ft) — switchable via dropdown
• Color-coded sheets for easy navigation
• Auto-generated recommendations and overall verdict on the Output Dashboard
• Built-in troubleshooting guide and typical parameter reference tables
• No macros or add-ins required — works in standard Excel

Perfect for: building engineers, HVAC consultants, architecture students, and technical buyers who need a defensible, well-documented preliminary estimate fast.