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

{"sheet":"Daten","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Auswahl","TS (%)","m³ Biogas/ t (oTS)","Methan (%)","m³ Biogas/ t (FM)","oTs (%)","Kosten","N %TS","P2O2 %TS","K2O %TS","Ertrag (to/ha)","Rohfaserhaltig","Verluste"]
["Maissilage (körnerarm)",32,560,52,{"$f":"(B2*F2*C2)/10000","v":170.24},95,35,1.34,0.53,1.59,60,"NEIN","JA"]
["Maissilage (körnerreich)",32,645,52,{"$f":"(B3*F3*C3)/10000","v":197.7312},95.8,35,1.34,0.53,1.59,60,"NEIN","NEIN"]
["Grassilage",25,600,53,135,90,30,2.7,0.81,3.13,20,"JA"]
["GPS",35,620,53,206.15,95,32,1.66,0.65,1.34,40,"JA"]
["Grünroggen",22,600,53,118.8,90,30,1.6,0.67,1.33,35,"JA"]
["CCM",65,708.4,52.6,451.25080000000003,98,100,1.68,0.68,0.6,15,"NEIN"]
["Weizen",87,720,52.8,614.49839999999995,98.1,130,2.4500000000000002,0.93,0.64,10,"NEIN"]
["Tritkale/Gerste",87,720,52.8,614.49839999999995,98.1,130,1.92,0.93,0.7,10,"NEIN"]
["Körnermais",87,720,52.8,614.49839999999995,98.1,130,1.65,0.93,0.57999999999999996,15,"NEIN"]
["Zuckerrübe",23,720,51,152.352,92,15,0.78,0.43,1.0900000000000001,80,"NEIN"]
["Kartoffel",22,737,51,150.7902,93,10,1.59,0.64,2.73,65,"NEIN"]
["Maisstroh",40,621,51.5,216.108,87,null,null,null,null,20,"JA"]
["Stroh (Weizen)",86,369.2,51.7,291.79352800000004,91.9,null,null,null,null,30,"JA"]
["Stroh (siliert)",30.5,582.79999999999995,55,151.26865399999997,85.1,null,null,null,null,40,"JA"]

{"sheet":"Siliermittel","index":1,"n_rows":24,"n_cols":21,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,20],[19,1,19,20],[21,1,21,20],[0,0,0,20],[15,6,15,16],[2,6,2,16],[2,0,2,1],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15]]}
["Siliermittelrechner "]
[]
["Name: ",null,null,null,null,null,"Prozent Verluste"]
[null,"Euro pro t FM","Ertrag in to/ha FM","Hektar","Euro pro ha FM","Gesamt- ertrag","< 1 m VS Winter ",null,"< 2 m VS Sommer ",null,"Schaufel entnahme ",null,"> 8 h locker im Silo",null,"> 12 h im Beschicker",null,"Verluste gesamt %","Verlust gesamt t (FM)","Verlust in €","Rohfaser- haltig","Verlust in ha"]
["Maissilage (körnerarm)",40,{"$f":"VLOOKUP(A5,Daten!$A$1:$L$15,11,0)","v":60},20,{"$f":"B5*C5","v":2400},{"$f":"C5*D5","v":1200},"NEIN",{"$f":"IF(G5=\"JA\",5,0)","v":0},"JA",{"$f":"IF(I5=\"JA\",5,0)","v":5},"JA",{"$f":"IF(K5=\"JA\",2,0)","v":2},"NEIN",{"$f":"IF(M5=\"JA\",2,0)","v":0},"NEIN",{"$f":"IF(O5=\"JA\",2,0)","v":0},{"$f":"(P5+N5+L5+J5+H5)/100","v":7.0000000000000007E-2},{"$f":"F5*Q5","v":84.000000000000014},{"$f":"R5*B5","v":3360.0000000000005},"NEIN",{"$f":"R5/C5","v":1.4000000000000001}]
["Maissilage (körnerreich)",45,{"$f":"VLOOKUP(A6,Daten!$A$1:$L$15,11,0)","v":60},150,{"$f":"B6*C6","v":2700},{"$f":"C6*D6","v":9000},"NEIN",{"$f":"IF(G6=\"JA\",5,0)","v":0},"JA",{"$f":"IF(I6=\"JA\",5,0)","v":5},"JA",{"$f":"IF(K6=\"JA\",2,0)","v":2},"NEIN",{"$f":"IF(M6=\"JA\",2,0)","v":0},"NEIN",{"$f":"IF(O6=\"JA\",2,0)","v":0},{"$f":"(P6+N6+L6+J6+H6)/100","v":7.0000000000000007E-2},{"$f":"F6*Q6","v":630.00000000000011},28350.000000000004,{"$f":"VLOOKUP(A6,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},10.500000000000002]
["Grassilage",50,{"$f":"VLOOKUP(A7,Daten!$A$1:$L$15,11,0)","v":20},50,1000,1000,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,70,3500,{"$f":"VLOOKUP(A7,Daten!$A$1:$L$15,12,FALSE)","v":"JA"},3.5]
["GPS",150,{"$f":"VLOOKUP(A8,Daten!$A$1:$L$15,11,0)","v":40},50,6000,2000,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,140,21000,{"$f":"VLOOKUP(A8,Daten!$A$1:$L$15,12,FALSE)","v":"JA"},3.5]
["Grünroggen",17,{"$f":"VLOOKUP(A9,Daten!$A$1:$L$15,11,0)","v":35},0,595,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A9,Daten!$A$1:$L$15,12,FALSE)","v":"JA"},0]
["CCM",18,{"$f":"VLOOKUP(A10,Daten!$A$1:$L$15,11,0)","v":15},0,270,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A10,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},0]
["Weizen",19,{"$f":"VLOOKUP(A11,Daten!$A$1:$L$15,11,0)","v":10},0,190,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A11,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},0]
["Tritkale/Gerste",20,{"$f":"VLOOKUP(A12,Daten!$A$1:$L$15,11,0)","v":10},0,200,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A12,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},0]
["Körnermais",21,{"$f":"VLOOKUP(A13,Daten!$A$1:$L$15,11,0)","v":15},0,315,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A13,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},0]
["Zuckerrübe",22,{"$f":"VLOOKUP(A14,Daten!$A$1:$L$15,11,0)","v":80},0,1760,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A14,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},0]
["Kartoffel",23,{"$f":"VLOOKUP(A15,Daten!$A$1:$L$15,11,0)","v":65},0,1495,0,"NEIN",0,"JA",5,"JA",2,"NEIN",0,"NEIN",0,7.0000000000000007E-2,0,0,{"$f":"VLOOKUP(A15,Daten!$A$1:$L$15,12,FALSE)","v":"NEIN"},0]
["Gesamt",null,{"$f":"SUM(C5:C11)","v":240},270,{"$f":"SUM(E5:E15)","v":16925},13200,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R5:R11)","v":924.00000000000011},{"$f":"SUM(S5:S15)","v":56210},null,{"$f":"SUM(U5:U11)","v":18.900000000000002}]
[]
[]
[]
[{"$f":"S16","v":56210},"Verlust in Euro"]
[]
[{"$f":"U16","v":18.900000000000002},"Verlust in Hektar bzw. Mehr Substrat einkaufen"]
[]
["Melde dich gleich bei unseren Biogasexperten !!!!!!!!!!!!!!!!!!!!!!!"]