{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Start","Auxiliary Tables_CH","Auxiliary Calculations_CH","Input_CombinationHeater","Output_CombinationHeater","Label_CombinationHeater","Input_SpaceHeater","Output_SpaceHeater","Label_SpaceHeater","Auxiliary Tables_SH","Auxiliary Calculations_SH","Input_WaterHeater","Output_WaterHeater","Label_WaterHeater","Auxiliary Tables_WH","Auxiliary Calculations_WH"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":182,"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":"Start","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Välkommen till beräkningsverktyget för produktetiketter till paket med pannor, värmepumpar och varmvattenberedare"]
[]
["Välj typ av panna eller värmepump"]

{"sheet":"Auxiliary Tables_CH","index":1,"n_rows":278,"n_cols":10,"rows_kept":278,"cut":false,"hidden":true,"merged":[]}
["Combination Heater",null,null,null,"Space Heater",null,null,null,null,"Water Heater"]
["Prated / (Prated + Psup)","with storage tank","without  storage tank"]
[0,1,1]
[0.01,0.97,0.96299999999999997]
[0.02,0.94,0.92600000000000005]
[0.03,0.91,0.88900000000000001]
[0.04,0.88,0.85199999999999998]
[0.05,0.85,0.81499999999999995]
[0.06,0.82000000000000006,0.77800000000000002]
[7.0000000000000007E-2,0.79,0.74099999999999999]
[0.08,0.76,0.70399999999999996]
[0.09,0.73,0.66700000000000004]
[0.1,0.7,0.63]
[0.11,0.67500000000000004,0.59699999999999998]
[0.12,0.65,0.56400000000000006]
[0.13,0.625,0.53100000000000003]
[0.14000000000000001,0.6,0.498]
[0.15,0.57499999999999996,0.46500000000000008]
[0.16,0.55000000000000004,0.43200000000000005]
[0.17,0.52499999999999991,0.39900000000000002]
[0.18,0.5,0.3660000000000001]
[0.19,0.47499999999999998,0.33300000000000007]
[0.2,0.44999999999999996,0.30000000000000004]
[0.21,0.42999999999999994,0.28500000000000003]
[0.22,0.40999999999999992,0.27]
[0.23,0.39,0.255]
[0.24,0.37,0.24]
[0.25,0.35,0.22500000000000009]
[0.26,0.32999999999999996,0.21000000000000008]
[0.27,0.30999999999999994,0.19500000000000006]
[0.28000000000000003,0.29000000000000004,0.18000000000000005]
[0.28999999999999998,0.27,0.16500000000000004]
[0.3,0.25,0.15000000000000002]
[0.31,0.24,0.14100000000000001]
[0.32,0.22999999999999998,0.13200000000000001]
[0.33,0.21999999999999997,0.123]
[0.34,0.20999999999999996,0.11399999999999999]
[0.35,0.19999999999999996,0.10499999999999998]
[0.36,0.19000000000000006,9.6000000000000085E-2]
[0.37,0.18000000000000005,8.7000000000000077E-2]
[0.38,0.17000000000000004,7.8000000000000069E-2]
[0.39,0.16000000000000003,6.9000000000000061E-2]
[0.4,0.15000000000000002,6.0000000000000053E-2]
[0.41,0.14000000000000001,5.600000000000005E-2]
[0.42,0.13,5.2000000000000046E-2]
[0.43,0.12,4.8000000000000043E-2]
[0.44,0.10999999999999999,4.4000000000000039E-2]
[0.45,0.10000000000000009,4.0000000000000036E-2]
[0.46,9.000000000000008E-2,3.6000000000000032E-2]
[0.47,8.0000000000000071E-2,3.2000000000000028E-2]
[0.48,7.0000000000000062E-2,2.8000000000000025E-2]
[0.49,6.0000000000000053E-2,2.4000000000000021E-2]
[0.5,5.0000000000000044E-2,2.0000000000000018E-2]
[0.51,4.7000000000000042E-2,1.8000000000000016E-2]
[0.52,4.4000000000000039E-2,1.6000000000000014E-2]
[0.53,4.1000000000000036E-2,1.4000000000000012E-2]
[0.54,3.8000000000000034E-2,1.2000000000000011E-2]
[0.55000000000000004,3.5000000000000031E-2,1.0000000000000009E-2]
[0.56000000000000005,3.2000000000000028E-2,8.0000000000000071E-3]
[0.56999999999999995,2.9000000000000026E-2,6.0000000000000053E-3]
[0.57999999999999996,2.6000000000000023E-2,4.0000000000000036E-3]
[0.59,2.300000000000002E-2,2.0000000000000018E-3]
[0.6,2.0000000000000018E-2,0]
[0.61,1.8000000000000016E-2,0]
[0.62,1.6000000000000014E-2,0]
[0.63,1.4000000000000012E-2,0]
[0.64,1.2000000000000011E-2,0]
[0.65,1.0000000000000009E-2,0]
[0.66,8.0000000000000071E-3,0]
[0.67,6.0000000000000053E-3,0]
[0.68,4.0000000000000036E-3,0]
[0.69,2.0000000000000018E-3,0]
[0.7,0,0]
[]
[]
["Psup / (Prated + Psup)","without storage tank","with storage tank"]
[0,0,0]
[0.01,0.03,3.6999999999999998E-2]
[0.02,0.06,7.3999999999999996E-2]
[0.03,0.09,0.111]
[0.04,0.12,0.14799999999999999]
[0.05,0.15,0.185]
[0.06,0.18,0.222]
[7.0000000000000007E-2,0.21000000000000002,0.25900000000000001]
[0.08,0.24,0.29599999999999999]
[0.09,0.26999999999999996,0.33299999999999996]
[0.1,0.3,0.37]
[0.11,0.32500000000000001,0.40299999999999997]
[0.12,0.35,0.436]
[0.13,0.375,0.46899999999999997]
[0.14000000000000001,0.4,0.502]
[0.15,0.42500000000000004,0.53499999999999992]
[0.16,0.45,0.56799999999999995]
[0.17,0.47500000000000003,0.60099999999999998]
[0.18,0.5,0.6339999999999999]
[0.19,0.52500000000000002,0.66699999999999993]
[0.2,0.55000000000000004,0.7]
[0.21,0.57000000000000006,0.71499999999999997]
[0.22,0.59000000000000008,0.73]
[0.23,0.61,0.745]
[0.24,0.63,0.76]
[0.25,0.65,0.77499999999999991]
[0.26,0.67,0.78999999999999992]
[0.27,0.69000000000000006,0.80499999999999994]
[0.28000000000000003,0.71,0.82]
[0.28999999999999998,0.73,0.83499999999999996]
[0.3,0.75,0.85]
[0.31,0.76,0.85899999999999999]
[0.32,0.77,0.86799999999999999]
[0.33,0.78,0.877]
[0.34,0.79,0.88600000000000001]
[0.35,0.8,0.89500000000000002]
[0.36,0.80999999999999994,0.90399999999999991]
[0.37,0.82,0.91299999999999992]
[0.38,0.83,0.92199999999999993]
[0.39,0.84,0.93099999999999994]
[0.4,0.85,0.94]
[0.41,0.86,0.94399999999999995]
[0.42,0.87,0.94799999999999995]
[0.43,0.88,0.95199999999999996]
[0.44,0.89,0.95599999999999996]
[0.45,0.89999999999999991,0.96]
[0.46,0.90999999999999992,0.96399999999999997]
[0.47,0.91999999999999993,0.96799999999999997]
[0.48,0.92999999999999994,0.97199999999999998]
[0.49,0.94,0.97599999999999998]
[0.5,0.95,0.98]
[0.51,0.95299999999999996,0.98199999999999998]
[0.52,0.95599999999999996,0.98399999999999999]
[0.53,0.95899999999999996,0.98599999999999999]
[0.54,0.96199999999999997,0.98799999999999999]
[0.55000000000000004,0.96499999999999997,0.99]
[0.56000000000000005,0.96799999999999997,0.99199999999999999]
[0.56999999999999995,0.97099999999999997,0.99399999999999999]
[0.57999999999999996,0.97399999999999998,0.996]
[0.59,0.97699999999999998,0.998]
[0.6,0.98,1]
[0.61,0.98199999999999998,1]
[0.62,0.98399999999999999,1]
[0.63,0.98599999999999999,1]
[0.64,0.98799999999999999,1]
[0.65,0.99,1]
[0.66,0.99199999999999999,1]
[0.67,0.99399999999999999,1]
[0.68,0.996,1]
[0.69,0.998,1]
[0.7,1,1]
[]
[]
["Temperature Control"]
["Class I",0.01]
["Class II",0.02]
["Class III",1.4999999999999999E-2]
["Class IV",0.02]
["Class V",0.03]
["Class VI",0.04]
["Class VII",3.5000000000000003E-2]
["Class VIII",0.05]
[]
["Solar Contribution - Tank Rating"]
["A+",0.95]
["A",0.91]
["B",0.86]
["C",0.83]
["D",0.81]
["E",0.81]
["F",0.81]
["G",0.81]
[]
["Efficiency Class of Package"]
[{"$f":"VLOOKUP(B171,_CH_EfficiencyClassOfPackage_Lookup_Reference,IF(_CH_Preferential_Heater_Type=\"Low-temperature Heat Pump\",3,2),FALSE)","v":0},"G"]
[0.3,"F"]
[0.34,"E"]
[0.36,"D"]
[0.75,"C"]
[0.82,"B"]
[0.9,"A"]
[0.98,"A+"]
[1.25,"A++"]
[1.5,"A+++"]
[]
["Load Profile","Qref"]
["M",5.8449999999999998]
["L",11.654999999999999]
["XL",19.07]
["XXL",24.53]
[]
[]
["M",1]
["L",2]
["XL",3]
["XXL",4]
[]
["Water Heating Efficiecny Class"]
["M"]
[0,"G"]
[0.27,"F"]
[0.3,"E"]
[0.33,"D"]
[0.36,"C"]
[0.39,"B"]
[0.65,"A"]
[1,"A+"]
[1.3,"A++"]
[1.63,"A+++"]
[]
["L"]
[0,"G"]
[0.27,"F"]
[0.3,"E"]
[0.34,"D"]
[0.37,"C"]
[0.5,"B"]
[0.75,"A"]
[1.1499999999999999,"A+"]
[1.5,"A++"]
[1.88,"A+++"]
[]
["XL"]
[0,"G"]
[0.27,"F"]
[0.3,"E"]
[0.35,"D"]
[0.38,"C"]
[0.55000000000000004,"B"]
[0.8,"A"]
[1.23,"A+"]
[1.6,"A++"]
[2,"A+++"]
[]
["XXL"]
[0,"G"]
[0.28000000000000003,"F"]
[0.32,"E"]
[0.36,"D"]
[0.4,"C"]
[0.6,"B"]
[0.85,"A"]
[1.31,"A+"]
[1.7,"A++"]
[2.13,"A+++"]
[]
["Efficiency Class of Package"]
[null,"Others","Low Temperature HP"]
["G",0,0]
["F",0.3,0.55000000000000004]
["E",0.34,0.59]
["D",0.36,0.61]
["C",0.75,1]
["B",0.82,1.07]
["A",0.9,1.1499999999999999]
["A+",0.98,1.23]
["A++",1.25,1.5]
["A+++",1.5,1.75]
[]
["Efficiency Class of Preferential Heater"]
[0,"G"]
[0.3,"F"]
[0.34,"E"]
[0.36,"D"]
[0.75,"C"]
[0.82,"B"]
[0.9,"A"]
[0.98,"A+"]
[1.25,"A++"]
[1.5,"A+++"]
[]
[]
["Preferential Heater Type"]
["Boiler"]
["Heat Pump"]
["Cogeneration Heater"]
[]
["Solar Contribution Factor"]
["Boiler",0.9]
["Heat Pump",0.45]
["Low-temperature Heat Pump",0.45]
["Cogeneration Heater",0.7]

{"sheet":"Auxiliary Calculations_CH","index":2,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Combination Heater"]
[]
["Psup",{"$f":"IF(_CH_SupplementaryHeater=\"Yes\",_CH_Psup_Boiler,0)+IF(_CH_SupplementaryHeatPump=\"Yes\",_CH_Psup_HP,0)","v":0}]
[]
["Psup /  (Prated + Psup)",{"$f":"ROUND(_CH_Psup/(_CH_Prated+_CH_Psup_Boiler),2)","v":0}]
[]
["Prated /  (Prated + Psup)",{"$f":"ROUND(_CH_Prated/(_CH_Prated+_CH_Psup),2)","v":1}]
[]
["Heat output of preferential and supplementary heaters "]
["Heating II",{"$f":"IF(_CH_Preferential_Heater_Type=\"Boiler\",VLOOKUP(B5,_CH_StorageTank_Lookup_Boiler,IF(_CH_StorageTank=\"Yes\",3,2),FALSE),VLOOKUP(B7,_CH_StorageTank_Lookup_Others,IF(_CH_StorageTank=\"Yes\",2,3),FALSE))","v":0}]
[]
["Heating III",{"$f":"2.94/(11*_CH_Prated)","v":5.3454545454545456E-3}]
[]
["Heating IV",{"$f":"1.15/(11*_CH_Prated)","v":2.0909090909090908E-3}]
["Heating Efficiency Class"]
["G",{"$f":"IF(_CH_Overall_Heating_EfficiencyClass=A16,TRUE,FALSE)","v":false}]
["F",false]
["E",false]
["D",false]
["C",false]
["B",true]
["A",false]
["A+",false]
["A++",false]
["A+++",false]
[]
["Water  Efficiency Class"]
["G",{"$f":"IF(_CH_Overall_Water_EfficiencyClass=A28,TRUE,FALSE)","v":false}]
["F",false]
["E",false]
["D",false]
["C",false]
["B",false]
["A",false]
["A+",false]
["A++",true]
["A+++",false]
[]
["Additional Heater",{"$f":"IF(OR(_CH_SupplementaryHeater=\"Yes\",_CH_SupplementaryHeatPump=\"Yes\"),TRUE,FALSE)","v":false}]
["Temperature Control",{"$f":"IF(_CH_TemperatureControl=\"Yes\",TRUE,FALSE)","v":true}]
["Solar Contribution",{"$f":"IF(_CH_SolarContribution=\"Yes\",TRUE,FALSE)","v":true}]
["Storage Tank",{"$f":"IF(_CH_StorageTank=\"Yes\",TRUE,FALSE)","v":true}]
[]
[]
["Water_II",{"$f":"220*VLOOKUP(_CH_LoadProfile,_CH_LoadProfile_Lookup,2,FALSE)/_CH_Qnonsol","v":1.6073749999999998}]
[]
["Water_III",{"$f":"_CH_Qaux*2.5/220/VLOOKUP(_CH_LoadProfile,_CH_LoadProfile_Lookup,2,FALSE)","v":3.8883272416206549E-3}]
[]
["Efficiency Class of the preferential heater",{"$f":"VLOOKUP(_CH_Heating_I,_CH_EfficiencyClassOfPreferentialHeater_Lookup,2,TRUE)","v":"B"}]
[]
["Water Heating Efficiency Class of the preferential heater",{"$f":"VLOOKUP(_CH_Water_I,INDIRECT(\"_CH_WaterEfficiencyClassOfPackage_Lookup_\"&_CH_LoadProfile),2)","v":"A+"}]
[]
["Supplementary Boiler Factor",{"$f":"IF(_CH_Preferential_Heater_Type=\"Boiler\",0.1,_CH_Heating_II)","v":0.1}]

{"sheet":"Input_CombinationHeater","index":3,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Allmän information"]
[]
["Återförsäljare"]
[]
[]
["Modellbeteckning"]
[]
[]
["Primär värmare"]
[]
["Typ av primär värmare"]
["Boiler"]
[]
["Säsongsmedelverkningsgrad vid rumsuppvärmning  för den primära värmaren",0.85]
[]
["Energieffektivitet vid tappvattenvärmning för den primära värmaren",1]
[]
["Belastningsprofil (tappvattenvärmning)","M"]
[]
["Nominell avgiven värmeeffekt för den primära värmaren (Prated)",50,"kW"]
[]
["Ackumulatortank"]
[]
["Finns ackumulatortank installerad?","Yes","[Yes/No]"]
[]
["Tankvolym",1.5,"m³"]
[]
["Energieffektivitetsklass för ackumulatortank","C"]
[]
["Temperaturreglering"]
[]
["Finns temperaturreglering installerat","Yes","[Yes/No]"]
[]
["Klass för temperaturreglaring","Class I"]
[]
["Solfångare"]
[]
["Finns solfångare installerat?","Yes","[Yes/No]"]
[]
["Årligt värmebidrag från andra källor än solen (Qnonsol)",800,"kWh"]
[]
["Årlig förbrukning av tilläggsel (Qaux)",2,"kWh"]
[]
["Solfångarens öppningsarea",5,"m²"]
[]
["Solfångarens effektivitet ",0.95]
[]
["Tillsatspanna "]
[]
["Finns tillsatspanna installerad?","No","[Yes/No]"]
[]
["Säsongsmedelverkningsgrad för rumsuppvärmning",1.05]
[]
["Nominell avgiven värmeeffekt för tillsatspanna (Psup, boiler)",25,"kW"]
[]
["Tillsatsvärmepump"]
[]
["Finns tillsatsvärmepump installerad?","No","[Yes/No]"]
[]
["Säsongsmedelverkningsgrad för rumsuppvärmning",2.6]
[]
["Nominell avgiven värmeeffekt för tillsatspanna (Psup, heat pump)",5,"kW"]

{"sheet":"Output_CombinationHeater","index":4,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Säsongsmedelverkningsgrad vid rumsuppvärmning för panna/värmepump",{"$f":"_CH_SeasonalSpaceHeatingEnergyEfficiency_Pref","v":0.85}]
[]
["Temperaturreglering",{"$f":"IF(_CH_TemperatureControl=\"Yes\",VLOOKUP(_CH_TemperatureControlClass,_CH_TemperatureControlClasses_Lookup,2,FALSE),0)","v":0.01}]
[]
["Tillsatspanna ",{"$f":"IF(_CH_SupplementaryHeater=\"Yes\",(_CH_SeasonalSpaceHeatingEnergyEfficiency_sup-_CH_SeasonalSpaceHeatingEnergyEfficiency_Pref)*_CH_Supplementary_Heater_Factor,0)","v":0}]
[]
["Solvärmebidrag",{"$f":"IF(_CH_SolarContribution=\"Yes\",(_CH_Heating_III*_CH_SolarContribution_CollectorSize+_CH_Heating_IV*_CH_SolarContribution_TankVolume)*VLOOKUP(_CH_Preferential_Heater_Type,_CH_Solar_Contribution_Factor,2,FALSE)*_CH_SolarContribution_CollectorEfficiency*VLOOKUP(_CH_SolarContribution_TankRating,_CH_SolarContribution_TankRating_Lookup,2,FALSE),0)","v":2.1192729545454547E-2}]
[]
["Tillsatsvärmepump",{"$f":"IF(AND(_CH_SupplementaryHeatPump=\"Yes\",_CH_Preferential_Heater_Type=\"Boiler\"),(_CH_SupplementaryHeatPump_SeasonalSpaceHeatingEnergyEfficiency-_CH_Heating_I)*_CH_Heating_II,0)","v":0}]
[]
["Bidrag solvärme och tillsatsvärmepump",{"$f":"IF(AND(_CH_SolarContribution=\"YES\",_CH_SupplementaryHeatPump=\"YES\",_CH_Preferential_Heater_Type=\"Boiler\"),-0.5*MIN(_CH_4,_CH_5),0)","v":0}]
[]
["Paketets säsongsbundna energieffektivitet vid rumsuppvärmning",{"$f":"SUM(B2,B4,B6,B8,B10,B12)","v":0.88119272954545458}]
[]
["Paketets energieffektivitetsklass vid rumsuppvärmning",{"$f":"VLOOKUP(_CH_EfficiencyClassOfPackage,_CH_EfficiencyClassOfPackage_Lookup,2)","v":"B"}]
[]
[]
["Energieffektivitet vid tappvarmvattenvärmning",{"$f":"_CH_Water_I","v":1}]
[]
["Solvärmebidrag",{"$f":"IF(_CH_SolarContribution_Bool,(1.1*_CH_Water_I-0.1)*_CH_Water_II-_CH_Water_III-B19,0)","v":0.60348667275837919}]
[]
["Paketets säsongsbundna energieffektivitet vid tappvarmvattenvärmning",{"$f":"SUM(_CH_Water_1,_CH_Water_2)","v":1.6034866727583792}]
[]
["Paketets energieffektivitetsklass vid tappvarmvattenvärmning",{"$f":"VLOOKUP(B23,INDIRECT(\"_CH_WaterEfficiencyClassOfPackage_Lookup_\"&_CH_LoadProfile),2)","v":"A++"}]

{"sheet":"Label_CombinationHeater","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input_SpaceHeater","index":6,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[]
["Allmän information"]
[]
["Återförsäljare"]
[]
[]
["Modellbeteckning"]
[]
[]
["Primär värmare"]
[]
["Typ av primär värmare"]
["Boiler"]
[]
["Säsongsmedelverkningsgrad vid rumsuppvärmning för den primära värmaren",0.85]
[]
["Nominell avgiven värmeeffekt för den primära värmaren (Prated)",12,"kW"]
[]
["Ackumulatortank"]
[]
["Finns ackumulatortank installerad?","No","[Yes/No]"]
[]
["Tankvolym",1.5,"m³"]
[]
["Energieffektivitetsklass för ackumulatortank","C"]
[]
["Temperaturreglering"]
[]
["Finns temperaturreglering installerat","No","[Yes/No]"]
[]
["Klass för temperaturreglaring","Class I"]
[]
["Solfångare"]
[]
["Finns solfångare installerat?","No","[Yes/No]"]
[]
["Solfångarens öppningsarea",8,"m²"]
[]
["Solfångarens effektivitet",0.95]
[]
["Tillsatspanna "]
[]
["Finns tillsatspanna installerad?","Yes","[Yes/No]"]
[]
["Säsongsmedelverkningsgrad för rumsuppvärmning",1.5]
[]
["Nominell avgiven värmeeffekt för tillsatspanna (Psup, boiler)",5,"kW"]
[]
["Tillsatsvärmepump"]
[]
["Finns tillsatsvärmepump installerad?","No","[Yes/No]"]
[]
["Säsongsmedelverkningsgrad vid rumsuppvärmning",0.95]
[]
["Nominell avgiven värmeeffekt för tillsatspanna (Psup, heat pump)",5,"kW"]

{"sheet":"Output_SpaceHeater","index":7,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
["Säsongsmedelverkningsgrad vid rumsuppvärmning för panna/värmepump",{"$f":"_SH_SeasonalSpaceHeatingEnergyEfficiency_Pref","v":0.85}]
[]
["Temperaturreglering",{"$f":"IF(_SH_TemperatureControl=\"Yes\",VLOOKUP(_SH_TemperatureControlClass,_SH_TemperatureControlClasses_Lookup,2,FALSE),0)","v":0}]
[]
["Tillsatspanna ",{"$f":"IF(_SH_SupplementaryHeater=\"Yes\",(_SH_SeasonalSpaceHeatingEnergyEfficiency_sup-_SH_SeasonalSpaceHeatingEnergyEfficiency_Pref)*_SH_Supplementary_Heater_Factor,0)","v":6.5000000000000002E-2}]
[]
["Solvärmebidrag",{"$f":"IF(_SH_SolarContribution=\"Yes\",(_SH_III*_SH_SolarContribution_CollectorSize+_SH_IV*_SH_SolarContribution_TankVolume)*VLOOKUP(_SH_Preferential_Heater_Type,_SH_Solar_Contribution_Factor,2,FALSE)*_SH_SolarContribution_CollectorEfficiency*VLOOKUP(_SH_SolarContribution_TankRating,_SH_SolarContribution_TankRating_Lookup,2,FALSE),0)","v":0}]
[]
["Tillsatsvärmepump",{"$f":"IF(AND(_SH_SupplementaryHeatPump=\"Yes\",_SH_Preferential_Heater_Type=\"Boiler\"),(_SH_SupplementaryHeatPump_SeasonalSpaceHeatingEnergyEfficiency-_SH_I)*_SH_II,0)","v":0}]
[]
["Bidrag solvärme och tillsatsvärmepump",{"$f":"IF(AND(_SH_SolarContribution=\"YES\",_SH_SupplementaryHeatPump=\"YES\",_SH_Preferential_Heater_Type=\"Boiler\"),-0.5*MIN(_SH_4,_SH_5),0)","v":0}]
[]
["Paketets säsongsbundna energieffektivitet vid rumsuppvärmning",{"$f":"SUM(B2,B4,B6,B8,B10,B12)","v":0.91500000000000004}]
[]
["Paketets energieffektivitetsklass vid rumsuppvärmning",{"$f":"VLOOKUP(_SH_EfficiencyClassOfPackage,_SH_EfficiencyClassOfPackage_Lookup,2)","v":"A"}]

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

{"sheet":"Auxiliary Tables_SH","index":9,"n_rows":215,"n_cols":3,"rows_kept":215,"cut":false,"hidden":true,"merged":[]}
[]
["Prated / (Prated + Psup)","with storage tank","without  storage tank"]
[0,1,1]
[0.01,0.97,0.96299999999999997]
[0.02,0.94,0.92600000000000005]
[0.03,0.91,0.88900000000000001]
[0.04,0.88,0.85199999999999998]
[0.05,0.85,0.81499999999999995]
[0.06,0.82000000000000006,0.77800000000000002]
[7.0000000000000007E-2,0.79,0.74099999999999999]
[0.08,0.76,0.70399999999999996]
[0.09,0.73,0.66700000000000004]
[0.1,0.7,0.63]
[0.11,0.67500000000000004,0.59699999999999998]
[0.12,0.65,0.56400000000000006]
[0.13,0.625,0.53100000000000003]
[0.14000000000000001,0.6,0.498]
[0.15,0.57499999999999996,0.46500000000000008]
[0.16,0.55000000000000004,0.43200000000000005]
[0.17,0.52499999999999991,0.39900000000000002]
[0.18,0.5,0.3660000000000001]
[0.19,0.47499999999999998,0.33300000000000007]
[0.2,0.44999999999999996,0.30000000000000004]
[0.21,0.42999999999999994,0.28500000000000003]
[0.22,0.40999999999999992,0.27]
[0.23,0.39,0.255]
[0.24,0.37,0.24]
[0.25,0.35,0.22500000000000009]
[0.26,0.32999999999999996,0.21000000000000008]
[0.27,0.30999999999999994,0.19500000000000006]
[0.28000000000000003,0.29000000000000004,0.18000000000000005]
[0.28999999999999998,0.27,0.16500000000000004]
[0.3,0.25,0.15000000000000002]
[0.31,0.24,0.14100000000000001]
[0.32,0.22999999999999998,0.13200000000000001]
[0.33,0.21999999999999997,0.123]
[0.34,0.20999999999999996,0.11399999999999999]
[0.35,0.19999999999999996,0.10499999999999998]
[0.36,0.19000000000000006,9.6000000000000085E-2]
[0.37,0.18000000000000005,8.7000000000000077E-2]
[0.38,0.17000000000000004,7.8000000000000069E-2]
[0.39,0.16000000000000003,6.9000000000000061E-2]
[0.4,0.15000000000000002,6.0000000000000053E-2]
[0.41,0.14000000000000001,5.600000000000005E-2]
[0.42,0.13,5.2000000000000046E-2]
[0.43,0.12,4.8000000000000043E-2]
[0.44,0.10999999999999999,4.4000000000000039E-2]
[0.45,0.10000000000000009,4.0000000000000036E-2]
[0.46,9.000000000000008E-2,3.6000000000000032E-2]
[0.47,8.0000000000000071E-2,3.2000000000000028E-2]
[0.48,7.0000000000000062E-2,2.8000000000000025E-2]
[0.49,6.0000000000000053E-2,2.4000000000000021E-2]
[0.5,5.0000000000000044E-2,2.0000000000000018E-2]
[0.51,4.7000000000000042E-2,1.8000000000000016E-2]
[0.52,4.4000000000000039E-2,1.6000000000000014E-2]
[0.53,4.1000000000000036E-2,1.4000000000000012E-2]
[0.54,3.8000000000000034E-2,1.2000000000000011E-2]
[0.55000000000000004,3.5000000000000031E-2,1.0000000000000009E-2]
[0.56000000000000005,3.2000000000000028E-2,8.0000000000000071E-3]
[0.56999999999999995,2.9000000000000026E-2,6.0000000000000053E-3]
[0.57999999999999996,2.6000000000000023E-2,4.0000000000000036E-3]
[0.59,2.300000000000002E-2,2.0000000000000018E-3]
[0.6,2.0000000000000018E-2,0]
[0.61,1.8000000000000016E-2,0]
[0.62,1.6000000000000014E-2,0]
[0.63,1.4000000000000012E-2,0]
[0.64,1.2000000000000011E-2,0]
[0.65,1.0000000000000009E-2,0]
[0.66,8.0000000000000071E-3,0]
[0.67,6.0000000000000053E-3,0]
[0.68,4.0000000000000036E-3,0]
[0.69,2.0000000000000018E-3,0]
[0.7,0,0]
[]
[]
["Psup / (Prated + Psup)","without storage tank","with  storage tank"]
[0,0,0]
[0.01,0.03,3.6999999999999998E-2]
[0.02,0.06,7.3999999999999996E-2]
[0.03,0.09,0.111]
[0.04,0.12,0.14799999999999999]
[0.05,0.15,0.185]
[0.06,0.18,0.222]
[7.0000000000000007E-2,0.21000000000000002,0.25900000000000001]
[0.08,0.24,0.29599999999999999]
[0.09,0.26999999999999996,0.33299999999999996]
[0.1,0.3,0.37]
[0.11,0.32500000000000001,0.40299999999999997]
[0.12,0.35,0.436]
[0.13,0.375,0.46899999999999997]
[0.14000000000000001,0.4,0.502]
[0.15,0.42500000000000004,0.53499999999999992]
[0.16,0.45,0.56799999999999995]
[0.17,0.47500000000000003,0.60099999999999998]
[0.18,0.5,0.6339999999999999]
[0.19,0.52500000000000002,0.66699999999999993]
[0.2,0.55000000000000004,0.7]
[0.21,0.57000000000000006,0.71499999999999997]
[0.22,0.59000000000000008,0.73]
[0.23,0.61,0.745]
[0.24,0.63,0.76]
[0.25,0.65,0.77499999999999991]
[0.26,0.67,0.78999999999999992]
[0.27,0.69000000000000006,0.80499999999999994]
[0.28000000000000003,0.71,0.82]
[0.28999999999999998,0.73,0.83499999999999996]
[0.3,0.75,0.85]
[0.31,0.76,0.85899999999999999]
[0.32,0.77,0.86799999999999999]
[0.33,0.78,0.877]
[0.34,0.79,0.88600000000000001]
[0.35,0.8,0.89500000000000002]
[0.36,0.80999999999999994,0.90399999999999991]
[0.37,0.82,0.91299999999999992]
[0.38,0.83,0.92199999999999993]
[0.39,0.84,0.93099999999999994]
[0.4,0.85,0.94]
[0.41,0.86,0.94399999999999995]
[0.42,0.87,0.94799999999999995]
[0.43,0.88,0.95199999999999996]
[0.44,0.89,0.95599999999999996]
[0.45,0.89999999999999991,0.96]
[0.46,0.90999999999999992,0.96399999999999997]
[0.47,0.91999999999999993,0.96799999999999997]
[0.48,0.92999999999999994,0.97199999999999998]
[0.49,0.94,0.97599999999999998]
[0.5,0.95,0.98]
[0.51,0.95299999999999996,0.98199999999999998]
[0.52,0.95599999999999996,0.98399999999999999]
[0.53,0.95899999999999996,0.98599999999999999]
[0.54,0.96199999999999997,0.98799999999999999]
[0.55000000000000004,0.96499999999999997,0.99]
[0.56000000000000005,0.96799999999999997,0.99199999999999999]
[0.56999999999999995,0.97099999999999997,0.99399999999999999]
[0.57999999999999996,0.97399999999999998,0.996]
[0.59,0.97699999999999998,0.998]
[0.6,0.98,1]
[0.61,0.98199999999999998,1]
[0.62,0.98399999999999999,1]
[0.63,0.98599999999999999,1]
[0.64,0.98799999999999999,1]
[0.65,0.99,1]
[0.66,0.99199999999999999,1]
[0.67,0.99399999999999999,1]
[0.68,0.996,1]
[0.69,0.998,1]
[0.7,1,1]
[]
[]
["Temperature Control"]
["Class I",0.01]
["Class II",0.02]
["Class III",1.4999999999999999E-2]
["Class IV",0.02]
["Class V",0.03]
["Class VI",0.04]
["Class VII",3.5000000000000003E-2]
["Class VIII",0.05]
[]
["Solar Contribution - Tank Rating"]
["A+",0.95]
["A",0.91]
["B",0.86]
["C",0.83]
["D",0.81]
["E",0.81]
["F",0.81]
["G",0.81]
[]
["Efficiency Class of Package"]
[null,"Others","Low Temperature HP"]
["G",0,0]
["F",0.3,0.55000000000000004]
["E",0.34,0.59]
["D",0.36,0.61]
["C",0.75,1]
["B",0.82,1.07]
["A",0.9,1.1499999999999999]
["A+",0.98,1.23]
["A++",1.25,1.5]
["A+++",1.5,1.75]
[]
["Efficiency Class of Package"]
[{"$f":"VLOOKUP(B184,_SH_EfficiencyClassOfPackage_Lookup_Reference,IF(_SH_Preferential_Heater_Type=\"Low-temperature Heat Pump\",3,2),FALSE)","v":0},"G"]
[0.3,"F"]
[0.34,"E"]
[0.36,"D"]
[0.75,"C"]
[0.82,"B"]
[0.9,"A"]
[0.98,"A+"]
[1.25,"A++"]
[1.5,"A+++"]
[]
["Efficiency Class of Preferential Heater"]
[0,"G"]
[0.3,"F"]
[0.34,"E"]
[0.36,"D"]
[0.75,"C"]
[0.82,"B"]
[0.9,"A"]
[0.98,"A+"]
[1.25,"A++"]
[1.5,"A+++"]
[]
["Preferential Heater Type"]
["Boiler"]
["Heat Pump"]
["Cogeneration Heater"]
[]
["Solar Contribution Factor"]
["Boiler",0.9]
["Heat Pump",0.45]
["Cogeneration Heater",0.7]

{"sheet":"Auxiliary Calculations_SH","index":10,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Psup",{"$f":"IF(_SH_SupplementaryHeater=\"Yes\",_SH_Psup_Boiler,0)+IF(_SH_SupplementaryHeatPump=\"Yes\",_SH_Psup_HP,0)","v":5}]
[]
["Psup /  (Prated + Psup)",{"$f":"ROUND((_SH_Psup)/(_SH_Prated+_SH_Psup),2)","v":0.28999999999999998}]
[]
["Prated /  (Prated + Psup)",{"$f":"ROUND(_SH_Prated/(_SH_Prated+_SH_Psup),2)","v":0.71}]
[]
["Heat output of preferential and supplementary heaters "]
["II",{"$f":"IF(_SH_Preferential_Heater_Type=\"Boiler\",VLOOKUP(B3,_SH_StorageTank_Lookup_Boiler,IF(_SH_StorageTank=\"Yes\",3,2),FALSE),VLOOKUP(B5,_SH_StorageTank_Lookup_Others,IF(_SH_StorageTank=\"Yes\",2,3),FALSE))","v":0.73}]
[]
["III",{"$f":"2.94/(11*_SH_Prated)","v":2.2272727272727274E-2}]
[]
["IV",{"$f":"1.15/(11*_SH_Prated)","v":8.712121212121211E-3}]
[]
["G",{"$f":"IF(_SH_Efficiency_Class=A14,TRUE,FALSE)","v":false}]
["F",false]
["E",false]
["D",false]
["C",false]
["B",false]
["A",true]
["A+",false]
["A++",false]
["A+++",false]
[]
["Additional Heater or Heat Pump",{"$f":"IF(OR(_SH_SupplementaryHeater=\"Yes\",_SH_SupplementaryHeatPump=\"Yes\"),TRUE,FALSE)","v":true}]
["Temperature Control",{"$f":"IF(_SH_TemperatureControl=\"Yes\",TRUE,FALSE)","v":false}]
["Solar Contribution",{"$f":"IF(_SH_SolarContribution=\"Yes\",TRUE,FALSE)","v":false}]
["Storage Tank",{"$f":"IF(_SH_StorageTank=\"Yes\",TRUE,FALSE)","v":false}]
[]
["Efficiency Class of the preferential heater",{"$f":"VLOOKUP(_SH_I,_SH_EfficiencyClassOfPreferentialHeater_Lookup,2,TRUE)","v":"B"}]
[]
["Supplementary Heater Factor",{"$f":"IF(_SH_Preferential_Heater_Type=\"Boiler\",0.1,_SH_II)","v":0.1}]

{"sheet":"Input_WaterHeater","index":11,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Allmän information"]
[]
["Återförsäljare"]
[]
[]
["Modellbeteckning"]
[]
[]
["Primär värmare"]
[]
["Energieffektivitet vid tappvattenvärmning för den primära värmaren",1.2]
[]
["Belastningsprofil (tappvattenvärmning)","M"]
[]
["Ackumulatortank"]
[]
["Finns ackumulatortank installerad?","Yes","[Yes/No]"]
[]
["Solfångare"]
[]
["Finns solfångare installerat?","Yes"]
[]
["Årligt värmebidrag från andra källor än solen (Qnonsol)",585,"kWh"]
[]
["Årlig förbrukning av tilläggsel (Qaux)",46,"kWh"]
[]
["Solfångarens öppningsarea",4,"m²"]
[]
["Solfångarens effektivitet ",1]

{"sheet":"Output_WaterHeater","index":12,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
["Energieffektivitet vid tappvarmvattenvärmning",{"$f":"_WH_Water_I","v":1.2}]
[]
["Solvärmebidrag",{"$f":"(1.1*_WH_Water_I-0.1)*_WH_Water_II-_WH_Water_III-B2","v":1.3922744563487079}]
[]
["Paketets säsongsbundna energieffektivitet vid tappvarmvattenvärmning",{"$f":"SUM(_WH_Water_1,_WH_Water_2)","v":2.5922744563487079}]
[]
["Paketets energieffektivitetsklass vid tappvarmvattenvärmning",{"$f":"VLOOKUP(B6,INDIRECT(\"_WH_WaterEfficiencyClassOfPackage_Lookup_\"&_WH_LoadProfile),2)","v":"A+++"}]

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

{"sheet":"Auxiliary Tables_WH","index":14,"n_rows":72,"n_cols":2,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[]
["Solar Contribution - Tank Rating"]
["A+",0.95]
["A",0.91]
["B",0.86]
["C",0.83]
["D",0.81]
["E",0.81]
["F",0.81]
["G",0.81]
[]
[]
["Load Profile","Qref"]
["M",5.8449999999999998]
["L",11.654999999999999]
["XL",19.07]
["XXL",24.53]
[]
[]
["M",1]
["L",2]
["XL",3]
["XXL",4]
[]
["Water Heating Efficiecny Class"]
["M"]
[0,"G"]
[0.27,"F"]
[0.3,"E"]
[0.33,"D"]
[0.36,"C"]
[0.39,"B"]
[0.65,"A"]
[1,"A+"]
[1.3,"A++"]
[1.63,"A+++"]
[]
["L"]
[0,"G"]
[0.27,"F"]
[0.3,"E"]
[0.34,"D"]
[0.37,"C"]
[0.5,"B"]
[0.75,"A"]
[1.1499999999999999,"A+"]
[1.5,"A++"]
[1.88,"A+++"]
[]
["XL"]
[0,"G"]
[0.27,"F"]
[0.3,"E"]
[0.35,"D"]
[0.38,"C"]
[0.55000000000000004,"B"]
[0.8,"A"]
[1.23,"A+"]
[1.6,"A++"]
[2,"A+++"]
[]
["XXL"]
[0,"G"]
[0.28000000000000003,"F"]
[0.32,"E"]
[0.36,"D"]
[0.4,"C"]
[0.6,"B"]
[0.85,"A"]
[1.31,"A+"]
[1.7,"A++"]
[2.13,"A+++"]

{"sheet":"Auxiliary Calculations_WH","index":15,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
["Solar Contribution",{"$f":"IF(_WH_SolarContribution=\"Yes\",TRUE,FALSE)","v":true}]
[]
["Strorage Tank",{"$f":"IF(_WH_StorageTank=\"Yes\",TRUE,FALSE)","v":true}]
[]
["Water_II",{"$f":"220*VLOOKUP(_WH_LoadProfile,_WH_LoadProfile_Lookup,2,FALSE)/_WH_Qnonsol","v":2.198119658119658}]
[]
["Water_III",{"$f":"_WH_Qaux*2.5/220/VLOOKUP(_WH_LoadProfile,_WH_LoadProfile_Lookup,2,FALSE)","v":8.9431526557275057E-2}]
[]
["Water Heating Efficiency Class of the preferential heater",{"$f":"VLOOKUP(_WH_Water_I,INDIRECT(\"_WH_WaterEfficiencyClassOfPackage_Lookup_\"&_WH_LoadProfile),2)","v":"A+"}]
[]
["Water  Efficiency Class"]
["G",{"$f":"IF(_WH_Overall_Water_EfficiencyClass=A13,TRUE,FALSE)","v":false}]
["F",false]
["E",false]
["D",false]
["C",false]
["B",false]
["A",false]
["A+",false]
["A++",false]
["A+++",true]