ABCDEFGHIJKLMNOPQRSTUVWXYZ
2
INSTRUCTIONS AND BACKGROUND INFORMATION
3
1. The spreadsheet is made up of 7 tabs - 2 tabs for informational support; 5 tabs for boards to populate:
Instructions - Information for boards
UNIFORMAT Codes - Invformation for boards
App A - Renewable Energy - board to populate
App B - Design, Costruction, Retrofit - board to populate
App C - Operations & Maintenance - board to populate
App D - Occupant Behaviour - board to populate
NOTE
App E - Conservation Goals - board must enter Total Floor Area & Energy Consumption from latest FY (top left corner); all other data fields are automatically populated based on the data entered into Appendices A, B, C & D
4
2. Users should calculate the total investment across the board's asset porfolio for each row, on each tab
NOTE
* VFA Board Expenditure Report is useful in calculating many of these values
5
3. The equation for calculating the estimated energy savings is shown in the Word template, page 19
6
4. the following fields have been pre-populated for the sector, but can be changed by the user:
* Quantity of Time the Measure will be in place (years)
* Energy Payback Period
* % related to electricity (automatically calculates % of natural gas)
* unit cost of electricity and natural gas
7
5. Unit Costs
* this template has been prepopulated with the provincial weighted average electricity and natural gas unit costs from the FY2022- Sector Energy Cost Analysis Report
* boards can use another value if they choose
Option # 1 - use your board's unit costs from the FY2022 Sector Energy Cost Analysis Report (found in the UCD at the MEC_EDU level, under the Document tab
Option # 2 - use the Utility Cost Analysis Report (EDU 09) for FY2022 or FY2023 (Note: if using FY2023, you need to ensure all consumption data is updated in the UCD before generating or your values will be skewed) (found in the UCD, at your board portfolio level, under the Export tab) and manually enter the utility expenditures for each facility
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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