{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Performance Estimate","RHI Graph Generation","LISTS","Version","Sheet1"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":13,"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":"Performance Estimate","index":0,"n_rows":160,"n_cols":16,"rows_kept":160,"cut":false,"hidden":false,"merged":[[128,5,140,14],[42,3,42,7],[44,3,44,7],[46,3,46,7],[54,3,54,7],[56,3,56,6],[64,4,64,7],[66,4,66,7],[68,4,68,8],[1,9,8,14],[14,4,14,8],[16,4,16,8],[117,1,121,14],[25,13,25,14],[18,4,18,8],[20,4,20,8],[32,9,32,10],[10,4,10,8],[12,4,12,8]]}
[]
[null,null,null,null,null,null,null,null,null,"**Optional Installer Logo**"]
[]
[]
[null,"Heat Pump System Performance Estimate"]
[]
[]
[]
[]
[]
[null,null,"Installer Project Reference"]
[]
[null,null,"   Client "]
[]
[null,null,"Installation Address Line 1"]
[]
[null,null,"Installation Address Line 2"]
[]
[null,null,"Installation Address Line 3"]
[]
[null,null,"Installation Address Line 4"]
[]
[]
[]
[]
[null,null,"Energy Performance Certificate (EPC) Information",null,null,null,null,null,null,null,null,"Fuel Information "]
[null,null,"Is the building existing and not proposed to be extended or reduced in size?",null,null,null,null,"Yes",null,null,null,"(where possible unit rate from customer bills inc. VAT)"]
[]
[null,null,{"$f":"IF(H27=\"Yes\",\"EPC No.\",\"System based on draft EPC\")","v":"EPC No."},null,null,null,null,null,null,null,null,null,"Date on which prices found  "]
[]
[null,null,null,"Energy required to heat property",20000,"  kWh",null,null,null,"Renewable Heat Incentive (RHI) info required  ","Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Existing Fuel","Cost"]
[null,null,null,"Energy required for hot water",3000,"  kWh",null,null,"RHI Funding Stream  ","Domestic",null,null,"Oil (p/litre)"]
[]
[null,null,null,"Potential RHI energy ",{"$f":"IF(D43=\"Air Source Heat Pump\",IF(E36>20000,20000,E36),IF(E36>30000,30000,E36))","v":20000}," kWh",null,null,null,"Ground Source - Shared Ground Loop System","No",null,null,"Cost"]
[null,null,null,null,{"$f":"IF(D55=\"Heating and Hot Water\",(E31+E33),IF(D55=\"Heating Only\",(E31),IF(D55=\"Hot Water Only\",(E33),IF(OR(D55=\"Hybrid - Using current boiler\",D55=\"Hybrid - Using new boiler\"),((E31))*(P55/100)))))","v":23000},null,null,null,{"$f":"IF(D55=\"Heating and Hot Water\",(E31+E33),IF(D55=\"Heating Only\",(E31),IF(D55=\"Hot Water Only\",(E33),IF(OR(D55=\"Hybrid - Using current boiler\",D55=\"Hybrid - Using new boiler\"),((E31))*(P55/100)))))","v":23000},null,null,null,"Electricity (p/kWh)  "]
[null,null,null,"Energy potentially eligible for RHI",{"$f":"IF(OR(J33=\"non-domestic\",AND(K35=\"Yes\",D43=\"Ground Source Heat Pump\",J33=\"non-domestic\")),E35,E35*(1-(1/D51)))","v":14722.955145118734},"  kWh"]
[null,null,null,"(Adjusted using SCoP where applicable)"]
[]
[]
[null,null,"New Renewable System Information"]
[]
[null,null,"Type of System","Air Source Heat Pump",null,null,null,null,"       *This calculator is not designed to be used for Solar Assisted Heat Pumps "]
[]
[null,null,"Manufacturer Name","Manufacturer A"]
[]
[null,null,"Manufacturer Model","Model ABC"]
[]
[null,null,"Flow Temperature",40," °C","* Determined by the temp. of the water leaving the HP when supplying space heating at the external design temp."]
[]
[null,null,"MCS SCOP Heating",{"$f":"VLOOKUP('Performance Estimate'!D49&\"oC\",C128:D159,2)","v":3.79},null,"* SCoP - Seasonal Coefficient of Performance. This value is based on the MCS HP SCoP Table below"]
[]
[null,null,"MCS SCOP Hot Water",{"$f":"IF(D43=\"Ground Source Heat Pump\",2.24,1.75)","v":1.75},null,"* If DHW only, this should be calculated in accordance with Clause 4.3.2 d) of MIS 3005. If providing space heating and DHW, default value from SAP2012"]
[]
[null,null,"Renewable Sytem Provides","Heating and Hot Water",null,null,null,null,null,null,null,null,null,null,"Heat Pump Covers",80]
[]
[null,null,"Hot Water Immersion Use","Once per week",null,null,null,"  * based on 50C up to 60C, 3kW",null,null,null,null,null,null,"New Boiler Efficiency"]
[]
[null,null,"Size of Hot Water Cylinder",200," ltr"]
[]
[]
[]
[null,"Existing Heating System",null,null,null,null,null,null,null,null,"Renewable Heat Incentive (RHI)  ",null,null,"RHI Tariffs can be viewed here"]
[]
[null,null,null,"Existing heating system fuel","Oil",null,null,null,null,null,null,"p/kWh","T1 Tariff",null,"p/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"T2 Tariff",null,"p/kWh"]
[null,null,null," Hot Water heated by","Oil",null,null,null,"   see note * below"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HP Capacity",null,"kW"]
[null,null,null,"Age of existing system","Post-2007"]
[null,null,null,null,null,null,null,null,null,null,null,null,"T1 Energy",{"$f":"IF(N68*1314>E37,E37,(N68*1314))","v":0},"kWh"]
[null,null,null,"Efficiency of existing system",{"$f":"IF(E65=\"Electric\",100,\nIF(E65=\"Smokeless Fuel\",75,\nIF(E65=\"Coal\",75,\nIF(E65=\"Seasoned Wood\",85,\nIF(E65=\"pellets\",90,\nIF(E65=\"Air Source Heat Pump\",250,\nIF(E65=\"Ground Source Heat Pump\",300,\nIF(E69=\"Pre-1994\",82,IF(E69=\"1994-2007\",87,IF(E69=\"Post-2007\",92))))))))))","v":92},"%",null,null,null,null,null,null,"T2 Energy",{"$f":"IF(OR(N70>(E35),N70=(E35)),0,(E35)-N70)","v":20000},"kWh"]
[]
[null,null,"*If a different source of fuel is chosen for heating & hot water system, "]
[null,null,"it is always assumed the hot water system is generated via direct ",null,null,null,null,null,null,null,"Metering and Monitoring Service Package (MMSP)"]
[null,null,"electricity despite there appearing to be a choice"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Yes","  *RHI Uplift"]
[]
[]
[null,null,"Running Costs"]
[]
[null,null,null,null,"Existing system annual running cost",{"$f":"((E31/(IF(OR(E65=\"ground source heat pump\",E65=\"Air Source Heat Pump\"),1,E71%))*(VLOOKUP(E65,LISTS!G2:H12,2,FALSE)/100)+IF(E67=E65,((E33/(IF(OR(E65=\"ground source heat pump\",E65=\"Air Source Heat Pump\"),1,E71%)))*(VLOOKUP(E65,LISTS!G2:H12,2,FALSE)/100)),((E33)*(N36/100)))))","v":0},null,null,null,null,null,"MMSP up front",{"$f":"IF(M76=\"Yes\",805,0)","v":805}]
[]
[null,null,null,null,"Renewable System annual running cost",{"$f":"(IF(D55=\"Heating Only\",(E31/D51)*(N36/100),\nIF(D55=\"Heating and Hot Water\",(E31/D51)*(N36/100),0)+(IF(D55=\"Heating and Hot Water\",(E33/D53)*(N36/100),\nIF(D55=\"Hot water only\",(E33/D53)*(N36/100),\nIF(OR(D55=\"Hybrid - Using current boiler\",D55=\"Hybrid - Using new boiler\"),(E31/D51)*(N36/100)*(P55/100))))\n+IF(OR(D55=\"Hybrid - Using current boiler\",D55=\"Hybrid - Using new boiler\",D55=\"Heating Only\"),0,((((D59*4.19*10)/3)/3600)*3)*(N36/100)*IF(D57=\"none\",0,IF(D57=\"Once per day\",365,IF(D57=\"Once per week\",52)))))))","v":0}," *Includes Immersion",null,null,null,null,"MMSP per year",{"$f":"IF(M76=\"Yes\",115,0)","v":115}]
[]
[null,null,null,null,"Fossil Fuel Cost in new system",{"$f":"IF(D55=\"Heating Only\",(E33/E71)*VLOOKUP(E65,LISTS!G2:H12,2,FALSE),\nIF(D55=\"Hot Water Only\",(E31/E71)*VLOOKUP(E65,LISTS!G2:H12,2,FALSE),\nIF(D55=\"Heating and Hot Water\",0,\nIF(D55=\"Hybrid - Using current boiler\",((E33+(E31*(1-(P55/100))))/E71)*VLOOKUP(E65,LISTS!G2:H12,2,FALSE),\nIF(D55=\"Hybrid - Using new boiler\",((E33+(E31*(1-(P55/100))))/P57)*VLOOKUP(E65,LISTS!G2:H12,2,FALSE))))))","v":0},null,null,null,null,null,"RHI per year",{"$f":"IF(OR(D43=\"Air Source Heat Pump\",J33=\"Domestic\"),(E37*K65/100),IF(N70<(E35),((N70*N65)+((N71)*N66))/100,E35*N65/100))","v":0},{"$f":"IF(OR(D43=\"Air Source Heat Pump\",J33=\"Domestic\"),\"* Note: RHI funding stops after 7 years\",\" *Note: RHI funding stops after 20 years\")","v":"* Note: RHI funding stops after 7 years"}]
[]
[null,null,null,null,"Annual fuel saving",{"$f":"F81-(F83+F85)","v":0},null,null,null,null,null,"Total RHI",{"$f":"IF(OR(D43=\"Air Source Heat Pump\",J33=\"Domestic\"),LISTS!O9,LISTS!O22)","v":0},"   * Please note payments are "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D43=\"ground source heat pump\",J33=\"non-domestic\",K35=\"yes\"),\"      based on deemed values\",IF(J33=\"non-domestic\",\"     based on metered values\",\"      based on deemed values\"))","v":"      based on deemed values"}]
[null,null,null,null,{"$f":"IF((J33=\"Domestic\"),\"Fuel saving over 7 years\",\"Fuel saving over 20 years\")","v":"Fuel saving over 7 years"},{"$f":"IF((J33=\"domestic\"),F87*7,F87*20)","v":0},null,null,null,null,null,{"$f":"IF((J33=\"Domestic\"),\"Total fuel saving, RHI & MMSP over 7 years\",\"Total fuel saving, RHI & MMSP over 20 years\")","v":"Total fuel saving, RHI & MMSP over 7 years"},{"$f":"IF((J33=\"Non-Domestic\"),M87+F89,M87+F89+M81+(M83*7))","v":1610}]
[]
[null,null,null,null,null,null,null,null,null,null,"CPI linkd@",2.3E-2,"    *  MMSP only applicable for Domestic RHI"]
[null,null,null,null,null,null,null,null,null,null,"Government CPI reference"]
[]
[null,null,"Capital Cost for Installation"]
[]
[null,null,null,null,"Cost for installation of new system     ",15000,"  inc.VAT","* Breakdown of quote detail provided seperately"]
[]
[]
[]
[null,null,"Energy Requirement for the building"]
[]
[null,null,"Energy required to heat property",null,null,{"$f":"E31","v":20000},"  kWh"]
[null,null,"Energy required for hot water",null,null,{"$f":"E33","v":3000},"  kWh"]
[]
[]
[]
[null,null,null,"New System Running Info"]
[]
[null,null,null,"Existing Annual Cost",{"$f":"F81","v":0}]
[null,null,null,"Proposed Annual Cost",{"$f":"F83+F85","v":0}]
[null,null,null,"Electrical Energy consumed",{"$f":"IF(D55=\"Heating and Hot Water\",(E31/D51)+(E33/D53),IF(D55=\"Heating Only\",(E31)/D51,IF(D55=\"Hot Water Only\",(E33)/D53,IF(OR(D55=\"Hybrid - Using current boiler\",D55=\"Hybrid - Using new boiler\"),((E31)/D51)*(P55/100)))))","v":6991.3305691669811},"  kWh"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Temperature (°C)"]
[]
[null,"Disclaimer"]
[null,"The performance of microgeneration heat pump systems is impossible to predict with certainty due to the variability of the climate and its subsequent effect on both heat supply and demand. This estimate is given as guidance only and should not be considered a guarantee.\n\nImportant Information: A technical variation to the specification could affect the performance of the Heat Pump System in which case the MCS Contractor MUST update and re-issue this document and advise the customer of their Consumer Rights. See CTSI approved Consumer Codes for more information: http://www.microgenerationcertification.org/consumers/important-consumer-information     "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MCS 031 - v2.0"]
[]
[]
[null,null,"Link to MCS Website SCoP values"]
[]
[null,null,"Flow temperature","SCOP",null,"SCoP Definition"]
[null,null,"35°C",{"$f":"IF($D$47=\"Model ABC\",4.02,0)","v":4.0199999999999996},null,"SCoP = Seasonal Coefficient of Performance:\nMCS SCoP is a theoretical indication of the anticipated efficiency of a heat pump aggregated over a year using standard climate data across Europe. It indicates the units of total heat energy generated (output) for each unit of energy (electricity) consumed (input). It is slightly different to ErP SCoP as it contains efficency losses due to controls and brine pumps (for a GSHP). As a guide a heat pump with a MCS SCoP of 3 generates 3 kWh of heat energy for every 1 kWh of electrical energy it consumes.\n\nThis also means that 2/3rds of the heat output could be eligible for RHI payments. MCS SCoP is based on stringent factory based tests for equipment but does not specifically include the energy consumption of  heating circulating pump(s) nor does it model the transient conditions typically experienced in practice in the consumers home and hence the overall final system efficiency is likely to be different from the MCS SCoP. \n"]
[null,null,"36°C",{"$f":"IF($D$47=\"Model ABC\",3.98,0)","v":3.98}]
[null,null,"37°C",{"$f":"IF($D$47=\"Model ABC\",3.93,0)","v":3.93}]
[null,null,"38°C",{"$f":"IF($D$47=\"Model ABC\",3.88,0)","v":3.88}]
[null,null,"39°C",{"$f":"IF($D$47=\"Model ABC\",3.84,0)","v":3.84}]
[null,null,"40°C",{"$f":"IF($D$47=\"Model ABC\",3.79,0)","v":3.79}]
[null,null,"41°C",{"$f":"IF($D$47=\"Model ABC\",3.74,0)","v":3.74}]
[null,null,"42°C",{"$f":"IF($D$47=\"Model ABC\",3.7,0)","v":3.7}]
[null,null,"43°C",{"$f":"IF($D$47=\"Model ABC\",3.65,0)","v":3.65}]
[null,null,"44°C",{"$f":"IF($D$47=\"Model ABC\",3.6,0)","v":3.6}]
[null,null,"45°C",{"$f":"IF($D$47=\"Model ABC\",3.55,0)","v":3.55}]
[null,null,"46°C",{"$f":"IF($D$47=\"Model ABC\",3.52,0)","v":3.52}]
[null,null,"47°C",{"$f":"IF($D$47=\"Model ABC\",3.48,0)","v":3.48}]
[null,null,"48°C",{"$f":"IF($D$47=\"Model ABC\",3.44,0)","v":3.44}]
[null,null,"49°C",{"$f":"IF($D$47=\"Model ABC\",3.4,0)","v":3.4}]
[null,null,"50°C",{"$f":"IF($D$47=\"Model ABC\",3.36,0)","v":3.36}]
[null,null,"51°C",{"$f":"IF($D$47=\"Model ABC\",3.32,0)","v":3.32}]
[null,null,"52°C",{"$f":"IF($D$47=\"Model ABC\",3.28,0)","v":3.28}]
[null,null,"53°C",{"$f":"IF($D$47=\"Model ABC\",3.25,0)","v":3.25}]
[null,null,"54°C",{"$f":"IF($D$47=\"Model ABC\",3.21,0)","v":3.21}]
[null,null,"55°C",{"$f":"IF($D$47=\"Model ABC\",3.17,0)","v":3.17}]
[null,null,"56°C",0]
[null,null,"57°C",0]
[null,null,"58°C",0]
[null,null,"59°C",0]
[null,null,"60°C",0]
[null,null,"61°C",0]
[null,null,"62°C",0]
[null,null,"63°C",0]
[null,null,"64°C",0]
[null,null,"65°C",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MCS 031 - v2.0"]

{"sheet":"RHI Graph Generation","index":1,"n_rows":91,"n_cols":16,"rows_kept":91,"cut":false,"hidden":true,"merged":[[37,4,37,5],[16,4,16,6],[18,4,18,6],[20,4,20,6],[26,4,26,6],[28,4,28,5],[35,4,35,5]]}
[]
[]
[]
[]
[null,null,"MCS Performance Estimate Template"]
[]
[]
[null,null,"EPC Information",null,null,null,null,null,null,"Fuel Information (Current Prices)"]
[]
[null,null,null,null,"Energy required to heat property",{"$f":"'Performance Estimate'!E31","v":20000},"kWh",null,null,"Gas (p/kWh)",{"$f":"'Performance Estimate'!N33","v":0},null,"Oil (p/litre)",{"$f":"'Performance Estimate'!N36","v":0}]
[]
[null,null,null,null,"Energy required for hot water",{"$f":"'Performance Estimate'!E33","v":3000},"kWh",null,null,"LPG (p/litre)",{"$f":"'Performance Estimate'!N33","v":0},null,"Electricity (p/kWh)",{"$f":"'Performance Estimate'!N36","v":0}]
[]
[]
[null,null,"New Renewable System Information"]
[]
[null,null,null,"Type of System","Ground Source Heat Pump",null,null,null,null,null,"MMSP Included (RHI Uplift)","Yes"]
[]
[null,null,null,"Manufacturer Name",{"$f":"'Performance Estimate'!D45","v":"Manufacturer A"}]
[]
[null,null,null,"Manufacturer Model",{"$f":"'Performance Estimate'!D47","v":"Model ABC"}]
[]
[null,null,null,"Flow Temperature",{"$f":"'Performance Estimate'!D49","v":40},"°C"]
[]
[null,null,null,"Seasonal Heating Efficiency",{"$f":"VLOOKUP(E23&\"oC\",'Performance Estimate'!$C$129:$D$159,2)","v":3.79},null,null,"Seasonal Hot Water Efficiency",{"$f":"'Performance Estimate'!D53","v":1.75}]
[]
[null,null,null,"Renewable Sytem Provides","Heating and Hot Water",null,null,"   *DHW by fossil fuel",null,null,"Renewable System Covers",80,"% of heating energy"]
[]
[null,null,null,"Hot Water Immersion Use",{"$f":"'Performance Estimate'!D57","v":"Once per week"},null,"  * 50C up to 60C, 3kW Immersion",null,null,null,"New Boiler Efficiency",92,"%"]
[]
[null,null,null,"Size of Cylinder",{"$f":"'Performance Estimate'!D59","v":200},"ltr"]
[]
[]
[null,null,"Current Heating System"]
[]
[null,null,null,"Existing heating system fuel",{"$f":"'Performance Estimate'!E65","v":"Oil"}]
[]
[null,null,"Hot water"," DHW heated by",{"$f":"'Performance Estimate'!E67","v":"Oil"}]
[]
[null,null,null,"Old system efficiency",{"$f":"'Performance Estimate'!E71","v":92},"%"]
[]
[]
[null,null,"Running Cost",null,null,null,null,null,null,"Renewable Heat Incentive"]
[]
[null,null,null,null,"Existing system annual running cost",{"$f":"((F10/E40%)*(LOOKUP(E36,LISTS!G2:H5,LISTS!H2:H5)/100))+IF(E38=E36,((F12/E40%)*(LOOKUP(E36,LISTS!G2:H5,LISTS!H2:H5)/100)),((F12)*(N12/100)))","v":0},null,null,null,"RHI Tariff",{"$f":"'Performance Estimate'!K65","v":0},"p/kWh"]
[]
[null,null,null,null,"Renewable System annual running cost",{"$f":"(IF(E27=\"Heating Only\",(F10/E25)*(N12/100),IF(E27=\"Heating and Hot Water\",(F10/E25)*(N12/100),0)+(IF(E27=\"Hot Water Only\",(F12/I25)*(N12/100),IF(E27=\"Heating and Hot Water\",(F12/I25)*(N12/100),IF(OR(E27=\"Hybrid - Using current boiler\",E27=\"Hybrid - Using new boiler\"),(F10/E25)*(N12/100)*(L27/100)))+IF(OR(E27=\"Hybrid - Using current boiler\",E27=\"Hybrid - Using new boiler\",E27=\"Heating Only\"),0,((((E31*4.19*10)/3)/3600)*3)*(N12/100)*IF(E29=\"none\",0,IF(E29=\"Once per day\",365,IF(E29=\"Once per week\",52))))))))","v":0}," *Includes Immersion",null,null,"MMSP per year",{"$f":"IF(L17=\"Yes\",115)","v":115}]
[]
[null,null,null,null,"Fossil Fuel Cost in new system",{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0,IF(E27=\"Hybrid - Using current boiler\",((F12+(F10*(1-(L27/100))))/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12))))),IF(E27=\"Hybrid - Using new boiler\",((F12+(F10*(1-(L27/100))))/L29)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12))))))))))","v":0}]
[]
[null,null,null,null,"Annual fuel saving",{"$f":"F45-(F47+F49)","v":0},null,null,null,"RHI per year",{"$f":"(F55*K45/100)+K47","v":115}]
[]
[null,null,null,null,"Fuel saving over the RHI period",{"$f":"F51*7","v":0},null,null,null,"RHI over 7 years",{"$f":"LISTS!O9","v":0},"CPI linkd @",{"$f":"'Performance Estimate'!L91","v":2.3E-2}]
[]
[null,null,null,null,"Renewable heat delivered",{"$f":"IF(E27=\"Heating and Hot Water\",(F10+F12)-((F10+F12)/E25),IF(E27=\"Heating Only\",(F10)-((F10)/E25),IF(E27=\"Hot Water Only\",(F12)-((F12)/E25),IF(OR(E27=\"Hybrid - Using current boiler\",E27=\"Hybrid - Using new boiler\"),((F10)-((F10)/E25))*(L27/100)))))","v":16931.398416886543},"kWh",null,null,"Total fuel saving and RHI",{"$f":"K53+F53","v":0}]
[]
[]
[]
[null,null,"Flow Temp",{"$f":"SCOP[[#Headers],[SCOP]]","v":"SCOP"},"Renew Cost","Fossil Cost","New Annual Running Cost"]
[null,null,35,{"$f":"IF('Performance Estimate'!D129=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D129)","v":4.0199999999999996},{"$f":"(IF($E$27=\"Heating Only\",($F$10/D60)*($N$12/100),IF($E$27=\"Heating and Hot Water\",($F$10/D60)*($N$12/100),0)+(IF($E$27=\"Hot Water Only\",($F$12/$I$25)*($N$12/100),IF($E$27=\"Heating and Hot Water\",($F$12/$I$25)*($N$12/100),IF(OR($E$27=\"Hybrid - Using current boiler\",$E$27=\"Hybrid - Using new boiler\"),($F$10/D60)*($N$12/100)*($L$27/100)))+IF(OR($E$27=\"Hybrid - Using current boiler\",$E$27=\"Hybrid - Using new boiler\",$E$27=\"Heating Only\"),0,(((($E$31*4.19*10)/3)/3600)*3)*($N$12/100)*IF($E$29=\"none\",0,IF($E$29=\"Once per day\",365,IF($E$29=\"Once per week\",52))))))))","v":0},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$f":"IF(D60=0,F60,F60+E60)","v":0},null,{"$f":"E23","v":40},{"$f":"ROUNDUP(MAX(G60:G80),-2)","v":0}]
[null,null,36,{"$f":"IF('Performance Estimate'!D130=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D130)","v":3.98},{"$f":"(IF($E$27=\"Heating Only\",($F$10/D61)*($N$12/100),IF($E$27=\"Heating and Hot Water\",($F$10/D61)*($N$12/100),0)+(IF($E$27=\"Hot Water Only\",($F$12/$I$25)*($N$12/100),IF($E$27=\"Heating and Hot Water\",($F$12/$I$25)*($N$12/100),IF(OR($E$27=\"Hybrid - Using current boiler\",$E$27=\"Hybrid - Using new boiler\"),($F$10/D61)*($N$12/100)*($L$27/100)))+IF(OR($E$27=\"Hybrid - Using current boiler\",$E$27=\"Hybrid - Using new boiler\",$E$27=\"Heating Only\"),0,(((($E$31*4.19*10)/3)/3600)*3)*($N$12/100)*IF($E$29=\"none\",0,IF($E$29=\"Once per day\",365,IF($E$29=\"Once per week\",52))))))))","v":0},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$f":"IF(D61=0,F61,F61+E61)","v":0},null,{"$f":"I60","v":40},0]
[null,null,37,{"$f":"IF('Performance Estimate'!D131=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D131)","v":3.93},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,38,{"$f":"IF('Performance Estimate'!D132=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D132)","v":3.88},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,39,{"$f":"IF('Performance Estimate'!D133=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D133)","v":3.84},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,40,{"$f":"IF('Performance Estimate'!D134=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D134)","v":3.79},{"$f":"(IF($E$27=\"Heating Only\",($F$10/D65)*($N$12/100),\nIF($E$27=\"Heating and Hot Water\",($F$10/D65)*($N$12/100),0)+(IF($E$27=\"Hot Water Only\",($F$12/$I$25)*($N$12/100),\nIF($E$27=\"Heating and Hot Water\",($F$12/$I$25)*($N$12/100),\nIF(OR($E$27=\"Hybrid - Using current boiler\",$E$27=\"Hybrid - Using new boiler\"),($F$10/D65)*($N$12/100)*($L$27/100)))\n+IF(OR($E$27=\"Hybrid - Using current boiler\",$E$27=\"Hybrid - Using new boiler\",$E$27=\"Heating Only\"),0,(((($E$31*4.19*10)/3)/3600)*3)*($N$12/100)*IF($E$29=\"none\",0,IF($E$29=\"Once per day\",365,IF($E$29=\"Once per week\",52))))))))","v":0},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,41,{"$f":"IF('Performance Estimate'!D135=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D135)","v":3.74},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,42,{"$f":"IF('Performance Estimate'!D136=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D136)","v":3.7},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,43,{"$f":"IF('Performance Estimate'!D137=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D137)","v":3.65},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,44,{"$f":"IF('Performance Estimate'!D138=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D138)","v":3.6},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,45,{"$f":"IF('Performance Estimate'!D139=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D139)","v":3.55},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,46,{"$f":"IF('Performance Estimate'!D140=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D140)","v":3.52},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,47,{"$f":"IF('Performance Estimate'!D141=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D141)","v":3.48},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,48,{"$f":"IF('Performance Estimate'!D142=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D142)","v":3.44},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,49,{"$f":"IF('Performance Estimate'!D143=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D143)","v":3.4},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,50,{"$f":"IF('Performance Estimate'!D144=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D144)","v":3.36},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,51,{"$f":"IF('Performance Estimate'!D145=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D145)","v":3.32},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,52,{"$f":"IF('Performance Estimate'!D146=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D146)","v":3.28},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,53,{"$f":"IF('Performance Estimate'!D147=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D147)","v":3.25},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,54,{"$f":"IF('Performance Estimate'!D148=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D148)","v":3.21},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,55,{"$f":"IF('Performance Estimate'!D149=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D149)","v":3.17},0,{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},0]
[null,null,56,{"$f":"IF('Performance Estimate'!D150=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D150)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$f":"IF(OR(D81=0,ISNA(D81)),NA(),F81+E81)","v":{"$error":"#N/A"}}]
[null,null,57,{"$f":"IF('Performance Estimate'!D151=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D151)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$f":"IF(OR(D82=0,ISNA(D82)),NA(),F82+E82)","v":{"$error":"#N/A"}}]
[null,null,58,{"$f":"IF('Performance Estimate'!D152=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D152)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,59,{"$f":"IF('Performance Estimate'!D153=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D153)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,60,{"$f":"IF('Performance Estimate'!D154=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D154)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,61,{"$f":"IF('Performance Estimate'!D155=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D155)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,62,{"$f":"IF('Performance Estimate'!D156=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D156)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,63,{"$f":"IF('Performance Estimate'!D157=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D157)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,64,{"$f":"IF('Performance Estimate'!D158=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D158)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,65,{"$f":"IF('Performance Estimate'!D159=\"HP Not suitable for this temperature\",0,'Performance Estimate'!D159)","v":0},{"$error":"#DIV/0!"},{"$f":"IF(E27=\"Heating Only\",((F12/E40)*IF(E38=\"Gas\",K10,IF(E38=\"LPG\",(K12/6.6),IF(E38=\"Oil\",(N10/10.27),IF(E38=\"Electric\",N12,IF(E38=\"Immersion\",N12)))))),IF(E27=\"Hot Water Only\",((F10/E40)*IF(E36=\"Gas\",K10,IF(E36=\"LPG\",(K12/6.6),IF(E36=\"Oil\",(N10/10.27),IF(E36=\"Electric\",N12,IF(E36=\"Immersion\",N12)))))),IF(E27=\"Heating and Hot Water\",0)))","v":0},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v1.0"]

{"sheet":"LISTS","index":2,"n_rows":32,"n_cols":31,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Type of System","Renewable System Provides","Old Heating System","MMSP","Immersion use",null,"Existing system fuel","p/kWh","DHW",null,"MMSM Package ","flow temp","Boiler Efficiency",null,"Capital Payback",null,null,null,null,null,"RHI Info Reqd","Existing system age","Building ext.","Shared ground loop",null,"MMSP","RHI Stream",null,"Calorific values",null,"Fuel list"]
["Air Source Heat Pump","Heating and Hot Water","Gas Boiler","Yes","None","Electric (p/kWh)","Electric",{"$f":"'Performance Estimate'!N36/(AD2)","v":0},"Electric","ASHP",115,35,90,null,7,"Years","CPI @",{"$f":"'Performance Estimate'!L91","v":2.3E-2},null,null,"Yes","Pre-1994","Yes","Yes",null,"Yes","Domestic",null,"Electric",1,"Gas (p/kWh)"]
["Ground Source Heat Pump","Heating Only","Oil Boiler","No","Once per day","Gas (p/kWh)","Gas",{"$f":"IF('Performance Estimate'!M33=\"Gas (p/kWh)\",'Performance Estimate'!N33/AD3,0)","v":0},"Gas","GSHP",null,36,89,null,{"$f":"'Performance Estimate'!M85","v":0},1,{"$f":"'Performance Estimate'!M85","v":0},{"$f":"Q3-$O$3","v":0},{"$f":"R3","v":0},null,"No","1994-2007","No","No",null,"No","Non-Domestic",null,"Gas",1,"LPG (p/litre)"]
[null,"Hot Water Only","Solid Fuel Boiler",null,"Once per week","LPG (p/litre)","LPG",{"$f":"IF('Performance Estimate'!M33=\"LPG (p/litre)\",'Performance Estimate'!N33/AD4,0)","v":0},"LPG",null,null,37,88,null,null,2,{"$f":"Q3+(Q3*$R$2)","v":0},{"$f":"Q4-$O$3","v":0},{"$f":"R4+S3","v":0},null,null,"Post-2007",null,null,null,null,null,null,"LPG",6.66,"Oil (p/litre)"]
[null,"Hybrid - Using current boiler","Electric - Storage",null,null,"Oil (p/litre)","Oil",{"$f":"IF('Performance Estimate'!M33=\"Oil (p/litre)\",'Performance Estimate'!N33/AD5,0)","v":0},"Oil",null,null,38,87,null,null,3,{"$f":"Q4+(Q4*$R$2)","v":0},0,{"$f":"R5+S4","v":0},null,null,null,null,null,null,null,null,null,"Oil",9.8000000000000007,"Electricity (p/kWh)"]
[null,"Hybrid - Using new boiler","Electric - Resistance Heaters",null,null,null,"Air Source Heat Pump",{"$f":"H2/AD6","v":0},"Air Source Heat Pump",null,null,39,86,null,null,4,0,0,0,null,null,null,null,null,null,null,null,null,"Air Source Heat Pump",2.5,"Smokeless Fuel (p/kg)"]
[null,null,null,null,null,null,"Ground Source Heat Pump",{"$f":"H2/AD7","v":0},"Ground Source Heat Pump",null,null,40,85,null,null,5,0,0,0,null,null,null,null,null,null,null,null,null,"Ground Source Heat Pump",3,"Coal (p/kg)"]
[null,null,null,null,null,"Smokeless Fuel (p/kg)","Smokeless Fuel",{"$f":"IF('Performance Estimate'!M33=\"Smokeless Fuel (p/kg)\",'Performance Estimate'!N33/LISTS!AD8,0)","v":0},"Smokeless Fuel",null,null,41,84,null,null,6,0,0,0,null,null,null,null,null,null,null,null,null,"Smokeless Fuel",6.7,"Pellets (p/kg)"]
[null,null,null,null,null,"Coal (p/kg)","Coal",{"$f":"IF('Performance Estimate'!M33=\"Coal (p/kg)\",'Performance Estimate'!N33/LISTS!AD9,0)","v":0},"Coal",null,null,42,83,"Total",{"$f":"SUM(Q3:Q9)","v":0},7,0,0,0,null,null,null,null,null,null,null,null,null,"Coal",6.85,"Seasoned Wood (p/kg)"]
[null,null,null,null,null,"Seasoned wood (p/kg)","Seasoned Wood",{"$f":"IF('Performance Estimate'!M33=\"Seasoned Wood (p/kg)\",'Performance Estimate'!N33/LISTS!AD10,0)","v":0},"Seasoned Wood",null,null,43,82,null,null,8,0,0,0,null,null,null,null,null,null,null,null,null,"Seasoned Wood",4.2]
[null,null,null,null,null,"Pellets (p/kg)","Pellets",{"$f":"IF('Performance Estimate'!M33=\"Pellets (p/kg)\",'Performance Estimate'!N33/LISTS!AD11,0)","v":0},"Pellets",null,null,44,81,null,null,9,0,0,0,null,null,null,null,null,null,null,null,null,"Pellets",4.72]
[null,null,null,null,null,null,"Immersion",{"$f":"H2","v":0},"Immersion",null,null,45,80,null,null,10,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,46,79,null,null,11,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,47,78,null,null,12,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,48,77,null,null,13,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,49,76,null,null,14,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,50,75,null,null,15,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,51,74,null,null,16,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,52,73,null,null,17,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,53,72,null,null,18,0,0,{"$f":"R20+S19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,54,71,null,null,19,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,55,70,"Total",{"$f":"SUM(Q3:Q22)","v":0},20,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,56,69]
[null,null,null,null,null,null,null,null,null,null,null,57,68]
[null,null,null,null,null,null,null,null,null,null,null,58,67]
[null,null,null,null,null,null,null,null,null,null,null,59,66]
[null,null,null,null,null,null,null,null,null,null,null,60,65]
[null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,65]

{"sheet":"Version","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[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. "]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}