{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Background Parameters EoU","Heat Pumps"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"Background Parameters EoU","index":0,"n_rows":188,"n_cols":9,"rows_kept":188,"cut":false,"hidden":true,"merged":[]}
["Source : https://oee.nrcan.gc.ca/organisme/statistiques/bnce/apd/menus/evolution/tableaux_complets/liste.cfm"]
[]
[]
["Sector : Whole sale trade","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",43.1,4.7,17.7,4.5999999999999996,19.8,10.1]
["Nova Scotia",43.1,4.7,17.7,4.5999999999999996,19.8,10.1]
["Prince Edward Island",43.1,4.7,17.7,4.5999999999999996,19.8,10.1]
["Newfoundland and Labrador",43.1,4.7,17.7,4.5999999999999996,19.8,10.1]
["Quebec",44,6.1,21.5,4.2,18.3,5.9]
["Ontario",64.3,5.3,9.4,3.2,11.3,6.6]
["Manitoba",72,4.2,8.6999999999999993,3.5,8.3000000000000007,3.3]
["Saskatchewan",62.2,6,11.6,4.3,13.6,2.2999999999999998]
["Alberta",65.2,5.4,14.5,3,10.7,1.1000000000000001]
["British Columbia",51.9,5.9,14.9,5.4,18.2,3.8]
["Yukon",51.9,5.9,14.9,5.4,18.2,3.8]
["Northwest Territories",51.9,5.9,14.9,5.4,18.2,3.8]
["Nunavut",51.9,5.9,14.9,5.4,18.2,3.8]
[]
[]
[]
["Sector : Retail trade","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",45.3,4.4000000000000004,16.399999999999999,3.6,20.7,9.6999999999999993]
["Nova Scotia",45.3,4.4000000000000004,16.399999999999999,3.6,20.7,9.6999999999999993]
["Prince Edward Island",45.3,4.4000000000000004,16.399999999999999,3.6,20.7,9.6999999999999993]
["Newfoundland and Labrador",45.3,4.4000000000000004,16.399999999999999,3.6,20.7,9.6999999999999993]
["Quebec",44.2,5.6,18.399999999999999,4,22.1,5.7]
["Ontario",61.8,5.2,8.6999999999999993,2.9,14.9,6.5]
["Manitoba",69.099999999999994,3.7,8.1,3.2,12.9,3]
["Saskatchewan",60.2,5.3,10.7,4,17.2,2.7]
["Alberta",65.7,5.2,12,2.9,13,1.2]
["British Columbia",49.9,5.3,14.4,5,21.1,4.3]
["Yukon",49.9,5.3,14.4,5,21.1,4.3]
["Northwest Territories",49.9,5.3,14.4,5,21.1,4.3]
["Nunavut",49.9,5.3,14.4,5,21.1,4.3]
[]
[]
[]
[]
["Sector : Transportation and Warehousing","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",49.3,3.1,9.1999999999999993,6.3,24.2,8]
["Nova Scotia",49.3,3.1,9.1999999999999993,6.3,24.2,8]
["Prince Edward Island",49.3,3.1,9.1999999999999993,6.3,24.2,8]
["Newfoundland and Labrador",49.3,3.1,9.1999999999999993,6.3,24.2,8]
["Quebec",43.8,6.7,19.600000000000001,4.5999999999999996,19.600000000000001,5.7]
["Ontario",71.599999999999994,3,7.2,3.6,10,4.5999999999999996]
["Manitoba",80.7,2.2999999999999998,0.4,4.5,9.6,2.5]
["Saskatchewan",73.2,3.4,0.9,5.5,15.5,1.4]
["Alberta",80.7,2.9,0.1,3.9,11.3,1.1000000000000001]
["British Columbia",63.5,3.2,3.2,7,18.8,4.3]
["Yukon",63.5,3.2,3.2,7,18.8,4.3]
["Northwest Territories",63.5,3.2,3.2,7,18.8,4.3]
["Nunavut",63.5,3.2,3.2,7,18.8,4.3]
[]
[]
["Sector : Information and Cultural Industries","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",42.7,4.4000000000000004,19.7,4.4000000000000004,19.600000000000001,9.1999999999999993]
["Nova Scotia",42.7,4.4000000000000004,19.7,4.4000000000000004,19.600000000000001,9.1999999999999993]
["Prince Edward Island",42.7,4.4000000000000004,19.7,4.4000000000000004,19.600000000000001,9.1999999999999993]
["Newfoundland and Labrador",42.7,4.4000000000000004,19.7,4.4000000000000004,19.600000000000001,9.1999999999999993]
["Quebec",43.8,5.6,22.6,4.0999999999999996,17.8,6]
["Ontario",62.2,6.6,9.6,2.6,12.7,6.3]
["Manitoba",70.599999999999994,4,9.1999999999999993,3.2,9.8000000000000007,3.3]
["Saskatchewan",62.2,5.6,11,4.3,14.5,2.2999999999999998]
["Alberta",64,4.7,15.9,3,10.4,2]
["British Columbia",51.7,5,15.1,5.5,18.100000000000001,4.5999999999999996]
["Yukon",51.7,5,15.1,5.5,18.100000000000001,4.5999999999999996]
["Northwest Territories",51.7,5,15.1,5.5,18.100000000000001,4.5999999999999996]
["Nunavut",51.7,5,15.1,5.5,18.100000000000001,4.5999999999999996]
[]
[]
["Sector : Offices ","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",43.9,1.7,18.399999999999999,4.0999999999999996,23.4,8.4]
["Nova Scotia",43.9,1.7,18.399999999999999,4.0999999999999996,23.4,8.4]
["Prince Edward Island",43.9,1.7,18.399999999999999,4.0999999999999996,23.4,8.4]
["Newfoundland and Labrador",43.9,1.7,18.399999999999999,4.0999999999999996,23.4,8.4]
["Quebec",42.7,2.6,21.7,4.5999999999999996,21.7,6.7]
["Ontario",60.9,2.7,13.9,2.8,14.4,5.3]
["Manitoba",68.8,1.8,11.1,3.2,12.1,3.1]
["Saskatchewan",64,2.7,11.8,4.2,14.9,2.4]
["Alberta",69.2,2.6,12.7,3.1,11.1,1.4]
["British Columbia",50.1,2.5,16.5,4.7,17.100000000000001,9]
["Yukon",50.1,2.5,16.5,4.7,17.100000000000001,9]
["Northwest Territories",50.1,2.5,16.5,4.7,17.100000000000001,9]
["Nunavut",50.1,2.5,16.5,4.7,17.100000000000001,9]
[]
[]
["Sector : Educational Services ","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",44.5,5.0999999999999996,17.899999999999999,4.5999999999999996,19,8.9]
["Nova Scotia",44.5,5.0999999999999996,17.899999999999999,4.5999999999999996,19,8.9]
["Prince Edward Island",44.5,5.0999999999999996,17.899999999999999,4.5999999999999996,19,8.9]
["Newfoundland and Labrador",44.5,5.0999999999999996,17.899999999999999,4.5999999999999996,19,8.9]
["Quebec",45.5,6.4,20.9,4.3,16.8,6.1]
["Ontario",59.5,6.4,13.5,3,11.6,6]
["Manitoba",70.8,4,10.5,3.4,8.4,2.9]
["Saskatchewan",63.1,5.8,12.3,4.4000000000000004,12.2,2.2000000000000002]
["Alberta",68.3,5.0999999999999996,13.3,3.2,9.1,1]
["British Columbia",53.2,5.0999999999999996,15.5,5.7,15.4,5]
["Yukon",53.2,5.0999999999999996,15.5,5.7,15.4,5,null,"x"]
["Northwest Territories",53.2,5.0999999999999996,15.5,5.7,15.4,5,null,"x"]
["Nunavut",53.2,5.0999999999999996,15.5,5.7,15.4,5,null,"x"]
[]
[]
["Sector : Health Care and Social Assistance","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",36.299999999999997,9.3000000000000007,27.5,4.4000000000000004,16,6.5]
["Nova Scotia",36.299999999999997,9.3000000000000007,27.5,4.4000000000000004,16,6.5]
["Prince Edward Island",36.299999999999997,9.3000000000000007,27.5,4.4000000000000004,16,6.5]
["Newfoundland and Labrador",36.299999999999997,9.3000000000000007,27.5,4.4000000000000004,16,6.5]
["Quebec",38.5,13.4,25.4,4.0999999999999996,14.4,4.2]
["Ontario",48.4,11.6,20.8,3,12,4.2]
["Manitoba",56.3,9.5,18.2,3.5,10,2.4]
["Saskatchewan",49.6,11.3,19.899999999999999,4.3,13.3,1.7]
["Alberta",47.3,15.1,25,2.9,8.6999999999999993,1.1000000000000001]
["British Columbia",40.1,11.7,22.3,5.3,17,3.6]
["Yukon",40.1,11.7,22.3,5.3,17,3.6]
["Northwest Territories",40.1,11.7,22.3,5.3,17,3.6]
["Nunavut",40.1,11.7,22.3,5.3,17,3.6]
[]
[]
[]
["Sector : Arts, Entertainment and Recreation ","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",46.4,3.9,19.399999999999999,5,20.5,4.9000000000000004]
["Nova Scotia",46.4,3.9,19.399999999999999,5,20.5,4.9000000000000004]
["Prince Edward Island",46.4,3.9,19.399999999999999,5,20.5,4.9000000000000004]
["Newfoundland and Labrador",46.4,3.9,19.399999999999999,5,20.5,4.9000000000000004]
["Quebec",45.7,4.7,21,4.3,18.899999999999999,5.4]
["Ontario",62.4,5.6,10.7,3.1,12,6.2]
["Manitoba",72.2,3.2,8.4,3.2,9.4,3.5]
["Saskatchewan",63.1,5,11.1,4.4000000000000004,14.1,2.4]
["Alberta",66.8,4.5999999999999996,13.6,3.1,10.8,1.2]
["British Columbia",53.3,4.7,13.7,5.6,18.3,4.4000000000000004]
["Yukon",53.3,4.7,13.7,5.6,18.3,4.4000000000000004]
["Northwest Territories",53.3,4.7,13.7,5.6,18.3,4.4000000000000004]
["Nunavut",53.3,4.7,13.7,5.6,18.3,4.4000000000000004]
[]
[]
[]
["Sector : Accommodation and Food Services ","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",42.6,4.7,18.3,4.4000000000000004,19.7,10.3]
["Nova Scotia",42.6,4.7,18.3,4.4000000000000004,19.7,10.3]
["Prince Edward Island",42.6,4.7,18.3,4.4000000000000004,19.7,10.3]
["Newfoundland and Labrador",42.6,4.7,18.3,4.4000000000000004,19.7,10.3]
["Quebec",47.9,5.5,19.8,4.3,17.7,4.8]
["Ontario",60.1,6.9,12.5,3,11.3,6.3]
["Manitoba",70.3,4.0999999999999996,9.9,3.2,9.3000000000000007,3.2]
["Saskatchewan",61.3,6.7,12,4,13.7,2.2999999999999998]
["Alberta",65.8,6.5,12.6,2.9,10.6,1.6]
["British Columbia",52.4,7.1,15.1,5.3,15.2,4.9000000000000004]
["Yukon",52.4,7.1,15.1,5.3,15.2,4.9000000000000004]
["Northwest Territories",52.4,7.1,15.1,5.3,15.2,4.9000000000000004]
["Nunavut",52.4,7.1,15.1,5.3,15.2,4.9000000000000004]
[]
[]
[]
["Sector :Other Services ","Space Heating (%)","Water Heating (%)","Auxiliary Equipment (%)","Auxiliary Motors (%)","Lighting (%)","Space cooling (%)"]
["New Brunswick",45.6,3.9,20.5,4.8,19.100000000000001,6.1]
["Nova Scotia",45.6,3.9,20.5,4.8,19.100000000000001,6.1]
["Prince Edward Island",45.6,3.9,20.5,4.8,19.100000000000001,6.1]
["Newfoundland and Labrador",45.6,3.9,20.5,4.8,19.100000000000001,6.1]
["Quebec",44.5,4.7,21.8,4.3,20,4.8]
["Ontario",62.7,5.9,10.7,3,11.4,6.2]
["Manitoba",71.2,3.7,9.3000000000000007,3.5,9.6,2.8]
["Saskatchewan",62,4.7,12.2,4.4000000000000004,14.7,1.9]
["Alberta",64.2,4.2,16.8,3.1,10.9,0.9]
["British Columbia",52.3,4.5999999999999996,15,5.6,18.899999999999999,3.5]
["Yukon",52.3,4.5999999999999996,15,5.6,18.899999999999999,3.5]
["Northwest Territories",52.3,4.5999999999999996,15,5.6,18.899999999999999,3.5]
["Nunavut",52.3,4.5999999999999996,15,5.6,18.899999999999999,3.5]
[]
[]
[]
[]
[]
[]
[]
["Select your building type",null,"Select your province "]
["Accommodation and food services","Accommodation and food services","Alberta","Alberta"]
["Arts, entertainment and recreation","Arts, entertainment and recreation ","British Columbia","British Columbia"]
["Educational services","Educational services ","Manitoba","Manitoba"]
["Health care and social assistance","Health care and social assistance ","New Brunswick","New Brunswick"]
["Information and cultural industries","Information and cultural industries","Newfoundland and Labrador","Newfoundland and Labrador"]
["Manufacturing","Manufacturing","Nova Scotia","Nova Scotia"]
["Offices","Offices","Northwest Territories","Northwest Territories"]
["Retail trade","Retail trade","Nunavut","Nunavut"]
["Transportation and warehousing","Transportation and Warehousing","Ontario","Ontario"]
["Whole sale trade","Whole sale trade","Prince Edward Island","Prince Edward Island"]
["Other","Other","Quebec","Quebec"]
[null,null,"Saskatchewan","Saskatchewan"]
[null,null,"Yukon","Yukon"]

{"sheet":"Heat Pumps","index":1,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,1048575,1],[0,16,3,16],[19,16,23,16]]}
[null,{"$f":"#VALUE!","v":{"$error":"#VALUE!"}},"Test"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"Natural Gas\",\"NaturalGasOptions\",IF(#REF!=\"Propane\",\"PropaneOptions\",IF(#REF!=\"Light Fuel Oil\",\"LightFuelOilOptions\",IF(#REF!=\"Only electricity\",\"ElectricOptions\",\"\"))))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select an option"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,null,null,null,"For cooling : ",{"$f":"IF(E9=\"Yes\",#REF! * (#REF! /\n 100),\n    \"-\"\n)","v":"-"}]
[]
[null,null,null,null,null,null,null,"For both to replace",{"$f":"IF(AND(J21 > 0, I13 > 0, I13 <> \"-\"),\n    J21 + I13,\n    IF(AND(J21 > 0, I13 = \"-\"),\n        J21,\n        \"-\"\n    )\n)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND((I15/1800)*0.8/3.516*VLOOKUP(#REF!,#REF!, 7, FALSE()), -3)","v":{"$error":"#REF!"}},"Real energy used for heating","Energy to replace"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E6=\"Natural Gas Furnace - Old/Low-efficiency\",\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        (((#REF!*(#REF!/100)*0.0373*277.7778)*#REF!)+\n        ((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*0.0373*277.7778))\n        )\n    ),\n\nIF(E6=\"Natural Gas Furnace - Standard\",\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        (((#REF!*(#REF!/100)*0.0373*277.7778)*#REF!)+          ((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*0.0373*277.7778))\n        )\n    ),\n\nIF(E6=\"Natural Gas Furnace - High efficiency\",\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        (((#REF!*(#REF!/100)*0.0373*277.7778)*#REF!)+\n        ((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*0.0373*277.7778))\n        )\n    ),\n\nIF(E6=\"Natural Gas Boiler - Condensing (High efficiency)\",\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        (((#REF!*(#REF!/100)*0.0373*277.7778)*#REF!)+\n        ((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*0.0373*277.7778))\n        )\n    ),\n\nIF(E6=\"Natural Gas Boiler - Standard\",\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        (((#REF!*(#REF!/100)*0.0373*277.7778)*#REF!)+\n        ((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*0.0373*277.7778))\n        )\n    ),\n\nIF(E6=\"Natural Gas Burners (Rooftop, Unit Heaters, ...)\",\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        (((#REF!*(#REF!/100)*0.0373*277.7778)*#REF!)+          ((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*0.0373*277.7778))\n        )\n    )\n))))))","v":false},{"$f":"IF(OR(E6=\"Electric Radiant\",E6=\"Electric Resistance (Coils, baseboards, Rooftop units, ...)\",E6=\"Electric Furnace\",E6=\"Electric Boiler\"),\nIF(#REF!=\"-\",#REF!*(#REF!/\n100),\nIF(#REF!=\"Natural Gas\",\nIF((#REF!*(#REF!/100)-(#REF!*(#REF!/100)*277.7778*0.0373))>=0,#REF!*(#REF!/\n100)-(#REF!*(#REF!/100)*277.7778*0.0373),\nMAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.0373)\n),\nIF(#REF!=\"Propane\",\nIF((#REF!*(#REF!/100)-(#REF!*(#REF!/100)*277.7778*0.02553))>=0,#REF!*(#REF!/\n100)-(#REF!*(#REF!/100)*277.7778*0.02553),\nMAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.02553)\n),\nIF(#REF!=\"Light Fuel Oil\",\nIF((#REF!*(#REF!/100)-(#REF!*(#REF!/100)*277.7778*0.03672))>=0,#REF!*(#REF!/\n100)-(#REF!*(#REF!/100)*277.7778*0.03672),\nMAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.03672)\n),\n\"-\"\n)))),\nIF(#REF!=\"-\",\n\"-\",\nIF(E6=\"Natural Gas Furnace - Old/Low-efficiency\",\n(#REF!*(#REF!/100)*0.0373*277.7778)*#REF!,\nIF(E6=\"Natural Gas Furnace - Standard\",\n(#REF!*(#REF!/100)*0.0373*277.7778)*#REF!,\nIF(E6=\"Natural Gas Furnace - High efficiency\",\n(#REF!*(#REF!/100)*0.0373*277.7778)*#REF!,\nIF(E6=\"Natural Gas Boiler - Condensing (High efficiency)\",\n(#REF!*(#REF!/100)*0.0373*277.7778)*#REF!,\nIF(E6=\"Natural Gas Boiler - Standard\",\n(#REF!*(#REF!/100)*0.0373*277.7778)*#REF!,\nIF(E6=\"Natural Gas Burners (Rooftop, Unit Heaters, ...)\",\n(#REF!*(#REF!/100)*0.0373*277.7778)*#REF!,\nIF(E6=\"Propane Furnace\",\n(#REF!*(#REF!/100)*0.02553*277.7778)*#REF!,\nIF(E6=\"Propane Boiler\",\n(#REF!*(#REF!/100)*0.02553*277.7778)*#REF!,\nIF(E6=\"Oil Furnace\",\n(#REF!*(#REF!/100)*0.03672*277.7778)*#REF!,\nIF(E6=\"Oil Boiler\",\n(#REF!*(#REF!/100)*0.03672*277.7778)*#REF!,\n\"-\"\n))))))))))))","v":{"$error":"#REF!"}},{"$f":"IF(OR(E6=\"Electric Radiant\",E6=\"Electric Resistance (Coils, baseboards, Rooftop units, ...)\",E6=\"Electric Furnace\",E6=\"Electric Boiler\"),\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100),\n        IF(#REF!=\"Natural Gas\",\n            IF((#REF!*(#REF!/100)-(#REF!*(#REF!/100)*277.7778*0.0373))>=0,#REF!*(#REF!/\n                100)-(#REF!*(#REF!/100)*277.7778*0.0373),\n                MAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.0373)\n            ),\n            IF(#REF!=\"Propane\",\n                IF((#REF!*(#REF!/100)-(#REF!*(#REF!/100)*277.7778*0.02553))>=0,#REF!*(#REF!/\n                    100)-(#REF!*(#REF!/100)*277.7778*0.02553),\n                    MAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.02553)\n                ),\n                IF(#REF!=\"Light Fuel Oil\",\n                    IF((#REF!*(#REF!/100)-(#REF!*(#REF!/100)*277.7778*0.03672))>=0,#REF!*(#REF!/\n                        100)-(#REF!*(#REF!/100)*277.7778*0.03672),\n                        MAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.03672)\n                    ),\n                    \"-\"\n                )\n            )\n        )\n    ),\n    IF(#REF!=\"-\",\n        \"-\",\n        IF(E6=\"Natural Gas Furnace - Old/Low-efficiency\",\n            (#REF!*(#REF!/100)*0.0373*277.7778),\n        IF(E6=\"Natural Gas Furnace - Standard\",\n            (#REF!*(#REF!/100)*0.0373*277.7778),\n        IF(E6=\"Natural Gas Furnace - High efficiency\",\n            (#REF!*(#REF!/100)*0.0373*277.7778),\n        IF(E6=\"Natural Gas Boiler - Condensing (High efficiency)\",\n            (#REF!*(#REF!/100)*0.0373*277.7778),\n        IF(E6=\"Natural Gas Boiler - Standard\",\n            (#REF!*(#REF!/100)*0.0373*277.7778),\n        IF(E6=\"Natural Gas Burners (Rooftop, Unit Heaters, ...)\",\n            (#REF!*(#REF!/100)*0.0373*277.7778),\n        IF(E6=\"Propane Furnace\",\n            (#REF!*(#REF!/100)*0.02553*277.7778),\n        IF(E6=\"Propane Boiler\",\n            (#REF!*(#REF!/100)*0.02553*277.7778),\n        IF(E6=\"Oil Furnace\",\n            (#REF!*(#REF!/100)*0.03672*277.7778),\n        IF(E6=\"Oil Boiler\",\n            (#REF!*(#REF!/100)*0.03672*277.7778),\n            \"-\"\n        )))))))))))\n)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,"Electricity used by HPs",null,{"$f":"IF(E17=\"Heating\",\n    IF(J21 > 0,\n        TEXT(ROUND(J21 /#REF!, -2), \"#,##0\") & \" - \" & TEXT(ROUND(J21 /#REF!, -2), \"#,##0\"),\n        IF(J21 = \"-\", \"-\", \"\")\n    ),\n\nIF(E17=\"Cooling\",\n    IF(I13 > 0,\n        TEXT(ROUND(I13 * 0.9, -2), \"#,##0\") & \" - \" & TEXT(ROUND(I13 * 0.95, -2), \"#,##0\"),\n        IF(I13 = \"-\", \"-\", \"\")\n    ),\n\nIF(E17=\"Heating and cooling\",\n    IF(AND(J21 > 0, I13 > 0),\n        TEXT(ROUND((J21 /#REF!) + (I13 * 0.9), -2), \"#,##0\") & \" - \" & TEXT(ROUND((J21 /#REF!) + (I13 * 0.95), -2), \"#,##0\"),\n        \"-\"\n    ),\n\"\"))\n)","v":""},{"$f":"IF(E27 <> \"\",\n    VALUE(LEFT(E27, FIND(\" -\", E27)-1)) * VLOOKUP(#REF!,#REF!, 2, FALSE()) / 1000000 & \" - \" &\n    VALUE(RIGHT(E27, LEN(E27) - FIND(\" - \", E27)-2)) * VLOOKUP(#REF!,#REF!, 2, FALSE()) / 1000000,\n    \"-\"\n)","v":"-"},null,null,null,"HP running cost",{"$f":"IF(AND(E27 <> \"\"),\n    TEXT(CEILING((VALUE(LEFT(E27, FIND(\" -\", E27)-1)) * VLOOKUP(#REF!,#REF!, 2, FALSE())) / 100, 10), \"#,##0\") & \" - \" &\n    TEXT(CEILING((VALUE(RIGHT(E27, LEN(E27) - FIND(\" - \", E27)-2)) * VLOOKUP(#REF!,#REF!, 2, FALSE())) / 100, 10), \"#,##0\"),\n    \"-\"\n)","v":"-"}]
[null,null,"GHG emisions of the Heating system",null,null,{"$f":"IF(#REF!=\"-\",#REF!*(#REF!/\n100)*VLOOKUP(#REF!,#REF!,2,FALSE())/1000000,\nIF(#REF!=\"Natural Gas\",\n(#REF!*(#REF!/100))*VLOOKUP(#REF!,#REF!,3,FALSE())/1000000+\nMAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.0373)*VLOOKUP(#REF!,#REF!,2,FALSE())/1000000,\nIF(#REF!=\"Propane\",\n(#REF!*(#REF!/100))*#REF!/1000000+\nMAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.02553)*VLOOKUP(#REF!,#REF!,2,FALSE())/1000000,\nIF(#REF!=\"Light Fuel Oil\",\n(#REF!*(#REF!/100))*#REF!/1000000+\nMAX(0,#REF!*(#REF!/100)-#REF!*(#REF!/100)*277.7778*0.03672)*VLOOKUP(#REF!,#REF!,2,FALSE())/1000000,\n\"-\"\n)\n)))","v":{"$error":"#REF!"}}]
[null,null,"GHG emissions of the Cooling system",null,null,{"$f":"IF(E9=\"Yes\",\n    I13 * VLOOKUP(#REF!,#REF!, 2, FALSE()) / 1000000,\n    \"-\"\n)","v":"-"},null,null,null,"Heating cost",{"$f":"IF(#REF!=\"-\",#REF!*(#REF!/\n100)*VLOOKUP(#REF!,#REF!,2,FALSE())/100,\n((#REF!*(#REF!/100))*VLOOKUP(#REF!,#REF!,3,FALSE())/100)+\n((#REF!*(#REF!/100))-(#REF!*(#REF!/100)*277.7778*0.0373))*VLOOKUP(#REF!,#REF!,2,FALSE())/100\n)","v":{"$error":"#REF!"}}]
[null,null,"Total GHG emissions for Both",null,null,{"$f":"IF(AND(F31 > 0, F29 > 0, F29 <> \"-\"),\n    F31 + F29,\n    IF(AND(F31 > 0, F29 = \"-\"),\n        F31,\n        \"-\"\n    )\n)","v":"-"},null,null,null,"Cooling cost",{"$f":"IF(E9=\"Yes\",\n    I13 * VLOOKUP(#REF!,#REF!, 2, FALSE()) / 100,\n    \"-\"\n)","v":"-"}]
[null,null,"Total GHG emissions for the system to replace",null,null,{"$f":"IF(OR(E6=\"Electric Radiant\", E6=\"Electric Resistance (Coils, baseboards, Rooftop units, ...)\", E6=\"Electric Furnace\", E6=\"Electric Boiler\"),\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100)*VLOOKUP(#REF!,#REF!,2,FALSE())/1000000,\n        MAX(0,#REF!*(#REF!/ 100) -\n            IF(#REF!=\"Natural Gas\",#REF!*(#REF!/ 100)*277.7778*0.0373,\n            IF(#REF!=\"Propane\",#REF!*(#REF!/ 100)*277.7778*0.02553,\n            IF(#REF!=\"Light Fuel Oil\",#REF!*(#REF!/ 100)*277.7778*0.03672, 0)))\n        ) * VLOOKUP(#REF!,#REF!,2,FALSE())/1000000\n    ),\n    IF(OR(E6=\"Natural Gas Furnace - Old/Low-efficiency\", E6=\"Natural Gas Furnace - Standard\", E6=\"Natural Gas Furnace - High efficiency\", E6=\"Natural Gas Boiler - Condensing (High efficiency)\", E6=\"Natural Gas Boiler - Standard\", E6=\"Natural Gas Burners (Rooftop, Unit Heaters, ...)\"),\n        ((#REF!*(#REF!/100))*VLOOKUP(#REF!,#REF!,3,FALSE())/1000000),\n    IF(OR(E6=\"Propane Furnace\", E6=\"Propane Boiler\"),\n        ((#REF!*(#REF!/100))*#REF!/1000000),\n    IF(OR(E6=\"Oil Furnace\", E6=\"Oil Boiler\"),\n        ((#REF!*(#REF!/100))*#REF!/1000000),\n        \"-\"))))","v":"-"},null,null,null,null,{"$f":"IF(AND(K29 > 0, K30 > 0, K30 <> \"-\"),\n    K29 + K30,\n    IF(AND(K29 > 0, K30 = \"-\"),\n        K29,\n        \"-\"\n    )\n)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Energy cost of the heating system to replace",{"$f":"IF(OR(E6=\"Electric Radiant\", E6=\"Electric Resistance (Coils, baseboards, Rooftop units, ...)\", E6=\"Electric Furnace\", E6=\"Electric Boiler\"),\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100)*VLOOKUP(#REF!,#REF!,2,FALSE())/100,\n        MAX(0,#REF!*(#REF!/ 100) -\n            IF(#REF!=\"Natural Gas\",#REF!*(#REF!/ 100)*277.7778*0.0373,\n            IF(#REF!=\"Propane\",#REF!*(#REF!/ 100)*277.7778*0.02553,\n            IF(#REF!=\"Light Fuel Oil\",#REF!*(#REF!/ 100)*277.7778*0.03672, 0)))\n        ) * VLOOKUP(#REF!,#REF!,2,FALSE())/100\n    ),\nIF(OR(E6=\"Natural Gas Furnace - Old/Low-efficiency\", E6=\"Natural Gas Furnace - Standard\", E6=\"Natural Gas Furnace - High efficiency\", E6=\"Natural Gas Boiler - Condensing (High efficiency)\", E6=\"Natural Gas Boiler - Standard\", E6=\"Natural Gas Burners (Rooftop, Unit Heaters, ...)\"),\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100)*VLOOKUP(#REF!,#REF!,2,FALSE())/100,\n        ((#REF!*(#REF!/100))*VLOOKUP(#REF!,#REF!,3,FALSE())/100) +\n        MAX(0,#REF!*(#REF!/ 100) - (#REF!*(#REF!/100)*277.7778*0.0373)) * VLOOKUP(#REF!,#REF!,2,FALSE())/100\n    ),\nIF(OR(E6=\"Propane Furnace\", E6=\"Propane Boiler\"),\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100)*VLOOKUP(#REF!,#REF!,2,FALSE())/100,\n        ((#REF!*(#REF!/100))*VLOOKUP(#REF!,#REF!,5,FALSE())/100) +\n        MAX(0,#REF!*(#REF!/ 100) - (#REF!*(#REF!/100)*277.7778*0.02553)) * VLOOKUP(#REF!,#REF!,2,FALSE())/100\n    ),\nIF(OR(E6=\"Oil Furnace\", E6=\"Oil Boiler\"),\n    IF(#REF!=\"-\",#REF!*(#REF!/\n        100)*VLOOKUP(#REF!,#REF!,2,FALSE())/100,\n        ((#REF!*(#REF!/100))*VLOOKUP(#REF!,#REF!,4,FALSE())/100) +\n        MAX(0,#REF!*(#REF!/ 100) - (#REF!*(#REF!/100)*277.7778*0.03672)) * VLOOKUP(#REF!,#REF!,2,FALSE())/100\n    )\n)\n)\n)\n)","v":false}]
[null,null,null,null,null,null,null,null,null,"for both",{"$f":"IF(AND(K32 > 0, K30 > 0, K30 <> \"-\"),\n    K32 + K30,\n    IF(AND(K32 > 0, K30 = \"-\"),\n        K32,\n        \"-\"\n    )\n)","v":false}]
[]
[null,null,"Heating"]
[null,null,"Cooling"]
[null,null,"Heating and cooling"]
[]
[null,null,"Heating"]