{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["1 Deckblatt BP","2 textliche Beschreibung -Excel","3.Investitionsbedarf 2.3.2 ","4.Investitionsbedarf 2.3.1  ","5. Finanzierungsmittel ","6.KrediteKap.dienst ","7. Feste Kosten ","8. Veränderl. Kosten ","9. Einkommensbeitrag ","10. Erfolgskennzahlen(IK)  ","11.Liqu.plan kopierfähig","12.Unternehmen(IK)","nicht förderfähig","Bearbeitung"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":19,"comments":13,"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":"1 Deckblatt BP","index":0,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,2,40,3],[42,2,42,3],[38,2,38,3],[36,2,36,3],[28,1,28,3],[2,1,2,2],[3,1,3,2],[34,1,34,3],[1,1,1,3],[4,1,4,2],[30,1,30,3],[32,2,32,3],[20,1,20,2],[24,1,24,3],[22,1,22,2],[7,1,7,3],[8,1,8,3],[14,1,14,3],[16,1,16,3],[18,2,18,3]]}
[]
[null,"Kreisstellen Rhein-Erft-Kreis, Rhein-Kreis Neuss, Rhein-Sieg-Kreis",null,null,null,"Kreisstellen Höxter, Lippe, Paderborn"]
[null,"Birgit Biermann",null,"Tel.: 0221 - 5340 108",null,"Kreisstellen Rhein-Erft-Kreis, Rhein-Kreis Neuss, Rhein-Sieg-Kreis"]
[null,"Beraterin für Urlaub auf dem Bauernhof, Bauernhofgastronomie,",null,"Fax: 0221 - 5340 199",null,"Kreisstelle Steinfurt"]
[null,"     Antragstellung Förderprogramm Diversifizierung",null,"E-Mail: birgit.biermann@lwk.nrw.de"]
[]
[]
[null," Wirtschaftlichkeitsrechnung - INVESTITIONSKONZEPT"]
[null,"als Anlage zum Diversifizierungsantrag "]
[]
[null,"Name/Anschrift des Antragstellers / der Antragstellerin"]
[null,"Nachname/Unternehmensbezeichnung"]
[]
[null,"Vorname"]
[]
[null,"Straße"]
[]
[null,"PLZ","Ort"]
[]
[null,"ZID-Nummer",null,"Unternehmensnummer"]
[]
[null,"Telefon",null,"Fax"]
[]
[null,"E-Mail"]
[]
[]
[null,"Name/Anschrift des landwirtschaftlichen Betriebes, falls abweichend"]
[null,"Vor- und Nachname/Unternehmensbezeichnung"]
[]
[null,"Straße"]
[]
[null,"PLZ","Ort"]
[]
[null,"Unternehmensnummer"]
[]
[]
[null,"Vorhaben",null,null,null,"Hinweis: Ist der Text länger als in den Kasten passt,von Hand das Textfeld länger ziehen und die Zeilenhöhe anpassen, sonst wird nur ein Teil des Textes angezeigt/ gedruckt.\nBitte immer kontrollieren, da sonst nur der obere Teil vom Text gezeigt wird."]
[null,"Planung bezieht sich auf folgenden Zeitrahmen für die Umsetzung (max. 3 Jahre):"]
[null,"von/bis Monat/Jahr"," von  3/2013                       bis          2/2016   "]
[]
[null,"Vorhaben \ngewerblich"]
[]
[null,"Datum:"]

{"sheet":"2 textliche Beschreibung -Excel","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,2,2],[5,2,6,2]]}
["Textliche Beschreibung des Vorhabens  "]
[" (Ergänzung und Erläuterung zum Excel-Div-IK)"]
[]
["Antragsteller/in:"]
[{"$f":"'1 Deckblatt BP'!B13","v":0}]
["Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]

{"sheet":"3.Investitionsbedarf 2.3.2 ","index":2,"n_rows":72,"n_cols":25,"rows_kept":72,"cut":false,"hidden":false,"merged":[[55,1,55,2],[7,23,9,23],[7,5,8,5],[8,11,10,11],[0,11,0,14],[2,11,2,14],[1,11,1,14],[53,7,53,11],[69,7,70,14],[68,8,68,11],[8,12,9,14],[8,7,10,7],[8,8,10,8],[8,9,10,9],[8,10,10,10],[54,7,54,11],[48,7,48,8],[49,7,49,8],[50,7,50,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8]]}
[null,null,null,"Vorsteuer %",null,null,null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,null,null,0.19,"Geb/Maschinen  ",null,null,null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,null,7.0000000000000007E-2,"Tierkauf/Dauerkulturen",null,null,null,null,null,"Datum",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"}]
[]
[]
[]
["Kapitalbedarf nach 2.3.2",null,null,"Berechnung der förderbaren Investitionen"]
["(auch Erweiterung ist förderbar)",null,null,null,null,"nicht zu-wend'fäh. Ausgaben Netto","zuwend'f.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nicht zu-wend'fäh. Ausgaben brutto"]
[null,null,null,"Ausgaben","Vorsteuer",null,"Invest.-","Nut-zungs-dauer (Jahre)\nn","AFA %","AFA \nin Euro","Instandh. %","Inst.haltg.  Euro","Investition soll erfolgen im Förderjahr (FJ)"]
[null,"Bauliche Maßnahmen / ",null,null,null,null,"volumen"]
[null,"unbewegliches Vermögen",null,"€","€","€","€",null,null,null,null,null,"1. FJ","2 FJ","3 FJ",null,null,null,null,null,null,null,null,"€"]
[1,null,null,null,{"$f":"D12/(1+$D$2)*$D$2","v":0},null,{"$f":"IF(D12=0,0,D12-SUM(E12:F12))","v":0},1,{"$f":"IF(H12=0,0,1/H12)","v":1},{"$f":"(G12+F12)*I12","v":0},0.02,{"$f":"(G12+F12)*K12","v":0},{"$f":"G12-N12-O12","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"F12*1.19","v":0}]
[2,null,null,null,0,null,0,1,{"$f":"IF(H13=0,0,1/H13)","v":1},0,0.02,0,0,0,0,null,null,null,null,null,null,null,null,0]
[3,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,0,null,0,1,1,0,0.02,0,0,0,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,0,null,0,1,1,0,0.02,0,0,0,0,null,null,null,null,null,null,null,null,0]
[16,null,null,null,{"$f":"D27/(1+$D$2)*$D$2","v":0},null,{"$f":"IF(D27=0,0,D27-SUM(E27:F27))","v":0},1,1,{"$f":"(G27+F27)*I27","v":0},0.02,{"$f":"(G27+F27)*K27","v":0},0,null,null,null,null,null,null,null,null,null,null,0]
[17," Summe Kosten unbewegliches Vermögen",null,{"$f":"SUM(D12:D27)","v":0},{"$f":"SUM(E12:E27)","v":0},{"$f":"SUM(F12:F27)","v":0},{"$f":"SUM(G12:G27)","v":0},"Summe Afa Baul. Maßn.",null,null,null,{"$f":"SUM(J12:J27)","v":0},{"$f":"SUM(M12:M27)","v":0},{"$f":"SUM(N12:N27)","v":0},{"$f":"SUM(O12:O27)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(X12:X27)","v":0}]
[18," Maschinen u. Anlagen der Innenwirtschaft",null,null,null,null,null,"Summe Instandh. Baul. Maßn.",null,null,null,{"$f":"SUM(L12:L27)","v":0}]
[19," (bewegl. Vermögen)"]
[20,null,null,null,{"$f":"D31/(1+$D$2)*$D$2","v":0},null,{"$f":"IF(D31=0,0,D31-SUM(E31:F31))","v":0},1,{"$f":"IF(H31=0,0,1/H31)","v":1},{"$f":"(G31+F31)*I31","v":0},0.02,{"$f":"(G31+F31)*K31","v":0},{"$f":"G31-N31-O31","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"F31*1.19","v":0}]
[21,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,0,null,0,1,1,{"$f":"(G37+F37)*I37","v":0},0.02,{"$f":"(G37+F37)*K37","v":0},{"$f":"G37-N37-O37","v":0},null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,0,null,0,1,1,{"$f":"(G38+F38)*I38","v":0},0.02,{"$f":"(G38+F38)*K38","v":0},{"$f":"G38-N38-O38","v":0},null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,0,null,0,1,1,{"$f":"(G39+F39)*I39","v":0},0.02,{"$f":"(G39+F39)*K39","v":0},{"$f":"G39-N39-O39","v":0},null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,0,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,{"$f":"SUM(D31:D45)","v":0},{"$f":"SUM(E31:E45)","v":0},{"$f":"SUM(F31:F45)","v":0},{"$f":"SUM(G31:G45)","v":0},"Summe Afa Einr. /Ausst.",null,null,null,{"$f":"SUM(J31:J45)","v":0},{"$f":"SUM(M31:M45)","v":0},{"$f":"SUM(N31:N45)","v":0},{"$f":"SUM(O31:O45)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(X48:X58)","v":0}]
[36,null,null,null,null,null,null,"Summe Instandh. Einr./Ausst.",null,null,null,{"$f":"SUM(L31:L45)","v":0}]
[37,"Baugenehmigung (MwStfrei)",null,null,null,null,{"$f":"IF(D48=0,0,D48-SUM(E48:F48))","v":0},null,null,"ohne Beratungsgebühr",null,null,{"$f":"G48-N48-O48","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"F48","v":0}]
[38,"                                       (MwStfrei)",null,null,null,null,{"$f":"IF(D49=0,0,D49-SUM(E49:F49))","v":0},{"$f":"G28+G46+G48+G49+G50+G51+G52+G53+G54+G55+G57+G58","v":0},null,"ff. Ausgaben 2.3.2",null,{"$f":"H49*L51/H51","v":{"$error":"#DIV/0!"}},0,null,null,null,null,null,null,null,null,null,null,{"$f":"F49","v":0}]
[39,"                                       (MwStfrei)",null,null,null,null,{"$f":"IF(D50=0,0,D50-SUM(E50:F50))","v":0},{"$f":"'5. Finanzierungsmittel '!G9+'5. Finanzierungsmittel '!G12+'5. Finanzierungsmittel '!G13+'5. Finanzierungsmittel '!G14+'5. Finanzierungsmittel '!G15+'5. Finanzierungsmittel '!G17+'5. Finanzierungsmittel '!G20+'5. Finanzierungsmittel '!G21","v":0},null,"ff. Ausgaben Rest",null,{"$f":"L51-L49","v":{"$error":"#DIV/0!"}},0,null,null,null,null,null,null,null,null,null,null,{"$f":"F50","v":0}]
[40,"Architektenleistungen  ",null,null,{"$f":"D51/(1+$D$2)*$D$2","v":0},null,{"$f":"IF(D51=0,0,D51-SUM(E51:F51))","v":0},{"$f":"H49+H50","v":0},null,"ff. Ausgaben gesamt",null,1,0,null,null,null,null,null,null,null,null,null,null,{"$f":"F51*1.19","v":0}]
[41,"Ingenieurs-,Statikerleistungen",null,null,null,null,0,{"$f":"'5. Finanzierungsmittel '!G15+'5. Finanzierungsmittel '!G16+'5. Finanzierungsmittel '!G17","v":{"$error":"#DIV/0!"}},null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"F52*1.19","v":0}]
[42,null,null,null,0,null,0,null,null,{"$f":"IF(H52>2000,\"Mindestzuschuss Orga.kosten erreicht\",\"Mindestzuschuss Orga.kosten nicht erreicht!\")","v":{"$error":"#DIV/0!"}},null,null,0,null,null,null,null,null,null,null,null,null,null,0]
[43,"Ausgleichspflanzung",null,null,0,null,0,{"$f":"IF(G56<1000,\"Achtung, Mindestgebühr 1000 Euro nicht erreicht, von Hand korrigieren\", \" \")","v":{"$error":"#DIV/0!"}},null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0]
[45,"förderfähiges Betreuungs-/Beratungsgebühr für 2.3.2",null,{"$f":"G56*1.19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"H57+IF(H58>2000,H57,H58)","v":{"$error":"#DIV/0!"}},null,null,"Gesamtgebühr lt. Vertrag netto",null,null,{"$error":"#DIV/0!"},null,0,null,null,null,null,null,null,null,null,0]
[46,"Beratung zum Bauvorhaben",null,null,{"$f":"D57/(1+$D$2)*$D$2","v":0},null,{"$f":"IF(D57=0,0,D57-SUM(E57:F57))","v":0},{"$f":"H56*L49","v":{"$error":"#DIV/0!"}},null,"Anteil Gebühr 2.3.2",null,{"$f":"H57*L59/H59","v":{"$error":"#DIV/0!"}},0,null,null,null,null,null,null,null,null,null,null,0]
[47,"Erwerb Patentrechte/Lizenzen/So. Genehmigungen",null,null,{"$f":"D58/(1+$D$2)*$D$2","v":0},null,{"$f":"IF(D58=0,0,D58-SUM(E58:F58))","v":0},{"$f":"H56*L50","v":{"$error":"#DIV/0!"}},null,"Gebühr Rest",null,{"$f":"L59-L57","v":{"$error":"#DIV/0!"}},0,null,null,null,null,null,null,null,null,null,null,0]
[48," Summe Allgemeine Aufwendungen ",null,{"$f":"SUM(D48:D58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E49:E58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F48:F58)","v":0},{"$f":"SUM(G48:G58)","v":{"$error":"#DIV/0!"}},{"$f":"H57+H58","v":{"$error":"#DIV/0!"}},null,"Netto-Gebühr gesamt",null,1,{"$f":"SUM(M48:M58)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N48:N58)","v":0},{"$f":"SUM(O48:O58)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(X48:X58)","v":0},"Summe nicht förderf. allg. Aufwendungen brutto"]
[49,"    Obergrenze 12 % (netto):",null,null,null,null,{"$f":"(G46+G28)*0.12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X48+X49+X50","v":0},"Summe nicht förderf. allg. Aufwendungen (MwSt-freie Positionen)"]
[50," Summe förderfähige Allgemeine Aufwendungen ",null,{"$f":"D59","v":{"$error":"#DIV/0!"}},{"$f":"E59","v":{"$error":"#DIV/0!"}},{"$f":"D61-E61-G61","v":{"$error":"#DIV/0!"}},{"$f":"IF(G59>G60,G60,G59)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X59-X60","v":0},"Summe nicht förderf. allg. Aufwendungen (MwSt-pflichtige Positionen)"]
[51,null,null,null,{"$f":"D62/(1+$D$2)*$D$2","v":0},{"$f":"D62-E62","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D62","v":0}]
[52,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[54,"Grundstückskauf (ohne MwSt.)",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[55,"Tieraufstockung (Formel hier mit 7 % MwSt!!)",null,null,{"$f":"D66/(1+$D$3)*$D$3","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"7 % MwSt."]
[56,"Summe mit der Baumaßnahme/der Erweiterung verbundener, aber nicht förderfähiger Kosten",null,{"$f":"SUM(D62:D66)","v":0},{"$f":"SUM(E62:E66)","v":0},{"$f":"SUM(F62:F66)","v":0},{"$f":"SUM(G62:G66)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X62:X66)","v":0}]
[57,"Summe aller Investitionen ",null,{"$f":"D67+D61+D46+D28","v":{"$error":"#DIV/0!"}},{"$f":"E67+E61+E46+E28","v":{"$error":"#DIV/0!"}},{"$f":"F67+F61+F46+F28","v":{"$error":"#DIV/0!"}},{"$f":"G67+G61+G46+G28+F28+F46+F61+F67","v":{"$error":"#DIV/0!"}}]
[58,"Förderfähiger Investitionsvolumen ",null,null,null,null,{"$f":"G61+G46+G28","v":{"$error":"#DIV/0!"}}]
[59,"bereits erhaltene Förderung, die anzurechnen ist (DeMinimis)",null,null,null,null,null,{"$f":"IF(G69<10000,\"Achtung, Bagatellgrenze von 10.000 Euro Mindestinvestitionsvolumen bei 2.3.2 nicht erreicht\", \" \")","v":{"$error":"#DIV/0!"}}]
[60,"noch förderbares Investitionsvolumen",null,null,null,null,{"$f":"G69-G70","v":{"$error":"#DIV/0!"}}]
[61,"Förderbetrag (20 %, max. 100.000 Euro) ",null,null,null,null,{"$f":"IF(G69*0.2>100000,100000,G69*0.2)","v":{"$error":"#DIV/0!"}}]

{"sheet":"4.Investitionsbedarf 2.3.1  ","index":3,"n_rows":69,"n_cols":24,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,12,0,14],[6,23,8,23],[36,23,38,23],[7,12,9,12],[5,4,5,7],[1,12,1,15],[2,12,2,15],[7,8,9,8],[37,13,37,15],[7,13,8,15],[68,1,68,7],[7,11,9,11],[7,9,9,9],[7,10,9,10],[65,1,65,7],[6,6,8,6],[35,4,35,7],[36,6,38,6],[38,0,39,1]]}
[null,null,null,null,"Vorsteuer %",null,null,null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,null,null,null,0.19,"Geb/Maschinen  ",null,null,null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,null,null,7.0000000000000007E-2,"Tierkauf/Dauerkulturen",null,null,null,null,null,"Datum",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"}]
[]
[]
["Kapitalbedarf nach 2.3.1",null,null,null,"Berechnung der förderbaren Investitionen"]
["(nur neue Betriebszweige sind förderbar)",null,null,null,null,null,"nicht zu-wend'fäh. Ausgaben Netto","zuwend'f.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nicht zu-wend'fäh. Ausgaben Brutto"]
[null,null,null,null,"Ausgaben","Vorsteuer",null,"Invest.-","Nut-zungs-dauer (Jahre)\nn","AFA %","AFA \nin Euro","Instandh. %","Inst.haltg. in Euro","Investition soll erfolgen im Förderjahr (FJ)"]
["Investitionen für Einrichtung u. Ausstattung",null,null,null,null,null,null,"volumen"]
[null,null,null,null,"€","€","€","€",null,null,null,null,null,"1. FJ","2 FJ","3 FJ",null,null,null,null,null,null,null,"€"]
[1,null,null,null,null,{"$f":"E11/(1+$E$2)*$E$2","v":0},null,{"$f":"IF(E11=0,0,E11-SUM(F11:G11))","v":0},1,{"$f":"IF(I11=0,0,1/I11)","v":1},{"$f":"(H11+G11)*J11","v":0},0.02,{"$f":"(H11+G11)*L11","v":0},{"$f":"H11-O11-P11","v":0},null,null,null,null,null,null,null,null,null,{"$f":"G11*1.19","v":0}]
[2,null,null,null,null,0,null,0,1,{"$f":"IF(I12=0,0,1/I12)","v":1},0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,0,null,0,1,1,0,0.02,0,0,0,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,0,0,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,0,null,0,1,1,0,0.02,0,0,0,null,null,null,null,null,null,null,null,0]
[15,null,null,null,0,0,0,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,0,null,0,1,1,0,0.02,0,0,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,0,null,{"$f":"IF(E33=0,0,E33-SUM(F33:G33))","v":0},1,1,{"$f":"(H33+G33)*J33","v":0},0.02,{"$f":"(H33+G33)*L33","v":0},0,null,null,null,null,null,null,null,null,null,0]
[24,"Summe Sachausg./Inv. in Einrichtung/Ausst.",null,null,{"$f":"SUM(E11:E33)","v":0},{"$f":"SUM(F11:F33)","v":0},{"$f":"SUM(G11:G33)","v":0},{"$f":"SUM(H11:H33)","v":0},"Summe Afa Einr. /Ausst.",null,null,null,{"$f":"SUM(K11:K33)","v":0},{"$f":"SUM(N11:N33)","v":0},{"$f":"SUM(O11:O33)","v":0},{"$f":"SUM(P11:P33)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(X11:X33)","v":0}]
[25,"Förderbetrag  nach 2.3.1 Einrichtung/Austattung (25 %, max. 25.000 Euro) *",null,null,null,null,null,{"$f":"IF(H34*0.25>=25000,\"25000\",IF(H34*0.25<25000,H34*0.25))","v":0},"Summe Instandhaltung Einr./Ausst.",null,null,null,{"$f":"SUM(M11:M33)","v":0}]
["Kapitalbedarf nach 2.3.1",null,null,null,"Berechnung der förderbaren Investitionen"]
["(nur neue Betriebszweige sind förderbar)",null,null,null,null,null,"nicht zu-wend'fäh. Ausgaben Netto","zuwend'f.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nicht zu-wend'fäh. Ausgaben Brutto"]
[null,null,null,null,"Ausgaben","Vorsteuer",null,"Invest.-",null,null,null,null,null,"Investition soll erfolgen im Förderjahr (FJ)"]
["Investitionen in So. Sachausgaben\n                          / Marketing",null,null,null,null,null,null,"volumen"]
[null,null,null,null,"€","€","€","€",null,null,null,null,null,"1. FJ","2 FJ","3 FJ",null,null,null,null,null,null,null,"€"]
[{"$f":"A35+1","v":26},null,null,null,null,{"$f":"E41/(1+$E$2)*$E$2","v":0},null,{"$f":"IF(E41=0,0,E41-SUM(F41:G41))","v":0},null,null,null,null,null,{"$f":"H41-O41-P41","v":0},null,null,null,null,null,null,null,null,null,{"$f":"G41*1.19","v":0}]
[{"$f":"A41+1","v":27},null,null,null,null,0,null,0,null,null,null,null,null,{"$f":"H42-O42-P42","v":0},null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[33,null,null,null,0,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[35,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[36,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[37,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[38,null,null,null,0,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[39,null,null,null,null,{"$f":"E54/(1+$E$2)*$E$2","v":0},null,{"$f":"IF(E54=0,0,E54-SUM(F54:G54))","v":0},null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[40,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[41,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[42,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[43,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[44,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[45,null,null,null,null,0,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[46,"Versicherung (ohne Mwst.)",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[47,"Versicherung (ohne Mwst.)",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[48," Summe Sonstige Sachausgaben (Marketing)",null,null,{"$f":"SUM(E41:E62)","v":0},{"$f":"SUM(F41:F62)","v":0},{"$f":"SUM(G41:G62)","v":0},{"$f":"SUM(H41:H62)","v":0},null,null,null,null,null,{"$f":"SUM(N41:N62)","v":0},{"$f":"SUM(O41:O62)","v":0},{"$f":"SUM(P41:P62)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(X41:X62)","v":0}]
[49,"Förderbetrag  nach 2.3.1 Marketingausgaben (50 %, max. 25.000 Euro) *",null,null,null,null,null,{"$f":"IF(H63*0.5>25000,25000,H63*0.5)","v":0}]
[null,{"$f":"IF(H35+H64<999.9,\"Achtung, Bagatellgrenze von 1000 Euro Zuschuss bei 2.3.1 nicht erreicht\", \" \")","v":"Achtung, Bagatellgrenze von 1000 Euro Zuschuss bei 2.3.1 nicht erreicht"}]
[null,"* Soll auch im Bereich 2.3.2 Förderung beantragt werden, ist die Aufteilung der Förderung auf die Module im Rahmen der Obergrenze von 200.000 Euro individuell vorzunehmen, und der Förderbetrag hier entsprechend zu korrigieren"]
[]
[]
[null,"Für 2.3.1 und sonstige förderfähige Nicht-GAKG-Kosten muss auf Basis der tatsächlich beantragten förderfähigen Kosten die Beratungsgebühr ausgerechnet werden, und im Dienstleistungsvertrag zusammen mit den nach 2.3.2 anfallenden  Gebühren in Rechnung gestellt werden.\nDiese Kosten sind grundsätzlich förderbar. Die Gesamtbetreuungsgebühr wird im gleichen prozentualen Verhältnis von förderfähigen GAKG- und Nicht-GAKG-Kosten auf GAKG (20 %-Förderung) und Nicht-GAKG (50 % Förderung) aufgeteilt."]

{"sheet":"5. Finanzierungsmittel ","index":4,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[51,5,51,6],[40,1,40,4],[47,5,47,6],[27,1,27,3],[24,1,24,3],[26,1,26,3],[50,1,50,4],[45,1,45,4],[47,1,47,4],[25,1,25,3],[36,1,36,4],[48,5,48,6],[49,2,49,4],[52,5,52,6],[44,5,44,6],[32,5,32,6],[33,5,33,6],[35,5,35,6],[37,5,37,6],[40,5,40,6],[39,5,39,6],[34,5,34,6],[38,5,38,6],[42,5,42,6],[50,5,50,6],[49,5,49,6],[46,5,46,6],[45,5,45,6],[36,5,36,6],[54,1,54,2],[28,1,28,3],[53,1,53,2],[32,1,32,4],[38,1,38,4],[37,1,37,4],[44,1,44,4],[33,1,33,4],[52,1,52,4],[35,1,35,4],[42,1,42,4],[34,1,34,4],[39,1,39,4],[51,1,51,4],[46,1,46,4],[0,5,0,6],[1,5,1,6],[2,5,2,6],[7,1,7,3],[8,1,8,3],[23,1,23,3],[10,1,10,3],[14,1,14,3],[13,1,13,3],[16,1,16,3],[20,1,20,3],[12,1,12,3],[11,1,11,3],[17,1,17,3],[19,1,19,3],[21,1,21,3],[22,1,22,3],[18,1,18,3],[15,1,15,3]]}
[null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0},null,0.19,"Vorsteuer"]
[null,null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,null,null,"Datum",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"}]
["3. Kapitalbedarf / Finanzierungsmittel"]
[]
[]
[1,"Kapitalbedarf nach 2.3.1 u. 2.3.2",null,null,"Ausgaben brutto","Vorsteuer","Ausgaben netto"]
[2,"Summe aller Investitionen nach 2.3.2 (Übertrag)",null,null,{"$f":"'3.Investitionsbedarf 2.3.2 '!D68","v":{"$error":"#DIV/0!"}},{"$f":"'3.Investitionsbedarf 2.3.2 '!E68","v":{"$error":"#DIV/0!"}},{"$f":"E8-F8","v":{"$error":"#DIV/0!"}}]
[3,"Summe aller Investitionen nach 2.3.1 (Übertrag)",null,null,{"$f":"'4.Investitionsbedarf 2.3.1  '!E34+'4.Investitionsbedarf 2.3.1  '!E63","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!F34+'4.Investitionsbedarf 2.3.1  '!F63","v":0},{"$f":"E9-F9","v":0}]
[]
[4,"Kapitalbedarf für Anlaufkosten / zu berücksichtigender Kapitalbedarf",null,null,"Ausgaben brutto","Vorsteuer","Ausgaben netto"]
[5,"förderfähige Löhne im 1. Jahr",null,null,null,null,{"$f":"E12-F12","v":0},"Finanzierbarkeit Löhne im 1. Jahr muss über Zuschuss + Eigenmittelnachweis/Kreditbereitschaftserklärung nachgewiesen werden"]
[6,"förderfähige Löhne im 2. Jahr",null,null,null,null,{"$f":"E13-F13","v":0},"Daten in den Liquditätsplan übernehmen"]
[7,"förderfähige Löhne im 3. Jahr",null,null,null,null,{"$f":"E14-F14","v":0},"Daten in den Liquditätsplan übernehmen"]
[8,"förderfähige Orga.-Kosten mit MwSt.\nohne Betreuungs-/Beratungsgebühr für 2.1-2.3.1, 2.4",null,null,null,{"$f":"E15*$H$1/(100%+$H$1)","v":0},{"$f":"E15-F15","v":0},"muss auf jeden Fall von der DIV-Beraterin angepasst werden, damit die Zahl zum Antrag passt"]
[9," förderfähige Orga.-Kosten mit MwSt. - \nnur Betreuungs-/Beratungsgebühr für 2.1-2.3.1, 2.4",null,null,{"$f":"G16*1.19","v":{"$error":"#DIV/0!"}},{"$f":"E16-G16","v":{"$error":"#DIV/0!"}},{"$f":"'3.Investitionsbedarf 2.3.2 '!H58","v":{"$error":"#DIV/0!"}},{"$f":"'3.Investitionsbedarf 2.3.2 '!H58:I58","v":{"$error":"#DIV/0!"}},"aus 3. Investitionsbedarf 2.3.2 Zelle H 58"]
[10,"förderfähige Orga.-Kosten ohne MwSt. (z.B. Konzession)",null,null,null,null,0,"muss auf jeden Fall von der DIV-Beraterin angepasst werden, damit die Zahl zum Antrag passt"]
[11,"Orga.-Kosten mit MwSt. - Nicht förderfähig",null,null,null,0,0,"muss von der DIV-Beraterin eingetragen werden, damit die Zahl zum Antrag passt (z.B. von einem Gutachten sind nur 50 % förderfähig, dann den Rest hier eintragen"]
[12,"Orga.-Kosten ohne MwSt. - Nicht förderfähig",null,null,null,null,0]
[13,"förderfähige Qualifizierungskosten mit MwSt.",null,null,null,0,0,"hier den Kapitalbedarf von z.B. förderfähigen Schulungen mit Mwst eintragen"]
[14,"förderfähige Qualifizierungskosten ohne MwSt.",null,null,null,null,{"$f":"E21-F21","v":0},"hier den Kapitalbedarf von z.B. förderfähigen Schulungen eintragen, die Mwst-frei sind"]
[15,"Qualifizierungskosten mit MwSt. - Nicht förderfähig",null,null,null,0,{"$f":"E22-F22","v":0},"muss von der DIV-Beraterin eingetragen werden, damit die Zahl zum Antrag passt (z.B. wenn Kosten über dem Reisekostengesetz liegen, dann den Rest hier eintragen"]
[16,"Qualifizierungskosten ohne MwSt. - Nicht förderfähig",null,null,null,null,0,"muss von der DIV-Beraterin eingetragen werden, damit die Zahl zum Antrag passt (z.B. wenn nut teil eines Seminars der Maßnahme dient, dann den Rest hier eintragen"]
[17,"Vorauszahlung Beiträge, Versicherung, Steuer (nf)",null,null,null,0,0,"nicht förderfähig"]
[18,"Erster Warenbestand (nf)",null,null,null,0,0,"nicht förderfähig"]
[19,"Sonstiges (ohne MwSt.) (nf)",null,null,null,null,0,"nicht förderfähig"]
[20,"Sonstiges (mit MwSt.) (nf)",null,null,null,0,0,"nicht förderfähig"]
[21,"Reserveaufschlag (nf)",null,null,null,0,0,"nicht förderfähig"]
[22,"Anlaufkosten / Reserveaufschlag insgesamt            ",null,null,{"$f":"SUM(E12:E28)-E16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F12:F28)-F16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G12:G28)","v":{"$error":"#DIV/0!"}}]
[23,"Summe Kapitalbedarf ",null,null,{"$f":"E29+E9+E8","v":{"$error":"#DIV/0!"}},{"$f":"F29+F9+F8","v":{"$error":"#DIV/0!"}},{"$f":"G29+G9+G8","v":{"$error":"#DIV/0!"}}]
[]
[24,"Finanzierungsplan"]
[25,"Barmittel/Guthaben",null,null,null,0,null,"Betrag muss über das Formblatt \"Eingemttelnachweis\" belegt werden."]
[26,"aus laufender EK-Bildung "]
[27,"aus dem Ertrag zu finanzierende Lohnkosten im 2. Jahr",null,null,null,{"$f":"G13-F46","v":0},null,"Der Liquiditätsplan muss zeigen, dass diese Lohnkosten aus dem Ertrag zu finanzieren sind!"]
[28,"aus dem Ertrag zu finanzierende Lohnkosten im 3. Jahr",null,null,null,{"$f":"G14-F47","v":0},null,"Der Liquiditätsplan muss zeigen, dass diese Lohnkosten aus dem Ertrag zu finanzieren sind!"]
[29,null,null,null,null,null,null,"Zeile frei ausfüllbar, z.B. Finanzierung förderfähiger Schulungen aus dem Ertrag, etc."]
[30,"Erstattung Vorsteuer (Opt. zur Regelbest.)",null,null,null,{"$f":"F30","v":{"$error":"#DIV/0!"}},null,"ggf. den Wert korrigieren, falls z.B. bei Koop. der landw. Betrieb keine Vorsteuererstattung für die Gebäudeinvestition bekommt"]
[31,"Sonstige Erlöse (Verkauf Grundstücke, o.ä.)",null,null,null,0,null,"Zeile frei überschreibbar"]
[32,"Leistungen Dritter",null,null,null,0]
[33,"Summe Eigenkapital",null,null,null,{"$f":"SUM(F33:G40)","v":{"$error":"#DIV/0!"}}]
[]
[34,"Übertrag Vorseite: Summe Eigenkapital",null,null,null,{"$f":"F41","v":{"$error":"#DIV/0!"}},null,{"$f":"IF((F51+F52)>200000,\"Achung, maximale Fördersumme von 200.000 Euro bereits überschritten\", \" \")","v":{"$error":"#DIV/0!"}}]
[]
[35,"Lohnzuschuss für das 1. Jahr",null,null,null,{"$f":"IF((E12*0.6+E13*0.5+E14*0.4)<1000,0,IF(E12*0.6<24000,E12*0.6,24000))","v":0},null,"Daten in den Liquditätsplan übernehmen"]
[36,"Lohnzuschuss für das 2. Jahr",null,null,null,{"$f":"IF((E12*0.6+E13*0.5+E14*0.4)<1000,0,IF(E13*0.5<20000,E13*0.5,20000))","v":0},null,"Daten in den Liquditätsplan übernehmen"]
[37,"Lohnzuschuss für das 3. Jahr",null,null,null,{"$f":"IF((E12*0.6+E13*0.5+E14*0.4)<1000,0,IF(E14*0.4<16000,E14*0.4,16000))","v":0},null,"Daten in den Liquditätsplan übernehmen"]
[38,"Zuschuss Orga.-Kosten",null,null,null,{"$f":"IF((G15+G16+G17)*0.5<1000,0,IF((G15+G16+G17)*0.5<25000,(G15+G16+G17)*0.5,25000))","v":{"$error":"#DIV/0!"}},null,"Daten in den Liquditätsplan übernehmen, auf die Verteilung (ggf. auch im 2. Jahr) achten."]
[39,"Zuschuss Qualifizierungskosten",null,null,null,{"$f":"IF((G20+G21)*0.8<200,0,IF((G20+G21)*0.8<1000,(G20+G21)*0.8,1000))","v":0}]
[40,"Sonst. öffentl. Förderung"]
[41,"Möglicher Zuschuss nach 2.3.1 ",null,null,null,{"$f":"'4.Investitionsbedarf 2.3.1  '!H35+'4.Investitionsbedarf 2.3.1  '!H64","v":0}]
[42,"Möglicher Zuschuss nach 2.3.2",null,null,null,{"$f":"'3.Investitionsbedarf 2.3.2 '!G72","v":{"$error":"#DIV/0!"}}]
[43,"Summe Zuschüsse",null,null,null,{"$f":"SUM(F45:G52)","v":{"$error":"#DIV/0!"}}]
[]
[44,"Fremdkapitalaufnahme für das Vorhaben"]
[null,null,"Darlehenssumme in EURO"]
[45,"Darlehen 1",{"$f":"E30-F41-F53-C58-C59-C60","v":{"$error":"#DIV/0!"}},null,null,null,null,"FK-Höhe muss über das Formblatt \"Kreditbereitschaftserklärung\" belegt werden."]
[46,"Darlehen 2"]
[47,"Darlehen 3"]
[48,"Darlehen 4"]
[49,"Summe",{"$f":"SUM(C57:C60)","v":{"$error":"#DIV/0!"}}]

{"sheet":"6.KrediteKap.dienst ","index":5,"n_rows":38,"n_cols":41,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,14,4,15],[6,20,6,22],[6,26,6,28],[6,29,6,31],[6,38,6,40],[31,38,34,40],[6,23,6,25],[6,32,6,34],[37,33,37,34],[37,36,37,37],[37,39,37,40],[31,23,34,25],[31,26,34,28],[31,29,34,31],[31,32,34,34],[31,35,34,37],[6,35,6,37],[0,16,0,17],[0,39,0,40],[1,39,1,40],[2,39,2,40],[0,30,0,31],[1,30,1,31],[2,30,2,31],[1,16,1,17],[2,16,2,17],[37,21,37,22],[37,24,37,25],[37,27,37,28],[37,30,37,31],[31,20,34,22]]}
[null,"Erfassung der Gesamtkreditbelastung zur Sicherung der Finanzierbarkeit im Gesamtkontext Betrieb/Familie",null,null,null,null,null,null,null,null,null,null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Betrieb: ",{"$f":"Q1","v":0},null,null,null,null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unternehmensnummer:",{"$f":"'1 Deckblatt BP'!D21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Unternehmensnummer:",{"$f":"Q2","v":0},null,null,null,null,null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null," Kredite und Kapitaldienst",null,null,null,null,null,null,null,null,null,5,"Zahl der Jahre zwischen Ist und Ziel",null,null,"Datum",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"},null,null,null,null,"Entwicklung der Darlehensstände / des Kapitaldienstes",null,null,null,null,null,null,null,"Datum",{"$f":"Q3","v":"00:00:00"},null,null,null,null,null,null,null,"Datum",{"$f":"AE3","v":"00:00:00"}]
[]
[null,null,"  Bank und Kto.- Nr.","Beginn","Evtl.","Falls","Nenn-","Zins-","Tilg-","Falls Annuit.-",{"$f":"'1 Deckblatt BP'!C43","v":"00:00:00"},{"$f":"DATE(YEAR(K5)+L3+1,MONTH(A3),DAY(A3))","v":"1905-12-31"},{"$f":"K5","v":"00:00:00"},null,{"$f":"L5","v":"1905-12-31"},null,null,"Bilanz Buchf.:",null,null,null,null,0]
[null,"Nr.",null,"neues","P","Annu.-","betrag","satz","ung","Darlehen:",null,null,null,null,null,null,null,"2011-06-30"]
[null,"d.","Verwendungszweck","Darl. im","oder","darl.:",null,"(verbill.)",null,"Annuität","Valuta ","Valuta ","Zins","Tilgung","Zins","Tilgung",null,"Valuta ",null,null,{"$f":"K5","v":"00:00:00"},null,null,{"$f":"DATE(YEAR(U7)+1,MONTH(U7),DAY(U7))","v":"1900-12-31"},{"$f":"DATE(YEAR(AH9)+Y5,MONTH(N5),DAY(N5))","v":"00:00:00"},{"$f":"DATE(YEAR(AI9)+Z5,MONTH(O5),DAY(O5))","v":"1900-12-31"},{"$f":"DATE(YEAR(X7)+1,MONTH(X7),DAY(X7))","v":"1901-12-31"},{"$f":"DATE(YEAR(AK9)+AB5,MONTH(Q5),DAY(Q5))","v":"00:00:00"},{"$f":"DATE(YEAR(AL9)+AC5,MONTH(R5),DAY(R5))","v":{"$error":"#VALUE!"}},{"$f":"DATE(YEAR(AA7)+1,MONTH(AA7),DAY(AA7))","v":"1902-12-31"},{"$f":"DATE(YEAR(AN9)+AE5,MONTH(T5),DAY(T5))","v":"00:00:00"},{"$f":"DATE(YEAR(AO9)+AF5,MONTH(U5),DAY(U5))","v":"00:00:00"},{"$f":"DATE(YEAR(AD7)+1,MONTH(AD7),DAY(AD7))","v":"1903-12-31"},{"$f":"DATE(YEAR(AQ9)+AH5,MONTH(W5),DAY(W5))","v":"00:00:00"},{"$f":"DATE(YEAR(AR9)+AI5,MONTH(X5),DAY(X5))","v":"00:00:00"},{"$f":"DATE(YEAR(AG7)+1,MONTH(AG7),DAY(AG7))","v":"1904-12-31"},{"$f":"DATE(YEAR(AT9)+AK5,MONTH(Z5),DAY(Z5))","v":"00:00:00"},{"$f":"DATE(YEAR(AU9)+AL5,MONTH(AA5),DAY(AA5))","v":"00:00:00"},{"$f":"DATE(YEAR(AJ7)+1,MONTH(AJ7),DAY(AJ7))","v":"1905-12-31"},{"$f":"DATE(YEAR(AW9)+AN5,MONTH(AC5),DAY(AC5))","v":"00:00:00"},{"$f":"DATE(YEAR(AX9)+AO5,MONTH(AD5),DAY(AD5))","v":"00:00:00"}]
[null,"Kr.","Jahr der Kreditaufnahme","Jahr:","M"," => a","Euro","%","%","Euro","Euro","Euro","Euro","Euro","Euro","Euro",null,"Euro",null,null,"Valuta","Zins","Tilgung","Valuta","Zins","Tilgung","Valuta","Zins","Tilgung","Valuta","Zins","Tilgung","Valuta","Zins","Tilgung","Valuta","Zins","Tilgung","Valuta","Zins","Tilgung"]
[null,"Vorhandene Verbindlichkeiten"]
[null,null,null,null,null,null,null,null,null,"Verbindlichkeiten aus Lieferungen und Leistungen, Wechsel, sonst. Verbindlichkeiten =>",{"$f":"R10","v":0},{"$f":"K10","v":0},null,null,null,null,null,null,null,null,"€","€","€","€","€","€","€","€","€","€","€","€","€","€","€","€","€","€","€","€","€"]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF($L$3=0,U11-W11,IF($L$3=1,X11-Z11,IF($L$3=2,AA11-AC11,IF($L$3=3,AD11-AF11,IF($L$3=4,AG11-AI11,IF($L$3=5,AJ11-AL11,IF($L$3=6,AM11-AO11)))))))","v":0},{"$f":"IF(U11<0,0,H11*K11/100)","v":0},{"$f":"IF(K11=0,0,IF(K11<0,-I11*G11/100,IF(G11*I11/100>K11,K11,IF(J11-M11>K11,K11,IF(J11>0,J11-M11,G11*I11/100)))))","v":0},{"$f":"IF($L$3=0,V11,IF($L$3=1,Y11,IF($L$3=2,AB11,IF($L$3=3,AE11,IF($L$3=4,AH11,IF($L$3=5,AK11,IF($L$3=6,AN11)))))))","v":0},{"$f":"IF($L$3=0,W11,IF($L$3=1,Z11,IF($L$3=2,AC11,IF($L$3=3,AF11,IF($L$3=4,AI11,IF($L$3=5,AL11,IF($L$3=6,AO11)))))))","v":0},null,null,null,null,{"$f":"K11","v":0},{"$f":"IF(U11<0,0,H11*U11/100)","v":0},{"$f":"IF(U11=0,0,IF(N11>U11,U11,IF(J11-V11>U11,U11,IF(J11>0,J11-V11,G11*I11/100))))","v":0},{"$f":"IF(U11=0,0,IF(U11<0,U11-W11+U11*H11/100,IF((U11-W11)<=0,0,U11-W11)))","v":0},{"$f":"IF(X11<0,0,H11*X11/100)","v":0},{"$f":"IF(X11=0,0,IF(N11>X11,X11,IF(J11-Y11>X11,X11,(IF(J11>0,J11-Y11,G11*I11/100)))))","v":0},{"$f":"IF(X11=0,0,IF(X11<0,X11-Z11+X11*H11/100,IF((X11-Z11)<=0,0,X11-Z11)))","v":0},{"$f":"IF(AA11<0,0,H11*AA11/100)","v":0},{"$f":"IF(AA11=0,0,IF(N11>AA11,AA11,IF(J11-AB11>AA11,AA11,(IF(J11>0,J11-AB11,G11*I11/100)))))","v":0},{"$f":"IF(AA11=0,0,IF(AA11<0,AA11-AC11+AA11*H11/100,IF((AA11-AC11)<=0,0,AA11-AC11)))","v":0},{"$f":"IF(AD11<0,0,H11*AD11/100)","v":0},{"$f":"IF(AD11=0,0,IF(N11>AD11,AD11,IF(J11-AE11>AD11,AD11,(IF(J11>0,J11-AE11,G11*I11/100)))))","v":0},{"$f":"IF(AD11=0,0,IF(AD11<0,AD11-AF11+AD11*H11/100,IF((AD11-AF11)<=0,0,AD11-AF11)))","v":0},{"$f":"IF(AG11<0,0,H11*AG11/100)","v":0},{"$f":"IF(AG11=0,0,IF(N11>AG11,AG11,IF(J11-AH11>AG11,AG11,(IF(J11>0,J11-AH11,G11*I11/100)))))","v":0},{"$f":"IF(AG11=0,0,IF(AG11<0,AG11-AI11+AG11*H11/100,IF((AG11-AI11)<=0,0,AG11-AI11)))","v":0},{"$f":"IF(AJ11<0,0,H11*AJ11/100)","v":0},{"$f":"IF(AJ11=0,0,IF(N11>AJ11,AJ11,IF(J11-AK11>AJ11,AJ11,(IF(J11>0,J11-AK11,G11*I11/100)))))","v":0},{"$f":"IF(AJ11=0,0,IF(AJ11<0,AJ11-AL11+AJ11*H11/100,IF((AJ11-AL11)<=0,0,AJ11-AL11)))","v":0},{"$f":"IF(AM11<0,0,H11*AM11/100)","v":0},{"$f":"IF(AM11=0,0,IF(N11>AM11,AM11,IF(J11-AN11>AM11,AM11,(IF(J11>0,J11-AN11,G11*I11/100)))))","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,3,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,4,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,6,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,7,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,8,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,11,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Neue Verbindlichkeiten (Zeile 12-13: für das beantragte DIV-Vorhaben; Zeile 16-18: sonstige neue Kredite (Wohnhaus-, Schweinestallbau, etc.))"]
[null,12,{"$f":"'5. Finanzierungsmittel '!B57","v":"Darlehen 1"},{"$f":"$K$5","v":"00:00:00"},null,null,{"$f":"'5. Finanzierungsmittel '!C57","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"G23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"IF(D23-$U$7=0,G23,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,13,{"$f":"'5. Finanzierungsmittel '!B58","v":"Darlehen 2"},{"$f":"$K$5","v":"00:00:00"},null,null,{"$f":"'5. Finanzierungsmittel '!C58","v":0},null,null,null,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,14,{"$f":"'5. Finanzierungsmittel '!B59","v":"Darlehen 3"},"00:00:00",null,null,{"$f":"'5. Finanzierungsmittel '!C59","v":0},null,null,null,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,15,{"$f":"'5. Finanzierungsmittel '!B60","v":"Darlehen 4"},"00:00:00",null,null,{"$f":"'5. Finanzierungsmittel '!C60","v":0},null,null,null,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,16,"Darlehen bei AFP-Förderung","00:00:00",null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,17,"Weitere Darlehen ","00:00:00",null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,18,"Weitere Darlehen","00:00:00",null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null," Kredite für landw. Unternehmen ",null,null,null," - Alte Kredite",null,null,null,{"$f":"SUM(K11:K21)-K32-K34-K35","v":0},{"$f":"SUM(L11:L29)-L32-L34-L35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10,M11:M21)-M32-M34-M35","v":0},{"$f":"SUM(N10,N11:N21)-N32-N34-N35","v":0},{"$f":"SUM(O10,O11:O29)-O32-O34-O35","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P10,P11:P29)-P32-P34-P35","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(R10:R21)","v":0},null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:"]
[null,null,null,null,null,null," - Neue Kredite",null,null,null,null,{"$f":"SUMIF($E23:E$29,\"\",L23:L29)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUMIF(E23:E29,\"\",O23:O29)","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(E23:E29,\"\",P23:P29)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:",null,null,"Erläuterungen:"]
[]
[null,"P"," Private Kredite (z.B. für Wohnhaus)",null,null,null,null,null,null,null,{"$f":"SUMIF(E$11:E29,\"P\",K11:K29)","v":0},{"$f":"SUMIF(E11:E29,\"P\",L11:L29)","v":0},{"$f":"SUMIF(E11:E29,\"P\",M11:M29)","v":0},{"$f":"SUMIF($E$11:E29,\"P\",N11:N29)","v":0},{"$f":"SUMIF(E11:E29,\"P\",O11:O29)","v":0},{"$f":"SUMIF(E11:E29,\"P\",P11:P29)","v":0},null,{"$f":"SUMIF($E$11:E29,\"P\",R11:R29)","v":0}]
[null,"M"," Kredite aus Vermietung/Verp. und Gewerbe",null,null,null,null,null,null,null,{"$f":"SUMIF(E11:E21,\"M\",K11:K21)","v":0},{"$f":"SUMIF(E$11:E29,\"M\",L11:L29)","v":0},{"$f":"SUMIF(E11:E21,\"M\",M11:M21)","v":0},{"$f":"SUMIF($E$11:E22,\"M\",N11:N21)","v":0},{"$f":"SUMIF(E11:E29,\"M\",O11:O29)","v":0},{"$f":"SUMIF(E11:E29,\"M\",P11:P29)","v":0},null,{"$f":"SUMIF($E$11:E29,\"M\",R11:R29)","v":0}]
[]
[null,"Se"," Kredite und Kapitaldienst insgesamt",null,null,null,null,null,null,null,{"$f":"SUM(K31:K35)","v":0},{"$f":"SUM(L31:L35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M31:N35)","v":0},null,{"$f":"SUM(O31:P35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zinsen lt. letztem Buchführungsabschluß abzügl. Zinsverbill.",null,null,null,null,{"$f":"SUM(U11:U37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(W11:W37)+SUM(V11:V37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(X11:X37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Z11:Z37)+SUM(Y11:Y37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AA11:AA37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AC11:AC37)+SUM(AB11:AB37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AD11:AD37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AF11:AF37)+SUM(AE11:AE37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AG11:AG37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AI11:AI37)+SUM(AH11:AH37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AJ11:AJ37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AL11:AL37)+SUM(AK11:AK37)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AM11:AM37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AO11:AO37)+SUM(AN11:AN37)","v":{"$error":"#DIV/0!"}}]

{"sheet":"7. Feste Kosten ","index":6,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,"Datum",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"}]
["4. Wirtschaftlichkeitsberechnung  (Nettowerte eintragen)"]
[null,"4.1 Feste Kosten"]
[]
[null,null,"EURO pro Jahr"]
[1,"4.1.1 Festkosten Übertrag aus den Vorseiten (Kapitalkosten)"]
[2,"Abschreibung bauliche Maßnahmen/Techn. Ausstattung / Geräte (Seite Inv.bedarf 2.3.2)",{"$f":"'3.Investitionsbedarf 2.3.2 '!L28+'3.Investitionsbedarf 2.3.2 '!L46","v":0}]
[3,"Abschreibung Einrichtung und Ausstattung/Marketing/Sachausgaben\n(Seite Inv.bedarf 2.3.1)",{"$f":"'4.Investitionsbedarf 2.3.1  '!M34","v":0}]
[4,"Instandhaltung                                                                  \n(Seite Inv.bedarf 2.3.1 und Inv.bedarf 2.3.2)",{"$f":"'3.Investitionsbedarf 2.3.2 '!L29+'3.Investitionsbedarf 2.3.2 '!L47+'4.Investitionsbedarf 2.3.1  '!M35","v":0}]
[5,"Zinsen für Fremdkapital neu\n(Zinszahlung im Zieljahr)",{"$f":"'6.KrediteKap.dienst '!O23+'6.KrediteKap.dienst '!O24+'6.KrediteKap.dienst '!O25+'6.KrediteKap.dienst '!O26","v":{"$error":"#DIV/0!"}}]
[6,"Summe AfA / I / Finanzierung",{"$f":"SUM(C9:C12)","v":{"$error":"#DIV/0!"}}]
[]
[7,"4.1.2 Sonstige feste Kosten (keine Doppelnennung zu 2.3.1. und 2.3.2)"]
[8,"Afa vorhandene Gebäude des DIV-Betriebszeiges "]
[9,"Afa vorhandene Masch./Geräte des DIV-Betriebszeiges"]
[10,"Instandh.  vorhandene Gebäude des DIV-Betriebszeiges"]
[11,"Instandh. vorhandene Masch./Geräte des DIV-Betriebszeiges"]
[12,"Zinsen der bestehenden, dem DIV-Vorhaben zuzurechnenden Kredite "]
[13,"Löhne fest angestellte Fremd-AK im IST"]
[14,"Löhne fest angestellter Fremd-AK - Neueinstellungen"]
[15,"Gebühren, Beiträge (z.B. Müllabfuhr) - Ist + Zuschlag für die Erweiterung"]
[16,"Werbung (jährlich wiederkehrend)"]
[17,"Versicherungen, Steuern"]
[18]
[19,"Miete / Pacht"]
[20]
[21]
[22]
[23]
[24]
[25,"Summe sonstige feste Kosten",{"$f":"SUM(C16:C32)","v":0}]
[]
[26,"4.1.3 Feste Kosten insgesamt"]
[27,"Feste Kosten insgesamt\n(Zeile 7 + Zeile 25)",{"$f":"C33+C13","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"(Fortsetzung nächste Seite)"]

{"sheet":"8. Veränderl. Kosten ","index":7,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,1,42,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[6,4,7,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[14,1,14,2],[13,1,13,2],[19,1,19,2],[20,1,20,2],[35,1,35,4],[25,1,25,4],[26,1,26,4],[15,1,15,2],[17,1,17,2],[18,1,18,2],[27,1,27,4],[28,1,28,4]]}
[null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
["(Fortsetzung Wirtschaftlichkeit)",null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,null,null,"Datum:",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"}]
[]
["4.2 Veränderlichen Kosten "]
[]
[null,null,null,"Kosten je Vorgang","Anzahl bzw. Vorgänge je Jahr","Kosten insgesamt"]
[null,null,null,"EURO",null,"EURO/Jahr"]
[1,"4.2.1 Materialkosten"]
[2,"Wareneinsatz",null,null,null,{"$f":"D10*E10","v":0}]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[11,null,null,null,null,0]
[12,null,null,null,null,0]
[13,null,null,null,null,0]
[14,"Summe Materialkosten",null,null,null,{"$f":"SUM(F10:F21)","v":0}]
[]
[15,"4.2.2 Betriebskosten"]
[16,"Löhne (Aushilfen) - IST"]
[17,"Löhne (Aushilfen) - Neueinstellungen"]
[18,"Hilfsstoffe (IST + Zuschlag)"]
[19,"Energie (Ist + Zuschlag Ziel)"]
[20,"Bürobedarf"]
[21,"Qualifizierungsmaßnahmen"]
[22,"Bereitstellung / Organisation"]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31,"Summe Betriebskosten",null,null,null,{"$f":"SUM(F25:F39)","v":0}]
[]
[32,"4.2.3 Veränderliche Kosten insgesamt"]
[33,"Veränderliche Kosten insgesamt                                                                        (Zeile 14 + Zeile 28)",null,null,null,{"$f":"F40+F22","v":0}]
[]
[null,null,null,null,null,"(Fortsetzung nächste Seite)"]

{"sheet":"9. Einkommensbeitrag ","index":8,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,4,5,5],[18,1,18,4],[28,1,28,2],[29,1,29,2],[28,3,28,4],[20,1,20,4],[19,1,19,4],[29,3,29,4],[40,0,40,5],[37,0,37,5],[39,0,39,5],[38,0,38,5],[33,0,33,5],[34,0,34,5],[36,0,36,5],[35,0,35,5],[30,3,30,4],[24,3,24,4],[25,3,25,4],[24,1,24,2],[25,1,25,2],[26,1,26,2]]}
[null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
["(Fortsetzung Wirtschaftlichkeit)",null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,"4.3 Einkommensbeitrag",null,null,"Datum",{"$f":"'1 Deckblatt BP'!$C$43","v":"00:00:00"}]
[]
[null,"Produkt","Einheit\n(Pferd, Bett)","Preis je Einheit\nEURO","Anzahl bzw.  Vorgänge je Jahr","EURO pro Jahr"]
[1,"Einnahmen aus der Maßnahme"]
[2,null,null,null,null,{"$f":"D7*E7","v":0}]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[11,null,null,null,null,0]
[12,"Einnahmen aus der Maßnahme insgesamt",null,null,null,{"$f":"SUM(F7:F16)","v":0}]
[]
[13,"Feste Kosten insgesamt",null,null,null,{"$f":"'7. Feste Kosten '!C36","v":{"$error":"#DIV/0!"}}]
[14,"Veränderliche Kosten insgesamt",null,null,null,{"$f":"'8. Veränderl. Kosten '!F43","v":0}]
[15,"Einkommensbeitrag insgesamt",null,null,null,{"$f":"F17-F19-F20","v":{"$error":"#DIV/0!"}}]
[]
[16,"4.4 Gewinnschwelle / Break Even Point"]
[null,null,null,null,null,"EURO"]
[17,"Bezeichnung der Einheit",null,"Öffnungstage"]
[18,"Anzahl der Einheiten",null,10]
[19,"Deckungsbeitrag pro Einheit     ",null,{"$f":"D25","v":"Öffnungstage"},null,{"$f":"IF(ISERROR((F17-F20)/D26),0,(F17-F20)/D26)","v":0}]
[]
[20,"Gewinnschwelle                                                     ",null,"Gewinn entsteht ab ..ten"]
[21,"Feste Kosten : Deck.beitrag je Einheit",null,{"$f":"D25","v":"Öffnungstage"},null,{"$f":"IF(ISERROR(F19/F27),0,F19/F27)","v":0}]
[null,null,null,"pro Jahr"]
[]
["Hinweis auf einkommenswirksame Synergieeffekte (ggf. in Tab.blatt 2: textl. Beschreibung näher erläutern)"]

{"sheet":"10. Erfolgskennzahlen(IK)  ","index":9,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,0,28,0],[19,1,19,4],[20,1,20,4],[23,0,24,0],[23,1,23,4],[8,3,8,4],[14,1,14,3],[17,1,17,4],[18,1,18,4],[23,5,24,5]]}
[null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,null,null,"Datum",{"$f":"'1 Deckblatt BP'!C43","v":"00:00:00"}]
[]
["5. Erfolgskennzahlen des Projekts im Überblick"]
[]
[1,"5.1 Entlohnung der eingesetzten Arbeitsstunde"]
[2,null,null,null,null,"EURO"]
[3,"Nicht entlohnte Familienarbeits-\nstunden pro Jahr insg.:",null,"Entlohnung pro Std.                             ",null,{"$f":"IF(ISERROR('9. Einkommensbeitrag '!F21/'10. Erfolgskennzahlen(IK)  '!C9),\"-\",'9. Einkommensbeitrag '!F21/'10. Erfolgskennzahlen(IK)  '!C9)","v":"-"}]
[]
[4,"5.2 Kalkulatorischer Gewinn "]
[5,"Einkommensbeitrag (Seite 7, Zeile 44)",null,null,null,{"$f":"'9. Einkommensbeitrag '!F21","v":{"$error":"#DIV/0!"}}]
[6,"Lohnansatz Familienarbeitskräfte ",null,null,null,{"$f":"C14*C9","v":0}]
[7,"EURO pro Std.:",null,"Stunden insg.:",{"$f":"C9","v":0}]
[8,"kalkulatorischer Gewinn     ",null,null,null,{"$f":"F12-F13","v":{"$error":"#DIV/0!"}}]
[]
[9,"5.3 Geldüberschuss (Liquidität)"]
[10,"Einkommensbeitrag                                           ",null,null,null,{"$f":"F12","v":{"$error":"#DIV/0!"}}]
[11,"Abschreibungen Gebäude/Technik insgesamt (Ist + neue Inv.)          ",null,null,null,{"$f":"'7. Feste Kosten '!C9+'7. Feste Kosten '!C10+'7. Feste Kosten '!C16+'7. Feste Kosten '!C17","v":0}]
[13,"Tilgung",null,null,null,{"$f":"'6.KrediteKap.dienst '!P23+'6.KrediteKap.dienst '!P24+'6.KrediteKap.dienst '!P25+'6.KrediteKap.dienst '!P26","v":{"$error":"#DIV/0!"}}]
[14,"Geldüberschuss                 ",null,null,null,{"$f":"F18+F19-F20","v":{"$error":"#DIV/0!"}}]
[]
[15,"5.4 Entlohnung des eingesetzten Kapitals (Deckungsbeitrag)"]
[16,"Einnahmen  - veränderliche Kosten insgesamt",null,null,null,{"$f":"'9. Einkommensbeitrag '!F17-'9. Einkommensbeitrag '!F20","v":0}]
[]
[]
[17,"5.5 Amortisationsdauer"]
[18,"Investitionen insgesamt                                   kalkulatorischer Gewinn + AfA"," = Amortisationsdauer ",null,null,"  Jahre"]
[null,null,null,null,{"$f":"'5. Finanzierungsmittel '!G8+'5. Finanzierungsmittel '!G9","v":{"$error":"#DIV/0!"}},{"$f":"IF(E29/(F15+F19)>0,E29/(F15+F19),\"unendlich\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"11.Liqu.plan kopierfähig","index":10,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"Anlage zum Diversifizierungsantrag - Liquiditätsplan"]
[null,"Betrieb:",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[]
[null,null,"1. Jahr","2. Jahr","3. Jahr"]
[null,null,"Durchschnitt","Durchschnitt","Durchschnitt"]
[null,null,"Soll","Soll","Soll"]
[null,"Liquide Mittel"]
[null,"Kassenbestand"]
[null,"Bankguthaben"]
[null,"Summe",{"$f":"SUM(C9:C10)","v":0},{"$f":"SUM(D9:D10)","v":0},{"$f":"SUM(E9:E10)","v":0}]
[]
[null,"Einnahmen"]
[null,"Umsatzerlöse"]
[null,"Darlehen"]
[null,"Privateinzahlungen"]
[null,"staatliche Zuschüsse"]
[null,"Sonstige Einnahmen (z.B. MwSt.Erstattung) "]
[null,"Summe verfügbare Mittel",{"$f":"SUM(C14:C18)","v":0},{"$f":"SUM(D14:D18)","v":0},{"$f":"SUM(E14:E18)","v":0}]
[]
[null,"Ausgaben"]
[null,"Wareneinsatz"]
[null,"Personalkosten (Löhne, Gehälter, Sozialabgaben)"]
[null,"Werbung + Vertrieb + sonst. betriebl. Kosten"]
[null,"Energie"]
[null,"Steuern + Versicherungen"]
[null,"Investitionen"]
[null,"Zinsen, Tilgung"]
[null,"Gründungskosten"]
[null,"Buchführung, KFZ, Telefon"]
[null,"Privatentnahmen"]
[null,"Summe Ausgaben",{"$f":"SUM(C22:C31)","v":0},{"$f":"SUM(D22:D31)","v":0},{"$f":"SUM(E22:E31)","v":0}]
[]
[]
[null,"Über-/Unterdeckung pro Jahr\n(Z 8 - Z 19)",{"$f":"C11+C19-C32","v":0},{"$f":"D11+D19-D32","v":0},{"$f":"E11+E19-E32","v":0}]
[null,"Saldo Vorjahr",null,{"$f":"C38","v":0},{"$f":"D38","v":0}]
[null,"Ausgleich durch Kontokorrentkredit (Betriebsmittelkredit)"]
[null,"Liquidität",{"$f":"C35+C37","v":0},{"$f":"D35+D36+D37","v":0},{"$f":"E35+E36+E37","v":0}]

{"sheet":"12.Unternehmen(IK)","index":11,"n_rows":40,"n_cols":29,"rows_kept":40,"cut":false,"hidden":false,"merged":[[40,1,40,7],[38,1,38,3],[1,0,3,4],[6,2,6,4],[6,5,6,7],[35,1,35,3],[36,1,36,3],[37,1,37,3],[4,1,4,3]]}
[null,null,null,null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
["Nachweis der Wirtschaftlichkeit des  Unternehmens bzw. der antragstellenden Kooperation\n (bitte Daten aus der beizufügenden Betriebsbuchführung übernehmen)",null,null,null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,null,null,null,"Datum",{"$f":"'1 Deckblatt BP'!C43","v":"00:00:00"}]
[]
["0","Stichdatum aktuellster Abschluss (Ausgangstermin IST für Bruttowertschöpfung)",null,null,null,null,"Startdatum Abschluss"]
[]
[]
[null,"   Art der Buchführung"]
[1,"Wirtschaftsjahr/Buchführungsjahr","2010/11","2011/12","Durchschnitt",2010,2011,"Durchschnitt"]
[]
[]
[2,"Umsatzerlöse",null,null,{"$f":"(C12+D12)/2","v":0},null,null,{"$f":"(F12+G12)/2","v":0}]
[3,"Bestandsveränderung",null,null,{"$f":"(C13+D13)/2","v":0},null,null,{"$f":"(F13+G13)/2","v":0}]
[4,"So. betriebl. Erträge:Zulagen/Zuschüsse",null,null,{"$f":"(C14+D14)/2","v":0},null,null,{"$f":"(F14+G14)/2","v":0}]
[5,"So. betriebl. Erträge: Sonstiger Betriebsertrag \n     (Pacht, etc.)",null,null,{"$f":"(C15+D15)/2","v":0},null,null,{"$f":"(F15+G15)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betriebsw. BMVEL-Jahresabschluss"]
[6,"So. betriebl. Erträge: Zeitraumfremde Erträge",null,null,{"$f":"(C16+D16)/2","v":0},null,null,{"$f":"(F16+G16)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Einnahme-Überschussrechnung (§ 4 Abs.3 EStG)"]
[7,"Summe Erträge",{"$f":"SUM(C12:C16)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nach Durchschnittssätzen (§13a EStG)"]
[8,"Materialaufwand",null,null,{"$f":"(C18+D18)/2","v":0},null,null,{"$f":"(F18+G18)/2","v":0}]
[9,"Personalaufwand",null,null,{"$f":"(C19+D19)/2","v":0},null,null,{"$f":"(F19+G19)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01.01."]
[10,"Abschreibungen",null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01.05."]
[11,"So. betr. Aufw.: Unterhaltung",null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01.07."]
[12,"So. betr. Aufw.: Betriebsversicherungen",null,null,0,null,null,0]
[13,"So. betr. Aufw.: Sonstiger Betriebsaufwand",null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009]
[14,"So. betr. Aufw.: Zeitraumfremde Aufwendungen",null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010]
[15,"Summe Betriebl. Aufwendungen",{"$f":"SUM(C18:C24)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011]
[16,"Betriebsergebnis",{"$f":"C17-C25","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012]
[17,"Zinsen u. ähnl. Erträge",null,null,{"$f":"(C27+D27)/2","v":0},null,null,{"$f":"(F27+G27)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[18,"Zinsen u. ähnl. Aufwendungen",null,null,{"$f":"(C28+D28)/2","v":0},null,null,{"$f":"(F28+G28)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[19,"Ergebnis der gewöhnl. Geschäftstätigkeit",{"$f":"C26+C27-C28","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015]
[20,"außerord. Erträge",null,null,{"$f":"(C30+D30)/2","v":0},null,null,{"$f":"(F30+G30)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,"außerord.Aufwendungen",null,null,{"$f":"(C31+D31)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,"Steuern",null,null,{"$f":"(C32+D32)/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[21,"Gewinn/Verlust",{"$f":"C29+C30-C31-C32","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019]
[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,2020]
[null,null,null,null,"Durchschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[22,"  Addition: Durchschnittl. Gewinn/Verlust des Antragstellers/der Kooperation",null,null,{"$f":"E33+H33","v":0}]
[23,"  Einkommen (Ziel) bei Neuvorhaben (= Ergebnis DIV-IK)"]
[24," Zusätzliches Einkommen (Ziel) aus der Erweitung desBetriebszweiges \n(Ergebnis DIV-Ik abzüglich des bereits bisher erzielten Einkommens aus diesem Zweig) "]
[25,"  Gesamtüberschuss IST plus Einkommensbeitrag Ziel des Div-Vorhabens",null,null,{"$f":"SUM(E36:E38)","v":0}]
[null,"ggf. Hinweise und Erläuterungen zur Buchführung:"]

{"sheet":"nicht förderfähig","index":12,"n_rows":120,"n_cols":5,"rows_kept":120,"cut":false,"hidden":false,"merged":[[5,3,6,3],[5,2,6,2]]}
[null,null,"Betrieb: ",{"$f":"'1 Deckblatt BP'!B13","v":0}]
[null,null,"Untern.nr.",{"$f":"'1 Deckblatt BP'!D21","v":0}]
[null,null,"Datum",{"$f":"'1 Deckblatt BP'!C43","v":"00:00:00"}]
[null,"Hilfsblatt zur detaillierteren Darstellung der nicht förderfähigen Kosten"]
[null,null,null,"Leere Zellen"]
[null,null,"nicht zuwend'fäh. Ausgaben \nNetto","nicht zuwend'fäh. Ausgaben\nBrutto"]
[]
[1,"Kapitalbedarf 2.3.2, 2.3.1 u. Anlaufkosten","€","€"]
[2,{"$f":"'3.Investitionsbedarf 2.3.2 '!B12","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F12","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X12","v":0}]
[3,{"$f":"'3.Investitionsbedarf 2.3.2 '!B13","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F13","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X13","v":0}]
[4,{"$f":"'3.Investitionsbedarf 2.3.2 '!B14","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F14","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X14","v":0}]
[5,{"$f":"'3.Investitionsbedarf 2.3.2 '!B15","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F15","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X15","v":0}]
[6,{"$f":"'3.Investitionsbedarf 2.3.2 '!B16","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F16","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X16","v":0}]
[7,{"$f":"'3.Investitionsbedarf 2.3.2 '!B17","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F17","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X17","v":0}]
[8,{"$f":"'3.Investitionsbedarf 2.3.2 '!B18","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F18","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X18","v":0}]
[9,{"$f":"'3.Investitionsbedarf 2.3.2 '!B19","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F19","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X19","v":0}]
[10,{"$f":"'3.Investitionsbedarf 2.3.2 '!B20","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F20","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X20","v":0}]
[11,{"$f":"'3.Investitionsbedarf 2.3.2 '!B21","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F21","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X21","v":0}]
[12,{"$f":"'3.Investitionsbedarf 2.3.2 '!B22","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F22","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X22","v":0}]
[13,{"$f":"'3.Investitionsbedarf 2.3.2 '!B23","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F23","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X23","v":0}]
[14,{"$f":"'3.Investitionsbedarf 2.3.2 '!B24","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F24","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X24","v":0}]
[15,{"$f":"'3.Investitionsbedarf 2.3.2 '!B25","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F25","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X25","v":0}]
[16,{"$f":"'3.Investitionsbedarf 2.3.2 '!B26","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F26","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X26","v":0}]
[17,{"$f":"'3.Investitionsbedarf 2.3.2 '!B27","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F27","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X27","v":0}]
[18," Summe Kosten unbewegliches Vermögen",{"$f":"SUM(C9:C24)","v":0},{"$f":"SUM(D9:D24)","v":0}]
[19,{"$f":"'3.Investitionsbedarf 2.3.2 '!B31","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F31","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X31","v":0}]
[20,{"$f":"'3.Investitionsbedarf 2.3.2 '!B32","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F32","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X32","v":0}]
[21,{"$f":"'3.Investitionsbedarf 2.3.2 '!B33","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F33","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X33","v":0}]
[22,{"$f":"'3.Investitionsbedarf 2.3.2 '!B34","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F34","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X34","v":0}]
[23,{"$f":"'3.Investitionsbedarf 2.3.2 '!B35","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F35","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X35","v":0}]
[24,{"$f":"'3.Investitionsbedarf 2.3.2 '!B36","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F36","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X36","v":0}]
[25,{"$f":"'3.Investitionsbedarf 2.3.2 '!B37","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F37","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X37","v":0}]
[26,{"$f":"'3.Investitionsbedarf 2.3.2 '!B38","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F38","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X38","v":0}]
[27,{"$f":"'3.Investitionsbedarf 2.3.2 '!B39","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F39","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X39","v":0}]
[28,{"$f":"'3.Investitionsbedarf 2.3.2 '!B40","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F40","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X40","v":0}]
[29,{"$f":"'3.Investitionsbedarf 2.3.2 '!B41","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F41","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X41","v":0}]
[30,{"$f":"'3.Investitionsbedarf 2.3.2 '!B42","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F42","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X42","v":0}]
[31,{"$f":"'3.Investitionsbedarf 2.3.2 '!B43","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F43","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X43","v":0}]
[32,{"$f":"'3.Investitionsbedarf 2.3.2 '!B44","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F44","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X44","v":0}]
[33,{"$f":"'3.Investitionsbedarf 2.3.2 '!B45","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F45","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X45","v":0}]
[34," Summe Kosten für Maschinen u. Anlagen",{"$f":"SUM(C26:C40)","v":0},{"$f":"SUM(D26:D40)","v":0}]
[35,{"$f":"'3.Investitionsbedarf 2.3.2 '!B48","v":"Baugenehmigung (MwStfrei)"},{"$f":"D42","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X48","v":0}]
[36,{"$f":"'3.Investitionsbedarf 2.3.2 '!B49","v":"                                       (MwStfrei)"},{"$f":"D43","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X49","v":0}]
[37,{"$f":"'3.Investitionsbedarf 2.3.2 '!B50","v":"                                       (MwStfrei)"},0,{"$f":"'3.Investitionsbedarf 2.3.2 '!X50","v":0}]
[38,{"$f":"'3.Investitionsbedarf 2.3.2 '!B51","v":"Architektenleistungen  "},{"$f":"'3.Investitionsbedarf 2.3.2 '!F51","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X51","v":0}]
[39,{"$f":"'3.Investitionsbedarf 2.3.2 '!B52","v":"Ingenieurs-,Statikerleistungen"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F52","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X52","v":0}]
[40,{"$f":"'3.Investitionsbedarf 2.3.2 '!B53","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F53","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X53","v":0}]
[41,{"$f":"'3.Investitionsbedarf 2.3.2 '!B54","v":"Ausgleichspflanzung"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F54","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X54","v":0}]
[42,{"$f":"'3.Investitionsbedarf 2.3.2 '!B55","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F55","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X55","v":0}]
[43,{"$f":"'3.Investitionsbedarf 2.3.2 '!B56","v":"förderfähiges Betreuungs-/Beratungsgebühr für 2.3.2"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F56","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X56","v":0}]
[44,{"$f":"'3.Investitionsbedarf 2.3.2 '!B57","v":"Beratung zum Bauvorhaben"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F57","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X57","v":0}]
[45,{"$f":"'3.Investitionsbedarf 2.3.2 '!B58","v":"Erwerb Patentrechte/Lizenzen/So. Genehmigungen"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F58","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!X58","v":0}]
[46,"Summe nicht förderfähiger allg. Aufwendungen",{"$f":"SUM(C42:C52)","v":0},{"$f":"SUM(D42:D52)","v":0}]
[47,{"$f":"'3.Investitionsbedarf 2.3.2 '!B62","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F62","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!D62","v":0}]
[48,{"$f":"'3.Investitionsbedarf 2.3.2 '!B63","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F63","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!D63","v":0}]
[49,{"$f":"'3.Investitionsbedarf 2.3.2 '!B64","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!F64","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!D64","v":0}]
[50,{"$f":"'3.Investitionsbedarf 2.3.2 '!B65","v":"Grundstückskauf (ohne MwSt.)"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F65","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!D65","v":0}]
[51,{"$f":"'3.Investitionsbedarf 2.3.2 '!B66","v":"Tieraufstockung (Formel hier mit 7 % MwSt!!)"},{"$f":"'3.Investitionsbedarf 2.3.2 '!F66","v":0},{"$f":"'3.Investitionsbedarf 2.3.2 '!D66","v":0}]
[52,"Summe mit der Baumaßnahme verbundener, aber nicht förderfähiger Kosten",{"$f":"SUM(C54:C58)","v":0},{"$f":"SUM(D54:D58)","v":0}]
[53,{"$f":"'4.Investitionsbedarf 2.3.1  '!B11","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G11","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X11","v":0}]
[54,{"$f":"'4.Investitionsbedarf 2.3.1  '!B12","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G12","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X12","v":0}]
[55,{"$f":"'4.Investitionsbedarf 2.3.1  '!B13","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G13","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X13","v":0}]
[56,{"$f":"'4.Investitionsbedarf 2.3.1  '!B14","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G14","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X14","v":0}]
[57,{"$f":"'4.Investitionsbedarf 2.3.1  '!B15","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G15","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X15","v":0}]
[58,{"$f":"'4.Investitionsbedarf 2.3.1  '!B16","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G16","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X16","v":0}]
[59,{"$f":"'4.Investitionsbedarf 2.3.1  '!B17","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G17","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X17","v":0}]
[60,{"$f":"'4.Investitionsbedarf 2.3.1  '!B18","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G18","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X18","v":0}]
[61,{"$f":"'4.Investitionsbedarf 2.3.1  '!B19","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G19","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X19","v":0}]
[62,{"$f":"'4.Investitionsbedarf 2.3.1  '!B20","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G20","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X20","v":0}]
[63,{"$f":"'4.Investitionsbedarf 2.3.1  '!B21","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G21","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X21","v":0}]
[64,{"$f":"'4.Investitionsbedarf 2.3.1  '!B22","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G22","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X22","v":0}]
[65,{"$f":"'4.Investitionsbedarf 2.3.1  '!B23","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G23","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X23","v":0}]
[66,{"$f":"'4.Investitionsbedarf 2.3.1  '!B24","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G24","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X24","v":0}]
[67,{"$f":"'4.Investitionsbedarf 2.3.1  '!B25","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G25","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X25","v":0}]
[68,{"$f":"'4.Investitionsbedarf 2.3.1  '!B26","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G26","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X26","v":0}]
[69,{"$f":"'4.Investitionsbedarf 2.3.1  '!B27","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G27","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X27","v":0}]
[70,{"$f":"'4.Investitionsbedarf 2.3.1  '!B28","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G28","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X28","v":0}]
[71,{"$f":"'4.Investitionsbedarf 2.3.1  '!B29","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G29","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X29","v":0}]
[72,{"$f":"'4.Investitionsbedarf 2.3.1  '!B30","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G30","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X30","v":0}]
[73,{"$f":"'4.Investitionsbedarf 2.3.1  '!B31","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G31","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X31","v":0}]
[74,{"$f":"'4.Investitionsbedarf 2.3.1  '!B32","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G32","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X32","v":0}]
[75,{"$f":"'4.Investitionsbedarf 2.3.1  '!B33","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G33","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X33","v":0}]
[76,{"$f":"'4.Investitionsbedarf 2.3.1  '!B34","v":"Summe Sachausg./Inv. in Einrichtung/Ausst."},{"$f":"SUM(C60:C82)","v":0},{"$f":"SUM(D60:D82)","v":0}]
[77,{"$f":"'4.Investitionsbedarf 2.3.1  '!B41","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G41","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X41","v":0}]
[78,{"$f":"'4.Investitionsbedarf 2.3.1  '!B42","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G42","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X42","v":0}]
[79,{"$f":"'4.Investitionsbedarf 2.3.1  '!B43","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G43","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X43","v":0}]
[80,{"$f":"'4.Investitionsbedarf 2.3.1  '!B44","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G44","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X44","v":0}]
[81,{"$f":"'4.Investitionsbedarf 2.3.1  '!B45","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G45","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X45","v":0}]
[82,{"$f":"'4.Investitionsbedarf 2.3.1  '!B46","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G46","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X46","v":0}]
[83,{"$f":"'4.Investitionsbedarf 2.3.1  '!B47","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G47","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X47","v":0}]
[84,{"$f":"'4.Investitionsbedarf 2.3.1  '!B48","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G48","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X48","v":0}]
[85,{"$f":"'4.Investitionsbedarf 2.3.1  '!B49","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G49","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X49","v":0}]
[86,{"$f":"'4.Investitionsbedarf 2.3.1  '!B50","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G50","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X50","v":0}]
[87,{"$f":"'4.Investitionsbedarf 2.3.1  '!B51","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G51","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X51","v":0}]
[88,{"$f":"'4.Investitionsbedarf 2.3.1  '!B52","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G52","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X52","v":0}]
[89,{"$f":"'4.Investitionsbedarf 2.3.1  '!B53","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G53","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X53","v":0}]
[90,{"$f":"'4.Investitionsbedarf 2.3.1  '!B54","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G54","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X54","v":0}]
[91,{"$f":"'4.Investitionsbedarf 2.3.1  '!B55","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G55","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X55","v":0}]
[92,{"$f":"'4.Investitionsbedarf 2.3.1  '!B56","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G56","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X56","v":0}]
[93,{"$f":"'4.Investitionsbedarf 2.3.1  '!B57","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G57","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X57","v":0}]
[94,{"$f":"'4.Investitionsbedarf 2.3.1  '!B58","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G58","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X58","v":0}]
[95,{"$f":"'4.Investitionsbedarf 2.3.1  '!B59","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G59","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X59","v":0}]
[96,{"$f":"'4.Investitionsbedarf 2.3.1  '!B60","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!G60","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X60","v":0}]
[97,{"$f":"'4.Investitionsbedarf 2.3.1  '!B61","v":"Versicherung (ohne Mwst.)"},{"$f":"'4.Investitionsbedarf 2.3.1  '!G61","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X61","v":0}]
[98,{"$f":"'4.Investitionsbedarf 2.3.1  '!B62","v":"Versicherung (ohne Mwst.)"},{"$f":"'4.Investitionsbedarf 2.3.1  '!G62","v":0},{"$f":"'4.Investitionsbedarf 2.3.1  '!X62","v":0}]
[99,{"$f":"'4.Investitionsbedarf 2.3.1  '!B63","v":" Summe Sonstige Sachausgaben (Marketing)"},{"$f":"SUM(C84:C105)","v":0},{"$f":"SUM(D84:D105)","v":0}]
[100,"Summe aller nicht förderfähiger Ausgaben\n nach 2.3.1 und 2.3.2",{"$f":"C106+C83+C59+C53+C41+C25","v":0},{"$f":"D106+D83+D59+D53+D41+D25","v":0}]
[101,{"$f":"'5. Finanzierungsmittel '!B18","v":"Orga.-Kosten mit MwSt. - Nicht förderfähig"},{"$f":"'5. Finanzierungsmittel '!G18","v":0},{"$f":"'5. Finanzierungsmittel '!E18","v":0}]
[102,{"$f":"'5. Finanzierungsmittel '!B19","v":"Orga.-Kosten ohne MwSt. - Nicht förderfähig"},{"$f":"'5. Finanzierungsmittel '!G19","v":0},{"$f":"'5. Finanzierungsmittel '!E19","v":0}]
[103,{"$f":"'5. Finanzierungsmittel '!B22","v":"Qualifizierungskosten mit MwSt. - Nicht förderfähig"},{"$f":"'5. Finanzierungsmittel '!G22","v":0},{"$f":"'5. Finanzierungsmittel '!E22","v":0}]
[104,{"$f":"'5. Finanzierungsmittel '!B23","v":"Qualifizierungskosten ohne MwSt. - Nicht förderfähig"},{"$f":"'5. Finanzierungsmittel '!G23","v":0},{"$f":"'5. Finanzierungsmittel '!E23","v":0}]
[105,{"$f":"'5. Finanzierungsmittel '!B24","v":"Vorauszahlung Beiträge, Versicherung, Steuer (nf)"},{"$f":"'5. Finanzierungsmittel '!G24","v":0},{"$f":"'5. Finanzierungsmittel '!E24","v":0}]
[106,{"$f":"'5. Finanzierungsmittel '!B25","v":"Erster Warenbestand (nf)"},{"$f":"'5. Finanzierungsmittel '!G25","v":0},{"$f":"'5. Finanzierungsmittel '!E25","v":0}]
[107,{"$f":"'5. Finanzierungsmittel '!B26","v":"Sonstiges (ohne MwSt.) (nf)"},{"$f":"'5. Finanzierungsmittel '!G26","v":0},{"$f":"'5. Finanzierungsmittel '!E26","v":0}]
[108,{"$f":"'5. Finanzierungsmittel '!B27","v":"Sonstiges (mit MwSt.) (nf)"},{"$f":"'5. Finanzierungsmittel '!G27","v":0},{"$f":"'5. Finanzierungsmittel '!E27","v":0}]
[109,{"$f":"'5. Finanzierungsmittel '!B28","v":"Reserveaufschlag (nf)"},{"$f":"'5. Finanzierungsmittel '!G28","v":0},{"$f":"'5. Finanzierungsmittel '!E28","v":0}]
[110,0,null,{"$f":"C117*1.19","v":0}]
[111,"ohne MwSt.",null,{"$f":"C118","v":0},"ohne MwSt."]
[112,"Summe nicht förderfähiger Ausgaben außer 2.3.2./2.3.1.",{"$f":"SUM(C108:C118)","v":0},{"$f":"SUM(D108:D118)","v":0}]
[113,"Summe aller nicht förderfähiger Ausgaben ",{"$f":"C107+C119","v":0},{"$f":"D107+D119","v":0}]

{"sheet":"Bearbeitung","index":13,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["wer","Datum","Datenblatt","Zelle","was"]
["Kloß","2013-08-27","3.Investitionsbedarf 2.3.2","M26","fehlende Formel ergänzt"]