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

{"sheet":"Invoere","index":0,"n_rows":60,"n_cols":5,"rows_kept":60,"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],[48,1,48,2],[49,1,49,2],[54,1,54,2],[55,1,55,2],[55,4,60,7],[59,1,60,2]]}
[]
[null,"Invoere"]
[]
[]
[null,"Fisiese Gegewens",null,null,"Verander asseblief die waardes na gelang van u boerdery omstandighede"]
[null,"Produktiewe Ooie (Aantal)",400]
[null,"Persentasie Ramme",{"v":0.03,"d":"3%"}]
[null,"Vervangings Persentasie",{"v":0.25,"d":"25%"}]
[null,"Speen Persentasie",{"v":0.7,"d":"70%"}]
[null,"Speen Gewig (Kg)",30]
[null,"Stoorlam Prys (R/kg)",{"v":25,"d":"R 25.00"}]
[null,"Uitskot Ooie Karkas Gewig (Kg)",33]
[null,"C Graad Karkas Pys (R/kg)",{"v":37.5,"d":"R 37.50"}]
[]
[null,"Lek en Voer Gegewens"]
[null,"Winterlek"]
[null,"Aankoop Grootte (bv. 50 kg)",50]
[null,"Aankoop Prys (R)",{"v":161,"d":"R 161"}]
[null,"Inname (kg/dier/dag)",0.25]
[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.025]
[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)",3]
[null,"Bestandeel 4 Prys (R/50kg)",{"v":38,"d":"R 38"}]
[null,"Inname (kg/dier/dag)",0.6]
[null,"Tydperk (Dae)",80]
[]
[null,"Doseer en Ent Gegewens"]
[null,"Medikament 1 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 1 Prys (R/bottel)",{"v":1452,"d":"R 1,452"}]
[null,"Medikament 2 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 2 Prys (R/bottel)",{"v":339,"d":"R 339"}]
[null,"Medikament 3 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 3 Prys (R/bottel)",{"v":276,"d":"R 276"}]
[null,"Medikament 4 Hoveelheid (Dosisse/bottel)",100]
[null,"Medikament 4 Prys (R/bottel)",{"v":176,"d":"R 176"}]
[]
[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 (bv Wol)",{"v":50000,"d":"R 50,000.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/KVE)",0.7]
[]
[null,"Marges"]

{"sheet":"Berekening","index":1,"n_rows":46,"n_cols":19,"rows_kept":46,"hidden":true,"merged":[[0,0,0,3],[2,0,2,3],[2,7,2,10],[2,13,2,15],[10,7,10,10],[13,13,13,15],[16,0,16,3],[19,7,19,10],[22,13,22,15],[34,7,34,10]]}
["Produksie kostes - Skaap"]
[]
["Fisiese Gegewens",{"$nulls":6},"Doseer en Ent Kostes",{"$nulls":8},"Koste/Kg","Marge/kg","Verandering"]
["Aantal Skape",null,{"$f":"C6+C7+C8","v":512},{"$nulls":5},"Dosisse","Per skaap","Aankoop prys",{"$nulls":3},"Basis","Nuwe",{"v":14.53,"d":"R 14.53"},{"v":10.47,"d":"R 10.47"},0]
[{"$nulls":7},"MultivaxP",{"$f":"Invoere!C41","v":100},{"$f":"K5/I5","v":{"v":14.52,"d":"R 14.52"}},{"$f":"Invoere!C42","v":{"v":1452,"d":"R 1,452"}},null,null,"Ooie",400,200,{"v":21.26,"d":"R 21.26"},{"v":3.74,"d":"R 3.74"},{"$f":"$Q$4-Q5","v":{"v":-6.730000000000002,"d":"-R 6.73"}}]
["Produktiewe Ooie",null,{"$f":"Invoere!C6","v":400},{"$nulls":4},"Slenkdal",{"$f":"Invoere!C43","v":100},{"$f":"K6/I6","v":{"v":3.39,"d":"R 3.39"}},{"$f":"Invoere!C44","v":{"v":339,"d":"R 339"}},null,null,"Speen %",70,60,{"v":17.21,"d":"R 17.21"},{"v":7.79,"d":"R 7.79"},{"$f":"$Q$4-Q6","v":{"v":-2.6800000000000015,"d":"-R 2.68"}}]
["Jong ooie",{"$f":"Invoere!C8","v":{"v":0.25,"d":"25%"}},{"$f":"C6*B7","v":100},{"$nulls":4},"Bloutong",{"$f":"Invoere!C45","v":100},{"v":2.76,"d":"R 2.76"},{"$f":"Invoere!C46","v":{"v":276,"d":"R 276"}},null,null,"Speen Kg",30,25,{"v":17.44,"d":"R 17.44"},{"v":7.56,"d":"R 7.56"},{"$f":"$Q$4-Q7","v":{"v":-2.910000000000002,"d":"-R 2.91"}}]
["Ramme",{"$f":"Invoere!C7","v":{"v":0.03,"d":"3%"}},{"$f":"C6*B8","v":12},{"$nulls":4},"MDB maxicare",{"$f":"Invoere!C47","v":100},{"$f":"K8/I8","v":{"v":1.76,"d":"R 1.76"}},{"$f":"Invoere!C48","v":{"v":176,"d":"R 176"}},null,null,"Kruipvoer","Ja","Nee",{"v":7.79,"d":"R 7.79"},{"v":17.21,"d":"R 17.21"},{"$f":"$Q$4-Q8","v":{"v":6.739999999999999,"d":"R 6.74"}}]
[{"$nulls":7},"Koste/Skaap",null,{"$f":"SUM(J5:J8)","v":{"v":22.430000000000003,"d":"R 22.43"}},{"$nulls":3},"Arbeid",2,3,{"v":17.89,"d":"R 17.89"},{"v":7.11,"d":"R 7.11"},{"$f":"$Q$4-Q9","v":{"v":-3.360000000000001,"d":"-R 3.36"}}]
["Lammers Gespeen",{"$f":"Invoere!C9","v":{"v":0.7,"d":"70%"}},{"$f":"C6*B10","v":280}]
["Lammers Bemark",null,{"$f":"C10-(B7*C6)","v":180},{"$nulls":4},"Ander Kostes en Inkomste",{"$nulls":5},"Speen %",70,100,{"v":12.8,"d":"R 12.80"},{"v":12.2,"d":"R 12.20"},{"$f":"$Q$4-Q11","v":{"v":1.7299999999999986,"d":"R 1.73"}}]
["Speengewig","kg",{"$f":"Invoere!C10","v":30},{"$nulls":5},"Werkers","Arbeid/Jaar","Werker/Maand"]
[{"$nulls":7},"Arbeid",{"$f":"Invoere!C51","v":2},{"$f":"(K13*I13)*12","v":{"v":33024,"d":"R 33,024"}},{"$f":"Invoere!C52","v":{"v":1376,"d":"R 1,376"}}]
["Uitskot Ooie",{"$f":"B7","v":{"v":0.25,"d":"25%"}},{"$f":"C6*B14","v":100},{"$nulls":10},"Vaste Koste"]
["Karkas gewig","kg",{"$f":"Invoere!C12","v":33},{"$nulls":5},"% van Tot","Tot/Jaar",{"$nulls":3},"Huur/Verband koste (R/ha/jaar)",null,{"$f":"Invoere!C57","v":{"v":300,"d":"R 300.00"}}]
[{"$nulls":7},"Oorhoofs",{"$f":"Invoere!C53","v":{"v":0.1,"d":"10%"}},{"$f":"((C24*C4)+(C45*C10)+((C4+C10)*J9)+J13)*(I16)","v":{"v":15799.822061814557,"d":"R 15,800"}}]
["Lek en Voer Kostes",{"$nulls":6},"Ander Inkomste",null,{"$f":"Invoere!C54","v":{"v":50000,"d":"R 50,000.00"}},{"$nulls":3},"Drakrag (ha/KVE)",null,{"$f":"Invoere!C58","v":0.7}]
["Winterlek","Hoeveelheid","Koste","R/50kg",{"$nulls":3},"Totaal",null,{"$f":"J13+J16-J17","v":{"v":-1176.177938185443,"d":"-R 1,176"}},{"$nulls":3},"Weiding Benodig",null,{"$f":"P17*C4","v":{"v":358.4,"d":"358"}}]
["Produksie",{"$f":"Invoere!C17","v":50},{"$f":"D19","v":{"v":161,"d":"R 161"}},{"$f":"Invoere!C18","v":{"v":161,"d":"R 161"}}]
["Koste","R/kg",{"$f":"C19/B19","v":{"v":3.22,"d":"R 3.22"}},{"$nulls":4},"Totale Kostes",{"$nulls":5},"Koste Per Jaar",null,{"$f":"P15*P18","v":{"v":107520,"d":"R 107,520"}}]
[{"$nulls":7},"Lek en Voer",null,{"$f":"(C34*(C4+C14))+(C45*C10)","v":{"v":133376.62061814556,"d":"R 133,377"}}]
["Inname","kg/dier/dag",{"$f":"Invoere!C19","v":0.25},{"$nulls":4},"Doseer en Ent",null,{"$f":"J9*(C4+C10+C14)","v":{"v":20007.56,"d":"R 20,008"}}]
["Tydperk","Dae",{"$f":"Invoere!C20","v":180},{"$nulls":4},"Ander",null,{"$f":"J18","v":{"v":-1176.177938185443,"d":"-R 1,176"}},{"$nulls":3},"Finale Marge"]
["Koste/dier",null,{"$f":"C20*C22*C23","v":{"v":144.9,"d":"R 144.90"}},{"$nulls":4},"Totaal",null,{"$f":"SUM(J21:J23)","v":{"v":152208.0026799601,"d":"R 152,208"}},{"$nulls":3},"Inkomste",null,{"$f":"J38","v":{"v":135000,"d":"R 135,000.00"}}]
[]
["Somerlek","Hoeveelheid","Koste","R/25kg",{"$nulls":3},"Per Bemarkte Lam",null,{"$f":"J24/C11","v":{"v":845.6000148886673,"d":"R 845.60"}},{"$nulls":3},"Veranderlike Kostes (Na Uitskot Ooie)",null,{"$f":"J42","v":{"v":28458.002679960104,"d":"R 28,458"}}]
["Fosfaatblok",{"$f":"Invoere!C23","v":25},{"$f":"D27","v":{"v":106,"d":"R 106"}},{"$f":"Invoere!C24","v":{"v":106,"d":"R 106"}},{"$nulls":3},"Per Bemarkte Kg",null,{"$f":"J26/C12","v":{"v":28.186667162955576,"d":"R 28.19"}}]
["Koste","R/kg",{"$f":"C27/B27","v":{"v":4.24,"d":"R 4.24"}},{"$nulls":10},"Vaste Koste",null,{"$f":"P20","v":{"v":107520,"d":"R 107,520"}}]
[{"$nulls":7},"Min: Uitskot Ooie"]
["Inname","kg/dier/dag",{"$f":"Invoere!C25","v":0.025},{"$nulls":4},"R/kg",{"$f":"Invoere!C13","v":{"v":37.5,"d":"R 37.50"}},{"$f":"C14*C15*I30","v":{"v":123750,"d":"R 123,750"}},{"$nulls":3},"Finale Marge",null,{"$f":"P24-P26-P28","v":{"v":-978.0026799601037,"d":"R -978.00"}}]
["Tydperk","Dae",{"$f":"Invoere!C26","v":180},{"$nulls":10},"Netto Marge/Bemarkbare Lam",null,{"$f":"P30/C11","v":{"v":-5.433348222000576,"d":"R -5.43"}}]
["Koste/dier",null,{"$f":"C28*C30*C31","v":{"v":19.080000000000002,"d":"R 19.08"}},{"$nulls":4},"Totaal per Lam",null,{"$f":"(J24-J30)/C11","v":{"v":158.10001488866723,"d":"R 158.10"}},{"$nulls":3},"Netto Marge/Bemarkbare Kg",null,{"$f":"P31/C12","v":{"v":-0.1811116074000192,"d":"R -0.18"}}]
[{"$nulls":7},"Totaal per kg",null,{"$f":"J32/C12","v":{"v":5.270000496288907,"d":"R 5.27"}}]
["Totale lek / dier",null,{"$f":"C24+C32","v":{"v":163.98000000000002,"d":"R 163.98"}}]
[{"$nulls":7},"Marge"]
["Kruipvoer","Hoeveelheid","Koste","R/50kg",{"$nulls":3},"Inkomste"]
["Mielies",{"$f":"Invoere!C29","v":700},{"$f":"(D37/50)*B37","v":{"v":1232,"d":"R 1,232"}},{"$f":"Invoere!C30","v":{"v":88,"d":"R 88"}},{"$nulls":3},"Lammers Bemark"]
["SS 200",{"$f":"Invoere!C31","v":200},{"$f":"(D38/50)*B38","v":{"v":724,"d":"R 724"}},{"$f":"Invoere!C32","v":{"v":181,"d":"R 181"}},{"$nulls":3},"R/kg",{"$f":"Invoere!C11","v":{"v":25,"d":"R 25.00"}},{"$f":"I38*C11*C12","v":{"v":135000,"d":"R 135,000.00"}}]
["Procon 33",{"$f":"Invoere!C33","v":100},{"v":505.99999999999994,"d":"R 506"},{"$f":"Invoere!C34","v":{"v":253,"d":"R 253"}},{"$nulls":3},"Per Lam",null,{"$f":"J38/C11","v":{"v":750,"d":"R 750.00"}}]
["Voerkalk",{"$f":"Invoere!C35","v":3},{"v":2.2800000000000002,"d":"R 2"},{"$f":"Invoere!C36","v":{"v":38,"d":"R 38"}}]
["Koste","R/kg",{"$f":"SUM(C37:C40)/SUM(B37:B40)","v":{"v":2.45690927218345,"d":"R 2.46"}},{"$nulls":4},"Kostes"]
[{"$nulls":7},"Na Uitskot Ooie",null,{"$f":"J24-J30","v":{"v":28458.002679960104,"d":"R 28,458"}}]
["Inname","kg/dier/dag",{"$f":"Invoere!C37","v":0.6}]
["Tydperk","Dae",{"$f":"Invoere!C38","v":80},{"$nulls":4},"Bruto Marge",null,{"$f":"J38-J42","v":{"v":106541.9973200399,"d":"R 106,542.00"}}]
["Koste/lam",null,{"$f":"C41*C43*C44","v":{"v":117.9316450648056,"d":"R 117.93"}},{"$nulls":4},"Marge/Bermarkte Lam",null,{"$f":"J44/C11","v":{"v":591.8999851113327,"d":"R 591.90"}}]
[{"$nulls":7},"Marge/Bermarkte Kg",null,{"$f":"J45/C12","v":{"v":19.729999503711092,"d":"R 19.73"}}]

{"sheet":"Marges","index":2,"n_rows":72,"n_cols":5,"rows_kept":72,"merged":[[1,1,2,2],[4,1,4,2],[4,4,9,7],[12,1,12,2],[13,1,13,2],[20,1,20,2],[21,1,21,2],[27,1,27,2],[28,1,28,2],[32,1,32,2],[33,1,33,2],[45,1,45,2],[46,1,46,2],[57,1,57,2],[58,1,58,2],[61,1,61,2],[62,1,62,2],[67,4,72,7],[71,1,72,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 Ooie",{"$f":"Berekening!C6","v":400}]
[null,"Jong Ooie",{"$f":"Berekening!C7","v":100}]
[null,"Ramme",{"$f":"Berekening!C8","v":12}]
[null,"Totale Aantal Skaap",{"$f":"Berekening!C4","v":512}]
[null,"Lammers Gespeen",{"$f":"Berekening!C10","v":280}]
[null,"Lammers Bemark",{"$f":"Berekening!C11","v":180}]
[null,"Uitskot Ooie",{"$f":"Berekening!C14","v":100}]
[]
[null,"Lek en Voer Afvoere"]
[null,"Winterlek Koste (R/kg)",{"$f":"Berekening!C20","v":{"v":3.22,"d":"R 3.22"}}]
[null,"Winterlek Koste (R/Dier)",{"$f":"Berekening!C24","v":{"v":144.9,"d":"R 144.90"}}]
[null,"Somerlek Koste (R/kg)",{"$f":"Berekening!C28","v":{"v":4.24,"d":"R 4.24"}}]
[null,"Somerlek Koste (R/Dier)",{"$f":"Berekening!C32","v":{"v":19.080000000000002,"d":"R 19.08"}}]
[null,"Kruipvoer Koste (R/kg)",{"$f":"Berekening!C41","v":{"v":2.45690927218345,"d":"R 2.46"}}]
[null,"Kruipvoer Koste (R/Lam)",{"$f":"Berekening!C45","v":{"v":117.9316450648056,"d":"R 117.93"}}]
[]
[null,"Doseer en Ent Afvoere"]
[null,"Medikament 1 (R/Dier)",{"$f":"Berekening!J5","v":{"v":14.52,"d":"R 14.52"}}]
[null,"Medikament 2 (R/Dier)",{"$f":"Berekening!J6","v":{"v":3.39,"d":"R 3.39"}}]
[null,"Medikament 3 (R/Dier)",{"$f":"Berekening!J7","v":{"v":2.76,"d":"R 2.76"}}]
[null,"Medikament 4 (R/Dier)",{"$f":"Berekening!J8","v":{"v":1.76,"d":"R 1.76"}}]
[null,"Totaal Per Dier",{"$f":"Berekening!J9","v":{"v":22.430000000000003,"d":"R 22.43"}}]
[]
[null,"Ander Koste en Inkoste Afvoere"]
[null,"Arbeid Koste per Jaar",{"$f":"Berekening!J13","v":{"v":33024,"d":"R 33,024"}}]
[null,"Oorhoofse Koste per Jaar",{"$f":"Berekening!J16","v":{"v":15799.822061814557,"d":"R 15,800"}}]
[null,"Ander Inkomste (bv Wol)",{"$f":"Berekening!J17","v":{"v":50000,"d":"R 50,000"}}]
[]
[null,"Totale Veranderlike Kostes"]
[null,"Lek en Voer",{"$f":"Berekening!J21","v":{"v":133376.62061814556,"d":"R 133,377"}}]
[null,"Doseer en Ent",{"$f":"Berekening!J22","v":{"v":20007.56,"d":"R 20,008"}}]
[null,"Ander",{"$f":"Berekening!J23","v":{"v":-1176.177938185443,"d":"-R 1,176"}}]
[null,"Totaal",{"$f":"Berekening!J24","v":{"v":152208.0026799601,"d":"R 152,208"}}]
[null,"Totaal / Bemarkte Lam",{"$f":"Berekening!J26","v":{"v":845.6000148886673,"d":"R 846"}}]
[null,"Totaal / Bemarkte Kg",{"$f":"Berekening!J27","v":{"v":28.186667162955576,"d":"R 28.19"}}]
[]
[null,"Min: Uitskot Ooie",{"$f":"Berekening!J30","v":{"v":123750,"d":"R 123,750"}}]
[]
[null,"Totaal / Lam",{"$f":"Berekening!J32","v":{"v":158.10001488866723,"d":"R 158"}}]
[null,"Totaal / Kg",{"$f":"Berekening!J33","v":{"v":5.270000496288907,"d":"R 5.27"}}]
[]
[null,"Marge voor Vaste Koste"]
[null,"Inkomste"]
[null,"Totale Lammers Bemark",{"$f":"Berekening!J38","v":{"v":135000,"d":"R 135,000.00"}}]
[null,"Inkomste / Lam",{"$f":"Berekening!J39","v":{"v":750,"d":"R 750.00"}}]
[]
[null,"Min: Kostes"]
[null,"Na Uitskot Ooie",{"$f":"Berekening!J42","v":{"v":28458.002679960104,"d":"R 28,458"}}]
[]
[null,"Bruto Marge",{"$f":"Berekening!J44","v":{"v":106541.9973200399,"d":"R 106,542"}}]
[null,"Bruto Marge/Bemarkte Lam",{"$f":"Berekening!J45","v":{"v":591.8999851113327,"d":"R 591.90"}}]
[null,"Bruto Marge/Bemarkte Kg",{"$f":"Berekening!J46","v":{"v":19.729999503711092,"d":"R 19.73"}}]
[]
[null,"Vaste Koste"]
[null,"Weiding Benodig (Ha)",{"$f":"Berekening!P18","v":{"v":358.4,"d":"358"}}]
[null,"Huur/Verband Koste per Jaar",{"$f":"Berekening!P20","v":{"v":107520,"d":"R 107,520"}}]
[]
[null,"Netto Marge"]
[null,"Bruto Marge",{"$f":"Berekening!J44","v":{"v":106541.9973200399,"d":"R 106,542"}}]
[]
[null,"Min:  Vaste Koste",{"$f":"Berekening!P28","v":{"v":107520,"d":"R 107,520.00"}}]
[]
[null,"Netto Marge",{"$f":"Berekening!P30","v":{"v":-978.0026799601037,"d":"R -978.00"}},null,"\"Click\" op Invoere indien u van die Invoere wil verander"]
[null,"Netto Marge/Bemarkbare Lam",{"$f":"Berekening!P31","v":{"v":-5.433348222000576,"d":"R -5.43"}}]
[null,"Netto Marge/Bemarkbare Kg",{"$f":"Berekening!P32","v":{"v":-0.1811116074000192,"d":"R -0.18"}}]
[]
[null,"Invoere"]