ABCDEFGHIJKLMNORSTUV
1
This EUI Calculator was created by the Vermont Green Building Network (VGBN).
2
For more info on VGBN, please visit: www.vtgreenbuildingnetwork.org
3
To use this spreadsheet:
1. Gather 12 continuous months of all fuel sources used in the building (bulk fuels may need to be allocated across years, or for the most accurate accounting, calculate for multiple years)
2. Fill in the yellow cells only
3. The calculations in the white cells will automatically populate your building Energy Use Intensity (EUI) and weather normalized EUI
4. Compare your building EUI (cell B28) with the regional average for that building type (cell B29)
4
5
Building TypeSingle family residential
6
Residential number of bedrooms
7
8
Energy Use Intensity (EUI) CalculationHDD Ratio:
*Refer to Table 1
Building SFTable 1. HDD Ratio:
9
Electrical UsageNatural Gas UsageOil UsagePropane UsageKerosene UsageWood UsageOther Usage**Burlington VT Heating Degree Day Data
10
DatekWhCCFGallonsGallonsGallonsCordBilling Data for YearHDD for billing yrAverage Annual HDDHDD RatioPeriod
11
2025 6,769 6,601 1.02545Calendar Year
12
2024 6,018 6,601 0.91168Calendar Year
13
2023 6,630 6,601 1.00439Calendar Year
14
2024, 2025 6,417 6,568 0.97701July-June
15
2023, 2024 5,960 6,568 0.90743July-June
16
2022, 2023 6,104 6,568 0.92935July-June
17
Special thanks to Energy Co-op of Vermont for providing this HDD data
18
19
20
21
22
23
TOTAL0.00.00.00.00.00.00.0
24
Energy Conversion Factor3.4102.9138.791.7135.022000.0
25
Total kBTUs0.00.00.00.00.00.00.0
26
Total Annual Energy Consumed (kBTUs from all sources)0.0
27
Building EUI 0.0kBTU/sf-yr
28
Weather Normalized Building EUI (kBTU/sf-yr)0.0kBTU/sf-yr
29
Building Type Regional Average EUI (kBtu/sf-yr)52.00kBTU/sf-yr
30
Building Type 50% reduction from Baseline (kBtu/sf-yr)26.00kBTU/sf-yr
31
Are you meeting the 50% Reduction from Baseline?YES
32
33
Renewable Energy Calculation
34
Solar Energy GeneratedWind Energy GeneratedHydro Energy GeneratedOther Energy Generated
35
DatekWhkWhkWh
36
37
38
39
40
41
42
43
44
45
46
47
48
TOTAL0.00.00.00.0
49
Energy Conversion Factor3.43.43.4
50
Total kBTUs0.00.00.00.0
51
Total Annual Energy Generated (kBTUs from all sources)0.0
52
Renewable Energy EUI0.0kBTU/sf-yr
53
Net Adjusted EUI (Normalized-Renewable Energy EUI) 0.0
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