{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":101,"n_cols":23,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,3,1,4],[0,5,1,8],[0,9,0,10],[0,11,0,13],[1,9,1,10],[1,11,1,13],[68,9,68,10],[59,7,59,8],[60,7,60,8],[61,7,61,8],[63,7,63,8],[67,9,67,10],[67,6,67,8],[68,6,68,8],[70,6,70,8],[70,9,70,10],[66,1,66,13],[67,1,67,2],[67,4,67,5],[74,1,74,7],[69,1,69,13],[26,4,26,5],[27,1,27,3],[32,1,32,3],[62,1,62,13],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[30,1,30,3],[31,1,31,3],[59,1,59,2],[59,4,59,5],[59,9,59,10],[54,1,54,11],[35,12,35,13],[36,1,36,3],[35,1,35,3],[44,1,44,3],[44,7,44,8],[43,12,43,13],[46,1,46,3],[46,7,46,8],[46,9,46,11],[37,1,37,3],[35,7,35,8],[36,5,36,6],[48,1,48,11],[40,1,40,11],[44,9,44,11],[36,18,36,22],[47,1,47,3],[47,7,47,8],[47,9,47,11],[37,18,37,22],[36,9,36,11],[13,1,13,13],[11,1,11,13],[38,7,38,8],[38,9,38,11],[26,1,26,3],[27,4,27,5],[25,4,25,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[14,1,14,13],[25,7,25,8],[25,9,25,10],[22,1,22,13],[33,1,33,5],[32,4,32,5],[32,9,32,10],[32,7,32,8],[33,7,33,11],[25,1,25,3],[28,1,28,3],[29,1,29,3],[37,7,37,8],[35,9,35,11],[3,1,3,13],[18,5,18,6],[19,5,19,6],[6,11,6,13],[7,11,7,13],[8,11,8,13],[8,3,8,8],[7,3,7,8],[5,11,5,13],[6,3,6,8],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[9,12,9,13],[12,1,12,13],[16,1,16,13],[19,7,19,8],[18,9,18,10],[19,9,19,10],[9,3,9,8],[17,12,17,13],[18,7,18,8],[100,12,100,13],[59,12,59,13],[67,12,67,13],[36,7,36,8],[82,2,82,13],[84,4,84,13],[86,4,86,13],[77,1,77,11],[78,1,78,11],[79,1,79,3],[79,6,79,9],[80,1,80,3],[80,6,80,9],[70,1,70,2],[70,4,70,5],[71,1,71,11],[55,1,55,11],[63,4,63,5],[39,7,39,8],[39,9,39,11],[37,9,37,11],[53,7,53,11],[64,1,64,11],[63,1,63,2],[75,3,75,11],[68,1,68,2],[68,4,68,5],[63,9,63,10],[38,1,38,3],[31,4,31,5],[60,1,60,2],[60,4,60,5],[43,2,43,11],[52,7,52,11],[60,9,60,10],[58,1,58,13],[44,12,44,13],[45,1,45,3],[45,7,45,8],[52,4,52,6],[39,1,39,3],[53,4,53,6],[51,6,51,11],[61,1,61,2],[61,4,61,5],[61,9,61,10],[45,9,45,11],[56,1,56,11]]}
[null,null,null,"Formular ALP",null,"Berechnung der Lagerkapazität \nfür Hofdünger und Abwasser ",null,null,null,"Gemeinde-Nr:"]
[null,null,null,null,null,null,null,null,null,"Eingang:"]
[]
[null,"Gewässerschutztechnische Beurteilung von Alpgebäuden"]
[]
[null,"     Baugesuch                    Betriebsbeurteilung",null,null,null,null,null,null,null,null,null,"= Eingabefelder"]
[null,"Name / Vorname:",null,null,null,null,null,null,null,"Telefon Nr.:"]
[null,"Adresse:",null,null,null,null,null,null,null,"PID Nr.:"]
[null,"PLZ / Ort:",null,null,null,null,null,null,null,"Parzellen Nr.:"]
[null,"Gebäudestandort:",null,null,null,null,null,null,null,"Koordinaten:"]
[]
[null,"Grundsätzliches zum Gewässerschutzvollzug \n"]
[null,"Gülle und Abwasser aus dem Stall sowie Molke und Reinigungsabwasser aus der Sennerei dürfen weder in ein Gewässer eingeleitet werden, noch im Gelände versickern. \nSämtliche Betriebe mit Nutztierhaltung müssen über genügend Güllelagerraum verfügen. Dies ermöglicht ein zeitgerechtes Ausbringen und einen wirksamen Schutz der Gewässer. \nMist muss grundsätzlich auf einer befestigten, dichten Platte gelagert werden. Die Entwässerung hat in die Güllegrube zu erfolgen. Das Lagern von Mist auf Naturboden ist verboten."]
[null,"Hinweis"]
[null,"In den Sömmerungsgebieten werden bei der Beurteilung der Hofdüngerlagereinrichtung die betrieblichen Verhältnisse berücksichtigt. Dies ist typischerweise für Alp- und Weideställe der Fall, welche meist nur im Sommerhalbjahr belegt sind. Die Bemessung der notwendigen Hofdüngeranlagen richtet sich somit nach der Länge der Alpsaison bzw. der durchschnittlichen Aufenthaltsdauer des Viehs im Stall. \nWird auf einer Alp Käse hergestellt, fallen auf die Menge verkäster Milch ca. 90% als Molke an. Falls die Molke in die Güllegrube abgeleitet wird, ist diese wie das Reinigungsabwasser aus der Sennerei und des Abwassers aus der Wohnung in die Lagerkapazität einzurechnen."]
[]
[null,"Ermitteln der Hofdüngeranlagen"]
[null,"Stallbelegung",null,null,"Eingabe Datum z.B. 14.5 ohne Punkt nach dem Monat",null,null,null,null,null,null,null,"Tage"]
[null,null,null,null,"Stallbelegung von:",null,null,"bis",null,null,null,null,"Periode 1",{"$f":"SUM(J19-F19)","v":0}]
[null,null,null,null,"von:",null,null,"bis",null,null,null,null,"Periode 2",{"$f":"SUM(J20-F20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Tage",{"$f":"SUM(N19:N20)","v":0}]
[]
[]
[null,"bis 50 Tage: 1/2 der Alpzeit",null,null,"50 bis 80 Tage: 1/3 der Alpzeit",null,null,null,null,null,null,null,null,"über 80 Tage: 1/4 der Alpzeit "]
[]
[null,"Tiere",null,null,"Anzahl Tiere",null,"GVE","Anzahl Tiere\nnur Gülle",null,"Anzahl Tiere \nGülle / Mist",null,"Anzahl Tiere \nnur Mist","Gülle m3","Mist m3","VG","FVG","LM50G","LM50M","F50G","F50M","NM","FNM"]
[null,"Milchkühe",null,null,null,null,{"$f":"SUM(E27*1)","v":0},null,null,null,null,null,{"$f":"SUM(O27+Q27)/365*N21","v":0},{"$f":"SUM(U27+R27)/365*N21","v":0},{"$f":"SUM(H27*P27)","v":0},23,{"$f":"SUM(J27*S27)","v":0},{"$f":"SUM(J27*T27)","v":0},11.5,10.5,{"$f":"SUM(L27*V27)","v":0},21]
[null,"Mutterkühe",null,null,null,null,{"$f":"SUM(E28*1)","v":0},null,null,null,null,null,{"$f":"SUM(O28+Q28)/365*N21","v":0},{"$f":"SUM(U28+R28)/365*N21","v":0},{"$f":"SUM(H28*P28)","v":0},17,{"$f":"SUM(J28*S28)","v":0},{"$f":"SUM(J28*T28)","v":0},8.5,8,{"$f":"SUM(L28*V28)","v":0},16]
[null,"Rinder > 2 Jahr",null,null,null,null,{"$f":"SUM(E29*0.6)","v":0},null,null,null,null,null,{"$f":"SUM(O29+Q29)/365*N21","v":0},{"$f":"SUM(U29+R29)/365*N21","v":0},{"$f":"SUM(H29*P29)","v":0},12,{"$f":"SUM(J29*S29)","v":0},{"$f":"SUM(J29*T29)","v":0},6,5,0,10]
[null,"Rinder 1-2 jährig",null,null,null,null,{"$f":"SUM(E30*0.4)","v":0},null,null,null,null,null,{"$f":"SUM(O30+Q30)/365*N21","v":0},{"$f":"SUM(U30+R30)/365*N21","v":0},{"$f":"SUM(H30*P30)","v":0},8,{"$f":"SUM(J30*S30)","v":0},{"$f":"SUM(J30*T30)","v":0},4,3.8,0,7.6]
[null,"Kälber",null,null,null,null,{"$f":"SUM(E31*0.18)","v":0},null,null,null,null,{"$f":"SUM(E31)","v":0},{"$f":"SUM(O31+Q31)/365*N21","v":0},{"$f":"SUM(U31)/365*N21","v":0},null,null,null,null,null,null,0,3.2]
[null,"Schweine",null,null,null,null,{"$f":"SUM(E32*0.4)","v":0},null,null,null,null,null,{"$f":"SUM(O32+Q32)/365*N21","v":0},{"$f":"SUM(U32+R32)/365*N21","v":0},{"$f":"SUM(H32*P32)","v":0},1.6,{"$f":"SUM(J32*S32)","v":0},{"$f":"SUM(J32*T32)","v":0},0.8,0.6,0,1.2]
[null,"Schafe / Ziegen",null,null,null,null,{"$f":"SUM(E33*0.18)","v":0},null,null,null,null,{"$f":"SUM(E33)","v":0},{"$f":"SUM(O33+Q33)/365*N21","v":0},{"$f":"SUM(U33)/365*N21","v":0},null,null,null,null,null,null,0,1.7]
[null,null,null,null,null,null,{"$f":"SUM(G27:G33)","v":0},"Total Hofdüngeranfall während Alpzeit",null,null,null,null,{"$f":"SUM(M27:M33)","v":0},{"$f":"SUM(N27:N33)","v":0}]
[]
[null,"Abwässer während der Alpzeit",null,null,"Anzahl","Anzahl Tage","Belegung \nim Ø in %","Was",null,"Ableitung in:",null,null,"Abwasser während Alpzeit",null,null,"Fa"]
[null,"Wohnteil",null,null,null,null,null,"Personen",null,null,null,null,{"$f":"IF(J37=\"Güllegrube\",E37*P37*N21,\"0\")","v":"0"},"m3",null,0.05]
[null,"Fremdnutzung",null,null,null,null,null,"Personen",null,null,null,null,{"$f":"IF(J38=\"Güllegrube\",E38*P38*F38,\"0\")","v":"0"},"m3",null,0.05]
[null,"Restaurant Sitzplätze innen",null,null,null,null,null,"Sitzplätze",null,null,null,null,{"$f":"IF(J39=\"Güllegrube\",E39*P39/365*F39)*G39","v":0},"m3",null,19]
[null,"Restaurant Sitzplätze aussen",null,null,null,null,null,"Sitzplätze",null,null,null,null,0,"m3",null,2.8]
[null,"Total Abwasser während der Alpzeit",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M37:M40)","v":0},"m3"]
[]
[]
[null,"August 2020","Bau- und Verkehrsdirektion, Amt für Wasser und Abfall, Reiterstrasse 11, 3011 Bern\n+41 31 633 38 11 l info.awa@be.ch l www.be.ch/awa",null,null,null,null,null,null,null,null,null,"Seite 1 von 1"]
[null,"Abwässer ausserhalb der Alpzeit",null,null,"Anzahl","Anzahl Tage","Belegung \nim Ø in %","Was",null,"Ableitung in:",null,null,"Abwasser aus Nebenerwerb",null,null,"Fa"]
[null,"Zimmer/Bett",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J46=\"Güllegrube\",E46*P46/365*F46)*G46","v":0},"m3",null,19]
[null,"Restaurant Sitzplätze innen",null,null,null,null,null,"Sitzplätze",null,null,null,null,{"$f":"IF(J47=\"Güllegrube\",E47*P47/365*F47)*G47","v":0},"m3",null,19]
[null,"Restaurant Sitzplätze aussen",null,null,null,null,null,"Sitzplätze",null,null,null,null,{"$f":"IF(J48=\"Güllegrube\",E48*P48/365*F48)*G48","v":0},"m3",null,2.8]
[null,"Total Abwasser ausserhalb der Alpzeit",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M46:M48)","v":0},"m3"]
[]
[null,"Milchverarbeitung / Käseherstellung:"]
[null,"Durchschnittliche Milchmenge pro Tag:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E53=\"Güllegrube\",E52*0.9,\"0\")","v":"0"},"Liter"]
[null,"Molkeverwertung / Beseitigung:",null,null,null,null,null,"Molkemenge verfüttert pro Tag:",null,null,null,null,null,"Liter"]
[null,"Reinigungsabwasser Ableitung in:",null,null,null,null,null,"Molkemenge in Güllengrube pro Tag:",null,null,null,null,{"$f":"SUM(M52-M53)","v":0},"Liter"]
[null,"Mindestanfall Reinigungsabwasser in Güllengrube pro Tag:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E54=\"Güllegrube\",E52,\"0\")","v":"0"},"Liter"]
[null,"Zuschlag Reinigungsabwasseranfall in Güllengrube pro Tag:",null,null,null,null,null,null,null,null,null,null,null,"Liter"]
[null,"Total Abwasser aus Käserei während der Alpzeit:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M54:M56)*N21/1000","v":0},"m3"]
[]
[null,"Güllegruben bestehend"]
[null,"Ausführung",null,"Standort","Baujahr",null,"Ø","Länge",null,"Breite",null,"Tiefe/Höhe","Volumen",null,null,"Nutzvolumen",null,"Ø","Ø Fläche",null,"Summe eckig",null,"Summe rund"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U61+W61)","v":0},"m3",null,{"$f":"SUM(L61)-0.1","v":-0.1},null,{"$f":"SUM(G61)/2","v":0},{"$f":"SUM(R61*R61*3.14)","v":0},null,{"$f":"SUM(H61*J61*P61)","v":0},null,{"$f":"SUM(S61*P61)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U62+W62)","v":0},"m3",null,{"$f":"SUM(L62)-0.1","v":-0.1},null,{"$f":"SUM(G62)/2","v":0},{"$f":"SUM(R62*R62*3.14)","v":0},null,{"$f":"SUM(H62*J62*P62)","v":0},null,{"$f":"SUM(S62*P62)","v":0}]
[null,"Neu (Ausführung)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutzvolumen",null,"Ø","Ø Fläche",null,"Summe eckig",null,"Summe rund"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U64+W64)","v":0},"m3",null,{"$f":"SUM(L64)-0.1","v":-0.1},null,{"$f":"SUM(G64)/2","v":0},{"$f":"SUM(R64*R64*3.14)","v":0},null,{"$f":"SUM(H64*J64*P64)","v":0},null,{"$f":"SUM(S64*P64)","v":0}]
[null,"Güllelagerraum Total:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M61+M62+M64)","v":0},"m3"]
[]
[null,"Mistplatz bestehend"]
[null,"Ausführung",null,"Standort","Baujahr",null,"Länge",null,null,"Breite ",null,"Stapelhöhe","Fläche",null,null,"MP Volumen",null,"Fläche mit Ableitung in GG",null,null,"MP Volumen Total "]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G69*J69)","v":0},"m2",null,{"$f":"SUM(M69*L69)","v":0},null,{"$f":"IF(B69=\"Betonplatte mit Güllegrube\",G69*J69,\"0\")","v":"0"},null,null,{"$f":"SUM(P69+P71)","v":0}]
[null,"Neu (Ausführung)",null,null,null,null,null,null,null,null,null,null,null,null,null,"MP Volumen",null,"Fläche mit Ableitung in GG"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G71*J71)","v":0},"m2",null,{"$f":"SUM(M71*L71)","v":0},null,{"$f":"IF(B71=\"Betonplatte mit Güllegrube\",G71*J71,\"0\")","v":"0"}]
[null,"Mistplatzfläche Total:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M69+M71)","v":0},"m2",null,null,null,{"$f":"SUM(R69+R71)","v":0}]
[]
[null,"Flächen welche in die Güllegrube entwässern:",null,null,null,null,null,null,null,null,null,null,null,null,"F Fläche",1.2,null,{"$f":"SUM(R72*P74)","v":0},"m3 Wasser/J"]
[null,"Laufhof/Auslauf, Wasch- und Vorplätze",null,null,null,null,null,null,null,null,null,"Fläche:",null,"m2","F Fläche",1.2,null,{"$f":"SUM(M75*P75)","v":0},"m3 Wasser/J",null,"Total",{"$f":"SUM(R74:R75)","v":0},"m3 Wasser/J"]
[null,null,null,"Abwasser von Flächen mit Ableitung in Güllegrube während der Alpzeit:",null,null,null,null,null,null,null,null,{"$f":"SUM(V75)/365*N21","v":0},"m3"]
[]
[null,"Total Gülle + Abwasser in Güllengrube während der Alpzeit:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M34+M41+M57+M76)","v":0},"m3"]
[null,"Total Abwasser in Güllengrube ausserhalb der Alpzeit:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49)","v":0},"m3"]
[null,"Mindestfläche des Mistplatzes:",null,null,{"$f":"IF(SUM((N34)/0.8/1.5)<9.9,\"10\",(SUM((N34)/0.8/1.5)))","v":"10"},"m2","bestehend und Neubau:",null,null,null,{"$f":"SUM(U69)","v":0},"m3     Manko:",{"$f":"SUM(P80)","v":0},"m2",null,{"$f":"IF(SUM(N34-U69)<=0,\"0\",SUM(N34-U69))","v":"0"}]
[null,"Mindestvolumen der Güllegruben",null,null,{"$f":"IF(N21>80,(SUM(M78)/4),IF(N21<51,(SUM(M78)/2),(SUM(M78)/3)))","v":0},"m3","bestehend und Neubau:",null,null,null,{"$f":"SUM(M65)","v":0},"m3     Manko:",{"$f":"SUM(P81)","v":0},"m3",null,{"$f":"IF(SUM(E81-K81)<=0,\"0\",SUM(E81-K81))","v":"0"}]
[]
[null,"Bemerkungen:"]
[]
[null,"Name/Vorname des Bauherrn:"]
[]
[null,"Ort und Datum:"]
[]
[null,"Betriebsinhaberin/Bauherrin:",null,null,null,null,null,null,"Der/Die Beauftragte:"]
[null,"Betriebsinhaber/Bauherr:"]
[]
[]
[]
[null,"Unterschrift:",null,null,null,null,null,null,"Unterschrift:"]
[]
[null,"Diesem Formular sind beizulegen (je ein Exemplar)"]
[null,"· Baugesuchformular 1.0"]
[null,"· Entwässerung von Grundstücken Formular 3.0"]
[null,"· Kartenausschnitt 1:25'000 mit bezeichnetem Standort"]
[null,"· Pläne des Bauvorhabens 1:100 oder 1:50 (Grundriss und Schnitte)"]
[null,"· Ingenieurbestätigung bei Bau oder Erweiterung von Güllegruben und Schwemmkanälen",null,null,null,null,null,null,null,null,null,null,"Seite 2 von 2"]

{"sheet":"Tabelle2","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[4]
[4.5]
[5]
[5.5]
[6]

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}