{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Berechnung","Parametertabelle"],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"Berechnung","index":0,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,7],[10,1,10,3],[11,1,11,3],[12,1,12,3],[6,2,6,9],[9,6,9,7],[9,1,9,3],[8,6,8,7],[8,8,8,9],[10,6,10,7],[3,1,3,9],[4,1,4,9],[2,1,2,9],[9,8,9,9],[11,6,11,7],[21,8,21,9],[23,8,23,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[16,8,16,9],[14,8,14,9],[13,1,13,3],[13,6,13,7],[11,4,11,5],[12,6,12,7],[37,1,37,9],[14,4,14,5],[15,4,15,5],[8,4,8,5],[10,4,10,5],[30,8,30,9],[15,1,15,3],[12,4,12,5],[15,8,15,9],[13,8,13,9],[14,6,14,7],[15,6,15,7],[14,1,14,3],[13,4,13,5],[35,8,35,9],[9,4,9,5],[45,7,45,9],[42,7,42,9],[43,7,43,9],[44,7,44,9],[41,3,41,5],[42,3,42,5],[43,3,43,5],[45,3,45,5],[44,3,44,5],[41,6,41,9]]}
[]
[]
[null,"Reinigungsanlagen für Regenwasser von Verkehrs- und Abstellflächen"]
[null,"(Verkehrsflächen-Sicherungsschächte)"]
[null,"Bemessung nach ÖNORM B 5102"]
[]
[null,"Bauvorhaben:"]
[]
[null,"Entwässerungsflächen:",null,null,"Fläche A",null,"Abflussbeiwert a",null,"Ared"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",+E10*G10)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E11=\"\",\"\",+E11*G11)","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"Bitte auswählen"]
[null,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,2]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,4]
[null,"Summe Entwässerungsflächen x Abflussbeiwerte:",null,null,null,null,null,null,{"$f":"SUM(I10:I16)","v":0},null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"Ermittlung der Nenngröße (NG):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"NG = Qr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,"Qr = qr * A * a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,{"$f":"+I17/10000*I24","v":0},null,null,null,null,null,"daher:",{"$f":"IF(C42=\"Bitte auswählen\",\"\",+B22/C42)","v":0},null,null,null,null,null,null,null,10]
[null,"Qr = Regenwasserzufluss (l/s)"]
[null,"qr = örtliche Regenspende (mind. 150l/s) des einjährlichen, 10 minütigen Starkregenereignisses",null,null,null,null,null,null,200]
[null,"A = Niederschlagsfläche in ha"]
[null,"a = Abflussbeiwert"]
[]
[]
[null,"Ermittlung des Schlammfangvolumens:"]
[null,"VS = 0,1 * NG"]
[null,{"$f":"IF(I22=\"\",\"\",0.1*I22)","v":0},"jedoch mind. 3,0 m3",null,null,null,null,null,{"$f":"IF(B31<3,3,B31)","v":3}]
[]
[null,"Ermittlung des Abscheiders:"]
[null,"Der Ölspeicherraum muss mindestens das 20-fache der Nenngröße, mindestens jedoch 500 Liter betragen"]
[null,"VÖ = 20 * NG"]
[null,{"$f":"IF(I22=\"\",\"\",+I22*20)","v":0},"jedoch mind. 500 Liter",null,null,null,null,null,{"$f":"IF(B36=\"\",\"\",(IF(B36<500,0.5,B36/1000)))","v":0.5}]
[]
[null,"Die Oberflächenbeschickung des Schlammfanges darf 35m/h (35m3/(m2.h)) nicht überschreiten!"]
[]
[]
[null,"SW-Verkehrsflächensicherheitsschacht \"Euro-Sedirat\" "]
[null,"Auswahl:",1,{"$f":"IF(C42=\"Bitte auswählen\",\"\",LOOKUP(Parametertabelle!E21,Parametertabelle!A2:B13))","v":"VFS 12-3.2-EN"},null,null,"lt. Berechnung und Norm:"]
[null,"Nenngröße:",null,{"$f":"IF(C42=\"Bitte auswählen\",\"\",LOOKUP(Parametertabelle!E21,Parametertabelle!A2:A13,Parametertabelle!F2:F13))","v":12},null,null,">",{"$f":"I22","v":0}]
[null,"Schlammfang-Volumen:",null,{"$f":"IF(C42=\"Bitte auswählen\",\"\",LOOKUP(Parametertabelle!E21,Parametertabelle!A2:A13,Parametertabelle!G2:G13))","v":3.2},null,null,">",{"$f":"I31","v":3}]
[null,"Ölspeicherkapazität:",null,{"$f":"IF(C42=\"Bitte auswählen\",\"\",LOOKUP(Parametertabelle!E21,Parametertabelle!A2:A13,Parametertabelle!N2:N13))","v":0.54},null,null,">",{"$f":"+I36","v":0.5}]
[null,"Oberflächenbeschickung:",null,{"$f":"IF(C42=\"Bitte auswählen\",\"\",LOOKUP(Parametertabelle!E21,Parametertabelle!A2:A13,Parametertabelle!O2:O13))","v":13.75},null,null,"<",{"$f":"IF(C42=\"Bitte auswählen\",\"\",35)","v":35}]
[]
[]
[null,null,null,null,null,"SW-Bemessungsprogramm_VFS_2020_web 1/1"]

{"sheet":"Parametertabelle","index":1,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":true,"merged":[[22,0,22,1],[24,0,24,1],[26,0,26,1],[14,0,14,1],[16,0,16,1],[18,0,18,1],[20,0,20,1]]}
["Index","Typenbezeichnung","Berechnungsparameter Nenngröße","Berechnungsparameter Schlammfanggröße","Ölspeicherraum","Nenngröße","Schlammfangvolumen","Aussenabmsgen","Einbautiefe","Zulauftiefe","Nennweite","größtes Stückgew.","Gesamtgewicht","Ölspeicherkapazität","Oberfl.-beschickg"]
[0,"Bitte Behälter auswählen!",0,0,0,"-","-","-","-","-","-","-","-","-","-"]
[1,"VFS 12-3.2-EN",0,0,0,12,3.2,224,260,90,200,5.2,7.49,0.54,13.75]
[2,"VFS 20-3.2-EN",12.000999999999999,3.2,0.54,20,3.2,224,260,90,200,5.2,7.49,0.54,22.9]
[3,"VFS 30-3.7-EN",20.001000000000001,3.2,0.54,30,3.7,274,260,100,300,7.04,10.19,1.3,22]
[4,"VFS 40-6.2-EN",30.001000000000001,3.7,1.3,40,6.2,270,310,100,300,7.28,10.43,1.0900000000000001,29.34]
[5,"VFS 50-5.2-EN",40.000999999999998,6.2,1.0900000000000001,50,5.2,"430/250",260,100,300,9.5299999999999994,13.63,1.96,24.3]
[6,"VFS 65-7.4-EN",50.000999999999998,5.2,1.96,65,7.44,"430/250",360,130,300,13.76,18.07,2.2200000000000002,31.6]
[7,"VFS 80-14.6-EN",65.001000000000005,7.4,2.2200000000000002,80,14.52,"594/295",330,110,400,16.54,22.98,4.6399999999999997,23.56]
[8,"VFS 100-14.6-EN",80.001000000000005,14.6,3.65,100,14.58,"594/295",330,110,400,20.420000000000002,27.47,3.65,29.46]
[9,"VFS 120-14.5-EN",100.001,14.6,3.65,120,"14.51","701/305",330,110,400,24.29,33.229999999999997,4.6399999999999997,28.742514970059883]
[10,"VFS 145-18.8-EN",120.001,14.5,4.3899999999999997,145,"18.78","701/305",360,110,400,26.28,35.22,5.67,34.730538922155688]
[12,"Nur auf Anfrage",145.001,18.8,4.3899999999999997,"-","-","-","-","-","-","-","-","-","-"]
[]
["nach Nenngröße",null,null,null,{"$f":"LOOKUP(Berechnung!I22,C2:C13,A2:A13)","v":1}]
[]
["nach Schlammfanggröße",null,null,null,{"$f":"LOOKUP(Berechnung!I31,D2:D13,A2:A13)","v":1}]
[]
["nach Ölspeicherraum",null,null,null,{"$f":"LOOKUP(Berechnung!I36,E2:E13,A2:A13)","v":1}]
[]
["schlagender Faktor",null,null,null,{"$f":"IF((OR(E15=0,E17=0,E19=0)),\"\",MAX(E15,E17,E19))","v":1}]