{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Manufacturers's Declaration","REF_DATA(V1.0)","Reference Test Data"," Installation Package ","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Manufacturers's Declaration","index":0,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[[45,1,45,5],[46,1,48,1],[46,2,46,3],[7,1,7,10],[19,1,19,10],[26,1,29,1],[16,7,16,8],[16,9,16,10],[16,2,16,5],[17,2,17,5],[14,6,14,10],[15,6,15,10],[10,2,10,5],[15,2,15,5],[8,6,8,10],[9,6,9,10],[10,6,10,10],[11,6,11,10],[13,6,13,10],[82,3,82,10],[72,1,76,1],[76,6,76,7],[80,1,80,2],[81,1,81,2],[80,8,80,10],[81,8,81,10],[80,3,80,6],[81,3,81,6],[74,6,74,7],[75,6,75,7],[72,2,76,5],[71,1,71,10],[8,2,8,5],[9,2,9,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[72,6,73,7],[55,2,57,5],[55,6,56,8],[57,6,57,8],[60,2,62,5],[60,1,69,1],[51,1,57,1],[54,2,54,8],[60,6,60,7],[51,2,52,8],[53,2,53,8],[12,6,12,10],[14,2,14,5],[31,1,31,10],[41,1,41,5],[42,1,44,1],[42,2,42,3],[32,5,32,7],[32,8,33,10],[32,1,39,1],[20,2,23,3],[20,1,23,1],[25,1,25,10],[26,2,29,5]]}
[]
[null,"Micro-Cogeneration Add-on Calculator ",null,null,null,null,null,null,"Version:","v 1.0"]
[]
[null,null,"Please fill out the blanks in all tables"]
[]
[]
[]
[null,"TABLE MD1: General description of the Add-on MCU",null,null,null,null,null,null,null,null,null,null,"User input data is in blue "]
[null,1,"Manufacturer's name",null,null,null,null,null,null,null,null,null,"Dark Red figures are taken from another cell/sheet"]
[null,2,"Brand name",null,null,null,null,null,null,null,null,null,"Red figures are calculated"]
[null,3,"Package name"]
[null,4,"Unique package identifiers"]
[null,5,"Prime mover: Software/Control package version"]
[null,6,"System Integration Package: Software/Control package version"]
[null,7,"Description of micro-cogeneration package"]
[null,8,"Prime mover type"]
[null,9,"Test fuel - Select from list",null,null,null,"1  Mains Gas","If special then specify : -"]
[null,10,"Condensing or Non-Condensing - Select from list",null,null,null,"Condensing"]
[]
[null,"TABLE MD2: Operating and test regimes"]
[null,11,"Select generic type, application and operating mode",null,"Generic type","Test mode","Target building","Operation","Space heating","Standby","DHW"]
[null,null,null,null,null,null,"Types","Mode","Test regime","Mode","Only"]
[null,null,null,null,"[Select]","[Select]","[Select]","[Select]"]
[null,null,null,null,"RegPK","With Ref boiler","Single family","1  Continuous",{"$f":"+'REF_DATA(V1.0)'!U41","v":1},"Yes",{"$f":"+IF($E$24=\"HeatPK\",\"N/A\",5)","v":5}]
[]
[null,"TABLE MD3: Electrical specification"]
[null,12,"Electrical specification",null,null,null,"Maximum","Voltage","Frequency","AC/DC","Electrical test"]
[null,null,null,null,null,null,"Electrical Output",null,null,null,"Mode"]
[null,null,null,null,null,null,"[kVA]","[V]","[Hz]",null,"[Select]"]
[null,null,null,null,null,null,null,null,null,null,1]
[]
[null,"TABLE MD4: Add-on MCU Manufacturer's declared performance data"]
[null,13,null,null,null,"Return temperature, TR",null,null,"Standby mode inputs and outputs"]
[null,null,null,null,null,"60oC","45oC","30oC"]
[null,null,"Fuel energy consumption rate",null,"[kW]",null,null,null,"Power input","[We]"]
[null,null,"Thermal power output",null,"[kWt]",null,null,null,"Fuel energy input","[W]",null,null,"About Table MD4: These declared results are not necessary, but can be used by the test house to make sense of their own results."]
[null,null,"Electrical power output",null,"[kWe]",null,null,null,"Power output","[We]"]
[null,null,"Gross electrical efficiency",null,"[%]",null,null,null,"Heat output","[Wt]"]
[null,null,"Gross thermal efficiency",null,"[%]"]
[null,null,"Gross overall efficiency",null,"[%]"]
[]
[null,"TABLE MD5A: Specification of the reference secondary (boiler) to be tested",null,null,null,null,"not required in the case of DHWPK"]
[null,null,"Heat Output power [kW]"]
[null,null,"Maximum","Minimum (if any)"]
[]
[null,"TABLE MD5B: Specification of the primary",null,null,null,null,"not required in the case of DHWPK"]
[null,null,"SH output power [kW] (80/60°C)"]
[null,null,"Maximum","Minimum"]
[]
[]
[null,"TABLE MD6: Space heating parameters",null,null,null,null,"not required in the case of DHWPK"]
[null,15,"Declared space heating full load (100% load factor)",null,null,null,null,null,null,"[kWT]",null,"(100% heat load could be the sum of the two heating system outputs or just the heat output of the largest heating system)"]
[null,null,null,null,null,null,null,null,null,"[kWh/24h]",{"$f":"+K52*24","v":0}]
[null,null,"Central heating return temperature at full load i.e. 100% load factor",null,null,null,null,null,null,"[oC]"]
[null,null,"Central heating flow temperature at full load i.e. 100% load factor",null,null,null,null,null,null,"[oC]"]
[null,null,"Optional space heating partial load supplementary tests",null,null,null,"From 90% to 40% (regime, % load)",null,null,"Continuous","enter","don't write a percentage sign (50,60,70,80,90% tests are impossible in a bimodal regime)"]
[null,null,null,null,null,null,null,null,null,"Continuous","enter","no percentage sign (70,80,90% tests are impossible for uni-modal regime)"]
[null,null,null,null,null,null,"20% part load (regime, % load)",null,null,"Continuous","enter","no percentage sign"]
[]
[null,"TABLE MD7: HW heating performance testing parameters",null,null,null,null,"not required in the case of HEAT-PK"]
[null,16,"DHW supply pressure requirements and flow rate for individual hot water tapping No.#  and hot water vessel capacity (See PAS67: 2013 for details)",null,null,null,"Pressure [bar]",null,"External HW Vessel","HW vessel","HW vessel"]
[null,null,null,null,null,null,"Maximum","Minimum","Select","Min Capacity (L)","Max Capacity (L)"]
[null,null,null,null,null,null,null,null,"No"]
[null,null,"Select hot water tapping cycles ",null,"HW heating","Tapping","HW energy content",null,"HW Volume","TC Flow rate","Test flow rate"]
[null,null,null,null,"Test No","Cycle",null,null,"at 60oC","Range","0 = From table"]
[null,null,null,null,null,"[Select]","[MJ/day]","[kWh/day]","[L]","[L/min]","> 0: Value"]
[null,null,null,null,1,"2 - M",{"$f":"+'REF_DATA(V1.0)'!C69","v":21.042000000000002},{"$f":"+'REF_DATA(V1.0)'!D69","v":5.8450000000000006},{"$f":"+'REF_DATA(V1.0)'!E69","v":100},{"$f":"+'REF_DATA(V1.0)'!F69","v":"3 - 6"},0]
[null,null,null,null,2,"3 - L",{"$f":"+'REF_DATA(V1.0)'!H69","v":41.957999999999998},{"$f":"+'REF_DATA(V1.0)'!I69","v":11.654999999999999},{"$f":"+'REF_DATA(V1.0)'!J69","v":200},{"$f":"+'REF_DATA(V1.0)'!K69","v":"3 - 10"},0]
[null,null,null,null,3,"4 - XL",{"$f":"+'REF_DATA(V1.0)'!M69","v":68.652000000000001},{"$f":"+'REF_DATA(V1.0)'!N69","v":19.07},{"$f":"+'REF_DATA(V1.0)'!O69","v":327},{"$f":"+'REF_DATA(V1.0)'!P69","v":"3 - 10"},0]
[null,null,null,null,"8 - Special","Specify the values"]
[]
[null,"TABLE MD8: Circulator in the Add-on MCU"]
[null,17,"Presence of circulators in the test package",null,null,null,null,null,"Present","Disconnected","Nominal rating"]
[null,null,null,null,null,null,null,null,"[Yes or No]","for test (Y or N)","[W]"]
[null,null,null,null,null,null,"Prime mover circuit",null,"Yes","No"]
[null,null,null,null,null,null,"Hydraulics (Heating system)",null,"Yes","No"]
[null,null,null,null,null,null,"Reference boiler circuit",null,"Yes","No"]
[]
[null,"Comments: Declaration is the same as in the latest version of the PAS67."]
[]
[null,"Signed",null,null,null,null,null,"Date"]
[null,"Name",null,null,null,null,null,"Position"]
[null,"Name of manufacturer"]

{"sheet":"REF_DATA(V1.0)","index":1,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[[57,12,57,13],[14,1,15,2],[33,2,33,3],[33,4,33,5],[57,2,57,3],[57,7,57,8]]}
[null,"Micro-Cogeneration Add-on Calculator ",null,null,null,null,null,null,"Version:","v 1.0"]
[]
[null,"Please only change data to match new current SAP values."]
[]
[]
[]
[null,"Table R1: Electrical test mode"]
[]
[null,"Synchronous",1]
[null,"Island Mode",2]
[]
[null,"Result",{"$f":"+'Manufacturers''s Declaration'!K30","v":1}]
[]
[null,"Table R2: Fuel types and properties"]
[null,"Fuel type",null,"Emissions","Unit price","Standing charge","Primary ",null,"Current values are from the SAP2012."]
[null,null,null,"[kgCO2/KWh]","[p/kWh]","[£/y]","Energy factor",null,"These values need updating with those values from the latest version of the SAP."]
[null,"1  Mains Gas",null,0.216,3.48,120,1.22]
[null,"2  LPG",null,0.24099999999999999,10.3,0,1.0900000000000001]
[null,"3  Heating oil",null,0.29799999999999999,5.44,0,1.1000000000000001]
[null,"4  Special"]
[null,"5  Import electricity",null,0.51900000000000002,13.19,54,3.07]
[null,"6  Export electricity",null,0.51900000000000002,13.19,0,3.07]
[null,{"$f":"+'Manufacturers''s Declaration'!G17","v":"1  Mains Gas"},null,{"$f":"+LOOKUP($B23,$B17:$B20,D17:D20)","v":0.216},{"$f":"+LOOKUP($B23,$B17:$B20,E17:E20)","v":3.48},{"$f":"+LOOKUP($B23,$B17:$B20,F17:F20)","v":120},{"$f":"+LOOKUP($B23,$B17:$B20,G17:G20)","v":1.22}]
[]
[null,"Table R3: Appliance type"]
[]
[null,"Condensing"]
[null,"Non-Condensing"]
[]
[null,{"$f":"+'Manufacturers''s Declaration'!G18","v":"Condensing"}]
[]
[null,"Table R4:  Category, Application and operating regimes"]
[null,null,null,null,null,null,null,null,null,null,"Load factor (%)",null,null,null,null,null,null,null,null,null,"Test"]
[null,"Category","Test mode",null,"Target building types",null,"Operation mode","On hours","Add-on MCU On times",null,100,90,80,70,60,50,40,30,20,10,"Regime"]
[null,"RegPK","With Ref boiler",null,"Single family",null,"1  Continuous",24,"24h",null,"Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous",1]
[null,"HeatPK",null,null,"Apartment blocks",null,"2  Uni-modal",16,"07:00 - 23:00",null,"Continuous","N/A","N/A","N/A","Uni-modal","Uni-modal","Uni-modal","Uni-modal","Uni-modal","Uni-modal",2]
[null,"CombiPK",null,null,"Commercial ",null,"3  Bi-modal",11,"06:00 - 09:00 & 15:00 - 2300",null,"Continuous","N/A","N/A","N/A","N/A","N/A","Bi-modal","Bi-modal","Bi-modal","Bi-modal",3]
[null,"DHWPK",null,null,null,null,"4  Uni + Bi-modal",null,"07:00 - 23:00 & 06:00 - 09:00 & 15:00 - 2300",null,"Continuous","Continuous","Continuous","Continuous","Uni-modal","Uni-modal","N/A","Uni-modal","N/A","Bi-modal",4]
[]
[null,{"$f":"+'Manufacturers''s Declaration'!E24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!F24","v":"With Ref boiler"},null,{"$f":"+'Manufacturers''s Declaration'!G24","v":"Single family"},null,{"$f":"+'Manufacturers''s Declaration'!H24","v":"1  Continuous"},null,{"$f":"+LOOKUP(G40,G35:G38,I35:I38)","v":"24h"},null,{"$f":"+LOOKUP($G40,$G35:$G38,K35:K38)","v":"Continuous"},{"$f":"+LOOKUP($G40,$G35:$G38,L35:L38)","v":"Continuous"},{"$f":"+LOOKUP($G40,$G35:$G38,M35:M38)","v":"Continuous"},"Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous",{"$f":"+LOOKUP($G40,$G35:$G38,U35:U38)","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"+IF($B$40=\"DHWPK\",\"N/A\",I40)","v":"24h"},null,{"$f":"+IF($B$40=\"DHWPK\",\"N/A\",K40)","v":"Continuous"},"Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous","Continuous",1]
[]
[]
[null,null,null,null,null,null,null,null,"Hours","on",{"$f":"+IF(K40=\"Continuous\",24,IF(K40=\"Uni-modal\",16,IF(K40=\"Bi-modal\",11,0)))","v":24},{"$f":"+IF(L40=\"Continuous\",24,IF(L40=\"Uni-modal\",16,IF(L40=\"Bi-modal\",11,0)))","v":24},{"$f":"+IF(M41=\"Continuous\",24,IF(M41=\"Uni-modal\",16,IF(M41=\"Bi-modal\",11,0)))","v":24},{"$f":"+IF(N41=\"Continuous\",24,IF(N41=\"Uni-modal\",16,IF(N41=\"Bi-modal\",11,0)))","v":24},24,24,24,24,24,24]
[]
[]
[null,"Table R4A:     Load factor and Heating on period"]
[null,"Load factor","[%]",0,10,{"$f":"+E48+10","v":20},{"$f":"+F48+10","v":30},40,50,60,70,80,90,100]
[null,"Heating on period","[h]",0,{"$f":"+T44","v":24},{"$f":"+S44","v":24},{"$f":"+R44","v":24},{"$f":"+Q44","v":24},{"$f":"+P44","v":24},{"$f":"+O44","v":24},{"$f":"+N44","v":24},{"$f":"+M44","v":24},{"$f":"+L44","v":24},{"$f":"+K44","v":24}]
[null,null,null,"*special case"]
[null,null,null,"inserted for calculations"]
[null,"Table R5"]
[null,"Yes"]
[null,"No"]
[]
[]
[null,"Table R6: Hot water tapping cycle data"]
[null,"Tapping","HW energy content",null,"HW Volume","Flow rates","Tapping","HW energy content",null,"HW Volume","Flow rates","Tapping","HW energy content",null,"HW Volume","Flow rates"]
[null,"Cycle No","[MJ/24h]","[kWh/24h]","at 60oC [L]","[L/min]","Cycle No","[MJ/day]","[kWh/day]","at 60oC [L]","[L/min]","Cycle No","[kWh]","[MJ]","at 60oC [L]","[L/min]"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"1 - S",7.56,{"$f":"+C61/3.6","v":2.0999999999999996},36,"3 - 6","1 - S",7.56,{"$f":"+H61/3.6","v":2.0999999999999996},36,"3 - 6","1 - S",7.56,{"$f":"+M61/3.6","v":2.0999999999999996},36,"3 - 6",null,"This tapping cycle data needs to be kept up to date in line with any changes."]
[null,"2 - M",21.042000000000002,{"$f":"+C62/3.6","v":5.8450000000000006},100,"3 - 6","2 - M",21.042000000000002,{"$f":"+H62/3.6","v":5.8450000000000006},100,"3 - 6","2 - M",21.042000000000002,{"$f":"+M62/3.6","v":5.8450000000000006},100,"3 - 6"]
[null,"3 - L",41.957999999999998,11.654999999999999,200,"3 - 10","3 - L",41.957999999999998,11.654999999999999,200,"3 - 10","3 - L",41.957999999999998,11.654999999999999,200,"3 - 10"]
[null,"4 - XL",68.652000000000001,19.07,327,"3 - 10","4 - XL",68.652000000000001,19.07,327,"3 - 10","4 - XL",68.652000000000001,19.07,327,"3 - 10"]
[null,"5 - XXL",{"$f":"+D65*3.6","v":88.38000000000001},24.55,420,"3 - 16","5 - XXL",{"$f":"+I65*3.6","v":88.38000000000001},24.55,420,"3 - 16","5 - XXL",{"$f":"+N65*3.6","v":88.38000000000001},24.55,420,"3 - 16"]
[null,"6 - 3XL",{"$f":"+D66*3.6","v":161.136},44.76,766,"24 - 48","6 - 3XL",{"$f":"+I66*3.6","v":161.136},44.76,766,"24 - 48","6 - 3XL",{"$f":"+N66*3.6","v":161.136},44.76,766,"24 - 48"]
[null,"7 - 4XL",336.67199999999997,93.52,1600,"48 - 96","7 - 4XL",336.67199999999997,93.52,1600,"48 - 96","7 - 4XL",336.67199999999997,93.52,1600,"48 - 96"]
[null,"8 - Special",{"$f":"+'Manufacturers''s Declaration'!G70","v":0},{"$f":"+C68*3.6","v":0},{"$f":"+E67*C67/C68","v":{"$error":"#DIV/0!"}},{"$f":"+'Manufacturers''s Declaration'!K70","v":0},"8 - Special",{"$f":"+C68","v":0},{"$f":"+D68","v":0},{"$error":"#DIV/0!"},0,"8 - Special",{"$f":"+C68","v":0},{"$f":"+D68","v":0},{"$error":"#DIV/0!"},0]
[null,{"$f":"+'Manufacturers''s Declaration'!F67","v":"2 - M"},{"$f":"+LOOKUP($B69,$B60:$B68,C60:C68)","v":21.042000000000002},{"$f":"+LOOKUP($B69,$B60:$B68,D60:D68)","v":5.8450000000000006},100,"3 - 6",{"$f":"+'Manufacturers''s Declaration'!F68","v":"3 - L"},{"$f":"+LOOKUP($G69,$G60:$G68,H60:H68)","v":41.957999999999998},{"$f":"+LOOKUP($G69,$G60:$G68,I60:I68)","v":11.654999999999999},200,"3 - 10",{"$f":"+'Manufacturers''s Declaration'!F69","v":"4 - XL"},{"$f":"+LOOKUP($L69,$L60:$L68,M60:M68)","v":68.652000000000001},{"$f":"+LOOKUP($L69,$L60:$L68,N60:N68)","v":19.07},327,"3 - 10"]

{"sheet":"Reference Test Data","index":2,"n_rows":123,"n_cols":40,"rows_kept":123,"cut":false,"hidden":false,"merged":[[53,24,53,25],[53,26,53,27],[53,29,53,31],[78,7,78,9],[78,11,78,13],[75,7,75,8],[78,14,78,15],[78,16,78,18],[78,20,78,21],[78,22,78,23],[68,29,68,31],[68,24,68,25],[68,26,68,27],[78,26,78,27],[78,29,78,31],[78,24,78,25],[53,35,53,36],[53,37,53,39],[78,35,78,36],[78,37,78,39],[78,32,78,34],[53,32,53,34],[68,32,68,34],[68,35,68,36],[68,37,68,39],[108,4,108,5],[16,8,16,9],[68,7,68,9],[27,4,27,6],[27,7,28,9],[87,7,87,8],[50,7,50,8],[52,1,52,6],[39,1,41,3],[40,5,40,7],[39,5,39,9],[44,1,44,3],[45,1,45,3],[46,1,47,3],[67,1,67,6],[9,1,9,3],[16,5,16,7],[16,1,17,2],[14,6,14,7],[65,7,65,8],[53,7,53,9],[25,6,25,7],[17,5,17,6],[90,16,90,18],[10,1,10,3],[11,1,11,3],[52,12,52,13],[53,11,53,13],[53,14,53,15],[53,16,53,18],[37,12,37,13],[77,11,77,12],[90,8,90,9],[16,10,16,11],[40,10,40,12],[39,10,39,14],[16,12,16,13],[67,12,67,13],[68,22,68,23],[53,20,53,21],[53,22,53,23],[68,11,68,13],[68,14,68,15],[68,16,68,18],[68,20,68,21]]}
[]
[null,{"$f":"+'Manufacturers''s Declaration'!B2","v":"Micro-Cogeneration Add-on Calculator "},null,null,"Version: ",{"$f":"+'Manufacturers''s Declaration'!J2","v":"v 1.0"},null,"Add-on MCU PERFORMANCE DATA WITH  REFERENCE BOILER"]
[]
[]
[]
[null,"TABLE RT_01:    FUEL PARAMETERS"]
[]
[null,null,null,null,"Fuel","Emissions","Price","Standing charge","Primary "]
[null,null,null,null,null,"[kgCO2/kWh]","[p/kWh]","[£/y]","Energy factor"]
[null,"Add-on MCU and reference test boiler",null,null,{"$f":"+'Manufacturers''s Declaration'!G17","v":"1  Mains Gas"},{"$f":"+'REF_DATA(V1.0)'!D23","v":0.216},{"$f":"+'REF_DATA(V1.0)'!E23","v":3.48},{"$f":"+'REF_DATA(V1.0)'!F23","v":120},{"$f":"+'REF_DATA(V1.0)'!G23","v":1.22}]
[null,"Import power",null,null,"Electricity",{"$f":"+'REF_DATA(V1.0)'!D21","v":0.51900000000000002},{"$f":"+'REF_DATA(V1.0)'!E21","v":13.19},{"$f":"+'REF_DATA(V1.0)'!F21","v":54},{"$f":"+'REF_DATA(V1.0)'!G21","v":3.07}]
[null,"Export power",null,null,"Electricity",{"$f":"+'REF_DATA(V1.0)'!D22","v":0.51900000000000002},{"$f":"+'REF_DATA(V1.0)'!E22","v":13.19},{"$f":"+'REF_DATA(V1.0)'!F22","v":0},{"$f":"+'REF_DATA(V1.0)'!G22","v":3.07}]
[]
[]
[null,"TABLE RT_02:    REFERENCE BOILER DATA",null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Make & Model",null,"SH output power at 70 - 80oC [kW]",null,"SAP seasonal efficiency [%]",null,null,"Electrical power consumption [W]",null,"Temperature rise [oC]",null,"DHW tank"]
[null,null,null,"Maximum","Minimum","Annual",null,"DHW ","Firing mode","Standby mode","Max power","Min power","Size (L)","Heat Loss at 45∆T(W)"]
[null,null,null,{"$f":"+'Manufacturers''s Declaration'!C45","v":0},{"$f":"+'Manufacturers''s Declaration'!D45","v":0}]
[]
[]
[]
[]
[]
[]
[null,"TABLE RT_03:    Add-on MCU MANUFACTURER'S PERFORMANCE DATA",null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,null,null,null,"Return temperature, TR",null,null,"Standby mode inputs and outputs"]
[null,null,null,null,"60oC","45oC","30oC"]
[null,"Fuel energy consumption rate",null,"[kW]",{"$f":"+'Manufacturers''s Declaration'!F35","v":0},{"$f":"+'Manufacturers''s Declaration'!G35","v":0},{"$f":"+'Manufacturers''s Declaration'!H35","v":0},"Power input","[We]",{"$f":"+'Manufacturers''s Declaration'!K35","v":0}]
[null,"Thermal power output",null,"[kWt]",{"$f":"+'Manufacturers''s Declaration'!F36","v":0},{"$f":"+'Manufacturers''s Declaration'!G36","v":0},{"$f":"+'Manufacturers''s Declaration'!H36","v":0},"Fuel energy input","[W]",{"$f":"+'Manufacturers''s Declaration'!K36","v":0}]
[null,"Electrical power output",null,"[kWe]",{"$f":"+'Manufacturers''s Declaration'!F37","v":0},{"$f":"+'Manufacturers''s Declaration'!G37","v":0},{"$f":"+'Manufacturers''s Declaration'!H37","v":0},"Power output","[We]",{"$f":"+'Manufacturers''s Declaration'!K37","v":0}]
[null,"Gross electrical efficiency",null,"[%]",{"$f":"+'Manufacturers''s Declaration'!F38","v":0},{"$f":"+'Manufacturers''s Declaration'!G38","v":0},{"$f":"+'Manufacturers''s Declaration'!H38","v":0},"Heat output","[Wt]",{"$f":"+'Manufacturers''s Declaration'!K38","v":0}]
[null,"Gross thermal efficiency",null,"[%]",{"$f":"+'Manufacturers''s Declaration'!F39","v":0},{"$f":"+'Manufacturers''s Declaration'!G39","v":0},{"$f":"+'Manufacturers''s Declaration'!H39","v":0}]
[null,"Gross overall efficiency",null,"[%]",{"$f":"+'Manufacturers''s Declaration'!F40","v":0},{"$f":"+'Manufacturers''s Declaration'!G40","v":0},{"$f":"+'Manufacturers''s Declaration'!H40","v":0}]
[]
[]
[null,"TABLE RT_04:    OPERATING AND TEST REGIMES FOR SPACE HEATING PERFORMANCE TESTS",null,null,null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Heating on times",null,null,null,"Operation and test regimes for standard heating performance tests",null,null,null,null,"(OPTIONAL) Operation and test regimes for optional part load heating performance tests"]
[null,null,null,null,"Space heating","Heating load factor (%)",null,null,"Standby","DHW","Heating load factor (%)"]
[null,null,null,null,"Test regime",100,30,10,"Mode","Only",20,40,50,60,70,80,90,0]
[null,{"$f":"+'REF_DATA(V1.0)'!I41","v":"24h"},null,null,{"$f":"+'REF_DATA(V1.0)'!U41","v":1},{"$f":"+'REF_DATA(V1.0)'!K41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!R41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!T41","v":"Continuous"},"Yes",{"$f":"+IF('Manufacturers''s Declaration'!$E$24=\"HeatPK\",\"N/A\",5)","v":5},{"$f":"+'REF_DATA(V1.0)'!S41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!Q41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!P41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!O41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!N41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!M41","v":"Continuous"},{"$f":"+'REF_DATA(V1.0)'!L41","v":"Continuous"},"N/A"]
[null,"Heating system parameters"]
[null,"Minimum Heating return temperature",null,null,"[oC]",{"$f":"+'Manufacturers''s Declaration'!$K54","v":0},{"$f":"+'Manufacturers''s Declaration'!$K54","v":0},{"$f":"+'Manufacturers''s Declaration'!$K54","v":0},null,null,{"$f":"+'Manufacturers''s Declaration'!$K54","v":0},{"$f":"+$F$45+((($F45-$G45)/($F$42-$G$42))*(L42-$F$42))","v":0},0,0,0,0,0,0]
[null,"Minimum Heating flow temperature",null,null,"[oC]",{"$f":"+'Manufacturers''s Declaration'!K55","v":0},{"$f":"+IF((($F46-$F45)*G42/$F$42)<5,(G45+5),(G45+(($F46-$F45)*G42/$F$42)))","v":5},{"$f":"+IF((($F46-$F45)*H42/$F$42)<5,(H45+5),(H45+(($F46-$F45)*H42/$F$42)))","v":5},null,null,{"$f":"+IF((($F46-$F45)*K42/$F$42)<5,(K45+5),(K45+(($F46-$F45)*K42/$F$42)))","v":5},5,5,5,5,5,5,0]
[null,"Space heating load",null,null,"[kWh/24h]",{"$f":"+'Manufacturers''s Declaration'!K53","v":0},{"$f":"+$F47*G42/$F42","v":0},{"$f":"+$F47*H42/$F42","v":0},null,null,{"$f":"+$F47*K42/$F42","v":0},{"$f":"+$F47*L42/$F42","v":0},0,0,0,0,0,0]
[null,null,null,null,"[MJ/24h]",{"$f":"+F47*3.6","v":0},{"$f":"+G47*3.6","v":0},0,null,null,{"$f":"+K47*3.6","v":0},0,0,0,0,0,0,0]
[]
[]
[null,"TABLE RT_05:    SPACE HEATING PERFORMANCE TARGET TEST AND MEASURED PARAMETERS",null,null,null,null,null,"Add-on MCU types:",null,"RegPK, HeatPK and CombiPK"]
[]
[null," TABLE RT_05A:     Target parameters specified by the manufacturer",null,null,null,null,null," TABLE RT_05B:      Laboratory measurements of the reference test system",null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!E24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!F24","v":"With Ref boiler"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE RT_05C:      Comparative gas boiler system"]
[null,"Load factor","Heating system","Heating system","Heating load","SH Return","SH Flow","Fuel energy consumption",null,null,"Average fuel","Space heating energy supplied ",null,null,"Space heating temperatures",null,"Electric power consumption",null,null,"Power produced","Flue losses (Gross basis)",null,"Case losses",null,"Change in energy level",null,"Energy balance",null,"Add-on MCU","Efficiency of reference test package",null,null,"Emissions",null,null,"Energy consumption",null,"Emissions"]
[null,null,"Operating mode","Operating regime",null,"Temperature","Temperature","Add-on MCU","Reference Boiler","Total","Calorific value","Add-on MCU","Reference Boiler","Total","Average return","Average flow","Add-on MCU","Ref Boiler","Total","Add-on MCU","Add-on MCU","Ref Boiler","Add-on MCU","Ref Boiler"," Add-on MCU","Ref Boiler","By Add-on MCU","Ref Boiler","On Hours","Thermal","Power (Electric)","Overall","Fuel","Electricity","Net","Fuel","Electricity","Fuel","Electricity","Total"]
[null,"LF",null,null,"QSH_(LF)","TSHR","TSHF","QF(LF)-AMCP","QF(LF)-RB","QF(LF)_TOT",null,"QSH(LF)-AMCP","QSH(LF)-RB","QSH(LF)_TOT","TSH_AR(LF)","TSH_AF(LF)","QPIN-AMCP(LF)","QPIN-RB(LF)","QPIN-TOT(LF)","QPOUT-AMCP(LF)","QFL_AMCP(LF)","QFL_RB(LF)","QCL_AMCP(LF)","QCL_RB(LF)","QΔAMCP(LF)","QΔRB(LF)","QBAL_AMCP(LF)","QBAL_RB(LF)",null,"ƞTH_RS(LF)","ƞEL_RS(LF)","ƞTOT_RS(LF)","CO2FUEL(LF)","CO2ELEC(LF)","CO2NET(LF)","QF(LF)-GS","QPIN-GS(LF)","CO2FUEL-GS(LF)","CO2ELEC-GS(LF)","CO2NET-GS(LF)"]
[null,"[%]","[ - ]","[ - ]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/m3]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ]","[MJ]","[h]","[%]","[%]","[%]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[MJ/24h]",null,"[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,100,{"$f":"+F43","v":"Continuous"},{"$f":"+E43","v":1},{"$f":"+F47*3.6","v":0},{"$f":"+F45","v":0},{"$f":"+F46","v":0},null,null,{"$f":"+H58+I58","v":0},null,null,null,{"$f":"+L58+M58","v":0},null,null,null,null,{"$f":"+Q58+R58","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+N58*100/J58","v":{"$error":"#DIV/0!"}},{"$f":"+(T58-S58)*100/J58","v":{"$error":"#DIV/0!"}},{"$f":"+AD58+AE58","v":{"$error":"#DIV/0!"}},{"$f":"+(J58/3.6)*$F$10","v":0},{"$f":"+(S58/3.6)*F$11-(T58/3.6)*F$12","v":0},{"$f":"+AG58+AH58","v":0},{"$f":"+N58*100/$F$19","v":{"$error":"#DIV/0!"}},{"$f":"+R58","v":0},{"$f":"+(AJ58/3.6)*$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(AK58/3.6)*$F$11","v":0},{"$f":"+AL58+AM58","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+'Manufacturers''s Declaration'!K56","v":"enter"},{"$f":"+LOOKUP(B59,K$42:R$42,K$43:R$43)","v":{"$error":"#N/A"}},{"$f":"+IF(B59>0,E$43,\"N/A\")","v":1},{"$f":"+IF(B59<>\"None\",((E$58/B$58)*B59),0)","v":{"$error":"#VALUE!"}},{"$f":"+LOOKUP($B59,$K$42:$Q$42,$K$45:$Q$45)","v":{"$error":"#N/A"}},{"$f":"+LOOKUP($B59,$K$42:$Q$42,$K$46:$Q$46)","v":{"$error":"#N/A"}},null,null,{"$f":"+H59+I59","v":0},null,null,null,{"$f":"+L59+M59","v":0},null,null,null,null,{"$f":"+Q59+R59","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+N59*100/J59","v":{"$error":"#DIV/0!"}},{"$f":"+(T59-S59)*100/J59","v":{"$error":"#DIV/0!"}},{"$f":"+AD59+AE59","v":{"$error":"#DIV/0!"}},{"$f":"+(J59/3.6)*$F$10","v":0},{"$f":"+(S59/3.6)*F$11-(T59/3.6)*F$12","v":0},{"$f":"+AG59+AH59","v":0},{"$f":"+N59*100/$F$19","v":{"$error":"#DIV/0!"}},{"$f":"+R59","v":0},{"$f":"+(AJ59/3.6)*$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(AK59/3.6)*$F$11","v":0},{"$f":"+AL59+AM59","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+'Manufacturers''s Declaration'!K57","v":"enter"},{"$f":"+LOOKUP(B60,K$42:R$42,K$43:R$43)","v":{"$error":"#N/A"}},{"$f":"+IF(B60>0,E$43,\"N/A\")","v":1},{"$f":"+IF(B60<>\"None\",((E$58/B$58)*B60),0)","v":{"$error":"#VALUE!"}},{"$f":"+LOOKUP($B60,$K$42:$Q$42,$K$45:$Q$45)","v":{"$error":"#N/A"}},{"$f":"+LOOKUP($B60,$K$42:$Q$42,$K$46:$Q$46)","v":{"$error":"#N/A"}},null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"+N60*100/J60","v":{"$error":"#DIV/0!"}},{"$f":"+(T60-S60)*100/J60","v":{"$error":"#DIV/0!"}},{"$f":"+AD60+AE60","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,30,{"$f":"+G43","v":"Continuous"},{"$f":"+E43","v":1},{"$f":"+G47*3.6","v":0},{"$f":"+G45","v":0},{"$f":"+G46","v":5},null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"+N61*100/J61","v":{"$error":"#DIV/0!"}},{"$f":"+(T61-S61)*100/J61","v":{"$error":"#DIV/0!"}},{"$f":"+AD61+AE61","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,{"$f":"+'Manufacturers''s Declaration'!K58","v":"enter"},{"$f":"+LOOKUP(B62,K$42:R$42,K$43:R$43)","v":{"$error":"#N/A"}},{"$f":"+IF(B62>0,E$43,\"N/A\")","v":1},{"$f":"+IF(B62<>\"None\",((E$58/B$58)*B62),0)","v":{"$error":"#VALUE!"}},{"$f":"+LOOKUP($B62,$K$42:$Q$42,$K$45:$Q$45)","v":{"$error":"#N/A"}},{"$f":"+LOOKUP($B62,$K$42:$Q$42,$K$46:$Q$46)","v":{"$error":"#N/A"}},null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,10,{"$f":"+H43","v":"Continuous"},{"$f":"+E43","v":1},{"$f":"+H47*3.6","v":0},{"$f":"+H45","v":0},{"$f":"+H46","v":5},null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"+N63*100/J63","v":{"$error":"#DIV/0!"}},{"$f":"+(T63-S63)*100/J63","v":{"$error":"#DIV/0!"}},{"$f":"+AD63+AE63","v":{"$error":"#DIV/0!"}},0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[]
[]
[null,"TABLE RT_06:    STANDBY PERFORMANCE MEASUREMENTS OF Add-on MCU REFERENCE TEST SYSTEM",null,null,null,null,null,"Add-on MCU types:",null,"RegPK, HeatPK, CombiPK and DHWPK"]
[]
[null," TABLE RT_06A:     Target parameters specified by the manufacturer",null,null,null,null,null," TABLE RT_06B:      Laboratory measurements of the reference test system",null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!E24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!F24","v":"With Ref boiler"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE RT_05C:      Comparative gas boiler system"]
[null,"Load factor","Heating system","Heating system","Heating load","SH Return","SH Flow","Fuel energy consumption",null,null,"Average fuel","Space heating energy supplied ",null,null,"Space heating temperatures",null,"Electric power consumption",null,null,"Power produced","Flue losses (Gross basis)",null,"Case losses",null,"Change in energy level",null,"Energy balance",null,"Add-on MCU","Efficiency of reference test package",null,null,"Emissions",null,null,"Energy consumption",null,"Emissions"]
[null,null,"Operating mode","Operating regime",null,"Temperature","Temperature","Add-on MCU","Reference Boiler","Total","Calorific value","Add-on MCU","Reference Boiler","Total","Average return","Average flow","Add-on MCU","Ref Boiler","Total","Add-on MCU","Add-on MCU","Ref Boiler","Add-on MCU","Ref Boiler"," Add-on MCU","Ref Boiler","By Add-on MCU","Ref Boiler","On Hours","Thermal","Power (Electric)","Overall","Fuel","Electricity","Net","Fuel","Electricity","Fuel","Electricity","Total"]
[null,"LF",null,null,"QSH_(LF)","TSHR","TSHF","QF(LF)-AMCP","QF(LF)-RB","QF(LF)_TOT",null,"QSH(LF)-AMCP","QSH(LF)-RB","QSH(LF)_TOT","TSH_AR(LF)","TSH_AF(LF)","QPIN-AMCP(LF)","QPIN-RB(LF)","QPIN-TOT(LF)","QPOUT-AMCP(LF)","QFL_AMCP(LF)","QFL_RB(LF)","QCL_AMCP(LF)","QCL_RB(LF)","QΔAMCP(LF)","QΔRB(LF)","QBAL_AMCP(LF)","QBAL_RB(LF)",null,"ƞTH_RS(LF)","ƞEL_RS(LF)","ƞTOT_RS(LF)","CO2FUEL(LF)","CO2ELEC(LF)","CO2NET(LF)","QF(LF)-GS","QPIN-GS(LF)","CO2FUEL-GS(LF)","CO2ELEC-GS(LF)","CO2NET-GS(LF)"]
[null,"[%]","[ - ]","[ - ]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/m3]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ]","[MJ]","[h]","[%]","[%]","[%]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[MJ/24h]",null,"[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,0,"Standby","-","n/a","n/a","n/a",null,null,{"$f":"+H73+I73","v":0},null,null,null,{"$f":"+L73+M73","v":0},"n/a","n/a",null,null,{"$f":"+Q73+R73","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+N73*100/J73","v":{"$error":"#DIV/0!"}},{"$f":"+(T73-S73)*100/J73","v":{"$error":"#DIV/0!"}},{"$f":"+AD73+AE73","v":{"$error":"#DIV/0!"}},{"$f":"+(J73/3.6)*$F$10","v":0},{"$f":"+(S73/3.6)*F$11-(T73/3.6)*F$12","v":0},{"$f":"+AG73+AH73","v":0},{"$f":"+I73*100/$F$19","v":{"$error":"#DIV/0!"}},{"$f":"+R73","v":0},{"$f":"+(AJ73/3.6)*$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(AK73/3.6)*$F$11","v":0},{"$f":"+AL73+AM73","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"TABLE RT_07:    HOT WATER PERFORMANCE MEASUREMENTS OF Add-on MCU REFERENCE TEST SYSTEM",null,null,null,null,null,"Add-on MCU types:",null,"RegPK, CombiPK, HeatPK and DHWPK"]
[]
[null," TABLE RT_07A:     Target parameters specified by the manufacturer",null,null,null,null,null," TABLE RT_07B:      Laboratory measurements of the reference test system",null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE RT-07C:      Comparative reference boiler only"]
[null,"HW heating","System","System","DHW tapping","DHW TC","DHW Flow","Fuel energy consumption",null,null,"Average fuel","DHW heating load supplied by",null,null,"Average Draw-off temperatures",null,"Electric power consumption",null,null,"Power produced","Flue losses (Gross basis)",null,"Case losses",null,"Change in energy level",null,"Energy balance",null,"Add-on MCU","Efficiency of reference test package",null,null,"Emissions",null,null,"Energy consumption",null,"Emissions"]
[null,"Test No","Operating mode","Operating regime","Cycle No","Energy content","Rate","Add-on MCU","Reference Boiler","Total","Calorific value","Add-on MCU","Reference Boiler","Total","Inlet CW","Outlet HW","Add-on MCU","Ref Boiler","Ref test system","By Add-on MCU","Add-on MCU","Ref Boiler","Add-on MCU","Ref Boiler","Add-on MCU","Ref Boiler","Add-on MCU","Ref Boiler","On Hours","Thermal","Power","Overall","Fuel","Electricity","Net","Fuel","Electricity","Fuel","Electricity","Total"]
[null,null,null,null,null,"QHW_(N)",null,"QFHW-AMCP(N)","QFHW-RB(N)","QFHW-TOT(N)",null,"QHW-AMCP(N)","QHW-RB(N)","QHW_TOT(N)","TA-CW(N)","TA-HW(N)","QPIN-HW-AMCP(N)","QPIN-HW-RB(N)","QPIN-HW-TOT(N)","QPOUT-HW(N)","QFL-HW-AMCP(N)","QFL-HW-RB(N)","QCL-HW-AMCP(N)","QCL-HW-RB(N)","QΔAMCP-HW(N)","QΔRB-HW(N)","QBAL-AMCP-HW(N)","QBAL-RB-HW(N)",null,"ƞTH-RS-HW(N)","ƞEL-RS-HW(N)","ƞTOT-RS-HW(N)","CO2FUEL-HW(N)","CO2ELEC-HW(N)","CO2NET-HW(N)","QF(LF)-GS","QPIN-GS(LF)","CO2FUEL-GS(LF)","CO2ELEC-GS(LF)","CO2NET-GS(LF)"]
[null,"[%]","[ - ]","[ - ]","[ - ]","[MJ/24h]","[L/min]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/m3]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ]","[MJ]","[h]","[%]","[%]","[%]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[MJ/24h]",null,"[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,1,{"$f":"+F$43","v":"Continuous"},{"$f":"+J$43","v":5},{"$f":"+'Manufacturers''s Declaration'!F67","v":"2 - M"},{"$f":"+'Manufacturers''s Declaration'!G67","v":21.042000000000002},{"$f":"IF('Manufacturers''s Declaration'!K67>0,'Manufacturers''s Declaration'!K67,\"From PAS67 table\")","v":"From PAS67 table"},null,null,{"$f":"+H83+I83","v":0},null,null,null,{"$f":"+L83+M83","v":0},null,null,null,null,{"$f":"+Q83+R83","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+N83*100/J83","v":{"$error":"#DIV/0!"}},{"$f":"+(T83-S83)*100/J83","v":{"$error":"#DIV/0!"}},{"$f":"+AD83+AE83","v":{"$error":"#DIV/0!"}},{"$f":"+(J83/3.6)*$F$10","v":0},{"$f":"+(S83/3.6)*$F$11-(T83/3.6)*$F$12","v":0},{"$f":"+AG83+AH83","v":0},{"$f":"+N83*100/$H$19","v":{"$error":"#DIV/0!"}},{"$f":"+R83","v":0},{"$f":"+(AJ83/3.6)*$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(AK83/3.6)*$F$11","v":0},{"$f":"+AL83+AM83","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"+F$43","v":"Continuous"},{"$f":"+J$43","v":5},{"$f":"+'Manufacturers''s Declaration'!F68","v":"3 - L"},{"$f":"+'Manufacturers''s Declaration'!G68","v":41.957999999999998},{"$f":"IF('Manufacturers''s Declaration'!K68>0,'Manufacturers''s Declaration'!K68,\"From PAS67 table\")","v":"From PAS67 table"},null,null,{"$f":"+H84+I84","v":0},null,null,null,{"$f":"+L84+M84","v":0},null,null,null,null,{"$f":"+Q84+R84","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+N84*100/J84","v":{"$error":"#DIV/0!"}},{"$f":"+(T84-S84)*100/J84","v":{"$error":"#DIV/0!"}},{"$f":"+AD84+AE84","v":{"$error":"#DIV/0!"}},{"$f":"+(J84/3.6)*$F$10","v":0},{"$f":"+(S84/3.6)*$F$11-(T84/3.6)*$F$12","v":0},{"$f":"+AG84+AH84","v":0},{"$f":"+N84*100/$H$19","v":{"$error":"#DIV/0!"}},{"$f":"+R84","v":0},{"$f":"+(AJ84/3.6)*$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(AK84/3.6)*$F$11","v":0},{"$f":"+AL84+AM84","v":{"$error":"#DIV/0!"}}]
[null,3,"Continuous",5,{"$f":"+'Manufacturers''s Declaration'!F69","v":"4 - XL"},{"$f":"+'Manufacturers''s Declaration'!G69","v":68.652000000000001},{"$f":"IF('Manufacturers''s Declaration'!K69>0,'Manufacturers''s Declaration'!K69,\"From PAS67 table\")","v":"From PAS67 table"},null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"+N85*100/J85","v":{"$error":"#DIV/0!"}},{"$f":"+(T85-S85)*100/J85","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0,{"$f":"+AG85+AH85","v":0},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*to deliver this heat the boiler is firing for a negligible amount or roughly the same amount as in the add-on test case, so no change to value"]
[]
[null,"TABLE RT_08:    SUMMARY OF PERFORMANCE MEASUREMENTS OF Add-on MCU REFERENCE TEST SYSTEM",null,null,null,null,null,"Add-on MCU types:",null,"RegPK, CombiPK, HeatPK and DHWPK"]
[]
[null,"Table RT_08:     PAS 67 Table: Reference System Test Results - Used by APM / SBEM Calculators"]
[null,"Test","Load","Operating","Operating","Total fuel","Average fuel","Energy output","Primary circuit temperatures",null,"Power produced","Total power used","Total Flue","Total Case","Total Change","Total Energy","Laboratory test conditions"]
[null,"No","Factor","Mode","Regime","Energy used","Calorific value","to SH or DHW","Average return","Average flow","By Add-on MCU","Ref test system","Losses","Losses","In energy","Balance","Temperature","Relative","Pressure"]
[null,null,null,null,null,"QFUEL_TOTAL",null,"QSH_TOTAL","TAPCR","TAPCF","EOUT-AOMCP","EIN-RT_SYSTEM","QFLUE_TOTAL","QCASE_TOTAL","QΔTOTAL","QBALANCE_TOTAL",null,"Humidity"]
[null,"[ - ]","[%]","[ - ]","[ - ]","[MJ/24h]","[MJ/m3]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ]","[oC]","[%]","[mbar]"]
[null,1,{"$f":"+B58","v":100},{"$f":"+C58","v":"Continuous"},{"$f":"+D58","v":1},{"$f":"+J58","v":0},{"$f":"+K58","v":0},{"$f":"+N58","v":0},{"$f":"+O58","v":0},{"$f":"+P58","v":0},{"$f":"+T58","v":0},{"$f":"+S58","v":0},{"$f":"+U58+V58","v":0},{"$f":"+W58+X58","v":0},{"$f":"+Y58+Z58","v":0},{"$f":"+AA58+AB58","v":0}]
[null,2,{"$f":"+B59","v":"enter"},{"$error":"#N/A"},1,{"$f":"+J59","v":0},{"$f":"+K59","v":0},{"$f":"+N59","v":0},{"$f":"+O59","v":0},0,{"$f":"+T59","v":0},{"$f":"+S59","v":0},{"$f":"+U59+V59","v":0},{"$f":"+W59+X59","v":0},{"$f":"+Y59+Z59","v":0},{"$f":"+AA59+AB59","v":0}]
[null,3,{"$f":"+B60","v":"enter"},{"$error":"#N/A"},1,0,{"$f":"+K60","v":0},0,{"$f":"+O60","v":0},0,0,0,0,0,0,0]
[null,4,{"$f":"+B61","v":30},"Continuous",1,0,{"$f":"+K61","v":0},0,{"$f":"+O61","v":0},0,0,0,0,0,0,0]
[null,5,{"$f":"+B62","v":"enter"},{"$error":"#N/A"},1,0,{"$f":"+K62","v":0},0,{"$f":"+O62","v":0},0,0,0,0,0,0,0]
[null,6,{"$f":"+B63","v":10},"Continuous",1,0,{"$f":"+K63","v":0},0,{"$f":"+O63","v":0},0,0,0,0,0,0,0]
[null,7,{"$f":"+B73","v":0},{"$f":"+C73","v":"Standby"},{"$f":"+D73","v":"-"},{"$f":"+J73","v":0},{"$f":"+K73","v":0},{"$f":"+N73","v":0},{"$f":"+L73","v":0},{"$f":"+M73","v":0},{"$f":"+Q73","v":0},{"$f":"+P73","v":"n/a"},{"$f":"+R73+S73","v":0},{"$f":"+T73+U73","v":0},{"$f":"+V73+W73","v":0},{"$f":"+X73+Y73","v":0}]
[null,8,"DHW",{"$f":"+C83","v":"Continuous"},{"$f":"+D83","v":5},{"$f":"+J83","v":0},{"$f":"+K83","v":0},{"$f":"+F83","v":21.042000000000002},{"$f":"+O83","v":0},{"$f":"+P83","v":0},{"$f":"+T83","v":0},{"$f":"+S83","v":0},{"$f":"+U83+V83","v":0},{"$f":"+W83+X83","v":0},{"$f":"+Y83+Z83","v":0},{"$f":"+AA83+AB83","v":0}]
[null,9,"DHW",{"$f":"+C84","v":"Continuous"},5,{"$f":"+J84","v":0},{"$f":"+K84","v":0},{"$f":"+F84","v":41.957999999999998},{"$f":"+O84","v":0},{"$f":"+P84","v":0},{"$f":"+T84","v":0},{"$f":"+S84","v":0},{"$f":"+U84+V84","v":0},{"$f":"+W84+X84","v":0},{"$f":"+Y84+Z84","v":0},{"$f":"+AA84+AB84","v":0}]
[null,10,"DHW",{"$f":"+C85","v":"Continuous"},5,0,0,68.652000000000001,0,0,{"$f":"+T85","v":0},{"$f":"+S85","v":0},{"$f":"+U85+V85","v":0},{"$f":"+W85+X85","v":0},{"$f":"+Y85+Z85","v":0},{"$f":"+AA85+AB85","v":0}]
[]
[]
[null,"TABLE RT_09:    CO2 Emission comparisons between Add-on MCU Reference System and Equivalent Gas Boiler only System"]
[]
[null,"Test","Load","Energy output","CO2 Emissions",null,null,"CO2 reduction (%)"]
[null,"No","Factor","to","Add-on MCU+","Equivalent",null,"(pos means reduction)"]
[null,null,null,"Space or HW","Reference test","Gas boiler"]
[null,null,null,"Heating","System","System",null,"(neg means increase)"]
[null,"[ - ]","[%]","[MJ/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,1,{"$f":"+C95","v":100},{"$f":"+H95","v":0},{"$f":"+AI58","v":0},{"$f":"+AN58","v":{"$error":"#DIV/0!"}},null,{"$f":"(F114-E114)/F114","v":{"$error":"#DIV/0!"}}]
[null,2,"enter",0,{"$f":"+AI59","v":0},{"$f":"+AN59","v":{"$error":"#DIV/0!"}},null,{"$f":"(F115-E115)/F115","v":{"$error":"#DIV/0!"}}]
[null,3,"enter",0,0,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,4,30,0,0,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,5,"enter",0,0,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,6,10,0,0,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[null,7,{"$f":"+C101&\" - Standby\"","v":"0 - Standby"},0,{"$f":"+AI73","v":0},{"$f":"+AN73","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,8,{"$f":"+C102","v":"DHW"},21.042000000000002,{"$f":"+AI83","v":0},{"$f":"+AN83","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,9,{"$f":"+C103","v":"DHW"},41.957999999999998,{"$f":"+AI84","v":0},{"$f":"+AN84","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[null,10,{"$f":"+C104","v":"DHW"},68.652000000000001,{"$f":"+AI85","v":0},{"$f":"+AN85","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]

{"sheet":" Installation Package ","index":3,"n_rows":220,"n_cols":23,"rows_kept":220,"cut":false,"hidden":false,"merged":[[214,14,214,15],[53,15,53,18],[28,8,28,10],[29,8,29,10],[27,8,27,10],[50,10,50,11],[53,7,53,9],[53,10,53,14],[38,10,38,14],[63,16,63,19],[153,10,153,11],[195,16,195,18],[196,16,196,18],[197,16,197,18],[180,10,180,11],[156,9,156,10],[28,1,28,4],[31,5,32,5],[30,1,32,4],[8,1,8,4],[8,8,8,10],[11,1,11,4],[10,1,10,4],[9,1,9,4],[10,8,10,10],[12,1,13,3],[12,8,12,10],[13,8,13,10],[15,8,15,10],[16,8,16,10],[14,1,15,4],[14,5,15,5],[5,7,5,8],[17,8,17,10],[35,10,35,11],[20,7,20,8],[23,8,23,10],[26,8,26,9],[11,8,11,10],[25,8,25,9],[14,8,14,10],[38,15,38,18],[54,10,54,12],[60,10,60,11],[38,7,38,9],[91,10,91,13],[147,1,147,3],[148,1,148,3],[149,1,149,3],[53,4,53,6],[63,3,63,4],[145,1,145,3],[142,1,142,3],[63,5,63,7],[138,1,138,3],[137,1,137,3],[136,1,136,3],[16,1,17,3],[130,6,130,7],[23,1,23,4],[24,1,24,4],[25,1,25,4],[129,1,129,3],[129,4,129,7],[26,1,26,4],[88,7,88,8],[70,7,70,8],[73,8,73,9],[63,8,63,10],[38,4,38,6],[39,10,39,12],[63,11,63,15],[64,11,64,13],[183,4,183,6],[183,7,183,9],[183,16,183,18],[190,10,190,11],[193,12,193,14],[193,7,193,9],[193,10,193,11],[183,13,183,14],[193,5,193,6],[214,12,217,12],[150,1,150,3],[194,16,194,18],[212,16,212,18],[209,16,209,18],[210,16,210,18],[211,16,211,18],[198,16,198,18],[199,16,199,18],[200,16,200,18],[201,16,201,18],[202,16,202,18],[203,16,203,18],[204,16,204,18],[207,16,207,18],[208,16,208,18]]}
[]
[null,{"$f":"+'Manufacturers''s Declaration'!B2","v":"Micro-Cogeneration Add-on Calculator "},null,null,null,null,null,null,"Version: ",{"$f":"+'Manufacturers''s Declaration'!J2","v":"v 1.0"}]
[]
[]
[]
[null,"TABLE IS_01: Specification of the boiler and space heating system in the installation dwelling",null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"TABLE IS_01: Specification of the boiler and space heating system in the installation dwelling"]
[null,null,null,null,null,"Symbol","Unit","Value","Notes"]
[null,"Maximum rating of the boiler - (Heating mode i.e. 80/60oC)",null,null,null,"QTB_MAX","[kW]",null,"Range Min - Max: ",{"$f":"+' Installation Package '!F133","v":0},{"$f":"+E133","v":0}]
[null,"Minimum rating of the boiler - (Heating mode i.e. 80/60oC)",null,null,null,"QTB_MIN","[kW]"]
[null,"Boiler turn down ration (Min/Max)",null,null,null,"BLR_MB","[ - ]",{"$f":"+H11/H10","v":{"$error":"#DIV/0!"}},{"$f":"+IF(H12<H133,\"Out of range\",IF(H12>G133,\"Out of range\",\"Ok\"))","v":{"$error":"#DIV/0!"}}]
[null,"Boiler efficiency",null,null,"Annual","ηA","[%]"]
[null,null,null,null,"DHW","ηDHW","[%]"]
[null,"Maximum power rating of the Add-on MCU system + target boiler (100% Load factor)",null,null,null,"QTSH_MAX","[kW]"]
[null,null,null,null,null,null,"[MJ/24h]",{"$f":"+H15*24*3.6","v":0}]
[null,"Standby power consumption of the target boiler",null,null,"Firing mode","QPB_FM","[W]"]
[null,null,null,null,"Standby mode","QPB_SM","[W]"]
[]
[]
[null,"TABLE IS_02: Specification of the hot water heating system in the installation dwelling",null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"TABLE IS_02: Specification of the hot water heating system in the installation dwelling",null,null,null,null,null,null,"Building type:  ",{"$f":"+'Manufacturers''s Declaration'!G24","v":"Single family"}]
[null,null,null,null,null,"Symbol","Unit","Value","Notes"]
[null,"Capacity of the hot water storage vessel in the building",null,null,null,"[VHW_STORE]","[L]",null,"Manufacturer's Range:",0,0]
[null,"Manufacturer Declared heat loss rate for the external hot water storage vessel at 45K ΔT (regPK only)",null,null,null,"[HLHWS]","[W]",null,"Max Permissable heat loss:",null,{"$f":"16.66+8.33*(H25^0.4)","v":16.66}]
[null,"Maximum hot water load tested with the reference boiler",null,null,null,"QHW-MAX","[MJ/24h]",{"$f":"+MAX('Reference Test Data'!N83:N85)","v":0},"Max draw limit (MJ/24h]  =",null,{"$f":"+H27*1.25","v":0}]
[null,"Select HW consumption option (assumed by Tapping cycle or L/day]",null,null,null,"[QHW_PROFILE]","[Select]","1)  EU_TC"]
[null,"Daily hot water usage",null,null,null,"[VHW_CON]","[L/day]",null,"Only required if  option L/day is selected above"]
[null,"Select EU Tapping cycle from the list",null,null,null,"[VHW_CON]","[ - ]","2 - M","Only required if  option EU_TC is selected above (EU tapping cycle)"]
[null,"Energy content of hot water consumption",null,null,null,"Volume","[L/day]",{"$f":"+IF(H28=\"1)  EU_TC\",E151,H29)","v":100}]
[null,null,null,null,null,"QTHW","[kWh/24h]",{"$f":"+IF(H28=\"1)  EU_TC\",' Installation Package '!E150,' Installation Package '!F150)","v":5.8450000000000006}]
[null,null,null,null,null,null,"[MJ/24h]",{"$f":"+H32*3.6","v":21.042000000000002},{"$f":"+IF(H33>K27,\"HW Load above limit - Decrease\",\"OK\")","v":"HW Load above limit - Decrease"}]
[]
[]
[null,"TABLE IS_03:       Space heating performance of the Add-on MCU + target secondary system in the installation building",null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Table IS_03A:     Add-on MCU + Boiler  space heating performance"]
[null,"Load factor","Heating system","Heating system","Energy for space heating",null,null,"Fuel energy consumption",null,null,"Electricity generation & consumption (Building Plant)",null,null,null,null,"CO2 Emissions"]
[null,null,"Operating mode","Operating regime","Total","Supplied by","Supplied by",null,"Building",null,"Consumption",null,null,"Generation","Net electricity","Fuel","Electricity","Electricity","Net"]
[null,null,null,null,"Required","Add-on MCU","Boiler","Add-on MCU","Boiler","Total","Add-on MCU","Heating system","Total","Add-on MCU","Exported",null,"Import","Export","Heating system"]
[null,"[%]","[ - ]","[ - ]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,{"$f":"+'Reference Test Data'!B58","v":100},{"$f":"+'Reference Test Data'!C58","v":"Continuous"},{"$f":"+'Reference Test Data'!D58","v":1},{"$f":"+IF(M36<>\"DHWPK\",(H15*24*3.6),0)","v":0},{"$f":"+K161","v":0},{"$f":"+E43-F43","v":0},{"$f":"+L161","v":{"$error":"#DIV/0!"}},{"$f":"+L173","v":{"$error":"#DIV/0!"}},{"$f":"+H43+I43","v":{"$error":"#DIV/0!"}},{"$f":"+N161","v":{"$error":"#DIV/0!"}},{"$f":"+IF(M$36<>\"DHWPK\",P173,0)","v":{"$error":"#DIV/0!"}},{"$f":"+K43+L43","v":{"$error":"#DIV/0!"}},{"$f":"+M161","v":{"$error":"#DIV/0!"}},{"$f":"+N43-M43","v":{"$error":"#DIV/0!"}},{"$f":"+(J43/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(M43/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"+(N43/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#DIV/0!"}},{"$f":"+(P43+Q43)-R43","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+'Reference Test Data'!B59","v":"enter"},{"$f":"+'Reference Test Data'!C59","v":{"$error":"#N/A"}},{"$f":"+'Reference Test Data'!D59","v":1},{"$f":"+(E$43/100)*B44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"+E44-F44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"+H44+I44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"+K44+L44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"+N44-M44","v":{"$error":"#VALUE!"}},{"$f":"+(J44/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#VALUE!"}},{"$f":"+(M44/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#VALUE!"}},{"$f":"+(N44/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#VALUE!"}},{"$f":"+(P44+Q44)-R44","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+'Reference Test Data'!B60","v":"enter"},{"$f":"+'Reference Test Data'!C60","v":{"$error":"#N/A"}},{"$f":"+'Reference Test Data'!D60","v":1},{"$f":"+(E$43/100)*B45","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"+(J45/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#VALUE!"}},{"$f":"+(M45/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#VALUE!"}},{"$f":"+(N45/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!B61","v":30},{"$f":"+'Reference Test Data'!C61","v":"Continuous"},{"$f":"+'Reference Test Data'!D61","v":1},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+(J46/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(M46/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"+(N46/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"+'Reference Test Data'!B62","v":"enter"},{"$f":"+'Reference Test Data'!C62","v":{"$error":"#N/A"}},{"$f":"+'Reference Test Data'!D62","v":1},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"+(J47/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#VALUE!"}},{"$f":"+(M47/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#VALUE!"}},{"$f":"+(N47/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!B63","v":10},{"$f":"+'Reference Test Data'!C63","v":"Continuous"},{"$f":"+'Reference Test Data'!D63","v":1},0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+(J48/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(M48/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"+(N48/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[null,"TABLE IS_04:      Standby performance of the Add-on MCU system in the installation building + target secondary system in the installation building",null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Table IS_04A:     Add-on MCU + Boiler Standby performance"]
[null,"Load factor","Heating system","Heating system","Energy for space heating",null,null,"Fuel energy consumption",null,null,"Electricity generation & consumption (Building Plant)",null,null,null,null,"CO2 Emissions"]
[null,null,"Operating mode","Operating regime","Total","Supplied by","Supplied by",null,"Building",null,"Consumption",null,null,"Generation","Net electricity","Fuel","Electricity","Electricity","Net"]
[null,null,null,null,"Required","Add-on MCU","Boiler","Add-on MCU","Boiler","Total","Add-on MCU","Heating system","Total","Add-on MCU","Exported",null,"Import","Export","Heating system"]
[null,"[%]","[ - ]","[ - ]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,{"$f":"+'Reference Test Data'!B73","v":0},{"$f":"+'Reference Test Data'!C73","v":"Standby"},{"$f":"+'Reference Test Data'!D73","v":"-"},0,0,0,{"$f":"+N188","v":0},{"$f":"+O188","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+Q188","v":0},{"$f":"+R188","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+T188","v":0},{"$f":"+N58-M58","v":{"$error":"#DIV/0!"}},{"$f":"+(J58/3.6)*'Reference Test Data'!F10","v":{"$error":"#DIV/0!"}},{"$f":"+(M58/3.6)*'Reference Test Data'!F11","v":{"$error":"#DIV/0!"}},{"$f":"+(N58/3.6)*'Reference Test Data'!F12","v":0},{"$f":"+(P58+Q58)-R58","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"TABLE IS_05:     Hot water heating performance of the Add-on MCU system in the installation building + target secondary system in the installation building",null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Table IS_05A:     Add-on MCU + Boiler in hot water heating mode"]
[null,"System","System","Energy required for HW heating",null,"HW heating energy supplied by",null,null,"Fuel energy consumption",null,null,"Electricity generation & consumption (Building Plant)",null,null,null,null,"CO2 Emissions"]
[null,"Operating mode","Operating regime","Energy content","Total","Add-on MCU","Boiler [1]","Boiler",null,"Building",null,"Consumption",null,null,"Generation","Net electricity","Fuel","Electricity","Electricity","Net"]
[null,null,null,"of draw-off",null,null,"All types","Total","Add-on MCU","Boiler","Total","Add-on MCU","Heating system","Total","Add-on MCU","Exported",null,"Import","Export","Heating system"]
[null,"[ - ]","[ - ]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,"HW heating",{"$f":"+'Reference Test Data'!D85","v":5},{"$f":"+D219","v":21.042000000000002},{"$f":"+F219","v":21.042000000000002},{"$f":"+H219","v":{"$error":"#DIV/0!"}},{"$f":"+I219","v":{"$error":"#DIV/0!"}},{"$f":"+IF(N61=\"Stand alone\",(G68+#REF!),G68)","v":{"$error":"#DIV/0!"}},{"$f":"+L219","v":{"$error":"#DIV/0!"}},{"$f":"+H68*100/(H14*E205)","v":{"$error":"#DIV/0!"}},{"$f":"+I68+J68","v":{"$error":"#DIV/0!"}},{"$f":"+O219","v":0},{"$f":"+P219","v":{"$error":"#DIV/0!"}},{"$f":"+L68+M68","v":{"$error":"#DIV/0!"}},{"$f":"+N219","v":{"$error":"#DIV/0!"}},{"$f":"+O68-N68","v":{"$error":"#DIV/0!"}},{"$f":"+(K68/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(N68/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"+(O68/3.6)*'Reference Test Data'!$F$12","v":{"$error":"#DIV/0!"}},{"$f":"+(Q68+R68)-S68","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"TABLE IS_06:    SUMMARY OF Add-on MCU HEATING SYSTEM + target secondary system in the installation building CALCULATED PERFORMANCE IN THE BUILDING",null,null,null,null,null,"Add-on MCU types:",null,"RegPK, CombiPK, HeatPK and DHWPK"]
[]
[null,"Table IS_06:     PAS 67 Format Results"]
[null,"Test","Load","Operating","Operating","Total fuel","Average fuel","Energy output","Primary circuit temperatures",null,"Power produced","Total power used","Net electricity","Emissions"]
[null,"No","Factor","Mode","Regime","Energy used","Calorific value","to SH or DHW","Average return","Average flow","By Add-on MCU",null,"Exported","Add-on MCU + "]
[null,null,null,null,null,"QFUEL_TOTAL",null,"QSH_TOTAL","TAPCR","TAPCF","EOUT-AOMCP","EIN-RT_SYSTEM",null,"target boiler"]
[null,"[ - ]","[%]","[ - ]","[ - ]","[MJ/24h]","[MJ/m3]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[kgCO2]"]
[null,1,{"$f":"+B43","v":100},"Continuous",1,{"$f":"+J43","v":{"$error":"#DIV/0!"}},"N/A",{"$f":"E43","v":0},"N/A","N/A",{"$f":"+N43","v":{"$error":"#DIV/0!"}},{"$f":"+M43","v":{"$error":"#DIV/0!"}},{"$f":"+O43","v":{"$error":"#DIV/0!"}},{"$f":"+S43","v":{"$error":"#DIV/0!"}}]
[null,2,"enter",{"$error":"#N/A"},1,{"$error":"#VALUE!"},"N/A",{"$f":"E44","v":{"$error":"#VALUE!"}},"N/A","N/A",{"$error":"#VALUE!"},{"$f":"+M44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,3,"enter",{"$error":"#N/A"},1,{"$error":"#VALUE!"},"N/A",{"$error":"#VALUE!"},"N/A","N/A",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,4,30,"Continuous",1,{"$error":"#DIV/0!"},"N/A",0,"N/A","N/A",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,5,"enter",{"$error":"#N/A"},1,{"$error":"#VALUE!"},"N/A",{"$error":"#VALUE!"},"N/A","N/A",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,6,10,"Continuous",1,{"$error":"#DIV/0!"},"N/A",0,"N/A","N/A",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,7,{"$f":"+B58","v":0},{"$f":"+C58","v":"Standby"},{"$f":"+D58","v":"-"},{"$f":"+J58","v":{"$error":"#DIV/0!"}},"N/A",{"$f":"+G58","v":0},"N/A","N/A",{"$f":"+N58","v":0},{"$f":"+M58","v":{"$error":"#DIV/0!"}},{"$f":"+O58","v":{"$error":"#DIV/0!"}},{"$f":"+S58","v":{"$error":"#DIV/0!"}}]
[null,8,"HW Heating",{"$f":"+B68","v":"HW heating"},{"$f":"+C68","v":5},{"$f":"K68","v":{"$error":"#DIV/0!"}},"N/A",{"$f":"+E68","v":21.042000000000002},"N/A","N/A",{"$f":"+O68","v":{"$error":"#DIV/0!"}},{"$f":"+N68","v":{"$error":"#DIV/0!"}},{"$f":"+P68","v":{"$error":"#DIV/0!"}},{"$f":"+T68","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"TABLE IS_07:    Gas boiler only calculations for comparison",null,null,null,null,null,"Add-on MCU types:",null,"RegPK, CombiPK, HeatPK and DHWPK"]
[]
[null,"Table IS_07:     Boiler only then comparison"]
[null,"Test","Load","Stated","Heat to be supplied","Boiler fuel","Average","Average ","Calculated","Corrected","Boiler Only CO2 Emissions"]
[null,"No","Factor","Boiler","by boiler","Consumption","Boiler heat ","Boiler ","power","Power","Fuel","Electricity","Electricity","Boiler total"]
[null,null,null,"Efficiency",null,null,"Output","Firing time","Consumption","Consumption",null,"Import","Export","Heating system"]
[null,"[ - ]","[%]","[%]","[MJ/24h]","[MJ/24h]","[kW]","[h]","[MJ/24h]","[MJ/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,1,{"$f":"+B43","v":100},{"$f":"+$H$13","v":0},{"$f":"E43","v":0},{"$f":"+IF(C96>0,(E96*100/D96),0)","v":{"$error":"#DIV/0!"}},{"$f":"(E96/(3.6*LOOKUP(C96,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(G96>' Installation Package '!$H$11,LOOKUP($C96,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G96/' Installation Package '!$H$11)*LOOKUP($C96,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(H96*' Installation Package '!$H$17+(24-' Installation Package '!H96)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$f":"I96","v":{"$error":"#DIV/0!"}},{"$f":"+(F96/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(J96/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},0,{"$f":"+(K96+L96)-M96","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"+B44","v":"enter"},{"$f":"+$H$13","v":0},{"$f":"E44","v":{"$error":"#VALUE!"}},{"$f":"+IF(C97>0,(E97*100/D97),0)","v":{"$error":"#VALUE!"}},{"$f":"(E97/(3.6*LOOKUP(C97,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G97>' Installation Package '!$H$11,LOOKUP($C97,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G97/' Installation Package '!$H$11)*LOOKUP($C97,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#VALUE!"}},{"$f":"+(H97*' Installation Package '!$H$17+(24-' Installation Package '!H97)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"+(F97/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#VALUE!"}},{"$f":"+(J97/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#VALUE!"}},0,{"$f":"+(K97+L97)-M97","v":{"$error":"#VALUE!"}}]
[null,3,"enter",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(E98/(3.6*LOOKUP(C98,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G98>' Installation Package '!$H$11,LOOKUP($C98,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G98/' Installation Package '!$H$11)*LOOKUP($C98,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#VALUE!"}},{"$f":"+(H98*' Installation Package '!$H$17+(24-' Installation Package '!H98)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"+(F98/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#VALUE!"}},{"$f":"+(J98/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"}]
[null,4,30,0,0,{"$error":"#DIV/0!"},{"$f":"(E99/(3.6*LOOKUP(C99,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(G99>' Installation Package '!$H$11,LOOKUP($C99,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G99/' Installation Package '!$H$11)*LOOKUP($C99,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(H99*' Installation Package '!$H$17+(24-' Installation Package '!H99)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+(F99/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(J99/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[null,5,"enter",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(E100/(3.6*LOOKUP(C100,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#VALUE!"}},{"$f":"IF(G100>' Installation Package '!$H$11,LOOKUP($C100,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G100/' Installation Package '!$H$11)*LOOKUP($C100,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#VALUE!"}},{"$f":"+(H100*' Installation Package '!$H$17+(24-' Installation Package '!H100)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"+(F100/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#VALUE!"}},{"$f":"+(J100/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"}]
[null,6,{"$f":"+B48","v":10},0,0,{"$error":"#DIV/0!"},{"$f":"(E101/(3.6*LOOKUP(C101,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(G101>' Installation Package '!$H$11,LOOKUP($C101,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G101/' Installation Package '!$H$11)*LOOKUP($C101,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(H101*' Installation Package '!$H$17+(24-' Installation Package '!H101)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$f":"I101","v":{"$error":"#DIV/0!"}},{"$f":"+(F101/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(J101/3.6)*'Reference Test Data'!$F$11","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"}]
[null,7,{"$f":"+C58","v":"Standby"},{"$f":"+C76","v":0},{"$f":"+E58","v":0},{"$f":"+I58","v":{"$error":"#DIV/0!"}},"N/A",{"$f":"+G76","v":0},{"$f":"+(H102*' Installation Package '!$H$17+(24-' Installation Package '!H102)*' Installation Package '!$H$18)*3.6/1000","v":0},{"$f":"I102","v":0},{"$f":"+(F102/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(J102/3.6)*'Reference Test Data'!$F$11","v":0},{"$f":"+O76","v":0},{"$error":"#DIV/0!"}]
[null,8,"HW Heating",{"$f":"$H$14","v":0},{"$f":"E68","v":21.042000000000002},{"$f":"+IF(C103>0,(E103*100/D103),0)","v":{"$error":"#DIV/0!"}},"N/A",0,{"$f":"+(H103*' Installation Package '!$H$17+(24-' Installation Package '!H103)*' Installation Package '!$H$18)*3.6/1000","v":0},{"$f":"I103","v":0},{"$f":"+(F103/3.6)*'Reference Test Data'!$F$10","v":{"$error":"#DIV/0!"}},{"$f":"+(J103/3.6)*'Reference Test Data'!$F$11","v":0},{"$f":"+U86","v":0},{"$error":"#DIV/0!"}]
[]
[]
[null,"TABLE IS_08:    Emissions Comparison"]
[]
[null,"Table IS_08:     Emissions Comparison"]
[null,"Test","Load","Emissions","Emissions","Emissions"]
[null,"No","Factor","Add-on MCU + ","Boiler only","Reduction"]
[null,null,null,"target boiler"]
[null,"[ - ]","[%]","[kgCO2/24h]","[kgCO2/24h]","[kgCO2/24h]"]
[null,1,{"$f":"B$43","v":100},{"$f":"S$43","v":{"$error":"#DIV/0!"}},{"$f":"K$96+L$96-M$96","v":{"$error":"#DIV/0!"}},{"$f":"E$113-D$113","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"B$44","v":"enter"},{"$f":"S$44","v":{"$error":"#VALUE!"}},{"$f":"K$97+L$97-M$97","v":{"$error":"#VALUE!"}},{"$f":"E$114-D$114","v":{"$error":"#VALUE!"}}]
[null,3,{"$f":"B$45","v":"enter"},{"$f":"S$45","v":{"$error":"#VALUE!"}},{"$f":"K$98+L$98-M$98","v":{"$error":"#VALUE!"}},{"$f":"E$115-D$115","v":{"$error":"#VALUE!"}}]
[null,4,{"$f":"B$46","v":30},{"$f":"S$46","v":{"$error":"#DIV/0!"}},{"$f":"K$99+L$99-M$99","v":{"$error":"#DIV/0!"}},{"$f":"E$116-D$116","v":{"$error":"#DIV/0!"}}]
[null,5,{"$f":"B$47","v":"enter"},{"$f":"S$47","v":{"$error":"#VALUE!"}},{"$f":"K$100+L$100-M$100","v":{"$error":"#VALUE!"}},{"$f":"E$117-D$117","v":{"$error":"#VALUE!"}}]
[null,6,{"$f":"B$48","v":10},{"$f":"S$48","v":{"$error":"#DIV/0!"}},{"$f":"K$101+L$101-M$101","v":{"$error":"#DIV/0!"}},{"$f":"E$118-D$118","v":{"$error":"#DIV/0!"}}]
[null,7,{"$f":"C$58","v":"Standby"},{"$f":"N$84","v":{"$error":"#DIV/0!"}},{"$f":"N$102","v":{"$error":"#DIV/0!"}},{"$f":"E$119-D$119","v":{"$error":"#DIV/0!"}},null,"* Check latest standards, but the Standby result may be ignored."]
[null,8,"HW Heating",{"$f":"N$85","v":{"$error":"#DIV/0!"}},{"$f":"K$103+L$103-M$103","v":{"$error":"#DIV/0!"}},{"$f":"E$120-D$120","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[null,"THE FOLLOWING TABLES ARE TO SHOW CALCULATIONS- THEY ARE NOT TO BE AMENDED MANUALLY"]
[]
[null,"Table IP_R1:       Installation boiler output range"]
[null,"Reference boiler rating",null,null,"Installation boiler limits"]
[null,"Maximum","Minimum","Min/Max ratio","Max output","Min output","Min/Max Ratio Permissable limits"]
[null,"[kW]","[kW]","[ - ]","[kW]","[kW]","Max","Min"]
[null,{"$f":"+'Manufacturers''s Declaration'!C45","v":0},{"$f":"+'Manufacturers''s Declaration'!D45","v":0},{"$f":"+C133/B133","v":{"$error":"#DIV/0!"}},{"$f":"H10","v":0},{"$f":"H11","v":0},{"$f":"+D133*2","v":{"$error":"#DIV/0!"}},{"$f":"0.01","v":0.01},null,"A boiler that can modulate deeper/lower is always a good thing, as it stops cycling and lowers return tempeartures"]
[null,null,null,null,null,null,null,null,null,"Therefore there should be no lower limit (Min) on turndown ratio. For completeness a 1% min ratio is written as this is not seen to be technologically possible, so should have no effect,  but the test house should ignore if necessary. "]
[]
[null,"Table IP_R2:     Design heat loss and 100% Load Factor limits"]
[null,"Parameters",null,null,"Unit","Value"]
[null,"Maximum thermal rating of Add-on MCU",null,null,"[kW]",{"$f":"+'Manufacturers''s Declaration'!F36","v":0}]
[null,"Maximum rating of the boiler",null,null,"[kW]",{"$f":"+H10","v":0}]
[]
[]
[null,"Table IP_R3:     HW Storage vessel & hot water usage parameters"]
[null,"Building type",null,null,{"$f":"+'Manufacturers''s Declaration'!G24","v":"Single family"}]
[null,null,null,null,"Minimum","Maximum"]
[null,null,null,null,"[L]","[L]"]
[null,"Capacity of the HW Store in the building",null,null,{"$f":"J25","v":0},{"$f":"K25","v":0}]
[]
[null,"HW Load profile type",null,null,"1)  EU_TC","2)  L/day"]
[null,"HW Load profile selected",null,null,{"$f":"+H30","v":"2 - M"},"n/a"]
[null,"Energy content of HW [kWh/24h] of load profile",null,null,{"$f":"+LOOKUP(E149,'REF_DATA(V1.0)'!B60:B68,'REF_DATA(V1.0)'!D60:D68)","v":5.8450000000000006},{"$f":"+F151*50*4.185/3600","v":0}]
[null,"Volume of 60°C hot water",null,null,{"$f":"+LOOKUP(E149,'REF_DATA(V1.0)'!B60:B68,'REF_DATA(V1.0)'!E60:E68)","v":100},{"$f":"+H29","v":0}]
[]
[]
[null,"Table IP_R4:     Space heating performance calculation of the Add-on MCU in the building",null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Table IP_R4A:     Reference system: Add-on MCU",null,null,null,null,null,null,null,"Table IP_R4B:     Target building system: Add-on MCU"]
[null,"Load","Heating on","Maximum","Heat supplied","Operating","Thermal","Electrical","Electrical power","Space heating energy",null,"Fuel","Electricity ","Electrical power"]
[null,"Factor","Period","Capacity of","By Add-on MCU","Efficiency of","Efficiency","Efficiency of","Used by","Total","Supplied by","Consumption","Generated by","Used by"]
[null,null,null,"Add-on MCU","Ref System","Add-on MCU","Of Add-on MCU","Add-on MCU","Add-on MCU","Required","Add-on MCU","Of Add-on MCU","Add-on MCU","Add-on MCU"]
[null,"[%]","[h]","[MJ/24h]","[MJ/24h]","[Fraction]","[%]","[%]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[mJ/24h]","[MJ/24h]","[MJ/24h]"]
[null,{"$f":"+'Reference Test Data'!C95","v":100},{"$f":"+LOOKUP(B161,'REF_DATA(V1.0)'!E$48:N$48,'REF_DATA(V1.0)'!E$49:N$49)","v":24},{"$f":"+IF(B161>0,('Manufacturers''s Declaration'!$C$49*' Installation Package '!C161*3.6),0)","v":0},{"$f":"+'Reference Test Data'!L58","v":0},{"$f":"+IF(D161>0,(E161/D161),0)","v":0},{"$f":"+IF(B161>0,(('Reference Test Data'!L58/'Reference Test Data'!H58)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B161>0,(('Reference Test Data'!T58/'Reference Test Data'!H58)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!Q58","v":0},{"$f":"+E43","v":0},{"$f":"+IF(J161>=(D161*F161),(D161*F161),J161)","v":0},{"$f":"+IF(B161>0,(K161*100/G161),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B161>0,(L161*H161/100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B161>0,((E161/K161)*I161),0)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+'Reference Test Data'!C96","v":"enter"},{"$f":"+LOOKUP(B162,'REF_DATA(V1.0)'!E$48:N$48,'REF_DATA(V1.0)'!E$49:N$49)","v":{"$error":"#N/A"}},{"$f":"+IF(B162>0,('Manufacturers''s Declaration'!$C$49*' Installation Package '!C162*3.6),0)","v":{"$error":"#N/A"}},{"$f":"+'Reference Test Data'!L59","v":0},{"$f":"+IF(D162>0,(E162/D162),0)","v":{"$error":"#N/A"}},{"$f":"+IF(B162>0,(('Reference Test Data'!L59/'Reference Test Data'!H59)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B162>0,(('Reference Test Data'!T59/'Reference Test Data'!H59)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!Q59","v":0},{"$error":"#VALUE!"},{"$f":"+IF(J162>=(D162*F162),(D162*F162),J162)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!C97","v":"enter"},{"$f":"+LOOKUP(B163,'REF_DATA(V1.0)'!E$48:N$48,'REF_DATA(V1.0)'!E$49:N$49)","v":{"$error":"#N/A"}},{"$f":"+IF(B163>0,('Manufacturers''s Declaration'!$C$49*' Installation Package '!C163*3.6),0)","v":{"$error":"#N/A"}},{"$f":"+'Reference Test Data'!L60","v":0},{"$error":"#N/A"},{"$f":"+IF(B163>0,(('Reference Test Data'!L60/'Reference Test Data'!H60)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B163>0,(('Reference Test Data'!T60/'Reference Test Data'!H60)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!Q60","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!C98","v":30},{"$f":"+LOOKUP(B164,'REF_DATA(V1.0)'!E$48:N$48,'REF_DATA(V1.0)'!E$49:N$49)","v":24},{"$f":"+IF(B164>0,('Manufacturers''s Declaration'!$C$49*' Installation Package '!C164*3.6),0)","v":0},{"$f":"+'Reference Test Data'!L61","v":0},0,{"$f":"+IF(B164>0,(('Reference Test Data'!L61/'Reference Test Data'!H61)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B164>0,(('Reference Test Data'!T61/'Reference Test Data'!H61)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!Q61","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+'Reference Test Data'!C99","v":"enter"},{"$f":"+LOOKUP(B165,'REF_DATA(V1.0)'!E$48:N$48,'REF_DATA(V1.0)'!E$49:N$49)","v":{"$error":"#N/A"}},{"$f":"+IF(B165>0,('Manufacturers''s Declaration'!$C$49*' Installation Package '!C165*3.6),0)","v":{"$error":"#N/A"}},{"$f":"+'Reference Test Data'!L62","v":0},{"$error":"#N/A"},{"$f":"+IF(B165>0,(('Reference Test Data'!L62/'Reference Test Data'!H62)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B165>0,(('Reference Test Data'!T62/'Reference Test Data'!H62)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!Q62","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!C100","v":10},{"$f":"+LOOKUP(B166,'REF_DATA(V1.0)'!E$48:N$48,'REF_DATA(V1.0)'!E$49:N$49)","v":24},{"$f":"+IF(B166>0,('Manufacturers''s Declaration'!$C$49*' Installation Package '!C166*3.6),0)","v":0},{"$f":"+'Reference Test Data'!L63","v":0},0,{"$f":"+IF(B166>0,(('Reference Test Data'!L63/'Reference Test Data'!H63)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B166>0,(('Reference Test Data'!T63/'Reference Test Data'!H63)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!Q63","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Table IP_R4C:     Reference system: Reference test boiler",null,null,null,null,null,null,null,"Table IP_R4D:     Target building system: Boiler"]
[null,"Load","Reference","Boiler efficiency","Electricity used","Heat supplied","Average","Average ","Calculated","Adjusted","Heat supplied","Boiler fuel","Average","Average ","Calculated","Corrected"]
[null,"Factor","System boiler","Ratio","by","by Ref boiler","Boiler heat","Boiler ","Power","Boiler","by boiler","Consumption","Boiler heat ","Boiler ","power","Power"]
[null,null,"Efficiency","Measured/Declared","Boiler system",null,"Ouptut","Firing time","Consumption","Efficiency",null,null,"Output","Firing time","Consumption","Consumption"]
[null,"[%]","[%]","[Fraction]","[MJ/24h]","[MJ/24h]","[kW]","[h]","[MJ/24h]","[%]","[MJ/24h]","[MJ/24h]","[kW]","[h]","[MJ/24h]","[MJ/24h]"]
[null,{"$f":"+'Reference Test Data'!B58","v":100},{"$f":"+IF(B173>0,(('Reference Test Data'!M58/'Reference Test Data'!I58)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B173>0,(C173/'Reference Test Data'!$F$19),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!R58","v":0},{"$f":"+'Reference Test Data'!M58","v":0},{"$f":"(F173/(3.6*LOOKUP(B173,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(G173>'Reference Test Data'!$E$19,LOOKUP($B173,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G173/'Reference Test Data'!$E$19)*LOOKUP(B173,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(H173*'Reference Test Data'!$I$19+(24-' Installation Package '!H173)*'Reference Test Data'!$J$19)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$f":"+$H$13*D173","v":{"$error":"#DIV/0!"}},{"$f":"J161-K161","v":0},{"$f":"+IF(B173>0,(K173*100/J173),0)","v":{"$error":"#DIV/0!"}},{"$f":"(K173/(3.6*LOOKUP(B173,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(M173>' Installation Package '!$H$11,LOOKUP($B173,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(M173/' Installation Package '!$H$11)*LOOKUP($B173,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(N173*' Installation Package '!$H$17+(24-' Installation Package '!N173)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$f":"+(O173/I173)*E173","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+'Reference Test Data'!B59","v":"enter"},{"$f":"+IF(B174>0,(('Reference Test Data'!M59/'Reference Test Data'!I59)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B174>0,(C174/'Reference Test Data'!$F$19),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!R59","v":0},{"$f":"+'Reference Test Data'!M59","v":0},{"$f":"(F174/(3.6*LOOKUP(B174,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#N/A"}},{"$f":"IF(G174>'Reference Test Data'!$E$19,LOOKUP($B174,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G174/'Reference Test Data'!$E$19)*LOOKUP(B174,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#N/A"}},{"$f":"+(H174*'Reference Test Data'!$I$19+(24-' Installation Package '!H174)*'Reference Test Data'!$J$19)*3.6/1000","v":{"$error":"#N/A"}},{"$f":"+$H$13*D174","v":{"$error":"#DIV/0!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(K174/(3.6*LOOKUP(B174,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#VALUE!"}},{"$f":"IF(M174>' Installation Package '!$H$11,LOOKUP($B174,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(M174/' Installation Package '!$H$11)*LOOKUP($B174,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#VALUE!"}},{"$f":"+(N174*' Installation Package '!$H$17+(24-' Installation Package '!N174)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#VALUE!"}},{"$f":"+(O174/I174)*E174","v":{"$error":"#VALUE!"}}]
[null,{"$f":"+'Reference Test Data'!B60","v":"enter"},{"$f":"+IF(B175>0,(('Reference Test Data'!M60/'Reference Test Data'!I60)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B175>0,(C175/'Reference Test Data'!$F$19),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!R60","v":0},{"$f":"+'Reference Test Data'!M60","v":0},{"$f":"(F175/(3.6*LOOKUP(B175,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#N/A"}},{"$f":"IF(G175>'Reference Test Data'!$E$19,LOOKUP($B175,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G175/'Reference Test Data'!$E$19)*LOOKUP(B175,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#N/A"}},{"$f":"+(H175*'Reference Test Data'!$I$19+(24-' Installation Package '!H175)*'Reference Test Data'!$J$19)*3.6/1000","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(K175/(3.6*LOOKUP(B175,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#VALUE!"}},{"$f":"IF(M175>' Installation Package '!$H$11,LOOKUP($B175,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(M175/' Installation Package '!$H$11)*LOOKUP($B175,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#VALUE!"}},{"$f":"+(N175*' Installation Package '!$H$17+(24-' Installation Package '!N175)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!B61","v":30},{"$f":"+IF(B176>0,(('Reference Test Data'!M61/'Reference Test Data'!I61)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B176>0,(C176/'Reference Test Data'!$F$19),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!R61","v":0},{"$f":"+'Reference Test Data'!M61","v":0},{"$f":"(F176/(3.6*LOOKUP(B176,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(G176>'Reference Test Data'!$E$19,LOOKUP($B176,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G176/'Reference Test Data'!$E$19)*LOOKUP(B176,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(H176*'Reference Test Data'!$I$19+(24-' Installation Package '!H176)*'Reference Test Data'!$J$19)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"(K176/(3.6*LOOKUP(B176,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(M176>' Installation Package '!$H$11,LOOKUP($B176,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(M176/' Installation Package '!$H$11)*LOOKUP($B176,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(N176*' Installation Package '!$H$17+(24-' Installation Package '!N176)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"+'Reference Test Data'!B62","v":"enter"},{"$f":"+IF(B177>0,(('Reference Test Data'!M62/'Reference Test Data'!I62)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B177>0,(C177/'Reference Test Data'!$F$19),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!R62","v":0},{"$f":"+'Reference Test Data'!M62","v":0},{"$f":"(F177/(3.6*LOOKUP(B177,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#N/A"}},{"$f":"IF(G177>'Reference Test Data'!$E$19,LOOKUP($B177,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G177/'Reference Test Data'!$E$19)*LOOKUP(B177,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#N/A"}},{"$f":"+(H177*'Reference Test Data'!$I$19+(24-' Installation Package '!H177)*'Reference Test Data'!$J$19)*3.6/1000","v":{"$error":"#N/A"}},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"(K177/(3.6*LOOKUP(B177,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":{"$error":"#VALUE!"}},{"$f":"IF(M177>' Installation Package '!$H$11,LOOKUP($B177,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(M177/' Installation Package '!$H$11)*LOOKUP($B177,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#VALUE!"}},{"$f":"+(N177*' Installation Package '!$H$17+(24-' Installation Package '!N177)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,{"$f":"+'Reference Test Data'!B63","v":10},{"$f":"+IF(B178>0,(('Reference Test Data'!M63/'Reference Test Data'!I63)*100),0)","v":{"$error":"#DIV/0!"}},{"$f":"+IF(B178>0,(C178/'Reference Test Data'!$F$19),0)","v":{"$error":"#DIV/0!"}},{"$f":"+'Reference Test Data'!R63","v":0},{"$f":"+'Reference Test Data'!M63","v":0},{"$f":"(F178/(3.6*LOOKUP(B178,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(G178>'Reference Test Data'!$E$19,LOOKUP($B178,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(G178/'Reference Test Data'!$E$19)*LOOKUP(B178,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(H178*'Reference Test Data'!$I$19+(24-' Installation Package '!H178)*'Reference Test Data'!$J$19)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"(K178/(3.6*LOOKUP(B178,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49)))","v":0},{"$f":"IF(M178>' Installation Package '!$H$11,LOOKUP($B178,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49),(M178/' Installation Package '!$H$11)*LOOKUP($B178,'REF_DATA(V1.0)'!$E$48:$N$48,'REF_DATA(V1.0)'!$E$49:$N$49))","v":{"$error":"#DIV/0!"}},{"$f":"+(N178*' Installation Package '!$H$17+(24-' Installation Package '!N178)*' Installation Package '!$H$18)*3.6/1000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[null,"Table IP_R5:     Standby performance calculation of the Add-on MCU in the building",null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Table IP_R5A:     Reference test system",null,null,null,null,null,null,null,null,null,null,"Table IP_R5B:     System in the target building"]
[null,"Load factor","Heating system","Heating system","Fuel energy consumption",null,null,"Electric power consumption",null,null,"Power produced","Standby power","Standby power","Fuel energy consumption",null,null,"Electric power consumption",null,null,"Power produced"]
[null,null,"Operating mode","Operating regime","Add-on MCU","Reference Boiler","Total","Add-on MCU","Ref Boiler","Total","Add-on MCU","Consumption","Consumption","Add-on MCU","Target Boiler","Total","Add-on MCU","Target Boiler","Total","Add-on MCU"]
[null,"LF",null,null,"QF(LF)-AMCP","QF(LF)-RB","QF(LF)_TOT","QPIN-AMCP(LF)","QPIN-RB(LF)","QPIN-TOT(LF)","QPOUT-AMCP(LF)","of Ref boiler","of building boiler","QF(LF)-AMCP","QF(LF)-RB","QF(LF)_TOT","QPIN-AMCP(LF)","QPIN-RB(LF)","QPIN-TOT(LF)","QPOUT-AMCP(LF)"]
[null,"[%]","[ - ]","[ - ]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[W]","[W]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]"]
[null,{"$f":"+'Reference Test Data'!B73","v":0},{"$f":"+'Reference Test Data'!C73","v":"Standby"},{"$f":"+'Reference Test Data'!D73","v":"-"},{"$f":"+'Reference Test Data'!H73","v":0},{"$f":"+'Reference Test Data'!I73","v":0},{"$f":"+'Reference Test Data'!J73","v":0},{"$f":"+'Reference Test Data'!Q73","v":0},{"$f":"+'Reference Test Data'!R73","v":0},{"$f":"+'Reference Test Data'!S73","v":0},{"$f":"+'Reference Test Data'!T73","v":0},{"$f":"'Reference Test Data'!J19","v":0},{"$f":"+H18","v":0},{"$f":"+E188","v":0},{"$f":"F188*'Reference Test Data'!F19/H13","v":{"$error":"#DIV/0!"}},{"$f":"+N188+O188","v":{"$error":"#DIV/0!"}},{"$f":"+H188","v":0},{"$f":"+I188*(M188/L188)","v":{"$error":"#DIV/0!"}},{"$f":"+Q188+R188","v":{"$error":"#DIV/0!"}},{"$f":"+K188","v":0}]
[]
[]
[null,"Table IP_R6:     Hot water heating performance calculation of the Add-on MCU in the building",null,null,null,null,null,null,null,null,"Add-on MCU type:  ",null,{"$f":"+'Manufacturers''s Declaration'!$E$24","v":"RegPK"},{"$f":"+'Manufacturers''s Declaration'!$F$24","v":"With Ref boiler"}]
[]
[null,"Table IP_R6A:     Reference test system"]
[null,"HW heating","HW Load",null,"DHW tapping","Fuel energy consumption",null,"DHW heating load supplied by",null,null,"Average Draw-off temperatures",null,"Electric power consumption",null,null,"Power produced","Number of HW load tests",null,{"$f":"SUM(D198:D200)","v":3}]
[null,"Test No","demand","Number of","Cycle No","Add-on MCU","Reference Boiler","Add-on MCU","Reference Boiler","Total","Inlet CW","Outlet HW","Add-on MCU","Ref Boiler","Ref test system","By Add-on MCU",null,null,null,"Units","Minimum","Maximum"]
[null,null,"setting","HW load tests",null,"QFHW-AMCP(N)","QFHW-RB(N)","QHW-AMCP(N)","QHW-RB(N)","QHW_TOT(N)","TA-CW(N)","TA-HW(N)","QPIN-HW-AMCP(N)","QPIN-HW-RB(N)","QPIN-HW-TOT(N)","QPOUT-HW(N)","Energy content of HW loads tested",null,null,"[MJ/24h]",{"$f":"+IF(S$194=1,J$198,IF(S$194=2,MIN(J$198:J$199),IF(S$194=3,MIN(J$198:J$200),0)))","v":0},{"$f":"+IF(S$194=1,J$198,IF(S$194=2,MAX(J$198:J$199),IF(S$194=3,MAX(J$198:J$200),0)))","v":0}]
[null,"[ - ]","[MJ/24h]","[ - ]","[ - ]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[oC]","[oC]","[MJ/24h]","[MJ/24h]","[MJ/24h]","[MJ/24h]","HW energy supplied by Add-on MCU",null,null,"[MJ/24h]",{"$f":"+LOOKUP(U196,J198:J200,H198:H200)","v":0},{"$f":"+LOOKUP(V196,J198:J200,H198:H200)","v":0}]
[null,{"$f":"+'Reference Test Data'!B83","v":1},{"$f":"+'Reference Test Data'!F83","v":21.042000000000002},{"$f":"+IF(C198>0,1,0)","v":1},{"$f":"+'Reference Test Data'!E83","v":"2 - M"},{"$f":"+'Reference Test Data'!H83","v":0},{"$f":"+'Reference Test Data'!I83","v":0},{"$f":"+'Reference Test Data'!L83","v":0},{"$f":"+'Reference Test Data'!M83","v":0},{"$f":"+'Reference Test Data'!N83","v":0},{"$f":"+'Reference Test Data'!O83","v":0},{"$f":"+'Reference Test Data'!P83","v":0},{"$f":"+'Reference Test Data'!Q83","v":0},{"$f":"+'Reference Test Data'!R83","v":0},{"$f":"+'Reference Test Data'!S83","v":0},{"$f":"+'Reference Test Data'!T83","v":0},"HW Heating energy fraction from Add-on MCU",null,null,"[Fraction]",{"$f":"+U197/U196","v":{"$error":"#DIV/0!"}},{"$f":"+V197/V196","v":{"$error":"#DIV/0!"}},"(assumed, please correct as necessary)"]
[null,{"$f":"+'Reference Test Data'!B84","v":2},{"$f":"+'Reference Test Data'!F84","v":41.957999999999998},{"$f":"+IF(C199>0,1,0)","v":1},{"$f":"+'Reference Test Data'!E84","v":"3 - L"},{"$f":"+'Reference Test Data'!H84","v":0},{"$f":"+'Reference Test Data'!I84","v":0},{"$f":"+'Reference Test Data'!L84","v":0},{"$f":"+'Reference Test Data'!M84","v":0},{"$f":"+'Reference Test Data'!N84","v":0},{"$f":"+'Reference Test Data'!O84","v":0},{"$f":"+'Reference Test Data'!P84","v":0},{"$f":"+'Reference Test Data'!Q84","v":0},{"$f":"+'Reference Test Data'!R84","v":0},{"$f":"+'Reference Test Data'!S84","v":0},{"$f":"+'Reference Test Data'!T84","v":0},"Add-on MCU utilisation for HW heating",null,null,"[Fraction]",1,1,"describes how much of the add-on MCU's declared output can actually be harnessed for producing hot water i.e, it could declare X but only in reality produce Y."]
[null,{"$f":"+'Reference Test Data'!B85","v":3},{"$f":"+'Reference Test Data'!F85","v":68.652000000000001},1,{"$f":"+'Reference Test Data'!E85","v":"4 - XL"},{"$f":"+'Reference Test Data'!H85","v":0},{"$f":"+'Reference Test Data'!I85","v":0},{"$f":"+'Reference Test Data'!L85","v":0},{"$f":"+'Reference Test Data'!M85","v":0},{"$f":"+'Reference Test Data'!N85","v":0},{"$f":"+'Reference Test Data'!O85","v":0},{"$f":"+'Reference Test Data'!P85","v":0},{"$f":"+'Reference Test Data'!Q85","v":0},{"$f":"+'Reference Test Data'!R85","v":0},{"$f":"+'Reference Test Data'!S85","v":0},{"$f":"+'Reference Test Data'!T85","v":0},"Max heat available from Add-on MCU for HW heating",null,null,"[MJ/24h]",{"$f":"+U199*('Manufacturers''s Declaration'!F36*24*3.6)","v":0},{"$f":"+V199*('Manufacturers''s Declaration'!F36*24*3.6)","v":0}]
[null,"HW heating","Boiler efficiency",null,"Boiler efficiency",null,null,null,null,null,null,null,null,null,null,null,"Fuel used by Add-on MCU for HW heating",null,null,"[MJ/24h]",{"$f":"+LOOKUP(U196,J198:J200,F198:F200)","v":0},{"$f":"+LOOKUP(V196,J198:J200,F198:F200)","v":0}]
[null,"Test No","Each test","Average","Ratio",null,null,null,null,null,null,null,null,null,null,null,"Thermal efficiency of Add-on MCU (HW heating))",null,null,"[%]",{"$f":"+U196*100/U201","v":{"$error":"#DIV/0!"}},{"$f":"+V196*100/V201","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Measured/Declared",null,null,null,null,null,null,null,null,null,null,null,"Power generated by Add-on MCU (HW heating)",null,null,"[MJ/24h]",{"$f":"+LOOKUP(U197,H198:H200,P198:P200)","v":0},{"$f":"+LOOKUP(V197,H198:H200,P198:P200)","v":0}]
[null,"[ - ]","[%]","[%]","[ - ]",null,null,null,null,null,null,null,null,null,null,null,"Electrical efficiency of Add-on MCU (HW heating)",null,null,"[%]",{"$f":"+U203*100/U201","v":{"$error":"#DIV/0!"}},{"$f":"+V203*100/V201","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+'Reference Test Data'!B83","v":1},{"$f":"+IF(I198>0,(100*I198/G198),0)","v":0},{"$f":"+IF(SUM(C205:C207)=0, 0, SUM(C205:C207)/COUNTIF(C205:C207,\"<>0\"))","v":0},{"$f":"+IF(D205>0,D205/'Reference Test Data'!H19,1)","v":1},null,null,null,null,null,null,null,null,null,null,null,"Electricity consumption of Add-on MCU",null,null,"[MJ/24h]",{"$f":"+LOOKUP(U197,H198:H200,M198:M200)","v":0},{"$f":"+LOOKUP(V197,H198:H200,M198:M200)","v":0}]
[null,{"$f":"+'Reference Test Data'!B84","v":2},{"$f":"+IF(I199>0,(100*I199/G199),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"HW energy supplied by Reference boiler",null,null,"[MJ/24h]",{"$f":"+LOOKUP(U196,J198:J200,I198:I200)","v":0},{"$f":"+LOOKUP(V196,J198:J200,I198:I200)","v":0}]
[null,{"$f":"+'Reference Test Data'!B85","v":3},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity consumption of Reference boiler",null,null,"[MJ/24h]",{"$f":"+LOOKUP(U206,I198:I200,N198:N200)","v":0},{"$f":"+LOOKUP(V206,I198:I200,N198:N200)","v":0}]
[null,null,null,null,"*if boiler is not called upon to do any hot water production during the testing, then a hot water production boiler efficiency correction factor cannot be created. ",null,null,null,null,null,null,null,null,null,null,null,"HW load fraction slope",null,null,"[ - ]",{"$f":"+IF(V$196<>U$196,((V198-U198)/(V$196-U$196)),0)","v":0}]
[null,null,null,null,"While it is preferred that a boiler correction factor for hot water production is available, in the absence of data we will generously assume it is 1 ( that there needs to be no correction).",null,null,null,null,null,null,null,null,null,null,null,"Thermal efficiency slope",null,null,"[ - ]",{"$f":"+IF(V$196<>U$196,((V202-U202)/(V$196-U$196)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electrical efficiency slope",null,null,"[ - ]",{"$f":"+IF(V$197<>U$197,((V204-U204)/(V$197-U$197)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add-on MCU power consumption slope",null,null,"[ - ]",{"$f":"+IF(V$196<>U$196,((V205-U205)/(V$196-U$196)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boiler power consumption slope",null,null,"[ - ]",{"$f":"+(V207-U207)/(V196-U196)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Table IP_R6B:     System in the target building"]
[null,"Hot water consumption in the building",null,null,"Building Store","Total energy","HW Load from","HW heating","HW energy","Thermal","Electrical ","Fuel","Fuel Consumption by boiler (MJ/24hr)","Electricity","Electricity consumption"]
[null,null,"Energy content",null,"heat losses","required for ","Add-on MCU","supplied by","supplied by","Efficiency of","Efficiency of","Consumption",null,"Generated by ","Add-on MCU","Boiler"]
[null,"Profile",null,null,null,"HW heating",null,"Add-on MCU","boiler","Add-on MCU","Add-on MCU","Add-on MCU",null,"Add-on MCU"]
[null,null,"[kWh/day]","[MJ/day]","[MJ/day]","[MJ/day]","[Fraction]","[MJ/24h]","[MJ/24h]","[%]","[%]","[MJ/24h]",null,"[MJ/24h]","[MJ/24h]","[MJ/24h]"]
[null,{"$f":"+H28","v":"1)  EU_TC"},{"$f":"+H32","v":5.8450000000000006},{"$f":"+C219*3.6","v":21.042000000000002},{"$f":"(H26-'Reference Test Data'!N19)*3600*24/1000000","v":0},{"$f":"+D219+E219","v":21.042000000000002},{"$f":"+IF(F219<=U196,U198,IF(F219>=V196,V198,(U198+(F219-U196)*U208)))","v":{"$error":"#DIV/0!"}},{"$f":"+IF((F219*G219)>U200,U200,(F219*G219))","v":{"$error":"#DIV/0!"}},{"$f":"+F219-H219","v":{"$error":"#DIV/0!"}},{"$f":"+IF(F219<=U196,U202,IF(F219>=V196,V202,(U202+(F219-U196)*U209)))","v":{"$error":"#DIV/0!"}},{"$f":"+IF(H219<=U197,U204,IF(H219>=V197,V204,(U204+(H219-U197)*U210)))","v":{"$error":"#DIV/0!"}},{"$f":"+F219*100/J219","v":{"$error":"#DIV/0!"}},{"$f":"IF(D205>0,I219/D205,0)","v":0},{"$f":"+L219*K219/100","v":{"$error":"#DIV/0!"}},{"$f":"+IF(F219<=U196,U205,IF(F219>=V196,V205,(U205+(F219-U196)*U211)))","v":0},{"$f":"+IF(F219<=U196,U207,IF(F219>=V196,V207,(U207+(F219-U196)*U212)))*$H$18/'Reference Test Data'!J19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"*add losses if external DHW store at installation site is worse than in reference case",null,null,null,null,null,null,null,null,null,null,"*as an approximation multiplied by the factor of the two boilers 'standby' energy uses to get target boiler electricity consumption - use 'standby' as boiler won't be firing for very long even in the largest water draw"]

{"sheet":"Version","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"AMENDMENTS SINCE PUBLICATION"]
[]
[null,"Date","Version","Notes"]
[null,"2018-11-12",1,"First issue."]
[null,"2019-08-07",1.1000000000000001,"Branding Update"]