{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["How to use the SGUE tool","SGUEh water_based HP average","SGUEh water_based HP colder","SGUEh water_based HP warmer","SGUEc_water_based HP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"How to use the SGUE tool","index":0,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[[31,0,31,11],[33,0,33,15],[25,0,25,15],[26,0,26,15],[28,0,28,15],[29,0,29,15],[23,0,23,15],[24,0,24,15],[11,0,11,15],[12,0,12,15],[13,0,13,15],[15,0,15,15],[16,0,16,15],[1,0,1,15],[2,0,2,15],[18,0,18,15],[21,0,21,15],[22,0,22,15],[6,0,6,15],[7,0,7,15],[8,0,8,15],[9,0,9,15],[10,0,10,15]]}
[]
["HEATING Mode: three tabs. One per climate (average, colder, warmer)"]
["COOLING Mode: one tab for average climate."]
[]
["For each tab"]
[]
["From row 1 to 31 : Input data for calculating SGUEh and SGUEc"]
["All coloured cells shall be filled in, because they are used for the calculations."]
["All grey cells are optional to fill in ; they provide information on the unit for which the calculation is made"]
["Some cells shall be filled in by using a selected list of options"]
[]
["Calculate / Reset"]
["To launch the calculations, click on \"Calculate\" button. If the required data for the calculations are missing or wrong, error messages will appear until all data are inserted correctly."]
["To reset all calculations, click on \"Reset\" button: all input data and calculations will be reset"]
[]
["Chek list:"]
["It provides a list of all missing or wrong values. It is updated as soon as the data are filled in."]
[]
["Bin calculation"]
["Cells of columns B to D are blocked and values cannot be changed"]
[]
["Results : Energy efficiency"]
["The final results are: \nHeating: SGUEhnet, SAEFhnet SPERhnet, SGUEh, SAEF, SAEFhon, SPERh, hs according to ErP regulation;\nCooling: SGUEc, SAEFcon, SAEFc."]
[]
["Error messages"]
["In case of error in input data, an error message will appear, once the calculation is launched by clicking on Calculate\""]
["Correct the data and click again on \"Calculate\""]
[]
["Warning messages"]
["In case no data are provided for backup heater and/or for primary energy factors, a warning message appear to advise that default value are used for the calculation"]
[]
["This tool has been developed by POLITECNICO DI MILANO by the use of Microsoft Excel 2013 version 15.0.5233.1000 (64 bit). The tool shall be used by the empowered certification bodies of the Heat Pump Keymark product certification scheme and maybe used by manufacturers in order to calculate their performance in a consistence with the certification bodies. Neither the developer nor the Heat Pump Keymark may be held responsible for any errors that may occur from the use of the tool."]
[]
["Version date: 2020-04-20"]

{"sheet":"SGUEh water_based HP average","index":1,"n_rows":63,"n_cols":30,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,7,1,10],[2,7,2,10],[1,12,1,15],[2,12,2,14],[16,10,16,17],[14,0,14,7],[2,0,2,1],[2,3,2,5],[32,0,32,16],[33,0,34,0],[33,6,33,8],[24,10,24,11],[24,0,24,8],[25,5,25,8]]}
["Calculation of energy efficiency - HEATING - Average climate"]
[null,null,null,null,null,null,null,"Backup heater for bivalent units"]
["Product reference",null,null,"Reference conditions",null,null,null,"Backup heater data - auxiliary gas boiler",null,null,null,null,"Primary energy factors"]
["Manufacturer",null,null,"Climate","average",null,null,null,null,null,"Default values",null,null,"Kw/kW","Default values"]
["Product reference",null,null,"Tdesignh",-10,"°C",null,"ηAux (GCV)",{"$f":"0.85*I6+0.15*I7","v":0},"%",0.8,null," PrimGAS (GCV)",1,1]
["Type of heat pump","water-to-water",null,"Pdesignh",10,"kW ",null,"η30% (GCV)",null,"%",null,null,"Primelec",2.1,2.5,null,null,null,null,null,null,"chek Pdes",{"$f":"IF(OR(E6<0,E6=\"\",NOT(ISNUMBER(E6))),1,\"\")","v":""},null,null,null,{"$f":"IF(E6=\"\",\"Pdesign Missing\",\"\")","v":""},{"$f":"IF(E6<0,\"Pdesign Negative\",\"\")","v":""},{"$f":"IF(NOT(ISNUMBER(E6)),\"Pdesign is not a number\",\"\")","v":""}]
["Operating mode","heating only",null,"Tbiv",-7,"°C",null,"η100% (GCV)",null,"%",null,null,null,null,null,null,null,null,null,null,null,"Chek Tbiv",{"$f":"IF(E7=\"\",1,\"\")","v":""},{"$f":"IF(E7>2,1,\"\")","v":""},{"$f":"IF(E7<E5,1,\"\")","v":""},null,{"$f":"IF(E7=\"\",\"Tbiv Missing\",\"\")","v":""},{"$f":"IF(E7>2,\"Tbiv > 2°C\",\"\")","v":""},{"$f":"IF(E7<E5,\"Tbiv < Tdesign\",\"\")","v":""}]
["Temperature application","55°C",null,"TOL",-10,"°C",null,"eAux",null,"kW",0.02,null,"Chek list:",null,null,null,null,null,null,null,null,"Chek TOL",{"$f":"IF(E8=\"\",1,\"\")","v":""},{"$f":"IF(E8>-7,1,\"\")","v":""},{"$f":"IF(E7<E8,1,\"\")","v":""},null,{"$f":"IF(E8=\"\",\"TOL Missing\",\"\")","v":""},{"$f":"IF(E8>=2,\"TOL >2\",\"\")","v":""},{"$f":"IF(E7<E8,\" TOL>Tbiv \",\"\")","v":""}]
["Water flow","fixed",null,"Heh",2066,"hours",null,null,null,null,null,null,{"$f":"AA6&\" \"&AB6&\" \"&AC6","v":"  "}]
["Water outlet temperature","fixed",null,"Qrefh",{"$f":"IF($W$32>0,\"\",$E$9*$E$6)","v":20660},"kWh",null,null,null,null,null,null,{"$f":"AA7","v":""},"",""]
["Capacity control","fixed",null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,"η30% (GCV)",{"$f":"IF(OR(I6<0,AND(I6<>\"\",NOT(ISNUMBER(I6)))),1,\"\")","v":""},null,null,null,{"$f":"IF(W11=1,\"Incorrect \"&V11,\"\")","v":""}]
["Calorific value of test gas","GCV",null,null,null,null,null,null,null,null,null,null,{"$f":"AA17","v":""},null,null,null,null,null,null,null,null,"η100% (GCV)",{"$f":"IF(OR(I7<0,AND(I7<>\"\",NOT(ISNUMBER(I7)))),1,\"\")","v":""},null,null,null,{"$f":"IF(W12=1,\"Incorrect \"&V12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA28&AB28","v":""},null,null,null,null,null,null,null,null,"eAux",{"$f":"IF(OR(I8<0,AND(I8<>\"\",NOT(ISNUMBER(I8)))),1,\"\")","v":""},null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA11&\"   \"&AA12&\"   \"&AA13","v":"      "},null,null,null,null,null,null,null,null," PrimGAS (GCV)",{"$f":"IF(OR(N5<0,AND(N5<>\"\",NOT(ISNUMBER(N5)))),1,\"\")","v":""},null,null,null,""]
["Performance data",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA14&\"  \"&AA15","v":"  "},null,null,null,null,null,null,null,null,"Primelec",{"$f":"IF(OR(N6<0,AND(N6<>\"\",NOT(ISNUMBER(N6)))),1,\"\")","v":""},null,null,null,""]
["Condition","Outdoor air T°C","Part load ratio (%)","Part Load (kW)","Inlet / outlet water temperatures for testing","Declared Capacity (kW)","Declared GUEd","Declared AEFd"]
["A",-7,{"$f":"(B17-16)/($E$5-16)","v":0.88461538461538458},{"$f":"IF($W$32>0,\"\",$E$6*C17)","v":8.8461538461538467},null,10,3,0.1,null,null,"Energy Efficiency",null,null,null,null,null,null,null,null,null,null,"Chek dati",{"$f":"IF(AND(F17>0,ISNUMBER(F17)),\"\",1)","v":""},"","",null,{"$f":"IF(SUM(W17:Y22)>0,\"Complete performance data with correct values\",\"\")","v":""}]
["B",2,{"$f":"(B18-16)/($E$5-16)","v":0.53846153846153844},5.3846153846153841,null,10,3,0.1,null,null,"SGUEhnet","SAEFhnet","SPERhnet","SGUEh","SAEFon","SAEF","SPERh","ηs",null,null,null,null,"","",""]
["C",7,0.34615384615384615,3.4615384615384617,null,10,3,0.1,null,null,{"$f":"IF($W$32>0,\"\",O63/P63)","v":3.0000000000000004},{"$f":"IF($W$32>0,\"\",O63/Q63)","v":0.10000000000000002},{"$f":"IF($W$32>0,\"\",IF(AND($N$5<>0,$N$6<>0),1/($N$5/$K$19+$N$6/L$19),IF(AND($N$5=\"\",$N$6<>0),1/($O$5/$K$19+$N$6/L$19),IF(AND($N$5<>0,$N$6=\"\"),1/($N$5/$K$19+$O$6/L$19),1/($O$5/$K$19+$O$6/L$19)))))","v":4.6875000000000014E-2},{"$f":"IF($W$32>0,\"\",K63/M63)","v":3.0109463986208378},{"$f":"IF($W$32>0,\"\",K63/N63)","v":9.9868237002615531E-2},{"$f":"IF($W$32>0,\"\",IF($B$7=\"heating only\",E10/(E10/O19+D29+D30+D31),E10/(E10/O19+I29+I30+I31)))","v":9.8043597660703266E-2},{"$f":"IF($W$32>0,\"\",IF(AND($N$5<>0,$N$6<>0),1/($N$5/$N$19+$N$6/P$19),(IF(AND($N$5=\"\",$N$6<>0),1/($O$5/$N$19+$N$6/P$19),IF(AND($N$5<>0,$N$6=\"\"),1/($N$5/$N$19+$O$6/P$19),1/($O$5/$N$19+$O$6/P$19))))))","v":4.5974550767009896E-2},{"$f":"IF($W$32>0,\"\",$Q$19*100-L27-L28)","v":1.5974550767009896},null,null,null,null,"","",""]
["D",12,0.15384615384615385,1.5384615384615385,null,10,3,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["E(TOL)",{"$f":"IF(E8=\"\",\"\",IF(E8<-10,-10,E8))","v":-10},{"$f":"IF(B21=\"\",\"\",(B21-16)/($E$5-16))","v":1},10,null,10,3,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
["F(Tbiv)",{"$f":"IF(E7=\"\",\"\",E7)","v":-7},{"$f":"IF(B22=\"\",\"\",(B22-16)/($E$5-16))","v":0.88461538461538458},8.8461538461538467,null,10,3,0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[]
[]
["Auxiliairy power consumptions",null,null,null,null,null,null,null,null,null,"Correction Factors"]
["Operating modes for heating only",null,null,null,null,"Operating modes for reversible units"]
[null,"Hours","Power input ","P * h",null,null,"Hours","Power input","P * h",null,"F1",3,"%"]
[null,null,"(kW)","(kWh)",null,null,null,"(kW)","(kWh)",null,"F2",{"$f":"IF($B$6=\"ground water-to-water\",2,IF($B$6=\"ground/brine-to-water\",1,0))","v":0},"%",null,null,null,null,null,null,null,null,"Chek Aux.",{"$f":"IF($B$7=\"heating only\",IF(AND(C29>=0,ISNUMBER(C29)),\"\",1),\"\")","v":""},{"$f":"IF($B$7=\"reversible\",IF(AND(H29>=0,ISNUMBER(H29)),\"\",1),\"\")","v":""},null,null,{"$f":"IF(SUM(W28:W30)>0,\"Complete Auxiliary data for heating only\",\"\")","v":""},{"$f":"IF(SUM(X28:X30)>0,\"Complete Auxiliary data for reversible unit\",\"\")","v":""}]
["Thermostat off",178,1,{"$f":"C29*B29","v":178},null,"Thermostat off",178,null,{"$f":"H29*G29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"heating only\",IF(AND(C30>=0,ISNUMBER(C30)),\"\",1),\"\")","v":""},{"$f":"IF($B$7=\"reversible\",IF(AND(H30>=0,ISNUMBER(H30)),\"\",1),\"\")","v":""}]
["Stand by",0,1,{"$f":"C30*B30","v":0},null,"Stand by",0,null,{"$f":"H30*G30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"heating only\",IF(AND(C31>=0,ISNUMBER(C31)),\"\",1),\"\")","v":""},{"$f":"IF($B$7=\"reversible\",IF(AND(H31>=0,ISNUMBER(H31)),\"\",1),\"\")","v":""}]
["Off mode",3672,1,3672,null,"Off mode",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W6:Y30)","v":0}]
["Bin calculation"]
["Condition","Bin ","Outdoor air temp.","Hours ","Part load ratio","Heat demand","Heat load covered by \nthe heat pump",null,null,"Heat load covered by auxiliary heater","Annual heating demand","Annual auxiliary heat","Annual gas input \nwith auxiliary heater","Annual electricity input (auxiliary heater","Annual heat produced by GAHP\nnet","Annual gas \ninput for GAHP \nnet","Annual electricity \ninput for GAHP \nnet"]
[null,"j","Tj","hj",null,"Ph(tj)",null,"GUEh(Tj)","AEFh(Tj)","Paux(Tj)","hj * Ph(Tj)","hj * Paux(Tj)",null,null,"hj *[Ph(Tj)-Paux(Tj)","hj *[Ph(Tj)-Paux(Tj)\n/GUEh(Tj)]","hj *[Ph(Tj)-Paux(Tj)\n/AEFh(Tj)]",null,null,null,null,null,null,null,"P declared","P declared","GUE","GUE","aef","aef"]
[null,"-","°C","h","%","kW","kW","-","-","kW","kWh","kWh","kWh","kWh","kWh","kWh","kWh",null,null,null,null,{"$f":"IF(A36=\"\",0,1)","v":0},0]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C37=$B$21,C37=$E$7),\"E/F\",IF(C37=$B$21,\"E\",IF(C37=$E$7,\"F\",\"\"))))","v":"E"},21,-10,1,{"$f":"(C37-16)/($E$5-16)","v":1},{"$f":"IF($W$32>0,\"\",$E$6*E37)","v":10},{"$f":"IF($W$32>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,F$22,IF($C37=$E$8,F$21,IF($V37=1,$Y37,($C37-$W37)/($X37-$W37)*($Z37-$Y37)+$Y37)))))","v":10},{"$f":"IF($W$32>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,G$22,IF($C37=$E$8,$G$21,IF($V37=1,$AA37,($C37-$W37)/($X37-$W37)*($AB37-$AA37)+$AA37)))))","v":3},{"$f":"IF($W$32>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,H$22,IF($C37=$E$8,H$21,IF($V37=1,$AC37,($C37-$W37)/($X37-$W37)*($AD37-$AC37)+$AC37)))))","v":0.1},{"$f":"IF($W$32>0,\"\",IF(C37<$E$8,F37,IF(C37<$E$7,F37-G37,0)))","v":0},{"$f":"IF($W$32>0,\"\",F37*D37)","v":10},{"$f":"IF($W$32>0,\"\",J37*D37)","v":0},{"$f":"IF($W$32>0,\"\",IF(AND(C37<$E$8,$I$5=0),K37/$K$5,IF(AND(C37<$E$8,$I$5>0),K37/$I$5,IF(AND(C37<$E$7,$I$5=0),D37*(G37/H37+J37/$K$5),IF(AND(C37<$E$7,$I$5>0),D37*(G37/H37+J37/$I$5),K37/H37)))))","v":3.3333333333333335},{"$f":"IF($W$32>0,\"\",IF(AND(C37<$E$8,$I$8=\"\"),K37*$K$8,IF(AND(C37<$E$8,$I$8>0),K37*$I$8,IF(AND(C37<$E$7,$I$8=\"\"),D37*(G37/I37+J37*$K$8),IF(AND(C37<$E$7,$I$8>0),D37*(G37/I37+J37*$I$8),K37/I37)))))","v":100},{"$f":"IF($W$32>0,\"\",IF(C37<$E$8,0,D37*(F37-J37)))","v":10},{"$f":"IF($W$32>0,\"\",IF(C37<$E$8,0,D37*((F37-J37)/H37)))","v":3.3333333333333335},{"$f":"IF($W$32>0,\"\",IF(C37<$E$8,0,D37*((F37-J37)/I37)))","v":100},null,null,null,null,1,{"$f":"IF(V37=0,W36,C37)","v":-10},{"$f":"IF(V37=0,X38,C37)","v":-10},{"$f":"VLOOKUP(W37,$B$17:$H$22,5,FALSE)","v":10},{"$f":"VLOOKUP(X37,$B$17:$H$22,5,FALSE)","v":10},{"$f":"VLOOKUP(W37,$B$17:$H$22,6,FALSE)","v":3},{"$f":"VLOOKUP(X37,$B$17:$H$22,6,FALSE)","v":3},{"$f":"VLOOKUP(W37,$B$17:$H$22,7,FALSE)","v":0.1},{"$f":"VLOOKUP(X37,$B$17:$H$22,7,FALSE)","v":0.1}]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C38=$B$21,C38=$E$7),\"E/F\",IF(C38=$B$21,\"E\",IF(C38=$E$7,\"F\",\"\"))))","v":""},22,-9,25,0.96153846153846156,9.615384615384615,10,3,0.1,-0.38461538461538503,240.38461538461539,-9.6153846153846256,{"$f":"IF($W$32>0,\"\",IF(AND(C38<$E$8,$I$5=0),K38/$K$5,IF(AND(C38<$E$8,$I$5>0),K38/$I$5,IF(AND(C38<$E$7,$I$5=0),D38*(G38/H38+J38/$K$5),IF(AND(C38<$E$7,$I$5>0),D38*(G38/H38+J38/$I$5),K38/H38)))))","v":71.314102564102555},{"$f":"IF($W$32>0,\"\",IF(AND(C38<$E$8,$I$8=\"\"),K38*$K$8,IF(AND(C38<$E$8,$I$8>0),K38*$I$8,IF(AND(C38<$E$7,$I$8=\"\"),D38*(G38/I38+J38*$K$8),IF(AND(C38<$E$7,$I$8>0),D38*(G38/I38+J38*$I$8),K38/I38)))))","v":2499.8076923076924},{"$f":"IF($W$32>0,\"\",IF(C38<$E$8,0,D38*(F38-J38)))","v":250},{"$f":"IF($W$32>0,\"\",IF(C38<$E$8,0,D38*((F38-J38)/H38)))","v":83.333333333333343},{"$f":"IF($W$32>0,\"\",IF(C38<$E$8,0,D38*((F38-J38)/I38)))","v":2500},null,null,null,null,0,-10,-7,10,10,3,3,0.1,0.1]
["",23,-8,23,0.92307692307692313,9.2307692307692317,10,3,0.1,-0.76923076923076827,212.30769230769232,-17.692307692307672,54.55128205128208,2299.6461538461535,230,76.666666666666671,2300,null,null,null,null,0,-10,-7,10,10,3,3,0.1,0.1]
[{"$f":"IF(AND(C40=$B$21,C40=$E$7,C40=-7),\"A/E/F\",IF(C40=$B$21,\"A/E\",IF(C40=$E$7,\"A/F\",\"A\")))","v":"A/F"},24,-7,24,0.88461538461538458,8.8461538461538467,10,3,0.1,0,212.30769230769232,0,70.769230769230774,2123.0769230769229,212.30769230769232,70.769230769230774,2123.0769230769233,null,null,null,null,1,-7,-7,10,10,3,3,0.1,0.1]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C41=$B$21,C41=$E$7),\"E/F\",IF(C41=$B$21,\"E\",IF(C41=$E$7,\"F\",\"\"))))","v":""},25,-6,27,0.84615384615384615,8.4615384615384617,10,3,0.1,0,228.46153846153845,0,76.153846153846146,2284.6153846153843,228.46153846153845,76.15384615384616,2284.6153846153848,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",26,-5,68,0.80769230769230771,8.0769230769230766,10,3,0.1,0,549.23076923076917,0,183.07692307692307,5492.3076923076915,549.23076923076917,183.07692307692307,5492.3076923076915,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",27,-4,91,0.76923076923076927,7.6923076923076925,10,3,0.1,0,700,0,233.33333333333334,7000,700,233.33333333333334,7000,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",28,-3,89,0.73076923076923073,7.3076923076923075,10,3,0.1,0,650.38461538461536,0,216.7948717948718,6503.8461538461534,650.38461538461536,216.79487179487177,6503.8461538461524,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",29,-2,165,0.69230769230769229,6.9230769230769234,10,3,0.1,0,1142.3076923076924,0,380.76923076923077,11423.076923076924,1142.3076923076924,380.76923076923083,11423.076923076922,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",30,-1,173,0.65384615384615385,6.5384615384615383,10,3,0.1,0,1131.1538461538462,0,377.05128205128204,11311.538461538461,1131.1538461538462,377.05128205128204,11311.538461538459,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",31,0,240,0.61538461538461542,6.1538461538461542,10,3,0.1,0,1476.9230769230769,0,492.30769230769232,14769.230769230768,1476.9230769230769,492.30769230769238,14769.23076923077,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
["",32,1,280,0.57692307692307687,5.7692307692307683,10,3,0.1,0,1615.384615384615,0,538.46153846153834,16153.846153846149,1615.384615384615,538.46153846153834,16153.846153846151,null,null,null,null,0,-7,2,10,10,3,3,0.1,0.1]
[{"$f":"IF(AND(C49=$B$21,C49=$E$7,C49=2),\"B/E/F\",IF(C49=$B$21,\"B/E\",IF(C49=$E$7,\"B/F\",\"B\")))","v":"B"},33,2,320,0.53846153846153844,5.3846153846153841,10,3,0.1,0,1723.0769230769229,0,574.35897435897425,17230.769230769227,1723.0769230769229,574.35897435897436,17230.769230769227,null,null,null,null,1,2,2,10,10,3,3,0.1,0.1]
[null,34,3,357,0.5,5,10,3,0.1,0,1785,0,595,17850,1785,595,17850,null,null,null,null,0,2,7,10,10,3,3,0.1,0.1]
[null,35,4,356,0.46153846153846156,4.6153846153846159,10,3,0.1,0,1643.0769230769233,0,547.69230769230774,16430.76923076923,1643.0769230769233,547.69230769230774,16430.76923076923,null,null,null,null,0,2,7,10,10,3,3,0.1,0.1]
[null,36,5,303,0.42307692307692307,4.2307692307692308,10,3,0.1,0,1281.9230769230769,0,427.30769230769232,12819.230769230768,1281.9230769230769,427.30769230769232,12819.23076923077,null,null,null,null,0,2,7,10,10,3,3,0.1,0.1]
[null,37,6,330,0.38461538461538464,3.8461538461538463,10,3,0.1,0,1269.2307692307693,0,423.07692307692309,12692.307692307691,1269.2307692307693,423.07692307692309,12692.307692307691,null,null,null,null,0,2,7,10,10,3,3,0.1,0.1]
["C",38,7,326,0.34615384615384615,3.4615384615384617,10,3,0.1,0,1128.4615384615386,0,376.15384615384619,11284.615384615385,1128.4615384615386,376.15384615384619,11284.615384615385,null,null,null,null,1,7,7,10,10,3,3,0.1,0.1]
[null,39,8,348,0.30769230769230771,3.0769230769230771,10,3,0.1,0,1070.7692307692307,0,356.92307692307691,10707.692307692307,1070.7692307692307,356.92307692307696,10707.692307692309,null,null,null,null,0,7,12,10,10,3,3,0.1,0.1]
[null,40,9,335,0.26923076923076922,2.6923076923076921,10,3,0.1,0,901.92307692307679,0,300.64102564102558,9019.2307692307677,901.92307692307679,300.64102564102564,9019.2307692307677,null,null,null,null,0,7,12,10,10,3,3,0.1,0.1]
[null,41,10,315,0.23076923076923078,2.3076923076923079,10,3,0.1,0,726.92307692307702,0,242.30769230769235,7269.2307692307695,726.92307692307702,242.30769230769232,7269.2307692307695,null,null,null,null,0,7,12,10,10,3,3,0.1,0.1]
[null,42,11,215,0.19230769230769232,1.9230769230769231,10,3,0.1,0,413.46153846153845,0,137.82051282051282,4134.6153846153838,413.46153846153845,137.82051282051285,4134.6153846153848,null,null,null,null,0,7,12,10,10,3,3,0.1,0.1]
["D",43,12,169,0.15384615384615385,1.5384615384615385,10,3,0.1,0,260,0,86.666666666666671,2600,260,86.666666666666671,2600,null,null,null,null,1,12,12,10,10,3,3,0.1,0.1]
[null,44,13,151,0.11538461538461539,1.153846153846154,10,3,0.1,0,174.23076923076925,0,58.076923076923087,1742.3076923076924,174.23076923076925,58.07692307692308,1742.3076923076924,null,null,null,null,0,7,12,10,10,3,3,0.1,0.1]
[null,45,14,105,7.6923076923076927E-2,0.76923076923076927,10,3,0.1,0,80.769230769230774,0,26.923076923076923,807.69230769230774,80.769230769230774,26.923076923076927,807.69230769230774,null,null,null,null,0,{"$f":"IF(V61=0,W60,C61)","v":7},12,10,10,3,3,0.1,0.1]
[null,46,15,74,3.8461538461538464E-2,0.38461538461538464,10,3,0.1,0,28.461538461538463,0,9.4871794871794872,284.61538461538464,28.461538461538463,9.487179487179489,284.61538461538464,null,null,null,null,0,{"$f":"IF(V62=0,W61,C62)","v":7},12,10,10,3,3,0.1,0.1]
[null,null,null,{"$f":"SUM(D36:D62)","v":4910},null,null,null,null,null,null,{"$f":"SUM(K37:K62)","v":20656.153846153848},{"$f":"SUM(L37:L62)","v":-27.307692307692299},{"$f":"SUM(M37:M62)","v":6860.3525641025644},{"$f":"SUM(N37:N62)","v":206834.06923076921},{"$f":"SUM(O37:O62)","v":20683.461538461543},{"$f":"SUM(P37:P62)","v":6894.4871794871797},206834.61538461538]

{"sheet":"SGUEh water_based HP colder","index":2,"n_rows":75,"n_cols":30,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,7,1,10],[1,12,1,15],[2,0,2,1],[2,3,2,5],[2,7,2,10],[2,12,2,14],[32,0,32,16],[33,0,34,0],[33,6,33,8],[14,0,14,7],[16,10,16,17],[24,0,24,8],[24,10,24,11],[25,5,25,8]]}
["Calculation of energy efficiency - HEATING - Average climate"]
[null,null,null,null,null,null,null,"Backup heater for bivalent units"]
["Product reference",null,null,"Reference conditions",null,null,null,"Backup heater data - auxiliary gas boiler",null,null,null,null,"Primary energy factors"]
["Manufacturer",null,null,"Climate","average",null,null,null,null,null,"Default values",null,null,"Kw/kW","Default values"]
["Product reference",null,null,"Tdesignh",-22,"°C",null,"ηAux (GCV)",{"$f":"0.85*I6+0.15*I7","v":0},"%",0.8,null," PrimGAS (GCV)",null,1]
["Type of heat pump","outdoor air-to-water",null,"Pdesignh",null,"kW ",null,"η30% (GCV)",null,"%",null,null,"Primelec",null,2.5,null,null,null,null,null,null,"chek Pdes",{"$f":"IF(OR(E6<0,E6=\"\",NOT(ISNUMBER(E6))),1,\"\")","v":1},null,null,null,{"$f":"IF(E6=\"\",\"Pdesign Missing\",\"\")","v":"Pdesign Missing"},{"$f":"IF(E6<0,\"Pdesign Negative\",\"\")","v":""},{"$f":"IF(NOT(ISNUMBER(E6)),\"Pdesign is not a number\",\"\")","v":"Pdesign is not a number"}]
["Operating mode","reversible",null,"Tbiv",null,"°C",null,"η100% (GCV)",null,"%",null,null,null,null,null,null,null,null,null,null,null,"Chek Tbiv",{"$f":"IF(E7=\"\",1,\"\")","v":1},{"$f":"IF(E7>2,1,\"\")","v":""},{"$f":"IF(E7<E5,1,\"\")","v":""},null,{"$f":"IF(E7=\"\",\"Tbiv Missing\",\"\")","v":"Tbiv Missing"},{"$f":"IF(E7>2,\"Tbiv > -7°C\",\"\")","v":""},{"$f":"IF(E7<E5,\"Tbiv < Tdesign\",\"\")","v":""}]
["Temperature application","55°C",null,"TOL",null,"°C",null,"eAux",null,"kW",0.02,null,"Chek list:",null,null,null,null,null,null,null,null,"Chek TOL",{"$f":"IF(E8=\"\",1,\"\")","v":1},{"$f":"IF(E8>-7,1,\"\")","v":1},{"$f":"IF(E7<E8,1,\"\")","v":""},null,{"$f":"IF(E8=\"\",\"TOL Missing\",\"\")","v":"TOL Missing"},{"$f":"IF(E8=\"\",\"\",IF(E8>-7,\"TOL > -7°C\",\"\"))","v":""},{"$f":"IF(E7<E8,\" TOL>Tbiv \",\"\")","v":""}]
["Water flow","fixed",null,"Heh",2465,"hours",null,null,null,null,null,null,{"$f":"AA6&\" \"&AB6&\" \"&AC6","v":"Pdesign Missing  Pdesign is not a number"}]
["Water outlet temperature","fixed",null,"Qrefh",{"$f":"IF($W$33>0,\"\",$E$9*$E$6)","v":""},"kWh",null,null,null,null,null,null,{"$f":"AA7","v":"Tbiv Missing"},"",""]
["Capacity control","fixed",null,null,null,null,null,null,null,null,null,null,"TOL Missing","","",null,null,null,null,null,null,"η30% (GCV)",{"$f":"IF(OR(I6<0,AND(I6<>\"\",NOT(ISNUMBER(I6)))),1,\"\")","v":""},null,null,null,{"$f":"IF(W11=1,\"Incorrect \"&V11,\"\")","v":""}]
["Calorific value of test gas","GCV",null,null,null,null,null,null,null,null,null,null,{"$f":"AA17","v":"Complete performance data with correct values"},null,null,null,null,null,null,null,null,"η100% (GCV)",{"$f":"IF(OR(I7<0,AND(I7<>\"\",NOT(ISNUMBER(I7)))),1,\"\")","v":""},null,null,null,{"$f":"IF(W12=1,\"Incorrect \"&V12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA28&AB28","v":""},null,null,null,null,null,null,null,null,"eAux",{"$f":"IF(OR(I8<0,AND(I8<>\"\",NOT(ISNUMBER(I8)))),1,\"\")","v":""},null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA11&\"   \"&AA12&\"   \"&AA13","v":"      "},null,null,null,null,null,null,null,null," PrimGAS (GCV)",{"$f":"IF(OR(N5<0,AND(N5<>\"\",NOT(ISNUMBER(N5)))),1,\"\")","v":""},null,null,null,""]
["Performance data",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA14&\"  \"&AA15","v":"  "},null,null,null,null,null,null,null,null,"Primelec",{"$f":"IF(OR(N6<0,AND(N6<>\"\",NOT(ISNUMBER(N6)))),1,\"\")","v":""},null,null,null,""]
["Condition","Outdoor air T°C","Part load ratio (%)","Part Load (kW)","Inlet / outlet water temperatures for testing","Declared Capacity (kW)","Declared GUEd","Declared AEFd"]
["O",-15,{"$f":"(B17-16)/($E$5-16)","v":0.81578947368421051},{"$f":"IF($W$33>0,\"\",$E$6*C17)","v":""},null,null,null,null,null,null,"Energy Efficiency",null,null,null,null,null,null,null,null,null,null,"Chek dati",{"$f":"IF(AND(F17>0,ISNUMBER(F17)),\"\",1)","v":1},1,1,null,{"$f":"IF(SUM(W17:Y23)>0,\"Complete performance data with correct values\",\"\")","v":"Complete performance data with correct values"}]
["A",-7,{"$f":"(B18-16)/($E$5-16)","v":0.60526315789473684},"",null,null,null,null,null,null,"SGUEhnet","SAEFhnet","SPERhnet","SGUEh","SAEFon","SAEF","SPERh","ηs",null,null,null,null,1,1,1]
["B",2,{"$f":"(B19-16)/($E$5-16)","v":0.36842105263157893},"",null,null,null,null,null,null,{"$f":"IF($W$33>0,\"\",O75/P75)","v":""},{"$f":"IF($W$33>0,\"\",O75/Q75)","v":""},{"$f":"IF($W$33>0,\"\",IF(AND($N$5<>0,$N$6<>0),1/($N$5/$K$19+$N$6/L$19),IF(AND($N$5=\"\",$N$6<>0),1/($O$5/$K$19+$N$6/L$19),IF(AND($N$5<>0,$N$6=\"\"),1/($N$5/$K$19+$O$6/L$19),1/($O$5/$K$19+$O$6/L$19)))))","v":""},{"$f":"IF($W$33>0,\"\",K75/M75)","v":""},{"$f":"IF($W$33>0,\"\",K75/N75)","v":""},{"$f":"IF($W$33>0,\"\",IF($B$7=\"heating only\",E10/(E10/O19+D29+D30+D31),E10/(E10/O19+I29+I30+I31)))","v":""},{"$f":"IF($W$33>0,\"\",IF(AND($N$5<>0,$N$6<>0),1/($N$5/$N$19+$N$6/P$19),(IF(AND($N$5=\"\",$N$6<>0),1/($O$5/$N$19+$N$6/P$19),IF(AND($N$5<>0,$N$6=\"\"),1/($N$5/$N$19+$O$6/P$19),1/($O$5/$N$19+$O$6/P$19))))))","v":""},{"$f":"IF($W$33>0,\"\",$Q$19*100-L27-L28)","v":""},null,null,null,null,1,1,1]
["C",7,0.23684210526315788,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
["D",12,0.10526315789473684,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
["E(TOL)",{"$f":"IF(E8=\"\",\"\",IF(E8<-22,-22,E8))","v":""},{"$f":"IF(B22=\"\",\"\",(B22-16)/($E$5-16))","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
["F(Tbiv)",{"$f":"IF(E7=\"\",\"\",E7)","v":""},{"$f":"IF(B23=\"\",\"\",(B23-16)/($E$5-16))","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
[]
["Auxiliairy power consumptions",null,null,null,null,null,null,null,null,null,"Correction Factors"]
["Operating modes for heating only",null,null,null,null,"Operating modes for reversible units"]
[null,"Hours","Power input ","P * h",null,null,"Hours","Power input","P * h",null,"F1",3,"%"]
[null,null,"(kW)","(kWh)",null,null,null,"(kW)","(kWh)",null,"F2",{"$f":"IF($B$6=\"ground water-to-water\",2,IF($B$6=\"ground/brine-to-water\",1,0))","v":0},"%"]
["Thermostat off",106,null,{"$f":"C29*B29","v":0},null,"Thermostat off",106,null,{"$f":"H29*G29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Chek Aux.",{"$f":"IF($B$7=\"heating only\",IF(AND(C29>=0,ISNUMBER(C29)),\"\",1),\"\")","v":""},{"$f":"IF($B$7=\"reversible\",IF(AND(H29>=0,ISNUMBER(H29)),\"\",1),\"\")","v":1},null,null,{"$f":"IF(SUM(W29:W31)>0,\"Complete Auxiliary data for heating only\",\"\")","v":""},{"$f":"IF(SUM(X29:X31)>0,\"Complete Auxiliary data for reversible unit\",\"\")","v":"Complete Auxiliary data for reversible unit"}]
["Stand by",0,null,{"$f":"C30*B30","v":0},null,"Stand by",0,null,{"$f":"H30*G30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"heating only\",IF(AND(C30>=0,ISNUMBER(C30)),\"\",1),\"\")","v":""},{"$f":"IF($B$7=\"reversible\",IF(AND(H30>=0,ISNUMBER(H30)),\"\",1),\"\")","v":1}]
["Off mode",2208,null,0,null,"Off mode",0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"",1]
[]
["Bin calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W6:Y31)","v":28}]
["Condition","Bin ","Outdoor air temp.","Hours ","Part load ratio","Heat demand","Heat load covered by \nthe heat pump",null,null,"Heat load covered by auxiliary heater","Annual heating demand","Annual auxiliary heat","Annual gas input \nwith auxiliary heater","Annual electricity input (auxiliary heater","Annual heat produced by GAHP\nnet","Annual gas \ninput for GAHP \nnet","Annual electricity \ninput for GAHP \nnet"]
[null,"j","Tj","hj",null,"Ph(tj)",null,"GUEh(Tj)","AEFh(Tj)","Paux(Tj)","hj * Ph(Tj)","hj * Paux(Tj)",null,null,"hj *[Ph(Tj)-Paux(Tj)","hj *[Ph(Tj)-Paux(Tj)\n/GUEh(Tj)]","hj *[Ph(Tj)-Paux(Tj)\n/AEFh(Tj)]",null,null,null,null,null,null,null,"P declared","P declared","GUE","GUE","aef","aef"]
[null,"-","°C","h","%","kW","kW","-","-","kW","kWh","kWh","kWh","kWh","kWh","kWh","kWh",null,null,null,null,{"$f":"IF(A36=\"\",0,1)","v":0},0]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C37=$B$22,C37=$E$7),\"E/F\",IF(C37=$B$22,\"E\",IF(C37=$E$7,\"F\",\"\"))))","v":""},9,-22,1,{"$f":"(C37-16)/($E$5-16)","v":1},{"$f":"IF($W$33>0,\"\",$E$6*E37)","v":""},{"$f":"IF($W$33>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,F$23,IF($C37=$E$8,F$22,IF($V37=1,$Y37,($C37-$W37)/($X37-$W37)*($Z37-$Y37)+$Y37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,G$23,IF($C37=$E$8,$G$22,IF($V37=1,$AA37,($C37-$W37)/($X37-$W37)*($AB37-$AA37)+$AA37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,H$23,IF($C37=$E$8,H$22,IF($V37=1,$AC37,($C37-$W37)/($X37-$W37)*($AD37-$AC37)+$AC37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,F37,IF(C37<$E$7,F37-G37,0)))","v":""},{"$f":"IF($W$33>0,\"\",F37*D37)","v":""},{"$f":"IF($W$33>0,\"\",J37*D37)","v":""},{"$f":"IF($W$33>0,\"\",IF(AND(C37<$E$8,$I$5=0),K37/$K$5,IF(AND(C37<$E$8,$I$5>0),K37/$I$5,IF(AND(C37<$E$7,$I$5=0),D37*(G37/H37+J37/$K$5),IF(AND(C37<$E$7,$I$5>0),D37*(G37/H37+J37/$I$5),K37/H37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF(AND(C37<$E$8,$I$8=\"\"),K37*$K$8,IF(AND(C37<$E$8,$I$8>0),K37*$I$8,IF(AND(C37<$E$7,$I$8=\"\"),D37*(G37/I37+J37*$K$8),IF(AND(C37<$E$7,$I$8>0),D37*(G37/I37+J37*$I$8),K37/I37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,0,D37*(F37-J37)))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,0,D37*((F37-J37)/H37)))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,0,D37*((F37-J37)/I37)))","v":""},null,null,null,null,0,{"$f":"IF(V37=0,W36,C37)","v":0},{"$f":"IF(V37=0,X38,C37)","v":-15},{"$f":"VLOOKUP(W37,$B$17:$H$23,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(X37,$B$17:$H$23,5,FALSE)","v":0},{"$f":"VLOOKUP(W37,$B$17:$H$23,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(X37,$B$17:$H$23,6,FALSE)","v":0},{"$f":"VLOOKUP(W37,$B$17:$H$23,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(X37,$B$17:$H$23,7,FALSE)","v":0}]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C38=$B$22,C38=$E$7),\"E/F\",IF(C38=$B$22,\"E\",IF(C38=$E$7,\"F\",\"\"))))","v":""},10,-21,6,0.97368421052631582,"","","","","","","","",{"$f":"IF($W$33>0,\"\",IF(AND(C38<$E$8,$I$8=\"\"),K38*$K$8,IF(AND(C38<$E$8,$I$8>0),K38*$I$8,IF(AND(C38<$E$7,$I$8=\"\"),D38*(G38/I38+J38*$K$8),IF(AND(C38<$E$7,$I$8>0),D38*(G38/I38+J38*$I$8),K38/I38)))))","v":""},"","","",null,null,null,null,0,0,-15,{"$error":"#N/A"},0,{"$error":"#N/A"},0,{"$error":"#N/A"},0]
["",11,-20,13,0.94736842105263153,"","","","","","","","","","","","",null,null,null,null,0,0,-15,{"$error":"#N/A"},0,{"$error":"#N/A"},0,{"$error":"#N/A"},0]
["",12,-19,17,0.92105263157894735,"","","","","","","","","","","","",null,null,null,null,0,0,-15,{"$error":"#N/A"},0,{"$error":"#N/A"},0,{"$error":"#N/A"},0]
["",13,-18,19,0.89473684210526316,"","","","","","","","","","","","",null,null,null,null,0,0,-15,{"$error":"#N/A"},0,{"$error":"#N/A"},0,{"$error":"#N/A"},0]
["",14,-17,26,0.86842105263157898,"","","","","","","","","","","","",null,null,null,null,0,0,-15,{"$error":"#N/A"},0,{"$error":"#N/A"},0,{"$error":"#N/A"},0]
["",15,-16,39,0.84210526315789469,"","","","","","","","","","","","",null,null,null,null,0,0,-15,{"$error":"#N/A"},0,{"$error":"#N/A"},0,{"$error":"#N/A"},0]
[{"$f":"IF(AND(C44=$B$22,C44=$E$7,C44=-15),\"O/E/F\",IF(C44=$B$22,\"O/E\",IF(C44=$E$7,\"O/F\",\"O\")))","v":"O"},16,-15,41,0.81578947368421051,"","","","","","","","","","","","",null,null,null,null,1,-15,-15,0,0,0,0,0,0]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C45=$B$22,C45=$E$7),\"E/F\",IF(C45=$B$22,\"E\",IF(C45=$E$7,\"F\",\"\"))))","v":""},17,-14,35,0.78947368421052633,"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),\"\",IF(AND(C46=$B$22,C46=$E$7),\"E/F\",IF(C46=$B$22,\"E\",IF(C46=$E$7,\"F\",\"\"))))","v":""},18,-13,52,0.76315789473684215,"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
["",19,-12,37,0.73684210526315785,"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
["",20,-11,41,0.71052631578947367,"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
["",21,-10,43,{"$f":"(C49-16)/($E$5-16)","v":0.68421052631578949},"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
["",22,-9,54,{"$f":"(C50-16)/($E$5-16)","v":0.65789473684210531},"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
["",23,-8,90,0.63157894736842102,"","","","","","","","","","","","",null,null,null,null,0,-15,-7,0,0,0,0,0,0]
[{"$f":"IF(AND(C52=$B$22,C52=$E$7,C52=-7),\"A/E/F\",IF(C52=$B$22,\"A/E\",IF(C52=$E$7,\"A/F\",\"A\")))","v":"A"},24,-7,125,0.60526315789473684,"","","","","","","","","","","","",null,null,null,null,1,-7,-7,0,0,0,0,0,0]
[null,25,-6,169,0.57894736842105265,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,26,-5,195,0.55263157894736847,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,27,-4,278,0.52631578947368418,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,28,-3,306,0.5,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,29,-2,454,0.47368421052631576,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,30,-1,385,0.44736842105263158,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,31,0,490,0.42105263157894735,"","","","","","","","","","","","",null,null,null,null,0,-7,2,0,0,0,0,0,0]
[null,32,1,533,0.39473684210526316,"","","","","","","","","","","","",null,null,null,null,0,7,2,0,0,0,0,0,0]
["B",33,2,380,0.36842105263157893,"","","","","","","","","","","","",null,null,null,null,1,{"$f":"IF(V61=0,W60,C61)","v":2},2,0,0,0,0,0,0]
[null,34,3,228,0.34210526315789475,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
[null,35,4,261,0.31578947368421051,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
[null,36,5,279,0.28947368421052633,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
[null,37,6,229,0.26315789473684209,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
["C",38,7,269,0.23684210526315788,"","","","","","","","","","","","",null,null,null,null,1,7,7,0,0,0,0,0,0]
[null,39,8,233,0.21052631578947367,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,40,9,230,0.18421052631578946,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,41,10,243,0.15789473684210525,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,42,11,191,0.13157894736842105,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
["D",43,12,146,0.10526315789473684,"","","","","","","","","","","","",null,null,null,null,1,12,12,0,0,0,0,0,0]
[null,44,13,150,7.8947368421052627E-2,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,45,14,97,5.2631578947368418E-2,"","","","","","","","","","","","",null,null,null,null,0,{"$f":"IF(V73=0,W72,C73)","v":7},12,0,0,0,0,0,0]
[null,46,15,61,2.6315789473684209E-2,"","","","","","","","","","","","",null,null,null,null,0,{"$f":"IF(V74=0,W73,C74)","v":7},12,0,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D37:D74)","v":6446},null,null,null,null,null,null,{"$f":"SUM(K49:K74)","v":0},{"$f":"SUM(L49:L74)","v":0},{"$f":"SUM(M49:M74)","v":0},{"$f":"SUM(N49:N74)","v":0},{"$f":"SUM(O49:O74)","v":0},{"$f":"SUM(P49:P74)","v":0},0]

{"sheet":"SGUEh water_based HP warmer","index":3,"n_rows":51,"n_cols":30,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,7,1,10],[1,12,1,15],[2,0,2,1],[2,3,2,5],[2,7,2,10],[2,12,2,14],[32,0,32,16],[33,0,34,0],[33,6,33,8],[14,0,14,7],[16,10,16,17],[24,0,24,8],[24,10,24,11],[25,5,25,8]]}
["Calculation of energy efficiency - HEATING - Average climate"]
[null,null,null,null,null,null,null,"Backup heater for bivalent units"]
["Product reference",null,null,"Reference conditions",null,null,null,"Backup heater data - auxiliary gas boiler",null,null,null,null,"Primary energy factors"]
["Manufacturer",null,null,"Climate","average",null,null,null,null,null,"Default values",null,null,"Kw/kW","Default values"]
["Product reference",null,null,"Tdesignh",2,"°C",null,"ηAux (GCV)",{"$f":"0.85*I6+0.15*I7","v":0},"%",0.8,null," PrimGAS (GCV)",null,1]
["Type of heat pump","outdoor air-to-water",null,"Pdesignh",null,"kW ",null,"η30% (GCV)",null,"%",null,null,"Primelec",null,2.5,null,null,null,null,null,null,"chek Pdes",{"$f":"IF(OR(E6<0,E6=\"\",NOT(ISNUMBER(E6))),1,\"\")","v":1},null,null,null,{"$f":"IF(E6=\"\",\"Pdesign Missing\",\"\")","v":"Pdesign Missing"},{"$f":"IF(E6<0,\"Pdesign Negative\",\"\")","v":""},{"$f":"IF(NOT(ISNUMBER(E6)),\"Pdesign is not a number\",\"\")","v":"Pdesign is not a number"}]
["Operating mode","heating only",null,"Tbiv",null,"°C",null,"η100% (GCV)",null,"%",null,null,null,null,null,null,null,null,null,null,null,"Chek Tbiv",{"$f":"IF(E7=\"\",1,\"\")","v":1},{"$f":"IF(E7>7,1,\"\")","v":""},{"$f":"IF(E7<E5,1,\"\")","v":1},null,{"$f":"IF(E7=\"\",\"Tbiv Missing\",\"\")","v":"Tbiv Missing"},{"$f":"IF(E7>7,\"Tbiv > 7°C\",\"\")","v":""},{"$f":"IF(E7<E5,\"Tbiv < Tdesign\",\"\")","v":"Tbiv < Tdesign"}]
["Temperature application","55°C",null,"TOL",null,"°C",null,"eAux",null,"kW",0.02,null,"Chek list:",null,null,null,null,null,null,null,null,"Chek TOL",{"$f":"IF(E8=\"\",1,\"\")","v":1},{"$f":"IF(E8>7,1,\"\")","v":""},{"$f":"IF(E7<E8,1,\"\")","v":""},null,{"$f":"IF(E8=\"\",\"TOL Missing\",\"\")","v":"TOL Missing"},{"$f":"IF(E8>7,\"TOL > 7°C\",\"\")","v":""},{"$f":"IF(E7<E8,\" TOL>Tbiv \",\"\")","v":""}]
["Water flow","fixed",null,"Heh",1366,"hours",null,null,null,null,null,null,{"$f":"AA6&\" \"&AB6&\" \"&AC6","v":"Pdesign Missing  Pdesign is not a number"}]
["Water outlet temperature","fixed",null,"Qrefh",{"$f":"$E$9*$E$6","v":0},"kWh",null,null,null,null,null,null,{"$f":"AA7","v":"Tbiv Missing"},"","Tbiv < Tdesign"]
["Capacity control","fixed",null,null,null,null,null,null,null,null,null,null,"TOL Missing","","",null,null,null,null,null,null,"η30% (GCV)",{"$f":"IF(OR(I6<0,AND(I6<>\"\",NOT(ISNUMBER(I6)))),1,\"\")","v":""},null,null,null,{"$f":"IF(W11=1,\"Incorrect \"&V11,\"\")","v":""}]
["Calorific value of test gas","GCV",null,null,null,null,null,null,null,null,null,null,{"$f":"AA18","v":"Complete performance data with correct values"},null,null,null,null,null,null,null,null,"η100% (GCV)",{"$f":"IF(OR(I7<0,AND(I7<>\"\",NOT(ISNUMBER(I7)))),1,\"\")","v":""},null,null,null,{"$f":"IF(W12=1,\"Incorrect \"&V12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA29&AB29","v":"Complete Auxiliary data for heating only"},null,null,null,null,null,null,null,null,"eAux",{"$f":"IF(OR(I8<0,AND(I8<>\"\",NOT(ISNUMBER(I8)))),1,\"\")","v":""},null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA11&\"   \"&AA12&\"   \"&AA13","v":"      "},null,null,null,null,null,null,null,null," PrimGAS (GCV)",{"$f":"IF(OR(N5<0,AND(N5<>\"\",NOT(ISNUMBER(N5)))),1,\"\")","v":""},null,null,null,""]
["Performance data",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA14&\"  \"&AA15","v":"  "},null,null,null,null,null,null,null,null,"Primelec",{"$f":"IF(OR(N6<0,AND(N6<>\"\",NOT(ISNUMBER(N6)))),1,\"\")","v":""},null,null,null,""]
["Condition","Outdoor air T°C","Part load ratio (%)","Part Load (kW)","Inlet / outlet water temperatures for testing","Declared Capacity (kW)","Declared GUEd","Declared AEFd"]
["A",-7,"NA","NA",null,"NA","NA","NA",null,null,"Energy Efficiency",null,null,null,null,null,null,null,null,null,null,"Chek dati"]
["B",2,{"$f":"(B18-16)/($E$5-16)","v":1},{"$f":"IF($W$33>0,\"\",$E$6*C18)","v":""},null,null,null,null,null,null,"SGUEhnet","SAEFhnet","SPERhnet","SGUEh","SAEFon","SAEF","SPERh","ηs",null,null,null,null,{"$f":"IF(AND(F18>0,ISNUMBER(F18)),\"\",1)","v":1},1,1,null,{"$f":"IF(SUM(W18:Y22)>0,\"Complete performance data with correct values\",\"\")","v":"Complete performance data with correct values"}]
["C",7,0.6428571428571429,{"$f":"IF($W$33>0,\"\",$E$6*C19)","v":""},null,null,null,null,null,null,{"$f":"IF($W$33>0,\"\",O51/P51)","v":""},{"$f":"IF($W$33>0,\"\",O51/Q51)","v":""},{"$f":"IF($W$33>0,\"\",IF(AND($N$5<>0,$N$6<>0),1/($N$5/$K$19+$N$6/L$19),IF(AND($N$5=\"\",$N$6<>0),1/($O$5/$K$19+$N$6/L$19),IF(AND($N$5<>0,$N$6=\"\"),1/($N$5/$K$19+$O$6/L$19),1/($O$5/$K$19+$O$6/L$19)))))","v":""},{"$f":"IF($W$33>0,\"\",K51/M51)","v":""},{"$f":"IF($W$33>0,\"\",K51/N51)","v":""},{"$f":"IF($W$33>0,\"\",IF($B$7=\"heating only\",E10/(E10/O19+D29+D30+D31),E10/(E10/O19+I29+I30+I31)))","v":""},{"$f":"IF($W$33>0,\"\",IF(AND($N$5<>0,$N$6<>0),1/($N$5/$N$19+$N$6/P$19),(IF(AND($N$5=\"\",$N$6<>0),1/($O$5/$N$19+$N$6/P$19),IF(AND($N$5<>0,$N$6=\"\"),1/($N$5/$N$19+$O$6/P$19),1/($O$5/$N$19+$O$6/P$19))))))","v":""},{"$f":"IF($W$33>0,\"\",$Q$19*100-L27-L28)","v":""},null,null,null,null,1,1,1]
["D",12,0.2857142857142857,{"$f":"IF($W$33>0,\"\",$E$6*C20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
["E(TOL)",{"$f":"IF(E8=\"\",\"\",IF(E8<2,2,E8))","v":""},{"$f":"IF(B21=\"\",\"\",(B21-16)/($E$5-16))","v":""},{"$f":"IF($W$33>0,\"\",$E$6*C21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
["F(Tbiv)",{"$f":"IF(E7=\"\",\"\",E7)","v":""},{"$f":"IF(B22=\"\",\"\",(B22-16)/($E$5-16))","v":""},{"$f":"IF($W$33>0,\"\",$E$6*C22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
[]
[]
["Auxiliairy power consumptions",null,null,null,null,null,null,null,null,null,"Correction Factors"]
["Operating modes for heating only",null,null,null,null,"Operating modes for reversible units"]
[null,"Hours","Power input ","P * h",null,null,"Hours","Power input","P * h",null,"F1",3,"%"]
[null,null,"(kW)","(kWh)",null,null,null,"(kW)","(kWh)",null,"F2",{"$f":"IF($B$6=\"ground water-to-water\",2,IF($B$6=\"ground/brine-to-water\",1,0))","v":0},"%"]
["Thermostat off",754,null,{"$f":"C29*B29","v":0},null,"Thermostat off",754,null,{"$f":"H29*G29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Chek Aux.",{"$f":"IF($B$7=\"heating only\",IF(AND(C29>=0,ISNUMBER(C29)),\"\",1),\"\")","v":1},{"$f":"IF($B$7=\"reversible\",IF(AND(H29>=0,ISNUMBER(H29)),\"\",1),\"\")","v":""},null,null,{"$f":"IF(SUM(W29:W31)>0,\"Complete Auxiliary data for heating only\",\"\")","v":"Complete Auxiliary data for heating only"},{"$f":"IF(SUM(X29:X31)>0,\"Complete Auxiliary data for reversible unit\",\"\")","v":""}]
["Stand by",0,null,{"$f":"C30*B30","v":0},null,"Stand by",0,null,{"$f":"H30*G30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"heating only\",IF(AND(C30>=0,ISNUMBER(C30)),\"\",1),\"\")","v":1},{"$f":"IF($B$7=\"reversible\",IF(AND(H30>=0,ISNUMBER(H30)),\"\",1),\"\")","v":""}]
["Off mode",4416,null,0,null,"Off mode",0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"heating only\",IF(AND(C31>=0,ISNUMBER(C31)),\"\",1),\"\")","v":1},{"$f":"IF($B$7=\"reversible\",IF(AND(H31>=0,ISNUMBER(H31)),\"\",1),\"\")","v":""}]
[]
["Bin calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W6:Y31)","v":22}]
["Condition","Bin ","Outdoor air temp.","Hours ","Part load ratio","Heat demand","Heat load covered by \nthe heat pump",null,null,"Heat load covered by auxiliary heater","Annual heating demand","Annual auxiliary heat","Annual gas input \nwith auxiliary heater","Annual electricity input (auxiliary heater","Annual heat produced by GAHP\nnet","Annual gas \ninput for GAHP \nnet","Annual electricity \ninput for GAHP \nnet"]
[null,"j","Tj","hj",null,"Ph(tj)",null,"GUEh(Tj)","AEFh(Tj)","Paux(Tj)","hj * Ph(Tj)","hj * Paux(Tj)",null,null,"hj *[Ph(Tj)-Paux(Tj)","hj *[Ph(Tj)-Paux(Tj)\n/GUEh(Tj)]","hj *[Ph(Tj)-Paux(Tj)\n/AEFh(Tj)]",null,null,null,null,null,null,null,"P declared","P declared","GUE","GUE","aef","aef"]
[null,"-","°C","h","%","kW","kW","-","-","kW","kWh","kWh","kWh","kWh","kWh","kWh","kWh",null,null,null,null,0,0]
[{"$f":"IF(AND(C37=$B$21,C37=$E$7,C37=2),\"B/E/F\",IF(C37=$B$21,\"B/E\",IF(C37=$E$7,\"B/F\",\"B\")))","v":"B"},33,2,3,{"$f":"(C37-16)/($E$5-16)","v":1},{"$f":"IF($W$33>0,\"\",$E$6*E37)","v":""},{"$f":"IF($W$33>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,F$22,IF($C37=$E$8,F$21,IF($V37=1,$Y37,($C37-$W37)/($X37-$W37)*($Z37-$Y37)+$Y37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,G$22,IF($C37=$E$8,$G$21,IF($V37=1,$AA37,($C37-$W37)/($X37-$W37)*($AB37-$AA37)+$AA37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF($C37<$E$8,0,IF($C37=$E$7,H$22,IF($C37=$E$8,H$21,IF($V37=1,$AC37,($C37-$W37)/($X37-$W37)*($AD37-$AC37)+$AC37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,F37,IF(C37<$E$7,F37-G37,0)))","v":""},{"$f":"IF($W$33>0,\"\",F37*D37)","v":""},{"$f":"IF($W$33>0,\"\",J37*D37)","v":""},{"$f":"IF($W$33>0,\"\",IF(AND(C37<$E$8,$I$5=0),K37/$K$5,IF(AND(C37<$E$8,$I$5>0),K37/$I$5,IF(AND(C37<$E$7,$I$5=0),D37*(G37/H37+J37/$K$5),IF(AND(C37<$E$7,$I$5>0),D37*(G37/H37+J37/$I$5),K37/H37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF(AND(C37<$E$8,$I$8=\"\"),K37*$K$8,IF(AND(C37<$E$8,$I$8>0),K37*$I$8,IF(AND(C37<$E$7,$I$8=\"\"),D37*(G37/I37+J37*$K$8),IF(AND(C37<$E$7,$I$8>0),D37*(G37/I37+J37*$I$8),K37/I37)))))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,0,D37*(F37-J37)))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,0,D37*((F37-J37)/H37)))","v":""},{"$f":"IF($W$33>0,\"\",IF(C37<$E$8,0,D37*((F37-J37)/I37)))","v":""},null,null,null,null,{"$f":"IF(A37=\"\",0,1)","v":1},{"$f":"IF(V37=0,W36,C37)","v":2},{"$f":"IF(V37=0,X38,C37)","v":2},{"$f":"VLOOKUP(W37,$B$18:$H$22,5,FALSE)","v":0},{"$f":"VLOOKUP(X37,$B$18:$H$22,5,FALSE)","v":0},{"$f":"VLOOKUP(W37,$B$18:$H$22,6,FALSE)","v":0},{"$f":"VLOOKUP(X37,$B$18:$H$22,6,FALSE)","v":0},{"$f":"VLOOKUP(W37,$B$18:$H$22,7,FALSE)","v":0},{"$f":"VLOOKUP(X37,$B$18:$H$22,7,FALSE)","v":0}]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),IF(AND(C38=$B$21,C38=$E$7),\"E/F\",IF(C38=$B$21,\"E\",IF(C38=$E$7,\"F\",\"\"))))","v":""},34,3,22,0.9285714285714286,"","","","","","","","",{"$f":"IF($W$33>0,\"\",IF(AND(C38<$E$8,$I$8=\"\"),K38*$K$8,IF(AND(C38<$E$8,$I$8>0),K38*$I$8,IF(AND(C38<$E$7,$I$8=\"\"),D38*(G38/I38+J38*$K$8),IF(AND(C38<$E$7,$I$8>0),D38*(G38/I38+J38*$I$8),K38/I38)))))","v":""},"","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
[{"$f":"IF(OR($E$7=\"\",$E$8=\"\"),IF(AND(C39=$B$21,C39=$E$7),\"E/F\",IF(C39=$B$21,\"E\",IF(C39=$E$7,\"F\",\"\"))))","v":""},35,4,63,0.8571428571428571,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
["",36,5,63,0.7857142857142857,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
["",37,6,175,0.7142857142857143,"","","","","","","","","","","","",null,null,null,null,0,2,7,0,0,0,0,0,0]
[{"$f":"IF(AND(C42=$B$21,C42=$E$7,C42=7),\"C/E/F\",IF(C42=$B$21,\"C/E\",IF(C42=$E$7,\"C/F\",\"C\")))","v":"C"},38,7,162,0.6428571428571429,"","","","","","","","","","","","",null,null,null,null,1,7,7,0,0,0,0,0,0]
[null,39,8,259,0.5714285714285714,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,40,9,360,0.5,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,41,10,428,0.42857142857142855,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,42,11,430,0.35714285714285715,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
["D",43,12,503,0.2857142857142857,"","","","","","","","","","","","",null,null,null,null,1,12,12,0,0,0,0,0,0]
[null,44,13,444,0.21428571428571427,"","","","","","","","","","","","",null,null,null,null,0,7,12,0,0,0,0,0,0]
[null,45,14,384,0.14285714285714285,"","","","","","","","","","","","",null,null,null,null,0,{"$f":"IF(V49=0,W48,C49)","v":7},12,0,0,0,0,0,0]
[null,46,15,294,7.1428571428571425E-2,"","","","","","","","","","","","",null,null,null,null,0,{"$f":"IF(V50=0,W49,C50)","v":7},12,0,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D37:D50)","v":3590},null,null,null,null,null,null,{"$f":"SUM(K37:K50)","v":0},0,0,0,0,0,0]

{"sheet":"SGUEc_water_based HP","index":4,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[10,10,10,12],[33,0,34,0],[33,6,33,8],[32,0,32,11],[14,0,14,7],[24,0,24,8],[25,5,25,8],[11,10,11,12],[12,10,12,12],[13,10,13,12],[14,10,14,12],[16,10,16,12],[7,8,7,11],[8,8,8,11],[1,8,1,11],[2,0,2,1],[2,3,2,5],[2,8,2,11],[3,8,3,11],[4,8,4,11],[5,8,5,11],[6,8,6,11]]}
["Calculation of energy efficiency - COOLING - Average climate"]
[]
["Product reference",null,null,"Reference conditions"]
["Manufacturer",null,null,"Climate","average"]
["Product reference",null,null,"Tdesignh",35,"°C"]
["Type of heat pump","outdoor air-to-water",null,"Pdesignh",null,"kW ",null,null,null,null,null,null,null,null,null,null,null,"chek Pdes",{"$f":"IF(OR(E6<0,E6=\"\",NOT(ISNUMBER(E6))),1,\"\")","v":1},null,null,null,{"$f":"IF(E6=\"\",\"Pdesignc Missing\",\"\")","v":"Pdesignc Missing"},{"$f":"IF(E6<0,\"Pdesign Negative\",\"\")","v":""},{"$f":"IF(NOT(ISNUMBER(E6)),\"Pdesignc is not a number\",\"\")","v":"Pdesignc is not a number"}]
["Operating mode","cooling only",null,"Hec",350,"hours"]
["Temperature application","23/18°C",null,"Qrefh",{"$f":"IF($S$33>0,\"\",$E$7*$E$6)","v":""},"kWh"]
["Water outlet temperature","fixed"]
["Capacity control","fixed",null,null,null,null,null,null,null,null,"Chek list:"]
["Calorific value of test gas","GCV",null,null,null,null,null,null,null,null,{"$f":"W6&X6&\"   \"&Y6","v":"Pdesignc Missing   Pdesignc is not a number"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"W17","v":"Complete performance data with correct value"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"W29&X29","v":"Complete Auxiliary data for cooling only"}]
[]
["Performance data"]
["Condition","Outdoor air T°C","Part load ratio (%)","Part Load (kW)","Inlet / outlet water temperatures for testing","Declared Capacity (kW)","Declared GUEd","Declared AEFd"]
["A",35,{"$f":"(B17-16)/($E$5-16)","v":1},{"$f":"IF(S33>0,\"\",$E$6*C17)","v":""},null,null,null,null,null,null,"Energy Efficiency",null,null,null,null,null,null,"Chek dati",{"$f":"IF(AND(F17>0,ISNUMBER(F17)),\"\",1)","v":1},1,1,null,{"$f":"IF(SUM(S17:U20)>0,\"Complete performance data with correct value\",\"\")","v":"Complete performance data with correct value"}]
["B",30,{"$f":"(B18-16)/($E$5-16)","v":0.73684210526315785},{"$f":"IF(S33>0,\"\",$E$6*C18)","v":""},null,null,null,null,null,null,"SGUEc","SAEFcon","SAEFc",null,null,null,null,null,1,1,1]
["C",25,{"$f":"(B19-16)/($E$5-16)","v":0.47368421052631576},{"$f":"IF(S33>0,\"\",$E$6*C19)","v":""},null,null,null,null,null,null,{"$f":"IF(S33>0,\"\",J61/K61)","v":""},{"$f":"IF(S33>0,\"\",J61/L61)","v":""},{"$f":"IF(S33>0,\"\",IF($B$7=\"cooling only\",E8/(E8/L19+D29+D30+D31),E8/(E8/L19+I29+I30+I31)))","v":""},null,null,null,null,null,1,1,1]
["D",20,{"$f":"(B20-16)/($E$5-16)","v":0.21052631578947367},{"$f":"IF(S33>0,\"\",$E$6*C20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1]
[]
[]
[]
[]
["Auxiliairy power consumptions"]
["Operating modes for cooling only",null,null,null,null,"Operating modes for reversible units"]
[null,"Hours","Power input ","P * h",null,null,"Hours","Power input","P * h"]
[null,null,"(kW)","(kWh)",null,null,null,"(kW)","(kWh)"]
["Thermostat off",221,null,{"$f":"C29*B29","v":0},null,"Thermostat off",221,null,{"$f":"H29*G29","v":0},null,null,null,null,null,null,null,null,"Chek Aux.",{"$f":"IF($B$7=\"cooling only\",IF(AND(C29>=0,ISNUMBER(C29)),\"\",1),\"\")","v":1},{"$f":"IF($B$7=\"reversible\",IF(AND(H29>=0,ISNUMBER(H29)),\"\",1),\"\")","v":""},null,null,{"$f":"IF(SUM(S29:S31)>0,\"Complete Auxiliary data for cooling only\",\"\")","v":"Complete Auxiliary data for cooling only"},{"$f":"IF(SUM(T29:T31)>0,\"Complete Auxiliary data for reversible unit\",\"\")","v":""}]
["Stand by",2142,null,{"$f":"C30*B30","v":0},null,"Stand by",2142,null,{"$f":"H30*G30","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"cooling only\",IF(AND(C30>=0,ISNUMBER(C30)),\"\",1),\"\")","v":1},{"$f":"IF($B$7=\"reversible\",IF(AND(H30>=0,ISNUMBER(H30)),\"\",1),\"\")","v":""}]
["Off mode",5088,null,{"$f":"C31*B31","v":0},null,"Off mode",0,null,{"$f":"H31*G31","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF($B$7=\"cooling only\",IF(AND(C31>=0,ISNUMBER(C31)),\"\",1),\"\")","v":1},{"$f":"IF($B$7=\"reversible\",IF(AND(H31>=0,ISNUMBER(H31)),\"\",1),\"\")","v":""}]
[]
["Bin calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S6:U31)","v":16}]
["Condition","Bin ","Outdoor air temp.","Hours ","Part load ratio","Cooling demand","Cooling load covered by \nthe heat pump",null,null,"Annual cooling demand","Annual gas \ninput ","Annual electricity \ninput f"]
[null,"j","Tj","hj",null,"Pc(tj)",null,"GUEc(Tj)","AEFc(Tj)","hj * fon*Pc(Tj)",null,null,null,null,null,null,null,null,null,"P declared","P declared","GUE","GUE","aef","aef"]
[null,"-","°C","h","%","kW","kW","-","-","kWh","kWh","kWh",null,null,null,null,{"$f":"IF(A36=\"\",0,1)","v":0},0]
[null,1,17,205,{"$f":"(C37-16)/($E$5-16)","v":5.2631578947368418E-2},{"$f":"IF($S$33>0,\"\",$E$6*E37)","v":""},{"$f":"IF($S$33>0,\"\",G$40)","v":""},"","",{"$f":"IF($S$33>0,\"\",F37*D37*(350/954))","v":""},{"$f":"IF($S$33>0,\"\",($J37/H37))","v":""},{"$f":"IF($S$33>0,\"\",($J37/I37))","v":""},null,null,null,null,0,20,{"$f":"IF(Q37=0,S38,C37)","v":25},{"$f":"VLOOKUP(R37,$B$17:$H$20,5,FALSE)","v":0},0,{"$f":"VLOOKUP(R37,$B$17:$H$20,6,FALSE)","v":0},0,{"$f":"VLOOKUP(R37,$B$17:$H$20,7,FALSE)","v":0},0]
[null,{"$f":"B37+1","v":2},{"$f":"C37+1","v":18},227,{"$f":"(C38-16)/($E$5-16)","v":0.10526315789473684},"","","","",{"$f":"IF($S$33>0,\"\",F38*D38*(350/954))","v":""},"","",null,null,null,null,0,20,{"$f":"IF(Q38=0,S39,C38)","v":25},0,0,0,0,0,0]
[null,{"$f":"B38+1","v":3},19,225,0.15789473684210525,"","","","","","","",null,null,null,null,0,20,{"$f":"IF(Q39=0,S40,C39)","v":25},0,0,0,0,0,0]
["D",4,20,225,{"$f":"(C40-16)/($E$5-16)","v":0.21052631578947367},"",{"$f":"IF($S$33>0,\"\",IF($Q40=1,$T40,($C40-$R40)/($S40-$R40)*($U40-$T40)+$T40))","v":""},{"$f":"IF($S$33>0,\"\",IF($Q40=1,$V40,($C40-$R40)/($S40-$R40)*($W40-$V40)+$V40))","v":""},{"$f":"IF($S$33>0,\"\",IF($Q40=1,$X40,($C40-$R40)/($S40-$R40)*($Y40-$X40)+$X40))","v":""},"","","",null,null,null,null,1,{"$f":"IF(Q40=0,R39,C40)","v":20},25,0,0,0,0,0,0]
[null,5,21,216,0.26315789473684209,"","","","","",{"$f":"IF($S$33>0,\"\",($J41/H41))","v":""},"",null,null,null,null,0,20,{"$f":"IF(Q41=0,S42,C41)","v":25},0,0,0,0,0,0]
[null,6,22,215,0.31578947368421051,"","","","","","","",null,null,null,null,0,20,25,0,0,0,0,0,0]
[null,7,23,218,0.36842105263157893,"","","","","","","",null,null,null,null,0,20,25,0,0,0,0,0,0]
[null,8,24,197,0.42105263157894735,"","","","","","","",null,null,null,null,0,20,25,0,0,0,0,0,0]
["C",9,25,178,0.47368421052631576,"","","","","","","",null,null,null,null,1,25,25,0,0,0,0,0,0]
[null,10,26,158,0.52631578947368418,"","","","","","","",null,null,null,null,0,25,30,0,0,0,0,0,0]
[null,11,27,137,0.57894736842105265,"","","","","","","",null,null,null,null,0,25,30,0,0,0,0,0,0]
[null,12,28,109,0.63157894736842102,"","","","","","","",null,null,null,null,0,25,30,0,0,0,0,0,0]
[null,13,29,88,0.68421052631578949,"","","","","","","",null,null,null,null,0,25,30,0,0,0,0,0,0]
["B",14,30,63,0.73684210526315785,"","","","","","","",null,null,null,null,1,30,30,0,0,0,0,0,0]
[null,15,31,39,0.78947368421052633,"","","","","","","",null,null,null,null,0,30,35,0,0,0,0,0,0]
[null,16,32,31,0.84210526315789469,"","","","","","","",null,null,null,null,0,30,35,0,0,0,0,0,0]
[null,17,33,24,0.89473684210526316,"","","","","","","",null,null,null,null,0,30,35,0,0,0,0,0,0]
[null,18,34,17,0.94736842105263153,"","","","","","","",null,null,null,null,0,30,35,0,0,0,0,0,0]
["A",{"$f":"B54+1","v":19},35,13,1,"","","","","","","",null,null,null,null,1,35,35,0,0,0,0,0,0]
[null,20,36,9,1,"",{"$f":"IF($S$33>0,\"\",G$55)","v":""},"","","","","",null,null,null,null,0,35,30,0,0,0,0,0,0]
[null,21,37,4,1,"","","","","","","",null,null,null,null,0,35,30,0,0,0,0,0,0]
[null,22,38,3,1,"","","","","","","",null,null,null,null,0,{"$f":"IF(Q58=0,R57,C58)","v":35},30,0,0,0,0,0,0]
[null,23,39,1,1,"","","","","","","",null,null,null,null,0,{"$f":"IF(Q59=0,R58,C59)","v":35},30,0,0,0,0,0,0]
[null,24,40,0,1,"","","","","","","",null,null,null,null,0,{"$f":"IF(Q60=0,R59,C60)","v":35},30,0,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D37:D60)","v":2602},null,null,null,null,null,{"$f":"SUM(J37:J60)","v":0},{"$f":"SUM(K37:K60)","v":0},0]