{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Read First","Submission Data","_lookup_"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Read First","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Please read the following instructions before completing the Template"]
[]
[null,null,"1. Does the format in which the data is pasted into the Excel template matter?"]
[null,null,"Yes, the format in which the data is pasted into the template does matter. Please check the following before uploading your data to the portal:"]
[null,null,"• That the data is pasted into the correct fields"]
[null,null,"• That the units used are the same as the ones available in the pull-down options. Please note: the dropdown fields are case sensitive"]
[null,null,"• That the pasted data does not contain any embedded formulas"]
[null,null,"• Row 9 of the Excel Template is an example row only and will not be included in your benchmarked data. Please DO NOT delete this example row or any of the rows above this."]
[]
[null,null,"You will receive an error message if data is pasted into the wrong column or with formulas, or pasted units are not the same as the ones available in the pull-down menus."]
[]
[]
[null,null,"2. Why are the units of measurement that I entered into the excel template invalid?"]
[null,null,"Users must select the unit of measurement in the template from the pull down options. Any custom units entered will be considered invalid."]
[]
[]
[null,null," 3. Why do the totals for GHG Emissions and Energy Intensity not calculate automatically on the excel template?"]
[null,null,"The GHG Emissions and Energy Intensity values will calculate automatically once you have completed the data validation process. You do not need to finalize the data for these values to calculate. After the data validation process, you can download the spreadsheet with GHG Emissions and Energy Intensity data via the “Excel template” button on the reporting portal."]
[]
[null,null,"Note: that there are no macros functions in this year’s templates."]
[]
[null,null,"NOTE: Please DO NOT close the browser window during the downloading / uploading of the data. DO NOT move away from the page or close the browser."]
[]
[null,null,"Should you have any additional questions, please visit the Toolkit located on the reporting portal under the “Toolkit” tab on the homepage."]
[]
[null,null,"Otherwise, please feel free to contact us at BPSSupport@ontario.ca "]

{"sheet":"Submission Data","index":1,"n_rows":12,"n_cols":36,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Energy Consumption and Greenhouse Gas Emissions Reporting - for 2019"]
["Confirm consecutive 12-mth period (mth-yr to mth-yr)","Jan/2019 - Dec/2019"]
["Sector","Municipal Service Board"]
["Agency Sub-sector","Municipal"]
["Organization Name","Union Water System Join Board of Management"]
[]
[]
["Operation Name","Operation Type","Address","City","Postal Code","Total Floor Area","Unit","Avg hrs/wk","Annual Flow\n (ML)","Electricity\n Quantity","Electricity\n Unit","Natural\n Gas Quantity","Natural\n Gas Unit","Fuel Oil\n 1 & 2 Quantity","Fuel Oil\n 1 & 2 Unit"," Fuel Oil\n 4 & 6 Quantity","Fuel Oil\n 4 & 6 Unit","Propane\n Quantity","Propane\n Unit","Coal\n Quantity","Coal\n Unit","Wood\n Quantity","Wood\n Unit","District\n Heating Quantity","District\n Heating Unit","Renewable?","If Yes,\n enter Emission Factor","District\n Cooling Quantity","District\n Cooling Unit","Renewable?","If Yes,\n enter Emission Factor","GHG Emissions (Kg)","Energy Intensity (ekWh/sqft)","Energy Intensity (ekWh/Mega Litre)","Building / Operation Identifier","Comments"]
["Stephenson Building","Administrative offices and related facilities, including municipal council chambers","2160 Yonge Street","Toronto","M7A 2G5",135034,"Square feet",70,23516.002240000002,2181065,"kWh",125300,"Cubic meter",null,"Litre",null,"Litre",null,"Litre",null,"Metric Tonne",null,"Metric Tonne",26.73,"Giga Joule","No",0,20.506,"Giga Joule","No",0,{"$nulls":4},"max. 255 characters"]
["Cottam Booster Station UWSS","Facilities related to the pumping of water","163 Talbot Street E","Cottam","N0R 1B0",0,null,168,1371.77,240760,"kWh",7117.3559999999998,"Cubic Meter",{"$nulls":18},0,0,0]
["Low Lift Pumping Station UWSS","Facilities related to the pumping of water","1ED Conc Lot 9","Ruthven","N0P 2G0",0,null,168,17125,2226857.4855999998,"kWh",12299.813,"Cubic Meter",{"$nulls":18},0,0,0]
["Ruthven Water Treatment Plant","Facilities related to the treatment of water","1615 Union Avenue","Ruthven","N0P 2G0",0,null,168,16830.91,4729267.6869999999,"kWh",106539.10799999999,"Cubic Meter",{"$nulls":18},0,0,0]

{"sheet":"_lookup_","index":2,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["OperationType","FloorArea","Electricity","NaturalGas","FuelOil12","FuelOil46","Propane","Coal","Wood","DistrictHeating","DistrictCooling","Renewable"]
["Facilities related to the treatment of water","Square feet","kWh","Cubic Meter","Litre","Litre","Litre","Metric Tonne","Metric Tonne","Metric Tonne","Giga Joule","Yes"]
["Facilities related to the treatment of sewage","Square meters",null,"Giga Joule",{"$nulls":5},"Giga Joule","KL Chilled Water","No"]
["Facilities related to the pumping of water",null,null,"ekWh",{"$nulls":5},"KL Hot Water"]
["Facilities related to the pumping of sewage"]
["Other"]