{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Anleitung","Rechnung_Mast","Rechnung_Ferkel","Daten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Anleitung","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Rechnung_Mast","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[13,10,14,10],[15,10,16,10],[7,9,8,9],[9,9,10,9],[8,12,11,12],[7,10,8,10],[9,10,10,10],[11,10,12,10],[13,8,14,8],[11,9,12,9],[13,9,14,9],[15,9,16,9],[0,1,0,2],[1,1,1,2],[2,1,2,2],[11,8,12,8],[4,8,6,8],[0,3,1,5],[7,8,8,8],[9,8,10,8],[36,1,39,7],[33,1,33,7],[30,0,30,7],[15,12,16,12],[17,8,18,8],[17,9,18,9],[17,10,18,10],[31,1,31,7],[15,8,16,8],[32,1,32,7]]}
["Schweinemast GbR","← Betrieb",null,{"$f":"VLOOKUP(\"x\",$I$8:$K$19,2,0)","v":"850g tägl. Zunahme / 2,73 Durchgänge / 246kg Zuwachs"}]
["Feldweg 99","← Straße"]
["98765 Überall","← PLZ Ort"]
["Bitte Phasen mit \"x\" auswählen","x","x","x","x"]
[null,"Phase 1","Phase 2","Phase 3","Phase 4","Phase 5","Phase 6","Summe bzw. Ø:","A U S W A H L","MJ ME / kg Zuwachs: (nach Auswahl)",{"$f":"VLOOKUP(\"x\",$I$8:$K$19,3,0)","v":36.5}]
["Abschnitt von … kg",28,{"$f":"IF(AND(B7<>\"\",C4=\"x\"),B7,\"\")","v":40},{"$f":"IF(AND(C7<>\"\",D4=\"x\"),C7,\"\")","v":65},90,"","",{"$f":"MIN(B6:G6)","v":28},null,"\"Standardwert\"",{"$f":"H13/(H7-H6)","v":36.315555555555548},{"$f":"IF(K5<>\"\",K5/K6,1)","v":1.0050789377065232}]
["Abschnitt bis … kg",40,65,90,118,null,null,{"$f":"MAX(B7:G7)","v":118}]
["ME, MJ / kg Futter",13.2,13.2,13,13,null,null,{"$f":"H14/H15","v":13.067154755370078},null,"750g tägl. Zunahme / 2,47 Durchgänge / 222kg Zuwachs",38.299999999999997]
["Rohprotein, g / kg Futter",165,155,140,135,null,null,{"$f":"H18/0.16/H15*1000","v":144.09816976055637},null,null,null,null,"vgl. DLG, Band 199:\n \"Bilanzierung der Nährstoffaus-scheidungen landw. Nutztiere\",\n2. Auflage 2014"]
["Phosphor, g / kg Futter",4.4000000000000004,4.2,4,4,null,null,{"$f":"H21/H15","v":4.0865149031386849},"x","850g tägl. Zunahme / 2,73 Durchgänge / 246kg Zuwachs",36.5]
["Futterpreis, EUR / dt",26,25,24,24,null,null,{"$f":"H16/H15*100","v":24.432574515693425}]
[null,null,null,null,null,null,null,null,null,"950g tägl. Zunahme / 2,97 Durchgänge / 267kg Zuwachs",35]
["Energiebedarf (MJ ME) - Standard:",{"$f":"IF(ISERROR(VLOOKUP(B7,Bereich,2)),\"\",VLOOKUP(B7,Bereich,2)-VLOOKUP(B6,Bereich,2))","v":319.60000000000002},789,920,1239.7999999999997,"","",{"$f":"SUM(B13:G13)","v":3268.3999999999996}]
["Energiebedarf (MJ ME) - (n. Eingabe):",{"$f":"IF(B6<>\"\",B13*Faktor,\"\")","v":321.22322849100487},793.00728185044682,924.67262269000139,1246.0968669685471,"","",{"$f":"SUM(B14:G14)","v":3285},null,"Ebermast (50% Eber) / 2,73 Durchgänge / 246kg Zuwachs",34.6]
["Futtermenge (kg):",{"$f":"IF(B6<>\"\",B14/B8,\"\")","v":24.33509306750037},60.076309231094456,71.128663283846265,95.853605151426706,"","",{"$f":"SUM(B15:G15)","v":251.39367073386779}]
["Futterkosten (€):",{"$f":"IF(B6<>\"\",B11*B15/100,\"\")","v":6.3271241975500958},15.019077307773614,17.070879188123104,23.004865236342411,"","",{"$f":"SUM(B16:G16)","v":61.421945929789224},null,"Ebermast (50% Eber) / 2,97 Durchgänge / 267kg Zuwachs",33.4,null,"vgl. DLG-Merkblatt 418        (3. Auflage 10/2018)"]
["Futterkosten pro kg Zuwachs (€):",{"$f":"IF(B6<>\"\",B16/(B7-B6),\"\")","v":0.52726034979584135},0.6007630923109446,0.68283516752492412,0.82160232986937187,"","",{"$f":"H16/(H7-H6)","v":0.6824660658865469}]
["N-Aufnahme (kg):",{"$f":"IF(B6<>\"\",B9*0.16*B15/1000,\"\")","v":0.64244645698200986},1.4898924689311426,1.5932820575581566,2.0704378712708174,"","",{"$f":"SUM(B18:G18)","v":5.7960588547421263},null,"Ebermast (100% Eber) / 2,85 Durchg. / 256,5kg Zuwachs",32.799999999999997]
["N-Ausscheidung (kg):",{"$f":"IF(B6<>\"\",B18-(B7-B6)*25.6/1000,\"\")","v":0.33524645698200983},0.84989246893114256,0.95328205755815654,1.3536378712708173,"","",{"$f":"SUM(B19:G19)","v":3.4920588547421261}]
["N-Aussch./Mastplatz u. Jahr (kg):",null,null,null,null,null,null,{"$f":"H19*K20","v":9.5333206734460045},null,"Umtriebe:",2.73]
["P-Aufnahme (g):",{"$f":"IF(B6<>\"\",B10*B15,\"\")","v":107.07440949700164},252.32049877059671,284.51465313538506,383.41442060570682,"","",{"$f":"SUM(B21:G21)","v":1027.3239820086901}]
["P-Ausscheidung (g):",{"$f":"IF(B6<>\"\",B21-(B7-B6)*5.1,\"\")","v":45.874409497001643},124.82049877059673,157.01465313538506,240.61442060570684,"","",568.32398200869034]
["P2O5-Anfall (kg):",{"$f":"IF(B6<>\"\",B22*2.291/1000,\"\")","v":0.10509827215763076},0.28596376268343709,0.35972057033316718,0.55124763760767437,"","",1.3020302427819095]
["P2O5-Anfall/Mastplatz u. Jahr (kg):",null,null,null,null,null,null,{"$f":"H23*K20","v":3.5545425627946128}]
[]
["N-Ausscheidung pro kg Zuwachs (g):",{"$f":"IF(B6<>\"\",B19/(B7-B6)*1000,\"\")","v":27.937204748500822},33.995698757245698,38.131282302326262,48.344209688243474,"","",{"$f":"H19/(H7-H6)*1000","v":38.800653941579178}]
["P-Ausscheidung pro kg Zuwachs (g):",{"$f":"IF(B6<>\"\",B22/(B7-B6),\"\")","v":3.8228674580834703},4.9928199508238693,6.2805861254154021,8.59337216448953,"","",{"$f":"H22/(H7-H6)","v":6.31471091120767}]
[]
[]
[]
["Anforderungen an das Futter für eine (sehr) stark N-/P-reduzierte Fütterung (DLG, 2014 u. 2018):"]
["Rohprotein:","max. (144) 149 g/kg bei 750 g tägl. Zunahme"]
["\"           ","max. (144) 154 g/kg bei den übrigen Verfahren"]
["Phosphor:","max. (4,1) 4,3 g/kg bei allen Verfahren"]
[]
[]
["B E M E R K U N G E N :"]

{"sheet":"Rechnung_Ferkel","index":2,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,0,30,7],[31,1,31,7],[32,1,32,7],[35,1,38,7],[7,12,10,12],[13,8,14,8],[13,9,14,9],[13,10,14,10],[14,12,15,12],[15,8,16,8],[15,9,16,9],[15,10,16,10],[7,9,8,9],[7,10,8,10],[9,8,10,8],[9,9,10,9],[9,10,10,10],[11,8,12,8],[11,9,12,9],[11,10,12,10],[0,1,0,2],[0,3,1,5],[1,1,1,2],[2,1,2,2],[4,8,6,8],[7,8,8,8]]}
["Ferkelmast GbR","← Betrieb",null,{"$f":"VLOOKUP(\"x\",$I$8:$K$17,2,0)","v":"450g tägl. Zunahme / 7 Durchgänge / 140kg Zuwachs"}]
["Feldweg 99","← Straße"]
["98765 Überall","← PLZ Ort"]
["Bitte Phasen mit \"x\" auswählen","x","x"]
[null,"Phase 1","Phase 2","Phase 3","Phase 4","Phase 5","Phase 6","Summe bzw. Ø:","A U S W A H L","MJ ME / kg Zuwachs: (nach Auswahl)",{"$f":"VLOOKUP(\"x\",$I$8:$K$17,3,0)","v":23.8}]
["Abschnitt von … kg",8,{"$f":"IF(AND(B7<>\"\",C4=\"x\"),B7,\"\")","v":15},"",{"$f":"IF(AND(D7<>\"\",E4=\"x\"),D7,\"\")","v":""},{"$f":"IF(AND(E7<>\"\",F4=\"x\"),E7,\"\")","v":""},"",{"$f":"MIN(B6:G6)","v":8},null,"\"Standardwert\"",{"$f":"H13/(H7-H6)","v":22.65},{"$f":"IF(K5<>\"\",K5/K6,1)","v":1.0507726269315674}]
["Abschnitt bis … kg",15,28,null,null,null,null,{"$f":"MAX(B7:G7)","v":28}]
["ME, MJ / kg Futter",13.8,13.4,null,null,null,null,{"$f":"H14/H15","v":13.526886234893652},"x","450g tägl. Zunahme / 7 Durchgänge / 140kg Zuwachs",23.8,null,"vgl. DLG, Band 199:\n \"Bilanzierung der Nährstoffaus-scheidungen landw. Nutztiere\",\n2. Auflage 2014"]
["Rohprotein, g / kg Futter",175,170,null,null,null,null,{"$f":"H18/0.16/H15*1000","v":171.58607793617065}]
["Phosphor, g / kg Futter",5.0999999999999996,4.8,null,null,null,null,{"$f":"H21/H15","v":4.8951646761702374},null,"500g tägl. Zunahme / 8 Durchgänge / 160kg Zuwachs",23.1]
["Futterpreis, EUR / dt",40,40,null,null,null,null,{"$f":"H16/H15*100","v":40.000000000000007}]
[]
["Energiebedarf (MJ ME) - Standard:",{"$f":"IF(ISERROR(VLOOKUP(B7,Bereich,2)),\"\",VLOOKUP(B7,Bereich,2)-VLOOKUP(B6,Bereich,2))","v":146.6},306.39999999999998,"","","","",{"$f":"SUM(B13:G13)","v":453}]
["Energiebedarf (MJ ME) - (n. Eingabe):",{"$f":"IF(B6<>\"\",B13*Faktor,\"\")","v":154.04326710816778},321.95673289183219,"","","","",{"$f":"SUM(B14:G14)","v":476}]
["Futtermenge (kg):",{"$f":"IF(B6<>\"\",B14/B8,\"\")","v":11.16255558754839},24.026621857599416,"","","","",{"$f":"SUM(B15:G15)","v":35.189177445147806}]
["Futterkosten (€):",{"$f":"IF(B6<>\"\",B11*B15/100,\"\")","v":4.4650222350193562},9.6106487430397678,"","","","",{"$f":"SUM(B16:G16)","v":14.075670978059124}]
["Futterkosten pro kg Zuwachs (€):",{"$f":"IF(B6<>\"\",B16/(B7-B6),\"\")","v":0.63786031928847942},0.73928067254152063,"","","","",{"$f":"H16/(H7-H6)","v":0.70378354890295625}]
["N-Aufnahme (kg):",{"$f":"IF(B6<>\"\",B9*0.16*B15/1000,\"\")","v":0.31255155645135496},0.65352411452670411,"","","","",{"$f":"SUM(B18:G18)","v":0.96607567097805913}]
["N-Ausscheidung (kg):",{"$f":"IF(B6<>\"\",B18-(B7-B6)*25.6/1000,\"\")","v":0.13335155645135494},0.32072411452670413,"","","","",{"$f":"SUM(B19:G19)","v":0.45407567097805906}]
["N-Aussch./Mastplatz u. Jahr (kg):",null,null,null,null,null,null,{"$f":"H19*K20","v":1.2396265817701013},null,"Umtriebe:",2.73]
["P-Aufnahme (g):",{"$f":"IF(B6<>\"\",B10*B15,\"\")","v":56.929033496496785},115.32778491647719,"","","","",{"$f":"SUM(B21:G21)","v":172.25681841297398}]
["P-Ausscheidung (g):",{"$f":"IF(B6<>\"\",B21-(B7-B6)*5.1,\"\")","v":21.22903349649679},49.027784916477188,"","","","",70.256818412973985]
["P2O5-Anfall (kg):",{"$f":"IF(B6<>\"\",B22*2.291/1000,\"\")","v":4.863571574047415E-2},0.11232265524364923,"","","","",0.16095837098412338]
["P2O5-Anfall/Mastplatz u. Jahr (kg):",null,null,null,null,null,null,{"$f":"H23*K20","v":0.43941635278665686}]
[]
["N-Ausscheidung pro kg Zuwachs (g):",{"$f":"IF(B6<>\"\",B19/(B7-B6)*1000,\"\")","v":19.050222350193565},24.671085732823393,"","","","",{"$f":"H19/(H7-H6)*1000","v":22.703783548902951}]
["P-Ausscheidung pro kg Zuwachs (g):",{"$f":"IF(B6<>\"\",B22/(B7-B6),\"\")","v":3.0327190709281129},3.7713680704982453,"","","","",{"$f":"H22/(H7-H6)","v":3.5128409206486992}]
[]
[]
[]
["Anforderungen an das Futter für eine (sehr) stark N-/P-reduzierte Fütterung (DLG, 2014 u. 2018):"]
["Rohprotein:","max. (172) 178 g/kg bei beiden Verfahren"]
["Phosphor:","max. (4,9) 5,1 g/kg bei beiden Verfahren"]
[]
[]
["B E M E R K U N G E N :"]

{"sheet":"Daten","index":3,"n_rows":121,"n_cols":9,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[null,5,null,5,0,null,null,5,0]
["Energiebedarf, MJ ME in Abschnitt",5,"-",10,99,{"$f":"(E2-E1)/5","v":19.8},null,6,19.8]
["Energiebedarf, MJ ME in Abschnitt",5,"-",15,206,{"$f":"(E3-E2)/5","v":21.4},null,7,39.6]
["Energiebedarf, MJ ME in Abschnitt",5,"-",20,318,22.4,null,8,59.400000000000006]
["Energiebedarf, MJ ME in Abschnitt",5,"-",25,438,24,null,9,79.2]
["Energiebedarf, MJ ME in Abschnitt",5,"-",30,562,24.8,null,10,99]
["Energiebedarf, MJ ME in Abschnitt",5,"-",35,694,26.4,null,11,120.4]
["Energiebedarf, MJ ME in Abschnitt",5,"-",40,832,27.6,null,12,141.80000000000001]
["Energiebedarf, MJ ME in Abschnitt",5,"-",45,978,29.2,null,13,163.20000000000002]
["Energiebedarf, MJ ME in Abschnitt",5,"-",50,1130,30.4,null,14,184.60000000000002]
["Energiebedarf, MJ ME in Abschnitt",5,"-",55,1288,31.6,null,15,206]
["Energiebedarf, MJ ME in Abschnitt",5,"-",60,1452,32.799999999999997,null,16,228.4]
["Energiebedarf, MJ ME in Abschnitt",5,"-",65,1621,33.799999999999997,null,17,250.8]
["Energiebedarf, MJ ME in Abschnitt",5,"-",70,1794,34.6,null,18,273.2]
["Energiebedarf, MJ ME in Abschnitt",5,"-",75,1972,35.6,null,19,295.59999999999997]
["Energiebedarf, MJ ME in Abschnitt",5,"-",80,2157,37,null,20,318]
["Energiebedarf, MJ ME in Abschnitt",5,"-",85,2347,38,null,21,342]
["Energiebedarf, MJ ME in Abschnitt",5,"-",90,2541,38.799999999999997,null,22,366]
["Energiebedarf, MJ ME in Abschnitt",5,"-",95,2741,40,null,23,390]
["Energiebedarf, MJ ME in Abschnitt",5,"-",100,2949,41.6,null,24,414]
["Energiebedarf, MJ ME in Abschnitt",5,"-",105,3167,43.6,null,25,438]
["Energiebedarf, MJ ME in Abschnitt",5,"-",110,3395,45.6,null,26,462.8]
["Energiebedarf, MJ ME in Abschnitt",5,"-",115,3632,47.4,null,27,487.6]
["Energiebedarf, MJ ME in Abschnitt",5,"-",120,3880,49.6,null,28,512.4]
[null,null,null,null,null,null,null,29,537.19999999999993]
[null,null,null,null,null,null,null,30,562]
[null,null,null,null,null,null,null,31,588.4]
[null,null,null,null,null,null,null,32,614.79999999999995]
[null,null,null,null,null,null,null,33,641.19999999999993]
[null,null,null,null,null,null,null,34,667.59999999999991]
[null,null,null,null,null,null,null,35,694]
[null,null,null,null,null,null,null,36,721.6]
[null,null,null,null,null,null,null,37,749.2]
[null,null,null,null,null,null,null,38,776.80000000000007]
[null,null,null,null,null,null,null,39,804.40000000000009]
[null,null,null,null,null,null,null,40,832]
[null,null,null,null,null,null,null,41,861.2]
[null,null,null,null,null,null,null,42,890.40000000000009]
[null,null,null,null,null,null,null,43,919.60000000000014]
[null,null,null,null,null,null,null,44,948.80000000000018]
[null,null,null,null,null,null,null,45,978]
[null,null,null,null,null,null,null,46,1008.4]
[null,null,null,null,null,null,null,47,1038.8]
[null,null,null,null,null,null,null,48,1069.2]
[null,null,null,null,null,null,null,49,1099.6000000000001]
[null,null,null,null,null,null,null,50,1130]
[null,null,null,null,null,null,null,51,1161.5999999999999]
[null,null,null,null,null,null,null,52,1193.1999999999998]
[null,null,null,null,null,null,null,53,1224.7999999999997]
[null,null,null,null,null,null,null,54,1256.3999999999996]
[null,null,null,null,null,null,null,55,1288]
[null,null,null,null,null,null,null,56,1320.8]
[null,null,null,null,null,null,null,57,1353.6]
[null,null,null,null,null,null,null,58,1386.3999999999999]
[null,null,null,null,null,null,null,59,1419.1999999999998]
[null,null,null,null,null,null,null,60,1452]
[null,null,null,null,null,null,null,61,1485.8]
[null,null,null,null,null,null,null,62,1519.6]
[null,null,null,null,null,null,null,63,1553.3999999999999]
[null,null,null,null,null,null,null,64,1587.1999999999998]
[null,null,null,null,null,null,null,65,1621]
[null,null,null,null,null,null,null,66,1655.6]
[null,null,null,null,null,null,null,67,1690.1999999999998]
[null,null,null,null,null,null,null,68,1724.7999999999997]
[null,null,null,null,null,null,null,69,1759.3999999999996]
[null,null,null,null,null,null,null,70,1794]
[null,null,null,null,null,null,null,71,1829.6]
[null,null,null,null,null,null,null,72,1865.1999999999998]
[null,null,null,null,null,null,null,73,1900.7999999999997]
[null,null,null,null,null,null,null,74,1936.3999999999996]
[null,null,null,null,null,null,null,75,1972]
[null,null,null,null,null,null,null,76,2009]
[null,null,null,null,null,null,null,77,2046]
[null,null,null,null,null,null,null,78,2083]
[null,null,null,null,null,null,null,79,2120]
[null,null,null,null,null,null,null,80,2157]
[null,null,null,null,null,null,null,81,2195]
[null,null,null,null,null,null,null,82,2233]
[null,null,null,null,null,null,null,83,2271]
[null,null,null,null,null,null,null,84,2309]
[null,null,null,null,null,null,null,85,2347]
[null,null,null,null,null,null,null,86,2385.8000000000002]
[null,null,null,null,null,null,null,87,2424.6000000000004]
[null,null,null,null,null,null,null,88,2463.4000000000005]
[null,null,null,null,null,null,null,89,2502.2000000000007]
[null,null,null,null,null,null,null,90,2541]
[null,null,null,null,null,null,null,91,2581]
[null,null,null,null,null,null,null,92,2621]
[null,null,null,null,null,null,null,93,2661]
[null,null,null,null,null,null,null,94,2701]
[null,null,null,null,null,null,null,95,2741]
[null,null,null,null,null,null,null,96,2782.6]
[null,null,null,null,null,null,null,97,2824.2]
[null,null,null,null,null,null,null,98,2865.7999999999997]
[null,null,null,null,null,null,null,99,2907.3999999999996]
[null,null,null,null,null,null,null,100,2949]
[null,null,null,null,null,null,null,101,2992.6]
[null,null,null,null,null,null,null,102,3036.2]
[null,null,null,null,null,null,null,103,3079.7999999999997]
[null,null,null,null,null,null,null,104,3123.3999999999996]
[null,null,null,null,null,null,null,105,3167]
[null,null,null,null,null,null,null,106,3212.6]
[null,null,null,null,null,null,null,107,3258.2]
[null,null,null,null,null,null,null,108,3303.7999999999997]
[null,null,null,null,null,null,null,109,3349.3999999999996]
[null,null,null,null,null,null,null,110,3395]
[null,null,null,null,null,null,null,111,3442.4]
[null,null,null,null,null,null,null,112,3489.8]
[null,null,null,null,null,null,null,113,3537.2000000000003]
[null,null,null,null,null,null,null,114,3584.6000000000004]
[null,null,null,null,null,null,null,115,3632]
[null,null,null,null,null,null,null,116,3681.6]
[null,null,null,null,null,null,null,117,3731.2]
[null,null,null,null,null,null,null,118,3780.7999999999997]
[null,null,null,null,null,null,null,119,3830.3999999999996]
[null,null,null,null,null,null,null,120,3879.9999999999995]
[null,null,null,null,null,null,null,121,3929.9999999999995]
[null,null,null,null,null,null,null,122,3979.9999999999995]
[null,null,null,null,null,null,null,123,4029.9999999999995]
[null,null,null,null,null,null,null,124,4079.9999999999995]
[null,null,null,null,null,null,null,125,4130]