{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Scope","Performance Estimate","Key Facts","Lists","Version"],"not_rendered":{"charts":1,"images":3,"macros":0,"external_links":0,"defined_names":14,"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":"Scope","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,2,12,6],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[10,2,10,6]]}
[]
[]
[null,null,"Heat Pump System Performance Estimate (HPSPE) - Scope"]
[]
[]
[]
[null,null,"This spreadsheet tool provides a method for calculating the electricity consumption of a heat pump when delivering a given annual heat (and hot water) demand at a given flow temperature. It also compares to any existing heating source."]
[]
[null,null,"MCS is keen to improve the calculator. Please submit feedback to feedback@mcscertified.com "]
[]
[null,null,"Whilst all reasonable care has been taken in the preparation of this document it is provided on an “as is” basis without any guarantee of completeness or accuracy. The MCS Service Company Ltd and The MCS Charitable Foundation (and any related parties) do not accept liability for any errors or omissions in the document nor for the use or application of the information, standards or requirements contained in the document by any third party."]
[]
[null,null,"COPYRIGHT © The MCS Charitable Foundation 2021"]

{"sheet":"Performance Estimate","index":1,"n_rows":137,"n_cols":16,"rows_kept":137,"cut":false,"hidden":false,"merged":[[2,11,13,13],[37,5,37,9],[39,5,39,9],[47,5,47,9],[62,5,62,8],[51,5,51,6],[3,2,4,6],[21,3,22,8],[21,9,22,9],[33,5,33,9],[7,5,7,9],[9,5,9,9],[11,5,11,9],[13,5,13,9],[15,5,15,9],[17,5,17,9],[35,5,35,9],[131,2,135,15],[111,6,123,15],[58,5,58,8],[60,5,60,8],[97,6,97,15],[69,9,69,15],[72,3,72,5],[74,3,74,5],[83,2,83,5],[82,2,82,5],[73,2,73,5],[78,2,78,5],[81,2,81,5],[85,3,87,8],[130,2,130,3]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"**Optional Installer Logo**"]
[null,null,"Heat Pump System Performance Estimate"]
[]
[]
[]
[null,null,null,null,"Installer Project Reference",1234]
[]
[null,null,null,null,"   Client Name","John Doe"]
[]
[null,null,null,null,"Installation Address Line 1","123 High Street"]
[]
[null,null,null,null,"Installation Address Line 2","Old Town"]
[]
[null,null,null,null,"Installation Address Line 3","Home counties"]
[]
[null,null,null,null,"Installation Postcode","AB1 2CD"]
[]
[]
[null,null,null,"Energy Performance Certificate (EPC) Information"]
[null,null,null,"Does this estimate relate to a new build or proposal for extension or reduction in size of an existing building?",null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,{"$f":"IF(J22=\"No\",\"EPC No. for building\",\"Estimate based on draft EPC\")","v":"EPC No. for building"}]
[]
[null,null,null,null,"Energy required to heat property",25000,"  kWh"]
[]
[null,null,null,null,"Energy required for hot water",3000,"  kWh"]
[]
[]
[null,null,null,"New Renewable System Information"]
[]
[null,null,null,null,"Type of System*","Air Source Heat Pump",null,null,null,null,null,"*This calculator is not designed to be used for Solar Assisted Heat Pumps "]
[]
[null,null,null,null,"Manufacturer Name","Manufacturer B"]
[]
[null,null,null,null,"Manufacturer Model","Model ABC"]
[]
[null,null,null,null,"MCS Certification Number*",null,null,null,null,null,null,"*Available from the MCS Product Directory"]
[]
[null,null,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,null,null,"MCS SCOP Heating*",{"$f":"VLOOKUP('Performance Estimate'!F42&\"oC\",D98:E128,2)","v":4.75},null,"* SCoP - Seasonal Coefficient of Performance. This value is based on the MCS HP SCoP Table below"]
[]
[null,null,null,null,"MCS SCOP Hot Water*",{"$f":"IF(F34=\"Ground Source Heat Pump\",2.24,1.75)","v":1.75},null,"* If providing space heating and DHW then default value from SAP2012. If DHW only see methodology in MIS3005"]
[]
[null,null,null,null,"Renewable System Provides","Heating and Hot Water",null,null,null,null,null,80,"Input % of heating requirements covered by heat pump"]
[]
[null,null,null,null,null,null,null,null,null,null,null,93,"Input efficiency (%) of new boiler"]
[]
[null,null,null,null,"Hot Water Immersion Use*","None",null,null,"  * based on 50C up to 60C, 3kW"]
[]
[null,null,null,null,"Size of Hot Water Cylinder",200," ltr",{"$f":"IF(F52=\"none\",0,IF(F52=\"once per week\",52,365))","v":0},{"$f":"(H54*F54*10*4.2)/3600","v":0},"<< This cell calculates the annual electricity consumption of an immersion depending on frequency of use."]
[]
[]
[null,null,null,"Existing Heating System"]
[]
[null,null,null,null,"Existing heating system fuel*","Gas",null,null,null,null,"* If new build model the most likely alternative fuel"]
[]
[null,null,null,null," Hot Water heated by*","Gas",null,null,null,null,"* If new build model the most likely alternative fuel"]
[]
[null,null,null,null,"Age of existing system","1994-2007"]
[]
[null,null,null,null,"Efficiency of existing system",{"$f":"IF(F59=\"Electric\",100,\nIF(F59=\"Smokeless Fuel\",75,\nIF(F59=\"Coal\",75,\nIF(F59=\"Seasoned Wood\",85,\nIF(F59=\"pellets\",90,\nIF(F59=\"Air Source Heat Pump\",250,\nIF(F59=\"Ground Source Heat Pump\",300,\nIF(F63=\"Pre-1994\",82,IF(F63=\"1994-2007\",87,IF(F63=\"Post-2007\",92))))))))))","v":87},"%"]
[]
[]
[]
[null,null,null,"Estimated System Performance / Comparison"]
[]
[null,null,null,"Energy Requirement for the building"]
[null,null,null,null,null,null,"Heating","Hot water","Total"]
[null,null,null,"Net Energy required to heat property",null,null,{"$f":"F27","v":25000},{"$f":"F29","v":3000},{"$f":"SUM(G73:H73)","v":28000},"  kWh"]
[null,null,"Existing System Consumption",null,null,null,{"$f":"(G73*100/F65)","v":28735.632183908045},{"$f":"IF(F61=\"Electric\",H73,(H73*100/(F65*0.9)))","v":3831.4176245210729},{"$f":"SUM(G74:H74)","v":32567.049808429118},"  kWh"]
[]
[null,null,null,"New HP System Estimated Consumption"]
[]
[null,null,null,"Full Heat Pump System (if selected above)"]
[null,null,"HP System Electricity Consumption",null,null,null,{"$f":"IF(OR(F48=\"Hybrid - Using new boiler\",F48=\"Hybrid - Using current boiler\"),0,IF(F48=\"Hot Water only\",\"-\",G73/F44))","v":5263.1578947368425},{"$f":"IF(OR(F48=\"Hybrid - Using new boiler\",F48=\"Hybrid - Using current boiler\"),0,IF(F48=\"Heating only\",\"-\",(H73/F46)+I54))","v":1714.2857142857142},{"$f":"IF(F48=\"Heating only\",SUM(G79,H74),\nIF(F48=\"Hot Water only\",SUM(G74,H79),\nSUM(G79,H79)))","v":6977.4436090225572},"  kWh"]
[]
[null,null,null,"Hybrid System (if selected above)"]
[null,null,"HP System Electricity Consumption",null,null,null,{"$f":"IF(OR(F$48=\"Hybrid - Using current boiler\",F$48=\"Hybrid - Using new boiler\"),((G73)/F$44)*(L$48/100),0)","v":0},{"$f":"IF(OR(F$48=\"Hybrid - Using current boiler\",F$48=\"Hybrid - Using new boiler\"),((H73)/F$46)*(L$48/100)+I54,0)","v":0},{"$f":"SUM(G82:H82)","v":0},"  kWh"]
[null,null,"Hybrid system other consumption",null,null,null,{"$f":"IF(F$48=\"Hybrid - Using current boiler\",(G73*(1-(L48/100))*100/F65),\nIF(F$48=\"Hybrid - Using new boiler\",(G73*(1-(L48/100))*100/L50),\n0))","v":0},{"$f":"IF(F$48=\"Hybrid - Using current boiler\",(H73*(1-(L48/100))*100/(F65*0.9)),\nIF(F$48=\"Hybrid - Using new boiler\",(H73*(1-(L48/100))*100/L50),\n0))","v":0},{"$f":"SUM(G83:H83)","v":0},"  kWh"]
[null,null,"Hybrid Total Consumption",null,null,null,null,null,{"$f":"SUM(I82:I83)","v":0},"  kWh"]
[]
[null,null,null,"Note: There are different types of hybrid system. This calculation presumes a hybrid where both sources of heat supply the same hydraulic circuits (heating and hot water) according to the proportion selected above."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Flow temperature","SCOP"]
[null,null,null,"35°C",5.2]
[null,null,null,"36°C",5.1100000000000003]
[null,null,null,"37°C",5.0199999999999996]
[null,null,null,"38°C",4.93]
[null,null,null,"39°C",4.84]
[null,null,null,"40°C",4.75]
[null,null,null,"41°C",4.66]
[null,null,null,"42°C",4.57]
[null,null,null,"43°C",4.4800000000000004]
[null,null,null,"44°C",4.38]
[null,null,null,"45°C",4.29]
[null,null,null,"46°C",4.21]
[null,null,null,"47°C",4.13]
[null,null,null,"48°C",4.05,null,"SCoP Definition"]
[null,null,null,"49°C",3.97,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,null,"50°C",3.88]
[null,null,null,"51°C",3.8]
[null,null,null,"52°C",3.72]
[null,null,null,"53°C",3.64]
[null,null,null,"54°C",3.55]
[null,null,null,"55°C",3.47]
[null,null,null,"56°C",0]
[null,null,null,"57°C",0]
[null,null,null,"58°C",0]
[null,null,null,"59°C",0]
[null,null,null,"60°C",0]
[null,null,null,"61°C",0]
[null,null,null,"62°C",0]
[null,null,null,"63°C",0]
[null,null,null,"64°C",0]
[null,null,null,"65°C",0]
[]
[]
[null,null,"Important Information:\n"]
[null,null,"This performance estimate should be accomanied by the Key Facts which explain the factors that can affect the performance of a heat pump.\n\nAny 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.     "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MCS 031 - v3.0"]

{"sheet":"Key Facts","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,1],[48,2,52,6],[40,2,46,6],[40,0,40,1],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[29,0,29,4],[30,0,30,4],[31,0,31,4],[38,0,38,6],[32,0,32,4],[33,0,33,4],[34,0,34,4],[34,5,34,6],[27,0,27,6],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[28,0,28,4],[3,0,3,6],[5,0,5,6],[7,0,7,6],[8,0,8,6],[22,0,22,6],[20,5,20,6],[21,5,21,6],[10,0,10,6],[11,0,11,6],[4,0,4,6],[18,0,18,4],[18,5,18,6],[20,0,20,4],[21,0,21,4],[19,0,19,6]]}
[]
["Key facts"]
[]
["Predicting the heat demand of a building, and therefore the performance and running costs of heating systems, is difficult to predict with certainty due to the variables discussed here. These variables apply to all types of heating systems, although the efficiency of heat pumps is more sensitive to good system design and installation. For these reasons your estimate is given as guidance only and should not be considered as a guarantee."]
["Seasonal Coefficient of Performance:"]
["MCS Seasonal Coefficient of Performance (SCoP) is derived from the EU ErP labelling requirements, and is a theoretical indication of the anticipated efficiency of a heat pump over a whole year using standard (i.e. not local) climate data for 3 locations in Europe. It is used to compare the relative performance of heat pumps under fixed conditions and indicates the units of total heat energy generated (output) for each unit of electricity consumed (input). As a guide, a heat pump with a MCS SCoP of 3 indicates that 3 kWh of heat energy would be generated for every 1 kWh of electrical energy it consumes over a ‘standard’ annual cycle."]
[]
["Energy Performance Certificate"]
["An Energy Performance Certificate (EPC) is produced in accordance with a methodology approved by the government. As with all such calculations, it relies on the accuracy of the information input. Some of this information, such as the insulating and air tightness properties of the building may have to be assumed and this can affect the final figures significantly leading to uncertainty especially with irregular or unusual buildings."]
[]
["Identifying the uncertainties of energy predictions for heating systems"]
["We have identified 3 key types of factor that can affect how much energy a heating system will consume and how much energy it will deliver into a home. These are ‘Fixed’, ‘Variable’ and ‘Random’. Most factors are common to ALL heating systems regardless of the type (e.g oil, gas, solid fuel, heat pump etc.) although the degree of effect varies between different types of heating system as given in the following table.\n\nThe combined effect of these factors on energy consumption and the running costs makes overall predictions difficult however an accuracy  + 25-30% would not be unreasonable in many instances. Under some conditions even this could be exceeded (e.g. considerable opening of windows). Therefore it is advised that when making choices based on mainly financial criteria (e.g. payback based on capital cost verses net benefits such as fuel savings and financial incentives) this variability is taken into account as it could extend paybacks well beyond the period of any incentives received, intended occupancy period, finance agreement period etc."]
[]
[]
[]
[]
[]
[]
["Factor",null,null,null,null,"Impact"]
["'Fixed' which include:"]
["Equipment Selection Performance figures (SCoP) from ErP data",null,null,null,null,"System Efficiency"]
["Energy Assessment via the EPC (e.g. assumptions as to fabric construction and levels of insulation; the variation in knowledge and experience of Energy Assessors)",null,null,null,null,"Energy Required"]
["'Variable' which are affected by the system design and include:"]
["Accuracy of sizing of heat pump- i.e.  closeness of unit output selection (kW) to demand heat requirement (kW)",null,null,null,null,"System Efficiency"]
["Design space and ambient (external) temperatures",null,null,null,null,"Energy Required"]
["Design flow /return water temperatures, and weather compensation",null,null,null,null,"System Efficiency"]
["Type of Heat emitter (e.g. Under-floor; natural convector (e.g. ‘radiator’), fan convector etc.)",null,null,null,null,"System Efficiency"]
["'Random' which cannot be anticipated and include:"]
["User behaviour:"]
["•\tRoom temperature settings",null,null,null,null,"Energy Required"]
["•\tHot water usage and temperature settings",null,null,null,null,"Energy Required"]
["•\tOccupancy patterns/times",null,null,null,null,"Energy Required"]
["•\tChanging the design HP flow temperatures",null,null,null,null,"System Efficiency"]
["•\tVentilation (i.e. opening windows)",null,null,null,null,"Energy Required"]
["Annual climatic variations (i.e. warmer and colder years than average)",null,null,null,null,"Energy Required"]
[]
["Key:"]
[]
["The statement at the end of each item indicates the major factor affected as follows:"]
[]
["Energy Required:",null,"the heat energy output requirement of the system which directly impacts on running costs. This requirement exists regardless of the heating system chosen as it is the heat required to keep the space comfortable. Opening windows or increasing room temperatures will demand more heat output, which means more energy input but this would NOT directly affect the efficiency. Thus increased energy demand does NOT automatically mean reduced efficiency."]
[]
[]
[]
[]
[]
[]
[]
["System Efficiency:",null,"the efficiency of the system has been directly affected and will therefore demand more input energy to achieve the same heat output thus increasing running costs. However, increased energy input does NOT necessarily mean lower system efficiency (see above)."]

{"sheet":"Lists","index":3,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Type of System","Renewable System Provides","Old Heating System","Immersion use","Existing system fuel","flow temp","SCOP","SH","HW",null,"Boiler Efficiency",null,null,"Existing system age","Building ext."]
["Air Source Heat Pump","Heating and Hot Water","Gas Boiler","None","Electric",35,{"$f":"'Performance Estimate'!E98","v":5.2},{"$f":"'Performance Estimate'!F$27/Lists!G2","v":4807.6923076923076},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$f":"H2+I2","v":6521.9780219780223},90,null,null,"Pre-1994","Yes"]
["Ground Source Heat Pump","Heating Only","Oil Boiler","Once per day","Gas",36,{"$f":"'Performance Estimate'!E99","v":5.1100000000000003},{"$f":"'Performance Estimate'!F$27/Lists!G3","v":4892.3679060665363},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$f":"H3+I3","v":6606.6536203522501},89,null,null,"1994-2007","No"]
[null,"Hot Water Only","Solid Fuel Boiler","Once per week","LPG",37,{"$f":"'Performance Estimate'!E100","v":5.0199999999999996},{"$f":"'Performance Estimate'!F$27/Lists!G4","v":4980.0796812749004},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},6694.3653955606151,88,null,null,"Post-2007"]
[null,"Hybrid - Using current boiler","Electric - Storage",null,"Oil",38,{"$f":"'Performance Estimate'!E101","v":4.93},{"$f":"'Performance Estimate'!F$27/Lists!G5","v":5070.9939148073026},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},6785.2796290930164,87]
[null,"Hybrid - Using new boiler","Electric - Resistance Heaters",null,"Air Source Heat Pump",39,{"$f":"'Performance Estimate'!E102","v":4.84},{"$f":"'Performance Estimate'!F$27/Lists!G6","v":5165.2892561983472},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},6879.5749704840619,86]
[null,null,null,null,"Ground Source Heat Pump",40,{"$f":"'Performance Estimate'!E103","v":4.75},{"$f":"'Performance Estimate'!F$27/Lists!G7","v":5263.1578947368425},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},6977.4436090225572,85]
[null,null,null,null,"Smokeless Fuel",41,{"$f":"'Performance Estimate'!E104","v":4.66},{"$f":"'Performance Estimate'!F$27/Lists!G8","v":5364.8068669527893},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7079.092581238503,84]
[null,null,null,null,"Coal",42,{"$f":"'Performance Estimate'!E105","v":4.57},{"$f":"'Performance Estimate'!F$27/Lists!G9","v":5470.4595185995622},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7184.745232885276,83]
[null,null,null,null,"Seasoned Wood",43,{"$f":"'Performance Estimate'!E106","v":4.4800000000000004},{"$f":"'Performance Estimate'!F$27/Lists!G10","v":5580.3571428571422},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7294.6428571428569,82]
[null,null,null,null,"Pellets",44,{"$f":"'Performance Estimate'!E107","v":4.38},{"$f":"'Performance Estimate'!F$27/Lists!G11","v":5707.7625570776254},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7422.0482713633392,81]
[null,null,null,null,"Immersion",45,{"$f":"'Performance Estimate'!E108","v":4.29},{"$f":"'Performance Estimate'!F$27/Lists!G12","v":5827.5058275058273},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7541.791541791541,80]
[null,null,null,null,null,46,{"$f":"'Performance Estimate'!E109","v":4.21},{"$f":"'Performance Estimate'!F$27/Lists!G13","v":5938.242280285036},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7652.5279945707498,79]
[null,null,null,null,null,47,{"$f":"'Performance Estimate'!E110","v":4.13},{"$f":"'Performance Estimate'!F$27/Lists!G14","v":6053.2687651331717},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7767.5544794188863,78]
[null,null,null,null,null,48,{"$f":"'Performance Estimate'!E111","v":4.05},{"$f":"'Performance Estimate'!F$27/Lists!G15","v":6172.8395061728397},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},7887.1252204585544,77]
[null,null,null,null,null,49,{"$f":"'Performance Estimate'!E112","v":3.97},{"$f":"'Performance Estimate'!F$27/Lists!G16","v":6297.2292191435763},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8011.514933429291,76]
[null,null,null,null,null,50,{"$f":"'Performance Estimate'!E113","v":3.88},{"$f":"'Performance Estimate'!F$27/Lists!G17","v":6443.2989690721652},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8157.5846833578798,75]
[null,null,null,null,null,51,{"$f":"'Performance Estimate'!E114","v":3.8},{"$f":"'Performance Estimate'!F$27/Lists!G18","v":6578.9473684210525},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8293.2330827067672,74]
[null,null,null,null,null,52,{"$f":"'Performance Estimate'!E115","v":3.72},{"$f":"'Performance Estimate'!F$27/Lists!G19","v":6720.4301075268813},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8434.7158218125951,73]
[null,null,null,null,null,53,{"$f":"'Performance Estimate'!E116","v":3.64},{"$f":"'Performance Estimate'!F$27/Lists!G20","v":6868.131868131868},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8582.4175824175818,72]
[null,null,null,null,null,54,{"$f":"'Performance Estimate'!E117","v":3.55},{"$f":"'Performance Estimate'!F$27/Lists!G21","v":7042.2535211267605},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8756.5392354124742,71]
[null,null,null,null,null,55,{"$f":"'Performance Estimate'!E118","v":3.47},{"$f":"'Performance Estimate'!F$27/Lists!G22","v":7204.6109510086453},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},8918.89666529436,70]
[null,null,null,null,null,56,{"$f":"'Performance Estimate'!E119","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G23","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"},69]
[null,null,null,null,null,57,{"$f":"'Performance Estimate'!E120","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G24","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"},68]
[null,null,null,null,null,58,{"$f":"'Performance Estimate'!E121","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G25","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"},67]
[null,null,null,null,null,59,{"$f":"'Performance Estimate'!E122","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G26","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"},66]
[null,null,null,null,null,60,{"$f":"'Performance Estimate'!E123","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G27","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"},65]
[null,null,null,null,null,61,{"$f":"'Performance Estimate'!E124","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G28","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"}]
[null,null,null,null,null,62,{"$f":"'Performance Estimate'!E125","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G29","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"}]
[null,null,null,null,null,63,{"$f":"'Performance Estimate'!E126","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G30","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"}]
[null,null,null,null,null,64,{"$f":"'Performance Estimate'!E127","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G31","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"}]
[null,null,null,null,null,65,{"$f":"'Performance Estimate'!E128","v":0},{"$f":"'Performance Estimate'!F$27/Lists!G32","v":{"$error":"#DIV/0!"}},{"$f":"('Performance Estimate'!F$29)/'Performance Estimate'!F$46","v":1714.2857142857142},{"$error":"#DIV/0!"}]

{"sheet":"Version","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"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. "]
[null,"2022-02-16",3,"Removed financial data and improved presentation plus calculation of Hybrids."]