{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["I 1","I 2","I 3","I 4","I 5","GV-Berechnung","Belegliste","Zwischennachweis","Ausgabengliederung","Einnahmen-Ausgaben","Schlussverwendung","Evaluierung","Notizblatt","Darlehen","DB"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":548,"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":"I 1","index":0,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,8,2,9],[3,8,3,9],[4,8,4,9],[19,7,19,10],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[11,7,11,8],[10,7,10,8],[18,7,18,8],[5,9,5,10],[7,7,7,9],[9,7,9,8],[12,7,12,8],[17,7,17,8],[54,1,55,2],[8,1,9,2],[52,1,52,5],[53,1,53,4],[54,7,60,10],[2,2,2,4],[3,2,3,4],[4,2,4,4],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,3,5,4],[54,5,54,6],[19,4,19,5],[5,5,5,6],[54,3,54,4]]}
["Rheinland-Pfalz                                Investitionskonzept",null,null,null,null,null,null,null,null,null,"I 1"]
[null,null,null,"Allgemeine Angaben/Betriebsspiegel"]
[1,"Antragsteller",null,null,null,"Bewilligungsstelle",null,null,"Buchstelle"]
[{"$f":"A3+1","v":2},"Straße",null,null,null,"Unternehmensberater",null,null,"Testbetriebsnummer"]
[3,"PLZ/Ort",null,null,null,"Antragsdatum",null,null,"Antragsnummer "]
[4,"BNRZD","276",null,null,"Weinbaukarteinummer",null,null,"Agrarzone","Normales Gebiet"]
[5,"Junglandwirt - persönliche Angaben:",null,null,"Datum Hofübernahme:",null,null,"   Alter (Hofübergeber):"]
[6,"Alter:",null,"Geschlecht:",null,null,"Ausbildung:"]
[7,"Betriebsflächen (ha)",null,"IST (t)",null,"ZIEL (t + x)",{"$f":"IF(E9=0,,+E9+(2*365)+1)","v":"00:00:00"},"Lieferrechte",null,"IST","ZIEL"]
[8,null,null," Eigentum","Bewirtsch."," Eigentum","Bewirtsch.","Milchref.menge",null,null,{"$f":"+J10","v":0}]
[9,"Ackerfläche",null,null,null,{"$f":"+D11","v":0},0,"davon gepachtet",null,null,{"$f":"+J11","v":0}]
[10,"Dauergrünland",null,null,null,0,0,null,null,null,0]
[11,"Gewächshausfläche",null,null,null,0,0,null,null,null,0]
[12,"weinbaul. gen. Fläche",null,null,null,0,0,null,null,null,0]
[13,"sonstige LF",null,null,null,0,0,null,null,null,0]
[14,"ldw. gen. Fläche (LF)",null,{"$f":"SUM(D11:D15)","v":0},{"$f":"SUM(E11:E15)","v":0},{"$f":"SUM(F11:F15)","v":0},{"$f":"SUM(G11:G15)","v":0},null,null,null,0]
[15,"forstw. Nutzfläche",null,null,null,{"$f":"+D17","v":0},{"$f":"+E17","v":0},null,null,null,0]
[16,"sonstige Betriebsflächen",null,null,null,{"$f":"+D18","v":0},{"$f":"+E18","v":0},null,null,null,0]
[17,"Betriebsfläche",null,{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},{"$f":"SUM(G16:G18)","v":0},null,null,null,0,"Hilfsspalte zur Veränderung der Produktionsverfahen"]
[18,"Produktion und Arbeitsbedarf",null,null,"IST",{"$f":"CONCATENATE(\"IST (t) \", A20)","v":"IST (t) 18"},null,"ZIEL",{"$f":"CONCATENATE(\"ZIEL (t) \", E20)","v":"ZIEL (t) IST"},{"$f":"CONCATENATE(\"ZIEL (t) \", F20)","v":"ZIEL (t) IST (t) 18"},{"$f":"CONCATENATE(\"ZIEL (t) \", G20)","v":"ZIEL (t) "},"Veränderung des Umlaufvermögen s für pflanzliche Produktionsverfahren"]
[19,"Wein-, Obst-,\nGarten-, Ackerbau (ha)","KTBL-Seite","Umfang","Ertrags-/Leistungs-niveau","AKh/\nEinheit","AKh","Umfang","Ertrags-/Leistungs-niveau","AKh/\nEinheit","AKh"," +/- Einheit","je Einheit in EUR","gesamt"]
[20,null,null,null,null,null,{"$f":"+D22*F22","v":0},{"$f":"+D22","v":0},{"$f":"+E22","v":0},{"$f":"+F22","v":0},{"$f":"+H22*J22","v":0},{"$f":"IF('I 1'!D22>'I 1'!H22,'I 1'!H22-'I 1'!D22,IF('I 1'!D22<'I 1'!H22,'I 1'!H22-'I 1'!D22,))","v":0},null,{"$f":"IF(M22>0,+L22*M22,\"\")","v":""}]
[21,null,null,null,null,null,{"$f":"+D23*F23","v":0},{"$f":"+D23","v":0},0,0,{"$f":"+H23*J23","v":0},{"$f":"IF('I 1'!D23>'I 1'!H23,'I 1'!H23-'I 1'!D23,IF('I 1'!D23<'I 1'!H23,'I 1'!H23-'I 1'!D23,))","v":0},null,{"$f":"IF(M23>0,+L23*M23,\"\")","v":""}]
[22,null,null,null,null,null,0,{"$f":"+D24","v":0},0,0,0,{"$f":"IF('I 1'!D24>'I 1'!H24,'I 1'!H24-'I 1'!D24,IF('I 1'!D24<'I 1'!H24,'I 1'!H24-'I 1'!D24,))","v":0},null,""]
[23,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D25>'I 1'!H25,'I 1'!H25-'I 1'!D25,IF('I 1'!D25<'I 1'!H25,'I 1'!H25-'I 1'!D25,))","v":0},null,""]
[24,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D26>'I 1'!H26,'I 1'!H26-'I 1'!D26,IF('I 1'!D26<'I 1'!H26,'I 1'!H26-'I 1'!D26,))","v":0},null,""]
[25,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D27>'I 1'!H27,'I 1'!H27-'I 1'!D27,IF('I 1'!D27<'I 1'!H27,'I 1'!H27-'I 1'!D27,))","v":0},null,""]
[26,null,null,null,null,null,{"$f":"+D28*F28","v":0},0,0,0,{"$f":"+H28*J28","v":0},{"$f":"IF('I 1'!D28>'I 1'!H28,'I 1'!H28-'I 1'!D28,IF('I 1'!D28<'I 1'!H28,'I 1'!H28-'I 1'!D28,))","v":0},null,""]
[27,null,null,null,null,null,{"$f":"+D29*F29","v":0},0,0,0,{"$f":"+H29*J29","v":0},{"$f":"IF('I 1'!D29>'I 1'!H29,'I 1'!H29-'I 1'!D29,IF('I 1'!D29<'I 1'!H29,'I 1'!H29-'I 1'!D29,))","v":0},null,""]
[28,null,null,null,null,null,0,{"$f":"+D30","v":0},0,0,0,{"$f":"IF('I 1'!D30>'I 1'!H30,'I 1'!H30-'I 1'!D30,IF('I 1'!D30<'I 1'!H30,'I 1'!H30-'I 1'!D30,))","v":0},null,""]
[29,"Ackerfutter und Grünland (ha)"]
[30,null,null,null,null,null,0,{"$f":"+D32","v":0},{"$f":"+E32","v":0},0,0,{"$f":"IF('I 1'!D32>'I 1'!H32,'I 1'!H32-'I 1'!D32,IF('I 1'!D32<'I 1'!H32,'I 1'!H32-'I 1'!D32,))","v":0},null,""]
[31,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D33>'I 1'!H33,'I 1'!H33-'I 1'!D33,IF('I 1'!D33<'I 1'!H33,'I 1'!H33-'I 1'!D33,))","v":0},null,""]
[32,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D34>'I 1'!H34,'I 1'!H34-'I 1'!D34,IF('I 1'!D34<'I 1'!H34,'I 1'!H34-'I 1'!D34,))","v":0},null,""]
[33,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D35>'I 1'!H35,'I 1'!H35-'I 1'!D35,IF('I 1'!D35<'I 1'!H35,'I 1'!H35-'I 1'!D35,))","v":0},null,""]
[34,null,null,null,null,null,0,{"$f":"+D36","v":0},0,0,0,{"$f":"IF('I 1'!D36>'I 1'!H36,'I 1'!H36-'I 1'!D36,IF('I 1'!D36<'I 1'!H36,'I 1'!H36-'I 1'!D36,))","v":0},null,""]
[35,"Tierhaltung (Jahresdurchschnittsbestand bzw. Jahreserzeugung)",null,null,null,null,null,null,null,null,null,"Veränderung  Pflanzenbau insgesamt",null,{"$f":"SUM(N22:N36)","v":0}]
[36,null,null,null,null,null,0,{"$f":"+D38","v":0},{"$f":"+E38","v":0},0,0,{"$f":"IF('I 1'!D38>'I 1'!H38,'I 1'!H38-'I 1'!D38,IF('I 1'!D38<'I 1'!H38,'I 1'!H38-'I 1'!D38,))","v":0},null,""]
[37,null,null,null,null,null,0,{"$f":"+D39","v":0},0,0,0,{"$f":"IF('I 1'!D39>'I 1'!H39,'I 1'!H39-'I 1'!D39,IF('I 1'!D39<'I 1'!H39,'I 1'!H39-'I 1'!D39,))","v":0},null,""]
[38,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D40>'I 1'!H40,'I 1'!H40-'I 1'!D40,IF('I 1'!D40<'I 1'!H40,'I 1'!H40-'I 1'!D40,))","v":0},null,""]
[39,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D41>'I 1'!H41,'I 1'!H41-'I 1'!D41,IF('I 1'!D41<'I 1'!H41,'I 1'!H41-'I 1'!D41,))","v":0},null,""]
[40,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D42>'I 1'!H42,'I 1'!H42-'I 1'!D42,IF('I 1'!D42<'I 1'!H42,'I 1'!H42-'I 1'!D42,))","v":0},null,""]
[41,null,null,null,null,null,0,0,0,0,0,{"$f":"IF('I 1'!D43>'I 1'!H43,'I 1'!H43-'I 1'!D43,IF('I 1'!D43<'I 1'!H43,'I 1'!H43-'I 1'!D43,))","v":0},null,""]
[42,"Handel, Dienstleistung, Sonstiges (z.B. UaBW in Belegtagen, Wein und Sekt in 1000 l)",null,null,null,null,null,null,null,null,null,"Veränderung  Tierhaltung insgesamt",null,{"$f":"SUM(N38:N43)","v":0}]
[43,null,null,null,null,null,0,{"$f":"+D45","v":0},{"$f":"+E45","v":0},0,0]
[44,null,null,null,null,null,{"$f":"+D46*F46","v":0},0,0,0,{"$f":"+H46*J46","v":0}]
[45,null,null,null,null,null,{"$f":"+D47*F47","v":0},0,0,0,{"$f":"+H47*J47","v":0}]
[46,null,null,null,null,null,0,0,0,0,0]
[47,null,null,null,null,null,0,0,0,0,0]
[48,null,null,null,null,null,0,0,0,0,0]
[49,"nicht zuteilbare Arbeiten "]
[50,"für Betriebsleitung",null,{"$f":"+E16","v":0},null,null,{"$f":"IF(D52>0,D52*F52,F52)","v":0},{"$f":"+G16","v":0},null,{"$f":"+F52","v":0},{"$f":"IF(H52>0,H52*J52,J52)","v":0}]
[51,"Arbeitszeitbedarf insgesamt",null,null,null,null,{"$f":"SUM(G22:G52)","v":0},null,null,null,{"$f":"SUM(K22:K52)","v":0}]
[52,"betriebsnotwendige Arbeitskräfteeinheiten (AK)",null,null,null,2100,{"$f":"ROUNDDOWN(G53/F54,1)","v":0},null,null,null,{"$f":"ROUNDDOWN(K53/F54,1)","v":0}]
[53,"Arbeitskräfte",null,"IST",null,"ZIEL",null,{"$f":"+J56+J58","v":0}]
[54,null,null,"Personen","Stun./ Jahr","Personen","Stun./ Jahr"]
[55,"nicht entlohnte Familien-Arb.kr."]
[56,"entlohnte Familien-Arb.kr."]
[57,"Fremd-Arbeitskräfte"]
[58,"Summe (Z.55 - 57)",null,{"$f":"SUM(D57:D59)","v":0},{"$f":"SUM(E57:E59)","v":0},{"$f":"SUM(F57:F59)","v":0},{"$f":"SUM(G57:G59)","v":0}]
[59,"Vollverpflegungspersonen",null,null,"-",null,"-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Agrarberuf",null,"Bernkastel-Kues",null,"Normales Gebiet"]
["Fachschule",null,"Mayen",null,"Benachteiligtes Gebiet"]
["Meister/Techniker",null,"Neustadt  a.d.W.",null,"Kleine Gebiete"]
["FH/Hochschule",null,null,null,"Natura 2000 - Gebiet"]
["gleichwertige agrar. Qualifik."]
["keine gleichwertige agrar. Qualif."]

{"sheet":"I 2","index":1,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[[66,3,66,5],[53,1,53,3],[52,1,52,3],[58,1,62,1],[54,1,54,3],[62,2,62,3],[58,2,58,3],[59,2,59,3],[50,2,50,3],[60,2,60,3],[61,2,61,3],[57,1,57,3],[55,1,55,3],[56,1,56,3],[51,1,51,3],[47,2,47,3],[49,2,49,3],[48,1,48,3],[2,7,2,10],[44,2,44,3],[6,1,16,1],[17,1,26,1],[9,2,9,3],[11,2,11,3],[16,2,16,3],[18,2,18,3],[45,2,45,3],[46,2,46,3],[30,1,30,3],[38,2,38,3],[36,2,36,3],[44,7,45,7],[58,7,62,7],[58,10,62,10],[5,4,5,10],[44,10,45,10],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,9,45,9],[44,8,45,8],[42,2,42,3],[25,2,25,3],[23,2,23,3],[22,2,22,3],[19,2,19,3],[41,2,41,3],[29,2,29,3],[40,2,40,3],[37,2,37,3],[32,2,32,3],[33,1,33,3],[3,0,3,3],[2,0,2,3],[6,2,6,3],[12,2,12,3],[10,2,10,3],[14,2,14,3],[13,2,13,3],[7,2,7,3],[8,2,8,3],[39,2,39,3],[20,2,20,3],[26,2,26,3],[28,2,28,3],[27,2,27,3],[21,2,21,3],[24,2,24,3],[34,2,34,3],[35,2,35,3],[15,2,15,3],[17,2,17,3]]}
["Rheinland-Pfalz                                Investitionskonzept",null,null,null,null,null,null,null,null,null,"I 2"]
[null,null,null,null,"Erfolgsrechnung"]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "}]
[{"$f":"+'I 1'!D6","v":0}]
[1,null,null,null,null,null,null,"Ø Jahre"," + / -","IST","ZIEL"]
[{"$f":"A5+1","v":2},null,null,null,"EUR"]
[3," + Betriebserträge","Umsatzerlöse Pflanzenproduktion 2099",null,null,0,0,{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E7:G7)/3,IF(AND($E$13<>0,$F$13<>0),(E7+F7)/2,IF(AND($F$13<>0,$G$13<>0),(F7+G7)/2,IF(AND($E$13<>0,$G$13<>0),(E7+G7)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F7,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E7,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G7,)))))))","v":0},0,{"$f":"+H7+I7","v":0}]
[4,null,"davon",null,0,0,0,0,0,{"$f":"+H8+I8","v":0}]
[5,null,"Umsatzerlöse Tierproduktion 2199",null,null,0,0,0,0,0]
[6,null,"davon",null,null,0,0,0,0,0]
[7,null,"Diversifizierung 2337",null,0,0,0,0,0,0]
[8,null,"davon",null,0,0,0,0,0,0]
[9,null,"Umsatzerlöse insgesamt 2339",null,null,0,null,0,0,0]
[10,null,"Bestandsveränderungen 2347, 2348",null,0,0,0,0,0,0]
[11,null,"andere aktivierbare Eigenleistungen 2349",null,0,0,0,0,0,0]
[12,null,"sonstige betriebliche Erträge 2498",null,0,0,0,0,0,0]
[13,null,"davon Zulagen und Zuschüsse 2449",null,0,0,0,0,0,0]
[14," - Betriebsaufwand","Materialaufwand 2789",null,null,0,0,0,0,0]
[15,null,"davon für Tierproduktion 2729",null,null,0,0,0,0,0]
[16,null,"Personalaufwand 2799",null,0,0,0,0,0,0,{"$f":"+J20+'I 5'!J37","v":0}]
[17,null,"Abschreibungen 2809",null,0,0,0,0,0,0,{"$f":"+J21+SUM('I 5'!G46:G52)","v":0}]
[18,null,"davon    immater. Vermögen (planmäßig) 2800 ",null,0,0,0,0,0,0]
[19,null,"  auf Sachanlagen (planmäßig) 2801",null,0,0,0,0,0,0]
[20,null,"sonstige Betriebsaufwendungen 2897",null,0,0,0,0,0,0]
[21,null,"davon              Unterhaltung Wirtsch.-geb. 2813",null,0,0,0,0,0,0,{"$f":"+J25+SUM('I 5'!I46:I52)","v":0}]
[22,null,"Pacht für luf. Flächen 2840",null,0,0,0,0,0,0]
[23,null,"Pacht für Lieferrechte 2842",null,0,0,0,0,0,0]
[24,"=","Betriebsergebnis 2899",null,{"$f":"(SUM(E13+E14+E15+E16))-E18-E20-E21-E24","v":0},{"$f":"(SUM(F13+F14+F15+F16))-F18-F20-F21-F24","v":0},{"$f":"(SUM(G13+G14+G15+G16))-G18-G20-G21-G24","v":0},0,null,{"$f":"(SUM(J13+J14+J15+J16))-J18-J20-J21-J24","v":0}]
[25,"+","Finanzergebnis 2918",null,null,0,0,0,0,{"$f":"H29-I30+I29","v":0}]
[26,"-","davon          Zinsen u. ähnliche Aufwend. 2914",null,null,0,0,0,{"$f":"IF('I 2'!J30<>'I 2'!H30,+J30-H30,)","v":0},{"$f":"IF(E6=\"EUR\",'I 4'!K61,'I 4'!K61*1.95583)","v":0},{"$f":"'I 4'!N61","v":0}]
[27," = Ergebnis der gewöhnl. Gesch.tätigk. 2919",null,null,{"$f":"E28+E29","v":0},{"$f":"F28+F29","v":0},{"$f":"G28+G29","v":0},0,null,{"$f":"+J28+J29","v":0}]
[28," +","außerordentliches Ergebnis 2929",null,null,0,0,0,0,0]
[29,"-","Steuern 2939, 2949",null,null,0,0,0,0,0]
[30," = Ergebnis (Gew./Verl.; Jahrü./Jahrv.) 2959",null,null,{"$f":"E31+E32-E33","v":0},{"$f":"F31+F32-F33","v":0},{"$f":"G31+G32-G33","v":0},0,null,{"$f":"J31+J32-J33","v":0}]
[31,"-","zeitraumfremde Erträge 2497",null,null,0,0,{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E35:G35)/3,IF(AND($E$13<>0,$F$13<>0),(E35+F35)/2,IF(AND($F$13<>0,$G$13<>0),(F35+G35)/2,IF(AND($E$13<>0,$G$13<>0),(E35+G35)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F35,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E35,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G35,)))))))","v":0},0,0]
[32,"+","zeitraumfremde Aufwend. 2896",null,0,0,0,{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E36:G36)/3,IF(AND($E$13<>0,$F$13<>0),(E36+F36)/2,IF(AND($F$13<>0,$G$13<>0),(F36+G36)/2,IF(AND($E$13<>0,$G$13<>0),(E36+G36)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F36,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E36,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G36,)))))))","v":0},0,0]
[33,"-","Erträge aus Invest.zul./-zuschuss (2351-2377)",null,null,0,0,0,0,0]
[34,"+","außerplanmäß. Abschreibungen  2800/2802/03",null,null,0,0,0,0,0]
[35,"-","außerordentliches Ergebnis 2929",null,{"$f":"+E32","v":0},{"$f":"+F32","v":0},{"$f":"+G32","v":0},0,{"$f":"+I32","v":0},0]
[36,"+","bei Pers.ges.: Ergebnis Sond.betr.vermögen",null,0,0,0,0,0,0]
[37,"-","bei juristischen Personen: priv. Ertragssteuer",null,0,0,0,0,0,0]
[38,"+","Sonstiges",null,0,0,0,0,0,0]
[39,"=","ordentliches Ergebnis",null,{"$f":"+E34-E35+E36-E37+E38-E39+E40+-E41+E42","v":0},{"$f":"+F34-F35+F36-F37+F38-F39+F40+-F41+F42","v":0},{"$f":"+G34-G35+G36-G37+G38-G39+G40+-G41+G42","v":0},0,null,{"$f":"+J34-J35+J36-J37+J38-J39+J40+-J41+J42","v":0},{"$f":"+'I 5'!J59","v":0}]
[40,"Entnahmen/Ausschüttungen",null,null,null,0,0,0,0,0]
[41,"-","bei Einzelunt. u. Pers.ges.: vorübergehen-",null,null,0,0,{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E45:G45)/3,IF(AND($E$13<>0,$F$13<>0),(E45+F45)/2,IF(AND($F$13<>0,$G$13<>0),(F45+G45)/2,IF(AND($E$13<>0,$G$13<>0),(E45+G45)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F45,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E45,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G45,)))))))","v":0},0,0]
[42,null,"de Überführ. v. Betriebs- in Priv.vermögen"]
[43,"-","sonst. nicht nachhaltige Entnahmen/Ausschütt.",null,0,0,0,{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E47:G47)/3,IF(AND($E$13<>0,$F$13<>0),(E47+F47)/2,IF(AND($F$13<>0,$G$13<>0),(F47+G47)/2,IF(AND($E$13<>0,$G$13<>0),(E47+G47)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F47,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E47,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G47,)))))))","v":0},0,0]
[44,"=","bereinigte Entnahmen/Ausschüttung",null,{"$f":"E44-E45-E47","v":0},{"$f":"F44-F45-F47","v":0},{"$f":"G44-G45-G47","v":0},{"$f":"IF(AND(E48<>0,F48<>0,G48<>0),SUM(E48:G48)/3,IF(OR(E48<>0,F48>0)*OR(E48<>0,G48>0)*OR(F48<>0,G48>0),SUM(E48:G48)/2,IF(F48<>0,+F48,IF(E48<>0,+E48,+G48))))","v":0},null,{"$f":"J44-J45-J47","v":0},{"$f":"+J48","v":0}]
[45,"Einlagen insgesamt",null,null,null,0,0,{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E49:G49)/3,IF(AND($E$13<>0,$F$13<>0),(E49+F49)/2,IF(AND($F$13<>0,$G$13<>0),(F49+G49)/2,IF(AND($E$13<>0,$G$13<>0),(E49+G49)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F49,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E49,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G49,)))))))","v":0},0,0]
[46,"-","nicht nachhaltige Einlagen",null,null,0,0,0,0,0]
[47,"=","bereinigte Einlagen",null,{"$f":"E49-E50","v":0},0,0,0,null,0,{"$f":"+J51","v":0}]
[48,"bereinigte Eigenkapitalbildung",null,null,{"$f":"E43-E48+E51","v":0},0,0,0,null,{"$f":"J43-J48+J51","v":0},0]
[{"$f":"A52+1","v":49},"ber. Eigenkapitalbildung/betr.notw. AK",null,null,{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!E52/'I 1'!$G$54)","v":"   "},{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!F52/'I 1'!$G$54)","v":"   "},{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!G52/'I 1'!$G$54)","v":"   "},0,null,{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!J52/'I 1'!$G$54)","v":"   "},{"$f":"IF('I 1'!$K$54=0,\"   \",'I 2'!K52/'I 1'!$K$54)","v":"   "}]
[{"$f":"A53+1","v":50},"ordentliches Ergebnis/betr.notw. AK",null,null,{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!E43/'I 1'!$G$54)","v":"   "},{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!F43/'I 1'!$G$54)","v":"   "},{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!G43/'I 1'!$G$54)","v":"   "},{"$f":"IF(AND($E$13<>0,$F$13<>0,$G$13<>0),SUM(E54:G54)/3,IF(AND($E$13<>0,$F$13<>0),(E54+F54)/2,IF(AND($F$13<>0,$G$13<>0),(F54+G54)/2,IF(AND($E$13<>0,$G$13<>0),(E54+G54)/2,IF(AND($E$13=0,$F$13<>0,$G$13=0),+F54,IF(AND($E$13<>0,$F$13=0,$G$13=0),+E54,IF(AND($E$13=0,$F$13=0,$G$13<>0),+G54,)))))))","v":0},null,{"$f":"IF('I 1'!$G$54=0,\"   \",'I 2'!J43/'I 1'!$G$54)","v":"   "},{"$f":"IF('I 1'!$K$54=0,\"   \",'I 2'!K43/'I 1'!$K$54)","v":"   "}]
[{"$f":"A54+1","v":51},"langfristige Kapitaldienstgrenze",null,null,{"$f":"E43+E51-E48+E30","v":0},{"$f":"F43+F51-F48+F30","v":0},{"$f":"G43+G51-G48+G30","v":0},0,null,{"$f":"J43+J51-J48+J30","v":0},{"$f":"K43+K51-K48+K30","v":0}]
[52,"Ausschöpf. der lfr. Kap.-dienstgrenze (%)",null,null,null,null,null,null,null,{"$f":"IF(J55=0,\"  \",('I 4'!I62*100)/J55)","v":"  "},{"$f":"IF(K55=0,\"  \",('I 4'!M62*100)/K55)","v":"  "}]
[53,"um Zinsaufw. erweitert. Cash-flow II (c.f.)",null,null,{"$f":"E34+E30+E40+E21+E51-E48","v":0},{"$f":"F34+F30+F40+F21+F51-F48","v":0},{"$f":"G34+G30+G40+G21+G51-G48","v":0},0,null,{"$f":"J34+J30+J40+J21+J51-J48","v":0},{"$f":"K43+K30+K21+K51-K48-J38","v":0}]
[54,"Über-/Unterdeck. c.f. zum tats. Kap.dienst.",null,null,null,null,null,null,null,{"$f":"J57-'I 4'!$I$62","v":0},{"$f":"K57-'I 4'!M62","v":0}]
[55,"Bilanz","Aktiva 1229",null,0,0,null,null,null,{"$f":"+I59+G59","v":0}]
[56,null,"Verbindlichkeiten/Rückst. 1559, 1539",null,0,0,0,null,null,{"$f":"+I60+G60","v":0}]
[57,null,"davon Verb. gegen Kreditinst. 1540",null,0,0,0,null,null,{"$f":"+I61+G61","v":0}]
[58,null,"sonst. Passiva (SoPo, RA) 1529, 1567",null,0,0,0,null,null,{"$f":"+I62+G62","v":0}]
[59,null,"Eigkap./eigkap.ähnl. Pos.1499, 1518/9",null,0,0,null,null,null,{"$f":"+I63+G63","v":0}]

{"sheet":"I 3","index":2,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[50,2,51,2],[43,2,45,2],[49,1,59,1],[57,2,59,2],[54,2,55,2],[52,2,53,2],[46,2,48,2],[43,1,48,1],[41,1,42,1],[41,2,42,2],[15,2,17,2],[29,1,40,1],[29,2,31,2],[35,2,37,2],[32,2,34,2],[12,1,28,1],[21,2,22,2],[12,2,14,2],[18,2,20,2],[23,2,25,2],[2,0,2,4],[5,5,5,9],[10,1,10,4],[2,7,2,9],[6,5,6,9],[7,5,7,9],[8,5,8,9],[3,0,3,5]]}
["Rheinland-Pfalz                                Investitionskonzept",null,null,null,null,null,null,null,null,"I 3"]
[null,null,null,null,"Schwerpunkte und Ziele/Investitionen/Finanzierungsbedarf",null,null,null,null,null,null,"10,7"]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "},null,null,null,null,null,null,null,null,null,1000000,19]
[{"$f":"+'I 1'!D6","v":0},null,null,null,null,null,null,null,null,null,3000000,7]
[1,"Schwerpunkte und Ziele:",null,null,null,null,null,null,null,null,0]
[2,null,"überwiegende Investitionsart:",null,null,null,null,null,null,null,"Rinderställe","Milcherzeugung","Einkommensverbess. durch Rationali. ohne Produktionskapazitätenausweitung"]
[3,null,"überwiegende Investitionsrichtung:",null,null,null,null,null,null,null,"Schweinställe","Rindfleischerzeugung","Einkommensverbess. durch Rationali. mit Produktionskapazitätenausweitung"]
[4,null,"überwiegendes Investitionsziel:",null,null,null,null,null,null,null,"sonstige Stallbauten","Schweinehaltung","Einkommensverbesserung durch Diversifikation"]
[{"$f":"A8+1","v":5},null,"(bis zu zwei Angaben möglich)",null,null,null,null,null,null,null,"Gewächshäuser und dazugehörige Anlagen","Eier und Geflügelhaltung","Verbesserung der Arbeitsbedingungen"]
[6,"Investitionen - Finanzierungsbedarf - Bemessungsgrundlage",null,null,null,null,null,null,null,null,"sonstige landwirtschaftliche Gebäude","Gartenbau","Verbesserung der Umwelt"]
[7,"Einzelbereiche der Investition",null,null,null,"Investitions-volumen\nbrutto","Umsatz-(pauschalierend), Grunderwerbs-steuer","Investitions-\nvolumen\nförderfähig\n(FIV)","bare\nEigenleistung","Bemessungs-grundlage","Geräte, mobile Betriebsmittel","Wärmedämmung und Regeltechnik","Verbesserung des Tierschutzes"]
[8,null,null,null,null,"EUR","EUR","EUR","EUR","EUR","Einrichtung zur Herstellung und zum Direktverkauf von Agrarerzeugnissen","Biomasseanlagen"]
[9,"AFP","bauliche Anlagen\nPremiumförderung",null,null,null,{"$f":"ROUNDUP(F13*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"+F13-G13","v":0},null,null,"Urlaub auf dem Bauern- und Winzernhof","sonstige Energieeinsparung/-umstellung"]
[10,null,null,"bar",null,null,{"$f":"ROUNDUP(F14*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F14-G14","v":0},{"$f":"H14*K5/100","v":0},{"$f":"TRUNC(IF(AND(H14>0,OR($H$14>0,$H$17>0,$H$20>0,$H$22>0,$H$25>0),$H$14+$H$17+$H$20+$H$22+$H$25>=AFP_Inv_max),(ROUND((H14/($H$14+$H$17+$H$20+$H$22+$H$25))*AFP_Inv_max,)),IF(H14>=AFP_Inv_max,AFP_Inv_max,H14-I14)))","v":0},"übrige Bereiche der Einkommenskombination","UABW, Freizeit und Erholung"]
[11,null,null,"unbar",null,null,null,null,null,null,null,"Direktvermarktung"]
[12,null,"bauliche Anlagen\nPremium + Stroh"]
[13,null,null,"bar",null,null,{"$f":"ROUNDUP(F17*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F17-G17","v":0},{"$f":"H17*K5/100","v":0},{"$f":"TRUNC(IF(AND(H17>0,OR($H$14>0,$H$17>0,$H$20>0,$H$22>0,$H$25>0),$H$14+$H$17+$H$20+$H$22+$H$25>=AFP_Inv_max),(ROUND((H17/($H$14+$H$17+$H$20+$H$22+$H$25))*AFP_Inv_max,)),IF(H17>=AFP_Inv_max,AFP_Inv_max,H17-I17)))","v":0}]
[14,null,null,"unbar"]
[15,null,"bauliche Anlagen\nBasisförderung",null,null,null,null,null,null,null,null,"übrige Einkommenskombination"]
[16,null,null,"bar",null,null,{"$f":"ROUNDUP(F20*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F20-G20","v":0},{"$f":"H20*K5/100","v":0},{"$f":"TRUNC(IF(AND(H20>0,OR($H$14>0,$H$17>0,$H$20>0,$H$22>0,$H$25>0),$H$14+$H$17+$H$20+$H$22+$H$25>=AFP_Inv_max),(ROUND((H20/($H$14+$H$17+$H$20+$H$22+$H$25))*AFP_Inv_max,)),IF(H20>=AFP_Inv_max,AFP_Inv_max,H20-I20)))","v":0},null,"Weinbau "]
[17,null,null,"unbar",null,null,null,null,null,null,null,"Sonstiges"]
[18,null,"öffentliche\nErschließung","bar",null,null,{"$f":"ROUNDUP(F22*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F22-G22","v":0},{"$f":"H22*K5/100","v":0},{"$f":"TRUNC(IF(AND(H22>0,OR($H$14>0,$H$17>0,$H$20>0,$H$22>0,$H$25>0),$H$14+$H$17+$H$20+$H$22+$H$25>=AFP_Inv_max),(ROUND((H22/($H$14+$H$17+$H$20+$H$22+$H$25))*AFP_Inv_max,)),IF(H22>=AFP_Inv_max,AFP_Inv_max,H22-I22)))","v":0}]
[19,null,null,"unbar"]
[20,null,"Maschinen, technische Anlagen"]
[21,null,null,"bar",null,null,{"$f":"ROUNDUP(F25*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"+F25-G25","v":0},{"$f":"H25*K5/100","v":0},{"$f":"TRUNC(IF(AND(H25>0,OR($H$14>0,$H$17>0,$H$20>0,$H$22>0,$H$25>0),$H$14+$H$17+$H$20+$H$22+$H$25>=AFP_Inv_max),(ROUND((H25/($H$14+$H$17+$H$20+$H$22+$H$25))*AFP_Inv_max,)),IF(H25>=AFP_Inv_max,AFP_Inv_max,H25-I25)))","v":0}]
[22,null,null,"unbar"]
[23,null,null,null,null,"-","-","-","-","-"]
[24,null,"Summe AFP","bar",null,{"$f":"+F14++F17+F20+F22+F25","v":0},{"$f":"+G14+G17+G20+G22+G25","v":0},{"$f":"+H14++H17+H20+H22+H25","v":0},{"$f":"+I14++I17+I20+I22+I25","v":0},{"$f":"+J14++J17+J20+J22+J25","v":0}]
[25,null,null,"unbar",null,{"$f":"F15+F18+F21+F23+F26","v":0},null,{"$f":"H15+H18+H21+H23+H26","v":0}]
[26,"FID","bauliche Anlagen"]
[27,null,null,"bar",null,null,{"$f":"ROUNDUP(F31*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F31-G31","v":0},{"$f":"H31*K5/100","v":0},{"$f":"TRUNC(H31-I31)","v":0}]
[28,null,null,"unbar"]
[29,null,"technische Anlagen"]
[30,null,null,"bar",null,null,{"$f":"ROUNDUP(F34*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F34-G34","v":0},{"$f":"H34*K5/100","v":0},{"$f":"TRUNC(H34-I34)","v":0}]
[31,null,null,"unbar"]
[32,null,"Maschinen"]
[33,null,null,"bar",null,null,{"$f":"ROUNDUP(F37*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F37-G37","v":0},{"$f":"H37*K5/100","v":0},{"$f":"TRUNC(H37-I37)","v":0}]
[34,null,null,"unbar"]
[35,null,null,null,null,"-","-","-","-","-"]
[36,null,"Summe FID","bar",null,{"$f":"F31+F34+F37","v":0},{"$f":"G31+G34+G37","v":0},{"$f":"H31+H34+H37","v":0},{"$f":"I31+I34+I37","v":0},{"$f":"J31+J34+J37","v":0}]
[37,null,null,"unbar",null,{"$f":"F32+F35+F38","v":0},null,{"$f":"+H38+H35+H32","v":0}]
[38,"FIS","Spezialmaschinen"]
[39,"FIS",null,"bar",null,null,{"$f":"ROUNDUP(F43*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F43-G43","v":0},{"$f":"H43*K5/100","v":0},{"$f":"TRUNC(+H43-I43)","v":0}]
[40,"GMO-W","Basisinvestition",null,null,null,{"$f":"ROUNDUP(F44*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0}]
[41,null,null,"bar",null,null,{"$f":"ROUNDUP(F45*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F45-G45","v":0},{"$f":"H45*K5/100","v":0},{"$f":"TRUNC(IF(AND(H45>0,OR($H$45>0,$H$48>0),$H$45+$H$48>=GMOW_Inv_max),(ROUND((H45/($H$45+$H$48))*GMOW_Inv_max,)),IF(H45>=GMOW_Inv_max,GMOW_Inv_max,H45-I45)))","v":0}]
[42,null,null,"unbar"]
[43,null,"Qualitätsinvestition"]
[44,null,null,"bar",null,null,{"$f":"ROUNDUP(F48*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0},{"$f":"F48-G48","v":0},{"$f":"H48*K5/100","v":0},{"$f":"TRUNC(IF(AND(H48>0,OR($H$45>0,$H$48>0),$H$45+$H$48>=GMOW_Inv_max),(ROUND((H48/($H$45+$H$48))*GMOW_Inv_max,)),IF(H48>=GMOW_Inv_max,GMOW_Inv_max,H48-I48)))","v":0}]
[45,null,null,"unbar"]
[46,"nicht förderfähige Investitionen","Grunderwerb","bar",null,null,{"$f":"ROUNDUP(F50*(Mwst_Satz/100/(1+(Mwst_Satz/100))),)","v":0}]
[47,null,"Wohnhaus","bar",null,null,{"$f":"ROUNDUP(F51*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0}]
[48,null,null,"unbar"]
[49,null,"Dauerkulturen","bar",null,null,{"$f":"ROUNDUP(F53*((VST_Satz/100)/(1+(VST_Satz/100))),)","v":0}]
[50,null,null,"unbar"]
[51,null,"Vieh","Zukauf",null,null,{"$f":"ROUNDUP(F55*((VST_Satz/100)/(1+(VST_Satz/100))),)","v":0}]
[52,null,null,"eigene Aufzucht"]
[53,null,"Pflanzen","unbar"]
[54,null,"Sonstiges",null,null,null,{"$f":"ROUNDUP(F58*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0}]
[55,null,null,null,null,null,{"$f":"ROUNDUP(F59*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0}]
[56,null,null,null,null,null,{"$f":"ROUNDUP(F60*((Mwst_Satz/100)/(1+(Mwst_Satz/100))),)","v":0}]
[57,null,"Finanzierungsbedarf",null,"insgesamt",{"$f":"F28+F29+F40+F41+F43+F45+F46+F48+F49+F50+F51+F52+F53+F54+F55+F56+F57+F58+F59+F60","v":0},{"$f":"+G28+G40+G43+G45+G48+G50+G51+G53+G55+G58+G59+G60","v":0},{"$f":"+H28+H40+H43+H45+H48","v":0},{"$f":"I28+I40+I43+I48","v":0},{"$f":"J28+J40+J43+J45+J48","v":0}]
[58,null,null,null,"davon unbar",{"$f":"F29+F41+F46+F49+F52+F54+F56+F57","v":0}]

{"sheet":"I 4","index":3,"n_rows":417,"n_cols":59,"rows_kept":417,"cut":false,"hidden":false,"merged":[[46,10,46,11],[44,10,44,11],[42,10,42,11],[46,8,46,9],[33,7,33,8],[39,7,39,8],[43,8,43,11],[60,1,61,2],[60,8,60,9],[60,10,60,11],[61,8,61,11],[44,1,53,1],[53,10,53,11],[32,1,38,1],[41,4,42,4],[41,3,42,3],[54,1,59,1],[59,8,59,9],[48,8,48,9],[51,10,51,11],[52,10,52,11],[50,10,50,11],[54,8,54,9],[52,8,52,9],[25,9,25,11],[43,12,43,13],[11,7,11,8],[18,2,18,3],[27,9,27,11],[19,7,19,8],[42,8,42,9],[12,7,12,8],[15,7,15,8],[14,7,14,8],[25,7,25,8],[41,12,41,13],[30,9,30,11],[32,9,40,13],[19,12,31,13],[19,9,19,11],[20,9,20,11],[26,9,26,11],[31,9,31,11],[29,7,29,8],[20,7,20,8],[21,7,21,8],[24,7,24,8],[28,9,29,11],[51,8,51,9],[48,10,48,11],[54,10,54,11],[55,10,55,11],[57,8,57,9],[58,8,58,9],[55,8,55,9],[56,8,56,9],[53,8,53,9],[49,10,49,11],[49,8,49,9],[50,8,50,9],[61,12,61,13],[56,10,56,11],[57,10,57,11],[58,10,58,11],[59,10,59,11],[22,7,22,8],[26,7,26,8],[30,7,30,8],[28,7,28,8],[21,9,24,11],[47,10,47,11],[32,7,32,8],[41,6,41,7],[44,8,44,9],[45,8,45,9],[47,8,47,9],[45,10,45,11],[34,7,34,8],[36,7,36,8],[41,8,41,11],[35,7,35,8],[38,7,38,8],[31,7,31,8],[37,7,37,8],[2,9,2,13],[5,9,5,13],[6,7,6,8],[7,7,7,8],[5,7,5,8],[6,9,18,13],[9,7,9,8],[10,7,10,8],[16,7,16,8],[18,7,18,8],[8,7,8,8],[17,7,17,8],[13,7,13,8],[27,7,27,8],[2,0,2,3],[15,2,15,3],[16,2,16,3],[6,1,12,1],[17,2,17,3],[3,0,3,4],[21,1,30,1],[30,2,30,3],[29,2,29,3],[23,7,23,8],[14,1,19,1]]}
["Rheinland-Pfalz                                       Investitionskonzept",null,null,null,null,null,null,null,null,null,null,null,null,"I 4"]
[null,null,null,null,"Finanzierungsmittel/Kapitaldienst"]
[{"$f":"CONCATENATE(\"Unternehmen: \",+'I 1'!C3)","v":"Unternehmen: "}]
[{"$f":"+'I 1'!D6","v":0}]
[null,"Finanzierungsmittel",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,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[1,null,null,null,"EUR","IST (t)","IST (t+1)","IST (t+2) ",null,"Bemerkungen:"]
[{"$f":"A6+1","v":2},"bare\n Eigenmittel","Zur Finanzierung verwendet",null,{"$f":"+F7+G7+H7","v":0}]
[3,null,"Guthaben",null,{"$f":"+F8+G8+H8","v":0}]
[4,null,"Verkauf von Grundstücken",null,{"$f":"+F9+G9+H9","v":0}]
[5,null,"Verkauf der Althofstelle, Gebäude",null,{"$f":"+F10+G10+H10","v":0}]
[6,null,"Verkauf von Betr.vorr., Maschinen",null,{"$f":"+F11+G11+H11","v":0}]
[7,null,"Abgänge Vieh",null,{"$f":"IF(F12+G12+H12<>O12,O12-(F12+G12+H12),O12)","v":0}]
[8,null,"Abgänge Umlaufvermögen",null,{"$f":"IF(F13+G13+H13<>O13,O13-(F13+G13+H13),O13)","v":0}]
[{"$f":"A13+1","v":9},null,"Summe bare Eigenmittel",null,{"$f":"+F14+G14+H14","v":0},{"$f":"SUM(F7:F13)","v":0},{"$f":"SUM(G7:G13)","v":0},{"$f":"SUM(H7:H13)","v":0}]
[10,"unbare Eigenleistungen","Summe eig. Aufzucht, Pflanzen und DK",null,{"$f":"IF(F15+G15+H15<>O15,O15-(F15+G15+H15),O15)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'I 3'!F54+'I 3'!F56+'I 3'!F57","v":0}]
[11,null,"AFP",null,{"$f":"IF(F16+G16+H16<>O16,O16-(F16+G16+H16),O16)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+'I 3'!F29","v":0}]
[12,null,"FID",null,{"$f":"IF(F17+G17+H17<>O17,O17-(F17+G17+H17),O17)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+'I 3'!F41","v":0}]
[{"$f":"A16+1","v":12},null,"GMO-W",null,{"$f":"IF(F18+G18+H18<>O18,O18-(F18+G18+H18),O18)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+'I 3'!F46+'I 3'!F49","v":0}]
[{"$f":"A17+1","v":13},null,"Wohnhaus",null,{"$f":"IF(F19+G19+H19<>O19,O19-(F19+G19+H19),O19)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+'I 3'!F52","v":0}]
[14,null,"Summe unbare Eigenleistungen",null,{"$f":"+F20+G20+H20","v":0},{"$f":"SUM(F15:F19)","v":0},{"$f":"SUM(G15:G19)","v":0},{"$f":"SUM(H15:H19)","v":0},null,"EU-Beihilfewert"]
[15,"Summe Eigenleistungen",null,null,{"$f":"+F21+G21+H21","v":0},{"$f":"+F20+F14","v":0},{"$f":"+G20+G14","v":0},{"$f":"+H20+H14","v":0},{"$f":"+I20+I14+I15","v":0},"%"]
[16,"Zuschüsse","AFP - Premiumförderung",null,{"$f":"IF(F22+G22+H22<>O22,O22-(F22+G22+H22),O22)","v":0},null,null,null,null,{"$f":"IF(OR('I 4'!E22>0,'I 4'!E23>0,'I 4'!E24>0,'I 4'!E25>0),('I 4'!E22+'I 4'!E23+'I 4'!E24+'I 4'!E25)/'I 3'!H28*100,\" \")","v":" "}]
[17,null,"AFP - Basis- u. Erschließungförderung",null,0]
[18,null,"AFP - Premiumförderung + Stroh",null,0]
[19,null,"AFP - Junglandwirte",null,0]
[20,null,"FID",null,0,null,null,null,null,{"$f":"IF('I 4'!E26>0,+E26/'I 3'!H40*100,\"\")","v":""}]
[21,null,null,null,0,null,null,null,null,"-"]
[22,null,"FIS - Spezialmaschinen",null,0,null,null,null,null,{"$f":"IF( 'I 4'!E28>0,+E28/'I 3'!H43*100,\"\")","v":""}]
[23,null,"GMOW-Basisförderung",null,0,null,null,null,null,{"$f":"IF(OR('I 3'!H45>0,'I 3'!H48>0),(+E29+E30)/('I 3'!H45+'I 3'!H48)*100,\"\")","v":""}]
[24,null,"GMOW-Qualitätsförderung",null,0]
[{"$f":"A30+1","v":25},null,null,null,0]
[{"$f":"A30+1","v":25},"Summe Zuschüsse",null,null,{"$f":"+F32+G32+H32","v":0},{"$f":"SUM(F22:F31)","v":0},{"$f":"SUM(G22:G31)","v":0},{"$f":"SUM(H22:I31)","v":0},null,{"$f":"IF('I 3'!H61>0,(E22+E23+E24+E25+E26+E27+E28+E29+E30+E31)/'I 3'!H61*100,)","v":0}]
[26,"Darlehensaufnahme",null,null,0]
[27,null,null,null,0]
[28,null,null,null,0]
[29,null,null,null,0]
[30,null,null,null,0]
[31,null,null,null,0]
[32,null,null,null,0]
[33,"Summe Darlehen",null,null,0,{"$f":"SUM(F33:F39)","v":0},{"$f":"SUM(G33:G39)","v":0},{"$f":"SUM(H33:H39)","v":0}]
[34,"Summe Finanzierungsmittel",null,null,{"$f":"E40+E32+E21","v":0}]
[35,"Kapitaldienst",null,"Auszahlungs-jahr","Nenn-\nbetrag","Valuta ","Konditionen",null,"IST",null,null,null,"ZIEL"]
[36,null,null,null,null,"Ist","Tilgung","Zins","Tilgung",null,"Zins",null,"Tilgung","Zins"]
[37,null,null,"TT.MM.JJJJ","EUR","EUR"," %","%","EUR",null,null,null,"EUR"]
[38,"Altverbindlichkeiten"]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48,"Neuverbindlichkeiten"]
[49]
[50]
[51]
[52]
[53]
[54,"Kapitaldienst insgesamt",null,null,null,null,null,null,{"$f":"SUM(I45:J54)","v":0},null,{"$f":"SUM(K45:L54)","v":0},null,{"$f":"SUM(M45:M60)","v":0},{"$f":"SUM(N45:N60)","v":0}]
[55,null,null,null,null,null,null,null,{"$f":"SUM(I45:L54)","v":0},null,null,null,{"$f":"SUM(M45:N60)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J22+J23+J24+J25+J26+J28+J29+J30+J31","v":{"$error":"#VALUE!"}}]

{"sheet":"I 5","index":4,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,6,2,9],[6,1,6,3],[21,2,21,3],[8,2,8,3],[9,2,9,3],[5,6,5,8],[2,0,2,5],[3,0,3,5],[13,2,13,3],[14,2,14,3],[15,2,15,3],[18,2,18,3],[10,2,10,3],[11,2,11,3],[4,1,4,3],[12,2,12,3],[58,2,58,3],[46,2,46,3],[28,2,28,3],[19,2,19,3],[20,2,20,3],[43,2,44,3],[39,2,39,8],[52,2,52,8],[57,2,57,8],[56,2,56,8],[25,2,25,3],[37,2,37,8],[30,2,30,8],[31,2,31,8],[32,2,32,8],[33,2,33,8],[53,1,57,1],[24,2,24,3],[43,1,51,1],[45,2,45,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[38,2,38,8],[34,2,34,8],[36,1,42,1],[30,1,35,1],[26,2,26,3],[29,2,29,3],[27,2,27,3],[35,2,35,8],[8,1,29,1],[23,2,23,3],[16,2,16,3],[22,2,22,3],[17,2,17,3],[36,4,36,8],[40,2,40,8],[55,2,55,8],[51,2,51,3],[41,2,41,8],[42,2,42,8],[53,2,53,8],[54,2,54,8],[43,5,43,6],[43,7,43,8]]}
["Rheinland-Pfalz                                Investitionskonzept",null,null,null,null,null,null,null,null,"I 5"]
[null,null,null,"                            wirtschaftliche Unternehmensentwicklung"]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "}]
[{"$f":"+'I 1'!D6","v":0}]
[1,"ordentliches  Ergebnis IST (EUR)",null,null,null,null,null,null,null,{"$f":"IF('I 2'!E6=\"EUR\",'I 2'!J43,'I 2'!J43/1.95583)","v":0},"Hilfsspalte zur Veränderung der"]
[{"$f":"+A5+1","v":2},null,null,null,null,"IST","ZIEL",null,null,null,"Produktionsverfahen"]
[{"$f":"+A6+1","v":3},"Änderungsposition",null,null,"Einheit","Umfang/\nMenge","Änderung gegenüber IST","Preis","Deckungs-\nbeitrag"," Veränderungen","Produktionsverfahren","Ist"," +/- Einheit"]
[4,null,null,null,"ha/GV/Stück","Anzahl Einheiten"," +/- Einheiten","EUR/Einheit","EUR/Einheit","EUR","Ackerbau ohne Futter"]
[5," + / - Änderung der Produktion",null,null,null,null,null,null,null,{"$f":"+G9*I9","v":0},{"$f":"IF('I 1'!D22>'I 1'!H22,'I 1'!B22,IF('I 1'!D22<'I 1'!H22,'I 1'!B22,\" \"))","v":" "},{"$f":"IF('I 1'!D22>'I 1'!H22,'I 1'!D22,IF('I 1'!D22<'I 1'!H22,'I 1'!D22,\" \"))","v":" "},{"$f":"IF('I 1'!D22>'I 1'!H22,CONCATENATE(,\"- \",'I 1'!D22-'I 1'!H22),IF('I 1'!D22<'I 1'!H22,CONCATENATE(\"+ \",'I 1'!H22-'I 1'!D22),\" \"))","v":" "}]
[6,null,null,null,null,null,null,null,null,{"$f":"+G10*I10","v":0},{"$f":"IF('I 1'!D23>'I 1'!H23,'I 1'!B23,IF('I 1'!D23<'I 1'!H23,'I 1'!B23,\" \"))","v":" "},{"$f":"IF('I 1'!D23>'I 1'!H23,'I 1'!D23,IF('I 1'!D23<'I 1'!H23,'I 1'!D23,\" \"))","v":" "},{"$f":"IF('I 1'!D23>'I 1'!H23,CONCATENATE(,\"- \",'I 1'!D23-'I 1'!H23),IF('I 1'!D23<'I 1'!H23,CONCATENATE(\"+ \",'I 1'!H23-'I 1'!D23),\" \"))","v":" "}]
[7,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D24>'I 1'!H24,'I 1'!B24,IF('I 1'!D24<'I 1'!H24,'I 1'!B24,\" \"))","v":" "},{"$f":"IF('I 1'!D24>'I 1'!H24,'I 1'!D24,IF('I 1'!D24<'I 1'!H24,'I 1'!D24,\" \"))","v":" "},{"$f":"IF('I 1'!D24>'I 1'!H24,CONCATENATE(,\"- \",'I 1'!D24-'I 1'!H24),IF('I 1'!D24<'I 1'!H24,CONCATENATE(\"+ \",'I 1'!H24-'I 1'!D24),\" \"))","v":" "}]
[8,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D25>'I 1'!H25,'I 1'!B25,IF('I 1'!D25<'I 1'!H25,'I 1'!B25,\" \"))","v":" "},{"$f":"IF('I 1'!D25>'I 1'!H25,'I 1'!D25,IF('I 1'!D25<'I 1'!H25,'I 1'!D25,\" \"))","v":" "},{"$f":"IF('I 1'!D25>'I 1'!H25,CONCATENATE(,\"- \",'I 1'!D25-'I 1'!H25),IF('I 1'!D25<'I 1'!H25,CONCATENATE(\"+ \",'I 1'!H25-'I 1'!D25),\" \"))","v":" "}]
[9,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D26>'I 1'!H26,'I 1'!B26,IF('I 1'!D26<'I 1'!H26,'I 1'!B26,\" \"))","v":" "},{"$f":"IF('I 1'!D26>'I 1'!H26,'I 1'!D26,IF('I 1'!D26<'I 1'!H26,'I 1'!D26,\" \"))","v":" "},{"$f":"IF('I 1'!D26>'I 1'!H26,CONCATENATE(,\"- \",'I 1'!D26-'I 1'!H26),IF('I 1'!D26<'I 1'!H26,CONCATENATE(\"+ \",'I 1'!H26-'I 1'!D26),\" \"))","v":" "}]
[10,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D27>'I 1'!H27,'I 1'!B27,IF('I 1'!D27<'I 1'!H27,'I 1'!B27,\" \"))","v":" "},{"$f":"IF('I 1'!D27>'I 1'!H27,'I 1'!D27,IF('I 1'!D27<'I 1'!H27,'I 1'!D27,\" \"))","v":" "},{"$f":"IF('I 1'!D27>'I 1'!H27,CONCATENATE(,\"- \",'I 1'!D27-'I 1'!H27),IF('I 1'!D27<'I 1'!H27,CONCATENATE(\"+ \",'I 1'!H27-'I 1'!D27),\" \"))","v":" "}]
[11,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D28>'I 1'!H28,'I 1'!B28,IF('I 1'!D28<'I 1'!H28,'I 1'!B28,\" \"))","v":" "},{"$f":"IF('I 1'!D28>'I 1'!H28,'I 1'!D28,IF('I 1'!D28<'I 1'!H28,'I 1'!D28,\" \"))","v":" "},{"$f":"IF('I 1'!D28>'I 1'!H28,CONCATENATE(,\"- \",'I 1'!D28-'I 1'!H28),IF('I 1'!D28<'I 1'!H28,CONCATENATE(\"+ \",'I 1'!H28-'I 1'!D28),\" \"))","v":" "}]
[12,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D29>'I 1'!H29,'I 1'!B29,IF('I 1'!D29<'I 1'!H29,'I 1'!B29,\" \"))","v":" "},{"$f":"IF('I 1'!D29>'I 1'!H29,'I 1'!D29,IF('I 1'!D29<'I 1'!H29,'I 1'!D29,\" \"))","v":" "},{"$f":"IF('I 1'!D29>'I 1'!H29,CONCATENATE(,\"- \",'I 1'!D29-'I 1'!H29),IF('I 1'!D29<'I 1'!H29,CONCATENATE(\"+ \",'I 1'!H29-'I 1'!D29),\" \"))","v":" "}]
[13,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D30>'I 1'!H30,'I 1'!B30,IF('I 1'!D30<'I 1'!H30,'I 1'!B30,\" \"))","v":" "},{"$f":"IF('I 1'!D30>'I 1'!H30,'I 1'!D30,IF('I 1'!D30<'I 1'!H30,'I 1'!D30,\" \"))","v":" "},{"$f":"IF('I 1'!D30>'I 1'!H30,CONCATENATE(,\"- \",'I 1'!D30-'I 1'!H30),IF('I 1'!D30<'I 1'!H30,CONCATENATE(\"+ \",'I 1'!H30-'I 1'!D30),\" \"))","v":" "}]
[14,null,null,null,null,null,null,null,null,0,"Ackerfutterbau und Grünland"]
[15,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D32>'I 1'!H32,'I 1'!B32,IF('I 1'!D32<'I 1'!H32,'I 1'!B32,\" \"))","v":" "},{"$f":"IF('I 1'!D32>'I 1'!H32,'I 1'!D32,IF('I 1'!D32<'I 1'!H32,'I 1'!D32,\" \"))","v":" "},{"$f":"IF('I 1'!D32>'I 1'!H32,CONCATENATE(,\"- \",'I 1'!D32-'I 1'!H32),IF('I 1'!D32<'I 1'!H32,CONCATENATE(\"+ \",'I 1'!H32-'I 1'!D32),\" \"))","v":" "}]
[16,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D33>'I 1'!H33,'I 1'!B33,IF('I 1'!D33<'I 1'!H33,'I 1'!B33,\" \"))","v":" "},{"$f":"IF('I 1'!D33>'I 1'!H33,'I 1'!D33,IF('I 1'!D33<'I 1'!H33,'I 1'!D33,\" \"))","v":" "},{"$f":"IF('I 1'!D33>'I 1'!H33,CONCATENATE(,\"- \",'I 1'!D33-'I 1'!H33),IF('I 1'!D33<'I 1'!H33,CONCATENATE(\"+ \",'I 1'!H33-'I 1'!D33),\" \"))","v":" "}]
[17,null,null,null,null,null,null,null,null,{"$f":"+G21*I21","v":0},{"$f":"IF('I 1'!D34>'I 1'!H34,'I 1'!B34,IF('I 1'!D34<'I 1'!H34,'I 1'!B34,\" \"))","v":" "},{"$f":"IF('I 1'!D34>'I 1'!H34,'I 1'!D34,IF('I 1'!D34<'I 1'!H34,'I 1'!D34,\" \"))","v":" "},{"$f":"IF('I 1'!D34>'I 1'!H34,CONCATENATE(,\"- \",'I 1'!D34-'I 1'!H34),IF('I 1'!D34<'I 1'!H34,CONCATENATE(\"+ \",'I 1'!H34-'I 1'!D34),\" \"))","v":" "}]
[18,null,null,null,null,null,null,null,null,{"$f":"+G22*I22","v":0},{"$f":"IF('I 1'!D35>'I 1'!H35,'I 1'!B35,IF('I 1'!D35<'I 1'!H35,'I 1'!B35,\" \"))","v":" "},{"$f":"IF('I 1'!D35>'I 1'!H35,'I 1'!D35,IF('I 1'!D35<'I 1'!H35,'I 1'!D35,\" \"))","v":" "},{"$f":"IF('I 1'!D35>'I 1'!H35,CONCATENATE(,\"- \",'I 1'!D35-'I 1'!H35),IF('I 1'!D35<'I 1'!H35,CONCATENATE(\"+ \",'I 1'!H35-'I 1'!D35),\" \"))","v":" "}]
[19,null,null,null,null,null,null,null,null,{"$f":"+G23*I23","v":0},{"$f":"IF('I 1'!D36>'I 1'!H36,'I 1'!B36,IF('I 1'!D36<'I 1'!H36,'I 1'!B36,\" \"))","v":" "},{"$f":"IF('I 1'!D36>'I 1'!H36,'I 1'!D36,IF('I 1'!D36<'I 1'!H36,'I 1'!D36,\" \"))","v":" "},{"$f":"IF('I 1'!D36>'I 1'!H36,CONCATENATE(,\"- \",'I 1'!D36-'I 1'!H36),IF('I 1'!D36<'I 1'!H36,CONCATENATE(\"+ \",'I 1'!H36-'I 1'!D36),\" \"))","v":" "}]
[20,null,null,null,null,null,null,null,null,0,"Tierproduktion"]
[21,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D38>'I 1'!H38,'I 1'!B38,IF('I 1'!D38<'I 1'!H38,'I 1'!B38,\" \"))","v":" "},{"$f":"IF('I 1'!D38>'I 1'!H38,'I 1'!D38,IF('I 1'!D38<'I 1'!H38,'I 1'!D38,\" \"))","v":" "},{"$f":"IF('I 1'!D38>'I 1'!H38,CONCATENATE(,\"- \",'I 1'!D38-'I 1'!H38),IF('I 1'!D38<'I 1'!H38,CONCATENATE(\"+ \",'I 1'!H38-'I 1'!D38),\" \"))","v":" "}]
[22,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D39>'I 1'!H39,'I 1'!B39,IF('I 1'!D39<'I 1'!H39,'I 1'!B39,\" \"))","v":" "},{"$f":"IF('I 1'!D39>'I 1'!H39,'I 1'!D39,IF('I 1'!D39<'I 1'!H39,'I 1'!D39,\" \"))","v":" "},{"$f":"IF('I 1'!D39>'I 1'!H39,CONCATENATE(,\"- \",'I 1'!D39-'I 1'!H39),IF('I 1'!D39<'I 1'!H39,CONCATENATE(\"+ \",'I 1'!H39-'I 1'!D39),\" \"))","v":" "}]
[23,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D40>'I 1'!H40,'I 1'!B40,IF('I 1'!D40<'I 1'!H40,'I 1'!B40,\" \"))","v":" "},{"$f":"IF('I 1'!D40>'I 1'!H40,'I 1'!D40,IF('I 1'!D40<'I 1'!H40,'I 1'!D40,\" \"))","v":" "},{"$f":"IF('I 1'!D40>'I 1'!H40,CONCATENATE(,\"- \",'I 1'!D40-'I 1'!H40),IF('I 1'!D40<'I 1'!H40,CONCATENATE(\"+ \",'I 1'!H40-'I 1'!D40),\" \"))","v":" "}]
[24,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D41>'I 1'!H41,'I 1'!B41,IF('I 1'!D41<'I 1'!H41,'I 1'!B41,\" \"))","v":" "},{"$f":"IF('I 1'!D41>'I 1'!H41,'I 1'!D41,IF('I 1'!D41<'I 1'!H41,'I 1'!D41,\" \"))","v":" "},{"$f":"IF('I 1'!D41>'I 1'!H41,CONCATENATE(,\"- \",'I 1'!D41-'I 1'!H41),IF('I 1'!D41<'I 1'!H41,CONCATENATE(\"+ \",'I 1'!H41-'I 1'!D41),\" \"))","v":" "}]
[25,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D42>'I 1'!H42,'I 1'!B42,IF('I 1'!D42<'I 1'!H42,'I 1'!B42,\" \"))","v":" "},{"$f":"IF('I 1'!D42>'I 1'!H42,'I 1'!D42,IF('I 1'!D42<'I 1'!H42,'I 1'!D42,\" \"))","v":" "},{"$f":"IF('I 1'!D42>'I 1'!H42,CONCATENATE(,\"- \",'I 1'!D42-'I 1'!H42),IF('I 1'!D42<'I 1'!H42,CONCATENATE(\"+ \",'I 1'!H42-'I 1'!D42),\" \"))","v":" "}]
[26,null,null,null,null,null,null,null,null,0,{"$f":"IF('I 1'!D43>'I 1'!H43,'I 1'!B43,IF('I 1'!D43<'I 1'!H43,'I 1'!B43,\" \"))","v":" "},{"$f":"IF('I 1'!D43>'I 1'!H43,'I 1'!D43,IF('I 1'!D43<'I 1'!H43,'I 1'!D43,\" \"))","v":" "},{"$f":"IF('I 1'!D43>'I 1'!H43,CONCATENATE(,\"- \",'I 1'!D43-'I 1'!H43),IF('I 1'!D43<'I 1'!H43,CONCATENATE(\"+ \",'I 1'!H43-'I 1'!D43),\" \"))","v":" "}]
[27," + sonstige Erträge",null,null,null,null,null,null,null,null,"Handel, Dienstleistungen usw."]
[28,null,null,null,null,null,null,null,null,null,{"$f":"IF('I 1'!D45>'I 1'!H45,'I 1'!B45,IF('I 1'!D45<'I 1'!H45,'I 1'!B45,\" \"))","v":" "},{"$f":"IF('I 1'!D45>'I 1'!H45,'I 1'!D45,IF('I 1'!D45<'I 1'!H45,'I 1'!D45,\" \"))","v":" "},{"$f":"IF('I 1'!D45>'I 1'!H45,CONCATENATE(,\"- \",'I 1'!D45-'I 1'!H45),IF('I 1'!D45<'I 1'!H45,CONCATENATE(\"+ \",'I 1'!H45-'I 1'!D45),\" \"))","v":" "}]
[29,null,null,null,null,null,null,null,null,null,{"$f":"IF('I 1'!D46>'I 1'!H46,'I 1'!B46,IF('I 1'!D46<'I 1'!H46,'I 1'!B46,\" \"))","v":" "},{"$f":"IF('I 1'!D46>'I 1'!H46,'I 1'!D46,IF('I 1'!D46<'I 1'!H46,'I 1'!D46,\" \"))","v":" "},{"$f":"IF('I 1'!D46>'I 1'!H46,CONCATENATE(,\"- \",'I 1'!D46-'I 1'!H46),IF('I 1'!D46<'I 1'!H46,CONCATENATE(\"+ \",'I 1'!H46-'I 1'!D46),\" \"))","v":" "}]
[30,null,null,null,null,null,null,null,null,null,{"$f":"IF('I 1'!D47>'I 1'!H47,'I 1'!B47,IF('I 1'!D47<'I 1'!H47,'I 1'!B47,\" \"))","v":" "},{"$f":"IF('I 1'!D47>'I 1'!H47,'I 1'!D47,IF('I 1'!D47<'I 1'!H47,'I 1'!D47,\" \"))","v":" "},{"$f":"IF('I 1'!D47>'I 1'!H47,CONCATENATE(,\"- \",'I 1'!D47-'I 1'!H47),IF('I 1'!D47<'I 1'!H47,CONCATENATE(\"+ \",'I 1'!H47-'I 1'!D47),\" \"))","v":" "}]
[31,null,null,null,null,null,null,null,null,null,{"$f":"IF('I 1'!D48>'I 1'!H48,'I 1'!B48,IF('I 1'!D48<'I 1'!H48,'I 1'!B48,\" \"))","v":" "},{"$f":"IF('I 1'!D48>'I 1'!H48,'I 1'!D48,IF('I 1'!D48<'I 1'!H48,'I 1'!D48,\" \"))","v":" "},{"$f":"IF('I 1'!D48>'I 1'!H48,CONCATENATE(,\"- \",'I 1'!D48-'I 1'!H48),IF('I 1'!D48<'I 1'!H48,CONCATENATE(\"+ \",'I 1'!H48-'I 1'!D48),\" \"))","v":" "}]
[32,null,null,null,null,null,null,null,null,null,{"$f":"IF('I 1'!D49>'I 1'!H49,'I 1'!B49,IF('I 1'!D49<'I 1'!H49,'I 1'!B49,\" \"))","v":" "},{"$f":"IF('I 1'!D49>'I 1'!H49,'I 1'!D49,IF('I 1'!D49<'I 1'!H49,'I 1'!D49,\" \"))","v":" "},{"$f":"IF('I 1'!D49>'I 1'!H49,CONCATENATE(,\"- \",'I 1'!D49-'I 1'!H49),IF('I 1'!D49<'I 1'!H49,CONCATENATE(\"+ \",'I 1'!H49-'I 1'!D49),\" \"))","v":" "}]
[33," - Betriebsaufwand"," dav. Personalaufwand",null,null,null,null,null,null,null,{"$f":"IF('I 1'!D50>'I 1'!H50,'I 1'!B50,IF('I 1'!D50<'I 1'!H50,'I 1'!B50,\" \"))","v":" "},{"$f":"IF('I 1'!D50>'I 1'!H50,'I 1'!D50,IF('I 1'!D50<'I 1'!H50,'I 1'!D50,\" \"))","v":" "},{"$f":"IF('I 1'!D50>'I 1'!H50,CONCATENATE(,\"- \",'I 1'!D50-'I 1'!H50),IF('I 1'!D50<'I 1'!H50,CONCATENATE(\"+ \",'I 1'!H50-'I 1'!D50),\" \"))","v":" "}]
[34]
[35]
[36]
[37]
[38]
[39]
[40," - Investitionskosten",null,null,"Anschaffungs-\nwert","Abschreibung",null,"Unterhaltung"]
[41,null,null,null,"EUR","%","EUR","%","EUR"]
[42,null,null,null,null,null,{"$f":"+E46*F46/100","v":0},null,{"$f":"+E46*H46/100","v":0},{"$f":"+G46+I46","v":0}]
[43,null,null,null,null,null,{"$f":"+E47*F47/100","v":0},null,{"$f":"+E47*H47/100","v":0},{"$f":"+G47+I47","v":0}]
[44,null,null,null,null,null,0,null,0,0]
[45,null,null,null,null,null,0,null,0,0]
[46,null,null,null,null,null,0,null,0,0]
[47,null,null,null,null,null,0,null,0,0]
[48,null,null,null,null,null,0,null,0,0]
[49,"-","Zinsdifferenz  (Zinsen Ist abzüglich Zinsen Ziel)",null,null,null,null,null,null,{"$f":"'I 4'!N61-'I 4'!K61","v":0}]
[50," - Steuern"]
[51]
[52]
[53]
[54]
[55,"=","ordentliches Ergebnis ZIEL",null,null,null,null,null,null,{"$f":"+J5+SUM(J9:J36)-SUM(J37:J43)-SUM(J46:J52)-SUM(J53:J58)","v":0}]

{"sheet":"GV-Berechnung","index":5,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[[36,0,36,1],[37,0,37,1],[38,0,38,1],[50,0,50,3],[51,0,51,3],[17,5,17,7],[66,0,66,3],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[43,0,43,1],[40,0,40,1],[22,0,22,1],[23,0,23,1],[28,0,28,1],[35,0,35,1],[32,0,32,1],[30,0,30,1],[33,0,33,1],[29,0,29,1],[67,0,67,3],[45,5,45,7],[45,2,45,4],[39,0,39,1],[52,0,52,1],[65,0,65,3],[41,0,41,1],[42,0,42,1],[61,0,61,1],[58,0,58,1],[59,0,59,1],[62,0,62,1],[34,0,34,1],[15,0,15,2],[19,0,19,1],[20,0,20,1],[21,0,21,1],[17,0,18,1],[17,2,17,4],[31,0,31,1],[12,0,12,2],[14,0,14,2],[1,0,1,7],[5,0,5,2],[6,0,6,2],[2,0,3,7],[4,0,4,2],[9,0,9,2],[11,0,11,2],[8,0,8,2],[13,0,13,2],[7,0,7,2]]}
["Rheinland-Pfalz                                       Investitionskonzept"]
["Viehbesatzberechnung  - Lagerkapazität wirtschaftseigener Dünger"]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!$C$3)","v":"Unternehmen: "}]
[]
["Vorhandene Lagerkapazitäten:",null,null,"m3","m2"]
["Güllegrube vorhanden"]
["Jauchegrube vorhanden"]
["Dunglege vorhanden"]
[]
["Summe IST",null,null,{"$f":"SUM(D6:D9)","v":0},{"$f":"SUM(E6:E9)","v":0}]
[]
["Neue Lagerkapazitäten:",null,null,"m3","m2"]
["Güllegrube neu"]
["Jauchegrube neu"]
["Dunglege neu"]
["Gesamte Lagerkapazität im Ziel (Ist vorhanden plus neu)",null,null,{"$f":"SUM(D13:D15)+D10","v":0},{"$f":"SUM(E13:E15)+E10","v":0}]
[]
["Tierart",null,"Ist - Betrieb",null,null,"Ziel - Betrieb"]
[null,null,"Stück"," x GV/St.","= GV","Stück"," x GV/St.","= GV"]
["Rinder > 2 Jahre",null,null,1,{"$f":"C20*D20","v":0},{"$f":"+C20","v":0},{"$f":"D20","v":1},{"$f":"F20*G20","v":0}]
["Rinder von 6 Monate bis  2 Jahre",null,null,0.6,{"$f":"C21*D21","v":0},0,{"$f":"D21","v":0.6},{"$f":"F21*G21","v":0}]
["Rinder < 6 Monate",null,null,0.4,{"$f":"C22*D22","v":0},0,{"$f":"D22","v":0.4},{"$f":"F22*G22","v":0}]
[null,null,null,null,{"$f":"C23*D23","v":0},0,0,{"$f":"F23*G23","v":0}]
[null,null,null,null,{"$f":"C24*D24","v":0},0,0,{"$f":"F24*G24","v":0}]
["Equiden > 6 Monate",null,null,1,{"$f":"+C25*D25","v":0},0,1,{"$f":"+F25*G25","v":0}]
["Equiden - Ponys u. Kleinpferde mit Stockmaß <= 1,40 m",null,null,0.7,{"$f":"+C26*D26","v":0},0,0.7,{"$f":"+F26*G26","v":0}]
[null,null,null,null,{"$f":"+C27*D27","v":0},0,0,{"$f":"+F27*G27","v":0}]
["Schafe und Ziegen",null,null,0.15,{"$f":"+C28*D28","v":0},0,0.15,{"$f":"+F28*G28","v":0}]
[null,null,null,null,{"$f":"C29*D29","v":0},0,{"$f":"D29","v":0},{"$f":"F29*G29","v":0}]
["Summe RGV",null,null,null,{"$f":"SUM(E20:E29)","v":0},null,null,{"$f":"SUM(H20:H29)","v":0}]
["Ferkel",null,null,0.02,{"$f":"C31*D31","v":0},{"$f":"+C31","v":0},{"$f":"D31","v":0.02},{"$f":"F31*G31","v":0}]
["Schweine < 50 kg",null,null,0.06,0,{"$f":"C32","v":0},{"$f":"D32","v":0.06},0]
["Mastschweine > 50 kg",null,null,0.16,0,0,{"$f":"D33","v":0.16},0]
["Zuchtsauen > 50 kg",null,null,0.5,0,0,0.5,0]
["Sonstige Schweine",null,null,0.3,0,0,0.3,0]
[null,null,null,null,0,0,{"$f":"D36","v":0},0]
["Summe Schweieveredlung GV",null,null,null,{"$f":"SUM(E31:E36)","v":0},null,null,{"$f":"SUM(H31:H36)","v":0}]
["Legehennen (Plätze)",null,null,1.4E-2,{"$f":"+C38*D38","v":0},{"$f":"+C38","v":0},{"$f":"D38","v":1.4E-2},{"$f":"+F38*G38","v":0}]
["Sonstiges Geflügel (Plätze)",null,null,0.03,{"$f":"+C39*D39","v":0},{"$f":"+C39","v":0},{"$f":"+D39","v":0.03},{"$f":"+F39*G39","v":0}]
["Summe sonstige Veredlung GV",null,null,null,{"$f":"SUM(E38:E39)","v":0},null,null,{"$f":"SUM(H38:H39)","v":0}]
[null,null,null,null,{"$f":"+C41*D41","v":0},{"$f":"+C41","v":0},{"$f":"+D41","v":0},{"$f":"+F41*G41","v":0}]
[null,null,null,null,{"$f":"+C42*D42","v":0},{"$f":"+C42","v":0},{"$f":"+D42","v":0},{"$f":"+F42*G42","v":0}]
["Summe sonstige GV",null,null,null,{"$f":"SUM(E41:E42)","v":0},null,null,{"$f":"SUM(H41:H42)","v":0}]
["Summe gehaltene GV",null,null,null,{"$f":"E43+E40+E37+E30","v":0},null,null,{"$f":"H43+H40+H37+H30","v":0}]
[]
[null,null,"Ist - Betrieb",null,null,"Ziel - Betrieb"]
["Lagerkapazität",null,"GV"," x L/GV 1)","= m2 / m3","GV"," x L/GV 1)","= m2 / m3"]
["Mistlager für RGV nötig",null,{"$f":"E30","v":0},3,{"$f":"D48*C48","v":0},{"$f":"H30","v":0},{"$f":"D48","v":3},{"$f":"G48*F48","v":0}]
["Mistlager für Veredlung nötig",null,{"$f":"E37+E40","v":0},2.5,{"$f":"D49*C49","v":0},{"$f":"H40+H37","v":0},{"$f":"D49","v":2.5},{"$f":"G49*F49","v":0}]
["Mistlager für sonstige nötig",null,{"$f":"E43","v":0},null,{"$f":"D50*C50","v":0},{"$f":"H43","v":0},{"$f":"D50","v":0},{"$f":"G50*F50","v":0}]
["Summe notw. Mistlager für 6 bzw. 9 Monate",null,null,null,{"$f":"SUM(E48:E50)","v":0},null,null,{"$f":"SUM(H48:H50)","v":0}]
["Mistlager vorhanden (insgesamt)",null,null,null,{"$f":"E10","v":0},null,null,{"$f":"E16","v":0}]
["Mistlagerkapazität ist ausreichend",null,null,null,{"$f":"IF(E51<>0,IF(E52>=E51,\"Ja\",\"Nein\"),)","v":0},null,null,{"$f":"IF(H51<>0,IF(H52>=H51,\"Ja\",\"Nein\"),)","v":0}]
["Jauchelager für RGV nötig",null,{"$f":"E30","v":0},2.5,{"$f":"D54*C54","v":0},{"$f":"H30","v":0},{"$f":"D54","v":2.5},{"$f":"G54*F54","v":0}]
["Jauchelager für Veredlung nötig",null,{"$f":"E37+E40","v":0},3.5,0,{"$f":"H40+H37","v":0},{"$f":"D55","v":3.5},0]
["Jauchelager für sonstige GV nötig",null,{"$f":"E43","v":0},null,0,{"$f":"H43","v":0},{"$f":"D56","v":0},0]
["Güllelager für RGV nötig",null,{"$f":"E30","v":0},9,0,{"$f":"H30","v":0},{"$f":"D57","v":9},0]
["Güllelager f. Schweine-Alt- u. Umbau nötig 2)3)4)",null,{"$f":"E37","v":0},8.4,0,{"$f":"H37","v":0},8.4,0]
[null,null,null,null,0,null,null,0]
[null,null,null,null,{"$f":"D60*C60","v":0},null,null,{"$f":"G60*F60","v":0}]
["Güllelager für Schweine-Neubau nötig 2)3)4)",null,null,null,0,{"$f":"H37-E37","v":0},12.6,0]
[null,null,null,null,{"$f":"D62*C62","v":0},null,null,{"$f":"G62*F62","v":0}]
[null,null,null,null,0,null,null,0]
["Güllelager für sonstige Veredlungs-GV",null,{"$f":"E40","v":0},null,0,{"$f":"H40","v":0},{"$f":"D64","v":0},0]
["Güllelager für sonstige GV nötig",null,{"$f":"E43","v":0},null,0,{"$f":"H43","v":0},{"$f":"D65","v":0},0]
["Summe notw. Gülle/Jauchelager für 6 bzw. 9 Monate",null,null,null,{"$f":"SUM(E54:E65)","v":0},null,null,{"$f":"SUM(H54:H65)","v":0}]
["Gülle-/Jauchelager vorhanden (insgesamt)",null,null,null,{"$f":"D10","v":0},null,null,{"$f":"D16","v":0}]
["Gülle/Jauche-Lagerkapazität ist ausreichend",null,null,null,{"$f":"IF(E66<>0,IF(E67>=E66,\"Ja\",\"Nein\"),)","v":0},null,null,{"$f":"IF(H66<>0,IF(H67>=H66,\"Ja\",\"Nein\"),)","v":0}]
[]
["GV je ha im Ziel:",null,null,null,"GV","ha LF5)","GV/ha LF"]
[null,null,"Viehbesatz",null,{"$f":"H44","v":0},{"$f":"+'I 1'!G16","v":0},{"$f":"IF(AND(F71>0,E71>0),E71/F71,\"\")","v":""}]
["1) Lagerraumbedarf: mind.  6 Monate für vorhandene Stallungen und Umbauten sowie mind. 9 Monate Güllelagerbedarf für Schweinestallneubauten"]
["2) hoher Bedarf bei Mastschweinen mit Trockenfütterung, Ferkelaufzucht"]
["3) mittlerer Bedarf bei Mastschweinen mit Flüssigfütterung oder Breiautomaten mit seperater Tränke, Sauen mit Ferkel"]
["4) geringer Bedarf bei Mastschweinen mit Flüssigfütterung oder Breiautomaten ohne seperater Tränke, Sauen, Eber"]
["5) selbstbewirtschaftete landwirtschaftliche Nutzfläche incl. Flächen im Betriebsverbund und vertraglich vereinbarte Ausbringungsflächen"]
["Güllelager f. Schweine-Alt- u. Umbau nötig2)3)4)",8.4,12.6]
["Güllelager für Schweine-Neubau nötig 2)3)4)",5.4,{"$f":"+B78*1.5","v":8.1}]
[null,4.2,{"$f":"+B79*1.5","v":6.3}]

{"sheet":"Belegliste","index":6,"n_rows":700,"n_cols":17,"rows_kept":700,"cut":false,"hidden":false,"merged":[[2,0,2,3],[2,7,2,10]]}
["Anlage \"Verwendung der zweckentsprechenden Ausgaben (Belegliste)\""]
[]
[{"$f":"+'I 1'!D6","v":0}]
["Beleg lfd. Nr.","Auftrags-datum","Rechnungs-datum","Zahlungs-datum","Rechnungs-nummer","Name und Ort des Rechnungsausstellers","Investitionsobjekt1)","Rechnungs-betrag\ninsgesamt","abzüglich Skonti, Nachlässe und Rabatte2)","abzüglich\nUmsatzsteuer,\nsonstige Steuer","ergibt\nNettobetrag","Bemerkungen"]
[null,null,null,null,null,null,null,"EUR","EUR","EUR","EUR"]
[1,2,3,4,5,6,7,8,9,10,11,"12","Zahl","Zahl","Zahl","Standard"]
[null,"Rechnungsbeträge insgesamt:",null,null,null,null,null,{"$f":"SUM(H8:H700)","v":0},{"$f":"SUM(I8:I700)","v":0},{"$f":"SUM(J8:J700)","v":0},{"$f":"SUM(K8:K700)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G9=\"Grunderwerb (AFP)\",+G9=\"Grunderwerb (FID)\",+G9=\"Grunderwerb (nicht förderfähig)\"),+(((H9-I9)/1.05)*0.05),+((H9-I9)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H9-I9-J9","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D13","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D16","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D19","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,"öffentliche Erschließung"]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D24","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,"Grunderwerb (AFP)"]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D30","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D33","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D36","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,"Grunderwerb (FID)"]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D42","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D44","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"+'I 3'!D47","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!C50,\" (nicht förderfähig)\")","v":"Grunderwerb (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!C51,\" (nicht förderfähig)\")","v":"Wohnhaus (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!C53,\" (nicht förderfähig)\")","v":"Dauerkulturen (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!C55,\" \", +'I 3'!D55,\" (nicht förderfähig)\")","v":"Vieh Zukauf (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!D58,\" (nicht förderfähig)\")","v":" (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!D59,\" (nicht förderfähig)\")","v":" (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"CONCATENATE(+'I 3'!D60,\" (nicht förderfähig)\")","v":" (nicht förderfähig)"}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G73=\"Grunderwerb (AFP)\",+G73=\"Grunderwerb (FID)\",+G73=\"Grunderwerb (nicht förderfähig)\"),+(((H73-I73)/1.05)*0.05),+((H73-I73)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H73-I73-J73","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G137=\"Grunderwerb (AFP)\",+G137=\"Grunderwerb (FID)\",+G137=\"Grunderwerb (nicht förderfähig)\"),+(((H137-I137)/1.05)*0.05),+((H137-I137)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H137-I137-J137","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G201=\"Grunderwerb (AFP)\",+G201=\"Grunderwerb (FID)\",+G201=\"Grunderwerb (nicht förderfähig)\"),+(((H201-I201)/1.05)*0.05),+((H201-I201)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H201-I201-J201","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G265=\"Grunderwerb (AFP)\",+G265=\"Grunderwerb (FID)\",+G265=\"Grunderwerb (nicht förderfähig)\"),+(((H265-I265)/1.05)*0.05),+((H265-I265)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H265-I265-J265","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G329=\"Grunderwerb (AFP)\",+G329=\"Grunderwerb (FID)\",+G329=\"Grunderwerb (nicht förderfähig)\"),+(((H329-I329)/1.05)*0.05),+((H329-I329)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H329-I329-J329","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G393=\"Grunderwerb (AFP)\",+G393=\"Grunderwerb (FID)\",+G393=\"Grunderwerb (nicht förderfähig)\"),+(((H393-I393)/1.05)*0.05),+((H393-I393)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H393-I393-J393","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G457=\"Grunderwerb (AFP)\",+G457=\"Grunderwerb (FID)\",+G457=\"Grunderwerb (nicht förderfähig)\"),+(((H457-I457)/1.05)*0.05),+((H457-I457)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H457-I457-J457","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G521=\"Grunderwerb (AFP)\",+G521=\"Grunderwerb (FID)\",+G521=\"Grunderwerb (nicht förderfähig)\"),+(((H521-I521)/1.05)*0.05),+((H521-I521)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H521-I521-J521","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G585=\"Grunderwerb (AFP)\",+G585=\"Grunderwerb (FID)\",+G585=\"Grunderwerb (nicht förderfähig)\"),+(((H585-I585)/1.05)*0.05),+((H585-I585)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H585-I585-J585","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(+G649=\"Grunderwerb (AFP)\",+G649=\"Grunderwerb (FID)\",+G649=\"Grunderwerb (nicht förderfähig)\"),+(((H649-I649)/1.05)*0.05),+((H649-I649)/((1+(Mwst_Satz/100))))*Mwst_Satz/100)","v":0},{"$f":"+H649-I649-J649","v":0}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]

{"sheet":"Zwischennachweis","index":7,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":true,"merged":[[3,1,3,3],[21,1,22,3],[9,1,18,1],[5,1,6,3],[5,6,18,8],[24,1,33,1],[44,6,44,8],[32,2,32,3],[33,2,33,3],[54,2,54,3],[54,6,54,8],[34,1,37,1],[44,2,44,3]]}
["Rheinland-Pfalz"]
[]
[null,{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!$C$3)","v":"Unternehmen: "},null,null,null,null,null,"                         Datum des jeweils geltenden Zuwendungsbescheids:"]
[null,{"$f":"+'I 1'!D6","v":0}]
[]
[1,"Investitionsvolumen",null,null,"lt.\nBewilligung","lt. Anlage \"Ausgaben-gliederung\"","für Vermerke:\n"]
[{"$f":"+A6+1","v":2},null,null,null,"EUR","EUR"]
[3,"Bruttoinvestitionsvolumen (BIV) gesamt",null,null,{"$f":"'I 3'!F61","v":0},{"$f":"Ausgabengliederung!G68","v":0}]
[4,"förderungsfähiges Investitionsvolumen (FIV) gesamt",null,null,{"$f":"+'I 3'!H61","v":0},{"$f":"Ausgabengliederung!H64","v":0},null,null,null,{"$f":"Ausgabengliederung!H31+Ausgabengliederung!H43+Ausgabengliederung!H46+Ausgabengliederung!H48+Ausgabengliederung!H51","v":0}]
[5,"davon den Zuschüssen zugeteiltes FIV ","AFP - Premiumförderung",null,{"$f":"'I 3'!H14","v":0},{"$f":"+Ausgabengliederung!H17","v":0},null,null,null,{"$f":"'I 3'!I61","v":0}]
[6,null,"AFP - Premiumförderung + Stroh",null,{"$f":"'I 3'!H17","v":0},{"$f":"+Ausgabengliederung!H20","v":0}]
[7,null,"AFP - Basisförderung + Erschließung",null,{"$f":"+'I 3'!H20+'I 3'!H22+'I 3'!H25","v":0},{"$f":"+Ausgabengliederung!H23+Ausgabengliederung!H25+Ausgabengliederung!H28","v":0}]
[8,null,"AFP-Junglandwirte",null,{"$f":"+'I 3'!H28","v":0},{"$f":"+Ausgabengliederung!H31","v":0}]
[9,null,"FID-Zuschuss",null,{"$f":"+'I 3'!H31+'I 3'!H34+'I 3'!H37","v":0},{"$f":"+Ausgabengliederung!H34+Ausgabengliederung!H37+Ausgabengliederung!H40","v":0}]
[10]
[11,null,"FIS - Spezialmaschinen",null,{"$f":"+'I 3'!H43","v":0},{"$f":"+Ausgabengliederung!H46","v":0}]
[12,null,"GMOW-Basisinvestition",null,{"$f":"+'I 3'!H45","v":0},{"$f":"+Ausgabengliederung!H48","v":0}]
[13,null,"GMOW-Qualitätsinvestition",null,{"$f":"+'I 3'!H48","v":0},{"$f":"+Ausgabengliederung!H51","v":0}]
[14,null,{"$f":"+'I 4'!C31:D31","v":0}]
[15]
[{"$f":"+A20+1","v":16}]
[17,"Zuwendungen",null,null,"lt. Bewilligung","davon abrufbar","davon ausgezahlt","noch abrufbar","Mittelabruf"]
[18,null,null,null,"EUR","EUR","EUR","EUR","EUR"]
[19,"Zuschüsse insgesamt",null,null,{"$f":"SUM(E25:E34)","v":0},{"$f":"IF(MIN((E24-E32)*0.9+E32,J9-J10+IF(F17>24999,MIN(E32,F17,F9-'I 3'!I61),0))>0,MIN((E24-E32)*0.9+E32,J9-J10+IF(F17>24999,MIN(E32,F17,F9-'I 3'!I61),0)),0)","v":0},{"$f":"SUM(G25:G34)","v":0},{"$f":"F24-G24","v":0},{"$f":"SUM(I25:I34)","v":0}]
[20,"Zuschüsse","AFP - Premiumförderung",null,{"$f":"'I 4'!E22","v":0},null,null,0]
[21,null,"AFP - Basisförderung + Erschließung",null,{"$f":"'I 4'!E23","v":0},null,null,0]
[22,null,"AFP - Premiumförderung + Stroh",null,{"$f":"'I 4'!E24","v":0},null,null,0]
[23,null,"AFP - Junglandwirte",null,{"$f":"'I 4'!E25","v":0},null,null,0]
[24,null,"FID - Zuschuss",null,{"$f":"'I 4'!E26","v":0},null,null,0]
[25,null,null,null,{"$f":"'I 4'!E27","v":0},null,null,0]
[26,null,"FIS - Spezialmaschinen",null,{"$f":"'I 4'!E28","v":0},null,null,0]
[27,null,"GMOW-Basisinvestition",null,{"$f":"'I 4'!E29","v":0},null,null,0]
[28,null,"GMOW-Qualitätsinvestition",null,{"$f":"+'I 4'!E30","v":0},null,null,0]
[29,null,{"$f":"+'I 4'!C31:D31","v":0},null,{"$f":"+E19","v":0},null,null,0]
[30]
[31]
[32]
[33]
[{"$f":"+A38+1","v":34},"Bestätigung des Zuwendungsempfängers:"]
[35,"Die Bestimmungen des Zuwendungsbescheids wurden beachtet. Die Ausgaben waren notwendig. Es wurde wirtschaftlich"]
[36,"und sparsam verfahren. Die Angaben stimmen mit den Büchern und Belegen überein."]
[37]
[38]
[39,null,null,"den, "]
[40,null,"(Ort)",null,"(Datum)",null,"(Unterschrift Zuwendungsempfänger)"]
[{"$f":"+A45+1","v":41}]
[42,"Prüfvermerk des zuständigen Dienstleistungszentrums Ländlicher Raum:"]
[43,"Der Teilverwendungsnachweis wurde anhand der vorliegenden Unterlagen geprüft."]
[44,"Es ergeben sich keine / die aus der Anlage ersichtlichen*) Beanstandungen."]
[45]
[46,null,null,"Die Zuwendungen werden am",null,"über die LBD/Profil-ELER abgerufen."]
[47]
[48]
[49,null,null,"den, "]
[50,null,"(Ort)",null,"(Datum)",null,"(Unterschrift Prüfteam)"]
[51,"*) Nichtzutreffendes bitte streichen"]

{"sheet":"Ausgabengliederung","index":8,"n_rows":68,"n_cols":10,"rows_kept":68,"cut":false,"hidden":false,"merged":[[46,1,51,1],[52,7,62,9],[64,7,67,9],[32,1,43,1],[32,2,34,2],[35,2,37,2],[38,2,40,2],[44,1,45,1],[44,2,45,2],[52,1,62,1],[53,2,54,2],[55,2,56,2],[57,2,58,2],[46,2,48,2],[49,2,51,2],[18,2,20,2],[11,5,12,6],[11,7,12,9],[1,6,1,7],[13,1,13,4],[2,6,2,9],[2,0,2,4],[1,0,1,5],[15,1,31,1],[15,2,17,2],[21,2,23,2],[24,2,25,2],[26,2,28,2]]}
["Anlage \"Ausgabengliederung\""]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "}]
[{"$f":"'I 1'!D6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Ausgaben\nlt. Anlage \"Belegliste\"",null," davon für die Zuwendungsgewährung anzuerkennende Ausgaben"]
[]
[null,"Einzelbereiche der Investition",null,null,null,"Bruttobetrag,\nunbare Eigenleistung","Nettobetrag","Investitions-volumen\nförderfähig","bare\nEigenleistung","Bemessungs-grundlage"]
[null,null,null,null,null,"EUR","EUR","EUR","EUR","EUR"]
[1,"AFP","bauliche Anlagen\nPremiumförderung",{"$f":"+'I 3'!D13","v":0}]
[{"$f":"+A16+1","v":2},null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,Ausgabengliederung!D16,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,Ausgabengliederung!D16,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G17,'I 3'!H14))","v":0},{"$f":"H17*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H17>0,OR($H$17>0,$H$20>0,$H$23>0,$H$25>0,$H$28>0),+$H$17+$H$20+$H$23+$H$25+$H$28>=+'I 3'!K3),(ROUND((H17/($H$17+$H$20+$H$23+$H$25+$H$28))*+'I 3'!K3,)),IF(H17>=+'I 3'!K3,+'I 3'!K3,H17-I17)))","v":0}]
[{"$f":"+A17+1","v":3},null,null,"unbar"]
[4,null,"bauliche Anlagen\nPremium + Stroh",{"$f":"+'I 3'!D16","v":0}]
[5,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D19,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D19,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G20,'I 3'!H17))","v":0},{"$f":"H20*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H20>0,OR($H$17>0,$H$20>0,$H$23>0,$H$25>0,$H$28>0),+$H$17+$H$20+$H$23+$H$25+$H$28>=+'I 3'!K3),(ROUND((H20/($H$17+$H$20+$H$23+$H$25+$H$28))*+'I 3'!K3,)),IF(H20>=+'I 3'!K3,+'I 3'!K3,H20-I20)))","v":0}]
[6,null,null,"unbar"]
[7,null,"bauliche Anlagen\nBasisförderung",{"$f":"+'I 3'!D19","v":0}]
[8,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D22,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D22,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G23,'I 3'!H20))","v":0},{"$f":"H23*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H23>0,OR($H$17>0,$H$20>0,$H$23>0,$H$25>0,$H$28>0),+$H$17+$H$20+$H$23+$H$25+$H$28>=+'I 3'!K3),(ROUND((H23/($H$17+$H$20+$H$23+$H$25+$H$28))*+'I 3'!K3,)),IF(H23>=+'I 3'!K3,+'I 3'!K3,H23-I23)))","v":0}]
[9,null,null,"unbar"]
[10,null,"öffentliche Erschließung","bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+C25,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+C25,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G25,'I 3'!H22))","v":0},{"$f":"H25*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H25>0,OR($H$17>0,$H$20>0,$H$23>0,$H$25>0,$H$28>0),+$H$17+$H$20+$H$23+$H$25+$H$28>=+'I 3'!K3),(ROUND((H25/($H$17+$H$20+$H$23+$H$25+$H$28))*+'I 3'!K3,)),IF(H25>=+'I 3'!K3,+'I 3'!K3,H25-I25)))","v":0}]
[11,null,null,"unbar"]
[12,null,"Maschinen, technische Anlagen",{"$f":"+'I 3'!D24","v":0}]
[13,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D27,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D27,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G28,'I 3'!H25))","v":0},{"$f":"H28*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H28>0,OR($H$17>0,$H$20>0,$H$23>0,$H$25>0,$H$28>0),+$H$17+$H$20+$H$23+$H$25+$H$28>=+'I 3'!K3),(ROUND((H28/($H$17+$H$20+$H$23+$H$25+$H$28))*+'I 3'!K3,)),IF(H28>=+'I 3'!K3,+'I 3'!K3,H28-I28)))","v":0}]
[14,null,null,"unbar",null,null,{"$f":"SUMIF(Belegliste!G9:G700,+D28,Belegliste!K9:K700)","v":0}]
[15,null,"Grunderwerb","bar",null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+C30,\" (AFP)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+C30,\" (AFP)\"),Belegliste!K9:K700)","v":0},"-","-","-"]
[16,null,"Summe AFP","bar",null,{"$f":"F17+F20+F23+F25+F28+F30","v":0},{"$f":"G17+G20+G23+G25+G28+G30","v":0},{"$f":"H17+H20+H23+H25+H28","v":0},{"$f":"I17+I20+I23+I25+I28","v":0},{"$f":"J17+J20+J23+J25+J28","v":0}]
[17,null,null,"unbar",null,{"$f":"F18+F21+F24+F26+F29","v":0}]
[18,"FID","bauliche Anlagen",{"$f":"+'I 3'!D30","v":0}]
[19,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D33,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D33,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G34,'I 3'!H31))","v":0},{"$f":"H34*'I 3'!K5/100","v":0},{"$f":"TRUNC(H34-I34)","v":0}]
[20,null,null,"unbar"]
[21,null,"technische Anlagen",{"$f":"+'I 3'!D33","v":0}]
[22,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D36,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D36,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G37,'I 3'!H34))","v":0},{"$f":"H37*'I 3'!K5/100","v":0},{"$f":"TRUNC(H37-I37)","v":0}]
[23,null,null,"unbar"]
[24,null,"Maschinen",{"$f":"+'I 3'!D36","v":0},null,null,null,null,{"$f":"'I 3'!I17","v":0}]
[25,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D39,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D39,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G40,'I 3'!H37))","v":0},{"$f":"H40*'I 3'!K5/100","v":0},{"$f":"TRUNC(H40-I40)","v":0}]
[26,null,null,"unbar"]
[27,null,"Grunderwerb","bar",null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(C42,\" (FID)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(C42,\" (FID)\"),Belegliste!K9:K700)","v":0},"-","-","-"]
[28,null,"Summe FID","bar",null,{"$f":"+F34+F37+F40+F42","v":0},{"$f":"+G34+G37+G40+G42","v":0},{"$f":"+H34+H37+H40","v":0},{"$f":"+I34+I37+I40","v":0},{"$f":"+J34+J37+J40","v":0}]
[29,null,null,"unbar",null,{"$f":"+F35+F38+F41","v":0}]
[30,"FIS","Spezial-maschinen",{"$f":"+'I 3'!D42","v":0}]
[31,"FIS",null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D45,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D45,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G46,'I 3'!H43))","v":0},null,{"$f":"TRUNC(H46-I46)","v":0}]
[32,"GMO-W","Basisinvestition",{"$f":"+'I 3'!D44","v":0},null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+C47,\" (AFP)\"),Belegliste!H9:H700)","v":0}]
[33,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D47,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D47,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G48,'I 3'!H45))","v":0},{"$f":"H48*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H48>0,OR($H$51>0,$H$48>0),$H$51+$H$48>=+'I 3'!K4),(ROUND((H48/($H$51+$H$48))*+'I 3'!K4,)),IF(H48>=+'I 3'!K4,+'I 3'!K4,H48-I48)))","v":0}]
[34,null,null,"unbar"]
[35,null,"Qualitätsinvestition",{"$f":"+'I 3'!D47","v":0}]
[36,null,null,"bar",null,{"$f":"SUMIF(Belegliste!G9:G700,+D50,Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,+D50,Belegliste!K9:K700)","v":0},{"$f":"TRUNC(MIN(G51,'I 3'!H48))","v":0},{"$f":"H51*'I 3'!K5/100","v":0},{"$f":"TRUNC(IF(AND(H51>0,OR($H$51>0,$H$48>0),$H$51+$H$48>=+'I 3'!K4),(ROUND((H51/($H$51+$H$48))*+'I 3'!K4,)),IF(H51>=+'I 3'!K4,+'I 3'!K4,H51-I51)))","v":0}]
[null,null,null,"unbar"]
[{"$f":"+A51+1","v":37},"nicht förderfähige Investitionen","Grunderwerb","bar",null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C50,\" (nicht förderfähig)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C50,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[38,null,"Wohnhaus","bar",null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C51,\" (nicht förderfähig)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C51,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[39,null,null,"unbar"]
[40,null,"Dauerkulturen","bar",null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C53,\" (nicht förderfähig)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C53,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[41,null,null,"unbar"]
[42,null,"Vieh","Zukauf",null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C55,\" \",+'I 3'!D55,\" (nicht förderfähig)\"),Belegliste!H9:GK700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!C55,\" \",+'I 3'!D55,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[43,null,null,"eigene Aufzucht"]
[44,null,"Pflanzen","unbar"]
[45,null,null,{"$f":"'I 3'!D58","v":0},null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!D58,\" (nicht förderfähig)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!D58,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[46,null,"Sonstiges",{"$f":"'I 3'!D59","v":0},null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!D59,\" (nicht förderfähig)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!D59,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[47,null,null,{"$f":"'I 3'!D60","v":0},null,{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!D60,\" (nicht förderfähig)\"),Belegliste!H9:H700)","v":0},{"$f":"SUMIF(Belegliste!G9:G700,CONCATENATE(+'I 3'!D60,\" (nicht förderfähig)\"),Belegliste!K9:K700)","v":0}]
[48,null,"Summen",null,null,{"$f":"+F31+F43+F46+F48+F51+F53+F54+F56+F58+F61+F62+F63","v":0},{"$f":"+G31+G43+G46+G48+G51+G53+G54+G56+G58+G61+G62+G63","v":0},{"$f":"+H31+H43+H46+H48+H51","v":0},{"$f":"+I31+I43+I46+I48+I51","v":0},{"$f":"+J31+J43+J46+J48+J51","v":0}]
[49,null,"Skonti, Nachlässe und Rabatte",null,null,null,{"$f":"Belegliste!I7","v":0}]
[50,null,"unbare Eigenleistung",null,null,null,{"$f":"F32+F44+F49+F52+F55+F57+F59+F60","v":0}]
[51,null,"Umsatz-, Grunderwerbssteuer",null,null,null,{"$f":"Belegliste!J7","v":0}]
[52,null,"Bruttoinvestitionsvolumen",null,null,null,{"$f":"G67+G66+G65+G64","v":0}]

{"sheet":"Einnahmen-Ausgaben","index":9,"n_rows":54,"n_cols":52,"rows_kept":54,"cut":false,"hidden":true,"merged":[[35,6,35,7],[36,6,36,7],[12,6,12,7],[33,6,33,7],[16,2,16,3],[14,2,14,3],[15,2,15,3],[15,6,15,7],[5,1,11,1],[31,2,31,3],[30,2,30,3],[14,1,18,1],[17,2,17,3],[53,6,53,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[2,0,2,3],[48,6,48,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[13,6,13,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[49,6,49,7],[51,1,53,1],[47,1,49,1],[51,6,51,7],[52,6,52,7],[14,6,14,7],[50,6,50,7],[35,1,41,1],[19,6,19,7],[22,1,31,1],[37,6,37,7],[34,6,34,7],[43,6,43,7],[42,6,42,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[11,6,11,7],[7,6,7,7]]}
["Anlage \"Einnahmen- und Ausgabenübersicht\""]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "}]
[{"$f":"'I 1'!D6","v":0}]
[null,"Eigenleistungen",null,null,"lt. Abrechnungs-unterlagen","lt.\nBewilligung","Saldo (+ / -)",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,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[1,null,null,null,"EUR","EUR","EUR"]
[{"$f":"A5+1","v":2},"bare\n Eigenmittel","Zur Finanzierung verwendet",null,null,{"$f":"+'I 4'!E7","v":0},{"$f":"+E6-F6","v":0}]
[3,null,"Guthaben",null,null,{"$f":"+'I 4'!E8","v":0},0]
[4,null,{"$f":"+'I 4'!C9","v":"Verkauf von Grundstücken"},null,null,{"$f":"+'I 4'!E9","v":0},0]
[5,null,{"$f":"+'I 4'!C10","v":"Verkauf der Althofstelle, Gebäude"},null,null,{"$f":"+'I 4'!E10","v":0},0]
[6,null,{"$f":"+'I 4'!C11","v":"Verkauf von Betr.vorr., Maschinen"},null,null,{"$f":"+'I 4'!E11","v":0},0]
[7,null,"Abgänge Vieh",null,null,{"$f":"+'I 4'!E12","v":0},0]
[8,null,"Abgänge Umlaufvermögen",null,null,{"$f":"+'I 4'!E13","v":0},0]
[{"$f":"A12+1","v":9},null,"Summe bare Eigenmittel",null,{"$f":"SUM(E6:E12)","v":0},{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:H12)","v":0}]
[10,null,"Summe eigene Aufzucht, Pflanzen und DK",null,{"$f":"Ausgabengliederung!F59+Ausgabengliederung!F60+Ausgabengliederung!F57","v":0},{"$f":"+'I 4'!E15","v":0},{"$f":"+E14-F14","v":0}]
[11,"unbare Eigenleistungen","AFP",null,{"$f":"Ausgabengliederung!F32","v":0},{"$f":"+'I 4'!E16","v":0},{"$f":"+E15-F15","v":0},null,null,{"$f":"IF(H15>E15,H15-G15,)","v":0}]
[12,null,"FID",null,{"$f":"+Ausgabengliederung!F44","v":0},{"$f":"+'I 4'!E17","v":0},{"$f":"+E16-F16","v":0}]
[{"$f":"A15+1","v":12},null,"GMO-W",null,{"$f":"+Ausgabengliederung!F49+Ausgabengliederung!F52","v":0},{"$f":"+'I 4'!E18","v":0},{"$f":"+E17-F17","v":0}]
[{"$f":"A16+1","v":13},null,"Wohnhaus",null,{"$f":"+Ausgabengliederung!F55","v":0},{"$f":"+'I 4'!E19","v":0},{"$f":"+E18-F18","v":0}]
[14,null,"Summe unbare Eigenleistungen",null,{"$f":"SUM(E15:E18)","v":0},{"$f":"SUM(F15:F18)","v":0},{"$f":"SUM(G15:H18)","v":0}]
[{"$f":"+A19+1","v":15},"Summe Eigenleistungen",null,null,{"$f":"+E13+E14+E19","v":0},{"$f":"+F13+F14+F19","v":0},{"$f":"+G19+G14+G13","v":0}]
[{"$f":"+A20+1","v":16},"Zuwendungen",null,null,"lt. Anlage \"Ausgaben-gliederung\" (Bemessungsgrundlage)","ausgezahlte Zuwendungen","noch abrufbare Zuwendungen","Rückforderung"]
[17,null,null,null,"EUR","EUR","EUR","EUR"]
[18,"Zuschüsse","AFP - Premiumförderung",null,null,0,{"$f":"IF(E23-F23>0,E23-F23,)","v":0},{"$f":"IF(E23-F23<0,F23-E23,)","v":0}]
[19,null,"AFP - Basisförderung + Erschließung",null,null,0,{"$f":"IF(E24-F24>0,E24-F24,)","v":0},{"$f":"IF(E24-F24<0,F24-E24,)","v":0}]
[20,null,"AFP - Premiumförderung + Stroh",null,null,0,0,0]
[21,null,"AFP - Junglandwirte",null,null,0,0,0]
[22,null,"FID",null,null,0,0,0]
[23,null,null,null,null,0,0,0]
[24,null,"FIS - Spezialmaschinen",null,null,0,0,0]
[25,null,"GMOW-Basisinvestition",null,null,0,0,0]
[26,null,"GMOW-Qualitätsinvestition",null,null,0,0,0]
[27,null,{"$f":"+Zwischennachweis!C34","v":0},null,{"$f":"+Zwischennachweis!E34","v":0},0,0,0]
[28,"Summe Zuwendungen",null,null,{"$f":"SUM(E23:E32)","v":0},{"$f":"SUM(F23:F32)","v":0},{"$f":"SUM(G23:G32)","v":0},{"$f":"SUM(H23:H32)","v":0}]
[29,"Darlehen",null,null,"lt. Abrechnungs-unterlagen","lt.\nBewilligung","Saldo (+ / -)",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,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[30,null,null,null,"EUR","EUR","EUR"]
[31,"Darlehensaufnahmen",{"$f":"+'I 4'!C33","v":0},null,null,{"$f":"+'I 4'!E33","v":0},{"$f":"+E36-F36","v":0}]
[32,null,{"$f":"+'I 4'!C34","v":0},null,null,{"$f":"+'I 4'!E34","v":0},{"$f":"+E37-F37","v":0}]
[33,null,{"$f":"+'I 4'!C35","v":0},null,null,{"$f":"+'I 4'!E35","v":0},0]
[34,null,{"$f":"+'I 4'!C36","v":0},null,null,{"$f":"+'I 4'!E36","v":0},0]
[35,null,{"$f":"+'I 4'!C37","v":0},null,null,{"$f":"+'I 4'!E37","v":0},0]
[36,null,{"$f":"+'I 4'!C38","v":0},null,null,{"$f":"+'I 4'!E38","v":0},0]
[37,null,{"$f":"+'I 4'!C39","v":0},null,null,{"$f":"+'I 4'!E39","v":0},0]
[38,"Summe Darlehen",null,null,{"$f":"SUM(E36:E42)","v":0},{"$f":"SUM(F36:F42)","v":0},{"$f":"SUM(G36:H42)","v":0}]
[39,"Summe Einnahmen",null,null,{"$f":"E43+E33+E20","v":0},{"$f":"+F20+E53+F43","v":0}]
[40," Einnahmen- / Ausgabenvergleich",null,null,"lt.\nBewilligung","lt. \nAbrechnungs-unterlagen","Saldo (+ / -)"]
[41,null,null,null,"EUR","EUR","EUR"]
[42,"Summe Ausgaben",null,null,{"$f":"+'I 3'!F61","v":0},{"$f":"+Ausgabengliederung!G68-Ausgabengliederung!G65","v":0},{"$f":"+F47-E47","v":0}]
[43,"davon","förderfähige Ausgaben",null,{"$f":"+'I 3'!H61","v":0},{"$f":"+Ausgabengliederung!H64","v":0},{"$f":"+F48-E48","v":0}]
[44,null,"bare Leistungen",null,{"$f":"+'I 3'!I61","v":0},{"$f":"+Ausgabengliederung!I64","v":0},0]
[45,null,"Bemessungsgrundlage",null,{"$f":"+'I 3'!J61","v":0},{"$f":"+Ausgabengliederung!J64","v":0},0]
[46,"Summe Einnahmen",null,null,{"$f":"+'I 4'!E41","v":0},{"$f":"+E44","v":0},0]
[47,"davon","Eigenleistungen",null,{"$f":"+'I 4'!E21","v":0},{"$f":"+E20","v":0},0]
[48,null,"Zuschüsse",null,{"$f":"+'I 4'!E32","v":0},{"$f":"+E33","v":0},0]
[49,null,"Darlehen",null,{"$f":"+'I 4'!E40","v":0},{"$f":"+E43","v":0},0]

{"sheet":"Schlussverwendung","index":10,"n_rows":123,"n_cols":8,"rows_kept":123,"cut":false,"hidden":true,"merged":[[120,1,120,2],[120,6,120,7],[17,2,17,3],[18,2,18,3],[119,1,119,2],[119,6,119,7],[82,6,82,7],[81,1,81,2],[48,1,48,7],[107,1,107,2],[19,2,19,3],[20,2,20,3],[44,1,44,7],[57,1,57,7],[81,6,81,7],[35,3,35,6],[0,0,0,7],[107,6,107,7],[106,6,106,7],[106,1,106,2],[33,3,33,6],[34,3,34,6],[36,3,36,6],[37,3,37,6],[14,1,14,7],[16,2,16,3],[2,1,2,3],[95,6,95,7],[94,6,94,7],[94,1,94,2],[82,1,82,2],[95,1,95,2],[49,1,49,7],[50,1,50,7],[51,1,51,7],[47,1,47,7],[45,1,45,7],[46,1,46,7]]}
["Verwendungsnachweis\nbetr. „Förderung von einzelbetrieblichen Investitionen in der Landwirtschaft \n(Einzelbetriebliches Förderungsprogramm - EFP)“ 1) und\nder \"Gemeinsamen Marktorganisation Wein\""]
[null,{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "}]
[null,{"$f":"+'I 1'!D6","v":0}]
[]
[null,"An das"]
[null,{"$f":"CONCATENATE(\"DLR Mosel, Abteilung 'Einzelbetriebliche Förderung und Marktförderung', Dienstsitz \",'I 1'!H3)","v":"DLR Mosel, Abteilung 'Einzelbetriebliche Förderung und Marktförderung', Dienstsitz "}]
[]
[null,"Durch Zuwendungsbescheid"]
[null,"vom",null,"mit Az.:",null,","]
[null,"geändert durch Zuwendungsbescheid(e)"]
[null,"vom",null,"mit Az.:",null,","]
[null,"vom",null,"mit Az.:",null,","]
[null,"vom",null,"mit Az.:",null,","]
[null,"wurden zur Finanzierung der geförderten Maßnahmen"]
[]
[null,"folgende Zuwendungen bewilligt:",null,null,null,"davon ausgezahlt / zur Auszahlung beantragt:"]
[null,"1.",null,null,"EUR",null,null,"EUR"]
[null,"2.",null,null,"EUR",null,null,"EUR"]
[null,"3.",null,null,"EUR",null,null,"EUR"]
[null,"4.",null,null,"EUR",null,null,"EUR"]
[null,"5.",null,null,"EUR",null,null,"EUR"]
[]
[null,"Folgende Anlagen sind Bestandteil dieses abschließenden zusammenfassenden Verwendungs-"]
[null,"nachweises:"]
[null,"  -    zahlenmäßiger Nachweis der Verwendung durch:"]
[]
[]
[]
[]
[null,"  -    aufgrund sonstiger Zuwendungsbestimmungen (gemäß o.g. Zuwendungsbescheid) vozulegende Unterlagen:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sachbericht:"]
[null,"Die durchgeführten Maßnahmen wurden"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"( Falls weitere Erläuterungen erforderlich sind, sind diese auf einen gesonderten Blatt abzugeben und vorzulegen.) "]
[]
[]
[]
[]
[null,"1) Verwaltungsvorschrift (VV) des Ministeriums für Wirtschaft, Verkehr, Landwirtschaft und Weinbau Rheinland-Pfalz in  \n   der jeweils geltenden Fassung"]
[null,"Bestätigungen / Erklärungen der Zuwendungsempfänger:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,", den"]
[null,"(Ort)",null,null,"(Datum)",null,"(Unterschrift Zuwendungsempfänger)"]
[]
[]
[]
[null,"Bei Baumaßnahmen Ergebnis der baufachlichen Prüfung:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,", den"]
[null,"(Ort)",null,null,"(Datum)",null,"(Unterschrift Bauleiter)"]
[]
[]
[]
[null,"  Prüfvermerk des zuständigen Prüfteams:"]
[]
[]
[]
[]
[]
[]
[null,null,null,", den"]
[null,"(Ort)",null,null,"(Datum)",null,"(Unterschrift Prüfteam)"]
[]
[null," 2) Nichtzutreffendes bitte streichen und ggf. Anlage beifügen"]
[]
[]
[null,"  Prüfvermerk der zuständigen Bewilligungsstelle:"]
[]
[]
[]
[]
[]
[]
[null,null,null,", den"]
[null,"(Ort)",null,null,"(Datum)",null,"(Unterschrift Bewilligungsstelle)"]
[]
[null," 2) Nichtzutreffendes bitte streichen und ggf. Anlage beifügen"]

{"sheet":"Evaluierung","index":11,"n_rows":635,"n_cols":35,"rows_kept":635,"cut":false,"hidden":false,"merged":[]}
["VARIABLENLISTE"]
[]
[null,"Allgemeines/Faktorausstattung/Betriebsspiegel"]
[]
["NR",null,null,null,null,"Code BML-Abschluss"]
[1,null,"EU-Fördernummer (12-stellig)",null,null,null,null,"Nr.",{"$f":"CONCATENATE(+'I 1'!C6,0,+'I 1'!D6)","v":"2760"}]
[2,null,"Buchstelle",null,null,"0001/2",null,"Nr.",{"$f":"'I 1'!K3","v":0}]
[3,null,"Betriebsnummer bei der Buchstelle",null,null,"0002/2",null,"Nr."]
[4,null,"Bundesland",null,null,"0003/2",null,"Nr.","07"]
[5,null,"Regierungsbezirk",null,null,"0004/2",null,"Nr."]
[6,null,"Landkreisnummer",null,null,"0005/2",null,"Nr.",{"$f":"MID(+'I 1'!D6,2,3)","v":""}]
[7,null,"Datum der IK-Erstellung",null,null,null,null,"Datum"]
[8,null,"Datum der IK-Ergänzung",null,null,null,null,"Datum"]
[9,null,"Datum der Antragstellung",null,null,null,null,"Datum",{"$f":"'I 1'!H5","v":"00:00:00"}]
[10,null,"Datum der Antragbewilligung",null,null,null,null,"Datum"]
[11,null,"Benachteiligtes Gebiet (entspr. Monitoring)",null,null,null,null,"Code",1]
[12,null,"Rechtsform",null,null,null,null,"Code"]
[13,null,"Betriebszusammenschluss",null,null,null,null,"Code"]
[14,null,null,"Anzahl der Ausgangsbetriebe",null,null,null,"Anzahl",null,"Produktionsrichtung",null,"Benacht. Gebiet",null,"Rechtsform",null,"Betriebszus.-schluss",null,"Sozialökonom. Typ",null,"Bewirtschaftungsform",null,"Verbuchung",null,"Umsatzsteuer",null,"Aussiedlung",null,"Schutzgebiet",null,"Geschlecht",null,"Ausbildung",null,"Folgemaßnahme"]
[15,null,null,"Jahr des Zusammenschlusses",null,null,null,"Jahr",null,"Ackerbau",1,"Normalgebiet",0,"Einzelunternehmen",1,"Nein",1,"Haupterwerb",1,"Konventionell",0,"Brutto",1,"Pauschalierung",1,"Nein",0,"Ja",1,"Männlich",1,"LW: Fachschule",1,"Ausgleichsmaßnahmen",1]
[16,null,"Sozialökonom. Betriebstyp",null,null,"0018/2",null,"Code",null,"Gartenbau",2,"Berggebiet",1,"Familien-GbR",2,"Teilweise",2,"Nebenerwerb",2,"Ökologisch",1,"Netto",2,"Regelbesteuerg.",2,"Vollaussiedlung",1,"Nein",0,"Weiblich",2,"LW: Meister",2,"Ersatzmaßnahmen",2]
[17,null,"Hauptproduktionsrichtung (entspr. Monitoring)",null,null,null,null,"Code",null,"Weinbau",3,"Sonst. ben. Gebiet",2,"Fremd-GbR",3,"Vollständig",3,null,null,"Ökolog. in Umstellung",2,null,null,"Kleinunternehmer",3,"Teilaussiedlung",2,null,null,null,null,"LW: FH/Uni",3,"Ersatzgeld/ Ausgleichsabgabe",3]
[18,null,"Bewirtschaftungsform",null,null,"0023/2",null,"Code",null,"Obstbau",4,"Gebiet mit spez. Nachteilen",3,"GmbH&Co KG",4,null,null,null,null,null,null,null,null,null,null,"B-Zweigaussiedlung",3,null,null,null,null,"NLW: Fachschule",4,"Sonstiges",4]
[19,null,null,"Jahr der Umstellung",null,null,null,"Jahr",null,"Sonst. Betriebe",5,null,null,"GmbH",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NLW: Meister",5]
[20,null,"Brutto-/Nettoverbuchung",null,null,"0027/2",null,"Code",null,"Milchviehhaltung",6,null,null,"Genossenschaft (eG)",6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NLW: FH/Uni",6]
[21,null,"Umsatzsteuersystem",null,null,null,null,"Code",1,"Mastviehhaltung",7,null,null,"Aktiengesellschaft",7]
[22,null,"Abschlussstichtag",null,null,null,null,"Datum",null,"Schweinezucht",8,null,null,"Sonstiges",8]
[23,null,"IST-Jahr des Investitionskonzeptes",null,null,null,null,"Jahr",{"$f":"+'I 1'!E9","v":"00:00:00"},"Geflügelzucht",9]
[24,null,"ZIEL-Jahr des Investitionskonzeptes",null,null,null,null,"Jahr",{"$f":"+'I 1'!G9","v":"00:00:00"},"Sonst. Tierhaltung",10]
[25,null,"Beginn der geförderten Investition (Plan)",null,null,null,null,"Datum",null,"Sonstige",11]
[26,null,"Abschluss der geförderten Investition (Plan)",null,null,null,null,"Datum"]
[27,null,"Aussiedlung ",null,null,null,null,"Code"]
[28,null,"Ø Ackerzahl",null,null,null,null,"Zahl"]
[29,null,"Ø Grünlandzahl",null,null,null,null,"Zahl"]
[30]
[31,"Schutzgebietskategorien (Standort des baul. Investitionsobjektes)"]
[32,null,"Natura-2000-Gebiet",null,null,null,null,"ja=1; nein=0"]
[33,null,"Wasserschutzgebiet",null,null,null,null,"ja=1; nein=0"]
[34,null,"Naturschutzgebiet",null,null,null,null,"ja=1; nein=0"]
[35,null,"Landschaftsschutzgebiet",null,null,null,null,"ja=1; nein=0"]
[36]
[37,"Betriebsleiter/in"]
[38,null,"BL_1: Jahr d. Hofübernahme",null,null,null,null,"Jahr",{"$f":"IF(+'I 1'!G7<>0,+'I 1'!G7,\" \")","v":" "}]
[39,null,"BL_1: Alter ",null,null,null,null,"Alter",{"$f":"+'I 1'!C8","v":0}]
[40,null,"BL_1: Geschlecht ",null,null,null,null,"M=1;W=2",2]
[41,null,"BL_1: Ausbildung",null,null,null,null,"Code"]
[42,null,"BL_2: Jahr d. Hofübernahme",null,null,null,null,"Jahr"]
[43,null,"BL_2: Alter",null,null,null,null,"Alter"]
[44,null,"BL_2: Geschlecht ",null,null,null,null,"M=1;W=2"]
[45,null,"BL_2: Ausbildung",null,null,null,null,"Code"]
[46]
[47,"Hauptziele der zu fördernden Investition"]
[48]
[49,"Verbesserung"]
[50,null,"a) des Einkommens durch:"]
[51,null,"-","Rationalisierung",null,null,null,"(0-5)"]
[52,null,"-","Aufstockung",null,null,null,"(0-5)"]
[53,null,"-","Diversifizierung",null,null,null,"(0-5)"]
[54,null,"-","Qualitätsverbesserung",null,null,null,"(0-5)"]
[55,null,"b) des Umweltschutzes durch"]
[56,null,"-","Energieeinsparung",null,null,null,"(0-5)"]
[57,null,"-","Lärmreduzierung",null,null,null,"(0-5)"]
[58,null,"-","Emmissionsminderung",null,null,null,"(0-5)"]
[59,null,"-","Wasserverbrauch",null,null,null,"(0-5)"]
[60,null,"c) der Arbeitsbedingungen durch Verminderung von"]
[61,null,"-","Staub",null,null,null,"(0-5)"]
[62,null,"-","schädliche Stoffe",null,null,null,"(0-5)"]
[63,null,"-","Gerüche",null,null,null,"(0-5)"]
[64,null,"-","Heben schwerer Lasten",null,null,null,"(0-5)"]
[65,null,"-","klimatisch extremer Bedingungen",null,null,null,"(0-5)"]
[66,null,"-","ungünstigen Arbeitszeiten",null,null,null,"(0-5)"]
[67,null,"d) des Tierschutzes (v.a.Haltungsbedingungen)",null,null,null,null,"(0-5)"]
[68,null,"e) der Tierhygiene",null,null,null,null,"(0-5)"]
[69]
[70,"Betriebsflächen"]
[71,null,"Ackerfläche",null,"Bewirtschaftet","6100/7","IST (t)","ha LF",{"$f":"+'I 1'!E11","v":0}]
[72,null,"Dauergrünland",null,"Bewirtschaftet","6104/7","IST (t)","ha LF",{"$f":"+'I 1'!E12","v":0}]
[73,null,"sonstige LF",null,"Bewirtschaftet","6119/7-(6100/7+6104/7)","IST (t)","ha LF",{"$f":"+'I 1'!E13+'I 1'!E14+'I 1'!E15","v":0}]
[74,null,"LF insgesamt",null,"Bewirtschaftet","6119/7","IST (t)","ha LF",{"$f":"+'I 1'!E16","v":0}]
[75,null,"LF insgesamt",null,"Eigentum","6119/2","IST (t)","ha LF",{"$f":"+'I 1'!D16","v":0}]
[76,null,"Forstw. Nutzfläche",null,"Bewirtschaftet","6122/7","IST (t)","ha LF",{"$f":"+'I 1'!E17","v":0}]
[77,null,"Sonstige Flächen",null,"Bewirtschaftet","6121/7+6128/7","IST (t)","ha LF",{"$f":"+'I 1'!E18","v":0}]
[78,null,"Betriebsfläche",null,"Bewirtschaftet","6129/7","IST (t)","ha LF",{"$f":"+'I 1'!E19","v":0}]
[79]
[80,null,"Ackerfläche",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G11","v":0}]
[81,null,"Dauergrünland",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G12","v":0}]
[82,null,"sonstige LF",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G13+'I 1'!G14+'I 1'!G15","v":0}]
[83,null,"LF insgesamt",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G16","v":0}]
[84,null,"LF insgesamt",null,"Eigentum",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!F16","v":0}]
[85,null,"Forstw. Nutzfläche",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G17","v":0}]
[86,null,"Sonstige Flächen",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G18","v":0}]
[87,null,"Betriebsfläche",null,"Bewirtschaftet",null,"ZIEL (t+x)","ha LF",{"$f":"+'I 1'!G19","v":0}]
[88]
[89,"Lieferrechte"]
[90,null,"Milchreferenzmenge",null,null,"8020/2","IST (t)","kg",{"$f":"+'I 1'!J10","v":0}]
[91,null,"     davon gepachtet",null,null,"8021/2","IST (t)","kg",{"$f":"+'I 1'!J11","v":0}]
[92,null,"Mutterkuhprämie",null,null,"8028/2","IST (t)","Prämienrechte",{"$f":"+'I 1'!J12","v":0}]
[93,null,"Weinquote (Tafelwein)",null,null,"8030/2","IST (t)","hl",{"$f":"+'I 1'!J13","v":0}]
[94,null,"A-Rüben",null,null,"8031/2","IST (t)","dt",{"$f":"+'I 1'!J14","v":0}]
[95,null,"Stärkekartoffeln",null,null,"8033/2","IST (t)","dt",{"$f":"+'I 1'!J16","v":0}]
[96]
[97,null,"Milchreferenzmenge",null,null,null,"ZIEL (t+x)","kg",{"$f":"+'I 1'!K10","v":0}]
[98,null,"     davon gepachtet",null,null,null,"ZIEL (t+x)","kg",{"$f":"+'I 1'!K11","v":0}]
[99,null,"Mutterkuhprämie",null,null,null,"ZIEL (t+x)","Prämienrechte",{"$f":"+'I 1'!K12","v":0}]
[100,null,"Weinquote (Tafelwein)",null,null,null,"ZIEL (t+x)","hl",{"$f":"+'I 1'!K13","v":0}]
[101,null,"A-Rüben",null,null,null,"ZIEL (t+x)","dt",{"$f":"+'I 1'!K14","v":0}]
[102,null,"Stärkekartoffeln",null,null,null,"ZIEL (t+x)","dt",{"$f":"+'I 1'!K16","v":0}]
[103]
[104,null,"Tierproduktion, insgesamt",null,null,null,"IST (t)","GVE",{"$f":"'GV-Berechnung'!E44","v":0}]
[105,null,"  davon Rinder",null,null,null,"IST (t)","GVE",{"$f":"'GV-Berechnung'!E20+'GV-Berechnung'!E21+'GV-Berechnung'!E22+'GV-Berechnung'!E23+'GV-Berechnung'!E24","v":0}]
[106,null,"Tierproduktion, insgesamt",null,null,null,"ZIEL (t+x)","GVE",{"$f":"'GV-Berechnung'!H44","v":0}]
[107,null,"  davon Rinder",null,null,null,"ZIEL (t+x)","GVE",{"$f":"'GV-Berechnung'!H20+'GV-Berechnung'!H21+'GV-Berechnung'!H22+'GV-Berechnung'!H23+'GV-Berechnung'!H24","v":0}]
[108]
[109,"Pflanzenproduktion in ha"]
[110,null,"Winterweizen",null,null,"4001/2","IST (t)","ha LF"]
[111,null,"Wintergerste",null,null,"4005/2","IST (t)","ha LF"]
[112,null,"Sonstiges Getreide",null,null,"4024/2","IST (t)","ha LF"]
[113,null,"Nachwachsende Rohstoffe",null,null,"4064/2 bis 4067/2","IST (t)","ha LF"]
[114,null,"Stilllegungsfläche (ohne NaRo)",null,null,"4096/2 bis 4097/2","IST (t)","ha LF"]
[115,null,"Pflanzenproduktion, insges.",null,null,null,"IST (t)","Akh",{"$f":"+'I 1'!G22+'I 1'!G23+'I 1'!G24+'I 1'!G25+'I 1'!G26+'I 1'!G27+'I 1'!G28+'I 1'!G29+'I 1'!G30+'I 1'!G32+'I 1'!G33+'I 1'!G34+'I 1'!G35+'I 1'!G36","v":0}]
[116]
[117,null,"Winterweizen",null,null,null,"ZIEL (t+x)","ha LF"]
[118,null,"Wintergerste",null,null,null,"ZIEL (t+x)","ha LF"]
[119,null,"Sonstiges Getreide",null,null,null,"ZIEL (t+x)","ha LF"]
[120,null,"Nachwachsende Rohstoffe",null,null,null,"ZIEL (t+x)","ha LF"]
[121,null,"Stilllegungsfläche  (ohne NaRo)",null,null,null,"ZIEL (t+x)","ha LF"]
[122,null,"Pflanzenproduktion, insges.",null,null,null,"ZIEL (t+x)","Akh",{"$f":"+'I 1'!K22+'I 1'!K23+'I 1'!K24+'I 1'!K25+'I 1'!K26+'I 1'!K27+'I 1'!K28+'I 1'!K29+'I 1'!K30+'I 1'!K32+'I 1'!K33+'I 1'!K34+'I 1'!K35+'I 1'!K36","v":0}]
[123]
[124,"Obst-/ Gemüse-/ Garten- und Weinbau"]
[125,null,"Obstbau",null,null,"4209/2","IST (t)","ha"]
[126,null,"Gemüsebau",null,null,"4050/2 bis 4057/2","IST (t)","ha"]
[127,null,"Gartenbau (incl. Baumschule)",null,null,"4269/2","IST (t)","ha"]
[128,null,"Weinbau ",null,null,"4299/2","IST (t)","ha"]
[129]
[130,null,"Obstbau",null,null,null,"IST (t)","Akh  "]
[131,null,"Gemüsebau",null,null,null,"IST (t)","Akh  "]
[132,null,"Gartenbau (incl. Baumschule)",null,null,null,"IST (t)","Akh  "]
[133,null,"Weinbau ",null,null,null,"IST (t)","Akh  "]
[134]
[135,null,"Obstbau",null,null,null,"ZIEL (t+x)","ha"]
[136,null,"Gemüsebau",null,null,null,"ZIEL (t+x)","ha"]
[137,null,"Gartenbau (incl. Baumschule)",null,null,null,"ZIEL (t+x)","ha"]
[138,null,"Weinbau ",null,null,null,"ZIEL (t+x)","ha"]
[139]
[140,null,"Obstbau",null,null,null,"ZIEL (t+x)","Akh  "]
[141,null,"Gemüsebau",null,null,null,"ZIEL (t+x)","Akh  "]
[142,null,"Gartenbau (incl. Baumschule)",null,null,null,"ZIEL (t+x)","Akh  "]
[143,null,"Weinbau ",null,null,null,"ZIEL (t+x)","Akh  "]
[144]
[145]
[146,"Tierproduktion"]
[147,null,"Pferde",null,null,"3109/9","IST (t)","Ø Jahresbestand"]
[148,null,"Milchkühe",null,null,"3116/9","IST (t)","Ø Jahresbestand"]
[149,null,"Milchleistung",null,null,"4116/2","IST (t)","kg Milch/Kuh"]
[150,null,"Jungvieh (Rinder)",null,null,null,"IST (t)","Ø Jahresbestand"]
[151,null,"Mastrinder",null,null,"3110/9+(3121/9 bis 3124/9)","IST (t)","Ø Jahresbestand"]
[152,null,"Mutterkühe",null,null,"3117/9","IST (t)","Ø Jahresbestand"]
[153,null,"Mastschweine ",null,null,"3133/9+3134/9","IST (t)","Ø Jahresbestand"]
[154,null,"Zuchtsauen",null,null,"3136/9","IST (t)","Ø Jahresbestand"]
[155,null,"Zuchtleistung Zuchtsauen",null,null,"4136/2","IST (t)","aufgez. Ferkel/ZS"]
[156,null,"Mutterschafe",null,null,"3149/9","IST (t)","Ø Jahresbestand"]
[157,null,"Legehennen",null,null,"3152/9","IST (t)","Ø Jahresbestand"]
[158,null,"Mastgeflügel",null,null,"3153/9 bis 3156/9","IST (t)","Ø Jahresbestand"]
[159]
[160,null,"Tierproduktion, insgesamt",null,null,null,"IST (t)","Akh",{"$f":"+'I 1'!G38+'I 1'!G39+'I 1'!G40+'I 1'!G41+'I 1'!G42+'I 1'!G43","v":0}]
[161]
[162,null,"Pferde",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[163,null,"Milchkühe",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[164,null,"Milchleistung",null,null,null,"ZIEL (t+x)","kg Milch/Kuh"]
[165,null,"Jungvieh (Rinder)",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[166,null,"Mastrinder",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[167,null,"Mutterkühe",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[168,null,"Mastschweine ",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[169,null,"Zuchtsauen",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[170,null,"Zuchtleistung Zuchtsauen",null,null,null,"ZIEL (t+x)","aufgez. Ferkel/ZS"]
[171,null,"Mutterschafe",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[172,null,"Legehennen",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[173,null,"Mastgeflügel",null,null,null,"ZIEL (t+x)","Ø Jahresbestand"]
[174]
[175,null,"Tierproduktion, insgesamt",null,null,null,"ZIEL (t+x)","Akh",{"$f":"+'I 1'!K38+'I 1'!K39+'I 1'!K40+'I 1'!K41+'I 1'!K42+'I 1'!K43","v":0}]
[176]
[177,"Handel, Dienstleistung, Nebenbetriebe  (Diversifikation)"]
[178,null,"Direktvermarktung",null,null,null,"IST (t)","Akh  "]
[179,null,"Lohnarbeit (für and. Landwirte)",null,null,null,"IST (t)","Akh  "]
[180,null,"Fremdenverkehr",null,null,null,"IST (t)","Akh  "]
[181,null,"Landschaftspflege (für Nicht-Landwirte)",null,null,null,"IST (t)","Akh  "]
[182,null,"sonstiges",null,null,null,"IST (t)","Akh  "]
[183]
[184,null,"Direktvermarktung",null,null,null,"ZIEL (t+x)","Akh  "]
[185,null,"Lohnarbeit (für and. Landwirte)",null,null,null,"ZIEL (t+x)","Akh  "]
[186,null,"Fremdenverkehr",null,null,null,"ZIEL (t+x)","Akh  "]
[187,null,"Landschaftspflege (für Nicht-Landwirte)",null,null,null,"ZIEL (t+x)","Akh  "]
[188,null,"sonstiges",null,null,null,"ZIEL (t+x)","Akh  "]
[189]
[190,"Forstwirtschaft",null,null,null,null,"IST (t)","Akh  "]
[191,"Betriebsleitung",null,null,null,null,"IST (t)","Akh  ",{"$f":"+'I 1'!G52","v":0}]
[192,"sonstiges",null,null,null,null,"IST (t)","Akh  "]
[193]
[194,"Forstwirtschaft",null,null,null,null,"ZIEL (t+x)","Akh  "]
[195,"für Betriebsleitung",null,null,null,null,"ZIEL (t+x)","Akh  ",{"$f":"+'I 1'!K52","v":0}]
[196,"sonstiges",null,null,null,null,"ZIEL (t+x)","Akh  "]
[197]
[198,"kalk. Arbeitszeitbedarf insges.",null,null,null,null,"IST (t)","Akh  ",{"$f":"+'I 1'!G53","v":0}]
[199,"betr.-notw. Voll-AK (2100 Akh/J.)",null,null,null,null,"IST (t)","Akh  ",{"$f":"+'I 1'!G54","v":0}]
[200,"tatsächliche Zahl der Voll-AK",null,null,null,null,"IST (t)","VollAk",{"$f":"+'I 1'!E60","v":0}]
[201,"davon:"]
[202,null,"nicht entlohnte Familien-AK",null,null,null,"IST (t)","VollAk",{"$f":"+'I 1'!E57","v":0}]
[203,null,"entlohnte Familien-AK",null,null,null,"IST (t)","VollAk",{"$f":"+'I 1'!G58","v":0}]
[204,null,"Fremd-AK",null,null,null,"IST (t)","VollAk",{"$f":"+'I 1'!E59","v":0}]
[205,null,"Frauen-AK",null,null,null,"IST (t)","VollAk"]
[206]
[207,"kalk. Arbeitszeitbedarf insges.",null,null,null,null,"ZIEL (t+x)","Akh  ",{"$f":"+'I 1'!K53","v":0}]
[208,"betr.-notw. Voll-AK (2100 Akh/J.)",null,null,null,null,"ZIEL (t+x)","Akh  ",{"$f":"+'I 1'!K54","v":0}]
[209,"tatsächliche Zahl der Voll-AK",null,null,null,null,"ZIEL (t+x)","VollAk",{"$f":"+'I 1'!G60","v":0}]
[210,"davon:"]
[211,null,"nicht entlohnte Familien-AK",null,null,null,"ZIEL (t+x)","VollAk",{"$f":"+'I 1'!G57","v":0}]
[212,null,"entlohnte Familien-AK",null,null,null,"ZIEL (t+x)","VollAk",{"$f":"+'I 1'!G58","v":0}]
[213,null,"Fremd-AK",null,null,null,"ZIEL (t+x)","VollAk",{"$f":"+'I 1'!G59","v":0}]
[214,null,"Frauen-AK",null,null,null,"ZIEL (t+x)","VollAk"]
[215]
[216]
[217,"Flächenausstattung Obst- und Gartenbau (einschl. Baumschulen)"]
[218,null,"Gärtnerische Grundfläche",null,null,null,"IST (t)","eqm"]
[219,null,"   dav.","Hochglas","heizbar",null,"IST (t)","eqm"]
[220,null,null,null,"nicht heizbar",null,"IST (t)","eqm"]
[221,null,null,"Foliengewächshäuser","heizbar",null,"IST (t)","eqm"]
[222,null,null,null,"nicht heizbar",null,"IST (t)","eqm"]
[223,null,null,"Freiland",null,null,"IST (t)","eqm"]
[224]
[225,null,"Gärtnerische Grundfläche",null,null,null,"ZIEL (t+x)","eqm"]
[226,null,"   dav.","Hochglas","heizbar",null,"ZIEL (t+x)","eqm"]
[227,null,null,null,"nicht heizbar",null,"ZIEL (t+x)","eqm"]
[228,null,null,"Foliengewächshäuser","heizbar",null,"ZIEL (t+x)","eqm"]
[229,null,null,null,"nicht heizbar",null,"ZIEL (t+x)","eqm"]
[230,null,null,"Freiland",null,null,"ZIEL (t+x)","eqm"]
[231]
[232,"Absatzverhältnisse in % des Gartenbau-Umsatzes"]
[233,null,"Direktabsatz",null,null,null,"IST (t)","%"]
[234,null,null,"Endverbraucher ab Betrieb",null,null,"IST (t)","%"]
[235,null,null,"Eigenes Ladengeschäft",null,null,"IST (t)","%"]
[236,null,null,"Wochenmarkt",null,null,"IST (t)","%"]
[237,null,null,"Großmarkt/Selbstvermarktung",null,null,"IST (t)","%"]
[238,null,"Indirekter Absatz",null,null,null,"IST (t)","%"]
[239,null,null,"Groß- und Kommissionshandel, Versteigerung, etc.",null,null,"IST (t)","%"]
[240,null,null,"Absatzgenossenschaft",null,null,"IST (t)","%"]
[241]
[242,null,"Direktabsatz",null,null,null,"ZIEL (t+x)","%"]
[243,null,null,"Endverbraucher ab Betrieb",null,null,"ZIEL (t+x)","%"]
[244,null,null,"Eigenes Ladengeschäft",null,null,"ZIEL (t+x)","%"]
[245,null,null,"Wochenmarkt",null,null,"ZIEL (t+x)","%"]
[246,null,null,"Großmarkt/Selbstvermarktung",null,null,"ZIEL (t+x)","%"]
[247,null,"Indirekter Absatz",null,null,null,"ZIEL (t+x)","%"]
[248,null,null,"Groß- und Kommissionshandel, Versteigerung, etc.",null,null,"ZIEL (t+x)","%"]
[249,null,null,"Absatzgenossenschaft",null,null,"ZIEL (t+x)","%"]
[250]
[251]
[252,"Erfolgsrechnung (t-1)"]
[253]
[254,"Betriebliche Erträge"]
[255,null,"Umsatzerlöse insgesamt",null,null,"2339/5","(t-1)","EUR",{"$f":"+'I 2'!H13","v":0}]
[256,null,"   dav.","Pflanzenproduktion",null,"2099/5","(t-1)","EUR",{"$f":"+'I 2'!H7","v":0}]
[257,null,null,"dar. Getreide",null,"2001/5 bis 2017/5","(t-1)","EUR"]
[258,null,null,"Tierproduktion",null,"2199/5","(t-1)","EUR",{"$f":"+'I 2'!H9","v":0}]
[259,null,null,"dar. Kuhmilch",null,"2127/5","(t-1)","EUR"]
[260,null,null,"        Rindfleisch",null,"2110/5, 2115/5, 2118/5, 2120/5 bis 2124/5","(t-1)","EUR"]
[261,null,null,"Obstbau",null,"2209/5","(t-1)","EUR"]
[262,null,null,"Gartenbau",null,"2269/5","(t-1)","EUR"]
[263,null,null,"Weinbau und Kellerei",null,"2299/5","(t-1)","EUR"]
[264,null,null,"Forstwirtschaft und Jagd",null,"2309/5","(t-1)","EUR"]
[265,null,null,"Handel, Dienstl., Nebenbetriebe",null,"2337/5","(t-1)","EUR"]
[266,null,null,"dar. Lohnarbeit, Maschinenmiete",null,"2332/5","(t-1)","EUR"]
[267,null,null,"       Fremdenverkehr",null,"2333/5","(t-1)","EUR"]
[268,null,null,"       Landschaftspflege",null,"2335/5","(t-1)","EUR"]
[269,null,null,"Sonstiges",null,"2319/5, 2338/5","(t-1)","EUR"]
[270,null,"Bestandsveränderungen",null,null,"2347/5, 2348/5","(t-1)","EUR",{"$f":"+'I 2'!H14","v":0}]
[271,null,"andere aktivierte Eigenleistungen",null,null,"2349/5","(t-1)","EUR",{"$f":"+'I 2'!H15","v":0}]
[272,null,"sonstige betriebl. Erträge",null,null,"2498/5","(t-1)","EUR",{"$f":"+'I 2'!H16","v":0}]
[273,null,"dar. Zulagen und Zuschüsse",null,null,"2449/5","(t-1)","EUR",{"$f":"+'I 2'!H17","v":0}]
[274,null,"        Pacht- und Mieterträge",null,null,"2450/5, 2451/5","(t-1)","EUR"]
[275,null,"Summe der betrieblichen Erträge",null,null,null,"(t-1)","EUR",{"$f":"+I260+I275+I276+I277","v":0}]
[276]
[277,"Betriebliche Aufwendungen"]
[278,null,"Materialaufwand",null,null,"2789/5","(t-1)","EUR",{"$f":"+'I 2'!H18","v":0}]
[279,null,"dar.  Düngemittel",null,null,"2539/5","(t-1)","EUR"]
[280,null,"        Pflanzenschutzmittel",null,null,"2559/5","(t-1)","EUR"]
[281,null,"       Tierproduktion",null,null,"2729/5","(t-1)","EUR"]
[282,null,"        Lohnarbeit, Maschinenmiete",null,null,"2762/5","(t-1)","EUR"]
[283,null,"        Heizmaterial und Strom",null,null,"2770/5+2771/5","(t-1)","EUR"]
[284,null,"        Wasser, Abwasser",null,null,"2772/5","(t-1)","EUR"]
[285,null,"Personalaufwand",null,null,"2799/5","(t-1)","EUR",{"$f":"+'I 2'!H20","v":0}]
[286,null,"dar. Betriebliche Unfallversicherung",null,null,"2798/5","(t-1)","EUR"]
[287,null,"Abschreibungen",null,null,"2809/5","(t-1)","EUR",{"$f":"+'I 2'!H21","v":0}]
[288,null,"dar. auf immater. Vermög. (planm.)",null,null,"2800/5","(t-1)","EUR",{"$f":"+'I 2'!H22","v":0}]
[289,null,"        auf Sachanlagen (planm.)",null,null,"2801/5","(t-1)","EUR",{"$f":"+'I 2'!H23","v":0}]
[290,null,"sonstige betriebliche Aufwendungen",null,null,"2897/5","(t-1)","EUR",{"$f":"+'I 2'!H24","v":0}]
[291,null,"dar. Pacht, Miete, Leasing",null,null,"2840/5 bis 2845/5","(t-1)","EUR",{"$f":"+'I 2'!H26+'I 2'!H27","v":0}]
[292,null,"Summe betriebliche Aufwendungen",null,null,null,"(t-1)","EUR",{"$f":"+I283+I290+I292+I295","v":0}]
[293]
[294,"Betriebsergebnis ",null,null,null,"2899/5","(t-1)","EUR",{"$f":"+'I 2'!H28","v":0}]
[295,"Finanzergebnis",null,null,null,"2918/5","(t-1)","EUR",{"$f":"+'I 2'!H29","v":0}]
[296,"dar. Zinsen u. ähnliche Aufwendungen",null,null,null,"2914/5","(t-1)","EUR",{"$f":"+'I 2'!H30","v":0}]
[297,"Ergebnis der gewöhnl. Geschäftstätigkeit",null,null,null,"2919/5","(t-1)","EUR",{"$f":"+'I 2'!H31","v":0}]
[298,"außerordentliches Ergebnis",null,null,null,"2929/5","(t-1)","EUR",{"$f":"+'I 2'!H32","v":0}]
[299,"Steuern",null,null,null,"2939/5+2949/5","(t-1)","EUR",{"$f":"+'I 2'!H33","v":0}]
[300,"Gewinn/Verlust; Jahresüberschuss/-fehlbetrag",null,null,null,"2959/5","(t-1)","EUR",{"$f":"+'I 2'!H34","v":0}]
[301,"Ordentliches Ergebnis",null,null,null,null,"(t-1)","EUR",{"$f":"+'I 2'!H43","v":0}]
[302,"Bereinigte Eigenkapitalveränderung im Unternehmen",null,null,null,null,"(t-1)","EUR",{"$f":"+'I 2'!H52","v":0}]
[303,"Sonstige Kapitalbildung des/der BL-Ehepaars/-paare",null,null,null,null,"(t-1)","EUR"]
[304]
[305]
[306,"Erfolgsrechnung (IST-Jahr)"]
[307]
[308,"Betriebliche Erträge"]
[309,null,"Umsatzerlöse insgesamt",null,null,"2339/5","IST (t)","EUR",{"$f":"+'I 2'!J13","v":0}]
[310,null,"   dav.","Pflanzenproduktion",null,"2099/5","IST (t)","EUR",{"$f":"+'I 2'!J7","v":0}]
[311,null,null,"dar. Getreide",null,"2001/5 bis 2017/5","IST (t)","EUR"]
[312,null,null,"Tierproduktion",null,"2199/5","IST (t)","EUR",{"$f":"+'I 2'!J9","v":0}]
[313,null,null,"dar. Kuhmilch",null,"2127/5","IST (t)","EUR"]
[314,null,null,"        Rindfleisch",null,"2110/5, 2115/5, 2118/5, 2120/5 bis 2124/5","IST (t)","EUR"]
[315,null,null,"Obstbau",null,"2209/5","IST (t)","EUR"]
[316,null,null,"Gartenbau",null,"2269/5","IST (t)","EUR"]
[317,null,null,"Weinbau und Kellerei",null,"2299/5","IST (t)","EUR"]
[318,null,null,"Forstwirtschaft und Jagd",null,"2309/5","IST (t)","EUR"]
[319,null,null,"Handel, Dienstl., Nebenbetriebe",null,"2337/5","IST (t)","EUR"]
[320,null,null,"dar. Lohnarbeit, Maschinenmiete",null,"2332/5","IST (t)","EUR"]
[321,null,null,"       Fremdenverkehr",null,"2333/5","IST (t)","EUR"]
[322,null,null,"       Landschaftspflege",null,"2335/5","IST (t)","EUR"]
[323,null,null,"Sonstiges",null,"2319/5, 2338/5","IST (t)","EUR"]
[324,null,"Bestandsveränderungen",null,null,"2347/5, 2348/5","IST (t)","EUR",{"$f":"+'I 2'!J14","v":0}]
[325,null,"andere aktivierte Eigenleistungen",null,null,"2349/5","IST (t)","EUR",{"$f":"+'I 2'!J15","v":0}]
[326,null,"sonstige betriebl. Erträge",null,null,"2498/5","IST (t)","EUR",{"$f":"+'I 2'!J16","v":0}]
[327,null,"dar. Zulagen und Zuschüsse",null,null,"2449/5","IST (t)","EUR",{"$f":"+'I 2'!J17","v":0}]
[328,null,"        Pacht- und Mieterträge",null,null,"2450/5, 2451/5","IST (t)","EUR"]
[329,null,"Summe der betrieblichen Erträge",null,null,null,"IST (t)","EUR",{"$f":"+I314+I329+I330+I331","v":0}]
[330]
[331,"Betriebliche Aufwendungen"]
[332,null,"Materialaufwand",null,null,"2789/5","IST (t)","EUR",{"$f":"+'I 2'!J18","v":0}]
[333,null,"dar.  Düngemittel",null,null,"2539/5","IST (t)","EUR"]
[334,null,"        Pflanzenschutzmittel",null,null,"2559/5","IST (t)","EUR"]
[335,null,"       Tierproduktion",null,null,"2729/5","IST (t)","EUR"]
[336,null,"        Lohnarbeit, Maschinenmiete",null,null,"2762/5","IST (t)","EUR"]
[337,null,"        Heizmaterial und Strom",null,null,"2770/5+2771/5","IST (t)","EUR"]
[338,null,"        Wasser, Abwasser",null,null,"2772/5","IST (t)","EUR"]
[339,null,"Personalaufwand",null,null,"2799/5","IST (t)","EUR",{"$f":"+'I 2'!J20","v":0}]
[340,null,"dar. Betriebliche Unfallversicherung",null,null,"2798/5","IST (t)","EUR"]
[341,null,"Abschreibungen",null,null,"2809/5","IST (t)","EUR",{"$f":"+'I 2'!J21","v":0}]
[342,null,"dar. auf immater. Vermög. (planm.)",null,null,"2800/5","IST (t)","EUR",{"$f":"+'I 2'!J22","v":0}]
[343,null,"        auf Sachanlagen (planm.)",null,null,"2801/5","IST (t)","EUR",{"$f":"+'I 2'!J23","v":0}]
[344,null,"sonstige betriebliche Aufwendungen",null,null,"2897/5","IST (t)","EUR",{"$f":"+'I 2'!J24","v":0}]
[345,null,"dar. Pacht, Miete, Leasing",null,null,"2840/5 bis 2845/5","IST (t)","EUR",{"$f":"+'I 2'!J26+'I 2'!J27","v":0}]
[346,null,"Summe betriebliche Aufwendungen",null,null,null,"IST (t)","EUR",{"$f":"+I337+I344+I346+I349","v":0}]
[347]
[348,"Betriebsergebnis ",null,null,null,"2899/5","IST (t)","EUR",{"$f":"+'I 2'!J28","v":0}]
[349,"Finanzergebnis",null,null,null,"2918/5","IST (t)","EUR",{"$f":"+'I 2'!J29","v":0}]
[350,"dar. Zinsen u. ähnliche Aufwendungen",null,null,null,"2914/5","IST (t)","EUR",{"$f":"+'I 2'!J30","v":0}]
[351,"Ergebnis der gewöhnl. Geschäftstätigkeit",null,null,null,"2919/5","IST (t)","EUR",{"$f":"+'I 2'!J31","v":0}]
[352,"außerordentliches Ergebnis",null,null,null,"2929/5","IST (t)","EUR",{"$f":"+'I 2'!J32","v":0}]
[353,"Steuern",null,null,null,"2939/5+2949/5","IST (t)","EUR",{"$f":"+'I 2'!J33","v":0}]
[354,"Gewinn/Verlust; Jahresüberschuss/-fehlbetrag",null,null,null,"2959/5","IST (t)","EUR",{"$f":"+'I 2'!J34","v":0}]
[355,"Ordentliches Ergebnis",null,null,null,null,"IST (t)","EUR",{"$f":"+'I 2'!J43","v":0}]
[356,"Bereinigte Eigenkapitalveränderung im Unternehmen",null,null,null,null,"IST (t)","EUR",{"$f":"+'I 2'!J52","v":0}]
[357,"Sonstige Kapitalbildung des/der BL-Ehepaars/-paare",null,null,null,null,"IST (t)","EUR"]
[358]
[359,"Bilanz (IST-Jahr)"]
[360,null,"Aktiva",null,null,"1229/5","IST (t)","EUR",{"$f":"+'I 2'!H59","v":0}]
[361,null,"Eigenkapital",null,null,"1439/2+1499/2","IST (t)","EUR",{"$f":"+'I 2'!J63","v":0}]
[362,null,"Sonderposten mit Rücklageanteil",null,null,"1529/2","IST (t)","EUR",0]
[363,null,"Rückstellungen",null,null,"1539/2","IST (t)","EUR",0]
[364,null,"Verbindlichkeiten",null,null,"1559/2","IST (t)","EUR",{"$f":"+'I 2'!H60","v":0}]
[365,null,"dar. Verb. gegenüber Kreditinstituten",null,null,"1540/2","IST (t)","EUR",{"$f":"+'I 2'!H61","v":0}]
[366]
[367]
[368,"Erfolgsrechnung (ZIEL-Jahr)"]
[369]
[370,"Betriebliche Erträge"]
[371,null,"Umsatzerlöse insgesamt",null,null,"2339/5","ZIEL (t+x)","EUR"]
[372,null,"   dav.","Pflanzenproduktion",null,"2099/5","ZIEL (t+x)","EUR"]
[373,null,null,"dar. Getreide",null,"2001/5 bis 2017/5","ZIEL (t+x)","EUR"]
[374,null,null,"Tierproduktion",null,"2199/5","ZIEL (t+x)","EUR"]
[375,null,null,"dar. Kuhmilch",null,"2127/5","ZIEL (t+x)","EUR"]
[376,null,null,"       Rindfleisch",null,"2110/5, 2115/5, 2118/5, 2120/5 bis 2124/5","ZIEL (t+x)","EUR"]
[377,null,null,"Obstbau",null,"2209/5","ZIEL (t+x)","EUR"]
[378,null,null,"Gartenbau",null,"2269/5","ZIEL (t+x)","EUR"]
[379,null,null,"Weinbau und Kellerei",null,"2299/5","ZIEL (t+x)","EUR"]
[380,null,null,"Forstwirtschaft und Jagd",null,"2309/5","ZIEL (t+x)","EUR"]
[381,null,null,"Handel, Dienstl., Nebenbetriebe",null,"2337/5","ZIEL (t+x)","EUR"]
[382,null,null,"dar. Lohnarbeit, Maschinenmiete",null,"2332/5","ZIEL (t+x)","EUR"]
[383,null,null,"       Fremdenverkehr",null,"2333/5","ZIEL (t+x)","EUR"]
[384,null,null,"       Landschaftspflege",null,"2320/5","ZIEL (t+x)","EUR"]
[385,null,null,"Sonstiges",null,"2319/5+2338/5","ZIEL (t+x)","EUR"]
[386,null,"Bestandsveränderungen",null,null,"2347/5+2348/5","ZIEL (t+x)","EUR"]
[387,null,"andere aktivierte Eigenleistungen",null,null,"2349/5","ZIEL (t+x)","EUR"]
[388,null,"sonstige betriebl. Erträge",null,null,"2498/5","ZIEL (t+x)","EUR"]
[389,null,"dar. Zulagen und Zuschüsse",null,null,"2449/5","ZIEL (t+x)","EUR"]
[390,null,"        Pacht- und Mieterträge",null,null,"2450/5+2451/5","ZIEL (t+x)","EUR"]
[391,null,"Summe der betrieblichen Erträge",null,null,null,"ZIEL (t+x)","EUR"]
[392]
[393,"Betriebliche Aufwendungen"]
[394,null,"Materialaufwand",null,null,"2789/5","ZIEL (t+x)","EUR"]
[395,null,"dar.  Düngemittel",null,null,"2539/5","ZIEL (t+x)","EUR"]
[396,null,"        Pflanzenschutzmittel",null,null,"2559/5","ZIEL (t+x)","EUR"]
[397,null,"       Tierproduktion",null,null,"2729/5","ZIEL (t+x)","EUR"]
[398,null,"        Lohnarbeit, Maschinenmiete",null,null,"2762/5","ZIEL (t+x)","EUR"]
[399,null,"        Heizmaterial und Strom",null,null,"2770/5+2771/5","ZIEL (t+x)","EUR"]
[400,null,"        Wasser, Abwasser",null,null,"2772/5","ZIEL (t+x)","EUR"]
[401,null,"Personalaufwand",null,null,"2799/5","ZIEL (t+x)","EUR"]
[402,null,"dar. Betriebliche Unfallversicherung",null,null,"2798/5","ZIEL (t+x)","EUR"]
[403,null,"Abschreibungen",null,null,"2809/5","ZIEL (t+x)","EUR",{"$f":"+'I 2'!K21","v":0}]
[404,null,"dar. auf immater. Vermög. (planm.)",null,null,"2800/5","ZIEL (t+x)","EUR"]
[405,null,"        auf Sachanlagen (planm.)",null,null,"2801/5","ZIEL (t+x)","EUR"]
[406,null,"sonstige betriebliche Aufwendungen",null,null,"2897/5","ZIEL (t+x)","EUR"]
[407,null,"dar. Pacht, Miete, Leasing",null,null,"2840/5 bis 2845/5","ZIEL (t+x)","EUR"]
[408,null,"Summe betriebliche Aufwendungen",null,null,null,"ZIEL (t+x)","EUR"]
[409]
[410,"Betriebsergebnis ",null,null,null,"2899/5","ZIEL (t+x)","EUR"]
[411,"Finanzergebnis",null,null,null,"2918/5","ZIEL (t+x)","EUR"]
[412,"dar. Zinsen u. ähnliche Aufwendungen",null,null,null,"2914/5","ZIEL (t+x)","EUR",{"$f":"+'I 2'!K30","v":0}]
[413,"Ergebnis der gewöhnl. Geschäftstätigkeit",null,null,null,"2919/5","ZIEL (t+x)","EUR",{"$f":"+'I 2'!K30","v":0}]
[414,"außerordentliches Ergebnis",null,null,null,"2929/5","ZIEL (t+x)","EUR"]
[415,"Steuern",null,null,null,"2939/5+2949/5","ZIEL (t+x)","EUR"]
[416,"Gewinn/Verlust; Jahresüberschuss/-fehlbetrag",null,null,null,"2959/5","ZIEL (t+x)","EUR"]
[417,"Ordentliches Ergebnis",null,null,null,null,"ZIEL (t+x)","EUR",{"$f":"+'I 2'!K43","v":0}]
[418,"Bereinigte Eigenkapitalveränderung im Unternehmen",null,null,null,null,"ZIEL (t+x)","EUR",{"$f":"+'I 2'!K52","v":0}]
[419,"Sonstige Kapitalbildung des/der BL-Ehepaars/-paare",null,null,null,null,"ZIEL (t+x)","EUR"]
[420]
[421,"Bilanz (ZIEL)"]
[422,null,"Aktiva",null,null,"1229/5","ZIEL (t+x)","EUR"]
[423,null,"Eigenkapital",null,null,"1439/2+1499/2","ZIEL (t+x)","EUR"]
[424,null,"Sonderposten mit Rücklageanteil",null,null,"1529/2","ZIEL (t+x)","EUR"]
[425,null,"Rückstellungen",null,null,"1539/2","ZIEL (t+x)","EUR"]
[426,null,"Verbindlichkeiten",null,null,"1559/2","ZIEL (t+x)","EUR"]
[427,null,"dar. Verb. gegenüber Kreditinstituten",null,null,"1540/2","ZIEL (t+x)","EUR"]
[428]
[429]
[430,"Investitionsbereich "]
[431]
[432,"Gebäude (einschl. baugebundener Technik)"]
[433,"-","Milchviehstall (incl. Melkstand)",null,null,null,null,"EUR"]
[434,"-","Rinderjungviehstall",null,null,null,null,"EUR"]
[435,"-","Mastrinderstall",null,null,null,null,"EUR"]
[436,"-","Zuchtsauenstall",null,null,null,null,"EUR"]
[437,"-","Mastschweinestall",null,null,null,null,"EUR"]
[438,"-","Legehennenstall",null,null,null,null,"EUR"]
[439,"-","Mastgeflügelstall",null,null,null,null,"EUR"]
[440,"-","Reitstall, -halle",null,null,null,null,"EUR"]
[441,"-","sonstige Ställe",null,null,null,null,"EUR"]
[442,"-","Gewächshäuser",null,null,null,null,"EUR"]
[443,"-","Maschinenhalle",null,null,null,null,"EUR"]
[444,"-","Lagerhalle/-räume für ldw. Produkte",null,null,null,null,"EUR"]
[445,"-","Verarbeitungs- und Verkaufsräume",null,null,null,null,"EUR"]
[446,"-","Sonstiges",null,null,null,null,"EUR"]
[447,"Wirtschaftsdüngerlager",null,null,null,null,null,"EUR"]
[448,"Maschinen, Geräte, Vorrichtungen"]
[449,"-","Pflanzenschutztechnik",null,null,null,null,"EUR"]
[450,"-","Ausbringungstechnik für Flüssig- und Festmist",null,null,null,null,"EUR"]
[451,"-","Bodenschondende Bearbeitungs- und Bestelltechnik",null,null,null,null,"EUR"]
[452,"-","GPS",null,null,null,null,"EUR"]
[453,"-","Spezialmaschinen und -geräte für NawaRo",null,null,null,null,"EUR"]
[454,"-","Beregnungstechnik",null,null,null,null,"EUR"]
[455,"-","Sonstiges",null,null,null,null,"EUR"]
[456,"Energieeinsparung und -umstellung"]
[457,"-","Wärme- und Kältedämmung",null,null,null,null,"EUR"]
[458,"-","Wärmerückgewinnung und Wärmepumpe",null,null,null,null,"EUR"]
[459,"-","Biomasseanlage",null,null,null,null,"EUR"]
[460,"-","Umstellung auf umweltverträgliche Energieträger",null,null,null,null,"EUR"]
[461,"-","Sonstiges",null,null,null,null,"EUR"]
[462,"Energiegewinnung bzw. -produktion",null,null,null,null,null,"EUR"]
[463,"Diversifizierung"]
[464,"-","Direktvermarktung",null,null,null,null,"EUR"]
[465,"-","Fremdenverkehr",null,null,null,null,"EUR"]
[466,"-","Pensionstierhaltung",null,null,null,null,"EUR"]
[467,"-","Landschaftspflege",null,null,null,null,"EUR"]
[468,"-","Lohnarbeit",null,null,null,null,"EUR"]
[469,"-","Sonstiges",null,null,null,null,"EUR"]
[470,"Erschließungskosten",null,null,null,null,null,"EUR",{"$f":"+'I 3'!F22","v":0}]
[471,"Landkauf",null,null,null,null,null,"EUR"]
[472,"Anpflanzung, Eingrünung",null,null,null,null,null,"EUR"]
[473,"Betreuungskosten / Erstellung des Investitionsplanes",null,null,null,null,null,"EUR"]
[474,"Dauerkulturen",null,null,null,null,null,"EUR",{"$f":"+'I 3'!F53+'I 3'!F54","v":0}]
[475,"Summe des förderfähigen Investitionsvolumens",null,null,null,null,null,"EUR",{"$f":"+'I 3'!H61","v":0}]
[476,"Summe des Investitionsvolumens (incl. MWSt)",null,null,null,null,null,"EUR",{"$f":"+'I 3'!F61","v":0}]
[477]
[478,"Finanzierung der Investitionsmaßnahme"]
[479]
[480,"Eigenleistungen"]
[481,null,"bare Eigenmittel",null,null,null,null,"EUR",{"$f":"+'I 4'!E14","v":0}]
[482,null,"unbare Eigenleistungen",null,null,null,null,"EUR",{"$f":"+'I 4'!E20","v":0}]
[483]
[484,"Junglandwirtezuschuss/Niederlassungsprämie"]
[485,null,"AFP",null,null,null,null,"EUR",{"$f":"+'I 4'!E25","v":0}]
[486,null,"Landesmaßnahme (LM)",null,null,null,null,"EUR"]
[487]
[488,"Investitionszuschüsse"]
[489,null,"Zuschüsse",null,null,null,null,"EUR",{"$f":"+'I 4'!E22+'I 4'!E23+'I 4'!E24+'I 4'!E26+'I 4'!E27","v":0}]
[490,null," - dar. für besonders tiergerechtes Bauen",null,null,null,null,"EUR",{"$f":"+'I 4'!E22+'I 4'!E24","v":0}]
[491,null," - dar. für Diversifizierung",null,null,null,null,"EUR",{"$f":"+'I 4'!E26","v":0}]
[492,null," - dar. für Emissionsminderung/Energieeinsparung",null,null,null,null,"EUR",{"$f":"+'I 4'!E27","v":0}]
[493,null," - dar. für Erschließungskosten",null,null,null,null,"EUR"]
[494,null,"Kapitalisierter Zinszuschuss",null,null,null,null,"EUR"]
[495]
[496,null,"Zuschüsse (LM)",null,null,null,null,"EUR"]
[497,null,"Kapitalisierter Zinszuschuss (LM)",null,null,null,null,"EUR"]
[498]
[499]
[500,"Zinsverbilligte Darlehen"]
[501,null,"ZV-Darlehen 1",null,null,null,null,"EUR"]
[502,null,"ZV-Darlehen 1",null,null,null,null,"Zinsverbilligung in %"]
[503,null,"ZV-Darlehen 1",null,null,null,null,"Zinssatz"]
[504,null,"ZV-Darlehen 1",null,null,null,null,"Laufzeit"]
[505,null,"ZV-Darlehen 2",null,null,null,null,"EUR"]
[506,null,"ZV-Darlehen 2",null,null,null,null,"Zinsverbilligung in %"]
[507,null,"ZV-Darlehen 2",null,null,null,null,"Zinssatz"]
[508,null,"ZV-Darlehen 2",null,null,null,null,"Laufzeit"]
[509,null,"ZV-Darlehen 3",null,null,null,null,"EUR"]
[510,null,"ZV-Darlehen 3",null,null,null,null,"Zinsverbilligung in %"]
[511,null,"ZV-Darlehen 3",null,null,null,null,"Zinssatz"]
[512,null,"ZV-Darlehen 3",null,null,null,null,"Laufzeit"]
[513]
[514,"Frei finanzierte Darlehen",null,null,null,null,null,"EUR",{"$f":"+'I 4'!E40","v":0}]
[515,"Summe Finanzierungsmittel",null,null,null,null,null,"EUR",{"$f":"+'I 4'!E41","v":0}]
[516]
[517,"Beihilfewert"]
[518,"Gesamtwert der Beihilfe",null,null,null,null,null,"EUR",{"$f":"+'I 4'!E32","v":0}]
[519,"Gesamtwert der Beihilfe",null,null,null,null,null,"%",{"$f":"+'I 4'!J32","v":0}]
[520]
[521,"Kapitaldienst"]
[522,null,"Kapitaldienst",null,null,"IST (t)",null,"EUR",{"$f":"+'I 4'!I62:L62","v":0}]
[523,null,"dar. Tilgung",null,null,"IST (t)",null,"EUR",{"$f":"+'I 4'!I61:J61","v":0}]
[524,null,"Kapitaldienst",null,null,"ZIEL (t + x)",null,"EUR",{"$f":"+'I 4'!M62","v":0}]
[525,null,"dar. Tilgung",null,null,"ZIEL (t + x)",null,"EUR",{"$f":"+'I 4'!M61","v":0}]
[526]
[527,"Änderung der Haltungsverfahren in der Tierhaltung:"]
[528,"(Haltungsverfahren in % der Tierplätze)"]
[529]
[530,null,"a) Milchviehhaltung"]
[531,null,null,"Laufstall","IST (t)",null,null,"%"]
[532,null,null,null,"ZIEL-Jahr",null,null,"%"]
[533,null,null,"Weidegang/Laufhof","IST (t)",null,null,"%"]
[534,null,null,null,"ZIEL-Jahr",null,null,"%"]
[535,null,null,"Vollspalten","IST (t)",null,null,"%"]
[536,null,null,null,"ZIEL-Jahr",null,null,"%"]
[537,null,"b) Jungvieh- und Mastrinderhaltung"]
[538,null,null,"Gruppen","IST (t)",null,null,"%"]
[539,null,null,null,"ZIEL-Jahr",null,null,"%"]
[540,null,null,"Vollspalten","IST (t)",null,null,"%"]
[541,null,null,null,"ZIEL-Jahr",null,null,"%"]
[542,null,"c) Kälberhaltung (ab 5. Woche)"]
[543,null,null,"Gruppen","IST (t)",null,null,"%"]
[544,null,null,null,"ZIEL-Jahr",null,null,"%"]
[545,null,null,"Offenstall/Auslauf","IST (t)",null,null,"%"]
[546,null,null,null,"ZIEL-Jahr",null,null,"%"]
[547,null,"d) Sauenhaltung (außer Abferkelbereich)"]
[548,null,null,"Gruppen","IST (t)",null,null,"%"]
[549,null,null,null,"ZIEL-Jahr",null,null,"%"]
[550,null,null,"Einstreu/Tiefstreu","IST (t)",null,null,"%"]
[551,null,null,null,"ZIEL-Jahr",null,null,"%"]
[552,null,"e) Mastschweinehaltung"]
[553,null,null,"Vollspalten","IST (t)",null,null,"%"]
[554,null,null,null,"ZIEL-Jahr",null,null,"%"]
[555,null,"f) Geflügelhaltung"]
[556,null,null,"Käfig","IST (t)",null,null,"%"]
[557,null,null,null,"ZIEL-Jahr",null,null,"%"]
[558,null,null,"Volieren","IST (t)",null,null,"%"]
[559,null,null,null,"ZIEL-Jahr",null,null,"%"]
[560,null,null,"Boden","IST (t)",null,null,"%"]
[561,null,null,null,"ZIEL-Jahr",null,null,"%"]
[562,null,null,"Freiland","IST (t)",null,null,"%"]
[563,null,null,null,"ZIEL-Jahr",null,null,"%"]
[564]
[565,"Investitionen in Dunglager"]
[566,null,"Lagerdauer (Monate)"]
[567,null,null,"Festmist","IST (t)",null,null,"Monate"]
[568,null,null,null,"ZIEL-Jahr",null,null,"Monate"]
[569,null,null,"Flüssigmist","IST (t)",null,null,"Monate"]
[570,null,null,null,"ZIEL-Jahr",null,null,"Monate"]
[571,null,"Abdeckung des Außenlagers (% der Grundfläche)"]
[572,null,null,"Festmist","IST (t)",null,null,"%"]
[573,null,null,null,"ZIEL-Jahr",null,null,"%"]
[574,null,null,"Flüssigmist","IST (t)",null,null,"%"]
[575,null,null,null,"ZIEL-Jahr",null,null,"%"]
[576]
[577,"Investitionen in Gülleausbringungstechnik"]
[578,null,"Emissionsmindernde Ausbringtechnik",null,"IST (t)",null,null,"% d. Güllemenge"]
[579,null," (Schleppschlauch, Injektor, etc.)",null,"ZIEL-Jahr",null,null,"% d. Güllemenge"]
[580]
[581,"Resourcenverbrauch"]
[582,null,"Energieverbrauch p.a. im Durchschnitt der letzten drei Jahre"]
[583,null,null,"Heizöl","IST (t)",null,null,"l"]
[584,null,null,"Gas","IST (t)",null,null,"m3"]
[585,null,null,"Strom","IST (t)",null,null,"kWh"]
[586,null,"geplanter Energieverbrauch p.a. nach Durchführung der Fördermaßnahme"]
[587,null,null,"Heizöl","ZIEL-Jahr",null,null,"l"]
[588,null,null,"Gas","ZIEL-Jahr",null,null,"m3"]
[589,null,null,"Strom","ZIEL-Jahr",null,null,"kWh"]
[590]
[591,null,"Trink- und Brauchwasser",null,"IST (t)",null,null,"m3/Jahr"]
[592,null,null,null,"ZIEL-Jahr",null,null,"m3/Jahr"]
[593]
[594,null,"Flächenverbrauch der baulichen Investition "]
[595,null,null,"überbaute Fläche",null,null,null,"m2"]
[596,null,null,"Weg- und Hoffläche",null,null,null,"m2"]
[597,null,null,"rekultivierte Fläche",null,null,null,"m2"]
[598]
[599,"Ist eine Umweltverträglichkeitsprüfung (UVP) erforderlich? ",null,null,null,null,null,"ja=1; nein=0"]
[600,null,"wenn \"Ja\":  - Kosten der UVP",null,null,null,null,"EUR"]
[601]
[602,"Unterliegt das Vorhaben der naturschutzrechtl. Eingriffsregelung?",null,null,null,null,null,"ja=1; nein=0"]
[603,null,"wenn \"Ja\":  - Art der Folgemaßnahmen",null,null,null,null,"Code"]
[604,null,null,"      - Kosten der Folgemaßnahmen",null,null,null,"EUR"]
[605]
[606,"Verbesserung der Produkt- und Prozessqualität"]
[607,"Überwachung des Produktionsprozesses"]
[608,null,"-","Zertifizierung (z.B. ISO 9001 ff.)","IST (t)",null,null,"% v. Umsatz"]
[609,null,null,null,"ZIEL-Jahr",null,null,"% v. Umsatz"]
[610,null,"-","Sonstige Systeme","IST (t)",null,null,"% v. Umsatz"]
[611,null,null,null,"ZIEL-Jahr",null,null,"% v. Umsatz"]
[612,"Teilnahme an Programmen für Güte-, Marken-, Herkunftszeichen"]
[613,null,"-","Gütezeichen","IST (t)",null,null,"% v. Umsatz"]
[614,null,null,null,"ZIEL-Jahr",null,null,"% v. Umsatz"]
[615,null,"-","Markenzeichen","IST (t)",null,null,"% v. Umsatz"]
[616,null,null,null,"ZIEL-Jahr",null,null,"% v. Umsatz"]
[617,null,"-","Herkunftszeichen","IST (t)",null,null,"% v. Umsatz"]
[618,null,null,null,"ZIEL-Jahr",null,null,"% v. Umsatz"]
[619,"-","Nennung der Güte-, Marken-, Herkunftszeichen "]
[620,null,"-","unternehmenseigen",null,null,null,"Name"]
[621,null,"-","regional/national",null,null,null,"Name"]
[622,null,"-","EU-Gütezeichen",null,null,null,"Name"]
[623]
[624,"-","Preiszuschlag i. Vgl. zu Standardware"]
[625,null,"-","Produkt 1","IST (t)",null,null,"%"]
[626,null,null,null,"ZIEL-Jahr",null,null,"%"]
[627,null,"-","Produkt 2","IST (t)",null,null,"%"]
[628,null,null,null,"ZIEL-Jahr",null,null,"%"]
[629,null,"-","Produkt 3","IST (t)",null,null,"%"]
[630,null,null,null,"ZIEL-Jahr",null,null,"%"]

{"sheet":"Notizblatt","index":12,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,39,5]]}
["Notizblatt"]
[{"$f":"+'I 1'!D6","v":0}]

{"sheet":"Darlehen","index":13,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,0,2,2],[2,5,2,7],[3,0,3,3],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4]]}
["Rheinland-Pfalz                                Investitionskonzept"]
[null,null,null,null,"Zins- und Tilgungsplan"]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3,)","v":"Unternehmen: "},null,null,null,null,{"$f":"'I 1'!D6","v":0}]
[]
["Darlehenshöhe (in EUR)"]
[]
["Darlehensart",null,null,null,null,"Tilgungsdarlehen"]
[]
["bei Annuitätendarlehn anfängliche Tilgung (in % pa.)"]
["bei Ratendarlehn jährlich vereinbarte Tilgungsrate (in EUR)"]
["Nominalzinssatz (% pa.)"]
["Verwaltungskosten (in EUR pa.)"]
["Zahlungsweise",null,null,null,null,"halbjährlich"]
[null,null,null,null,null,null,null,null,null,null,"monatlich","Tilgungsdarlehen"]
["Auszahlungstag",null,null,null,null,null,null,null,null,null,"vierteljährlich","Annuitätendarlehen"]
["erste Zahlung fällig am (Datum)",null,null,null,null,null,null,null,null,null,"halbjährlich","Versicherungshypothek"]
[null,null,null,null,null,null,null,null,null,null,"jährlich"]
[]
["vertraglich vereinbarte Darlehenslaufzeit (in Jahren)"]
["Zinsfestschreibung (wenn ja, Datum, sonst keine Eingabe)"]
["Zinsverbilligung (wenn ja, um ... % pa)"]
["voraussichtliches Ende der Darlehenslaufzeit ",null,null,null,null,{"$f":"IF($A$28>0,MAX(A:A),\"  \")","v":"  "}]
["Gesamtzinsaufwand (in EUR)",null,null,null,null,{"$f":"IF(D29<>0,SUM(D:D),\"\")","v":""}]
[]
[]
["Datum","Valuta","Tilgung","Zinsen","Verwaltungs-\nkosten","Zahlung an ","Zinsver-","Restbelastung"]
[null,null,null,null,null,"die Bank","billigung","des Landwirts"]

{"sheet":"DB","index":14,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":true,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,4],[4,5,4,7],[17,0,17,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[27,0,27,1],[27,2,27,3],[27,5,27,6],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[26,2,26,3],[26,5,26,6],[28,0,28,1],[28,2,28,3],[28,5,28,6],[29,0,29,1],[29,2,29,3],[29,5,29,6],[36,0,36,3],[30,0,30,1],[30,2,30,3],[30,5,30,6],[31,0,31,1],[31,2,31,3],[31,5,31,6],[32,2,32,3],[32,5,32,6],[33,2,33,3],[33,5,33,6],[35,0,35,3],[44,5,44,6],[45,0,45,1],[46,0,46,1],[47,0,47,1],[37,0,37,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[43,0,43,1],[44,0,44,1],[44,2,44,3]]}
["Rheinland-Pfalz                                Investitionskonzept"]
[{"$f":"CONCATENATE(\"Unternehmen: \",'I 1'!C3)","v":"Unternehmen: "}]
[{"$f":"'I 1'!D6","v":0}]
["Planungsaktivitäten                 "]
["(Produktionsverfahren)               "]
[]
[null,null,null,null,{"$f":"+C7*D7","v":0},null,null,{"$f":"+F7*G7","v":0}]
[null,null,null,null,{"$f":"+C8*D8","v":0},null,null,{"$f":"+F8*G8","v":0}]
[null,null,null,null,{"$f":"+C9*D9","v":0},null,null,{"$f":"+F9*G9","v":0}]
[null,null,null,null,{"$f":"+C10*D10","v":0},null,null,{"$f":"+F10*G10","v":0}]
[null,null,null,null,{"$f":"+D11","v":0},null,null,{"$f":"+G11","v":0}]
["Summe Leistungen             ",null,null,null,{"$f":"SUM(E7:E11)","v":0},null,null,{"$f":"SUM(H7:H11)","v":0}]
[]
[]
[null,null,null,null,{"$f":"+C15*D15+C16*D16","v":0},null,null,{"$f":"+F15*G15+F16*G16","v":0}]
[]
[]
[null,null,null,null,{"$f":"+C18*D18","v":0},null,null,{"$f":"+F18*G18","v":0}]
[null,null,null,{"$f":"+B19*C19","v":0},{"$f":"+C19*D19","v":0},null,{"$f":"+F19*C19","v":0},{"$f":"+F19*G19","v":0}]
[null,null,null,{"$f":"+B20*C20","v":0},{"$f":"+C20*D20","v":0},null,{"$f":"+F20*C20","v":0},{"$f":"+F20*G20","v":0}]
[null,null,null,{"$f":"+B21*C21","v":0},{"$f":"+C21*D21","v":0},null,{"$f":"+F21*C21","v":0},{"$f":"+F21*G21","v":0}]
[null,null,null,null,{"$f":"SUM(E18:E21)","v":0},null,null,{"$f":"SUM(H18:H21)","v":0}]
[null,null,null,null,{"$f":"+C23*D23","v":0},null,null,{"$f":"+F23*G23","v":0}]
[null,null,null,0,0,null,null,{"$f":"+F24*G24","v":0}]
[null,null,null,0,0,null,null,{"$f":"+F25*G25","v":0}]
[null,null,null,0,0,null,null,{"$f":"+F26*G26","v":0}]
[null,null,null,null,{"$f":"SUM(E23:E26)","v":0},null,null,{"$f":"SUM(H23:H26)","v":0}]
[]
[]
[]
[]
["                                           "]
["Zinsansatz                                 ",0.06,null,null,{"$f":"(SUM(E28:E32)+E22+E15+E27)*(7/12)*$B$33","v":0},null,null,{"$f":"(SUM(H28:H32)+H22+H15+H27)*(7/12)*$B$33","v":0}]
["Summe veränderl. Kosten",null,null,null,{"$f":"SUM(E28:E33)+E27+E22+E15","v":0},null,null,{"$f":"SUM(H28:H33)+H27+H22+H15","v":0}]
[]
["Deckungsbeitrag (ohne Zinsansatz)              ",null,null,null,{"$f":"+E12-E34+E33","v":0},"                ",null,{"$f":"+H12-H34+H33","v":0}]
["Deckungsbeitrag (mit Zinsansatz)              ",null,null,null,{"$f":"+E12-E34","v":0},"               ",null,{"$f":"+H12-H34","v":0}]
["Deckungsbeitrag (ohne Prämie,mit Zins)              ",null,null,null,{"$f":"+E12-E34-E11","v":0},"               ",null,{"$f":"+H12-H34-H11","v":0}]
[]
["                                            "]
["Arbeitszeitbedarf  Akh/Jahr  "]
["                                          "]
[]
[]
[null,null,null,null,{"$f":"+E49+E48+E47+E46","v":0},null,null,{"$f":"+H49+H48+H47+H46","v":0}]
[null,null,null,null,{"$f":"+D46","v":0},null,null,{"$f":"+G46","v":0}]
[null,null,null,null,{"$f":"+D47","v":0},null,null,{"$f":"+G47","v":0}]
[null,null,null,null,{"$f":"+D48","v":0},null,null,{"$f":"+G48","v":0}]
[null,null,null,null,{"$f":"+D49","v":0},null,null,{"$f":"+G49","v":0}]