{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Hinweise zum Programm","Version","Auslegung","Funktion","Maße","Datenblatt","Grunddaten","Lw","DR","Berechnung-R","Berechnung-L","Temperaturprofil"],"not_rendered":{"charts":2,"images":14,"macros":1,"external_links":1,"defined_names":5,"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":"Hinweise zum Programm","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Hinweise zur Bedienung"]
[]
["Allgemeine Hinweise:"]
["Das Auslegungstool QAL dient als Hilfsmittel zur Technischen Planung der emcoair Quellluftdurchlässe. "]
[]
["Auslegung:"]
["Im Tabellenblatt \"Auslegung\" erfolgt die Festlegung des gewünschten Auslasstyps. Bei Eingabe der Vorgabedaten, wie z.B. dem benötigten Luftvolumenstrom werden die technischen Daten des gewählten Luftdurchlasses berechnet."]
[]
["Strömungsformen:"]
["Die im Tabellenblatt \"Auslegung\" ermittelten Strömungsgeschwindigkeiten gelten für einen deckenbündig montierten Luftdurchlass mit horizontaler Ausblascharakteristik. "]
[]
["Funktion:"]
["Im Tabellenblatt \"Funktion\" finden Sie eine kurze Funktionsbeschreibung zum emcoair QAL."]
[]
["Hinweise zur Funktion:"]
["Für eine ordnungsgemäße Funktion des Auslegungstools muss die Ausführung von Makros und MS Excel aktiviert sein. Die Aktivierung von Makros erfolgt im Menü Makrosicherheit."]
["Einstellung unter MS Excel 97-2003: Extras → Makro → Sicherheit"]
["Einstellung unter MS Excel 2007: Entwicklertools* → Makrosicherheit  "]
["*Das Menü Entwicklertools muss unter Umständen eingefügt werden unter Excel-Optionen"]

{"sheet":"Version","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Service",{"$f":"MID(CELL(\"dateiname\"),FIND(\"[\",CELL(\"dateiname\"))+1,FIND(\"]\",CELL(\"dateiname\"))-FIND(\"[\",CELL(\"dateiname\"))-1)","v":"655_Auslegungstool_QAL_201030.xlsm"}]
["Version:","1.0"]

{"sheet":"Auslegung","index":2,"n_rows":135,"n_cols":12,"rows_kept":135,"cut":false,"hidden":false,"merged":[[86,1,86,4],[130,3,130,4],[115,3,115,4],[117,3,117,4],[124,3,124,4],[125,3,125,4],[126,3,126,4],[119,3,119,4],[118,3,118,4],[0,0,0,3],[34,0,34,4],[43,3,43,4],[7,3,7,4],[5,0,5,4],[11,3,11,4],[17,3,17,4],[25,3,25,4],[31,3,31,4],[6,3,6,4],[32,3,32,4],[18,3,18,4],[36,3,36,4],[37,3,37,4],[42,0,42,4],[38,3,38,4],[129,5,129,6],[91,1,91,4],[88,1,88,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[95,0,95,4],[106,3,106,4],[107,3,107,4],[98,3,98,4],[99,3,99,4],[102,3,102,4],[104,3,104,4],[105,3,105,4],[103,3,103,4],[26,3,26,4],[29,3,29,4],[30,3,30,4],[96,3,96,4],[97,3,97,4],[83,1,83,4],[82,1,82,4],[72,0,72,4],[73,1,73,4],[35,3,35,4],[71,3,71,4],[78,1,78,4],[77,1,77,4],[39,3,39,4],[68,3,68,4],[40,3,40,4]]}
["Auslegung Kampmann Quellluftdurchlässe QAL"]
[]
["Eingabefelder sind gelb gekennzeichnet"]
["Ergebnisfelder sind blau gekennzeichnet"]
[]
["Vorgaben"]
["Lüftungstechnik","Symbol","Einheit","Wert"]
["Bezeichung","Symbol","Einheit"]
[null,"L","mm"]
[null,"L","mm"]
[null,"L","mm"]
["Durchlass Typ",null,null,"QAL-K"]
[null,null,null,"QAL-L"]
[null,null,null,"QAL-K"]
[null,null,null,"QAL-R"]
[null,null,null,"QAL-H"]
[null,null,null,"QAL-V"]
["Nenn-Höhe","H","mm",1500]
[{"$f":"IF(OR(D12=\"QAL-L\",D12=\"QAL-K\"),\"Nenn-Breite\",\"Nenn-Durchmesser\")","v":"Nenn-Breite"},"DN","[-]",1000]
[null,null,null,{"$f":"IF(OR(D12=\"QAL-H\",D12=\"QAL-V\"),\"\",400)","v":400}]
[null,null,null,{"$f":"IF(D12=\"QAL-V\",\"\",600)","v":600}]
[null,null,null,800]
[null,null,null,1000]
[null,null,null,{"$f":"IF(D12=\"QAL-V\",1200,\"\")","v":""}]
[null,null,null,{"$f":"IF(D12=\"QAL-V\",1400,\"\")","v":""}]
["Luftvolumenstrom, Einzeldurchlass","V·0","m³/h",860]
["Anschlussstutzen",null,null,"rund"]
[null,null,null,"rund"]
[null,null,null,"eckig"]
[{"$f":"IF($D$27=\"rund\",\"Stutzendurchmesser\",\"Stutzenbreite\")","v":"Stutzendurchmesser"},"d","mm",355]
["Stutzenlänge","t","mm",250]
["Temperatur Zuluft","Dt0","°C",17]
["Temperatur in 1,1m Höhe","tRaum","°C",23]
[]
["Raumdaten"]
["Raumhöhe","H1","m",4]
["Obergrenze Aufenthaltsbereich","H2","m",1.8]
["Raumlänge","LR","m",12]
["Raumbreite","BR","m",6]
["Unterkante Aufenthaltsbereich","hmin","m",0.1]
["Maximale Luftgeschwindigkeit im Aufenthaltsbereich","vmax","m/s",0.2]
[]
["Akustikdaten"]
["Raumart nach VDI 2081",null,null,"Konzertsaal"]
[null,null,"Einzelbüro",null,null,null,null,null,5,"min. Abmessung Frontblende rund",{"$f":"Grunddaten!AB33","v":0},"mm"]
[null,null,"Großraumbüro"]
[null,null,"Werkstätten"]
[null,null,"Ruheraum, Pausenraum"]
[null,null,"Untersuchungsraum Krankenhaus"]
[null,null,"Rundfunk-, Fernsehstudio"]
[null,null,"Chemielabor"]
[null,null,"Wasch- und WC-Raum, Umkleide"]
[null,null,"Schwimmbad"]
[null,null,"EDV-Raum"]
[null,null,"Konzertsaal"]
[null,null,"Lesesaal"]
[null,null,"Museum"]
[null,null,"Küche"]
[null,null,"Theater, Kino"]
[null,null,"Klassen- Seminarraum"]
[null,null,"Gaststätte"]
[null,null,"kein Typ"]
[null,null,"Konferenzraum"]
[null,null,"Hotelzimmer"]
[null,null,"Hörsaal"]
[null,null,"Bettenzimmer Krankenhaus"]
[null,null,"Verkaufsraum"]
[null,"","Sporthalle"]
["Betrachteter Durchlass",null,null,"Zuluft"]
[null,null,null,"Zuluft"]
[null,null,null,"Abluft"]
["Abstand zur Schallquelle","r","m",1.5]
["Zusatzdaten"]
["Funktion","",null,null,null,{"$f":"VLOOKUP(B74,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($B$74,$B$75:$G$77,6,0)","v":"Z"}]
[null,{"$f":"IF(D12=500,\"Zuluft\",\"\")","v":""},null,null,null,null,"Z"]
[null,{"$f":"IF(D12=500,\"Abluft\",\"\")","v":""},null,null,null,null,"A"]
[null,{"$f":"IF(D12>500,\"Zuluft/Abluft-Kombination\",\"\")","v":"Zuluft/Abluft-Kombination"},null,null,null,null,"K"]
["Farbe Abdeckprofil und Endwinkel",9010,null,null,null,{"$f":"VLOOKUP(B78,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"$B$78","v":9010}]
["Farbe Luftlenkelement","schwarz",null,null,null,null,{"$f":"VLOOKUP(B79,B80:G82,6,FALSE)","v":"S"}]
[null,"schwarz",null,null,null,null,"S"]
[null,"weiß",null,null,null,null,"W"]
[null,"grau",null,null,null,null,"G"]
["Einstellung Luftlenkelement","Deckenstrahl D / E",null,null,null,null,{"$f":"VLOOKUP(B83,B84:G87,6,FALSE)","v":"D"}]
[null,"Deckenstrahl D / E",null,null,null,null,"D"]
[null,"Sondereinstellung",null,null,null,null,"S"]
[]
["Werkstoff Anschlusskasten","Stahl verzinkt",null,null,null,null,"V"]
[null,"Stahl verzinkt"]
["frontseitig bedienbare Drossel","ohne",null,null,null,{"$f":"VLOOKUP(B89,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B89,B90:G92,6,FALSE)","v":0}]
[null,"mit",null,null,null,null,1]
[null,"ohne",null,null,null,null,0]
["Innenauskleidung","Baustoffklasse B1 (Standard)",null,null,null,null,{"$f":"VLOOKUP(B92,B93:G96,6,FALSE)","v":"B1"}]
[null,"Baustoffklasse B1 (Standard)",null,null,null,null,"B1"]
[null,"Baustoffklasse A2 (optional)",null,null,null,null,"A2"]
[]
["Thermische Daten",null,null,null,null,null,{"$f":"IF(D12<1000,CONCATENATE(0,D12),D12)","v":"QAL-K"}]
["spezifische Kühllast","q°","W/m²",35,null,null,{"$f":"IF(K124=78,\"080\",100)","v":100}]
["Gesamtkühllast","Q°K","W",{"$f":"'Berechnung-R'!$B$19","v":2520}]
["Kühlleistung Durchlass","Q°D","W",{"$f":"'Berechnung-R'!$B$17","v":1730.32}]
["Kühlleistungs-Asymmetrie","DQ°K","W",{"$f":"'Berechnung-R'!$B$20","v":789.68000000000006}]
[]
["Berechnung strömungstechnische und Akustische Daten"]
["Druckverlust","Dpt","Pa",{"$f":"Grunddaten!$AC$33","v":2.9063274174252847}]
["Anströmgeschwindigkeit","v0","m/s",{"$f":"Grunddaten!$V$33","v":0.15925925925925927}]
["Austrittsgeschwindigkeit","vSUP","m/s",{"$f":"Grunddaten!$AD$33","v":0.15925925925925927}]
["Nahzone","LN","m",{"$f":"IF(OR($D$12=\"QAL-L\",$D$12=\"QAL-K\"),'Berechnung-L'!$I$1,'Berechnung-R'!$I$1)","v":2.2000000000000002}]
["Temperatur in Fußbodennähe","t0,1","°C",{"$f":"IF(OR(D12=\"QAL-L\",D12=\"QAL-K\"),'Berechnung-L'!$I$2,'Berechnung-R'!$I$2)","v":18.775471960466291}]
["Ablufttemperatur","tETA","°C",{"$f":"'Berechnung-R'!$B$24","v":25.738268066022471}]
["Geschwindigkeit im Fußbodenbereich in Wandnähe","vx1","m/s",{"$f":"IF(D69=\"Zuluft\",IF(#REF!< 0.1,\"< 0,1\",#REF!),\"\")","v":{"$error":"#REF!"}}]
["Zugluftrisiko am Fußboden**","DR1","%",{"$f":"IF(D69=\"Zuluft\",IF($D$32>$D$33,\"Heizfall\",DR!$C$16),\"\")","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(D32>D33,D12=\"MSA\"),\"Eindringtiefe (Walzenstellung CD)\",\"Geschwindigkeit im Aufenthaltsbereich*\")","v":"Geschwindigkeit im Aufenthaltsbereich*"},"vx2",{"$f":"IF(AND(D33<=D32,D12=\"MSA\"),\"m\",\"m/s\")","v":"m/s"},{"$f":"IF(D69=\"Zuluft\",IF($D$32>$D$33,#REF!,IF(#REF!<0.1,\"< 0,1\",#REF!)),\"\")","v":{"$error":"#REF!"}}]
["Zugluftrisiko im Aufenthaltsbereich**","DR2","%",{"$f":"IF(D69=\"Zuluft\",IF($D$32>$D$33,\"Heizfall\",DR!$C$24),\"\")","v":{"$error":"#REF!"}}]
["Geschwindigkeit nach Ablösen an Xkr.","vx3","m/s",{"$f":"IF(D69=\"Zuluft\",IF(#REF!<0.1,\"<0,1\",IF($D$32>=$D$33,\"Heizfall\",#REF!)),\"\")","v":{"$error":"#REF!"}}]
["Zugluftrisiko nach Ablösepunkt**","DR3","%",{"$f":"IF(D69=\"Zuluft\",IF($D$32>=$D$33,\"Heizfall\",DR!$C$32),\"\")","v":{"$error":"#REF!"}}]
["Resultierende Raumkategorie","RAL","[-]",{"$f":"IF(D69=\"Zuluft\",IF(D32>=D33,\"Heizfall\",IF(AND($D$110<9.95,$D$112<9.95,$D$114<9.95),\"A\",IF(AND($D$110<19.95,$D$112<19.95,$D$114<19.95),\"B\",IF(AND($D$110<29.95,$D$112<29.95,$D$114<29.95),\"C\",\"Außerhalb C\")))),\"\")","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(\"Schallleistungspegel, \",D69,\"durchlass*\")","v":"Schallleistungspegel, Zuluftdurchlass*"},"LWA_SUP","dB(A)",{"$f":"IF(Grunddaten!$AK$33<25,\"<25\",Grunddaten!$AK$33)","v":"<25"},null,null,null,null,1,"Breite Durchlass",{"$f":"Grunddaten!D33","v":1033},"mm"]
["Schalldruckpegel, Zahlenwert Zuluft + Abluft",null,null,{"$f":"D116+10*LOG(Lw!$K$130/(4*PI()*Auslegung!D72^2)+4/(Lw!$M$130))","v":{"$error":"#VALUE!"}},{"$f":"E116+10*LOG(Lw!$K$130/(4*PI()*Auslegung!E72^2)+4/(Lw!$M$130))","v":{"$error":"#DIV/0!"}}]
[{"$f":"CONCATENATE(\"Schallldruckpegel in \",D72,\"m Entfernung\")","v":"Schallldruckpegel in 1,5m Entfernung"},"LPA_SUP","dB(A)",{"$f":"IF(D69=\"Zuluft\",IF(D116=\"<25\",\"<25\",IF(D116+10*LOG(Lw!$G$78/(4*PI()*Auslegung!D72^2)+4/(Lw!$I$78))>=25,D116+10*LOG(Lw!$G$78/(4*PI()*Auslegung!D72^2)+4/(Lw!$I$78)),\"<25\")),\"\")","v":"<25"},null,null,null,null,2,"Höhe Durchlass",{"$f":"Grunddaten!F33","v":1533},"mm"]
["Schalldruckpegel rechnerisch ",null,null,{"$f":"IF(10*LOG(10^(D117/10)+10^(E117/10))<25,\"<25\",10*LOG(10^(D117/10)+10^(E117/10)))","v":{"$error":"#VALUE!"}}]
["Summen-Schallldruckpegel im betrachteten Punkt","LPA","dB(A)",{"$f":"IFERROR(IF(E117-D117>6,MAX(E117,D117),D119),IF(E118=\"a. Anf\",D118,IF(AND(D118=\"<25\",E118=\"<25\"),\"<25\",\"a. Anf\")))","v":"a. Anf"}]
["*Schallleistungspegel nur gültig für Anströmgeschwindigkeiten <3m/s",null,null,null,null,null,null,null,3,"Tiefe Durchlass",{"$f":"Grunddaten!E33","v":6.5},"mm"]
[null,null,null,null,null,null,null,null,5,{"$f":"IF(D27=\"rund\",\"\",A31)","v":""},{"$f":"IF(D27=\"rund\",\"\",D31)","v":""},"mm"]
[null,null,null,null,null,null,null,null,4,{"$f":"A30","v":"Stutzendurchmesser"},{"$f":"IF(D27=\"rund\",Grunddaten!K33,D30)","v":" -/-"},"mm"]
["Oktavspektrum Schallleistung","LW_Okt","dB",null,null,null,null,null,6,"Abstand Wand - Stutzenmitte",{"$f":"Grunddaten!O33","v":" -/-"},"mm"]
[null,"LW_125","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!G$69)","v":""},null,null,null,null,7,"Minimaler Volumenstrom",{"$f":"Grunddaten!S33","v":809.99999999999989},"m³/h"]
[null,"LW_250","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!H$69)","v":""},null,null,null,null,8,"Maximaler Volumenstrom",{"$f":"Grunddaten!T33","v":1350},"m³/h"]
[null,"LW_500","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!I$69)","v":""}]
[null,"LW_1000","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!J$69)","v":""}]
[null,"LW_2000","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!K$69)","v":""}]
[null,"LW_4000","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!L$69)","v":""},null,{"$f":"IF($D$116>25,Lw!N69,\"a. Anf\")","v":0}]
[null,"LW_8000","dB",{"$f":"IF($D$116=\"<25\",\"\",Lw!M$69)","v":""}]
[]
["Änderungen vorbehalten"]
["Stand:"]
[{"$f":"Grunddaten!E36","v":"2020-10-30"}]

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

{"sheet":"Maße","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Datenblatt","index":5,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,7],[32,2,32,3],[25,5,25,6],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[5,6,5,7],[5,2,5,4],[34,2,34,3],[26,5,26,6],[33,2,33,3],[9,0,9,8],[18,6,18,7],[22,5,22,6],[23,5,23,6],[24,5,24,6],[27,5,27,6]]}
[]
["Typ",{"$f":"Auslegung!$D$12","v":"QAL-K"},null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-02-03"}]
["Projekt","bitte Projektnummer angeben"]
[]
["Definition:"]
["Durchlass, Typ:",{"$f":"Auslegung!$D$12","v":"QAL-K"},"Nennhöhe:",null,null,{"$f":"Auslegung!$D$18","v":1500},"Nenngröße:",null,{"$f":"Auslegung!D19","v":1000}]
["Schlitzanzahl:",{"$f":"Auslegung!D18","v":1500},"Farbe Abdeckprofil:",null,{"$f":"Auslegung!B78","v":9010}]
["Innenauskleidung:",{"$f":"Auslegung!G92","v":"B1"},"Drossel fb:",null,{"$f":"Auslegung!B89","v":"ohne"}]
[]
["Beschreibung:\nLuftdurchlass in linearer (-L), runder (-R), halbrunder (-H), viertelrunder (-V) Bauform bzw. Durchlassfront zur direkten Montage innerhalb von Lüftungskanälen (-K) zur\nErzeugung einer turbulenzarmen Quellluftströmung im Komfortbereich."]
["Einsatzbereich"]
["Minimalvolumenstrom","V°min",{"$f":"Auslegung!$K$125","v":809.99999999999989},"m³/h"]
["Maximalvolumenstrom","V°max",{"$f":"Auslegung!$K$126","v":1350},"m³/h"]
[]
["technische Vorgaben",null,null,null,null,"Raumdaten"]
["Luftvolumenstrom Zuluft","V·SUP",{"$f":"Auslegung!D26","v":860},"m³/h",null,"Raumhöhe",{"$f":"Auslegung!D36","v":4},"m"]
["Temperatur Zuluft","tZUL",{"$f":"Auslegung!D32","v":17},"°C",null,"Raumbreite ",{"$f":"Auslegung!D39","v":6},"m"]
["Temperatur Raum","tRAUM",{"$f":"Auslegung!D33","v":23},"°C",null,"Raumlänge",{"$f":"Auslegung!D38","v":12},"m"]
[{"$f":"Auslegung!A40","v":"Unterkante Aufenthaltsbereich"},"hmin",{"$f":"Auslegung!D40","v":0.1},"m",null,"Nutzungsart",{"$f":"Auslegung!D44","v":"Konzertsaal"}]
[{"$f":"Auslegung!A41","v":"Maximale Luftgeschwindigkeit im Aufenthaltsbereich"},"vmin",{"$f":"Auslegung!D41","v":0.2},"m/s"]
[]
["technische Daten",null,null,null,null,"Maße / Einsatzbereich"]
[{"$f":"CONCATENATE(\"Druckverlust \",Auslegung!D69,\"durchlass\")","v":"Druckverlust Zuluftdurchlass"},"Dp_SUP/ETA",{"$f":"IF(Auslegung!D103=\"\",Auslegung!E103,Auslegung!D103)","v":2.9063274174252847},null,"Pa",{"$f":"Auslegung!J116","v":"Breite Durchlass"},null,{"$f":"Auslegung!K116","v":1033},{"$f":"Auslegung!L116","v":"mm"}]
[{"$f":"Auslegung!A104","v":"Anströmgeschwindigkeit"},"v0",{"$f":"Auslegung!D104","v":0.15925925925925927},null,"m",{"$f":"Auslegung!J118","v":"Höhe Durchlass"},null,{"$f":"Auslegung!K118","v":1533},{"$f":"Auslegung!L118","v":"mm"}]
[{"$f":"Auslegung!A105","v":"Austrittsgeschwindigkeit"},"vSUP",{"$f":"Auslegung!D105","v":0.15925925925925927},null,"m/s",{"$f":"Auslegung!J123","v":"Stutzendurchmesser"},null,{"$f":"Auslegung!K123","v":" -/-"},{"$f":"Auslegung!L123","v":"mm"}]
[{"$f":"Auslegung!A106","v":"Nahzone"},"LN",{"$f":"Auslegung!D106","v":2.2000000000000002},null,"m",{"$f":"Auslegung!J124","v":"Abstand Wand - Stutzenmitte"},null,{"$f":"Auslegung!K124","v":" -/-"},{"$f":"Auslegung!L124","v":"mm"}]
[{"$f":"Auslegung!A107","v":"Temperatur in Fußbodennähe"},"t0,1",{"$f":"Auslegung!D107","v":18.775471960466291},null,"°C",{"$f":"IF(Auslegung!$D$27=\"rund\",\"\",Auslegung!A31)","v":""},null,{"$f":"IF(Auslegung!$D$27=\"rund\",\"\",Auslegung!D31)","v":""},{"$f":"IF(H27=\"\",\"\",\"mm\")","v":""}]
[{"$f":"Auslegung!A116","v":"Schallleistungspegel, Zuluftdurchlass*"},"LWA_SUP",{"$f":"Auslegung!D116","v":"<25"},null,"dB(A)"]
[{"$f":"Auslegung!A118","v":"Schallldruckpegel in 1,5m Entfernung"},"LPA_SUP",{"$f":"Auslegung!D118","v":"<25"},null,"dB(A)"]
["*Schallleistungspegel nur gültig für Anströmgeschwindigkeiten <3m/s"]
["Oktavspektrum Schallleistungspegel","f [Hz]",125,250,500,1000,2000,4000,8000]
[{"$f":"Auslegung!D69","v":"Zuluft"},"LWA_Okt",{"$f":"IF(Auslegung!$D$125=\"\",Auslegung!$E$125,Auslegung!$D$125)","v":0},{"$f":"IF(Auslegung!$D$126=\"\",Auslegung!$E$126,Auslegung!$D$126)","v":0},{"$f":"IF(Auslegung!$D$127=\"\",Auslegung!$E$127,Auslegung!$D$127)","v":0},{"$f":"IF(Auslegung!$D$128=\"\",Auslegung!$E$128,Auslegung!$D$128)","v":0},{"$f":"IF(Auslegung!$D$129=\"\",Auslegung!$E$129,Auslegung!$D$129)","v":0},{"$f":"IF(Auslegung!$D$130=\"\",Auslegung!$E$130,Auslegung!$D$130)","v":0},{"$f":"IF(Auslegung!$D$131=\"\",Auslegung!$E$131,Auslegung!$D$131)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"technische Änderungen vorbehalten"]
[null,null,null,null,null,null,null,"Stand:",{"$f":"Grunddaten!$E$36","v":"2020-10-30"}]

{"sheet":"Grunddaten","index":6,"n_rows":44,"n_cols":40,"rows_kept":44,"cut":false,"hidden":true,"merged":[[0,37,0,40],[0,12,0,13],[37,25,37,26],[0,22,0,27],[0,29,0,35],[1,31,1,35]]}
["Typ","DN",null,"Breite","Tiefe","Höhe","min. Baubreite","max. Baubreite","min. Bauhöhe","max. Bauhöhe","Stutzendurchmesser","Nenndurch-messer, Stutzen rund","Abmessungen Rechteckstutzen",null,"Abstand Wand-Stutzenmitte","Soll-Volumenstrom","v Auslegung min","v Auslegung max","Volumenstrom minimal","Volumenstrom maximal","Aktive Fläche","Anströmgeschwindigkeit","Druckverlust, Zuluft",null,null,null,null,null,"Totaldruckverlust"]
[null,"Nenngröße",null,"b","t","h ","bmin","bmax","hmin","hmax","d","DN","l","b","e","V°","vmin","vmax","V°min","V°max","Aakt","v","K1","K2","K3","K4","K5","K6",null,"Ausströmgeschwindigkeit","im Auslegungsbereich?","Schallleistungspegel",null,null,null,null,"LW,A"]
[null,null,null,"mm","mm","mm",null,null,"mm","mm","mm","mm","mm","mm","mm","m³/h","m/s","m/s","m³/h","m³/h","mm²","m/s","Pa","Pa","mm","mm","mm","mm",null,null,null,"K1","K2","K3","K4","K5"]
["QAL-L",400,{"$f":"CONCATENATE(A4,B4)","v":"QAL-L400"},402,332,{"$f":"Auslegung!$D$18","v":1500},400,400,600,1500,224,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},166,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,{"$f":"Q4*U4*3600","v":324},{"$f":"R4*U4*3600","v":540},{"$f":"(D4-2)/1000*Auslegung!$D$18/1000","v":0.6},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L4/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},5.4191645917222557E-5,1.984842659274026,{"$f":"Z4*Auslegung!$D$18^Grunddaten!AA4","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W4*P4^X4*Y4","v":24.313972257534651},{"$f":"P4/U4/3600","v":0.3981481481481482},{"$f":"IF(AND(Q4<AD4,AD4<R4),\"x\",\"\")","v":""},-4.0385141989319777,2.092826447670777,24.663795305046342,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF4+AG4*LOG(P4)+AH4*LOG(AC4)","v":36.283348425405464},null,"L-400"]
["QAL-L",600,{"$f":"CONCATENATE(A5,B5)","v":"QAL-L600"},602,382,{"$f":"Auslegung!$D$18","v":1500},600,600,600,1500,280,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},191,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,{"$f":"Q5*U5*3600","v":486.00000000000006},{"$f":"R5*U5*3600","v":810},{"$f":"(D5-2)/1000*Auslegung!$D$18/1000","v":0.9},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L5/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.7635340349285521E-5,2.0713094444213813,{"$f":"Z5*Auslegung!$D$18^Grunddaten!AA5","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W5*P5^X5*Y5","v":14.192015209098075},{"$f":"P5/U5/3600","v":0.26543209876543211},{"$f":"IF(AND(Q5<AD5,AD5<R5),\"x\",\"\")","v":""},-3.4698452198240322,3.0892479069308343,23.097060913742435,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF5+AG5*LOG(P5)+AH5*LOG(AC5)","v":32.204379990323226}]
["QAL-L",800,"QAL-L800",802,382,{"$f":"Auslegung!$D$18","v":1500},800,800,600,1500,280,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},191,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,648,1080,{"$f":"(D6-2)/1000*Auslegung!$D$18/1000","v":1.2},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L6/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.8952055887082448E-5,2.0388736815459252,{"$f":"Z6*Auslegung!$D$18^Grunddaten!AA6","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,12.249936987114202,0.1990740740740741,"x",-2.8483072883379363,3.0365463789063427,22.67012768617446,-1.2001156502132525E-2,12.001381377435667,30.730566783922765]
["QAL-L",1000,"QAL-L1000",1002,402,{"$f":"Auslegung!$D$18","v":1500},1000,1000,600,1500,315,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},201,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,809.99999999999989,1350,{"$f":"(D7-2)/1000*Auslegung!$D$18/1000","v":1.5},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L7/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.5075621903040784E-5,2.0479672989185951,{"$f":"Z7*Auslegung!$D$18^Grunddaten!AA7","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,10.361865941505172,0.15925925925925927,"x",-2.8177172228034766,3.1012531456057331,22.718532960249423,-1.2001156502132525E-2,12.001381377435667,29.352166302814837]
["QAL-R",400,"QAL-R400",402,402,{"$f":"Auslegung!$D$18","v":1500},400,400,600,1500,315,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250}," -/-",{"$f":"Auslegung!$D$26","v":860},0.15,0.25,1017.876019763093,1696.4600329384882,{"$f":"((D8-2)/1000)*PI()*Auslegung!$D$18/1000","v":1.8849555921538759},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L8/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},8.2182108979129628E-5,1.8368873773714451,{"$f":"Z8*Auslegung!$D$18^Grunddaten!AA8","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,13.568327311338795,0.12673449172132409,"",-5.3380272169466565,0.21618418057492517,26.520029133283828,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF8+AG8*LOG(P8)+AH8*LOG(AC8)","v":25.330995704171016},null,"R-400"]
["QAL-R",600,"QAL-R600",602,602,{"$f":"Auslegung!$D$18","v":1500},600,600,600,1500,400,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250}," -/-",{"$f":"Auslegung!$D$26","v":860},0.15,0.25,1526.8140296446395,2544.6900494077322,{"$f":"(D9-2)/1000*PI()*Auslegung!$D$18/1000","v":2.8274333882308138},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L9/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},2.7194389502580692E-5,1.9050767655330434,{"$f":"Z9*Auslegung!$D$18^Grunddaten!AA9","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W9*P9^X9*Y9","v":7.1175413209118155},8.4489661147549383E-2,"",-4.0285722003573534,2.1246325306512959,23.70364216983258,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF9+AG9*LOG(P9)+AH9*LOG(AC9)","v":22.409483932753986}]
["QAL-R",800,"QAL-R800",802,802,{"$f":"Auslegung!$D$18","v":1500},800,800,600,1500,450,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250}," -/-",{"$f":"Auslegung!$D$26","v":860},0.15,0.25,2035.7520395261861,3392.9200658769764,{"$f":"(D10-2)/1000*PI()*Auslegung!$D$18/1000","v":3.7699111843077517},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L10/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.4307900747066219E-5,1.9534659818967324,{"$f":"Z10*Auslegung!$D$18^Grunddaten!AA10","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,5.1930760516113166,6.3367245860662044E-2,"",-3.0443520403986093,2.7337641534949233,22.163301478631176,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF10+AG10*LOG(P10)+AH10*LOG(AC10)","v":20.834047564286365}]
["QAL-R",1000,"QAL-R1000",1002,1002,{"$f":"Auslegung!$D$18","v":1500},1000,1000,600,1500,500,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250}," -/-",{"$f":"Auslegung!$D$26","v":860},0.15,0.25,2544.6900494077322,4241.1500823462211,{"$f":"(D11-2)/1000*PI()*Auslegung!$D$18/1000","v":4.7123889803846897},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L11/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.7770757531610575E-5,1.8955342979202763,{"$f":"Z11*Auslegung!$D$18^Grunddaten!AA11","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,4.3606805059483689,5.0693796688529628E-2,"",-3.230493757996276,2.4901367595434309,22.936405381962793,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF11+AG11*LOG(P11)+AH11*LOG(AC11)","v":18.74588466954993}]
["QAL-H",null,"QAL-H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z12*Auslegung!$D$18^Grunddaten!AA12","v":0.67205662331948468},525.6312336620249,-0.91095471197027766]
["QAL-H",600,"QAL-H600",602,386,{"$f":"Auslegung!$D$18","v":1500},600,600,600,1500,280,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},193,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,763.40701482231975,1272.3450247038661,{"$f":"(D13-2)/1000*PI()*Auslegung!$D$18/1000/2","v":1.4137166941154069},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L13/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.400682041736658E-5,2.0624834878965728,{"$f":"Z13*Auslegung!$D$18^Grunddaten!AA13","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W13*P13^X13*Y13","v":10.619401159503601},0.16897932229509877,"x",-119.64889478884808,50.326839714156748,-0.13715214300472633,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF13+AG13*LOG(P13)+AH13*LOG(AC13)+AI13*Auslegung!$D$18+Grunddaten!AJ13","v":21.894053214916525}]
["QAL-H",800,"QAL-H800",802,404,{"$f":"Auslegung!$D$18","v":1500},800,800,600,1500,315,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},202,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,1017.876019763093,1696.4600329384882,{"$f":"(D14-2)/1000*PI()*Auslegung!$D$18/1000/2","v":1.8849555921538759},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L14/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.5744337391148711E-5,2.0122058179024798,{"$f":"Z14*Auslegung!$D$18^Grunddaten!AA14","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,8.4985553960015352,0.12673449172132409,"",-120.97128777933965,49.833452384525792,-0.22993174500062774,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF14+AG14*LOG(P14)+AH14*LOG(AC14)+(AI14*Auslegung!$D$18+Grunddaten!AJ14)","v":19.050861744647211},null,"H-800"]
["QAL-H",1000,"QAL-H1000",1002,504,{"$f":"Auslegung!$D$18","v":1500},1000,1000,600,1500,355,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},252,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,1272.3450247038661,2120.5750411731105,{"$f":"(D15-2)/1000*PI()*Auslegung!$D$18/1000/2","v":2.3561944901923448},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L15/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.2578266803164379E-5,1.9988104500976971,{"$f":"Z15*Auslegung!$D$18^Grunddaten!AA15","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,6.2020153701858565,0.10138759337705926,"",-121.52250378631329,48.8718117447442,8.3364547329629557E-2,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF15+AG15*LOG(P15)+AH15*LOG(AC15)+AI15*Auslegung!$D$18+Grunddaten!AJ15","v":15.957467853642715},null,1250,{"$f":"AI15*AM15+AJ15","v":-3.0000642502299897}]
["QAL-V",800,"QAL-V800",404,404,{"$f":"Auslegung!$D$18","v":1500},800,800,600,1500,224,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},169,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,511.4826999309542,852.47116655159039,{"$f":"(D16-2)/1000*PI()*Auslegung!$D$18/1000/2","v":0.94719018505732266},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L16/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.2170013080982432E-4,1.9200375044688898,{"$f":"Z16*Auslegung!$D$18^Grunddaten!AA16","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W16*P16^X16*Y16","v":35.240656781564503},0.25220794372402799,"",-87.86894999014811,44.536048127801337,2.1335006176773876,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF16+AG16*LOG(P16)+AH16*LOG(AC16)+AI16*Auslegung!$D$18+Grunddaten!AJ16","v":40.122280205933421},null,"V-400"]
["QAL-V",1000,"QAL-V1000",504,504,{"$f":"Auslegung!$D$18","v":1500},1000,1000,600,1500,280,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},210,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,638.71720240134084,1064.5286706689014,{"$f":"(D17-2)/1000*PI()*Auslegung!$D$18/1000/2","v":1.182809634076557},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L17/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},1.073777717520527E-4,1.8559291914493852,{"$f":"Z17*Auslegung!$D$18^Grunddaten!AA17","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W17*P17^X17*Y17","v":20.162370497674363},0.20196731748418179,"x",-103.13750474906598,50.557960269507326,-2.0847927294752839,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF17+AG17*LOG(P17)+AH17*LOG(AC17)+AI17*Auslegung!$D$18+Grunddaten!AJ17","v":36.504699159973711}]
["QAL-V",1200,"QAL-V1200",602,602,{"$f":"Auslegung!$D$18","v":1500},1200,1200,600,1500,280,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},251,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,763.40701482231975,1272.3450247038661,{"$f":"(D18-2)/1000*PI()*Auslegung!$D$18/1000/2","v":1.4137166941154069},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L18/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},2.9099381733858184E-5,2.0198271618064325,{"$f":"Z18*Auslegung!$D$18^Grunddaten!AA18","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,16.53747898849813,0.16897932229509877,"x",-99.359166607789959,47.684030225236121,0.40055132671686244,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF18+AG18*LOG(P18)+AH18*LOG(AC18)+AI18*Auslegung!$D$18+Grunddaten!AJ18","v":35.057252358298797}]
["QAL-V",1400,"QAL-V1400",704,704,{"$f":"Auslegung!$D$18","v":1500},1400,1400,600,1500,315,{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$30","v":355},{"$f":"Auslegung!$D$31","v":250},293,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,893.18620734211402,1488.6436789035233,{"$f":"(D19-2)/1000*PI()*Auslegung!$D$18/1000/2","v":1.654048532115026},{"$f":"IF(Auslegung!$D$27=\"rund\",(Auslegung!$D$26/(PI()*(L19/1000)^2/4))/3600,(Auslegung!$D$26/((Auslegung!$D$30/1000)*(Auslegung!$D$31/1000))/3600))","v":2.4135114471825254},3.4419577544237719E-5,1.9803465334115098,{"$f":"Z19*Auslegung!$D$18^Grunddaten!AA19","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,14.980807945998645,0.14442677119239211,"",-98.856462985341096,47.097374856379169,0.49964848307741666,-1.2001156502132525E-2,12.001381377435667,{"$f":"AF19+AG19*LOG(P19)+AH19*LOG(AC19)+AI19*Auslegung!$D$18+Grunddaten!AJ19","v":33.937711610247504}]
["QAL-K",null,"QAL-K",{"$f":"Auslegung!$D$19+33","v":1033},6.5,{"$f":"Auslegung!$D$18+33","v":1533},200,1000,200,1000," -/-"," -/-",null,null," -/-",{"$f":"Auslegung!$D$26","v":860},0.15,0.25,{"$f":"U20*Q20*3600","v":809.99999999999989},1350,{"$f":"(Auslegung!D18/1000)*(Auslegung!D19/1000)","v":1.5},{"$f":"P20/U20/3600","v":0.15925925925925927},39.179899650156401,1.4158734463604945,{"$f":"Z20*Auslegung!$D$18^Grunddaten!AA20","v":0.67205662331948468},525.6312336620249,-0.91095471197027766,null,{"$f":"W20*V20^X20","v":2.9063274174252847},0.15925925925925927,null,40.986016637520599,67.717483585782674,13.549057206814156,null,null,{"$f":"AF20+AG20*LOG(AD20)+AH20*LOG(U20)","v":-10.659575281812614}]
[null,125,"125",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25,null,null,null,null,null,null,{"$f":"Z21*Auslegung!$D$18^Grunddaten!AA21","v":0.67205662331948468},525.6312336620249,-0.91095471197027766]
[null,180,"180",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,250,"250",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,315,"315",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,355,"355",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,300,"300",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,400,"400",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,500,"500",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[null,600,"600",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Auslegung!$D$26","v":860},0.15,0.25]
[]
[null,null,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
[]
["Auswahl:","Zuluft",{"$f":"IF(Auslegung!$D$12=\"QAL-K\",Grunddaten!A20,CONCATENATE(Auslegung!$D$12,Auslegung!$D$19))","v":"QAL-K"},{"$f":"VLOOKUP($C$33,$C$4:$W$30,D31,FALSE)","v":1033},{"$f":"VLOOKUP($C$33,$C$4:$W$30,E31,FALSE)","v":6.5},{"$f":"VLOOKUP($C$33,$C$4:$W$30,F31,FALSE)","v":1533},{"$f":"VLOOKUP($C$33,$C$4:$W$30,G31,FALSE)","v":200},1000,{"$f":"VLOOKUP($C$33,$C$4:$W$30,I31,FALSE)","v":200},1000,{"$f":"VLOOKUP($C$33,$C$4:$AL$29,K31,FALSE)","v":" -/-"},{"$f":"VLOOKUP($C$33,$C$4:$AL$29,L31,FALSE)","v":" -/-"},null,null,{"$f":"VLOOKUP($C$33,$C$4:$AL$29,O31,FALSE)","v":" -/-"},{"$f":"VLOOKUP($C$33,$C$4:$W$30,P31,FALSE)","v":860},{"$f":"VLOOKUP($C$33,$C$4:$W$30,Q31,FALSE)","v":0.15},{"$f":"VLOOKUP($C$33,$C$4:$W$30,R31,FALSE)","v":0.25},{"$f":"VLOOKUP($C$33,$C$4:$W$30,S31,FALSE)","v":809.99999999999989},1350,{"$f":"VLOOKUP($C$33,$C$4:$W$30,U31,FALSE)","v":1.5},{"$f":"VLOOKUP($C$33,$C$4:$AK$29,V31,FALSE)","v":0.15925925925925927},39.179899650156401,1.4158734463604945,0.67205662331948468,525.6312336620249,-0.91095471197027766,0,2.9063274174252847,0.15925925925925927,0,40.986016637520599,67.717483585782674,13.549057206814156,0,0,{"$f":"VLOOKUP($C$33,$C$4:$AK$29,AK31,FALSE)","v":-10.659575281812614},{"$error":"#REF!"}]
[null,"Abluft",{"$f":"CONCATENATE(Auslegung!$D$12,Auslegung!$D$19)","v":"QAL-K1000"},{"$f":"VLOOKUP($C$34,$C$4:$W$30,D31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$W$30,E31,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP($C$34,$C$4:$W$30,K31,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP($C$34,$C$4:$W$30,P31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$W$30,Q31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$W$30,R31,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($C$34,$C$4:$W$30,U31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$W$30,V31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$W$30,W31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$33,$C$4:$X$30,X31,FALSE)","v":1.4158734463604945},{"$f":"VLOOKUP($C$34,$C$4:$Y$30,Y31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$AB$30,Z31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$AB$30,AA31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$34,$C$4:$AB$30,AB31,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP($C$34,$C$4:$AD$30,AD31,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,"Stand:","2020-10-30"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP = K1 * V°^K2 * K3",null,null,"K3 = K4 * h^ K5",null,null,null,null,null,null,"LWA = K1 + K2 * log(V°) + K3 * log(Dp) + K4*h + K5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,402,{"$f":"R39/2","v":201},null,{"$f":"0.15*1*0.6*3600","v":324}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.25*1*0.6*3600","v":540}]
[null,"Änderung am 18.01.18:",null,"Erweiterung der Temperaturbetrachtung in Fußbodennähe, die sich einstellenden lokalen Temperaturen in Fußbodennähe wurden nur bis auf 1,5m an den Durchlass heran ausgegeben. TU"]
[null,"Änderung am 18.06.19:",null,"Anpassung der Akustikberechnungen und Druckverlustberechnungen für QAL-H und QAL-V und QAL-L. QAL-R ist nicht betroffen. TU"]
[null,null,"14.4.20:","Änderung der emco-Logos, Anpassung des Datums"]
[null,null,"30.10.20:","Logoänderung, Datumsänderung"]

{"sheet":"Lw","index":7,"n_rows":100,"n_cols":36,"rows_kept":100,"cut":false,"hidden":true,"merged":[[60,6,60,12],[34,3,37,4],[33,0,37,2],[2,0,6,2],[16,3,19,4],[25,3,28,4],[24,0,28,2],[15,0,19,2],[3,3,6,4],[74,1,74,3],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[99,1,99,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[98,1,98,2]]}
[]
[null,null,null,null,null,null,"Oktavbandkoeffizienten QAL-L, Datenherkunft:\\\\EMCO-WI\\Daten\\daten_EK\\EMCOAIR\\QAL\\AKustikberechnung_QAL-L_600-1000.xlsx"]
["Koeffizienten werden nicht weiter verwendet",null,null,"Frequenz","f",null,125,250,500,1000,2000,4000,8000]
[null,null,null,"Koeffizienten",null,"K1",-108.64174965456081,-13.977933474172257,-19.683135212196603,-59.7617445348844,-86.206725037461197,-3.04796724153239,172.5216534488751,null,"Zeta Konstant auf 3 gesetzt"]
[null,null,null,null,null,"K2",32.290921817243387,-12.413107241277331,-0.60464588692427224,18.551602478188016,17.663098492202089,-49.619783921020954,-133.29514206211726,null,"LW = K1+K2*log(V°)+K3*log(v)+k4*log(zeta)"]
[null,null,null,null,null,"K3",24.339080899351895,71.526125779366936,51.784127634685746,45.682767527063199,71.339734484423019,160.75171154455046,206.29502139273293,null,"Daten kommen A-bewertet raus"]
[null,null,null,null,null,"K4",34.468853432237673,53.336351615771207,31.092085847542869,11.219498461009453,34.372893346449217,139.94564253200889,220.89268637974649,null,"Daten gelten für Bauhöhe 600mm"]
[]
[null,null,null,null,"A-Bewertung",null,-16.100000000000001,-8.6,-3.2,0,1.2,1,-1.1000000000000001]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Terzbandkoeffizienten QAL-L, Datenherkunft:\\\\EMCO-WI\\Daten\\daten_EK\\EMCOAIR\\QAL\\CAP_LWA_QAL-L_131023.xls"]
["Lw =K1+ k2*log(V°)+k3*log(v)",null,null,"Frequenz","f","Hz",100,125,160,200,250,315,400,500,630,800,1000,1250,1600,2000,2500,3150,4000,5000,6300,8000,10000]
[null,null,null,"Koeffizienten",null,"k1",-16.684586735649333,-28.186766073190348,-24.665970816289381,-19.230817611044142,-19.523436856438096,-20.672580139610623,-19.416539411700075,-10.592606414583903,-16.648811874911441,-16.614174399443655,-17.233725926518858,-21.752318460834161,-28.631272598834183,-36.927617893593037,-44.449465732972151,-48.121329926870033,-46.132574856211271,-40.62224698135757,-28.957802001109158,-15.709042723534285,-3.2141600349488724]
[null,null,null,null,null,"k2",87.032765633919865,147.63369270717016,124.84613840262226,83.79381054102906,87.573722052634906,96.917353417537328,96.567202276737433,42.837222295774623,83.287602176812584,69.774353512977711,75.712299151311584,93.463136070012936,114.21478879075721,145.44735370993848,170.05998348531799,175.82926568401095,164.86220656872695,145.67883558911146,107.87818946577507,62.523069789482065,21.959125826194935]
[null,null,null,null,null,"k3",-113.8034256105652,-202.13254751454215,-161.60996999872697,-89.353851333727704,-94.318128709149519,-110.24099568242146,-111.78590892636988,-22.419976363328665,-87.980696649925392,-55.422180229104193,-64.673699039263028,-86.092890782807416,-105.96468504468449,-147.1851521236218,-177.19851926552087,-179.84297051328349,-166.47155734527846,-147.90171939484,-109.9306122470401,-61.802256138289017,-19.925081194298976]
[null,null,null,null,null,"k4",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
[]
[null,null,null,null,null,null,"Terzbandkoeffizienten QAL-H, Datenherkunft:\\\\EMCO-WI\\Daten\\daten_EK\\EMCOAIR\\QAL\\CAP_LWA_QAL-H_131023.xls",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP = K1 * V°^K2 * K3",null,"Stutzen DN 280!"]
["Lw =K1*log(V°)+K2*log(Dp)+k3*log(v)",null,null,"Frequenz","f","Hz",100,125,160,200,250,315,400,500,630,800,1000,1250,1600,2000,2500,3150,4000,5000,6300,8000,10000,null,"Nenngröße","K1","K2","Höhe","K3","K4","K5","K6"]
[null,null,null,"Koeffizienten",null,"k1",-5.5711632811840026,-8.4214889238117294,-8.5861852940622079,-8.1567319567039824,-6.7888588589666972,-5.83783818861024,-4.910605896810158,-5.1343860400818331,-5.8366300963677613,-6.4576102282329293,-8.8259928769579705,-12.248402692507868,-14.820416424585611,-18.757326330009672,-22.842854976392751,-24.658568412984256,-21.986132964664485,-17.45982025080243,-10.268031523657264,-3.0909376771654316,3.8629046431027421,null,400,null,null,750,1.25,-6.4684024708911748E-7,7.0404388107958571E-4,0.99815385547495594]
[null,null,null,null,null,"k2",16.626229500257146,23.413599920476635,25.154742408400537,24.151151569649713,23.578167848927155,22.527771142563051,21.653181095079731,22.82212147668497,24.724102869428837,26.937763967174774,31.531017129756961,37.34006258924363,41.360760942524308,47.081733005105733,52.892666886165394,54.21736607560954,47.809937305763391,38.779793293710455,25.703923558324639,12.45958863597119,0.47668153970312721,null,600,1.400682041736658E-5,2.0624834878965728,1000,1]
[null,null,null,null,null,"k3",8.5307820117090412,11.801836609444374,12.642786527255701,12.159149083957601,11.88666392447802,11.382097278053719,10.962419221024831,11.526636075531483,12.443575872387107,13.51141190416641,15.723625408919959,18.520005273851794,20.454846084194099,23.206994710748894,26.002135614453042,26.636468765124718,23.548462307064796,19.198922062187901,12.902749051932673,6.5251102574744486,0.75638779066170247,null,800,1.5744337391148711E-5,2.0122058179024798,1250,0.8]
[null,null,null,null,null,"b",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,1000,1.2578266803164379E-5,1.9988104500976971,1500,0.65]
[]
[]
[]
[null,null,null,null,null,null,"Terzbandkoeffizienten QAL-V, Datenherkunft:\\\\EMCO-WI\\Daten\\daten_EK\\EMCOAIR\\QAL\\CAP_LWA_QAL-V_131023.xls",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP = K1 * V°^K2 * K3",null,"Stutzen DN280!",null,"K3 = K4 * h^2 + K5 * h + K6"]
["Lw =K1*log(V°)+K2*log(Dp)+k3*log(v)",null,null,"Frequenz","f","Hz",100,125,160,200,250,315,400,500,630,800,1000,1250,1600,2000,2500,3150,4000,5000,6300,8000,10000,null,"Nenngröße","K1","K2","Höhe","K3","K4","K5","K6"]
[null,null,null,"Koeffizienten",null,"k1",-6.0476265077435336,-9.408641304371816,-9.6408280712975092,-11.528418926325072,-9.227627681039678,-10.192266554963556,-7.9682347658960255,-8.0093009485959925,-9.5873776460685818,-11.028950298836637,-13.02814370645226,-16.553522717771063,-21.800683392618076,-23.976949401384449,-23.434971878856622,-21.603668329886069,-18.581598571748387,-14.447789566552578,-8.571570812727467,-3.0003836805903745,2.090828412391708,null,800,1.2170013080982432E-4,1.9200375044688898,750,1.25,-6.4684024708911748E-7,7.0404388107958571E-4,0.99815385547495594]
[null,null,null,null,null,"k2",15.162069007594376,19.986427900803868,20.908172172794064,24.429359352251836,22.917321824862036,24.578919164581489,22.459348326161223,23.034586843573102,26.646155665987063,29.357311448136368,32.696593087705153,37.894305779790976,45.284299895536513,47.411853784212681,45.812221615981564,42.131254725380316,36.861738270550354,29.771904334640325,20.57019761727917,11.473233877103322,3.6296228395722117,null,1000,1.073777717520527E-4,1.8559291914493852,1000,1]
[null,null,null,null,null,"k3",9.0330378766091215,11.803312457152098,12.314371256663414,14.311181896142955,13.387460602510469,14.333012275191605,13.082663784270281,13.396986284393495,15.429132398083528,16.966062192979489,18.869015316511796,21.849422271182355,26.097342120675986,27.349904645374561,26.456808661143764,24.375702551637271,21.378669917493877,17.343318877974269,12.08321955601159,6.8935848794602377,2.4060742517683917,null,1200,2.9099381733858184E-5,2.0198271618064325,1250,0.8]
[null,null,null,null,null,"b",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,1400,3.4419577544237719E-5,1.9803465334115098,1500,0.65]
[]
[null,null,null,null,null,null,100,125,160,200,250,315,400,500,630,800,1000,1250,1600,2000,2500,3150,4000,5000,6300,8000,10000]
[null,null,null,"QAL-L","k1",{"$f":"CONCATENATE(D41,E41)","v":"QAL-Lk1"},-16.684586735649333,-28.186766073190348,-24.665970816289381,-19.230817611044142,-19.523436856438096,-20.672580139610623,-19.416539411700075,-10.592606414583903,-16.648811874911441,-16.614174399443655,-17.233725926518858,-21.752318460834161,-28.631272598834183,-36.927617893593037,-44.449465732972151,-48.121329926870033,-46.132574856211271,-40.62224698135757,-28.957802001109158,-15.709042723534285,-3.2141600349488724]
[null,null,null,"QAL-L","k2",{"$f":"CONCATENATE(D42,E42)","v":"QAL-Lk2"},87.032765633919865,147.63369270717016,124.84613840262226,83.79381054102906,87.573722052634906,96.917353417537328,96.567202276737433,42.837222295774623,83.287602176812584,69.774353512977711,75.712299151311584,93.463136070012936,114.21478879075721,145.44735370993848,170.05998348531799,175.82926568401095,164.86220656872695,145.67883558911146,107.87818946577507,62.523069789482065,21.959125826194935]
[null,null,null,"QAL-L","k3","QAL-Lk3",-113.8034256105652,-202.13254751454215,-161.60996999872697,-89.353851333727704,-94.318128709149519,-110.24099568242146,-111.78590892636988,-22.419976363328665,-87.980696649925392,-55.422180229104193,-64.673699039263028,-86.092890782807416,-105.96468504468449,-147.1851521236218,-177.19851926552087,-179.84297051328349,-166.47155734527846,-147.90171939484,-109.9306122470401,-61.802256138289017,-19.925081194298976]
[null,null,null,"QAL-H","k1","QAL-Hk1",-5.5711632811840026,-8.4214889238117294,-8.5861852940622079,-8.1567319567039824,-6.7888588589666972,-5.83783818861024,-4.910605896810158,-5.1343860400818331,-5.8366300963677613,-6.4576102282329293,-8.8259928769579705,-12.248402692507868,-14.820416424585611,-18.757326330009672,-22.842854976392751,-24.658568412984256,-21.986132964664485,-17.45982025080243,-10.268031523657264,-3.0909376771654316,3.8629046431027421]
[null,null,null,"QAL-H","k2","QAL-Hk2",16.626229500257146,23.413599920476635,25.154742408400537,24.151151569649713,23.578167848927155,22.527771142563051,21.653181095079731,22.82212147668497,24.724102869428837,26.937763967174774,31.531017129756961,37.34006258924363,41.360760942524308,47.081733005105733,52.892666886165394,54.21736607560954,47.809937305763391,38.779793293710455,25.703923558324639,12.45958863597119,0.47668153970312721]
[null,null,null,"QAL-H","k3","QAL-Hk3",8.5307820117090412,11.801836609444374,12.642786527255701,12.159149083957601,11.88666392447802,11.382097278053719,10.962419221024831,11.526636075531483,12.443575872387107,13.51141190416641,15.723625408919959,18.520005273851794,20.454846084194099,23.206994710748894,26.002135614453042,26.636468765124718,23.548462307064796,19.198922062187901,12.902749051932673,6.5251102574744486,0.75638779066170247]
[null,null,null,"QAL-V","k1","QAL-Vk1",-6.0476265077435336,-9.408641304371816,-9.6408280712975092,-11.528418926325072,-9.227627681039678,-10.192266554963556,-7.9682347658960255,-8.0093009485959925,-9.5873776460685818,-11.028950298836637,-13.02814370645226,-16.553522717771063,-21.800683392618076,-23.976949401384449,-23.434971878856622,-21.603668329886069,-18.581598571748387,-14.447789566552578,-8.571570812727467,-3.0003836805903745,2.090828412391708]
[null,null,null,"QAL-V","k2","QAL-Vk2",15.162069007594376,19.986427900803868,20.908172172794064,24.429359352251836,22.917321824862036,24.578919164581489,22.459348326161223,23.034586843573102,26.646155665987063,29.357311448136368,32.696593087705153,37.894305779790976,45.284299895536513,47.411853784212681,45.812221615981564,42.131254725380316,36.861738270550354,29.771904334640325,20.57019761727917,11.473233877103322,3.6296228395722117]
[null,null,null,"QAL-V","k3","QAL-Vk3",9.0330378766091215,11.803312457152098,12.314371256663414,14.311181896142955,13.387460602510469,14.333012275191605,13.082663784270281,13.396986284393495,15.429132398083528,16.966062192979489,18.869015316511796,21.849422271182355,26.097342120675986,27.349904645374561,26.456808661143764,24.375702551637271,21.378669917493877,17.343318877974269,12.08321955601159,6.8935848794602377,2.4060742517683917]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[]
[null,null,"Auswahl:",{"$f":"Auslegung!$D$12","v":"QAL-K"},"k1",{"$f":"CONCATENATE(D52,E52)","v":"QAL-Kk1"},{"$f":"VLOOKUP($F52,$F$41:$AA$49,G$50,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F52,$F$41:$AA$49,H$50,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,{"$f":"Auslegung!$D$12","v":"QAL-K"},"k2",{"$f":"CONCATENATE(D53,E53)","v":"QAL-Kk2"},{"$f":"VLOOKUP($F53,$F$41:$AA$49,G$50,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,{"$f":"Auslegung!$D$12","v":"QAL-K"},"k3","QAL-Kk3",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,"V°=",{"$f":"Auslegung!$D$26","v":860},null,null,{"$f":"G$52*LOG($D$56)+G$53*LOG($D$57)+G$54*LOG($D$58)","v":{"$error":"#N/A"}},{"$f":"H$52*LOG($D$56)+H$53*LOG($D$57)+H$54*LOG($D$58)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"R$52*LOG($D$56)+R$53*LOG($D$57)+R$54*LOG($D$58)","v":{"$error":"#N/A"}},{"$f":"S$52*LOG($D$56)+S$53*LOG($D$57)+S$54*LOG($D$58)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"10*LOG(10^(0.1*G56)+10^(0.1*H56)+10^(0.1*I56)+10^(0.1*J56)+10^(0.1*K56)+10^(0.1*L56)+10^(0.1*M56)+10^(0.1*N56)+10^(0.1*O56)+10^(0.1*P56)+10^(0.1*Q56)+10^(0.1*R56)+10^(0.1*S56)+10^(0.1*T56)+10^(0.1*U56)+10^(0.1*V56)+10^(0.1*W56)+10^(0.1*X56)+10^(0.1*Y56)+10^(0.1*Z56)+10^(0.1*AA56))","v":{"$error":"#N/A"}}]
[null,null,"Dp=",{"$f":"Auslegung!$D$103","v":2.9063274174252847}]
[null,null,"v=",{"$f":"Grunddaten!$V$33","v":0.15925925925925927}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Relativspektren",null,null,null,null,null,null,0]
[null,null,null,null,null,"QAL-L",-3.8096086446000115,-6.1546660625344067,-6.4510247554536191,-4.378405574064721,-5.6354850050474123,-13.254829481673275,-19.235866540313953,0]
[null,null,null,null,null,"QAL-H",-0.92246267129537429,-3.9111547154497863,-5.1107051788804343,-4.0393539865063266,-6.8201396725945429,-14.230737735192147,-19.05855844030566,0]
[null,null,null,null,null,"QAL-V",-3.3988696531812508,-5.5300219926304468,-5.5787324254190738,-4.6559275285219401,-7.1332119808898851,-12.821566826772175,-16.624718010499485]
[null,null,null,null,null,"QAL-K",{"$f":"G62","v":-3.8096086446000115},{"$f":"H62","v":-6.1546660625344067},-6.4510247554536191,-4.378405574064721,-5.6354850050474123,-13.254829481673275,-19.235866540313953]
[null,null,null,null,null,"QAL-R",{"$f":"AVERAGE(G63:G65)","v":-2.710313656358879},{"$f":"AVERAGE(H63:H65)","v":-5.1986142568715463},-5.7134874532510418,-4.3578956963643298,-6.5296122195106134,-13.435711347879199,-18.3063809970397]
[null,null,null,null,null,1,2,3,4,5,6,7,8,"Summe"]
[null,null,null,null,"Auswahl:",{"$f":"Auslegung!$D$12","v":"QAL-K"},{"$f":"VLOOKUP($F$68,$F$62:$M$67,G67,FALSE)","v":-3.8096086446000115},{"$f":"VLOOKUP($F$68,$F$62:$M$67,H67,FALSE)","v":-6.1546660625344067},-6.4510247554536191,-4.378405574064721,-5.6354850050474123,-13.254829481673275,-19.235866540313953,{"$f":"Grunddaten!$AK$33","v":-10.659575281812614}]
[null,null,null,null,"Oktavband, unbewertet:",null,{"$f":"$N$68+G$68","v":-14.469183926412626},{"$f":"$N$68+H$68","v":-16.814241344347021},-17.110600037266234,-15.037980855877336,-16.295060286860028,-23.914404763485891,-29.895441822126568]
[]
[]
[]
[]
[]
[null,"T[s] nach VDI 2081",null,null,null,"Nachhallzeit","Richtungsfaktor","Raumvolumen","äqu. Absorptionsfläche"]
[null,"Raumart",null,"s",null,"t","Q","V","A"]
[null,"Einzelbüro",null,0.5,null,"s",null,"m³","m²Sabine"]
[null,"Großraumbüro",null,0.5,{"$f":"Auslegung!$D$44","v":"Konzertsaal"},{"$f":"VLOOKUP(E78,[1]Lw!$A$126:$C$149,3,FALSE)","v":1.5},4,{"$f":"Auslegung!$D$36*Auslegung!$D$38*Auslegung!$D$39","v":288},{"$f":"0.163*H78/F78","v":31.296000000000003}]
[null,"Werkstätten",null,1.5]
[null,"Ruheraum, Pausenraum",null,1]
[null,"Untersuchungsraum Krankenhaus",null,2]
[null,"Rundfunk-, Fernsehstudio",null,0.5]
[null,"Chemielabor",null,2]
[null,"Wasch- und WC-Raum, Umkleide",null,2]
[null,"Schwimmbad",null,2]
[null,"EDV-Raum",null,1.5]
[null,"Konzertsaal",null,1.5]
[null,"Lesesaal",null,1]
[null,"Museum",null,1.5]
[null,"Küche",null,1.5]
[null,"Theater, Kino",null,1]
[null,"Klassen- Seminarraum",null,1]
[null,"Gaststätte",null,1]
[null,"kein Typ",null,"x"]
[null,"Konferenzraum",null,1]
[null,"Hotelzimmer",null,0.5]
[null,"Hörsaal",null,1]
[null,"Bettenzimmer Krankenhaus",null,1]
[null,"Verkaufsraum",null,1]
[null,"Sporthalle",null,2]

{"sheet":"DR","index":8,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,0,10]]}
["Berechnung des Zugluftrisikos"]
["Achtung: Automatisierte Konstantenauswahl aus den \"-CAP\" Arbeitsblättern"]
["Annahme:","Turbulenzgrad =",40,"%"]
[]
["Konstanten Temperaturverhältnis",null,"K051",{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[null,null,"K052",{"$f":"SUM(#REF!,#REF!,#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
["Temperaturen","Zuluft",{"$f":"Auslegung!$D$32","v":17}]
[null,"Raum",{"$f":"Auslegung!$D$33","v":23}]
[]
["1. Zugluftrisiko im Fußbodenbereich"]
[null,"Lauflänge",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Luftgeschwindigkeit, errechnet",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Luftgeschwindigkeit, gesetzt",{"$f":"IF(C12<0.05,0.05,C12)","v":{"$error":"#REF!"}}]
[null,"lok. Temperaturdifferenz",{"$f":"($C$8-$C$7)*$D$5*(1/C11)^$D$6","v":{"$error":"#REF!"}}]
[null,"Absolute Temperatur",{"$f":"C8-C14","v":{"$error":"#REF!"}}]
[null,"Zugluftrisiko",{"$f":"IF((34-C15)*((C13-0.05)^0.62)*(0.37*C13*$C$3+3.14)>100,100,IF((34-C15)*((C13-0.05)^0.62)*(0.37*C13*$C$3+3.14)<0,0,(34-C15)*((C13-0.05)^0.62)*(0.37*C13*$C$3+3.14)))","v":{"$error":"#REF!"}}]
[]
["2. Zugluftrisiko nach Stoßpunkt"]
[null,"Lauflänge",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Luftgeschwindigkeit, errechnet",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Luftgeschwindigkeit, gesetzt",{"$f":"IF(C20<0.05,0.05,C20)","v":{"$error":"#REF!"}}]
[null,"lok. Temperaturdifferenz",{"$f":"($C$8-$C$7)*$D$5*(1/C19)^$D$6","v":{"$error":"#REF!"}}]
[null,"Absolute Temperatur",{"$f":"C8-C22","v":{"$error":"#REF!"}}]
[null,"Zugluftrisiko",{"$f":"IF((34-C23)*((C21-0.05)^0.62)*(0.37*C21*$C$3+3.14)>100,100,IF((34-C23)*((C21-0.05)^0.62)*(0.37*C21*$C$3+3.14)<0,0,(34-C23)*((C21-0.05)^0.62)*(0.37*C21*$C$3+3.14)))","v":{"$error":"#REF!"}}]
[]
["3. Zugluftrisiko nach Ablösen an X_kritisch"]
[null,"Lauflänge",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Luftgeschwindigkeit, errechnet",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Luftgeschwindigkeit, gesetzt",{"$f":"IF(C28<0.05,0.05,C28)","v":{"$error":"#REF!"}}]
[null,"lok. Temperaturdifferenz",{"$f":"($C$8-$C$7)*$D$5*(1/C27)^$D$6","v":{"$error":"#REF!"}}]
[null,"Absolute Temperatur",{"$f":"C8-C30","v":{"$error":"#REF!"}}]
[null,"Zugluftrisiko",{"$f":"IF((34-C31)*((C29-0.05)^0.62)*(0.37*C29*$C$3+3.14)>100,100,IF((34-C31)*((C29-0.05)^0.62)*(0.37*C29*$C$3+3.14)<0,0,(34-C31)*((C29-0.05)^0.62)*(0.37*C29*$C$3+3.14)))","v":{"$error":"#REF!"}}]

{"sheet":"Berechnung-R","index":9,"n_rows":103,"n_cols":24,"rows_kept":103,"cut":false,"hidden":true,"merged":[[49,0,49,1],[5,16,5,17],[5,19,5,20],[5,22,5,23],[7,3,7,5],[7,6,7,7],[7,9,7,10],[13,16,13,17],[13,19,13,20]]}
["Raumdaten",null,null,"Austrittsgeschwindigkeit",null,{"$f":"B16","v":0.18146736870007965},"m/s","Nahbereich:",{"$f":"IF(MIN(O10:O102)-B35<0.5,\"<0,5\",MIN(O10:O102)-B35)","v":1.3},"m"]
["Länge",6,"m","Raumtemperatur 1,1m",null,{"$f":"B12","v":23},"°C","Temperatur:",{"$f":"IF($F$2-AVERAGE(P10:P103)<B11,B11,$F$2-AVERAGE(P10:P103))","v":19.338030954665143},"°C in Fußbodennähe"]
["Breite",12,"m","Temperaturdifferenz",null,{"$f":"B12-B11","v":6},"K"]
["Höhe",3,"m","UK-Aufenthlatsbereich",null,0.1,"m"]
["spez.Kühllast",{"$f":"Auslegung!$D$97","v":35},"W/m²","Maximalgeschwindigkeit",null,{"$f":"Auslegung!$D$41","v":0.2},"m/s"]
[null,null,null,"Höhenoffset:",null,0.06,"m",null,null,null,null,null,null,null,null,null,"Geschwindigkeit",null,null,"Strahldicke",null,null,"Temperaturverhältnis"]
["Durchlass","Halbrund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k1",1.4661974959865125,null,"k1",2.2372640239819456E-4,null,"k1",17.209842409295018]
["Höhe",{"$f":"Auslegung!$D$18","v":1500},"mm","Vorgaben",null,null,"Zwischenergebnisse",null,null,"Vorgabe",null,null,null,null,"Länge Nahzone","Lokale Temperatur","k2",0.47657698545355603,null,"k2",8.287057573268175,null,"k2",-1.2138402474170331E-2]
["Durchmesser",{"$f":"Auslegung!$D$19","v":1000},"mm","vaus","X","DT","vrech(5cm)","Delta","v(Delta)","vmax","h","m","vBoden","v an h","über Geradengleichung",null,"k3",-1.5548372249595821,null,"k3",4.4713610032872853E-8,null,"k3",-18.825125987329905]
["Volumenstrom",{"$f":"Auslegung!$D$26","v":860},"m³/h",{"$f":"$F$1","v":0.18146736870007965},1.99999999999999E-2,{"$f":"$F$3","v":6},{"$f":"($R$7*D10*(1/E10)^$R$8+$R$9*F10^$R$10+$R$11)*$B$31","v":2.0368694501611238},{"$f":"($U$7*D10*E10^$U$8+$U$9*F10^$U$10+$U$11)","v":0.16558507823257826},{"$f":"G10/2","v":1.0184347250805619},{"$f":"$F$5","v":0.2},{"$f":"$F$4","v":0.1},{"$f":"I10/(H10-0.05)","v":8.8111263205730204},{"$f":"G10+0.05*L10","v":2.4774257661897749},{"$f":"M10-(K10+$F$6)*L10","v":1.0676455548980917},{"$f":"IF(AND(N10<J10,N9>J9),E10,\"\")","v":""},{"$f":"IF(O10<>\"\",F10*($X$7*E10^$X$8+$X$9+$X$10*K10^$X$11)*$B$32,\"\")","v":""},"k4",-5.0663890153856202E-2,null,"k4",0,null,"k4",2.1554792961749625]
["Zulufttemperatur",{"$f":"Auslegung!$D$32","v":17},"°C",0.18146736870007965,2.9999999999999898E-2,6,1.6931719452699805,{"$f":"($U$7*D11*E11^$U$8+$U$9*F11^$U$10+$U$11)","v":0.16558507823257826},0.84658597263499025,0.2,{"$f":"$F$4","v":0.1},{"$f":"I11/(H11-0.05)","v":7.3243535028933833},{"$f":"G11+0.05*L11","v":2.0593896204146498},{"$f":"M11-(K11+$F$6)*L11","v":0.88749305995170835},"","","k5",1.4908586099277945,null,"k5",0.16558503351896822,null,"k5",-2.2611097410998076E-2]
["Raumtemperatur in 1,1m Höhe",{"$f":"Auslegung!$D$33","v":23},"°C",0.18146736870007965,0.04,6,1.4866014355287318,0.16558507823257837,0.7433007177643659,0.2,0.1,6.4307670949420359,1.8081397902758336,0.77921705508510786,"",""]
[null,null,null,0.18146736870007965,0.05,6,1.3447804838001365,0.16558507823257892,0.67239024190006824,0.2,0.1,5.8172754838396408,1.6356442579921184,0.70488018057777591,"",""]
["Zwischenergebnisse",null,null,0.18146736870007965,0.06,6,1.2395926436888109,0.16558507823258128,0.61979632184440547,0.2,0.1,5.3622520425798044,1.5077052458178013,0.64974491900503262,"","","Höhe-Geschw.",null,null,"Höhe-Temp."]
["Mantelfläche",{"$f":"Grunddaten!$U$33","v":1.5},"m²",0.18146736870007965,7.0000000000000007E-2,6,1.1575171735776437,0.16558507823258917,0.57875858678882186,0.2,0.1,5.0072085050995891,1.4078775988326231,0.60672423801668884,"","","K1",8.9472212485381666E-8,null,"K1",2.7193604400785383E-7]
["Austrittsgeschwindigkeit",{"$f":"B10/B15/3600*B31","v":0.18146736870007965},"m/s",0.18146736870007965,0.08,6,1.0911343880575903,0.16558507823261123,0.54556719402879517,0.2,0.1,4.7200486634689893,1.3271368212310399,0.57192903507600157,"","","K2",-3.9310759210066872E-5,null,"K2",-1.5442148811552488E-4]
["Kühlleistung / Durchlass",{"$f":"1.2*1.006*(B12-B11)*B10/3.6","v":1730.32},"W",0.18146736870007965,0.09,6,1.0359862695076631,0.1655850782326658,0.51799313475383157,0.2,0.1,4.4814879452790839,1.2600606667716174,0.54302259552696397,"","","K3",0.99709992930488678,null,"K3",0.99709931223169013]
["spez. Kühlleistung / Durchlass",{"$f":"B17/(B2*B3)","v":24.03222222222222},"W/m²",{"$f":"$F$1","v":0.18146736870007965},0.1,{"$f":"$F$3","v":6},0.9892103954607766,0.1655850782327879,{"$f":"G18/2","v":0.4946051977303883},{"$f":"$F$5","v":0.2},0.1,4.2791440321929395,1.2031675970704236,0.51850455191955336,"",""]
["Kühllast Raum",{"$f":"B2*B3*B5","v":2520},"W",{"$f":"$F$1","v":0.18146736870007965},0.2,{"$f":"$F$3","v":6},0.73366900605517982,0.16558507829805863,{"$f":"G19/2","v":0.36683450302758991},{"$f":"$F$5","v":0.2},0.1,3.1737185147864477,0.8923549317945022,0.38455996942867054,"",""]
["Leistungsasymmetrie",{"$f":"B19-B17","v":789.68000000000006},"W",0.18146736870007965,0.3,6,0.6189595041693764,0.16558508011791753,0.3094797520846882,0.2,0.1,2.677506056741608,0.75283480700645677,0.32443383792779951,"",""]
[null,null,null,0.18146736870007965,0.4,6,0.5500163202954641,0.16558509868590793,0.27500816014773205,0.2,0.1,{"$f":"I21/(H21-0.05)","v":2.3792700207406656},0.66897982133249734,0.28829661801399081,"",{"$f":"IF(O21<>\"\",F21*($X$7*E21^$X$8+$X$9+$X$10*K21^$X$11)*$B$32,\"\")","v":""}]
["Temperaturberechnung",null,null,0.18146736870007965,0.5,6,0.50268338799818046,0.16558520820849093,0.25134169399909023,0.2,0.1,2.1745143508823701,0.61140910554229899,0.26348680940111979,"",{"$f":"IF(O22<>\"\",F22*($X$7*E22^$X$8+$X$9+$X$10*K22^$X$11)*$B$32,\"\")","v":""}]
["Volumenstrom Abluft",{"$f":"B10","v":860},"m³/h",0.18146736870007965,0.6,6,0.46757680569280302,0.16558566713375264,0.23378840284640151,0.2,0.1,2.0226418088314344,0.5687088961343747,0.24508620672134518,{"$f":"IF(AND(N23<J23,N22>J22),E23,\"\")","v":""},{"$f":"IF(O23<>\"\",F23*($X$7*E23^$X$8+$X$9+$X$10*K23^$X$11)*$B$32,\"\")","v":""}]
["Temperatur Abluft",{"$f":"B12+(B20/(1.2*1.006*B23/3.6))","v":25.738268066022471},"°C",0.18146736870007965,0.7,6,0.44018400778326611,0.16558719091549406,0.22009200389163305,0.2,0.1,1.9041210548367993,0.53539006052510607,0.23073069175121819,"",""]
["Temperaturgradient A-Bereich",{"$f":"ROUND((I2-B11)/1.1,1)","v":2.1},"K/m",0.18146736870007965,0.8,6,0.4180286643419186,0.16559146699772784,0.2090143321709593,0.2,0.1,1.8082159315018285,0.50843946091700998,0.2191249118767174,"",""]
["Temperaturgradient oberhalb",{"$f":"ROUND((B4-1.1)/(B24-B12),1)","v":0.7},"K/m",0.18146736870007965,0.9,6,0.3996229060260269,0.16560203413163166,0.19981145301301345,0.2,0.1,1.7284423627485284,0.4860450241634533,0.20949424612368878,"",{"$f":"IF(O26<>\"\",F26*($X$7*E26^$X$8+$X$9+$X$10*K26^$X$11)*$B$32,\"\")","v":""}]
["Differenz",null,null,0.18146736870007965,1,6,0.38401139550926922,0.16562567727413019,0.19200569775463461,0.2,0.1,1.660580091560627,0.46704040008730058,0.20134758543760023,"",""]
["Vorgeschlagener Einsatzfall",{"$f":"IF(B25>B26,\"Wärmequellen unten\",IF(B25<B26,\"Wärmequellen oben\",\"Homogene Lastverteilung\"))","v":"Wärmequellen unten"},null,0.18146736870007965,1.1000000000000001,6,0.37054872692936863,0.16567451978859593,0.18527436346468432,0.2,0.1,1.6016869039377681,0.45063307212625703,0.19436316749621413,1.1000000000000001,5.2516713565131301]
[null,null,null,0.18146736870007965,1.2,6,0.35878096945881965,0.16576902634078777,0.17939048472940983,0.2,0.1,1.5495550960352764,0.43625872426058349,0.18832990889493925,"",""]
["Durchlasskorrekturen",null,null,0.18146736870007965,1.3,6,0.34837825529704164,0.16594216265244649,0.17418912764852082,0.2,0.1,1.502379493909201,0.42349722999250172,0.18311651096702955,"",""]
["Höhenkorrektur Geschwindigkeit",{"$f":"$R$15*B8^2+$R$16*B8+$R$17","v":1.1394462685818953},null,0.18146736870007965,1.4,6,0.33909429201583696,0.1662449920559986,0.16954714600791848,0.2,0.1,1.458532905454049,0.41202093728853939,0.17865567241589153,"",""]
["Höhenkorrektur Temperaturdiff.",{"$f":"$U$15*B8^2+$U$16*B8+$U$17","v":1.377323179076074},null,0.18146736870007965,1.5,6,0.33074094418291883,0.16675402351601473,0.16537047209145941,0.2,0.1,1.416400626816738,0.40156097552375575,0.17493687523307766,"",""]
[null,null,null,0.18146736870007965,1.6,6,0.32317167244960227,0.16758066138669492,0.16158583622480113,0.2,0.1,1.3742552076092143,0.39188443283006297,0.17200359961258868,"",""]
["Nahzonenkorrekturen",null,null,0.18146736870007965,1.7,6,0.31627039781216437,0.16888314360838894,0.15813519890608219,0.2,0.1,1.3301734300280015,0.38277906931356442,0.16995132050908418,"",""]
["Durchmesserdifferenz",{"$f":"(800-B36)/1000","v":-0.2},null,0.18146736870007965,1.8,6,0.30994380765626917,0.17088139226534935,0.15497190382813458,0.2,0.1,1.2820162055045861,0.37404461793149846,0.16892202505076467,"",""]
["Durchmesserkorrektur V-Variante",{"$f":"IF(Auslegung!$D$12=\"QAL-V\",Auslegung!D19,Auslegung!D19)","v":1000},null,0.18146736870007965,1.9,6,0.30411591263161669,0.17387523839229177,0.15205795631580835,0.2,0.1,1.2275088895027326,0.36549135710675335,0.16908993478631612,"",""]
[null,null,null,0.18146736870007965,2,6,0.29872411505837859,0.17826652159405587,0.1493620575291893,0.2,0.1,1.1644664225159047,0.35694743618417385,0.1706328085816291,"",""]
[null,null,null,0.18146736870007965,2.1,6,0.2937163163836623,0.18458560439955518,0.14685815819183115,0.2,0.1,1.0911877154100482,0.3482757021541647,0.17368566768855698,"",""]
[null,null,null,0.18146736870007965,2.2000000000000002,6,0.28904875386564699,0.19352288128020989,0.1445243769328235,0.2,0.1,1.0069779511369918,0.33939765142249656,0.17828117924057788,"",""]
[null,null,null,0.18146736870007965,2.2999999999999998,6,0.28468435862414504,0.20596590289874384,0.14234217931207252,0.2,0.1,0.91264934621308791,0.33031682593479944,0.18429293054070536,"",""]
[null,null,null,0.18146736870007965,2.4,6,0.28059149271565348,0.22304277739342737,0.14029574635782674,0.2,0.1,0.8107575968851477,0.32112937255991086,0.19140815705828723,"",""]
[null,null,null,0.18146736870007965,2.5,6,0.27674296594148973,0.24617255232435653,0.13837148297074486,0.2,0.1,0.70535598039198688,0.31201076496108909,0.19915380809837119,"",""]
[null,null,null,0.18146736870007965,2.6,6,0.27311526195927743,0.27712332329268174,0.13655763097963872,0.2,0.1,0.60124882376639122,0.30317770314759701,0.20697789134497441,"",""]
[null,null,null,0.18146736870007965,2.7,6,0.26968792297359151,0.31807885817283321,0.13484396148679575,0.2,0.1,0.50300110350313587,0.29483797814874829,0.21435780158824655,"",""]
[null,null,null,0.18146736870007965,2.8,6,0.26644305596143991,0.37171456935506686,0.13322152798071996,0.2,0.1,0.41409852294779753,0.2871479821088298,0.22089221843718221,"",""]
[null,null,null,0.18146736870007965,2.9,6,0.26336493303073633,0.44128371036558667,0.13168246651536816,0.2,0.1,0.33653960803104677,0.28019191343228866,0.22634557614732118,"",""]
[null,null,null,0.18146736870007965,3,6,0.26043966540240376,0.53071471769962641,0.13021983270120188,0.2,0.1,0.27088796724249553,0.27398406376452855,0.23064198900572927,"",""]
[null,null,null,0.18146736870007965,3.1,6,0.25765493549754487,0.64472066365570269,0.12882746774877243,0.2,0.1,0.21661844899903057,0.26848585794749641,0.2338269061076515,"",""]
[null,null,null,0.18146736870007965,3.2,6,0.25499977526835454,0.78892183138415028,0.12749988763417727,0.2,0.1,0.17254854602867012,0.26362720256978805,0.23601943520520083,"",""]
["Diagrammanzeige",null,null,0.18146736870007965,3.3,6,0.25246438162132362,0.9699824692480542,0.12623219081066181,0.2,0.1,0.13721151764319753,0.2593249575034835,0.2373711146805719,"",""]
["Temperaturprofil",null,null,0.18146736870007965,3.4,6,0.25003996181003796,1.1957628279287351,0.12501998090501898,0.2,0.1,0.1091150610384395,0.25549571486195993,0.23803730509580961,"",""]
["h","T",null,0.18146736870007965,3.5,6,0.24771860320839947,1.4754876304803404,0.12385930160419974,0.2,0.1,8.6889074977426081E-2,0.25206305695727077,0.2381608049608826,"",""]
[0,{"$f":"B11","v":17},null,0.18146736870007965,3.6,6,{"$f":"($R$7*D53*(1/E53)^$R$8+$R$9*F53^$R$10+$R$11)*$B$31","v":0.24549316304474267},{"$f":"($U$7*D53*E53^$U$8+$U$9*F53^$U$10+$U$11)","v":1.8199321727388935},{"$f":"G53/2","v":0.12274658152237133},0.2,0.1,{"$f":"I53/(H53-0.05)","v":6.935100870697565E-2},{"$f":"G53+0.05*L53","v":0.24896071348009144},{"$f":"M53-(K53+$F$6)*L53","v":0.23786455208697532},{"$f":"IF(AND(N53<J53,N52>J52),E53,\"\")","v":""},{"$f":"IF(O53<>\"\",F53*($X$7*E53^$X$8+$X$9+$X$10*K53^$X$11)*$B$32,\"\")","v":""}]
[0.1,{"$f":"I2","v":19.338030954665143},null,0.18146736870007965,3.7,6,0.243357174577013,2.2416272991110677,0.1216785872885065,0.2,0.1,5.5519744318689487E-2,0.24613316179294747,0.23725000270195715,"",""]
[1.1000000000000001,{"$f":"B12","v":23},null,0.18146736870007965,3.8,6,0.24130476688671648,2.755084546797574,0.12065238344335824,0.2,0.1,4.4602074854256615E-2,0.2435348706294293,0.23639853865274824,"",""]
[{"$f":"B4","v":3},{"$f":"B24","v":25.738268066022471},null,0.18146736870007965,3.9,6,0.23933059601419859,3.3770427999376444,0.1196652980070993,0.2,0.1,3.5967465765496635E-2,0.24112896930247343,0.23537417477999398,"",""]
[null,null,null,0.18146736870007965,4,6,0.23742978558642233,4.1267378439854427,0.11871489279321117,0.2,0.1,2.9120070344566183E-2,0.23888578910365063,0.23422657784852005,"",""]
[1.8,15,null,0.18146736870007965,4.0999999999999996,6,0.23559787542779984,5.0261962598398577,0.11779893771389992,0.2,0.1,2.367248628527583E-2,0.23678149974206364,0.2329939019364195,"",""]
[1.8,31,null,0.18146736870007965,4.2,6,0.23383077691508786,6.100555146837662,0.11691538845754393,0.2,0.1,1.9323084513765659E-2,0.23479693114077613,0.23170523761857362,"",""]
[null,null,null,0.18146736870007965,4.3,6,0.23212473405415079,7.3784092136799346,0.1160623670270754,0.2,0.1,1.583732071217064E-2,0.23291660008975931,0.230382628775812,"",""]
[null,null,null,0.18146736870007965,4.4000000000000004,6,0.23047628943116649,8.8921868266861015,0.11523814471558325,0.2,0.1,1.3032765194215255E-2,0.23112792769087726,0.22904268525980281,"",""]
[null,null,null,0.18146736870007965,4.5,6,0.22888225433249554,10.678556655452345,0.11444112716624777,0.2,0.1,1.0767325317642316E-2,0.22942062059837764,0.22769784854755487,"",""]
[null,null,null,0.18146736870007965,4.5999999999999996,6,0.22733968244283057,12.77886660702581,0.11366984122141528,0.2,0.1,8.9300834654574991E-3,0.22778618661610345,0.22635737326163025,"",""]
[null,null,null,0.18146736870007965,4.7,6,0.22584584662569895,15.239616791086275,0.11292292331284948,0.2,0.1,7.4342180494715348E-3,0.22621755752817252,0.22502808264025706,"",""]
[null,null,null,0.18146736870007965,4.8,6,0.22439821836807788,18.112968310347121,0.11219910918403894,0.2,0.1,6.2115543390378006E-3,0.22470879608502978,0.22371494739078374,"",""]
[null,null,null,0.18146736870007965,4.9000000000000004,6,0.22299444953504619,21.457289722444237,0.11149722476752309,0.2,0.1,5.2083765022633887E-3,0.22325486836015934,0.22242152811979721,"",""]
[null,null,null,0.18146736870007965,5,6,0.22163235613363777,25.337743071965054,0.11081617806681889,0.2,0.1,4.3822091102180601E-3,0.22185146658914867,0.22115031313151379,"",""]
[null,null,null,0.18146736870007965,5.0999999999999996,6,0.22030990382939056,29.8269114439803,0.11015495191469528,0.2,0.1,3.6993410858587954E-3,0.2204948708836835,0.2199029763099461,"",""]
[null,null,null,0.18146736870007965,5.2,6,0.21902519499616346,35.005470043469629,0.10951259749808173,0.2,0.1,3.1329173191461872E-3,0.21918184086212078,0.2186805740910574,"",""]
[null,null,null,0.18146736870007965,5.3,6,0.21777645711089916,40.962902858377113,0.10888822855544958,0.2,0.1,2.6614642557232816E-3,0.21790953032368532,0.2174836960427696,"",""]
[null,null,null,0.18146736870007965,5.4,6,0.21656203233122542,47.798267017685504,0.10828101616561271,0.2,0.1,2.2677475629745147E-3,0.21667541970937415,0.21631258009929824,"",""]
[null,null,null,0.18146736870007965,5.5,6,0.21538036811592029,55.621007009858921,0.10769018405796014,0.2,0.1,1.9378843366803609E-3,0.2154772623327543,0.21516720083888544,"",""]
[null,null,null,0.18146736870007965,5.6,6,0.2142300087670547,64.55182098126761,0.10711500438352735,0.2,0.1,1.6606508584406524E-3,0.21431304130997672,0.21404733717262622,"",""]
[null,null,null,0.18146736870007965,5.7,6,0.21310958778859285,74.723581388763023,0.10655479389429642,0.2,0.1,1.426940986525804E-3,0.21318093483791914,0.212952624280075,"",""]
[null,null,null,0.18146736870007965,5.8,6,0.21201782096985611,86.282312335428742,0.10600891048492805,0.2,{"$f":"$F$4","v":0.1},1.2293409235342289E-3,0.21207928801603282,0.21188259346826735,"",""]
[null,null,null,0.18146736870007965,5.9,6,0.21095350011391897,99.388225973675745,0.10547675005695949,0.2,0.1,1.0617941786569697E-3,0.21100658982285181,0.21083670275426669,"",""]
[null,null,null,0.18146736870007965,6,6,0.20991548734101062,114.21682041527379,0.10495774367050531,0.2,0.1,9.1933666268999075E-4,0.20996145417414511,0.20981436030811471,"",""]
[null,null,null,0.18146736870007965,6.1,6,0.2089027099056002,130.9600416436306,0.1044513549528001,0.2,0.1,7.9788650008333535E-4,0.20894260423060437,0.20881494239059104,"",""]
[null,null,null,0.18146736870007965,6.2,6,0.20791415547327566,149.82751197961059,0.10395707773663783,0.2,0.1,6.9407667654934504E-4,0.20794885930710313,0.20783780703885524,"",""]
[null,null,null,0.18146736870007965,6.3,6,0.20694886780994631,171.0478277084589,0.10347443390497316,0.2,0.1,6.0512133570135703E-4,0.20697912387673137,0.20688230446301914,"",""]
[null,null,null,0.18146736870007965,6.4,6,0.20600594284146898,194.86992853193101,0.10300297142073449,0.2,0.1,5.2870859873995022E-4,0.20603237827140597,0.20594778489560758,"",""]
[null,null,null,0.18146736870007965,6.5,6,0.20508452504663513,221.56454156652865,0.10254226252331756,0.2,0.1,4.6291436127916916E-4,0.2051076707646991,0.20503360446689445,"",""]
[null,null,null,{"$f":"$F$1","v":0.18146736870007965},6.6,{"$f":"$F$3","v":6},0.20418380415067447,251.42570266583073,0.10209190207533723,{"$f":"$F$5","v":0.2},0.1,4.0613273674685387E-4,0.2042041107875118,0.20413912954963231,"",""]
[null,null,null,0.18146736870007965,6.7,6,0.20330301209010967,284.7723579022242,0.10165150604505484,0.2,0.1,3.5701975353815638E-4,0.20332086307778657,0.20326373991722047,"",""]
[null,null,null,0.18146736870007965,6.8,6,0.20244142022301648,321.95004810094355,0.10122071011150824,0.2,0.1,3.1444763897570707E-4,0.20245714260496525,0.20240683098272913,"",""]
[null,null,null,0.18146736870007965,6.9,6,0.20159833676156116,363.33267937719131,0.10079916838078058,0.2,0.1,2.77467586821342E-4,0.20161221014090222,0.20156781532701082,"",""]
[null,null,null,0.18146736870007965,7,6,0.20077310440617777,409.32438268519257,0.10038655220308888,0.2,0.1,2.4527934424936788E-4,0.20078536837339023,0.20074612367831032,"",""]
[null,null,null,0.18146736870007965,7.1,6,0.19996509816291619,460.36146544641429,9.9982549081458094E-2,0.2,0.1,2.1720629744578294E-4,0.19997595847778848,0.19994120547019717,7.1,2.072266734156583]
[null,null,null,0.18146736870007965,7.2,6,0.19917372332742642,516.91445838277366,9.9586861663713208E-2,0.2,0.1,1.9267500414966101E-4,0.1991833570776339,0.19915252907696995,"",""]
[null,null,null,0.18146736870007965,7.3,6,0.19839841362074145,579.49026073953598,9.9199206810370727E-2,0.2,0.1,1.7119833317029678E-4,0.19840697353739997,0.19837958180409274,"",""]
[null,null,null,0.18146736870007965,7.4,6,0.1976386294635214,648.63438714165568,9.8819314731760699E-2,0.2,0.1,1.5236153797543975E-4,0.19764624754042018,0.19762186969434412,"",""]
[null,null,null,0.18146736870007965,7.5,6,0.1968938563767639,724.93331938668575,9.8446928188381952E-2,0.2,0.1,1.3581072367850402E-4,0.19690064691294784,0.19687891719715928,"",""]
[null,null,null,0.18146736870007965,7.6,6,0.19616360349816359,809.01696653696149,9.8081801749081793E-2,0.2,0.1,1.2124327173574455E-4,0.19616966566175037,0.19615026673827266,"",""]
[null,null,null,0.18146736870007965,7.7,6,0.19544740220435886,901.56123673354432,9.7723701102179428E-2,0.2,0.1,1.0839987026258574E-4,0.19545282219787199,0.19543547821862997,"",""]
[null,null,null,0.18146736870007965,7.8,6,0.19474480483024584,1003.2907242144621,9.7372402415122919E-2,0.2,0.1,9.7057864642970451E-5,0.19474965772347799,0.1947341284651351,"",""]
[null,null,null,0.18146736870007965,7.9,6,0.19405538347737197,1114.9815150801273,9.7027691738685987E-2,0.2,0.1,8.7025696579859293E-5,0.19405973476220095,0.19404581065074816,"",""]
[null,null,null,0.18146736870007965,8,6,0.19337872890417679,1237.4641154091937,9.6689364452088394E-2,0.2,0.1,7.8138242685323433E-5,0.19338263581631104,0.19337013369748141,"",""]
[null,null,null,0.18146736870007965,8.1,6,0.19271444949151195,1371.6265053890013,9.6357224745755976E-2,0.2,0.1,7.0252898301453125E-5,0.19271796213642703,0.19270672167269878,"",""]
[null,null,null,0.18146736870007965,8.1999999999999993,6,0.19206217027747413,1518.417323185558,9.6031085138737066E-2,0.2,0.1,6.3246280180254645E-5,0.19206533259148315,0.19205521318665431,"",""]
[null,null,null,0.18146736870007965,8.3000000000000007,6,0.19142153205613005,1678.8491823393449,9.5710766028065025E-2,0.2,0.1,5.7011444272146707E-5,0.19142438262834366,0.19141526079726012,"",""]
[null,null,null,0.18146736870007965,8.4,6,0.19079219053518495,1854.0021265345179,9.5396095267592476E-2,0.2,0.1,5.1455533237479388E-5,0.19079476331184683,0.19078653042652882,"",""]
[null,null,null,0.18146736870007965,8.5,6,0.19017381554809429,2045.0272256508172,9.5086907774047144E-2,0.2,0.1,4.6497783242444466E-5,0.19017614043725642,0.19016870079193762,"",""]
[null,null,null,0.18146736870007965,8.6,6,0.18956609031650382,2253.1503170691171,9.4783045158251908E-2,0.2,0.1,4.2067831796121621E-5,0.18956819370809364,0.18956146285500625,{"$f":"IF(SUM(O10:O52)=0,8.6,\"\")","v":""},{"$f":"IF(O103<>\"\",F53*($X$7*E53^$X$8+$X$9+$X$10*K53^$X$11)*$B$32,\"\")","v":""}]

{"sheet":"Berechnung-L","index":10,"n_rows":63,"n_cols":24,"rows_kept":63,"cut":false,"hidden":true,"merged":[[54,8,54,13],[53,8,53,13],[5,16,5,17],[5,19,5,20],[5,22,5,23],[7,3,7,5],[7,6,7,7],[7,9,7,10],[13,16,13,17],[13,19,13,20]]}
["Raumdaten",null,null,"Austrittsgeschwindigkeit",null,{"$f":"B16","v":0.1633206318300717},"m/s","Nahbereich:",{"$f":"ROUND($M$56,1)","v":2.2000000000000002},"m"]
["Länge",6,"m","Raumtemperatur 1,1m",null,{"$f":"B12","v":23},"°C","Temperatur:",{"$f":"IF($F$2-AVERAGE(P10:P53)<B11,B11,$F$2-AVERAGE(P10:P53))","v":18.775471960466291},"°C in Fußbodennähe"]
["Breite",12,"m","Temperaturdifferenz",null,{"$f":"B12-B11","v":6},"K"]
["Höhe",3,"m","UK-Aufenthlatsbereich",null,0.1,"m"]
["spez.Kühllast",{"$f":"Auslegung!$D$97","v":35},"W/m²","Maximalgeschwindigkeit",null,{"$f":"Auslegung!$D$41","v":0.2},"m/s"]
[null,null,null,"Höhenoffset:",null,0.09,"m",null,null,null,null,null,null,null,null,null,"Geschwindigkeit",null,null,"Strahldicke",null,null,"Temperaturverhältnis"]
["Durchlass","Linear",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"k1",2.2222786453937475,null,"k1",1.2514335551866069,null,"k1",17.209842409295018]
["Höhe",{"$f":"Auslegung!$D$18/1000","v":1.5},"m","Vorgaben",null,null,"Zwischenergebnisse",null,null,"Vorgabe",null,null,null,null,"Länge Nahzone","Lokale Temperatur","k2",0.74330776585525316,null,"k2",-1.6855895300119479,null,"k2",-1.2138402474170331E-2]
["Durchmesser",{"$f":"Auslegung!$D$19/1000","v":1},"m","vaus","X","DT","vrech(5cm)","Delta","v(Delta)","vmax","h","m","vBoden","v an h","über Geradengleichung",null,"k3",-17.426297604512321,null,"k3",-1.2937957573291553E-2,null,"k3",-18.825125987329905]
["Volumenstrom",{"$f":"Auslegung!$D$26","v":860},"m³/h",{"$f":"$F$1","v":0.1633206318300717},0.5,{"$f":"$F$3","v":6},{"$f":"($R$7*D10*(1/E10)^$R$8+$R$9*F10^$R$10+$R$12*$B$8+$R$11)*$B$31","v":0.77077447458354331},{"$f":"($U$7*D10*E10^$U$8+$U$9*F10^$U$10+$U$11)","v":0.79469571435197295},{"$f":"G10/2","v":0.38538723729177166},{"$f":"$F$5","v":0.2},{"$f":"$F$4","v":0.1},{"$f":"I10/(H10-0.05)","v":0.51750967524652935},{"$f":"G10+0.05*L10","v":0.79664995834586982},{"$f":"M10-(K10+$F$6)*L10","v":0.69832312004902919},{"$f":"IF(AND(N10<J10,N9>J9),E10,\"\")","v":""},{"$f":"IF(O10<>\"\",F10*($X$7*E10^$X$8+$X$9+$X$10*K10^$X$11)*$B$32,\"\")","v":""},"k4",4.5641843250907241E-3,null,"k4",0,null,"k4",2.1554792961749625]
["Zulufttemperatur",{"$f":"Auslegung!$D$32","v":17},"°C",0.1633206318300717,0.6,6,{"$f":"($R$7*D11*(1/E11)^$R$8+$R$9*F11^$R$10+$R$12*$B$8+$R$11)*$B$31","v":0.69180762297264797},{"$f":"($U$7*D11*E11^$U$8+$U$9*F11^$U$10+$U$11)","v":0.62074514246769685},0.34590381148632399,0.2,{"$f":"$F$4","v":0.1},{"$f":"I11/(H11-0.05)","v":0.60605651410498262},{"$f":"G11+0.05*L11","v":0.72211044867789709},{"$f":"M11-(K11+$F$6)*L11","v":0.60695971099795043},"","","k5",17.481078543643605,null,"k5",0.15018499456645726,null,"k5",-2.2611097410998076E-2]
["Raumtemperatur in 1,1m Höhe",{"$f":"Auslegung!$D$33","v":23},"°C",0.1633206318300717,0.7,6,0.63290312589417919,0.51011062038163746,0.31645156294708959,0.2,0.1,0.68777278534585817,0.66729176516147204,0.53661493594575904,"","","k6",0.15489990663328118]
[null,null,null,0.1633206318300717,0.8,6,0.58705800467585401,0.43496110043826386,0.293529002337927,0.2,0.1,0.762490033418325,0.62518250634677031,0.48030939999728856,"",""]
["Zwischenergebnisse",null,null,0.1633206318300717,0.9,6,0.55022908662041259,0.38135232867906865,0.27511454331020629,0.2,0.1,0.83027798358003546,0.59174298579941431,0.43399016891920761,"","","Höhe-Geschw.",null,null,"Höhe-Temp."]
["Mantelfläche",{"$f":"Grunddaten!$U$33","v":1.5},"m²",0.1633206318300717,1,6,0.5199083735314155,0.34163195591959528,0.25995418676570775,0.2,0.1,0.89137757879105239,0.56447725247096814,0.39511551250066818,"","","K1",8.9472212485381666E-8,null,"K1",2.7193604400785383E-7]
["Austrittsgeschwindigkeit",{"$f":"B10/B15/3600*B31","v":0.1633206318300717},"m/s",0.1633206318300717,1.1000000000000001,6,0.49445232741821837,0.31129853696392362,0.24722616370910919,0.2,0.1,0.94614446212242909,0.54175955052433977,0.36199210272107823,"","","K2",-3.9310759210066872E-5,null,"K2",-1.5442148811552488E-4]
["Kühlleistung / Durchlass",{"$f":"1.2*1.006*(B12-B11)*B10/3.6","v":1730.32},"W",0.1633206318300717,1.2,6,0.47273609115286391,0.2875549233600323,0.23636804557643196,0.2,0.1,0.99500377526673467,0.52248627991620067,0.3334355626155211,"","","K3",0.99709992930488678,null,"K3",0.99709931223169013]
["spez. Kühlleistung / Durchlass",{"$f":"B17/(B2*B3)","v":24.03222222222222},"W/m²",{"$f":"$F$1","v":0.1633206318300717},1.3,{"$f":"$F$3","v":6},0.45396217333573813,0.26858404713102579,{"$f":"G18/2","v":0.22698108666786906},{"$f":"$F$5","v":0.2},0.1,1.0384156101374125,0.50588295384260873,0.30858398791650032,"",""]
["Kühllast Raum",{"$f":"B2*B3*B5","v":2520},"W",{"$f":"$F$1","v":0.1633206318300717},1.4,{"$f":"$F$3","v":6},0.43754842046739412,0.25316132184293183,{"$f":"G19/2","v":0.21877421023369706},{"$f":"$F$5","v":0.2},0.1,1.0768497086410762,0.49139090589944795,0.28678946125764349,"",""]
["Leistungsasymmetrie",{"$f":"B19-B17","v":789.68000000000006},"W",0.1633206318300717,1.5,6,0.4230592890171298,0.24043552870766699,0.2115296445085649,0.2,0.1,1.1107677540217769,0.47859767671821862,0.26755180345408103,"",""]
[null,null,null,0.1633206318300717,1.6,6,{"$f":"($R$7*D21*(1/E21)^$R$8+$R$9*F21^$R$10+$R$12*$B$8+$R$11)*$B$31","v":0.41016200503265143},{"$f":"($U$7*D21*E21^$U$8+$U$9*F21^$U$10+$U$11)","v":0.22979915066526591},0.20508100251632572,0.2,0.1,1.1406116311312688,0.46719258658921486,{"$f":"M21-(K21+$F$6)*L21","v":0.2504763766742738},"",{"$f":"IF(O21<>\"\",F21*($X$7*E21^$X$8+$X$9+$X$10*K21^$X$11)*$B$32,\"\")","v":""}]
["Temperaturberechnung",null,null,0.1633206318300717,1.7,6,0.39859765678056103,0.22080860061927132,0.19929882839028051,0.2,0.1,1.1667962132335086,0.45693746744223646,0.23524618692786983,"",{"$f":"IF(O22<>\"\",F22*($X$7*E22^$X$8+$X$9+$X$10*K22^$X$11)*$B$32,\"\")","v":""}]
["Volumenstrom Abluft",{"$f":"B10","v":860},"m³/h",0.1633206318300717,1.8,6,0.38816158223792718,0.21313347797159526,0.19408079111896359,0.2,0.1,{"$f":"I23/(H23-0.05)","v":1.1897054702208756},{"$f":"G23+0.05*L23","v":0.44764685574897095},0.22160281640700458,{"$f":"IF(AND(N23<J23,N22>J22),E23,\"\")","v":""},{"$f":"IF(O23<>\"\",F23*($X$7*E23^$X$8+$X$9+$X$10*K23^$X$11)*$B$32,\"\")","v":""}]
["Temperatur Abluft",{"$f":"B12+(B20/(1.2*1.006*B23/3.6))","v":25.738268066022471},"°C",0.1633206318300717,1.9,6,0.37868972824370012,0.20652333884672425,0.18934486412185006,0.2,0.1,1.2096909350193861,0.43917427499466943,0.20933299734098607,"",""]
["Temperaturgradient A-Bereich",{"$f":"ROUND((I2-B11)/1.1,1)","v":1.6},"K/m",0.1633206318300717,2,6,0.37004895383023811,0.20078537317536044,0.18502447691511906,0.2,0.1,1.227071784343029,0.43140254304738956,0.19825890402221405,2,4.224528039533709]
["Temperaturgradient oberhalb",{"$f":"ROUND((B4-1.1)/(B24-B12),1)","v":0.7},"K/m",0.1633206318300717,2.1,6,0.36213000284623209,0.19576906633192492,0.18106500142311605,0.2,0.1,1.2421359756179007,0.42423680162712712,0.18823096625972599,"",""]
["Differenz",null,null,0.1633206318300717,2.2000000000000002,6,0.35484232255398701,0.19135544565778961,0.17742116127699351,0.2,0.1,1.2551420318571676,0.41759942414684537,0.17912243809398354,"",""]
["Vorgeschlagener Einsatzfall",{"$f":"IF(B25>B26,\"Wärmequellen unten\",IF(B25<B26,\"Wärmequellen oben\",\"Homogene Lastverteilung\"))","v":"Wärmequellen unten"},null,0.1633206318300717,2.2999999999999998,6,0.34811018374350777,0.18744940396283483,0.17405509187175389,0.2,0.1,1.2663211833120565,0.41142624290911062,0.1708252180798199,"",""]
[null,null,null,0.1633206318300717,2.4,6,0.34186973458306946,0.18397412950555811,0.17093486729153473,0.2,0.1,1.2758796636513565,0.40566371776563731,0.16324658167187958,"",""]
["Durchlasskorrekturen",null,null,0.1633206318300717,2.5,6,0.3360667349685233,0.18086700421622204,0.16803336748426165,0.2,0.1,1.2840010244800311,0.40026678619252487,0.15630659154131896,"",""]
["Höhenkorrektur Geschwindigkeit",{"$f":"($R$15*(B8*1000)^2+$R$16*(B8*1000)+$R$17)*C31","v":1.0255016417237059},0.9,0.1633206318300717,2.6,6,0.33065479395222042,0.17807654215987284,0.16532739697611021,0.2,0.1,1.2908483801017878,0.39519721295730981,0.1499360207379701,"",""]
["Höhenkorrektur Temperaturdiff.",{"$f":"$U$15*(B8*1000)^2+$U$16*(B8*1000)+$U$17","v":1.377323179076074},null,0.1633206318300717,2.7,6,0.32559398397283584,0.17556007607294427,0.16279699198641792,0.2,0.1,1.2965665287733723,0.39042231041150444,0.14407466994456369,"",""]
[null,null,null,0.1633206318300717,2.8,6,0.32084974070010003,0.17328198926747823,0.16042487035005001,0.2,0.1,1.3012839207354523,0.38591393673687263,0.13866999179713668,"",""]
[null,null,null,0.1633206318300717,2.9,6,0.31639198177067784,0.17121235015320616,0.15819599088533892,0.2,0.1,1.305114459750903,0.38164770475822302,0.13367595740555144,"",""]
[null,null,null,0.1633206318300717,3,6,0.31219439499175428,0.16932584746082868,0.15609719749587714,0.2,0.1,1.3081591358244447,0.37760235178297652,0.12905211597633204,"",""]
[null,null,null,0.1633206318300717,3.1,6,0.30823385898810074,0.16760095247398255,0.15411692949405037,0.2,0.1,1.3105074937904644,0.37375923367762398,0.12476280985743574,"",""]
[null,null,null,0.1633206318300717,3.2,6,0.30448996826558411,0.16601925435518836,0.15224498413279205,0.2,0.1,1.3122389467070703,0.37010191560093764,0.12077651572659429,"",""]
[null,null,null,0.1633206318300717,3.3,6,0.3009446412673214,0.16456492868743589,0.1504723206336607,0.2,0.1,1.3134239453348755,0.36661583853406521,0.11706528892043885,"",""]
[null,null,null,0.1633206318300717,3.4,6,0.29758179489735315,0.16322430943319596,0.14879089744867657,0.2,0.1,1.3141250160281652,0.36328804569876139,0.11360429265340999,"",""]
[null,null,null,0.1633206318300717,3.5,6,0.29438707265672015,0.16198554183192457,0.14719353632836008,0.2,0.1,1.3143976795618673,0.36010695663481351,0.11037139751805872,"",""]
[null,null,null,0.1633206318300717,3.6,6,0.29134761631220946,0.16083829912681344,0.14567380815610473,0.2,0.1,1.3142912630717558,0.35706217946579727,0.10734683948216367,"",""]
[null,null,null,0.1633206318300717,3.7,6,0.28845187313518056,0.15977354998919885,0.14422593656759028,0.2,0.1,1.3138496166133042,0.35414435396584576,0.10451292680931795,"",{"$f":"IF(O42<>\"\",F42*($X$7*E42^$X$8+$X$9+$X$10*K42^$X$11)*$B$32,\"\")","v":""}]
[null,null,null,0.1633206318300717,3.8,6,0.28568943237617644,0.15878336648240282,0.14284471618808822,0.2,0.1,1.3131117449945373,0.35134501962590331,0.1018537880769412,"",""]
[null,null,null,0.1633206318300717,3.9,6,0.28305088590301175,0.15786076464847526,0.14152544295150588,0.2,0.1,1.3121123646095578,0.34865650413348964,9.9355154857673655E-2,"",""]
[null,null,null,0.1633206318300717,4,6,0.28052770891517703,0.15699957150504326,0.14026385445758852,0.2,0.1,1.3108823940568528,0.34607182861801966,9.700417374721762E-2,"",""]
[null,null,null,0.1633206318300717,4.0999999999999996,6,{"$f":"($R$7*D46*(1/E46)^$R$8+$R$9*F46^$R$10+$R$12*$B$8+$R$11)*$B$31","v":0.27811215742189077},0.15619431354422608,0.13905607871094539,0.2,0.1,1.3094493864121413,0.34358462674249785,9.4789243324191003E-2,"",""]
[null,null,null,0.1633206318300717,4.2,6,0.27579717978378704,0.15544012283199327,0.13789858989189352,0.2,0.1,1.30783791016271,0.34118907529192255,9.2699872361007657E-2,"",""]
[null,null,null,0.1633206318300717,4.3,6,0.27357634010590154,0.15473265758794308,0.13678817005295077,0.2,0.1,1.3060698850126187,0.33887983435653246,9.0726556204134917E-2,"",""]
[null,null,null,0.1633206318300717,4.4000000000000004,6,0.27144375166024515,0.15406803473641886,0.13572187583012257,0.2,0.1,1.3041648780422908,0.3366519955623597,8.8860668734324438E-2,"",""]
[null,null,null,0.1633206318300717,4.5,6,0.26939401883052916,0.15344277240036092,0.13469700941526458,0.2,0.1,1.3021403650507208,0.33450103708306522,8.7094367723428268E-2,"",""]
["Temperaturprofil",null,null,0.1633206318300717,4.5999999999999996,6,0.26742218632616788,0.15285374068938576,0.13371109316308394,0.2,0.1,1.3000119613236643,0.33242278439235107,8.5420511740854854E-2,"",""]
["h","T",null,0.1633206318300717,4.7,6,0.26552369461967779,0.15229811943593974,0.13276184730983889,0.2,0.1,1.2977936255512097,0.33041337589723829,8.3832587042508455E-2,"",""]
[0,{"$f":"B11","v":17},null,0.1633206318300717,5.7,6,{"$f":"($R$7*D53*(1/E53)^$R$8+$R$9*F53^$R$10+$R$12*$B$8+$R$11)*$B$31","v":0.24978584286546815},{"$f":"($U$7*D53*E53^$U$8+$U$9*F53^$U$10+$U$11)","v":0.14812015507219997},{"$f":"G53/2","v":0.12489292143273407},0.2,0.1,{"$f":"I53/(H53-0.05)","v":1.2728569511619079},{"$f":"G53+0.05*L53","v":0.31342869042356353},{"$f":"M53-(K53+$F$6)*L53","v":7.1585869702801036E-2},{"$f":"IF(SUM(O10:O52)=0,3.6,\"\")","v":""},{"$f":"IF(O53<>\"\",F53*($X$7*E53^$X$8+$X$9+$X$10*K53^$X$11)*$B$32,\"\")","v":""}]
[0.1,{"$f":"I2","v":18.775471960466291},null,null,null,null,null,null,"Achtung! Messwerte unbarauchbar!"]
[1.1000000000000001,{"$f":"B12","v":23},null,null,null,null,null,null,"Nahzonenberechung aus Trox-Auslegungstool verwendet!"]
[{"$f":"B4","v":3},{"$f":"B24","v":25.738268066022471},null,null,null,null,null,null,0.1,"k1",0.44320710747347736,null,{"$f":"$K$56*(B12-B11)^$K$57+$K$58*B16^$K$59+$K$60*B8+$K$63*B9+$K$61*B10+$K$62","v":2.1717836892551401},{"$f":"F10*($X$7*M56^$X$8+$X$9+$X$10*I56^$X$11)*$B$32","v":4.0835374540869722}]
[null,null,null,null,null,null,null,null,null,"k2",0.69776701945321151]
[null,null,null,null,null,null,null,null,null,"k3",4.3889318184182375]
[null,null,null,null,null,null,null,null,null,"k4",1.0635487325351924]
[null,null,null,null,null,null,null,null,null,"k5",-5.5612724047417348E-3]
[null,null,null,null,null,null,null,null,null,"k6",1.7054973104337003E-3]
[null,null,null,null,null,null,null,null,null,"k7",-1.260548223904042]
[null,null,null,null,null,null,null,null,null,"k8",-0.21219192034720322]

{"sheet":"Temperaturprofil","index":11,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[[7,2,7,3]]}
[]
[]
[]
[]
[]
[null,"Dynamisches Diagramm zur Anzeige im Berechnungsblatt \"Auslegung\""]
[]
[null,"Höhendaten","Temperaturen"]
[null,null,"R-Versionen","L-Version"]
[null,0,{"$f":"'Berechnung-R'!$B$53","v":17},{"$f":"'Berechnung-L'!$B$53","v":17},{"$f":"IF(Auslegung!$D$12=\"QAL-L\",Temperaturprofil!D10,Temperaturprofil!C10)","v":17}]
[null,0.1,{"$f":"IF('Berechnung-R'!$I$2<C10,C10,'Berechnung-R'!$I$2)","v":19.338030954665143},{"$f":"IF('Berechnung-L'!$B$54<D10,D10,'Berechnung-L'!$B$54)","v":18.775471960466291},{"$f":"IF(Auslegung!$D$12=\"QAL-L\",Temperaturprofil!D11,Temperaturprofil!C11)","v":19.338030954665143},null,"Temperaturgradient oberhalb von 3m:",null,null,0.3,"K/m"]
[null,1.1000000000000001,{"$f":"Auslegung!$D$33","v":23},{"$f":"C12","v":23},{"$f":"IF(Auslegung!$D$12=\"QAL-L\",Temperaturprofil!D12,Temperaturprofil!C12)","v":23}]
[null,3,{"$f":"'Berechnung-R'!$B$24","v":25.738268066022471},{"$f":"'Berechnung-L'!$B$24","v":25.738268066022471},{"$f":"IF(Auslegung!$D$12=\"QAL-L\",Temperaturprofil!D13,Temperaturprofil!C13)","v":25.738268066022471}]
[null,{"$f":"Auslegung!D36","v":4},null,null,{"$f":"E13+(B14-B13)*J11","v":26.038268066022471}]
[]
[]
[]
[null,{"$f":"Auslegung!$D$37","v":1.8},15]
[null,{"$f":"Auslegung!$D$37","v":1.8},31]