{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Read First","Submission Data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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,"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":41,"n_cols":88,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,34,7,34],[6,35,7,35],[5,8,7,8],[5,9,5,30],[5,31,5,33],[6,9,6,10],[6,11,6,12],[6,13,6,14],[6,15,6,16],[6,17,6,18],[6,19,6,20],[6,21,6,22],[6,23,6,26],[6,27,6,30],[6,31,7,31],[6,32,7,32],[6,33,7,33],[0,1,0,7],[3,2,3,5],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7]]}
["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 2012",{"$nulls":51},"FloorArea","Electricity","NaturalGas","FuelOil12","FuelOil46","Propane","Coal","Wood","DistrictHeating","DistrictCooling","Renewable",null,"operation Type","Administrative offices and related facilities, including municipal council chambers","Public libraries","Cultural facilities","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","Other"]
["Confirm consecutive 12-mth period (mth-yr to mth-yr)",{"$nulls":52},"Square feet","kWh","Cubic Meter","Litre","Litre","Litre","Metric Tonne","Metric Tonne","Metric Tonne","Giga Joule","Yes"]
["Sector",{"$nulls":52},"Square meters",null,"Giga Joule",{"$nulls":5},"Giga Joule","KL Chilled Water","No"]
["Agency Sub-sector","CityMunicipality",{"$nulls":53},"ekWh",{"$nulls":5},"KL Hot Water"]
["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 (Kg)","Energy Intensity (ekWh/sqft)","Energy Intensity (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"]
["Bentley House","Administrative offices and related facilities, including municipal council chambers","3590 BROCK RD (3590 MOWBRAY STREET)","Brougham","L0H 1A0",2816,"Square feet",40,0,84846.571538019503,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,8148.6647305113929,30.130174551853518,0]
["Brougham Hall","Community centres","3545 BROCK RD (3545 MOWBRAY STREET)","Brougham","L0H 1A0",2400,"Square feet",3,0,62241.189427312798,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,5977.6438325991212,25.933828928046999,0]
["Centennial Park Club House","Community centres","2250 BROCK ROAD","Pickering","L1V 2P8",1545,"Square feet",13,0,22125.158015705802,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,2124.9001758283853,14.320490625052299,0]
["City Hall","Administrative offices and related facilities, including municipal council chambers","1 THE ESPLANADE","Pickering","L1V 6K7",103743,"Square feet",48,0,943778.09327714995,"kWh",69357,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,221768.66491733748,16.202431225876929,0]
["Central Library","Public libraries","1 THE ESPLANADE","Pickering","L1V 6K7",34165,"Square feet",74.5,0,943778.09327714995,"kWh",69357,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,221768.66491733748,49.199145987594029,0]
["Claremont CC & Fire Stn 4 & Library","Community centres","4941 OLD BROCK RD","Claremont","L1Y 1A9",11243,"Square feet",17,0,97983.748324076005,"kWh",18553,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,44487.161920044266,26.252859112788048,0]
["Claremont CC & Fire Stn 4 & Library","Public libraries","4941 OLD BROCK RD","Claremont","L1Y 1A9",1666,"Square feet",9.8000000000000007,0,19596.749664815201,"kWh",3710.6,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,8897.4323840088509,35.433480792926289,0]
["Claremont CC & Fire Stn 4 & Library","Fire stations and associated offices and facilities","4941 OLD BROCK RD","Claremont","L1Y 1A9",5274,"Square feet",168,0,78386.998659260804,"kWh",14842.4,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,35589.729536035404,44.772225256742665,0]
["Don Beer Arena","Indoor ice rinks","940 DILLINGHAM RD","Pickering","L1W 1Z6",94211,"Square feet",104,0,1603693.67937177,"kWh",98025,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,339347.45264186477,28.080388912088505,0,null,"2011 Total Indoor Space Floor Area of 18,183 was corrected to 94,211."]
["Dunbarton Pool","Indoor swimming pools","655 SHEPPARD AVE E","Pickering","L1V 1G2",20790,"Square feet",102,0,0,"kWh",121808,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,230293.49361599999,62.267833613083212,0]
["East Shore CC & Senior's Cntr","Community centres","910 LIVERPOOL RD","Pickering","L1W 1S6",28766,"Square feet",91,0,248963.60850411799,"kWh",40044,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,99618.732548735497,23.449291201144337,0]
["Fire Station # 2","Fire stations and associated offices and facilities","553 KINGSTON RD","Pickering","L1V 3N7",7955,"Square feet",168,0,76838.709059567103,"kWh",10493,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,27217.938729080823,23.677683610379269,0]
["Fire Station # 5","Fire stations and associated offices and facilities","1616 BAYLY ST","Pickering","L1W 3N2",13360,"Square feet",168,0,219374.851561004,"kWh",30232,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,78226.196207918823,40.46959624438653,0]
["Fire Station # 6","Fire stations and associated offices and facilities","1115 FINCH AVE","Pickering","L1V 1J7",9130,"Square feet",168,0,119507.72840452001,"kWh",6610,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,23974.566705970101,20.783935857012047,0]
["Green River CC","Community centres","190 HWY 7","Green River","L0H 1J0",3210,"Square feet",1,0,47695.278682244803,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,4580.6545646427912,14.858342268612088,0]
["Greenwood CC","Community centres","3551 GREENWOOD RD","Greenwood","L0H 1E0",8400,"Square feet",27,0,143913.20628232101,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,13821.42433135411,17.132524557419167,0]
["Greenwood Library","Public libraries","3540 WESTNEY RD","Greenwood","L1H 1H0",1728,"Square feet",12,0,11721.7965906914,"kWh",1825,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,4576.1556195700023,18.007806490562153,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,6905.2001532273498,"kWh",5980,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,11969.124882715954,16.013478775733489,0]
["Mount Zion CC","Community centres","4230 SIDELINE 6","Pickering","L1Y 1A2",2150,"Square feet",25,0,5413.3882398008,"kWh",0,"Cubic Meter",4359.8,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,12444.63493535047,24.373181583442236,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,684719.98659260699,"kWh",47377,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,155332.74289135396,16.727418561576783,0]
["Petticoat Creek Community Centre","Community centres","470 KINGSTON RD","Pickering","L1V 1A4",7821,"Square feet",68.5,0,200880.003830684,"kWh",14770,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,47217.076357898892,45.755308799473724,0]
["Petticoat Creek Library","Public libraries","470 KINGSTON RD","Pickering","L1V 1A4",9369,"Square feet",65.5,0,200880.003830684,"kWh",14770,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,47217.076357898892,38.195353839330132,0]
["PMV Gas & Steam Barn","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",5975,"Square feet",48,0,8659.0787205516208,"kWh",977,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,2678.7604993217778,3.1870153723098946,0]
["PMV NE/Post Misc Building Use","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",6290,"Square feet",30.5,0,3426.9584370810198,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,329.12508829726113,0.54482646058521778,0]
["PMV Puterbaugh Schoolhouse","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",480,"Square feet",30.5,0,0,"kWh",0,"Cubic Meter",1007.9,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,2756.7637323999998,22.631086329791668,0]
["PMV Redman House","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",2803,"Square feet",56,0,31266.471940241299,"kWh",4686,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,11862.310087140775,28.921953250888798,0]
["PMV Robert A Miller","Cultural facilities","2365 CONC 6","Greenwood","L0H 1H0",3127,"Square feet",48,0,56049.109366021803,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,5382.9564635127335,17.924243481298944,0]
["Progress Club House","Community centres","680 FRONT RD","Pickering","L1X 1R1",2050,"Square feet",9.3000000000000007,0,21352.2026431718,"kWh",2097,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,6015.3103608502197,21.287146835205757,0]
["Recreation Complex","Indoor recreational facilities","1867 VALLEY FARM RD","Pickering","L1V 3Y7",214188,"Square feet",113,0,4922259.2894081604,"kWh",357663,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,1148941.1068557599,40.727874085192262,0]
["West Shore CC","Community centres","1011 BAYLY ST","Pickering","L1W 0A4",7500,"Square feet",58,0,45794.397624976104,"kWh",4715,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,13312.400252902706,12.787248823996814,0]
["Whitevale CC","Community centres","405 WHITEVALE RD","Whitevale","L0H 1M0",2120,"Square feet",12.8,0,21586.1520781459,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,2073.1340455851323,10.182147206672594,0]
["Whitevale Library","Public libraries","475 WHITEVALE RD","Whitevale","L0H 1M0",900,"Square feet",11,0,9302.7676690289209,"kWh",0,"Cubic Meter",0,"Litre",0,"Litre",0,"Litre",0,"Metric Tonne",0,"Metric Tonne",0,"Giga Joule",null,null,0,"Giga Joule",null,null,893.43780693353756,10.336408521143245,0]