{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Deckblatt","nach Art des Betriebes","nach vorh. Installationen","Dichtetabelle","Parametertabelle"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Deckblatt","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,5],[40,1,40,5],[43,1,43,5],[42,1,42,5],[41,1,41,5],[24,1,24,5],[30,1,37,5],[10,1,10,5],[13,1,13,5],[16,1,16,5],[19,1,19,2],[19,3,19,4]]}
[]
[]
[]
[]
[null,"Fettabscheideranlagen"]
[null,"Bemessung nach ÖNORM EN 1825-2"]
[]
[null,"Allgemeines:"]
[]
[null,"Bauherr:"]
[]
[]
[null,"Adresse:"]
[]
[]
[null,"Bauadresse:"]
[]
[]
[null,"Parzellen-Nr.:",null,"KG:",null,"KG Nr.:"]
[]
[]
[null,"Bemessungsgrundlagen:"]
[]
[null,"Betriebsart:"]
[]
[]
[null,"Betriebszeiten:"]
[null,null,"Std/Tag",null,"Tage/Woche"]
[]
[null,"Sonstige Angaben:"]
{"$rows_empty":9}
[null,"Anmerkung:"]
[null,"Der maximale Schmutzwasserabfluss Qs kann entweder"]
[null," 1.) in Abhängigkeit von der Art des Betriebes "]
[null,"oder"]
[null,"2.) in Abhängigkeit von den vorhandenen Installationen"]
[null,"ermittelt werden!"]

{"sheet":"nach Art des Betriebes","index":1,"n_rows":79,"n_cols":18,"rows_kept":79,"cut":false,"hidden":false,"merged":[[28,1,31,13],[22,7,22,8],[25,9,25,10],[25,7,25,8],[26,7,26,8],[36,7,36,8],[39,7,39,8],[39,9,39,10],[26,9,26,10],[27,7,27,8],[27,9,27,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[19,7,19,8],[20,7,20,8],[73,2,73,3],[40,7,40,8],[40,9,40,10],[36,9,36,10],[37,7,37,8],[4,4,4,7],[38,9,38,10],[5,2,5,3],[6,2,6,3],[23,7,23,8],[41,7,41,8],[41,9,41,10],[1,1,3,11],[22,9,22,10],[23,9,23,10],[24,9,24,10],[21,7,21,8],[24,7,24,8],[37,9,37,10],[38,7,38,8]]}
[]
[null,"Fettabscheider -  Bemessung nach ÖNORM EN1825-2 - Berechnung nach Art des Betriebes (ungeachtet der installierten Armaturen und Einrichtungen)",{"$nulls":14},1]
[{"$nulls":16},2]
[{"$nulls":16},3]
[{"$nulls":4},{"$f":"Deckblatt!F5","v":0},{"$nulls":11},4]
[null,null,"Eingabefelder",{"$nulls":13},5]
[null,null,"Ausgabefelder",{"$nulls":13},6]
[{"$nulls":16},7]
[null,"Qs =","(V * F) : (t * 3600)",{"$nulls":13},8]
[{"$nulls":16},9]
[null,"Qs =","maximaler Schmutzwasserabfluss (l/s)",{"$nulls":14},""]
[null,"V =","durchschnittliches tägliches Schmutzwasservolumen"]
[null,"F =","Stoßbelastungsfaktor in Abhängigkeit von der Betriebsart"]
[null,"t =","durchschnittliche tägliche Betriebszeit in Stunden",{"$nulls":13},0]
[]
[null,null,"Küchenbetriebe:    V = M * Vm"]
[null,"M =","Anzahl der täglich produzierten warmen Essensportionen "]
[null,"Vm =","betriebsspezifische Wassermengen je warme Essensportionen"]
[]
[null,"M","Art des Betriebes",{"$nulls":4},"Vm",null,"F"]
[null,"Ess.Port.",{"$nulls":5},"Liter Wasser",null,"Stoßbelastungs-",null,"V","t","Qs"]
[null,"pro Tag","Küchenbetrieb(*):",{"$nulls":4},"je Portion",null,"faktor",null,"[Liter]","[Std]","[l / s]"]
[null,null,"Hotelküche/Gasthaus",{"$nulls":4},100,null,5,null,{"$f":"+B23*H23","v":0},null,{"$f":"IF(M23>0,(+L23*J23)/(M23*3600), )","v":0}]
[null,null,"Spezialitätenrestaurant",{"$nulls":4},50,null,8.5,null,0,null,0]
[null,null,"Krankenhaus",{"$nulls":4},20,null,13,null,0,null,0]
[null,null,"Großküche ",{"$nulls":4},10,null,22,null,0,null,0]
[null,null,"Werksküche / Mensa",{"$nulls":4},5,null,20,null,0,null,0]
[null,null,"Benutzerdefinierte Angabe",{"$nulls":8},0,null,0]
[null,"(*) Die Charakterisierung der Abwässer nach Betrieben entspringt Untersuchungen, die 1987 in Deutschland an 5 Küchenbetrieben unterschiedlicher Kategorie (Bachon 1987) bzw. an 3 Fleischereibetrieben unterschiedlicher Größe durchgeführt wurden (vorgestellt in DWA vormals ATV-DVWK, 2001)"]
[]
[]
[]
[null,null,"Fleischverarbeitungsbetriebe:   V = Mp * Vp"]
[null,"Mp =","tägliche Wurstwarenproduktion (kg/d)"]
[null,"Vp =","betriebsspezifisches Wasservolumen je kg Wurstwaren"]
[]
[null,"Mp","Art des Betriebes",{"$nulls":4},"Vp",null,"F"]
[null,"Fleisch",{"$nulls":5},"Liter Wasser",null,"Stoßbelastungs-",null,"V","t","Qs"]
[null,"kg / Tag","Fleischer, fleischverarbeitender Betrieb",{"$nulls":4},"je kg Wurst",null,"faktor",null,"[Liter]","[Std]","[l / s]"]
[null,null,"bis 5 GV / Woche, bis 500 kg Wurst / Tag",{"$nulls":4},20,null,30,null,{"$f":"+B40*H40","v":0},null,{"$f":"IF(M40>0,(+L40*J40)/(M40*3600), )","v":0}]
[null,null,"bis 10 GV / Woche, bis 1000 kg Wurst / Tag",{"$nulls":4},15,null,35,null,{"$f":"+B41*H41","v":0},null,{"$f":"IF(M41>0,(+L41*J41)/(M41*3600), )","v":0}]
[null,null,"bis 40 GV / Woche, bis 4000 kg Wurst / Tag",{"$nulls":4},10,null,40,null,{"$f":"+B42*H42","v":0},null,{"$f":"IF(M42>0,(+L42*J42)/(M42*3600), )","v":0}]
[]
[null,null,"1 GV = 1 Rind oder 2,5 Schweine"]
[null,null,"Wenn über die tägliche Fleischverarbeitung oder Wurstwarenproduktion keine Angaben vorliegen,"]
[null,null,"kann Mp mit 100 kg Fleisch bzw. Wurst pro GV angenommen werden."]
[null,null,"1 GV pro Woche entsprechen ca. 100 kg Fleisch pro Woche "]
[]
[null,null,"Ermittlung der Nenngröße:"]
[]
[null,"NS =","Qs * ft * fd * fr*fe"]
[]
[null,"NS =","Nenngröße des Abscheiders"]
[null,"Qs =","maximale Schmutzwasserabfluss l/s"]
[null,"ft =","Erschwernisfaktor für die Zuflusstemperatur",{"$nulls":6},"bis 60° C :","ft =",1]
[{"$nulls":9},"ständig oder gelegendlich > 60° C :","ft =",1.3,"ft =",1.3]
[null,"fd =","Dichtefaktor für Fette bzw. Öle ",null,null,null,"Dichte des Fettes < 0,94 g/cm³",null,null,null,"fd =",1]
[null,null,"(siehe ÖNORM EN 1825-2 Seite 14)",null,null,null,"Dichte des Fettes > 0,94 g/cm³",null,null,null,"fd =",1.5,"fd =",1]
[null,"fr =","Erschwernisfaktor für die den Einfluss von Spül- und Reinigungsmitteln"]
[{"$nulls":9},"Kein Einsatz von Spül- und Reinigungsmittel:","fr =",1]
[{"$nulls":9},"Anwendung von Spül- und Reinigungsmitteln:","fr =",1.3]
[{"$nulls":9},"Abwasser aus Krankenhausküchen:","fr >=",1.5,"fr =",1.3]
[null,"fe =","Entsorgungsfaktor",{"$nulls":6},"monatlich","fe =",1]
[{"$nulls":9},"vierteljährlich","fe =",2]
[{"$nulls":9},"halbjährlich","fe =",4,"fe =",4]
[]
[{"$nulls":12},"erforderliche Nenngröße des Fettabscheiders:  NS =",{"$f":"SUM(N23:N28,N40:N42)*N56*N58*N62*N65","v":0}]
[]
[null,null,"Ermittlung des Schlammfanges:"]
[]
[null,null,"100 l Nutzinhalt pro 1 l/s Durchfluss!"]
[null,null,"200 l Nutzinhalt pro 1 l/s Durchfluss bei Schlachthöfen!"]
[]
[null,null,"Küchenbetrieb:",null,"Schlammfangvolumen=",null,{"$f":"SUM(N23:N28)*N56*N58*N62*N65","v":0},"l/s * 0,1 m³     =",{"$nulls":4},{"$f":"+G74*0.1","v":0},"m³"]
[]
[]
[null,null,"Schlachthof::",null,"Schlammfangvolumen=",null,{"$f":"SUM(N40:N42)*N56*N58*N62*N65","v":0},"l/s * 0,2 m³   =",{"$nulls":4},{"$f":"+G77*0.2","v":0},"m³"]
[]
[{"$nulls":11},"erforderliches Schlammfangvolumen  =",{"$f":"M74+M77","v":0},"m³"]

{"sheet":"nach vorh. Installationen","index":2,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[20,2,20,6],[21,2,21,6],[4,4,4,7],[1,1,3,11],[5,2,5,3],[6,2,6,3],[15,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[67,2,67,3],[37,2,37,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[27,2,27,6],[26,2,26,6],[15,8,15,12],[33,2,34,6],[66,2,66,3],[33,8,33,12],[30,2,30,6],[35,2,35,6],[36,2,36,6],[28,2,28,6],[29,2,29,6],[22,2,22,6]]}
[]
[null,"Fettabscheider -  Bemessung nach ÖNORM EN1825-2 - Berechnung nach installierten Amaturen und Einrichtungen (ungeachtet der Art des Betriebes)",{"$nulls":14},1]
[{"$nulls":16},2]
[{"$nulls":16},3]
[{"$nulls":4},{"$f":"Deckblatt!F5","v":0},{"$nulls":11},4]
[null,null,"Eingabefelder",{"$nulls":13},5]
[null,null,"Ausgabefelder",{"$nulls":13},6]
[{"$nulls":16},7]
[null,"Qs =","Summe von (n * qi * Zi(n))",{"$nulls":13},8]
[{"$nulls":16},9]
[null,"Qs =","maximaler Schmutzwasserabfluss (l/s)"]
[null,"n =","Anzahl der Einrichtungsgegenstände"]
[null,"qi =","maximaler Schmutzwasserabfluss des Einrichtungsgegenstandes"]
[null,"Zi(n) =","Gleichzeitigkeitsfaktor für den Einrichtungsgegenstand in Abhängigkeit von n"]
[]
[null,"Anzahl","Kücheneinrichtungsgegenstand",{"$nulls":4},"qi","Zi(n)",{"$nulls":4},"Qs"]
[null,"[ n ]",{"$nulls":5}," [l/s]","n = 1","n = 2","n = 3","n = 4","n >= 5"," [l/s]"]
[null,null,"Kochkessel Auslauf DN25 mm",{"$nulls":4},{"$f":"IF(B18>=1,1,\" \")","v":" "},{"$f":"IF(B18=1,0.45, )","v":0},{"$f":"IF(B18=2,0.31, )","v":0},{"$f":"IF(B18=3,0.25, )","v":0},{"$f":"IF(B18=4,0.21, )","v":0},{"$f":"IF(B18>=5,0.2,  )","v":0},{"$f":"IF(B18>=1,+B18*H18*SUM(I18:M18), )","v":0}]
[null,null,"Kochkessel Auslauf DN50 mm",{"$nulls":4},{"$f":"IF(B19>=1,2,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Kippkessel Auslauf DN70 mm",{"$nulls":4},{"$f":"IF(B20>=1,1,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Kippkessel Auslauf DN100 mm",{"$nulls":4},{"$f":"IF(B21>=1,3,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Spülbecken mit Geruchsverschluss DN40",{"$nulls":4},{"$f":"IF(B22>=1,0.8,\" \")","v":" "},{"$f":"IF(B22=1,0.31, )","v":0},0,0,0,0,0]
[null,null,"Spülbecken mit Geruchsverschluss DN50",{"$nulls":4},{"$f":"IF(B23>=1,1.5,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Spülbecken ohne Geruchsverschluss DN40",{"$nulls":4},{"$f":"IF(B24>=1,2.5,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Spülbecken ohne Geruchsverschluss DN50",{"$nulls":4},{"$f":"IF(B25>=1,4,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Geschirrspülmaschine",{"$nulls":4},{"$f":"IF(B26>=1,2,\" \")","v":" "},{"$f":"IF(B26=1,0.6, )","v":0},{"$f":"IF(B26=2,0.45, )","v":0},{"$f":"IF(B26=3,0.4, )","v":0},{"$f":"IF(B26=4,0.34, )","v":0},0,0]
[null,null,"Kippbratpfanne",{"$nulls":4},{"$f":"IF(B27>=1,1,\" \")","v":" "},{"$f":"IF(B27=1,0.45, )","v":0},{"$f":"IF(B27=2,0.31, )","v":0},{"$f":"IF(B27=3,0.25, )","v":0},{"$f":"IF(B27=4,0.21, )","v":0},0,0]
[null,null,"Bratpfanne",{"$nulls":4},{"$f":"IF(B28>=1,0.1,\" \")","v":" "},{"$f":"IF(B28=1,0.45, )","v":0},{"$f":"IF(B28=2,0.31, )","v":0},{"$f":"IF(B28=3,0.25, )","v":0},{"$f":"IF(B28=4,0.21, )","v":0},0,0]
[null,null,"Hochdruck- oder Dampfstrahlreinigungsgerät",{"$nulls":4},{"$f":"IF(B29>=1,2,\" \")","v":" "},{"$f":"IF(B29=1,0.45, )","v":0},{"$f":"IF(B29=2,0.31, )","v":0},{"$f":"IF(B29=3,0.25, )","v":0},{"$f":"IF(B29=4,0.21, )","v":0},0,0]
[null,null,"Schälgerät",{"$nulls":4},{"$f":"IF(B30>=1,1.5,\" \")","v":" "},{"$f":"IF(B30=1,0.45, )","v":0},{"$f":"IF(B30=2,0.31, )","v":0},{"$f":"IF(B30=3,0.25, )","v":0},{"$f":"IF(B30=4,0.21, )","v":0},0,0,null,null,"ja"]
[null,null,"Gemüsewascheinrichtung",{"$nulls":4},{"$f":"IF(B31>=1,2,\" \")","v":" "},{"$f":"IF(B31=1,0.45, )","v":0},{"$f":"IF(B31=2,0.31, )","v":0},{"$f":"IF(B31=3,0.25, )","v":0},{"$f":"IF(B31=4,0.21, )","v":0},0,0,null,null,"nein"]
[{"$nulls":12},"S Qs [l/s] =",{"$f":"SUM(N18:N31)","v":0}]
[]
[null,"Anzahl","Größe des Auslaufventils",{"$nulls":4},"qi","Zi(n)",{"$nulls":4},"Qs"]
[null,"[ n ]",{"$nulls":5}," [l/s]","n = 1","n = 2","n = 3","n = 4","n >= 5"," [l/s]"]
[null,null,"DN 15",{"$nulls":4},{"$f":"IF(B36>=1,0.5,\" \")","v":" "},{"$f":"IF(B36=1,0.45, )","v":0},{"$f":"IF(B36=2,0.31, )","v":0},{"$f":"IF(B36=3,0.25, )","v":0},{"$f":"IF(B36=4,0.21, )","v":0},{"$f":"IF(B36>=5,0.2,  )","v":0},{"$f":"IF(B36>=1,+B36*H36*SUM(I36:M36), )","v":0}]
[null,null,"DN 20",{"$nulls":4},{"$f":"IF(B37>=1,1,\" \")","v":" "},{"$f":"IF(B37=1,0.45, )","v":0},{"$f":"IF(B37=2,0.31, )","v":0},{"$f":"IF(B37=3,0.25, )","v":0},{"$f":"IF(B37=4,0.21, )","v":0},{"$f":"IF(B37>=5,0.2,  )","v":0},{"$f":"IF(B37>=1,+B37*H37*SUM(I37:M37), )","v":0}]
[null,null,"DN 25",{"$nulls":4},{"$f":"IF(B38>=1,1.7,\" \")","v":" "},{"$f":"IF(B38=1,0.45, )","v":0},{"$f":"IF(B38=2,0.31, )","v":0},{"$f":"IF(B38=3,0.25, )","v":0},{"$f":"IF(B38=4,0.21, )","v":0},{"$f":"IF(B38>=5,0.2,  )","v":0},{"$f":"IF(B38>=1,+B38*H38*SUM(I38:M38), )","v":0}]
[{"$nulls":12},"S Qs [l/s] =",{"$f":"SUM(N36:N38)","v":0}]
[]
[null,null,"Ermittlung der Nenngröße:"]
[]
[null,"NS =","Qs * ft * fd * fr*fe"]
[]
[null,"NS =","Nenngröße des Abscheiders"]
[null,"Qs =","maximale Schmutzwasserabfluss l/s"]
[null,"ft =","Erschwernisfaktor für die Zuflusstemperatur",{"$nulls":6},"bis 60° C :","ft =",1]
[{"$nulls":9},"ständig oder gelegendlich > 60° C :","ft =",1.3,"ft =",1.3]
[null,"fd =","Dichtefaktor für Fette bzw. Öle ",null,null,null,"Dichte des Fettes < 0,94 g/cm³",null,null,null,"fd =",1]
[null,null,"(siehe ÖNORM EN 1825-2 Seite 14)",null,null,null,"Dichte des Fettes > 0,94 g/cm³",null,null,null,"fd =",1.5,"fd =",1]
[null,"fr =","Erschwernisfaktor für die den Einfluss von Spül- und Reinigungsmitteln"]
[{"$nulls":9},"Kein Einsatz von Spül- und Reinigungsmittel:","fr =",1]
[{"$nulls":9},"Anwendung von Spül- und Reinigungsmitteln:","fr =",1.3]
[{"$nulls":9},"Abwasser aus Krankenhausküchen:","fr >=",1.5,"fr =",1.3]
[null,"fe =","Entsorgungsfaktor",{"$nulls":6},"monatlich","fe =",1]
[{"$nulls":9},"vierteljährlich","fe =",2]
[{"$nulls":9},"halbjährlich","fe =",4,"fe =",1]
[]
[{"$nulls":12},"erforderliche Nenngröße des Fettabscheiders:  NS =",{"$f":"SUM(N32+N39)*N48*N50*N54*N57","v":0}]
[]
[null,null,"Ermittlung des Schlammfanges:"]
[]
[null,null,"100 l Nutzinhalt pro 1 l/s Durchfluss!"]
[null,null,"200 l Nutzinhalt pro 1 l/s Durchfluss bei Schlachthöfen!"]
[]
[null,null,"Schlachthof bzw. fleischverarbeitende Betriebe "]
[null,null,"(ja/nein)"]
[null,null,"nein",null,"Schlammfangvolumen=",null,{"$f":"(N32+N39)*N48*N50*N54*N57","v":0},"l/s * 0,1 m³  =",{"$nulls":4},{"$f":"+G68*0.1","v":0},"m³"]
[{"$nulls":4},"Schlammfangvolumen=",null,{"$f":"(N32+N39)*N48*N50*N54*N57","v":0},"l/s * 0,2 m³   =",{"$nulls":4},{"$f":"+G69*0.2","v":0},"m³"]
[]
[{"$nulls":11},"erforderliches Schlammfangvolumen  =",{"$f":"IF(C68=\"ja\",M69,IF(C68=\"nein\",M68,0))","v":0},"m³"]

{"sheet":"Dichtetabelle","index":3,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,36,1],[1,0,1,1]]}
["Fett/Öl","Dichte bei einer Temperatur von 20°C [g/cm³]"]
["Fette/Öle mit Dichte <0,94g/cm³ (Dichtefaktor fd = 1,0) sind  markiert"]
["Anisöl",1]
["Baumwollsamenöl",0.92]
["Butterfett",0.91]
["Erdnussöl","0,91 bis 0,92"]
["Fichtenöl","0,87 bis 0,91"]
["Harzöl","0,87 bis 0,91"]
["Holzöl","0,95 bis 0,97*)"]
["Jojobaöl","0,86 bis 0,90"]
["Kakaobutter","0,89 bis 0,94"]
["Kienöl","0,93 bis 0,94"]
["Kokosöl","0,92 bis 0,93"]
["Leinöl","0,93 bis 0,94"]
["Maisöl",0.92]
["Majoranöl","0,89 bis 0,91"]
["Mohnöl",0.92]
["Oleinsäure","0,89 bis 0,90"]
["Olivenöl",0.91]
["Palmitinsäure",0.84]
["Palmkernöl","0,94 bis 0,95"]
["Palmöl","0,91 bis 0,92"]
["Rapsöl","0,91 bis 0,92"]
["Rizinusöl","0,95 bis 0,97*)"]
["Sesamöl",0.92]
["Sojaöl","0,92 bis 0,93"]
["Sonnenblumenöl","0,92 bis 0,93"]
["Specköl","0,91 bis 0,92"]
["Stearinsäure",0.84]
["Talg",0.92]
["Tierfett","0,85 bis 0,94"]
["Tran","0,89 bis 0,94"]
[]
[]
["*) Bei der Behandlung des Fettes/Öles in einer Abscheideranlage für Fette nach dieser Norm ist besondere Vorsicht geboten."]

{"sheet":"Parametertabelle","index":4,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":true,"merged":[[46,3,46,5],[48,3,48,5],[0,1,0,5],[16,3,16,5],[18,3,18,5],[20,3,20,5],[28,1,28,5],[44,3,44,5]]}
["Art des Betriebes","Fettabscheider ohne Schlammfang"]
["Berechnungsparameter Schlammfanggröße","Berechnungsparameter Nenngröße","Index","Typenbezeichnung","maximale Nenngröße","Nutzinhalt Schlammfang"]
[0,0,0,"zu kleines NS"]
[0.1,1,1,"SW-KFA 2i-EN",2,"0,2 m³"]
[0.2,2,2,"SW-KFA 3i-EN",3,"0,3 m³"]
[0.3,3,3,"SW-KFA 5i-EN",5,"0,5 m³"]
[0.5,5,4,"SW-KFA 7i-EN",7,"0,7 m³"]
[0.7,7,5,"SW-KFA 9i-EN",9,"0,9 m³"]
[0.9,9,6,"SW-KFA 12i-EN",12,"1,21 m³"]
[1.21,12,7,"SW-KFA 19i-EN",19,"1,92 m³"]
[1.92,19,8,"SW-KFA 23i-EN",23,"2,31 m³"]
[2.31,23,9,"SW-KFA 29i-EN",29,"3,02 m³"]
[3.02,29,10,"SW-KFA 45i-EN",45,"4,52 m³"]
[4.5199999999999996,45,11,"SW-KFA 55i-EN",55,"5,51 m³"]
[5.51,55,12,"nur auf Anfrage"]
[]
[null,"nach Nenngröße",null,{"$f":"LOOKUP(E23,Parametertabelle!B3:B15,Parametertabelle!C3:C15)","v":{"$error":"#REF!"}}]
[]
[null,"nach Schlammfanggröße",null,{"$f":"LOOKUP(E25,Parametertabelle!A3:A15,Parametertabelle!C3:C15)","v":{"$error":"#REF!"}}]
[]
[null,"schlagender Faktor",null,{"$f":"IF(D17>D19,D17,D19)","v":{"$error":"#REF!"}}]
[]
[null,"erforderliche Nenngröße",null,{"$f":"'nach Art des Betriebes'!N67","v":0},{"$f":"IF('nach Art des Betriebes'!#REF!=\"\",D23,D23/'nach Art des Betriebes'!#REF!)","v":{"$error":"#REF!"}},"pro Stück"]
[]
[null,"erforderlicher Schlammfang",null,{"$f":"'nach Art des Betriebes'!M79","v":0},{"$f":"IF('nach Art des Betriebes'!#REF!=\"\",D25,D25/'nach Art des Betriebes'!#REF!)","v":{"$error":"#REF!"}},"pro Stück"]
[]
[]
[]
["vorh. Installationen","Fettabscheider ohne Schlammfang"]
["Berechnungsparameter Schlammfanggröße","Berechnungsparameter Nenngröße","Index","Typenbezeichnung","maximale Nenngröße","Nutzinhalt Schlammfang"]
[0,0,0,"zu kleines NS"]
[0.1,1,1,"SW-KFA 2i-EN",2,"0,2 m³"]
[0.2,2,2,"SW-KFA 3i-EN",3,"0,3 m³"]
[0.3,3,3,"SW-KFA 5i-EN",5,"0,5 m³"]
[0.5,5,4,"SW-KFA 7i-EN",7,"0,7 m³"]
[0.7,7,5,"SW-KFA 9i-EN",9,"0,9 m³"]
[0.9,9,6,"SW-KFA 12i-EN",12,"1,21 m³"]
[1.21,12,7,"SW-KFA 19i-EN",19,"1,92 m³"]
[1.92,19,8,"SW-KFA 23i-EN",23,"2,31 m³"]
[2.31,23,9,"SW-KFA 29i-EN",29,"3,02 m³"]
[3.02,29,10,"SW-KFA 45i-EN",45,"4,52 m³"]
[4.5199999999999996,45,11,"SW-KFA 55i-EN",55,"5,51 m³"]
[5.51,55,12,"nur auf Anfrage"]
[]
[null,"nach Nenngröße",null,{"$f":"LOOKUP(E51,Parametertabelle!B31:B43,Parametertabelle!C31:C43)","v":{"$error":"#REF!"}}]
[]
[null,"nach Schlammfanggröße",null,{"$f":"LOOKUP(E53,Parametertabelle!A31:A43,Parametertabelle!C31:C43)","v":{"$error":"#REF!"}}]
[]
[null,"schlagender Faktor",null,{"$f":"IF(D45>D47,D45,D47)","v":{"$error":"#REF!"}}]
[]
[null,"erforderliche Nenngröße",null,{"$f":"'nach vorh. Installationen'!N59","v":0},{"$f":"IF('nach vorh. Installationen'!#REF!=\"\",D51,D51/'nach vorh. Installationen'!#REF!)","v":{"$error":"#REF!"}},"pro Stück"]
[]
[null,"erforderlicher Schlammfang",null,{"$f":"'nach vorh. Installationen'!M71","v":0},{"$f":"IF('nach vorh. Installationen'!#REF!=\"\",D53,D53/'nach vorh. Installationen'!#REF!)","v":{"$error":"#REF!"}},"pro Stück"]