{"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":38,"n_cols":36,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,7],[3,2,3,5],[5,4,7,4],[5,8,7,8],[6,32,7,32],[5,31,5,33],[6,19,6,20],[5,9,5,30],[6,13,6,14],[6,21,6,22],[6,17,6,18],[6,15,6,16],[6,35,7,35],[5,3,7,3],[5,2,7,2],[5,1,7,1],[5,0,7,0],[5,7,7,7],[6,23,6,26],[6,11,6,12],[6,9,6,10],[5,6,7,6],[5,5,7,5],[6,27,6,30],[6,31,7,31],[6,33,7,33],[6,34,7,34]]}
["Press TAB to move to input areas. Press UP or DOWN ARROW in column A to read through the document.","Energy Consumption and Greenhouse Gas Emissions Reporting - for 2015"]
["Confirm consecutive 12-mth period (mth-yr to mth-yr)","Jan/2015 - Dec/2015"]
["Sector","Municipality"]
["Agency Sub-sector","Municipal"]
["Organization Name","City of Pickering","Please fill in the mandatory fields indicated in red, in addition to submitting data on your energy usage."]
["Operation Name","Operation Type","Address","City","Postal Code","Total Floor Area","Unit","Avg hrs/wk","Annual Flow (Mega Litres)","Energy Type and Amount Purchased and Consumed in Natural Units",{"$nulls":21},"Total (calculated in webform)"]
[{"$nulls":9},"Electricity",null,"Natural Gas",null,"Fuel Oil 1 & 2",null,"Fuel Oil 4 & 6",null,"Propane",null,"Coal",null,"Wood",null,"District Heating",null,null,null,"District Cooling",null,null,null,"GHG Emissions\n(Kg)","Energy Intensity\n(ekWh/sqft)","Energy Intensity\n(ekWh/Mega Litre)","Building / Operation Identifier","Comments"]
[{"$nulls":9},"Quantity","Unit","Quantity","Unit","Quantity","Unit","Quantity","Unit","Quantity","Unit","Quantity","Unit","Quantity","Unit","Quantity","Unit","Renewable?","If Yes, enter Emission Factor","Quantity","Unit","Renewable?","If Yes, enter Emission Factor"]
["Stephenson Building","Administrative offices and related facilities, including municipal council chambers","2160 Yonge Street","Toronto","M7A 2G5",135034,"Square meters",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"]
["Animal Services","Administrative offices and related facilities, including municipal council chambers","1688 Highway 7","Pickering","L0H 1A0",2725,"Square feet",34,0,35208,"kWh",null,null,4827.8999999999996,"Litre",{"$nulls":16},14632.673636400001,32.015423698458697,0]
["Bentley House","Administrative offices and related facilities, including municipal council chambers","3590 BROCK RD","Brougham","L0H 1A0",2816,"Square feet",40,0,70135,"kWh",{"$nulls":20},2843.8339799999999,24.905894886363601,0]
["Brougham Hall","Community centres","3545 BROCK RD","Brougham","L0H 1A0",2400,"Square feet",3,0,51136.44,"kWh",{"$nulls":20},2073.48036912,21.306850000000001,0]
["Centennial Park Club House","Community centres","2250 BROCK ROAD","Pickering","L1V 2P8",1545,"Square feet",13,0,33445.96,"kWh",{"$nulls":20},1356.1667860800001,21.647870550161802,0]
["City Hall","Administrative offices and related facilities, including municipal council chambers","1 THE ESPLANADE","Pickering","L1V 6K7",137908,"Square feet",48,0,1836290,"kWh",182340,"Cubic Meter",{"$nulls":18},419194.81410000002,27.367222047887001,0]
["Claremont CC & Fire Stn 4 & Library","Community centres","4941 OLD BROCK RD","Claremont","L1Y 1A9",18183,"Square feet",17,0,149187.84,"kWh",44753,"Cubic Meter",{"$nulls":18},90660.498667320004,34.362467364076302,0]
["Don Beer Arena","Indoor ice rinks","940 DILLINGHAM RD","Pickering","L1W 1Z6",94211,"Square feet",104,0,1538757,"kWh",74899,"Cubic Meter",{"$nulls":18},203999.590509,24.782317027979701,0]
["Dunbarton Pool","Indoor swimming pools","655 SHEPPARD AVE E","Pickering","L1V 1G2",20790,"Square feet",102,0,null,null,94162,"Cubic Meter",{"$nulls":18},178025.21957399999,48.135292827032202,0]
["East Shore CC & Senior's Cntr","Community centres","910 LIVERPOOL RD","Pickering","L1W 1S6",28766,"Square feet",91,0,237089.6,"kWh",51324.82,"Cubic Meter",{"$nulls":18},106649.59956294,27.204280801124199,0]
["Fire Station # 2","Fire stations and associated offices and facilities","553 KINGSTON RD","Pickering","L1V 3N7",7955,"Square feet",168,0,55093.38,"kWh",14403,"Cubic Meter",{"$nulls":18},29464.627053240001,26.1678506764299,0]
["Fire Station # 5","Fire stations and associated offices and facilities","1616 BAYLY ST","Pickering","L1W 3N2",13360,"Square feet",168,0,174588.22,"kWh",28419,"Cubic Meter",{"$nulls":18},60808.931857559997,35.6750759403443,0]
["Fire Station # 6","Fire stations and associated offices and facilities","1115 FINCH AVE","Pickering","L1V 1J7",9130,"Square feet",168,0,103933.71,"kWh",9524,"Cubic Meter",{"$nulls":18},22220.63562108,22.470170662431499,0]
["Green River CC","Community centres","190 HWY 7","Green River","L0H 1J0",3210,"Square feet",1,0,24318.240000000002,"kWh",{"$nulls":20},986.05599552000001,7.5757757009345799,0]
["Greenwood CC","Community centres","3551 GREENWOOD RD","Greenwood","L0H 1E0",8400,"Square feet",27,0,93340.43,"kWh",7418,"Cubic Meter",{"$nulls":18},17809.43884164,20.497295212619001,0]
["Greenwood Library","Public libraries","3540 WESTNEY RD","Greenwood","L1H 1H0",1728,"Square feet",12,0,12554.27,"kWh",2754,"Cubic Meter",{"$nulls":18},5715.8372979599999,24.2032221400463,0]
["Industrial Unit, Parks Dept","Storage facilities where equipment or vehicles are maintained, repaired or stored","935 DILLINGHAM RD","Pickering","L1W 1Z7",4400,"Square feet",168,0,7541.12,"kWh",7361,"Cubic Meter",{"$nulls":18},14222.682680759999,19.4936787493182,0]
["Mount Zion CC","Community centres","4230 SIDELINE 6","Pickering","L1Y 1A2",2150,"Square feet",25,0,5135.8100000000004,"kWh",null,null,5392.3,"Litre",{"$nulls":16},14957.028522680001,29.419914845162801,0]
["Operations Centre","Storage facilities where equipment or vehicles are maintained, repaired or stored","2570 TILLINGS RD","Pickering","L1V 2P8",71035,"Square feet",55,0,526601.69999999995,"kWh",50014,"Cubic Meter",{"$nulls":18},115910.4645096,14.8960278577884,0]
["Petticoat Creek Community Centre","Community centres","470 KINGSTON RD","Pickering","L1V 1A4",17190,"Square feet",68.5,0,302671.46000000002,"kWh",48683,"Cubic Meter",{"$nulls":18},104314.11660107999,47.705848033217002,0]
["PMV Gas & Steam Barn","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",5975,"Square feet",48,0,8710.56,"kWh",2154,"Cubic Meter",{"$nulls":18},4425.6063448799996,5.2891701519665304,0]
["PMV NE/Post Misc Building Use","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",6290,"Square feet",30.5,0,166.68,"kWh",{"$nulls":20},6.7585406399999997,2.64992050874404E-2,0]
["PMV Puterbaugh Schoolhouse","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",480,"Square feet",30.5,0,{"$nulls":4},1342.7,"Litre",{"$nulls":16},3672.4939611999998,30.148585787291701,0]
["PMV Redman House","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",2803,"Square feet",56,0,44527.519999999997,"kWh",7286,"Cubic Meter",{"$nulls":18},15580.610202960001,43.5110607285052,0]
["PMV Robert A Miller","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",3127,"Square feet",48,0,41918.080000000002,"kWh",{"$nulls":20},1699.69430784,13.4052062679885,0]
["Progress Club House","Community centres","680 FRONT RD","Pickering","L1X 1R1",2050,"Square feet",9.3000000000000007,0,10425,"kWh",2391,"Cubic Meter",{"$nulls":18},4943.2020570000004,17.480982832682901,0,null,"Limited use, in process of decommissioning of facility. "]
["Recreation Complex","Indoor recreational facilities","1867 VALLEY FARM RD","Pickering","L1V 3Y7",230120,"Square feet",113,0,4280708.7,"kWh",479641,"Cubic Meter",{"$nulls":18},1080396.4012746001,40.753634138957899,0]
["West Shore CC","Community centres","1011 BAYLY ST","Pickering","L1W 0A4",7500,"Square feet",58,0,46642.84,"kWh",6327,"Cubic Meter",{"$nulls":18},13853.27090532,15.1846380105333,0]
["Whitevale CC","Community centres","405 WHITEVALE RD","Whitevale","L0H 1M0",2120,"Square feet",12.8,0,29972.25,"kWh",{"$nulls":20},1215.314793,14.137853773584901,0]
["Whitevale Library","Public libraries","475 WHITEVALE RD","Whitevale","L0H 1M0",900,"Square feet",11,0,4096.3500000000004,"kWh",{"$nulls":20},166.09879979999999,4.5514999999999999,0,null,"Limited use, facility was shut down for 6 months and in the process of being converted to Arts Centre. "]

{"sheet":"_lookup_","index":2,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["OperationType","FloorArea","Electricity","NaturalGas","FuelOil12","FuelOil46","Propane","Coal","Wood","DistrictHeating","DistrictCooling","Renewable"]
["Administrative offices and related facilities, including municipal council chambers","Square feet","kWh","Cubic Meter","Litre","Litre","Litre","Metric Tonne","Metric Tonne","Metric Tonne","Giga Joule","Yes"]
["Public libraries","Square meters",null,"Giga Joule",{"$nulls":5},"Giga Joule","KL Chilled Water","No"]
["Cultural facilities",null,null,"ekWh",{"$nulls":5},"KL Hot Water"]
["Indoor recreational facilities"]
["Community centres"]
["Art galleries"]
["Performing arts facilities"]
["Auditoriums"]
["Indoor sports arenas"]
["Indoor ice rinks"]
["Indoor swimming pools"]
["Gyms and indoor courts for playing tennis, basketball or other sports"]
["Ambulance stations and associated offices and facilities"]
["Fire stations and associated offices and facilities"]
["Police stations and associated offices and facilities"]
["Storage facilities where equipment or vehicles are maintained, repaired or stored"]
["Parking garages"]
["Facilities related to the treatment of water"]
["Facilities related to the treatment of sewage"]
["Facilities related to the pumping of water"]
["Facilities related to the pumping of sewage"]
["Street lighting"]
["Social housing"]
["Long-term care"]
["Other"]