{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Notes & Usage","Input","Output","Optional Outputs","Climate & Other Lookups","SPF Lookups","Notes Lookups","Notes Index","Version"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":4,"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,"Heat Pump Performance Estimate Calculator"]

{"sheet":"Input","index":1,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,1,1,5],[13,1,13,5],[14,1,14,3],[15,1,15,3],[4,2,4,5],[5,2,5,5],[11,2,11,5],[3,2,3,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,1,9,3],[10,1,10,3],[17,1,17,3],[32,1,32,3],[12,1,12,3],[29,1,29,3],[27,1,27,3],[30,1,30,3],[31,1,31,5],[23,1,23,5],[25,1,25,3],[24,1,24,3],[42,1,42,3],[36,1,36,5],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,5],[1,7,1,9],[3,10,3,11],[8,10,8,11],[35,1,35,3],[41,1,41,3],[26,1,26,3],[28,1,28,5],[20,1,20,5],[21,1,21,3],[22,1,22,3],[18,1,18,3],[19,1,19,3],[33,1,33,3],[34,1,34,3],[2,1,2,5],[16,1,16,3]]}
[]
[null,"Heat Pump System Performance Estimate - Input"]
[null,"Proposed system"]
[null,"Heat pump type (select one):","Air Source Heat Pump"]
[null,"Is the system type hybrid?","Yes"]
[null,"What is the age of the boiler?","New boiler"]
[null,"What is the purpose of the proposed system?","Space heat and hot water"]
[null,"Emitter type(s)?","Existing radiators"]
[null,"Type of underfloor (select one):","UFH: Flooring on High Conductivity Panel on Aluminium"]
[null,"The proposed design flow temperature will be (select one):",null,null,"56-60"," oC "]
[null,"What is the volume of the proposed cylinder?",null,null,0,"litres"]
[null,"What is the system pasteurisation strategy?","N/A - Space heating system only"]
[null,"Pasteurisation cycles by immersion",null,null,{"$f":"IF(OR(Input!C12 = \"To be provided by the heat pump\",Input!C12=\"N/A - Space heating system only\"),0, IF(Input!C12 = \"To be provided daily by immersion\", 365, IF(Input!C12 = \"To be provided weekly by immersion\", 52, \"Invalid input\")))","v":0},"per year"]
[null,"Property details (from valid EPC)"]
[null,"Space Heating Demand (Q)",null,null,0,"kWh/year"]
[null,"Demand to be supplied by the heat pump",null,null,0,"kWh/year"]
[null,"Energy required for hot water (W)",null,null,0,"kWh/year"]
[null,"Demand to be supplied by the heat pump",null,null,0,"kWh/year"]
[null,"Postcode prefix",null,null,"IP"]
[null,"Total property floorspace (not property footprint)",null,null,50,"m²"]
[null,"Climate data"]
[null,"Degree days (D)",null,null,{"$f":"VLOOKUP(E$19,'Climate & Other Lookups'!B$3:D$126,3,0)","v":2254},"per year"]
[null,"Outdoor Low Temperature (d₀)",null,null,{"$f":"VLOOKUP(E$19,'Climate & Other Lookups'!B$3:D$126,2,0)","v":-4.5999999999999996}," oC "]
[null,"Heat Loss calculations"]
[null,"Property Specific Heat Loss (Pspecific)",null,null,{"$f":"(1000*E15)/(24*E22)","v":0},"W/K"]
[null,"Total Heat Loss (Pt)",null,null,{"$f":"E25*(21-E23)","v":0},"W"]
[null,"Specific Heat Loss",null,null,{"$f":"E26/E20","v":0},"W/m²"]
[null,"Looked up Specific Heat Loss Band",null,null,{"$f":"VLOOKUP(E27,'SPF Lookups'!G10:H16,2,1)","v":"0-30"}]
[null,"Heat Pump calculations"]
[null,"Indicative Heat Pump Capacity (Subject to full Heat Loss Calculation)",null,null,{"$f":"E26/1000","v":0},"kW"]
[null,"Looked-up Seasonal Performance Factor",null,null,{"$f":"IF(C7=\"Hot water only\",\n    IF(OR(C4=\"Air Source Heat Pump\", C4=\"Solar Assisted Heat Pump\"), 1.7,\n       IF(OR(C4=\"Ground Source Heat Pump\", C4=\"Water Source Heat Pump\"), 2.24, \"\")),\n    _xlfn.XLOOKUP(C4,'SPF Lookups'!$G$3:$G$6,'SPF Lookups'!$I$3:$I$6,0))","v":2.5}]
[null,"Heat Pump System Performance"]
[null,"Annual electricity consumption (space)",null,null,{"$f":"E16/E31","v":0},"kWh/year"]
[null,"Annual electricity consumption (water)",null,null,{"$f":"E18/1.7","v":0},"kWh/year"]
[null,"Annual electricity consumption (immersion)",null,null,{"$f":"E11*E13*10*4200/3600000","v":0},"kWh/year"]
[null,"Total calculated electricity consumption of the heat pump",null,null,{"$f":"SUM(E33:E35)","v":0},"kWh/year"]
[null,"Where hybrid system"]
[null,"Demand to be supplied by the boiler",null,null,{"$f":"(E15+E17)-(E16+E18)","v":0},"kWh/year"]
[null,"Boiler efficiency",null,null,{"$f":"'Climate & Other Lookups'!G9","v":0.93}]
[null,"Energy consumption of boiler",null,null,{"$f":"E38/E39","v":0},"kWh/year"]
[null,"Totals High / Low"]
[null,"Total annual energy consumption (high)",null,null,{"$f":"IF(C5=\"No\",E36*1.1,(E36+E40)*1.1)","v":0},"kWh/year"]
[null,"Total annual energy consumption (low)",null,null,{"$f":"IF(C5=\"No\",E36*0.9,(E36+E40)*0.9)","v":0},"kWh/year"]

{"sheet":"Output","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[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],[21,1,21,5],[22,1,22,5],[23,1,23,5],[17,1,17,5],[18,1,18,3],[18,4,18,5],[19,1,20,1],[19,2,19,3],[19,4,19,5],[16,1,16,3],[13,3,13,5],[14,1,14,2],[13,1,13,2],[15,1,15,2],[14,3,14,5],[15,3,15,5]]}
[]
[null,"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!E15, \"N/a - Hot water only\")","v":0},"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!E16, \"N/a - Hot water only\")","v":0},"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!E17, \"N/a - Space heating only\")","v":0},"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!E18, \"N/a - Space heating only\")","v":0},"kWh"]
[null,"Your property"]
[null,"Your postcode prefix",null,null,{"$f":"Input!E19","v":"IP"}]
[null,"Total property floorspace (not property footprint)",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E20, \"N/a - Hot water only\")","v":50},"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!E27, \"N/a - Hot water only\")","v":0},"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!E30, \"N/a - Hot water only\")","v":0},"kW"]
[null,"Heat pump type",null,{"$f":"VLOOKUP(Input!C4,'SPF Lookups'!G3:H6,2,FALSE)","v":"ASHP"}]
[null,"Your system is proposed to provide",null,{"$f":"Input!C7","v":"Space heat and hot water"}]
[null,"Your proposed heating system will be",null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!C8, \"N/a - Hot water only\")","v":"Existing radiators"}]
[null,"The proposed flow temperature will be",null,null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), Input!E10, \"N/a - Hot water only\")","v":"56-60"}," oC "]
[null,"Performance"]
[null,"The Seasonal Performance Factor is calculated to be:",null,null,{"$f":"Input!E31","v":2.5}]
[null,"Estimate of energy consumption of the proposed heat pump (or combined system where Hybrid).\nNote: you can convert these figures to approximate running costs.","High estimate",null,"Low estimate"]
[null,null,{"$f":"Input!E42","v":0},"kWh",{"$f":"Input!E43","v":0},"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)."]
[null,"Applicable warning notes (from Table 2):"]
[null,{"$f":"IF(OR(D15=\"Space heating only\", D15=\"Space heat and hot water\"), 'Notes Lookups'!H3, \"N/a - Hot water only\")","v":"Note 5: Forecast system efficiency is low and running costs may be high without system design changes."}]

{"sheet":"Optional Outputs","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,2,3,5],[4,1,4,5],[5,1,5,5],[1,1,1,5]]}
[]
[null,"Heat Pump System Performance Estimate - Optional Outputs"]
[null,"Star rating"]
[null,"The system emitter star rating\n(based on the proposed design flow temperature of the system, ranging between 0 and 6 stars)",{"$f":"'Climate & Other Lookups'!K14","v":"«"}]
[null,"Graph of system performance"]

{"sheet":"Climate & Other Lookups","index":4,"n_rows":126,"n_cols":12,"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,"Boiler efficiency factors"]
[null,"AB",-5.4,2668,null,"Generation source","Factor",null,"Flow temp","Star rating","Flow temp","Graph outputs"]
[null,"AL",-3,2033,null,"New boiler",0.93]
[null,"B",-5.0999999999999996,2425,null,"Existing boiler (pre-1994)",0.82,null,"up to 35","««««««","up to 35",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/3.6, (Input!$E$16 + Input!$E$18)/4.3)","v":0}]
[null,"BA",-4.5999999999999996,1835,null,"Existing boiler (1994-2007)",0.87,null,"36-40","«««««","36-40",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/3.4, (Input!$E$16 + Input!$E$18)/4.1)","v":0}]
[null,"BB",-4.5,2228,null,"Existing boiler (post-2007)",0.92,null,"41-45","««««","41-45",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/3, (Input!$E$16 + Input!$E$18)/3.7)","v":0}]
[null,"BD",-3.3,2307,null,null,null,null,"46-50","«««","46-50",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/2.7, (Input!$E$16 + Input!$E$18)/3.4)","v":0}]
[null,"BH",-4.8,2224,null,"Selected boiler efficiency",{"$f":"VLOOKUP(Input!C6, 'Climate & Other Lookups'!F4:G7, 2, FALSE)","v":0.93},null,"51-55","««","51-55",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/2.4, (Input!$E$16 + Input!$E$18)/3.1)","v":0}]
[null,"BL",-4.5,2228,null,null,null,null,"56-60","«","56-60",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/2.1, (Input!$E$16 + Input!$E$18)/2.8)","v":0}]
[null,"BN",-4.8,2224,null,null,null,null,"61-65","No stars","61-65",{"$f":"IF(OR(Input!$C$4=\"Air Source Heat Pump\", Input!$C$4=\"Solar Assisted Heat Pump\"), (Input!$E$16 + Input!$E$18)/2.1, (Input!$E$16 + Input!$E$18)/2.8)","v":0}]
[null,"BR",-3,2255]
[null,"BS",-3.1,1835,null,null,null,null,"Flow temperature of proposed system (ºC)",null,{"$f":"Input!E10","v":"56-60"}]
[null,"BT",-3.2,2360,null,null,null,null,"Resultant star rating",null,{"$f":"IF(K13=\"61-65\",\"\",VLOOKUP(K13,I5:J11, 2, FALSE))","v":"«"}]
[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":5,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Specific heat loss band","Flow temperature ","SPF (Ground Source Heat Pump/Water Source Heat Pump)","SPF (Air Source Heat Pump/Solar Assisted Heat Pump)",null,"Heat pump type","Abbreviation","SPF calculation"]
[null,"0-30","up to 35",4.3,4,null,"Air Source Heat Pump","ASHP",{"$f":"INDEX('SPF Lookups'!$E$3:$E$44,MATCH(1,(Input!E28='SPF Lookups'!$B$3:$B$44)*(Input!E10='SPF Lookups'!$C$3:$C$44),0))","v":2.5}]
[null,"0-30","36-40",4.0999999999999996,3.8,null,"Solar Assisted Heat Pump","SAHP",{"$f":"INDEX('SPF Lookups'!$E$3:$E$44,MATCH(1,(Input!E28='SPF Lookups'!$B$3:$B$44)*(Input!E10='SPF Lookups'!$C$3:$C$44),0))","v":2.5}]
[null,"0-30","41-45",3.7,3.4,null,"Ground Source Heat Pump","GSHP",{"$f":"INDEX('SPF Lookups'!$D$3:$D$44,MATCH(1,(Input!E28='SPF Lookups'!$B$3:$B$44)*(Input!E10='SPF Lookups'!$C$3:$C$44),0))","v":2.8}]
[null,"0-30","46-50",3.4,3.1,null,"Water Source Heat Pump","WSHP",{"$f":"INDEX('SPF Lookups'!$D$3:$D$44,MATCH(1,(Input!E28='SPF Lookups'!$B$3:$B$44)*(Input!E10='SPF Lookups'!$C$3:$C$44),0))","v":2.8}]
[null,"0-30","51-55",3.1,2.8]
[null,"0-30","56-60",2.8,2.5,null,"Specific heat loss bands"]
[null,"0-30","61-65",2.8,2.5,null,"Minimum value","Band"]
[null,"30-50","up to 35",4.3,4,null,0,"0-30"]
[null,"30-50","36-40",4.0999999999999996,3.8,null,30,"30-50"]
[null,"30-50","41-45",3.7,3.4,null,50,"50-80"]
[null,"30-50","46-50",3.4,3.1,null,80,"80-100"]
[null,"30-50","51-55",3.1,2.8,null,100,"100-120"]
[null,"30-50","56-60",2.8,2.5,null,120,"120-150"]
[null,"30-50","61-65",2.8,2.5,null,150.00001,"Error"]
[null,"50-80","up to 35",4.3,4]
[null,"50-80","36-40",4.0999999999999996,3.8]
[null,"50-80","41-45",3.7,3.4]
[null,"50-80","46-50",3.4,3.1]
[null,"50-80","51-55",3.1,2.8]
[null,"50-80","56-60",2.8,2.5]
[null,"50-80","61-65",2.8,2.5]
[null,"80-100","up to 35",4.3,4]
[null,"80-100","36-40",4.0999999999999996,3.8]
[null,"80-100","41-45",3.7,3.4]
[null,"80-100","46-50",3.4,3.1]
[null,"80-100","51-55",3.1,2.8]
[null,"80-100","56-60",2.8,2.5]
[null,"80-100","61-65",2.8,2.5]
[null,"100-120","up to 35",4.3,4]
[null,"100-120","36-40",4.0999999999999996,3.8]
[null,"100-120","41-45",3.7,3.4]
[null,"100-120","46-50",3.4,3.1]
[null,"100-120","51-55",3.1,2.8]
[null,"100-120","56-60",2.8,2.5]
[null,"100-120","61-65",2.8,2.5]
[null,"120-150","up to 35",4.3,4]
[null,"120-150","36-40",4.0999999999999996,3.8]
[null,"120-150","41-45",3.7,3.4]
[null,"120-150","46-50",3.4,3.1]
[null,"120-150","51-55",3.1,2.8]
[null,"120-150","56-60",2.8,2.5]
[null,"120-150","61-65",2.8,2.5]

{"sheet":"Notes Lookups","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,4,18,4],[1,1,1,2],[1,4,1,5],[2,7,7,7]]}
[]
[null,"Notes",null,null,"Notes helper cells",null,null,"Combined notes reference (full)"]
[null,"Note 1","Note 1: No or minimal change to existing radiators is unlikely to be viable - unless the current radiators are significantly over-sized for your existing fossil fuel boiler.",null,"Note section 1\nbased on heat pump type",{"$f":"IF(\n    OR(\n        Input!E10=\"56-60\",\n        Input!E10=\"61-65\",\n        AND(\n            Input!E10=\"51-55\",\n            OR(Input!C4=\"Air Source Heat Pump\", Input!C4=\"Solar Assisted Heat Pump\")\n        )\n    ),\n    \"Note 5\",\n    \"\"\n)","v":"Note 5"},null,{"$f":"_xlfn.TEXTJOIN(CHAR(10) & CHAR(10), TRUE, H12:H25)","v":"Note 5: Forecast system efficiency is low and running costs may be high without system design changes."}]
[null,"Note 2","Note 2: Proposed system design is possible, but the size of standard emitters may be excessive. Speak to your installer about the emitter choices.",null,"Note section 2 (a)\nif heating system is existing radiators",{"$f":"IF(\n    Input!C8=\"Existing radiators\",\n    INDEX('Notes Index'!H4:H45,\n        MATCH(1,\n            (Input!E28='Notes Index'!B4:B45) * (Input!E10='Notes Index'!C4:C45),\n            0\n        )\n    ),\n    \"\"\n)","v":0}]
[null,"Note 3","Note 3: Important: The system cannot operate as designed for tile, wood or carpet on screed, or where aluminium panels are used instead of screed. Fabric heat loss should be reduced and/or load sharing with other emitter types.",null,"Note section 2 (b)\nif heating system is mostly upgraded radiators",{"$f":"IF(\n    Input!C8=\"Mostly upgraded radiators\",\n    IFERROR(\n        INDEX('Notes Index'!I4:I45,\n            MATCH(1,\n                (Input!E28='Notes Index'!B4:B45) * (Input!E10='Notes Index'!C4:C45),\n                0\n            )\n        ),\n        \"\"\n    ),\n    \"\"\n)","v":""}]
[null,"Note 4","Note 4: The system can operate as designed for tiles. For wood and carpet floor coverings, additional measures to improve property energy efficiency are likely to be needed (such as improved insulation or draught proofing).",null,"Note section 2 (c)\nif UFH: flooring on screed",{"$f":"IF(\n    AND(\n        OR(Input!C8=\"Mostly underfloor\", Input!C8=\"Approximately 50% radiators and 50% underfloor\"),\n        Input!C9=\"UFH: Flooring on Screed\"\n    ),\n    IFERROR(\n        INDEX('Notes Index'!J4:J45,\n            MATCH(1,\n                (Input!E28='Notes Index'!B4:B45) * (Input!E10='Notes Index'!C4:C45),\n                0\n            )\n        ),\n        \"\"\n    ),\n    \"\"\n)","v":""}]
[null,"Note 5","Note 5: Forecast system efficiency is low and running costs may be high without system design changes.",null,"Note section 2 (d)\nif UFH: chipboard on aluminium",{"$f":"IF(\n    AND(\n        OR(Input!C8=\"Mostly underfloor\", Input!C8=\"Approximately 50% radiators and 50% underfloor\"),\n        Input!C9=\"UFH: Flooring on Chipboard on Aluminium\"\n    ),\n    IFERROR(\n        INDEX('Notes Index'!K4:K45,\n            MATCH(1,\n                (Input!E28='Notes Index'!B4:B45) * (Input!E10='Notes Index'!C4:C45),\n                0\n            )\n        ),\n        \"\"\n    ),\n    \"\"\n)","v":""}]
[null,"Note 6","Note 6: Not suitable for UFH.",null,"Note section 2 (e)\nif UFH: high conductivity panel on aluminium",{"$f":"IF(\n    AND(\n        OR(Input!C8=\"Mostly underfloor\", Input!C8=\"Approximately 50% radiators and 50% underfloor\"),\n        Input!C9=\"UFH: Flooring on High Conductivity Panel on Aluminium\"\n    ),\n    IFERROR(\n        INDEX('Notes Index'!L4:L45,\n            MATCH(1,\n                (Input!E28='Notes Index'!B4:B45) * (Input!E10='Notes Index'!C4:C45),\n                0\n            )\n        ),\n        \"\"\n    ),\n    \"\"\n)","v":""}]
[null,"Note 7","Note 7: Suitable for tiles in bathrooms/ensuites only."]
[null,"Note 8","Note 8: Screed on floors with UFH complies with BS1264 Type A construction laid on floor insulation - default pipe spacing 200mm cc.",null,"Collated note\nreferences",{"$f":"CONCATENATE(F3, CHAR(10), F4, CHAR(10), F5, CHAR(10), F6, CHAR(10), F7, CHAR(10), F8)","v":"Note 5\n0\n\n\n\n"}]
[null,"Note 9","Note 9: Dry floor systems with UFH complies with BS1264 Type B aluminium plate construction laid with insulation underneath - default pipe spacing 200mm cc."]
[null,"Note 10","Note 10: specialist UFH designers can provide more accurate information for heating performance with different systems.",null,"Separated note\nreferences",{"$f":"_xlfn.FILTERXML(\"<t><s>\" & SUBSTITUTE(_xlfn.TEXTJOIN(\"|\", TRUE, F10), CHAR(10), \"</s><s>\") & \"</s></t>\", \"//s\")","v":"Note 5"},null,{"$f":"IFERROR(INDEX($C$3:$C$12, MATCH(F12, $B$3:$B$12, 0)), \"\")","v":"Note 5: Forecast system efficiency is low and running costs may be high without system design changes."}]
[null,null,null,null,null,0,null,{"$f":"IFERROR(INDEX($C$3:$C$12, MATCH(F13, $B$3:$B$12, 0)), \"\")","v":""}]
[null,null,null,null,null,{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"Notes Index","index":7,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,12,1,14]]}
[]
[null,"Heat loss band","Flow temp","Ground Source Heat Pump","Water Source Heat Pump","Air Source Heat Pump","Solar Assisted Heat Pump","Existing radiators","Mostly upgraded radiators","Mostly underfloor",null,null,"Approximately 50% radiators and 50% underfloor"]
[null,null,null,null,null,null,null,null,null,"UFH: Flooring on Screed","UFH: Flooring on Chipboard on Aluminium","UFH: Flooring on High Conductivity Panel on Aluminium","UFH: Flooring on Screed","UFH: Flooring on Chipboard on Aluminium","UFH: Flooring on High Conductivity Panel on Aluminium"]
[null,"0-30","up to 35",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 4\nNote 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 4\nNote 9\nNote 10","Note 9\nNote 10"]
[null,"0-30","36-40",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"0-30","41-45",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"0-30","46-50",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"0-30","51-55",null,null,"Note 5","Note 5",null,null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"0-30","56-60","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 9\nNote 10","Note 9\nNote 10","Note 6","Note 9\nNote 10","Note 9\nNote 10"]
[null,"0-30","61-65","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]
[null,"30-50","up to 35",null,null,null,null,"Note 1",null,"Note 4\nNote 8\nNote 10","Note 3","Note 4\nNote 9\nNote 10","Note 4\nNote 8\nNote 10","Note 3","Note 4\nNote 9\nNote 10"]
[null,"30-50","36-40",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"30-50","41-45",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"30-50","46-50",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"30-50","51-55",null,null,"Note 5","Note 5",null,null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"30-50","56-60","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 9\nNote 10","Note 9\nNote 10","Note 6","Note 9\nNote 10","Note 9\nNote 10"]
[null,"30-50","61-65","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]
[null,"50-80","up to 35",null,null,null,null,"Note 1",null,"Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"50-80","36-40",null,null,null,null,"Note 1",null,"Note 4\nNote 8\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 8\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 9\nNote 10"]
[null,"50-80","41-45",null,null,null,null,"Note 1",null,"Note 4\nNote 8\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 8\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 9\nNote 10"]
[null,"50-80","46-50",null,null,null,null,"Note 1",null,"Note 8\nNote 10","Note 4\nNote 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 4\nNote 9\nNote 10","Note 9\nNote 10"]
[null,"50-80","51-55",null,null,"Note 5","Note 5","Note 1",null,"Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 9\nNote 10","Note 9\nNote 10"]
[null,"50-80","56-60","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 9\nNote 10","Note 9\nNote 10","Note 6","Note 9\nNote 10","Note 9\nNote 10"]
[null,"50-80","61-65","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]
[null,"80-100","up to 35",null,null,null,null,"Note 2","Note 2","Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"80-100","36-40",null,null,null,null,"Note 1",null,"Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"80-100","41-45",null,null,null,null,"Note 1",null,"Note 4\nNote 8\nNote 10","Note 3","Note 4\nNote 9\nNote 10","Note 4\nNote 8\nNote 10","Note 3","Note 4\nNote 9\nNote 10"]
[null,"80-100","46-50",null,null,null,null,"Note 1",null,"Note 4\nNote 8\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 8\nNote 10","Note 4\nNote 9\nNote 10","Note 4\nNote 9\nNote 10"]
[null,"80-100","51-55",null,null,"Note 5","Note 5","Note 1",null,"Note 8\nNote 10","Note 4\nNote 9\nNote 10","Note 9\nNote 10","Note 8\nNote 10","Note 4\nNote 9\nNote 10","Note 9\nNote 10"]
[null,"80-100","56-60","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 9\nNote 10","Note 9\nNote 10","Note 6","Note 9\nNote 10","Note 9\nNote 10"]
[null,"80-100","61-65","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]
[null,"100-120","up to 35",null,null,null,null,"Note 2","Note 2","Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"100-120","36-40",null,null,null,null,"Note 2","Note 2","Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"100-120","41-45",null,null,null,null,"Note 2","Note 2","Note 7\nNote 8\nNote 10","Note 3","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 3","Note 7\nNote 8\nNote 10"]
[null,"100-120","46-50",null,null,null,null,"Note 1",null,"Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10"]
[null,"100-120","51-55",null,null,"Note 5","Note 5","Note 1",null,"Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10"]
[null,"100-120","56-60","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 6","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10"]
[null,"100-120","61-65","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]
[null,"120-150","up to 35",null,null,null,null,"Note 2","Note 2","Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"120-150","36-40",null,null,null,null,"Note 2","Note 2","Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"120-150","41-45",null,null,null,null,"Note 2","Note 2","Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"120-150","46-50",null,null,null,null,"Note 1",null,"Note 3","Note 3","Note 3","Note 3","Note 3","Note 3"]
[null,"120-150","51-55",null,null,"Note 5","Note 5","Note 1",null,"Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10","Note 7\nNote 8\nNote 10"]
[null,"120-150","56-60","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]
[null,"120-150","61-65","Note 5","Note 5","Note 5","Note 5",null,null,"Note 6","Note 6","Note 6","Note 6","Note 6","Note 6"]

{"sheet":"Version","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Amendments since publication"]
[]
[null,"Date","Version","Notes"]
[null,"2017-09-19",1,"First issue."]
[null,"2018-05-22",2,"Inclusion of installation address and customer details\nLink to CPI to enable updates by MCS Contractors as CPI changes\nDate and installer project reference\nUpdate to include default SAP DHW figures to 1.75 for ASHPs and 2.24 for GSHPs where system is providing space heating and hot water. If the system is providing hot water only, this should be calculated in accordance with Clause 4.3.2 d) of MIS 3005\nAddition of EPC option that heat demand is based on draft EPC using SAP for new or custom builds\nAddition of RHI funding stream option – (non-domestic for shared ground loop GSHPs)\nAmended Age of existing system ranges to be within years (e.g. post-2007) rather than less than 10 years \nUnlock RHI Tariff cell to enable updates by MCS Contractors as tariffs change\nAddition of a note to state that the fuel values include VAT\nAmendment the calorific values in the value look up table\nAddition of ASHP and GSHP systems for the existing heating system fuel type\nNote added to clarify that the RHI is correct within the 7-year payback period\nAmendment to the SCOP table of values to zero\nUpdate the Annual Running Cost graph in the PET to include VHTHPs (55-65 degrees)\nAddition of MCS reference and version number to each page\nAddition of note that MMSP is only applicable for Domestic RHI\nClarification with a note of where RHI payments are deemed and when they are metered"]
[null,"2019-07-31",2.1,"Updated for the replacement of brand elements including fonts and logos. "]
[null,"2022-02-01",3,"Removed financial data and improved presentation plus calculation of Hybrids."]
[null,"XXX",4,"Removal of the use of SCOP values and instead relying on SPF values  \nIntegrating the use of 'notes' for support"]