{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Inhaltsverzeichnis","Vorbemerkungen","Vorräte","2a_Vieh","2b_sonstiges","Betriebsfläche am 30.6.","Betr.flächenveränderung im WJ","Erntefläche","Anbaufläche","nachrichtliche Angaben","aussteh. Geldforderungen","zum Stichtag n.n.bez. Rg. ","lang. mittelf. Darlehen","Privatkonten","betr. AK im Wirtschaftsjahr","betr. beköstigte Personen","Zugänge im AV","Abgänge im AV","Berücks. zuk. Investitionen","Berücksichtigung Heizung","Berücksichtigung Pkw","Entnahmen f.d. Haushalt","Waschen f.d. Betrieb","Forstfläche","a.o. Holznutzung","Eigenjagd","Bemerkungen","betr.wirt. Paket","Erstellungsb.f. Kreditgeber","Vollständigkeitserklärung"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":58,"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":"Inhaltsverzeichnis","index":0,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,2,1]]}
[]
[null,"Inhaltsverzeichnis",null,null,null,null,"WJ",2024,2023]
[]
[]
[null,"Vorbemerkungen","hier Klicken",null,null,null,null,{"$f":"RIGHT(H2,2)","v":"24"}]
[1,"Vorräte am 30.6 des WJ.","hier Klicken"]
["2a)"," Viehbestand am 30.6.des WJ.","hier Klicken",null,null,null,"WJ 1",{"$f":"CONCATENATE(I2,\"/\",H2)","v":"2023/2024"},"Stichtag 30.6"]
["2b)","Sonstige Angaben Vieh","hier Klicken",null,null,null,"WJ 2",{"$f":"\"30.6.\"&H2","v":"30.6.2024"},"Stichtag 31.12"]
[3,"Betriebsfläche am 30.6 d. WJ.","hier Klicken"]
[4,"Betriebsflächenveränderung im WJ.","hier Klicken"]
[5,"Ernteflächen WJ. und innerbetriebliche Verbräuche","hier Klicken"]
[6,"Anbaufläche und Aussaatmengen im WJ.","hier Klicken"]
[7,"Nachrichtliche Angaben","hier Klicken"]
[8,"Größere am 30.6.d. WJ. ausstehende Geldforderungen,\n die uns in der Buchhaltung noch nicht vorlagen","hier Klicken"]
[9,"Größere am 30.6. d. WJ. noch nicht bezahlte Rech-\nnungen, die uns in der Buchhaltung noch nicht vorlagen","hier Klicken"]
[10,"Lang- und mittelfristige Darlehen","hier Klicken"]
[11,"Privatkonten","hier Klicken"]
[12,"Betriebliche Arbeitskräfte im WJ.","hier Klicken"]
[13,"Betrieblich beköstigte Personen im WJ.","hier Klicken"]
[14,"Zugänge Maschinen. Gebäude, bauliche Anlagen und Grundverbesserungen","hier Klicken"]
[15,"Alte Maschine,Gebaüde, bauliche Anlagen und Grundverbesserungen","hier Klicken"]
[16,"Berücksichtigung zukünftiger Investitionen","hier Klicken"]
[17,"Berücksichtigung Heizungen","hier Klicken"]
[18,"Berücksichtigung  PKW","hier Klicken"]
[19,"Entnahmen für den Haushalt","hier Klicken"]
[20,"Waschen für den Betrieb","hier Klicken"]
[21,"Forstfläche","hier Klicken"]
[22,"Außerordentliche Holznutzung","hier Klicken"]
[23,"Besitzen Sie eine Eigenjagd?","hier Klicken"]
[24,"Bemerkungen","hier Klicken"]
[25,"Betriebswirtschafliches Paket","hier Klicken"]
[26,"Erstellungsbericht für Kreditgeber","hier Klicken"]
[27,"Vollständigkeitserklärung","hier Klicken"]

{"sheet":"Vorbemerkungen","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,6,10,7],[10,1,10,2],[10,3,10,4],[1,2,1,3],[5,6,5,9],[5,1,5,4],[8,1,8,9],[6,1,6,2],[6,3,6,4],[6,6,6,7],[6,8,6,9],[3,1,3,9],[1,7,1,8]]}
[]
[null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"},null,"Stichtag:  ",{"$f":"WJ_2","v":"30.6.2024"}]
[]
[null,"Vorbemerkungen"]
[]
[null,"Mandantenname",null,null,null,null,"e-mail Adresse"]
[]
[]
[null,"Inventur und Abschlussfragebogen"]
[]
[null,"Wirtschaftsjahr:",null,null,null,null,"Stichtag"]
[]
[]
[null,"Bitte füllen Sie die Abschlussunterlagen sorgfältig und gewissenhaft aus bzw. kreuzen Sie entsprechende"]
[null,"Punkte an. Für Sie nicht zutreffende Punkte lassen Sie bitte unberührt. Nicht Angefügtes ergänzen"]
[null,"Sie bitte."]

{"sheet":"Vorräte","index":2,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[3,1,3,4],[78,1,78,2],[73,1,73,2],[5,1,5,2],[5,3,5,4],[19,1,19,2],[69,3,69,4],[60,1,60,2],[31,1,31,2],[45,1,45,2],[56,1,56,2],[65,1,65,2]]}
[]
[null,null,"Wirtschaftsjahr",{"$f":"WJ_1","v":"2023/2024"}]
[null,null,null,null,null,null,null,null,"=WENN(ZÄHLENWENN($C$13:$C$26;F13)>=1;\"\";(ZEILE()))"]
["1.","Vorräte am",null,null,null,null,{"$f":"WJ_2","v":"30.6.2024"}]
[]
["a)","Bodenerzerzeugnisse",null,"Menge in dt",null,null,null,null,"=BEREICH.VERSCHIEBEN('Vorräte'!$H$75;0;0;ANZAHL('Vorrräte!$G$75:$G$78);1)"]
[]
[null,null,null,"gesamt","davon für Ver-\nkauf bestimmt",null,"Ergänzungen bitte\nunten einfügen"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,null,"Weizen",{"$f":"IF(COUNTIF($C$10:$C$18,G10)>=1,\"\",(ROW()))","v":10},{"$f":"IF(ROW(G10)-ROW(G10)+1>COUNT($H$10:$H$18),\"\",INDEX(G:G,SMALL(H$10:H$18,1+ROW(G10)-ROW(G$10))))","v":"Weizen"},null,"Vorräte"]
[null,null,null,null,null,null,"Roggen",11,"Roggen"]
[null,null,null,null,null,null,"Triticale",12,"Triticale"]
[null,null,null,null,null,null,"Gerste",13,"Gerste"]
[null,null,null,null,null,null,"Hafer",14,"Hafer"]
[null,null,null,null,null,null,"Speisekartoffeln",15,"Speisekartoffeln"]
[null,null,null,null,null,null,"Futterkartoffeln",16,"Futterkartoffeln"]
[null,null,null,null,null,null,"Energiemais",17,"Energiemais"]
[null,null,null," "," ",null,null,18,0]
[]
["b)","Düngemittel",null,null,"Menge in dt"]
[]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,null,"AHL",{"$f":"IF(COUNTIF($C$23:$C$29,G23)>=1,\"\",(ROW()))","v":23},{"$f":"IF(ROW(G23)-ROW(G23)+1>COUNT($H$23:$H$30),\"\",INDEX(G:G,SMALL(H$23:H$30,1+ROW(G23)-ROW(G$23))))","v":"AHL"},null,"Vorräte1"]
[null,null,null,null,null,null,"Kalkammonsalpeter",24,"Kalkammonsalpeter"]
[null,null,null,null,null,null,"Harnstoff",25,"Harnstoff"]
[null,null,null,null,null,null,"Thomaphosphat",26,"Thomaphosphat"]
[null,null,null,null,null,null,"Kali",27,"Kali"]
[null,null,null,null,null,null,null,28,0]
[null,null,null,null,null,null,null,29,0]
[null,null,null,null,null,null,null,30,0]
[]
["c)","Futtermittel",null,null,"Menge in dt"]
[]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,null,"Trockenschnitzel",{"$f":"IF(COUNTIF($C$35:$C$44,G35)>=1,\"\",(ROW()))","v":35},{"$f":"IF(ROW(G35)-ROW(G35)+1>COUNT($H$35:$H$44),\"\",INDEX(G:G,SMALL(H$35:H$44,1+ROW(G35)-ROW(G$35))))","v":"Trockenschnitzel"}]
[null,null,null,null,null,null,"Sojaschrot",{"$f":"IF(COUNTIF($C$35:$C$44,G36)>=1,\"\",(ROW()))","v":36},"Sojaschrot"]
[null,null,null,null,null,null,"Fischmehl",37,"Fischmehl"]
[null,null,null,null,null,null,"Eiweisskonzentrat",38,"Eiweisskonzentrat"]
[null,null,null,null,null,null,"Milchviehmischfutter",39,"Milchviehmischfutter"]
[null,null,null,null,null,null,"Schweinefertigfutter",40,"Schweinefertigfutter"]
[null,null,null,null,null,null,"Mineralfutter",41,"Mineralfutter"]
[null,null,null,null,null,null,"Rapsschrot",42,"Rapsschrot"]
[null,null,null,null,null,null,null,43,0]
[null,null,null,null,null,null,null,44,0]
[]
["d)","Treib- und Schmier-\nstoffe",null,"Menge in l.","Preis/l in €"]
[]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,null,"Benzin ",{"$f":"IF(COUNTIF($C$49:$C$53,G49)>=1,\"\",(ROW()))","v":49},{"$f":"IF(ROW(G49)-ROW(G49)+1>COUNT($H$49:$H$53),\"\",INDEX(G:G,SMALL(H$49:H$53,1+ROW(G49)-ROW(G$49))))","v":"Benzin "},null,"Vorräte3"]
[null,null,null,null,null,null,"Diesel",{"$f":"IF(COUNTIF($C$49:$C$53,G50)>=1,\"\",(ROW()))","v":50},{"$f":"IF(ROW(G50)-ROW(G50)+1>COUNT($H$49:$H$53),\"\",INDEX(G:G,SMALL(H$49:H$53,1+ROW(G50)-ROW(G$49))))","v":"Diesel"}]
[null,null,null,null,null,null,"Pflanzenöl",{"$f":"IF(COUNTIF($C$49:$C$53,G51)>=1,\"\",(ROW()))","v":51},{"$f":"IF(ROW(G51)-ROW(G51)+1>COUNT($H$49:$H$53),\"\",INDEX(G:G,SMALL(H$49:H$53,1+ROW(G51)-ROW(G$49))))","v":"Pflanzenöl"}]
[null,null,null,null,null,null,"Motorenöl",{"$f":"IF(COUNTIF($C$49:$C$53,G52)>=1,\"\",(ROW()))","v":52},{"$f":"IF(ROW(G52)-ROW(G52)+1>COUNT($H$49:$H$53),\"\",INDEX(G:G,SMALL(H$49:H$53,1+ROW(G52)-ROW(G$49))))","v":"Motorenöl"}]
[null,null,null,null,null,null,"Hydrauliköl",{"$f":"IF(COUNTIF($C$49:$C$53,G53)>=1,\"\",(ROW()))","v":53},{"$f":"IF(ROW(G53)-ROW(G53)+1>COUNT($H$49:$H$53),\"\",INDEX(G:G,SMALL(H$49:H$53,1+ROW(G53)-ROW(G$49))))","v":"Hydrauliköl"}]
[null,null,"",null,null,null,null,54,{"$f":"IF(ROW(G54)-ROW(G54)+1>COUNT($H$49:$H$53),\"\",INDEX(G:G,SMALL(H$49:H$53,1+ROW(G54)-ROW(G$49))))","v":{"$error":"#NUM!"}}]
[null,null,"",null,null,null,null,55,{"$error":"#NUM!"}]
[]
["e)","Fette",null,"Menge in Kg","Preis/Kg in €"]
[]
[]
[]
["f)","Heizstoffe",null,"Menge in l."]
[]
[null,null,"Heizöl"]
[null,null,"wasserstoff"]
[]
["g)","Verkaufsf. Brennholz",null,"Menge i. rm."]
[]
[]
[]
["h)",null,"Sonstige","Menge in cbm."]
[]
[]
[]
["i)","Geschlagenes unver-\nkauftes Holz im Wald",null,"Menge","Preis/fm in € "]
[]
[]
[]
[]
["j)","sonstiges",null,null,"Wert in €"]

{"sheet":"2a_Vieh","index":3,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":false,"merged":[[33,1,33,2],[3,1,3,2]]}
[]
[null,null,"Wirtschaftsjahr",{"$f":"WJ_1","v":"2023/2024"}]
[]
["2.","Angaben zu Vieh"]
[]
[]
["2 a)","Viehbestand zum",null,{"$f":"WJ_2","v":"30.6.2024"}]
[]
[null,"Rindvieh"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"männl. bis 1/2 Jahr",{"$f":"IF(COUNTIF($C$13:$C$26,F13)>=1,\"\",(ROW()))","v":13},{"$f":"IF(ROW(F13)-ROW(F13)+1>COUNT(G$13:G$26),\"\",INDEX(F:F,SMALL(G$13:G$25,1+ROW(F13)-ROW(F$13))))","v":"männl. bis 1/2 Jahr"}]
[null,null,null,null,null,"männl. 1/2 bis 1 Jahr",{"$f":"IF(COUNTIF($C$13:$C$26,F14)>=1,\"\",(ROW()))","v":14},{"$f":"IF(ROW(F14)-ROW(F14)+1>COUNT(G$13:G$26),\"\",INDEX(F:F,SMALL(G$13:G$25,1+ROW(F14)-ROW(F$13))))","v":"männl. 1/2 bis 1 Jahr"}]
[null,null,null,null,null,"männl. 1 bis 1 1/2  Jahr",{"$f":"IF(COUNTIF($C$13:$C$26,F15)>=1,\"\",(ROW()))","v":15},"männl. 1 bis 1 1/2  Jahr"]
[null,null,null,null,null,"männl. über 1 1/2 ",16,"männl. über 1 1/2 "]
[null,null,null,null,null,"Zuchtbullen",17,"Zuchtbullen"]
[null,null,null,null,null,"weibl. bis 1/2 Jahr",18,"weibl. bis 1/2 Jahr"]
[null,null,null,null,null,"weibl. 1/2 bis 1 Jahr",19,"weibl. 1/2 bis 1 Jahr"]
[null,null,null,null,null,"weibl. 1 bis 2  Jahr",20,"weibl. 1 bis 2  Jahr"]
[null,null,null,null,null,"Färsen",21,"Färsen"]
[null,null,null,null,null,"Milchkühe",22,"Milchkühe"]
[null,null,null,null,null,"Mutter- und Ammenkühe",23,"Mutter- und Ammenkühe"]
[null,null,null,null,null,null,24,0]
[null,null,null,null,null,null,25,0]
[]
[null,"Um Rindviehbestände in der Tier-Datenbank mit dem Jahresabschluss abgleichen zu "]
[null,"können, bitten wir um Angabe der",null,null,null,null," =WENN(ZEILE(E1)-ZEILE(E$1)+1>ANZAHL(F$1:F$15);\"\";INDEX(E:E;KKLEINSTE(F$1:F$15;1+ZEILE(E4)-ZEILE(E$1))))"]
[null,null,null,null,null,null," =WENN(ZEILE(E1)-ZEILE(E$1)+1>ANZAHL(F$1:F$15);\"\";INDEX(E:E;KKLEINSTE(F$1:F$15;1+ZEILE(E4)-ZEILE(E$1))))"]
[null,null,null,null,null,null," =WENN(ZEILE(f13)-ZEILE(Ef13)+1>ANZAHL(g$13:g$26);\"\";INDEX(f:f;KKLEINSTE(g$13:g$26;1+ZEILE(f13)-ZEILE(f$13))))"]
[null,null,"Betriebsnummer","PIN Nr.",null,null," =BEREICH.VERSCHIEBEN(Tabelle1!$G$1;0;0;ANZAHL(Tabelle1!$G$1:$G$15)-ANZAHLLEEREZELLEN(Tabelle1!$G$1:$G$15);1)"]
[null,null,null,null,null,null," =BEREICH.VERSCHIEBEN(!2a_vieh!!$H$13;0;0;anzahl('2a_Vieh'!$g$13:$g$26);1)","Rinder"]
[null,null,null,null,null,null," =BEREICH.VERSCHIEBEN('2a_vieh'!$H$54;0;0;anzahl('2a_Vieh!$g$54:$g$59);1)","Pferde"]
[null,"Schweine"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"Ferkel 10 bis 12 Kg",{"$f":"IF(COUNTIF($C$38:$C$46,F38)>=1,\"\",(ROW()))","v":38},{"$f":"IF(ROW(F38)-ROW(F38)+1>COUNT(G$38:G$46),\"\",INDEX(F:F,SMALL(G$38:G$46,1+ROW(F38)-ROW(F$38))))","v":"Ferkel 10 bis 12 Kg"}]
[null,null,null,null,null,"Ferkel 13 bis 20 Kg",39,"Ferkel 13 bis 20 Kg"]
[null,null,null,null,null,"Ferkel 21 bis 30 Kg",40,"Ferkel 21 bis 30 Kg"]
[null,null,null,null,null,"Läufer 31 bis 45 Kg",41,"Läufer 31 bis 45 Kg"]
[null,null,null,null,null,"Läufer 46 bis 50 Kg",42,"Läufer 46 bis 50 Kg"]
[null,null,null,null,null,"Mastschweine",43,"Mastschweine"]
[null,null,null,null,null,"Jungsauen",44,"Jungsauen"]
[null,null,null,null,null,"Zuchtsauen",45,"Zuchtsauen"]
[null,null,null,null,null,"Eber",46,"Eber"]
[]
[null,"Pferde im Betriebsvermögen"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"Fohlen bis 1 Jahr",{"$f":"IF(COUNTIF($C$52:$C$57,F52)>=1,\"\",(ROW()))","v":52},{"$f":"IF(ROW(F52)-ROW(F52)+1>COUNT(G$52:G$57),\"\",INDEX(F:F,SMALL(G$52:G$57,1+ROW(F52)-ROW(F$52))))","v":"Fohlen bis 1 Jahr"}]
[null,null,null,null,null,"Pferde 1 - 2 jahre",53,{"$f":"IF(ROW(F53)-ROW(F53)+1>COUNT(G$52:G$57),\"\",INDEX(F:F,SMALL(G$52:G$57,1+ROW(F53)-ROW(F$52))))","v":"Pferde 1 - 2 jahre"}]
[null,null,null,null,null,"Pferde 2 - 3 jahre",54,"Pferde 2 - 3 jahre"]
[null,null,null,null,null,"Pferde über 3 jahre",55,"Pferde über 3 jahre"]
[null,null,null,null,null,"wertvolle Reitpferde",56,"wertvolle Reitpferde"]
[null,null,null,null,null,"Ponys",57,"Ponys"]
[]
[null,"Schafe"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"Lämmer bis 6 Mon.",{"$f":"IF(COUNTIF($C$63:$C$67,F63)>=1,\"\",(ROW()))","v":63},{"$f":"IF(ROW(F63)-ROW(F63)+1>COUNT(G$63:G$67),\"\",INDEX(F:F,SMALL(G$63:G$67,1+ROW(F63)-ROW(F$63))))","v":"Lämmer bis 6 Mon."}]
[null,null,null,null,null,"Jungschafe über 6 Mon.",{"$f":"IF(COUNTIF($C$63:$C$67,F64)>=1,\"\",(ROW()))","v":64},{"$f":"IF(ROW(F64)-ROW(F64)+1>COUNT(G$63:G$67),\"\",INDEX(F:F,SMALL(G$63:G$67,1+ROW(F64)-ROW(F$63))))","v":"Jungschafe über 6 Mon."}]
[null,null,null,null,null,"Mutterschafe",{"$f":"IF(COUNTIF($C$63:$C$67,F65)>=1,\"\",(ROW()))","v":65},{"$f":"IF(ROW(F65)-ROW(F65)+1>COUNT(G$63:G$67),\"\",INDEX(F:F,SMALL(G$63:G$67,1+ROW(F65)-ROW(F$63))))","v":"Mutterschafe"}]
[null,null,null,null,null,"Zuchtböcke",{"$f":"IF(COUNTIF($C$63:$C$67,F66)>=1,\"\",(ROW()))","v":66},{"$f":"IF(ROW(F66)-ROW(F66)+1>COUNT(G$63:G$67),\"\",INDEX(F:F,SMALL(G$63:G$67,1+ROW(F66)-ROW(F$63))))","v":"Zuchtböcke"}]
[null,null,null,null,null,"sonst. Schafe über 12 Mon.",{"$f":"IF(COUNTIF($C$63:$C$67,F67)>=1,\"\",(ROW()))","v":67},{"$f":"IF(ROW(F67)-ROW(F67)+1>COUNT(G$63:G$67),\"\",INDEX(F:F,SMALL(G$63:G$67,1+ROW(F67)-ROW(F$63))))","v":"sonst. Schafe über 12 Mon."}]
[]
[null,"Geflügel"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"Junghennen",{"$f":"IF(COUNTIF($C$73:$C$76,F73)>=1,\"\",(ROW()))","v":73},{"$f":"IF(ROW(F73)-ROW(F73)+1>COUNT(G$73:G$76),\"\",INDEX(F:F,SMALL(G$73:G$76,1+ROW(F73)-ROW(F$73))))","v":"Junghennen"}]
[null,null,null,null,null,"Legehennen",{"$f":"IF(COUNTIF($C$73:$C$76,F74)>=1,\"\",(ROW()))","v":74},{"$f":"IF(ROW(F74)-ROW(F74)+1>COUNT(G$73:G$76),\"\",INDEX(F:F,SMALL(G$73:G$76,1+ROW(F74)-ROW(F$73))))","v":"Legehennen"}]
[null,null,null,null,null,"Hähne",{"$f":"IF(COUNTIF($C$73:$C$76,F75)>=1,\"\",(ROW()))","v":75},{"$f":"IF(ROW(F75)-ROW(F75)+1>COUNT(G$73:G$76),\"\",INDEX(F:F,SMALL(G$73:G$76,1+ROW(F75)-ROW(F$73))))","v":"Hähne"}]
[null,null,null,null,null,"Eier",{"$f":"IF(COUNTIF($C$73:$C$76,F76)>=1,\"\",(ROW()))","v":76},{"$f":"IF(ROW(F76)-ROW(F76)+1>COUNT(G$73:G$76),\"\",INDEX(F:F,SMALL(G$73:G$76,1+ROW(F76)-ROW(F$73))))","v":"Eier"}]
[]
[null,null,null,null,null,null,null,"=BEREICH.VERSCHIEBEN('2a_Vieh'!$H$75;0;0;ANZAHL('2a_Vieh'!$G$75:$G$78);1)"]

{"sheet":"2b_sonstiges","index":4,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,1,5,2],[16,1,16,2],[27,1,27,2]]}
[]
[null,null,"Wirtschaftsjahr",{"$f":"WJ_1","v":"2023/2024"}]
[null,null,null,null,null,null,null,"=WENN(ZÄHLENWENN($C$13:$C$26;F13)>=1;\"\";(ZEILE()))"]
["2.","Sonstige Angaben Vieh"]
[null,null,null,null,null,null,null,"=WENN(ZEILE(F22)-ZEILE(F22)+1>ANZAHL(G$22:G$27);\"\";INDEX(F:F;KKLEINSTE(G$22:G$27;1+ZEILE(F22)-ZEILE(F$22))))"]
["2 b)","Geburten",null,null,null,null,null,"=BEREICH.VERSCHIEBEN('2a_Vieh'!$H$75;0;0;ANZAHL('2a_Vieh'!$G$75:$G$78);1)"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"männliche Kälber",{"$f":"IF(COUNTIF($C$10:$C$14,F10)>=1,\"\",(ROW()))","v":10},{"$f":"IF(ROW(F10)-ROW(F10)+1>COUNT(G$10:G$14),\"\",INDEX(F:F,SMALL(G$10:G$14,1+ROW(F10)-ROW(F$10))))","v":"männliche Kälber"}]
[null,null,null,null,null,"weibliche Kälber",{"$f":"IF(COUNTIF($C$10:$C$14,F11)>=1,\"\",(ROW()))","v":11},{"$f":"IF(ROW(F11)-ROW(F11)+1>COUNT(G$10:G$14),\"\",INDEX(F:F,SMALL(G$10:G$14,1+ROW(F11)-ROW(F$10))))","v":"weibliche Kälber"}]
[null,null,null,null,null,"Fohlen",{"$f":"IF(COUNTIF($C$10:$C$14,F12)>=1,\"\",(ROW()))","v":12},{"$f":"IF(ROW(F12)-ROW(F12)+1>COUNT(G$10:G$14),\"\",INDEX(F:F,SMALL(G$10:G$14,1+ROW(F12)-ROW(F$10))))","v":"Fohlen"}]
[null,null,null,null,null,"Lämmer",{"$f":"IF(COUNTIF($C$10:$C$14,F13)>=1,\"\",(ROW()))","v":13},{"$f":"IF(ROW(F13)-ROW(F13)+1>COUNT(G$10:G$14),\"\",INDEX(F:F,SMALL(G$10:G$14,1+ROW(F13)-ROW(F$10))))","v":"Lämmer"}]
[null,null,null,null,null,"Ferkel",{"$f":"IF(COUNTIF($C$10:$C$14,F14)>=1,\"\",(ROW()))","v":14},{"$f":"IF(ROW(F14)-ROW(F14)+1>COUNT(G$10:G$14),\"\",INDEX(F:F,SMALL(G$10:G$14,1+ROW(F14)-ROW(F$10))))","v":"Ferkel"}]
[]
[]
[null,"Durchschnittsbestände"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"Kühe",{"$f":"IF(COUNTIF($C$21:$C$26,F21)>=1,\"\",(ROW()))","v":21},{"$f":"IF(ROW(F21)-ROW(F21)+1>COUNT(G$21:G$26),\"\",INDEX(F:F,SMALL(G$21:G$26,1+ROW(F21)-ROW(F$21))))","v":"Kühe"}]
[null,null,null,null,null,"Sauen",22,"Sauen"]
[null,null,null,null,null,"Mutterschafe",23,"Mutterschafe"]
[null,null,null,null,null,"Legehennen",24,"Legehennen"]
[null,null,null,null,null,null,25,0]
[null,null,null,null,null,null,26,0]
[]
[null,"Verendete Tiere"]
[]
[null,null,null,"Stück"]
[null,null,"Bitte Auswählen"]
[null,null,null,null,null,"Schweine",{"$f":"IF(COUNTIF($C$32:$C$49,F32)>=1,\"\",(ROW()))","v":32},{"$f":"IF(ROW(F32)-ROW(F32)+1>COUNT(G$32:G$49),\"\",INDEX(F:F,SMALL(G$32:G$49,1+ROW(F32)-ROW(F$32))))","v":"Schweine"}]
[null,null,null,null,null,"Pferde",33,"Pferde"]
[null,null,null,null,null,"Schafe",34,"Schafe"]
[null,null,null,null,null,"Rindvieh",35,"Rindvieh"]
[null,null,null,null,null,"männl. bis 1/2 Jahr",36,"männl. bis 1/2 Jahr"]
[null,null,null,null,null,"männl. 1/2 bis 1 Jahr",37,"männl. 1/2 bis 1 Jahr"]
[null,null,null,null,null,"männl. 1 bis 1 1/2  Jahr",38,"männl. 1 bis 1 1/2  Jahr"]
[null,null,null,null,null,"männl. über 1 1/2 ",39,"männl. über 1 1/2 "]
[null,null,null,null,null,"Zuchtbullen",40,"Zuchtbullen"]
[null,null,null,null,null,"weibl. bis 1/2 jahr",41,"weibl. bis 1/2 jahr"]
[null,null,null,null,null,"weibl. 1/2 bis 1 Jahr",42,"weibl. 1/2 bis 1 Jahr"]
[null,null,null,null,null,"weibl. 1 bis 2  Jahr",43,"weibl. 1 bis 2  Jahr"]
[null,null,null,null,null,"Färsen",44,"Färsen"]
[null,null,null,null,null,"Milchkühe",45,"Milchkühe"]
[null,null,null,null,null,"Mutter- und Ammenkühe",46,"Mutter- und Ammenkühe"]
[null,null,null,null,null,"Junghennen",47,"Junghennen"]
[null,null,null,null,null,"Legehennen",48,"Legehennen"]
[null,null,null,null,null,"Hähne",49,"Hähne"]
[]
[null,"Abdeckungsbescheinigungen sind für Prüfungszwecke aufzubewahren!"]

{"sheet":"Betriebsfläche am 30.6.","index":5,"n_rows":25,"n_cols":27,"rows_kept":25,"cut":false,"hidden":false,"merged":[[15,15,17,15],[15,16,17,16],[12,11,14,11],[12,12,14,12],[12,13,14,13],[12,14,14,14],[12,15,14,15],[1,5,1,6],[9,6,11,6],[15,6,17,6],[12,6,14,6],[3,15,3,16],[12,7,14,7],[12,8,14,8],[12,9,14,9],[12,10,14,10],[15,9,17,9],[15,10,17,10],[15,11,17,11],[15,12,17,12],[15,13,17,13],[1,2,1,4],[3,1,3,2],[9,3,11,3],[12,3,14,3],[15,3,17,3],[9,4,11,4],[9,5,11,5],[12,4,14,4],[12,5,14,5],[15,4,17,4],[15,5,17,5],[15,2,17,2],[3,17,3,18],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[15,26,17,26],[3,19,3,20],[4,19,4,20],[5,19,5,20],[6,19,8,20],[15,22,17,22],[6,10,8,10],[6,11,8,11],[6,12,8,12],[6,3,8,3],[6,4,8,4],[6,5,8,5],[6,6,8,6],[6,7,8,7],[6,8,8,8],[6,9,8,9],[15,14,17,14],[18,19,18,20],[12,23,14,23],[6,1,11,1],[6,2,8,2],[9,2,11,2],[12,2,14,2],[12,1,17,1],[15,23,17,23],[6,17,8,17],[6,18,8,18],[9,17,11,17],[9,18,11,18],[12,17,14,17],[12,18,14,18],[15,17,17,17],[9,11,11,11],[9,12,11,12],[9,13,11,13],[9,14,11,14],[9,15,11,15],[9,7,11,7],[9,8,11,8],[9,9,11,9],[15,8,17,8],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[19,15,19,16],[6,22,8,22],[6,23,8,23],[9,22,11,22],[9,23,11,23],[12,22,14,22],[9,19,11,20],[12,19,14,20],[19,19,19,20],[15,18,17,18],[6,13,8,13],[6,14,8,14],[6,15,8,15],[6,16,8,16],[9,16,11,16],[9,10,11,10],[12,16,14,16],[15,7,17,7],[6,27,8,27],[9,27,11,27],[12,27,14,27],[15,19,17,20],[15,27,17,27],[6,24,8,24],[6,25,8,25],[6,26,8,26],[9,24,11,24],[9,25,11,25],[9,26,11,26],[12,24,14,24],[12,25,14,25],[12,26,14,26],[15,24,17,24],[15,25,17,25]]}
[]
[null,null,"Betriebsfläche  am",null,null,{"$f":"WJ_2","v":"30.6.2024"}]
[]
["3.","Flächen",null,"Acker-\nland",null,"Dauer-\ngrünland",null,"Obst",null,"Forst",null,"Öd- und Umland",null,"Wege, Hof,\nGebäude",null,"sonstige Flächen",null,"Gesamt-\nfläche",null,"Gesamt-\nfläche in ha",null,null,"ha","ar"]
[null,null,null,"ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","ha","ar"]
[null,null,"Eigentum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6+F6+H6+J6+L6+N6+P6","v":0},{"$f":"E6+G6+I6+K6+M6+O6+Q6","v":0},{"$f":"AA6","v":0},null,null,{"$f":"D6+F6+H6+J6+L6+N6+P6","v":0},{"$f":"SUM(E6+G6+I6+K6+M6+O6+Q6)/100","v":0},null,null,{"$f":"W6+X6","v":0}]
[null,"Zupacht","Entgeltlich",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D7+F7+H7+J7+L7+N7+P7","v":0},{"$f":"E7+G7+I7+K7+M7+O7+Q7","v":0},{"$f":"AA7","v":0},null,null,{"$f":"D7+F7+H7+P7+J7+L7+N7","v":0},{"$f":"SUM(E7+G7+I7+K7+M7+O7+Q7)/100","v":0},null,null,{"$f":"W7+X7","v":0}]
[]
[]
[null,null,"Unentgeltlich",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10+F10+H10+J10+L10+N10+P10","v":0},{"$f":"E10+G10+I10+K10+M10+O10+Q10","v":0},{"$f":"AA10","v":0},null,null,{"$f":"D10+F10+H10+P10+J10+L10+N10","v":0},{"$f":"SUM(E10+G10+I10+K10+M10+O10+Q10)/100","v":0},null,null,{"$f":"W10+X10","v":0}]
[]
[]
[null,"Verpacht","Entgeltlich",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D13+F13+H13+J13+L13+N13+P13","v":0},{"$f":"E13+G13+I13+K13+M13+O13+Q13","v":0},{"$f":"AA13","v":0},null,null,{"$f":"D13+F13+H13+P13+J13+L13+N13","v":0},{"$f":"SUM(E13+G13+I13+K13+M13+O13+Q13)/100","v":0},null,null,{"$f":"W13+X13","v":0}]
[]
[]
[null,null,"Unentgeltlich",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D16+F16+H16+J16+L16+N16+P16","v":0},{"$f":"E16+G16+I16+K16+M16+O16+Q16","v":0},{"$f":"AA16","v":0},null,null,{"$f":"D16+F16+H16+J16+L16+N16+P16","v":0},{"$f":"SUM(E16+G16+I16+K16+M16+O16+Q16)/100","v":0},null,null,{"$f":"W16+X16","v":0}]
[]
[]
[null,"bewirtschaftete Fläche",null,{"$f":"D6+D7+D10-D13-D16","v":0},{"$f":"E6+E7+E10-E13-E16","v":0},0,0,0,0,{"$f":"J6+J7+J10-J13-J16","v":0},0,{"$f":"L6+L7+L10-L13-L16","v":0},0,{"$f":"N6+N7+N10-N13-N16","v":0},0,{"$f":"P6+P7+P10-P13-P16","v":0},0,{"$f":"R6+R7+R10-R13-R16","v":0},{"$f":"S6+S7+S10-S13-S16","v":0},{"$f":"T6+T7+T10-T13-T16","v":0},null,null,{"$f":"W6+W7+W10-W13-W16","v":0},{"$f":"X6+X7+X10-X13-X16","v":0},null,null,{"$f":"AA6+AA7+AA10-AA13-AA16","v":0}]
[null,"bewirtschaftete Fläche in ha",null,{"$f":"D24+E24","v":0},null,{"$f":"F24+G24","v":0},null,{"$f":"H24+I24","v":0},null,{"$f":"J24+K24","v":0},null,{"$f":"L24+M24","v":0},null,{"$f":"N24+O24","v":0},null,{"$f":"P24+Q24","v":0}]
[]
[]
[null,null,null,{"$f":"D19","v":0},{"$f":"E19/10","v":0},{"$f":"F19","v":0},{"$f":"G19/10","v":0},{"$f":"H19","v":0},{"$f":"I19/10","v":0},{"$f":"J19","v":0},{"$f":"K19/10","v":0},{"$f":"L19","v":0},{"$f":"M19/10","v":0},{"$f":"N19","v":0},{"$f":"O19/10","v":0},{"$f":"P19","v":0},{"$f":"Q19/10","v":0},{"$f":"R19","v":0},{"$f":"S19/10","v":0}]
[null,null,null,{"$f":"D19","v":0},{"$f":"E19/100","v":0},{"$f":"F19","v":0},{"$f":"G19/100","v":0},{"$f":"H19","v":0},0,{"$f":"J19","v":0},0,{"$f":"L19","v":0},0,{"$f":"N19","v":0},0,{"$f":"P19","v":0},0]
[null,null,null,null,{"$f":"IF(ROUND(E19/100,1)>=0.5,1,0)","v":0},null,{"$f":"IF(ROUND(G19/100,1)>=0.5,1,0)","v":0},null,{"$f":"IF(ROUND(I19/100,1)>=0.5,1,0)","v":0},null,{"$f":"IF(ROUND(K19/100,1)>=0.5,1,0)","v":0},null,{"$f":"IF(ROUND(M19/100,1)>=0.5,1,0)","v":0},null,{"$f":"IF(ROUND(O19/100,1)>=0.5,1,0)","v":0},null,{"$f":"IF(ROUND(Q19/100,1)>=0.5,1,0)","v":0}]

{"sheet":"Betr.flächenveränderung im WJ","index":6,"n_rows":26,"n_cols":32,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,3,1,9],[1,11,1,12],[4,21,4,22],[5,20,6,20],[7,19,8,19],[21,26,22,26],[7,11,8,11],[7,12,8,12],[19,19,20,19],[19,20,20,20],[9,19,10,19],[9,20,10,20],[11,19,12,19],[11,20,12,20],[13,19,14,19],[13,20,14,20],[15,19,16,19],[15,20,16,20],[17,19,18,19],[17,20,18,20],[9,3,10,3],[13,3,14,3],[5,19,6,19],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[21,1,21,4],[3,1,3,4],[5,4,6,4],[7,4,8,4],[9,4,10,4],[11,4,12,4],[13,4,14,4],[15,4,16,4],[17,3,18,3],[5,2,12,2],[5,1,12,1],[11,3,12,3],[19,3,20,3],[13,1,20,1],[13,2,20,2],[5,3,6,3],[15,3,16,3],[17,4,18,4],[7,3,8,3],[19,4,20,4],[7,13,8,13],[7,20,8,20],[3,17,3,18],[3,19,3,20],[7,18,8,18],[9,8,10,8],[9,9,10,9],[5,16,6,16],[5,17,6,17],[5,18,6,18],[7,14,8,14],[7,15,8,15],[7,16,8,16],[7,17,8,17],[9,15,10,15],[9,16,10,16],[9,17,10,17],[9,18,10,18],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,15,6,15],[3,15,3,16],[5,10,6,10],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,13,12,13],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[5,11,6,11],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,13,10,13],[9,14,10,14],[9,5,10,5],[9,6,10,6],[9,7,10,7],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[7,10,8,10],[11,17,12,17],[11,18,12,18],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,16,14,16],[13,17,14,17],[13,18,14,18],[11,14,12,14],[11,15,12,15],[11,16,12,16],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,9,12,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[3,21,3,22],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[17,17,18,17],[17,18,18,18],[19,5,20,5],[19,6,20,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[19,16,20,16],[19,17,20,17],[19,18,20,18],[15,15,16,15],[15,16,16,16],[5,24,6,24],[5,25,6,25],[7,24,8,24],[7,25,8,25],[9,24,10,24],[9,25,10,25],[22,15,22,16],[22,17,22,18],[22,1,22,4],[22,19,22,20],[15,17,16,17],[15,18,16,18],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[17,10,18,10],[17,11,18,11],[17,12,18,12],[17,13,18,13],[17,14,18,14],[17,15,18,15],[17,16,18,16],[17,24,18,24],[17,25,18,25],[19,24,20,24],[19,25,20,25],[21,24,22,24],[21,25,22,25],[11,24,12,24],[11,25,12,25],[13,24,14,24],[13,25,14,25],[15,24,16,24],[15,25,16,25],[21,21,22,22],[17,26,18,26],[17,27,18,27],[19,26,20,26],[19,27,20,27],[5,21,6,22],[7,21,8,22],[9,21,10,22],[11,21,12,22],[13,21,14,22],[15,21,16,22],[17,21,18,22],[19,21,20,22],[11,26,12,26],[11,27,12,27],[13,26,14,26],[13,27,14,27],[15,26,16,26],[15,27,16,27],[5,26,6,26],[5,27,6,27],[7,26,8,26],[7,27,8,27],[9,26,10,26],[23,27,24,27],[23,28,24,28],[25,27,26,27],[25,28,26,28],[5,28,6,28],[7,28,8,28],[9,28,10,28],[11,28,12,28],[13,28,14,28],[15,28,16,28],[17,28,18,28],[19,28,20,28],[9,27,10,27]]}
[]
["4.",null,null,"Betriebsflächenveränderung im Wirtschaftsjahr",null,null,null,null,null,null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
[null,"Flächen",null,null,null,"Acker-\nland",null,"Dauer-\ngrünland",null,"Obst",null,"Forst",null,"Öd- und Umland",null,"Wege, Hof,\nGebäude",null,"sonstige Flächen",null,"Gesamt\nfläche",null,"Gesamt\nfläche"]
[null,null,null,null,null,"ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","ha","ar","in ha"]
[null,"Zugang","Eigentum","Zugang","+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F6+H6+J6+L6+N6+P6+R6)","v":0},{"$f":"SUM(G6+I6+K6+M6+O6+Q6+S6)","v":0},{"$f":"AD6","v":0},null,null,{"$f":"F6+H6+J6+L6+N6+P6+R6","v":0},{"$f":"G6+I6+K6+M6+O6+Q6+S6","v":0},null,{"$f":"Y6+AA6","v":0},{"$f":"Z6/100","v":0},{"$f":"SUM(AB6:AC7)","v":0}]
[]
[null,null,null,"Umwandlung","+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F8+H8+J8+L8+N8+P8+R8)","v":0},{"$f":"SUM(G8+I8+K8+M8+O8+Q8+S8)","v":0},{"$f":"AD8","v":0},null,null,{"$f":"F8+H8+J8+L8+N8+P8+R8","v":0},{"$f":"G8+I8+K8+M8+O8+Q8+S8","v":0},null,{"$f":"Y8+AA8","v":0},{"$f":"Z8/100","v":0},{"$f":"SUM(AB8:AC9)","v":0}]
[]
[null,null,null,"zurückgenommene\nPacht","+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10+H10+J10+L10+N10+P10+R10)","v":0},{"$f":"SUM(G10+I10+K10+M10+O10+Q10+S10)","v":0},{"$f":"AD10","v":0},null,null,{"$f":"F10+H10+J10+L10+N10+P10+R10","v":0},{"$f":"G10+I10+K10+M10+O10+Q10+S10","v":0},null,{"$f":"Y10+AA10","v":0},{"$f":"Z10/100","v":0},0]
[]
[null,null,null,"Zupacht","+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F12+H12+J12+L12+N12+P12+R12)","v":0},{"$f":"SUM(G12+I12+K12+M12+O12+Q12+S12)","v":0},{"$f":"AD12","v":0},null,null,{"$f":"F12+H12+J12+L12+N12+P12+R12","v":0},{"$f":"G12+I12+K12+M12+O12+Q12+S12","v":0},null,{"$f":"Y12+AA12","v":0},{"$f":"Z12/100","v":0},0,null,{"$f":"SUM(AD6:AD12)","v":0}]
[]
[null,"Abgan","Eigentum","Abgang","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F14+H14+J14+L14+N14+P14+R14)","v":0},{"$f":"SUM(G14+I14+K14+M14+O14+Q14+S14)","v":0},{"$f":"AD14","v":0},null,null,{"$f":"F14+H14+J14+L14+N14+P14+R14","v":0},{"$f":"G14+I14+K14+M14+O14+Q14+S14","v":0},null,{"$f":"Y14+AA14","v":0},{"$f":"Z14/100","v":0},0]
[]
[null,null,null,"Umwandlung","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F16+H16+J16+L16+N16+P16+R16)","v":0},{"$f":"SUM(G16+I16+K16+M16+O16+Q16+S16)","v":0},{"$f":"AD16","v":0},null,null,{"$f":"F16+H16+J16+L16+N16+P16+R16","v":0},{"$f":"G16+I16+K16+M16+O16+Q16+S16","v":0},null,{"$f":"Y16+AA16","v":0},{"$f":"Z16/100","v":0},0]
[]
[null,null,null,"Verpachtet","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F18+H18+J18+L18+N18+P18+R18)","v":0},{"$f":"SUM(G18+I18+K18+M18+O18+Q18+S18)","v":0},{"$f":"AD18","v":0},null,null,{"$f":"F18+H18+J18+L18+N18+P18+R18","v":0},{"$f":"G18+I18+K18+M18+O18+Q18+S18","v":0},null,{"$f":"Y18+AA18","v":0},{"$f":"Z18/100","v":0},0]
[]
[null,null,null,"Zupacht abgegeben","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F20+H20+J20+L20+N20+P20+R20)","v":0},{"$f":"SUM(G20+I20+K20+M20+O20+Q20+S20)","v":0},{"$f":"AD20","v":0},null,null,{"$f":"F20+H20+J20+L20+N20+P20+R20","v":0},{"$f":"G20+I20+K20+M20+O20+Q20+S20","v":0},null,{"$f":"Y20+AA20","v":0},{"$f":"Z20/100","v":0},0,null,{"$f":"SUM(AD14:AD20)","v":0}]
[]
[null,"Aufrechnung",null,null,null,{"$f":"SUM(F6+F8+F10+F12-F14-F16-F18-F20)","v":0},{"$f":"SUM(G6+G8+G10+G12-G14-G16-G18-G20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T6+T8+T10+T12-T14-T16-T18-T20)","v":0},{"$f":"U6+U8+U10+U12-U14-U16-U18-U20","v":0},{"$f":"SUM(V6+V8+V10+V12-V14-V16-V18-V20)","v":0},null,null,{"$f":"F22+H22+J22+L22+N22+P22+R22","v":0},{"$f":"G22+I22+K22+M22+O22+Q22+S22","v":0},null,{"$f":"SUM(AB6+AB8+AB10+AB12-AB14-AB16-AB18-AB20)","v":0},0,{"$f":"SUM(AD6+AD8+AD10+AD12-AD14-AD16-AD18-AD20)","v":0},null,{"$f":"AF12-AF20","v":0}]
[null,"Aufrechnung in ha",null,null,null,{"$f":"SUM(F24:G24)","v":0},null,{"$f":"SUM(H24:I24)","v":0},null,{"$f":"SUM(J24:K24)","v":0},null,{"$f":"SUM(L24:M24)","v":0},null,{"$f":"SUM(N24:O24)","v":0},null,{"$f":"SUM(P24:Q24)","v":0},null,{"$f":"SUM(R24:S24)","v":0},null,{"$f":"SUM(T24:U24)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AB7+AB9+AB11+AB13-AB15-AB17-AB19-AB21)","v":0},0]
[null,null,null,null,null,{"$f":"SUM(F22)","v":0},{"$f":"G22/100","v":0},{"$f":"SUM(H22)","v":0},{"$f":"I22/100","v":0},{"$f":"SUM(J22)","v":0},{"$f":"K22/100","v":0},{"$f":"SUM(L22)","v":0},{"$f":"M22/100","v":0},{"$f":"SUM(N22)","v":0},{"$f":"O22/100","v":0},{"$f":"SUM(P22)","v":0},{"$f":"Q22/100","v":0},{"$f":"SUM(R22)","v":0},{"$f":"S22/100","v":0},{"$f":"SUM(T22)","v":0},{"$f":"U22/100","v":0},null,null,null,null,null,null,{"$f":"Y24+AA24","v":0},{"$f":"Z24/100","v":0},{"$f":"SUM(AB24:AC25)","v":0}]
[null,"Bei Flächenzukäufen oder -verkäufen im abgelaufenen Wirtschaftsjahr bitten wir um Einreichen entsprechender Kaufverträge, sofern uns diese "]
[null,"noch nicht vorliegen. Bei neuen Flächenzu- und -verpachtungen bitten wir um Einreichen entsprechender Pachtverträge",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":"Y26+AA26","v":0},{"$f":"Z26/100","v":0},{"$f":"SUM(AB26:AC27)","v":0}]

{"sheet":"Erntefläche","index":7,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,5]]}
[]
[null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["5.","Ernteflächen 2023/24 und innerbetriebliche Verbräuche"]
[]
[null,"Die folgenden Angaben sind für einen aussagekräftigen Jahresabschluß unumgänglich. Es sind die"]
[null,"Flächen anzugeben, die im Sommer bzw, Herbst 2023 abgeerntet wurden."]
[null,"(Vgl. Agrarantrag Frühjahr 2023 bzw. Abschlussfragebogen Vorjahr Punkt 6)"]
[]
[null,null,"Verbrauch eigenproduzierter Produkte"]
[]
[null,null,"Fläche in ha","Verfüttert in dt\n(Gesamtmenge)","ausgesät/ausge-\npflanzt in dt (Gesamtmenge)","NF",null,"Ergänzungen bitte\nunten einfügen",null,null,null,"=BEREICH.VERSCHIEBEN('Erntefläche'!$H$16;0;0;ANZAHL('Erntefläche'!$G$16:$G$42);1)"]
[null,"Bitte Auswählen"]
[null,null,null,null,null,null,null,"Winterweizen",null,null,{"$f":"IF(COUNTIF($B$14:$B$44,H14)>=1,\"\",(ROW()))","v":14},{"$f":"IF(ROW(H14)-ROW(H14)+1>COUNT($K$14:$K$44),\"\",INDEX(H:H,SMALL(K$14:K$44,1+ROW(H14)-ROW(H$14))))","v":"Winterweizen"}]
[null,null,null,null,null,null,null,"Sommerweizen",null,null,15,{"$f":"IF(ROW(H15)-ROW(H15)+1>COUNT($K$14:$K$44),\"\",INDEX(H:H,SMALL(K$14:K$44,1+ROW(H15)-ROW(H$14))))","v":"Sommerweizen"}]
[null,null,null,null,null,null,null,"Tricale",null,null,16,{"$f":"IF(ROW(H11)-ROW(H16)+1>COUNT($K$14:$K$44),\"\",INDEX(H:H,SMALL(K$14:K$44,1+ROW(H16)-ROW(H$14))))","v":"Tricale"}]
[null,null,null,null,null,null,null,"Roggen",null,null,17,"Roggen"]
[null,null,null,null,null,null,null,"Wintergerste",null,null,18,"Wintergerste"]
[null,null,null,null,null,null,null,"Sommergerste",null,null,19,"Sommergerste"]
[null,null,null,null,null,null,null,"Hafer",null,null,20,"Hafer"]
[null,null,null,null,null,null,null,"Öllein",null,null,21,"Öllein"]
[null,null,null,null,null,null,null,"Raps",null,null,22,"Raps"]
[null,null,null,null,null,null,null,"Erbsen",null,null,23,"Erbsen"]
[null,null,null,null,null,null,null,"Bohnen",null,null,24,"Bohnen"]
[null,null,null,null,null,null,null,"Speisekartoffeln",null,null,25,"Speisekartoffeln"]
[null,null,null,null,null,null,null,"Saatkartoffeln",null,null,26,"Saatkartoffeln"]
[null,null,null,null,null,null,null,"Industriekartoffeln",null,null,27,"Industriekartoffeln"]
[null,null,null,null,null,null,null,"Zuckerrüben",null,null,28,"Zuckerrüben"]
[null,null,null,null,null,null,null,"Futterrrüben",null,null,29,"Futterrrüben"]
[null,null,null,null,null,null,null,"Silomais",null,null,30,"Silomais"]
[null,null,null,null,null,null,null,"Körnermais",null,null,31,"Körnermais"]
[null,null,null,null,null,null,null,"Energiemais",null,null,32,"Energiemais"]
[null,null,null,null,null,null,null,"Grassamen",null,null,33,"Grassamen"]
[null,null,null,null,null,null,null,"Ackerfutter",null,null,34,"Ackerfutter"]
[null,null,null,null,null,null,null,"Dauergrünland Fläche",null,null,35,"Dauergrünland Fläche"]
[null,null,null,null,null,null,null,"Spargel",null,null,36,"Spargel"]
[null,null,null,null,null,null,null,"Erdbeeren",null,null,37,"Erdbeeren"]
[null,null,null,null,null,null,null,"Heidelbeeren",null,null,38,"Heidelbeeren"]
[null,null,null,null,null,null,null,"sonstiges ",null,null,39,"sonstiges "]
[null,null,null,null,null,null,null,"Blumen",null,null,40,"Blumen"]
[null,null,null,null,null,null,null,"Flächenstilllegung",null,null,{"$f":"IF(COUNTIF($B$14:$B$44,H41)>=1,\"\",(ROW()))","v":41},{"$f":"IF(ROW(H36)-ROW(H41)+1>COUNT($K$14:$K$44),\"\",INDEX(H:H,SMALL(K$14:K$44,1+ROW(H41)-ROW(H$14))))","v":"Flächenstilllegung"}]
[null,null,null,null,null,null,null,null,null,null,42,0]
[null,null,null,null,null,null,null,null,null,null,43,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF($B$14:$B$44,H44)>=1,\"\",(ROW()))","v":44},{"$f":"IF(ROW(H35)-ROW(H44)+1>COUNT($K$14:$K$44),\"\",INDEX(H:H,SMALL(K$14:K$44,1+ROW(H44)-ROW(H$14))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF($B$14:$B$44,H45)>=1,\"\",(ROW()))","v":45},{"$f":"IF(ROW(H36)-ROW(H45)+1>COUNT($K$14:$K$45),\"\",INDEX(H:H,SMALL(K$14:K$45,1+ROW(H45)-ROW(H$14))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(ROW(H37)-ROW(H46)+1>COUNT($K$14:$K$46),\"\",INDEX(H:H,SMALL(K$14:K$46,1+ROW(H46)-ROW(H$14))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(ROW(H38)-ROW(H47)+1>COUNT($K$14:$K$47),\"\",INDEX(H:H,SMALL(K$14:K$47,1+ROW(H47)-ROW(H$14))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(ROW(H39)-ROW(H48)+1>COUNT($K$14:$K$48),\"\",INDEX(H:H,SMALL(K$14:K$48,1+ROW(H48)-ROW(H$14))))","v":0}]
[null,"Gesamtfläche in ha",{"$f":"SUM(C18:C48)","v":0}]
[]
[null,"Im Falle von 2 Ernten (z.B.Grünroggen / Mais) bitte die Vorfrucht mit \"NF\" kennzeichnen"]

{"sheet":"Anbaufläche","index":8,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,1,3,5],[1,1,1,2],[1,3,1,5]]}
[]
[null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["6.","Anbaufläche und Aussaatmengen im Wirtschaftsjahr",null,null,null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
[null,"Es sind die Flächen anzugeben, die im Sommer Herbst 2023 bzw. im Frühjahr 2024",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF($C$13:$C$26,F13)>=1,\"\",(ROW()))","v":6}]
[null,"bestellt wurden."]
[]
[null,null,"Fläche in ha","Aussaatmenge in\ndt/ha","NF",null,"Ergänzungen bitte\nunten einfügen",null,null,null,null,"=WENN(ZEILE(G11)-ZEILE(G11)+1>ANZAHL($H$11:$H$19);\"\";INDEX(G:G;KKLEINSTE(H$11:H$19;1+ZEILE(G11)-ZEILE(G$11))))"]
[null,"Bitte Auswählen"]
[null,null,null,null,null,null,"Winterweizen",null,{"$f":"IF(COUNTIF($B$11:$B$41,G11)>=1,\"\",(ROW()))","v":11},{"$f":"IF(ROW(I11)-ROW(I11)+1>COUNT($I$11:$I$41),\"\",INDEX(G:G,SMALL(I$11:I$41,1+ROW(G11)-ROW(G$11))))","v":"Winterweizen"},null,"=BEREICH.VERSCHIEBEN('Erntefläche'!$H$16;0;0;ANZAHL('Erntefläche'!$G$16:$G$42);1)"]
[null,null,null,null,null,null,"Sommerweizen",null,12,"Sommerweizen"]
[null,null,null,null,null,null,"Tricale",null,13,"Tricale"]
[null,null,null,null,null,null,"Roggen",null,14,"Roggen"]
[null,null,null,null,null,null,"Wintergerste",null,15,"Wintergerste"]
[null,null,null,null,null,null,"Sommergerste",null,16,"Sommergerste"]
[null,null,null,null,null,null,"Hafer",null,17,"Hafer"]
[null,null,null,null,null,null,"Öllein",null,18,"Öllein"]
[null,null,null,null,null,null,"Raps",null,19,"Raps"]
[null,null,null,null,null,null,"Erbsen",null,20,"Erbsen"]
[null,null,null,null,null,null,"Bohnen",null,21,"Bohnen"]
[null,null,null,null,null,null,"Speisekartoffeln",null,22,"Speisekartoffeln"]
[null,null,null,null,null,null,"Saatkartoffeln",null,23,"Saatkartoffeln"]
[null,null,null,null,null,null,"Industriekartoffeln",null,24,"Industriekartoffeln"]
[null,null,null,null,null,null,"Zuckerrüben",null,25,"Zuckerrüben"]
[null,null,null,null,null,null,"Futterrrüben",null,26,"Futterrrüben"]
[null,null,null,null,null,null,"Silomais",null,27,"Silomais"]
[null,null,null,null,null,null,"Körnermais",null,28,"Körnermais"]
[null,null,null,null,null,null,"Energiemais",null,29,"Energiemais"]
[null,null,null,null,null,null,"Grassamen",null,30,"Grassamen"]
[null,null,null,null,null,null,"Ackerfutter",null,31,"Ackerfutter"]
[null,null,null,null,null,null,"Dauergrünland Fläche",null,32,"Dauergrünland Fläche"]
[null,null,null,null,null,null,"Spargel",null,33,"Spargel"]
[null,null,null,null,null,null,"Erdbeeren",null,34,"Erdbeeren"]
[null,null,null,null,null,null,"Heidelbeeren",null,35,"Heidelbeeren"]
[null,null,null,null,null,null,"sonstiges ",null,36,"sonstiges "]
[null,null,null,null,null,null,"Blumen",null,{"$f":"IF(COUNTIF($B$11:$B$41,G37)>=1,\"\",(ROW()))","v":37},"Blumen"]
[null,null,null,null,null,null,"Flächenstilllegung",null,38,"Flächenstilllegung"]
[null,null,null,null,null,null,null,null,39,0]
[null,null,null,null,null,null,null,null,40,0]
[null,null,null,null,null,null,null,null,41,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF($B$11:$B$41,G42)>=1,\"\",(ROW()))","v":42},{"$f":"IF(ROW(I42)-ROW(I42)+1>COUNT($I$11:$I$42),\"\",INDEX(G:G,SMALL(I$11:I$42,1+ROW(G42)-ROW(G$11))))","v":0}]
[null,null,null,null,null,null,null,null,43,{"$f":"IF(ROW(I43)-ROW(I43)+1>COUNT($I$11:$I$43),\"\",INDEX(G:G,SMALL(I$11:I$43,1+ROW(G43)-ROW(G$11))))","v":0}]
[null,null,null,null,null,null,null,null,44,{"$f":"IF(ROW(I44)-ROW(I44)+1>COUNT($I$11:$I$44),\"\",INDEX(G:G,SMALL(I$11:I$44,1+ROW(G44)-ROW(G$11))))","v":0}]
[null,null,null,null,null,null,null,null,45,{"$f":"IF(ROW(I45)-ROW(I45)+1>COUNT($I$11:$I$45),\"\",INDEX(G:G,SMALL(I$11:I$45,1+ROW(G45)-ROW(G$11))))","v":0}]
[null,null,null,null,null,null,null,null,46,{"$f":"IF(ROW(I46)-ROW(I46)+1>COUNT($I$11:$I$46),\"\",INDEX(G:G,SMALL(I$11:I$46,1+ROW(G46)-ROW(G$11))))","v":0}]
[null,null,null,null,null,null,null,null,47,{"$f":"IF(ROW(I47)-ROW(I47)+1>COUNT($I$11:$I$47),\"\",INDEX(G:G,SMALL(I$11:I$47,1+ROW(G47)-ROW(G$11))))","v":0}]
[null,"Gesamtfläche in ha",{"$f":"SUM(C11:C47)","v":0}]
[]
[null,"Die Anbaufläche muss mit dem Agrarantrag übereinstimmen (Antrag  ggf. in Kopie beifügen)"]
[]
[null,"Die Gesamtfläche muss mit der unter Punkt 3 aufgeführten bewirtschafteten Fläche Acker"]
[null,"übereinstimmen."]
[]
[null,"Im Fall von zwei Ernten (z.B. Grünroggen / Mais) bitte die Vorfrucht mit \"NF\" kennzeichnen"]

{"sheet":"nachrichtliche Angaben","index":9,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,1,3]]}
[]
[null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["7.","Nachrichtliche Angaben"]
[]
[null,"Vorratsmenge\n Zuckerrüben",null,null,"Vorratsmenge Industrie-\nkartoffeln"]
[]
[null,null,"in dt",null,null,"in dt"]
[null,"Zuckerrüben",null,null,"Stärkeproduktion"]
[null,"Bioethanolproduktion",null,null,"Chipsproduktion"]
[null,null,null,null,"Veredelungsproduktion"]
[]
[null,"gesamt",{"$f":"SUM(C9:C12)","v":0},null,"gesamt",{"$f":"SUM(F9:F12)","v":0}]
[]
[null,"Pachtwert der Eigentums-\nflächen",null,null,"Anzahl der bewirtschafteten\nSchläge"]
[]
[null,null,"in €/ha",null,null,"in Stück"]
[]
[]
[null,"Belieferbare Referenzmenge Milch"]
[]
[null,null,"Menge in Kg ","bei Basisfettgehalt in %"]
[null,"belieferbare Referenzmenge"]
[]
[null,"im Rahmen des Milchlieferstreiks wurden …"]
[]
[null,null,null,"Menge in l"]
[null,"an die Kälber vertränkt / anderweitig verfüttert"]
[null,"nicht  geliefert (vernichtet etc.)"]

{"sheet":"aussteh. Geldforderungen","index":10,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,3],[10,2,10,4],[11,2,11,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[3,1,3,5]]}
[]
[null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["8.","Größere am 30.6.2024 noch ausstehende Geldforde-\nrungen, die uns in der Buchhaltung noch nicht vorlagen"]
[]
[null,"Name","Art der Lieferung",null,null,"offener Betrag\nin €"]
[]
[null,"Hauptzollamt","Agrardieselerstattung für 2023"]
[null,null,"(nachreichen, sobald diese vorliegt oder ggf. schätzen)"]

{"sheet":"zum Stichtag n.n.bez. Rg. ","index":11,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,3],[11,2,11,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[3,1,3,5]]}
[]
[null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["9.","Größere am 30.6.2024 noch nicht bezahlte Rechnungen, die uns in der Buchhaltung noch nicht vorlagen"]
[]
[null,"Name","Art der Lieferung",null,null,"offener Betrag\nin €"]

{"sheet":"lang. mittelf. Darlehen","index":12,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[18,4,18,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5]]}
[]
[null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["10.","Lang- und mittelfristige Darlehen"]
[]
[null,"Bitte stellen Sie die Darlehnsstände per 30.6.2024 auf und dokumentieren Sie diese mittels"]
[null,"Kopie, soweit die Angaben nicht aus der Buchführung ersichtlich sind."]
[null,"Fügen Sie für neu aufgenommene Darlehen bitte die Kreditverträge, Darlehnskontoauszüge oder"]
[null,"Tilgungpläne bei."]
[null,"Wir benötigen auch die Angabe wofür die neuen Kreditmittel in Anspruch genommen wurden."]
[]
[null,"Darlehnsgeber","Darl. Nr.","Darl. Höhe","Darlehnsgrund"]

{"sheet":"Privatkonten","index":13,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,3,1,4],[15,3,15,5],[16,3,16,5],[10,3,10,5],[12,3,12,5],[13,3,13,5],[14,3,14,5]]}
[]
[null,null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["11.","Privatkonten"]
[]
[null,"Sind im abgelaufenen Wirtschaftsjahr betriebliche Vorgänge über Privatkonten oder"]
[null," andere Konten abgewickelt worden die uns in der Buchhaltung noch nicht vorlagen?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[null,null,null,"Vorgang",null,null,"Betrag in €"]

{"sheet":"betr. AK im Wirtschaftsjahr","index":14,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,3],[11,2,11,4],[12,2,12,4],[13,2,13,4],[9,2,9,4],[10,2,10,4]]}
[]
[null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["12.","Betriebliche Arbeitskräfte im Wirtschaftsjahr ",null,null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
[null,"(280 Arbeitstage entsprechen einer Voll Arbeitskraft)"]
[]
[null,null,null,null,null,"Anzahl auf Voll-\nAk umgerechnet"]
[]
[]
[]
[]
[]
[null,null,"Arbeitskräfte gesamt",null,null,{"$f":"SUM(F10:F12)","v":0}]

{"sheet":"betr. beköstigte Personen","index":15,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Wirtschaftsjahr",{"$f":"WJ_1","v":"2023/2024"}]
[]
["13.","Betrieblich beköstigte Personen im Wirtschaftsjahr 2023/2024"]
[]
[null,null,null,"Geburtsjahr","Verpflegungstage"]
[]
[null,"Auszubildende"]
[]
[]
[]
[null,"sonstige Fremd AK"]
[]
[]
[]
[null,"Aushilfen bei denen die Beköstigung in der"]
[null,"Lohnabrechnung berücksichtigt wurde"]

{"sheet":"Zugänge im AV","index":16,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[24,1,24,2],[18,1,18,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[1,3,1,4],[1,1,1,2],[5,1,5,2],[16,1,16,2],[7,1,7,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2]]}
[]
[null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["14.","Zugänge Maschinen. Gebäude, bauliche Anlagen und\nGrundverbesserungen"]
[]
[null,"a) neue Wirtschaftsgüter"]
[]
[null,"Wirtschaftsgut",null,null,"Anschaffungskosten\nin €","Datum der Lie-\nferung bzw. Fertig-\nstellung","Voraussichtl. be-\ntriebsgew. ND in \nJahren"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"a) gebrauchte Wirtschaftgüter"]
[]
[null,"Wirtschaftsgut","Baujahr",null,"Anschaffungskosten\nin €","Datum der Lie-\nferung ","Voraussichtl. Rest-\nnutzungsdauer in\nJahren"]

{"sheet":"Abgänge im AV","index":17,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[14,1,14,2],[24,1,24,2],[1,3,1,4]]}
[]
[null,null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["15.","Alte Maschinen, Gebäude, bauliche Anlagen und Grundverbesserungen"]
[]
[null,"Sind Maschinen, Gebäude usw. im Wirtschaftsjahr 2023/2024 aus dem Betriebsvermögen"]
[null,"ausgeschieden? (Verkauf, Verschrottung usw.)"]
[null,"Geben Sie ggf.Bezeichnung und Codierung/Inventarnummer aus dem"]
[null," Inventarverzeichnis des Vorjahresabschlusses (2022/2023)  an.",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[]
[]
[null,"Verkauf",null,null,"Bezeichnung","Codierung ","Inventar Nr.","Erlös in €"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Schrott",null,null,"Bezeichnung","Codierung ","Inventar Nr.","Erlös in €"]

{"sheet":"Berücks. zuk. Investitionen","index":18,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[15,1,15,2],[16,1,16,2],[13,1,13,2],[10,1,10,2],[12,1,12,2],[14,1,14,2]]}
[]
[null,null,"Wirtschaftsjahr",{"$f":"WJ_1","v":"2023/2024"}]
[]
["16.","Berücksichtigung zukünftiger Investitionen"]
[]
[null,"Um Ihre Steuerbelastung zu reduzieren, ist es unter bestimmten Voraussetzungen möglich, "]
[null,"Investitionsabzüge außerbilanzlich zu berücksichtigen. Wir bitten insofern um Auflistung"]
[null,"der Investitionen in neue oder gebrauchte bewegliche Wirtschaftsgüter, die Sie bis"]
[null,"zum 30.6.2027 planen."]
[]
[null,"geplante Anschaffung",null,"voraussichtliches\nInvestitionsdatum","voraussichtliche An-\nschaffungskosten\n(o. Ust) in €"]

{"sheet":"Berücksichtigung Heizung","index":19,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,3,1,4],[31,1,31,3],[25,1,25,3],[28,1,28,2],[29,1,29,2],[22,1,22,2],[5,1,5,3],[12,1,12,2],[13,1,13,2],[19,1,19,2],[20,1,20,2],[11,1,11,2],[14,1,14,2],[16,1,16,3],[9,1,9,2],[10,1,10,2],[7,5,7,7],[7,1,7,3],[21,1,21,2],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[18,1,18,2]]}
[]
[null,null,"Wirtschaftsjahr",{"$f":"WJ_1","v":"2023/2024"}]
[]
["17.","Berücksichtigung Heizungen"]
[]
[null,"a) Heizungen"]
[]
[null,"Heizung Wohnhaus",null,null,null,"Heizung Stall u/o Werkstatt"]
[]
[null,"Ölheizung",null,null,null,"Ölheizung"]
[null,"Gasheizung",null,null,null,"Gasheizung"]
[null,"Holzheizung",null,null,null,"Holzheizung"]
[null,"Solarheizung",null,null,null,"Solarheizung"]
[null,"Wärme Biogasanlage",null,null,null,"Wärme Biogasanlage"]
[null,null,null,null,null,"keine Heizung / Stall"]
[]
[null,"Heizung Trocknungsanlage"]
[]
[null,"Ölheizung"]
[null,"Gasheizung"]
[null,"Wärme Biogasanlage"]
[]
[null,"keine Trocknung"]
[]
[]
[null,"b) Verbrauch im Betrieb"]
[]
[null,null,null,null,"Maß","bzw. Betrag in €"]
[null,"Trocknungsanlage"]
[null,"Stall/Werkstatt"]
[]
[null,"c) Verbrauch im Büro"]
[]
[null,"Der Heizungsverbrauch des betrieblich genutzten Büroteils am ansonsten privat genutzten "]
[null,"Wohnteil beträgt:"]
[]
[null,null,"in Prozent"]

{"sheet":"Berücksichtigung Pkw","index":20,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["18.","Berücksichtigung PKW"]
[]
[null,"a) Diesel für PKW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,"Menge in Liter","für PKW","Kennzeichen"]
[]
[]
[]
[]
[]
[]
[null,"b) Privatnutzung PKW"]
[]
[null,"in wie vielen Monaten des Wirtschaftsjahres 2023/2024 wurde der Betriebs PKW (vgl. Inventarverzeichnis des"]
[null,"Vorjahresabschlusses 2022/2023) auch privat eingesetzt?"]
[]
[null,null,null,null,"PKW (Kennzeichen)","Anzahl Monate"]
[]
[]
[null,"Falls keine Eintragung erfolgt, gehen wir davon aus, dass der Betriebs PKW in allen 12 Monaten auch privat mit-"]
[null,"benutzt wurde. Wenn ein oder mehrere PKW ausschließlich betrieblich genutzt wurden, sollte das mittels"]
[null,"eines Fahrtenbuches dokumentiert werden, um den Ansatz von Privatanteilen zu vermeiden. Das gilt nach"]
[null,"Auffassung der Finanzverwaltung auch für PKW - ähnliche Fahrzeuge z.B. Geländewagen oder Pick up's."]
[]
[null,"Seit 2006 gilt bei PKW des sogenannten gewillkürten Betriebsvermögens (betriebliche Nutzung zwischen"]
[null,"10 und 50 %) eine geänderte Nutzungswertbesteuerung. Wir halten zum Nachweis des Anteils der betrieb-"]
[null,"lichen Nutzung eines Betriebs PKW eine entsprechende Dokumentation mittels Fahrtenbuch oder anderer"]
[null,"geeigneter Unterlagen für empfohlen."]
[]
[]
[null,null,null,null,null,"%"]
[null,"Danach beträgt der betreibliche Anteil"]
[]
[null,"und der nicht betriebliche Anteil"]
[]
[null,"c) betrieblich veranlasste Fahrten"]
[]
[null,"mit dem privaten PKW für den Betrieb gefahrene Km"]

{"sheet":"Entnahmen f.d. Haushalt","index":21,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,2,1,4],[27,1,27,3],[30,1,30,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[24,1,24,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[20,1,20,3]]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["19.","Entnahmen für den Haushalt"]
[]
[null,"Vom 1.7.2023 bis 30.6.2024 wurden aus dem Betrieb für den Haushalt "]
[null,"entnommen:"]
[]
[null,null,null,null,"Stück","Gewicht in KG"]
[null,"Schlachtschweine"]
[null,"Schlachtrinder"]
[null,"Schlachtgeflügel"]
[null,null,null,null,null," "]
[]
[null,null,null,null,null,"Menge in Kg"]
[null,"Spargel"]
[null,"Erdbeeren"]
[null,"Heidelbeeren"]
[]
[null,null,null,null,null,"Menge in Stück"]
[null,"Eier"]
[]
[]
[null,null,null,null,null,"Menge in Liter"]
[null,"Milch"]
[]
[null,null,null,null,null,"Menge in dt"]
[null,"Kartoffel"]
[]
[null,null,null,null,null,"Menge in rm"]
[null,"Brennholz, wenn es \nsonst hätte ver-\nkauft werden können"]

{"sheet":"Waschen f.d. Betrieb","index":22,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,1,9,3],[10,1,10,3],[11,1,11,3],[1,3,1,4]]}
[]
[null,null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["20.","Waschen für den Betrieb"]
[]
[null,"Wieviel Kg Wäsche (trocken) wurde im Wirtschaftsjahr 2023/2024. für Ihren Betrieb "]
[null," in Ihrer privaten Waschmaschine gewaschen?"]
[]
[null,null,null,null,"Menge in KG"]
[null,"typische Arbeitskleidung"]
[null,"Eutertücher u. ähnliches"]
[null,"gesamt",null,null,{"$f":"SUM(E10:E11)","v":0}]
[]
[null,"Wenn keine Eintragung erfolgt gehen wir davon aus, dass dafür kein betrieb-"]
[null,"licher Aufwand zu berücksichtigen ist."]

{"sheet":"Forstfläche","index":23,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[]
[null,null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["21.","Forstfläche"]
[]
[null,"Liegt ein aktuelles Forstbetriebsgutachten mit steuerlich anerkannten"]
[null,"Nutzungssatz vor?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]

{"sheet":"a.o. Holznutzung","index":24,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,3,1,4]]}
[]
[null,null,null,"Wirtschaftsjahr",null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["22.","Außerordentliche Holznutzung"]
[]
[null,"Ist im Wirtschaftsjahr 2023/2024. eine außerordentliche Holznutzung außerhalb des im "]
[null,"gültigen Forstberiebsgutachten festgelegten Nutzungssatzes angefallen oder hat es eine"]
[null,"Holznutzung infolge höherer Gewalt (Kalamitätsnutzung) gegeben?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,null,null,null,"Nachweise sind beigefügt"]
[null,null,null,null,"Nachweise wurden bereits eingereicht"]

{"sheet":"Eigenjagd","index":25,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,2,8,3],[9,2,9,3],[10,2,10,3],[1,2,1,4]]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["23.","Besitzen Sie eine Eigenjagd?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,"Eigenjagd 1","Eigenjagd 2","Eigenjagd 3"]
[null,null,"ja und zwar"]
[null,null,"selbst bejagt"]
[null,null,"verpachtet"]

{"sheet":"Bemerkungen","index":26,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[10,4,10,7],[1,2,1,4]]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["24.","Bemerkungen"]
[]
[null,"Haben sich im Wirtschaftsjahr 2023/2024 in Ihrem Betrieb besondere "]
[null,"Vorfälle ergeben, die das Betriebsergebnis maßgeblich beeinflußt haben?",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"z.B. Nässeschäden, Trockenschäden, Seuchen usw."]

{"sheet":"betr.wirt. Paket","index":27,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,1,4]]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["25.","Betriebswirtschaftliches Paket"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Ein betriebswirtschaftlicher Jahresabschluss mit ggf. darauf aufbauenden Betriebsvergleichen hat"]
[null,"für die Agrarberatung und für Kreditgeber zunehmende Bedeutung. Wir bieten Ihnen dieses Paket zu"]
[null,"einem Pauschalpreis von 250,00 € an."]
[null,"Von diesem Angebot soll Gebrauch gemacht werden:"]
[]
[]
[]
[]
[null,"Bei erstmaliger Ertstellung wird eine einmalige Einrichtungsgebühr von 130,00 € zusätzlich erhoben."]

{"sheet":"Erstellungsb.f. Kreditgeber","index":28,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,3,6,9],[1,2,1,4]]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["26.","Erstellungsbericht für Kreditgeber"]
[]
[]
[null,null,null,"es wird ein auf dem Jahresabschluss aufbauender Bericht mit \nPlausibilitätsprüfung benötigt",null,null,null,null,null,null,null,null,null,null,1,null,2]
[]
[]
[null,"Der Erstellungsbericht wird gesondert abgerechnet."]

{"sheet":"Vollständigkeitserklärung","index":29,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[9,1,9,3],[9,5,9,9],[1,2,1,4],[5,1,5,9],[7,1,7,3],[7,5,7,9]]}
[]
[null,null,"Wirtschaftsjahr",null,null,{"$f":"WJ_1","v":"2023/2024"}]
[]
["27.","Vollständigkeitserklärung"]
[]
[null,"Es wurden sämtliche Unterlagen und Nachweise vorgelegt sowie Auskünfte nach besten\n Wissen und Gewissen erteilt, welche für die Aufstellung des Jahresabschlusses zum 30.6.2024 notwendig sind. Es wird insbesondere versichert, dass bei der Inventur alle\n Gegenstände, Forderungen und Verbindlichkeiten erfasst wurden."]
[]
[null,"Ort",null,null,"den","Unterschrift"]