{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Version","Hinweise zum Programm","Auslegung","Funktion","Maße","Datenblatt","Grunddaten","Lw","DR","xkr._vx","Eingabe","SAL35-CAP","SAL50-CAP","SALS-CAP"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":55,"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":"Version","index":0,"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":"Auslegungstool Schlitzluftdurchlass SAL.xlsm"}]
["Version:","1.0"]

{"sheet":"Hinweise zum Programm","index":1,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Hinweise zur Bedienung"]
[]
["Allgemeine Hinweise:"]
["Das Auslegungstool schlitze dient als Hilfsmittel zur Technischen Planung der emcoair SAL-Typen. "]
[]
["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. Hierbei geht die technische Auslegung davon aus, dass zwei parallel verlaufende Schlitzreihen Luftströmungen mit in entgegengesetzter Richtung gerichteten Luftströmungen beaufschlagt sind."]
[]
["Strömungsformen:"]
["Die im Tabellenblatt \"Auslegung\" ermittelten Strömungsgeschwindigkeiten gelten für einen deckenbündig montierten Luftdurchlass mit horizontaler Ausblascharakteristik. "]
[]
["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":"Auslegung","index":2,"n_rows":148,"n_cols":12,"rows_kept":148,"cut":false,"hidden":false,"merged":[[143,3,143,4],[138,3,138,4],[139,3,139,4],[140,3,140,4],[141,3,141,4],[142,3,142,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[130,3,130,4],[137,3,137,4],[132,3,132,4],[131,3,131,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[125,3,125,4],[24,3,24,4],[41,5,41,6],[0,0,0,3],[52,0,52,4],[61,3,61,4],[7,3,7,4],[5,0,5,4],[11,3,11,4],[17,3,17,4],[48,3,48,4],[50,3,50,4],[49,3,49,4],[6,3,6,4],[51,3,51,4],[41,3,41,4],[54,3,54,4],[55,3,55,4],[53,3,53,4],[96,1,96,4],[95,1,95,4],[57,3,57,4],[86,3,86,4],[89,3,89,4],[60,0,60,4],[56,3,56,4],[58,3,58,4],[101,1,101,4],[90,0,90,4],[91,1,91,4],[100,1,100,4],[106,1,106,4],[116,3,116,4],[117,3,117,4],[113,1,113,4],[109,1,109,4],[104,1,104,4]]}
["Auslegung Kampmann Schlitzdurchlässe"]
[]
["Eingabefelder sind gelb gekennzeichnet"]
["Ergebnisfelder sind blau gekennzeichnet"]
[]
["Vorgaben"]
["Strömungstechnik","Symbol","Einheit","Wert"]
["Bezeichung","Symbol","Einheit"]
[null,"L","mm"]
[null,"L","mm"]
[null,"L","mm"]
["Durchlass Typ",null,null,"SAL 35","SAL 35"]
[null,null,null,"SAL 35"]
[null,null,null,"SAL 50"]
[null,null,null,"SAL-S"]
[]
[]
["Anzahl Schlitze","n",1,2,1]
[null,null,null,1]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,{"$f":"IF(D12=\"SAL-S\",\"\",5)","v":5}]
[]
["Schlitzlänge","L","mm",1300,500]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),500,600)","v":500}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),600,750)","v":600}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),700,900)","v":700}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),800,1050)","v":800}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),900,1200)","v":900}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1000,1350)","v":1000}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1100,1500)","v":1100}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1200,1650)","v":1200}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1300,1800)","v":1300}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1400,1950)","v":1400}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1500,\"\")","v":1500}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1600,\"\")","v":1600}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1700,\"\")","v":1700}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1800,\"\")","v":1800}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),1900,\"\")","v":1900}]
[null,null,null,{"$f":"IF(OR($D$12=\"SAL 35\",$D$12=\"SAL-S\"),2000,\"\")","v":2000}]
["Walzenstellung",null,"[-]","A1/F6 hochdiffus",null,161]
[null,null,null,"A1/F6 hochdiffus",1]
[null,null,null,{"$f":"IF(D12<>\"SAL-S\",\"CD\",\"\")","v":"CD"},3]
[null,null,null,{"$f":"IF(D12<>\"SAL-S\",\"A1 oder F6 einseitig\",\"\")","v":"A1 oder F6 einseitig"},4]
[]
[null,null,null,{"$f":"IF(D18>1,\"A1/F6 divergent\",\"\")","v":"A1/F6 divergent"},2]
[null,null,null,{"$f":"IF(D42=\"A1/F6 hochdiffus\",1,IF(D42=\"A1/F6 divergent\",2,IF(D42=\"CD\",3,IF(D42=\"A1 oder F6 einseitig\",4,\"\"))))","v":1}]
["Luftvolumenstrom","V·SUP","m³/h",333]
["max. Luftgeschwindigkeit im Aufenthaltsbereich","vMax","m/s",0.2]
["Temperatur Zuluft","tSUP","°C",20]
["Temperatur Raum","tRaum","°C",20]
["Raumdaten"]
["Raumhöhe","H1","m",4]
["Obergrenze Aufenthaltsbereich","H2","m",1.8,null,null,null,null,1,"Sichtbare Breite, ZS-Profil",{"$f":"Grunddaten!$J$63","v":69},"mm"]
["Raumlänge","LR","m",10,null,null,null,null,2,"Sichtbare Breite, ZB-Profil",{"$f":"Grunddaten!$K$63","v":92},"mm"]
["Raumbreite","BR","m",10,null,null,null,null,3,"Anzahl Anschlussstutzen",{"$f":"Grunddaten!$R$63","v":1},"mm"]
["Abstand Durchlass zur nächstgelegenen Wand*","a","m",1,null,null,null,null,4,"Durchmesser Anschlussstutzen",{"$f":"Grunddaten!$Q$63","v":138},"mm"]
["kleinster Abstand zwischen 2 Durchlässen","smin","m",10,null,null,null,null,5,"Gesamthöhe Durchlass",{"$f":"Grunddaten!$M$63","v":242},"mm"]
["* In Strömungsrichtung gesehen",null,null,null,null,null,null,null,6,"Breite Anschlusskasten",{"$f":"Grunddaten!L63","v":120},"mm"]
["Akustikdaten",null,null,null,null,null,null,null,7,"Minimaler Volumenstrom",{"$f":"Grunddaten!$N$63","v":60},"m³/h"]
["Raumart nach VDI 2081",null,null,"Einzelbüro",null,null,null,null,8,"Maximaler Volumenstrom",{"$f":"Grunddaten!$O$66","v":286},"m³/h"]
[null,null,"Einzelbüro"]
[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",null,null,null,null,null,8,"Maximaler Volumenstrom",{"$f":"Grunddaten!$O$63","v":220},"m³/h"]
["Betrachteter Durchlass",null,null,"Zuluft"]
[null,null,null,"Zuluft"]
[null,null,null,"Abluft"]
["Abstand zur Schallquelle","r","m",2]
["Zusatzdaten"]
["Funktion","",null,null,null,{"$f":"VLOOKUP(B92,Eingabe!$A$45:$B$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$92,$B$93:$G$95,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(B96,Eingabe!A45:B48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"$B$96","v":9010}]
["Farbe Luftlenkelement","schwarz",null,null,null,null,{"$f":"VLOOKUP(B97,B98:G100,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(B101,B102:G105,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(B107,Eingabe!$A$45:$B$51,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B107,B108:G110,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(B110,B111:G114,6,FALSE)","v":"B1"}]
[null,"Baustoffklasse B1 (Standard)",null,null,null,null,"B1"]
[null,"Baustoffklasse A2 (optional)",null,null,null,null,"A2"]
[]
["Merkmalschlüssel",{"$f":"CONCATENATE(1,\"KSW\",\"0\",D18,G114,G92,\"A\",G96,G97,G101,G105,G107,G110,1,G115)","v":"1KSW02SAL 35ZA9010SDV0B11100"},null,null,null,null,{"$f":"IF(D12<1000,CONCATENATE(0,D12),D12)","v":"SAL 35"}]
[null,null,null,null,null,null,{"$f":"IF(K57=78,\"080\",100)","v":100}]
["Berechnung strömungstechnische und Akustische Daten"]
["Druckverlust","Dpt","Pa",{"$f":"IF(D87=\"Zuluft\",Grunddaten!$I$63,\"\")","v":28.037845676598554}]
[{"$f":"IF(D51>D52,\"Vertikale Eindringtiefe\",\"kritischer Strahlweg\")","v":"kritischer Strahlweg"},"xkr. bzw. ymax.","m",{"$f":"IF(D87=\"Zuluft\",IF(D51>D52,xkr._vx!M32,xkr._vx!$F$11),\"\")","v":">Raumlänge"}]
["Laufweg bis Fußbodenbereich","xx","m",{"$f":"xkr._vx!L24","v":5.5}]
["Laufweg bis Aufenthaltsbereich nach Stoßpunkt","xx+y","m",{"$f":"xkr._vx!L26","v":12.2}]
["Laufweg bis Aufenthaltsbereich nach xkrit","xxkr","m",{"$f":"IF(D51>=D52,\"Heizfall\",xkr._vx!L28)","v":"Heizfall"}]
["Geschwindigkeit im Fußbodenbereich in Wandnähe","vx1","m/s",{"$f":"IF(D87=\"Zuluft\",IF(AND(D42=\"CD\",D51>=D52),\"Walzenstellung!\",IF(xkr._vx!$N$24< 0.1,\"< 0,1\",xkr._vx!$N$24)),\"\")","v":0.38825175170851939}]
["Zugluftrisiko am Fußboden**","DR1","%",{"$f":"IF(D87=\"Zuluft\",IF(AND(D42=\"CD\",$D$51>=$D$52),\"Walzenstellung!\",DR!$C$16),\"\")","v":63.528607016025823}]
[{"$f":"IF(AND(D42=\"CD\",D51>D52),CONCATENATE(\"Geschwindigkeit in \",$D$55,\" m Höhe im Wandbereich\"),IF(D42=\"CD\",\"Maximalgeschwindigkeit unterhalb des Druchlasses\",IF(D59=0,\"\",\"Geschwindigkeit im Aufenthaltsbereich*\")))","v":"Geschwindigkeit im Aufenthaltsbereich*"},{"$f":"IF(AND(D42=\"CD\",D51>D52),\"vx2\",IF(D59=0,\"\",\"vx2\"))","v":"vx2"},{"$f":"IF(AND(D42=\"CD\",D51>D52),\"m/s\",IF(D59=0,\"\",IF(D52<=D51,\"m\",\"m/s\")))","v":"m"},{"$f":"IF(AND(D42=\"CD\",D51>D52),xkr._vx!P68,IF(D59=0,\"\",IF(D87=\"Zuluft\",IF(D42=\"CD\",xkr._vx!O31,xkr._vx!P26),\"\")))","v":0.19085724024642897}]
[{"$f":"IF(AND(D42=\"CD\",D51>D52),\"\",IF(D59=0,\"\",\"Zugluftrisiko im Aufenthaltsbereich**\"))","v":"Zugluftrisiko im Aufenthaltsbereich**"},{"$f":"IF(AND(D42=\"CD\",D51>D52),\"\",IF(D59=0,\"\",\"DR2\"))","v":"DR2"},{"$f":"IF(AND(D42=\"CD\",D51>D52),\"\",IF(D59=0,\"\",\"%\"))","v":"%"},{"$f":"IF(AND(D42=\"CD\",D51>D52),\"\",IF(D59=0,\"\",IF(D87=\"Zuluft\",DR!$D$24,\"\")))","v":24.771870125469945}]
["Geschwindigkeit nach Ablösen an Xkr.","vx3","m/s",{"$f":"IF(D87=\"Zuluft\",IF($D$51>$D$52,\"Heizfall\",IF(D42=\"CD\",\"Walzenstellung!\",xkr._vx!O28)),\"\")","v":"<0,1"}]
["Zugluftrisiko nach Ablösepunkt**","DR3","%",{"$f":"IF(D87=\"Zuluft\",IF(D42=\"CD\",\"Walzenstellung!\",IF($D$51>$D$52,\"Heizfall\",DR!$C$32)),\"\")","v":0}]
["Resultierende Raumkategorie","RAL","[-]",{"$f":"IF(D87=\"Zuluft\",IF(D12=\"MPC-V\",\"a. Anf\",IF(MAX(D123,D125,D127)<9.95,\"A\",IF(MAX(D123,D125,D127)<19.95,\"B\",IF(MAX(D123,D125,D127)<29.95,\"C\",\"Außerhalb C\")))),\"\")","v":"Außerhalb C"}]
[{"$f":"CONCATENATE(\"Schallleistungspegel, \",D87,\"durchlass\")","v":"Schallleistungspegel, Zuluftdurchlass"},"LWA_SUP/ETA","dB(A)",{"$f":"IF(D87=\"Zuluft\",IF(Lw!$E$40<25,\"<25\",Lw!$E$40),\"\")","v":41.763069450675353}]
["Schallleistungspegel, Zahlenwert Zuluft + Abluft",null,null,{"$f":"Lw!$E$40","v":41.763069450675353},{"$f":"Lw!$E$40","v":41.763069450675353}]
[{"$f":"CONCATENATE(\"Schallldruckpegel in \",D90,\"m Entfernung, \",D87,\"durchlass\")","v":"Schallldruckpegel in 2m Entfernung, Zuluftdurchlass"},"LPA_SUP/ETA","dB(A)",{"$f":"IF(D87=\"Zuluft\",IF(D129=\"<25\",\"<25\",IF(D129+10*LOG(Lw!$H$7/(4*PI()*Auslegung!D90^2)+4/(Lw!$J$7))>=25,D129+10*LOG(Lw!$H$7/(4*PI()*Auslegung!D90^2)+4/(Lw!$J$7)),\"<25\")),\"\")","v":32.186946748046857}]
["Schalldruckpegel rechnerisch ",null,null,{"$f":"IF(10*LOG(10^(D130/10)+10^(E130/10))<25,\"<25\",10*LOG(10^(D130/10)+10^(E130/10)))","v":44.773369407315172}]
["Summen-Schallldruckpegel im betrachteten Punkt","LPA","dB(A)",{"$f":"IFERROR(IF(E130-D130>6,MAX(E130,D130),D132),IF(E131=\"a. Anf\",D131,IF(AND(D131=\"<25\",E131=\"<25\"),\"<25\",\"a. Anf\")))","v":44.773369407315172}]
["*Gilt für Eintritt der Luftströmung in den Aufenthaltbereich nach dem Stoßpunkt"]
["** Berechnung gemäß DIN EN ISO 7730"]
[]
["Oktavspektrum Schallleistung","LW_Okt","dB"]
[null,"LW_125","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$I$50,\"a. Anf\")),\"\")","v":43.457386298451851}]
[null,"LW_250","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$J$50,\"a. Anf\")),\"\")","v":47.582962699770377}]
[null,"LW_500","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$K$50,\"a. Anf\")),\"\")","v":38.147495730561502}]
[null,"LW_1000","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$L$50,\"a. Anf\")),\"\")","v":33.376631605841197}]
[null,"LW_2000","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$M$50,\"a. Anf\")),\"\")","v":26.305907132405938}]
[null,"LW_4000","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$N$50,\"a. Anf\")),\"\")","v":17.491702818893149}]
[null,"LW_8000","dB",{"$f":"IF($D$87=\"Zuluft\",IF(OR($D$130<25,D12=\"SAL-S\"),\"\",IFERROR(Lw!$O$50,\"a. Anf\")),\"\")","v":10.290718538582636}]
[]
["Änderungen vorbehalten"]
["Stand:",null,null,null,{"$f":"IF(D12=500,KSW(),\"\")","v":""}]
[{"$f":"Grunddaten!C58","v":"2020-10-30"}]

{"sheet":"Funktion","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"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],[32,5,32,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],[29,2,29,3],[30,2,30,3],[31,2,31,3],[5,5,5,6],[33,2,33,3],[33,5,33,6],[9,0,9,8],[18,6,18,7],[26,5,26,6],[27,5,27,6],[31,5,31,6],[35,5,36,6],[35,7,36,7],[35,8,36,8],[34,2,34,3],[34,5,34,6]]}
[]
["Typ",{"$f":"Auslegung!$D$12","v":"SAL 35"},null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-02-02"}]
["Projekt","bitte Projektnummer angeben"]
[]
["Definition:"]
["Durchlass, Typ:",{"$f":"Auslegung!$D$12","v":"SAL 35"},"Länge:",{"$f":"Auslegung!$D$25","v":1300},"mm","Schlitzanzahl:",null,{"$f":"Auslegung!$D$18","v":2}]
["Schlitzanzahl:",{"$f":"Auslegung!D18","v":2},"Farbe Abdeckprofil:",null,{"$f":"Auslegung!B96","v":9010}]
["Innenauskleidung:",{"$f":"Auslegung!G110","v":"B1"},"Drossel fb:",null,{"$f":"Auslegung!B107","v":"ohne"}]
[]
["Beschreibung:\nZu- und Abluftschlitzdurchlass in ein- oder mehrreihiger Ausführung aus Aluminium-Strangpressprofilen mit eingesetzten, exzentrisch gelagerten Luftlenkwalzen und integrierten Gleichrichtern aus Kunststoff (ABS). Die Walzen können zwischen 0 und 360 Grad stufenlos gedreht werden. Somit können sowohl der Austrittsquerschnitt, als auch die Luftstrahlrichtung in jeder gewünschten Weise geregelt und beeinflusst werden."]
["Einsatzbereich"]
["Minimalvolumenstrom","V°min",{"$f":"Auslegung!K$61","v":60},"m³/h"]
["Maximalvolumenstrom","V°max",{"$f":"Auslegung!$K$62","v":286},"m³/h"]
[]
["technische Vorgaben",null,null,null,null,"Raumdaten"]
["Luftvolumenstrom Zuluft","V·SUP",{"$f":"Auslegung!D49","v":333},"m³/h",null,"Raumhöhe",{"$f":"Auslegung!D54","v":4},"m"]
["Temperatur Zuluft","tZUL",{"$f":"Auslegung!D51","v":20},"°C",null,"Raumbreite ",{"$f":"Auslegung!D57","v":10},"m"]
["Temperatur Raum","tRAUM",{"$f":"Auslegung!D52","v":20},"°C",null,"Raumlänge",{"$f":"Auslegung!D56","v":10},"m"]
[{"$f":"Auslegung!A58","v":"Abstand Durchlass zur nächstgelegenen Wand*"},{"$f":"Auslegung!B58","v":"a"},{"$f":"Auslegung!D58","v":1},"m",null,"Nutzungsart",{"$f":"Auslegung!D62","v":"Einzelbüro"}]
[{"$f":"Auslegung!A59","v":"kleinster Abstand zwischen 2 Durchlässen"},"smin",{"$f":"Auslegung!D59","v":10},"m"]
[]
["technische Daten"]
[{"$f":"CONCATENATE(\"Druckverlust \",Auslegung!D87,\"durchlass\")","v":"Druckverlust Zuluftdurchlass"},"Dp_SUP/ETA",{"$f":"IF(Auslegung!$D$117=\"\",Auslegung!$E$117,Auslegung!$D$117)","v":28.037845676598554},null,"Pa"]
["kritischer Strahlweg","xkr.",{"$f":"Auslegung!D118","v":">Raumlänge"},null,"m"]
[{"$f":"Auslegung!A122","v":"Geschwindigkeit im Fußbodenbereich in Wandnähe"},"vx1",{"$f":"Auslegung!D122","v":0.38825175170851939},null,"m/s"]
[{"$f":"Auslegung!A123","v":"Zugluftrisiko am Fußboden**"},"DR1",{"$f":"Auslegung!$D$123","v":63.528607016025823},null,"%"]
[{"$f":"Auslegung!A124","v":"Geschwindigkeit im Aufenthaltsbereich*"},{"$f":"Auslegung!B124","v":"vx2"},{"$f":"Auslegung!$D$124","v":0.19085724024642897},null,{"$f":"Auslegung!C124","v":"m"}]
[{"$f":"Auslegung!A125","v":"Zugluftrisiko im Aufenthaltsbereich**"},{"$f":"Auslegung!B125","v":"DR2"},{"$f":"Auslegung!$D$125","v":24.771870125469945},null,{"$f":"Auslegung!C125","v":"%"}]
[{"$f":"Auslegung!A126","v":"Geschwindigkeit nach Ablösen an Xkr."},"vx3",{"$f":"Auslegung!$D$126","v":"<0,1"},null,"m/s"]
[{"$f":"Auslegung!A127","v":"Zugluftrisiko nach Ablösepunkt**"},"DR3",{"$f":"Auslegung!$D$127","v":0},null,"%"]
["Raumkategorie**","RAL",{"$f":"Auslegung!D128","v":"Außerhalb C"},null,{"$f":"\"-/-\"","v":"-/-"},"Maße"]
[{"$f":"Auslegung!$A$129","v":"Schallleistungspegel, Zuluftdurchlass"},"LWA_SUP/ETA",{"$f":"IF(Auslegung!$D$129=\"\",Auslegung!$E$129,Auslegung!$D$129)","v":41.763069450675353},null,"dB(A)",{"$f":"Auslegung!J55","v":"Sichtbare Breite, ZS-Profil"},null,{"$f":"Auslegung!K55","v":69},"mm"]
[{"$f":"Auslegung!$A$131","v":"Schallldruckpegel in 2m Entfernung, Zuluftdurchlass"},"LPA_SUP",{"$f":"IF(Auslegung!$D$131=\"\",Auslegung!$E$131,Auslegung!$D$131)","v":32.186946748046857},null,"dB(A)",{"$f":"Auslegung!J56","v":"Sichtbare Breite, ZB-Profil"},null,{"$f":"Auslegung!K56","v":92},"mm"]
[null,null,null,null,null,{"$f":"Auslegung!J59","v":"Gesamthöhe Durchlass"},null,{"$f":"Auslegung!K59","v":242},"mm"]
[null,null,null,null,null,{"$f":"Auslegung!J57","v":"Anzahl Anschlussstutzen"},null,{"$f":"Auslegung!K57","v":1},"mm"]
["*Gilt für Eintritt der Luftströmung in den Aufenthaltbereich nach dem Stoßpunkt",null,null,null,null,"Stutzendurchmesser",null,{"$f":"Auslegung!$K$58","v":138},"mm"]
["** Raumkategorie nach DIN EN ISO 7730: DR<10 % = A; DR<20 % = B; DR<30 % = C"]
[]
[]
["Oktavspektrum Schallleistungspegel","f [Hz]",125,250,500,1000,2000,4000,8000]
[{"$f":"Auslegung!D87","v":"Zuluft"},"LWA_Okt",{"$f":"IF(Auslegung!$D$138=\"\",Auslegung!$E$138,Auslegung!$D$138)","v":43.457386298451851},{"$f":"IF(Auslegung!$D$139=\"\",Auslegung!$E$139,Auslegung!$D$139)","v":47.582962699770377},{"$f":"IF(Auslegung!$D$140=\"\",Auslegung!$E$140,Auslegung!$D$140)","v":38.147495730561502},{"$f":"IF(Auslegung!$D$141=\"\",Auslegung!$E$141,Auslegung!$D$141)","v":33.376631605841197},{"$f":"IF(Auslegung!$D$142=\"\",Auslegung!$E$142,Auslegung!$D$142)","v":26.305907132405938},{"$f":"IF(Auslegung!$D$143=\"\",Auslegung!$E$143,Auslegung!$D$143)","v":17.491702818893149},{"$f":"IF(Auslegung!$D$144=\"\",Auslegung!$E$144,Auslegung!$D$144)","v":10.290718538582636}]
[]
[null,null,null,null,null,null,null,null,"technische Änderungen vorbehalten"]
[null,null,null,null,null,null,null,"Stand:",{"$f":"Grunddaten!C58","v":"2020-10-30"}]

{"sheet":"Grunddaten","index":6,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":true,"merged":[[0,6,0,7],[0,13,0,15],[0,16,0,17],[0,19,0,21],[0,22,0,23]]}
["Typ","Walzenstellung*","Schlitzanzahl","Code","Abs. Volumenstrom","spez. Volumenstrom","Konstanten Druckverlust",null,"Druckverlust","Breite mit ZS Profil","Breite mit ZB Profil","Breite AK","Gesamthöhe","Einsatzbereich",null,null,"Stutzen",null,"Zeta-Abluft","Abmessungen",null,null,"Volumenstrom"]
[null,null,"n",null,"V°abs","V°spez","K011","K012","Dptot","bs","bz","bak",null,"V°min","V°max",null,"Durchmesser","Anzahl","z","Höhe AK","Breite","D Stutzen","Minimal","Maximal"]
[null,null,1,null,"m³/h","m³/hm",1,1,"Pa","mm","mm","mm",null,1,1,null,null,null,1,"mm","mm","mm","m³/h","m³/h"]
["SAL 35",1,1,{"$f":"CONCATENATE(A4,B4,C4)","v":"SAL 3511"},{"$f":"Auslegung!$D$49","v":333},{"$f":"E4/(C4*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},{"$f":"G4*F4^H4","v":106.10167320023298},36,61,88,227,50,115,null,123,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",1,2,{"$f":"CONCATENATE(A5,B5,C5)","v":"SAL 3512"},{"$f":"Auslegung!$D$49","v":333},{"$f":"E5/(C5*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},{"$f":"G5*F5^H5","v":28.037845676598554},69,92,120,242,60,220,null,138,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",1,3,"SAL 3513",{"$f":"Auslegung!$D$49","v":333},{"$f":"E6/(C6*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},12.872100551220562,101,126,152,262,90,350,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",1,4,"SAL 3514",{"$f":"Auslegung!$D$49","v":333},{"$f":"E7/(C7*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},7.4091271746601448,134,158,184,302,150,480,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",1,5,"SAL 3515",{"$f":"Auslegung!$D$49","v":333},{"$f":"E8/(C8*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},4.8272503683775048,168,192,218,328,200,550,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",2,1,"SAL 3521",{"$f":"Auslegung!$D$49","v":333},{"$f":"E9/(C9*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},{"$f":"G9*F9^H9","v":106.10167320023298},36,61,88,227,40,110,null,123,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",2,2,"SAL 3522",{"$f":"Auslegung!$D$49","v":333},{"$f":"E10/(C10*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},{"$f":"G10*F10^H10","v":28.037845676598554},69,92,120,242,60,220,null,138,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",2,3,"SAL 3523",{"$f":"Auslegung!$D$49","v":333},{"$f":"E11/(C11*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},12.872100551220562,101,126,152,262,90,350,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",2,4,"SAL 3524",{"$f":"Auslegung!$D$49","v":333},{"$f":"E12/(C12*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},7.4091271746601448,134,158,184,302,150,480,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",2,5,"SAL 3525",{"$f":"Auslegung!$D$49","v":333},{"$f":"E13/(C13*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},4.8272503683775048,168,192,218,328,200,550,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",3,1,"SAL 3531",{"$f":"Auslegung!$D$49","v":333},{"$f":"E14/(C14*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},{"$f":"G14*F14^H14","v":106.10167320023298},36,61,88,227,40,110,null,123,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",3,2,"SAL 3532",{"$f":"Auslegung!$D$49","v":333},{"$f":"E15/(C15*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},28.037845676598554,69,92,120,242,60,220,null,138,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",3,3,"SAL 3533",{"$f":"Auslegung!$D$49","v":333},{"$f":"E16/(C16*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},12.872100551220562,101,126,152,262,90,350,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",3,4,"SAL 3534",{"$f":"Auslegung!$D$49","v":333},{"$f":"E17/(C17*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},7.4091271746601448,134,158,184,302,150,480,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",3,5,"SAL 3535",{"$f":"Auslegung!$D$49","v":333},{"$f":"E18/(C18*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},4.8272503683775048,168,192,218,328,200,550,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",4,1,"SAL 3541",{"$f":"Auslegung!$D$49","v":333},{"$f":"E19/(C19*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},106.10167320023298,36,61,88,227,40,110,null,123,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",4,2,"SAL 3542",{"$f":"Auslegung!$D$49","v":333},{"$f":"E20/(C20*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},{"$f":"G20*F20^H20","v":28.037845676598554},69,92,120,242,60,220,null,138,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",4,3,"SAL 3543",{"$f":"Auslegung!$D$49","v":333},{"$f":"E21/(C21*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},12.872100551220562,101,126,152,262,90,350,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",4,4,"SAL 3544",{"$f":"Auslegung!$D$49","v":333},{"$f":"E22/(C22*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},7.4091271746601448,134,158,184,302,150,480,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 35",4,5,"SAL 3545",{"$f":"Auslegung!$D$49","v":333},{"$f":"E23/(C23*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL35-CAP'!$C$40","v":2.5200000000000001E-3},{"$f":"'SAL35-CAP'!$C$41","v":1.92},4.8272503683775048,168,192,218,328,200,550,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",1,1,"SAL 5011",{"$f":"Auslegung!$D$49","v":333},{"$f":"E24/(C24*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$f":"G24*F9^H24","v":{"$error":"#VALUE!"}},51,75,101,277,80,250,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",1,2,"SAL 5012",{"$f":"Auslegung!$D$49","v":333},{"$f":"E25/(C25*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},97,121,148,317,160,450,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",1,3,"SAL 5013",{"$f":"Auslegung!$D$49","v":333},{"$f":"E26/(C26*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},144,168,194,341,260,650,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",1,4,"SAL 5014",{"$f":"Auslegung!$D$49","v":333},{"$f":"E27/(C27*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},190,215,241,367,280,850,null,248,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",1,5,"SAL 5015",{"$f":"Auslegung!$D$49","v":333},{"$f":"E28/(C28*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},237,262,288,417,420,1000,null,298,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",2,1,"SAL 5021",{"$f":"Auslegung!$D$49","v":333},{"$f":"E29/(C29*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},51,75,101,277,80,250,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",2,2,"SAL 5022",{"$f":"Auslegung!$D$49","v":333},{"$f":"E30/(C30*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},97,121,148,317,160,450,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",2,3,"SAL 5023",{"$f":"Auslegung!$D$49","v":333},{"$f":"E31/(C31*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},144,168,194,341,260,650,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",2,4,"SAL 5024",{"$f":"Auslegung!$D$49","v":333},{"$f":"E32/(C32*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},190,215,241,367,280,850,null,248,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",2,5,"SAL 5025",{"$f":"Auslegung!$D$49","v":333},{"$f":"E33/(C33*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},237,262,288,417,420,1000,null,298,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",3,1,"SAL 5031",{"$f":"Auslegung!$D$49","v":333},{"$f":"E34/(C34*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$f":"G34*F19^H34","v":{"$error":"#VALUE!"}},51,75,101,277,80,250,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",3,2,"SAL 5032",{"$f":"Auslegung!$D$49","v":333},{"$f":"E35/(C35*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},97,121,148,317,160,450,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",3,3,"SAL 5033",{"$f":"Auslegung!$D$49","v":333},{"$f":"E36/(C36*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},144,168,194,341,260,650,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",3,4,"SAL 5034",{"$f":"Auslegung!$D$49","v":333},{"$f":"E37/(C37*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},190,215,241,367,280,850,null,248,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",3,5,"SAL 5035",{"$f":"Auslegung!$D$49","v":333},{"$f":"E38/(C38*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},237,262,288,417,420,1000,null,298,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",4,1,"SAL 5041",{"$f":"Auslegung!$D$49","v":333},{"$f":"E39/(C39*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$error":"#VALUE!"},51,75,101,277,80,250,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",4,2,"SAL 5042",{"$f":"Auslegung!$D$49","v":333},{"$f":"E40/(C40*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$f":"G40*F25^H40","v":{"$error":"#VALUE!"}},97,121,148,317,160,450,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",4,3,"SAL 5043",{"$f":"Auslegung!$D$49","v":333},{"$f":"E41/(C41*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$f":"G41*F26^H41","v":{"$error":"#VALUE!"}},144,168,194,341,260,650,null,222,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",4,4,"SAL 5044",{"$f":"Auslegung!$D$49","v":333},{"$f":"E42/(C42*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$f":"G42*F27^H42","v":{"$error":"#VALUE!"}},190,215,241,367,280,850,null,248,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL 50",4,5,"SAL 5045",{"$f":"Auslegung!$D$49","v":333},{"$f":"E43/(C43*Auslegung!$D$25/1000)","v":51.230769230769234},{"$f":"'SAL50-CAP'!$C$40","v":""},{"$f":"'SAL50-CAP'!$C$41","v":""},{"$f":"G43*F28^H43","v":{"$error":"#VALUE!"}},237,262,288,417,420,1000,null,298,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL-S",1,1,"SAL-S11",{"$f":"Auslegung!$D$49","v":333},{"$f":"E44/(C44*Auslegung!$D$25/1000)","v":256.15384615384613},{"$f":"'SALS-CAP'!$C$40","v":""},{"$f":"'SALS-CAP'!$C$41","v":""},{"$f":"G44*F29^H44","v":{"$error":"#VALUE!"}},35,59,88,215,50,115,null,123,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL-S",1,2,"SAL-S12",{"$f":"Auslegung!$D$49","v":333},{"$f":"E45/(C45*Auslegung!$D$25/1000)","v":128.07692307692307},{"$f":"'SALS-CAP'!$C$40","v":""},{"$f":"'SALS-CAP'!$C$41","v":""},{"$error":"#VALUE!"},67,91,120,230,60,220,null,138,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL-S",1,3,"SAL-S13",{"$f":"Auslegung!$D$49","v":333},{"$f":"E46/(C46*Auslegung!$D$25/1000)","v":85.384615384615387},{"$f":"'SALS-CAP'!$C$40","v":""},{"$f":"'SALS-CAP'!$C$41","v":""},{"$error":"#VALUE!"},100.5,124.5,152,250,90,350,null,158,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
["SAL-S",1,4,"SAL-S14",{"$f":"Auslegung!$D$49","v":333},{"$f":"E47/(C47*Auslegung!$D$25/1000)","v":64.038461538461533},{"$f":"'SALS-CAP'!$C$40","v":""},{"$f":"'SALS-CAP'!$C$41","v":""},{"$error":"#VALUE!"},133,157.5,184,290,150,480,null,198,{"$f":"IF(Auslegung!$D$25<=1500,1,2)","v":1}]
[]
[]
[]
[]
["Spaltenindex",null,1,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Einsatzbereich SAL-S vom SAL35 übernommen, 10.10.17 TU"]
[]
[]
[]
["Stand:",null,"2020-10-30"]
[]
[null,null,"Übergabe:",null,"Volumenstrom für Druckverlustberechnung",null,null,{"$f":"Auslegung!$D$49","v":333}]
[]
[]
["Auswahl:",null,"Zuluft",null,{"$f":"CONCATENATE(Auslegung!$D$12,Auslegung!$D$48,Auslegung!$D$18)","v":"SAL 3512"},{"$f":"VLOOKUP($E$63,$D$4:$R$47,G52,FALSE)","v":128.07692307692307},{"$f":"VLOOKUP($E$63,$D$4:$R$47,H52,FALSE)","v":2.5200000000000001E-3},1.92,28.037845676598554,69,92,120,242,60,220,0,138,1,{"$error":"#REF!"},{"$f":"VLOOKUP($E$63,$D$4:$R$43,T52,FALSE)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Abluft",null,{"$f":"CONCATENATE(Auslegung!$D$12,Auslegung!$D$48,Auslegung!$D$18)","v":"SAL 3512"},{"$f":"VLOOKUP($E$63,$D$4:$R$43,G52,FALSE)","v":128.07692307692307},{"$f":"VLOOKUP($E$63,$D$4:$R$43,H52,FALSE)","v":2.5200000000000001E-3},1.92,28.037845676598554,69,92,120,242,{"$f":"VLOOKUP($E$63,$D$4:$R$43,O52,FALSE)","v":60},{"$f":"VLOOKUP($E$63,$D$4:$R$43,P52,FALSE)","v":220},0,138,1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Einsatzgrenzen, absolut:",null,{"$f":"N63*Auslegung!$D$25/1000","v":78},{"$f":"O63*Auslegung!$D$25/1000","v":286}]
[null,"Walzenstellungen:",null,null,"1= A1/F6 hochdiffus"]
[null,null,null,null,"2= A1/F6 divergent"]
[null,null,null,null,"3=CD"]
[null,null,null,null,"4=einseitig"]

{"sheet":"Lw","index":7,"n_rows":50,"n_cols":25,"rows_kept":50,"cut":false,"hidden":true,"merged":[[43,8,43,14],[44,8,44,14],[28,0,28,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[18,0,18,3],[19,0,19,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[3,0,3,4],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3]]}
[]
[]
[]
["T[s] nach VDI 2081",null,null,null,null,null,"Nachhallzeit","Richtungsfaktor","Raumvolumen","äqu. Absorptionsfläche"]
["Raumart",null,null,null,"s",null,"t","Q","V","A"]
["Einzelbüro",null,null,null,0.5,null,"s",null,"m³","m²Sabine"]
["Großraumbüro",null,null,null,0.5,{"$f":"Auslegung!$D$62","v":"Einzelbüro"},{"$f":"VLOOKUP(F7,$A$6:$E$29,5,FALSE)","v":0.5},4,{"$f":"Auslegung!$D$54*Auslegung!$D$56*Auslegung!$D$57","v":400},{"$f":"0.163*I7/G7","v":130.4}]
["Werkstätten",null,null,null,1.5]
["Ruheraum, Pausenraum",null,null,null,1]
["Untersuchungsraum Krankenhaus",null,null,null,2]
["Rundfunk-, Fernsehstudio",null,null,null,0.5]
["Chemielabor",null,null,null,2]
["Wasch- und WC-Raum, Umkleide",null,null,null,2]
["Schwimmbad",null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*LOG(10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!))","v":{"$error":"#REF!"}}]
["EDV-Raum",null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*LOG(10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!))","v":{"$error":"#REF!"}}]
["Konzertsaal",null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*LOG(10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!))","v":{"$error":"#REF!"}}]
["Lesesaal",null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*LOG(10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!))","v":{"$error":"#REF!"}}]
["Museum",null,null,null,1.5]
["Küche",null,null,null,1.5]
["Theater, Kino",null,null,null,1]
["Klassen- Seminarraum",null,null,null,1]
["Gaststätte",null,null,null,1]
["kein Typ",null,null,null,"x"]
["Konferenzraum",null,null,null,1]
["Hotelzimmer",null,null,null,0.5]
["Hörsaal",null,null,null,1]
["Bettenzimmer Krankenhaus",null,null,null,1]
["Verkaufsraum",null,null,null,1]
["Sporthalle",null,null,null,2]
[]
["Achtung: Automatisierte Konstantenauswahl aus den \"-CAP\" Arbeitsblättern"]
["Konstantenübergabe Summen Schallleistungspegel",null,null,"K021",{"$f":"SUM('SAL35-CAP'!C42,'SAL50-CAP'!C42,'SALS-CAP'!C42)","v":-75.599999999999994}]
[null,null,null,"K022",{"$f":"SUM('SAL35-CAP'!C43,'SAL50-CAP'!C43,'SALS-CAP'!C43)","v":53.72},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"10*LOG(10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!)+10^(0.1*#REF!))","v":{"$error":"#REF!"}}]
["Vorgabedaten:",null,"Schlitzanzahl",null,{"$f":"Auslegung!$D$18","v":2}]
[null,null,"Schlitzlänge",null,{"$f":"Auslegung!$D$25","v":1300}]
[null,null,"abs. Volumenstrom",null,{"$f":"Auslegung!$D$49","v":333}]
[]
[null,null,"spez. Volumenstrom",null,{"$f":"E36/(E34*(E35/1000))","v":128.07692307692307}]
[]
[null,null,"Rückgabe LWA",null,{"$f":"$E$32+$E$33*LOG($E$38)+10*LOG($E$34)+10*LOG(($E$35/1000))","v":41.763069450675353}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Relativspektrum LWOkt [dB(A)]"]
[null,null,null,null,null,null,null,null,"Oktavfrequenzband fm"]
[null,null,null,null,null,null,null,null,125,250,500,1000,2000,4000,8000]
[null,null,null,null,null,null,null,null,-14.405683152223503,-2.7801067509049759,-6.8155737201138535,-8.3864378448341572,-14.257162318269414,-23.271366631782204,-30.372350912092717]
[null,null,null,null,null,"A-bewertete","Oktavband-Schallleistung",null,{"$f":"IF($E$40+I47>0,$E$40+I47,0)","v":27.35738629845185},{"$f":"IF($E$40+J47>0,$E$40+J47,0)","v":38.982962699770376},34.947495730561499,33.376631605841197,27.505907132405937,18.491702818893149,11.390718538582636]
[null,null,null,null,null,"A-Bewertung",null,null,16.100000000000001,8.6,3.2,0,-1.2,-1,-1.1000000000000001]
[null,null,null,null,null,"Unbewertete Oktavband Schallleistung",null,null,{"$f":"IF(I48+I49>0,I48+I49,0)","v":43.457386298451851},{"$f":"IF(J48+J49>0,J48+J49,0)","v":47.582962699770377},38.147495730561502,33.376631605841197,26.305907132405938,17.491702818893149,10.290718538582636]

{"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 =",{"$f":"IF(Auslegung!D12=\"MPC-Q\",20,40)","v":40},"%"]
[]
["Konstanten Temperaturverhältnis",null,"K051",{"$f":"SUM('SAL35-CAP'!$C$51,'SAL50-CAP'!$C$51,'SALS-CAP'!$C$51)","v":9.9320000000000006E-2}]
[null,null,"K052",{"$f":"SUM('SAL35-CAP'!$C$52,'SAL50-CAP'!$C$52,'SALS-CAP'!$C$52)","v":0.5}]
["Temperaturen","Zuluft",{"$f":"Auslegung!$D$51","v":20}]
[null,"Raum",{"$f":"Auslegung!$D$52","v":20}]
[]
["1. Zugluftrisiko im Fußbodenbereich"]
[null,"Lauflänge",{"$f":"xkr._vx!$L$24","v":5.5}]
[null,"Luftgeschwindigkeit, errechnet",{"$f":"xkr._vx!$N$24","v":0.38825175170851939}]
[null,"Luftgeschwindigkeit, gesetzt",{"$f":"IF(C12<0.05,0.05,C12)","v":0.38825175170851939}]
[null,"lok. Temperaturdifferenz",{"$f":"($C$8-$C$7)*$D$5*(1/C11)^$D$6","v":0}]
[null,"Absolute Temperatur",{"$f":"C8-C14","v":20}]
[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":63.528607016025823}]
[]
["2. Zugluftrisiko nach Stoßpunkt"]
[null,"Lauflänge",{"$f":"IF(Auslegung!$D$12=\"MPC-Q\",xkr._vx!$L$31,xkr._vx!$L$26)","v":12.2}]
[null,"Luftgeschwindigkeit, errechnet",{"$f":"IF(Auslegung!$D$42=\"CD\",xkr._vx!$N$31,xkr._vx!$N$26)","v":0.19085724024642897}]
[null,"Luftgeschwindigkeit, gesetzt",{"$f":"IF(C20<0.05,0.05,C20)","v":0.19085724024642897}]
[null,"lok. Temperaturdifferenz",{"$f":"($C$8-$C$7)*$D$5*(1/C19)^$D$6","v":0}]
[null,"Absolute Temperatur",{"$f":"C8-C22","v":20}]
[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":24.771870125469945},{"$f":"IF(C24<C32,C32,C24)","v":24.771870125469945}]
[]
["3. Zugluftrisiko nach Ablösen an X_kritisch"]
[null,"Lauflänge",{"$f":"xkr._vx!$L$28","v":1245.6176075783253}]
[null,"Luftgeschwindigkeit, errechnet",{"$f":"xkr._vx!N28","v":2.5798971887790068E-2}]
[null,"Luftgeschwindigkeit, gesetzt",{"$f":"IF(C28<0.05,0.05,C28)","v":0.05}]
[null,"lok. Temperaturdifferenz",{"$f":"($C$8-$C$7)*$D$5*(1/C27)^$D$6","v":0}]
[null,"Absolute Temperatur",{"$f":"C8-C30","v":20}]
[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":0}]

{"sheet":"xkr._vx","index":9,"n_rows":84,"n_cols":16,"rows_kept":84,"cut":false,"hidden":true,"merged":[[47,9,47,13],[60,9,60,13]]}
["Geschwindigkeit im Strahl und kritischer Strahlweg",null,null,null,null,null,"Annahme:","Winkel nach xkrit",45]
["Achtung: Automatisierte Konstantenauswahl aus den \"-CAP\" Arbeitsblättern"]
["Konstanten","K031",{"$f":"SUM('SAL35-CAP'!C44,'SAL50-CAP'!C44,'SALS-CAP'!C44)","v":5.0270000000000002E-3},null,"Konstanten:","K041",{"$f":"SUM('SAL35-CAP'!C48,'SAL50-CAP'!C48,'SALS-CAP'!C48)","v":8.8200000000000001E-2},null,"Konstanten","K071",{"$f":"SUM('SAL50-CAP'!C53,'SAL35-CAP'!C53,'SALS-CAP'!C53)","v":0}]
[null,"K032",{"$f":"SUM('SAL35-CAP'!C45,'SAL50-CAP'!C45,'SALS-CAP'!C45)","v":5.8},null,null,"K042",{"$f":"SUM('SAL35-CAP'!C49,'SAL50-CAP'!C49,'SALS-CAP'!C49)","v":0.64300000000000002},null,null,"K072",{"$f":"SUM('SAL50-CAP'!C54,'SAL35-CAP'!C54,'SALS-CAP'!C54)","v":0}]
[null,"K033",{"$f":"SUM('SAL35-CAP'!C46,'SAL50-CAP'!C46,'SALS-CAP'!C46)","v":0.5},null,null,"K043",{"$f":"SUM('SAL35-CAP'!C50,'SAL50-CAP'!C50,'SALS-CAP'!C50)","v":1.2869999999999999},null,null,"K081",{"$f":"SUM('SAL50-CAP'!C55,'SAL35-CAP'!C55,'SALS-CAP'!C55)","v":0}]
[null,"K034",{"$f":"SUM('SAL35-CAP'!C47,'SAL50-CAP'!C47,'SALS-CAP'!C47)","v":1},null,null,"Dt0",{"$f":"IF(ABS(Auslegung!$D$52-Auslegung!$D$51)=0,0.01,ABS(Auslegung!$D$52-Auslegung!$D$51))","v":0.01},null,null,"K082",{"$f":"SUM('SAL50-CAP'!C56,'SAL35-CAP'!C56,'SALS-CAP'!C56)","v":0}]
[null,null,null,null,null,null,null,null,null,"K083",{"$f":"SUM('SAL50-CAP'!C57,'SAL35-CAP'!C57,'SALS-CAP'!C57)","v":0}]
[null,"Lauflänge","Geschwindigkeit im Strahl horizontal","Geschwindigkeit im Strahl vertikal",null,"kritischer Strahlweg Anzeige","kritischer Strahlweg","vertikaler Strahlweg",null,"Geschwindigkeit im Strahl an xKr"]
[null,"L","v0","v1",null,"xkr._Anzeige","xkr.","y",null,"v0"]
[null,"m","m/s","m/s",null,"m","m","m",null,"m/s",null,{"$f":"G3*SQRT(3)*138.39^G5*(1/(10^G4))","v":19.798440074042528}]
[null,0.5,{"$f":"$C$3*$G$21*((1/xkr._vx!B11)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":1.2876853846153848},{"$f":"1/B11*$J$11","v":0},null,{"$f":"IF(AND(G22=3,Auslegung!$D$51<=Auslegung!$D$52),\"Walzenstellung!\",IF($G$11<Auslegung!$D$56,$G$11,\">Raumlänge\"))","v":">Raumlänge"},{"$f":"IF(OR(G22=1,G22=2),J27,J27)","v":1242.5063377411045},null,null,null,null,null,null,{"$f":"138.89*4.5","v":625.00499999999988}]
[null,0.6,{"$f":"$C$3*$G$21*((1/xkr._vx!B12)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":1.1754905535392699},{"$f":"1/B12*$J$11","v":0}]
[null,0.7,{"$f":"$C$3*$G$21*((1/xkr._vx!B13)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":1.0882927815594186},0]
[null,0.8,{"$f":"$C$3*$G$21*((1/xkr._vx!B14)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":1.0180046812736396},0]
[null,0.9,{"$f":"$C$3*$G$21*((1/xkr._vx!B15)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.95978401787765399},{"$f":"1/B15*$J$11","v":0}]
[null,1,{"$f":"$C$3*$G$21*((1/xkr._vx!B16)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.91053106749634616},0]
[null,1.1000000000000001,{"$f":"$C$3*$G$21*((1/xkr._vx!B17)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.86815730920361944},0]
[null,1.2,{"$f":"$C$3*$G$21*((1/xkr._vx!B18)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.83119734162834624},0]
[null,1.3,{"$f":"$C$3*$G$21*((1/xkr._vx!B19)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.7985885745758603},0]
[null,1.4,{"$f":"$C$3*$G$21*((1/xkr._vx!B20)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.76953920575703494},{"$f":"1/B20*$J$11","v":0},null,"Schlitzanzahl",{"$f":"Auslegung!$D$18","v":2},null,null,"ACHTUNG! Walzenstellung wird bei rot dargestellten Zahlen berücksichtigt!"]
[null,1.5,{"$f":"$C$3*$G$21*((1/xkr._vx!B21)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.74344550343923921},0,null,"spez. Volumenstrom",{"$f":"Auslegung!$D$49/(Auslegung!D18*(Auslegung!D25/1000))","v":128.07692307692307}]
[null,1.6,{"$f":"$C$3*$G$21*((1/xkr._vx!B22)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.71983801340824061},0,null,"Walzenstellung*",{"$f":"Auslegung!$D$48","v":1},null," 1/2 Durchlassabstand","hor. Lauflänge","ver. Lauflänge","ges. Lauflänge","Geschw. Endpunkt","Geschw. OK A-Ber.","Geschw. Anzeige"]
[null,1.7,{"$f":"$C$3*$G$21*((1/xkr._vx!B23)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.69834545002751935},0,"Betrachtung Strahlweg frei entlang der Decke bis Wandkante",null,null,null,null,{"$f":"Auslegung!$D$58","v":1},null,null,{"$f":"$C$3*(Auslegung!$D$49/(Auslegung!$D$18*(Auslegung!D25/1000)))*SQRT(G20)*(1/xkr._vx!J23)^xkr._vx!$C$5","v":0.91053106749634616}]
[null,1.8,{"$f":"$C$3*$G$21*((1/xkr._vx!B24)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.67866978751575979},0,"Betrachtung Strahlweg von Wandkante bis Fußboden Aufenthaltsbereich",null,null,null,null,null,{"$f":"Auslegung!$D$54+0.5","v":4.5},{"$f":"IF(OR($G$22=1,$G$22=2),(K24+J23),(K24+J23))","v":5.5},null,{"$f":"IF(G22=4,$C$3*$G$21*SQRT(G20)*((1/xkr._vx!L24)^xkr._vx!$C$5)*$C$6*2,$C$3*$G$21*SQRT(G20)*((1/xkr._vx!L24)^xkr._vx!$C$5)*$C$6)","v":0.38825175170851939},{"$f":"IF(N24<0.1,\"<0,1\",N24)","v":0.38825175170851939}]
[null,1.9,{"$f":"$C$3*$G$21*((1/xkr._vx!B25)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.66056866445591511},0,"Betrachtung Strahlweg von Durchlassmitte bis Stoßpunkt",null,null,null,{"$f":"IF(OR($G$22=1,$G$22=2),Auslegung!$D$59,Auslegung!$D$59)","v":10},null,null,null,{"$f":"$C$3*$G$21*SQRT(G20)*(1/xkr._vx!I25)^xkr._vx!$C$5","v":0.28793520536329625}]
[null,2,{"$f":"$C$3*$G$21*((1/xkr._vx!B26)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.64384269230769242},0,"Betrachtung Freistrahl ab Stoßpunkt bis Oberkante Aufenthaltsbereich",null,null,null,null,null,{"$f":"Auslegung!$D$54-Auslegung!$D$55","v":2.2000000000000002},{"$f":"K26+I25","v":12.2},null,{"$f":"$C$3*SQRT(G20)*$G$21*((1/(xkr._vx!I25+xkr._vx!$C$4*xkr._vx!K26))^xkr._vx!$C$5)*$C$6","v":0.19085724024642897},{"$f":"MAX(N26,N28)","v":0.19085724024642897},{"$f":"IF(O26<0.1,\"<0,1\",O26)","v":0.19085724024642897}]
[null,2.1,{"$f":"$C$3*$G$21*((1/xkr._vx!B27)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.62832613039045704},0,"Betrachtung Strahlweg bis xkritisch",null,null,null,null,{"$f":"$G$3*SQRT(G20)*$G$21^$G$5*(1/xkr._vx!$G$6^(xkr._vx!$G$4))","v":1242.5063377411045},null,null,{"$f":"$C$3*(Auslegung!$D$49/(Auslegung!$D$18*(Auslegung!D25/1000)))*SQRT(G20)*(1/xkr._vx!J27)^xkr._vx!$C$5","v":2.5831252358077851E-2}]
[null,2.2000000000000002,{"$f":"$C$3*$G$21*((1/xkr._vx!B28)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.61387992047454554},0,"Betrachtung von xkritisch bis Oberkante Aufenthaltsbereich",null,null,null,null,null,{"$f":"(Auslegung!$D$54-Auslegung!$D$55)/SIN($I$1/180*PI())","v":3.1112698372208096},{"$f":"J27+K28","v":1245.6176075783253},null,{"$f":"IFERROR($G$21*SQRT(G20)*$C$3*(1/xkr._vx!L28)^xkr._vx!$C$5*$C$6,\"\")","v":2.5798971887790068E-2},{"$f":"IF(N28<0.1,\"<0,1\",N28)","v":"<0,1"}]
[null,2.2999999999999998,{"$f":"$C$3*$G$21*((1/xkr._vx!B29)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.60038640632731211},0]
[null,2.4,{"$f":"$C$3*$G$21*((1/xkr._vx!B30)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.58774527676963495},0]
[null,2.5,{"$f":"$C$3*$G$21*((1/xkr._vx!B31)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.5758704107265924},0,null,null,"die Maximalgeschwindigkeit im Vertikalstrahl berücksichtigt",null,null,"vymax",{"$f":"K26","v":2.2000000000000002},{"$f":"K31","v":2.2000000000000002},{"$f":"($K$3*$G$21*SQRT(xkr._vx!G20))/(xkr._vx!K31^K4)*1.6","v":0},{"$f":"M31","v":0},"<0,1"]
[null,2.6,{"$f":"$C$3*$G$21*((1/xkr._vx!B32)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.56468739646068966},0,null,null,"einen Korrekturfaktor von 1,6 (Katalogangabe)",null,null,"ymax",{"$f":"K31","v":2.2000000000000002},null,{"$f":"(K5*(SQRT(G20)*G21^K7))/(G6)^xkr._vx!K6","v":0}]
[null,2.7,{"$f":"$C$3*$G$21*((1/xkr._vx!B33)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.55413156108556416},0]
[null,2.8,{"$f":"$C$3*$G$21*((1/xkr._vx!B34)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.54414639077970928},0]
[null,2.9,{"$f":"$C$3*$G$21*((1/xkr._vx!B35)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.53468225333016173},0,null,"Walzenstellungen:","1 = hochdiffus"]
[null,3,{"$f":"$C$3*$G$21*((1/xkr._vx!B36)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.52569535692453273},0,null,null,"2 = divergent"]
[null,3.1,{"$f":"$C$3*$G$21*((1/xkr._vx!B37)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.5171468952341628},0,null,null,"3 = CD vertikal"]
[null,3.2,{"$f":"$C$3*$G$21*((1/xkr._vx!B38)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.50900234063681982},0,null,null,"4 = einseitig"]
[null,3.3,{"$f":"$C$3*$G$21*((1/xkr._vx!B39)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.50123085616765084},0]
[null,3.4,{"$f":"$C$3*$G$21*((1/xkr._vx!B40)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.49380480332523025},0]
[null,3.5,{"$f":"$C$3*$G$21*((1/xkr._vx!B41)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.48669932779783798},0]
[null,3.6,{"$f":"$C$3*$G$21*((1/xkr._vx!B42)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.479892008938827},0]
[null,3.7,{"$f":"$C$3*$G$21*((1/xkr._vx!B43)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.47336256171285979},0]
[null,3.8,{"$f":"$C$3*$G$21*((1/xkr._vx!B44)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.46709258207611865},0]
[null,3.9,{"$f":"$C$3*$G$21*((1/xkr._vx!B45)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.46106532850313248},0]
[null,4,{"$f":"$C$3*$G$21*((1/xkr._vx!B46)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.45526553374817308},0]
[null,4.0999999999999996,{"$f":"$C$3*$G$21*((1/xkr._vx!B47)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.44967924201754311},0,null,null,null,null,null,null,null,null,null,null,"K1",9.0107102841719897E-3]
[null,4.2,{"$f":"$C$3*$G$21*((1/xkr._vx!B48)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.44429366759579497},0,null,null,null,null,null,"Freistrahl, Quelle Bachelorarbeit Warzecha",null,null,null,null,"K2",0.55274815422861001]
[null,4.3,{"$f":"$C$3*$G$21*((1/xkr._vx!B49)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.43909707166327594},0,null,null,null,null,null,null,null,null,null,null,"K3",17.3970091932872]
[null,4.4000000000000004,{"$f":"$C$3*$G$21*((1/xkr._vx!B50)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.43407865460180972},0]
[null,4.5,{"$f":"$C$3*$G$21*((1/xkr._vx!B51)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.42922846153846156},0,null,null,null,null,null,"Abstand","Temperaturdifferenz",null,"Volumenstrom","Schlitzanzahl"]
[null,4.5999999999999996,{"$f":"$C$3*$G$21*((1/xkr._vx!B52)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.42453729924626427},0,null,null,null,null,null,"m","K",null,"m³/h"]
[null,4.7,{"$f":"$C$3*$G$21*((1/xkr._vx!B53)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.41999666282261722},0,null,null,null,null,null,{"$f":"Auslegung!D54-Auslegung!D55","v":2.2000000000000002},{"$f":"G6","v":0.01},null,{"$f":"G21","v":128.07692307692307},{"$f":"G20","v":2},null,{"$f":"$P$47*M53*(SQRT($P$48/J53)-SQRT((K53*$P$49)/(M53^2)*(2.83*SQRT(J53/$P$48)-1)))*SQRT(N53)","v":0.80662635631717372}]
[null,4.8,{"$f":"$C$3*$G$21*((1/xkr._vx!B54)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.41559867081417312},0]
[null,4.9000000000000004,{"$f":"$C$3*$G$21*((1/xkr._vx!B55)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.41133600766185174},0]
[null,5,{"$f":"$C$3*$G$21*((1/xkr._vx!B56)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.40720187250945583},0]
[null,5.0999999999999996,{"$f":"$C$3*$G$21*((1/xkr._vx!B57)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.40318993356073873},0]
[null,5.2,{"$f":"$C$3*$G$21*((1/xkr._vx!B58)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.39929428728793015},0]
[null,5.3,{"$f":"$C$3*$G$21*((1/xkr._vx!B59)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.39550942189383964},0,null,null,null,null,null,null,null,null,null,null,"K1",0.173519787620667]
[null,5.4,{"$f":"$C$3*$G$21*((1/xkr._vx!B60)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.39183018451308999},0,null,null,null,null,null,null,null,null,null,null,"K2",9.1567408045590992E-2]
[null,5.5,{"$f":"$C$3*$G$21*((1/xkr._vx!B61)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.38825175170851933},0,null,null,null,null,null,"Wandstrahl, Quelle Bachelorarbeit Warzecha",null,null,null,null,"K3",1.609834693426494E-8]
[null,5.6,{"$f":"$C$3*$G$21*((1/xkr._vx!B62)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.38476960287851747},0,null,null,null,null,null,null,null,null,null,null,"K4",5.2931975108558181E-3]
[null,5.7,{"$f":"$C$3*$G$21*((1/xkr._vx!B63)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.38137949624185413},0,null,null,null,null,null,null,null,null,null,null,"K5",3.1739119172641939E-2]
[null,5.8,{"$f":"$C$3*$G$21*((1/xkr._vx!B64)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.3780774471098608},0]
[null,5.8999999999999897,{"$f":"$C$3*$G$21*((1/xkr._vx!B65)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.3748597081928744},0]
[null,6,{"$f":"$C$3*$G$21*((1/xkr._vx!B66)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.3717227517196196},0,null,null,null,null,null,"Abstand","Temperaturdifferenz",null,"Volumenstrom","Schlitzanzahl"]
[null,7,{"$f":"$C$3*$G$21*((1/xkr._vx!B67)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.34414839508478551},{"$f":"1/B67*$J$11","v":0},null,null,null,null,null,"m","K",null,"m³/h"]
[null,8,{"$f":"$C$3*$G$21*((1/xkr._vx!B68)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.32192134615384621},0,null,null,null,null,null,{"$f":"J53","v":2.2000000000000002},{"$f":"K53","v":0.01},null,{"$f":"M53","v":128.07692307692307},{"$f":"N53","v":2},null,{"$f":"($P$59*M68*(($P$60/J68)^$P$63-((K68*$P$61)/(M68^2)*(2.83*SQRT(J68/$P$60)-1))^$P$62))*SQRT(N68)","v":1.5555680527190383}]
[null,9,{"$f":"$C$3*$G$21*((1/xkr._vx!B69)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.30351035583211533},0]
[null,10,{"$f":"$C$3*$G$21*((1/xkr._vx!B70)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.2879352053632962},0]
[null,11,{"$f":"$C$3*$G$21*((1/xkr._vx!B71)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.27453544644064976},0]
[null,12,{"$f":"$C$3*$G$21*((1/xkr._vx!B72)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.26284767846226637},0]
[null,13,{"$f":"$C$3*$G$21*((1/xkr._vx!B73)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.25253588090469531},0]
[null,14,{"$f":"$C$3*$G$21*((1/xkr._vx!B74)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.24334966389891899},0]
[null,15,{"$f":"$C$3*$G$21*((1/xkr._vx!B75)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.23509811070785397},0]
[null,16,{"$f":"$C$3*$G$21*((1/xkr._vx!B76)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.22763276687408654},0]
[null,17,{"$f":"$C$3*$G$21*((1/xkr._vx!B77)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.22083622157022578},0]
[null,18,{"$f":"$C$3*$G$21*((1/xkr._vx!B78)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.21461423076923078},0]
[null,19,{"$f":"$C$3*$G$21*((1/xkr._vx!B79)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.20889015306162026},0]
[null,20,{"$f":"$C$3*$G$21*((1/xkr._vx!B80)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.20360093625472792},0]
[null,21,{"$f":"$C$3*$G$21*((1/xkr._vx!B81)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.19869416854337862},0]
[null,22,{"$f":"$C$3*$G$21*((1/xkr._vx!B82)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.19412587585425967},0]
[null,23,{"$f":"$C$3*$G$21*((1/xkr._vx!B83)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.18985885201976341},0]
[null,24,{"$f":"$C$3*$G$21*((1/xkr._vx!B84)^xkr._vx!$C$5)*$C$6*SQRT(Auslegung!$D$18)","v":0.1858613758598098},0]

{"sheet":"Eingabe","index":10,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,1,"= Produktgruppe emcoair"]
[null,null,null,null,null,"KSW","Artikel"]
[null,null,null,null,null,null,1,"Schlitzanzahl","1 Schlitz "]
[null,null,null,null,null,null,2,null,"2 Schlitze"]
[null,null,null,null,null,null,"X",null,"Sonder"]
[null,null,null,null,null,null,null,"K","Funktion","Zuluft / Abluft Kombination"]
[null,null,null,null,null,null,null,"Z",null,"Zuluft"]
[null,null,null,null,null,null,null,"A",null,"Abluft"]
[null,null,null,null,null,null,null,null,"0500","Breite"]
[null,null,null,null,null,null,null,null,"0600"]
[null,null,null,null,null,null,null,null,"0700"]
[null,null,null,null,null,null,null,null,"0800"]
[null,null,null,null,null,null,null,null,"0900"]
[null,null,null,null,null,null,null,null,"1000"]
[null,null,null,null,null,null,null,null,"1100"]
[null,null,null,null,null,null,null,null,"1200"]
[null,null,null,null,null,null,null,null,null,"A","Werkstoff","Aluminium"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,9010,"Oberfläche Luftdurchlass","RAL 9010 glänzend"]
[null,null,null,null,null,null,null,null,null,null,"E6C0",null,"Aluminium naturfarbig eloxiert"]
[null,null,null,null,null,null,null,null,null,null,"XXXX",null,"RAL-Ton **** glänzend"]
[null,null,null,null,null,null,null,null,null,null,"SSSS",null,"Sonderlackierung"]
[null,null,null,null,null,null,null,null,null,null,null,"S","Farbe Luftlenkelement","schwarz"]
[null,null,null,null,null,null,null,null,null,null,null,"W",null,"weiß"]
[null,null,null,null,null,null,null,null,null,null,null,"G",null,"grau"]
[null,null,null,null,null,null,null,null,null,null,null,null,"C","Luftlenkeinstellung","DE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S",null,"Sonder"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"V","Werkstoff Anschlusskasten","Stahl verzinkt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"ohne Anschlusskasten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Drossel ","mit FBD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"ohne FBD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1","Innenauskleidung","Dämmung Baustoffklasse B1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",null,"Dämmung Baustoffklasse A2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Stutzenanzahl","1 Stutzen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",null,"Sonder"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"Stutzendurchmesser","98 mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"080",null,"78 mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xxx",null,"Sonder"]
[null,null,null,null,{"$f":"E2","v":1},{"$f":"F3","v":"KSW"},{"$f":"G4","v":1},1,{"$f":"I10","v":"0500"},{"$f":"J18","v":"A"},{"$f":"K21","v":9010},{"$f":"L25","v":"S"},{"$f":"M28","v":"C"},{"$f":"N30","v":"V"},{"$f":"O32","v":1},{"$f":"P34","v":"B1"},{"$f":"Q36","v":1},{"$f":"R38","v":100}]
[]
[]
[]
["Schwarz","S"]
["weiß","W"]
["naturfarbig eloxiert","K"]
["weiß (RAL 9010) bepulvert","L"]
["Anschlusskasten ohne Mengeneinstellung","AK1"]
["Anschlusskasten mit Mengeneinstellung*","AK2"]

{"sheet":"SAL35-CAP","index":11,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Übergabedaten:",null,"Gewählter Durchlass",null,{"$f":"CONCATENATE(Auslegung!$D$12,Auslegung!$D$48)","v":"SAL 351"},null,"Schlitzzahl",{"$f":"Auslegung!$D$18","v":2}]
[null,null,"Volumenstrom",null,{"$f":"Auslegung!$D$49","v":333}]
[null,null,"Temperaturdifferenz",null,{"$f":"Auslegung!$D$52-Auslegung!$D$51","v":0}]
[null,null,"SAL 35","SAL 35","SAL 35","SAL 35"]
[null,null,"hochdiffus","divergent","vertikal","einseitig",null,null,null,null,null,"rote Markierung:",null,"Datensatz von CAP2000"]
[null,null,{"$f":"CONCATENATE(C4,C7)","v":"SAL 351"},{"$f":"CONCATENATE(D4,D7)","v":"SAL 352"},{"$f":"CONCATENATE(E4,E7)","v":"SAL 353"},{"$f":"CONCATENATE(F4,F7)","v":"SAL 354"},null,null,1]
[null,null,1,2,3,4,null,null,2]
["Konstante","K011",2.5200000000000001E-3,2.5200000000000001E-3,3.8579999999999999E-3,2.3519999999999999E-3,null,null,3]
[null,"K012",1.92,1.92,1.889,1.92,null,null,4]
[null,"K021",-75.599999999999994,-75.599999999999994,-88.76,-75.599999999999994,null,null,5,null,null,null,null,null,null,null,null,"SAL 35","SAL 35","SAL 35","SAL 35"]
[null,"K022",53.72,53.72,59.88,53.72,null,null,6,null,null,null,null,"Datensätze vor 2000",null,null,null,"hochdiffus","divergent","vertikal","einseitig"]
[null,"K031",5.0270000000000002E-3,5.0270000000000002E-3,null,5.0270000000000002E-3,null,null,7,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(R10,R13)","v":"SAL 351"},{"$f":"CONCATENATE(S10,S13)","v":"SAL 352"},{"$f":"CONCATENATE(T10,T13)","v":"SAL 353"},{"$f":"CONCATENATE(U10,U13)","v":"SAL 354"}]
[null,"K032",5.8,5.8,null,5.8,null,null,8,null,null,null,null,null,null,null,null,1,2,3,4]
[null,"K033",0.5,0.5,null,0.5,null,null,9,null,null,null,null,null,null,"Konstante","K011",2.5200000000000001E-3,2.5200000000000001E-3,3.8579999999999999E-3,2.3519999999999999E-3]
[null,"K034",1,1,null,1,null,null,10,null,null,null,null,null,null,null,"K012",1.92,1.92,1.889,1.92]
[null,"K041",8.8200000000000001E-2,8.8200000000000001E-2,null,8.8200000000000001E-2,null,null,11,null,null,null,null,null,null,null,"K021",-75.599999999999994,-75.599999999999994,-88.76,-75.599999999999994]
[null,"K042",0.64300000000000002,0.64300000000000002,null,0.64300000000000002,null,null,12,null,null,null,null,null,null,null,"K022",53.72,53.72,59.88,53.72]
[null,"K043",1.2869999999999999,1.2869999999999999,null,1.2869999999999999,null,null,13,null,null,null,null,null,null,null,"K031",1.0054E-2,1.0054E-2,null,5.0270000000000002E-3]
[null,"K051",9.9320000000000006E-2,9.9320000000000006E-2,7.9460000000000003E-2,4.9660000000000003E-2,null,null,14,null,null,null,null,null,null,null,"K032",5.8,5.8,null,5.8]
[null,"K052",0.5,0.5,0.5,0.5,null,null,15,null,null,null,null,null,null,null,"K033",0.5,0.5,null,0.5]
[null,"K071",null,null,8.0429999999999998E-3,null,null,null,16,null,null,null,null,null,null,null,"K034",0.70699999999999996,0.70699999999999996,null,0.70699999999999996]
[null,"K072",null,null,0.5,null,null,null,17,null,null,null,null,null,null,null,"K041",8.8200000000000001E-2,8.8200000000000001E-2,null,8.8200000000000001E-2]
[null,"K081",null,null,2.0369999999999999E-2,null,null,null,18,null,null,null,null,null,null,null,"K042",0.64300000000000002,0.64300000000000002,null,0.64300000000000002]
[null,"K082",null,null,0.64300000000000002,null,null,null,19,null,null,null,null,null,null,null,"K043",1.2869999999999999,1.2869999999999999,null,1.2869999999999999]
[null,"K083",null,null,1.2869999999999999,null,null,null,20,null,null,null,null,null,null,null,"K051",9.9320000000000006E-2,9.9320000000000006E-2,7.9460000000000003E-2,4.9660000000000003E-2]
[null,"K091",0,0,null,0,null,null,21,null,null,null,null,null,null,null,"K052",0.5,0.5,0.5,0.5]
[null,"K092",23.5,23.5,null,23.5,null,null,22,null,null,null,null,null,null,null,"K071",null,null,8.0429999999999998E-3]
[null,"K093",2.5,2.5,null,2.5,null,null,23,null,null,null,null,null,null,null,"K072",null,null,0.5]
[null,"K094",0,0,null,0,null,null,24,null,null,null,null,null,null,null,"K081",null,null,2.0369999999999999E-2]
[null,"K101",-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,null,null,25,null,null,null,null,null,null,null,"K082",null,null,0.64300000000000002]
[null,"K102",24,24,24,24,null,null,26,null,null,null,null,null,null,null,"K083",null,null,1.2869999999999999]
[null,"K103",7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,null,null,27,null,null,null,null,null,null,null,"K091",0,0,null,0]
[null,"K104",0.01,0.01,0.01,0.01,null,null,28,null,null,null,null,null,null,null,"K092",23.5,23.5,null,47]
[null,"K021Abluft",null,null,null,null,null,null,29,null,null,null,null,null,null,null,"K093",2.5,2.5,null,2.5]
[null,"K022Abluft",null,null,null,null,null,null,30,null,null,null,null,null,null,null,"K094",0,0,null,0]
[null,"K011Abluft",null,null,null,null,null,null,31,null,null,null,null,null,null,null,"K101",-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,-0.69299999999999995]
[null,"K012Abluft",null,null,null,null,null,null,32,null,null,null,null,null,null,null,"K102",24,24,24,24]
[null,null,{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$H$36,#REF!,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"K103",7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3]
[null,null,{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$H$36,I7,FALSE),\"\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,"K104",0.01,0.01,0.01,0.01]
["Rückgabe","K011",{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$H$36,I8,FALSE),\"\")","v":2.5200000000000001E-3}]
[null,"K012",1.92]
[null,"K021",-75.599999999999994]
[null,"K022",53.72]
[null,"K031",5.0270000000000002E-3]
[null,"K032",5.8]
[null,"K033",0.5]
[null,"K034",1]
[null,"K041",8.8200000000000001E-2]
[null,"K042",0.64300000000000002]
[null,"K043",1.2869999999999999]
[null,"K051",9.9320000000000006E-2]
[null,"K052",0.5]
[null,"K071",0]
[null,"K072",0]
[null,"K081",0]
[null,"K082",0]
[null,"K083",0]
[null,"K091",0]
[null,"K092",23.5]
[null,"K093",2.5]
[null,"K094",0]
[null,"K101",-0.69299999999999995]
[null,"K102",24]
[null,"K103",7.0000000000000001E-3]
[null,"K104",0.01]
[null,"K021Abluft",0]
[null,"K022Abluft",0]
[null,"K011Abluft",0]
[null,"K012Abluft",""]

{"sheet":"SAL50-CAP","index":12,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Übergabedaten:",null,"Gewählter Durchlass",null,{"$f":"CONCATENATE(Auslegung!$D$12,Auslegung!$D$48)","v":"SAL 351"}]
[null,null,"Volumenstrom",null,{"$f":"Auslegung!$D$49","v":333},null,null,null,null,null,null,null,"k41",0.10710270433156224]
[null,null,"Temperaturdifferenz",null,{"$f":"Auslegung!$D$52-Auslegung!$D$51","v":0},null,null,null,null,null,null,null,"k42",0.63752960991410801]
[null,null,"SAL 50","SAL 50","SAL 50","SAL 50",null,null,null,null,null,null,"k43",1.135276760836136]
[null,null,1,2,3,4,null,null,"n","V°spez","DJ","xkrit","sum",{"$f":"SUM(N6:N28)","v":28.030552348634309}]
[null,null,{"$f":"CONCATENATE(C4,C5,)","v":"SAL 501"},{"$f":"CONCATENATE(D4,D5,)","v":"SAL 502"},"SAL 503","SAL 504",1,null,1,250,10,11.88,{"$f":"$N$2*SQRT(I6)*J6^$N$4*(1/K6^$N$3)","v":13.019562557273275},{"$f":"(M6-L6)^2","v":1.2986028219392047}]
[null,null,"hochdiffus","divergent","vertikal","einseitig",2,null,1,194.44,10,8.6,{"$f":"$N$2*SQRT(I7)*J7^$N$4*(1/K7^$N$3)","v":9.7875939367416578},{"$f":"(M7-L7)^2","v":1.4103793585855495},null,null,null,"Originalkonstanten"]
["Konstante","K011",7.2059999999999995E-4,8.0800000000000002E-4,1.1180000000000001E-3,8.0800000000000002E-4,3,null,1,194.44,6,11.94,13.555361063888766,2.6093913667278472,null,null,null,"Konstante","K011",8.0800000000000002E-4,8.0800000000000002E-4,1.1180000000000001E-3,8.0800000000000002E-4]
[null,"K012",1.9610000000000001,1.946,1.9259999999999999,1.946,4,null,1,277.77999999999997,4.2,23.77,25.511587586531991,3.0331273215623282,null,null,null,null,"K012",1.946,1.946,1.9259999999999999,1.946]
[null,"K021",-104.9,-104.9,-114.23,-104.9,5,null,1,277.77999999999997,12,12.1,13.063735050764624,0.92878524807229301,null,null,null,null,"K021",-104.9,-104.9,-114.23,-104.9]
[null,"K022",60.3,60.3,64.78,60.3,6,null,2,125,6,10.56,11.608983098623373,1.1003655411974917,null,null,null,null,"K022",60.3,60.3,64.78,60.3]
[null,"K031",3.8800000000000002E-3,3.8800000000000002E-3,null,3.8800000000000002E-3,7,null,2,250,6,25.78,25.500373252188304,7.8191118091746614E-2,null,null,null,null,"K031",3.8800000000000002E-3,3.8800000000000002E-3,null,3.8800000000000002E-3]
[null,"K032",5.8,5.8,null,5.8,8,null,2,208.33,6,20.9,20.732230086451175,2.814674389217987E-2,null,null,null,null,"K032",5.8,5.8,null,5.8]
[null,"K033",0.5,0.5,null,0.5,9,null,2,104.17,8.1999999999999993,7.43,7.7344315772037486,9.267858519876214E-2,null,null,null,null,"K033",0.5,0.5,null,0.5]
[null,"K034",1,1,null,1,10,null,2,104.17,7,6.44,8.5553300171516646,4.4746210814628604,null,null,null,null,"K034",0.70699999999999996,0.70699999999999996,null,0.70699999999999996]
[null,"K041",0.10710270433156224,4.283E-2,null,0.10710270433156224,11,null,2,208.33,1,64.52,64.9741315074711,0.20623542607797707,null,null,null,null,"K041",4.283E-2,4.283E-2,null,4.283E-2]
[null,"K042",0.63752960991410801,0.64300000000000002,null,0.63752960991410801,12,null,3,222.22,4,37.32,35.381672483992752,3.7571135593108305,null,null,null,null,"K042",0.64300000000000002,0.64300000000000002,null,0.64300000000000002]
[null,"K043",1.135276760836136,1.2869999999999999,null,1.135276760836136,13,null,3,111.11,4,15.29,16.107420617164937,0.66817646536630826,null,null,null,null,"K043",1.2869999999999999,1.2869999999999999,null,1.2869999999999999]
[null,"K051",0.2455,3.8199999999999998E-2,6.1120000000000001E-2,3.8199999999999998E-2,14,null,3,166.67,2.6,34,33.59126660976839,0.1670629842902259,null,null,null,null,"K051",3.8199999999999998E-2,3.8199999999999998E-2,6.1120000000000001E-2,3.8199999999999998E-2]
[null,"K052",1,0.5,0.5,0.5,15,null,3,166.67,10,14.3,14.231627456344079,4.6748047259809813E-3,null,null,null,null,"K052",0.5,0.5,0.5,0.5]
[null,"K071",null,null,6.221E-3,null,16,null,3,166.67,12,12.7,12.669928899030733,9.0427111350380499E-4,null,null,null,null,"K071",null,null,6.221E-3]
[null,"K072",null,null,0.5,null,17,null,4,151.52000000000001,6,21.14,20.425506963756092,0.51050029884103898,null,null,null,null,"K072",null,null,0.5]
[null,"K081",null,null,9.8919999999999998E-3,null,18,null,4,101.01,6,12.54,12.889743054800546,0.12232020438121805,null,null,null,null,"K081",null,null,9.8919999999999998E-3]
[null,"K082",null,null,0.64300000000000002,null,19,null,4,189.39,4.8,32.520000000000003,30.335384252088691,4.7725459660221032,null,null,null,null,"K082",null,null,0.64300000000000002]
[null,"K083",null,null,1.2869999999999999,null,20,null,4,126.26,4.8,19.3,19.144198392178822,2.4274140999664334E-2,null,null,null,null,"K083",null,null,1.2869999999999999]
[null,"K091",0,0,null,0,21,null,4,126.26,11,11.32,11.283139931714723,1.3586646339952746E-3,null,null,null,null,"K091",0,0,null,0]
[null,"K092",61,61,null,61,22,null,4,189.39,11,19.079999999999998,17.878961468477385,1.4424935542019948,null,null,null,null,"K092",61,61,null,61]
[null,"K093",2.5,2.5,null,2.5,23,null,1,250,10,11.88,13.019562557273275,1.2986028219392047,null,null,null,null,"K093",2.5,2.5,null,2.5]
[null,"K094",0,0,null,0,24,null,null,null,null,null,null,null,null,null,null,null,"K094",0,0,null,0]
[null,"K101",-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,25,null,null,null,null,null,null,null,null,null,null,null,"K101",-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,-0.69299999999999995]
[null,"K102",24,24,24,24,26,null,null,null,null,null,null,null,null,null,null,null,"K102",24,24,24,24]
[null,"K103",1.2E-2,1.2E-2,1.2E-2,1.2E-2,27,null,null,null,null,null,null,null,null,null,null,null,"K103",1.2E-2,1.2E-2,1.2E-2,1.2E-2]
[null,"K104",0.01,0.01,0.01,0.01,28,null,null,null,null,null,null,null,null,null,null,null,"K104",0.01,0.01,0.01,0.01]
[null,"K021Abluft"]
[null,"K022Abluft"]
[null,"K011Abluft"]
[null,"K012Abluft"]
[null,null,{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$F$37,G6,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$F$37,G7,FALSE),\"\")","v":""}]
["Rückgabe","K011",""]
[null,"K012","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6794999999999997E-3]
[null,"K021",""]
[null,"K022",""]
[null,"K031",""]
[null,"K032",""]
[null,"K033",""]
[null,"K034",""]
[null,"K041",""]
[null,"K042",""]
[null,"K043",""]
[null,"K051",""]
[null,"K052",""]
[null,"K071",""]
[null,"K072",""]
[null,"K081",""]
[null,"K082",""]
[null,"K083",""]
[null,"K091",""]
[null,"K092",""]
[null,"K093",""]
[null,"K094",""]
[null,"K101",""]
[null,"K102",""]
[null,"K103",""]
[null,"K104",""]
[null,"K021Abluft",""]
[null,"K022Abluft",""]
[null,"K011Abluft",""]
[null,"K012Abluft",""]

{"sheet":"SALS-CAP","index":13,"n_rows":69,"n_cols":20,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Übergabedaten:",null,"Gewählter Durchlass",null,{"$f":"CONCATENATE(Auslegung!$D$12,Auslegung!$D$48)","v":"SAL 351"}]
[null,null,"Volumenstrom",null,{"$f":"Auslegung!$D$49","v":333}]
[null,null,"Temperaturdifferenz",null,{"$f":"Auslegung!$D$52-Auslegung!$D$51","v":0}]
[null,null,"SAL-S","SAL-S","SAL-S","SAL-S"]
[null,null,1,2,3,4]
[null,null,{"$f":"CONCATENATE(C4,C5,)","v":"SAL-S1"},{"$f":"CONCATENATE(D4,D5,)","v":"SAL-S2"},"SAL-S3","SAL-S4",1]
[null,null,"hochdiffus","divergent","vertikal","einseitig",2]
["Konstante","K011",2.66E-3,3.8800000000000002E-3,4.9199999999999999E-3,4.0000000000000001E-3,3]
[null,"K012",2,2,2,2,4]
[null,"K021",-90.8,-88.161199999999994,-86.140590000000003,-84.65,5]
[null,"K022",61.83,61.83,61.83,56.22,6]
[null,"K031",4.8429500000000004E-3,4.0702000000000004E-3,3.6197999999999998E-3,6.4837999999999996E-3,7]
[null,"K032",4.3722599999999998,2.91,2.17604,2.8017116,8]
[null,"K033",0.5,0.5,0.5,0.92302870000000004,9]
[null,"K034",0.70699999999999996,0.70699999999999996,0.70699999999999996,1,10]
[null,"K041",1.6389999999999998E-2,1.346E-2,1.173E-3,4.6359999999999998E-2,11]
[null,"K042",0.64300000000000002,0.64300000000000002,0.64300000000000002,0.27182000000000001,12]
[null,"K043",1.2869999999999999,1.2869999999999999,1.2869999999999999,1.0028999999999999,13]
[null,"K051",4.9660000000000003E-2,4.9660000000000003E-2,4.9660000000000003E-2,0.1239,14]
[null,"K052",0.5,0.5,0.5,0.26300000000000001,15]
[null,"K071",null,null,null,null,16]
[null,"K072",null,null,null,null,17]
[null,"K081",null,null,null,null,18]
[null,"K082",null,null,null,null,19]
[null,"K083",null,null,null,null,20]
[null,"K091",null,null,null,0,21]
[null,"K092",47,47,47,240,22]
[null,"K093",2.5,2.5,2.5,3,23]
[null,"K094",0,0,0,0,24]
[null,"K101",-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,-0.69299999999999995,25]
[null,"K102",24,24,24,33,26]
[null,"K103",7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,2.7E-2,27]
[null,"K104",0.01,0.01,0.01,0.01,28]
[null,"K021Abluft"]
[null,"K022Abluft"]
[null,"K011Abluft"]
[null,"K012Abluft"]
[null,null,{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$F$37,G6,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(HLOOKUP($E$1,$C$6:$F$37,G7,FALSE),\"\")","v":""}]
["Rückgabe","K011",""]
[null,"K012","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6794999999999997E-3]
[null,"K021",""]
[null,"K022",""]
[null,"K031",""]
[null,"K032",""]
[null,"K033",""]
[null,"K034",""]
[null,"K041",""]
[null,"K042",""]
[null,"K043",""]
[null,"K051",""]
[null,"K052",""]
[null,"K071",""]
[null,"K072",""]
[null,"K081",""]
[null,"K082",""]
[null,"K083",""]
[null,"K091",""]
[null,"K092",""]
[null,"K093",""]
[null,"K094",""]
[null,"K101",""]
[null,"K102",""]
[null,"K103",""]
[null,"K104",""]
[null,"K021Abluft",""]
[null,"K022Abluft",""]
[null,"K011Abluft",""]
[null,"K012Abluft",""]