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

{"sheet":"Zusammenschlüsse Februar 2024","index":0,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":false,"merged":[[70,7,72,8],[76,2,79,6],[69,2,71,6],[74,2,74,8],[87,7,87,8],[113,15,113,16],[108,12,109,13],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[81,2,83,6],[85,2,85,7],[82,7,84,8],[77,7,79,8],[115,12,115,18],[87,5,87,6],[100,2,100,4],[100,5,100,6],[102,2,103,4],[105,2,106,3],[108,2,109,3],[89,2,90,4],[93,4,93,5],[93,6,93,8],[99,4,99,5],[98,4,98,5],[97,4,97,5],[96,4,96,5],[95,4,95,5],[95,6,95,8],[96,6,96,8],[97,6,97,8],[98,6,98,8],[87,2,87,4],[99,6,99,8],[123,2,123,5],[124,2,124,5],[123,6,123,7],[124,6,124,7],[108,5,108,6],[109,5,109,6],[110,5,110,6],[111,5,111,6],[112,5,112,6],[118,1,118,4],[118,5,118,7],[119,5,119,7],[113,5,113,6],[42,12,42,14],[42,15,42,16],[42,17,42,18],[49,12,49,14],[43,12,43,14],[43,15,43,16],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[40,12,40,14],[40,15,40,16],[40,17,40,18],[41,12,41,14],[41,15,41,16],[41,17,41,18],[38,12,38,14],[38,15,38,16],[38,17,38,18],[37,7,37,8],[37,2,37,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[40,7,40,8],[40,2,40,4],[51,15,51,16],[51,17,51,18],[50,12,50,14],[51,12,51,14],[43,7,43,8],[46,7,46,8],[49,7,49,8],[50,7,50,8],[50,15,50,16],[50,17,50,18],[46,12,46,14],[46,15,46,16],[46,17,46,18],[47,12,47,14],[49,15,49,16],[49,17,49,18],[51,7,51,8],[43,17,43,18],[44,12,44,14],[44,15,44,16],[44,17,44,18],[45,12,45,14],[45,15,45,16],[45,17,45,18],[47,2,47,4],[52,7,52,8],[52,15,52,16],[52,17,52,18],[52,12,52,14],[44,7,44,8],[49,5,49,6],[46,5,46,6],[50,5,50,6],[51,5,51,6],[52,5,52,6],[51,2,51,4],[52,2,52,4],[46,2,46,4],[49,2,49,4],[50,2,50,4],[53,15,53,16],[53,17,53,18],[64,2,68,6],[56,12,56,14],[55,12,55,14],[55,17,55,18],[53,12,53,14],[53,7,53,8],[56,2,56,4],[55,7,55,8],[65,7,67,8],[53,5,53,6],[53,2,53,4],[55,2,55,4],[61,2,61,5],[39,17,39,18],[32,17,32,18],[33,12,33,14],[33,15,33,16],[33,17,33,18],[34,12,34,14],[34,15,34,16],[34,17,34,18],[35,15,35,16],[35,17,35,18],[36,17,36,18],[37,12,37,14],[37,15,37,16],[37,17,37,18],[35,12,35,14],[39,12,39,14],[39,15,39,16],[29,17,29,18],[31,12,31,14],[31,15,31,16],[31,17,31,18],[3,16,3,18],[9,11,9,18],[4,3,4,8],[4,13,4,18],[8,5,8,8],[3,6,3,8],[9,1,9,8],[8,15,8,18],[15,2,15,8],[29,7,29,8],[31,7,31,8],[31,5,31,6],[13,1,13,8],[13,11,13,18],[27,2,27,8],[27,12,27,18],[22,2,22,8],[21,2,21,8],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[32,2,32,4],[32,7,32,8],[29,12,29,14],[29,15,29,16],[32,12,32,14],[32,15,32,16],[36,12,36,14],[36,15,36,16],[34,7,34,8],[35,7,35,8],[36,7,36,8],[0,1,0,9],[42,7,42,8],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[38,2,38,4],[39,2,39,4],[45,2,45,4],[45,7,45,8],[38,7,38,8],[39,7,39,8],[29,2,29,4],[29,5,29,6],[31,2,31,4],[33,7,33,8],[24,2,24,8],[16,2,16,8],[17,2,17,8],[18,2,18,8],[23,2,23,8],[20,2,20,8],[41,7,41,8],[44,2,44,4]]}
[null," Verwaltungsausgaben \n Forstwirtschaftlicher Zusammenschlüsse"]
[]
[]
[null,"  zum Antrag vom",null,null,null,null,null,null,null,null,null,"  zum Verwendungsnachweis vom"]
[null,"  Antragsteller",null,null,null,null,null,null,null,null,null,"  Antragsteller"]
[]
[]
[]
[null,"  Geplante Maßnahmen: ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F9),\" \",F9)","v":" "}]
[]
[]
[null,null,"geplante Verwaltungsausgaben"]
[null,null," nach Nr. 4.1.1 und 4.1.2 der PKW-RL"]
[]
[]
[null,null,"Nr. 4.1.1 PKW-RL: Verwaltungsausgaben für 5 Jahre ab dem ",null,null,null,null,null,null,null,null,null," Durchführung wie geplant",null,null,null,"  (ja = j, nein = n)"]
[null,null,"Tag der Anerkennung oder Satzungsgenehmigung oder nach "]
[null,null,"Zusammenlegung, Fusion oder wesentlicher Erweiterung des ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P16=\"\",\"\",IF(P22=\"\",\"\",\"bitte    j  oder    n    eingeben\"))","v":""}]
[null,null,"Zusammenschlusses"]
[]
[null,null,"Nr. 4.1.2 PKW-RL:  lfd. Geschäftsführungsausgaben, wie zum "]
[null,null,"Beispiel Ausgaben für Rechnungsstellungen, Versicherungen, ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P16=\"j\",\"\",IF(P16=\"n\",\"\",\".\"))","v":"."}]
[null,null,"Steuerberatung und Büroausstattung für Zusammenschlüsse, "]
[null,null,"die eine Zuwendung nach der [RL zur Direkten Förderung für "]
[null,null,"WG oder für FWZ] erhalten."]
[]
[]
[null,null,"Zusammenstellung aller Ausgaben nach Nr. 4.1.1:",null,null,null,null,null,null,null,null,null,"Zusammenstellung aller Ausgaben nach Nr. 4.1.1:"]
[]
[null,null,"Ausgaben",null,null,"fallen an \nim Jahr ...",null,"in Höhe \nvon ... EUR",null,null,null,null,"Ausgaben",null,null,"fallen an \nim Jahr ...",null,"in Höhe \nvon ... EUR"]
[]
[null,null,"1.",null,null,null,null,null,null,null,null,null,{"$f":"IF(C32=\"\",\"\",C32)","v":"1."},null,null,{"$f":"IF(F32=\"\",\"\",F32)","v":""},null,{"$f":"IF($P$16=\"J\",H32,0)","v":0}]
[null,null,"2.",null,null,null,null,null,null,null,null,null,{"$f":"IF(C33=\"\",\"\",C33)","v":"2."},null,null,{"$f":"IF(F33=\"\",\"\",F33)","v":""},null,0]
[null,null,"3.",null,null,null,null,null,null,null,null,null,"3.",null,null,"",null,0]
[null,null,"4.",null,null,null,null,null,null,null,null,null,"4.",null,null,"",null,0]
[null,null,"5.",null,null,null,null,null,null,null,null,null,"5.",null,null,"",null,0]
[null,null,"6.",null,null,null,null,null,null,null,null,null,"6.",null,null,"",null,0]
[null,null,"7.",null,null,null,null,null,null,null,null,null,"7.",null,null,"",null,0]
[null,null,"8.",null,null,null,null,null,null,null,null,null,"8.",null,null,"",null,0]
[null,null,"9.",null,null,null,null,null,null,null,null,null,"9.",null,null,"",null,0]
[null,null,"10.",null,null,null,null,null,null,null,null,null,"10.",null,null,"",null,0]
[null,null,"11.",null,null,null,null,null,null,null,null,null,"11.",null,null,"",null,0]
[null,null,"12.",null,null,null,null,null,null,null,null,null,"12.",null,null,"",null,0]
[null,null,"13.",null,null,null,null,null,null,null,null,null,"13.",null,null,"",null,0]
[null,null,"14.",null,null,null,null,null,null,null,null,null,"14.",null,null,"",null,0]
[null,null,"15.",null,null,null,null,null,null,null,null,null,"15.",null,null,"",null,0]
[null,null,"16.",null,null,null,null,null,null,null,null,null,"16.",null,null,"",null,0]
[]
[]
[null,null,"Fördersatz beträgt 60 % im 1. Jahr",null,null,2024,null,{"$f":"SUMIF(F$32:G$47,F50,H$32:I$47)","v":0},null,null,null,null,"Fördersatz beträgt 60 % im 1. Jahr =",null,null,2024,null,{"$f":"SUMIF(P$32:Q$47,P50,R$32:S$47)","v":0}]
[null,null,"Fördersatz beträgt 60 % im 2. Jahr",null,null,{"$f":"F50+1","v":2025},null,{"$f":"SUMIF(F$32:G$47,F51,H$32:I$47)","v":0},null,null,null,null,"Fördersatz beträgt 60 % im 2. Jahr =",null,null,{"$f":"P50+1","v":2025},null,{"$f":"SUMIF(P$32:Q$47,P51,R$32:S$47)","v":0}]
[null,null,"Fördersatz beträgt 50 % im 3. Jahr",null,null,{"$f":"F51+1","v":2026},null,0,null,null,null,null,"Fördersatz beträgt 50 % im 3. Jahr =",null,null,{"$f":"P51+1","v":2026},null,0]
[null,null,"Fördersatz beträgt 50 % im 4. Jahr",null,null,2027,null,0,null,null,null,null,"Fördersatz beträgt 50 % im 4. Jahr =",null,null,2027,null,0]
[null,null,"Fördersatz beträgt 40 % im 5. Jahr",null,null,2028,null,0,null,null,null,null,"Fördersatz beträgt 40 % im 5. Jahr =",null,null,2028,null,0]
[]
[null,null,"Förderung beträgt",null,null,null,null,{"$f":"IF(SUM(H32:I47)=0,\"\",\n  MIN(40000,0.6*H50)\n+MIN(40000,0.6*H51)\n+MIN(40000,0.5*H52)\n+MIN(40000,0.5*H53)\n+MIN(40000,0.4*H54))","v":""},null,null,null,null,"Förderung beträgt",null,null,null,null,{"$f":"IF(SUM(R32:S47)=0,\"\",\n  MIN(40000,0.6*R50)\n+MIN(40000,0.6*R51)\n+MIN(40000,0.5*R52)\n+MIN(40000,0.5*R53)\n+MIN(40000,0.4*R54))","v":""}]
[null,null,"höchstens = 40.000 EUR je Jahr",null,null,null,null,null,null,null,null,null,"höchstens = 40.000 EUR je Jahr"]
[]
[]
[]
[]
[null,null,"Ausgaben nach Nr. 4.1.2:",null,null,null,null,"bitte eingeben"]
[null,null,null,null,null,null,null,"J / N"]
[]
[null,null,"a) Eigenständige Geschäftsführung durch den Zusammenschluss oder einen Dritten ohne Bündelung der Geschäftsführung -\n2,50 EUR je Jahr und ha"]
[null,null,null,null,null,null,null,{"$f":"IF(H65=\"\",\"\",\nIF(H65=\"J\",\"\",\"falls Auswahl, bitte    j  eingeben\"))","v":""}]
[]
[]
[]
[null,null,"b) Geschäftsführung durch einen Dritten mit Bündelung der Geschäftsführung - \n3,50 EUR je Jahr und ha"]
[null,null,null,null,null,null,null,{"$f":"IF(H70=\"\",\"\",\nIF(H70=\"J\",\"\",\"falls Auswahl, bitte    j  eingeben\"))","v":""}]
[]
[]
[]
[null,null,"für Waldgenossenschaften als eigenständige Zuwendungsempfänger in der Direkten Förderung:"]
[]
[null,null,"a) Eigenständige Geschäftsführung durch den Zusammenschluss oder einen Dritten ohne Bündelung der Geschäftsführung - \n3,00 EUR je Jahr und ha"]
[null,null,null,null,null,null,null,{"$f":"IF(H77=\"\",\"\",\nIF(H77=\"J\",\"\",\"falls Auswahl, bitte    j  eingeben\"))","v":""}]
[]
[]
[]
[null,null,"b) Geschäftsführung durch einen Dritten mit Bündelung der Geschäftsführung - \n4,00 EUR je Jahr und ha"]
[null,null,null,null,null,null,null,{"$f":"IF(H82=\"\",\"\",\nIF(H82=\"J\",\"\",\"falls Auswahl, bitte    j  eingeben\"))","v":""}]
[]
[]
[null,null,{"$f":"IF(COUNTIF(H65:I82,\"x\")>1,\"bitte nur eines der vier Felder ankreuzen!\",\"\")","v":""}]
[]
[null,null,"für eine Fläche von ……",null,null,null,null,"  Hektar"]
[]
[null,null,"Ende der Bewilligung zur Direkten Förderung",null,null,"Tag","Monat","Jahr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"was ist, wenn Bewilligung nicht bis zum Monatsende läuft?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kommt der Fall jemals vor? Wenn ja, müssen Monatsbruchteile her..."]
[]
[null,null,null,null,"entspricht in Monaten je Jahr:",null,"Beantragte Förderung ja Jahr in  EUR:"]
[]
[null,null,2023,null,{"$f":"IF(2023=C96,F$120*12/365,\nIF(H$91<C96,0,\nIF(H$91=C96,G$91,\nIF(H$91>C96,12,\"Fehler\"))))","v":1501.0520547945205},null,{"$f":"IF(H$65=\"x\",2.5*F$88*E96/12,\n  IF(H$70=\"x\",3.5*F$88*E96/12,\n  IF(H$77=\"x\",3*F$88*E96/12,\n  IF(H$82=\"x\",4*F$88*E96/12,0))))","v":0}]
[null,null,2024,null,{"$f":"IF(2023=C97,F$120*12/365,\nIF(H$91<C97,0,\nIF(H$91=C97,G$91,\nIF(H$91>C97,12,\"Fehler\"))))","v":0},null,{"$f":"IF(H$65=\"x\",2.5*F$88*E97/12,\n  IF(H$70=\"x\",3.5*F$88*E97/12,\n  IF(H$77=\"x\",3*F$88*E97/12,\n  IF(H$82=\"x\",4*F$88*E97/12,0))))","v":0}]
[null,null,2025,null,{"$f":"IF(2023=C98,F$120*12/365,\nIF(H$91<C98,0,\nIF(H$91=C98,G$91,\nIF(H$91>C98,12,\"Fehler\"))))","v":0},null,{"$f":"IF(H$65=\"x\",2.5*F$88*E98/12,\n  IF(H$70=\"x\",3.5*F$88*E98/12,\n  IF(H$77=\"x\",3*F$88*E98/12,\n  IF(H$82=\"x\",4*F$88*E98/12,0))))","v":0}]
[null,null,2026,null,{"$f":"IF(2023=C99,F$120*12/365,\nIF(H$91<C99,0,\nIF(H$91=C99,G$91,\nIF(H$91>C99,12,\"Fehler\"))))","v":0},null,{"$f":"IF(H$65=\"x\",2.5*F$88*E99/12,\n  IF(H$70=\"x\",3.5*F$88*E99/12,\n  IF(H$77=\"x\",3*F$88*E99/12,\n  IF(H$82=\"x\",4*F$88*E99/12,0))))","v":0}]
[null,null,2027,null,{"$f":"IF(2023=C100,F$120*12/365,\nIF(H$91<C100,0,\nIF(H$91=C100,G$91,\nIF(H$91>C100,12,\"Fehler\"))))","v":0},null,{"$f":"IF(H$65=\"x\",2.5*F$88*E100,\n  IF(H$70=\"x\",3.5*F$88*E100,\n  IF(H$77=\"x\",3*F$88*E100,\n  IF(H$82=\"x\",4*F$88*E100,0))))","v":0}]
[null,null,"für eine Fläche von ……",null,null,null,null,"   Hektar"]
[]
[null,null,"Endes der Bewilligung zur Direkten Förderung",null,null,"Tag","Monat","Jahr"]
[]
[]
[null,null,"entspricht in Monaten je Jahr:\n(Monate eingeben)",null,2024,2025,2026,2027,2028]
[]
[]
[null,null,"Beantragte Förderung ja Jahr:",null,2024,{"$f":"IF(H65=\"j\",2.5*F101*G125/365,\nIF(H70=\"j\",F101*3.5/365*G125,\nIF(H77=\"j\",F101*3/365*G125,\nIF(H82=\"j\",F101*4/365*G125,0))))","v":0},null,"EUR",null,null,null,null,"Beantragte Förderung ja Jahr:",null,2024,{"$f":"IF($P$16=\"J\",F109,0)","v":0},null,"EUR",null,null,"   Zeilen 109, 119, 124: zu Neujahr ändern"]
[null,null,null,null,2025,{"$f":"IF($H$65=\"j\",F107*2.5*$F$101/12,IF($H$70=\"j\",F107*3.5*$F$101/12,IF($H$77=\"j\",F107*3*$F$101/12,IF($H$82=\"j\",F107*4*$F$101/12,0))))","v":0},null,"EUR",null,null,null,null,null,null,2025,{"$f":"IF($P$16=\"J\",F110,0)","v":0},null,"EUR"]
[null,null,null,null,2026,{"$f":"IF($H$65=\"j\",G107*2.5*$F$101/12,IF($H$70=\"j\",G107*3.5*$F$101/12,IF($H$77=\"j\",G107*3*$F$101/12,IF($H$82=\"j\",G107*4*$F$101/12,0))))","v":0},null,"EUR",null,null,null,null,null,null,2026,0,null,"EUR"]
[null,null,null,null,2027,{"$f":"IF($H$65=\"j\",H107*2.5*$F$101/12,IF($H$70=\"j\",H107*3.5*$F$101/12,IF($H$77=\"j\",H107*3*$F$101/12,IF($H$82=\"j\",H107*4*$F$101/12,0))))","v":0},null,"EUR",null,null,null,null,null,null,2027,0,null,"EUR"]
[null,null,null,null,2028,{"$f":"IF($H$65=\"j\",I107*2.5*$F$101/12,IF($H$70=\"j\",I107*3.5*$F$101/12,IF($H$77=\"j\",I107*3*$F$101/12,IF($H$82=\"j\",I107*4*$F$101/12,0))))","v":0},null,"EUR",null,null,null,null,null,null,2028,0,null,"EUR"]
[null,null,null,null,"gesamt:",{"$f":"SUM(F109:G113)","v":0},null,"EUR",null,null,null,null,null,null,"gesamt:",{"$f":"SUM(P109:Q113)","v":0},null,"EUR"]
[]
[]
[]
[]
[null,"Erforderlich zur Berechnung der Tage des ersten Jahres",null,null,null,"2024-12-31"]
[null,null,null,null,"in Tagen",{"$f":"F119-G4","v":45657}]
[]
[]
[]
[null,null,"Erforderlich zur Berechnung der Tage des ersten Jahres",null,null,null,"2024-12-31"]
[null,null,"in Tagen",null,null,null,{"$f":"G124-G4","v":45657}]