{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Kühlsegel","Prototyp","Konvektion+Strahlung","Kollektorfeld","Raum","Leistung","Kuehlsegel","Koll","Waerme","Simulation","Kollektormodelle","Umgebungsprofile","Decke","Wand","Luft"],"not_rendered":{"charts":19,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":4,"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":"Kühlsegel","index":0,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Halbempirisches Modell für plattenförmige Kühlsegel",null,"FHNW","Institut Nachhaltigkeit und Energie am Bau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wärmeübergang Rohr - Blech"]
["Parameter des empirischen Modells nach DIN EN 14240 aus Datenblatt",null,null,null,null,null,null,null,"Temperaturverteilung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L_P","U"]
["Leistungsfaktor k","W/Kmn",11.446999999999999,null,null,null,null,null,"Ort","ϑ(x)",null,null,null,null,null,null,null,null,null,null,null,null,null,"W/Km","W/Km2"]
["Exponent n"," -",1.0680000000000001,null,null,null,null,null,"m","°C",null,null,null,null,null,null,null,null,null,null,null,"Recknagel (2021)","Blechlamellen + Rohre",null,"15..35"]
["Abmessungen des Kühlsegels",null,null,null,"Prüfraum",null,null,null,0,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I5,C$16,C$25,C$18,C$9)","v":19.673320461241552},null,null,null,null,null,null,null,null,null,null,null,null,"Al-Strangpressprofil + Rohr",null,180]
["Breite B_P","m",0.86499999999999999,null,"Länge","m",4.0999999999999996,null,{"$f":"C16/10","v":6.7083333333333326E-3},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I6,C$16,C$25,C$18,C$9)","v":19.667386686294993},null,null,null,null,null,null,null,null,null,null,null,"Eismann (2015)","Laser welding",{"$f":"20*0.003/0.001","v":60}]
["Länge (Richtung der Strömungskanäle) L_P","m",2.3650000000000002,null,"Breite","m",4,null,{"$f":"I6+I$6","v":1.3416666666666665E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I7,C$16,C$25,C$18,C$9)","v":19.649585361455316},null,null,null,null,null,null,null,null,null,null,null,"Garg et al. (1981)","Aluminiumblech + Rohr geklemmt",25.58111111111111]
["Fläche einer Seite","m2",{"$f":"C6*C7","v":2.045725},null,"Höhe","m",2.875,null,{"$f":"I7+I$6","v":2.0124999999999997E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I8,C$16,C$25,C$18,C$9)","v":19.619916486722524},null,null,null,null,null,null,null,null,null,null,null,null,"Aluminiumblech + Rohr genietet",27.325277777777778]
["Dicke der Platte   s","m",2E-3,null,"Gesamte Oberfläche","m2",{"$f":"Oberfläche_Quader(G6,G7,G8)","v":79.375},null,2.6833333333333331E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I9,C$16,C$25,C$18,C$9)","v":19.578380062096613},null,null,null,null,null,null,null,null,null,null,null,null,"Aluminiumblech + wärmeleitender Epoxi Klebstoff",38.953055555555558]
["Durchmesser eines kreisförmigen Strömungskanals   d","m",0.01,null,"Emissionsvermögen Raumflächen"," -",0.93,null,3.3541666666666664E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I10,C$16,C$25,C$18,C$9)","v":19.524976087577581}]
["Wärmeleitvermögen der Verbindung Rohr-Platte","W/Km",60,null,"Ref.temperatur des Raumknotens","°C",26,null,4.0249999999999994E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I11,C$16,C$25,C$18,C$9)","v":19.459704563165438}]
["Höhe eines volldurchströmten Plattenspaltes   h","m",3.5000000000000001E-3,null,"Temperaturdifferenz Raum-Globus","K",0.4,null,4.6958333333333324E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I12,C$16,C$25,C$18,C$9)","v":19.382565488860173}]
["Anzahl Strömungskanäle pro Plattenbreite   n"," -",6,null,null,null,null,null,{"$f":"I12+I$6","v":5.3666666666666654E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I13,C$16,C$25,C$18,C$9)","v":19.29355886466179}]
["Anzahl seriell geschaltete Strömungskanäle   m"," -",6,null,null,null,null,null,{"$f":"I13+I$6","v":6.0374999999999984E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I14,C$16,C$25,C$18,C$9)","v":19.192684690570292}]
["Querschnitt total","m2",{"$f":"Querschnitt(C10,C6,C12,C13,C14)","v":7.8537500000000005E-5},null,null,null,null,null,{"$f":"I14+I$6","v":6.7083333333333314E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,I15,C$16,C$25,C$18,C$9)","v":19.079942966585676}]
["Halbe Plattenbreite b zwischen zwei Strömungskanälen","m",{"$f":"(C6-C13*C10)/(C13*2)","v":6.7083333333333328E-2},null,null,null,null,null,{"$f":"I15+C10","v":7.7083333333333309E-2},{"$f":"J15","v":19.079942966585676}]
["Stoffdaten",null,null,null,null,null,null,null,{"$f":"I16+I$6","v":8.3791666666666639E-2},{"$f":"J14","v":19.192684690570292}]
["Wärmeleitfähigkeit des Plattenmaterials","W/Km ",200,null,"Emissionsvermögen der Oberseite"," -",0.93,null,9.0499999999999969E-2,{"$f":"J13","v":19.29355886466179}]
["Dichte von Wasser","kg/m3",{"$f":"rho_sat_Wasser(C24)","v":998.39060518823999},null,"Emissionsvermögen der Unterseite"," -",{"$f":"G18","v":0.93},null,9.7208333333333299E-2,{"$f":"J12","v":19.382565488860173}]
["Wärmeleitfähigkeit von Wasser","W/Km",{"$f":"lamda_sat_Wasser(C24)","v":0.59553496250959992},null,null,null,null,null,0.10391666666666663,{"$f":"J11","v":19.459704563165438}]
["Kinemat. Viskosität von Wasser","m2/s",{"$f":"ny_sat_Wasser(C24)","v":1.0949925624666294E-6},null,null,null,null,null,0.11062499999999996,{"$f":"J10","v":19.524976087577581}]
["Wärmekapazität von Wasser","J/kgK",{"$f":"cp_sat_Wasser(C24)","v":4189.6574657092797},null,null,null,null,null,0.11733333333333329,{"$f":"J9","v":19.578380062096613}]
["Betriebsbedingungen",null,null,null,"Flächenbezogener Durchfluss aus Datenblatt/Prüfbericht",null,null,null,0.12404166666666662,{"$f":"J8","v":19.619916486722524}]
["Mittlere Temperatur des Fluids","°C",18,null,"Gesamtmassenstrom im Test","kg/h",198.2,null,{"$f":"I23+I$6","v":0.13074999999999995},{"$f":"J7","v":19.649585361455316}]
["Leistungsdichte Kühlsegel nach empirischem Modell","W/m2",{"$f":"qs_Kuehlsegel(C3,C4,G11,C24)","v":105.48526273578479},null,null,"kg/m2s",{"$f":"G24/C8/3600","v":2.6912490953356658E-2},null,{"$f":"I24+I$6","v":0.13745833333333329},{"$f":"J6","v":19.667386686294993}]
["Flächenbezogener Massenstrom Wasser","kg/m2s",{"$f":"G24/3600/C8","v":2.6912490953356658E-2},null,null,null,null,null,{"$f":"I25+I$6","v":0.14416666666666664},{"$f":"J5","v":19.673320461241552}]
["Volumenstrom","m3/s",{"$f":"Volumenstrom(C26*C6*C7,C24)","v":5.5144304513137117E-5}]
["Fliessgeschwindigkeit","m/s",{"$f":"Fliessgeschwindigkeit(C27,C15)","v":0.70213979962612905}]
["Reynoldszahl"," -",{"$f":"Reynoldszahl_Kanal(C28,C10,C12,C21)","v":6412.2791669420794}]
["Prandtlzahl Wasser"," -",{"$f":"C22*C21*C19/C20","v":7.6910017421324}]
["Nusseltzahl"," -",{"$f":"Nu_Rohrstroemung(C29,C30)","v":46.057857181086696}]
["Wärmeübergang zum Fluid","W/Km2",{"$f":"alpha_Rohrstroemung(C31,C20,C10,C12)","v":2742.9064249610974}]
["Temperatur an der Basis","°C",{"$f":"Temperatur_Basis(C24,C16,C10,C32,C11,C18,C9,C25)","v":18.429942966585678}]
["Innerer Wärmedurchgangskoeffizient U","W/Km2",{"$f":"1/(C37/C25)","v":72.84448410919822},null,null,null,null,null,"x","ϑ_m","ϑ_b","ϑ_P","ϑ_i"]
["Temperaturzuschlag zur Berücksichtigung der inhomogenität","K",0.65,"proportional zur Leistung",null,null,null,null,"m","°C","°C","°C","°C"]
["Mittlere Plattentemperatur (basierend auf Fluidtemp.)","°C",{"$f":"Temperatur_Mittelwert(C24,C25,C10,C16,C11,C32,C18,C9,C35,C25)","v":19.448088541304735},null,null,null,null,null,0,{"$f":"C24","v":18},{"$f":"C33","v":18.429942966585678},{"$f":"C36","v":19.448088541304735},{"$f":"G11","v":26}]
["Temperaturdifferenz","K",{"$f":"C36-C24","v":1.4480885413047346},null,null,null,null,null,{"$f":"I26","v":0.14416666666666664},{"$f":"J36","v":18},{"$f":"K36","v":18.429942966585678},{"$f":"L36","v":19.448088541304735},{"$f":"M36","v":26}]
["Beispiel KIGO Standard"]
["Länge","m",0.86499999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Re","Nu"]
["Breite","m",2.3650000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"]
["Blechdicke","m",6.4000000000000005E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,{"$f":"Nu_Rohrstroemung(S41,C$30)","v":4.3600000000000003}]
["Volumen","m3",{"$f":"C39*C40*C41","v":1.3092640000000001E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,{"$f":"Nu_Rohrstroemung(S42,C$30)","v":4.3600000000000003}]
["Dichte Edelstahl","kg/m3",7700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1700,{"$f":"Nu_Rohrstroemung(S43,C$30)","v":4.3600000000000003}]
["Masse","kg/m3",{"$f":"2*C42*C43","v":20.1626656},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1900,{"$f":"Nu_Rohrstroemung(S44,C$30)","v":4.3600000000000003}]
["Masse gefüllt","kg/m3",25.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2100,{"$f":"Nu_Rohrstroemung(S45,C$30)","v":4.3600000000000003}]
["Dichte Wasser","kg/m3",{"$f":"rho_sat_Wasser(C24)","v":998.39060518823999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2300,{"$f":"Nu_Rohrstroemung(S46,C$30)","v":4.3600000000000003}]
["Volumen Wasser","m3",{"$f":"(C45-C44)/C46","v":5.0454545283408819E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2500,{"$f":"Nu_Rohrstroemung(S47,C$30)","v":6.3879682136509004}]
["Durchströmter Anteil"," -",0.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2700,{"$f":"Nu_Rohrstroemung(S48,C$30)","v":8.4159364273018014}]
["Mittlere Höhe eines volldurchströmten Plattenspaltes","m",{"$f":"C47/(C39*C40)/C48","v":3.5233436475303952E-3},"wird in Zelle C12 benötigt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2900,{"$f":"Nu_Rohrstroemung(S49,C$30)","v":10.443904640952699}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3100,{"$f":"Nu_Rohrstroemung(S50,C$30)","v":12.4718728546036}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3300,{"$f":"Nu_Rohrstroemung(S51,C$30)","v":14.499841068254501}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3500,{"$f":"Nu_Rohrstroemung(S52,C$30)","v":16.527809281905398}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3700,{"$f":"Nu_Rohrstroemung(S53,C$30)","v":18.555777495556299}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3900,{"$f":"Nu_Rohrstroemung(S54,C$30)","v":20.5837457092072}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4100,{"$f":"Nu_Rohrstroemung(S55,C$30)","v":22.611713922858097}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4500,{"$f":"Nu_Rohrstroemung(S56,C$30)","v":26.667650350159899}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5000,{"$f":"Nu_Rohrstroemung(S57,C$30)","v":31.737570884287148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5500,{"$f":"Nu_Rohrstroemung(S58,C$30)","v":36.807491418414401}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6000,{"$f":"Nu_Rohrstroemung(S59,C$30)","v":41.877411952541649}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6500,{"$f":"Nu_Rohrstroemung(S60,C$30)","v":46.947332486668898}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7000,{"$f":"Nu_Rohrstroemung(S61,C$30)","v":52.017253020796147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8000,{"$f":"Nu_Rohrstroemung(S62,C$30)","v":62.157094089050645}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10000,{"$f":"Nu_Rohrstroemung(S63,C$30)","v":82.43677622555964}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12000,{"$f":"Nu_Rohrstroemung(S64,C$30)","v":95.381906028991935}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14000,{"$f":"Nu_Rohrstroemung(S65,C$30)","v":107.90049286643112}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16000,{"$f":"Nu_Rohrstroemung(S66,C$30)","v":120.06515504730027}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18000,{"$f":"Nu_Rohrstroemung(S67,C$30)","v":131.92861524231023}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,{"$f":"Nu_Rohrstroemung(S68,C$30)","v":143.53076395895499}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000,{"$f":"Nu_Rohrstroemung(S69,C$30)","v":298.74249473717288}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,{"$f":"Nu_Rohrstroemung(S70,C$30)","v":520.14089414787054}]

{"sheet":"Prototyp","index":1,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Analytisches Modell für plattenförmige Kühlsegel",null,"FHNW","Institut Nachhaltigkeit und Energie am Bau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wärmeübergang Rohr - Blech"]
["Parameter des empirischen Modells nach DIN EN 14240 aus Datenblatt",null,null,null,null,null,null,null,null,null,null,null,"Temperaturverteilung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L_P","U"]
["Leistungsfaktor k","W/Kmn",{"$f":"EXP(D4)","v":10.424897458235773},null,null,null,null,null,null,null,null,null,"Ort","ϑ(x)",null,null,null,null,null,null,null,null,null,null,null,null,null,"W/Km","W/Km2"]
["Exponent n"," -",{"$f":"LINEST(LN(C25:G25),LN(C23:G23))","v":1.0346658183014497},2.3441969314960365,null,null,null,null,null,null,null,null,"m","°C",null,null,null,null,null,null,null,null,null,null,null,"Recknagel (2021)","Blechlamellen + Rohre",null,"15..35"]
["Abmessungen des Kühlsegels",null,null,null,null,null,null,null,"Prüfraum",null,null,null,0,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M5,C$16,C$25,C$18,C$9)","v":19.626784227691658},null,null,null,null,null,null,null,null,null,null,null,null,"Al-Strangpressprofil + Rohr",null,180]
["Breite B_P","m",0.86499999999999999,null,null,null,null,null,"Länge","m",4.0999999999999996,null,{"$f":"C16/10","v":6.7083333333333326E-3},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M6,C$16,C$25,C$18,C$9)","v":19.621740891826899},null,null,null,null,null,null,null,null,null,null,null,"Eismann (2015)","Laser welding",{"$f":"20*0.003/0.001","v":60}]
["Länge (Richtung der Strömungskanäle) L_P","m",2.3650000000000002,null,null,null,null,null,"Breite","m",400,null,{"$f":"M6+M$6","v":1.3416666666666665E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M7,C$16,C$25,C$18,C$9)","v":19.606610884232619},null,null,null,null,null,null,null,null,null,null,null,"Garg et al. (1981)","Aluminiumblech + Rohr geklemmt",25.58111111111111]
["Fläche einer Seite","m2",{"$f":"C6*C7","v":2.045725},null,null,null,null,null,"Höhe","m",2.875,null,{"$f":"M7+M$6","v":2.0124999999999997E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M8,C$16,C$25,C$18,C$9)","v":19.581394204908818},null,null,null,null,null,null,null,null,null,null,null,null,"Aluminiumblech + Rohr genietet",27.325277777777778]
["Dicke der Platte   s","m",2E-3,null,null,null,null,null,"Gesamte Oberfläche","m2",{"$f":"Oberfläche_Quader(K6,K7,K8)","v":5603.5749999999989},null,2.6833333333333331E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M9,C$16,C$25,C$18,C$9)","v":19.546090853855496},null,null,null,null,null,null,null,null,null,null,null,null,"Aluminiumblech + wärmeleitender Epoxi Klebstoff",38.953055555555558]
["Durchmesser eines kreisförmigen Strömungskanals d","m",0.01,null,null,null,null,null,"Emissionsvermögen Raumflächen"," -",0.93,null,3.3541666666666664E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M10,C$16,C$25,C$18,C$9)","v":19.500700831072656}]
["Wärmeleitvermögen der Verbindung Rohr-Platte","W/Km",40,null,null,null,null,null,"Temperatur des Raumknotens","°C",26,null,4.0249999999999994E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M11,C$16,C$25,C$18,C$9)","v":19.445224136560295}]
["Höhe eines volldurchströmten Plattenspaltes","m",3.5000000000000001E-3,null,null,null,null,null,null,null,null,null,4.6958333333333324E-2,{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M12,C$16,C$25,C$18,C$9)","v":19.379660770318413}]
["Anzahl Strömungskanäle pro Plattenbreite n"," -",6,null,null,null,null,null,null,null,null,null,{"$f":"M12+M$6","v":5.3666666666666654E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M13,C$16,C$25,C$18,C$9)","v":19.30401073234701}]
["Anzahl seriell geschaltete Strömungskanäle m"," -",6,null,null,null,null,null,null,null,null,null,{"$f":"M13+M$6","v":6.0374999999999984E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M14,C$16,C$25,C$18,C$9)","v":19.218274022646089}]
["Querschnitt total","m2",{"$f":"Querschnitt(C10,C6,C12,C13,C14)","v":7.8537500000000005E-5},null,null,null,null,null,null,null,null,null,{"$f":"M14+M$6","v":6.7083333333333314E-2},{"$f":"Temperatur_oertlich(C$33+C$35,C$10,M15,C$16,C$25,C$18,C$9)","v":19.122450641215647}]
["Halbe Plattenbreite b zwischen zwei Strömungskanälen","m",{"$f":"(C6-C13*C10)/(C13*2)","v":6.7083333333333328E-2},null,null,null,null,null,null,null,null,null,{"$f":"M15+C10","v":7.7083333333333309E-2},{"$f":"N15","v":19.122450641215647}]
["Stoffdaten",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M16+M$6","v":8.3791666666666639E-2},{"$f":"N14","v":19.218274022646089}]
["Wärmeleitfähigkeit des Plattenmaterials","W/Km ",200,null,null,null,null,null,"Emissionsvermögen der Oberseite"," -",0.93,null,9.0499999999999969E-2,{"$f":"N13","v":19.30401073234701}]
["Dichte von Wasser","kg/m3",{"$f":"rho_sat_Wasser(C24)","v":998.39060518823999},{"$f":"rho_sat_Wasser(D24)","v":998.10609519256036},{"$f":"rho_sat_Wasser(E24)","v":997.79998862956506},{"$f":"rho_sat_Wasser(F24)","v":997.47262556894532},{"$f":"rho_sat_Wasser(G24)","v":997.12434138623996},null,"Emissionsvermögen der Unterseite"," -",{"$f":"K18","v":0.93},null,9.7208333333333299E-2,{"$f":"N12","v":19.379660770318413}]
["Wärmeleitfähigkeit von Wasser","W/Km",{"$f":"lamda_sat_Wasser(C24)","v":0.59553496250959992},{"$f":"lamda_sat_Wasser(D24)","v":0.59802515573633741},{"$f":"lamda_sat_Wasser(E24)","v":0.60047535368329996},{"$f":"lamda_sat_Wasser(F24)","v":0.60288575693281254},{"$f":"lamda_sat_Wasser(G24)","v":0.60525656606719991},null,null,null,null,null,0.10391666666666663,{"$f":"N11","v":19.445224136560295}]
["Kinemat. Viskosität von Wasser","m2/s",{"$f":"ny_sat_Wasser(C24)","v":1.0949925624666294E-6},{"$f":"ny_sat_Wasser(D24)","v":1.0562845835578642E-6},{"$f":"ny_sat_Wasser(E24)","v":1.0193587667862889E-6},{"$f":"ny_sat_Wasser(F24)","v":9.8412881511866598E-7},{"$f":"ny_sat_Wasser(G24)","v":9.5051264367273639E-7},null,null,null,null,null,0.11062499999999996,{"$f":"N10","v":19.500700831072656}]
["Wärmekapazität von Wasser","J/kgK",{"$f":"cp_sat_Wasser(C24)","v":4189.6574657092797},{"$f":"cp_sat_Wasser(D24)","v":4188.1915297114519},{"$f":"cp_sat_Wasser(E24)","v":4186.8315930744302},{"$f":"cp_sat_Wasser(F24)","v":4185.5751456574217},{"$f":"cp_sat_Wasser(G24)","v":4184.4197283532803},null,null,null,null,null,0.11733333333333329,{"$f":"N9","v":19.546090853855496}]
["Betriebsbedingungen","K",{"$f":"$K11-C24","v":8},6.5,5,3.5,2,"Mittlere Teperaturdifferenz",null,null,null,null,0.12404166666666662,{"$f":"N8","v":19.581394204908818}]
["Mittlere Temperatur des Fluids","°C",18,19.5,21,22.5,24,null,null,null,null,null,{"$f":"M23+M$6","v":0.13074999999999995},{"$f":"N7","v":19.606610884232619}]
["Leistungsdichte Kühlsegel","W/m2",89.655845317752437,72.291839066627062,55.118000437517885,38.093626221611032,21.361401198157278,null,null,null,null,null,{"$f":"M24+M$6","v":0.13745833333333329},{"$f":"N6","v":19.621740891826899}]
["Flächenbezogener Massenstrom Wasser","kg/m2s",2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,null,null,null,null,null,{"$f":"M25+M$6","v":0.14416666666666664},{"$f":"N5","v":19.626784227691658}]
["Volumenstrom","m3/s",{"$f":"Volumenstrom(C26*$C6*$C7,C24)","v":5.5323612534981632E-5},{"$f":"Volumenstrom(D26*$C6*$C7,D24)","v":5.5339382522600299E-5},{"$f":"Volumenstrom(E26*$C6*$C7,E24)","v":5.5356359620591196E-5},{"$f":"Volumenstrom(F26*$C6*$C7,F24)","v":5.5374527164086264E-5},{"$f":"Volumenstrom(G26*$C6*$C7,G24)","v":5.539386885612562E-5}]
["Fliessgeschwindigkeit","m/s",{"$f":"Fliessgeschwindigkeit(C27,$C15)","v":0.7044228876012304},{"$f":"Fliessgeschwindigkeit(D27,$C15)","v":0.70462368324176727},{"$f":"Fliessgeschwindigkeit(E27,$C15)","v":0.7048398487422084},{"$f":"Fliessgeschwindigkeit(F27,$C15)","v":0.7050711719126056},{"$f":"Fliessgeschwindigkeit(G27,$C15)","v":0.70531744524750106}]
["Reynoldszahl"," -",{"$f":"Reynoldszahl_Kanal(C28,$C10,$C12,C21)","v":6433.1294270567078},{"$f":"Reynoldszahl_Kanal(D28,$C10,$C12,D21)","v":6670.7750374278503},{"$f":"Reynoldszahl_Kanal(E28,$C10,$C12,E21)","v":6914.5414912586893},{"$f":"Reynoldszahl_Kanal(F28,$C10,$C12,F21)","v":7164.4195463130336},{"$f":"Reynoldszahl_Kanal(G28,$C10,$C12,G21)","v":7420.3899331858174}]
["Prandtlzahl Wasser"," -",{"$f":"C22*C21*C19/C20","v":7.6910017421324},{"$f":"D22*D21*D19/D20","v":7.383541672198298},7.0918715832918613,{"$f":"F22*F21*F19/F20","v":6.8151128790364988},6.5524384161200366]
["Nusseltzahl"," -",{"$f":"Nu_Rohrstroemung(C29,C30)","v":46.269275504880795},{"$f":"Nu_Rohrstroemung(D29,D30)","v":47.92153041620395},{"$f":"Nu_Rohrstroemung(E29,E30)","v":49.573746227282825},{"$f":"Nu_Rohrstroemung(F29,F30)","v":51.225669631845008},{"$f":"Nu_Rohrstroemung(G29,G30)","v":52.877022012216337}]
["Wärmeübergang zum Fluid","W/Km2",{"$f":"alpha_Rohrstroemung(C31,C20,$C10,$C12)","v":2755.4971253145536},{"$f":"alpha_Rohrstroemung(D31,D20,$C10,$C12)","v":2865.8280690273996},{"$f":"alpha_Rohrstroemung(E31,E20,$C10,$C12)","v":2976.7812799233811},{"$f":"alpha_Rohrstroemung(F31,F20,$C10,$C12)","v":3088.3226610385063},{"$f":"alpha_Rohrstroemung(G31,G20,$C10,$C12)","v":3200.4164766973799}]
["Temperatur an der Basis","°C",{"$f":"Temperatur_Basis(C24,$C16,$C10,C32,$C11,$C18,$C9,C25)","v":18.472450641215648},{"$f":"Temperatur_Basis(D24,$C16,$C10,D32,$C11,$C18,$C9,D25)","v":19.876314079924956},{"$f":"Temperatur_Basis(E24,$C16,$C10,E32,$C11,$C18,$C9,E25)","v":21.283626162639028},{"$f":"Temperatur_Basis(F24,$C16,$C10,F32,$C11,$C18,$C9,F25)","v":22.69390112275287},{"$f":"Temperatur_Basis(G24,$C16,$C10,G32,$C11,$C18,$C9,G25)","v":24.107620334760984}]
["Innerer Wärmedurchgangskoeffizient U","W/Km2",{"$f":"1/(C37/C25)","v":62.462651878277711},{"$f":"1/(D37/D25)","v":62.713816624861536},{"$f":"1/(E37/E25)","v":62.949443997323073},63.170856878401054,63.379231111338605,null,null,null,null,null,"x","ϑ_m","ϑ_b","ϑ_P","ϑ_i"]
["Temperaturzuschlag zur Berücksichtigung der inhomogenität","K",0.65,0.52411189952835491,0.39960250396850261,0.27617671727137644,0.15486899632246207,"proportional zur Leistung",null,null,null,null,"m","°C","°C","°C","°C"]
["Mittlere Plattentemperatur (basierend auf Fluidtemp.)","°C",{"$f":"Temperatur_Mittelwert(C24,C25,$C10,$C16,$C11,C32,$C18,$C9,C35,C25)","v":19.435351247853944},{"$f":"Temperatur_Mittelwert(D24,D25,$C10,$C16,$C11,D32,$C18,$C9,D35,D25)","v":20.652725873774497},{"$f":"Temperatur_Mittelwert(E24,E25,$C10,$C16,$C11,E32,$C18,$C9,E35,E25)","v":21.875591537232033},{"$f":"Temperatur_Mittelwert(F24,F25,$C10,$C16,$C11,F32,$C18,$C9,F35,F25)","v":23.103025320598995},{"$f":"Temperatur_Mittelwert(G24,G25,$C10,$C16,$C11,G32,$C18,$C9,G35,G25)","v":24.337041027850773},null,null,null,null,null,0,{"$f":"C24","v":18},{"$f":"C33","v":18.472450641215648},{"$f":"C36","v":19.435351247853944},{"$f":"K11","v":26}]
["Temperaturdifferenz","K",{"$f":"C36-C24","v":1.4353512478539443},{"$f":"D36-D24","v":1.1527258737744965},0.87559153723203309,{"$f":"F36-F24","v":0.60302532059899505},0.33704102785077339,null,null,null,null,null,{"$f":"M26","v":0.14416666666666664},{"$f":"N36","v":18},{"$f":"O36","v":18.472450641215648},{"$f":"P36","v":19.435351247853944},{"$f":"Q36","v":26}]

{"sheet":"Konvektion+Strahlung","index":2,"n_rows":87,"n_cols":31,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Korrelationen für den konvektiven Wärmeübergang und Strahlungsaustausch",null,null,null,null,"Institut Nachhaltigkeit und Energie am Bau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vergleich Datenblatt - Prototyp"]
["Parameter des empirischen Modells nach DIN EN 14240",null,null,null,"Legende:","Eingabe",null,null,null,null,"Daten übernehmen",null,null,null,null,null,null,null,null,null,null,null,null,"Datenblatt",null,"Prototyp opt."]
["Leistungsfaktor k","W/Kmn",10.424897458235773,null,null,"Formeln empirisches Modell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/Kmn",{"$f":"Kühlsegel!C3","v":11.446999999999999},null,{"$f":"Prototyp!C3","v":10.424897458235773}]
["Exponent n"," -",1.0346658183014497,"Raumluft",null,"Formeln analytisches Modell",null,null,"Beahr&Stephan",null,null,null,null,null,null,null,null,null,null,null,null,null," -",{"$f":"Kühlsegel!C4","v":1.0680000000000001},null,{"$f":"Prototyp!C4","v":1.0346658183014497}]
["Kühlsegelfläche","m2",2.045725,"°C","K","Formeln analytisches Modell",null,null,"Lloyd+Lewandowski"]
["Referenz- und Raumlufttemperatur","°C",26,{"$f":"C6+E6","v":26},0,"Übertrag aus \"Kühlsegel\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
["Mittlere Fluidtemperatur",null,18,19,20,21,22,23,24,25,"k","n",null,null,null,null,null,null,null,null,null,null,null,18,19,20,21,22,23,24,25]
["Differenz Fluid-Referenztemperatur","kg/m3",{"$f":"$C6-C7","v":8},{"$f":"$C6-D7","v":7},6,5,4,3,2,1,"W/Kmn"," -",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C6-X7","v":8},{"$f":"$C6-Y7","v":7},6,5,4,3,2,1]
["Gesamtleistung","W/m2",{"$f":"qs_Kuehlsegel($C3,$C4,$C6,C7)","v":89.633041238631748},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,D7)","v":78.066704584744187},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,E7)","v":66.557697889908582},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,F7)","v":55.115298435016747},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,G7)","v":43.752481056162949},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,H7)","v":32.488738257995699},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,I7)","v":21.356852028187628},{"$f":"qs_Kuehlsegel($C3,$C4,$C6,J7)","v":10.424897458235773},{"$f":"EXP(M9)","v":10.424897458235776},{"$f":"LINEST(LN(C9:J9),LN(C$8:J$8))","v":1.0346658183014497},2.3441969314960369,null,null,null,null,null,null,null,null,null,null,{"$f":"qs_Kuehlsegel($X3,$X4,$X6,X7)","v":105.48526273578479},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,Y7)","v":91.465305556186379},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,Z7)","v":77.58132958209427},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,AA7)","v":63.854520416763059},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,AB7)","v":50.314336914410163},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,AC7)","v":37.00472514950831},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,AD7)","v":23.998921114484563},{"$f":"qs_Kuehlsegel($X3,$X4,$X6,AE7)","v":11.446999999999999}]
[null,null,{"$f":"C8+$E6*C9/$C9","v":8},{"$f":"D8+$E6*D9/$C9","v":7},6,5,4,3,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,X7)","v":89.633041238631748},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,Y7)","v":78.066704584744187},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,Z7)","v":66.557697889908582},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,AA7)","v":55.115298435016747},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,AB7)","v":43.752481056162949},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,AC7)","v":32.488738257995699},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,AD7)","v":21.356852028187628},{"$f":"qs_Kuehlsegel($Z3,$Z4,$X6,AE7)","v":10.424897458235773}]
["Temperatur an der Basis","°C",{"$f":"Temperatur_Basis(C7,$C69,$C63,$C84,$C64,$C71,$C62,C9)","v":18.473015700408787},{"$f":"Temperatur_Basis(D7,$C69,$C63,$C84,$C64,$C71,$C62,D9)","v":19.411977284687328},{"$f":"Temperatur_Basis(E7,$C69,$C63,$C84,$C64,$C71,$C62,E9)","v":20.351241413321837},{"$f":"Temperatur_Basis(F7,$C69,$C63,$C84,$C64,$C71,$C62,F9)","v":21.290857044815326},{"$f":"Temperatur_Basis(G7,$C69,$C63,$C84,$C64,$C71,$C62,G9)","v":22.230892650583002},{"$f":"Temperatur_Basis(H7,$C69,$C63,$C84,$C64,$C71,$C62,H9)","v":23.171451097387067},{"$f":"Temperatur_Basis(I7,$C69,$C63,$C84,$C64,$C71,$C62,I9)","v":24.112705383874513},{"$f":"Temperatur_Basis(J7,$C69,$C63,$C84,$C64,$C71,$C62,J9)","v":25.055014759119562}]
["Mittlere Oberflächentemperatur des Kühlsegels","°C",{"$f":"Temperatur_Mittelwert(C7,C9,$C63,$C69,$C64,C84,$C71,$C62,$C86,$C9)","v":19.435836720376905},{"$f":"Temperatur_Mittelwert(D7,D9,$C63,$C69,$C64,D84,$C71,$C62,$C86,$C9)","v":20.247155979890213},{"$f":"Temperatur_Mittelwert(E7,E9,$C63,$C69,$C64,E84,$C71,$C62,$C86,$C9)","v":21.060532547458941},{"$f":"Temperatur_Mittelwert(F7,F9,$C63,$C69,$C64,F84,$C71,$C62,$C86,$C9)","v":21.876028301935484},{"$f":"Temperatur_Mittelwert(G7,G9,$C63,$C69,$C64,G84,$C71,$C62,$C86,$C9)","v":22.693769779544024},{"$f":"Temperatur_Mittelwert(H7,H9,$C63,$C69,$C64,H84,$C71,$C62,$C86,$C9)","v":23.513991489064804},{"$f":"Temperatur_Mittelwert(I7,I9,$C63,$C69,$C64,I84,$C71,$C62,$C86,$C9)","v":24.337141191955265},{"$f":"Temperatur_Mittelwert(J7,J9,$C63,$C69,$C64,J84,$C71,$C62,$C86,$C9)","v":25.164223993613227}]
["Differenz Oberflächen-Lufttemperatur","K ",{"$f":"$D6-C12","v":6.5641632796230951},{"$f":"$D6-D12","v":5.7528440201097872},4.9394674525410593,4.1239716980645156,3.3062302204559764,2.4860085109351964,1.6628588080447351,0.83577600638677296]
["Mittlere Lufttemperatur","°C",{"$f":"($D6+C12)/2","v":22.717918360188452},{"$f":"($D6+D12)/2","v":23.123577989945105},23.53026627372947,23.938014150967742,24.346884889772014,24.756995744532404,25.168570595977634,25.582111996806614]
["Dichte der Luft","kg/m3",{"$f":"rho_Luft(C14)","v":1.1807967412829863},{"$f":"rho_Luft(D14)","v":1.1793262449935564},{"$f":"rho_Luft(E14)","v":1.1778540021179307},{"$f":"rho_Luft(F14)","v":1.1763799159401773},{"$f":"rho_Luft(G14)","v":1.174903773752904},{"$f":"rho_Luft(H14)","v":1.1734251696260924},{"$f":"rho_Luft(I14)","v":1.1719433163507555},{"$f":"rho_Luft(J14)","v":1.1704564299377571}]
["Spezifische Wärmekapazität Luft","J/kgK",{"$f":"cp_Luft(C14)","v":1004.8717918360188},{"$f":"cp_Luft(D14)","v":1004.9123577989944},{"$f":"cp_Luft(E14)","v":1004.953026627373},{"$f":"cp_Luft(F14)","v":1004.9938014150968},{"$f":"cp_Luft(G14)","v":1005.0346884889772},{"$f":"cp_Luft(H14)","v":1005.0756995744532},{"$f":"cp_Luft(I14)","v":1005.1168570595976},{"$f":"cp_Luft(J14)","v":1005.1582111996806}]
["Kinematische Viskosität Luft","m2/s",{"$f":"ny_Luft(C14)","v":1.5616342200770156E-5},{"$f":"ny_Luft(D14)","v":1.5654707144699794E-5},{"$f":"ny_Luft(E14)","v":1.5693202746671269E-5},{"$f":"ny_Luft(F14)","v":1.5731832192678178E-5},{"$f":"ny_Luft(G14)","v":1.5770601746352013E-5},{"$f":"ny_Luft(H14)","v":1.5809522818704647E-5},{"$f":"ny_Luft(I14)","v":1.5848616993011716E-5},{"$f":"ny_Luft(J14)","v":1.5887932433209659E-5}]
["Wärmeleitfähigkeit Luft","W/Km",{"$f":"lamda_Luft(C14)","v":2.5883088970739508E-2},{"$f":"lamda_Luft(D14)","v":2.5912914995675176E-2},{"$f":"lamda_Luft(E14)","v":2.5942806740974957E-2},{"$f":"lamda_Luft(F14)","v":2.5972766404262729E-2},{"$f":"lamda_Luft(G14)","v":2.6002798554128848E-2},{"$f":"lamda_Luft(H14)","v":2.6032911716116634E-2},{"$f":"lamda_Luft(I14)","v":2.6063122229263384E-2},{"$f":"lamda_Luft(J14)","v":2.60934668549343E-2}]
["Prandtlzahl Luft"," -",{"$f":"Prandtlzahl(C17,C18,C15,C16)","v":0.71589447878000789},{"$f":"Prandtlzahl(D17,D18,D15,D16)","v":0.71596340977340078},{"$f":"Prandtlzahl(E17,E18,E15,E16)","v":0.7160310403188529},{"$f":"Prandtlzahl(F17,F18,F15,F16)","v":0.71609737235056359},{"$f":"Prandtlzahl(G17,G18,G15,G16)","v":0.71616241251196899},{"$f":"Prandtlzahl(H17,H18,H15,H16)","v":0.71622617490723295},{"$f":"Prandtlzahl(I17,I18,I15,I16)","v":0.71628868804188017},{"$f":"Prandtlzahl(J17,J18,J15,J16)","v":0.71635001813361732}]
["Expansionskoeffizient","1/K",{"$f":"1/(C14+273.15)","v":3.3798865572934609E-3},{"$f":"1/(D14+273.15)","v":3.3752587955512454E-3},3.3706320024580226E-3,3.3660058715524006E-3,3.3613797346836696E-3,3.3567523229885532E-3,3.3521211837473303E-3,3.347480769026565E-3]
["Dimensionen des Kühlsegels",null,null,null,"Emissivitäten"]
["Anzahl Module ohne Abstand in Längsrichtung","m ",1,null,"Begrenzungsflächen des Raumes",null,null," -",0.93]
["Anzahl Module ohne Abstand in Querrichtung","m ",1,null,"Kühlsegel zum Raum ",null,null," -",{"$f":"Prototyp!K18","v":0.93}]
["Anzahl Module im Prüfraum"," -",4,null,"Kühlsegel zur Decke",null,null," -",{"$f":"I23","v":0.93}]
["Gesamte Projektionsfläche","m2",{"$f":"C24*C60*C61","v":8.1829000000000001}]
["Charakteristische Länge","m",{"$f":"Char_Länge_horiz_Platte(C61,C22,C60,C23)","v":0.31667569659442718}]
["Strahlung"]
["Strahlungsanteil Raum","W/m2",{"$f":"Strahlung_isothermer_Raum(C12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":70.703289132026242},{"$f":"Strahlung_isothermer_Raum(D12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":62.217926557338856},{"$f":"Strahlung_isothermer_Raum(E12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":53.640089888231884},{"$f":"Strahlung_isothermer_Raum(F12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":44.968183288273245},{"$f":"Strahlung_isothermer_Raum(G12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":36.199884232423571},{"$f":"Strahlung_isothermer_Raum(H12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":27.331643691904254},{"$f":"Strahlung_isothermer_Raum(I12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":18.357483643340146},{"$f":"Strahlung_isothermer_Raum(J12,$D6,$I23,$I22,$C25,Kühlsegel!$G9)/(2*$C25)","v":9.2650991275277228},{"$f":"EXP(M28)","v":9.306122618373287},{"$f":"LINEST(LN(C28:J28),LN(C$8:J$8))","v":0.97744347377355345},2.230672529606152]
["Rad. Oben","W/m2",{"$f":"Strahlung_infinit_parallele_Platten($D6,C12,$I22,$I24)","v":33.515765322563652},{"$f":"Strahlung_infinit_parallele_Platten($D6,D12,$I22,$I24)","v":29.493414676343622},{"$f":"Strahlung_infinit_parallele_Platten($D6,E12,$I22,$I24)","v":25.427228162160006},{"$f":"Strahlung_infinit_parallele_Platten($D6,F12,$I22,$I24)","v":21.316449299232229},{"$f":"Strahlung_infinit_parallele_Platten($D6,G12,$I22,$I24)","v":17.159977131648191},{"$f":"Strahlung_infinit_parallele_Platten($D6,H12,$I22,$I24)","v":12.956129298981281},{"$f":"Strahlung_infinit_parallele_Platten($D6,I12,$I22,$I24)","v":8.7020720146991604},{"$f":"Strahlung_infinit_parallele_Platten($D6,J12,$I22,$I24)","v":4.3919723093596499},{"$f":"EXP(M29)","v":4.4114188401897065},{"$f":"LINEST(LN(C29:J29),LN(C$8:J$8))","v":0.97744347377355356},1.4841963701832832]
["Rad. Unten","W/m2",{"$f":"C28-C29","v":37.18752380946259},{"$f":"D28-D29","v":32.724511880995237},28.212861726071878,23.651733989041016,{"$f":"G28-G29","v":19.03990710077538},14.375514392922973,9.6554116286409855,4.8731268181680729,{"$f":"EXP(M30)","v":4.894703778183584},{"$f":"LINEST(LN(C30:J30),LN(C$8:J$8))","v":0.97744347377355345},1.5881537589692487]
["Konvektion Oberseite des Kühlsegels"]
["Rayleighzahl"," -",{"$f":"Ra_Luft($C6,C12,$C26)","v":20290827.923997547},{"$f":"Ra_Luft($C6,D12,$C26)","v":17673333.74924542},{"$f":"Ra_Luft($C6,E12,$C26)","v":15080925.554326521},{"$f":"Ra_Luft($C6,F12,$C26)","v":12513299.652225098},{"$f":"Ra_Luft($C6,G12,$C26)","v":9969961.2959714234},{"$f":"Ra_Luft($C6,H12,$C26)","v":7450104.4868576936},{"$f":"Ra_Luft($C6,I12,$C26)","v":4952314.3913107449},{"$f":"Ra_Luft($C6,J12,$C26)","v":2473581.6292144647}]
["Nu Lewandowski"," -",{"$f":"Nu_O_gekühlt_Lewandowski(C32)","v":15.047463453493112},{"$f":"Nu_O_gekühlt_Lewandowski(D32)","v":14.637504426491502},{"$f":"Nu_O_gekühlt_Lewandowski(E32)","v":14.180415061449729},{"$f":"Nu_O_gekühlt_Lewandowski(F32)","v":13.660849681393954},{"$f":"Nu_O_gekühlt_Lewandowski(G32)","v":13.05395280147647},{"$f":"Nu_O_gekühlt_Lewandowski(H32)","v":12.315039704715451},{"$f":"Nu_O_gekühlt_Lewandowski(I32)","v":11.34919309454434},{"$f":"Nu_O_gekühlt_Lewandowski(J32)","v":9.8779902464312297}]
["alpha_Lewandowski","W/Km2",{"$f":"C33*C18/$C26","v":1.2298854618121249},1.1977566072532271,1.1616924550959518,1.1204208642288211,1.071883029491288,1.0123806305980041,0.93406412303705166,0.81392735173714448]
["Anteil Lewandowski","W/Km2",{"$f":"C34*C13","v":8.073168986569442},{"$f":"D34*D13","v":6.8905069355837147},5.7381420718089702,4.6205839340006438,3.5438920648980008,2.5167868639725794,1.5532167542707425,0.68026095152383281]
["Hilfsfunktion phi_2 ^1/5 (Baehr)"," -",{"$f":"phi_2(C19) ^(1/5)","v":0.80983773681747406},{"$f":"phi_2(D19) ^(1/5)","v":0.80984471456416529},{"$f":"phi_2(E19) ^(1/5)","v":0.80985155987174362},{"$f":"phi_2(F19) ^(1/5)","v":0.80985827298166146},{"$f":"phi_2(G19) ^(1/5)","v":0.80986485461090751},{"$f":"phi_2(H19) ^(1/5)","v":0.80987130623013959},{"$f":"phi_2(I19) ^(1/5)","v":0.80987763076545327},{"$f":"phi_2(J19) ^(1/5)","v":0.8098838349556674}]
["Nu_Baehr"," -",{"$f":"Nu_O_gekühlt_Baehr(C32,C19)","v":14.060773555408286},{"$f":"Nu_O_gekühlt_Baehr(D32,D19)","v":13.677814147158132},{"$f":"Nu_O_gekühlt_Baehr(E32,E19)","v":13.250805296704419},{"$f":"Nu_O_gekühlt_Baehr(F32,F19)","v":12.765406304348984},{"$f":"Nu_O_gekühlt_Baehr(G32,G19)","v":12.198389524229297},{"$f":"Nu_O_gekühlt_Baehr(H32,H19)","v":11.507996875308386},{"$f":"Nu_O_gekühlt_Baehr(I32,I19)","v":10.605528016741399},{"$f":"Nu_O_gekühlt_Baehr(J32,J19)","v":9.2307976412704633}]
["alpha_Baehr","W/Km2",{"$f":"C37*C18/$C26","v":1.1492396064676675},1.1192271435211529,1.0855366694431061,1.0469793532118925,1.0016312236602245,0.94603618119749755,0.87285881417106725,0.76059992884637184]
["Anteil Baehr&Stephan","W/Km2",{"$f":"C38*C13","v":7.5437964242635598},{"$f":"D38*D13","v":6.4387391797502236},5.361973047254045,4.3177132211037366,3.3116234214177336,2.3518539981096107,1.4514409673238418,0.63569117098928429]
["Konvektion Unterseite des Kühlsegels"]
["Nu Lloyd et al."," -",{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(C32)","v":40.912672396966215},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(D32)","v":39.071859930358798},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(E32)","v":37.059588360966778},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(F32)","v":34.824258179426224},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(G32)","v":30.343601621092823},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(H32)","v":28.212030893990431},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(I32)","v":25.473921824937275},{"$f":"Nu_U_gekühlt_O_geheizt_Lloyd(J32)","v":21.415357144372649}]
["alpha_Lloyd et al.","W/Km2",{"$f":"C41*C18/$C26","v":3.3439457181888148},3.1971692049200713,3.0360073383843158,2.8561785215060609,2.4915665106139353,2.3192222121681203,2.0965610728010762,1.7645841403135383]
["Anteil Konvektion Lloyd et al.","W/m2",{"$f":"(C42)*($C6-C12)","v":21.950205692387897},18.392815741803595,14.996259433625138,11.778799387310748,8.23769249366784,5.7656061581999012,3.4862850465109885,1.4747970857246862]
["Hilfsfunktion phi_1 ^1/5 (Baehr)"," -",{"$f":"phi_1(C19) ^(1/5)","v":0.83454946007795505},{"$f":"phi_1(D19) ^(1/5)","v":0.83455575758021971},{"$f":"phi_1(E19) ^(1/5)","v":0.83456193553406521},{"$f":"phi_1(F19) ^(1/5)","v":0.83456799415858174},{"$f":"phi_1(G19) ^(1/5)","v":0.8345739341020062},{"$f":"phi_1(H19) ^(1/5)","v":0.83457975669273021},{"$f":"phi_1(I19) ^(1/5)","v":0.83458546457263505},{"$f":"phi_1(J19) ^(1/5)","v":0.83459106382450765}]
["Nu_Baehr&Stephan"," -",{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(C32,C19)","v":30.265276726427565},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(D32,D19)","v":28.90389348613904},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(E32,E19)","v":27.415628854476296},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(F32,F19)","v":25.76230690329449},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(G32,G19)","v":23.883452701065622},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(H32,H19)","v":21.673304081283437},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(I32,I19)","v":18.915247252690168},{"$f":"Nu_U_gekühlt_O_geheizt_Baehr(J32,J19)","v":15.008002446649684}]
["alpha_Baehr&Stephan","W/Km2",{"$f":"C45*C18/$C26","v":2.4736942514330034},2.3651456142831484,2.2459518324352885,2.1129451562907464,1.9611123178746732,1.7816940731868309,1.5567674009887307,1.2366304664736243]
["Anteil Baehr&Stephan","W/m2",{"$f":"C46*C13","v":16.23773297027126},{"$f":"D46*D13","v":13.606313803817701},11.093805976289058,8.7137260241055436,6.4838888110657118,4.4293066298252581,2.588684384811021,1.0335460726455379]
["Konvektion"]
["Konvektion","W/m2",{"$f":"C9-C28","v":18.929752106605505},15.848778027405331,12.917608001676697,10.147115146743502,7.5525968237393784,5.1570945660914447,2.9993683848474824,1.1597983307080497,{"$f":"EXP(M49)","v":1.1733124414218492},{"$f":"LINEST(LN(C49:J49),LN(C$8:J$8))","v":1.339972245738388},0.15983089517699578]
["Leistungsdichte - Strahlung Oberseite","W/m2",{"$f":"C9-C29","v":56.117275916068095},48.573289908400568,41.130469727748576,33.798849135784522,26.592503924514759,19.532608959014418,12.654780013488468,6.0329251488761226]
["Ln ","W/m2",null,{"$f":"$K6*D8^$J6","v":0},0,0,0,0,0,0]
["Strahlung + Baehr&Stephan","W/m2",{"$f":"C28+C47+C39","v":94.484818526561057},{"$f":"D28+D47+D39","v":82.262979540906784},70.095868911774986,57.99962253348253,45.995396464907017,34.112804319839121,22.397608995475007,10.934336371162546]
["Baehr&Stephan","W/m2",{"$f":"C39+C47","v":23.781529394534822},{"$f":"D39+D47","v":20.045052983567924},16.455779023543101,13.031439245209281,9.7955122324834463,6.7811606279348684,4.0401253521348632,1.6692372436348222]
["Strahlung + Lloyd+Lewandowski","W/m2",{"$f":"C28+C43+C35","v":100.72666381098358},87.501249234726174,74.374491393665991,61.367566609584635,47.98146879098941,35.614036714076732,23.396985444121878,11.420157164776242]
["Lloyd, Lewandowski",null,{"$f":"C43+C35","v":30.023374678957339},{"$f":"D43+D35","v":25.283322677387311},{"$f":"E43+E35","v":20.734401505434107},16.39938332131139,11.781584558565841,8.2823930221724815,5.0395018007817312,2.1550580372485189]
["Rel. Differenz Emprisch - Baehr+Stephan"," -",{"$f":"(C49-C53)/C53","v":-0.20401451931196199},{"$f":"(D49-D53)/D49","v":-0.2647696212860382},{"$f":"(E49-E53)/E49","v":-0.2739029564457407},-0.28425065220546358,-0.29697274475106622,-0.31491880574032238,-0.34699204424010865,{"$f":"(J49-J53)/J49","v":-0.43924784114472998}]
["Rel. Differenz Emprisch - Lloyd+Lewandowski"," -",{"$f":"(C49-C55)/C55","v":-0.36949952132220121},{"$f":"(D49-D55)/D55","v":-0.37315287908815759},-0.37699634116320024,-0.38125020020984057,-0.35894897785644314,-0.3773424477339361,-0.40482839308000285,-0.46182501321921332]
[]
["Abmessungen der Platte"]
["Breite B_P","m",0.86499999999999999]
["Länge (Richtung der Strömungskanäle) L_P","m",2.3650000000000002]
["Dicke s","m",2E-3]
["Durchmesser eines kreisförmigen Strömungskanals d","m",0.01]
["Wärmeleitvermögen der Verbindung Rohr-Platte","W/Km",40]
["Höhe eines volldurchströmten Plattenspaltes","m",3.5000000000000001E-3]
["Anzahl Strömungskanäle pro Plattenbreite n"," -",6]
["Anzahl seriell geschaltete Strömungskanäle m"," -",6]
["Querschnitt total","m2",{"$f":"Querschnitt(C63,C60,C65,C66,C67)","v":7.8537500000000005E-5}]
["Halbe Plattenbreite b zwischen zwei Strömungskanälen","m",{"$f":"(C60-C66*C63)/(C66*2)","v":6.7083333333333328E-2}]
["Stoffdaten"]
["Wärmeleitfähigkeit des Plattenmaterials","W/Km ",200]
[]
["Dichte von Wasser","kg/m3",{"$f":"rho_sat_Wasser(C7)","v":998.39060518823999},{"$f":"rho_sat_Wasser(D7)","v":998.203348405165},{"$f":"rho_sat_Wasser(E7)","v":998.00644239999997},{"$f":"rho_sat_Wasser(F7)","v":997.79998862956506},{"$f":"rho_sat_Wasser(G7)","v":997.58408762344004},{"$f":"rho_sat_Wasser(H7)","v":997.35883898396503},{"$f":"rho_sat_Wasser(I7)","v":997.12434138623996},{"$f":"rho_sat_Wasser(J7)","v":996.88069257812504}]
["Wärmeleitfähigkeit von Wasser","W/Km",{"$f":"lamda_sat_Wasser(C7)","v":0.59553496250959992},{"$f":"lamda_sat_Wasser(D7)","v":0.59719954515269991},{"$f":"lamda_sat_Wasser(E7)","v":0.59884632239999991},{"$f":"lamda_sat_Wasser(F7)","v":0.60047535368329996},{"$f":"lamda_sat_Wasser(G7)","v":0.60208669843439999},{"$f":"lamda_sat_Wasser(H7)","v":0.60368041608509992},{"$f":"lamda_sat_Wasser(I7)","v":0.60525656606719991},{"$f":"lamda_sat_Wasser(J7)","v":0.60681520781249998}]
["Kinemat. Viskosität von Wasser","m2/s",{"$f":"ny_sat_Wasser(C7)","v":1.0949925624666294E-6},{"$f":"ny_sat_Wasser(D7)","v":1.0689848381612227E-6},{"$f":"ny_sat_Wasser(E7)","v":1.0437823105324388E-6},{"$f":"ny_sat_Wasser(F7)","v":1.0193587667862889E-6},{"$f":"ny_sat_Wasser(G7)","v":9.9568885422013186E-7},{"$f":"ny_sat_Wasser(H7)","v":9.7274805196773953E-7},{"$f":"ny_sat_Wasser(I7)","v":9.5051264367273639E-7},{"$f":"ny_sat_Wasser(J7)","v":9.2895969105990357E-7}]
["Wärmekapazität von Wasser","J/kgK",{"$f":"cp_sat_Wasser(C7)","v":4189.6574657092797},{"$f":"cp_sat_Wasser(D7)","v":4188.6682719096298},{"$f":"cp_sat_Wasser(E7)","v":4187.7265648000002},{"$f":"cp_sat_Wasser(F7)","v":4186.8315930744302},{"$f":"cp_sat_Wasser(G7)","v":4185.9826155076798},{"$f":"cp_sat_Wasser(H7)","v":4185.1789009552303},{"$f":"cp_sat_Wasser(I7)","v":4184.4197283532803},{"$f":"cp_sat_Wasser(J7)","v":4183.7043867187504}]
["Betriebsbedingungen"]
["Flächenbezogener Massenstrom Wasser","kg/sm2",{"$f":"Kühlsegel!C26","v":2.6912490953356658E-2}]
["Volumenstrom","m3/s",{"$f":"Volumenstrom($C78*$C60*$C61,C7)","v":5.5144304513137117E-5},{"$f":"Volumenstrom($C78*$C60*$C61,D7)","v":5.5154649244082508E-5},{"$f":"Volumenstrom($C78*$C60*$C61,E7)","v":5.5165531219576382E-5},{"$f":"Volumenstrom($C78*$C60*$C61,F7)","v":5.5176945462959938E-5},{"$f":"Volumenstrom($C78*$C60*$C61,G7)","v":5.5188887070878667E-5},{"$f":"Volumenstrom($C78*$C60*$C61,H7)","v":5.5201351212410231E-5},{"$f":"Volumenstrom($C78*$C60*$C61,I7)","v":5.5214333128218739E-5},{"$f":"Volumenstrom($C78*$C60*$C61,J7)","v":5.5227828129734673E-5}]
["Fliessgeschwindigkeit","m/s",{"$f":"Fliessgeschwindigkeit(C79,$C68)","v":0.70213979962612905},{"$f":"Fliessgeschwindigkeit(D79,$C68)","v":0.70227151671599564},{"$f":"Fliessgeschwindigkeit(E79,$C68)","v":0.70241007441765246},{"$f":"Fliessgeschwindigkeit(F79,$C68)","v":0.70255540936444294},{"$f":"Fliessgeschwindigkeit(G79,$C68)","v":0.70270745912307708},{"$f":"Fliessgeschwindigkeit(H79,$C68)","v":0.70286616218252718},{"$f":"Fliessgeschwindigkeit(I79,$C68)","v":0.70303145794325939},{"$f":"Fliessgeschwindigkeit(J79,$C68)","v":0.70320328670679189}]
["Reynoldszahl"," -",{"$f":"Reynoldszahl_Kanal(C80,$C63,$C65,C75)","v":6412.2791669420794},{"$f":"Reynoldszahl_Kanal(D80,$C63,$C65,D75)","v":6569.5180291236284},{"$f":"Reynoldszahl_Kanal(E80,$C63,$C65,E75)","v":6729.4690409090126},{"$f":"Reynoldszahl_Kanal(F80,$C63,$C65,F75)","v":6892.1309381521751},{"$f":"Reynoldszahl_Kanal(G80,$C63,$C65,G75)","v":7057.5005047482337},{"$f":"Reynoldszahl_Kanal(H80,$C63,$C65,H75)","v":7225.5725494461049},{"$f":"Reynoldszahl_Kanal(I80,$C63,$C65,I75)","v":7396.3398869348939},{"$f":"Reynoldszahl_Kanal(J80,$C63,$C65,J75)","v":7569.7933233730173}]
["Prandtlzahl Wasser"," -",{"$f":"C76*C75*C73/C74","v":7.6910017421324},{"$f":"D76*D75*D73/D74","v":7.4842289863709102},7.2846083492599334,7.0918715832918613,6.9057610412236752,6.7260292353471103,6.5524384161200366,6.3847601692562419]
["Nusseltzahl"," -",{"$f":"Nu_Rohrstroemung(C81,C82)","v":46.057857181086696},{"$f":"Nu_Rohrstroemung(D81,D82)","v":47.156648301306411},{"$f":"Nu_Rohrstroemung(E81,E82)","v":48.255441237449396},{"$f":"Nu_Rohrstroemung(F81,F82)","v":49.354165351720127},{"$f":"Nu_Rohrstroemung(G81,G82)","v":50.452744799113368},{"$f":"Nu_Rohrstroemung(H81,H82)","v":51.551098744587648},{"$f":"Nu_Rohrstroemung(I81,I82)","v":52.649141589323449},{"$f":"Nu_Rohrstroemung(J81,J82)","v":53.746783205740904}]
["Wärmeübergang zum Fluid","W/Km2",{"$f":"alpha_Rohrstroemung(C83,C74,$C63,$C65)","v":2742.9064249610974},{"$f":"alpha_Rohrstroemung(D83,D74,$C63,$C65)","v":2816.1928916466027},{"$f":"alpha_Rohrstroemung(E83,E74,$C63,$C65)","v":2889.7593520835871},{"$f":"alpha_Rohrstroemung(F83,F74,$C63,$C65)","v":2963.595989531821},{"$f":"alpha_Rohrstroemung(G83,G74,$C63,$C65)","v":3037.6926543051513},{"$f":"alpha_Rohrstroemung(H83,H74,$C63,$C65)","v":3112.038873977674},{"$f":"alpha_Rohrstroemung(I83,I74,$C63,$C65)","v":3186.623864473971},{"$f":"alpha_Rohrstroemung(J83,J74,$C63,$C65)","v":3261.4365420245049}]
["Innerer Wärmedurchgangskoeffizient U","W/Km2",{"$f":"1/(C87/C9)","v":62.425650470272984}]
["Mittlere Temperaturerhöhung durch Inhomogenität","K",0.65]
["Temperaturdifferenz","K",{"$f":"C12-C7","v":1.4358367203769049},1.2471559798902128,1.0605325474589407,0.87602830193548442,0.69376977954402363,0.51399148906480363,0.33714119195526493,0.16422399361322704]

{"sheet":"Kollektorfeld","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Modell für die nächtliche Wärmeabgabe über ein Kollektorfeld"]
["Kollektorfeld",null,null,null,null,null,null,"Randbedingungen"]
["Kollektortyp"," -","P3",null,null,null,"T_l - T_a",null,"T_a","EL","T_sky","w","Qu"]
["Modulfläche","m2",2]
["Anzahl Module"," -",22,null,null,null,null,null,"°C","W/m2","°C","m/s","W/m2"]
["Kollektorfläche","m2",{"$f":"C4*C5","v":44}]
["Mittlere Fluidtemperatur T_l","°C",0,null,null,null,{"$f":"C7-I$7","v":-20},null,20,418.77499999999998,{"$f":"T_Sky(J7)","v":19.999965986391715},2,{"$f":"qu_collector(C$3,C7,D$7,I$7,L$7,J$7)","v":578.10331814135486}]
[null,null,1,null,null,null,{"$f":"C8-I$7","v":-19},null,null,null,null,null,{"$f":"qu_collector(C$3,C8,D$7,I$7,L$7,J$7)","v":551.93447741501177}]
[null,null,2,null,null,null,-18,null,null,null,null,null,{"$f":"qu_collector(C$3,C9,D$7,I$7,L$7,J$7)","v":525.47709255882683}]
[null,null,3,null,null,null,-17,null,null,null,null,null,{"$f":"qu_collector(C$3,C10,D$7,I$7,L$7,J$7)","v":498.73124729877611}]
[null,null,4,null,null,null,-16,null,null,null,null,null,{"$f":"qu_collector(C$3,C11,D$7,I$7,L$7,J$7)","v":471.69702566568145}]
[null,null,5,null,null,null,-15,null,null,null,null,null,{"$f":"qu_collector(C$3,C12,D$7,I$7,L$7,J$7)","v":444.37451199521092}]
[null,null,6,null,null,null,-14,null,null,null,null,null,{"$f":"qu_collector(C$3,C13,D$7,I$7,L$7,J$7)","v":416.76379092787869}]
[null,null,7,null,null,null,-13,null,null,null,null,null,{"$f":"qu_collector(C$3,C14,D$7,I$7,L$7,J$7)","v":388.86494740904487}]
[null,null,8,null,null,null,-12,null,null,null,null,null,{"$f":"qu_collector(C$3,C15,D$7,I$7,L$7,J$7)","v":360.67806668891581}]
[null,null,9,null,null,null,-11,null,null,null,null,null,{"$f":"qu_collector(C$3,C16,D$7,I$7,L$7,J$7)","v":332.20323432254389}]
[null,null,10,null,null,null,-10,null,null,null,null,null,{"$f":"qu_collector(C$3,C17,D$7,I$7,L$7,J$7)","v":303.44053616982745}]
[null,null,11,null,null,null,-9,null,null,null,null,null,{"$f":"qu_collector(C$3,C18,D$7,I$7,L$7,J$7)","v":274.39005839551089}]
[null,null,12,null,null,null,-8,null,null,null,null,null,{"$f":"qu_collector(C$3,C19,D$7,I$7,L$7,J$7)","v":245.05188746918506}]
[null,null,13,null,null,null,-7,null,null,null,null,null,{"$f":"qu_collector(C$3,C20,D$7,I$7,L$7,J$7)","v":215.42611016528645}]
[null,null,14,null,null,null,-6,null,null,null,null,null,{"$f":"qu_collector(C$3,C21,D$7,I$7,L$7,J$7)","v":185.51281356309789}]
[null,null,15,null,null,null,-5,null,null,null,null,null,{"$f":"qu_collector(C$3,C22,D$7,I$7,L$7,J$7)","v":155.31208504674822}]
[null,null,16,null,null,null,-4,null,null,null,null,null,{"$f":"qu_collector(C$3,C23,D$7,I$7,L$7,J$7)","v":124.82401230521225}]
[null,null,17,null,null,null,{"$f":"C24-I$7","v":-3},null,null,null,null,null,{"$f":"qu_collector(C$3,C24,D$7,I$7,L$7,J$7)","v":94.048683332311128}]
[null,null,18,null,null,null,-2,null,null,null,null,null,{"$f":"qu_collector(C$3,C25,D$7,I$7,L$7,J$7)","v":62.986186426711818}]
[null,null,19,null,null,null,-1,null,null,null,null,null,{"$f":"qu_collector(C$3,C26,D$7,I$7,L$7,J$7)","v":31.636610191927485},{"$f":"M26*C$6","v":1392.0108484448094},{"$f":"N26*9","v":12528.097636003286}]
[null,null,20,null,null,null,0,null,null,null,null,null,{"$f":"qu_collector(C$3,C27,D$7,I$7,L$7,J$7)","v":4.3536317391044576E-5}]
[null,null,21,null,null,null,{"$f":"C28-I$7","v":1},null,null,null,null,null,{"$f":"qu_collector(C$3,C28,D$7,I$7,L$7,J$7)","v":-31.623424326913188}]
[null,null,22,null,null,null,2,null,null,null,null,null,{"$f":"qu_collector(C$3,C29,D$7,I$7,L$7,J$7)","v":-62.933703879712837},{"$f":"M29*C$6","v":-2769.0829707073649},{"$f":"N29*9","v":-24921.746736366284}]
[null,null,23,null,null,null,3,null,null,null,null,null,{"$f":"qu_collector(C$3,C30,D$7,I$7,L$7,J$7)","v":-93.930705299184069},{"$f":"M30*C$6","v":-4132.9510331640995},{"$f":"N30*9","v":-37196.559298476895}]
[null,null,24,null,null,null,4,null,null,null,null,null,{"$f":"qu_collector(C$3,C31,D$7,I$7,L$7,J$7)","v":-124.61433845758334},{"$f":"M31*C$6","v":-5483.0308921336673},{"$f":"N31*9","v":-49347.278029203007}]
[null,null,25,null,null,null,5,null,null,null,null,null,{"$f":"qu_collector(C$3,C32,D$7,I$7,L$7,J$7)","v":-154.98451292232107}]
[null,null,26,null,null,null,{"$f":"C33-I$7","v":6},null,null,null,null,null,{"$f":"qu_collector(C$3,C33,D$7,I$7,L$7,J$7)","v":-185.04113795596146}]
[null,null,27,null,null,null,{"$f":"C34-I$7","v":7},null,null,null,null,null,{"$f":"qu_collector(C$3,C34,D$7,I$7,L$7,J$7)","v":-214.78412251622282}]
[null,null,28,null,null,null,8,null,null,null,null,null,{"$f":"qu_collector(C$3,C35,D$7,I$7,L$7,J$7)","v":-244.21337525597718}]
[null,null,29,null,null,null,9,null,null,null,null,null,{"$f":"qu_collector(C$3,C36,D$7,I$7,L$7,J$7)","v":-273.32880452325065}]
[null,null,30,null,null,null,10,null,null,null,null,null,{"$f":"qu_collector(C$3,C37,D$7,I$7,L$7,J$7)","v":-302.1303183612232}]
[null,null,31,null,null,null,11,null,null,null,null,null,{"$f":"qu_collector(C$3,C38,D$7,I$7,L$7,J$7)","v":-330.61782450822864},{"$f":"M38*C$6","v":-14547.18427836206}]

{"sheet":"Raum","index":4,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[46,1,46,3],[42,1,42,3],[45,1,45,3],[36,1,36,3],[44,1,44,3]]}
["Nächtliche Kühlung eines Raumes",null,"Institut Nachhaltigkeit und Energie am Bau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimale Distanz zwischen zwei Rechenknoten"]
["Abmessungen des Raumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lambda","alpha","L","Bi"]
["Länge","L_R","m",18,"Volumen","V","m3",{"$f":"D3*D4*D5","v":432},null,null,null,null,null,null,null,null,null,null,null,"W/Km","W/Km2","mm"," -"]
["Breite","B_R","m",8,"Wärmekapazität Luftvolumen","C_A","m2",{"$f":"H3*H21*H22","v":494113.66518529021},null,null,null,null,null,null,null,null,null,null,"Gipsplatte",0.3,3,{"$f":"W$4*T4/U4*1000","v":10},0.1]
["Höhe","H_R","m",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beton",2.1,3,{"$f":"W$4*T5/U5*1000","v":70}]
["Glasfläche der Fenster","A_F","m2",41,"Gesamte Wärmekapazität","C_tot","J/K",{"$f":"H4+H9+H15","v":113294113.66518529},null,null,null,null,null,null,null,null,null,null,"Holz",0.15,3,5]
["Geschossdecke"]
["Dicke","D_D","m",0.25,"Deckenfläche","A_D","m2",{"$f":"D3*D4","v":144}]
["Dichte","rho_D","kg/m3",2400,"Wärmekapazität Geschossdecke","C_R","J/K",{"$f":"H8*D8*D9*D10","v":86400000}]
["Spezifische Wärmekapazität","cp_D","J/kgK",1000,"Anzahl Knoten","n_D"," -",20]
["Wärmeleitfähigkeit","lam_D",null,2.5,"Maximale Dicke der Randschicht","s_D","m",{"$f":"H43*D11/E46","v":0}]
["Emissivität","eps_D"," -",0.93,"Erf. Anzahl Knoten","n_erf"," -",{"$f":"ROUNDUP(D8/H11,0)","v":{"$error":"#DIV/0!"}}]
["Wände und Boden",null,null,null,"Dicke Oberflächenschicht","s_DO","m",{"$f":"D8/(2*H10-1)","v":6.41025641025641E-3}]
["Mittlere aktive Dicke","D_W","m",0.04,"Wand+Bodenfläche","A_R","m2",{"$f":"2*(D3*D5+D4*D5)+D3*D4","v":300}]
["Mittlere Dichte","rho_W","kg/m3",2200,"Wärmekapazität Wand+Boden","C_R","J/K",{"$f":"H14*D14*D15*D16","v":26400000}]
["Mittlere spezifische Wärmekapazität","cp_W","J/kgK",1000,"Anzahl Knoten","n_D"," -",10]
["Mittlere Wärmeleitfähigkeit","lam_D",null,1.5,"Maximale Dicke der Randschicht","s_D","m",{"$f":"H43*D17/E46","v":0}]
["Mittlere Emissivität","eps_W"," -",0.93,"Erf. Anzahl Knoten","n_erf"," -",{"$f":"ROUNDUP(D14/H17,0)","v":{"$error":"#DIV/0!"}}]
["Luft"]
["Anfangstemperatur","T_init","°C",26,"Taupunkttemperatur","T_tau",null,{"$f":"Taupunkt(D20,D21)","v":17.574864439316652}]
["Rel. Luftfeuchte","phi_A"," -",0.6,"Dichte","rho_A",null,{"$f":"rho_Luft_phi(D20,D21,D23)","v":1.1092336354723971}]
["Höhe über Meer","h ","m",450,"Spezifische Wärmekapazität","cp_A",null,{"$f":"cp_Luft_phi(D20,D21,D23)","v":1031.145825186095},"Anteil "]
["Luftdruck","p_A","Pa",{"$f":"Int_Hoehenformel(D22)","v":96027.476456163902},null,null,null,null,"Decke %"]
["Kapillarrohrmatte","A_K","m2",60,"Abminderungsfaktor lambda Oberfl.","R_K"," -",1,{"$f":"D24/H8","v":0.41666666666666669}]
["Kühlsegel"]
["Fläche pro Modul","A_P","m2",{"$f":"'Konvektion+Strahlung'!C5","v":2.045725},"Gesamtfläche","A_S","m2",{"$f":"D26*D27","v":100.24052500000001},{"$f":"H26/H8","v":0.69611475694444447}]
["Anzahl Module","n_P"," -",49]
["Abstand zur Decke","s_P","m ",0.1]
[null,null,null,null,"Leistung zu Beginn","Qs_P","W",{"$f":"Leistungsdichte_Potenzfunktion(D31,D32,D20,D38)*H26","v":6671.7785792758305}]
["Leistungsdaten nach Datenblatt",null,null,null,"Strahlungsaustausch Decke"]
["Wärmeübertragungskoeffizient","k","W/(m2Kn)",{"$f":"'Konvektion+Strahlung'!K9","v":10.424897458235776},"Wärmeübertragungskoeffizient","k_r,D","W/(m2Kn)",{"$f":"'Konvektion+Strahlung'!K29","v":4.4114188401897065}]
["Exponent","n"," -",{"$f":"'Konvektion+Strahlung'!L9","v":1.0346658183014497},"Exponent","n_r,D"," -",{"$f":"'Konvektion+Strahlung'!L29","v":0.97744347377355356}]
["Leistungsparameter für Konvektion",null,null,null,"Strahlungsaustausch Raum"]
["Wärmeübertragungskoeffizient","k_c","W/(m2Kn)",{"$f":"'Konvektion+Strahlung'!K49","v":1.1733124414218492},"Wärmeübertragungskoeffizient","k_r,B","W/(m2Kn)",{"$f":"'Konvektion+Strahlung'!K30","v":4.894703778183584}]
["Exponent","n_c"," -",{"$f":"'Konvektion+Strahlung'!L49","v":1.339972245738388},"Exponent","n_r,B"," -",{"$f":"'Konvektion+Strahlung'!L30","v":0.97744347377355345}]
[]
["Betriebsbedingungen","Gesamtsystem, WP",null,null,"Entzogene Wärmemengen","kJ","kWh"]
["Mittlere Fluidtemperatur","T_l","°C",20,"Decke",-85126.833568540285,{"$f":"-F38/3600","v":23.646342657927857}]
["Startzeit",null,"h",22,"Wände+Boden",-81116.253383987147,{"$f":"-F39/3600","v":22.532292606663095},"Anteil"]
["Zeitdauer",null,"h",9,"Luft",-1489.6882750635891,0.41380229862877477,"%",null,null,null,null,null,null,null,null,null,null,null,"Vergleichsrechnung",null,"kWh","unterschiedliche Grädigkeit und Kollektor"]
["WP-Betrieb vor Free Cooling",null,"h",0,"Total",{"$f":"SUM(F38:F40)","v":-167732.77522759102},46.592437563219725,{"$f":"G41/G42","v":1.0974313950056347},null,null,null,null,null,null,null,null,null,null,null,"4K, P3",null,30.211127134059598]
["Vorgaben für die Simulation",null,null,null,"Erforderlich",{"$f":"-G42*3600","v":-152841.24},{"$f":"C52","v":42.4559},"SIA",null,null,null,null,null,null,null,null,null,null,null,"2K, P3",null,35.736840355979282]
["Kühlsegelmodell","Potenzfunktion",null,null,null,"Grädigkeit Wärmeübertrager",null,null,null,null,null,null,null,null,null,null,null,null,null,"4K, P5",null,37.444198394136237]
["Wärmeübertrager Free Cooling","Qs_0","kW",2,null,"ΔT_0","K ",2,null,null,null,null,null,null,null,null,null,null,null,"2K, P5",null,45.80861692650943]
["Datensatz Wetterdaten","July, clear, warm (6. Juli)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erforderlich",null,{"$f":"G42","v":42.4559}]
["Konvektion Decke","Vorgabe",null,null,3]
["Konvektion Wand+Boden","Vorgabe",null,null,3]
[]
["Daten nach Auslegung HSLU",null,"Büro"]
["Energiebezugsfläche Büro","m2",{"$f":"D3*D4","v":144}]
["Energiebezugsfläche Gebäude",null,2268]
["Abwärme Büro","kWh",42.4559,null,"Mittlere Entzugsleistung","W",{"$f":"C52*1000/D40","v":4717.3222222222221}]
["Abwärme Gebäude","kWh",{"$f":"C52*C51/C50","v":668.68042500000001},null,null,"W",{"$f":"C53*1000/D41","v":{"$error":"#DIV/0!"}}]
["Abschätzung des Volumens von Speichern"]
[null,null,"Wasser","Kies-Wasser Speicher",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vergleichsrechnung",null,"kWh","unterschiedliche Umgebungsbedingungen"]
["Spezifische Wärmekapazität","J/kgK",4180,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, clear, warm",null,35.736840355979282]
["Dichte","kg/m3",1000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, grey",null,27.683224603217763]
["Temperaturhub","K ",5,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, clear, warm",null,34.277099915735043]
["Spezifische Wärmekapazität","J/m3K",null,2800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, grey",null,41.699772686575614]
["Erforderliches Volumen","m3",{"$f":"C53*1000*3600/(C56*C57*C58)","v":115.1794033492823},{"$f":"C53*3600/(D58*D59)","v":171.94639500000002},"Länge","m",16,null,null,null,null,null,null,null,null,null,null,null,null,"Erforderlich",null,{"$f":"V45","v":42.4559}]
["Durchmesser",null,4,null,"Tiefe","m",2]
["Höhe",null,{"$f":"C60/(C61^2*3.1415/4)","v":9.165956020156159},null,"Breite","m",{"$f":"D60/(G60*G61)","v":5.3733248437500007}]
["Für Diagramm",null,"Büro","Gebäude"]
["Energiebezugsfläche","m2",{"$f":"C50","v":144},2400]
["Abzuführende Wärme","kWh",{"$f":"C52","v":42.4559},593.95899999999995]
["Puffer ΔT = 5K","m3",{"$f":"C$52*1000*3600/($C$56*$C$57*5)","v":7.312977990430622},{"$f":"C$53*1000*3600/($C$56*$C$57*5)","v":115.1794033492823}]
["Kies  ΔT =  5K","m3",{"$f":"C$52*3600/(D$59*5)","v":10.917231428571428},{"$f":"C$53*3600/(D$59*5)","v":171.94639500000002}]
["Puffer  ΔT =  10K","m3",{"$f":"C$52*1000*3600/($C$56*$C$57*10)","v":3.656488995215311},{"$f":"C$53*1000*3600/($C$56*$C$57*10)","v":57.589701674641148}]
["Kies  ΔT =  10K","m3",{"$f":"C$52*3600/(D$59*10)","v":5.4586157142857141},{"$f":"C$53*3600/(D$59*10)","v":85.973197500000012}]

{"sheet":"Leistung","index":5,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,1,1.9991666666666668,2.9983333333333335,3.9975000000000001,4.996666666666667,5.9958333333333336,6.9950000000000001,7.9941666666666666,8.9933333333333341,9.9924999999999997]
[null,6.673053737316609,5.8539490680112403,5.4968132409175707,5.189808444277265,4.9176778599970534,4.6729121800486517,4.4507410408049592,4.2478120026575912,4.0615994801895301,3.8900957165666585]
[null,6.6728864240972108,5.8595238101493328,5.4980176667456515,5.1885682675580842,4.9147316164978685,4.6760244727108615,4.451380390368243,4.2487820717474367,4.0615594066340215,3.8902483062496818]

{"sheet":"Kuehlsegel","index":6,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["t",1,1.9991666666666668,2.9983333333333335,3.9975000000000001,4.996666666666667,5.9958333333333336,6.9950000000000001,7.9941666666666666,8.9933333333333341,9.9924999999999997]
["T_l",20,20,20,20,20,20,20,20,20,20]
["Qs_S",6673.0537373166089,5853.9490680112403,5496.8132409175705,5189.8084442772652,4917.677859997053,4672.9121800486519,4450.7410408049591,4247.8120026575916,4061.5994801895299,3890.0957165666587]

{"sheet":"Koll","index":7,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["t",1,1.9991666666666668,2.9983333333333335,3.9975000000000001,4.996666666666667,5.9958333333333336,6.9950000000000001,7.9941666666666666,8.9933333333333341,9.9924999999999997]
["T_a",22.8,22.8,20.7,18.600000000000001,18.600000000000001,17.100000000000001,15.3,14.3,13.5,13.3]
["T_l_Koll",27.672190892309793,27.04782807498858,24.185456836538151,22.294844771103485,22.766133211400721,21.051531778692286,19.193004115226344,17.745996827493567,17.263006617855993,16.692527110253074]
["Qs_Koll",6672.8864240972107,5859.5238101493323,5498.0176667456517,5188.5682675580838,4914.7316164978683,4676.0244727108611,4451.3803903682428,4248.7820717474369,4061.5594066340218,3890.2483062496817]

{"sheet":"Waerme","index":8,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,0,0.99916666666666665,1.9983333333333333,2.9975000000000001,3.9966666666666666,4.9958333333333336,5.9950000000000001,6.9941666666666666,7.9933333333333332,8.9924999999999997]
[null,0,-9794.6041803933367,-19331.640876982485,-28822.639537772269,-38299.763455521483,-47758.443750510261,-57185.644958851291,-66566.074889679308,-75884.515467189369,-85126.833568540285]
[null,0,-12954.636047193522,-24879.85039349923,-35633.162180274747,-45315.891292448519,-54032.963260777578,-61884.068366217682,-68960.974514797053,-75346.817128271359,-81116.253383987147]
[null,0,-634.05125159103375,-786.13540610538178,-919.24361313539953,-1038.3145542402378,-1145.8753071958424,-1243.6369550798131,-1332.8785473904998,-1414.6154257352405,-1489.6882750635891]

{"sheet":"Simulation","index":9,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Varianten der Simulation"]
[null,"Mittlere Fluidtemperatur vorgegeben"]
[null,"Daraus ergibt sich die abzuführende Leistung"]
[null,"Aus der abzuführenden Leistung und den Wetterdaten kann die erforderliche mittlere Abgabetemperatur berechnet werden."]
[null,"Bei Maximalleistung Grädigkeit des WU definieren. Diese nimmt linear mit abnehmender Leistung ab."]
[null,"Daraus ergibt sich die mittlere Abgabetemperatur bei Free Cooling"]
[]
[null,"Mittlere Fluidtemperatur vorgegeben"]
[null,"Daraus ergibt sich die abzuführende Leistung"]
[null,"Bei Maximalleistung Grädigkeit des WU definieren. Diese nimmt linear mit abnehmender Leistung ab."]
[null,"Daraus ergibt sich die mittlere Abgabetemperatur"]
[]
[null,"Bei Maximalleistung Grädigkeit des WU definieren. Diese nimmt linear mit abnehmender Leistung ab."]
[null,"Free Cooling:"]
[null,"Annahme einer mittleren Fluidtemperatur T_l=T_i-1"]
[null,"Kühlbetrieb starten, falls T_a<T_i-2"]
[null,"Kühlbetrieb stoppen, falls T_i<=T_a+2"]
[1,"Berechnen der Kühlleistung"]
[2,"Berechnen der Grädigkeit"]
[3,"Berechnen der Abgabetemperatur"]
[4,"Berechnen der Abgabeleistung"]
[5,"Falls Kühlleistung > Abgabeleistung T_l=T_l + delta_T"]
[6,"Falls Kühlleistung < Abgabeleistung T_l=T_l - delta_T"]
[7,"Bei Vorzeichenwechsel delta_T=delta_T/2"]
[8,"Wiederholen ab 1 bis Leistungen nicht mehr als 1% abweichen"]
[null,"Resultate sind  T_l, T_K, Qs, Q"]
[]
[null,"Wärmepumpe:"]
[null,"Mittlere Fluidtemperatur vorgegeben"]
[null,"Daraus ergibt sich die abzuführende Leistung"]
[null,"Aus der abzuführenden Leistung und den Wetterdaten kann die erforderliche mittlere Abgabetemperatur berechnet werden."]
[null,"Grädigkeit von Verdampfer und Kondensator vorgeben"]
[null,"Temperaturhub berechnen"]

{"sheet":"Kollektormodelle","index":10,"n_rows":8,"n_cols":22,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Kollektor","eta0,b","Κ","Kd","a1 ","a2 ","a3 ","a4","a5 ","a6 ","a7 ","a8 ","A","Parameter bestimmt nach der modifizierten ISO 9806",null,null,null,null,null,null,null,"Kollektor"]
["Typ",null,null,null,"W/(m²K)","W/(m²K²)","Ws/(m3K)",null,"Ws/(m2K)","s/m","s/m","W/(m2K4)","m2","auf dem Prüfstand des SPF in Rapperswil",null,null,null,null,null,null,null,"Typ"]
["P1",0.65300000000000002,1479,1,19.678999999999998,0.02,1.3979999999999999,0.379,18135.3,1.9E-2,0.03,0,2,null,null,null,null,null,null,null,null,"P1"]
["P2",0.24399999999999999,727.4,1,23.83,0,2.87,0.73199999999999998,13608.7,0,0.01,0,2,null,null,null,null,null,null,null,null,"P2"]
["P3",0.40200000000000002,4.3630000000000004,0.88700000000000001,24.988,0.15,4.0359999999999996,5.8000000000000003E-2,6819.4,3.2000000000000001E-2,8.3000000000000004E-2,0,2,null,null,null,null,null,null,null,null,"P3"]
["P4",0.623,2213.1,1,22.423999999999999,3.2000000000000001E-2,5.01,0.03,3279.3,2.5999999999999999E-2,0.192,0,2,null,null,null,null,null,null,null,null,"P4"]
["P5",0.375,9.1170000000000009,1,56.351999999999997,5.3999999999999999E-2,5.9550000000000001,0,2631.7,0,6.8000000000000005E-2,0,2,null,null,null,null,null,null,null,null,"P5"]
["P6",0.38500000000000001,61.555999999999997,1,17.140999999999998,0,1.802,7.1999999999999995E-2,6662.4,3.5999999999999997E-2,0,0,2,null,null,null,null,null,null,null,null,"P6"]

{"sheet":"Umgebungsprofile","index":11,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Typische Tagesdatensätze für Umgebungsbedingungen"]
[null,"May, clear, warm (13. Mai)",null,null,null,"May, grey (1. Mai)",null,null,null,"July, clear, warm (6. Juli)",null,null,null,"July, grey (30. Juli)",null,null,null,"Test"]
["Zeit","T_a","EL","G","v","T_a","EL","G","v","T_a","EL","G","v","T_a","EL","G","v","T_a","EL","G","v","T_sky"]
["h","°C","W/Km2","W/Km2","m/s","°C","W/Km2","W/Km2","m/s","°C","W/Km2","W/Km2","m/s","°C","W/Km2","W/Km2","m/s","°C","W/Km2","W/Km2","m/s","K"]
[12,23.8,338,779,2.8,16.2,361,266,7.8,24.5,327,908,5.8,21.3,404,141,1.9,20,418.77499999999998,0,2,{"$f":"T_Sky(S5)","v":19.999965986391715}]
[13,25.2,339,830,3.8,17.3,365,280,6.4,26.1,328,985,6.5,21.6,405,149,1.4,20,418.77499999999998,0,2,{"$f":"T_Sky(S6)","v":19.999965986391715}]
[14,26.3,343,836,1.9,17.7,368,282,2.8,27.4,326,1010,7.7,21.9,405,169,1.2,20,418.77499999999998,0,2,{"$f":"T_Sky(S7)","v":19.999965986391715}]
[15,27.1,343,812,0.8,18.3,367,289,2.8,28.4,329,979,7.7,22.1,401,175,5.8,20,418.77499999999998,0,2,{"$f":"T_Sky(S8)","v":19.999965986391715}]
[16,27.6,345,743,1.7,18.399999999999999,367,277,6.4,28.9,329,901,10.199999999999999,22.3,398,167,4.0999999999999996,20,418.77499999999998,0,2,{"$f":"T_Sky(S9)","v":19.999965986391715}]
[17,27.7,347,620,0.9,18.399999999999999,368,220,2.6,29,333,781,14.6,22.3,402,146,6.5,20,418.77499999999998,0,2,{"$f":"T_Sky(S10)","v":19.999965986391715}]
[18,27.4,349,472,0.7,18.2,367,169,4.5999999999999996,28.7,335,625,11,22.2,404,101,6.5,20,418.77499999999998,0,2,{"$f":"T_Sky(S11)","v":19.999965986391715}]
[19,26.7,353,304,4.5999999999999996,17.8,370,101,1.3,27.8,334,444,12.4,22,400,74.099999999999994,2.9,20,418.77499999999998,0,2,{"$f":"T_Sky(S12)","v":19.999965986391715}]
[20,25.6,360,144,3.8,17.5,368,41.3,1,26.4,337,257,5.8,21.8,401,33.200000000000003,3.9,20,418.77499999999998,0,2,{"$f":"T_Sky(S13)","v":19.999965986391715}]
[21,24.3,360,9.6,4.2,17,363,1.2,0.5,24.7,343,93.7,4.0999999999999996,21,400,3.1,3.1,20,418.77499999999998,0,2,{"$f":"T_Sky(S14)","v":19.999965986391715}]
[22,22.8,361,0.04,1.1000000000000001,16.399999999999999,358,4.0000000000000001E-3,0.3,22.8,340,0.4,4.5,20.3,398,0.01,1.2,20,418.77499999999998,0,2,{"$f":"T_Sky(S15)","v":19.999965986391715},20.3,{"$f":"N15-W15","v":0}]
[23,21.2,357,0,1,15.8,353,0,1.1000000000000001,20.7,344,0,7.7,19.5,397,0,0.2,20,418.77499999999998,0,2,{"$f":"T_Sky(S16)","v":19.999965986391715},19.5,{"$f":"N16-W16","v":0}]
[24,19.7,354,0,1,15.2,347,0,1.5,18.600000000000001,342,0,4.5,18.600000000000001,392,0,0.1,20,418.77499999999998,0,2,{"$f":"T_Sky(S17)","v":19.999965986391715},18.600000000000001,0]
[1,18.8,346,0,4.5999999999999996,16.399999999999999,334,0,2.1,18.600000000000001,354,0,1.7,18.899999999999999,394,0,2.1,20,418.77499999999998,0,2,{"$f":"T_Sky(S18)","v":19.999965986391715},18.600000000000001,0.29999999999999716]
[2,17.5,344,0,2.2999999999999998,15.9,326,0,2.8,17.100000000000001,352,0,1.1000000000000001,18.899999999999999,392,0,2.1,20,418.77499999999998,0,2,{"$f":"T_Sky(S19)","v":19.999965986391715},18.899999999999999,0]
[3,16.100000000000001,341,0,1.3,15.3,325,0,1,15.3,341,0,0.4,18.3,389,0,1.5,20,418.77499999999998,0,2,{"$f":"T_Sky(S20)","v":19.999965986391715},18.899999999999999,-0.59999999999999787]
[4,15.4,337,0,3.5,15,321,0,0.2,14.3,337,0,1.9,18.8,393,0,0.8,20,418.77499999999998,0,2,{"$f":"T_Sky(S21)","v":19.999965986391715},18.3,0.5]
[5,14.9,334,0,6.1,14.7,326,0,0.1,13.5,335,0,0.5,19.100000000000001,394,0,0.5,20,418.77499999999998,0,2,{"$f":"T_Sky(S22)","v":19.999965986391715},18.8,0.30000000000000071]
[6,14.9,339,0,7,14.3,339,0,0.1,13.3,331,1,1.1000000000000001,19.100000000000001,394,0,0.7,20,418.77499999999998,0,2,{"$f":"T_Sky(S23)","v":19.999965986391715},19.100000000000001,0]
[7,15.5,340,52.8,6.1,14.4,349,4,0.3,14.4,329,93.6,2.4,18.899999999999999,394,4,1.4,20,418.77499999999998,0,2,{"$f":"T_Sky(S24)","v":19.999965986391715},19.100000000000001]
[8,16.8,343,192,3.5,15,353,50.8,1.1000000000000001,16.2,327,257,0.4,19.399999999999999,397,33.9,0.7,20,418.77499999999998,0,2,{"$f":"T_Sky(S25)","v":19.999965986391715}]
[9,18.5,343,358,3.8,15.5,354,109,0.8,18.2,325,444,1.5,20,399,63.9,0.8,20,418.77499999999998,0,2,{"$f":"T_Sky(S26)","v":19.999965986391715}]
[10,20.3,342,522,2.5,16.2,355,184,2.2999999999999998,20.399999999999999,319,626,2.9,20.399999999999999,401,103,4.8,20,418.77499999999998,0,2,{"$f":"T_Sky(S27)","v":19.999965986391715}]
[11,22.1,339,665,3.8,16.8,359,227,4.2,22.5,323,785,5.8,21,403,133,2.4,20,418.77499999999998,0,2,{"$f":"T_Sky(S28)","v":19.999965986391715}]
[]
["Umgebungsprofile"]
["May, clear, warm (13. Mai)"]
["May, grey (1. Mai)"]
["July, clear, warm (6. Juli)"]
["July, grey (30. Juli)"]
["Test"]

{"sheet":"Decke","index":12,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,1,1.9991666666666668,2.9983333333333335,3.9975000000000001,4.996666666666667,5.9958333333333336,6.9950000000000001,7.9941666666666666,8.9933333333333341,9.9924999999999997]
[0,26,25.483364983327302,25.281017656986876,25.126733614846327,24.99502650719301,24.875690327572762,24.763687475844421,24.656428266080916,24.552570879774297,24.451417188210467]
[1.2500000000000001E-2,26,25.569988824624421,25.367688288781672,25.21338608832696,25.081609303678782,24.962086729663262,24.84975323239453,24.742015786602998,24.637541016103871,24.535644229131044]
[2.5000000000000001E-2,26,25.647090784834887,25.447731500967087,25.294604537845977,25.163381128310331,25.044025450182861,24.931577468284999,24.823507478854054,24.718524829252047,24.615975914166871]
[3.7500000000000006E-2,26,25.714140208498485,25.520692445400893,25.36999247740539,25.239975690910622,25.121155104365304,25.008816175259842,24.900563245026365,24.79518472517551,24.692076764125666]
[0.05,26,25.771572223060538,25.586714214069879,25.439619791157547,25.311426967095123,25.193487891437318,25.081467102133455,24.973170579738191,24.86750050604066,24.763920561051162]
[6.25E-2,26,25.820003877950374,25.646008612474464,25.503590820824247,25.377787740383663,25.26104695023087,25.149534932968376,25.041321888870122,24.935455878054501,24.83148450257244]
[7.5000000000000011E-2,26,25.8601951620821,25.698849138596387,25.562041470708262,25.4391280189894,25.323865404301031,25.213030670759267,25.10501406514507,24.999038141400071,24.89474896428553]
[8.7500000000000008E-2,26,25.893004314837743,25.745562099158647,25.615135481777834,25.495533037303453,25.381985196246838,25.271970914967568,25.164248011275347,25.058237855146483,24.953697250918836]
[0.1,26,25.919341652224727,25.786516279457526,25.663059982825999,25.547100889682326,25.43545573593693,25.326377046374557,25.219028118296176,25.113048481649685,25.008315339123151]
[0.1125,26,25.94012582201956,25.82211162579717,25.706020447161546,25.593939854505347,25.484332392670197,25.376274335458422,25.269361708101883,25.163466015663602,25.05859161507356]
[0.125,26,25.956245657695579,25.852767410539418,25.74423519864564,25.636165475149674,25.528674865838862,25.421690992831348,25.315258450384476,25.209488603971781,25.104516610355361]
[0.13750000000000001,26,25.968529779213601,25.87891033061813,25.777929620854326,25.673897471302688,25.568545472283358,25.462657182131945,25.356729765110202,25.251116161808753,25.146082739821026]
[0.15000000000000002,26,25.97772496823081,25.900962945275285,25.807330227729569,25.707256558733643,25.604007391135266,25.499204017102649,25.393788222331207,25.288349992654588,25.183284045242374]
[0.16250000000000001,26,25.984483290979622,25.91933279401615,25.832658753558313,25.736361258182136,25.635122908467142,25.531362565354126,25.426446951496555,25.321192418145433,25.216115948636752]
[0.17500000000000002,26,25.989357079084233,25.934402458923106,25.854126414990418,25.761324774362016,25.661951704465224,25.559162881505564,25.454719072487812,25.349646424840568,25.244575019115068]
[0.1875,26,25.992800278383076,25.946520754572241,25.871928488732006,25.782252024258668,25.684549225103744,25.582633091983958,25.478617160355292,25.373715334421789,25.268658756982251]
[0.2,26,25.995174355449524,25.955995151584187,25.886239336278255,25.79923689000692,25.702965178449297,25.601798552776525,25.49815275517679,25.393402503575494,25.288365398618392]
[0.21250000000000002,26,25.996756883308382,25.963085472956006,25.897207992344004,25.812359765816709,25.717242192810751,25.616681099882669,25.513335927613923,25.408711059329146,25.303693745385662]
[0.22500000000000001,26,25.997751055624278,25.96799885073878,25.904954417229128,25.821685460848116,25.727414670054472,25.627298410144782,25.524174909622854,25.419643674992528,25.314643019447271]
[0.23750000000000002,26,25.998294635464173,25.97088589726236,25.909566495836973,25.827261510845158,25.733507862629711,25.63366348760561,25.530675798414155,25.426202391105043,25.321212748959038]
[0.25,26,25.998467168568077,25.971838030645301,25.911097847934197,25.829116940964301,25.735537197323065,25.635784287608693,25.532842340185859,25.428388484931908,25.323402684610095]

{"sheet":"Wand","index":13,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,1,1.9991666666666668,2.9983333333333335,3.9975000000000001,4.996666666666667,5.9958333333333336,6.9950000000000001,7.9941666666666666,8.9933333333333341,9.9924999999999997]
[0,26,25.433093440304262,25.012518331335944,24.633509345104947,24.292287252772546,23.985084791108488,23.708360619683944,23.458871047996713,23.233685404178111,23.030175839508132]
[4.0000000000000001E-3,26,25.459787105115783,25.036627550038748,24.655227477602239,24.311838723975448,24.00268876237693,23.724221327123804,23.473174723495049,23.246599892492096,23.041851433723306]
[8.0000000000000002E-3,26,25.484930086531357,25.05933718214893,24.675685052780345,24.330255422877833,24.019270938805146,23.739161329101876,23.486647965050306,23.258764479652111,23.052848944783783]
[1.2E-2,26,25.507153125607939,25.079411329493929,24.693768928609593,24.346535280612805,24.033929019816103,23.752367597426634,23.498557464608954,23.269516977759928,23.062569608865456]
[1.6E-2,26,25.526441942606318,25.096836424906467,24.709466726533794,24.36066713484189,24.046652996612419,23.763831184568044,23.508895235804385,23.278850263454181,23.071007073733011]
[0.02,26,25.542784167172318,25.111600695760128,24.722767702289897,24.372641295779715,24.057434180225087,23.773544322618726,23.517654345059984,23.286758152357859,23.078155824483272]
[2.4E-2,26,25.556169336543427,25.123694170175057,24.733662752844118,24.382449552942496,24.066265207796437,23.781500429020628,23.524828916749236,23.293235403698137,23.084011187666601]
[2.8000000000000001E-2,26,25.56658889363548,25.133108682247638,24.74214442225993,24.390085180862304,24.073140047902356,23.787694111416993,23.530414137568076,23.298277724221286,23.088569334779493]
[3.2000000000000001E-2,26,25.574036185194167,25.139837876314566,24.748206906498407,24.395542943765168,24.078054004910747,23.792121171626416,23.534406260116519,23.301881771399685,23.09182728512576]
[3.6000000000000004E-2,26,25.578506460174342,25.143877210260062,24.751846057151276,24.398819099211284,24.081003722373961,23.794778608736458,23.536802605686962,23.304045155928602,23.093782908044126]
[0.04,26,25.579996868481313,25.14522395787316,24.753059384107189,24.399911400696098,24.081987185453244,23.795664621314785,23.537601566257226,23.304766443510943,23.09443492450055]

{"sheet":"Luft","index":14,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["t",1,1.9991666666666668,2.9983333333333335,3.9975000000000001,4.996666666666667,5.9958333333333336,6.9950000000000001,7.9941666666666666,8.9933333333333341,9.9924999999999997]
["T_i",26,24.766957078017914,24.471198194490778,24.212341939378529,23.98078403175726,23.771610049713743,23.581492440668494,23.407943830096428,23.248989677644254,23.102995098712242]