{"text_format":"1","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,"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":[[24,1,24,5],[30,1,37,5],[44,1,44,5],[40,1,40,5],[43,1,43,5],[42,1,42,5],[41,1,41,5],[10,1,10,5],[13,1,13,5],[16,1,16,5],[19,1,19,2],[19,3,19,4]]}
[]
[]
[]
[]
[null,"SW-Fettabscheideranlagen",null,null,null,"Version 07/2018"]
[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:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[[25,9,25,10],[25,7,25,8],[41,7,41,8],[26,7,26,8],[36,7,36,8],[41,9,41,10],[27,7,27,8],[27,9,27,10],[26,9,26,10],[28,1,31,13],[40,7,40,8],[40,9,40,10],[36,9,36,10],[37,7,37,8],[37,9,37,10],[38,7,38,8],[1,1,3,11],[22,9,22,10],[23,9,23,10],[24,9,24,10],[21,7,21,8],[19,9,19,10],[20,9,20,10],[21,9,21,10],[19,7,19,8],[20,7,20,8],[5,2,5,3],[6,2,6,3],[23,7,23,8],[24,7,24,8],[4,4,4,7],[22,7,22,8],[38,9,38,10],[39,7,39,8],[39,9,39,10],[81,6,81,8],[81,9,81,10],[81,11,81,13],[81,1,81,4],[73,2,73,3],[80,11,80,13],[80,6,80,8],[80,9,80,10],[80,1,80,4],[87,1,87,4],[87,6,87,8],[87,9,87,10],[87,11,87,13],[82,1,82,4],[82,6,82,13],[83,12,83,14],[88,1,88,4],[88,6,88,8],[88,9,88,10],[88,11,88,13],[91,1,91,4]]}
[]
[null,"Fettabscheider -  Bemessung nach ÖNORM EN1825-2 - Berechnung nach Art des Betriebes (ungeachtet der installierten Armaturen und Einrichtungen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,{"$f":"Deckblatt!F5","v":"Version 07/2018"},null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Eingabefelder",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"Ausgabefelder",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"Qs =","(V * F) : (t * 3600)",null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,"Qs =","maximaler Schmutzwasserabfluss (l/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"V =","durchschnittliches tägliches Schmutzwasservolumen"]
[null,"F =","Stoßbelastungsfaktor in Abhängigkeit von der Betriebsart"]
[null,"t =","durchschnittliche tägliche Betriebszeit in Stunden",null,null,null,null,null,null,null,null,null,null,null,null,null,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",null,null,null,null,"Vm",null,"F"]
[null,"Ess.Port.",null,null,null,null,null,"Liter Wasser",null,"Stoßbelastungs-",null,"V","t","Qs"]
[null,"pro Tag","Küchenbetrieb(*):",null,null,null,null,"je Portion",null,"faktor",null,"[Liter]","[Std]","[l / s]"]
[null,null,"Hotelküche/Gasthaus",null,null,null,null,100,null,5,null,{"$f":"+B23*H23","v":0},null,{"$f":"IF(M23>0,(+L23*J23)/(M23*3600), )","v":0}]
[null,null,"Spezialitätenrestaurant",null,null,null,null,50,null,8.5,null,0,null,0]
[null,null,"Krankenhaus",null,null,null,null,20,null,13,null,0,null,0]
[null,null,"Großküche ",null,null,null,null,10,null,22,null,0,null,0]
[null,null,"Werksküche / Mensa",null,null,null,null,5,null,20,null,0,null,0]
[null,null,"Benutzerdefinierte Angabe",null,null,null,null,null,null,null,null,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",null,null,null,null,"Vp",null,"F"]
[null,"Fleisch",null,null,null,null,null,"Liter Wasser",null,"Stoßbelastungs-",null,"V","t","Qs"]
[null,"kg / Tag","Fleischer, fleischverarbeitender Betrieb",null,null,null,null,"je kg Wurst",null,"faktor",null,"[Liter]","[Std]","[l / s]"]
[null,null,"bis 5 GV / Woche, bis 500 kg Wurst / Tag",null,null,null,null,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",null,null,null,null,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",null,null,null,null,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",null,null,null,null,null,null,"bis 60° C :","ft =",1]
[null,null,null,null,null,null,null,null,null,"ständig oder gelegendlich > 60° C :","ft =",1.3,"ft =",1]
[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"]
[null,null,null,null,null,null,null,null,null,"Kein Einsatz von Spül- und Reinigungsmittel:","fr =",1]
[null,null,null,null,null,null,null,null,null,"Anwendung von Spül- und Reinigungsmitteln:","fr =",1.3]
[null,null,null,null,null,null,null,null,null,"Abwasser aus Krankenhausküchen:","fr >=",1.5,"fr =",1.3]
[null,"fe =","Entsorgungsfaktor",null,null,null,null,null,null,"monatlich","fe =",1]
[null,null,null,null,null,null,null,null,null,"vierteljährlich","fe =",2]
[null,null,null,null,null,null,null,null,null,"halbjährlich","fe =",4,"fe =",2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"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³     =",null,null,null,null,{"$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³   =",null,null,null,null,{"$f":"+G77*0.2","v":0},"m³"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"erforderliches Schlammfangvolumen  =",{"$f":"M74+M77","v":0},"m³"]
[]
[null,"gewählter Fettabscheider: ",null,null,null,"Stück","Type:",null,null,"Nenngröße NS",null,"Nutzinhalt Schlammfang"]
[null,"Kompaktfettabscheider ",null,null,null,1,{"$f":"LOOKUP(Parametertabelle!$D$22,Parametertabelle!$C$3:$C$16,Parametertabelle!D3:D16)","v":"zu kleines NS"},null,null,{"$f":"LOOKUP(Parametertabelle!$D$22,Parametertabelle!$C$3:$C$16,Parametertabelle!E3:E16)","v":0},null,{"$f":"LOOKUP(Parametertabelle!$D$22,Parametertabelle!$C$3:$C$16,Parametertabelle!F3:F16)","v":0}]

{"sheet":"nach vorh. Installationen","index":2,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[4,4,4,7],[1,1,3,11],[5,2,5,3],[6,2,6,3],[22,2,22,6],[15,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[15,8,15,12],[21,2,21,6],[25,2,25,6],[27,2,27,6],[26,2,26,6],[30,2,30,6],[35,2,35,6],[33,2,34,6],[28,2,28,6],[29,2,29,6],[72,11,72,13],[73,1,73,4],[74,6,74,13],[74,1,74,4],[66,2,66,3],[23,2,23,6],[24,2,24,6],[78,1,78,4],[78,6,78,8],[78,9,78,10],[33,8,33,12],[72,9,72,10],[72,6,72,8],[73,9,73,10],[73,11,73,13],[36,2,36,6],[75,12,75,14],[73,6,73,8],[67,2,67,3],[37,2,37,6],[72,1,72,4],[82,1,82,4],[78,11,78,13],[79,1,79,4],[79,6,79,8],[79,9,79,10],[79,11,79,13]]}
[]
[null,"Fettabscheider -  Bemessung nach ÖNORM EN1825-2 - Berechnung nach installierten Amaturen und Einrichtungen (ungeachtet der Art des Betriebes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,{"$f":"Deckblatt!F5","v":"Version 07/2018"},null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"Eingabefelder",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"Ausgabefelder",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"Qs =","Summe von (n * qi * Zi(n))",null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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",null,null,null,null,"qi","Zi(n)",null,null,null,null,"Qs"]
[null,"[ n ]",null,null,null,null,null," [l/s]","n = 1","n = 2","n = 3","n = 4","n >= 5"," [l/s]"]
[null,null,"Kochkessel Auslauf DN25 mm",null,null,null,null,{"$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",null,null,null,null,{"$f":"IF(B19>=1,2,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Kippkessel Auslauf DN70 mm",null,null,null,null,{"$f":"IF(B20>=1,1,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Kippkessel Auslauf DN100 mm",null,null,null,null,{"$f":"IF(B21>=1,3,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Spülbecken mit Geruchsverschluss DN40",null,null,null,null,{"$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",null,null,null,null,{"$f":"IF(B23>=1,1.5,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Spülbecken ohne Geruchsverschluss DN40",null,null,null,null,{"$f":"IF(B24>=1,2.5,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Spülbecken ohne Geruchsverschluss DN50",null,null,null,null,{"$f":"IF(B25>=1,4,\" \")","v":" "},0,0,0,0,0,0]
[null,null,"Geschirrspülmaschine",null,null,null,null,{"$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",null,null,null,null,{"$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",null,null,null,null,{"$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",null,null,null,null,{"$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",null,null,null,null,{"$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",null,null,null,null,{"$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"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S Qs [l/s] =",{"$f":"SUM(N18:N31)","v":0}]
[]
[null,"Anzahl","Größe des Auslaufventils",null,null,null,null,"qi","Zi(n)",null,null,null,null,"Qs"]
[null,"[ n ]",null,null,null,null,null," [l/s]","n = 1","n = 2","n = 3","n = 4","n >= 5"," [l/s]"]
[null,null,"DN 15",null,null,null,null,{"$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",null,null,null,null,{"$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",null,null,null,null,{"$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}]
[null,null,null,null,null,null,null,null,null,null,null,null,"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",null,null,null,null,null,null,"bis 60° C :","ft =",1]
[null,null,null,null,null,null,null,null,null,"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"]
[null,null,null,null,null,null,null,null,null,"Kein Einsatz von Spül- und Reinigungsmittel:","fr =",1]
[null,null,null,null,null,null,null,null,null,"Anwendung von Spül- und Reinigungsmitteln:","fr =",1.3]
[null,null,null,null,null,null,null,null,null,"Abwasser aus Krankenhausküchen:","fr >=",1.5,"fr =",1.3]
[null,"fe =","Entsorgungsfaktor",null,null,null,null,null,null,"monatlich","fe =",1]
[null,null,null,null,null,null,null,null,null,"vierteljährlich","fe =",2]
[null,null,null,null,null,null,null,null,null,"halbjährlich","fe =",4,"fe =",2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"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³  =",null,null,null,null,{"$f":"+G68*0.1","v":0},"m³"]
[null,null,null,null,"Schlammfangvolumen=",null,{"$f":"(N32+N39)*N48*N50*N54*N57","v":0},"l/s * 0,2 m³   =",null,null,null,null,{"$f":"+G69*0.2","v":0},"m³"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"erforderliches Schlammfangvolumen  =",{"$f":"IF(C68=\"ja\",M69,IF(C68=\"nein\",M68,0))","v":0},"m³"]
[]
[null,"gewählter Fettabscheider: ",null,null,null,"Stück","Type:",null,null,"Nenngröße NS",null,"Nutzinhalt Schlammfang"]
[null,"Kompaktfettabscheider",null,null,null,1,{"$f":"LOOKUP(Parametertabelle!$D$51,Parametertabelle!$C$32:$C$45,Parametertabelle!D32:D45)","v":"zu kleines NS"},null,null,{"$f":"LOOKUP(Parametertabelle!$D$51,Parametertabelle!$C$32:$C$45,Parametertabelle!E32:E45)","v":0},null,{"$f":"LOOKUP(Parametertabelle!$D$51,Parametertabelle!$C$32:$C$45,Parametertabelle!F32:F45)","v":0}]

{"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":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":true,"merged":[[48,3,48,5],[50,3,50,5],[0,1,0,5],[17,3,17,5],[19,3,19,5],[21,3,21,5],[29,1,29,5],[46,3,46,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 4i-EN",4,"0,4 m³"]
[0.4,4,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 10i-EN",10,"1,0m³"]
[1,10,6,"SW-KFA 12i-EN",12,"1,21 m³"]
[1.21,12,7,"SW-KFA 15i-EN",15,"1,5 m³"]
[1.5,15,8,"SW-KFA 19i-EN",19,"1,92 m³"]
[1.92,19,9,"SW-KFA 23i-EN",23,"2,31 m³"]
[2.31,23,10,"SW-KFA 29i-EN",29,"3,02 m³"]
[3.02,29,11,"SW-KFA 45i-EN",45,"4,52 m³"]
[4.5199999999999996,45,12,"SW-KFA 55i-EN",55,"5,51 m³"]
[5.51,55,13,"nur auf Anfrage"]
[]
[null,"nach Nenngröße",null,{"$f":"LOOKUP(E24,Parametertabelle!B3:B16,Parametertabelle!C3:C16)","v":0}]
[]
[null,"nach Schlammfanggröße",null,{"$f":"LOOKUP(E26,Parametertabelle!A3:A16,Parametertabelle!C3:C16)","v":0}]
[]
[null,"schlagender Faktor",null,{"$f":"IF(D18>D20,D18,D20)","v":0}]
[]
[null,"erforderliche Nenngröße",null,{"$f":"'nach Art des Betriebes'!N67","v":0},{"$f":"IF('nach Art des Betriebes'!F82=\"\",D24,D24/'nach Art des Betriebes'!F82)","v":0},"pro Stück"]
[]
[null,"erforderlicher Schlammfang",null,{"$f":"'nach Art des Betriebes'!M79","v":0},{"$f":"IF('nach Art des Betriebes'!F82=\"\",D26,D26/'nach Art des Betriebes'!F82)","v":0},"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 4i-EN",4,"0,4 m³"]
[0.4,4,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 10i-EN",10,"1,0 m³"]
[1,10,6,"SW-KFA 12i-EN",12,"1,21 m³"]
[1.21,12,7,"SW-KFA 15i-EN",15,"1,5 m³"]
[1.5,15,8,"SW-KFA 19i-EN",19,"1,92 m³"]
[1.92,19,9,"SW-KFA 23i-EN",23,"2,31 m³"]
[2.31,23,10,"SW-KFA 29i-EN",29,"3,02 m³"]
[3.02,29,11,"SW-KFA 45i-EN",45,"4,52 m³"]
[4.5199999999999996,45,12,"SW-KFA 55i-EN",55,"5,51 m³"]
[5.51,55,13,"nur auf Anfrage"]
[]
[null,"nach Nenngröße",null,{"$f":"LOOKUP(E53,Parametertabelle!B32:B45,Parametertabelle!C32:C45)","v":0}]
[]
[null,"nach Schlammfanggröße",null,{"$f":"LOOKUP(E55,Parametertabelle!A32:A45,Parametertabelle!C32:C45)","v":0}]
[]
[null,"schlagender Faktor",null,{"$f":"IF(D47>D49,D47,D49)","v":0}]
[]
[null,"erforderliche Nenngröße",null,{"$f":"'nach vorh. Installationen'!N59","v":0},{"$f":"IF('nach vorh. Installationen'!$F$74=\"\",D53,D53/'nach vorh. Installationen'!$F$74)","v":0},"pro Stück"]
[]
[null,"erforderlicher Schlammfang",null,{"$f":"'nach vorh. Installationen'!M71","v":0},{"$f":"IF('nach vorh. Installationen'!$F$74=\"\",D55,D55/'nach vorh. Installationen'!$F$74)","v":0},"pro Stück"]
[]
[]
[]
[null,null,"NS","Typenbezeichnung LIPORAT"]
[null,null,null,"zu kleine NS"]
[null,null,2,"SW-LIP-2i-EN"]
[null,null,4,"SW-LIP-4i-EN"]
[null,null,5,"SW-LIP-6i-EN"]
[7,null,6,"SW-LIP-6i-EN"]
[null,null,7,"SW-LIP-8i-EN"]
[null,null,8,"SW-LIP-8i-EN"]
[null,null,10,"SW-LIP-12i-EN"]
[null,null,12,"SW-LIP-12i-EN"]
[null,null,15,"SW-LIP-16i-EN"]
[null,null,16,"SW-LIP-16i-EN"]
[null,null,null,"nur auf Anfrage"]