{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["GV-Berechnung-Gülleanfall","Mistanfall","Zusammenfassung","Stammdaten-Tierhaltung"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"GV-Berechnung-Gülleanfall","index":0,"n_rows":65,"n_cols":27,"rows_kept":65,"cut":false,"hidden":false,"merged":[[24,9,24,11],[16,2,16,4],[17,2,17,4],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,7,19,8],[19,5,19,6],[20,5,20,6],[21,5,21,6],[18,7,18,8],[20,2,20,4],[21,2,21,4],[15,7,15,8],[19,2,19,4],[16,15,16,17],[17,15,17,17],[18,15,18,17],[19,15,19,17],[0,0,0,18],[6,3,6,5],[6,6,6,7],[10,15,10,17],[11,15,11,17],[12,15,12,17],[13,15,13,17],[15,15,15,17],[15,12,15,14],[16,12,16,14],[17,12,17,14],[18,2,18,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,5,15,6],[15,2,15,4],[13,7,13,8],[18,12,18,14],[19,12,19,14],[10,12,10,14],[23,2,23,4],[22,5,22,6],[23,5,23,6],[21,12,21,14],[22,12,22,14],[16,9,16,11],[17,9,17,11],[18,9,18,11],[19,9,19,11],[20,12,20,14],[10,9,10,11],[11,9,11,11],[12,9,12,11],[13,9,13,11],[16,7,16,8],[17,7,17,8],[14,9,14,11],[15,9,15,11],[12,7,12,8],[22,15,22,17],[23,15,23,17],[21,15,21,17],[23,7,23,8],[23,9,23,11],[21,7,21,8],[23,12,23,14],[22,2,22,4],[20,15,20,17],[22,7,22,8],[22,9,22,11],[21,9,21,11],[20,7,20,8],[20,9,20,11],[6,14,6,17],[6,11,6,13],[6,8,6,10],[3,0,3,17],[14,12,14,14],[9,12,9,17],[9,9,9,11],[12,5,12,6],[13,5,13,6],[14,5,14,6],[9,2,9,8],[10,5,10,8],[11,5,11,8],[14,7,14,8],[11,12,11,14],[12,12,12,14],[13,12,13,14],[14,15,14,17],[24,12,24,14],[24,15,24,17],[26,12,26,14],[27,12,27,14],[28,12,28,14],[29,12,29,14],[26,15,26,17],[28,15,28,17],[29,15,29,17],[25,12,25,14],[25,15,25,17],[41,2,41,4],[42,2,42,4],[43,2,43,4],[46,2,46,4],[27,9,27,11],[31,12,31,14],[31,15,31,17],[32,12,32,14],[32,15,32,17],[27,15,27,17],[30,15,30,17],[44,2,44,4],[45,2,45,4],[38,2,38,4],[44,6,44,17],[48,2,48,4],[41,6,42,17],[45,6,46,17],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[33,12,33,14],[39,2,39,4],[40,2,40,4],[38,6,40,17],[33,15,33,17],[35,12,35,14],[35,15,35,17],[35,5,35,7],[34,2,34,4],[34,5,34,7],[34,15,34,17],[35,2,35,4],[47,2,47,4],[36,12,36,14],[36,15,36,17],[53,14,53,16],[50,14,50,16],[51,14,51,16],[34,12,34,14],[28,5,28,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[33,5,33,7],[30,12,30,14]]}
["WDL - Berechnung der Großvieheinheiten und der Lagerkapazität"]
["für flüssige Wirtschaftsdünger"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"Stall"]
["Antragstellendes Unternehmen (Name, Vorname, ggf. Unternehmensbezeichnung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weide"]
[null,null,null,"EU-Registriernummer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tagweide"]
[null,null,null,"Nation",null,null,"BL",null,"LK",null,null,"Gemeinde",null,null,"Betrieb"]
[null,null,null,2,7,6,"0",3]
[]
["Tierhaltung","Aufstallung1)","Ø Jahresbestand2)",null,null,null,null,null,null,"GVE3)",null,null,"Lagerraumbedarf4)"]
[null,null,"Gülle",null,null,"Mist / Jauche",null,null,null,null,null,null,"6 Monate",null,null,"9 Monate"]
[null,null,null,null,null,"Einstreumenge"]
[null,null,null,null,null,"niedrig",null,"hoch",null,null,null,null,"Menge",null,null,"Menge"]
[null,null,"Anzahl",null,null,"Anzahl",null,"Anzahl",null,null,null,null,"m3",null,null,"m3",null,null,null,null,null,"Gülle","Jauche","GVE"]
[{"$f":"INDEX(Tierart,$T15)","v":"--"},{"$f":"IF($T15=1,\" --\",INDEX(Weide,$U15))","v":" --"},0,null,null,0,null,0,null,{"$f":"($C15+$F15+$H15)*X15","v":0},null,null,{"$f":"($C15*$V15/2)+($F15*$W15/2)","v":0},null,null,{"$f":"IF($U15=1,($C15*$V15/12)*9,IF($U15=2,($C15*$V15/12)*7,$C15*$V15/12*8))+IF($U15=1,($F15*$W15/12)*9,IF($U15=2,($F15*$W15/12)*7,$F15*$W15/12*8))","v":0},null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T15)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T15)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T15)","v":0},{"$f":"IF($U15=1,($C15*$V15/12)*12,IF($U15=2,($C15*$V15/12)*7,$C15*$V15/12*9.5))+IF($U15=1,($F15*$W15/12)*12,IF($U15=2,($F15*$W15/12)*7,$F15*$W15/12*9.5))","v":0},{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T15)","v":0},{"$f":"IF($U15=1,(F15+H15)*Z15,IF($U15=2,(F15+H15)*Z15/12*7,(F15+H15)*Z15/12*9.5))","v":0}]
["--"," --",0,null,null,0,null,0,null,{"$f":"($C16+$F16+$H16)*X16","v":0},null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T16)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T16)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T16)","v":0},{"$f":"IF($U16=1,($C16*$V16/12)*12,IF($U16=2,($C16*$V16/12)*7,$C16*$V16/12*9.5))+IF($U16=1,($F16*$W16/12)*12,IF($U16=2,($F16*$W16/12)*7,$F16*$W16/12*9.5))","v":0},{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T16)","v":0},{"$f":"IF($U16=1,(F16+H16)*Z16,IF($U16=2,(F16+H16)*Z16/12*7,(F16+H16)*Z16/12*9.5))","v":0}]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T17)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T17)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T17)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T17)","v":0},{"$f":"IF($U17=1,(F17+H17)*Z17,IF($U17=2,(F17+H17)*Z17/12*7,(F17+H17)*Z17/12*9.5))","v":0}]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T18)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T18)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T18)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T18)","v":0},0]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T19)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T19)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T19)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T19)","v":0},0]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T20)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T20)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T20)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T20)","v":0},0]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T21)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T21)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T21)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T21)","v":0},0]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T22)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T22)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T22)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T22)","v":0},0]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T23)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T23)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T23)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T23)","v":0},0]
["--"," --",0,null,null,0,null,0,null,0,null,null,0,null,null,0,null,null,1,1,1,{"$f":"INDEX(Gülleanfall,'GV-Berechnung-Gülleanfall'!$T24)","v":0},{"$f":"INDEX(Jaucheanfall,'GV-Berechnung-Gülleanfall'!$T24)","v":0},{"$f":"INDEX(GVE,'GV-Berechnung-Gülleanfall'!$T24)","v":0},0,{"$f":"INDEX(Mistanfall,'GV-Berechnung-Gülleanfall'!$T24)","v":0},0]
["Summe GVE",null,null,null,null,null,null,null,null,{"$f":"SUM(J15:L24)","v":0}]
["Anfall flüssiger Wirtschaftsdünger aus der Tierhaltung",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M15:O25)","v":0},null,null,{"$f":"SUM(P15:R25)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Y15:Y25)","v":0},null,{"$f":"SUM(AA15:AA25)","v":0}]
[]
["Oberflächenwasser u. sonstige","Niederschlagsmenge in mm /Jahr",null,null,null,null,null,null,null,700]
["Abwässer5)","Lageplan","Fläche",null,null,"Sonstiges"]
["Oberflächenbezeichnung","Nummer","m2",null,null,"m³/Jahr"]
[null,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF($C31>1,$J$28*$C31/1000/2/12*6,\"\")","v":""},null,null,{"$f":"IF(C31>1,$J$28*C31/1000/2/12*9,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($C31>1,$J$28*$C31/1000/2/12*12,\"\")","v":""}]
[0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32>1,$J$28*C32/1000/2/12*6,\"\")","v":""},null,null,{"$f":"IF(C32>1,$J$28*C32/1000/2/12*9,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($C32>1,$J$28*$C32/1000/2/12*12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C33>1,$J$28*C33/1000/2/12*6,\"\")","v":""},null,null,{"$f":"IF(C33>1,$J$28*C33/1000/2/12*9,\"\")","v":""},null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C34>1,$J$28*C34/1000/2/12*6,\"\")","v":""},null,null,{"$f":"IF(C34>1,$J$28*C34/1000/2/12*9,\"\")","v":""},null,null,null,null,null,null,null,null,""]
["Sonstiges",null,null,null,null,0,null,null,null,null,null,null,{"$f":"F35/12*6","v":0},null,null,{"$f":"$F35/12*9","v":0},null,null,null,null,null,null,null,null,{"$f":"$F35/12*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F36/12*6","v":0},null,null,{"$f":"F36/12*9","v":0},null,null,null,null,null,null,null,null,{"$f":"$F36/12*12","v":0}]
["Lagerraumbedarf insgesamt",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M26:O36)","v":0},null,null,{"$f":"SUM(P26:X36)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(Y31:Y36)","v":0}]
[]
["Lagerkapazitätsberechnung6)",null,"Netto-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y37+Y26","v":0}]
[null,"Lageplan","volumen7)"]
["Bezeichnung der Lagerstätte","Nummer","m³"]
["vorhandene Lagerstätten",null,0]
[null,null,0]
[null,null,0]
[null,null,0,null,null,null,{"$f":"IF(ISERROR(J25/B55),\"\",\"Der Tierbesatz beträgt \"&ROUND(J25/B55,2)&\" GV/ha LF.\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GV/ha",{"$f":"IF(ISERROR(J25/B55),0,J25/B55)","v":0}]
[null,null,0,null,null,null,{"$f":"IF(ISERROR(J25/B55),\"\",IF(J25/B55>2,\"Der Tierbesatz von 2,0 GV/ha LF wird um \"&ROUND(IF(J25/B55>2,J25-B55*2,0),2)&\" GV überschritten.\",\"\"))","v":""}]
[null,null,0]
["geplante Lagerstätte",null,0]
["Summe Lagerraum:",null,{"$f":"SUM(C42:E48)","v":0}]
[]
["landwirtschaftlich genutzte Fläche"]
[null,"ha LF"]
["Gesamtflächen u. Nutzungsnachweis",0]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vorhandener Lagerraum",null,{"$f":"SUM(C42:C47)","v":0}]
["Summe",{"$f":"SUM(B53:B54)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung größer 12M",null,{"$f":"IF(C49>=Y39,C49-Y39,0)","v":0}]
[]
["1) Bei Weidehaltung werden 7 Stallhaltungsmonate berücksichtigt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung kleiner 6/9M",null,{"$f":"IF(X45<3,IF(Y54<M37,M37-Y54,0),IF(Y54<P37,P37-Y54,0))","v":0}]
["2) Baugenehmigte Stallplätze. Bei Sauenhaltung können die produktiven Sauen berücksichtigt werden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"förderfähiger Lagerraum",null,{"$f":"C48-Y55-Y57","v":0}]
["3) GV - Schlüssel aus der Agrarförderung"]
["4) Gülle-/ Jaucheanfall auf Grundlage der Düngeverordnung 2017 incl. Reinigungs- und Prozesswasser"]
["5) Oberflächen nicht abgedeckter Lager (Festmist, Güllebehälter). Alle sonstigen Flächen, wenn eingeleitet wird (Fahrsilo,"]
["    Hofbefestigung). Es werden 50% Verdunstung des Niederschlags berücksichtigt"]
["6) Aufstellung aller Lagerstätten und evtl. Pachtbehälter mit Kennzeichnung im Lageplan "]
["7) Bei Güllekellern sind 10 cm und bei offenen Behältern 20 cm von der Höhe als Freibord abzuziehen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand:24.06.2019"]

{"sheet":"Mistanfall","index":1,"n_rows":60,"n_cols":23,"rows_kept":60,"cut":false,"hidden":false,"merged":[[26,2,26,4],[27,2,27,4],[28,2,28,4],[25,2,25,4],[30,2,30,4],[22,2,22,4],[22,5,22,7],[22,8,22,10],[20,2,20,4],[20,5,20,7],[20,8,20,10],[21,2,21,4],[21,5,21,7],[21,8,21,10],[18,2,18,4],[18,5,18,7],[18,8,18,10],[19,2,19,4],[19,5,19,7],[19,8,19,10],[16,2,16,4],[16,5,16,7],[16,8,16,10],[17,2,17,4],[17,5,17,7],[17,8,17,10],[14,2,14,4],[14,5,14,7],[14,8,14,10],[15,2,15,4],[15,5,15,7],[15,8,15,10],[12,2,12,4],[12,5,12,7],[12,8,12,10],[13,2,13,4],[13,5,13,7],[13,8,13,10],[10,2,10,4],[10,5,10,7],[10,8,10,10],[11,2,11,4],[11,5,11,7],[11,8,11,10],[3,0,3,17],[6,3,6,5],[6,6,6,7],[6,8,6,10],[6,11,6,13],[6,14,6,17]]}
["Berechnung des Mist- bzw. Trockenkotanfalls"]
[]
[]
[{"$f":"'GV-Berechnung-Gülleanfall'!A4:R4","v":0}]
["Antragstellendes Unternehmen (Name, Vorname, ggf. Unternehmensbezeichnung)"]
[null,null,null,"EU-Registriernummer"]
[null,null,null,"Nation",null,null,"BL",null,"LK",null,null,"Gemeinde",null,null,"Betrieb"]
[null,null,null,2,7,6,"0",3,{"$f":"'GV-Berechnung-Gülleanfall'!I8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!J8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!K8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!L8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!M8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!N8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!O8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!P8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!Q8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!R8","v":0}]
[]
[]
["Tierhaltung",null,"Anfall2)",null,null,"Anfall3)"]
[null,"Anzahl1)","m³ / Monat",null,null,"m³ / Jahr"]
[{"$f":"'GV-Berechnung-Gülleanfall'!A15","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F15+'GV-Berechnung-Gülleanfall'!H15","v":0},{"$f":"B13*'GV-Berechnung-Gülleanfall'!Z15/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA15","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A16","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F16+'GV-Berechnung-Gülleanfall'!H16","v":0},{"$f":"B14*'GV-Berechnung-Gülleanfall'!Z16/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA16","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A17","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F17+'GV-Berechnung-Gülleanfall'!H17","v":0},{"$f":"B15*'GV-Berechnung-Gülleanfall'!Z17/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA17","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A18","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F18+'GV-Berechnung-Gülleanfall'!H18","v":0},{"$f":"B16*'GV-Berechnung-Gülleanfall'!Z18/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA18","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A19","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F19+'GV-Berechnung-Gülleanfall'!H19","v":0},{"$f":"B17*'GV-Berechnung-Gülleanfall'!Z19/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA19","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A20","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F20+'GV-Berechnung-Gülleanfall'!H20","v":0},{"$f":"B18*'GV-Berechnung-Gülleanfall'!Z20/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA20","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A21","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F21+'GV-Berechnung-Gülleanfall'!H21","v":0},{"$f":"B19*'GV-Berechnung-Gülleanfall'!Z21/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA21","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A22","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F22+'GV-Berechnung-Gülleanfall'!H22","v":0},{"$f":"B20*'GV-Berechnung-Gülleanfall'!Z22/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA22","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A23","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F23+'GV-Berechnung-Gülleanfall'!H23","v":0},{"$f":"B21*'GV-Berechnung-Gülleanfall'!Z23/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA23","v":0}]
[{"$f":"'GV-Berechnung-Gülleanfall'!A24","v":"--"},{"$f":"'GV-Berechnung-Gülleanfall'!F24+'GV-Berechnung-Gülleanfall'!H24","v":0},{"$f":"B22*'GV-Berechnung-Gülleanfall'!Z24/12","v":0},null,null,{"$f":"'GV-Berechnung-Gülleanfall'!AA24","v":0}]
["Gesamtanfall Mist und Trockenkot",null,{"$f":"SUM(C13:E22)","v":0},null,null,{"$f":"SUM(F13:H22)","v":0}]
[]
[]
["Lagerkapazitätsberechnung","m²","m³"]
["vorhandene Lagerkapazität4)",null,0]
["geplante Lagerstätte5)",0,{"$f":"B28*2","v":0}]
["Lagerkapazität insgesamt",null,{"$f":"SUM(C27:E28)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anfall 12 Monate"]
[]
["förderfähiger Anteil6):",{"$f":"IF(ISERROR(IF((C28-W33)/C28*100>0,(C28-W33)/C28*100,0)),0,IF((C28-W33)/C28*100>0,(C28-W33)/C28*100,0))","v":0},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung kleiner 2 Monate",null,null,{"$f":"IF(C27<(C23*2),(C23*2)-C27,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung größer 12 Monate",null,null,{"$f":"IF(C29>F23,C29-F23,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W31:W32)","v":0}]
[]
[]
["1) Ø Jahresbestand mit Mist bzw. Trockenkotanfall (GV-Berechnung, Spalten Mist / Jauche)"]
["2) Lagerungsdichte: 1,25 m³/t Rindermist, 2 m³/t Hähnchen/Hennenmist, 2 m³/t Pferdemist, 1,1 m³/t Schweinemist"]
["3) Bei Weidehaltung werden 7 Stallhaltungsmonate berücksichtigt"]
["4) Lageplan bzw. Beschreibung beifügen"]
["5) 2 m Stapelhöhe"]
["6) förderfähiger Anteil bei einer Lagerkapazität von mind. 2 Monaten und max. 12 Monaten"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GV-Berechnung-Gülleanfall'!O65","v":"Stand:24.06.2019"}]

{"sheet":"Zusammenfassung","index":2,"n_rows":58,"n_cols":22,"rows_kept":58,"cut":false,"hidden":false,"merged":[[34,3,34,4],[3,0,3,17],[6,3,6,5],[6,6,6,7],[6,8,6,10],[6,11,6,13],[6,14,6,17]]}
["WDL - Zusammenfassung der Berechnungsgrundlagen"]
[]
[]
[{"$f":"'GV-Berechnung-Gülleanfall'!A4:R4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDL für Tierhaltung",1]
["Antragstellendes Unternehmen (Name, Vorname, ggf. Unternehmensbezeichnung)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDL als Düngerlager",2]
[null,null,null,"EU-Registriernummer"]
[null,null,null,"Nation",null,null,"BL",null,"LK",null,null,"Gemeinde",null,null,"Betrieb"]
[null,null,null,2,7,6,"0",3,{"$f":"'GV-Berechnung-Gülleanfall'!I8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!J8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!K8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!L8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!M8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!N8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!O8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!P8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!Q8","v":0},{"$f":"'GV-Berechnung-Gülleanfall'!R8","v":0}]
[]
["Berechnungsgrundlage:"]
[]
[{"$f":"IF(U12=1,T4,T5)","v":"WDL für Tierhaltung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["landwirtschaftlich genutzte Fläche",{"$f":"'GV-Berechnung-Gülleanfall'!B55","v":0},"ha"]
["Besatzdichte",{"$f":"'GV-Berechnung-Gülleanfall'!X45","v":0},"GV/ha"]
["Lager für flüssige Wirtschaftsdünger"]
[]
["vorhandene Lagerstätten:",{"$f":"'GV-Berechnung-Gülleanfall'!Y54","v":0},"m³"]
["geplante Lagerstätte:",{"$f":"'GV-Berechnung-Gülleanfall'!C48","v":0},"m³"]
["Summe Lagerstätten:",{"$f":"B19+B18","v":0},"m³"]
["max. Wirtschaftsdüngerlagerung:",{"$f":"IF(U12=1,'GV-Berechnung-Gülleanfall'!Y39,Zusammenfassung!B14*25)","v":0},"m³ ",{"$f":"IF(U12=1,\"(max. 12 Monate Lagerkapazität)\",\"(max. 25 m³/ha)\")","v":"(max. 12 Monate Lagerkapazität)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung max.",null,{"$f":"IF(B20>B21,B20-B21,0)","v":0}]
["Mindestlagerkapazität:",{"$f":"IF(B15>3,'GV-Berechnung-Gülleanfall'!P37,'GV-Berechnung-Gülleanfall'!M37)","v":0},"m³ (6 Monate bzw. 9 Monate bei mehr als 3 GV/ha)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anerchnung min.",null,{"$f":"IF(B22>B18,B22-B18,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V22+V21","v":0}]
["förderfähige Lagerstätte:",{"$f":"IF(B19-V23>0,B19-V23,0)","v":0},"m³"]
["förderfähiger Anteil:",{"$f":"IF(ISERROR(B24/B19*100),0,B24/B19*100)","v":0},"%"]
[]
["Abgabemenge bei > 2GV/ha:",{"$f":"IF(B15>2,V28-V28/B15*2,0)","v":0},"m³ (ohne Oberflächenwasser u. sonstige Abwässer)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anfall 12 Monate",null,{"$f":"'GV-Berechnung-Gülleanfall'!Y39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anfall 12 Monate ohne wasser",null,{"$f":"'GV-Berechnung-Gülleanfall'!Y26","v":0}]
["Anfall aus eig. Tierhaltung",{"$f":"V27","v":0},"m³ (Anfall 12 Monate ggf. mit Oberflächenwasser)"]
["Aufnahmemenge bei Düngerlager:",{"$f":"IF(V32<0,0,V32)","v":0},"m³"]
[]
["Lager für Mist/Trockenkot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U12=2,IF(B21>B20,B20-V27,B21-V27),0)","v":0}]
[]
["vorhandene Lagerstätten:",{"$f":"Mistanfall!C27","v":0},"m³"]
["geplante Lagerstätte:",{"$f":"Mistanfall!C28","v":0},"m³ /",{"$f":"Mistanfall!B28","v":0},null,"m²"]
["Summe Lagerstätten:",{"$f":"B35+B34","v":0},"m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung max.",null,{"$f":"IF(B36>B37,B36-B37,0)","v":0}]
["max. Wirtschaftsdüngerlagerung:",{"$f":"Mistanfall!F23","v":0},"m³ (max. 12 Monate Lagerkapazität)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anrechnung min.",null,{"$f":"IF(B38>B34,B38-B34,0)","v":0}]
["Mindestlagerkapazität:",{"$f":"Mistanfall!C23*2","v":0},"m³ (2 Monate)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V37+V36","v":0}]
[]
["förderfähige Lagerstätte:",{"$f":"IF(B35-V38>0,B35-V38,0)","v":0},"m³"]
["förderfähiger Anteil:",{"$f":"IF(ISERROR(B40/B35*100),0,B40/B35*100)","v":0},"%"]
[]
["Bei Mistlagern als Düngerlager können max. 4t Mist/ha ausgebracht werden. Es ist eine individuelle Berechnung der"]
["max. Größe, je nach Mistart, erforderlich."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'GV-Berechnung-Gülleanfall'!O65","v":"Stand:24.06.2019"}]

{"sheet":"Stammdaten-Tierhaltung","index":3,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[]
[]
[null,"Anfall in m³\nanfall\nm³/Stallpl.",null,null,"Anfall m³"]
["Tierart","Gülle","Jauche","GVE/Platz","Mist / Trockenkot"]
[]
[]
["--"]
["Milchkuh, Laufstall, 6000 kg Milch p.a.",27,14,1,18]
["Milchkuh, Laufstall, 8000 kg Milch p.a.",28,14.4,1,18.8]
["Milchkuh, Laufstall, 10000 kg Milch p.a.",29,14.8,1,20]
["Milchkuh, Laufstall, 12000 kg Milch p.a.",30,15.2,1,21.3]
["Milchkuh, Anbind., 6000 kg Milch p.a.",21.4,8.4,1,18]
["Milchkuh, Anbind., 8000 kg Milch p.a.",22.4,8.8000000000000007,1,18.8]
["Milchkuh, Anbind., 10000 kg Milch p.a.",23.4,9.1999999999999993,1,20]
["Milchkuh, Anbind., 12000 kg Milch p.a.",24.4,9.6,1,21.3]
["Färsen über 24 Monate",14.1,3.6,1,15.1]
["Jungrinder weiblich (13 - 24 Monate)",11.4,2.9,0.6,12.3]
["Jungrinder weiblich (7 - 12 Monate)",7.4,1.9,0.6,8]
["Kalb (0 - 6 Monate)",4.5999999999999996,1.2,0.3,4.9000000000000004]
["Mutterkuh 500 kg LM",16,5.5,1,15]
["Mutterkuh 700 kg LM",20,6,1,19.8]
[]
["Mastbullen 675 kg (0 - 19 Monate)",6.7,2.4,0.5,5.8]
["Mastbullen 675 kg (13 - 19 Monate)",9.6999999999999993,3.5,0.6,8.3000000000000007]
["Mastbullen 675 kg (7 - 12 Monate)",6.6,2.4,0.6,5.8]
["Mastbullen 675 kg (0 - 6 Monate)",3.3,1.2,0.3,2.9]
["Mastbullen 750 kg (0 - 19 Monate)",7.3,3,0.5,5.75]
["Mastbullen 750 kg (13 - 19 Monate)",10.6,4.4000000000000004,0.6,8.3800000000000008]
["Mastbullen 750 kg (7 - 12 Monate)",7.3,3,0.6,5.75]
["Mastbullen 750 kg (0 - 6 Monate)",3.5,1.4,0.3,2.75]
["Jungrindermast, Fresser",5.5,0.5,0.4,5.75]
["Jungrindermast, Kälbermast",2.5,0.6,0.4,2.35]
["Jungrindermast, Rosa Kalbfleisch",4,0.5,0.4,0.42299999999999999]
[]
["Sau mit Ferkel. bis 8 kg, 22 Ferkel ",4.75,1.95,0.3,3.85]
["Sau mit Ferkel. bis 8 kg, 25 Ferkel ",4.95,2.0499999999999998,0.3,3.96]
["Sau mit Ferkel. bis 8 kg, 28 Ferkel ",5.15,2.15,0.3,4.07]
["Ferkelaufzucht (8 bis 28 kg)",0.7,0.4,3.3000000000000002E-2,0.40699999999999997]
["Jungsauenaufzucht, 28 bis 115 kg LM",1.92,0.72,0.13,1.518]
["Jungsaueneingliederung",2.62,1.1200000000000001,0.13,2.0459999999999998]
["Erberhaltung",3.72,1.62,0.3,2.706]
[]
["Mastschwein",1.62,0.72,0.13,1.1879999999999999]
["Mastschwein, Brei-/Sensorfütterung",1.32,null,0.13]
["Mastschwein, Flüssigfütterung",1.92,null,0.13]
[]
["Legehennen braun (Durchschnitt 2 kg)",null,null,4.0000000000000001E-3,4.3999999999999997E-2]
["Legehennen weiß (Durchschnitt 1,7 kg)",null,null,3.3999999999999998E-3,4.3999999999999997E-2]
["Junghennen",null,null,2.2000000000000001E-3,1.4E-2]
["Masthähnchen (Kurzmast 25 Tage)",null,null,8.0000000000000004E-4,1.8599999999999998E-2]
["Masthähnchen (Langmast 36 Tage)",null,null,1.4E-3,2.2200000000000001E-2]
["Putenhennen (Durchschnitt 3,9 kg)",null,null,7.9000000000000008E-3,0.126]
["Putenhähne (Durchschnitt 8,2 kg)",null,null,1.6400000000000001E-2,0.121]
["Putenaufzucht (Durchschnitt 1,1 kg)",null,null,2.2000000000000001E-3,3.3000000000000002E-2]
[]
["Pferde unter 6 Monate",null,null,0.5,13.6]
["Pferde über 6 Monate",null,null,1,22.4]
["Mutterschafe",null,null,0.15,1.65]
["Schafe (außer Mutterschafe) größer 1 Jahr",null,null,0.1,1.65]
["Ziegen",null,null,0.15,1.5]