{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Inputs","Outputs"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":138,"comments":1,"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":"Introduction","index":0,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Ref.:","prEN 15316-4-3, method 2"]
[null,"Monthy, using components data"]
["Author:","GvA"]
["Date:","2014-08-11",null,"Status:","Delopment"]

{"sheet":"Inputs","index":1,"n_rows":89,"n_cols":34,"rows_kept":89,"cut":false,"hidden":false,"merged":[[29,3,29,5],[24,20,31,20],[6,3,6,6],[11,3,11,5],[56,3,56,5],[36,3,36,5],[38,3,38,5],[40,3,40,5],[49,3,49,5],[53,3,53,5],[21,3,21,5],[16,3,16,5],[18,3,18,5],[32,3,32,5],[34,3,34,5],[27,3,27,5],[24,3,24,5]]}
["Input sheet",null,null,"Method:","prEN 15316-4-3, method 2 (monthly, using components data)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data warehouse"]
[null,null,null,"Author:","Gerard van Amerongen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"! Do not change anything !"]
[null,null,null,"Date:","2014-08-06"]
[]
[]
[null,"Product technical data (6.1.2.3.1)"]
[null,null,"Type:","Worst case, glazed collector",null,null,null,"\u0082å",null,null,null,null,null,null,"Enter value keyboard",null,null,null,null,{"$f":"VLOOKUP(D7,V11:AA19,6,FALSE)","v":6}]
[null,null,"Symbol:","ηo ","a1 ","a2 ","IAM ",null,null,null,null,null,null,null,"Select value from list",null,null,null,null,null,null,"Annex A.1.2.2.1, table A.1",null,null,null,null,null,null,"Annex A.1.2.2.2, formula (70)"]
[null,null,"Dimension:","-","W/(m2.K)","W/(m2.K2)","-",null,null,null,null,null,null,null,"All others: no changes!",null,null,null,null,null,null,"Collector specifications","ηo ","a1 ","a2 ","IAM ",null,null,"Collector pump power"]
[null,null,"Value:",0.6,6,0,0.85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","W/(m2.K)","W/(m2.K2)","-",null,null,"Default",0]
[null,null,"Amod =",2,"m2","...Module aperture area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typical, unglazed collector",1,15,0,1,0,null,"Manual input",1]
[null,null,"Collector pump:","Default",null,null,"\u0082",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D12,AC10:AD12,2,FALSE)","v":0},null,"Typical, glazed collector",0.8,3.5,0,0.94,1,null,"Thermo syphon",2]
[null,null,null,null,"Psol;pmp =",41,"W","...Power collector pump",null,null,null,null,null,null,null,null,null,null,null,null,null,"Typical, evacuated collector circular absorber",0.8,1.8,0,1,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Typical: evacuated collector flat absorber",0.8,1.8,0,0.97,3]
[null,null,"Vst;tot =",600,"l","…Total storage volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manual input",0.8,3.5,0,0.94,4]
[null,null,"Vst;bu =",200,"l","…Back up heating designated storage volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst case, unglazed collector",0.6,20,0.6,0.85,5]
[null,null,"Energy label:","Default ",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D17,V25:Y35,4,FALSE)","v":9},null,"Worst case, glazed collector",0.6,6,0,0.85,6]
[null,null,null,null,"Hst;ls =",2.761846689540095,"W/K","...Storage heat losses",null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst case, evacuated collector circular absorber",0.6,3,0,0.85,7]
[null,null,"Storage heat exchanger:","Typical value",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D19,Z25:AA27,2,FALSE)","v":0},null,"Worst case, evacuated collector flat absorber",0.6,3,0,0.85,8]
[null,null,null,null,"Hst;hx",800,"W/K","...Heat exchanger heat transfer value"]
[null,"System design data (6.1.2.3.2)"]
[null,null,"Type of service:","Water and space heating services",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annex A.1.2.2.3,  + formula (72)"]
[null,null,null,null,"SOL_USE:",{"$f":"VLOOKUP(D22,V39:X41,2,FALSE)","v":"COMBI"},"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annex A.1.2.2.3,  + formula (71)",null,null,null,"Table A.5",null,null,null,"Table A.10 & form (74)"]
[null,null,null,null,"taux =",{"$f":"VLOOKUP(D22,V39:X41,3,FALSE)","v":2000},"h","…collector pump operation time",null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage E-label heat losses","c1","c2",null,"Constants Hst;hx",null,null,null,"Constants Hloop;p"]
[null,null,"Location of storage tank:","Heated space",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,"For convenience","A+",5.5,3.16,1,"Typical value",0,null,null,"Default",0]
[null,null,null,null,"STO_LOC:",{"$f":"VLOOKUP(D25,Z39:AB41,2,FALSE)","v":"HS"},"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",8.5,4.25,2,"Worst case",1,null,null,"Manual input",1]
[null,null,null,null,"frbl =",{"$f":"VLOOKUP(D25,Z39:AB41,3,FALSE)","v":1},"-","...factor determining the recoverable part of the system heat losses",null,null,null,null,null,null,null,null,null,null,null,null,null,"B",12,5.93,3,"Manual input",2]
[null,null,"System layout type:","Integrated backup heating",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",16.66,8.33,4]
[null,null,null,null,"SOL_TYPE:",{"$f":"VLOOKUP(D28,AD31:AE32,2,FALSE)","v":"PAR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",21,10.33,5,"Table A.11"]
[null,null,"Orientation collector:","South east - South west / -20o - +5o",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E",26,13.66,6,"Constants:",null,null,null,"Table A.8","SOL_TYPE"]
[null,null,null,null,"fcol =",{"$f":"VLOOKUP(D30,AD39:AE41,2,FALSE)","v":1},"-","...factor for the effect of the collector orientation",null,null,null,null,null,null,null,null,null,null,null,null,null,"F",31,16.66,7,"Typical",0,null,null,"External backup heating","SER"]
[null,null,"Ncol =",4,"-","...Number of collector modules",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G",31,16.66,8,"Worst case",1,null,null,"Integrated backup heating","PAR"]
[null,null,"Collector loop heat losses:","Default",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D33,AD25:AE26,2,FALSE)","v":0},null,"Default ",16.66,8.33,9,"Calculated",2]
[null,null,null,null,"Hloop;p =",9,"W/K","...'Heat loss coefficient of collector loop",null,null,null,null,null,null,null,null,null,null,null,null,null,"Worst case",26,13.66,10,"Manual input",3]
[null,null,"Collector loop efficiency:","Typical",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D35,Z31:AA34,2,FALSE)","v":0},null,"Manual input",null,null,0]
[null,null,null,null,"ηloop =",0.9,"-","...efficiency of the collector loop"]
[null,null,"Operation backup heater:","Permantly powered backup heater",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table A.7 and Table A.16"]
[null,null,null,null,"fbu =",{"$f":"VLOOKUP(D37,V45:W47,2,FALSE)","v":1},null,"...factor for the effect of the type of back up heater control",null,null,null,null,null,null,null,null,null,null,null,null,null,"Table A.6 and table A.12","SOL_USE:","taux",null,null,"STO_LOC","frbl",null,"Table A.9","fcol "]
[null,null,"Insulation backup loop:","Insulated",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water heating service only","WHS",2000,null,"Heated space","HS",1,null,"South east - South west / -20o - +5o",1]
[null,null,null,null,"fbu;ins =",{"$f":"VLOOKUP(D39,Z45:AA46,2,FALSE)","v":0.02},"-","...factor for the effect of insulation in the back up heater loop",null,null,null,null,null,null,null,null,null,null,null,null,null,"Space heating service only","SHS",1500,null,"Unheated space","NHS",0.5,null,"East - West / minimum shading",0.8]
[null,null,"Type of space heating emittors:","Medium temperature emission",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water and space heating services","COMBI",2000,null,"Outside","OUT",0,null,"other cases",0]
[null,null,null,null,"ϑH;dis;rtn =",{"$f":"VLOOKUP(D41,AD45:AE47,2,FALSE)","v":45},"oC","...space heating distribution return temperature "]
[null,null,"fapp =",1.08,"-","...correction factor ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table A.14",null,null,null,"Table A.13",null,null,null,"Table A.15"]
[null,null,"ϑW;bu;set =",80,"oC","...thermostat setting back up heating designated part of the heat storage (WH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fbu ",null,null,null,"fbu;ins ",null,null,null,"ϑH;dis;rtn"]
[null,null,"ϑH;bu;set =",80,"oC","...thermostat setting back up heating designated part of the heat storage  (SH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permantly powered backup heater",1,null,null,"Insulated",0.02,null,null,"Low temperature emission",30]
[null,null,"ϑi;hr =",20,"oC","…temperature heated room",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Night powered backup heater",0.7,null,null,"Not insulated",0.05,null,null,"Medium temperature emission",45]
[null,null,"ϑW;hw =",60,"oC","...the domestic hot water temperature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency powered backup heater",0.3,null,null,null,null,null,null,"High temperature emission",60]
[null,"Operating conditions (6.1.2.3.3)",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"tci =",{"$f":"SUM(tbl_tci)","v":8760},"h",null,null,744,672,744,720,744,720,744,744,720,744,720,744,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"Location of application:","Würzburg (DE)",null,null,"\u0082å"]
[null,null,null,null,"Isol;45,m =",{"$f":"AVERAGE(H51:S51)","v":145.41666666666666},"W/m2",{"$f":"VLOOKUP($D$50,$V$52:$AH$58,H48+1,FALSE)","v":67},108,145,184,204,209,210,200,177,121,67,53,null,null,"Isol;45,m ="]
[null,null,null,null,"ϑW;cw =",{"$f":"VLOOKUP(D50,V61:W67,2,FALSE)","v":10},"oC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Athens (GR)",150,154,164,206,220,236,250,267,252,193,142,117]
[null,null,null,null,"ϑoutside,m =",{"$f":"AVERAGE(H53:S53)","v":9.3916666666666675},"oC",{"$f":"VLOOKUP($D$50,$V$70:$AH$76,H48+1,FALSE)","v":0.6},1.1000000000000001,5.6,8.3000000000000007,13.3,16.7,18.3,18.3,15,9.4,4.4000000000000004,1.7,null,null,"Birmingham (UK)",42,67,97,154,175,175,174,164,127,80,53,32]
[null,null,"Water heating load:","Load profile: L",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carpentras (FR)",141,163,208,220,234,255,270,267,238,177,138,119]
[null,null,null,null,"QW;sol;us =",{"$f":"SUM(H55:S55)","v":2552.4449999999997},"kWh/a",{"$f":"0.6*VLOOKUP($D$54,$V$79:$W$83,2,FALSE)*H49/24","v":216.78299999999999},195.80399999999997,216.78299999999999,209.79,216.78299999999999,209.79,216.78299999999999,216.78299999999999,209.79,216.78299999999999,209.79,216.78299999999999,null,null,"Davos (CH)",173,215,251,249,231,217,229,217,208,195,153,141]
[null,null,"ϑW;srv =",40,"oC",null,"...Domestic hot water service temperature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stockholm (SE)",37,84,150,190,237,245,222,204,148,94,45,36]
[null,null,"Water heating load:","Medium",null,null,"\u0082å",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Würzburg (DE)",67,108,145,184,204,209,210,200,177,121,67,53]
[null,null,null,null,"QH;sol;us =",{"$f":"SUM(H58:S58)","v":12093},"kWh/a",{"$f":"VLOOKUP($D$57,$V$87:$AH$89,H48+1,FALSE)","v":2409},2211,1425,903,92.999999999999886,0,0,0,0,927,1839,2286,null,null,"Zürich (CH)",72,105,141,164,183,190,214,204,171,121,72,57]
[]
["Compliments to the Solar Certification Fund (= SCF), Project ref.: 5C8_1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ϑW;cw =","Annual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V52","v":"Athens (GR)"},17.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V53","v":"Birmingham (UK)"},3.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carpentras (FR)",13.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Davos (CH)",5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stockholm (SE)",8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Würzburg (DE)",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zürich (CH)",9.6999999999999993]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ϑoutside,m ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V52","v":"Athens (GR)"},9.3000000000000007,9.8000000000000007,11.7,15.5,20.2,24.6,27,26.6,23.3,18.3,14.4,11.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V53","v":"Birmingham (UK)"},3.2,5.3,7.6,10.7,14,15.8,15.5,13.3,10.1,6.1,4.3,9.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carpentras (FR)",5.5,5.8,9.8000000000000007,11.3,15.1,18.899999999999999,22.9,21.3,18.399999999999999,13.9,8.6999999999999993,5.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Davos (CH)",-5.0999999999999996,-5,-1.6,1.5,6.1,8.9,12.5,11.8,8.9,5.3,-0.7,-3.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stockholm (SE)",-2.8,-3,0.1,4.5999999999999996,10.7,15.6,17.2,16.2,11.9,7.5,2.6,-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Würzburg (DE)",0.6,1.1000000000000001,5.6,8.3000000000000007,13.3,16.7,18.3,18.3,15,9.4,4.4000000000000004,1.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zürich (CH)",0.1,0.5,4.8,8,12.5,15.2,18.8,18.100000000000001,14.5,9.9,4.0999999999999996,1.6]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qrefs ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load profile: S",2.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load profile: M",5.8449999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load profile: L",11.654999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load profile: XL",19.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load profile: XXL",24.53]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QH;sol;us ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",1539,1365.9999999999998,805,417.99999999999989,0,0,0,0,0,497,1159,1471]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",2409,2211,1425,903,92.999999999999886,0,0,0,0,927,1839,2286]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High",3279,3055.9999999999995,2045,1387.9999999999998,327.99999999999989,0,0,0,69,1357,2519,3101]

{"sheet":"Outputs","index":2,"n_rows":73,"n_cols":24,"rows_kept":73,"cut":false,"hidden":false,"merged":[[25,2,25,14],[31,2,31,14],[51,2,51,14],[2,5,2,6]]}
["Output sheet",null,null,null,"Method:","prEN 15316-4-3, method 2 (monthly, using components data)"]
[null,null,null,null,"Author:","Gerard van Amerongen"]
[null,null,null,null,"Date:","2014-08-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:"]
[null,"Product technical  data",null,null,null,"System design data",null,null,null,null,null,null,"Operational conditions",null,null,null,null,null,"- No inputs in this sheets. Only outputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Click 'RUN' button to start calculations"]
[null,"Worst case, glazed collector",null,null,null,"SOL_USE:","COMBI",null,"...Water and space heating services",null,null,null,null,"Location:","Würzburg (DE)"]
[null,"Asol;mod =",2,"m2",null,"taux =",2000,"h","...Water and space heating services",null,null,null,null,"Water heating:","Load profile: L"]
[null,"ηo =",0.60000002384185791,"-",null,"STO_LOC:","HS",null,"...Heated space",null,null,null,null,"Space heating:","Low"]
[null,"a1 =",6,"W/(m2.K)",null,"ƒrbl =",1,"-","...Heated space"]
[null,"a2 =",0,"W/(m2.K2)",null,"SOL_TYPE:","PAR",null,"...Integrated backup heating",null,null,null,null," ϑw_srv =",40,"oC"]
[null,"IAM =",0.85000002384185791,"-",null,"ƒcol =",1,"-","...South east - South west / -20o - +5o"]
[null,"Psol;pmp =",41,"W",null,"Ncol =",4,"-",null,null,null,null,"Annual results",null,null,"Dimensions:","MJ","\u0082å",null,null,null,null,"kWh","MJ"]
[null,"Vsto;tot =",600,"l",null,"Hloop;p =",9,"W/K","...Default",null,null,null,null,"WHS","SHS","Total"]
[null,"Vsto;bu =",200,"l",null,"ηloop =",0.89999997615814209,"-","...Typical",null,null,null,"Qsol;us =",{"$f":"IF(Q13=\"kWh\",O34,O34*3.6)","v":9188.8020263671879},{"$f":"IF(Q13=\"kWh\",O54,O54*3.6)","v":43534.8},{"$f":"SUM(N15:O15)","v":52723.602026367189},{"$f":"$Q$13&\"/a\"","v":"MJ/a"}]
[null,"Vsto;sol =",0,"l",null,"ƒbu =",1,"-","...Permantly powered backup heater",null,null,null,"Qbu;out =",{"$f":"IF(Q13=\"kWh\",O44,O44*3.6)","v":7133.9315734863285},{"$f":"IF(Q13=\"kWh\",O64,O64*3.6)","v":42380.635350036624},{"$f":"SUM(N16:O16)","v":49514.566923522951},{"$f":"$Q$13&\"/a\"","v":"MJ/a"}]
[null,"Label class:","Default ",null,null,"ƒbu;ins =",0.02,"-","...Insulated",null,null,null,"Qsol;bu;out =",{"$f":"IF(Q13=\"kWh\",O45,O45*3.6)","v":9188.8020263671879},{"$f":"IF(Q13=\"kWh\",O465,O65*3.6)","v":43534.8},{"$f":"SUM(N17:O17)","v":52723.602026367189},{"$f":"$Q$13&\"/a\"","v":"MJ/a"}]
[null,"Hsto;ls =",2.7618467807769775,"W/K",null,"ϑh;dis;rtn =",45,"oC","...Medium temperature emission",null,null,null,"Qsol;out =",{"$f":"IF(Q13=\"kWh\",(O40-O42),(O40-O42)*3.6)","v":2865.7720783531668},{"$f":"IF(Q13=\"kWh\",(O60-O62),(O60-O62)*3.6)","v":2085.2148615963756},{"$f":"SUM(N18:O18)","v":4950.9869399495419},{"$f":"$Q$13&\"/a\"","v":"MJ/a"}]
[null,"Def type Hhx:","Typical value",null,null,"ƒapp =",1.0800000429153442,"-",null,null,null,null,"fsolar =",{"$f":"N18/N15","v":0.31187657217228737},{"$f":"IF(O15<>0,O18/O15,0)","v":4.7897655705237546E-2},{"$f":"P18/P15","v":9.3904565501301343E-2},"-"]
[null,"Hsto;hx =",800,"W/K",null,"ϑw_bu_set =",80,"oC"]
[null,null,null,null,null,"ϑh_bu_set =",80,"oC"]
[null,null,null,null,null,"ϑi;hr =",20,"oC"]
[null,null,null,null,null,"  ϑw_hw =",60,"oC"]
[]
["Monthly values (including calculation results)"]
[null,null,"Output data for both water and space heating service",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref."]
[null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Okt","Nov","Dec","Annual",null,"formula"]
["(I)","tci =",744,672,744,720,744,720,744,744,720,744,720,744,{"$f":"SUM(C28:N28)","v":8760},"h"]
["(I)","Isol =",67,108,145,184,204,209,210,200,177,121,67,53,{"$f":"AVERAGE(out_tbl_Isol)","v":145.41666666666666},"W/m2","(14)"]
["(I)","Te =",0.60000002384185791,1.1000000238418579,5.5999999046325684,8.3000001907348633,13.300000190734863,16.700000762939453,18.299999237060547,18.299999237060547,15,9.3999996185302734,4.4000000953674316,1.7000000476837158,{"$f":"AVERAGE(out_tbl_Toutside)","v":9.3916666110356655},"oC",null,"WH"]
["(I)","Tst;amb =",20,20,20,20,20,20,20,20,20,20,20,20,{"$f":"AVERAGE(D31:N31)","v":20},"oC",null,"SH"]
[null,null,"Output data for the water heating service"]
["(C)","Asol",0.66047501564025879,0.65083485841751099,1.056329607963562,1.5082091093063354,5.5983190536499023,8,8,8,8,1.5162526369094849,0.81917619705200195,0.69293421506881714,{"$f":"AVERAGE(C33:N33)","v":3.7085442245006561},"m2","(16)"]
["(I)","Qsol;us =",216.78300476074219,195.80400085449219,216.78300476074219,209.78999328613281,216.78300476074219,209.78999328613281,216.78300476074219,216.78300476074219,209.78999328613281,216.78300476074219,209.78999328613281,216.78300476074219,{"$f":"SUM(C34:N34)","v":2552.4450073242187},"kWh","OID"]
["(C)","ƒuse =",8.2559376955032349E-2,8.1354357302188873E-2,0.13204120099544525,0.18852613866329193,0.69978988170623779,1,1,1,1,0.18953157961368561,0.10239702463150024,8.6616776883602142E-2,{"$f":"AVERAGE(C35:N35)","v":0.46356802806258202},"-","(15)"]
["(C)","ƒst =",1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,{"$f":"AVERAGE(C36:N36)","v":1.1066819429397583},"-","(29)"]
["(C)","Hloop =",19.626556396484375,19.828392028808594,14.520068168640137,11.967342376708984,7.6076254844665527,7.125,7.125,7.125,7.125,11.935686111450195,16.98664665222168,18.988245010375977,{"$f":"AVERAGE(C37:N37)","v":12.496713519096375},"W/K","(33)"]
["(C)","X =",4.2542300224304199,4.1840753555297852,4.4255247116088867,4.8213424682617187,9.6878786087036133,11.428792953491211,10.705530166625977,10.705530166625977,12.197258949279785,4.676358699798584,4.1473879814147949,4.203364372253418,{"$f":"AVERAGE(C38:N38)","v":7.1197728713353472},"-","(32)"]
["(C)","Y =",6.9709442555904388E-2,0.11072736978530884,0.24128362536430359,0.43715938925743103,1.7990707159042358,2.6338844299316406,2.6464865207672119,2.5204634666442871,2.2306101322174072,0.28901296854019165,8.6459465324878693E-2,5.7853318750858307E-2,{"$f":"AVERAGE(C39:N39)","v":1.093560070420305},"-","(34)"]
["(C)","Qsol;tmp =",0,0,0,30.194513320922852,169.1988525390625,202.94349670410156,214.51402282714844,208.79951477050781,178.96151733398438,3.0081799030303955,0,0,{"$f":"SUM(C40:N40)","v":1007.6200973987579},"kWh","(35)"]
["(C)","ftmp =",0,0,0,0.14392733573913574,0.7804986834526062,0.96736502647399902,0.98953342437744141,0.96317291259765625,0.85305076837539673,1.3876456767320633E-2,0,0,{"$f":"AVERAGE(C41:N41)","v":0.39261871731529635},"-","(36)"]
["(O)","Qsol;st;ls =",0,0,0,-0.10085023194551468,21.716625213623047,49.204319000244141,53.512134552001953,50.347564697265625,36.926033020019531,-3.3528394997119904E-2,0,0,{"$f":"SUM(C42:N42)","v":211.57229785621166},"kWh","(37)"]
["(O)","Qbu;st;ls =",3.39288330078125,3.0198104381561279,5.4264020919799805,7.4977960586547852,28.758760452270508,39.770591735839844,41.096279144287109,41.096279144287109,39.770591735839844,7.7890424728393555,4.0723905563354492,3.5596272945404053,225.25045442581177,"kWh","(39)"]
["(O)","QW;bu;out =",220.17588806152344,198.82380676269531,222.20941162109375,186.992431640625,98.059539794921875,95.821403503417969,96.877395629882813,99.427337646484375,107.52509307861328,221.53033447265625,213.86238098144531,220.34263610839844,1981.6476593017578,"kWh","(40)"]
["(O)","Qsol;bu;out =",216.78300476074219,195.80400085449219,216.78300476074219,209.78999328613281,216.78300476074219,209.78999328613281,216.78300476074219,216.78300476074219,209.78999328613281,216.78300476074219,209.78999328613281,216.78300476074219,2552.4450073242187,"kWh","(41)"]
["(O)","Qbu;dis;ls =",0,0,0,0.60590726137161255,2.9496445655822754,3.0747835636138916,3.2200379371643066,3.1690390110015869,2.840709924697876,6.0834165662527084E-2,0,0,15.920956429094076,"kWh","(42)"]
["(O)","Qsol;ls;rbl =",3.39288330078125,3.0198104381561279,5.4264020919799805,8.0028533935546875,53.425029754638672,0,0,0,0,7.8163480758666992,4.0723905563354492,3.5596272945404053,88.715344905853271,"kWh","(43)"]
["(O)","Wsol;aux =",0.25993192195892334,0.41287916898727417,0.8996962308883667,1.6300758123397827,6.7083582878112793,9.8212032318115234,9.868194580078125,9.3982810974121094,8.3174781799316406,1.0776689052581787,0.32238924503326416,0.21572293341159821,48.931879594922066,"kWh","(44)"]
["(O)","Wbu;aux =",10.839150428771973,9.7902002334594727,10.839150428771973,8.9747314453125,3.4650392532348633,2.8025405406951904,2.7890558242797852,2.9165525436401367,3.3877253532409668,10.687065124511719,10.489500045776367,10.839150428771973,87.819861650466919,"kWh","(46)"]
["(C)","fsol =",0,0,0,0.14440804719924927,0.68032187223434448,0.73282420635223389,0.74268686771392822,0.73092424869537354,0.67703652381896973,1.4031119644641876E-2,0,0,{"$f":"AVERAGE(C50:N50)","v":0.3101860738048951},"-","(47)"]
["(O)","Qbu;ls =",2.1678299903869629,1.9580399990081787,2.1678299903869629,2.0978999137878418,2.1678299903869629,2.0978999137878418,2.1678299903869629,2.1678299903869629,2.0978999137878418,2.1678299903869629,2.0978999137878418,2.1678299903869629,{"$f":"SUM(C51:N51)","v":25.524449586868286},"kWh","(48)"]
[null,null,"Output data for the space heating service"]
["(C)","Asol",7.3395252227783203,7.3491649627685547,6.9436702728271484,6.491790771484375,2.4016811847686768,null,null,null,null,6.4837474822998047,7.180823802947998,7.3070659637451172,{"$f":"AVERAGE(C53:N53)","v":6.4371837079524994},"m2","(23)"]
["(I)","Qsol;us =",2409,2211,1425,903,93,0,0,0,0,927,1839,2286,{"$f":"SUM(C54:N54)","v":12093},"kWh"]
["(C)","ƒuse =",0.91744065284729004,0.91864562034606934,0.86795878410339355,0.81147384643554688,0.30021014809608459,null,null,null,null,0.81046843528747559,0.89760297536849976,0.91338324546813965,{"$f":"AVERAGE(C55:N55)","v":0.80464796349406242},"-","(22)"]
["(C)","ƒst =",1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,1.1066819429397583,null,null,null,null,1.1066819429397583,1.1066819429397583,1.1066819429397583,{"$f":"AVERAGE(C56:N56)","v":1.1066819429397583},"-","(29)"]
["(C)","Hloop =",7.2262372970581055,7.2246289253234863,7.2961444854736328,7.3863663673400879,9.7473745346069336,null,null,null,null,7.3880863189697266,7.2533378601074219,7.231684684753418,{"$f":"SUM(C57:N57)","v":60.753860473632813},"W/K","(33)"]
["(C)","X =",1.4381492137908936,1.4088064432144165,2.1906256675720215,3.0635957717895508,14.074000358581543,null,null,null,null,3.0385298728942871,1.7132208347320557,1.4911224842071533,{"$f":"AVERAGE(C58:N58)","v":3.5522563308477402},"-","(32)"]
["(C)","Y =",6.9709442555904388E-2,0.11072736978530884,0.24128364026546478,0.43715935945510864,1.7990705966949463,null,null,null,null,0.28901299834251404,8.6459465324878693E-2,5.7853322476148605E-2,{"$f":"AVERAGE(C59:N59)","v":0.38640952436253428},"-","(34)"]
["(C)","Qsol;tmp =",0,54.835090637207031,154.77224731445312,217.06117248535156,62.793735504150391,null,null,null,null,96.675285339355469,0,0,{"$f":"SUM(C60:N60)","v":586.13753128051758},"kWh","(35)"]
["(C)","ftmp =",0,2.4801036342978477E-2,0.10861210525035858,0.24037782847881317,0.67520147562026978,null,null,null,null,0.10428833216428757,0,0,{"$f":"AVERAGE(C61:N61)","v":0.14416009723208845},"-","(36)"]
["(O)","Qsol;st;ls =",0,1.7478538677096367E-2,0.35065251588821411,1.5539754629135132,4.6871981620788574,null,null,null,null,0.30187615752220154,0,0,{"$f":"SUM(C62:N62)","v":6.9111808370798826},"kWh","(37)"]
["(O)","Qbu;st;ls =",37.703395843505859,34.099411010742187,35.669876098632812,32.272796630859375,12.337520599365234,null,null,null,null,33.307239532470703,35.698204040527344,37.536651611328125,258.62509536743164,"kWh","(39)"]
["(O)","QH;bu;out =",2446.703369140625,2190.28173828125,1306.248291015625,719.765625,47.230983734130859,null,null,null,null,863.933837890625,1874.6982421875,2323.53662109375,11772.398708343506,"kWh","(40)"]
["(O)","Qsol;bu;out =",2409,2211,1425,903,93,null,null,null,null,927,1839,2286,12093,"kWh","(41)"]
["(O)","Qbu;dis;ls =",0,1.096352219581604,3.0884320735931396,4.3101439476013184,1.1621307134628296,null,null,null,null,1.9274680614471436,0,0,11.584527015686035,"kWh","(42)"]
["(O)","Qsol;ls;rbl =",37.703395843505859,35.213241577148437,39.108959197998047,38.136917114257812,18.186849594116211,null,null,null,null,35.536582946777344,35.698204040527344,37.536651611328125,277.12080192565918,"kWh","(43)"]
["(O)","Wsol;aux =",2.8884923458099365,4.6621923446655273,5.914057731628418,7.0163421630859375,2.8778882026672363,null,null,null,null,4.6082911491394043,2.8260350227355957,2.2748215198516846,{"$f":"SUM(C68:N68)","v":33.06812047958374},"kWh","(44)"]
["(O)","Wbu;aux =",120.44999694824219,107.80912017822266,63.528919219970703,34.374641418457031,1.7446732521057129,null,null,null,null,41.531330108642578,91.949996948242188,114.30000305175781,{"$f":"SUM(C69:N69)","v":575.68868112564087},"kWh","(46)"]
["(C)","fsol =",0,2.4793131276965141E-2,0.10836603492498398,0.23865692317485809,0.62480145692825317,null,null,null,null,0.10396268218755722,0,0,{"$f":"AVERAGE(C70:N70)","v":0.1375725285615772},"-","(47)"]
["(O)","Qbu;ls =",24.090000152587891,22.110000610351563,14.25,9.0299997329711914,0.93000000715255737,null,null,null,null,9.2700004577636719,18.389999389648438,22.860000610351563,{"$f":"SUM(C71:N71)","v":120.93000096082687},"kWh","(48)"]
[]
["Compliments to the Solar Certification Fund (= SCF), Project ref.: 5C8_1"]