{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Invoere","Berekeninge","Marges"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Invoere","index":0,"n_rows":64,"n_cols":5,"rows_kept":64,"merged":[[1,1,2,2],[4,1,4,2],[4,4,9,7],[13,1,13,2],[14,1,14,2],[20,1,20,2],[26,1,26,2],[38,1,38,2],[39,1,39,2],[52,1,52,2],[53,1,53,2],[58,1,58,2],[59,1,59,2],[59,4,64,7],[63,1,64,2]]}
[]
[null,"Invoere"]
[]
[]
[null,"Fisiese Gegewens",null,null,"Verander asseblief die waardes na gelang van u boerdery omstandighede"]
[null,"Produktiewe Koeie (Aantal)",100]
[null,"Persentasie Bulle",{"v":0.03,"d":"3%"}]
[null,"Vervangings Persentasie",{"v":0.15,"d":"15%"}]
[null,"Speen Persentasie",{"v":0.7,"d":"70%"}]
[null,"Speen Gewig (Kg)",200]
[null,"Speenkalf Prys (R/kg)",{"v":17,"d":"R 17.00"}]
[null,"Uitskot Koeie Karkas Gewig (Kg)",250]
[null,"Graad C Karkas Pys (R/kg)",{"v":23.5,"d":"R 23.50"}]
[]
[null,"Lek en Voer Gegewens"]
[null,"Winterlek"]
[null,"Aankoop Grootte (bv. 50 kg)",50]
[null,"Aankoop Prys (R)",{"v":143,"d":"R 143"}]
[null,"Inname (kg/dier/dag)",0.5]
[null,"Tydperk (Dae)",180]
[]
[null,"Somerlek"]
[null,"Aankoop Grootte (bv. 50 kg)",25]
[null,"Aankoop Prys (R)",{"v":106,"d":"R 106"}]
[null,"Inname (kg/dier/dag)",0.15]
[null,"Tydperk (Dae)",180]
[]
[null,"Kruipvoer"]
[null,"Bestandeel 1 Hoeveelheid (kg)",700]
[null,"Bestandeel 1 Prys (R/50kg)",{"v":88,"d":"R 88"}]
[null,"Bestandeel 2 Hoeveelheid (kg)",200]
[null,"Bestandeel 2 Prys (R/50kg)",{"v":181,"d":"R 181"}]
[null,"Bestandeel 3 Hoeveelheid (kg)",100]
[null,"Bestandeel 3 Prys (R/50kg)",{"v":253,"d":"R 253"}]
[null,"Bestandeel 4 Hoeveelheid (kg)"]
[null,"Bestandeel 4 Prys (R/50kg)"]
[null,"Inname (kg/dier/dag)",2.8]
[null,"Tydperk (Dae)",120]
[]
[null,"Doseer en Ent Gegewens"]
[null,"Medikament 1 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 1 Prys (R/bottel)",{"v":1972,"d":"R 1,972"}]
[null,"Medikament 2 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 2 Prys (R/bottel)",{"v":825,"d":"R 825"}]
[null,"Medikament 3 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 3 Prys (R/bottel)",{"v":960,"d":"R 960"}]
[null,"Medikament 4 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 4 Prys (R/bottel)",{"v":138,"d":"R 138"}]
[null,"Medikament 5 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 5 Prys (R/bottel)",{"v":802,"d":"R 802"}]
[null,"Medikament 6 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 6 Prys (R/bottel)",{"v":445,"d":"R 445"}]
[]
[null,"Ander Kostes en Inkomstes"]
[null,"Arbeid Hoeveelheid (Aantal Werkers)",2]
[null,"Arbeid Prys (R/Arbeider/Maand)",{"v":1376,"d":"R 1,376"}]
[null,"Oorhoofse Koste (% van Tot. Veranderlike Kostes)",{"v":0.1,"d":"10%"}]
[null,"Ander Inkomste",{"v":0,"d":"R 0.00"}]
[]
[null,"Vaste Koste",null,null,"\"Click\" op Marges om u na die Koste en Marge berekenings te neem"]
[null,"Huur/Verband Koste (R/ha/jaar)",{"v":300,"d":"R 300"}]
[null,"Drakrag (ha/GVE)",4]
[]
[null,"Marges"]

{"sheet":"Berekeninge","index":1,"n_rows":48,"n_cols":18,"rows_kept":48,"hidden":true,"merged":[[0,0,0,3],[2,0,2,3],[2,6,2,9],[2,12,2,14],[12,6,12,9],[12,12,12,14],[17,0,17,3],[21,6,21,9],[21,12,21,14],[36,6,36,9]]}
["Produksie kostes - Bees"]
[]
["Fisiese Gegewens",{"$nulls":5},"Doseer en Ent Kostes",{"$nulls":8},"Koste/Kg","Marge/kg","Verandering"]
["Aantal Beeste",null,{"$f":"C6+C7+C8+C9","v":133},{"$nulls":4},"Dosisse","Per bees","Prys per bottel",{"$nulls":3},"Basis","Nuwe",{"v":7.52,"d":"R 7.52"},{"v":9.48,"d":"R 9.48"},0]
[{"$nulls":6},"Dectovax",{"$f":"Invoere!C41","v":100},{"$f":"J5/H5","v":{"v":19.72,"d":"R 19.72"}},{"$f":"Invoere!C42","v":{"v":1972,"d":"R 1,972"}},null,null,"Koeie",100,200,{"v":5.87,"d":"R 5.87"},{"v":11.13,"d":"R 11.13"},{"$f":"$P$4-P5","v":{"v":1.6499999999999995,"d":"R 1.65"}}]
["Produktiewe Koeie",null,{"$f":"Invoere!C6","v":100},{"$nulls":3},"OneShot Ultra 7",{"$f":"Invoere!C43","v":100},{"$f":"J6/H6","v":{"v":8.25,"d":"R 8.25"}},{"$f":"Invoere!C44","v":{"v":825,"d":"R 825"}},null,null,"Speen %",70,80,{"v":7.11,"d":"R 7.11"},{"v":9.89,"d":"R 9.89"},{"$f":"$P$4-P6","v":{"v":0.40999999999999925,"d":"R 0.41"}}]
["Verse by bul",{"$f":"Invoere!C8","v":{"v":0.15,"d":"15%"}},{"$f":"C6*B7","v":15},{"$nulls":3},"Chlamysure",{"$f":"Invoere!C45","v":100},{"v":9.6,"d":"R 9.60"},{"$f":"Invoere!C46","v":{"v":960,"d":"R 960"}},null,null,"Speen Kg",200,220,{"v":6.84,"d":"R 6.84"},{"v":10.16,"d":"R 10.16"},{"$f":"$P$4-P7","v":{"v":0.6799999999999997,"d":"R 0.68"}}]
["Jong verse",{"$f":"Invoere!C8","v":{"v":0.15,"d":"15%"}},{"$f":"C6*B8","v":15},{"$nulls":3},"Miltsiek",{"$f":"Invoere!C47","v":100},{"v":1.38,"d":"R 1.38"},{"$f":"Invoere!C48","v":{"v":138,"d":"R 138"}},null,null,"Kruipvoer","Ja","Nee",{"v":1.72,"d":"R 1.72"},{"v":15.28,"d":"R 15.28"},{"$f":"$P$4-P8","v":{"v":5.8,"d":"R 5.80"}}]
["Bulle",{"$f":"Invoere!C7","v":{"v":0.03,"d":"3%"}},{"$f":"C6*B9","v":3},{"$nulls":3},"Lumpyvax",{"$f":"Invoere!C49","v":100},{"v":8.02,"d":"R 8.02"},{"$f":"Invoere!C50","v":{"v":802,"d":"R 802"}},null,null,"Arbeid",2,1,{"v":5.87,"d":"R 5.87"},{"v":11.13,"d":"R 11.13"},{"$f":"$P$4-P9","v":{"v":1.6499999999999995,"d":"R 1.65"}}]
[{"$nulls":6},"Slenkdal",{"$f":"Invoere!C51","v":100},{"v":4.45,"d":"R 4.45"},{"$f":"Invoere!C52","v":{"v":445,"d":"R 445"}}]
["Kalwers gespeen",{"$f":"Invoere!C9","v":{"v":0.7,"d":"70%"}},{"$f":"C6*B11","v":70},{"$nulls":3},"Koste/Bees",null,{"$f":"SUM(I5:I10)","v":{"v":51.42,"d":"R 51.42"}}]
["Kalwers Bemark",null,{"$f":"C11-(B7*C6)","v":55}]
["Speengewig","kg",{"$f":"Invoere!C10","v":200},{"$nulls":3},"Ander Kostes En Inkostes",{"$nulls":5},"Vaste Koste"]
[{"$nulls":7},"Werkers","Arbeid/Jaar","Werker/Maand",null,null,"Huur/Verband koste (R/ha/jaar)",null,{"$f":"Invoere!C61","v":{"v":300,"d":"R 300.00"}}]
["Uitskot Koeie",{"$f":"Invoere!C8","v":{"v":0.15,"d":"15%"}},{"$f":"C6*B15","v":15},{"$nulls":3},"Arbeid",{"$f":"Invoere!C55","v":2},{"$f":"(J15*H15)*12","v":{"v":33024,"d":"R 33,024"}},{"$f":"Invoere!C56","v":{"v":1376,"d":"R 1,376"}}]
["Karkas gewig","kg",{"$f":"Invoere!C12","v":250},{"$nulls":9},"Drakrag (ha/GVE)",null,{"$f":"Invoere!C62","v":4}]
[{"$nulls":7},"% van Tot","Tot/Jaar",{"$nulls":3},"Weiding Benodig",null,{"$f":"O16*C4","v":532}]
["Lek en Voer Kostes",{"$nulls":5},"Oorhoofs",{"$f":"Invoere!C57","v":{"v":0.1,"d":"10%"}},{"$f":"((C25*C4)+(C45*C11)+((C4+C11)*I11)+I15)*(10/100)","v":{"v":13560.270000000002,"d":"R 13,560"}}]
["Winterlek","Hoeveelheid","Koste","R/50kg",null,null,"Ander Inkomstes",null,{"$f":"Invoere!C58","v":{"v":0,"d":"R 0.00"}},{"$nulls":3},"Koste Per Jaar",null,{"$f":"O14*O17","v":{"v":159600,"d":"R 159,600"}}]
["Premix 450",{"$f":"Invoere!C17","v":50},{"$f":"D20","v":{"v":143,"d":"R 143"}},{"$f":"Invoere!C18","v":{"v":143,"d":"R 143"}},null,null,"Totaal",null,{"$f":"I15+I18-I19","v":{"v":46584.270000000004,"d":"R 46,584"}}]
["Koste","R/kg",{"$f":"C20/B20","v":{"v":2.86,"d":"R 2.86"}}]
[{"$nulls":6},"Totale Kostes",{"$nulls":5},"Finale Marge"]
["Inname","kg/dier/dag",{"$f":"Invoere!C19","v":0.5},{"$nulls":3},"Lek en Voer",null,{"$f":"(C35*(C4+C15))+(C45*C11)","v":{"v":112944.48,"d":"R 112,944"}},{"$nulls":3},"Inkomste",null,{"$f":"I40","v":{"v":187000,"d":"R 187,000.00"}}]
["Tydperk","Dae",{"$f":"Invoere!C20","v":180},{"$nulls":3},"Doseer en Ent",null,{"$f":"I11*(C4+C11+C15)","v":{"v":11209.56,"d":"R 11,210"}}]
["Koste/dier",null,{"$f":"C21*C23*C24","v":{"v":257.4,"d":"R 257.40"}},{"$nulls":3},"Ander",null,{"$f":"I20","v":{"v":46584.270000000004,"d":"R 46,584"}},{"$nulls":3},"Veranderlike Kostes (Na Uitskot Koeie)",null,{"$f":"I44","v":{"v":82613.31,"d":"R 82,613"}}]
[{"$nulls":6},"Totaal",null,{"$f":"SUM(I23:I25)","v":{"v":170738.31,"d":"R 170,738"}}]
["Somerlek","Hoeveelheid","Koste","R/25kg",{"$nulls":8},"Vaste Koste",null,{"$f":"O19","v":{"v":159600,"d":"R 159,600"}}]
["Fosfaatblok",{"$f":"Invoere!C23","v":25},{"$f":"D28","v":{"v":106,"d":"R 106"}},{"$f":"Invoere!C24","v":{"v":106,"d":"R 106"}},null,null,"Per Bemarkte Kalf",null,{"$f":"I26/C12","v":{"v":3104.332909090909,"d":"R 3,104.33"}}]
["Koste","R/kg",{"$f":"C28/B28","v":{"v":4.24,"d":"R 4.24"}},{"$nulls":3},"Per Bemarkte Kg",null,{"$f":"I28/C13","v":{"v":15.521664545454547,"d":"R 15.52"}},{"$nulls":3},"Finale Marge",null,{"$f":"O23-O25-O27","v":{"v":-55213.31,"d":"R -55,213.31"}}]
[{"$nulls":12},"Per kalf",null,{"$f":"O29/C12","v":{"v":-1003.8783636363636,"d":"R -1,003.88"}}]
["Inname","kg/dier/dag",{"$f":"Invoere!C25","v":0.15},{"$nulls":3},"Min: Uitskot Koeie",{"$nulls":5},"Per kg",null,{"$f":"O30/C13","v":{"v":-5.019391818181818,"d":"R -5.02"}}]
["Tydperk","Dae",{"$f":"Invoere!C26","v":180},{"$nulls":3},"R/kg",{"$f":"Invoere!C13","v":{"v":23.5,"d":"R 23.50"}},{"$f":"C15*C16*H32","v":{"v":88125,"d":"R 88,125"}}]
["Koste/dier",null,{"$f":"C29*C31*C32","v":{"v":114.48,"d":"R 114.48"}}]
[{"$nulls":6},"Totaal per kalf",null,{"$f":"(I26-I32)/C12","v":{"v":1502.0601818181817,"d":"R 1,502.06"}}]
["Totale lek / dier",null,{"$f":"C25+C33","v":{"v":371.88,"d":"R 371.88"}},{"$nulls":3},"Totaal per kg",null,{"$f":"I34/C13","v":{"v":7.510300909090908,"d":"R 7.51"}}]
[]
["Kruipvoer","Hoeveelheid","Koste","R/50kg",null,null,"Marge (Slegs Veranderlike Kostes)"]
["Mielies",{"$f":"Invoere!C29","v":700},{"$f":"(D38/50)*B38","v":{"v":1232,"d":"R 1,232"}},{"$f":"Invoere!C30","v":{"v":88,"d":"R 88"}},null,null,"Inkomste"]
["SS 200",{"$f":"Invoere!C31","v":200},{"$f":"(D39/50)*B39","v":{"v":724,"d":"R 724"}},{"$f":"Invoere!C32","v":{"v":181,"d":"R 181"}},null,null,"Kalwers Bemark"]
["Procon 33",{"$f":"Invoere!C33","v":100},{"v":505.99999999999994,"d":"R 506"},{"$f":"Invoere!C34","v":{"v":253,"d":"R 253"}},null,null,"R/kg",{"$f":"Invoere!C11","v":{"v":17,"d":"R 17.00"}},{"$f":"H40*C12*C13","v":{"v":187000,"d":"R 187,000.00"}}]
["Koste","R/kg",{"$f":"SUM(C38:C40)/SUM(B38:B40)","v":{"v":2.462,"d":"R 2.46"}},{"$nulls":3},"Per Kalf",null,{"$f":"I40/C12","v":{"v":3400,"d":"R 3,400.00"}}]
[]
["Inname","kg/dier/dag",{"$f":"Invoere!C37","v":2.8},{"$nulls":3},"Kostes"]
["Tydperk","Dae",{"$f":"Invoere!C38","v":120},{"$nulls":3},"Na Uitskot Koeie",null,{"$f":"I26-I32","v":{"v":82613.31,"d":"R 82,613"}}]
["Koste/kalf",null,{"$f":"C41*C43*C44","v":{"v":827.232,"d":"R 827.23"}}]
[{"$nulls":6},"Bruto Marge",null,{"$f":"I40-I44","v":{"v":104386.69,"d":"R 104,386.69"}}]
[{"$nulls":6},"Marge/Bermarkte kalf",null,{"$f":"I46/C12","v":{"v":1897.9398181818183,"d":"R 1,897.94"}}]
[{"$nulls":6},"Marge/Bermarkte Kg",null,{"$f":"I47/C13","v":{"v":9.489699090909092,"d":"R 9.49"}}]

{"sheet":"Marges","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"merged":[[1,1,2,2],[4,1,4,2],[4,4,10,7],[13,1,13,2],[14,1,14,2],[21,1,21,2],[22,1,22,2],[30,1,30,2],[31,1,31,2],[35,1,35,2],[36,1,36,2],[48,1,48,2],[49,1,49,2],[60,1,60,2],[61,1,61,2],[64,1,64,2],[65,1,65,2],[70,4,75,7],[74,1,75,2]]}
[]
[null,"Kostes en Marges"]
[]
[]
[null,"Fisiese Afvoere",null,null,"Al die betrokke waardes is berekenings en moet dus nie verander word nie"]
[null,"Produktiewe Koeie",{"$f":"Berekeninge!C6","v":100}]
[null,"Verse by bul",{"$f":"Berekeninge!C7","v":15}]
[null,"Jong Verse",{"$f":"Berekeninge!C8","v":15}]
[null,"Bulle",{"$f":"Berekeninge!C9","v":3}]
[null,"Totale Aantal Bees",{"$f":"Berekeninge!C4","v":133}]
[null,"Kalwers Gespeen",{"$f":"Berekeninge!C11","v":70}]
[null,"Kalwers Bemark",{"$f":"Berekeninge!C12","v":55}]
[null,"Uitskot Koeie",{"$f":"Berekeninge!C15","v":15}]
[]
[null,"Lek en Voer Afvoere"]
[null,"Winterlek Koste (R/kg)",{"$f":"Berekeninge!C21","v":{"v":2.86,"d":"R 2.86"}}]
[null,"Winterlek Koste (R/Dier)",{"$f":"Berekeninge!C25","v":{"v":257.4,"d":"R 257.40"}}]
[null,"Somerlek Koste (R/kg)",{"$f":"Berekeninge!C29","v":{"v":4.24,"d":"R 4.24"}}]
[null,"Somerlek Koste (R/Dier)",{"$f":"Berekeninge!C33","v":{"v":114.48,"d":"R 114.48"}}]
[null,"Kruipvoer Koste (R/kg)",{"$f":"Berekeninge!C41","v":{"v":2.462,"d":"R 2.46"}}]
[null,"Kruipvoer Koste (R/Kalf)",{"$f":"Berekeninge!C45","v":{"v":827.232,"d":"R 827.23"}}]
[]
[null,"Doseer en Ent Afvoere"]
[null,"Medikament 1 (R/Dier)",{"$f":"Berekeninge!I5","v":{"v":19.72,"d":"R 19.72"}}]
[null,"Medikament 2 (R/Dier)",{"$f":"Berekeninge!I6","v":{"v":8.25,"d":"R 8.25"}}]
[null,"Medikament 3 (R/Dier)",{"$f":"Berekeninge!I7","v":{"v":9.6,"d":"R 9.60"}}]
[null,"Medikament 4 (R/Dier)",{"$f":"Berekeninge!I8","v":{"v":1.38,"d":"R 1.38"}}]
[null,"Medikament 5 (R/Dier)",{"$f":"Berekeninge!I9","v":{"v":8.02,"d":"R 8.02"}}]
[null,"Medikament 6 (R/Dier)",{"$f":"Berekeninge!I10","v":{"v":4.45,"d":"R 4.45"}}]
[null,"Totaal Per Dier",{"$f":"Berekeninge!I11","v":{"v":51.42,"d":"R 51.42"}}]
[]
[null,"Ander Koste en Inkomste Afvoere"]
[null,"Arbeid per Jaar",{"$f":"Berekeninge!I15","v":{"v":33024,"d":"R 33,024"}}]
[null,"Oorhoofs per Jaar",{"$f":"Berekeninge!I18","v":{"v":13560.270000000002,"d":"R 13,560"}}]
[null,"Ander Inkomstes",{"$f":"Berekeninge!I19","v":{"v":0,"d":"R 0"}}]
[]
[null,"Totale Veranderlike Kostes"]
[null,"Lek en Voer",{"$f":"Berekeninge!I23","v":{"v":112944.48,"d":"R 112,944"}}]
[null,"Doseer en Ent",{"$f":"Berekeninge!I24","v":{"v":11209.56,"d":"R 11,210"}}]
[null,"Ander",{"$f":"Berekeninge!I25","v":{"v":46584.270000000004,"d":"R 46,584"}}]
[null,"Totaal",{"$f":"Berekeninge!I26","v":{"v":170738.31,"d":"R 170,738"}}]
[null,"Totaal / Bemarkte Kalf",{"$f":"Berekeninge!I28","v":{"v":3104.332909090909,"d":"R 3,104"}}]
[null,"Totaal / Bemarkte Kg",{"$f":"Berekeninge!I29","v":{"v":15.521664545454547,"d":"R 15.52"}}]
[]
[null,"Min: Uitskot Koeie",{"$f":"Berekeninge!I32","v":{"v":88125,"d":"R 88,125"}}]
[]
[null,"Totaal / Kalf",{"$f":"Berekeninge!I34","v":{"v":1502.0601818181817,"d":"R 1,502"}}]
[null,"Totaal / Kg",{"$f":"Berekeninge!I35","v":{"v":7.510300909090908,"d":"R 7.51"}}]
[]
[null,"Marge voor Vaste Koste"]
[null,"Inkomste"]
[null,"Totale Kalwers Bemark",{"$f":"Berekeninge!I40","v":{"v":187000,"d":"R 187,000.00"}}]
[null,"Inkomste / Kalf",{"$f":"Berekeninge!I41","v":{"v":3400,"d":"R 3,400.00"}}]
[]
[null,"Min: Kostes"]
[null,"Na Uitskot Koeie",{"$f":"Berekeninge!I44","v":{"v":82613.31,"d":"R 82,613"}}]
[]
[null,"Bruto Marge",{"$f":"Berekeninge!I46","v":{"v":104386.69,"d":"R 104,387"}}]
[null,"Bruto Marge/Bemarkte Kalf",{"$f":"Berekeninge!I47","v":{"v":1897.9398181818183,"d":"R 1,897.94"}}]
[null,"Bruto Marge/Bemarkte Kg",{"$f":"Berekeninge!I48","v":{"v":9.489699090909092,"d":"R 9.49"}}]
[]
[null,"Vaste Koste"]
[null,"Weiding Benodig (Ha)",{"$f":"Berekeninge!O17","v":532}]
[null,"Huur/Verband Koste per Jaar",{"$f":"Berekeninge!O19","v":{"v":159600,"d":"R 159,600"}}]
[]
[null,"Netto Marge"]
[null,"Bruto Marge",{"$f":"Berekeninge!I46","v":{"v":104386.69,"d":"R 104,387"}}]
[]
[null,"Min:  Vaste Koste",{"$f":"Berekeninge!O19","v":{"v":159600,"d":"R 159,600.00"}}]
[]
[null,"Netto Marge",{"$f":"Berekeninge!O29","v":{"v":-55213.31,"d":"R -55,213.31"}},null,"\"Click\" op Invoere indien u van die Invoere wil verander"]
[null,"Netto Marge/Bemarkbare Kalf",{"$f":"Berekeninge!O30","v":{"v":-1003.8783636363636,"d":"R -1,003.88"}}]
[null,"Netto Marge/Bemarkbare Kg",{"$f":"Berekeninge!O31","v":{"v":-5.019391818181818,"d":"R -5.02"}}]
[]
[null,"Invoere"]