{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","1-Building information","2-Energy use before retrofit","3-Energy use after retrofit","List items"],"not_rendered":{"charts":0,"images":31,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Instructions:"]
[]
["This excel calculator can be used to determine if the retrofit of a building qualifies for the clean buildings tax credit."]
[]
["To use this calculator, you’ll need:"]
[null,"1. Building information, including the"]
[null,null,"type of building"]
[null,null,"floor area"]
[null,null,"operating hours in an ordinary week, and"]
[null,null,"climate zone the building is located in"]
[null,"2. Type(s) and amount of fuel that entered and left the building before the retrofit (for a year that ends within 12 month before the retrofit begins)"]
[null,"3. Type(s) and amount of fuel that entered and left the building after the retrofit (for a year that ends on or before March 31, 2027)"]
[]
["Important:"]
[null,"1. You must fill out all three tabs '1-Building Information', '2-Energy use before retrofit' and '3-Energy use after retrofit'."]
[null,"2. If you skip fields, the calculator will not work correctly."]
[null,"3. At the bottom (row 79) of the tab '3-Energy use after retrofit', the calculator will tell you whether the retrofit meets the energy use target or not."]
[null,"4. This excel workbook has been password protected to prevent inadvertent changes. To remove incorrectly inputted values, use the backspace key."]
[null,"    The delete key will not work."]
[null,"5. Unchecking boxes does not clear the contents of the fields associated with that box. If unchecking boxes to make a different selection, be sure to clear "]
[null,"    the associated fields first using the backspace key. "]
[]
["This calculator is for information only and is not a part of the application process. The BC Ministry of Finance cannot guarantee the accuracy of these calculations"]
["as incorrect use of the calculator may result in inaccurate calculations. If there is discrepancy between this calculator and the online application form,"]
["assume the online application is correct."]

{"sheet":"1-Building information","index":1,"n_rows":108,"n_cols":42,"rows_kept":108,"cut":false,"hidden":false,"merged":[[56,24,56,35],[50,24,50,35],[44,24,44,35],[38,24,38,35],[32,24,32,35],[46,24,46,35],[86,24,86,35],[80,24,80,35],[74,24,74,35],[68,24,68,35],[100,24,100,35],[94,24,94,35],[88,24,88,35],[82,24,82,35],[76,24,76,35],[107,24,107,35],[3,0,4,23],[3,24,4,35],[62,24,62,35],[105,24,105,35],[26,24,26,35],[28,24,28,35],[103,24,103,35],[58,24,58,35],[52,24,52,35],[40,24,40,35],[34,24,34,35],[70,24,70,35],[64,24,64,35],[98,24,98,35],[92,24,92,35]]}
["Part 1: Building information"]
[]
["Building Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parcel Identifier (PID)"]
[]
[]
[]
["Is the building being retrofitted located in BC?"]
[]
["What type of building is it (select all that apply)?"]
[]
[null,"Multi-unit residential building - low-rise (3 or fewer stories)"]
[null,"Multi-unit residential building - high-rise (4 or more stories)"]
[null,"Accommodation (class 6 property only)"]
[null,"Colleges and universities"]
[null,"Food services"]
[null,"Hospitals"]
[null,"Logistics and warehouses"]
[null,"Long term care"]
[null,"Offices"]
[null,"Retail - food"]
[null,"Retail - other"]
[null,"Schools"]
[null,"Other class 6 or 8 buildings"]
[]
["'Multi-unit residential building - low-rise' building or building portion information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part EUI"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B11, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y29, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B11, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
["'Multi-unit residential building -  high-rise' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B12, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y35, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B12, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Accomodation' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B13, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y41, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B13, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Colleges and universities' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B14, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y47, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B14, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Food services' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B15, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y53, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B15, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Hospitals' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B16, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y59, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B16, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Logistics and warehouses' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B17, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y65, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B17, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Long term care' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B18, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y71, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B18, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Offices' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B19, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y77, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B19, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Retail - food' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B20, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y83, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B20, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Retail - other' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B21, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y89, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B21, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Schools' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B22, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y95, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B22, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[" 'Other class 6 or 8 buildings' building or building portion information:"]
[]
[null,"Floor area, expressed in square meters"]
[]
[null,"Operating hours in an ordinary week",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.XLOOKUP(B23, 'List items'!$A$2:$A$14, _xlfn.XLOOKUP($Y$104, 'List items'!$B$1:$D$1, 'List items'!$B$2:$D$14))*_xlfn.XLOOKUP(Y101, 'List items'!$F$1:$H$1, _xlfn.XLOOKUP(B23, 'List items'!$A$2:$A$14, 'List items'!$F$2:$H$14)), 0)","v":0}]
[]
[]
["Select the climate zone the building is in"]
[]
["Total floor area of the building, expressed in square meters (calculated from above)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(Y27+Y33+Y39+Y45+Y51+Y57+Y63+Y69+Y75+Y81+Y87+Y93+Y99, \"Error - check inputted values\")","v":0}]
[]
["Target energy use intensity (EUI) (calculated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AP29*Y27/$Y$106, 0)+IFERROR(AP35*Y33/Y106, 0)+IFERROR(AP41*Y39/Y106, 0)+IFERROR(AP47*Y45/Y106, 0)+IFERROR(AP53*Y51/Y106, 0)+IFERROR(AP59*Y57/Y106, 0)+IFERROR(AP65*Y63/Y106, 0)+IFERROR(AP71*Y69/Y106, 0)+IFERROR(AP77*Y75/Y106, 0)+IFERROR(AP83*Y81/Y106, 0)+IFERROR(AP89*Y87/Y106, 0)+IFERROR(AP95*Y93/Y106, 0)+IFERROR(AP101*Y99/Y106, 0)","v":0}]

{"sheet":"2-Energy use before retrofit","index":2,"n_rows":81,"n_cols":43,"rows_kept":81,"cut":false,"hidden":false,"merged":[[77,24,77,35],[64,24,64,35],[66,24,66,35],[68,24,68,35],[70,24,70,35],[72,24,72,35],[75,24,75,35],[62,24,62,35],[40,24,40,35],[42,24,42,35],[44,24,44,35],[46,24,46,35],[48,24,48,35],[50,24,50,35],[52,24,52,35],[54,24,54,35],[56,24,56,35],[58,24,58,35],[60,24,60,35],[38,24,38,35],[9,24,9,29],[9,30,9,35],[10,24,10,29],[10,30,10,35],[24,24,24,35],[28,24,28,35],[32,24,32,35],[34,24,34,35],[36,24,36,35],[26,24,26,35],[30,24,30,35]]}
["Part 2: Energy use before the retrofit"]
[]
["Instructions: Select the type(s) of energy used by the building before the retrofit and enter the amounts for a year "]
["(any 12 consecutive months). The chosen year must end within 12 months before the start of the retrofit."]
[]
[]
["Year ending within the 12 months before the retrofit begins:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year Start",null,null,null,null,null,"Year End"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YYYY/MM/DD",null,null,null,null,null,"YYYY/MM/DD"]
[]
[]
["Select the type(s) of energy used by the building before the retrofit:"]
[]
[null,null,"Fuel oil #1"]
[null,null,"Fuel oil #2"]
[null,null,"Fuel oil #4"]
[null,null,"Fuel oil #5L"]
[null,null,"Fuel oil #5H"]
[null,null,"Fuel oil #6"]
[null,null,"Propane"]
[null,null,"Natural gas"]
[null,null,"Electricity"]
[]
[null,"Total metered electricity that entered the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh",null,null,null,null,null,3.6]
[]
[null,"Total metered electricity that left the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh",null,null,null,null,null,3.6]
[]
[null,"Total metered natural gas that entered the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3",null,null,null,null,null,38.4]
[]
[null,"Total metered natural gas that left the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3",null,null,null,null,null,38.4]
[]
[null,"Total bulk fuel oil #1 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,37.6]
[]
[null,"Total deliveries of bulk fuel oil #1 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,37.6]
[]
[null,"Total bulk fuel oil #1 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,37.6]
[]
[null,"Total bulk fuel oil #2 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,38.700000000000003]
[]
[null,"Total deliveries of bulk fuel oil #2 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,38.700000000000003]
[]
[null,"Total bulk fuel oil #2 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,38.700000000000003]
[]
[null,"Total bulk fuel oil #4 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,40.700000000000003]
[]
[null,"Total deliveries of bulk fuel oil #4 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,40.700000000000003]
[]
[null,"Total bulk fuel oil #4 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,40.700000000000003]
[]
[null,"Total bulk fuel oil #5L inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.3]
[]
[null,"Total deliveries of bulk fuel oil #5L during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.3]
[]
[null,"Total bulk fuel oil #5L inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.3]
[]
[null,"Total bulk fuel oil #5H inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.8]
[]
[null,"Total deliveries of bulk fuel oil #5H during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.8]
[]
[null,"Total bulk fuel oil #5H inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.8]
[]
[null,"Total bulk fuel oil #6 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,42.9]
[]
[null,"Total deliveries of bulk fuel oil #6 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,42.9]
[]
[null,"Total bulk fuel oil #6 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,42.9]
[]
[null,"Total bulk propane inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,25.5]
[]
[null,"Total deliveries of bulk propane during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,25.5]
[]
[null,"Total bulk propane inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,25.5]
[]
[]
["Net energy of the building, expressed as megajoules (calculated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y25*AQ25-Y27*AQ27+Y29*AQ29+Y33*AQ33-Y31*AQ31+Y35*AQ35-Y37*AQ37+Y39*AQ39+Y41*AQ41-Y43*AQ43+Y45*AQ45+Y47*AQ47-Y49*AQ49+Y51*AQ51+Y53*AQ53-Y55*AQ55+Y57*AQ57+Y59*AQ59-Y61*AQ61+Y63*AQ63+Y65*AQ65-Y67*AQ67+Y69*AQ69+Y71*AQ71-Y73*AQ73","v":0}]
[]
["Energy use intensity (calculated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(Y76/'1-Building information'!Y106, 0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"25245/990","v":25.5}]

{"sheet":"3-Energy use after retrofit","index":3,"n_rows":79,"n_cols":43,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,24,78,35],[68,24,68,35],[70,24,70,35],[72,24,72,35],[74,24,74,35],[76,24,76,35],[66,24,66,35],[44,24,44,35],[46,24,46,35],[48,24,48,35],[50,24,50,35],[52,24,52,35],[54,24,54,35],[56,24,56,35],[58,24,58,35],[60,24,60,35],[62,24,62,35],[64,24,64,35],[42,24,42,35],[9,24,9,29],[9,30,9,35],[10,24,10,29],[10,30,10,35],[24,24,24,35],[28,24,28,35],[32,24,32,35],[34,24,34,35],[36,24,36,35],[38,24,38,35],[40,24,40,35],[26,24,26,35],[30,24,30,35]]}
["Part 3: Energy use after the retrofit"]
[]
["Instructions: Select the type(s) of energy used by the building after the retrofit and enter the amounts for a year "]
["(any 12 consecutive months). The chosen year must begin after the retrofit is completed and must end on or before "]
["March 31, 2027."]
[]
[]
["Year beginnning after the retrofit is completed and ending on or before March 31, 2027:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year Start",null,null,null,null,null,"Year End"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YYYY/MM/DD",null,null,null,null,null,"YYYY/MM/DD"]
[]
[]
["Select all types of energy used by the building after the retrofit:"]
[]
[null,null,"Fuel oil #1"]
[null,null,"Fuel oil #2"]
[null,null,"Fuel oil #4"]
[null,null,"Fuel oil #5L"]
[null,null,"Fuel oil #5H"]
[null,null,"Fuel oil #6"]
[null,null,"Propane"]
[null,null,"Natural gas"]
[null,null,"Electricity"]
[]
[null,"Total metered electricity that entered the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh",null,null,null,null,null,3.6]
[]
[null,"Total metered electricity that left the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh",null,null,null,null,null,3.6]
[]
[null,"Total metered natural gas that entered the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3",null,null,null,null,null,38.4]
[]
[null,"Total metered natural gas that left the building during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m3",null,null,null,null,null,38.4]
[]
[null,"Total bulk fuel oil #1 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,37.6]
[]
[null,"Total deliveries of bulk fuel oil #1 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,37.6]
[]
[null,"Total bulk fuel oil #1 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,37.6]
[]
[null,"Total bulk fuel oil #2 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,38.700000000000003]
[]
[null,"Total deliveries of bulk fuel oil #2 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,38.700000000000003]
[]
[null,"Total bulk fuel oil #2 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,38.700000000000003]
[]
[null,"Total bulk fuel oil #4 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,40.700000000000003]
[]
[null,"Total deliveries of bulk fuel oil #4 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,40.700000000000003]
[]
[null,"Total bulk fuel oil #4 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,40.700000000000003]
[]
[null,"Total bulk fuel oil #5L inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.3]
[]
[null,"Total deliveries of bulk fuel oil #5L during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.3]
[]
[null,"Total bulk fuel oil #5L inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.3]
[]
[null,"Total bulk fuel oil #5H inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.8]
[]
[null,"Total deliveries of bulk fuel oil #5H during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.8]
[]
[null,"Total bulk fuel oil #5H inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,41.8]
[]
[null,"Total bulk fuel oil #6 inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,42.9]
[]
[null,"Total deliveries of bulk fuel oil #6 during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,42.9]
[]
[null,"Total bulk fuel oil #6 inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,42.9]
[]
[null,"Total bulk propane inventory at the beginning of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,25.5]
[]
[null,"Total deliveries of bulk propane during the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,25.5]
[]
[null,"Total bulk propane inventory at the end of the year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,null,null,null,25.5]
[]
["Net energy of the building, expressed as megajoules (calculated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y25*AQ25-Y27*AQ27+Y29*AQ29-Y31*AQ31+Y33*AQ33+Y35*AQ35-Y37*AQ37+Y39*AQ39+Y41*AQ41-Y43*AQ43+Y45*AQ45+Y47*AQ47-Y49*AQ49+Y51*AQ51+Y53*AQ53-Y55*AQ55+Y57*AQ57+Y59*AQ59-Y61*AQ61+Y63*AQ63+Y65*AQ65-Y67*AQ67+Y69*AQ69+Y71*AQ71-Y73*AQ73","v":0}]
[]
["Energy use intensity (calculated)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(Y75/'1-Building information'!Y106, 0)","v":0}]
[]
["Retrofit meets energy-use target?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(Y77<'1-Building information'!Y108, Y77<'2-Energy use before retrofit'!Y78), \"Yes\", \"No\"), 0)","v":"No"}]

{"sheet":"List items","index":4,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Building type ","Zone 4 - 3,000 HDD or less","Zone 5 - Between 3,000 HDD and 4,000 HDD","Zone 6 - 4,000 HDD or more",null,"50 hours or less","More than 50 but less than 168 hours","168 hours"]
["Multi-unit residential building - low-rise (3 or fewer stories)",573,550,749,null,1,1,1]
["Multi-unit residential building - high-rise (4 or more stories)",644,658,842,null,1,1,1]
["Accommodation (class 6 property only)",902,923,1046,null,1,1,1]
["Colleges and universities",1003,1034,1420,null,1,1,1.2]
["Food services",2345,2328,3002,null,0.8,1,1.2]
["Hospitals",1787,2032,2919,null,1,1,1]
["Logistics and warehouses",470,505,710,null,1.2,1.3,1.3]
["Long term care",887,922,1272,null,1,1,1]
["Offices",678,720,864,null,0.9,0.9,1.2]
["Retail - food",1584,1555,1886,null,1,1,1.4]
["Retail - other",635,671,728,null,0.7,1.1000000000000001,1.5]
["Schools",553,578,835,null,1,1,1.2]
["Other class 6 or 8 buildings",595,638,734,null,0.8,1,1.2]
[]
["Zone 4 - 3,000 HDD or less"]
["Zone 5 - Between 3,000 HDD and 4,000 HDD"]
["Zone 6 - 4,000 HDD or more"]
[]
["50 hours or less"]
["More than 50 but less than 168 hours"]
["168 hours"]