{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Notes & Usage","Input","Output","Climate & Other Lookups","SPF Lookups","Version"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Notes & Usage","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[[4,5,22,8]]}
[]
[]
[null,null,null,null,null,"Air to Air Heat Pump Performance Estimate Calculator"]

{"sheet":"Input","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,7,1,9],[3,10,3,11],[29,1,29,3],[13,1,13,3],[14,1,14,3],[2,1,2,5],[11,1,11,3],[1,1,1,5],[6,2,6,5],[3,2,3,5],[4,2,4,5],[5,1,5,3],[21,1,21,3],[22,1,22,5],[7,1,7,3],[8,1,8,5],[32,1,32,3],[30,1,30,5],[12,1,12,3],[26,1,26,3],[31,1,31,3],[27,1,27,3],[28,1,28,3],[23,1,23,3],[24,1,24,3],[25,1,25,5],[18,1,18,5],[20,1,20,3],[19,1,19,3],[9,1,9,3],[10,1,10,3],[17,1,17,3],[15,1,15,5],[16,1,16,3]]}
[]
[null,"Air to Air Heat Pump System Performance Estimate - Input"]
[null,"Proposed system"]
[null,"Heat pump type (select one):","Air to Air Heat Pump"]
[null,"What is the purpose of the proposed system?","Space heat and hot water"]
[null,"What is the volume of the proposed cylinder?",null,null,200,"litres"]
[null,"What is the system pasteurisation strategy?","To be provided daily by immersion"]
[null,"Pasteurisation cycles by immersion",null,null,{"$f":"IF(OR(Input!C7 = \"To be provided by the heat pump\",Input!C7=\"N/A - Space heating system only\"),0, IF(Input!C7 = \"To be provided daily by immersion\", 365, IF(Input!C7 = \"To be provided weekly by immersion\", 52, \"Invalid input\")))","v":365},"per year"]
[null,"Property details (from valid EPC)"]
[null,"Space Heating Demand (Q)",null,null,15500,"kWh/year"]
[null,"Demand to be supplied by the heat pump",null,null,15500,"kWh/year"]
[null,"Energy required for domestic hot water (W)",null,null,2900,"kWh/year"]
[null,"Demand to be supplied by the heat pump",null,null,2900,"kWh/year"]
[null,"Postcode prefix",null,null,"BS"]
[null,"Total property floorspace (not property footprint)",null,null,145,"m²"]
[null,"Climate data"]
[null,"Degree days (D)",null,null,{"$f":"VLOOKUP(E$14,'Climate & Other Lookups'!B$3:D$126,3,0)","v":1835},"per year"]
[null,"Outdoor Low Temperature (d₀)",null,null,{"$f":"VLOOKUP(E$14,'Climate & Other Lookups'!B$3:D$126,2,0)","v":-3.1}," oC "]
[null,"Heat Loss calculations"]
[null,"Property Specific Heat Loss (Pspecific)",null,null,{"$f":"(1000*E10)/(24*E17)","v":351.95277020890097},"W/K"]
[null,"Total Heat Loss (Pt)",null,null,{"$f":"E20*(21-E18)","v":8482.0617620345147},"W"]
[null,"Specific Heat Loss",null,null,{"$f":"E21/E15","v":58.496977669203552},"W/m²"]
[null,"Heat Pump calculations"]
[null,"Indicative Heat Pump Capacity (Subject to full Heat Loss Calculation)",null,null,{"$f":"E21/1000","v":8.4820617620345153},"kW"]
[null,"Looked-up Seasonal Performance Factor",null,null,{"$f":"IF(C5=\"Hot water only\",1.9,4.1)","v":4.0999999999999996}]
[null,"Heat Pump System Performance"]
[null,"Annual electricity consumption (space)",null,null,{"$f":"IF(C5=\"Hot water only\",0,E11/E25)","v":3780.4878048780492},"kWh/year"]
[null,"Annual electricity consumption (water)",null,null,{"$f":"E13/1.9","v":1526.3157894736844},"kWh/year"]
[null,"Annual electricity consumption (immersion)",null,null,{"$f":"E6*E8*10*4200/3600000","v":851.66666666666663},"kWh/year"]
[null,"Total calculated electricity consumption of the heat pump",null,null,{"$f":"SUM(E27:E29)","v":6158.4702610184004},"kWh/year"]
[null,"Totals High / Low"]
[null,"Total annual energy consumption (high)",null,null,{"$f":"E30*1.1","v":6774.3172871202414},"kWh/year"]
[null,"Total annual energy consumption (low)",null,null,{"$f":"E30*0.9","v":5542.6232349165602},"kWh/year"]

{"sheet":"Output","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[13,3,13,5],[14,1,14,2],[13,1,13,2],[14,3,14,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[15,1,15,5],[16,1,16,3],[16,4,16,5],[17,1,18,1],[17,2,17,3],[17,4,17,5],[7,1,7,5],[10,1,10,3],[11,1,11,5],[12,1,12,3],[1,1,1,5],[2,1,2,5],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[8,1,8,3],[9,1,9,3]]}
[]
[null,"Air to Air Heat Pump System Performance Estimate - Output"]
[null,"Your energy requirements"]
[null,"Energy required for space heating",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E10, \"N/a - Hot water only\")","v":15500},"kWh"]
[null,"Demand to be supplied by the heat pump",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E11, \"N/a - Hot water only\")","v":15500},"kWh"]
[null,"Energy required for hot water",null,null,{"$f":"IF(OR($D$15=\"Hot water only\", $D$15=\"Space heat and hot water\"), Input!E12, \"N/a - Space heating only\")","v":2900},"kWh"]
[null,"Demand to be supplied by the heat pump",null,null,{"$f":"IF(OR($D$15=\"Hot water only\", $D$15=\"Space heat and hot water\"), Input!E13, \"N/a - Space heating only\")","v":2900},"kWh"]
[null,"Your property"]
[null,"Your postcode prefix",null,null,{"$f":"Input!E14","v":"BS"}]
[null,"Total property floorspace (not property footprint)",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E15, \"N/a - Hot water only\")","v":145},"m²"]
[null,"Average watts per square metre\nNote: W/m² is a measure of your property's thermal efficiency. 0-30W/m² is very low heat loss and 120-150W/m² is very high heat loss.",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E22, \"N/a - Hot water only\")","v":58.496977669203552},"W/m²"]
[null,"Proposed system"]
[null,"Heat pump capacity\nNote: unless a full heat loss calculation has been undertaken, this figure is indicative only and may change.",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E24, \"N/a - Hot water only\")","v":8.4820617620345153},"kW"]
[null,"Heat pump type",null,{"$f":"VLOOKUP(Input!C4,'SPF Lookups'!G3:H6,2,FALSE)","v":"AAHP"}]
[null,"Your system is proposed to provide",null,{"$f":"Input!C5","v":"Space heat and hot water"}]
[null,"Performance"]
[null,"The Seasonal Performance Factor is calculated to be:",null,null,{"$f":"Input!E25","v":4.0999999999999996}]
[null,"Estimate of energy consumption of the proposed heat pump \nNote: you can convert these figures to approximate running costs.","High estimate",null,"Low estimate"]
[null,null,{"$f":"Input!E32","v":6774.3172871202414},"kWh",{"$f":"Input!E33","v":5542.6232349165602},"kWh"]
[null,"Important Note: This is not a detailed system design. It offers a reasonable estimate of likely performance and a description of the likely design.\n\nDetails may change after the heat loss survey and design / this estimate is based on a full heat loss survey and design (delete as appropriate)."]

{"sheet":"Climate & Other Lookups","index":3,"n_rows":126,"n_cols":4,"rows_kept":126,"cut":false,"hidden":false,"merged":[[3,8,3,11],[13,8,13,9],[12,10,12,11],[13,10,13,11]]}
[]
[null,"Postcode","Design outdoor low temperature","Degree days per year"]
[null,"AB",-5.4,2668]
[null,"AL",-3,2033]
[null,"B",-5.0999999999999996,2425]
[null,"BA",-4.5999999999999996,1835]
[null,"BB",-4.5,2228]
[null,"BD",-3.3,2307]
[null,"BH",-4.8,2224]
[null,"BL",-4.5,2228]
[null,"BN",-4.8,2224]
[null,"BR",-3,2255]
[null,"BS",-3.1,1835]
[null,"BT",-3.2,2360]
[null,"CA",-3.7,2388]
[null,"CB",-3,2033]
[null,"CF",-3.1,1835]
[null,"CH",-4.5,2228]
[null,"CM",-3,2033]
[null,"CO",-4.5999999999999996,2254]
[null,"CR",-3,2224]
[null,"CT",-3,2255]
[null,"CV",-5.0999999999999996,2425]
[null,"CW",-4.5,2228]
[null,"DA",-3,2255]
[null,"DD",-5.4,2577]
[null,"DE",-3.9,2228]
[null,"DG",-5.6,2483]
[null,"DH",-3.7,2370]
[null,"DL",-3.7,2388]
[null,"DN",-3.3,2307]
[null,"DT",-4.8,2224]
[null,"DY",-5.0999999999999996,2425]
[null,"E",-3,2033]
[null,"EC",-3,2033]
[null,"EH",-5.4,2577]
[null,"EN",-3,2255]
[null,"EX",-1.5,1858]
[null,"FK",-5.6,2577]
[null,"FY",-4.5,2388]
[null,"G",-5.6,2494]
[null,"GL",-4.5999999999999996,2425]
[null,"GU",-3,2033]
[null,"GY",-4.8,1800]
[null,"HA",-3,2033]
[null,"HD",-4.5,2307]
[null,"HG",-3.3,2307]
[null,"HP",-3,2033]
[null,"HR",-5.0999999999999996,2425]
[null,"HS",-5.6,1800]
[null,"HU",-3.3,2307]
[null,"HX",-4.5,2228]
[null,"IG",-3,2033]
[null,"IM",-4.5,2228]
[null,"IP",-4.5999999999999996,2254]
[null,"IV",-5.6,2668]
[null,"JE",-4.8,1800]
[null,"KA",-5.6,2494]
[null,"KT",-3,2033]
[null,"KW",-5.4,2668]
[null,"KY",-5.4,2577]
[null,"L",-4.5,2228]
[null,"LA",-4.5,2388]
[null,"LD",-3.1,2161]
[null,"LE",-3.9,2425]
[null,"LL",-4.5,2228]
[null,"LN",-3.9,2307]
[null,"LS",-3.3,2307]
[null,"LU",-3,2033]
[null,"M",-4.5,2228]
[null,"ME",-3,2033]
[null,"MK",-4.5999999999999996,2425]
[null,"ML",-5.4,2494]
[null,"N",-3,2033]
[null,"NE",-3.7,2370]
[null,"NG",-3.9,2254]
[null,"NN",-3.9,2425]
[null,"NP",-3.1,2425]
[null,"NR",-4.5999999999999996,2254]
[null,"NW",-3,2033]
[null,"OL",-4.5,2228]
[null,"OX",-4.5999999999999996,2425]
[null,"PA",-5.6,2494]
[null,"PE",-4.5999999999999996,2254]
[null,"PH",-5.6,2668]
[null,"PL",-1.5,1858]
[null,"PO",-4.8,2224]
[null,"PR",-4.5,2388]
[null,"RG",-4.5999999999999996,2033]
[null,"RH",-3,2033]
[null,"RM",-3,2033]
[null,"S",-3.3,2228]
[null,"SA",-3.1,2161]
[null,"SE",-3,2033]
[null,"SG",-3,2033]
[null,"SK",-4.5,2228]
[null,"SL",-3,2033]
[null,"SM",-3,2033]
[null,"SN",-4.5999999999999996,2425]
[null,"SO",-4.8,2224]
[null,"SP",-4.8,2224]
[null,"SR",-3.7,2370]
[null,"SS",-3,2033]
[null,"ST",-5.0999999999999996,2228]
[null,"SW",-3,2033]
[null,"SY",-5.0999999999999996,2161]
[null,"TA",-1.5,1835]
[null,"TD",-5.4,2483]
[null,"TF",-5.0999999999999996,2425]
[null,"TN",-3,2255]
[null,"TQ",-1.5,1858]
[null,"TR",-1.5,1858]
[null,"TS",-3.7,2370]
[null,"TW",-3,2203]
[null,"UB",-3,2203]
[null,"W",-3,2203]
[null,"WA",-4.5,2228]
[null,"WC",-3,2203]
[null,"WD",-3,2203]
[null,"WF",-3.3,2307]
[null,"WN",-4.5,2228]
[null,"WR",-5.0999999999999996,2425]
[null,"WS",-5.0999999999999996,2425]
[null,"WV",-5.0999999999999996,2425]
[null,"YO",-3.3,2307]
[null,"ZE",-5.4,2668]

{"sheet":"SPF Lookups","index":4,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Heat pump type","Abbreviation","Providing","SPF calculation"]
[null,null,null,null,null,null,"Air to Air Heat Pump","AAHP","Space Heating",4.0999999999999996]
[null,null,null,null,null,null,"Air to Air Heat Pump","AAHP","DHW",1.9]

{"sheet":"Version","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Amendments since publication"]
[]
[null,"Date","Version","Notes"]
[null,"XX/XX/2025",1,"First issue."]