A good Excel sheet will automate the summation of all these zones into a total load, then convert BTU/hr to Tons (1 Ton = 12,000 BTU/hr).

Create a hidden tab called "Standards". On this tab, list all insulation types with their R-values. Then use: =VLOOKUP(A2, Standards!A:B, 2, FALSE) Now, you simply type "Fiberglass Batt" into a cell, and the sheet automatically pulls R-19.

Download our free "HVAC Load & Duct Sizing Excel Sheet" template below. Includes pre-loaded insulation R-values and climate data for 50 US cities. (No email required – instant .xlsx download).

Some common HVAC calculations performed using Excel sheets include:

logo metalgeddon red
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful. Read more about our Cookie Policy in our privacy statement.