{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Version","Hinweise zum Programm","Auslegung","Bauakustik","Funktion","Maße","Datenblatt","Grunddaten","Lw","Dt","v_x","Eingabe","Dp"],"not_rendered":{"charts":2,"images":21,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"660_Auslegungstool_LBQ_201030.xlsm"}]
["Version:","1.0"]

{"sheet":"Hinweise zum Programm","index":1,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Hinweise zur Bedienung"]
[]
["Allgemeine Hinweise:"]
["Das Auslegungstool LBQ dient als Hilfsmittel zur Technischen Planung des Bodenquelldurchlasses emcoair LBQ. "]
[]
["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."]
[]
["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":118,"n_cols":10,"rows_kept":118,"cut":false,"hidden":false,"merged":[[0,0,0,3],[25,0,25,3],[5,0,5,3],[83,1,83,3],[58,1,58,3],[59,1,59,3],[77,1,77,3],[78,1,78,3],[80,1,80,3],[81,1,81,3],[82,1,82,3],[71,1,71,3],[72,1,72,3],[69,1,69,3],[61,1,61,3],[75,1,75,3],[85,1,85,3],[73,1,73,3],[68,1,68,3],[76,1,76,3],[79,1,79,3],[70,1,70,3],[74,1,74,3],[84,1,84,3],[62,1,62,3],[56,0,56,3],[57,1,57,3],[60,1,60,3],[67,1,67,3],[65,1,65,3],[64,1,64,3],[63,1,63,3],[66,1,66,3]]}
["Auslegung Boden-Quellluftdurchlass - Kampmann LBQ"]
[]
["Eingabefelder sind gelb gekennzeichnet"]
["Ergebnisfelder sind blau gekennzeichnet"]
[]
["Vorgaben"]
["Position","Symbol","Einheit","Wert"]
["Bezeichung","Symbol","Einheit","LBQ"]
[null,"L","mm","LBQ"]
[null,"L","mm"]
[null,"L","mm"]
["Nenngröße","B","mm",150]
["Nennlänge","L","mm",1000]
["Nennlänge","L","mm",600]
["Luftvolumenstrom Zuluft","V·","m³/h",150]
["Anzahl Stutzen","n","-",1]
[null,null,null,{"$f":"IF(AND(D13>1000,D21=2),2,1)","v":1}]
[null,null,null,{"$f":"IF(OR(D13<=1000,D12=\"600x600\"),2,1)","v":2}]
[null,null,null,{"$f":"IF(D13>1500,3,\"\")","v":""}]
[null,null,null,{"$f":"IF(D13>1500,4,\"\")","v":""}]
[null,null,null,{"$f":"IF(D12=\"600x600\",1,2)","v":2}]
["Anströmgeschwindigkeit im Stutzen","v","m/s",{"$f":"Grunddaten!I22","v":5.3051647697298439}]
["Temperatur Zuluft","tSUP","°C",24]
["Temperatur Raum","tRaum","°C",26]
[]
["Raumdaten"]
["Raumhöhe","H1","m",3]
["Obergrenze Aufenthaltsbereich","H2","m",1.8]
["Raumlänge","LR","m",5]
["Raumbreite","BR","m",3,null,null,1,"Sichtbare Länge",{"$f":"Grunddaten!$N$22","v":1020},"mm"]
["Raumart nach VDI 2081",null,null,"Einzelbüro",null,null,2,"Sichtbare Breite",{"$f":"Grunddaten!$O$22","v":170},"mm"]
[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,null,"Sporthalle"]
["Abstand zur Schallquelle","r","m",3,null,null,3,"Länge Anschlusskasten",{"$f":"Grunddaten!$K$22","v":1000},"mm"]
["Zusatzdaten",null,null,null,null,null,4,"Höhe Anschlusskasten",{"$f":"Grunddaten!$M$22","v":160},"mm"]
["Blendrahmenprofil","Z Profil",null,null,{"$f":"VLOOKUP(B58,B59:E60,4,0)","v":"Z"},null,5,"Gesamthöhe",{"$f":"Grunddaten!$M$22","v":160},"mm"]
[null,"Z Profil",null,null,"Z",null,null,null,null,"mm"]
[null,"L Profil",null,null,"L",null,null,null,null,"mm"]
["Werkstoff Luftdurchlass","Stahl verzinkt",null,null,{"$f":"VLOOKUP(B61,B62:E64,4,0)","v":"V"},null,6,"Stutzendurchmesser",{"$f":"Grunddaten!$P$22","v":98},"mm"]
[null,"Stahl verzinkt",null,null,"V"]
[null,null,null,null,"E"]
[null,null,null,null,"S"]
["Farbe Luftdurchlass / Blendrahmen (RAL, matt)",7012,null,null,{"$f":"B65","v":7012},null,7,"Stutzenabstand",{"$f":"Grunddaten!$Q$22","v":498.25},"mm"]
["Anschlusskasten","mit",null,null,{"$f":"VLOOKUP(B66,B67:E68,4,0)","v":1}]
[null,"mit",null,null,1]
[null,"ohne",null,null,0]
["Werkstoff Anschlusskasten","Stahl verzinkt",null,null,{"$f":"VLOOKUP(B69,B70:E73,4,0)","v":"V"}]
[null,"Stahl verzinkt",null,null,"V"]
[]
[]
[]
["Drossel im Anschlusskasten (selbsthemmend)","ohne",null,null,{"$f":"VLOOKUP(B74,B75:E76,4,0)","v":0}]
[null,"mit",null,null,1]
[null,"ohne",null,null,0]
["integrierte Höhenverstellung","mit",null,null,{"$f":"VLOOKUP(B77,B78:E79,4,0)","v":1}]
[null,"mit",null,null,1]
[null,"ohne",null,null,0]
["Ausführung","Einzelposition",null,null,{"$f":"VLOOKUP(B80,B81:E84,4,0)","v":1}]
[null,"Einzelposition",null,null,1]
[null,"Bandanfang",null,null,2]
[null,"Bandmitte",null,null,3]
[null,"Bandende",null,null,4]
["Merkmalschlüssel",{"$f":"CONCATENATE(1,\"LBQ\",$D$12,$E$85,$D$16,$E$58,$E$61,$E$65,$E$66,$E$69,$E$74,$E$77,$E$80,)","v":"1LBQ15010001ZV70121V011"},null,null,{"$f":"IF($D$13<1000,CONCATENATE(\"0\",D13),D13)","v":1000}]
["Brutto-Listenpreis","Preis auf Anfrage"]
[{"$f":"IF(B68=\"frontseitig bedienbare Drossel*\",\"*Preis für Anschlusskasten mit Mengeneinstellung auf Anfrage\",\"\")","v":""}]
["Berechnung",null,null,{"$f":"IF(D12=500,\"Zuluft/Abluft\",\"Zuluft\")","v":"Zuluft"}]
["Druckverlust","Dpt","Pa",{"$f":"Grunddaten!$J$22","v":35.892404574344745}]
["Austrittsgeschwindigkeit","v0","m/s",{"$f":"Grunddaten!$F$22","v":0.27777777777777779}]
["Schallleistungspegel","LWA","dB(A)",{"$f":"Lw!I61","v":37.56495306205742}]
[null,null,null,{"$f":"IF(D91=\"<25\",0,D91)","v":37.56495306205742}]
[]
["Schallldruckpegel im Raum","LPA","dB(A)",{"$f":"IF(D92+10*LOG(Lw!$F$69/(4*PI()*Auslegung!D56^2)+4/(Lw!$H$69))>=25,D92+10*LOG(Lw!$F$69/(4*PI()*Auslegung!D56^2)+4/(Lw!$H$69)),\"<25\")","v":32.450926483031722}]
[]
[]
["Oktavspektrum Schallleistung","LW_Okt","dB",{"$f":"D88","v":"Zuluft"}]
[null,"LW_125","dB",{"$f":"Lw!B$62","v":37.473288828537463}]
[null,"LW_250","dB",{"$f":"Lw!C$62","v":36.182114141210832}]
[null,"LW_500","dB",{"$f":"Lw!D$62","v":36.741253192640727}]
[null,"LW_1000","dB",{"$f":"Lw!E$62","v":32.031777450311822}]
[null,"LW_2000","dB",{"$f":"Lw!F$62","v":27.57659934943403}]
[null,"LW_4000","dB",{"$f":"Lw!G$62","v":23.120951260653545}]
[null,"LW_8000","dB",{"$f":"Lw!H$62","v":22.188289103814615}]
[null,null,null,{"$f":"Grunddaten!F23","v":189}]
["Durchgangsdämpfungsmaß","Dt","dB"]
[null,"Dt_63","dB",{"$f":"Dt!D$12","v":0}]
[null,"Dt_125","dB",{"$f":"Dt!E$12","v":0}]
[null,"Dt_250","dB",{"$f":"Dt!F$12","v":0}]
[null,"Dt_500","dB",{"$f":"Dt!G$12","v":0}]
[null,"Dt_1000","dB",{"$f":"Dt!H$12","v":0}]
[null,"Dt_2000","dB",{"$f":"Dt!I$12","v":0}]
[null,"Dt_4000","dB",{"$f":"Dt!J$12","v":0}]
[null,"Dt_8000","dB",{"$f":"Dt!K$12","v":0}]
[]
["Änderungen vorbehalten"]
["Stand:"]
[{"$f":"Grunddaten!D25","v":"2020-10-30"}]

{"sheet":"Bauakustik","index":3,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":true,"merged":[[3,0,3,3],[0,0,0,3],[8,0,8,3],[21,0,21,3],[28,0,28,3]]}
["Bauakustik - resultierendes Schalldämm-Maß"]
[]
["Erläuterung:"]
["Aus den Einzahlangaben der bewerteten Schalldämm-Maße nach DIN EN ISO 717-1 und den Flächenanteilen der Einzelelemente wird das resultierende Schalldämm-Maß R´W,R,res nach DIN 4109 berechnet."]
[]
["Eingabefelder sind gelb gekennzeichnet"]
["Ergebnisfelder sind blau gekennzeichnet"]
[]
["Vorgaben KSW"]
["Position","Symbol","Einheit","Wert"]
["gewählter Luftdurchlass",null,null,{"$f":"Auslegung!#REF!","v":{"$error":"#REF!"}}]
["aktive Länge","L","mm",{"$f":"Auslegung!D12","v":150}]
["Schlitzanzahl","n","[-]",{"$f":"Auslegung!D13","v":1000}]
["Breite Anschlusskasten","bAK","m",{"$f":"Auslegung!I30/1000","v":1.02}]
["Höhe Anschlusskasten","hAK","m",{"$f":"Auslegung!I56/1000","v":1}]
["Bezugsfläche KSW für die Berechnung","SAK","m²",{"$f":"D14*D15","v":1.02}]
["Abluft an Kanal angeschlossen?",null,null,"ja"]
[null,null,null,"ja"]
[null,null,null,"nein"]
["Schalldämm-Maß emcoair KSW","RW_AK","dB",{"$f":"IF(D17=\"ja\",Grunddaten!S22,Grunddaten!U22)","v":0}]
[]
["Vorgaben Trennwand"]
["Position","Symbol","Einheit","Wert"]
["Breite Trennwand","bE1","m",5]
["Höhe Trennwand","hE1","m",3]
["Fläche Trennwand exklusive Einbauten","SE1","m²",{"$f":"D24*D25-D33-D16","v":13.98}]
["Schalldämm-Maß der Trennwand","RW_E1","dB",40]
[]
["Vorgaben weitere Bauteile im System (Tür, Fenster, …)"]
["Position","Symbol","Einheit","Wert"]
["Breite Element","bE2","m",0]
["Höhe Element","hE2","m",0]
["Fläche Element","SE2","m²",{"$f":"D31*D32","v":0}]
["Schalldämm-Maß Element","RW_E2","dB",0]
[]
["resultierendes Schalldämmmaß des Gesamtsystems","R´W,R,res","dB",{"$f":"-10*LOG(1/(D33+D26+D16)*($D$16*10^(-0.1*$D$20)+$D$26*10^(-0.1*$D$27)+$D$33*10^(-0.1*$D$34)))","v":11.668962559275972}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"technische Änderungen vorbehalten"]
[null,null,"Stand:",{"$f":"Grunddaten!$D$25","v":"2020-10-30"}]

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

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

{"sheet":"Datenblatt","index":6,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":false,"merged":[[49,5,49,6],[50,5,50,6],[14,0,14,8],[21,6,21,7],[1,1,1,7],[11,7,11,8],[9,3,9,4],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6]]}
[]
["Typ",{"$f":"Auslegung!$D$8","v":"LBQ"},null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-01-04"}]
["Projekt"]
["Bearbeiter"]
[]
[]
[]
[]
[]
["Nenngröße:",{"$f":"Auslegung!D12","v":150},null,"integrierte Höhenverstellung:",null,null,{"$f":"Auslegung!B77","v":"mit"}]
["Nennlänge:",{"$f":"Auslegung!D13","v":1000},null,"Ausführung:",null,null,{"$f":"Auslegung!B80","v":"Einzelposition"}]
["Blendrahmen:",{"$f":"Auslegung!B58","v":"Z Profil"},null,"Anschlusskasten:",null,null,{"$f":"Auslegung!B66","v":"mit"}]
["Drossel im AK:",{"$f":"Auslegung!B74","v":"ohne"}]
[]
["Beschreibung:\nLinearer Bodenquellluftdurchlass für turbulenzarme Zulufteinbringung in Komfortbereiche.\nPerforiertes Ausblasfeld mit innen liegendem Luftverteilmechanismus zur gleichmäßigen Luftverteilung.\nVariable Baulängen von 500-2000 mm\nBaubreiten 100 mm, 150 mm oder quadratisch 600 x 600 mm\nHöhenverstellbarer Anschlusskasten (Stellfuß)"]
[]
[]
["technische Vorgaben",null,null,null,null,"Raumdaten"]
["Luftvolumenstrom","V·SUP",{"$f":"Auslegung!D15","v":150},"m³/h",null,"Raumhöhe",{"$f":"Auslegung!D27","v":3},"m"]
["Temperatur Zuluft","tZUL",{"$f":"Auslegung!D23","v":24},"°C",null,"Raumbreite ",{"$f":"Auslegung!D30","v":3},"m"]
["Temperatur Raum","tRAUM",{"$f":"Auslegung!D24","v":26},"°C",null,"Raumlänge",{"$f":"Auslegung!D29","v":5},"m"]
[null,null,null,null,null,"Nutzungsart",{"$f":"Auslegung!D31","v":"Einzelbüro"}]
[]
["technische Daten",null,{"$f":"IF(B10=500,\"Zuluft/Abluft\",\"Zuluft\")","v":"Zuluft"}]
["Druckverlust","Dp",{"$f":"Auslegung!D89","v":35.892404574344745},"Pa"]
[{"$f":"Auslegung!A90","v":"Austrittsgeschwindigkeit"},"v0",{"$f":"Auslegung!D90","v":0.27777777777777779},"m"]
["Schallleistungspegel","LWA",{"$f":"Auslegung!D91","v":37.56495306205742},"dB(A)"]
[{"$f":"CONCATENATE(\"Schalldruckpegel in \",Auslegung!D56,\" m Abstand\")","v":"Schalldruckpegel in 3 m Abstand"},"LPA",{"$f":"Auslegung!D94","v":32.450926483031722},"dB(A)"]
[]
[]
[]
["Oktavspektrum ","f [Hz]",125,250,500,1000,2000,4000,8000]
[null,"LW_Okt",{"$f":"Auslegung!D98","v":37.473288828537463},{"$f":"Auslegung!D99","v":36.182114141210832},{"$f":"Auslegung!D100","v":36.741253192640727},{"$f":"Auslegung!D101","v":32.031777450311822},{"$f":"Auslegung!D102","v":27.57659934943403},{"$f":"Auslegung!D103","v":23.120951260653545},{"$f":"Auslegung!D104","v":22.188289103814615}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,1,"Sichtbare Länge",null,{"$f":"Grunddaten!$N$22","v":1020},"mm"]
[null,null,null,null,2,"Sichtbare Breite",null,{"$f":"Grunddaten!$O$22","v":170},"mm"]
[null,null,null,null,3,"Länge Anschlusskasten",null,{"$f":"Grunddaten!$K$22","v":1000},"mm"]
[null,null,null,null,4,"Höhe Anschlusskasten",null,{"$f":"Grunddaten!$M$22","v":160},"mm"]
[null,null,null,null,5,"Gesamthöhe",null,{"$f":"Grunddaten!$M$22","v":160},"mm"]
[null,null,null,null,6,"Stutzendurchmesser",null,{"$f":"Grunddaten!$P$22","v":98},"mm"]
[null,null,null,null,7,"Stutzenabstand",null,{"$f":"Grunddaten!$Q$22","v":498.25},"mm"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,7,"Stutzenabstand",{"$f":"Grunddaten!$Q$22","v":498.25},"mm"]

{"sheet":"Grunddaten","index":7,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Typ",null,null,"Nennbreite","spez.Volumenstrom","Austrittsgeschwindigkeit","Durchmesser Anschluss","Anzahl Stutzen","Anströmgeschwindigkeit","Druckverlust","Länge AK","Breite AK","Höhe AK","Sichtlänge","Sichtbreite","Durchmesser Stutzen","Abstand Stutzen",null,null,null,null,"Identnummer","Bruttopreis"]
[null,null,null,"l","V°spez","v_in","d","n","v","Dp","L_AK","B_AK","H_AK","L","B","D","x"]
[null,null,null,"mm","m³/(h·Walze)","m/s","mm","-","m/s","Pa","mm","mm","mm","mm","mm","mm","mm"]
["LBQ","ZUL",{"$f":"CONCATENATE(A4,D4)","v":"LBQ100"},100,{"$f":"Auslegung!$D$15/Auslegung!$D$13*1000","v":150},{"$f":"Auslegung!$D$15/(D4*Auslegung!$D$13*10^-6)/3600","v":0.41666666666666674},100,{"$f":"Auslegung!$D$16","v":1},{"$f":"Auslegung!$D$15/(PI()/4*(Grunddaten!G4/1000)^2*3600)/H4","v":5.3051647697298439},{"$f":"Dp!F5","v":41.694814104921875},{"$f":"Auslegung!$D$13","v":1000},100,160,{"$f":"K4+20","v":1020},120,{"$f":"G4-2","v":98},{"$f":"(K4-3.5)/(Auslegung!$D$16+1)","v":498.25}]
["LBQ","ZUL",{"$f":"CONCATENATE(A5,D5)","v":"LBQ150"},150,{"$f":"Auslegung!$D$15/Auslegung!$D$13*1000","v":150},{"$f":"Auslegung!$D$15/(D5*Auslegung!$D$13*10^-6)/3600","v":0.27777777777777779},100,{"$f":"Auslegung!$D$16","v":1},{"$f":"Auslegung!$D$15/(PI()/4*(Grunddaten!G5/1000)^2*3600)/H5","v":5.3051647697298439},{"$f":"Dp!F6","v":35.892404574344745},{"$f":"Auslegung!$D$13","v":1000},150,160,1020,170,{"$f":"G5-2","v":98},{"$f":"(K5-3.5)/(Auslegung!$D$16+1)","v":498.25}]
["LBQ","ZUL","LBQ600x600","600x600",{"$f":"Auslegung!$D$15/Auslegung!$D$13*1000","v":150},{"$f":"Auslegung!D15/(0.6*0.6)/3600","v":0.11574074074074074},100,{"$f":"Auslegung!$D$16","v":1},{"$f":"Auslegung!$D$15/(PI()/4*(Grunddaten!G6/1000)^2*3600)/H6","v":5.3051647697298439},{"$f":"Dp!F7","v":34.012767309309503},600,600,160,620,620,98,{"$f":"(K6-3.5)/(Auslegung!$D$16+1)","v":298.25}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,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,0.35]
["Auswahl:","Zuluft",{"$f":"CONCATENATE(Auslegung!D8,Auslegung!$D$12)","v":"LBQ150"},{"$f":"VLOOKUP($C$22,$C$4:$J$19,D20,FALSE)","v":150},{"$f":"VLOOKUP($C$22,$C$4:$J$19,E20,FALSE)","v":150},{"$f":"VLOOKUP($C$22,$C$4:$J$19,F20,FALSE)","v":0.27777777777777779},{"$f":"VLOOKUP($C$22,$C$4:$J$19,G20,FALSE)","v":100},null,{"$f":"VLOOKUP($C$22,$C$4:$J$19,I20,FALSE)","v":5.3051647697298439},{"$f":"VLOOKUP($C$22,$C$4:$J$19,J20,FALSE)","v":35.892404574344745},{"$f":"VLOOKUP($C$22,$C$4:$K$19,K20,FALSE)","v":1000},{"$f":"VLOOKUP($C$22,$C$4:$N$19,L20,FALSE)","v":150},{"$f":"VLOOKUP($C$22,$C$4:$N$19,M20,FALSE)","v":160},{"$f":"VLOOKUP($C$22,$C$4:$N$19,N20,FALSE)","v":1020},{"$f":"VLOOKUP($C$22,$C$4:$O$19,O20,FALSE)","v":170},{"$f":"VLOOKUP($C$22,$C$4:$U$19,P20,FALSE)","v":98},498.25,0,0,0,0,{"$f":"VLOOKUP($C$22,$C$4:$V$19,V20,FALSE)","v":0},{"$f":"VLOOKUP($C$22,$C$4:$W$19,W20,FALSE)","v":0}]
[null,null,null,null,null,{"$f":"IF(D22=\"600x600\",(F21*3600*0.6^2),F21*3600*(D22*Auslegung!$D$13*10^-6))","v":189}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"offen",null,"geschlossen",null,"ZUL geschlossen, ABL offen"]
[null,null,"Stand:","2020-10-30"]
[]
[]
[]
[]
[]
[null,null,null,null,1]
[null,null,null,null,2]
[null,null,null,null,3]
[null,null,null,null,4]

{"sheet":"Lw","index":8,"n_rows":91,"n_cols":28,"rows_kept":91,"cut":false,"hidden":true,"merged":[[90,0,90,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[85,0,85,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[84,0,84,1],[1,26,1,27],[73,0,73,1],[40,1,40,7],[21,1,21,21],[65,0,65,2],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[72,0,72,1]]}
[]
["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,null,"Konstanten Berechnung Dp"]
["K1",50.094616897244698,0.34857116621405648,-33.885637509275846,-95.589930491496133,-26.137760447983524,0.29792907723290252,17.740872987198717,36.847675304529638,15.198757079974307,-3.9048183624684407,17.573674864770091,25.17970643412912,40.430519793232065,40.971990179292092,49.614457054704232,50.37111250906964,56.981333936418139,58.498994428454949,42.611022414085987,25.396716067029715,22.028895108204072,null,null,null,null,"K011",1.5683959462046119E-4]
["K2",-57.707657111493226,-23.818597477629048,15.974491801138722,46.186737412071302,-5.7190376404923748,-21.61615815400086,-39.894286120779775,-52.226893114018758,-42.79050751005223,-30.947455095058359,-45.501454962137984,-57.362213645565824,-72.081495639317964,-68.943422508686538,-70.321109457589046,-66.068869115761558,-61.773912162474488,-52.99221624970442,-36.928238056376998,-21.640208584891784,-15.251080562988989,null,null,null,null,"K012",2.1406521356411474]
["K3",-122.19465500885298,-60.655601524469603,38.024145009203558,106.27631222242434,-8.8012138651193617,-27.905035691484716,-82.724167749100204,-112.14908109277061,-82.177389342224984,-43.694054421026657,-55.070421319776194,-95.705067139468227,-138.60503848160786,-130.67739055941141,-134.16725228591415,-133.79396403840298,-129.72608002939216,-116.16859237721947,-92.16763748125372,-65.736046012881232,-48.034582120735699,null,null,null,null,"K013",0.98518554979317252]
["K4",106.32070068997632,59.665199620365229,-7.7283246554073006,-49.843431571777394,32.010490072304627,50.986018401575215,87.083884928933898,107.69695133815038,89.707505369967507,70.508663955816715,86.559208780233234,114.5303548238501,143.90677975286459,136.75808794872935,134.40113396271468,127.14287110651951,115.75898854418574,95.938830736488953,69.124102014876115,44.75469141147866,31.309695091663443,null,null,null,null,"K014",2.0217406552869268]
["K5",4.9594178484260771,6.1169864580643054,0.4242401326557893,4.7696207213137685,5.1787951778023285,4.5297998003863444,7.4732736069786316,6.66084782866929,8.6642786089012276,7.1897326644722872,4.733615667473984,5.5112303719189004,6.1621482020412301,5.0022419089360071,4.5863985709330901,4.4818718117097323,3.5405907752089019,3.0915407941807382,4.4507700119379949,5.2343031777099132,4.6480317366218333]
["Hz",100,125,160,200,250,315,400,500,630,800,1000,1250,1600,2000,2500,3150,4000,5000,6300,8000,10000]
["K1",-7.4341723591356272,-8.9950687905815947,-9.3294232294110184,-9.5262759626373033,-9.3842150112861571,-10.496542512125949,-13.180584563453285,-15.174407102351722,-18.03078227066835,-19.417276628970246,-19.270300015222187,-19.137279550181756,-19.602313862877498,-17.323322386257978,-15.091121311365068,-11.422804924728544,-5.5466887670055023,-0.24919271589398195,3.5630099481082693,5.7597585982307287,6.6174198907680593]
["K2",-4.2094479166730085,-5.3557361225697475,-5.2010009419534855,-4.46656642009442,-3.7307323327859603,-4.2666811488173808,-5.8699231232673768,-7.1543134538818975,-9.5555060607872235,-10.75919089926434,-11.029878759671229,-11.309085050059803,-11.610653189949225,-10.339425479782149,-8.8648828796901409,-6.3443212553142185,-2.1854096381153432,1.7313816220233775,4.7077251913732034,6.4313115733408424,7.1416849545540115]
["K3",8.0319746973029478,9.1511639013172186,9.7912089192936573,10.811419042029604,11.341112968304905,12.419610782507158,14.711999929036375,16.321447979040649,18.065961653506122,18.874616328661521,18.390576933477764,17.918278995537079,18.29166027460381,16.255143175124989,14.48986676694433,11.686240551457706,7.3165735264425127,3.5446114945163658,0.98795972430410384,-0.47679586101218013,-1.0112195146469616]
["K4",14.742716609995446,16.915465894208761,18.195080395995628,20.257052049613794,21.343840348673087,23.46359999367801,27.94800947169503,31.089176093416448,34.447803177460059,36.000522125221032,35.025778339368856,34.073983321876526,34.802550396260735,30.811682493068247,27.369394483621942,21.910495442521434,13.412909272167882,6.0926272332315881,1.145612401053919,-1.6877906999326313,-2.7178455184872519]
[]
[]
[]
[]
[]
[]
[]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[]
[null,"Terzfrequenzband fm [Hz]"]
[null,100,125,160,200,250,315,400,500,630,800,1000,1250,1600,2000,2500,3150,4000,5000,6300,8000,10000]
[{"$f":"Grunddaten!C4","v":"LBQ100"},{"$f":"B25+1.5","v":17.670374130951533},{"$f":"C25+1.5","v":17.190580281918876},19.187525468594025,20.237147935238191,21.851641292654953,27.409236492930681,30.312638545247623,30.874454515267928,29.517081779316541,29.796013501187428,28.949521729128762,27.125625473133049,26.889546188988142,25.408954735269056,23.611750726747928,22.291993234435878,20.670614345536663,18.955596665485071,17.798488236652773,17.46337760251329,18.161295342972956,{"$f":"10*LOG(10^(0.1*B24)+10^(0.1*C24)+10^(0.1*D24)+10^(0.1*E24)+10^(0.1*F24)+10^(0.1*G24)+10^(0.1*H24)+10^(0.1*I24)+10^(0.1*J24)+10^(0.1*K24)+10^(0.1*L24)+10^(0.1*M24)+10^(0.1*N24)+10^(0.1*O24)+10^(0.1*P24)+10^(0.1*Q24)+10^(0.1*R24)+10^(0.1*S24)+10^(0.1*T24)+10^(0.1*U24)+10^(0.1*V24))","v":39.064953062057413}]
[{"$f":"Grunddaten!C5","v":"LBQ150"},{"$f":"B$3+B$4*LOG(Grunddaten!$E$5)+Lw!B$5*LOG(Grunddaten!$I$5)+Lw!B$6*LOG(Grunddaten!$J$5)+Lw!B$7*LOG(Auslegung!$D$13)","v":16.170374130951533},{"$f":"C$3+C$4*LOG(Grunddaten!$E$5)+Lw!C$5*LOG(Grunddaten!$I$5)+Lw!C$6*LOG(Grunddaten!$J$5)+Lw!C$7*LOG(Auslegung!$D$13)","v":15.690580281918876},{"$f":"D$3+D$4*LOG(Grunddaten!$E$5)+Lw!D$5*LOG(Grunddaten!$I$5)+Lw!D$6*LOG(Grunddaten!$J$5)+Lw!D$7*LOG(Auslegung!$D$13)","v":17.687525468594025},{"$f":"E$3+E$4*LOG(Grunddaten!$E$5)+Lw!E$5*LOG(Grunddaten!$I$5)+Lw!E$6*LOG(Grunddaten!$J$5)+Lw!E$7*LOG(Auslegung!$D$13)","v":18.737147935238191},{"$f":"F$3+F$4*LOG(Grunddaten!$E$5)+Lw!F$5*LOG(Grunddaten!$I$5)+Lw!F$6*LOG(Grunddaten!$J$5)+Lw!F$7*LOG(Auslegung!$D$13)","v":20.351641292654953},{"$f":"G$3+G$4*LOG(Grunddaten!$E$5)+Lw!G$5*LOG(Grunddaten!$I$5)+Lw!G$6*LOG(Grunddaten!$J$5)+Lw!G$7*LOG(Auslegung!$D$13)","v":25.909236492930681},{"$f":"H$3+H$4*LOG(Grunddaten!$E$5)+Lw!H$5*LOG(Grunddaten!$I$5)+Lw!H$6*LOG(Grunddaten!$J$5)+Lw!H$7*LOG(Auslegung!$D$13)","v":28.812638545247623},{"$f":"I$3+I$4*LOG(Grunddaten!$E$5)+Lw!I$5*LOG(Grunddaten!$I$5)+Lw!I$6*LOG(Grunddaten!$J$5)+Lw!I$7*LOG(Auslegung!$D$13)","v":29.374454515267928},{"$f":"J$3+J$4*LOG(Grunddaten!$E$5)+Lw!J$5*LOG(Grunddaten!$I$5)+Lw!J$6*LOG(Grunddaten!$J$5)+Lw!J$7*LOG(Auslegung!$D$13)","v":28.017081779316541},{"$f":"K$3+K$4*LOG(Grunddaten!$E$5)+Lw!K$5*LOG(Grunddaten!$I$5)+Lw!K$6*LOG(Grunddaten!$J$5)+Lw!K$7*LOG(Auslegung!$D$13)","v":28.296013501187428},{"$f":"L$3+L$4*LOG(Grunddaten!$E$5)+Lw!L$5*LOG(Grunddaten!$I$5)+Lw!L$6*LOG(Grunddaten!$J$5)+Lw!L$7*LOG(Auslegung!$D$13)","v":27.449521729128762},{"$f":"M$3+M$4*LOG(Grunddaten!$E$5)+Lw!M$5*LOG(Grunddaten!$I$5)+Lw!M$6*LOG(Grunddaten!$J$5)+Lw!M$7*LOG(Auslegung!$D$13)","v":25.625625473133049},{"$f":"N$3+N$4*LOG(Grunddaten!$E$5)+Lw!N$5*LOG(Grunddaten!$I$5)+Lw!N$6*LOG(Grunddaten!$J$5)+Lw!N$7*LOG(Auslegung!$D$13)","v":25.389546188988142},{"$f":"O$3+O$4*LOG(Grunddaten!$E$5)+Lw!O$5*LOG(Grunddaten!$I$5)+Lw!O$6*LOG(Grunddaten!$J$5)+Lw!O$7*LOG(Auslegung!$D$13)","v":23.908954735269056},{"$f":"P$3+P$4*LOG(Grunddaten!$E$5)+Lw!P$5*LOG(Grunddaten!$I$5)+Lw!P$6*LOG(Grunddaten!$J$5)+Lw!P$7*LOG(Auslegung!$D$13)","v":22.111750726747928},{"$f":"Q$3+Q$4*LOG(Grunddaten!$E$5)+Lw!Q$5*LOG(Grunddaten!$I$5)+Lw!Q$6*LOG(Grunddaten!$J$5)+Lw!Q$7*LOG(Auslegung!$D$13)","v":20.791993234435878},{"$f":"R$3+R$4*LOG(Grunddaten!$E$5)+Lw!R$5*LOG(Grunddaten!$I$5)+Lw!R$6*LOG(Grunddaten!$J$5)+Lw!R$7*LOG(Auslegung!$D$13)","v":19.170614345536663},{"$f":"S$3+S$4*LOG(Grunddaten!$E$5)+Lw!S$5*LOG(Grunddaten!$I$5)+Lw!S$6*LOG(Grunddaten!$J$5)+Lw!S$7*LOG(Auslegung!$D$13)","v":17.455596665485071},{"$f":"T$3+T$4*LOG(Grunddaten!$E$5)+Lw!T$5*LOG(Grunddaten!$I$5)+Lw!T$6*LOG(Grunddaten!$J$5)+Lw!T$7*LOG(Auslegung!$D$13)","v":16.298488236652773},{"$f":"U$3+U$4*LOG(Grunddaten!$E$5)+Lw!U$5*LOG(Grunddaten!$I$5)+Lw!U$6*LOG(Grunddaten!$J$5)+Lw!U$7*LOG(Auslegung!$D$13)","v":15.963377602513289},{"$f":"V$3+V$4*LOG(Grunddaten!$E$5)+Lw!V$5*LOG(Grunddaten!$I$5)+Lw!V$6*LOG(Grunddaten!$J$5)+Lw!V$7*LOG(Auslegung!$D$13)","v":16.661295342972956},{"$f":"10*LOG(10^(0.1*B25)+10^(0.1*C25)+10^(0.1*D25)+10^(0.1*E25)+10^(0.1*F25)+10^(0.1*G25)+10^(0.1*H25)+10^(0.1*I25)+10^(0.1*J25)+10^(0.1*K25)+10^(0.1*L25)+10^(0.1*M25)+10^(0.1*N25)+10^(0.1*O25)+10^(0.1*P25)+10^(0.1*Q25)+10^(0.1*R25)+10^(0.1*S25)+10^(0.1*T25)+10^(0.1*U25)+10^(0.1*V25))","v":37.564953062057413}]
[{"$f":"Grunddaten!C6","v":"LBQ600x600"},{"$f":"B$9+B$10*LOG(Auslegung!$D$15)+B$11*LOG(Grunddaten!$I$6)+B$12*LOG(Grunddaten!$J$6)","v":11.807011348147849},{"$f":"C$9+C$10*LOG(Auslegung!$D$15)+C$11*LOG(Grunddaten!$I$6)+C$12*LOG(Grunddaten!$J$6)","v":11.890636320259059},{"$f":"D$9+D$10*LOG(Auslegung!$D$15)+D$11*LOG(Grunddaten!$I$6)+D$12*LOG(Grunddaten!$J$6)","v":14.316750934890624},{"$f":"E$9+E$10*LOG(Auslegung!$D$15)+E$11*LOG(Grunddaten!$I$6)+E$12*LOG(Grunddaten!$J$6)","v":19.615642196626435},{"$f":"F$9+F$10*LOG(Auslegung!$D$15)+F$11*LOG(Grunddaten!$I$6)+F$12*LOG(Grunddaten!$J$6)","v":23.407384436095505},{"$f":"G$9+G$10*LOG(Auslegung!$D$15)+G$11*LOG(Grunddaten!$I$6)+G$12*LOG(Grunddaten!$J$6)","v":25.157082390380406},{"$f":"H$9+H$10*LOG(Auslegung!$D$15)+H$11*LOG(Grunddaten!$I$6)+H$12*LOG(Grunddaten!$J$6)","v":27.514041090305891},{"$f":"I$9+I$10*LOG(Auslegung!$D$15)+I$11*LOG(Grunddaten!$I$6)+I$12*LOG(Grunddaten!$J$6)","v":28.702775800226405},{"$f":"J$9+J$10*LOG(Auslegung!$D$15)+J$11*LOG(Grunddaten!$I$6)+J$12*LOG(Grunddaten!$J$6)","v":27.029647686021182},{"$f":"K$9+K$10*LOG(Auslegung!$D$15)+K$11*LOG(Grunddaten!$I$6)+K$12*LOG(Grunddaten!$J$6)","v":25.988065911791026},{"$f":"L$9+L$10*LOG(Auslegung!$D$15)+L$11*LOG(Grunddaten!$I$6)+L$12*LOG(Grunddaten!$J$6)","v":23.702259742080464},{"$f":"M$9+M$10*LOG(Auslegung!$D$15)+M$11*LOG(Grunddaten!$I$6)+M$12*LOG(Grunddaten!$J$6)","v":21.427618860248668},{"$f":"N$9+N$10*LOG(Auslegung!$D$15)+N$11*LOG(Grunddaten!$I$6)+N$12*LOG(Grunddaten!$J$6)","v":21.692837655533637},{"$f":"O$9+O$10*LOG(Auslegung!$D$15)+O$11*LOG(Grunddaten!$I$6)+O$12*LOG(Grunddaten!$J$6)","v":19.149694216579768},{"$f":"P$9+P$10*LOG(Auslegung!$D$15)+P$11*LOG(Grunddaten!$I$6)+P$12*LOG(Grunddaten!$J$6)","v":18.038987943100587},{"$f":"Q$9+Q$10*LOG(Auslegung!$D$15)+Q$11*LOG(Grunddaten!$I$6)+Q$12*LOG(Grunddaten!$J$6)","v":16.799412808576484},{"$f":"R$9+R$10*LOG(Auslegung!$D$15)+R$11*LOG(Grunddaten!$I$6)+R$12*LOG(Grunddaten!$J$6)","v":15.543747793252827},{"$f":"S$9+S$10*LOG(Auslegung!$D$15)+S$11*LOG(Grunddaten!$I$6)+S$12*LOG(Grunddaten!$J$6)","v":15.418951232632809},{"$f":"T$9+T$10*LOG(Auslegung!$D$15)+T$11*LOG(Grunddaten!$I$6)+T$12*LOG(Grunddaten!$J$6)","v":16.278090922208335},{"$f":"U$9+U$10*LOG(Auslegung!$D$15)+U$11*LOG(Grunddaten!$I$6)+U$12*LOG(Grunddaten!$J$6)","v":16.82425500309613},{"$f":"V$9+V$10*LOG(Auslegung!$D$15)+V$11*LOG(Grunddaten!$I$6)+V$12*LOG(Grunddaten!$J$6)","v":17.262782190170309},{"$f":"10*LOG(10^(0.1*B26)+10^(0.1*C26)+10^(0.1*D26)+10^(0.1*E26)+10^(0.1*F26)+10^(0.1*G26)+10^(0.1*H26)+10^(0.1*I26)+10^(0.1*J26)+10^(0.1*K26)+10^(0.1*L26)+10^(0.1*M26)+10^(0.1*N26)+10^(0.1*O26)+10^(0.1*P26)+10^(0.1*Q26)+10^(0.1*R26)+10^(0.1*S26)+10^(0.1*T26)+10^(0.1*U26)+10^(0.1*V26))","v":35.835530291153901}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Oktav-Frequenz fOkt [Hz]",null,null,null,null,null,null,"SLWA "]
[null,125,250,500,1000,2000,4000,8000,"Summe"]
[{"$f":"A24","v":"LBQ100"},{"$f":"10*LOG(10^(0.1*B24)+10^(0.1*C24)+10^(0.1*D24))","v":22.873288828537465},{"$f":"10*LOG(10^(0.1*E24)+10^(0.1*F24)+10^(0.1*G24))","v":29.082114141210837},{"$f":"10*LOG(10^(0.1*H24)+10^(0.1*I24)+10^(0.1*J24))","v":35.041253192640724},{"$f":"10*LOG(10^(0.1*K24)+10^(0.1*L24)+10^(0.1*M24))","v":33.531777450311814},{"$f":"10*LOG(10^(0.1*N24)+10^(0.1*O24)+10^(0.1*P24))","v":30.276599349434036},{"$f":"10*LOG(10^(0.1*Q24)+10^(0.1*R24)+10^(0.1*S24))","v":25.620951260653545},{"$f":"10*LOG(10^(0.1*T24)+10^(0.1*U24)+10^(0.1*V24))","v":22.58828910381461},{"$f":"10*LOG(10^(0.1*B43)+10^(0.1*C43)+10^(0.1*D43)+10^(0.1*E43)+10^(0.1*F43)+10^(0.1*G43)+10^(0.1*H43))","v":39.06495306205742}]
[{"$f":"A25","v":"LBQ150"},{"$f":"10*LOG(10^(0.1*B25)+10^(0.1*C25)+10^(0.1*D25))","v":21.373288828537461},{"$f":"10*LOG(10^(0.1*E25)+10^(0.1*F25)+10^(0.1*G25))","v":27.582114141210834},{"$f":"10*LOG(10^(0.1*H25)+10^(0.1*I25)+10^(0.1*J25))","v":33.541253192640724},{"$f":"10*LOG(10^(0.1*K25)+10^(0.1*L25)+10^(0.1*M25))","v":32.031777450311822},{"$f":"10*LOG(10^(0.1*N25)+10^(0.1*O25)+10^(0.1*P25))","v":28.776599349434029},{"$f":"10*LOG(10^(0.1*Q25)+10^(0.1*R25)+10^(0.1*S25))","v":24.120951260653545},{"$f":"10*LOG(10^(0.1*T25)+10^(0.1*U25)+10^(0.1*V25))","v":21.088289103814613},{"$f":"10*LOG(10^(0.1*B44)+10^(0.1*C44)+10^(0.1*D44)+10^(0.1*E44)+10^(0.1*F44)+10^(0.1*G44)+10^(0.1*H44))","v":37.56495306205742}]
["LBQ600x600",17.606805582603762,28.051973448939229,32.57814582280777,28.867606194901363,24.676825237989227,20.738005041313578,21.578171347803785,35.835530291153901]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[0,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[{"$f":"A39","v":0},4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,4.7712125471966242,13.222192947339193]
[null,2,3,4,5,6,7,8,9]
["Auswahl:",-16.100000000000001,-8.6,-3.2,0,1.2,1,-1.1000000000000001]
[{"$f":"Grunddaten!C22","v":"LBQ150"},{"$f":"IF($I$61=\"<25\",\"\",VLOOKUP($A$61,$A$43:$I$58,B$59,FALSE))","v":21.373288828537461},{"$f":"IF($I$61=\"<25\",\"\",VLOOKUP($A$61,$A$43:$I$58,C$59,FALSE))","v":27.582114141210834},33.541253192640724,32.031777450311822,28.776599349434029,24.120951260653545,21.088289103814613,{"$f":"IF(VLOOKUP($A$61,$A$43:$I$58,I$59,FALSE)<25,\"<25\",VLOOKUP($A$61,$A$43:$I$58,I$59,FALSE))","v":37.56495306205742}]
[null,{"$f":"B61-B60","v":37.473288828537463},{"$f":"C61-C60","v":36.182114141210832},36.741253192640727,32.031777450311822,27.57659934943403,23.120951260653545,22.188289103814615]
[]
[]
[]
["T[s] nach VDI 2081",null,null,null,"Nachhallzeit","Richtungsfaktor","Raumvolumen","äqu. Absorptionsfläche"]
["Raumart",null,"s",null,"t","Q","V","A"]
["Einzelbüro",null,0.5,null,"s",null,"m³","m²Sabine"]
["Großraumbüro",null,0.5,{"$f":"Auslegung!D31","v":"Einzelbüro"},{"$f":"VLOOKUP(D69,Lw!$A$68:$C$91,3,FALSE)","v":0.5},4,{"$f":"Auslegung!D27*Auslegung!D29*Auslegung!D30","v":45},{"$f":"0.163*G69/E69","v":14.67}]
["Werkstätten",null,1.5]
["Ruheraum, Pausenraum",null,1]
["Untersuchungsraum Krankenhaus",null,2]
["Rundfunk-, Fernsehstudio",null,0.5]
["Chemielabor",null,2]
["Wasch- und WC-Raum, Umkleide",null,2]
["Schwimmbad",null,2]
["EDV-Raum",null,1.5]
["Konzertsaal",null,1.5]
["Lesesaal",null,1]
["Museum",null,1.5]
["Küche",null,1.5]
["Theater, Kino",null,1]
["Klassen- Seminarraum",null,1]
["Gaststätte",null,1]
["kein Typ",null,"x"]
["Konferenzraum",null,1]
["Hotelzimmer",null,0.5]
["Hörsaal",null,1]
["Bettenzimmer Krankenhaus",null,1]
["Verkaufsraum",null,1]
["Sporthalle",null,2]

{"sheet":"Dt","index":9,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Frequenzband","fm_Okt","[Hz]",63,125,250,500,1000,2000,4000,8000]
[null,null,{"$f":"Grunddaten!C4","v":"LBQ100"}]
[null,null,{"$f":"Grunddaten!C5","v":"LBQ150"}]
[null,null,{"$f":"Grunddaten!C6","v":"LBQ600x600"}]
[null,null,{"$f":"Grunddaten!C7","v":0}]
[null,null,{"$f":"Grunddaten!C8","v":0}]
[null,null,{"$f":"Grunddaten!C9","v":0}]
[null,null,{"$f":"Grunddaten!C10","v":0}]
[null,null,{"$f":"Grunddaten!C11","v":0}]
[null,null,null,2,3,4,5,6,7,8,9]
[]
[null,null,{"$f":"Grunddaten!C22","v":"LBQ150"},{"$f":"VLOOKUP($C$12,$C$2:$K$9,D10,FALSE)","v":0},{"$f":"VLOOKUP($C$12,$C$2:$K$9,E10,FALSE)","v":0},0,0,0,0,0,0]

{"sheet":"v_x","index":10,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["mittlere Untertemperatur","DTm","K",{"$f":"Auslegung!D24-Auslegung!D23","v":2}]
[]
["Berechnung Geschwindigkeit entlang der Lauflänge"]
[]
["vx = K1 * x^(K2)"]
[]
["Berechnung Konstanten"]
[]
["K1",{"$f":"IF($D$1>=0,0.667*Auslegung!$D$90+0.0667,\"\")","v":0.2519777777777778},null,"y = 0,667x + 0,0667"]
["K2",{"$f":"-1.9587*Auslegung!$D$90-0.0348","v":-0.57888333333333342},null,"y = -1,9587x - 0,0348",null,null,"Basis:","F:\\daten_EK\\EMCOAIR\\LBQ\\Auswertung_Strahlgeschwindigkeit_130312_3"]
[]
["Lauflänge","Geschwindigkeit"]
["x","v"]
["m","m/s"]
[0.5,{"$f":"B16","v":0.2519777777777778}]
[1,{"$f":"$B$9*A16^$B$10","v":0.2519777777777778}]
[1.5,0.19926267055078764]
[2,0.16869452750740141]
[2.5,0.14825228738971702]
[3,0.13340272445800028]
[3.5,0.12201418361589422]
[{"$f":"Auslegung!$D$29","v":5},9.9252203085765142E-2]
[]
[]
["Berechnung Turbulenzgrad entlang der Lauflänge"]
[]
["TU= K1 * x^(K2)"]
[]
["Berechnung Konstanten"]
[null,null,null,"y = 30,802x + 10,561"]
["K1",{"$f":"IF(D1>=0,30.802*Auslegung!$D$90+10.561,\"\")","v":19.117111111111111},null,"y = 0,5698x - 0,7686"]
["K2",{"$f":"0.5698*Auslegung!$D$90-0.7686","v":-0.61032222222222221},null,null,null,null,"Basis:","F:\\daten_EK\\EMCOAIR\\LBQ\\Auswertung_Strahlgeschwindigkeit_130312_3"]
[]
["Lauflänge","Turbulenzgrad",null,"R² = 0,3587 "]
["x","TU"]
["m","%"]
[{"$f":"A15","v":0.5},{"$f":"$B$31*A37^$B$32","v":29.184184366621317}]
[{"$f":"A16","v":1},{"$f":"$B$31*A38^$B$32","v":19.117111111111111}]
[1.5,14.926220595509255]
[2,12.522670931744734]
[2.5,10.928250310728673]
[3,9.7774264995277047]
[3.5,8.8994967023625318]
[5,7.1585545381620355]
[]
[]
["Berechnung Zugluftrisiko nach ISO 7730"]
["(34-tL)*(vx-0,05)^0,62*(0,37*vx*TU+3,14)"]
[]
["Lauflänge","Zugluftrisiko"]
["x","DR"]
["m","%"]
[{"$f":"A15","v":0.5},{"$f":"(34-(Auslegung!$D$23))*(B15-0.05)^0.62*(0.37*B15*B37+3.14)","v":21.739624944825668}]
[{"$f":"A16","v":1},{"$f":"(34-(Auslegung!$D$23))*(B16-0.05)^0.62*(0.37*B16*B38+3.14)","v":18.258212960094244}]
[1.5,{"$f":"(34-(Auslegung!$D$23))*(B17-0.05)^0.62*(0.37*B17*B39+3.14)","v":13.03957891259752}]
[2,{"$f":"(34-(Auslegung!$D$23))*(B18-0.05)^0.62*(0.37*B18*B40+3.14)","v":10.461966911927602}]
[2.5,{"$f":"(34-(Auslegung!$D$23))*(B19-0.05)^0.62*(0.37*B19*B41+3.14)","v":8.8727922642210491}]
[3,{"$f":"(34-(Auslegung!$D$23))*(B20-0.05)^0.62*(0.37*B20*B42+3.14)","v":7.7651995098871742}]
[3.5,{"$f":"(34-(Auslegung!$D$23))*(B21-0.05)^0.62*(0.37*B21*B43+3.14)","v":6.9313772891186449}]
[5,{"$f":"(34-(Auslegung!$D$23))*(B22-0.05)^0.62*(0.37*B22*B44+3.14)","v":5.2620054265194689}]

{"sheet":"Eingabe","index":11,"n_rows":52,"n_cols":18,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,1,"Produktgruppe emcoair"]
[null,null,null,"LBQ","Artikel"]
[null,null,null,null,100,"Breite","100 mm"]
[null,null,null,null,150,null,"150 mm"]
[null,null,null,null,600,null,"600 mm"]
[null,null,null,null,null,"0500","Länge","500 - 2000 mm"]
[null,null,null,null,null,null,null,600]
[null,null,null,null,null,null,1,"Stutzenanzahl","1 Stutzen"]
[null,null,null,null,null,null,2,null,"2 Stutzen"]
[null,null,null,null,null,null,3,null,"3 Stutzen"]
[null,null,null,null,null,null,null,"Z","Rahmenprofil","Z Profil"]
[null,null,null,null,null,null,null,"L",null,"L Profil"]
[null,null,null,null,null,null,null,null,"V","Werkstoff Luftdurchlass","Stahl verzinkt"]
[null,null,null,null,null,null,null,null,"E",null,"Edelstahl V2A \"1.4301\""]
[null,null,null,null,null,null,null,null,"S",null,"Edelstahl V4A \"1.4571\""]
[null,null,null,null,null,null,null,null,null,7012,"Oberfläche Luftdurchlass","RAL 7012 matt"]
[null,null,null,null,null,null,null,null,null,"xxxx",null,"RAL ****"]
[null,null,null,null,null,null,null,null,null,"SSSS",null,"Sonderlackierung"]
[null,null,null,null,null,null,null,null,null,null,1,"Anschlusskasten","mit Anschlusskasten"]
[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,"V","Werkstoff AK","Stahl verzinkt"]
[null,null,null,null,null,null,null,null,null,null,null,null,"V","Werkstoff AK","Stahl verzinkt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Drossel","mit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"ohne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"integrierte Höhenverstellung","mit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"ohne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Ausführung","Einzelposition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"Bandanfang"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"Bandmitte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"Bandende"]
[]
[]
[]
[null,null,{"$f":"C2","v":1},{"$f":"D3","v":"LBQ"},{"$f":"E4","v":100},{"$f":"F7","v":"0500"},{"$f":"G9","v":1},{"$f":"H12","v":"Z"},{"$f":"I14","v":"V"},{"$f":"J17","v":7012},{"$f":"K20","v":1},{"$f":"L22","v":"V"},{"$f":"M23","v":"V"},{"$f":"N24","v":1},{"$f":"O26","v":1},{"$f":"P28","v":1}]
[null,null,"* Anschlusskasten mit Mengeneinstellung auf Anfrage",null,null,null,null,","]
[]
[]
[]
["Schwarz","S"]
["weiß","W"]
["naturfarbig eloxiert","E6C0"]
["weiß (RAL 9010) bepulvert",9010]
["ohne Drossel",0]
["frontseitig bedienbare Drossel*",1]
[500,"0500"]
[800,"0800"]
[1000,1000]
[1200,1200]
["Zuluft","Z"]
["Abluft","A"]
["Zuluft/Abluft-Kombination","K"]

{"sheet":"Dp","index":12,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["DP=K011*V^K012+K013*v^K014"]
["Breite",null,null,null,null,"Druckverlust"]
["Breite","Konstante",null,null,null,"Dp"]
["mm","K1","K2","K3","K4","Pa"]
[100,8.9442155868751407E-5,2.4381139561429803,1.7974410994786942,1.5435440628380555,{"$f":"B$5*Grunddaten!$E4^C$5+D$5*Grunddaten!$I4^E$5","v":41.694814104921875}]
[150,1.5683959462046119E-4,2.1406521356411474,0.98518554979317252,2.0217406552869268,{"$f":"B$6*Grunddaten!$E5^C$6+D$6*Grunddaten!$I5^E$6","v":35.892404574344745}]
["600x600",0.16803174059934628,0.95001808899351636,9.4509871455369474E-2,3.0117917125753535,{"$f":"$B$7*Auslegung!D15^C7+$D$7*Grunddaten!I6^Dp!$E$7","v":34.012767309309503}]