Hvac Calculation Excel Sheet __full__ Link

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.