{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dateneingabe","Berechnung","Korrektur","Hilfe"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Dateneingabe","index":0,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[9,6,9,7],[60,6,60,7],[63,6,63,7],[40,6,40,7],[47,6,47,7],[51,6,51,7],[57,6,57,7],[49,6,49,7],[23,6,23,7],[65,6,65,7],[47,11,49,11],[64,11,66,13],[10,3,10,4],[12,3,12,4],[14,3,14,4],[16,3,16,4],[18,3,18,4],[20,3,20,4],[22,3,22,4],[40,11,42,11],[47,1,47,4],[49,1,49,4],[51,1,51,4],[24,3,24,4],[26,3,26,4],[28,3,28,4],[36,3,36,4],[30,3,30,4],[32,3,32,4],[34,3,34,4],[57,1,57,4],[40,1,40,4],[42,1,42,4],[42,6,42,7],[44,1,44,4],[44,6,44,7],[53,1,53,4],[53,6,53,7],[55,1,55,4],[55,6,55,7]]}
["Dateneingabe"]
[]
[null,"Eingabefelder:",null,null,"xxx",null,"In diese Felder musst du betriebliche Daten eingeben!"]
[]
[null,null,null,null,"xxx",null,"Die hier enthaltenen Daten kannst du in betriebliche Werte verändern!"]
[]
[null,null,null,null,"xxx",null,"Hier kannst du die Kalkulation um betriebsspezifische Werte ergänzen!"]
[]
[]
[null,"Produktionsverfahren",null,null,null,null,"Anzahl",null,null,"DB/VK",null,"Energie-Bedarf/-Ertrag",null,"Arbeitszeit in Akh"]
[null,"DB","-","Milchverarbeitung",null,null,3,"Stk.",null,1822,null,20035,null,195]
[]
[null,"DB","-","Kalbinnen",null,null,1,{"$f":"IF(D13=\"\",\"\",IF(B13=\"DB\",\"Stk.\",\"ha\"))","v":"Stk."},null,443,null,28296,null,202.5]
[]
[null,"DB","-","Milchkälbermast",null,null,2,{"$f":"IF(D15=\"\",\"\",IF(B15=\"DB\",\"Stk.\",\"ha\"))","v":"Stk."},null,331,null,null,null,49]
[]
[null,"DB","-","Schweinemast",null,null,15,{"$f":"IF(D17=\"\",\"\",IF(B17=\"DB\",\"Stk.\",\"ha\"))","v":"Stk."},null,17,null,null,null,49]
[]
[null,"DB","-","Kartoffel Ab-Hof",null,null,2,"ha",null,1776,null,null,null,230]
[]
[null,"DB","-",null,null,null,null,{"$f":"IF(D21=\"\",\"\",IF(B21=\"DB\",\"Stk.\",\"ha\"))","v":""}]
[]
[null,"DB","-",null,null,null,null,{"$f":"IF(D23=\"\",\"\",IF(B23=\"DB\",\"Stk.\",\"ha\"))","v":""}]
[null,"Produktionsverfahren",null,null,null,null,"Anzahl",null,null,"DB/VK",null,"Energie-Bedarf/-Ertrag",null,"Arbeitszeit in Akh"]
[null,"VK","-","Feldfutterbau",null,null,0.5,{"$f":"IF(D25=\"\",\"\",IF(B25=\"DB\",\"Stk.\",\"ha\"))","v":"ha"},null,1045,null,53100,null,62.4]
[]
[null,"VK","-","mehrschn. Dauergl.",null,null,3,{"$f":"IF(D27=\"\",\"\",IF(B27=\"DB\",\"Stk.\",\"ha\"))","v":"ha"},null,542,null,33930,null,52.2]
[]
[null,"VK","-","einschn. Dauergl.",null,null,2,{"$f":"IF(D29=\"\",\"\",IF(B29=\"DB\",\"Stk.\",\"ha\"))","v":"ha"},null,542,null,18370,null,45]
[]
[null,"VK","-",null,null,null,null,{"$f":"IF(D31=\"\",\"\",IF(B31=\"DB\",\"Stk.\",\"ha\"))","v":""}]
[]
[null,"VK","-",null,null,null,null,{"$f":"IF(D33=\"\",\"\",IF(B33=\"DB\",\"Stk.\",\"ha\"))","v":""}]
[]
[null,"VK","-",null,null,null,null,{"$f":"IF(D35=\"\",\"\",IF(B35=\"DB\",\"Stk.\",\"ha\"))","v":""}]
[]
[null,"VK","-","Sonstige Arbeiten",null,null,null,{"$f":"IF(D37=\"\",\"\",IF(B37=\"DB\",\"Stk.\",\"ha\"))","v":"ha"},null,null,null,null,null,150]
[]
[]
[]
[null,"Maschinenringtätigkeit",null,null,null,null,655,null,null,null,null,"Lebenshaltungs-\nkosten",null,-16985]
[]
[]
[]
[]
[]
[]
[null,"Ausgleichszulage",null,null,null,null,2900,null,null,null,null,"Kapitaldienst für\nbestehende Kredite",null,-550]
[]
[null,"GAP Prämien Bodennutzung",null,null,null,null,1260]
[]
[null,"Tierprämien",null,null,null,null,950]
[]
[null,"ÖPUL",null,null,null,null,1280]
[]
[]
[]
[]
[]
[]
[null,"Feste Kosten - IST-Organisation",null,null,null,null,-9452]
[]
[]
[null,"Sozialeinkommen",null,null,null,null,4560,null,null,null,null,"Afa für Gebäude",null,620]
[null,null,null,null,null,null,null,null,null,null,null,"und Maschinen, die während der Kreditlaufzeit nicht erneuert werden"]
[null,"Nebeneinkommen",null,null,null,null,13460]
[]
["© Mag. Wolfgang Harasleben",null,null,null,null,null,null,null,null,null,null,null,null,null,"2014.03.06.067"]

{"sheet":"Berechnung","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,1,42,3],[32,5,33,7],[38,1,38,3],[39,1,39,3],[22,5,24,5],[22,7,24,7],[32,8,33,8],[22,6,24,6],[22,8,24,8],[2,2,4,2],[2,3,3,4],[2,1,4,1],[0,1,0,9],[2,5,3,6],[2,7,3,8]]}
[null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung"]
[]
[null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) bzw. Variable Kosten (-)",null,"Ertrag (+) bzw Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh"]
[null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh"]
[null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt"]
[null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},{"$f":"IF(Dateneingabe!J11=\"\",\"\",Dateneingabe!J11)","v":1822},null,{"$f":"IF(Dateneingabe!L11=\"\",\"\",Dateneingabe!L11)","v":20035},null,{"$f":"IF(Dateneingabe!N11=\"\",\"\",Dateneingabe!N11)","v":195}]
[null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},{"$f":"IF(Dateneingabe!J13=\"\",\"\",Dateneingabe!J13)","v":443},null,{"$f":"IF(Dateneingabe!L13=\"\",\"\",Dateneingabe!L13)","v":28296},null,{"$f":"IF(Dateneingabe!N13=\"\",\"\",Dateneingabe!N13)","v":202.5}]
[null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},{"$f":"IF(Dateneingabe!J15=\"\",\"\",Dateneingabe!J15)","v":331},null,{"$f":"IF(Dateneingabe!L15=\"\",\"\",Dateneingabe!L15)","v":""},null,{"$f":"IF(Dateneingabe!N15=\"\",\"\",Dateneingabe!N15)","v":49}]
[null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},{"$f":"IF(Dateneingabe!J17=\"\",\"\",Dateneingabe!J17)","v":17},null,{"$f":"IF(Dateneingabe!L17=\"\",\"\",Dateneingabe!L17)","v":""},null,{"$f":"IF(Dateneingabe!N17=\"\",\"\",Dateneingabe!N17)","v":49}]
[null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},{"$f":"IF(Dateneingabe!J19=\"\",\"\",Dateneingabe!J19)","v":1776},null,{"$f":"IF(Dateneingabe!L19=\"\",\"\",Dateneingabe!L19)","v":""},null,{"$f":"IF(Dateneingabe!N19=\"\",\"\",Dateneingabe!N19)","v":230}]
[null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},{"$f":"IF(Dateneingabe!J21=\"\",\"\",Dateneingabe!J21)","v":""},null,{"$f":"IF(Dateneingabe!L21=\"\",\"\",Dateneingabe!L21)","v":""},null,{"$f":"IF(Dateneingabe!N21=\"\",\"\",Dateneingabe!N21)","v":""}]
[null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},{"$f":"IF(Dateneingabe!J23=\"\",\"\",Dateneingabe!J23)","v":""},null,{"$f":"IF(Dateneingabe!L23=\"\",\"\",Dateneingabe!L23)","v":""},null,{"$f":"IF(Dateneingabe!N23=\"\",\"\",Dateneingabe!N23)","v":""}]
[null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},{"$f":"IF(Dateneingabe!J25=\"\",\"\",Dateneingabe!J25)","v":1045},null,{"$f":"IF(Dateneingabe!L25=\"\",\"\",Dateneingabe!L25)","v":53100},null,{"$f":"IF(Dateneingabe!N25=\"\",\"\",Dateneingabe!N25)","v":62.4}]
[null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},{"$f":"IF(Dateneingabe!J27=\"\",\"\",Dateneingabe!J27)","v":542},null,{"$f":"IF(Dateneingabe!L27=\"\",\"\",Dateneingabe!L27)","v":33930},null,{"$f":"IF(Dateneingabe!N27=\"\",\"\",Dateneingabe!N27)","v":52.2}]
[null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},{"$f":"IF(Dateneingabe!J29=\"\",\"\",Dateneingabe!J29)","v":542},null,{"$f":"IF(Dateneingabe!L29=\"\",\"\",Dateneingabe!L29)","v":18370},null,{"$f":"IF(Dateneingabe!N29=\"\",\"\",Dateneingabe!N29)","v":45}]
[null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},{"$f":"IF(Dateneingabe!J31=\"\",\"\",Dateneingabe!J31)","v":""},null,{"$f":"IF(Dateneingabe!L31=\"\",\"\",Dateneingabe!L31)","v":""},null,{"$f":"IF(Dateneingabe!N31=\"\",\"\",Dateneingabe!N31)","v":""}]
[null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},{"$f":"IF(Dateneingabe!J33=\"\",\"\",Dateneingabe!J33)","v":""},null,{"$f":"IF(Dateneingabe!L33=\"\",\"\",Dateneingabe!L33)","v":""},null,{"$f":"IF(Dateneingabe!N33=\"\",\"\",Dateneingabe!N33)","v":""}]
[null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},{"$f":"IF(Dateneingabe!J35=\"\",\"\",Dateneingabe!J35)","v":""},null,{"$f":"IF(Dateneingabe!L35=\"\",\"\",Dateneingabe!L35)","v":""},null,{"$f":"IF(Dateneingabe!N35=\"\",\"\",Dateneingabe!N35)","v":""}]
[null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},{"$f":"IF(Dateneingabe!J37=\"\",\"\",Dateneingabe!J37)","v":""},null,{"$f":"IF(Dateneingabe!L37=\"\",\"\",Dateneingabe!L37)","v":""},null,{"$f":"IF(Dateneingabe!N37=\"\",\"\",Dateneingabe!N37)","v":150}]
[null,"Gesamt DB",null," "]
[]
[null,"Sonstige betriebliche Erträge       +",null,null,null,"Energie- und Arbeitszeitbilanz",null,null,null,{"$f":"ROUND(I22/2000,1)","v":0}]
[null,{"$f":"IF(Dateneingabe!B41=\"\",\"\",Dateneingabe!B41)","v":"Maschinenringtätigkeit"},null,null,{"$f":"IF(Dateneingabe!G41=\"\",\"\",Dateneingabe!G41)","v":655}," +/- Ges.\nEnergie",null,"Gesamt\nAkh"]
[null,{"$f":"IF(Dateneingabe!B43=\"\",\"\",Dateneingabe!B43)","v":""},null,null,{"$f":"IF(Dateneingabe!G43=\"\",\"\",Dateneingabe!G43)","v":""}]
[null,{"$f":"IF(Dateneingabe!B45=\"\",\"\",Dateneingabe!B45)","v":""},null,null,{"$f":"IF(Dateneingabe!G45=\"\",\"\",Dateneingabe!G45)","v":""}]
[null,"Summe Sonstige Erträge"]
[]
[null,"Förderungen",null,"+",null,"Kapitaldienstgrenze"]
[null,{"$f":"IF(Dateneingabe!B48=\"\",\"\",Dateneingabe!B48)","v":"Ausgleichszulage"},null,null,{"$f":"IF(Dateneingabe!G48=\"\",\"\",Dateneingabe!G48)","v":2900},"Gesamteinkommen",null,null,{"$f":"IF(E43=\"\",\"noch leer\",E43)","v":"noch leer"},{"$f":"-I30","v":16985}]
[null,{"$f":"IF(Dateneingabe!B50=\"\",\"\",Dateneingabe!B50)","v":"GAP Prämien Bodennutzung"},null,null,1540,"Lebenshaltungskosten",null,null,{"$f":"IF(Dateneingabe!N41=\"\",\"\",Dateneingabe!N41)","v":-16985}]
[null,{"$f":"IF(Dateneingabe!B52=\"\",\"\",Dateneingabe!B52)","v":"Tierprämien"},null,null,{"$f":"IF(Dateneingabe!G52=\"\",\"\",Dateneingabe!G52)","v":950},"Kapitaldienst für bestehende Kredite",null,null,{"$f":"IF(Dateneingabe!N48=\"\",\"\",Dateneingabe!N48)","v":-550},{"$f":"-I31","v":550}]
[null,{"$f":"IF(Dateneingabe!B54=\"\",\"\",Dateneingabe!B54)","v":"ÖPUL"},null,null,{"$f":"IF(Dateneingabe!G54=\"\",\"\",Dateneingabe!G54)","v":1280},"Vorläufige Kapitaldienstgrenze"]
[null,{"$f":"IF(Dateneingabe!B56=\"\",\"\",Dateneingabe!B56)","v":""},null,null,{"$f":"IF(Dateneingabe!G56=\"\",\"\",Dateneingabe!G56)","v":""},"Afa für Gebäude und Maschinen, die während der Kreditlaufzeit nicht erneuert werden müssen.",null,null,{"$f":"IF(Dateneingabe!N64=\"\",\"\",Dateneingabe!N64)","v":620}]
[null,{"$f":"IF(Dateneingabe!B58=\"\",\"\",Dateneingabe!B58)","v":""},null,null,{"$f":"IF(Dateneingabe!G58=\"\",\"\",Dateneingabe!G58)","v":""}]
[null,"SUMME FÖRDERUNGEN",null,null,null,"Kapitaldienstgrenze"]
[]
[null,"GDB einschl. Förd. und sonst. Erträge"]
[null,"Feste Kosten bei IST-Organisation",null,null,{"$f":"IF(Dateneingabe!G61=\"\",\"\",Dateneingabe!G61)","v":-9452}]
[null,"LANDWIRTSCHAFTLICHES EINKOMMEN - Gesamt"]
[null,"LANDWIRTSCHAFTLICHES EINKOMMEN - EK/Akh"]
[null,"SOZIALEINKOMMEN",null,null,{"$f":"IF(Dateneingabe!G64=\"\",\"\",Dateneingabe!G64)","v":4560}]
[null,"NEBEEINKOMMEN",null,null,{"$f":"IF(Dateneingabe!G66=\"\",\"\",Dateneingabe!G66)","v":13460}]
[null,"GESAMTEINKOMMEN"]

{"sheet":"Korrektur","index":2,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,8,77,9],[1,0,1,11],[6,9,6,11],[69,4,69,6],[72,2,72,7]]}
["Korrekturblatt zur Deckungsbeitragsrechnung"]
[{"$f":"IF(H70<D70,\"Du musst zuerst alle Berechnungen durchführen, um das Ergebnis ansehen zu können!\",\"\")","v":"Du musst zuerst alle Berechnungen durchführen, um das Ergebnis ansehen zu können!"}]
[null,"unabhängige Ergebnisse"]
[]
[null,"abhängige Ergebnisse (werden wenn die Formel korrekt ist, als Folgefehler mit 0,5 Punkten bewertet)"]
[]
[null,null,null,"Ergebnis",null,"Formel-\nprüfung",null,"Deine Be-rechnung",{"$f":"\"Fehler\"","v":"Fehler"},"Punkte"]
["1.","Deckungsbeitrag / Variable Kosten"]
[null,{"$f":"IF(Berechnung!B6=\"\",\"\",Berechnung!B6)","v":"DB Milchverarbeitung"},null,{"$f":"IF(Hilfe!$E6=\"\",\"\",Hilfe!$E6)","v":5466},null,"-",null,{"$f":"IF(Berechnung!$E6=\"\",\"\",Berechnung!$E6)","v":""},{"$f":"IF(AND(D9=\"\",H9=\"\"),\"\",IF(H9=D9,\"Richtig!\",IF(H9=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D9=\"\",H9=\"\"),\"\",IF(I9=\"Richtig!\",1,IF(I9=\"Formel: OK\",0.5,IF(OR(I9=\"Falsch\",I9=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D9=\"\",H9=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B7=\"\",\"\",Berechnung!B7)","v":"DB Kalbinnen"},null,{"$f":"IF(Hilfe!$E7=\"\",\"\",Hilfe!$E7)","v":443},null,"-",null,{"$f":"IF(Berechnung!$E7=\"\",\"\",Berechnung!$E7)","v":""},{"$f":"IF(AND(D10=\"\",H10=\"\"),\"\",IF(H10=D10,\"Richtig!\",IF(H10=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D10=\"\",H10=\"\"),\"\",IF(I10=\"Richtig!\",1,IF(I10=\"Formel: OK\",0.5,IF(OR(I10=\"Falsch\",I10=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D10=\"\",H10=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B8=\"\",\"\",Berechnung!B8)","v":"DB Milchkälbermast"},null,{"$f":"IF(Hilfe!$E8=\"\",\"\",Hilfe!$E8)","v":662},null,"-",null,{"$f":"IF(Berechnung!$E8=\"\",\"\",Berechnung!$E8)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B9=\"\",\"\",Berechnung!B9)","v":"DB Schweinemast"},null,{"$f":"IF(Hilfe!$E9=\"\",\"\",Hilfe!$E9)","v":255},null,"-",null,{"$f":"IF(Berechnung!$E9=\"\",\"\",Berechnung!$E9)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B10=\"\",\"\",Berechnung!B10)","v":"DB Kartoffel Ab-Hof"},null,{"$f":"IF(Hilfe!$E10=\"\",\"\",Hilfe!$E10)","v":3552},null,"-",null,{"$f":"IF(Berechnung!$E10=\"\",\"\",Berechnung!$E10)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B11=\"\",\"\",Berechnung!B11)","v":""},null,{"$f":"IF(Hilfe!$E11=\"\",\"\",Hilfe!$E11)","v":""},null,"-",null,{"$f":"IF(Berechnung!$E11=\"\",\"\",Berechnung!$E11)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B12=\"\",\"\",Berechnung!B12)","v":""},null,{"$f":"IF(Hilfe!$E12=\"\",\"\",Hilfe!$E12)","v":""},null,"-",null,{"$f":"IF(Berechnung!$E12=\"\",\"\",Berechnung!$E12)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B13=\"\",\"\",Berechnung!B13)","v":"VK Feldfutterbau"},null,{"$f":"IF(Hilfe!$E13=\"\",\"\",Hilfe!$E13)","v":-522.5},null,"-",null,{"$f":"IF(Berechnung!$E13=\"\",\"\",Berechnung!$E13)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B14=\"\",\"\",Berechnung!B14)","v":"VK mehrschn. Dauergl."},null,{"$f":"IF(Hilfe!$E14=\"\",\"\",Hilfe!$E14)","v":-1626},null,"-",null,{"$f":"IF(Berechnung!$E14=\"\",\"\",Berechnung!$E14)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B15=\"\",\"\",Berechnung!B15)","v":"VK einschn. Dauergl."},null,{"$f":"IF(Hilfe!$E15=\"\",\"\",Hilfe!$E15)","v":-1084},null,"-",null,{"$f":"IF(Berechnung!$E15=\"\",\"\",Berechnung!$E15)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B16=\"\",\"\",Berechnung!B16)","v":""},null,{"$f":"IF(Hilfe!$E16=\"\",\"\",Hilfe!$E16)","v":""},null,"-",null,{"$f":"IF(Berechnung!$E16=\"\",\"\",Berechnung!$E16)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B17=\"\",\"\",Berechnung!B17)","v":""},null,{"$f":"IF(Hilfe!$E17=\"\",\"\",Hilfe!$E17)","v":""},null,"-",null,{"$f":"IF(Berechnung!$E17=\"\",\"\",Berechnung!$E17)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B18=\"\",\"\",Berechnung!B18)","v":""},null,{"$f":"IF(Hilfe!$E18=\"\",\"\",Hilfe!$E18)","v":""},null,"-",null,{"$f":"IF(Berechnung!$E18=\"\",\"\",Berechnung!$E18)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B19=\"\",\"\",Berechnung!B19)","v":"VK Sonstige Arbeiten"},null,{"$f":"IF(Hilfe!$E19=\"\",\"\",Hilfe!$E19)","v":""},null,"-",null,{"$f":"IF(Berechnung!$E19=\"\",\"\",Berechnung!$E19)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B20=\"\",\"\",Berechnung!B20)","v":"Gesamt DB"},null,{"$f":"IF(Hilfe!$E20=\"\",\"\",Hilfe!$E20)","v":7145.5},null,{"$f":"IF(SUM(H9:H22)=0,\"-\",SUM(H9:H22))","v":"-"},null,{"$f":"IF(Berechnung!$E20=\"\",\"\",Berechnung!$E20)","v":""},{"$f":"IF(B23=\"-\",\"\",IF(H23=D23,\"Richtig!\",IF(AND(D23<>H23,F23=H23),\"Formel: OK\",IF(H23=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B23=\"-\",\"\",IF(I23=\"Richtig!\",1,IF(I23=\"Formel: OK\",0.5,IF(OR(I23=\"Falsch\",I23=\"Fehlt\"),0,\"\"))))","v":0},"│",1]
[]
["2.","Ertrag / Bedarf MJ NEL"]
[null,{"$f":"IF(Berechnung!B6=\"\",\"\",MID(Berechnung!B6,4,30))","v":"Milchverarbeitung"},null,{"$f":"IF(Hilfe!$G6=\"\",\"\",Hilfe!$G6)","v":-60105},null,"-",null,{"$f":"IF(Berechnung!$G6=\"\",\"\",Berechnung!$G6)","v":""},{"$f":"IF(AND(D26=\"\",H26=\"\"),\"\",IF(H26=D26,\"Richtig!\",IF(H26=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D26=\"\",H26=\"\"),\"\",IF(I26=\"Richtig!\",1,IF(I26=\"Formel: OK\",0.5,IF(OR(I26=\"Falsch\",I26=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D26=\"\",H26=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B7=\"\",\"\",MID(Berechnung!B7,4,30))","v":"Kalbinnen"},null,{"$f":"IF(Hilfe!$G7=\"\",\"\",Hilfe!$G7)","v":-28296},null,"-",null,{"$f":"IF(Berechnung!$G7=\"\",\"\",Berechnung!$G7)","v":""},{"$f":"IF(AND(D27=\"\",H27=\"\"),\"\",IF(H27=D27,\"Richtig!\",IF(H27=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D27=\"\",H27=\"\"),\"\",IF(I27=\"Richtig!\",1,IF(I27=\"Formel: OK\",0.5,IF(OR(I27=\"Falsch\",I27=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D27=\"\",H27=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B8=\"\",\"\",MID(Berechnung!B8,4,30))","v":"Milchkälbermast"},null,{"$f":"IF(Hilfe!$G8=\"\",\"\",Hilfe!$G8)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G8=\"\",\"\",Berechnung!$G8)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B9=\"\",\"\",MID(Berechnung!B9,4,30))","v":"Schweinemast"},null,{"$f":"IF(Hilfe!$G9=\"\",\"\",Hilfe!$G9)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G9=\"\",\"\",Berechnung!$G9)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B10=\"\",\"\",MID(Berechnung!B10,4,30))","v":"Kartoffel Ab-Hof"},null,{"$f":"IF(Hilfe!$G10=\"\",\"\",Hilfe!$G10)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G10=\"\",\"\",Berechnung!$G10)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B11=\"\",\"\",MID(Berechnung!B11,4,30))","v":""},null,{"$f":"IF(Hilfe!$G11=\"\",\"\",Hilfe!$G11)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G11=\"\",\"\",Berechnung!$G11)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B12=\"\",\"\",MID(Berechnung!B12,4,30))","v":""},null,{"$f":"IF(Hilfe!$G12=\"\",\"\",Hilfe!$G12)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G12=\"\",\"\",Berechnung!$G12)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B13=\"\",\"\",MID(Berechnung!B13,4,30))","v":"Feldfutterbau"},null,{"$f":"IF(Hilfe!$G13=\"\",\"\",Hilfe!$G13)","v":26550},null,"-",null,{"$f":"IF(Berechnung!$G13=\"\",\"\",Berechnung!$G13)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B14=\"\",\"\",MID(Berechnung!B14,4,30))","v":"mehrschn. Dauergl."},null,{"$f":"IF(Hilfe!$G14=\"\",\"\",Hilfe!$G14)","v":101790},null,"-",null,{"$f":"IF(Berechnung!$G14=\"\",\"\",Berechnung!$G14)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B15=\"\",\"\",MID(Berechnung!B15,4,30))","v":"einschn. Dauergl."},null,{"$f":"IF(Hilfe!$G15=\"\",\"\",Hilfe!$G15)","v":36740},null,"-",null,{"$f":"IF(Berechnung!$G15=\"\",\"\",Berechnung!$G15)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B16=\"\",\"\",MID(Berechnung!B16,4,30))","v":""},null,{"$f":"IF(Hilfe!$G16=\"\",\"\",Hilfe!$G16)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G16=\"\",\"\",Berechnung!$G16)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B17=\"\",\"\",MID(Berechnung!B17,4,30))","v":""},null,{"$f":"IF(Hilfe!$G17=\"\",\"\",Hilfe!$G17)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G17=\"\",\"\",Berechnung!$G17)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B18=\"\",\"\",MID(Berechnung!B18,4,30))","v":""},null,{"$f":"IF(Hilfe!$G18=\"\",\"\",Hilfe!$G18)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G18=\"\",\"\",Berechnung!$G18)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B19=\"\",\"\",MID(Berechnung!B19,4,30))","v":"Sonstige Arbeiten"},null,{"$f":"IF(Hilfe!$G19=\"\",\"\",Hilfe!$G19)","v":""},null,"-",null,{"$f":"IF(Berechnung!$G19=\"\",\"\",Berechnung!$G19)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!F23=\"\",\"\",Berechnung!F23)","v":" +/- Ges.\nEnergie"},null,{"$f":"IF(Hilfe!$G71=\"\",\"\",Hilfe!$G71)","v":76679},null,{"$f":"IF(SUM(H26:H39)=0,\"-\",SUM(H26:H39))","v":"-"},null,{"$f":"IF(Berechnung!$G23=\"\",\"\",Berechnung!$G23)","v":""},{"$f":"IF(B40=\"-\",\"\",IF(H40=D40,\"Richtig!\",IF(AND(D40<>H40,F40=H40),\"Formel: OK\",IF(H40=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B40=\"-\",\"\",IF(I40=\"Richtig!\",1,IF(I40=\"Formel: OK\",0.5,IF(OR(I40=\"Falsch\",I40=\"Fehlt\"),0,\"\"))))","v":0},"│",1]
[]
["3.","Jahresarbeitszeit"]
[null,{"$f":"IF(Berechnung!B6=\"\",\"\",MID(Berechnung!B6,4,30))","v":"Milchverarbeitung"},null,{"$f":"IF(Hilfe!$I6=\"\",\"\",Hilfe!$I6)","v":585},null,"-",null,{"$f":"IF(Berechnung!$I6=\"\",\"\",Berechnung!$I6)","v":""},{"$f":"IF(AND(D43=\"\",H43=\"\"),\"\",IF(H43=D43,\"Richtig!\",IF(H43=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D43=\"\",H43=\"\"),\"\",IF(I43=\"Richtig!\",1,IF(I43=\"Formel: OK\",0.5,IF(OR(I43=\"Falsch\",I43=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D43=\"\",H43=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B7=\"\",\"\",MID(Berechnung!B7,4,30))","v":"Kalbinnen"},null,{"$f":"IF(Hilfe!$I7=\"\",\"\",Hilfe!$I7)","v":202.5},null,"-",null,{"$f":"IF(Berechnung!$I7=\"\",\"\",Berechnung!$I7)","v":""},{"$f":"IF(AND(D44=\"\",H44=\"\"),\"\",IF(H44=D44,\"Richtig!\",IF(H44=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D44=\"\",H44=\"\"),\"\",IF(I44=\"Richtig!\",1,IF(I44=\"Formel: OK\",0.5,IF(OR(I44=\"Falsch\",I44=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D44=\"\",H44=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B8=\"\",\"\",MID(Berechnung!B8,4,30))","v":"Milchkälbermast"},null,{"$f":"IF(Hilfe!$I8=\"\",\"\",Hilfe!$I8)","v":98},null,"-",null,{"$f":"IF(Berechnung!$I8=\"\",\"\",Berechnung!$I8)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B9=\"\",\"\",MID(Berechnung!B9,4,30))","v":"Schweinemast"},null,{"$f":"IF(Hilfe!$I9=\"\",\"\",Hilfe!$I9)","v":735},null,"-",null,{"$f":"IF(Berechnung!$I9=\"\",\"\",Berechnung!$I9)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B10=\"\",\"\",MID(Berechnung!B10,4,30))","v":"Kartoffel Ab-Hof"},null,{"$f":"IF(Hilfe!$I10=\"\",\"\",Hilfe!$I10)","v":460},null,"-",null,{"$f":"IF(Berechnung!$I10=\"\",\"\",Berechnung!$I10)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B11=\"\",\"\",MID(Berechnung!B11,4,30))","v":""},null,{"$f":"IF(Hilfe!$I11=\"\",\"\",Hilfe!$I11)","v":""},null,"-",null,{"$f":"IF(Berechnung!$I11=\"\",\"\",Berechnung!$I11)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B12=\"\",\"\",MID(Berechnung!B12,4,30))","v":""},null,{"$f":"IF(Hilfe!$I12=\"\",\"\",Hilfe!$I12)","v":""},null,"-",null,{"$f":"IF(Berechnung!$I12=\"\",\"\",Berechnung!$I12)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B13=\"\",\"\",MID(Berechnung!B13,4,30))","v":"Feldfutterbau"},null,{"$f":"IF(Hilfe!$I13=\"\",\"\",Hilfe!$I13)","v":31.2},null,"-",null,{"$f":"IF(Berechnung!$I13=\"\",\"\",Berechnung!$I13)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B14=\"\",\"\",MID(Berechnung!B14,4,30))","v":"mehrschn. Dauergl."},null,{"$f":"IF(Hilfe!$I14=\"\",\"\",Hilfe!$I14)","v":156.60000000000002},null,"-",null,{"$f":"IF(Berechnung!$I14=\"\",\"\",Berechnung!$I14)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B15=\"\",\"\",MID(Berechnung!B15,4,30))","v":"einschn. Dauergl."},null,{"$f":"IF(Hilfe!$I15=\"\",\"\",Hilfe!$I15)","v":90},null,"-",null,{"$f":"IF(Berechnung!$I15=\"\",\"\",Berechnung!$I15)","v":""},"Fehlt",0,"│",1]
[null,{"$f":"IF(Berechnung!B16=\"\",\"\",MID(Berechnung!B16,4,30))","v":""},null,{"$f":"IF(Hilfe!$I16=\"\",\"\",Hilfe!$I16)","v":""},null,"-",null,{"$f":"IF(Berechnung!$I16=\"\",\"\",Berechnung!$I16)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B17=\"\",\"\",MID(Berechnung!B17,4,30))","v":""},null,{"$f":"IF(Hilfe!$I17=\"\",\"\",Hilfe!$I17)","v":""},null,"-",null,{"$f":"IF(Berechnung!$I17=\"\",\"\",Berechnung!$I17)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B18=\"\",\"\",MID(Berechnung!B18,4,30))","v":""},null,{"$f":"IF(Hilfe!$I18=\"\",\"\",Hilfe!$I18)","v":""},null,"-",null,{"$f":"IF(Berechnung!$I18=\"\",\"\",Berechnung!$I18)","v":""},"","","│",""]
[null,{"$f":"IF(Berechnung!B19=\"\",\"\",MID(Berechnung!B19,4,30))","v":"Sonstige Arbeiten"},null,{"$f":"IF(Hilfe!$I19=\"\",\"\",Hilfe!$I19)","v":150},null,"-",null,{"$f":"IF(Berechnung!$I19=\"\",\"\",Berechnung!$I19)","v":""},"Fehlt",0,"│",1]
[null,"Gesamt Akh",null,{"$f":"IF(Hilfe!$I99=\"\",\"\",Hilfe!$I99)","v":2508.2999999999997},null,{"$f":"IF(SUM(H43:H56)=0,\"-\",SUM(H43:H56))","v":"-"},null,{"$f":"IF(Berechnung!$I23=\"\",\"\",Berechnung!$I23)","v":""},{"$f":"IF(B57=\"-\",\"\",IF(H57=D57,\"Richtig!\",IF(AND(D57<>H57,F57=H57),\"Formel: OK\",IF(H57=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B57=\"-\",\"\",IF(I57=\"Richtig!\",1,IF(I57=\"Formel: OK\",0.5,IF(OR(I57=\"Falsch\",I57=\"Fehlt\"),0,\"\"))))","v":0},"│",1]
[]
["4.","Einkommensermittlung"]
[null,{"$f":"IF(Berechnung!B26=\"\",\"\",Berechnung!B26)","v":"Summe Sonstige Erträge"},null,{"$f":"IF(Hilfe!$E111=\"\",\"\",Hilfe!$E111)","v":655},null,"-",null,{"$f":"IF(Berechnung!$E26=\"\",\"\",Berechnung!$E26)","v":""},{"$f":"IF(AND(D60=\"\",H60=\"\"),\"\",IF(H60=D60,\"Richtig!\",IF(H60=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D60=\"\",H60=\"\"),\"\",IF(I60=\"Richtig!\",1,IF(I60=\"Formel: OK\",0.5,IF(OR(I60=\"Falsch\",I60=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D60=\"\",H60=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B35=\"\",\"\",Berechnung!B35)","v":"SUMME FÖRDERUNGEN"},null,{"$f":"IF(Hilfe!$E122=\"\",\"\",Hilfe!$E122)","v":6670},null,"-",null,{"$f":"IF(Berechnung!$E35=\"\",\"\",Berechnung!$E35)","v":""},{"$f":"IF(AND(D61=\"\",H61=\"\"),\"\",IF(H61=D61,\"Richtig!\",IF(H61=\"\",\"Fehlt\",\"Falsch\")))","v":"Fehlt"},{"$f":"IF(AND(D61=\"\",H61=\"\"),\"\",IF(I61=\"Richtig!\",1,IF(I61=\"Formel: OK\",0.5,IF(OR(I61=\"Falsch\",I61=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D61=\"\",H61=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B37=\"\",\"\",Berechnung!B37)","v":"GDB einschl. Förd. und sonst. Erträge"},null,{"$f":"IF(Hilfe!$E124=\"\",\"\",Hilfe!$E124)","v":14470.5},null,{"$f":"IF(SUM(H23,H60,H61)=0,\"-\",SUM(H23,H60,H61))","v":"-"},null,{"$f":"IF(Berechnung!$E37=\"\",\"\",Berechnung!$E37)","v":""},{"$f":"IF(B62=\"-\",\"\",IF(H62=D62,\"Richtig!\",IF(AND(D62<>H62,F62=H62),\"Formel: OK\",IF(H62=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B62=\"-\",\"\",IF(I62=\"Richtig!\",1,IF(I62=\"Formel: OK\",0.5,IF(OR(I62=\"Falsch\",I62=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(B62=\"-\",\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B39=\"\",\"\",Berechnung!B39)","v":"LANDWIRTSCHAFTLICHES EINKOMMEN - Gesamt"},null,{"$f":"IF(Hilfe!$E126=\"\",\"\",Hilfe!$E126)","v":5018.5},null,{"$f":"IF(OR(F62=\"-\",Berechnung!E38=\"\"),\"-\",SUM(F62,Berechnung!E38))","v":"-"},null,{"$f":"IF(Berechnung!$E39=\"\",\"\",Berechnung!$E39)","v":""},{"$f":"IF(B63=\"-\",\"\",IF(H63=D63,\"Richtig!\",IF(AND(D63<>H63,F63=H63),\"Formel: OK\",IF(H63=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B63=\"-\",\"\",IF(I63=\"Richtig!\",1,IF(I63=\"Formel: OK\",0.5,IF(OR(I63=\"Falsch\",I63=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(B63=\"-\",\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B40=\"\",\"\",Berechnung!B40)","v":"LANDWIRTSCHAFTLICHES EINKOMMEN - EK/Akh"},null,{"$f":"IF(Hilfe!$E127=\"\",\"\",Hilfe!$E127)","v":2.0007574851493044},null,{"$f":"IF(OR(H63=\"\",H57=\"\"),\"-\",H63/H57)","v":"-"},null,{"$f":"IF(Berechnung!$E40=\"\",\"\",Berechnung!$E40)","v":""},{"$f":"IF(B64=\"-\",\"\",IF(H64=D64,\"Richtig!\",IF(AND(D64<>H64,F64=H64),\"Formel: OK\",IF(H64=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B64=\"-\",\"\",IF(I64=\"Richtig!\",1,IF(I64=\"Formel: OK\",0.5,IF(OR(I64=\"Falsch\",I64=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(B64=\"-\",\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!B43=\"\",\"\",Berechnung!B43)","v":"GESAMTEINKOMMEN"},null,{"$f":"IF(Hilfe!$E130=\"\",\"\",Hilfe!$E130)","v":23038.5},null,{"$f":"IF(OR(H63=\"\",SUM(Berechnung!E41:E42)=0),\"-\",SUM(H63,Berechnung!E41:E42))","v":"-"},null,{"$f":"IF(Berechnung!$E43=\"\",\"\",Berechnung!$E43)","v":""},{"$f":"IF(B65=\"-\",\"\",IF(H65=D65,\"Richtig!\",IF(AND(D65<>H65,F65=H65),\"Formel: OK\",IF(H65=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(B65=\"-\",\"\",IF(I65=\"Richtig!\",1,IF(I65=\"Formel: OK\",0.5,IF(OR(I65=\"Falsch\",I65=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(B65=\"-\",\"\",1)","v":1}]
[]
["5.","Ermittlung der Kapitaldienstgrenze"]
[null,{"$f":"IF(Berechnung!F32=\"\",\"\",Berechnung!F32)","v":"Vorläufige Kapitaldienstgrenze"},null,{"$f":"IF(Hilfe!$I119=\"\",\"\",Hilfe!$I119)","v":5503.5},null,{"$f":"IF(OR(H65=\"\",SUM(Berechnung!I30:I31)=0),\"-\",SUM(H65,Berechnung!I30:I31))","v":"-"},null,{"$f":"IF(Berechnung!$I32=\"\",\"\",Berechnung!$I32)","v":""},{"$f":"IF(B68=\"-\",\"\",IF(H68=D68,\"Richtig!\",IF(AND(D68<>H68,F68=H68),\"Formel: OK\",IF(H68=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(AND(D68=\"\",H68=\"\"),\"\",IF(I68=\"Richtig!\",1,IF(I68=\"Formel: OK\",0.5,IF(OR(I68=\"Falsch\",I68=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D68=\"\",H68=\"\"),\"\",1)","v":1}]
[null,{"$f":"IF(Berechnung!F35=\"\",\"\",Berechnung!F35)","v":"Kapitaldienstgrenze"},null,{"$f":"IF(Hilfe!$I122=\"\",\"\",Hilfe!$I122)","v":6123.5},null,{"$f":"IF(OR(H68=\"\",Berechnung!I33=\"\"),\"-\",SUM(H68,Berechnung!I33))","v":"-"},null,{"$f":"IF(Berechnung!$I35=\"\",\"\",Berechnung!$I35)","v":""},{"$f":"IF(B69=\"-\",\"\",IF(H69=D69,\"Richtig!\",IF(AND(D69<>H69,F69=H69),\"Formel: OK\",IF(H69=\"\",\"Fehlt\",\"Falsch\"))))","v":"Fehlt"},{"$f":"IF(AND(D69=\"\",H69=\"\"),\"\",IF(I69=\"Richtig!\",1,IF(I69=\"Formel: OK\",0.5,IF(OR(I69=\"Falsch\",I69=\"Fehlt\"),0,\"\"))))","v":0},"│",{"$f":"IF(AND(D69=\"\",H69=\"\"),\"\",1)","v":1}]
["Gesamtpunktezahl",null,null,{"$f":"COUNT(D9:D69)","v":33},null,null,null,{"$f":"COUNT(H9:H69)","v":0},null,{"$f":"SUM(J9:J69)","v":0},"│",{"$f":"SUM(L9:L69)","v":33}]
[]
[]
["Note",null,{"$f":"J70/L70","v":0}]
[null,{"$f":"C74-I78","v":30},{"$f":"L70","v":33},{"$f":"IF(AND(J70>=B74-0.5,J70<=C74),\"u\",\"j\")","v":"j"},{"$f":"IF(OR(J70=B74-0.5,J70=B74),\"-\",\"\")","v":""}]
[null,{"$f":"C75-I78","v":26},{"$f":"B74-1","v":29},{"$f":"IF(AND(J70>=B75-0.5,J70<=C75),\"v\",\"k\")","v":"k"},{"$f":"IF(OR(J70=B75-0.5,J70=B75),\"-\",IF(OR(J70=C75-0.5,J70=C75),\"+\",\"\"))","v":""}]
[null,{"$f":"C76-I78","v":22},{"$f":"B75-1","v":25},{"$f":"IF(AND(J70>=B76-0.5,J70<=C76),\"w\",\"l\")","v":"l"},{"$f":"IF(OR(J70=B76-0.5,J70=B76),\"-\",IF(OR(J70=C76-0.5,J70=C76),\"+\",\"\"))","v":""}]
[null,{"$f":"C77-I78","v":18},{"$f":"B76-1","v":21},{"$f":"IF(AND(J70>=B77-0.5,J70<=C77),\"x\",\"m\")","v":"m"},{"$f":"IF(OR(J70=B77-0.5,J70=B77),\"-\",IF(OR(J70=C77-0.5,J70=C77),\"+\",\"\"))","v":""},null,"Abstufung:",null,0.1]
[null,0,{"$f":"B77-1","v":17},{"$f":"IF(AND(J70>=B78-0.5,J70<=C78),\"y\",\"n\")","v":"y"},{"$f":"IF(OR(J70=C78-1,J70=C78-0.5,J70=C78),\"+\",\"\")","v":""},null,null,null,{"$f":"ROUND(L70*I77,0)","v":3}]

{"sheet":"Hilfe","index":3,"n_rows":150,"n_cols":125,"rows_kept":150,"cut":false,"hidden":false,"merged":[[35,43,37,43],[35,45,37,45],[33,50,34,52],[30,48,30,49],[23,68,27,70],[24,61,26,61],[24,62,26,62],[24,63,26,63],[24,60,26,60],[26,50,27,52],[23,66,23,67],[23,50,25,52],[22,40,23,44],[8,122,9,124],[17,122,18,124],[14,104,16,106],[17,104,18,106],[7,99,8,99],[8,104,10,106],[3,79,5,79],[3,80,5,80],[3,81,5,81],[7,96,8,98],[0,119,0,125],[0,56,0,63],[0,65,0,71],[0,74,0,81],[0,83,0,89],[2,26,3,27],[3,122,4,124],[4,110,4,112],[3,104,4,106],[3,78,5,78],[0,29,0,35],[0,38,0,45],[0,47,0,53],[5,110,5,112],[2,62,3,63],[2,56,4,56],[2,57,4,57],[2,58,3,59],[2,60,3,61],[2,44,3,45],[2,38,4,38],[2,39,4,39],[2,40,3,41],[2,42,3,43],[0,92,0,99],[0,101,0,107],[2,22,3,23],[2,24,3,25],[28,68,30,70],[30,50,32,52],[0,110,0,117],[0,20,0,27],[58,13,60,15],[0,10,0,16],[21,11,21,12],[24,13,25,15],[31,13,32,15],[2,20,4,20],[2,21,4,21],[33,32,34,34],[30,30,30,31],[23,32,25,34],[30,32,32,34],[23,30,23,31],[26,32,27,34],[23,48,23,49],[8,110,8,112],[35,42,37,42],[119,5,120,7],[107,5,109,5],[2,7,3,8],[39,1,41,1],[76,7,77,8],[98,7,100,7],[129,1,129,3],[76,1,78,1],[76,2,78,2],[76,5,77,6],[107,6,109,6],[70,5,72,5],[70,6,72,6],[125,1,125,3],[126,1,126,3],[70,7,72,7],[70,8,72,8],[0,1,0,8],[28,11,28,12],[39,2,41,2],[39,3,40,4],[39,5,40,6],[2,1,4,1],[2,2,4,2],[2,3,3,4],[2,5,3,6],[98,6,100,6],[21,13,23,15],[28,13,30,15],[107,7,109,7],[107,8,109,8],[59,3,60,7],[68,13,69,15],[98,5,100,5],[39,7,40,8],[65,11,65,12],[76,3,77,4],[58,11,58,12],[61,13,62,15],[65,13,67,15],[98,8,100,8],[138,13,139,15],[147,13,148,15],[120,13,122,15],[126,13,128,15],[129,13,130,15],[133,13,134,15],[119,8,120,8],[94,11,94,12],[99,13,101,15],[94,13,98,15],[115,13,116,15]]}
[null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse",null,null,null,null,null,null,"Notizen",null,null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse",null,null,null,null,null,null,null,null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse",null,null,null,null,null,null,null,null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse",null,null,null,null,null,null,null,null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse",null,null,null,null,null,null,null,null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse",null,null,null,null,null,null,null,null,"Berechnung der betrieblichen Ausgangssituation\nüber die Deckungsbeitragsrechnung",null,null,null,null,null,null,null,null,"Hilfe - Formeln, Rechenansätze und Ergebnisse"]
[]
[null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) / Variable Kosten (-)",null,"Ertrag (+) / Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh",null,null,null,"Deckungsbeitrag / Variable Kosten gesamt",null,null,null,null,null,null,null,null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) / Variable Kosten (-)",null,"Ertrag (+) / Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh",null,null,null,"Deckungsbeitrag / Variable Kosten gesamt",null,null,null,null,null,null,null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) / Variable Kosten (-)",null,"Ertrag (+) / Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh",null,null,null,"Energieertrag / Energiebedarf gesamt",null,null,null,null,null,null,null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) / Variable Kosten (-)",null,"Ertrag (+) / Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh",null,null,null,"Arbeitszeit gesamt",null,null,null,null,null,null,null,"Sonstige betriebliche Erträge       +",null,null,null,"Energie- und Arbeitszeitbilanz",null,null,null,null,null,null,null,null,null,null,null,null,null,"Förderungen",null,"+",null,"Kapitaldienstgrenze",null,null,null,null,null,"Vorläufige Kapitaldienstgrenze",null,null,null,"Excel: =SUMME(I29:I30)",null,null,null,"GDB einschl. Förd. und sonst. Erträge",null,null,{"$f":"SUM(X20,BZ7,CR10)","v":14470.5},null,null,null,null,null,null,"GDB einschl. Förd. Und sonst. Erträge",null,null,null,"Excel: =SUMME(E20;E26;E35)"]
[null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh",null,null,null,"DB gesamt = DB je Stk. * Stk.",null,null,"… oder: DB gesamt = DB je ha * ha",null,null,null,null,null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh",null,null,null,"DB gesamt = DB je Stk. * Stk.",null,null,"… oder: DB gesamt = DB je ha * ha",null,null,null,null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh",null,null,null,"Bedarf ges. = Bedarf je Stk * Stk.",null,null,null,"… oder: Bedarf gesamt = Bedarf je ha * ha",null,null,null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh",null,null,null,"AZ ges. = AZ je Stk * Stk.",null,null,null,"… oder: AZ ges. = AZ je ha * ha",null,null,null,{"$f":"IF(Dateneingabe!B41=\"\",\"\",Dateneingabe!B41)","v":"Maschinenringtätigkeit"},null,null,{"$f":"IF(Dateneingabe!G41=\"\",\"\",Dateneingabe!G41)","v":655}," +/- Ges.\nEnergie",{"$f":"SUM(Z6:Z19)","v":76679},"Gesamt\nAkh",{"$f":"SUM(AB6:AB19)","v":2508.2999999999997},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!B48=\"\",\"\",Dateneingabe!B48)","v":"Ausgleichszulage"},null,null,{"$f":"IF(Dateneingabe!G48=\"\",\"\",Dateneingabe!G48)","v":2900},"Gesamteinkommen",null,null,{"$f":"IF(E130=\"\",\"noch leer\",E130)","v":23038.5},null,null,"vorl. KDG =",null,{"$f":"IF(CS4=\"\",\"\",CS4)&IF(CS5<>\"\",\" - \",\"\")&IF(CS5=\"\",\"\",CS5)&IF(CS6<>\"\",\" - \",\"\")&IF(CS6=\"\",\"\",CS6)","v":"Gesamteinkommen - Lebenshaltungskosten - Kapitaldienst für bestehende Kredite"},null,null,null,null,null,"Feste Kosten bei IST-Organisation",null,null,{"$f":"IF(Dateneingabe!G61=\"\",\"\",Dateneingabe!G61)","v":-9452},null,null,null,null,null,null,"GDB i.F.u.s.E. =",null,{"$f":"IF(U20=\"\",\"\",U20)&IF(BW7<>\"\",\" + \",\"\")&IF(BW7=\"\",\"\",BW7)&IF(CO10<>\"\",\" + \",\"\")&IF(CO10=\"\",\"\",CO10)","v":"Gesamt DB + Summe Sonstige Erträge + SUMME FÖRDERUNGEN"}]
[null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt",null,null,"VK gesamt = VK je ha * ha",null,null,null,null,null,null,null,null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt",null,null,"VK gesamt = VK je ha * ha",null,null,null,null,null,null,null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt",null,null,"Ertrag ges. = Ertrag je ha * ha",null,null,null,null,null,null,null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt",null,null,"Bsp.:",{"$f":"IF(BE6=\"\",\"\",MID(BE6,4,20))","v":"Milchverarbeitung"},null,{"$f":"IF(AND(BF6=\"\",BK6=\"\"),\"\",IF(AND(BF6=\"\",BK6<>\"\"),\"AZ ges. = \"&FIXED(BK6,2),\"AZ ges. = \"&FIXED(BF6,2)&\" * \"&FIXED(BK6,2)&\" = \"&FIXED(BF6*BK6,2)))","v":"AZ ges. = 3,00 * 195,00 = 585,00"},null,null,null,null,{"$f":"IF(Dateneingabe!B43=\"\",\"\",Dateneingabe!B43)","v":""},null,null,{"$f":"IF(Dateneingabe!G43=\"\",\"\",Dateneingabe!G43)","v":""},null,null,null,null,null,null,"Summe sonstiger Erträge",null,null,null,"Excel: =SUMME(E23:E25)",null,null,null,{"$f":"IF(Dateneingabe!B50=\"\",\"\",Dateneingabe!B50)","v":"GAP Prämien Bodennutzung"},null,null,1540,"Lebenshaltungskosten",null,null,{"$f":"IF(Dateneingabe!N41=\"\",\"\",Dateneingabe!N41)","v":-16985},null,null,null,null,null,null,null,null,null,null,"LANDWIRTSCHAFTLICHES EINKOMMEN - Gesamt",null,null,{"$f":"SUM(DJ3:DJ4)","v":5018.5}]
[null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},{"$f":"IF(Dateneingabe!J11=\"\",\"\",Dateneingabe!J11)","v":1822},{"$f":"IF(OR(D6=\"\",$C6=\"\"),\"\",D6*$C6)","v":5466},{"$f":"IF(Dateneingabe!L11=\"\",\"\",Dateneingabe!L11)","v":20035},{"$f":"IF(OR(F6=\"\",$C6=\"\"),\"\",-F6*$C6)","v":-60105},{"$f":"IF(Dateneingabe!N11=\"\",\"\",Dateneingabe!N11)","v":195},{"$f":"IF(AND(H6=\"\",$C6=\"\"),\"\",IF(AND(H6<>\"\",$C6=\"\"),H6,H6*$C6))","v":585},null,null,"Bsp.:",{"$f":"IF(B6=\"\",\"\",MID(B6,4,20))","v":"Milchverarbeitung"},null,{"$f":"IF(OR(C6=\"\",D6=\"\"),\"\",\"DB ges. = \"&FIXED(C6,2)&\" * \"&DOLLAR(D6,2)&\" = \"&DOLLAR(C6*D6,2))","v":"DB ges. = 3,00 * € 1 822,00 = € 5 466,00"},null,null,null,null,null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},{"$f":"IF(Dateneingabe!J11=\"\",\"\",Dateneingabe!J11)","v":1822},{"$f":"IF(OR(W6=\"\",$V6=\"\"),\"\",W6*$V6)","v":5466},{"$f":"IF(Dateneingabe!L11=\"\",\"\",Dateneingabe!L11)","v":20035},{"$f":"IF(OR(Y6=\"\",$V6=\"\"),\"\",-Y6*$V6)","v":-60105},{"$f":"IF(Dateneingabe!N11=\"\",\"\",Dateneingabe!N11)","v":195},{"$f":"IF(AND(AA6=\"\",$V6=\"\"),\"\",IF(AND(AA6<>\"\",$V6=\"\"),AA6,AA6*$V6))","v":585},null,null,"Bsp.:",{"$f":"IF(U6=\"\",\"\",MID(U6,4,20))","v":"Milchverarbeitung"},null,{"$f":"IF(OR(V6=\"\",W6=\"\"),\"\",\"DB ges. = \"&FIXED(V6,2)&\" * \"&DOLLAR(W6,2)&\" = \"&DOLLAR(V6*W6,2))","v":"DB ges. = 3,00 * € 1 822,00 = € 5 466,00"},null,null,null,null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},null,null,{"$f":"IF(Dateneingabe!L11=\"\",\"\",Dateneingabe!L11)","v":20035},{"$f":"IF(OR(AQ6=\"\",$AN6=\"\"),\"\",-AQ6*$AN6)","v":-60105},null,null,null,null,"Bsp.:",{"$f":"IF(OR(AM6=\"\",AQ6=\"\"),\"\",MID(AM6,4,20))","v":"Milchverarbeitung"},null,{"$f":"IF(OR(AN6=\"\",AQ6=\"\"),\"\",\"Bedarf ges. = \"&FIXED(AN6,2)&\" * \"&FIXED(-AQ6,2)&\" = \"&FIXED(-AN6*AQ6,2))","v":"Bedarf ges. = 3,00 * -20 035,00 = -60 105,00"},null,null,null,null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},null,null,null,null,{"$f":"IF(Dateneingabe!N11=\"\",\"\",Dateneingabe!N11)","v":195},{"$f":"IF(AND(BF6=\"\",$BK6=\"\"),\"\",IF(AND(BF6=\"\",$BK6<>\"\"),BK6,BF6*$BK6))","v":585},null,null,null,"Kalbinnen",null,"AZ ges. = 1,00 * 202,50 = 202,50",null,null,null,null,{"$f":"IF(Dateneingabe!B45=\"\",\"\",Dateneingabe!B45)","v":""},null,null,{"$f":"IF(Dateneingabe!G45=\"\",\"\",Dateneingabe!G45)","v":""},null,null,null,null,null,null,{"$f":"\"∑ sonst. Erträge = \"&IF(BW4=\"\",\"\",BW4)&IF(BW5<>\"\",\" + \",\"\")&IF(BW5=\"\",\"\",BW5)&IF(BW6<>\"\",\" + \",\"\")&IF(BW6=\"\",\"\",BW6)","v":"∑ sonst. Erträge = Maschinenringtätigkeit"},null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!B52=\"\",\"\",Dateneingabe!B52)","v":"Tierprämien"},null,null,{"$f":"IF(Dateneingabe!G52=\"\",\"\",Dateneingabe!G52)","v":950},"Kapitaldienst für bestehende Kredite",null,null,{"$f":"IF(Dateneingabe!N48=\"\",\"\",Dateneingabe!N48)","v":-550},null,null,{"$f":"CY4","v":"vorl. KDG ="},null,{"$f":"IF(CV4=\"\",\"\",DOLLAR(CV4,2))&IF(CV5<>\"\",\" - \",\"\")&IF(CV5=\"\",\"\",DOLLAR(-CV5,2)&IF(CV6<>\"\",\" - \",\"\")&IF(CV6=\"\",\"\",DOLLAR(-CV6,2))&\" = \"&DOLLAR(SUM(CV4:CV6),2))","v":"€ 23 038,50 - € 16 985,00 - € 550,00 = € 5 503,50"},null,null,null,null,null,"LANDWIRTSCHAFTLICHES EINKOMMEN - EK/Akh",null,null,{"$f":"DJ5/CD4","v":2.0007574851493044},null,null,null,null,null,null,{"$f":"DQ4","v":"GDB i.F.u.s.E. ="},null,{"$f":"IF(X20=\"\",\"\",DOLLAR(X20,2))&IF(BZ7<>\"\",\" + \",\"\")&IF(BZ7=\"\",\"\",DOLLAR(BZ7,2)&IF(CR10<>\"\",\" + \",\"\")&IF(CR10=\"\",\"\",DOLLAR(CR10,2))&\" = \"&DOLLAR(SUM(X20,BZ7,CR10),2))","v":"€ 7 145,50 + € 655,00 + € 6 670,00 = € 14 470,50"}]
[null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},{"$f":"IF(Dateneingabe!J13=\"\",\"\",Dateneingabe!J13)","v":443},{"$f":"IF(OR(D7=\"\",$C7=\"\"),\"\",D7*$C7)","v":443},{"$f":"IF(Dateneingabe!L13=\"\",\"\",Dateneingabe!L13)","v":28296},-28296,{"$f":"IF(Dateneingabe!N13=\"\",\"\",Dateneingabe!N13)","v":202.5},202.5,null,null,null,"Kalbinnen",null,"DB ges. = 1,00 * € 443,00 = € 443,00",null,null,null,null,null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},{"$f":"IF(Dateneingabe!J13=\"\",\"\",Dateneingabe!J13)","v":443},443,{"$f":"IF(Dateneingabe!L13=\"\",\"\",Dateneingabe!L13)","v":28296},-28296,{"$f":"IF(Dateneingabe!N13=\"\",\"\",Dateneingabe!N13)","v":202.5},202.5,null,null,null,"Kalbinnen",null,"DB ges. = 1,00 * € 443,00 = € 443,00",null,null,null,null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},null,null,{"$f":"IF(Dateneingabe!L13=\"\",\"\",Dateneingabe!L13)","v":28296},{"$f":"IF(OR(AQ7=\"\",$AN7=\"\"),\"\",-AQ7*$AN7)","v":-28296},null,null,null,null,null,"Kalbinnen",null,"Bedarf ges. = 1,00 * -28 296,00 = -28 296,00",null,null,null,null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},null,null,null,null,{"$f":"IF(Dateneingabe!N13=\"\",\"\",Dateneingabe!N13)","v":202.5},202.5,null,null,null,"Milchkälbermast",null,"AZ ges. = 2,00 * 49,00 = 98,00",null,null,null,null,"Summe Sonstige Erträge",null,null,{"$f":"SUM(BZ4:BZ6)","v":655},null,null,null,null,null,null,{"$f":"\"∑ sonst. Erträge = \"&IF(BZ4=\"\",\"\",BZ4)&IF(BZ5<>\"\",\" + \",\"\")&IF(BZ5=\"\",\"\",BZ5)&IF(BZ6<>\"\",\" + \",\"\")&IF(BZ6=\"\",\"\",BZ6)&\" = \"&DOLLAR(SUM(BZ4:BZ6),2)","v":"∑ sonst. Erträge = 655 = € 655,00"},null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!B54=\"\",\"\",Dateneingabe!B54)","v":"ÖPUL"},null,null,{"$f":"IF(Dateneingabe!G54=\"\",\"\",Dateneingabe!G54)","v":1280},"Vorläufige Kapitaldienstgrenze",null,null,{"$f":"SUM(CV4:CV6)","v":5503.5},null,null,null,null,null,null,null,null,null,null,"SOZIALEINKOMMEN",null,null,{"$f":"IF(Dateneingabe!G64=\"\",\"\",Dateneingabe!G64)","v":4560}]
[null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},{"$f":"IF(Dateneingabe!J15=\"\",\"\",Dateneingabe!J15)","v":331},662,{"$f":"IF(Dateneingabe!L15=\"\",\"\",Dateneingabe!L15)","v":""},"",{"$f":"IF(Dateneingabe!N15=\"\",\"\",Dateneingabe!N15)","v":49},98,null,null,null,"Milchkälbermast",null,"DB ges. = 2,00 * € 331,00 = € 662,00",null,null,null,null,null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},{"$f":"IF(Dateneingabe!J15=\"\",\"\",Dateneingabe!J15)","v":331},662,{"$f":"IF(Dateneingabe!L15=\"\",\"\",Dateneingabe!L15)","v":""},"",{"$f":"IF(Dateneingabe!N15=\"\",\"\",Dateneingabe!N15)","v":49},98,null,null,null,"Milchkälbermast",null,"DB ges. = 2,00 * € 331,00 = € 662,00",null,null,null,null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},null,null,{"$f":"IF(Dateneingabe!L15=\"\",\"\",Dateneingabe!L15)","v":""},null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},null,null,null,null,{"$f":"IF(Dateneingabe!N15=\"\",\"\",Dateneingabe!N15)","v":49},98,null,null,null,"Schweinemast",null,"AZ ges. = 15,00 * 49,00 = 735,00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!B56=\"\",\"\",Dateneingabe!B56)","v":""},null,null,{"$f":"IF(Dateneingabe!G56=\"\",\"\",Dateneingabe!G56)","v":""},"Afa für Gebäude und Maschinen, die während der Kreditlaufzeit nicht erneuert werden müssen.",null,null,{"$f":"IF(Dateneingabe!N64=\"\",\"\",Dateneingabe!N64)","v":620},null,null,"Kapitaldienstgrenze",null,null,null,"Excel: =SUMME(I29:I30)",null,null,null,"NEBEEINKOMMEN",null,null,{"$f":"IF(Dateneingabe!G66=\"\",\"\",Dateneingabe!G66)","v":13460},null,null,null,null,null,null,"Landwirtschaftliches Einkommen - Gesamt",null,null,null,"Excel: =SUMME(E37:E38)"]
[null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},{"$f":"IF(Dateneingabe!J17=\"\",\"\",Dateneingabe!J17)","v":17},255,{"$f":"IF(Dateneingabe!L17=\"\",\"\",Dateneingabe!L17)","v":""},"",{"$f":"IF(Dateneingabe!N17=\"\",\"\",Dateneingabe!N17)","v":49},735,null,null,null,"Schweinemast",null,"DB ges. = 15,00 * € 17,00 = € 255,00",null,null,null,null,null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},{"$f":"IF(Dateneingabe!J17=\"\",\"\",Dateneingabe!J17)","v":17},255,{"$f":"IF(Dateneingabe!L17=\"\",\"\",Dateneingabe!L17)","v":""},"",{"$f":"IF(Dateneingabe!N17=\"\",\"\",Dateneingabe!N17)","v":49},735,null,null,null,"Schweinemast",null,"DB ges. = 15,00 * € 17,00 = € 255,00",null,null,null,null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},null,null,{"$f":"IF(Dateneingabe!L17=\"\",\"\",Dateneingabe!L17)","v":""},null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},null,null,null,null,{"$f":"IF(Dateneingabe!N17=\"\",\"\",Dateneingabe!N17)","v":49},735,null,null,null,"Kartoffel Ab-Hof",null,"AZ ges. = 2,00 * 230,00 = 460,00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!B58=\"\",\"\",Dateneingabe!B58)","v":""},null,null,{"$f":"IF(Dateneingabe!G58=\"\",\"\",Dateneingabe!G58)","v":""},null,null,null,null,null,null,"KDG =",null,{"$f":"IF(CS7=\"\",\"\",CS7)&IF(CS8<>\"\",\" + \",\"\")&IF(CS8=\"\",\"\",CS8)","v":"Vorläufige Kapitaldienstgrenze + Afa für Gebäude und Maschinen, die während der Kreditlaufzeit nicht erneuert werden müssen."},null,null,null,null,null,"GESAMTEINKOMMEN",null,null,{"$f":"SUM(DJ5:DJ8)","v":23040.500757485148},null,null,null,null,null,null,"Lw EK Ges. =",null,{"$f":"IF(DG3=\"\",\"\",DG3)&IF(DG4<>\"\",\" - \",\"\")&IF(DG4=\"\",\"\",DG4)","v":"GDB einschl. Förd. und sonst. Erträge - Feste Kosten bei IST-Organisation"}]
[null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},{"$f":"IF(Dateneingabe!J19=\"\",\"\",Dateneingabe!J19)","v":1776},3552,{"$f":"IF(Dateneingabe!L19=\"\",\"\",Dateneingabe!L19)","v":""},"",{"$f":"IF(Dateneingabe!N19=\"\",\"\",Dateneingabe!N19)","v":230},460,null,null,null,"Kartoffel Ab-Hof",null,"DB ges. = 2,00 * € 1 776,00 = € 3 552,00",null,null,null,null,null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},{"$f":"IF(Dateneingabe!J19=\"\",\"\",Dateneingabe!J19)","v":1776},3552,{"$f":"IF(Dateneingabe!L19=\"\",\"\",Dateneingabe!L19)","v":""},"",{"$f":"IF(Dateneingabe!N19=\"\",\"\",Dateneingabe!N19)","v":230},460,null,null,null,"Kartoffel Ab-Hof",null,"DB ges. = 2,00 * € 1 776,00 = € 3 552,00",null,null,null,null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},null,null,{"$f":"IF(Dateneingabe!L19=\"\",\"\",Dateneingabe!L19)","v":""},null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},null,null,null,null,{"$f":"IF(Dateneingabe!N19=\"\",\"\",Dateneingabe!N19)","v":230},460,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,"SUMME FÖRDERUNGEN",null,null,{"$f":"SUM(CR4:CR7)","v":6670},"Kapitaldienstgrenze",null,null,{"$f":"SUM(CV7,CV8)","v":6123.5}]
[null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},{"$f":"IF(Dateneingabe!J21=\"\",\"\",Dateneingabe!J21)","v":""},"",{"$f":"IF(Dateneingabe!L21=\"\",\"\",Dateneingabe!L21)","v":""},"",{"$f":"IF(Dateneingabe!N21=\"\",\"\",Dateneingabe!N21)","v":""},"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},{"$f":"IF(Dateneingabe!J21=\"\",\"\",Dateneingabe!J21)","v":""},"",{"$f":"IF(Dateneingabe!L21=\"\",\"\",Dateneingabe!L21)","v":""},"",{"$f":"IF(Dateneingabe!N21=\"\",\"\",Dateneingabe!N21)","v":""},"",null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},null,null,{"$f":"IF(Dateneingabe!L21=\"\",\"\",Dateneingabe!L21)","v":""},null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N21=\"\",\"\",Dateneingabe!N21)","v":""},"",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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ9","v":"Lw EK Ges. ="},null,{"$f":"IF(DJ3=\"\",\"\",DOLLAR(DJ3,2))&IF(DJ4<>\"\",\" - \",\"\")&IF(DJ4=\"\",\"\",DOLLAR(-DJ4,2)&\" = \"&DOLLAR(SUM(DJ3,DJ4),2))","v":"€ 14 470,50 - € 9 452,00 = € 5 018,50"}]
[null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},{"$f":"IF(Dateneingabe!J23=\"\",\"\",Dateneingabe!J23)","v":""},"",{"$f":"IF(Dateneingabe!L23=\"\",\"\",Dateneingabe!L23)","v":""},"",{"$f":"IF(Dateneingabe!N23=\"\",\"\",Dateneingabe!N23)","v":""},"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},{"$f":"IF(Dateneingabe!J23=\"\",\"\",Dateneingabe!J23)","v":""},"",{"$f":"IF(Dateneingabe!L23=\"\",\"\",Dateneingabe!L23)","v":""},"",{"$f":"IF(Dateneingabe!N23=\"\",\"\",Dateneingabe!N23)","v":""},"",null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},null,null,{"$f":"IF(Dateneingabe!L23=\"\",\"\",Dateneingabe!L23)","v":""},null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N23=\"\",\"\",Dateneingabe!N23)","v":""},"",null,null,null,"Feldfutterbau",null,"AZ ges. = 0,50 * 62,40 = 31,20",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,{"$f":"CY9","v":"KDG ="},null,{"$f":"IF(CV7=\"\",\"\",DOLLAR(CV7,2))&IF(CV8<>\"\",\" + \",\"\")&IF(CV8=\"\",\"\",DOLLAR(CV8,2)&\" = \"&DOLLAR(SUM(CV7:CV8),2))","v":"€ 5 503,50 + € 620,00 = € 6 123,50"}]
[null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},{"$f":"IF(Dateneingabe!J25=\"\",\"\",Dateneingabe!J25)","v":1045},{"$f":"IF(OR(D13=\"\",$C13=\"\"),\"\",-D13*$C13)","v":-522.5},{"$f":"IF(Dateneingabe!L25=\"\",\"\",Dateneingabe!L25)","v":53100},{"$f":"IF(OR(F13=\"\",$C13=\"\"),\"\",F13*$C13)","v":26550},{"$f":"IF(Dateneingabe!N25=\"\",\"\",Dateneingabe!N25)","v":62.4},31.2,null,null,null,"Feldfutterbau",null,{"$f":"IF(OR(C13=\"\",D13=\"\"),\"\",\"VK ges. = \"&FIXED(C13,2)&\" * \"&DOLLAR(-D13,2)&\" = \"&DOLLAR(-C13*D13,2))","v":"VK ges. = 0,50 * -€ 1 045,00 = -€ 522,50"},null,null,null,null,null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},{"$f":"IF(Dateneingabe!J25=\"\",\"\",Dateneingabe!J25)","v":1045},{"$f":"IF(OR(W13=\"\",$V13=\"\"),\"\",-W13*$V13)","v":-522.5},{"$f":"IF(Dateneingabe!L25=\"\",\"\",Dateneingabe!L25)","v":53100},{"$f":"IF(OR(Y13=\"\",$V13=\"\"),\"\",Y13*$V13)","v":26550},{"$f":"IF(Dateneingabe!N25=\"\",\"\",Dateneingabe!N25)","v":62.4},31.2,null,null,null,"Feldfutterbau",null,{"$f":"IF(OR(V13=\"\",W13=\"\"),\"\",\"VK ges. = \"&FIXED(V13,2)&\" * \"&DOLLAR(-W13,2)&\" = \"&DOLLAR(-V13*W13,2))","v":"VK ges. = 0,50 * -€ 1 045,00 = -€ 522,50"},null,null,null,null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},null,null,{"$f":"IF(Dateneingabe!L25=\"\",\"\",Dateneingabe!L25)","v":53100},{"$f":"IF(OR(AQ13=\"\",$AN13=\"\"),\"\",AQ13*$AN13)","v":26550},null,null,null,null,null,"Feldfutterbau",null,{"$f":"IF(OR(AN13=\"\",AQ13=\"\"),\"\",\"Ertrag ges. = \"&FIXED(AN13,2)&\" * \"&FIXED(AQ13,2)&\" = \"&FIXED(AN13*AQ13,2))","v":"Ertrag ges. = 0,50 * 53 100,00 = 26 550,00"},null,null,null,null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},null,null,null,null,{"$f":"IF(Dateneingabe!N25=\"\",\"\",Dateneingabe!N25)","v":62.4},31.2,null,null,null,"mehrschn. Dauergl.",null,"AZ ges. = 3,00 * 52,20 = 156,60",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,null,null,null,null,null,null,null,null,"Landwirtschaftliches Einkommen/Akh",null,null,null,"Excel: =SUMME(E39/I23)"]
[null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},{"$f":"IF(Dateneingabe!J27=\"\",\"\",Dateneingabe!J27)","v":542},{"$f":"IF(OR(D14=\"\",$C14=\"\"),\"\",-D14*$C14)","v":-1626},{"$f":"IF(Dateneingabe!L27=\"\",\"\",Dateneingabe!L27)","v":33930},101790,{"$f":"IF(Dateneingabe!N27=\"\",\"\",Dateneingabe!N27)","v":52.2},156.60000000000002,null,null,null,"mehrschn. Dauergl.",null,{"$f":"IF(OR(C14=\"\",D14=\"\"),\"\",\"VK ges. = \"&FIXED(C14,2)&\" * \"&DOLLAR(-D14,2)&\" = \"&DOLLAR(-C14*D14,2))","v":"VK ges. = 3,00 * -€ 542,00 = -€ 1 626,00"},null,null,null,null,null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},{"$f":"IF(Dateneingabe!J27=\"\",\"\",Dateneingabe!J27)","v":542},-1626,{"$f":"IF(Dateneingabe!L27=\"\",\"\",Dateneingabe!L27)","v":33930},101790,{"$f":"IF(Dateneingabe!N27=\"\",\"\",Dateneingabe!N27)","v":52.2},156.60000000000002,null,null,null,"mehrschn. Dauergl.",null,"VK ges. = 3,00 * -€ 542,00 = -€ 1 626,00",null,null,null,null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},null,null,{"$f":"IF(Dateneingabe!L27=\"\",\"\",Dateneingabe!L27)","v":33930},101790,null,null,null,null,null,"mehrschn. Dauergl.",null,"Ertrag ges. = 3,00 * 33 930,00 = 101 790,00",null,null,null,null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},null,null,null,null,{"$f":"IF(Dateneingabe!N27=\"\",\"\",Dateneingabe!N27)","v":52.2},156.60000000000002,null,null,null,"einschn. Dauergl.",null,"AZ ges. = 2,00 * 45,00 = 90,00",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,"Summe Förderungen",null,null,null,"Excel: =SUMME(E29:E34)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lw EK/AKh =",null,{"$f":"MID(DQ9,1,10)& \"   :   Akh\"","v":"Lw EK Ges.   :   Akh"}]
[null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},{"$f":"IF(Dateneingabe!J29=\"\",\"\",Dateneingabe!J29)","v":542},-1084,{"$f":"IF(Dateneingabe!L29=\"\",\"\",Dateneingabe!L29)","v":18370},36740,{"$f":"IF(Dateneingabe!N29=\"\",\"\",Dateneingabe!N29)","v":45},90,null,null,null,"einschn. Dauergl.",null,"VK ges. = 2,00 * -€ 542,00 = -€ 1 084,00",null,null,null,null,null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},{"$f":"IF(Dateneingabe!J29=\"\",\"\",Dateneingabe!J29)","v":542},-1084,{"$f":"IF(Dateneingabe!L29=\"\",\"\",Dateneingabe!L29)","v":18370},36740,{"$f":"IF(Dateneingabe!N29=\"\",\"\",Dateneingabe!N29)","v":45},90,null,null,null,"einschn. Dauergl.",null,"VK ges. = 2,00 * -€ 542,00 = -€ 1 084,00",null,null,null,null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},null,null,{"$f":"IF(Dateneingabe!L29=\"\",\"\",Dateneingabe!L29)","v":18370},36740,null,null,null,null,null,"einschn. Dauergl.",null,"Ertrag ges. = 2,00 * 18 370,00 = 36 740,00",null,null,null,null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},null,null,null,null,{"$f":"IF(Dateneingabe!N29=\"\",\"\",Dateneingabe!N29)","v":45},90,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,"∑ Förd. =",null,{"$f":"IF(CO4=\"\",\"\",CO4)&IF(CO5<>\"\",\" + \",\"\")&IF(CO5=\"\",\"\",CO5)&IF(CO6<>\"\",\" + \",\"\")&IF(CO6=\"\",\"\",CO6)&IF(CO7<>\"\",\" + \",\"\")&IF(CO7=\"\",\"\",CO7)&IF(CO8<>\"\",\" + \",\"\")&IF(CO8=\"\",\"\",CO8)&IF(CO9<>\"\",\" + \",\"\")&IF(CO9=\"\",\"\",CO9)","v":"Ausgleichszulage + GAP Prämien Bodennutzung + Tierprämien + ÖPUL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ14","v":"Lw EK/AKh ="},null,{"$f":"IF(DJ5=\"\",\"\",DOLLAR(DJ5,2))&IF(CD4<>\"\",\"   :   \",\"\")&IF(CD4=\"\",\"\",FIXED(CD4,2)&\" AKh = \"&DOLLAR(DJ5/CD4,2))","v":"€ 5 018,50   :   2 508,30 AKh = € 2,00"}]
[null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},{"$f":"IF(Dateneingabe!J31=\"\",\"\",Dateneingabe!J31)","v":""},"",{"$f":"IF(Dateneingabe!L31=\"\",\"\",Dateneingabe!L31)","v":""},"",{"$f":"IF(Dateneingabe!N31=\"\",\"\",Dateneingabe!N31)","v":""},"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},{"$f":"IF(Dateneingabe!J31=\"\",\"\",Dateneingabe!J31)","v":""},"",{"$f":"IF(Dateneingabe!L31=\"\",\"\",Dateneingabe!L31)","v":""},"",{"$f":"IF(Dateneingabe!N31=\"\",\"\",Dateneingabe!N31)","v":""},"",null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},null,null,{"$f":"IF(Dateneingabe!L31=\"\",\"\",Dateneingabe!L31)","v":""},"",null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N31=\"\",\"\",Dateneingabe!N31)","v":""},"",null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},{"$f":"IF(Dateneingabe!J33=\"\",\"\",Dateneingabe!J33)","v":""},"",{"$f":"IF(Dateneingabe!L33=\"\",\"\",Dateneingabe!L33)","v":""},"",{"$f":"IF(Dateneingabe!N33=\"\",\"\",Dateneingabe!N33)","v":""},"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},{"$f":"IF(Dateneingabe!J33=\"\",\"\",Dateneingabe!J33)","v":""},"",{"$f":"IF(Dateneingabe!L33=\"\",\"\",Dateneingabe!L33)","v":""},"",{"$f":"IF(Dateneingabe!N33=\"\",\"\",Dateneingabe!N33)","v":""},"",null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},null,null,{"$f":"IF(Dateneingabe!L33=\"\",\"\",Dateneingabe!L33)","v":""},"",null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N33=\"\",\"\",Dateneingabe!N33)","v":""},"",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,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamteinkommen",null,null,null,"Excel: =SUMME(E39;E41:E42)"]
[null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},{"$f":"IF(Dateneingabe!J35=\"\",\"\",Dateneingabe!J35)","v":""},"",{"$f":"IF(Dateneingabe!L35=\"\",\"\",Dateneingabe!L35)","v":""},"",{"$f":"IF(Dateneingabe!N35=\"\",\"\",Dateneingabe!N35)","v":""},"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},{"$f":"IF(Dateneingabe!J35=\"\",\"\",Dateneingabe!J35)","v":""},"",{"$f":"IF(Dateneingabe!L35=\"\",\"\",Dateneingabe!L35)","v":""},"",{"$f":"IF(Dateneingabe!N35=\"\",\"\",Dateneingabe!N35)","v":""},"",null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},null,null,{"$f":"IF(Dateneingabe!L35=\"\",\"\",Dateneingabe!L35)","v":""},"",null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N35=\"\",\"\",Dateneingabe!N35)","v":""},"",null,null,null,"Sonstige Arbeiten",null,{"$f":"IF(AND(BF19=\"\",BK19=\"\"),\"\",IF(AND(BF19=\"\",BK19<>\"\"),\"AZ ges. = \"&FIXED(BK19,2),\"AZ ges. = \"&FIXED(BF19,2)&\" * \"&FIXED(BK19,2)&\" = \"&FIXED(BF19*BK19,2)))","v":"AZ ges. = 150,00"},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,{"$f":"CY15","v":"∑ Förd. ="},null,{"$f":"IF(CR4=\"\",\"\",DOLLAR(CR4,2))&IF(CR5<>\"\",\" + \",\"\")&IF(CR5=\"\",\"\",DOLLAR(CR5,2))&IF(CR6<>\"\",\" + \",\"\")&IF(CR6=\"\",\"\",DOLLAR(CR6,2))&IF(CR7<>\"\",\" + \",\"\")&IF(CR7=\"\",\"\",DOLLAR(CR7,2))&IF(CR8<>\"\",\" + \",\"\")&IF(CR8=\"\",\"\",DOLLAR(CR8,2))&IF(CR9<>\"\",\" + \",\"\")&IF(CR9=\"\",\"\",DOLLAR(CR9,2))&\" = \"&DOLLAR(SUM(CR4:CR9),2)","v":"€ 2 900,00 + € 1 540,00 + € 950,00 + € 1 280,00 = € 6 670,00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ges-EK =",null,{"$f":"IF(DG5=\"\",\"\",MID(DG5,1,30))&IF(DG7<>\"\",\" + \",\"\")&IF(DG7=\"\",\"\",DG7)&IF(DG8<>\"\",\" + \",\"\")&IF(DG8=\"\",\"\",DG8)","v":"LANDWIRTSCHAFTLICHES EINKOMMEN + SOZIALEINKOMMEN + NEBEEINKOMMEN"}]
[null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},{"$f":"IF(Dateneingabe!J37=\"\",\"\",Dateneingabe!J37)","v":""},"",{"$f":"IF(Dateneingabe!L37=\"\",\"\",Dateneingabe!L37)","v":""},"",{"$f":"IF(Dateneingabe!N37=\"\",\"\",Dateneingabe!N37)","v":150},{"$f":"IF(AND(H19=\"\",$C19=\"\"),\"\",IF(AND(H19<>\"\",$C19=\"\"),H19,H19*$C19))","v":150},null,null,null,"Sonstige Arbeiten",null,"",null,null,null,null,null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},{"$f":"IF(Dateneingabe!J37=\"\",\"\",Dateneingabe!J37)","v":""},"",{"$f":"IF(Dateneingabe!L37=\"\",\"\",Dateneingabe!L37)","v":""},"",{"$f":"IF(Dateneingabe!N37=\"\",\"\",Dateneingabe!N37)","v":150},{"$f":"IF(AND(AA19=\"\",$V19=\"\"),\"\",IF(AND(AA19<>\"\",$V19=\"\"),AA19,AA19*$V19))","v":150},null,null,null,"Sonstige Arbeiten",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},null,null,{"$f":"IF(Dateneingabe!L37=\"\",\"\",Dateneingabe!L37)","v":""},"",null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N37=\"\",\"\",Dateneingabe!N37)","v":150},{"$f":"IF(AND(BF19=\"\",$BK19=\"\"),\"\",IF(AND(BF19=\"\",$BK19<>\"\"),BK19,BF19*$BK19))","v":150}]
[null,"Gesamt DB",null," ",{"$f":"IF(AND(E6=\"\",E7=\"\",E8=\"\",E9=\"\",E10=\"\",E11=\"\",E12=\"\",E13=\"\",E14=\"\",E15=\"\",E16=\"\",E17=\"\",E18=\"\",E19=\"\",),\"\",SUM(E6:E19))","v":7145.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamt DB",null," ",{"$f":"IF(AND(X6=\"\",X7=\"\",X8=\"\",X9=\"\",X10=\"\",X11=\"\",X12=\"\",X13=\"\",X14=\"\",X15=\"\",X16=\"\",X17=\"\",X18=\"\",X19=\"\",),\"\",SUM(X6:X19))","v":7145.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamt DB",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesa\"Bedarf-\"Mt DB",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DQ18","v":"Ges-EK ="},null,{"$f":"IF(DJ5=\"\",\"\",DOLLAR(DJ5,2))&IF(DJ7<>\"\",\" + \",\"\")&IF(DJ7=\"\",\"\",DOLLAR(DJ7,2)&IF(DJ8<>\"\",\" + \",\"\")&IF(DJ8=\"\",\"\",DOLLAR(DJ8,2)&\" = \"&DOLLAR(SUM(DJ5,DJ7,DJ8),2)))","v":"€ 5 018,50 + € 4 560,00 + € 13 460,00 = € 23 038,50"}]
[null,null,null,null,null,null,null,null,null,null,null,"Summe DB"]
[null,null,null,null,null,null,null,null,null,null,null,"Summe DB = ",null,{"$f":"IF(B6=\"\",\"\",B6)&IF(B7<>\"\",\" + \",\"\")&IF(B7=\"\",\"\",B7)&IF(B8<>\"\",\" + \",\"\")&IF(B8=\"\",\"\",B8)&IF(B9<>\"\",\" + \",\"\")&IF(B9=\"\",\"\",B9)&IF(B10<>\"\",\" + \",\"\")&IF(B10=\"\",\"\",B10)&IF(B11<>\"\",\" + \",\"\")&IF(B11=\"\",\"\",B11)&IF(B12<>\"\",\" + \",\"\")&IF(B12=\"\",\"\",B12)","v":"DB Milchverarbeitung + DB Kalbinnen + DB Milchkälbermast + DB Schweinemast + DB Kartoffel Ab-Hof"}]
[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,"Summe DB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe Energiebedarf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe Arbeitszeit pro Jahr",null,null,null,"Excel: =SUMME(I6:I19)"]
[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,"Summe DB = ",null,{"$f":"IF(U6=\"\",\"\",U6)&IF(U7<>\"\",\" + \",\"\")&IF(U7=\"\",\"\",U7)&IF(U8<>\"\",\" + \",\"\")&IF(U8=\"\",\"\",U8)&IF(U9<>\"\",\" + \",\"\")&IF(U9=\"\",\"\",U9)&IF(U10<>\"\",\" + \",\"\")&IF(U10=\"\",\"\",U10)&IF(U11<>\"\",\" + \",\"\")&IF(U11=\"\",\"\",U11)&IF(U12<>\"\",\" + \",\"\")&IF(U12=\"\",\"\",U12)","v":"DB Milchverarbeitung + DB Kalbinnen + DB Milchkälbermast + DB Schweinemast + DB Kartoffel Ab-Hof"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∑ E-Bedarf = ",null,{"$f":"IF(AX6=\"\",\"\",\"Bedarf-\"&AX6)&IF(AX7<>\"\",\" + \",\"\")&IF(AX7=\"\",\"\",\"Bedarf-\"&AX7)&IF(AX8<>\"\",\" + \",\"\")&IF(AX8=\"\",\"\",\"Bedarf-\"&AX8)&IF(AX9<>\"\",\" + \",\"\")&IF(AX9=\"\",\"\",\"Bedarf-\"&AX9)&IF(AX10<>\"\",\" + \",\"\")&IF(AX10=\"\",\"\",\"Bedarf-\"&AX10)&IF(AX11<>\"\",\" + \",\"\")&IF(AX11=\"\",\"\",\"Bedarf-\"&AX11)&IF(AX12<>\"\",\" + \",\"\")&IF(AX12=\"\",\"\",\"Bedarf-\"&AX12)","v":"Bedarf-Milchverarbeitung + Bedarf-Kalbinnen"},null,null,null,null,null,null,null,null,null,"Energie- und Arbeitszeitbilanz",null,null,null,null,null,"∑ AZ = ",null,{"$f":"IF(BP5=\"\",\"\",\"AZ-\"&BP5)&IF(BP6<>\"\",\" + \",\"\")&IF(BP6=\"\",\"\",\"AZ-\"&BP6)&IF(BP7<>\"\",\" + \",\"\")&IF(BP7=\"\",\"\",\"AZ-\"&BP7)&IF(BP8<>\"\",\" + \",\"\")&IF(BP8=\"\",\"\",\"AZ-\"&BP8)&IF(BP9<>\"\",\" + \",\"\")&IF(BP9=\"\",\"\",\"AZ-\"&BP9)&IF(BP10<>\"\",\" + \",\"\")&IF(BP10=\"\",\"\",\"AZ-\"&BP10)&IF(BP11<>\"\",\" + \",\"\")&IF(BP11=\"\",\"\",\"AZ-\"&BP11)&IF(BP12<>\"\",\" + \",\"AZ-\"&BP12)&IF(BP12=\"\",\"\",\"AZ-\"&BP12)&IF(BP13<>\"\",\" + \",\"\")&IF(BP13=\"\",\"\",\"AZ-\"&BP13)&IF(BP14<>\"\",\" + \",\"\")&IF(BP14=\"\",\"\",\"AZ-\"&BP14)&IF(BP15<>\"\",\" + \",\"\")&IF(BP15=\"\",\"\",\"AZ-\"&BP15)&IF(BP16<>\"\",\" + \",\"\")&IF(BP16=\"\",\"\",\"AZ-\"&BP16)&IF(BP17<>\"\",\" + \",\"\")&IF(BP17=\"\",\"\",\"AZ-\"&BP17)&IF(BP18<>\"\",\" + \",\"\")&IF(BP18=\"\",\"\",\"AZ-\"&BP18)","v":"AZ-Milchverarbeitung + AZ-Kalbinnen + AZ-Milchkälbermast + AZ-Schweinemast + AZ-Kartoffel Ab-Hof + AZ-Feldfutterbau + AZ-mehrschn. Dauergl. + AZ-einschn. Dauergl. + AZ-Sonstige Arbeiten"}]
[null,null,null,null,null,null,null,null,null,null,null,"Summe DB =",null,{"$f":"IF(E6=\"\",\"\",DOLLAR(E6,2)&\" + \")&IF(E7=\"\",\"\",DOLLAR(E7,2)&\" + \")&IF(E8=\"\",\"\",DOLLAR(E8,2)&\" + \")&IF(E9=\"\",\"\",DOLLAR(E9,2)&\" + \")&IF(E10=\"\",\"\",DOLLAR(E10,2)&\" + \")&IF(E11=\"\",\"\",DOLLAR(E11,2)&\" + \")&IF(E12=\"\",\"\",DOLLAR(E12,2))&\" = \"&DOLLAR(SUM(E6:E12),2)","v":"€ 5 466,00 + € 443,00 + € 662,00 + € 255,00 + € 3 552,00 +  = € 10 378,00"},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,null,null,null,null,null,null,"Gesamt\nAkh",{"$f":"SUM(BL6:BL19)","v":2508.2999999999997}]
[]
[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,"Summe DB =",null,{"$f":"IF(X6=\"\",\"\",DOLLAR(X6,2)&\" + \")&IF(X7=\"\",\"\",DOLLAR(X7,2)&\" + \")&IF(X8=\"\",\"\",DOLLAR(X8,2)&\" + \")&IF(X9=\"\",\"\",DOLLAR(X9,2)&\" + \")&IF(X10=\"\",\"\",DOLLAR(X10,2)&\" + \")&IF(X11=\"\",\"\",DOLLAR(X11,2)&\" + \")&IF(X12=\"\",\"\",DOLLAR(X12,2))&\" = \"&DOLLAR(SUM(X6:X12),2)","v":"€ 5 466,00 + € 443,00 + € 662,00 + € 255,00 + € 3 552,00 +  = € 10 378,00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∑ E-Bedarf = ",null,{"$f":"IF(AR6=\"\",\"\",FIXED(-AR6,0)&\" + \")&IF(AR7=\"\",\"\",FIXED(-AR7,0)&\" + \")&IF(AR8=\"\",\"\",FIXED(-AR8,0)&\" + \")&IF(AR9=\"\",\"\",FIXED(-AR9,0)&\" + \")&IF(AR10=\"\",\"\",FIXED(-AR10,0)&\" + \")&IF(AR11=\"\",\"\",FIXED(-AR11,0)&\" + \")&IF(AR12=\"\",\"\",FIXED(-AR12,0))&\" = \"&FIXED(-SUM(AR6:AR12),0)","v":"60 105 + 28 296 +  = 88 401"}]
[null,null,null,null,null,null,null,null,null,null,null,"Summe VK"]
[null,null,null,null,null,null,null,null,null,null,null,"Summe VK = ",null,{"$f":"IF(B13=\"\",\"\",B13)&IF(B14<>\"\",\" + \",\"\")&IF(B14=\"\",\"\",B14)&IF(B15<>\"\",\" + \",\"\")&IF(B15=\"\",\"\",B15)&IF(B16<>\"\",\" + \",\"\")&IF(B16=\"\",\"\",B16)&IF(B17<>\"\",\" + \",\"\")&IF(B17=\"\",\"\",B17)&IF(B18<>\"\",\" + \",\"\")&IF(B18=\"\",\"\",B18)&IF(B19<>\"\",\" + \",\"\")&IF(B19=\"\",\"\",B19)","v":"VK Feldfutterbau + VK mehrschn. Dauergl. + VK einschn. Dauergl. + VK Sonstige Arbeiten"},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,null,null,null,null,null,null,null,null,null,null,"∑ AZ = ",null,{"$f":"IF(BL6=\"\",\"\",FIXED(BL6,1)&\" + \")&IF(BL7=\"\",\"\",FIXED(BL7,1)&\" + \")&IF(BL8=\"\",\"\",FIXED(BL8,1)&\" + \")&IF(BL9=\"\",\"\",FIXED(BL9,1)&\" + \")&IF(BL10=\"\",\"\",FIXED(BL10,1)&\" + \")&IF(BL11=\"\",\"\",FIXED(BL11,1)&\" + \")&IF(BL12=\"\",\"\",FIXED(BL12,1))&IF(BL13=\"\",\"\",FIXED(BL13,1)&\" + \")&IF(BL14=\"\",\"\",FIXED(BL14,1)&\" + \")&IF(BL15=\"\",\"\",FIXED(BL15,1)&\" + \")&IF(BL16=\"\",\"\",FIXED(BL16,1)&\" + \")&IF(BL17=\"\",\"\",FIXED(BL17,1)&\" + \")&IF(BL18=\"\",\"\",FIXED(BL18,1)&\" + \")&IF(BL19=\"\",\"\",FIXED(BL19,1))&\" = \"&FIXED(SUM(BL6:BL19),1)","v":"585,0 + 202,5 + 98,0 + 735,0 + 460,0 + 31,2 + 156,6 + 90,0 + 150,0 = 2 508,3"}]
[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,"Summe VK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe Energieertrag"]
[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,"Summe VK = ",null,{"$f":"IF(U13=\"\",\"\",U13)&IF(U14<>\"\",\" + \",\"\")&IF(U14=\"\",\"\",U14)&IF(U15<>\"\",\" + \",\"\")&IF(U15=\"\",\"\",U15)&IF(U16<>\"\",\" + \",\"\")&IF(U16=\"\",\"\",U16)&IF(U17<>\"\",\" + \",\"\")&IF(U17=\"\",\"\",U17)&IF(U18<>\"\",\" + \",\"\")&IF(U18=\"\",\"\",U18)&IF(U19<>\"\",\" + \",\"\")&IF(U19=\"\",\"\",U19)","v":"VK Feldfutterbau + VK mehrschn. Dauergl. + VK einschn. Dauergl. + VK Sonstige Arbeiten"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∑ E-Ergtrag = ",null,{"$f":"IF(AX13=\"\",\"\",\"Ertrag-\"&AX13)&IF(AX14<>\"\",\" + \",\"\")&IF(AX14=\"\",\"\",\"Ertrag-\"&AX14)&IF(AX15<>\"\",\" + \",\"\")&IF(AX15=\"\",\"\",\"Ertrag-\"&AX15)&IF(AX16<>\"\",\" + \",\"\")&IF(AX16=\"\",\"\",\"Ertrag-\"&AX16)&IF(AX17<>\"\",\" + \",\"\")&IF(AX17=\"\",\"\",\"Ertrag-\"&AX17)&IF(AX18<>\"\",\" + \",\"\")&IF(AX18=\"\",\"\",\"Ertrag-\"&AX18)&IF(AX19<>\"\",\" + \",\"\")&IF(AX19=\"\",\"\",\"Ertrag-\"&AX19)","v":"Ertrag-Feldfutterbau + Ertrag-mehrschn. Dauergl. + Ertrag-einschn. Dauergl."}]
[null,null,null,null,null,null,null,null,null,null,null,"Summe VK =",null,{"$f":"IF(E13=\"\",\"\",DOLLAR(-E13,2)&\" + \")&IF(E14=\"\",\"\",DOLLAR(-E14,2)&\" + \")&IF(E15=\"\",\"\",DOLLAR(-E15,2)&\" + \")&IF(E16=\"\",\"\",DOLLAR(-E16,2)&\" + \")&IF(E17=\"\",\"\",DOLLAR(-E17,2)&\" + \")&IF(E18=\"\",\"\",DOLLAR(-E18,2)&\" + \")&IF(E19=\"\",\"\",DOLLAR(-E19,2))&\" = \"&DOLLAR(-SUM(E13:E19),2)","v":"€ 522,50 + € 1 626,00 + € 1 084,00 +  = € 3 232,50"}]
[]
[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,"Summe VK =",null,{"$f":"IF(X13=\"\",\"\",DOLLAR(-X13,2)&\" + \")&IF(X14=\"\",\"\",DOLLAR(-X14,2)&\" + \")&IF(X15=\"\",\"\",DOLLAR(-X15,2)&\" + \")&IF(X16=\"\",\"\",DOLLAR(-X16,2)&\" + \")&IF(X17=\"\",\"\",DOLLAR(-X17,2)&\" + \")&IF(X18=\"\",\"\",DOLLAR(-X18,2)&\" + \")&IF(X19=\"\",\"\",DOLLAR(-X19,2))&\" = \"&DOLLAR(-SUM(X13:X19),2)","v":"€ 522,50 + € 1 626,00 + € 1 084,00 +  = € 3 232,50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"∑ E-Ergtrag = ",null,{"$f":"IF(AR13=\"\",\"\",FIXED(AR13,0)&\" + \")&IF(AR14=\"\",\"\",FIXED(AR14,0)&\" + \")&IF(AR15=\"\",\"\",FIXED(AR15,0)&\" + \")&IF(AR16=\"\",\"\",FIXED(AR16,0)&\" + \")&IF(AR17=\"\",\"\",FIXED(AR17,0)&\" + \")&IF(AR18=\"\",\"\",FIXED(AR18,0)&\" + \")&IF(AR19=\"\",\"\",FIXED(AR19,0))&\" = \"&FIXED(SUM(AR13:AR19),0)","v":"26 550 + 101 790 + 36 740 +  = 165 080"}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamt-DB",null,null,null,"Excel: =SUMME(E6:E19)",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,"Energie- und Arbeitszeitbilanz"]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamt-DB =",null,{"$f":"L21&\" - \"&L28","v":"Summe DB - Summe VK"},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," +/- Ges.\nEnergie",{"$f":"SUM(AR6:AR19)","v":76679}]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamt-DB =",null,{"$f":"DOLLAR(SUM(E6:E12),2)&\" - \"&DOLLAR(-SUM(E13:E19),2)&\" = \"&DOLLAR(SUM(E6:E19,2))","v":"€ 10 378,00 - € 3 232,50 = € 7 147,50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamt-DB",null,null,null,"Excel: =SUMME(E6:E19)",null,null,null,null,null,null,null,null,null,null,null,null,null,"+/- Gesamt-Energie",null,null,null,"Excel: =SUMME(G6:G19)"]
[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,"Gesamt-DB =",null,{"$f":"AE23&\" - \"&AE30","v":"Summe DB - Summe VK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ges-Energie =",null,{"$f":"AW23&\" - \"&AW30","v":"Summe Energiebedarf - Summe Energieertrag"}]
[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,"Gesamt-DB =",null,{"$f":"DOLLAR(SUM(X6:X12),2)&\" - \"&DOLLAR(-SUM(X13:X19),2)&\" = \"&DOLLAR(SUM(X6:X19,2))","v":"€ 10 378,00 - € 3 232,50 = € 7 147,50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ges-Energie =",null,{"$f":"FIXED(SUM(AR13:AR19),0)&\" - \"&FIXED(-SUM(AR6:AR11),0)&\" = \"&FIXED(SUM(AR6:AR19,0))","v":"165 080 - 88 401 = 76 679,00"}]
[null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) / Variable Kosten (-)",null,"Ertrag (+) / Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh",null,null,null,"Energieertrag / Energiebedarf gesamt"]
[null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh",null,null,null,"Bedarf ges. = Bedarf je Stk * Stk.",null,null,null,"… oder: Bedarf gesamt = Bedarf je ha * ha"]
[null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt",null,null,"Ertrag ges. = Ertrag je ha * ha"]
[null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},null,null,{"$f":"IF(Dateneingabe!L11=\"\",\"\",Dateneingabe!L11)","v":20035},{"$f":"IF(OR(F43=\"\",$C43=\"\"),\"\",-F43*$C43)","v":-60105},null,null,null,null,"Bsp.:",{"$f":"IF(OR(B43=\"\",F43=\"\"),\"\",MID(B43,4,20))","v":"Milchverarbeitung"},null,{"$f":"IF(OR(C43=\"\",F43=\"\"),\"\",\"Bedarf ges. = \"&FIXED(C43,2)&\" * \"&FIXED(-F43,2)&\" = \"&FIXED(-C43*F43,2))","v":"Bedarf ges. = 3,00 * -20 035,00 = -60 105,00"}]
[null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},null,null,{"$f":"IF(Dateneingabe!L13=\"\",\"\",Dateneingabe!L13)","v":28296},{"$f":"IF(OR(F44=\"\",$C44=\"\"),\"\",-F44*$C44)","v":-28296},null,null,null,null,null,"Kalbinnen",null,"Bedarf ges. = 1,00 * -28 296,00 = -28 296,00"]
[null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},null,null,{"$f":"IF(Dateneingabe!L15=\"\",\"\",Dateneingabe!L15)","v":""},null,null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},null,null,{"$f":"IF(Dateneingabe!L17=\"\",\"\",Dateneingabe!L17)","v":""},null,null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},null,null,{"$f":"IF(Dateneingabe!L19=\"\",\"\",Dateneingabe!L19)","v":""},null,null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},null,null,{"$f":"IF(Dateneingabe!L21=\"\",\"\",Dateneingabe!L21)","v":""},null,null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},null,null,{"$f":"IF(Dateneingabe!L23=\"\",\"\",Dateneingabe!L23)","v":""},null,null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},null,null,{"$f":"IF(Dateneingabe!L25=\"\",\"\",Dateneingabe!L25)","v":53100},{"$f":"IF(OR(F50=\"\",$C50=\"\"),\"\",F50*$C50)","v":26550},null,null,null,null,null,"Feldfutterbau",null,{"$f":"IF(OR(C50=\"\",F50=\"\"),\"\",\"Ertrag ges. = \"&FIXED(C50,2)&\" * \"&FIXED(F50,2)&\" = \"&FIXED(C50*F50,2))","v":"Ertrag ges. = 0,50 * 53 100,00 = 26 550,00"}]
[null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},null,null,{"$f":"IF(Dateneingabe!L27=\"\",\"\",Dateneingabe!L27)","v":33930},101790,null,null,null,null,null,"mehrschn. Dauergl.",null,"Ertrag ges. = 3,00 * 33 930,00 = 101 790,00"]
[null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},null,null,{"$f":"IF(Dateneingabe!L29=\"\",\"\",Dateneingabe!L29)","v":18370},36740,null,null,null,null,null,"einschn. Dauergl.",null,"Ertrag ges. = 2,00 * 18 370,00 = 36 740,00"]
[null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},null,null,{"$f":"IF(Dateneingabe!L31=\"\",\"\",Dateneingabe!L31)","v":""},"",null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},null,null,{"$f":"IF(Dateneingabe!L33=\"\",\"\",Dateneingabe!L33)","v":""},"",null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},null,null,{"$f":"IF(Dateneingabe!L35=\"\",\"\",Dateneingabe!L35)","v":""},"",null,null,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},null,null,{"$f":"IF(Dateneingabe!L37=\"\",\"\",Dateneingabe!L37)","v":""},"",null,null,null,null,null,"",null,""]
[null,"Gesamt DB"]
[null,null,null,null,null,null,null,null,null,null,null,"Summe Energiebedarf"]
[null,null,null,null,null,null,null,null,null,null,null,"∑ E-Bedarf = ",null,{"$f":"IF(M43=\"\",\"\",\"Bedarf-\"&M43)&IF(M44<>\"\",\" + \",\"\")&IF(M44=\"\",\"\",\"Bedarf-\"&M44)&IF(M45<>\"\",\" + \",\"\")&IF(M45=\"\",\"\",\"Bedarf-\"&M45)&IF(M46<>\"\",\" + \",\"\")&IF(M46=\"\",\"\",\"Bedarf-\"&M46)&IF(M47<>\"\",\" + \",\"\")&IF(M47=\"\",\"\",\"Bedarf-\"&M47)&IF(M48<>\"\",\" + \",\"\")&IF(M48=\"\",\"\",\"Bedarf-\"&M48)&IF(M49<>\"\",\" + \",\"\")&IF(M49=\"\",\"\",\"Bedarf-\"&M49)","v":"Bedarf-Milchverarbeitung + Bedarf-Kalbinnen"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"∑ E-Bedarf = ",null,{"$f":"IF(G43=\"\",\"\",FIXED(-G43,0)&\" + \")&IF(G44=\"\",\"\",FIXED(-G44,0)&\" + \")&IF(G45=\"\",\"\",FIXED(-G45,0)&\" + \")&IF(G46=\"\",\"\",FIXED(-G46,0)&\" + \")&IF(G47=\"\",\"\",FIXED(-G47,0)&\" + \")&IF(G48=\"\",\"\",FIXED(-G48,0)&\" + \")&IF(G49=\"\",\"\",FIXED(-G49,0))&\" = \"&FIXED(-SUM(G43:G49),0)","v":"60 105 + 28 296 +  = 88 401"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Summe Energieertrag"]
[null,null,null,null,null,null,null,null,null,null,null,"∑ E-Ergtrag = ",null,{"$f":"IF(M50=\"\",\"\",\"Ertrag-\"&M50)&IF(M51<>\"\",\" + \",\"\")&IF(M51=\"\",\"\",\"Ertrag-\"&M51)&IF(M52<>\"\",\" + \",\"\")&IF(M52=\"\",\"\",\"Ertrag-\"&M52)&IF(M53<>\"\",\" + \",\"\")&IF(M53=\"\",\"\",\"Ertrag-\"&M53)&IF(M54<>\"\",\" + \",\"\")&IF(M54=\"\",\"\",\"Ertrag-\"&M54)&IF(M55<>\"\",\" + \",\"\")&IF(M55=\"\",\"\",\"Ertrag-\"&M55)&IF(M56<>\"\",\" + \",\"\")&IF(M56=\"\",\"\",\"Ertrag-\"&M56)","v":"Ertrag-Feldfutterbau + Ertrag-mehrschn. Dauergl. + Ertrag-einschn. Dauergl."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"∑ E-Ergtrag = ",null,{"$f":"IF(G50=\"\",\"\",FIXED(G50,0)&\" + \")&IF(G51=\"\",\"\",FIXED(G51,0)&\" + \")&IF(G52=\"\",\"\",FIXED(G52,0)&\" + \")&IF(G53=\"\",\"\",FIXED(G53,0)&\" + \")&IF(G54=\"\",\"\",FIXED(G54,0)&\" + \")&IF(G55=\"\",\"\",FIXED(G55,0)&\" + \")&IF(G56=\"\",\"\",FIXED(G56,0))&\" = \"&FIXED(SUM(G50:G56),0)","v":"26 550 + 101 790 + 36 740 +  = 165 080"}]
[null,null,null,null,null,"Energie- und Arbeitszeitbilanz"]
[null,null,null,null,null," +/- Ges.\nEnergie",{"$f":"SUM(G43:G56)","v":76679}]
[null,null,null,null,null,null,null,null,null,null,null,"+/- Gesamt-Energie",null,null,null,"Excel: =SUMME(G6:G19)"]
[null,null,null,null,null,null,null,null,null,null,null,"Ges-Energie =",null,{"$f":"L58&\" - \"&L65","v":"Summe Energiebedarf - Summe Energieertrag"}]
[null,null,null,null,null,null,null,null,null,null,null,"Ges-Energie =",null,{"$f":"FIXED(SUM(G50:G56),0)&\" - \"&FIXED(-SUM(G43:G48),0)&\" = \"&FIXED(SUM(G43:G56,0))","v":"165 080 - 88 401 = 76 679,00"}]
[]
[]
[null,"Produktions-verfahren","Anzahl:\nha, Stk.","Deckungsbeitrag (+) / Variable Kosten (-)",null,"Ertrag (+) / Bedarf (-) an KStE oder MJ NEL",null,"Jahresarbeits-\nzeit in Akh",null,null,null,"Arbeitszeit gesamt"]
[null,"verfahren","ha;Stk","bzw. VK (-)",null,"(-) an KStE oder NEL",null,"bedarf in AKh",null,null,null,"AZ ges. = AZ je Stk * Stk.",null,null,null,"… oder: AZ ges. = AZ je ha * ha"]
[null,null,null,"je ha; Stk.","gesamt","je ha; Stk.","gesamt","je ha; Stk","gesamt",null,null,"Bsp.:",{"$f":"IF(B80=\"\",\"\",MID(B80,4,20))","v":"Milchverarbeitung"},null,{"$f":"IF(OR(C80=\"\",H80=\"\"),\"\",\"AZ ges. = \"&FIXED(C80,2)&\" * \"&FIXED(H80,2)&\" = \"&FIXED(C80*H80,2))","v":"AZ ges. = 3,00 * 195,00 = 585,00"}]
[null,{"$f":"IF(Dateneingabe!D11=\"\",\"\",Dateneingabe!B11&\" \"&Dateneingabe!D11)","v":"DB Milchverarbeitung"},{"$f":"IF(Dateneingabe!G11=\"\",\"\",Dateneingabe!G11)","v":3},null,null,null,null,{"$f":"IF(Dateneingabe!N11=\"\",\"\",Dateneingabe!N11)","v":195},{"$f":"IF(AND(H80=\"\",$C80=\"\"),\"\",IF(AND(H80<>\"\",$C80=\"\"),H80,H80*$C80))","v":585},null,null,null,"Kalbinnen",null,"AZ ges. = 1,00 * 202,50 = 202,50"]
[null,{"$f":"IF(Dateneingabe!D13=\"\",\"\",Dateneingabe!B13&\" \"&Dateneingabe!D13)","v":"DB Kalbinnen"},{"$f":"IF(Dateneingabe!G13=\"\",\"\",Dateneingabe!G13)","v":1},null,null,null,null,{"$f":"IF(Dateneingabe!N13=\"\",\"\",Dateneingabe!N13)","v":202.5},202.5,null,null,null,"Milchkälbermast",null,"AZ ges. = 2,00 * 49,00 = 98,00"]
[null,{"$f":"IF(Dateneingabe!D15=\"\",\"\",Dateneingabe!B15&\" \"&Dateneingabe!D15)","v":"DB Milchkälbermast"},{"$f":"IF(Dateneingabe!G15=\"\",\"\",Dateneingabe!G15)","v":2},null,null,null,null,{"$f":"IF(Dateneingabe!N15=\"\",\"\",Dateneingabe!N15)","v":49},98,null,null,null,"Schweinemast",null,"AZ ges. = 15,00 * 49,00 = 735,00"]
[null,{"$f":"IF(Dateneingabe!D17=\"\",\"\",Dateneingabe!B17&\" \"&Dateneingabe!D17)","v":"DB Schweinemast"},{"$f":"IF(Dateneingabe!G17=\"\",\"\",Dateneingabe!G17)","v":15},null,null,null,null,{"$f":"IF(Dateneingabe!N17=\"\",\"\",Dateneingabe!N17)","v":49},735,null,null,null,"Kartoffel Ab-Hof",null,"AZ ges. = 2,00 * 230,00 = 460,00"]
[null,{"$f":"IF(Dateneingabe!D19=\"\",\"\",Dateneingabe!B19&\" \"&Dateneingabe!D19)","v":"DB Kartoffel Ab-Hof"},{"$f":"IF(Dateneingabe!G19=\"\",\"\",Dateneingabe!G19)","v":2},null,null,null,null,{"$f":"IF(Dateneingabe!N19=\"\",\"\",Dateneingabe!N19)","v":230},460,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D21=\"\",\"\",Dateneingabe!B21&\" \"&Dateneingabe!D21)","v":""},{"$f":"IF(Dateneingabe!G21=\"\",\"\",Dateneingabe!G21)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N21=\"\",\"\",Dateneingabe!N21)","v":""},"",null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D23=\"\",\"\",Dateneingabe!B23&\" \"&Dateneingabe!D23)","v":""},{"$f":"IF(Dateneingabe!G23=\"\",\"\",Dateneingabe!G23)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N23=\"\",\"\",Dateneingabe!N23)","v":""},"",null,null,null,"Feldfutterbau",null,"AZ ges. = 0,50 * 62,40 = 31,20"]
[null,{"$f":"IF(Dateneingabe!D25=\"\",\"\",Dateneingabe!B25&\" \"&Dateneingabe!D25)","v":"VK Feldfutterbau"},{"$f":"IF(Dateneingabe!G25=\"\",\"\",Dateneingabe!G25)","v":0.5},null,null,null,null,{"$f":"IF(Dateneingabe!N25=\"\",\"\",Dateneingabe!N25)","v":62.4},31.2,null,null,null,"mehrschn. Dauergl.",null,"AZ ges. = 3,00 * 52,20 = 156,60"]
[null,{"$f":"IF(Dateneingabe!D27=\"\",\"\",Dateneingabe!B27&\" \"&Dateneingabe!D27)","v":"VK mehrschn. Dauergl."},{"$f":"IF(Dateneingabe!G27=\"\",\"\",Dateneingabe!G27)","v":3},null,null,null,null,{"$f":"IF(Dateneingabe!N27=\"\",\"\",Dateneingabe!N27)","v":52.2},156.60000000000002,null,null,null,"einschn. Dauergl.",null,"AZ ges. = 2,00 * 45,00 = 90,00"]
[null,{"$f":"IF(Dateneingabe!D29=\"\",\"\",Dateneingabe!B29&\" \"&Dateneingabe!D29)","v":"VK einschn. Dauergl."},{"$f":"IF(Dateneingabe!G29=\"\",\"\",Dateneingabe!G29)","v":2},null,null,null,null,{"$f":"IF(Dateneingabe!N29=\"\",\"\",Dateneingabe!N29)","v":45},90,null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D31=\"\",\"\",Dateneingabe!B31&\" \"&Dateneingabe!D31)","v":""},{"$f":"IF(Dateneingabe!G31=\"\",\"\",Dateneingabe!G31)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N31=\"\",\"\",Dateneingabe!N31)","v":""},"",null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D33=\"\",\"\",Dateneingabe!B33&\" \"&Dateneingabe!D33)","v":""},{"$f":"IF(Dateneingabe!G33=\"\",\"\",Dateneingabe!G33)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N33=\"\",\"\",Dateneingabe!N33)","v":""},"",null,null,null,"",null,""]
[null,{"$f":"IF(Dateneingabe!D35=\"\",\"\",Dateneingabe!B35&\" \"&Dateneingabe!D35)","v":""},{"$f":"IF(Dateneingabe!G35=\"\",\"\",Dateneingabe!G35)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N35=\"\",\"\",Dateneingabe!N35)","v":""},"",null,null,null,"Sonstige Arbeiten",null,""]
[null,{"$f":"IF(Dateneingabe!D37=\"\",\"\",Dateneingabe!B37&\" \"&Dateneingabe!D37)","v":"VK Sonstige Arbeiten"},{"$f":"IF(Dateneingabe!G37=\"\",\"\",Dateneingabe!G37)","v":""},null,null,null,null,{"$f":"IF(Dateneingabe!N37=\"\",\"\",Dateneingabe!N37)","v":150},{"$f":"IF(AND(H93=\"\",$C93=\"\"),\"\",IF(AND(H93<>\"\",$C93=\"\"),H93,H93*$C93))","v":150}]
[null,"Gesa\"Bedarf-\"Mt DB",null,null,null,null,null,null,null,null,null,"Summe Arbeitszeit pro Jahr",null,null,null,"Excel: =SUMME(I6:I19)"]
[null,null,null,null,null,null,null,null,null,null,null,"∑ AZ = ",null,{"$f":"IF(M79=\"\",\"\",\"AZ-\"&M79)&IF(M80<>\"\",\" + \",\"\")&IF(M80=\"\",\"\",\"AZ-\"&M80)&IF(M81<>\"\",\" + \",\"\")&IF(M81=\"\",\"\",\"AZ-\"&M81)&IF(M82<>\"\",\" + \",\"\")&IF(M82=\"\",\"\",\"AZ-\"&M82)&IF(M83<>\"\",\" + \",\"\")&IF(M83=\"\",\"\",\"AZ-\"&M83)&IF(M84<>\"\",\" + \",\"\")&IF(M84=\"\",\"\",\"AZ-\"&M84)&IF(M85<>\"\",\" + \",\"\")&IF(M85=\"\",\"\",\"AZ-\"&M85)&IF(M86<>\"\",\" + \",\"AZ-\"&M86)&IF(M86=\"\",\"\",\"AZ-\"&M86)&IF(M87<>\"\",\" + \",\"\")&IF(M87=\"\",\"\",\"AZ-\"&M87)&IF(M88<>\"\",\" + \",\"\")&IF(M88=\"\",\"\",\"AZ-\"&M88)&IF(M89<>\"\",\" + \",\"\")&IF(M89=\"\",\"\",\"AZ-\"&M89)&IF(M90<>\"\",\" + \",\"\")&IF(M90=\"\",\"\",\"AZ-\"&M90)&IF(M91<>\"\",\" + \",\"\")&IF(M91=\"\",\"\",\"AZ-\"&M91)&IF(M92<>\"\",\" + \",\"\")&IF(M92=\"\",\"\",\"AZ-\"&M92)","v":"AZ-Milchverarbeitung + AZ-Kalbinnen + AZ-Milchkälbermast + AZ-Schweinemast + AZ-Kartoffel Ab-Hof + AZ-Feldfutterbau + AZ-mehrschn. Dauergl. + AZ-einschn. Dauergl. + AZ-Sonstige Arbeiten"}]
[]
[]
[null,null,null,null,null,"Energie- und Arbeitszeitbilanz"]
[null,null,null,null,null,null,null,"Gesamt\nAkh",{"$f":"SUM(I80:I93)","v":2508.2999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,"∑ AZ = ",null,{"$f":"IF(I80=\"\",\"\",FIXED(I80,1)&\" + \")&IF(I81=\"\",\"\",FIXED(I81,1)&\" + \")&IF(I82=\"\",\"\",FIXED(I82,1)&\" + \")&IF(I83=\"\",\"\",FIXED(I83,1)&\" + \")&IF(I84=\"\",\"\",FIXED(I84,1)&\" + \")&IF(I85=\"\",\"\",FIXED(I85,1)&\" + \")&IF(I86=\"\",\"\",FIXED(I86,1))&IF(I87=\"\",\"\",FIXED(I87,1)&\" + \")&IF(I88=\"\",\"\",FIXED(I88,1)&\" + \")&IF(I89=\"\",\"\",FIXED(I89,1)&\" + \")&IF(I90=\"\",\"\",FIXED(I90,1)&\" + \")&IF(I91=\"\",\"\",FIXED(I91,1)&\" + \")&IF(I92=\"\",\"\",FIXED(I92,1)&\" + \")&IF(I93=\"\",\"\",FIXED(I93,1))&\" = \"&FIXED(SUM(I80:I93),1)","v":"585,0 + 202,5 + 98,0 + 735,0 + 460,0 + 31,2 + 156,6 + 90,0 + 150,0 = 2 508,3"}]
[]
[]
[]
[]
[]
[]
[null,"Sonstige betriebliche Erträge       +",null,null,null,"Energie- und Arbeitszeitbilanz"]
[null,{"$f":"IF(Dateneingabe!B41=\"\",\"\",Dateneingabe!B41)","v":"Maschinenringtätigkeit"},null,null,{"$f":"IF(Dateneingabe!G41=\"\",\"\",Dateneingabe!G41)","v":655}," +/- Ges.\nEnergie",{"$f":"G71","v":76679},"Gesamt\nAkh",{"$f":"I99","v":2508.2999999999997}]
[null,{"$f":"IF(Dateneingabe!B43=\"\",\"\",Dateneingabe!B43)","v":""},null,null,{"$f":"IF(Dateneingabe!G43=\"\",\"\",Dateneingabe!G43)","v":""},null,null,null,null,null,null,"Summe sonstiger Erträge",null,null,null,"Excel: =SUMME(E23:E25)"]
[null,{"$f":"IF(Dateneingabe!B45=\"\",\"\",Dateneingabe!B45)","v":""},null,null,{"$f":"IF(Dateneingabe!G45=\"\",\"\",Dateneingabe!G45)","v":""},null,null,null,null,null,null,{"$f":"\"∑ sonst. Erträge = \"&IF(B108=\"\",\"\",B108)&IF(B109<>\"\",\" + \",\"\")&IF(B109=\"\",\"\",B109)&IF(B110<>\"\",\" + \",\"\")&IF(B110=\"\",\"\",B110)","v":"∑ sonst. Erträge = Maschinenringtätigkeit"}]
[null,"Summe Sonstige Erträge",null,null,{"$f":"SUM(E108:E110)","v":655},null,null,null,null,null,null,{"$f":"\"∑ sonst. Erträge = \"&IF(E108=\"\",\"\",E108)&IF(E109<>\"\",\" + \",\"\")&IF(E109=\"\",\"\",E109)&IF(E110<>\"\",\" + \",\"\")&IF(E110=\"\",\"\",E110)&\" = \"&DOLLAR(SUM(E108:E110),2)","v":"∑ sonst. Erträge = 655 = € 655,00"}]
[]
[]
[]
[null,"Förderungen",null,"+",null,"Kapitaldienstgrenze",null,null,null,null,null,"Vorläufige Kapitaldienstgrenze",null,null,null,"Excel: =SUMME(I29:I30)"]
[null,{"$f":"IF(Dateneingabe!B48=\"\",\"\",Dateneingabe!B48)","v":"Ausgleichszulage"},null,null,{"$f":"IF(Dateneingabe!G48=\"\",\"\",Dateneingabe!G48)","v":2900},"Gesamteinkommen",null,null,{"$f":"IF(E130=\"\",\"noch leer\",E130)","v":23038.5},null,null,"vorl. KDG =",null,{"$f":"IF(F116=\"\",\"\",F116)&IF(F117<>\"\",\" - \",\"\")&IF(F117=\"\",\"\",F117)&IF(F118<>\"\",\" - \",\"\")&IF(F118=\"\",\"\",F118)","v":"Gesamteinkommen - Lebenshaltungskosten - Kapitaldienst für bestehende Kredite"}]
[null,{"$f":"IF(Dateneingabe!B50=\"\",\"\",Dateneingabe!B50)","v":"GAP Prämien Bodennutzung"},null,null,1540,"Lebenshaltungskosten",null,null,{"$f":"IF(Dateneingabe!N41=\"\",\"\",Dateneingabe!N41)","v":-16985}]
[null,{"$f":"IF(Dateneingabe!B52=\"\",\"\",Dateneingabe!B52)","v":"Tierprämien"},null,null,{"$f":"IF(Dateneingabe!G52=\"\",\"\",Dateneingabe!G52)","v":950},"Kapitaldienst für bestehende Kredite",null,null,{"$f":"IF(Dateneingabe!N48=\"\",\"\",Dateneingabe!N48)","v":-550},{"$f":"-#REF!","v":{"$error":"#REF!"}},null,{"$f":"L116","v":"vorl. KDG ="},null,{"$f":"IF(I116=\"\",\"\",DOLLAR(I116,2))&IF(I117<>\"\",\" - \",\"\")&IF(I117=\"\",\"\",DOLLAR(-I117,2)&IF(I118<>\"\",\" - \",\"\")&IF(I118=\"\",\"\",DOLLAR(-I118,2))&\" = \"&DOLLAR(SUM(I116:I118),2))","v":"€ 23 038,50 - € 16 985,00 - € 550,00 = € 5 503,50"}]
[null,{"$f":"IF(Dateneingabe!B54=\"\",\"\",Dateneingabe!B54)","v":"ÖPUL"},null,null,{"$f":"IF(Dateneingabe!G54=\"\",\"\",Dateneingabe!G54)","v":1280},"Vorläufige Kapitaldienstgrenze",null,null,{"$f":"SUM(I116:I118)","v":5503.5}]
[null,{"$f":"IF(Dateneingabe!B56=\"\",\"\",Dateneingabe!B56)","v":""},null,null,{"$f":"IF(Dateneingabe!G56=\"\",\"\",Dateneingabe!G56)","v":""},"Afa für Gebäude und Maschinen, die während der Kreditlaufzeit nicht erneuert werden müssen.",null,null,{"$f":"IF(Dateneingabe!N64=\"\",\"\",Dateneingabe!N64)","v":620},null,null,"Kapitaldienstgrenze",null,null,null,"Excel: =SUMME(I29:I30)"]
[null,{"$f":"IF(Dateneingabe!B58=\"\",\"\",Dateneingabe!B58)","v":""},null,null,{"$f":"IF(Dateneingabe!G58=\"\",\"\",Dateneingabe!G58)","v":""},null,null,null,null,null,null,"KDG =",null,{"$f":"IF(F119=\"\",\"\",F119)&IF(F120<>\"\",\" + \",\"\")&IF(F120=\"\",\"\",F120)","v":"Vorläufige Kapitaldienstgrenze + Afa für Gebäude und Maschinen, die während der Kreditlaufzeit nicht erneuert werden müssen."}]
[null,"SUMME FÖRDERUNGEN",null,null,{"$f":"SUM(E116:E119)","v":6670},"Kapitaldienstgrenze",null,null,{"$f":"SUM(I119,I120)","v":6123.5}]
[]
[null,"GDB einschl. Förd. und sonst. Erträge",null,null,{"$f":"SUM(E20,E111,E122)","v":14470.5},null,null,null,null,null,null,{"$f":"L121","v":"KDG ="},null,{"$f":"IF(I119=\"\",\"\",DOLLAR(I119,2))&IF(I120<>\"\",\" + \",\"\")&IF(I120=\"\",\"\",DOLLAR(I120,2)&\" = \"&DOLLAR(SUM(I119:I120),2))","v":"€ 5 503,50 + € 620,00 = € 6 123,50"}]
[null,"Feste Kosten bei IST-Organisation",null,null,{"$f":"IF(Dateneingabe!G61=\"\",\"\",Dateneingabe!G61)","v":-9452}]
[null,"LANDWIRTSCHAFTLICHES EINKOMMEN - Gesamt",null,null,{"$f":"SUM(E124:E125)","v":5018.5},null,null,null,null,null,null,"Summe Förderungen",null,null,null,"Excel: =SUMME(E29:E34)"]
[null,"LANDWIRTSCHAFTLICHES EINKOMMEN - EK/Akh",null,null,{"$f":"E126/I108","v":2.0007574851493044},null,null,null,null,null,null,"∑ Förd. =",null,{"$f":"IF(B116=\"\",\"\",B116)&IF(B117<>\"\",\" + \",\"\")&IF(B117=\"\",\"\",B117)&IF(B118<>\"\",\" + \",\"\")&IF(B118=\"\",\"\",B118)&IF(B119<>\"\",\" + \",\"\")&IF(B119=\"\",\"\",B119)&IF(B120<>\"\",\" + \",\"\")&IF(B120=\"\",\"\",B120)&IF(B121<>\"\",\" + \",\"\")&IF(B121=\"\",\"\",B121)","v":"Ausgleichszulage + GAP Prämien Bodennutzung + Tierprämien + ÖPUL"}]
[null,"SOZIALEINKOMMEN",null,null,{"$f":"IF(Dateneingabe!G64=\"\",\"\",Dateneingabe!G64)","v":4560}]
[null,"NEBEEINKOMMEN",null,null,{"$f":"IF(Dateneingabe!G66=\"\",\"\",Dateneingabe!G66)","v":13460}]
[null,"GESAMTEINKOMMEN",null,null,{"$f":"SUM(E126,E128:E129)","v":23038.5},null,null,null,null,null,null,{"$f":"L127","v":"∑ Förd. ="},null,{"$f":"IF(E116=\"\",\"\",DOLLAR(E116,2))&IF(E117<>\"\",\" + \",\"\")&IF(E117=\"\",\"\",DOLLAR(E117,2))&IF(E118<>\"\",\" + \",\"\")&IF(E118=\"\",\"\",DOLLAR(E118,2))&IF(E119<>\"\",\" + \",\"\")&IF(E119=\"\",\"\",DOLLAR(E119,2))&IF(E120<>\"\",\" + \",\"\")&IF(E120=\"\",\"\",DOLLAR(E120,2))&IF(E121<>\"\",\" + \",\"\")&IF(E121=\"\",\"\",DOLLAR(E121,2))&\" = \"&DOLLAR(SUM(E116:E121),2)","v":"€ 2 900,00 + € 1 540,00 + € 950,00 + € 1 280,00 = € 6 670,00"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"GDB einschl. Förd. Und sonst. Erträge",null,null,null,"Excel: =SUMME(E20;E26;E35)"]
[null,null,null,null,null,null,null,null,null,null,null,"GDB i.F.u.s.E. =",null,{"$f":"IF(B20=\"\",\"\",B20)&IF(B111<>\"\",\" + \",\"\")&IF(B111=\"\",\"\",B111)&IF(B122<>\"\",\" + \",\"\")&IF(B122=\"\",\"\",B122)","v":"Gesamt DB + Summe Sonstige Erträge + SUMME FÖRDERUNGEN"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L134","v":"GDB i.F.u.s.E. ="},null,{"$f":"IF(E20=\"\",\"\",DOLLAR(E20,2))&IF(E111<>\"\",\" + \",\"\")&IF(E111=\"\",\"\",DOLLAR(E111,2)&IF(E122<>\"\",\" + \",\"\")&IF(E122=\"\",\"\",DOLLAR(E122,2))&\" = \"&DOLLAR(SUM(E20,E111,E122),2))","v":"€ 7 145,50 + € 655,00 + € 6 670,00 = € 14 470,50"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Landwirtschaftliches Einkommen - Gesamt",null,null,null,"Excel: =SUMME(E37:E38)"]
[null,null,null,null,null,null,null,null,null,null,null,"Lw EK Ges. =",null,{"$f":"IF(B124=\"\",\"\",B124)&IF(B125<>\"\",\" - \",\"\")&IF(B125=\"\",\"\",B125)","v":"GDB einschl. Förd. und sonst. Erträge - Feste Kosten bei IST-Organisation"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L139","v":"Lw EK Ges. ="},null,{"$f":"IF(E124=\"\",\"\",DOLLAR(E124,2))&IF(E125<>\"\",\" - \",\"\")&IF(E125=\"\",\"\",DOLLAR(-E125,2)&\" = \"&DOLLAR(SUM(E124,E125),2))","v":"€ 14 470,50 - € 9 452,00 = € 5 018,50"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Landwirtschaftliches Einkommen/Akh",null,null,null,"Excel: =SUMME(E39/I23)"]
[null,null,null,null,null,null,null,null,null,null,null,"Lw EK/AKh =",null,{"$f":"MID(L139,1,10)& \"   :   Akh\"","v":"Lw EK Ges.   :   Akh"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L144","v":"Lw EK/AKh ="},null,{"$f":"IF(E126=\"\",\"\",DOLLAR(E126,2))&IF(I108<>\"\",\"   :   \",\"\")&IF(I108=\"\",\"\",FIXED(I108,2)&\" AKh = \"&DOLLAR(E126/I108,2))","v":"€ 5 018,50   :   2 508,30 AKh = € 2,00"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gesamteinkommen",null,null,null,"Excel: =SUMME(E39;E41:E42)"]
[null,null,null,null,null,null,null,null,null,null,null,"Ges-EK =",null,{"$f":"IF(B126=\"\",\"\",MID(B126,1,30))&IF(B128<>\"\",\" + \",\"\")&IF(B128=\"\",\"\",B128)&IF(B129<>\"\",\" + \",\"\")&IF(B129=\"\",\"\",B129)","v":"LANDWIRTSCHAFTLICHES EINKOMMEN + SOZIALEINKOMMEN + NEBEEINKOMMEN"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L148","v":"Ges-EK ="},null,{"$f":"IF(E126=\"\",\"\",DOLLAR(E126,2))&IF(E128<>\"\",\" + \",\"\")&IF(E128=\"\",\"\",DOLLAR(E128,2)&IF(E129<>\"\",\" + \",\"\")&IF(E129=\"\",\"\",DOLLAR(E129,2)&\" = \"&DOLLAR(SUM(E126,E128,E129),2)))","v":"€ 5 018,50 + € 4 560,00 + € 13 460,00 = € 23 038,50"}]