{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Titel","Erläuterung","Auswahlmenü","KOSTRA","Grundstück","Schmutzwasser","Flächen","Speichervolumen","Überflutung","Zusammenstellung"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":20,"comments":3,"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":"Titel","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,0,4,6],[5,0,5,6],[7,0,7,6],[17,2,17,4],[10,0,13,6]]}
[]
[]
[]
[]
["Arbeitshilfe"]
["zum Entwässerungsantrag             der Stadt Bünde"]
[]
[]
[]
[]
["Berechnung des Schmutz- und Regenwasseranfalls\nErmittlung des Rückhalteraumes nach DWA-A 117\nÜberflutungsnachweis nach DIN 1986-100"]
[]
[]
[]
[]
[]
[]
[null,null,"Stand 10/2023"]

{"sheet":"Erläuterung","index":1,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[[42,1,45,6],[46,1,46,6],[0,1,25,6],[27,1,40,6]]}
[null,"Erläuterungen\n\nMit dem Entwässerungsantrag sind zum Teil Berechnungen und Ermittlungen erforderlich, die durch unsere Satzung oder gesetzliche Regelungen festgelegt sind. Grundlage der Berechnungen sind die anerkannten technischen Regelwerke.\n\nDiese Datei soll Ihnen eine Hilfestellung hierzu geben. Diese Datei ist nur anzuwenden, wenn folgende Randbedingungen eingehalten werden:\n\n1. AE,k max 200 ha oder Fließzeit bis zum RRR max. 15 min\n2. Überschreitungshäufigkeit von V des RRR beträgt n >= 0,1/a bzw. Tn <= 10a\n3. Regenanteil der Drosselabflussspende ist qdr,r,u >= 2 l/(s*ha)\n\nDie Bearbeitung dieser Datei erfordert Fachwissen hinsichtlich der Dimensionierung eines Regenrückhalteraumes (offenes Becken, unterirdisches Bechen). Die Verwendung der Datei sowie der berechneten Ergebnisse erfolgt auf eigene Gefahr. Es wird keine Gewähr für die Richtigkeit der Berechnungsergebnisse gegeben.\n\nIn die Datei sind die für die Stadt Bünde durch den deutschen Wetterdienst (DWD) herausgegebenen KOSTRA-Starkniederschlagsreihe eines 5-jährlichen Regenereignisses eingebunden und können nicht verändert werden. Die Berechnung erfolgt nach Vorgabe der Satzung für einen max. Drosselabfluss von 4 l(s*ha).\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Quellenangabe\n\nDWA - Deutsche Vereinigung für Wasserwirtschaft, Abwasser und Abfall e.V. (2006):             \nDWA-Regelwerk, Arbeitsblatt DWA-A 117, Bemessung von Regenrückhalteräumen. Hennef (Selbstverlag). ISBN 3-937758-75-5            \nBezug: DWA, Theodor-Heuss-Allee 17, 53773 Hennef, E-Mail: kundenzentrum@dwa.de, Web: www.dwa.de            \n\nDIN Deutsches Institut für Normung e.V.\nDIN 1986-100, Entwässerungsanlagen für Gebäude und Grundstücke, ICS 23.040.05; 91.140.80; 93.030\nAlleinverkauf der Norm durch den Beuth Verlag GmbH, 10772 Berlin, Web: www.beuth.de"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Anregungen und Hinweise\n\nSofern Anregungen und Hinweise zur Arbeitshilfe bestehen, wenden sie sich bitte an: \n\n"]
[]
[]
[]
[null,"michael.boeke-hasselmeier@buende.de"]

{"sheet":"Auswahlmenü","index":2,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,1,48,6],[9,1,34,6],[0,1,0,6],[3,1,7,6]]}
[null,"Auswahlmenü"]
[]
[]
[null,"Information\n\nZur Navigation zwischen den einzelnen Arbeitsblättern können sie auf die entsprechenden Navigationsfelder klicken und gelangen hierüber sofort ins Arbeitsblatt."]
[]
[]
[]
[]
[]
[null,"Navigation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Legende"]

{"sheet":"KOSTRA","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,1,3,10],[4,2,4,10],[1,1,1,10]]}
[]
[null,"Berechnungswerte KOSTRA Rasterfeld Spalte 24, Zeile 39, Klassenfaktor 1,0 (Bünde)"]
[]
[null,"Regenspende rD,T [l/(s * ha)]"]
[null,"Regendauer D","Wiederkehrzeiten T"]
[null,"T","1 a","2 a","3 a","5 a","10 a","20 a","30 a","50 a","100 a"]
[null,5,253.3,316.7,353.3,403.3,476.7,550,596.70000000000005,663.3,753.3]
[null,10,158.30000000000001,196.7,220,250,295,341.7,371.7,411.7,468.3]
[null,15,117.8,146.69999999999999,164.4,187.8,221.1,255.6,277.8,307.8,350]
[null,20,95.8,119.2,133.30000000000001,151.69999999999999,179.2,207.5,225.8,249.2,284.2]
[null,30,71.099999999999994,88.3,98.9,112.8,132.80000000000001,153.9,167.2,185,210.6]
[null,45,52.6,65.2,73,83.3,98.5,113.7,124.1,137,156.30000000000001]
[null,60,42.2,52.5,58.9,67.5,79.400000000000006,91.9,100.3,110.8,126.4]
[null,90,31.3,38.9,43.7,50,58.9,68.099999999999994,74.3,82.2,93.5]
[null,120,25.3,31.5,35.299999999999997,40.299999999999997,47.5,55,60,66.400000000000006,75.599999999999994]
[null,180,18.8,23.3,26.2,29.9,35.200000000000003,40.700000000000003,44.4,49.1,55.8]
[null,240,15.1,18.899999999999999,21.1,24.2,28.5,32.9,35.799999999999997,39.700000000000003,45.1]
[null,320,11.3,14,15.6,17.899999999999999,21.1,24.4,26.5,29.4,33.4]
[null,540,8.3000000000000007,10.3,11.6,13.2,15.6,18,19.600000000000001,21.7,24.7]
[null,720,6.7,8.3000000000000007,9.4,10.7,12.6,14.6,15.9,17.5,20]
[null,1080,5,6.2,6.9,7.9,9.3000000000000007,10.8,11.7,13,14.8]
[null,1440,4,5,5.6,6.4,7.5,8.6999999999999993,9.5,10.5,11.9]
[null,2880,2.4,3,3.3,3.8,4.5,5.2,5.7,6.3,7.1]
[null,4320,1.7,2.1,2.2999999999999998,2.7,3.2,3.6,4,4.4000000000000004,5]

{"sheet":"Grundstück","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,2,15,3],[24,1,24,4],[14,2,14,3],[19,2,19,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[3,2,3,5],[4,2,4,5],[5,2,5,5],[6,4,6,5],[9,2,9,5]]}
[null,"Baugrundstück/e"]
[]
[null,"Bauherr*in"]
[null,"Vorname:"]
[null,"Nachname:"]
[null,"Straße:"]
[null,"PLZ:",null,"Ort:"]
[]
[null,"Bauort"]
[null,"Straße:"]
[null,"Hausnummer:",null,null,null,"(nur, wenn bereits vergeben)"]
[]
[null,"Lage"]
[null,"Gemarkung","Flur",null,"Flurstück","Größe*"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,null,null,null,null,null,"m2"]
[null,"Summe AG",null,null,null,{"$f":"SUM(F15:F24)","v":0},"m2"]
[]
[null,"* Flurstücksgröße in m2 eingeben"]

{"sheet":"Schmutzwasser","index":5,"n_rows":60,"n_cols":30,"rows_kept":60,"cut":false,"hidden":false,"merged":[[9,29,9,31],[11,22,11,23],[11,27,11,28],[35,6,38,7],[5,22,5,23],[5,27,5,28],[7,22,7,23],[7,27,7,28],[9,23,9,25],[9,26,9,28],[33,4,33,5],[30,4,30,5],[31,4,31,5],[28,1,28,6],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[32,4,32,5],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[11,1,11,2],[12,1,12,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[10,1,10,2]]}
[null,"Ermittlung Schmutzwassermengen"]
[]
[]
[null,"Entwässerungsgegenstand",null,"Anzahl","x","Anschlusswert DU\nin [l/s]",null,"Teilsumme"]
[null,"Waschbecken, Bidet",null,null,"x",0.5,"=",{"$f":"IF(D5=\"\",\"\",F5*D5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D37=150,Y14,0)","v":15.3},null,{"$f":"IF(D37=200,AD14,0)","v":0}]
[null,"Dusche ohne Stöpsel",null,null,"x",0.6,"=",{"$f":"IF(D6=\"\",\"\",F6*D6)","v":""}]
[null,"Badewanne, Dusche mit Stöpsel",null,null,"x",0.8,"=",""]
[null,"Einzelurinal mit Spülkasten",null,null,"x",0.8,"=",""]
[null,"Einzelurinal mit Druckspüler",null,null,"x",0.5,"=",""]
[null,"Standurinal",null,null,"x",0.2,"=",""]
[null,"Urinal ohne Wasserspülung",null,null,"x",0.1,"=",""]
[null,"Küchenspüle und Geschirrspülmaschine\nmit gemeinsamen Geruchsverschluß",null,null,"x",0.8,"=",""]
[null,"Küchenspüle, Ausgussbecken,\nGeschirrspüler, ",null,null,"x",0.8,"=",""]
[null,"Waschmaschine bis 6 kg",null,null,"x",0.8,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DN 150",{"$f":"MAX(X16:X35)","v":15.3},null,null,null,"DN 200",{"$f":"MAX(AC16:AC35)","v":28.4}]
[null,"Waschmaschine bis 12 kg",null,null,"x",1.5,"=",""]
[null,"WC mit 4,0/4,5 l Spülkasten",null,null,"x",1.8,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$38=X41,Y41,0)","v":0},null,null,null,null,{"$f":"IF($D$38=AC40,AD40,0)","v":0}]
[null,"WC mit 6,0 l Spülkasten / Druckspüler",null,null,"x",2,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$38=X42,Y42,0)","v":0},null,null,null,null,{"$f":"IF($D$38=AC41,AD41,0)","v":0}]
[null,"WC mit 7,5 l Spülkasten / Druckspüler",null,null,"x",2,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"WC mit 9,0 l Spülkasten / Druckspüler",null,null,"x",2.5,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Bodenablauf DN 50",null,null,"x",0.8,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Bodenablauf DN 70",null,null,"x",1.5,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Bodenablauf DN 100",null,null,"x",2,"=","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Gesamtanschlusswert",null,"∑DU",null,null,"=",{"$f":"SUM(H5:H22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.3,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,28.4]
[null,"Abflusskennzahl (K)",null,null,null,null,null,"K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Unregelmäßige Benutzung, z.B. in Wohnhäusern, Altersheimen, Pensionen, Büros",null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Regelmäßige Benutzung, z.B. in Krankenhäusern, Schulen, Restaurants, Hotels",null,null,null,null,null,0.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Häufige Benutzung, z.B., in öffentlichen Toiletten und/oder Duschen",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Gewählte Kennzahl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Qww",null,null,"K ∙√ ∑ DU",null,"=",{"$f":"H29*SQRT(H23)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Qc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Qp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Qtot",null,null,null,null,null,{"$f":"SUM(H31:H33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(D39<H34,\"DN Anschluss zu klein!\",\"\")","v":""}]
[null,null,"DN",150]
[null,null,"Gefälle",1,"%"]
[null,null,"Qvoll",{"$f":"SUM(Z5:AB5)","v":15.3},null,{"$f":"IF(H34>D39,\"Leitungsquer zu klein\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," cm/m"," l/s",null,null,null," cm/m"," l/s"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,12.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,8.3000000000000007,null,null,null,0.3,15.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,9.6,null,null,null,0.4,17.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10.8,null,null,null,0.5,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,11.8,null,null,null,0.6,21.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,12.8,null,null,null,0.7,23.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,13.7,null,null,null,0.8,25.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,14.5,null,null,null,0.9,26.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15.3,null,null,null,1,28.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,16.100000000000001,null,null,null,1.1000000000000001,29.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,16.8,null,null,null,1.2,31.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,17.5,null,null,null,1.3,32.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,18.2,null,null,null,1.4,33.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,18.8,null,null,null,1.5,34.799999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,21.7,null,null,null,2,40.200000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,24.3,null,null,null,2.5,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,26.7,null,null,null,3,49.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,28.8,null,null,null,3.5,53.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,30.8,null,null,null,4,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5,32.700000000000003,null,null,null,4.5,60.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,34.5,null,null,null,5,63.8]

{"sheet":"Flächen","index":6,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[18,1,18,2],[16,1,16,2],[3,1,3,2],[11,1,11,2],[5,1,5,2],[6,1,6,2],[8,1,8,2],[10,1,10,2],[9,1,9,2],[7,1,7,3],[34,1,34,7],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[16,5,16,6],[32,5,32,6],[33,4,33,6],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[29,1,29,2],[19,1,19,2],[25,1,25,2],[27,1,27,2],[26,1,26,2],[20,1,20,2],[28,1,28,2]]}
[null,"Ermittlung abflusswirksamer Flächen"]
[]
[null,"Art der Fläche",null,"Befestigte Fläche A\n[m²]","x","Spitzen-abfluss-beiwert\nCs","x","Abfluss-wirksame \nFläche\nAU"]
[null,"Dachflächen - FD"]
[null,"Schrägdach"]
[null,"Metall, Glas, Schiefer, Faserzement",null,null,"x",0.9,"=",{"$f":"IF(D6=\"\",\"\",F6*D6)","v":""}]
[null,"Ziegel, Abdichtungsbahnen",null,null,"x",0.8,"=",{"$f":"IF(D7=\"\",\"\",F7*D7)","v":""}]
[null,"Flachdach (Neigung bis 3° oder 5%)",null,null,null,null,null,""]
[null,"Metall, Glas, Faserzement",null,null,"x",0.9,"=",""]
[null,"Abdichtungsbahnen",null,null,"x",0.9,"=",""]
[null,"Kiesschüttung",null,null,"x",0.8,"=",""]
[null,"Begrünte Dachflächen"]
[null,"Extensivbegrünung (> 5°)",null,null,"x",0.4,"=",""]
[null,"Intensivbegrünung ab 30 cm (≤5°)",null,null,"x",0.1,"=",""]
[null,"Extensivbegrünung ab 10 cm (≤5°)",null,null,"x",0.2,"=",""]
[null,"Extensivbegrünung unter 10 cm (≤5°)",null,null,"x",0.3,"=",""]
[null,"∑ AFD",null,{"$f":"SUM(D6:D16)","v":0},null,"∑ AU,FD",null,{"$f":"SUM(H6:H16)","v":0}]
[null,"Flächen außerhalb von Gebäuden - FaG"]
[null,"Betonflächen, Schwarzdecken (Asphalt)",null,null,"x",0.9,"=",{"$f":"IF(D19=\"\",\"\",F19*D19)","v":""}]
[null,"Pflaster mit Fugenverguss",null,null,"x",0.8,"=",{"$f":"IF(D20=\"\",\"\",F20*D20)","v":""}]
[null,"Rampen mit Neigung zum Gebäude",null,null,"x",1,"=",""]
[null,"Pflaster in Sand/Schlacke, Plattenflächen",null,null,"x",0.7,"=",""]
[null,"Pflaster mit Fugenanteil > 15%",null,null,"x",0.6,"=",""]
[null,"Fester Kiesbelag",null,null,"x",0.6,"=",""]
[null,"Wassergebundene Flächen",null,null,"x",0.7,"=",""]
[null,"Lockerer Kiesbelag, Schotterrasen",null,null,"x",0.2,"=",""]
[null,"Verbundsteine mit Sickerfugen, Sickersteine",null,null,"x",0.25,"=",""]
[null,"Rasengittersteine mit häufiger Belastung ",null,null,"x",0.2,"=",""]
[null,"Rasengittersteine mit seltener Belastung",null,null,"x",0.1,"=",""]
[null,"Parkanlagen, Rasenflächen"]
[null,"Flaches Gelände",null,null,"x",0.1,"=",""]
[null,"Steiles Gelände",null,null,"x",0.2,"=",""]
[null,"∑ AFaG",null,{"$f":"SUM(D19:D32)","v":0},null,"∑ AU,FaG",null,{"$f":"SUM(H19:H32)","v":0}]
[null,"∑ A",null,{"$f":"D17+D33","v":0},"∑ AU",null,null,{"$f":"H33+H17","v":0}]
[null,{"$f":"IF(D34<>Grundstück!F25,\"Fehler! Summe Einzelflächen ungleich Gesamtgrundstücksfläche\",\"\")","v":""}]

{"sheet":"Speichervolumen","index":7,"n_rows":27,"n_cols":29,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,7,4,8],[17,12,18,17],[23,12,23,17],[21,12,21,17]]}
[null,"Notwendiges Rückhaltevolumen nach DWA A-117"]
[]
[null,"Eingabedaten",null,null,null,null,null,null,null,null,"Ergebnisdaten"]
[]
[null,"Flächendaten",null,null,null,null,null,"Regendaten",null,null,"Volumen"]
[null,"AE,k",{"$f":"Flächen!D34/10000","v":0},"ha",null,null,null,"D","rD(n)",null,"V ",null,null,null,null,null,null,null,null,null,null,null,"D","rmaßg","Qdr","V R,U","V","T","rDn"]
[null,"AU",{"$f":"Flächen!H34/10000","v":0},"ha",null,null,null,"[min]","[l/(s*ha)]",null,"[m3]"]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B7","v":5},{"$f":"KOSTRA!F7","v":403.3},null,{"$f":"AA8","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"H8","v":5},{"$f":"I8","v":403.3},{"$f":"$C$12","v":0},{"$f":"IF((I8-$C$13)*H8*$C$16*$C$19*0.06>0,(I8-$C$13)*H8*$C$16*$C$19*0.06,0)","v":145.18799999999996},{"$f":"IF((Z8*$C$7)<=0,\"\",Z8*$C$7)","v":""},{"$f":"IF(AA8=$AA$27,W8,0)","v":0},{"$f":"IF(AA8=$AA$27,X8,0)","v":0}]
[null,"Abflussdaten",null,null,null,null,null,{"$f":"KOSTRA!B8","v":10},{"$f":"KOSTRA!F8","v":250},null,"",null,null,null,null,null,null,null,null,null,null,null,10,250,{"$f":"$C$12","v":0},{"$f":"IF((I9-$C$13)*H9*$C$16*$C$19*0.06>0,(I9-$C$13)*H9*$C$16*$C$19*0.06,0)","v":179.99999999999997},{"$f":"IF((Z9*$C$7)<=0,\"\",Z9*$C$7)","v":""},0,0]
[null,"qDr",4,"l/s*ha",null,null,null,{"$f":"KOSTRA!B9","v":15},{"$f":"KOSTRA!F9","v":187.8},null,"",null,null,null,null,null,null,null,null,null,null,null,15,187.8,0,202.82399999999998,"",0,0]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B10","v":20},{"$f":"KOSTRA!F10","v":151.69999999999999},null,"",null,null,null,null,null,null,null,null,null,null,null,20,151.69999999999999,0,218.44799999999995,"",0,0]
[null,"QDr,max",{"$f":"C10*C6","v":0},"l/s",null,null,null,{"$f":"KOSTRA!B11","v":30},{"$f":"KOSTRA!F11","v":112.8},null,"",null,null,null,null,null,null,null,null,null,null,null,30,112.8,0,243.64799999999994,"",0,0]
[null,"qDr,R,u",{"$f":"IFERROR(C12/C7,0)","v":0},"l/s*ha",null,null,null,{"$f":"KOSTRA!B12","v":45},{"$f":"KOSTRA!F12","v":83.3},null,"",null,null,null,null,null,null,null,null,null,null,null,45,83.3,0,269.89199999999994,"",0,0]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B13","v":60},{"$f":"KOSTRA!F13","v":67.5},null,"",null,null,null,null,null,null,null,null,null,null,null,60,67.5,0,291.59999999999991,"",0,0]
[null,"weitere Daten",null,null,null,null,null,{"$f":"KOSTRA!B14","v":90},{"$f":"KOSTRA!F14","v":50},null,"",null,null,null,null,null,null,null,null,null,null,null,90,50,0,323.99999999999994,"",0,0]
[null,"fz",1.2,"[-]",null,null,null,{"$f":"KOSTRA!B15","v":120},{"$f":"KOSTRA!F15","v":40.299999999999997},null,"",null,null,null,null,null,null,null,null,null,null,null,120,40.299999999999997,0,348.19199999999989,"",0,0]
[null,"tf",5,"[min]",null,null,null,{"$f":"KOSTRA!B16","v":180},{"$f":"KOSTRA!F16","v":29.9},null,"",null,null,null,null,null,null,null,null,null,null,null,180,29.9,0,387.50399999999991,"",0,0]
[null,"n",0.2,"[1/a]",null,null,null,{"$f":"KOSTRA!B17","v":240},{"$f":"KOSTRA!F17","v":24.2},null,"",null,"Volumen und Entleerungszeit der Rückhalteeinrichtung",null,null,null,null,null,null,null,null,null,240,24.2,0,418.17599999999987,"",0,0]
[null,"fA",{"$f":"IF(E13>40,C21,(0.6134*C18+0.3866)*C20-(0.6134*C18-0.6134))","v":0.99999999999999989},"[-]",null,null,null,360,{"$f":"KOSTRA!F18","v":17.899999999999999},null,"",null,null,null,null,null,null,null,null,null,null,null,360,17.899999999999999,0,463.96799999999985,"",0,0]
[null,"f1",{"$f":"1-(0.0000000001*C17^3-0.000000008*C17^2+0.00000001*C17)*C13^3+(0.000000016*C17^3-0.000000915*C17^2+0.00000114*C17)*C13^2+(0.00000018*C17^3-0.0000125*C17^2+0.0000156*C17)*C13","v":1},"[-]",null,null,null,{"$f":"KOSTRA!B19","v":540},{"$f":"KOSTRA!F19","v":13.2},null,"",null,"VMax = ",{"$f":"AA27","v":0},"[m3]","tRRB =",{"$f":"IFERROR((N20*1000)/C12/60/60,0)","v":0},"[h]",null,null,null,null,540,13.2,0,513.21599999999989,"",0,0]
[null,"fa, interpoliert",0.95,"[-]",null,null,null,{"$f":"KOSTRA!B20","v":720},{"$f":"KOSTRA!F20","v":10.7},null,"",null,null,null,null,null,null,null,null,null,null,null,720,10.7,0,554.68799999999987,"",0,0]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B21","v":1080},{"$f":"KOSTRA!F21","v":7.9},null,"",null,"Maßgebliches Regenereignis",null,null,null,null,null,null,null,null,null,1080,7.9,0,614.30399999999986,"",0,0]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B22","v":1440},{"$f":"KOSTRA!F22","v":6.4},null,"",null,"D =",{"$f":"$AB$27","v":0},"[min]","rD(n) =",{"$f":"$AC$27","v":0},"[l/s*ha]",null,null,null,null,1440,6.4,0,663.55199999999979,"",0,0]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B23","v":2880},{"$f":"KOSTRA!F23","v":3.8},null,"",null,"anfallende Regenmengen",null,null,null,null,null,null,null,null,null,2880,3.8,0,787.96799999999985,"",0,0]
[null,null,null,null,null,null,null,{"$f":"KOSTRA!B24","v":4320},{"$f":"KOSTRA!F24","v":2.7},null,"",null,null,{"$f":"C7*Q23","v":0},"[l/s]",null,{"$f":"IF(N23<120,N25*N23*60/1000,N25*120*60/1000)","v":0},"[m3/2h]",null,null,null,null,4320,2.7,0,839.80799999999977,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N25*60*N23/1000","v":0},"[m3/d]",null,{"$f":"C6*0.8*10000","v":0},"[m3/a]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AA8:AA25)","v":0},{"$f":"MAX(AB8:AB25)","v":0},{"$f":"MAX(AC8:AC25)","v":0}]

{"sheet":"Überflutung","index":8,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[26,3,26,4],[30,9,30,11],[28,1,28,4],[28,5,28,8],[28,9,28,11],[5,19,5,20],[7,19,7,20],[11,19,11,20],[9,23,9,25],[9,26,9,28],[5,24,5,25],[7,24,7,25],[11,24,11,25],[9,20,9,22],[0,1,0,11],[40,1,40,4],[40,5,40,8],[40,9,40,11],[15,9,15,11],[29,1,29,4],[29,5,29,8],[29,9,29,11],[30,1,30,4],[30,5,30,8],[2,2,2,11],[31,1,31,4],[31,5,31,8],[31,9,31,11],[39,9,39,11],[37,9,37,11],[33,9,33,11],[32,5,32,8],[32,9,32,11],[37,1,37,4],[41,1,41,4],[41,5,41,8],[32,1,32,4],[39,1,39,4],[39,5,39,8],[36,1,36,4],[36,5,36,8],[34,1,34,4],[33,1,33,4],[33,5,33,8],[41,9,41,11],[34,5,34,8],[46,1,46,4],[46,5,46,8],[46,9,46,11],[43,1,43,4],[43,5,43,8],[43,9,43,11],[44,1,44,4],[44,5,44,8],[44,9,44,11],[45,1,45,4],[45,5,45,8],[45,9,45,11],[42,1,42,4],[42,5,42,8],[42,9,42,11],[38,1,38,4],[38,5,38,8],[38,9,38,11],[34,9,34,11],[35,1,35,4],[35,5,35,8],[35,9,35,11],[37,5,37,8],[36,9,36,11],[24,3,24,11],[16,1,16,4],[16,5,16,8],[16,9,16,11],[17,1,17,4],[22,1,22,11],[20,3,20,4],[3,1,3,11],[17,5,17,8],[17,9,17,11],[18,1,18,4],[18,5,18,8],[18,9,18,11],[9,1,9,11],[5,3,5,11],[11,3,11,11],[15,1,15,4],[15,5,15,8],[7,3,7,4]]}
[null,"Überflutungsnachweis nach DIN 1986-100"]
[null,{"$f":"IF((Flächen!D34-Flächen!D31-Flächen!D32)<800,\"! nicht erforderlich, befestigte Fläche < 800 m2 !\",\"\")","v":"! nicht erforderlich, befestigte Fläche < 800 m2 !"}]
[]
[null,"Gleichung 20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14=150,V14,0)","v":15.3},null,{"$f":"IF(D14=200,AA14,0)","v":0}]
[null,"Vrück","=","( rD;30 * Ages - ( rD;2 * ADach * CsDach + rD;2 *AFaG * CsFaG )) * D * 60 / (10000 * 1000)"]
[]
[null,"Vrück","=",{"$f":"IF(Flächen!D34-Flächen!D31-Flächen!D32<800,0,ROUND((F17*Flächen!D34-(F30*Flächen!H33+F31*Flächen!H17))*Überflutung!B30*60/(10000*1000),2))","v":0},null,"m3"]
[]
[null,"Gleichung 21"]
[]
[null,"Vrück","=","(( rD;30 * Ages )  / 10.000 - Qvoll) * ( D * 60 ) / 1.000))"]
[]
[null,null,"DN",150,null,"Gefälle",1,"%",null,"Qvoll",{"$f":"SUM(W5:Y5)","v":15.3},null,null,null,null,null,null,null,null,null,"DN 150",{"$f":"MAX(U16:U35)","v":15.3},null,null,null,"DN 200",{"$f":"MAX(Z16:Z35)","v":28.4}]
[]
[null,"Minuten",null,null,null,"Regenspende 30a\n[l/s*ha]",null,null,null,"VRRR\n[m³]",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$14=U41,V41,0)","v":0},null,null,null,null,{"$f":"IF(G$14=Z40,AA40,0)","v":0}]
[null,5,null,null,null,{"$f":"KOSTRA!I7","v":596.70000000000005},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((ROUND(((F17*Flächen!$D$34)/10000-Überflutung!$K$14)*(Überflutung!B17*60)/1000,3))<0,\"\",(ROUND(((F17*Flächen!$D$34)/10000-Überflutung!$K$14)*(Überflutung!B17*60)/1000,3))))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,10,null,null,null,{"$f":"KOSTRA!I8","v":371.7},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((ROUND(((F18*Flächen!$D$34)/10000-Überflutung!$K$14)*(Überflutung!B18*60)/1000,3))<0,\"\",(ROUND(((F18*Flächen!$D$34)/10000-Überflutung!$K$14)*(Überflutung!B18*60)/1000,3))))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,15,null,null,null,{"$f":"KOSTRA!I9","v":277.8},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((ROUND(((F19*Flächen!$D$34)/10000-Überflutung!$K$14)*(Überflutung!B19*60)/1000,3))<0,\"\",(ROUND(((F19*Flächen!$D$34)/10000-Überflutung!$K$14)*(Überflutung!B19*60)/1000,3))))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Vrück","=",{"$f":"MAX(J17:L19)","v":0},null,"m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Gleichung 22 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.3,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,28.4]
[null,"VRRR","=","∑ AU * rD;T / 10000 * D * fZ * 0,06 - D * fZ * QDr * 0,06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"VRRR","=",{"$f":"MAX(J30:L47)","v":0},null,"m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Minuten",null,null,null,"Regenspende 2a\n[l/s*ha]",null,null,null,"VRRR\n[m³]",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,5,null,null,null,{"$f":"KOSTRA!D7","v":316.7},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F30/10000*B30*1.15*0.06-B30*1.15*Speichervolumen!C12*0.06)<0,\"\",Flächen!$H$34*F30/10000*B30*1.15*0.06-B30*1.15*Speichervolumen!C12*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,10,null,null,null,{"$f":"KOSTRA!D8","v":196.7},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F31/10000*B31*1.15*0.06-B31*1.15*Speichervolumen!C13*0.06)<0,\"\",Flächen!$H$34*F31/10000*B31*1.15*0.06-B31*1.15*Speichervolumen!C13*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,15,null,null,null,{"$f":"KOSTRA!D9","v":146.69999999999999},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F32/10000*B32*1.15*0.06-B32*1.15*Speichervolumen!C14*0.06)<0,\"\",Flächen!$H$34*F32/10000*B32*1.15*0.06-B32*1.15*Speichervolumen!C14*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,20,null,null,null,{"$f":"KOSTRA!D10","v":119.2},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F33/10000*B33*1.15*0.06-B33*1.15*Speichervolumen!C15*0.06)<0,\"\",Flächen!$H$34*F33/10000*B33*1.15*0.06-B33*1.15*Speichervolumen!C15*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,30,null,null,null,{"$f":"KOSTRA!D11","v":88.3},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F34/10000*B34*1.15*0.06-B34*1.15*Speichervolumen!C16*0.06)<0,\"\",Flächen!$H$34*F34/10000*B34*1.15*0.06-B34*1.15*Speichervolumen!C16*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,45,null,null,null,{"$f":"KOSTRA!D12","v":65.2},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F35/10000*B35*1.15*0.06-B35*1.15*Speichervolumen!C17*0.06)<0,\"\",Flächen!$H$34*F35/10000*B35*1.15*0.06-B35*1.15*Speichervolumen!C17*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,60,null,null,null,{"$f":"KOSTRA!D13","v":52.5},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F36/10000*B36*1.15*0.06-B36*1.15*Speichervolumen!C18*0.06)<0,\"\",Flächen!$H$34*F36/10000*B36*1.15*0.06-B36*1.15*Speichervolumen!C18*0.06))","v":""}]
[null,90,null,null,null,{"$f":"KOSTRA!D14","v":38.9},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F37/10000*B37*1.15*0.06-B37*1.15*Speichervolumen!C19*0.06)<0,\"\",Flächen!$H$34*F37/10000*B37*1.15*0.06-B37*1.15*Speichervolumen!C19*0.06))","v":""}]
[null,120,null,null,null,{"$f":"KOSTRA!D15","v":31.5},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F38/10000*B38*1.15*0.06-B38*1.15*Speichervolumen!C20*0.06)<0,\"\",Flächen!$H$34*F38/10000*B38*1.15*0.06-B38*1.15*Speichervolumen!C20*0.06))","v":""}]
[null,180,null,null,null,{"$f":"KOSTRA!D16","v":23.3},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F39/10000*B39*1.15*0.06-B39*1.15*Speichervolumen!C21*0.06)<0,\"\",Flächen!$H$34*F39/10000*B39*1.15*0.06-B39*1.15*Speichervolumen!C21*0.06))","v":""},null,null,null,null,null,null,null,null,null,null," cm/m"," l/s",null,null,null," cm/m"," l/s"]
[null,240,null,null,null,{"$f":"KOSTRA!D17","v":18.899999999999999},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F40/10000*B40*1.15*0.06-B40*1.15*Speichervolumen!C22*0.06)<0,\"\",Flächen!$H$34*F40/10000*B40*1.15*0.06-B40*1.15*Speichervolumen!C22*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,12.5]
[null,360,null,null,null,{"$f":"KOSTRA!D18","v":14},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F41/10000*B41*1.15*0.06-B41*1.15*Speichervolumen!C23*0.06)<0,\"\",Flächen!$H$34*F41/10000*B41*1.15*0.06-B41*1.15*Speichervolumen!C23*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.3,8.3000000000000007,null,null,null,0.3,15.4]
[null,540,null,null,null,{"$f":"KOSTRA!D19","v":10.3},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F42/10000*B42*1.15*0.06-B42*1.15*Speichervolumen!C24*0.06)<0,\"\",Flächen!$H$34*F42/10000*B42*1.15*0.06-B42*1.15*Speichervolumen!C24*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.4,9.6,null,null,null,0.4,17.8]
[null,720,null,null,null,{"$f":"KOSTRA!D20","v":8.3000000000000007},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F43/10000*B43*1.15*0.06-B43*1.15*Speichervolumen!C25*0.06)<0,\"\",Flächen!$H$34*F43/10000*B43*1.15*0.06-B43*1.15*Speichervolumen!C25*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.5,10.8,null,null,null,0.5,20]
[null,1080,null,null,null,{"$f":"KOSTRA!D21","v":6.2},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F44/10000*B44*1.15*0.06-B44*1.15*Speichervolumen!C26*0.06)<0,\"\",Flächen!$H$34*F44/10000*B44*1.15*0.06-B44*1.15*Speichervolumen!C26*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.6,11.8,null,null,null,0.6,21.9]
[null,1440,null,null,null,{"$f":"KOSTRA!D22","v":5},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F45/10000*B45*1.15*0.06-B45*1.15*Speichervolumen!C27*0.06)<0,\"\",Flächen!$H$34*F45/10000*B45*1.15*0.06-B45*1.15*Speichervolumen!C27*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.7,12.8,null,null,null,0.7,23.7]
[null,2880,null,null,null,{"$f":"KOSTRA!D23","v":3},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F46/10000*B46*1.15*0.06-B46*1.15*Speichervolumen!C28*0.06)<0,\"\",Flächen!$H$34*F46/10000*B46*1.15*0.06-B46*1.15*Speichervolumen!C28*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.8,13.7,null,null,null,0.8,25.3]
[null,4320,null,null,null,{"$f":"KOSTRA!D24","v":2.1},null,null,null,{"$f":"IF(Flächen!$D$34-Flächen!$D$31-Flächen!$D$32<800,\"\",IF((Flächen!$H$34*F47/10000*B47*1.15*0.06-B47*1.15*Speichervolumen!C29*0.06)<0,\"\",Flächen!$H$34*F47/10000*B47*1.15*0.06-B47*1.15*Speichervolumen!C29*0.06))","v":""},null,null,null,null,null,null,null,null,null,null,0.9,14.5,null,null,null,0.9,26.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15.3,null,null,null,1,28.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,16.100000000000001,null,null,null,1.1000000000000001,29.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,16.8,null,null,null,1.2,31.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,17.5,null,null,null,1.3,32.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,18.2,null,null,null,1.4,33.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,18.8,null,null,null,1.5,34.799999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,21.7,null,null,null,2,40.200000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,24.3,null,null,null,2.5,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,26.7,null,null,null,3,49.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,28.8,null,null,null,3.5,53.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,30.8,null,null,null,4,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5,32.700000000000003,null,null,null,4.5,60.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,34.5,null,null,null,5,63.8]

{"sheet":"Zusammenstellung","index":9,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,1,46,4],[44,1,44,4],[32,1,32,4],[22,1,22,4],[3,2,3,5],[4,2,4,5],[5,2,5,5],[6,4,6,5],[9,2,9,5]]}
[null,"Zusammenstellung der Ergebnisse"]
[]
[null,"Bauherr*in"]
[null,"Vorname:",{"$f":"IF(Grundstück!C4=0,\"\",Grundstück!C4)","v":""}]
[null,"Nachname:",{"$f":"IF(Grundstück!C5=0,\"\",Grundstück!C5)","v":""}]
[null,"Straße:",{"$f":"IF(Grundstück!C6=0,\"\",Grundstück!C6)","v":""}]
[null,"PLZ:",{"$f":"IF(Grundstück!C7=0,\"\",Grundstück!C7)","v":""},"Ort:",{"$f":"IF(Grundstück!E7=0,\"\",Grundstück!E7)","v":""}]
[]
[null,"Bauort"]
[null,"Straße:",{"$f":"IF(Grundstück!C10=0,\"\",Grundstück!C10)","v":""}]
[null,"Hausnummer:",{"$f":"IF(Grundstück!C11=0,\"\",Grundstück!C11)","v":""},null,"(wenn bereits vergeben)"]
[]
[]
[null,"Flächen"]
[]
[null,"∑ AFD",{"$f":"Flächen!D17","v":0},"m2",null,"∑ AU,FD",{"$f":"Flächen!H17","v":0},"m2"]
[null,"∑ AFaG",{"$f":"Flächen!D33","v":0},"m2",null,"∑ AU,FaG",{"$f":"Flächen!H33","v":0},"m2"]
[null,"∑ A",{"$f":"SUM(C16:C17)","v":0},"m2",null,"∑ AU",{"$f":"SUM(G16:G17)","v":0},"m2"]
[]
[]
[null,"Schmutzwasser"]
[]
[null,"Schmutzwassermenge",null,null,null,{"$f":"Schmutzwasser!H34","v":0},"l/s"]
[null,"Anschlussgröße DN",null,null,null,{"$f":"Schmutzwasser!D37","v":150},"-"]
[]
[]
[null,"Regenwasser"]
[]
[null,"Regenrückhaltung"]
[null,"Regenwasseranfall",null,null,null,{"$f":"Speichervolumen!Q23*Speichervolumen!C7","v":0},"l/s"]
[null,"QDr,max",null,null,null,{"$f":"Speichervolumen!N25","v":0},"l/s"]
[null,"Anschlussgröße DN",null,null,null,{"$f":"Überflutung!D14","v":150},"-"]
[null,"Rückhaltevolumen nach A 117",null,null,null,{"$f":"Speichervolumen!N20","v":0},"m3",null,null,null,null,{"$f":"F33","v":0}]
[]
[null,"Überflutungsnachweis"]
[null,{"$f":"IF(F39<800,\"Nachweis nicht erforderlich, befestigte Fläche < 800 m2 !\",\"\")","v":"Nachweis nicht erforderlich, befestigte Fläche < 800 m2 !"}]
[]
[null,"Grundstücksgröße AG",null,null,null,{"$f":"Grundstück!F25","v":0},"m2"]
[null,"befestigte angeschlossene Fläche",null,null,null,{"$f":"Flächen!D34-Flächen!D31-Flächen!D32","v":0},"m2"]
[]
[null,"Rückhaltevolumen DIN 1986",null,null,"Gl. 20",{"$f":"Überflutung!D8","v":0},"m3",null,null,null,null,{"$f":"F41","v":0}]
[null,"Rückhaltevolumen DIN 1986",null,null,"Gl. 21",{"$f":"Überflutung!D21","v":0},"m3",null,null,null,null,{"$f":"F42","v":0}]
[null,"Rückhaltevolumen DIN 1986",null,null,"Gl. 22",{"$f":"Überflutung!D27","v":0},"m3",null,null,null,null,{"$f":"F43","v":0}]
[]
[null,"Maßgebliches Rückhaltevolumen nach DIN 1986",null,null,null,{"$f":"MAX(F41:F43)","v":0},"m3"]
[]
[null,{"$f":"IF(F39>800,\"Das zusätzlich zum Rückhaltevolumen nach A 117 zu schaffende Volumen nach DIN 1986 beträgt:\",\"Das erforderliche Rückhaltevolumen entspricht dem Volumen nach A 117 und beträgt:\")","v":"Das erforderliche Rückhaltevolumen entspricht dem Volumen nach A 117 und beträgt:"},null,null,null,{"$f":"IF(Flächen!D34-Flächen!D31-Flächen!D32<800,Zusammenstellung!F33,Zusammenstellung!F45-Zusammenstellung!F33)","v":0},"m3"]