{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Eingabe","B21","B22","B4","B5a","B5b","B6","Codes"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":11,"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":"Eingabe","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,1,16,3],[17,1,17,3],[5,1,5,4],[6,1,6,4],[7,1,7,4],[9,1,9,4],[14,1,14,3],[15,1,15,3]]}
["Eingabe"]
["Liegenschaftsentwässerung"]
[]
["Fachplaner",null,null,null,null,null,null,"Diese Datei enthält Makros!"]
[]
["Ingenieurbüro",null,null,null,null,null,null,"Klicken Sie auf der Statusleiste auf Inhalt aktivieren."]
["Adresse",null,null,null,null,null,null,"Die Datei wird geöffnet und ist ein vertrauenswürdiges Dokument."]
["PLZ, Ort",null,null,null,null,null,null,"Hilfe: Aktivieren oder Deaktivieren von Makros in Office-Dateien"]
[]
["Speicherort für PDF-Dateien",{"$f":"LEFT(CELL(\"dateiname\"),SEARCH(\"[\",CELL(\"dateiname\"))-2)","v":"J:\\6000 Allgemeine Projekte\\6328 Liegenschaftsentwaess einh Handhab\\Dokumente 2021\\Datenabgabe\\Abgabe AZV 20220222\\Formulare_Berechnungshilfen\\Berechnungshilfen"}]
[]
[]
["Bauobjekt"]
[]
["Gemeinde:"]
["Objekt:"]
["Bauherr:"]
["Architekt:"]
["Parzellen-Nr."]
["Parzellenfläche",null,"m2"]

{"sheet":"B21","index":1,"n_rows":50,"n_cols":19,"rows_kept":50,"cut":false,"hidden":false,"merged":[[46,0,46,1],[46,3,46,12],[47,3,47,12],[48,3,48,12],[42,0,42,1],[42,3,42,12],[43,0,44,1],[43,3,44,12],[43,13,44,13],[45,3,45,12],[39,0,39,1],[39,3,39,12],[40,0,40,1],[40,3,40,12],[41,0,41,1],[41,3,41,12],[36,0,36,1],[36,3,36,12],[37,0,37,1],[37,3,37,12],[38,0,38,1],[38,3,38,12],[35,0,35,1],[35,3,35,12],[29,0,29,1],[29,3,29,12],[30,0,30,1],[30,3,30,12],[31,0,31,1],[31,3,31,12],[32,0,32,1],[32,3,32,12],[33,0,33,1],[33,3,33,12],[34,3,34,12],[21,16,21,17],[23,6,23,12],[27,0,27,1],[27,3,27,12],[28,0,28,1],[28,3,28,12],[13,16,14,18],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,13],[5,0,5,1],[5,2,5,13],[6,0,6,1],[6,2,6,13],[7,2,7,13],[9,3,9,5],[10,3,10,5]]}
["B2","Nachweis Abflussbeiwert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDF-Druck Formular"]
[null,"Liegenschaftsentwässerung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B21 und B22"]
[]
["Gemeinde",null,{"$f":"IF(Eingabe!B15=\"\",\"\",Eingabe!B15)","v":""},null,null,"Parzellen-Nr.:",{"$f":"IF(Eingabe!B19=\"\",\"\",Eingabe!B19)","v":""}]
["Objekt",null,{"$f":"IF(Eingabe!B16=\"\",\"\",Eingabe!B16)","v":""}]
["Bauherr",null,{"$f":"IF(Eingabe!B17=\"\",\"\",Eingabe!B17)","v":""}]
["Architekt",null,{"$f":"IF(Eingabe!B18=\"\",\"\",Eingabe!B18)","v":""}]
["Fachplaner",null,{"$f":"IF(Eingabe!B6=\"\",\"\",Eingabe!B6&\", \"&Eingabe!B7&\", \"&Eingabe!B8)","v":""}]
[]
["Abwassersystem:",null,null,null,null,null,"(vgl. Wegleitung 2021, Kapitel 7)"]
["Bauzone:"]
["Versickerung erforderlich:"]
[null,null,null,"mit","ohne Versickerung",null,null,null,null,null,null,null,null,null,null,null,"ACHTUNG"]
["Abflussbeiwert nach GEP:",null,null,null,null,null,"(vgl. Wegleitung 2021, Kapitel 8)",null,null,null,null,null,null,null,null,null,"Ausgewiesene Fläche entspricht nicht der Summe aller Flächen im Formular B2 auf Seite 2."]
[]
["Parz. Fläche:",null,null,{"$f":"Eingabe!B20","v":0},"m2",null,null,null,null,null,null,null,null,null,null,null,"ausgewiesene Fläche:",{"$f":"D16","v":0},"m2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe der Flächen (S. 2)",{"$f":"'B22'!D12+'B22'!D21+'B22'!D30+'B22'!D39","v":0},"m2"]
["Regenspende r:",null,null,{"$f":"0.036*D19","v":3.5999999999999997E-2},"l/s m2",null,null,null,null,null,null,null,null,null,null,null,"Differenz:",{"$f":"R17-R16","v":0},"m2"]
["Sicherheitsfaktor SF:",null,null,1,null,null,"(vgl. SN 592 000, Kapitel 7.3.3)"]
[]
[]
["Nachweis Abflussbeiwert",null,null,"MW","RW","Total"]
["zulässiger Abflussbeiwert:",null,null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,Codes!B29:E32,3,FALSE))","v":""},{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,Codes!B29:E32,4,FALSE))","v":""},{"$f":"IF(D12=\"Nein\",E14,D14)","v":0},null,"Fred,zul=",{"$f":"F23*D16","v":0},"Fred,vorh=",{"$f":"'B22'!K30+'B22'!K39","v":0},{"$f":"IF('B22'!J30+'B22'!J39>0,\"(mit Retention)\",\"\")","v":""}]
["errechneter Abflussbeiwert:",null,null,{"$f":"IFERROR(IF('B22'!K39=\"\",\"\",'B22'!K39/$D$16),0)","v":0},{"$f":"IFERROR(IF('B22'!K30=\"\",\"\",'B22'!K30/$D$16),0)","v":0},{"$f":"SUM(D24:E24)","v":0},{"$f":"IF(F24>F23,\"GEP-Bedingungen NICHT erfüllt\",IF(OR(D23<D24,E23<E24),\"GEP-Bedingungen teilweise NICHT erfüllt\",\"GEP-Bedingungen erfüllt\"))","v":"GEP-Bedingungen erfüllt"}]
[]
[]
["Beregnete, homogene Fläche",null,null,null,null,null,null,null,null,null,null,null,null,"C",null,null,"C-Wert für Technische Dachretention manuell eingeben gemäss Herstellerangaben"]
["Gebäude",null,null,"Schräg- u. Flachdächer befestigt, unabhängig v. Material u. Dachhaut",null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,"Flachdach bekiest (Kiesklebedach)",null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,"Flachdach humusiert1), Aufbaudicke         > 50 cm",null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,"Flachdach humusiert1), Aufbaudicke      26-50 cm",null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,"Flachdach humusiert1), Aufbaudicke      10-25 cm",null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,"Flachdach humusiert1), Aufbaudicke         < 10 cm",null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,"Technische Dachretention (Nachweis erforderlich)"]
["Plätze / Wege",null,null,"Hartbeläge undurchlässig",null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,"Hartbeläge durchlässig (Sickerbeläge)",null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,"Kiesbelag",null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,"Pflaster mit Fugenverschluss",null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,"Plaster mit normalen Sandfugen",null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,"Pflaster mit Ökosystem (Splittfugen / Rasenfugen)",null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,"Pflaster mit Sickersteinen ",null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,"Pflaster mit Rasengittersteinen",null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,"Gartenplatten mit Splitt- u. Sandfugen",null,null,null,null,null,null,null,null,null,0.6]
["Kultivierte Flächen",null,null,"Wasserdurchlässige Flächen ohne definierte Wasserableitung, aber dennoch abflusswirksam:"]
[]
[null,null,null,"- Parkanlagen und Vegetationsschichten",null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,"- Wiese, Acker",null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,"- Bestockte Flächen",null,null,null,null,null,null,null,null,null,0.05]
["Gewässer",null,null,"Biotope, Schwimmbäder, etc.",null,null,null,null,null,null,null,null,null,1]
["1)gültig bis 15° Dachneigung (C um 0.10 erhöhen, wenn Dachneigung grösser ist)"]

{"sheet":"B22","index":2,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,2,39,9],[41,0,43,9],[22,9,23,9],[22,10,23,10],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,33,7],[31,8,32,8],[31,9,32,9],[31,10,32,10],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,6],[31,11,32,11],[22,11,23,11],[22,7,24,7],[22,8,23,8],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,6,7],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6]]}
["B2","Nachweis Abflussbeiwert"]
[null,"Liegenschaftsentwässerung",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(O3:O32)","v":0}]
[]
[]
["A","Oberflächenversickerung (nicht Abflusswirksam)",null,"Fläche","Abfluss-beiwert","Fred","Abfluss",null,null,null,null,"Beispiel",null,null,{"$f":"IF(ROW(A14)<59,\"\",ROW()-1)","v":""}]
[]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","[m2]","[-]","[m2]","[l/s]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle1[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle1[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle1[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle1[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle1[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle1[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle1[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle1[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle1[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle1[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle1[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle1[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle1[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle1[[#This Row],[Fred]])","v":""}]
[null,null,"Total A",{"$f":"SUM(D9:D11)","v":0},null,{"$f":"SUM(F9:F11)","v":0},{"$f":"SUM(G9:G11)","v":0}]
[]
["B","Ableitung zur Versickerungsanlage",null,"Fläche","Abfluss-beiwert","Fred","Abfluss",null,null,null,null,null,null,null,{"$f":"IF(ROW(A23)<59,\"\",ROW()-1)","v":""}]
[]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","[m2]","[-]","[m2]","[l/s]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle2[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle2[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle2[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle2[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle2[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle2[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle2[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle2[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle2[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle2[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle2[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle2[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle2[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle2[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle2[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle2[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle2[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle2[[#This Row],[Fred]])","v":""}]
[null,null,"Total B",{"$f":"SUM(D18:D20)","v":0},null,{"$f":"SUM(F18:F20)","v":0},{"$f":"SUM(G18:G20)","v":0}]
[]
["C","Ableitung in Gewässer / Regenwasserleitung",null,"Fläche","Abfluss-beiwert","Fred","Abfluss\nohne Ret","Retention","fR","Fred,R","Fred od. Fred,R","Abfluss\nmit Ret",null,null,{"$f":"IF(ROW(A32)<59,\"\",ROW()-1)","v":""}]
[]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","[m2]","[-]","[m2]","[l/s]",null,"[-]","[m2]","[m2]","[l/s]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","Abfluss","R","fR","FredR","Feff","Abfluss eff"]
[null,null,null,null,{"$f":"IF(Tabelle3[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle3[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle3[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle3[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle3[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle3[[#This Row],[Fred]])","v":""},null,{"$f":"IF(Tabelle3[[#This Row],[R]]=\"\",\"\",INDEX(B5a!$J$4:$J$8,Tabelle3[[#This Row],[R]],1))","v":""},{"$f":"IF(Tabelle3[[#This Row],[fR]]=\"\",\"\",PRODUCT(Tabelle3[[#This Row],[Fred]],Tabelle3[[#This Row],[fR]]))","v":""},{"$f":"IF(Tabelle3[[#This Row],[fR]]=\"\",Tabelle3[[#This Row],[Fred]],Tabelle3[[#This Row],[FredR]])","v":""},{"$f":"IF(Tabelle3[[#This Row],[FredR]]<>\"\",Tabelle3[[#This Row],[FredR]]*0.025,Tabelle3[[#This Row],[Abfluss]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle3[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle3[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle3[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle3[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle3[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle3[[#This Row],[Fred]])","v":""},null,{"$f":"IF(Tabelle3[[#This Row],[R]]=\"\",\"\",INDEX(B5a!$J$4:$J$8,Tabelle3[[#This Row],[R]],1))","v":""},{"$f":"IF(Tabelle3[[#This Row],[fR]]=\"\",\"\",PRODUCT(Tabelle3[[#This Row],[Fred]],Tabelle3[[#This Row],[fR]]))","v":""},{"$f":"IF(Tabelle3[[#This Row],[fR]]=\"\",Tabelle3[[#This Row],[Fred]],Tabelle3[[#This Row],[FredR]])","v":""},{"$f":"IF(Tabelle3[[#This Row],[FredR]]<>\"\",Tabelle3[[#This Row],[FredR]]*0.025,Tabelle3[[#This Row],[Abfluss]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle3[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle3[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle3[[#This Row],[C]]=\"\",\"\",PRODUCT(Tabelle3[[#This Row],[Fläche]:[C]]))","v":""},{"$f":"IF(Tabelle3[[#This Row],[Fred]]=\"\",\"\",'B21'!$D$18*Tabelle3[[#This Row],[Fred]])","v":""},null,{"$f":"IF(Tabelle3[[#This Row],[R]]=\"\",\"\",INDEX(B5a!$J$4:$J$8,Tabelle3[[#This Row],[R]],1))","v":""},{"$f":"IF(Tabelle3[[#This Row],[fR]]=\"\",\"\",PRODUCT(Tabelle3[[#This Row],[Fred]],Tabelle3[[#This Row],[fR]]))","v":""},{"$f":"IF(Tabelle3[[#This Row],[fR]]=\"\",Tabelle3[[#This Row],[Fred]],Tabelle3[[#This Row],[FredR]])","v":""},{"$f":"IF(Tabelle3[[#This Row],[FredR]]<>\"\",Tabelle3[[#This Row],[FredR]]*0.025,Tabelle3[[#This Row],[Abfluss]])","v":""}]
[null,null,"Total C",{"$f":"SUM(D27:D29)","v":0},null,{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":0},null,null,{"$f":"SUM(J27:J29)","v":0},{"$f":"SUM(K27:K29)","v":0},{"$f":"SUM(L27:L29)","v":0}]
[]
["D","Ableitung in Schmutz- bzw. Mischwasserkanalisation",null,"Fläche","yH","Fred","Abfluss\nohne Ret","Retention","fR","Fred,R","Fred od. Fred,R","Abfluss\nmit Ret",null,null,{"$f":"IF(ROW(K44)<59,\"\",ROW()-1)","v":""}]
[]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","[m2]","[-]","[m2]","[l/s]",null,"[-]","[m2]","[m2]","[l/s]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","Abfluss","R","fR","FredR","Feff","Abfluss eff"]
[null,null,null,null,{"$f":"IF('B22'!$C36=\"\",\"\",VLOOKUP('B22'!$C36,Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF('B22'!$E36=\"\",\"\",PRODUCT('B22'!$D36:$E36))","v":""},{"$f":"IF('B22'!$F36=\"\",\"\",'B21'!$D$18*'B22'!$F36)","v":""},null,{"$f":"IF('B22'!$H36=\"\",\"\",INDEX(B5a!$J$4:$J$8,'B22'!$H36,1))","v":""},{"$f":"IF('B22'!$I36=\"\",\"\",PRODUCT('B22'!$F36,'B22'!$I36))","v":""},{"$f":"IF('B22'!$I36=\"\",'B22'!$F36,'B22'!$J36)","v":""},{"$f":"IF(Tabelle4[[#This Row],[FredR]]<>\"\",Tabelle4[[#This Row],[FredR]]*0.025,Tabelle4[[#This Row],[Abfluss]])","v":""}]
[null,null,null,null,{"$f":"IF('B22'!$C37=\"\",\"\",VLOOKUP('B22'!$C37,Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF('B22'!$E37=\"\",\"\",PRODUCT('B22'!$D37:$E37))","v":""},{"$f":"IF('B22'!$F37=\"\",\"\",'B21'!$D$18*'B22'!$F37)","v":""},null,{"$f":"IF('B22'!$H37=\"\",\"\",INDEX(B5a!$J$4:$J$8,'B22'!$H37,1))","v":""},{"$f":"IF('B22'!$I37=\"\",\"\",PRODUCT('B22'!$F37,'B22'!$I37))","v":""},{"$f":"IF('B22'!$I37=\"\",'B22'!$F37,'B22'!$J37)","v":""},{"$f":"IF(Tabelle4[[#This Row],[FredR]]<>\"\",Tabelle4[[#This Row],[FredR]]*0.025,Tabelle4[[#This Row],[Abfluss]])","v":""}]
[null,null,null,null,{"$f":"IF('B22'!$C38=\"\",\"\",VLOOKUP('B22'!$C38,Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF('B22'!$E38=\"\",\"\",PRODUCT('B22'!$D38:$E38))","v":""},{"$f":"IF('B22'!$F38=\"\",\"\",'B21'!$D$18*'B22'!$F38)","v":""},null,{"$f":"IF('B22'!$H38=\"\",\"\",INDEX(B5a!$J$4:$J$8,'B22'!$H38,1))","v":""},{"$f":"IF('B22'!$I38=\"\",\"\",PRODUCT('B22'!$F38,'B22'!$I38))","v":""},{"$f":"IF('B22'!$I38=\"\",'B22'!$F38,'B22'!$J38)","v":""},{"$f":"IF(Tabelle4[[#This Row],[FredR]]<>\"\",Tabelle4[[#This Row],[FredR]]*0.025,Tabelle4[[#This Row],[Abfluss]])","v":""}]
[null,null,"Total D",{"$f":"SUM(D36:D38)","v":0},null,{"$f":"SUM(F36:F38)","v":0},{"$f":"SUM(G36:G38)","v":0},null,null,{"$f":"SUM(J36:J38)","v":0},{"$f":"SUM(K36:K38)","v":0},{"$f":"SUM(L36:L38)","v":0}]
[]
["Bemerkung:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'B21'!D16","v":0},"Grundstückfläche"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'B22'!D12+'B22'!D21+'B22'!D30+'B22'!D39","v":0},"ausgewiesene Fläche"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K43-K42","v":0},"Differenz"]

{"sheet":"B4","index":3,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":false,"merged":[[44,1,44,6],[45,1,45,6],[46,1,46,2],[49,1,50,9],[38,1,38,6],[39,1,39,6],[40,1,40,6],[41,1,41,6],[42,1,42,6],[43,1,43,6],[37,1,37,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[31,1,31,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[25,1,25,6],[4,2,4,9],[5,2,5,9],[6,2,6,9],[7,2,7,9],[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[24,1,24,6]]}
["B4","Berechnung massgebender Abwasseranfall",null,null,null,null,null,null,null,null,null,null,null,null,"B4 Abwasseranfall"]
[null,"Liegenschaftsentwässerung"]
[]
["Gemeinde",null,{"$f":"IF('B21'!$C$4:$D$4=\"\",\"\",'B21'!$C$4:$D$4)","v":""},"Parzellen-Nr.:",{"$f":"IF('B21'!$G$4=\"\",\"\",'B21'!$G$4)","v":""}]
["Objekt",null,{"$f":"IF('B21'!$C$5:$J$5=\"\",\"\",'B21'!$C$5:$J$5)","v":""}]
["Bauherr",null,{"$f":"IF('B21'!$C$6:$J$6=\"\",\"\",'B21'!$C$6:$J$6)","v":""}]
["Architekt",null,{"$f":"IF('B21'!$C$7:$J$7=\"\",\"\",'B21'!$C$7:$J$7)","v":""}]
["Fachplaner",null,{"$f":"IF('B21'!$C$8:$J$8=\"\",\"\",'B21'!$C$8:$J$8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"K= 0.5 bei unregelmässiger Benutzung z.B. in Wohnhäusern, Pensionen, Büros"]
["Abwasseranfall",null,null,null,null,"SW / MW",null,"RW",null,null,null,"K= 0.7 bei regelmässiger Benutzung z.B. in Krankenhäusern, Schulen, Restaurants, Hotels"]
["Schmutzwasser (vgl. Tabelle 1)        Abflusskennzahl K =",null,null,null,0.5,{"$f":"IF(E11*SQRT(J47)<MAX(O19:O46),MAX(O19:O46),E11*SQRT(J47))","v":0},"l/s 1)",null,null,null,null,"K= 1.0 bei häufiger Benutzung, z.B. in öffentlichen Toiletten und/oder Duschen"]
["Niederschlagswasser (vgl. Beilage B2: Total C bzw. Total D)",null,null,null,null,{"$f":"'B22'!L39","v":0},"l/s",{"$f":"'B22'!L30","v":0},"l/s",null,null,"L= 1.2 bei spezieller Benutzung, z.B. Labor"]
["Dauerabfluss",null,null,null,null,0,"l/s",0,"l/s",null,null,"manuelle Eingabe"]
["Hebeanlage (maximale Pumpen-Fördermenge)",null,null,null,null,0,"l/s",0,"l/s",null,null,"manuelle Eingabe (vgl. Berechnungsbeilagen Hebeanlagen)"]
["Total",null,null,null,null,{"$f":"SUM(F11:F14)","v":0},"l/s",{"$f":"SUM(H11:H14)","v":0},"l/s"]
["Gesamtabfluss SW/MW + RW",null,null,null,null,{"$f":"F15+H15","v":0},"l/s"]
[]
[null,"Entwässerungsgegenstand",null,null,null,null,null,"Schmutz-wasserwert\nDU [l/s]","Anzahl\n\n","Total\n\nDU [l/s]"]
[null,"Urinal wasserlos",null,null,null,null,null,0.1,null,{"$f":"H19*I19","v":0},null,null,null,null,{"$f":"IF(I19=\"\",\"\",H19)","v":""}]
[null,"Standurinal pro Person",null,null,null,null,null,0.2,null,0,null,null,null,null,{"$f":"IF(I20=\"\",\"\",H20)","v":""}]
[null,"Waschtisch, Wandbecken, Bidet",null,null,null,null,null,0.5,null,0,null,null,null,null,""]
[null,"Urinal mit Druckspüler",null,null,null,null,null,0.5,null,0,null,null,null,null,""]
[null,"Schulwandbrunnen",null,null,null,null,null,0.5,null,0,null,null,null,null,""]
[null,"Waschrinne mit 3 Entnahmestellen",null,null,null,null,null,0.5,null,0,null,null,null,null,""]
[null,"Wäschezentrifuge bis 10 kg",null,null,null,null,null,0.5,null,0,null,null,null,null,{"$f":"IF(I25=\"\",\"\",H25)","v":""}]
[null,"Dusche nicht staubar",null,null,null,null,null,0.6,null,0,null,null,null,null,""]
[null,"Bodenablauf DN 50",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Dusche staubar",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Urinal mit Spülkasten",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Badewanne",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Waschrinne 4-10 Entnahmestellen",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Wandausgussbecken, Spültisch 1- und 2-fach",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Waschfontäne 6-10 Entnahmestellen",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Waschtrog, Geschirrspülmaschine Haushalt",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Waschmaschine bis 6kg",null,null,null,null,null,0.8,null,0,null,null,null,null,""]
[null,"Bodenablauf DN 56",null,null,null,null,null,1,null,0,null,null,null,null,""]
[null,"Waschmaschine 7-12 kg",null,null,null,null,null,1.5,null,0,null,null,null,null,""]
[null,"Geschirrspülmaschine Gewerbe",null,null,null,null,null,1.5,null,0,null,null,null,null,""]
[null,"Bodenablauf DN 70",null,null,null,null,null,1.5,null,0,null,null,null,null,""]
[null,"Klosettanlage 6l oder 7.5l Spülwassermenge",null,null,null,null,null,2,null,0,null,null,null,null,""]
[null,"Bodenablauf DN 100",null,null,null,null,null,2,null,0,null,null,null,null,""]
[null,"Stand-/Wandausguss (Fäkalien/Putzwasser)",null,null,null,null,null,2.5,null,0,null,null,null,null,""]
[null,"Waschmaschine 13-40 kg",null,null,null,null,null,2.5,null,0,null,null,null,null,""]
[null,"Steckbeckenapparat",null,null,null,null,null,2.5,null,0,null,null,null,null,""]
[null,"Klosettanlage 9l Spülwassermenge",null,null,null,null,null,2.5,null,0,null,null,null,null,""]
[null,"Grosswanne, Saunatauchbecken",null,null,null,null,null,2.5,null,0,null,null,null,null,""]
[null,"Summe DU",null,null,null,null,null,null,null,{"$f":"SUM(J19:J46)","v":0}]
[]
[null,"Bemerkungen"]
[null,"Entwässerungsgegenstände, welche in eine Hebeanlage entwässern, sind in der Tabelle 1 nicht aufzuführen, sondern im separaten Berechnungsblatt der Hebeanlage."]
[]
[null,"1) Der Schmutzwasseranfall muss mindestens der Leistung des grössten Entwässerungsgegenstands entsprechen."]

{"sheet":"B5a","index":4,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["B5","Ermittlung Retentionsvolumen",null,null,null,null,null,null,null,"C  Ableitung in Gewässer / Regenwasserleitung",null,null,null,"mit Wirbeldrossel, etc."]
[null,"Liegenschaftsentwässerung",null,null,null,null,null,null,null,"D  Ableitung in Schmutz- bzw. Mischwasserkanalisation",null,null,null,"mit Lochdrossel"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"G10","v":0},null,null,null,null,{"$f":"Eingabe!B19","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G24","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G38","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"G52","v":0.4}]
[null,null,null,null,null,null,null,null,null,{"$f":"G66","v":0},null,null,null,{"$f":"MAX(N9:N80)+4","v":4},{"$f":"MIN(O9:O72)","v":{"$error":"#VALUE!"}},{"$f":"MIN(P9:P72)","v":{"$error":"#VALUE!"}}]
[]
["Retentions-Anlage Nr. 1"]
[{"$f":"INDEX(J$1:J$2,J12,1)","v":"D  Ableitung in Schmutz- bzw. Mischwasserkanalisation"}]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","Fläche","yH","Fred","Fred,R",null,null,2]
[null,null,null,"[m2]","[-]","[m2]","[m2]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle5[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle5[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle5[[#This Row],[Fläche]]=\"\",\"\",Tabelle5[[#This Row],[Fläche]]*Tabelle5[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle5[[#This Row],[Fred]]=\"\",\"\",G$10*Tabelle5[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle5[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle5[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle5[[#This Row],[Fläche]]=\"\",\"\",Tabelle5[[#This Row],[Fläche]]*Tabelle5[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle5[[#This Row],[Fred]]=\"\",\"\",G$10*Tabelle5[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle5[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle5[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle5[[#This Row],[Fläche]]=\"\",\"\",Tabelle5[[#This Row],[Fläche]]*Tabelle5[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle5[[#This Row],[Fred]]=\"\",\"\",G$10*Tabelle5[[#This Row],[Fred]])","v":""}]
[null,null,"Total",{"$f":"SUM(D15:D17)","v":0},null,{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},null,null,2,{"$f":"INDEX(N$1:N$2,J18,1)","v":"mit Lochdrossel"},null,null,{"$f":"IF(B5a!$D18>0,ROW(),\"\")","v":""},{"$f":"IF(N32<54,\"\",N18+4)","v":{"$error":"#VALUE!"}},{"$f":"IF(O$8+56<N32+4,N18+5,\"\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,"Qab",{"$f":"G18*0.025","v":0},"[l/s]"]
[null,null,null,null,null,null,null,null,null,"VR",{"$f":"J18*(SQRT(247/G10)-10)*(393*SQRT(G10)-250*G10)*F18*6*10^-6","v":{"$error":"#DIV/0!"}},"[m3]"]
[null,null,null,null,null,null,null,null,null,"Qab,Not",{"$f":"'B21'!$D$18*B5a!F18","v":0},"l/s"]
[]
["Retentions-Anlage Nr. 2"]
[{"$f":"INDEX(J$1:J$2,J26,1)","v":"D  Ableitung in Schmutz- bzw. Mischwasserkanalisation"}]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","Fläche","yH","Fred","Fred,R",null,null,2]
[null,null,null,"[m2]","[-]","[m2]","[m2]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle6[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle6[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle6[[#This Row],[Fläche]]=\"\",\"\",Tabelle6[[#This Row],[Fläche]]*Tabelle6[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle6[[#This Row],[Fred]]=\"\",\"\",G$24*Tabelle6[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle6[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle6[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle6[[#This Row],[Fläche]]=\"\",\"\",Tabelle6[[#This Row],[Fläche]]*Tabelle6[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle6[[#This Row],[Fred]]=\"\",\"\",G$24*Tabelle6[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle6[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle6[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle6[[#This Row],[Fläche]]=\"\",\"\",Tabelle6[[#This Row],[Fläche]]*Tabelle6[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle6[[#This Row],[Fred]]=\"\",\"\",G$24*Tabelle6[[#This Row],[Fred]])","v":""}]
[null,null,"Total",{"$f":"SUM(D29:D31)","v":0},null,{"$f":"SUM(F29:F31)","v":0},{"$f":"SUM(G29:G31)","v":0},null,null,2,{"$f":"INDEX(N$1:N$2,J32,1)","v":"mit Lochdrossel"},null,null,{"$f":"IF(B5a!$D32>0,ROW(),N18)","v":""},{"$f":"IF(N46<54,\"\",N32+5)","v":{"$error":"#VALUE!"}},{"$f":"IF(O$8+56<N46+4,N32+5,\"\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,"Qab",{"$f":"G32*0.025","v":0},"[l/s]"]
[null,null,null,null,null,null,null,null,null,"VR",{"$f":"J32*(SQRT(247/G24)-10)*(393*SQRT(G24)-250*G24)*F32*6*10^-6","v":{"$error":"#DIV/0!"}},"[m3]"]
[null,null,null,null,null,null,null,null,null,"Qab,Not",{"$f":"'B21'!$D$18*B5a!F32","v":0},"l/s"]
[]
["Retentions-Anlage Nr. 3"]
[{"$f":"INDEX(J$1:J$2,J40,1)","v":"D  Ableitung in Schmutz- bzw. Mischwasserkanalisation"}]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","Fläche","yH","Fred","Fred,R",null,null,2]
[null,null,null,"[m2]","[-]","[m2]","[m2]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle7[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle7[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle7[[#This Row],[Fläche]]=\"\",\"\",Tabelle7[[#This Row],[Fläche]]*Tabelle7[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle7[[#This Row],[Fred]]=\"\",\"\",G$38*Tabelle7[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle7[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle7[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle7[[#This Row],[Fläche]]=\"\",\"\",Tabelle7[[#This Row],[Fläche]]*Tabelle7[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle7[[#This Row],[Fred]]=\"\",\"\",G$38*Tabelle7[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle7[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle7[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle7[[#This Row],[Fläche]]=\"\",\"\",Tabelle7[[#This Row],[Fläche]]*Tabelle7[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle7[[#This Row],[Fred]]=\"\",\"\",G$38*Tabelle7[[#This Row],[Fred]])","v":""}]
[null,null,"Total",{"$f":"SUM(D43:D45)","v":0},null,{"$f":"SUM(F43:F45)","v":0},{"$f":"SUM(G43:G45)","v":0},null,null,2,{"$f":"INDEX(N$1:N$2,J46,1)","v":"mit Lochdrossel"},null,null,{"$f":"IF(B5a!$D46>0,ROW(),N32)","v":""},{"$f":"IF(N60<54,\"\",N46+5)","v":{"$error":"#VALUE!"}},{"$f":"IF(O$8+56<N60+4,N46+5,\"\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,"Qab",{"$f":"G46*0.025","v":0},"[l/s]"]
[null,null,null,null,null,null,null,null,null,"VR",{"$f":"J46*(SQRT(247/G38)-10)*(393*SQRT(G38)-250*G38)*F46*6*10^-6","v":{"$error":"#DIV/0!"}},"[m3]"]
[null,null,null,null,null,null,null,null,null,"Qab,Not",{"$f":"'B21'!$D$18*B5a!F46","v":0},"l/s"]
[]
["Retentions-Anlage Nr. 4",null,null,null,null,null,0.4]
[{"$f":"INDEX(J$1:J$2,J54,1)","v":"D  Ableitung in Schmutz- bzw. Mischwasserkanalisation"}]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","Fläche","yH","Fred","Fred,R",null,null,2]
[null,null,null,"[m2]","[-]","[m2]","[m2]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle8[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle8[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle8[[#This Row],[Fläche]]=\"\",\"\",Tabelle8[[#This Row],[Fläche]]*Tabelle8[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle8[[#This Row],[Fred]]=\"\",\"\",G$52*Tabelle8[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle8[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle8[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle8[[#This Row],[Fläche]]=\"\",\"\",Tabelle8[[#This Row],[Fläche]]*Tabelle8[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle8[[#This Row],[Fred]]=\"\",\"\",G$52*Tabelle8[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle8[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle8[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle8[[#This Row],[Fläche]]=\"\",\"\",Tabelle8[[#This Row],[Fläche]]*Tabelle8[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle8[[#This Row],[Fred]]=\"\",\"\",G$52*Tabelle8[[#This Row],[Fred]])","v":""}]
[null,null,"Total",{"$f":"SUM(D57:D59)","v":0},null,{"$f":"SUM(F57:F59)","v":0},{"$f":"SUM(G57:G59)","v":0},null,null,2,{"$f":"INDEX(N$1:N$2,J60,1)","v":"mit Lochdrossel"},null,null,{"$f":"IF(B5a!$D60>0,ROW(),N46)","v":""},{"$f":"IF(N74<54,\"\",N60+5)","v":{"$error":"#VALUE!"}},{"$f":"IF(O$8+56<N74+4,N60+5,\"\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,"Qab",{"$f":"G60*0.025","v":0},"[l/s]"]
[null,null,null,null,null,null,null,null,null,"VR",{"$f":"J60*(SQRT(247/G52)-10)*(393*SQRT(G52)-250*G52)*F60*6*10^-6","v":0},"[m3]"]
[null,null,null,null,null,null,null,null,null,"Qab,Not",{"$f":"'B21'!$D$18*B5a!F60","v":0},"l/s"]
[]
["Retentions-Anlage Nr. 5"]
[{"$f":"INDEX(J$1:J$2,J68,1)","v":"D  Ableitung in Schmutz- bzw. Mischwasserkanalisation"}]
["Nr.","Art der Fläche bzw. Entwässerung","Teilfläche","Fläche","yH","Fred","Fred,R",null,null,2]
[null,null,null,"[m2]","[-]","[m2]","[m2]"]
["Nr.","Bezeichnung","Teilfläche","Fläche","C","Fred","FredR"]
[null,null,null,null,{"$f":"IF(Tabelle9[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle9[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle9[[#This Row],[Fläche]]=\"\",\"\",Tabelle9[[#This Row],[Fläche]]*Tabelle9[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle9[[#This Row],[Fred]]=\"\",\"\",G$66*Tabelle9[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle9[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle9[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle9[[#This Row],[Fläche]]=\"\",\"\",Tabelle9[[#This Row],[Fläche]]*Tabelle9[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle9[[#This Row],[Fred]]=\"\",\"\",G$66*Tabelle9[[#This Row],[Fred]])","v":""}]
[null,null,null,null,{"$f":"IF(Tabelle9[[#This Row],[Teilfläche]]=\"\",\"\",VLOOKUP(Tabelle9[[#This Row],[Teilfläche]],Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(Tabelle9[[#This Row],[Fläche]]=\"\",\"\",Tabelle9[[#This Row],[Fläche]]*Tabelle9[[#This Row],[C]])","v":""},{"$f":"IF(Tabelle9[[#This Row],[Fred]]=\"\",\"\",G$66*Tabelle9[[#This Row],[Fred]])","v":""}]
[null,null,"Total",{"$f":"SUM(D71:D73)","v":0},null,{"$f":"SUM(F71:F73)","v":0},{"$f":"SUM(G71:G73)","v":0},null,null,2,{"$f":"INDEX(N$1:N$2,J74,1)","v":"mit Lochdrossel"},null,null,{"$f":"IF(B5a!$D74>0,ROW(),N60)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"Qab",{"$f":"G74*0.025","v":0},"[l/s]"]
[null,null,null,null,null,null,null,null,null,"VR",{"$f":"J74*(SQRT(247/G66)-10)*(393*SQRT(G66)-250*G66)*F74*6*10^-6","v":{"$error":"#DIV/0!"}},"[m3]"]
[null,null,null,null,null,null,null,null,null,"Qab,Not",{"$f":"'B21'!$D$18*B5a!F74","v":0},"l/s"]

{"sheet":"B5b","index":5,"n_rows":57,"n_cols":33,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,2,58,12],[17,1,17,3],[17,4,17,6],[18,1,18,3],[18,4,18,6],[19,1,19,3],[19,4,19,6],[20,1,20,3],[20,4,20,6],[23,4,23,5],[24,4,24,5],[26,0,26,12],[14,1,14,3],[14,4,14,6],[15,1,15,3],[15,4,15,6],[16,1,16,3],[16,4,16,6],[6,0,6,1],[6,2,6,12],[7,2,7,12],[11,12,13,12],[12,1,12,3],[12,4,12,6],[13,1,13,3],[13,4,13,6],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,12],[5,0,5,1],[5,2,5,12]]}
["B5","Ermittlung Retentionsvolumen"]
[null,"Liegenschaftsentwässerung"]
[]
["Gemeinde",null,{"$f":"IF('B21'!$C$4:$D$4=\"\",\"\",'B21'!$C$4:$D$4)","v":""},null,null,"Parzellen-Nr.:",{"$f":"IF('B21'!$G$4=\"\",\"\",'B21'!$G$4)","v":""}]
["Objekt",null,{"$f":"IF('B21'!$C$5:$J$5=\"\",\"\",'B21'!$C$5:$J$5)","v":""}]
["Bauherr",null,{"$f":"IF('B21'!$C$6:$J$6=\"\",\"\",'B21'!$C$6:$J$6)","v":""}]
["Architekt",null,{"$f":"IF('B21'!$C$7:$J$7=\"\",\"\",'B21'!$C$7:$J$7)","v":""}]
["Fachplaner",null,{"$f":"IF('B21'!$C$8:$J$8=\"\",\"\",'B21'!$C$8:$J$8)","v":""}]
[]
["Reduktionsfaktor:              fR =",null,null,null,null,null,"Fred,R = Fred * fR",null,null,null,"Retentionsanlage-Nr."]
[]
[null,"Ableitung in Retention",null,null,null,null,null,"Fläche","yH","Fred","fR","Fred,R","Werte aus Beilage B2 übernehmen"]
["Nr.","Art der Fläche bzw. Entwässerung",null,null,"Teilfläche",null,null,"[m2]","[-]","[m2]","[-]","[m2]"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E14=\"\",\"\",VLOOKUP(E14,Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(I14=\"\",\"\",PRODUCT(H14:I14))","v":""},{"$f":"IF(J14=\"\",\"\",D$10)","v":""},{"$f":"IF(J14=\"\",\"\",J14*K14)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",VLOOKUP(E15,Codes!$B$3:$E$25,4,FALSE))","v":""},{"$f":"IF(I15=\"\",\"\",PRODUCT(H15:I15))","v":""},{"$f":"IF(J15=\"\",\"\",D$10)","v":""},{"$f":"IF(J15=\"\",\"\",J15*K15)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E16=\"\",\"\",VLOOKUP(E16,Codes!$B$3:$E$25,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(E17=\"\",\"\",VLOOKUP(E17,Codes!$B$3:$E$25,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(E18=\"\",\"\",VLOOKUP(E18,Codes!$B$3:$E$25,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(E19=\"\",\"\",VLOOKUP(E19,Codes!$B$3:$E$25,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(E20=\"\",\"\",VLOOKUP(E20,Codes!$B$3:$E$25,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(E21=\"\",\"\",VLOOKUP(E21,Codes!$B$3:$E$25,4,FALSE))","v":""},"","",""]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H14:H21)","v":0},null,{"$f":"SUM(J14:J21)","v":0},null,{"$f":"SUM(L14:L21)","v":0}]
[]
["reduzierte Fläche",null,null,"Fred,Total",{"$f":"J22/10000","v":0},null,"[ha]"]
["gedrosselter Abfluss",null,null,"Qab",{"$f":"L22*0.025","v":0},null,"[l/s]","Qab = Fred,R,Total * 0.025 l/s m2"]
[]
["Abb. 1:  Diagramm zur Bemessung  des erforderlichen Regenrückhaltevolumens bei gegebener maximal zulässiger spezifischer\n               Abfluss- bzw. Einleitmenge qab für Liechtenstein (Jährlichkeit z = 10)"]
[]
[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,null,null,"qab","iR"]
[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,null,null,"[l/s ha]","[m3/ha]"]
[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,null,null,5,284.39999999999998]
[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,null,null,10,272.39999999999998]
[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,null,null,15,260.39999999999998]
[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,null,null,20,248.4]
[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,null,null,25,236.4]
[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,null,null,30,225.17]
[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,null,null,50,189.64]
[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,null,null,75,157.24]
[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,null,null,100,132.30000000000001]
[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,null,null,125,112.09]
[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,null,null,150,95.25]
[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,null,null,175,81]
[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,null,null,200,68.67]
[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,null,null,225,58.06]
[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,null,null,250,48.94]
[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,null,null,{"$f":"D51","v":{"$error":"#DIV/0!"}},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,null,null,null,null,null,null,null,{"$f":"D51","v":{"$error":"#DIV/0!"}},null,290]
[]
[]
[]
["1.","qab = Qab / SFred =",null,{"$f":"E25/E24","v":{"$error":"#DIV/0!"}},"l/s ha  in untere Skala als vertikale Linie eintragen"]
["2.","bei Schnittpunkt mit Kurve horizontale Linie eintragen und entsprechendes spezifisches Retentionsvolumen"]
[null,"aus linker Skala herauslesen"]
[null,"spezifisches Retentionsionsvolumen iR",null,null,null,"aus Graphik",null,"[m3/ha]"]
[null,"Notwendiges Retentionsvolumen VR",null,null,null,"iR x Fred,Total",{"$f":"G54*E24","v":0},"[m3]"]
[]
["Bemerkung:",null,"Das berechnete Retentionsvolumen IR gilt bei Verwendung eines speziellen Drosselorgans (Wirbeldrossel, Doppelblenden-Drossel, etc.). Bei der Verwendung einer einfachen Lochblende muss das rechnerisch ermittelte Retentionsvolumen IR verdoppelt werden!"]

{"sheet":"B6","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[45,5,45,6],[45,7,45,8],[45,9,45,10],[46,5,46,6],[46,7,46,8],[46,9,46,10],[43,5,43,6],[43,7,43,8],[43,9,43,10],[44,5,44,6],[44,7,44,8],[44,9,44,10],[42,5,42,6],[42,7,42,8],[42,9,42,10],[36,6,36,8],[36,9,36,10],[38,0,38,8],[40,0,40,1],[40,2,40,3],[40,5,40,8],[40,9,40,11],[41,0,41,1],[41,2,41,3],[41,5,41,6],[41,7,41,8],[41,9,41,10],[33,6,33,8],[33,9,33,10],[34,6,34,8],[34,9,34,10],[35,6,35,8],[35,9,35,10],[30,6,30,8],[30,9,30,10],[31,6,31,8],[31,9,31,10],[32,6,32,8],[32,9,32,10],[27,6,27,8],[27,9,27,10],[28,6,28,8],[28,9,28,10],[29,6,29,8],[29,9,29,10],[25,2,25,5],[6,0,6,1],[6,2,6,12],[7,2,7,12],[9,0,9,8],[11,0,11,12],[14,0,14,12],[15,0,15,12],[16,0,16,12],[17,0,17,12],[18,0,18,12],[20,0,20,8],[5,0,5,1],[5,2,5,12],[3,0,3,1],[3,2,3,4],[3,5,3,6],[4,0,4,1],[4,2,4,12]]}
["B6","Sickerversuch"]
[null,"Liegenschaftsentwässerung"]
[]
["Gemeinde",null,{"$f":"IF('B21'!$C$4:$D$4=\"\",\"\",'B21'!$C$4:$D$4)","v":""},null,null,"Parzellen-Nr.:",null,{"$f":"IF('B21'!$G$4=\"\",\"\",'B21'!$G$4)","v":""}]
["Objekt",null,{"$f":"IF('B21'!$C$5:$J$5=\"\",\"\",'B21'!$C$5:$J$5)","v":""}]
["Bauherr",null,{"$f":"IF('B21'!$C$6:$J$6=\"\",\"\",'B21'!$C$6:$J$6)","v":""}]
["Architekt",null,{"$f":"IF('B21'!$C$7:$J$7=\"\",\"\",'B21'!$C$7:$J$7)","v":""}]
["Fachplaner",null,{"$f":"IF('B21'!$C$8:$J$8=\"\",\"\",'B21'!$C$8:$J$8)","v":""}]
[]
["Versuchsdurchführung"]
[]
["- Grube (ca. 1 x 1 m) mit geraden Wänden ausheben."]
["- Die Lage und Tiefe sollte mit der künftigen Versickerungsanlage übereinstimmen."]
["- Sohle ausebnen und mit 2 Zentimeter Splitt abdecken. "]
["- Wände und Sohle sollen durch Baggerschaufel nicht verdichtet werden. Allenfalls sind diese aufzurauhen."]
["- Doppelmeter bzw. Messlatte entsprechend fixieren wobei der Nullpunkt die Grabensohle berührt"]
["- Grube vorsichtig mit Wasser bis ca. 50 cm über der Sohle – maximal bis zum Mutterboden -  füllen"]
["- Wasserspiegel alle 15 min ablesen und Messwert in Protokoll eintragen."]
["- Der Versuch ist als Kontrolle ein zweites Mal durchzuführen"]
[]
["Angaben Baggerschlitz"]
[]
["Länge  L:",null,null,"[m]",null,"mittlere Länge Lm:",null,null,"[m]","Höhe  z:",null,"[m]"]
["Breite  B:",null,null,"[m]",null,"mittlere Breite Bm:",null,null,"[m]","z = Abstand Wasserspiegel - Sohle Baggerschlitz"]
[]
["Bodentyp:",null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",\"  Sickerfähigkeit:\")","v":""},null,{"$f":"VLOOKUP(C26,G29:M37,7,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,"Bodentyp",null,null,"spezifische\nSickerleistung",null,"Einheit","Sickerfähigkeit"]
[null,null,null,null,null,null,"Grobkies",null,null,"> 100",null,"l / min·m²","sehr gut"]
[null,null,null,null,null,null,"Kies (sauber)",null,null,"> 20",null,"l / min·m²","sehr gut"]
[null,null,null,null,null,null,"Feinkies, sandig siltig",null,null,"> 10 ",null,"l / min·m²","gut"]
[null,null,null,null,null,null,"Sand siltig, kiesig ",null,null," 5 - 10",null,"l / min·m²","mässig bis gut"]
[null,null,null,null,null,null,"Kies, Sand leicht tonig",null,null," 0,5 - 5",null,"l / min·m²","mässig bis gut"]
[null,null,null,null,null,null,"Humus (unverdichtet)",null,null," 1 - 3",null,"l / min·m²","mässig"]
[null,null,null,null,null,null,"lehmiger Kies",null,null," 0,5 - 2",null,"l / min·m²","schlecht"]
[null,null,null,null,null,null,"Möräne, kiesiger Lehm",null,null,"<0,5",null,"l / min·m²","sehr schlecht"]
[null,null,null,null,null,null,"Silt, Ton",null,null,"< 0,1",null,"l / min·m²","sehr schlecht"]
[]
["Messung"]
[]
["Datum:",null,null,null,null,"Zeit",null,null,null,"Wasserhöhe",null,null,"Sickerleistung"]
["Zeit:",null,null,null,null,"t",null,"Dt",null,"h",null,"Dh","Sspez"]
[null,null,null,null,null,"[min]",null,"[min]",null,"[cm]",null,"[cm]","[l/min m2]"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(F44=\"\",\"\",F45-F44)","v":""},null,null,null,{"$f":"IF(J44=\"\",\"\",J44-J45)","v":""},{"$f":"IF(L45=\"\",\"\",H$23*H$24*L45/H45*10/(C$23*C$24+K$23*(H$23+H$24)))","v":""}]
[null,null,null,null,null,null,null,"",null,null,null,"",{"$f":"IF(L46=\"\",\"\",H$23*H$24*L46/H46*10/(C$23*C$24+K$23*(H$23+H$24)))","v":""}]
[null,null,null,null,null,null,null,"",null,null,null,"",{"$f":"IF(L47=\"\",\"\",H$23*H$24*L47/H47*10/(C$23*C$24+K$23*(H$23+H$24)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"spezifische Sickerleistung:",{"$f":"IF(SUM(M45:M47)=0,\"\",AVERAGE(M45:M47))","v":""}]
[]
[]
[]
[null,null,"Ort, Datum:",null,null,null,null,null,"Unterschrift Fachspezialist VSA Liegenschaftsentwässerung"]

{"sheet":"Codes","index":7,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[null,"Abflussbeiwert",null,null,null,"Art"]
[]
[null,"Schräg- u. Flachdächer befestigt",null,null,0.9,"DW"]
[null,"Flachdach bekiest ohne Retention",null,null,0.8,"DW"]
[null,"Flachdach bekiest mit Retention",null,null,0.25,"DW"]
[null,"Flachdach humusiert (d > 50 cm)",null,null,0.1,"DW"]
[null,"Flachdach humusiert (d = 25-50 cm)",null,null,0.2,"DW"]
[null,"Flachdach humusiert (d = 10-25 cm)",null,null,0.4,"DW"]
[null,"Flachdach humusiert (d < 10 cm)",null,null,0.7,"DW"]
[null,"Technische Dachretention",null,null,{"$f":"'B21'!N34","v":0},"DW"]
[]
[null,"Hartbeläge undurchlässig",null,null,0.9,"PW"]
[null,"Hartbeläge durchlässig (Sickerbelag)",null,null,0.6,"PW"]
[null,"Kiesbelag",null,null,0.6,"PW"]
[null,"Pflaster mit Fugenverschluss",null,null,0.8,"PW"]
[null,"Plaster mit normalen Sandfugen",null,null,0.6,"PW"]
[null,"Pflaster mit Splitt-/Rasenfugen",null,null,0.4,"PW"]
[null,"Pflaster mit Sickersteinen ",null,null,0.2,"PW"]
[null,"Pflaster mit Rasengittersteinen",null,null,0.2,"PW"]
[null,"Gartenplatten mit Splitt- / Sandfugen",null,null,0.6,"PW"]
[]
[null,"Parkanlagen und Vegetationsschichten",null,null,0.1]
[null,"Wiese, Acker",null,null,0.1]
[null,"Bestockte Flächen",null,null,0.05]
[null,"Gewässer",null,null,1]
[]
[]
[null,"Entwässerungssystem",null,"MW","RW"]
[null,"Mischsystem",null,{"$f":"'B21'!F23","v":0},0,"Schmutz- und Regenwasser im gleichen Kanal"]
[null,"Mod. Mischsystem",null,{"$f":"'B21'!F23","v":0},0,"Mischsystem mit Versickerung"]
[null,"Trennsystem",null,0,{"$f":"'B21'!F23","v":0},"Schmutz- und Regenwasser in getrenntem Kanal"]
[null,"Teil-Trennsystem",null,{"$f":"MIN(0.5*'B21'!F23,'B21'!D24)","v":0},{"$f":"'B21'!F23-D32","v":0},"Trennsystem mit verschmutztem RW in MW"]