{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":184,"n_cols":31,"rows_kept":184,"cut":false,"hidden":false,"merged":[[119,12,119,13],[116,12,116,13],[115,12,115,13],[93,1,93,4],[101,1,101,10],[112,1,112,4],[114,7,114,11],[43,12,43,13],[154,8,154,11],[154,1,154,5],[141,8,144,13],[117,1,117,4],[148,7,148,13],[118,1,118,4],[146,1,146,5],[145,1,145,5],[142,1,142,5],[145,8,145,11],[146,8,146,11],[131,8,131,10],[130,1,130,13],[126,9,126,10],[127,9,127,10],[117,7,117,11],[118,7,118,11],[140,1,140,13],[117,12,117,13],[123,1,123,2],[105,1,105,10],[110,1,110,11],[110,12,110,13],[112,12,112,13],[113,12,113,13],[114,12,114,13],[108,1,108,10],[107,1,107,10],[109,1,109,2],[106,1,106,10],[113,7,113,11],[109,3,109,13],[116,1,116,4],[127,1,127,2],[133,1,133,2],[133,3,133,4],[134,1,134,2],[134,3,134,4],[133,11,133,13],[123,9,123,10],[177,1,177,13],[173,1,173,13],[176,1,176,13],[36,12,36,13],[42,12,42,13],[78,1,78,3],[76,1,76,3],[77,1,77,3],[74,1,74,3],[86,9,87,10],[60,1,60,3],[40,1,40,3],[41,1,41,3],[70,1,70,3],[75,1,75,3],[42,1,42,4],[51,1,51,3],[52,1,52,3],[123,3,123,4],[124,1,124,2],[118,12,118,13],[143,1,143,5],[133,8,133,10],[125,1,125,2],[175,1,175,13],[17,1,17,3],[16,12,16,13],[15,1,15,13],[18,1,18,3],[13,1,13,3],[21,7,21,8],[21,9,21,11],[161,8,161,13],[148,1,148,5],[157,3,157,13],[149,1,149,4],[151,5,151,6],[155,1,155,11],[119,1,119,11],[122,11,122,13],[144,1,144,5],[131,1,131,2],[131,3,131,4],[132,1,132,2],[132,3,132,4],[102,1,102,10],[96,1,96,4],[18,9,18,11],[5,1,5,2],[14,1,14,3],[19,9,19,11],[20,9,20,11],[20,1,20,3],[13,7,13,11],[4,7,4,10],[3,3,3,6],[7,1,7,13],[16,7,16,8],[17,7,17,8],[11,7,11,11],[14,7,14,11],[17,9,17,11],[16,9,16,11],[0,11,0,13],[0,9,0,10],[1,11,1,13],[1,9,1,10],[19,1,19,3],[0,1,1,1],[5,3,5,6],[11,1,11,3],[3,1,3,2],[4,1,4,2],[4,3,4,6],[11,12,11,13],[5,7,5,8],[16,1,16,3],[5,9,5,13],[19,7,19,8],[18,7,18,8],[3,7,3,8],[0,3,1,4],[0,5,1,8],[12,1,12,3],[12,7,12,11],[3,9,3,13],[4,11,4,13],[153,8,153,11],[174,1,174,13],[125,3,125,4],[126,3,126,4],[159,8,159,13],[124,3,124,4],[127,3,127,4],[91,1,91,4],[104,1,104,10],[134,8,134,10],[134,11,134,13],[128,9,128,10],[131,11,131,13],[132,11,132,13],[132,8,132,10],[128,1,128,2],[128,3,128,4],[152,1,152,13],[137,9,138,10],[137,11,138,13],[127,11,127,13],[128,11,128,13],[125,9,125,10],[126,1,126,2],[21,1,21,3],[20,7,20,8],[83,6,83,11],[83,12,83,13],[86,11,87,13],[78,12,78,13],[79,12,79,13],[80,12,80,13],[81,12,81,13],[82,12,82,13],[76,12,76,13],[77,12,77,13],[74,12,74,13],[75,12,75,13],[33,1,33,3],[83,1,83,4],[62,1,62,3],[71,1,71,3],[68,1,68,3],[74,6,74,10],[65,1,65,3],[81,1,81,3],[43,3,43,11],[43,1,43,2],[39,1,39,3],[75,6,82,10],[66,8,71,11],[44,11,45,13],[37,1,37,3],[61,1,61,3],[100,1,100,10],[95,1,95,4],[66,1,66,3],[89,7,89,11],[90,7,90,11],[91,7,91,11],[92,7,92,11],[93,7,93,11],[94,7,94,11],[95,7,95,11],[96,7,96,11],[89,1,89,4],[92,1,92,4],[90,1,90,4],[94,1,94,4],[98,1,98,10],[23,1,23,5],[25,1,25,3],[27,1,27,3],[24,1,24,3],[34,1,34,3],[47,6,47,13],[59,1,59,3],[58,1,58,3],[39,12,39,13],[37,12,37,13],[53,1,53,3],[54,1,54,3],[36,6,36,10],[23,6,23,13],[40,12,40,13],[41,12,41,13],[38,12,38,13],[47,1,47,5],[29,1,29,3],[28,1,28,3],[34,6,34,11],[26,1,26,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[124,9,124,10],[44,9,45,10],[63,6,63,11],[65,8,65,11],[80,1,80,3],[69,1,69,3],[67,1,67,3],[99,1,99,10],[63,1,63,4],[57,1,57,3],[79,1,79,3],[82,1,82,3],[55,1,55,4],[72,1,72,4],[72,6,72,11],[37,6,41,10],[55,6,55,11],[42,6,42,11],[48,1,48,3],[49,1,49,3],[50,1,50,3],[36,1,36,3],[38,1,38,3],[141,1,141,4],[135,1,135,2],[135,3,135,4],[135,8,135,10],[135,11,135,13],[150,1,150,11],[44,1,45,8],[86,1,87,8],[137,1,138,8],[123,11,123,13],[124,11,124,13],[125,11,125,13],[126,11,126,13],[111,0,111,16383],[121,1,121,13],[122,1,122,2],[122,3,122,4],[122,9,122,10],[115,7,115,11],[116,7,116,11],[112,7,112,11],[115,1,115,4],[114,1,114,4],[113,1,113,4]]}
[null,null,null,"Formular 4.4 ",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,"Name / Vorname:",null,null,null,null,null,"Adresse:"]
[null,"PLZ / Ort:",null,null,null,null,null,"Parzelle(n) / Baurecht-Nr.(n):"]
[null,"Betriebsstandort:",null,null,null,null,null,"Gemeinde:"]
[]
[null,"Gewässerschutztechnische Beurteilung von Landwirtschaftsbetrieben"]
[]
[null,"     Baugesuch                    Betriebsbeurteilung",null,null,null,null,null,null,null,null,"=","Eingabefelder"]
[]
[null,"Abwässer aus Haushalt ",null,null,"Anzahl Wohnungen","Bewohnbare Zimmer","Anzahl Bewohner","Ableitung \nder häuslichen\nAbwässer in:",null,null,null,null,"Abwasser aus Haushalt pro Jahr",null,null,"Fa"]
[null,"Bauernhaus",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H13=\"Güllegrube\",F13*P13,\"0\")","v":"0"},"m3",null,60]
[null,"Stöckli",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H14=\"Güllegrube\",F14*P14,\"0\")","v":"0"},"m3",null,60]
[null,"Andere Wohnungen",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H15=\"Güllegrube\",F15*P15,\"0\")","v":"0"},"m3",null,60]
[]
[null,"Abwässer aus Nebenerwerb mit Ableitung in Güllegrube",null,null,"Anzahl Bett Sitzplätze","Anzahl Tage in Betrieb","Belegung im Ø in %","Einheit",null,"Nutzung:\nSommer: Verdünnungsrelevant\nWinter: Güllegrubenvolumenrelevant",null,null,"Abwasser aus Neben-erwerb",null,null,"Fa","Sommer","Winter","Summe für 1:3"]
[null,"Restaurant innen",null,null,null,null,null,"Sitzplätze",null,null,null,null,{"$f":"IF(J18=\"im Winter (ganzes Jahr)\",E18*P18/365*F18)*G18","v":0},"m3",null,19.2,{"$f":"SUM(E18*19.2/365*F18)*G18","v":0},{"$f":"SUM(M18)","v":0},null,null,"FVG","Vollgülle"]
[null,"Rest. aussen, Saal",null,null,null,null,null,"Sitzplätze",null,null,null,null,{"$f":"IF(J19=\"im Winter (ganzes Jahr)\",E19*P19/365*F19)*G19","v":0},"m3",null,3.6,{"$f":"SUM(G19*3.6/365*E19)*F19","v":0},{"$f":"SUM(M19)","v":0},null,null,"F25G F25M","10-40% eingestreut"]
[null,"Partyraum",null,null,null,null,null,"Sitzplätze",null,null,null,null,{"$f":"IF(J20=\"im Winter (ganzes Jahr)\",E20*P20/365*F20)*G20","v":0},"m3",null,19.2,{"$f":"SUM(G20*19.2/365*E20)*F20","v":0},{"$f":"SUM(M20)","v":0},null,null,"F50G F50M","40-60% eingestreut"]
[null,"Ferien auf dem Bauernhof",null,null,null,null,null,"Bett",null,null,null,null,{"$f":"IF(J21=\"im Winter (ganzes Jahr)\",E21*P21/365*F21)*G21","v":0},"m3",null,60,{"$f":"SUM(G21*60/365*E21)*F21","v":0},{"$f":"SUM(M21)","v":0},null,null,"F75G F75M","60-90% eingestreut"]
[null,"Schlafen im Stroh",null,null,null,null,null,"Bett",null,null,null,null,{"$f":"IF(J22=\"im Winter (ganzes Jahr)\",E22*P22/365*F22)*G22","v":0},"m3",null,26.4,{"$f":"SUM(G22*26.4/365*E22)*F22","v":0},{"$f":"SUM(M22)","v":0},null,null,"FNM ","Nur Mist"]
[]
[null,"Tiere",null,null,null,null,"Aufstallungssystem und errechneter Hofdüngeranfall",null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q18:Q23)","v":0},{"$f":"SUM(R18:R23)","v":0},{"$f":"SUM(Q24-R24)","v":0}]
[null,"Rindvieh",null,null,"Stk.","GVE","Tiere\n nur Gülle","Tiere\n Gülle, wenig Mist","Tiere \nGülle / Mist","Tiere\nMist, wenig Gülle","Tiere\nnur Mist","Tiere \nnur Weidegang","Gülle m3/J","Mist m3/J","VG","FVG","LM25G","LM25M","F25G","F25M","LM50G","LM50M","F50G","F50M","LM75G","LM75M","F75G","F75M","NM","FNM"]
[null,"Milchkühe",null,null,null,{"$f":"SUM(E26*1)","v":0},null,null,null,null,null,null,{"$f":"SUM(O26+Q26+U26+Y26)","v":0},{"$f":"SUM((R26+V26+Z26+AC26)/0.8)","v":0},{"$f":"SUM(G26*P26)","v":0},23,{"$f":"SUM(H26*S26)","v":0},{"$f":"SUM(H26*T26)","v":0},17.3,5.3,{"$f":"SUM(I26*W26)","v":0},{"$f":"SUM(I26*X26)","v":0},11.5,10.5,{"$f":"SUM(J26*AA26)","v":0},{"$f":"SUM(J26*AB26)","v":0},5.8,15.8,{"$f":"SUM(K26*AD26)","v":0},21]
[null,"Mutter- und Ammenkühe",null,null,null,{"$f":"SUM(E27*1)","v":0},null,null,null,null,null,null,0,0,{"$f":"SUM(G27*P27)","v":0},17,{"$f":"SUM(H27*S27)","v":0},{"$f":"SUM(H27*T27)","v":0},12.8,4,0,0,8.5,8,{"$f":"SUM(J27*AA27)","v":0},{"$f":"SUM(J27*AB27)","v":0},4.3,12,0,16]
[null,"Mutterkuhkälber",null,null,null,{"$f":"SUM(E28*0.22)","v":0},"-","-",null,"-",null,null,0,0,null,null,null,null,null,null,0,0,2.2999999999999998,2,null,null,null,null,0,3.9]
[null,"Zuchtstier",null,null,null,{"$f":"SUM(E29*0.6)","v":0},null,null,null,null,null,null,0,0,0,18.399999999999999,{"$f":"SUM(H29*S29)","v":0},{"$f":"SUM(H29*T29)","v":0},13.8,4.2,0,0,9.1999999999999993,8.4,{"$f":"SUM(J29*AA29)","v":0},{"$f":"SUM(J29*AB29)","v":0},4.5999999999999996,12.6,0,16.8]
[null,"Aufzuchtrinder unter\n1-jährig",null,null,null,{"$f":"SUM(E30*0.23)","v":0},null,null,null,null,null,null,0,0,0,4.8,{"$f":"SUM(H30*S30)","v":0},{"$f":"SUM(H30*T30)","v":0},3.6,1.2,0,0,2.4,2.2999999999999998,{"$f":"SUM(J30*AA30)","v":0},{"$f":"SUM(J30*AB30)","v":0},1.2,3.5,0,4.5999999999999996]
[null,"Aufzuchtrinder \n1 bis 2-jährig",null,null,null,{"$f":"SUM(E31*0.4)","v":0},null,null,null,null,null,null,0,0,0,8,{"$f":"SUM(H31*S31)","v":0},{"$f":"SUM(H31*T31)","v":0},6,1.9,0,0,4,3.8,{"$f":"SUM(J31*AA31)","v":0},{"$f":"SUM(J31*AB31)","v":0},2,5.7,0,7.6]
[null,"Aufzuchtrinder über\n 2-jährig",null,null,null,{"$f":"SUM(E32*0.6)","v":0},null,null,null,null,null,null,0,0,0,12,{"$f":"SUM(H32*S32)","v":0},{"$f":"SUM(H32*T32)","v":0},9,2.5,0,0,6,5,{"$f":"SUM(J32*AA32)","v":0},{"$f":"SUM(J32*AB32)","v":0},3,7.5,0,10]
[null,"Mastkälber",null,null,null,{"$f":"SUM(E33*0.1)","v":0},"-","-","-","-",{"$f":"SUM(E33)","v":0},"-","-",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3.2]
[null,"Rindviehmastsplatz 65-\n520 kg Rindviehweidemast",null,null,null,{"$f":"SUM(E34*0.27)","v":0},null,null,null,null,null,null,{"$f":"SUM(O34+Q34+U34+Y34)","v":0},0,0,5.8,{"$f":"SUM(H34*S34)","v":0},{"$f":"SUM(H34*T34)","v":0},4.4000000000000004,1.3,{"$f":"SUM(I34*W34)","v":0},{"$f":"SUM(I34*X34)","v":0},2.9,2.6,{"$f":"SUM(J34*AA34)","v":0},{"$f":"SUM(J34*AB34)","v":0},1.5,4,0,5.3]
[null,"Total GVE Rindvieh",null,null,null,{"$f":"SUM(F26:F34)","v":0},"Total Hofdüngeranfall pro Jahr",null,null,null,null,null,{"$f":"SUM(M26:M34)","v":0},{"$f":"SUM(N26:N34)","v":0}]
[]
[null,"Pferde  ",null,null,"Stk.","GVE","Tiefstreustall, Boxenlaufstall",null,null,null,null,"GVE pro Einheit","Mist m3/J",null,"NM","FNM",null,null,null,null,"FVG","Vollgülle"]
[null,"Pferde > 3-jährig",null,null,null,{"$f":"SUM(E38*0.7)","v":0},null,null,null,null,null,0.7,{"$f":"SUM(O38/0.8)","v":0},null,{"$f":"SUM(E38*P38)","v":0},12,null,null,null,null,"F25G F25M","10-40% eingestreut"]
[null,"Stuten mit Fohlen",null,null,null,{"$f":"SUM(E39*1)","v":0},null,null,null,null,null,1,{"$f":"SUM(O39/0.8)","v":0},null,{"$f":"SUM(E39*P39)","v":0},14,null,null,null,null,"F50G F50M","40-60% eingestreut"]
[null,"Fohlen 1/2 bis 3-jährig",null,null,null,{"$f":"SUM(E40*0.5)","v":0},null,null,null,null,null,0.5,{"$f":"SUM(O40/0.8)","v":0},null,{"$f":"SUM(E40*P40)","v":0},10,null,null,null,null,"F75G F75M","60-90% eingestreut"]
[null,"Ponys, Kleinpferde, Esel",null,null,null,{"$f":"SUM(E41*0.3)","v":0},null,null,null,null,null,0.25,{"$f":"SUM(O41/0.8)","v":0},null,{"$f":"SUM(E41*P41)","v":0},3.5,null,null,null,null,"FNM ","Nur Mist"]
[null,"Maultier, Maulesel",null,null,null,{"$f":"SUM(E42*0.4)","v":0},null,null,null,null,null,0.4,{"$f":"SUM(O42/0.8)","v":0},null,{"$f":"SUM(E42*P42)","v":0},5.6,null,null,null,null,"FMSF","Faktor Mastschweineplatz"]
[null,"Total GVE Pferde",null,null,null,{"$f":"SUM(F38:F42)","v":0},"Total Hofdüngeranfall pro Jahr",null,null,null,null,null,{"$f":"SUM(M38:N42)","v":0}]
[null,"März 2020",null,"Bau- und Verkehrsdirektion, Amt für Wasser und Abfall, Reiterstrasse 11, 3013 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,"Seite 1 von 4"]
[null,"Berechnung der Lagerkapazität für Hofdünger und Abwasser",null,null,null,null,null,null,null,"Gemeinde-Nr:",null,{"$f":"SUM(L1)","v":0}]
[]
[]
[null,"Tiere",null,null,null,null,"Aufstallungssystem und errechneter Hofdüngeranfall"]
[null,"Schweine",null,null,"Platz","GVE","Platz nur Gülle","Platz Gülle, wenig Mist","Platz \nGülle / Mist","Platz \nMist, wenig Gülle","Platz \nnur Mist","MSP","Gülle m3/J","Mist m3/J","VG","FVG","LM25G","LM25M","F25G","F25M","LM50G","LM50M","F50G","F50M","LM75G","LM75M","F75G","F75M","NM","FNM","FMSP"]
[null,"Zuchtschweineplatz inkl. Ferkel bis 25 kg",null,null,null,{"$f":"SUM(E50*0.45)","v":0},null,null,null,null,null,{"$f":"SUM(G50:K50)*AE50","v":0},{"$f":"SUM(O50+Q50+U50+Y50)","v":0},{"$f":"SUM((R50+V50+Z50+AC50)/0.8)","v":0},{"$f":"SUM(G50*P50)","v":0},7.5,{"$f":"SUM(H50*S50)","v":0},{"$f":"SUM(H50*T50)","v":0},5.6,1.1000000000000001,{"$f":"SUM(I50*W50)","v":0},{"$f":"SUM(I50*X50)","v":0},3.8,2.1,{"$f":"SUM(J50*AA50)","v":0},{"$f":"SUM(J50*AB50)","v":0},1.9,3.2,{"$f":"SUM(K50*AD50)","v":0},4.2,2.65]
[null,"Mastschweineplatz 25-100kg Remonten",null,null,null,{"$f":"SUM(E51*0.17)","v":0},null,null,null,null,null,{"$f":"SUM(G51:K51)*AE51","v":0},0,0,0,1.6,0,0,1.2,0.3,0,0,0.8,0.6,0,0,0.4,0.9,0,1.2,1]
[null,"Ferkel abgesetzt",null,null,null,{"$f":"SUM(E52*0.06)","v":0},null,null,null,null,null,0,0,0,0,0.6,0,0,0.5,0.1,0,0,0.3,0.2,0,0,0.2,0.2,0,0.3,0.35]
[null,"Zuchteber",null,null,null,{"$f":"SUM(E53*0.25)","v":0},null,null,null,null,null,0,0,0,0,4.2,0,0,3.2,0.6,0,0,2.1,1.2,0,0,1.1000000000000001,1.8,0,2.2999999999999998,1.47]
[null,"Galtsauenplatz",null,null,null,{"$f":"SUM(E54*0.26)","v":0},null,null,null,null,null,0,0,0,0,5.5,0,0,4.0999999999999996,0.6,0,0,2.8,1.2,0,0,1.4,1.7,0,2.2999999999999998,1.53]
[null,"Zuchtsauenplatz säugend (AFP)",null,null,null,{"$f":"SUM(E55*0.55)","v":0},null,null,null,null,null,0,0,0,0,8.1999999999999993,0,0,6.2,0.9,0,0,4.0999999999999996,1.8,0,0,2.1,2.6,0,3.5,3.24]
[null,"Total GVE Schweine",null,null,null,{"$f":"SUM(F50:F55)","v":0},"Total Hofdüngeranfall pro Jahr",null,null,null,null,null,{"$f":"SUM(M50:M55)","v":0},{"$f":"SUM(N50:N55)","v":0}]
[]
[null,"Geflügel",null,null,"Platz","GVE","Plätze Mist Kotband","Plätze Mist Kotgrube","Plätze Kot verflüssigt","Plätze Mist verflüssigt","100 LHP pro Einheit","Anzahl \n100 LHP","Gülle m3/J","Kot m3/J","Band","FBand","KBOH","FKBOH",null,"Kver","FKVer","Mver","FMVer",null,"FLHP","FMMP","FMTP"]
[null,"Legehennenplätze ",null,null,null,{"$f":"SUM(E59*0.01)","v":0},null,null,null,null,1,{"$f":"SUM(G59:J59)/Y59","v":0},{"$f":"SUM(T59+V59)","v":0},{"$f":"SUM((O59+Q59)/0.8)","v":0},{"$f":"SUM(G59*P59)","v":0},2.7E-2,{"$f":"SUM(H59*R59)","v":0},1.4999999999999999E-2,null,{"$f":"SUM(I59*U59)","v":0},2.7E-2,{"$f":"SUM(J59*W59)","v":0},1.4999999999999999E-2,null,100,250,66.66]
[null,"Junghennenplätze",null,null,null,{"$f":"SUM(E60*0.004)","v":0},null,null,null,null,0.4,{"$f":"SUM(G60:J60)/Z59","v":0},{"$f":"SUM(T60+V60)","v":0},{"$f":"SUM((O60+Q60)/0.8)","v":0},{"$f":"SUM(G60*P60)","v":0},0.01,{"$f":"SUM(H60*R60)","v":0},6.0000000000000001E-3,null,{"$f":"SUM(I60*U60)","v":0},0.01,{"$f":"SUM(J60*W60)","v":0},6.0000000000000001E-3]
[null,"Mastpouletplätze ",null,null,null,{"$f":"SUM(E61*0.004)","v":0},null,null,null,null,0.4,{"$f":"SUM(G61:J61)/Z59","v":0},{"$f":"SUM(T61+V61)","v":0},{"$f":"SUM((O61+Q61)/0.8)","v":0},null,null,{"$f":"SUM(H61*R61)","v":0},8.0000000000000002E-3,null,null,null,{"$f":"SUM(J61*W61)","v":0},8.0000000000000002E-3]
[null,"Masttrutenplätze",null,null,null,{"$f":"SUM(E62*0.015)","v":0},null,null,null,null,1.5,{"$f":"SUM(G62:J62)/AA59","v":0},{"$f":"SUM(T62+V62)","v":0},{"$f":"SUM((O62+Q62)/0.8)","v":0},null,null,{"$f":"SUM(H62*R62)","v":0},0.03,null,null,null,{"$f":"SUM(J62*W62)","v":0},0.03]
[null,"Strausse, Emu ",null,null,null,{"$f":"SUM(E63*0.2)","v":0},null,null,null,null,1.5,{"$f":"SUM(G63:J63)/AA59","v":0},{"$f":"SUM(T63+V63)","v":0},{"$f":"SUM((O63+Q63)/0.8)","v":0},null,null,{"$f":"SUM(H63*R63)","v":0},0.02,null,null,null,{"$f":"SUM(J63*W63)","v":0},0.02]
[null,"Total GVE Geflügel",null,null,null,{"$f":"SUM(F59:F63)","v":0},"Total Hofdüngeranfall pro Jahr",null,null,null,null,null,{"$f":"SUM(M59:M63)","v":0},{"$f":"SUM(N59:N63)","v":0}]
[]
[null,"Schafe, Ziegen, Kaninchen (Zibben)",null,null,"Platz","GVE","Plätze Mist","Plätze Mist verflüssigt",null,null,null,null,"Gülle m3/J","Mist m3/J","NM","FNM","Mver","FMVer",null,null,"FBand","Kotband"]
[null,"Ziegen",null,null,null,{"$f":"SUM(E67*0.17)","v":0},null,null,null,null,null,null,{"$f":"SUM(Q67)","v":0},{"$f":"SUM(O67)/0.8","v":0},{"$f":"SUM(G67*P67)","v":0},1.7,{"$f":"SUM(H67*R67)","v":0},1.7,null,null,"FKBOH","Kotgrube"]
[null,"Milchziegen",null,null,null,{"$f":"SUM(E68*0.2)","v":0},null,null,null,null,null,null,0,0,{"$f":"SUM(G68*P68)","v":0},2,0,2,null,null,"FKVer","Kot verflüssigt"]
[null,"Schafe",null,null,null,{"$f":"SUM(E69*0.17)","v":0},null,null,null,null,null,null,0,0,0,1.7,0,1.7,null,null,"FMVer","Mist verflüssigt"]
[null,"Milchschafe",null,null,null,{"$f":"SUM(E70*0.25)","v":0},null,null,null,null,null,null,0,0,0,2.2999999999999998,0,2.2999999999999998,null,null,"FLHP","Faktor Legehennenplätz"]
[null,"Mutterkaninchen (Zibben) inkl. Jungtiere < 35 Tage",null,null,null,{"$f":"SUM(E71*0.034)","v":0},null,null,null,null,null,null,0,0,0,0.16,0,0.16,null,null,"FMMP","Faktor Mastpouletplätz"]
[null,"Jungtiere > 35 Tage",null,null,null,{"$f":"SUM(E72*0.011)","v":0},null,null,null,null,null,null,0,0,0,2.8000000000000001E-2,0,2.8000000000000001E-2,null,null,"FMTP","Faktor Masttrutenplätz"]
[null,"Total GVE Schafe, Ziegen, Kaninchen (Zibben)",null,null,null,{"$f":"SUM(F67:F72)","v":0},"Total Hofdüngeranfall pro Jahr",null,null,null,null,null,{"$f":"SUM(M67:M72)","v":0},{"$f":"SUM(N67:N72)","v":0}]
[]
[null,"Tiere Übrige",null,null,"Platz","GVE","Tiefstreustall, Boxenlaufstall",null,null,null,null,"GVE pro Einheit","Mist m3/J",null,"NM","FNM","Mver","FMVer"]
[null,"Bison > 3-jährig",null,null,null,{"$f":"SUM(E76*0.8)","v":0},null,null,null,null,null,0.8,{"$f":"SUM(O76)/0.8","v":0},null,{"$f":"SUM(E76*P76)","v":0},9.6]
[null,"Bison < 3-jährig",null,null,null,{"$f":"SUM(E77*0.4)","v":0},null,null,null,null,null,0.4,0,null,{"$f":"SUM(E77*P77)","v":0},4.4000000000000004]
[null,"Rothirsche",null,null,null,{"$f":"SUM(E78*0.2)","v":0},null,null,null,null,null,0.2,0,null,0,1.6]
[null,"Damhirsche",null,null,null,{"$f":"SUM(E79*0.1)","v":0},null,null,null,null,null,0.1,0,null,0,1.6]
[null,"Lama > 2-jährig",null,null,null,{"$f":"SUM(E80*0.17)","v":0},null,null,null,null,null,0.17,0,null,0,1.6]
[null,"Lama < 2-jährig",null,null,null,{"$f":"SUM(E81*0.11)","v":0},null,null,null,null,null,0.11,0,null,0,1.6]
[null,"Alpakas > 2-jährig",null,null,null,{"$f":"SUM(E82*0.11)","v":0},null,null,null,null,null,0.11,0,null,0,1.6]
[null,"Alpakas < 2-jährig",null,null,null,{"$f":"SUM(E83*0.07)","v":0},null,null,null,null,null,7.0000000000000007E-2,0,null,0,1.6]
[null,"Total GVE übrige Tiere",null,null,null,{"$f":"SUM(F76:F83)","v":0},"Total Hofdüngeranfall pro Jahr",null,null,null,null,null,{"$f":"SUM(M76:N83)","v":0}]
[]
[]
[null,"Berechnung der Lagerkapazität für Hofdünger und Abwasser",null,null,null,null,null,null,null,"Gemeinde-Nr:",null,{"$f":"SUM(L1)","v":0}]
[]
[]
[null,"Total Tiere",null,null,null,"Plätze","GVE","Hofdüngeranfall",null,null,null,null,"Gülle m3/J","Mist m3/J","Wasser","Faktor"]
[null,"Rindvieh",null,null,null,{"$f":"SUM(F35)","v":0},{"$f":"SUM(F35)","v":0},"Rindviehhaltung",null,null,null,null,{"$f":"SUM(M35)","v":0},{"$f":"SUM(N35)","v":0},{"$f":"SUM(F91*P91)","v":0},2.4,"Rindvieh"]
[null,"Pferde",null,null,null,{"$f":"SUM(F43)","v":0},{"$f":"SUM(F43)","v":0},"Pferdehaltung",null,null,null,null,"-",{"$f":"SUM(M43)","v":0},{"$f":"SUM(F92*P92)","v":0},2.4,"Pferde"]
[null,"Schweine (MSP)",null,null,null,{"$f":"SUM(L50:L55)","v":0},{"$f":"SUM(F56)","v":0},"Schweinehaltung",null,null,null,null,{"$f":"SUM(M56)","v":0},{"$f":"SUM(N56)","v":0},{"$f":"SUM(L50:L55)*P93","v":0},0.5,"Schweine"]
[null,"Geflügel (100 LHP)",null,null,null,{"$f":"SUM(L59:L63)","v":0},{"$f":"SUM(F64)","v":0},"Geflügelhaltung",null,null,null,null,{"$f":"SUM(M64)","v":0},{"$f":"SUM(N64)","v":0},{"$f":"SUM(L59:L60)*P94","v":0},0.25,"LHP",{"$f":"SUM(L61:L63)*S94","v":0},1.25,"MPP"]
[null,"Schafe / Ziegen / Kaninchen",null,null,null,{"$f":"SUM(F73)","v":0},{"$f":"SUM(F73)","v":0},"Schafe / Ziegen / Kaninchen (Zibben)",null,null,null,null,{"$f":"SUM(M73)","v":0},{"$f":"SUM(N73)","v":0},{"$f":"SUM(F68,F70,F71,F72)*P95","v":0},0.25,"Schafe, Ziegen, Zibben"]
[null,"Übrige",null,null,null,{"$f":"SUM(F84)","v":0},{"$f":"SUM(F84)","v":0},"Übrige",null,null,null,null,"-",{"$f":"SUM(M84)","v":0},{"$f":"SUM(F96*P96)","v":0},0,"Übrige Tiere"]
[null,"Total GVE",null,null,null,null,{"$f":"SUM(G91:G96)","v":0},"Total Gülle / Mist pro Jahr",null,null,null,null,{"$f":"SUM(M91+M93+M94+M95)","v":0},{"$f":"SUM(N91:N96)","v":0}]
[]
[null,"Abwässer aus Ställen und Flächen",null,null,null,null,null,null,null,null,null,null,null,"m3/J",null,"Faktor"]
[null,"Wasser für die Stallreinigung und Tierpflege, Rindvieh",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O91)","v":0}]
[null,"Wasser für die Stallreinigung und Tierpflege, Schweine",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O93)","v":0}]
[null,"Wasser für die Stallreinigung und Tierpflege, Pferde und übrige Tiere",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O92+O95+O96)","v":0}]
[null,"Wasser zur Reinigung von Geflügelställen            ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O94+R94)","v":0},null,null,"MP Volumen neu"]
[null,"Mistplatz neu (m)",null,null,"Länge:",null,"Breite:",null,null,"Stapelhöhe:",null,{"$f":"SUM(F104*H104)","v":0},"m2",{"$f":"SUM(L104*P104)","v":0},{"$f":"SUM(L104*P104)","v":0},1.2,{"$f":"SUM(L104*K104)","v":0}]
[null,"Flächen von befestigten und nicht überdachten Laufhöfen",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L105*P105)","v":0},{"$f":"SUM(L105*P105)","v":0},1.2]
[null,"Flächen von unüberdeckten Güllegruben / Güllesilos",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L106*P106)","v":0},0,1.2]
[null,"Flächen von Flach-, Fahrsilos",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L107*P107)","v":0},0,0.4]
[null,"Weitere in die Güllegrube entwässerte Flächen (Waschplätze, andere Flächen etc.)",null,null,null,null,null,null,null,null,null,null,"m2",{"$f":"SUM(L108*P108)","v":0},0,1.2]
[null,"Freie Korrektur Abwasser; Zuschläge oder Abzüge pro Jahr. z.B. Zuschlag Nassfütterung Schweine oder zusätzliches Abwasser Kleingewerbe. Abzug für geringeren Wasserverbrauch. (bei Zuschlag Zahl/Menge eingeben, bei Abzug vor der Zahl/Menge das Minuszeichen; z.B. -5 eingeben)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L109)","v":0}]
[null,"Begründung:"]
[null,"Total Abwasser aus den Ställen pro Jahr",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N100+N101+N102+N103+N104+N105+N106+N107+N108+N109)","v":0}]
[]
[null,"Abwässer aus Melkanlagen \nbei Ableitung in Güllegrube",null,null,null,"Ja/Nein","Anz.","Einheit",null,null,null,null,"m3/J",null,"Wasser","Faktor","F-Zusatz"]
[null,"Milchkammer",null,null,null,null,null,"Melkeinheiten",null,null,null,null,{"$f":"IF(F114=\"Ja\",O114)/12*12","v":0},null,{"$f":"IF(G114>0.9,P114)+(G114*Q114)","v":0},6,0.6]
[null,"Kühltank",null,null,null,null,null,"Liter",null,null,null,null,{"$f":"IF(F115=\"Ja\",O115)/12*12","v":0},null,{"$f":"SUM(G115*P115)","v":0},1.7999999999999999E-2]
[null,"Eimermelkanlage",null,null,null,null,null,"Melkeinheiten",null,null,null,null,0,null,{"$f":"IF(G116>0.9,P116)+(G116*Q116)","v":0},36,6]
[null,"Rohrmelkanlage",null,null,null,null,null,"Melkeinheiten",null,null,null,null,0,null,{"$f":"IF(G117>0.9,P117)+(G117*Q117)","v":0},48,6]
[null,"Melkroboter",null,null,null,null,null,"Einheit",null,null,null,null,0,null,{"$f":"IF(G118>0.9,P118)*(G118)","v":0},300,150]
[null,"Melkstand inkl. Reinigung Melkgrube",null,null,null,null,null,"Standplatz",null,null,null,null,0,null,{"$f":"IF(G119>0.9,P119)+(G119*Q119)","v":0},48,12,"Himweis: 6 pro Stamdplatz + 6 pro Melkeinheit"]
[null,"Total Abwasser aus den Melkanlagen pro Jahr",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M114:N119)","v":0}]
[]
[null,"Güllelagerraum bestehend. Nur Güllegruben angeben, welche in gutem Zustand sind oder einwandfrei instandgestellt werden können und ganzjährig uneingeschränkt nutzbar sind! (Nutzvolumen = Höhe -10 cm)"]
[null,"Standort",null,"Ausführung",null,"Baujahr","Länge","Breite","Ø","Höhe / Tiefe",null,"Nutzvolumen in m3",null,null,null,"Nutzvolumen",null,"Ø","Ø Fläche",null,"Summe eckig",null,"Summe rund"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U124+W124)","v":0},null,null,null,{"$f":"SUM(J124)-0.1","v":-0.1},null,{"$f":"SUM(I124)/2","v":0},{"$f":"SUM(R124*R124*3.14)","v":0},null,{"$f":"SUM(G124*H124*P124)","v":0},null,{"$f":"SUM(S124*P124)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U125+W125)","v":0},null,null,null,{"$f":"SUM(J125)-0.1","v":-0.1},null,0,{"$f":"SUM(R125*R125*3.14)","v":0},null,{"$f":"SUM(G125*H125*P125)","v":0},null,{"$f":"SUM(S125*P125)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U126+W126)","v":0},null,null,null,-0.1,null,0,0,null,{"$f":"SUM(G126*H126*P126)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,-0.1,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,-0.1,null,0,0,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,-0.1,null,0,0,null,0,null,0]
[]
[null,"Mistplatz bestehend. Nur Mistplätze angeben, welche in Güllegrube entwässern, oder einwandfrei instandgestellt werden können und ganzjährig uneingeschränkt nutzbar sind! (Standartstapelhöhe = 1.50 m)"]
[null,"Standort",null,"Ausführung",null,"Baujahr","Länge","Breite","Stapelhöhe",null,null,"Mistplatzfläche in m2",null,null,null,"MP Volumen",null,"Fläche mit Ableitung in GG"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G133*H133)","v":0},null,null,null,{"$f":"SUM(L133*I133)","v":0},null,{"$f":"IF(D133=\"Betonplatte mit Güllegrube\",G133*H133,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G134*H134)","v":0},null,null,null,{"$f":"SUM(L134*I134)","v":0},null,{"$f":"IF(D134=\"Betonplatte mit Güllegrube\",G134*H134,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G136*H136)","v":0},null,null,null,0,null,"0",{"$f":"SUM(R133:R136)*1.2","v":0}]
[]
[null,"Berechnung der Lagerkapazität für Hofdünger und Abwasser",null,null,null,null,null,null,null,"Gemeinde-Nr:",null,{"$f":"SUM(L31)","v":0}]
[]
[]
[null,"Ermitteln der Gülle, Platz- und Abwassermengen"]
[null,"Abwässer aus Haushalt",null,null,null,null,{"$f":"SUM(M13:M15)","v":0},"m3"]
[null,"Abwässer aus Nebenerwerb (bei Winterbetrieb)",null,null,null,null,{"$f":"SUM(M18:M22)","v":0},"m3"]
[null,"Abwässer aus Stall und Flächen",null,null,null,null,{"$f":"SUM(M111)+S136","v":0},"m3"]
[null,"Abwässer aus Melkanlagen in Güllegrube",null,null,null,null,{"$f":"SUM(M120)","v":0},"m3"]
[null,"Gülle unverdünnt",null,null,null,null,{"$f":"SUM(M97)","v":0},"m3","Verdünnung Gülle",null,null,null,4.1666666666666664E-2,{"$f":"SUM(Q24+G142+G144+G145)/G146","v":{"$error":"#DIV/0!"}}]
[null,"Total Gülleanfall verdünnt",null,null,null,null,{"$f":"SUM(G142:G146)","v":0},"m3"]
[]
[null,"Ermitteln der Güllegrubengrösse\nbei einer Lagerdauer von",null,null,null,null,null,"Monaten"]
[null,"Benötigter Güllegrubengrösse",null,null,null,null,{"$f":"SUM(G147/12*G149)","v":0},"m3",null,null,null,"Güllelagerraum bestehend ",{"$f":"SUM(L124:N129)","v":0},"m3"]
[null,"Neu zu erstellender Güllelagerraum",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G150-M150)<=0,\"0\",SUM(G150-M150))","v":"0"},"m3"]
[]
[null,"Ermitteln der Mistplatzfläche und des Mistvolumens"]
[null,"Mistanfall während 6 Monaten in Kubikmeter",null,null,null,null,{"$f":"N97/2","v":0},"m3","Mistlagervolumen bestehend + neu",null,null,null,{"$f":"SUM(P133:P136)+Q104","v":0},"m3"]
[null,"Mistlagerflächen bestehend und neu",null,null,null,null,{"$f":"SUM(L133+L134+L135+L136+L104)","v":0},"m2","Manko Mistlagervolumen",null,null,null,{"$f":"SUM(G154-M154)","v":0},"m3",null,{"$f":"ROUND(SUM(M155/#REF!),0)","v":{"$error":"#REF!"}}]
[null,"Neu zu erstellende Mistplatzfläche bei einer Stapelhöhe 1.5 Meter",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M155/1.5)<=0,\"0\",SUM(M155/1.5))","v":"0"},"m2"]
[]
[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,"· Baugesuchsformular 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"]
[]
[1]
[1.5,null,5]
[2,null,6]
[2.5]
[3]

{"sheet":"Tabelle2","index":1,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[4,null,null,"Kanalisationanschluss (ARA)",null,null,null,"im Sommer",null,null,"Ja",null,1]
[4.5,null,null,"Güllegrube",null,null,null,"im Winter (ganzes Jahr)",null,null,"Nein",null,1.5]
[5,null,null,"Klärgrube",null,null,null,null,null,null,null,null,2]
[5.5,null,null,"Kleinkläranlage (KLARA)",null,null,null,null,null,null,null,null,2.5]
[6,null,null,"Andere Ableitung (siehe Bemerkungen)",null,null,null,null,null,null,null,null,3]