Home Energy Score Assessor Calculator - 18Jan2017.ods
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Enter values in the salmon colored fields to calculate the weighted average of up to 3 components.
4
6
R-Value - Weighted AverageCeiling Height - Weighted Average
7
Column AColumn BColumn AColumn B
8
Building Component 1
R-value
Building Component 1
Area
Building Component 1
UA
1st Ceiling HeightFloor AreaBuilding Area 1 Volume
9
161006Cavity Insulation812009600Ceiling Height to Enter
10
1610
11
Building Component 2
R-value
Building Component 2
Area
Building Component 2
UA
2nd Ceiling HeightFloor AreaBuilding Area 2 Volume
12
0001290010800
13
14
Building Component 3
R-value
Building Component 3
Area
Building Component 3
UA
Cavity U-Factor3rd Ceiling HeightFloor AreaBuilding Area 3 VolumeAverage Ceiling Height
15
0000.06309.7
16
17
Instructions - R-value
Instructions - Ceiling Height
18
Use the Insulation De-rate calculator to determine batt insulation R-values to use above
Enter Ceiling Height of each space in column A
19
Use cavity insulation R-values
Enter the floor area corresponding to each ceiling height in column B
20
Enter the R-value for each building component in column A
Enter the "Ceiling Height to Enter" in the Home Energy Scoring Tool
21
Enter the area of the corresponding space with that R-value in colum B
22
Enter the "Assembly R-value" in the Home Energy Scoring Tool
23
Follow rules for choosing the appropriate value from the drop down lists in the Tool
24
25
AFUE - Weighted AverageHSPF/SEER - Weighted Average Energy Factor - Weighted Average
26
Column AColumn BColumn AColumn BColumn AColumn B
27
HVAC System 1 InputHVAC System 1 EfficiencySystem Weighted EfficiencyHVAC System 1 Output HVAC System 1 EfficiencySystem Weighted EfficiencyDHW System 1 InputDHW System 1 Energy FactorSystem Weighted Energy Factor
28
1000000.8585000Combustion System Efficiency48007.536000Heat Pump/AC Efficiency340000.5518700Energy Factor
29
0.888.10.64
30
HVAC System 2 Input HVAC System 2 EfficiencySystem Weighted EfficiencyHVAC System 2 Output HVAC System 2 EfficiencySystem Weighted EfficiencyDHW System 2 Input DHW System 2 Energy FactorSystem Weighted Energy Factor
31
600000.9255200240008.2196800400000.7228800
32
33
HVAC System 3 InputHVAC System 3 EfficiencySystem Weighted EfficiencyHVAC System 3 Output HVAC System 3 EfficiencySystem Weighted EfficiencyHVAC System 3 Input DHW System 3 Energy FactorSystem Weighted Energy Factor
34
000
35
36
Instructions - AFUE
Instructions - HSPF/SEER
Instructions - Energy Factor
37
Use the Equipment Efficiency Calculator to determine intial values to enter above
Use the Equipment Efficiency Calculator to determine intial values to enter above
Use the Equipment Efficiency Calculator to determine intial values to enter above
38
Enter Combustion Heating System Fuel Input (on the equipment in btus or gallons) in column A
Enter Heat Pump/AC size (in BTUs on the equipment) in column A
Enter Water Heater System Input (on the equipment) in column A
39
Enter the Combustion Heating System AFUE in column B
Enter the HSPF or SEER in column B
System Input can be BTU's or kWh but cannot be mixed
40
Enter the "Combustion System Efficiency" in Home Energy Scoring Tool
Enter the "Heat Pump/AC Efficiency" in the Home Energy Scoring Tool
Enter the Energy Factor in column B
41
Enter the "Energy Factor" in the Home Energy Scoring Tool
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
Loading...
 
 
 
Averaging Calculator
Insulation De-rate Calculator
Pivot Table 1
Equipment Efficiency Calculator
Floor-Roof Area
Insul_calcs
Eff_Calcs
Cath_calcs