{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","Assumptions","Farrow-Finish Summary","Risk Analysis","Farrow Input","Feed Input","Feed-Summary","Farrow Finish Worksheet","Finish-O","Weaner-O","Ingredient-Summary"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":69,"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":"Introduction","index":0,"n_rows":88,"n_cols":8,"rows_kept":88,"cut":false,"hidden":false,"merged":[[27,1,37,8],[58,1,60,8],[4,1,4,8],[5,1,5,8],[6,1,6,8],[62,1,62,8],[7,1,7,8],[17,1,25,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
[null,"Guidelines For Estimating"]
[null,"Swine Farrow-Finish Costs"]
[null,{"$f":"\"Based On \"&'Farrow Input'!G13&\" Sows and \"&FIXED('Farrow Input'!F79,0)&\" Pigs Sold\"","v":"Based On 500 Sows and 13,002 Pigs Sold"}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Date:","April, 2023"]
[]
[]
[]
[]
[]
[null,"This guide is designed to provide you with planning information and a format for calculating costs of production of a swine farrow to finish enterprise  in Manitoba.  General Manitoba Agriculture recommendations are assumed in using feed and veterinary inputs. These figures provide an economic evaluation of the livestock and estimated prices required to cover all costs.  Costs include labour, investment and depreciation, but do not include management costs, nor do they necessarily represent the average cost of production in Manitoba."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"These budgets may be adjusted by putting in your own figures.  As a producer you are encouraged to calculate your own costs of production. The assumptions on which the costs are based are outlined in the supporting pages. These assumptions were arrived at using the breeding stock, management practices, and facilities seen in modern, well managed swine operations of comparable size in Manitoba. Productivity and performance assumptions are based on information collected by department specialists, feed companies and other organizations. Where individual herd productivity and performance levels differ from those listed, adjustments will be required. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This tool is available as an Excel worksheet at: "]
[]
[]
[]
[]
[]
[]
[]
[null,"                                                                                          is also available to help"]
[null,"determine machinery costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: This budget is only a guide and is not intended as an in-depth study of the cost of production of this industry. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact a Farm Management Specialist."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Assumptions","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,1,23,7],[25,1,30,7],[1,1,1,7],[10,1,13,7],[15,1,18,7],[3,1,8,7]]}
[]
[null,"Farrow-Finish Pig Cost of Production"]
[]
[null,{"$f":"\"The following farrow to finish budget is based on the assumption that all feed is purchased or home-mixed. The budget includes a land investment cost for \"&'Farrow Input'!G211&\" acres, with \"&'Farrow Input'!G212&\" acres rented out at $\"&'Farrow Input'!G213&\" per acre, of the estimated \"&ROUND(((('Farrow Finish Worksheet'!D258*'Farrow Input'!F177)/(40.768*2))*2.4709661),0)&\" to \"&ROUND(((('Farrow Finish Worksheet'!D258*'Farrow Input'!F177)/(26.362*2))*2.4709661),0)&\" acres of total landbase that would be required for this size of livestock operation.  This land base falls within the 2XP2O5 application rate, soil phosphorus levels permitting.\"","v":"The following farrow to finish budget is based on the assumption that all feed is purchased or home-mixed. The budget includes a land investment cost for 40 acres, with 0 acres rented out at $80 per acre, of the estimated 233 to 361 acres of total landbase that would be required for this size of livestock operation.  This land base falls within the 2XP2O5 application rate, soil phosphorus levels permitting."}]
[]
[]
[]
[]
[]
[]
[null,"The budget includes an assumption that 1.75% of the market pigs are sold as lightweight pigs. It is assumed that when the lightweight pigs are sold, they will have a salvage value. Therefore, total marketings are reduced by only 1% to compensate for the lightweight pigs. "]
[]
[]
[]
[]
[null,"The budget includes an assumption that this particular operation is \"all-in, all-out\" by  room. Space allocations for finishing pigs are in accordance with the Recommended Code of Practice for the Care and Handling of Farm Animals: Pigs."]
[]
[]
[]
[]
[null,"The rations illustrated in this budget are examples only. Individual farm conditions should be taken into account when formulating the diets. Producers need to know the feed intakes of their animals. Please consult with a nutritionist for diet information and suggestions."]
[]
[]
[]
[]
[null,"The Manitoba pork production industry profile is changing and this budget was specifically designed to address the need of producers who may want to analyze the cost of production for a new farrow to finish operation. Several companies are offering contracts with varying levels of guarantees. Producers need to accurately calculate their costs before they can properly make a decision."]

{"sheet":"Farrow-Finish Summary","index":2,"n_rows":78,"n_cols":13,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,0,78,12],[1,4,1,6],[1,8,1,10],[0,0,0,12],[52,0,52,12]]}
[{"$f":"'Farrow Input'!G13&\" Sow Farrow-Finish Cost of Production Summary - \"&Introduction!H12","v":"500 Sow Farrow-Finish Cost of Production Summary - April, 2023"}]
[null,null,null,null,"Purchased Feed",null,null,null,"Home-Mixed Feed"]
[null,null,null,null,"$/Pig","$/Sow","Total",null,"$/Pig","$/Sow","Total",null,"Your "]
["A. Operating Costs",null,null,null,"Sold","/Year","Cost",null,"Sold","/Year","Cost",null,"Cost"]
["1.","Feed Costs:"]
[null,1.01,"Sow Lactation ",null,{"$f":"'Farrow Finish Worksheet'!D16","v":7.9698284498790057},{"$f":"E6*'Farrow Input'!$G$79","v":207.24456899999998},{"$f":"E6*'Farrow Input'!$F$79","v":103622.28449999999},null,{"$f":"'Farrow Finish Worksheet'!D25","v":5.8635439883241141},{"$f":"I6*'Farrow Input'!$G$79","v":152.47350106905003},{"$f":"I6*'Farrow Input'!$F$79","v":76236.750534525025}]
[null,1.02,"Sow Gestation ",null,{"$f":"'Farrow Finish Worksheet'!D35","v":19.64677159035228},{"$f":"E7*'Farrow Input'!$G$79","v":510.88762274999999},{"$f":"E7*'Farrow Input'!$F$79","v":255443.81137499999},null,{"$f":"'Farrow Finish Worksheet'!D44","v":13.959678959802185},{"$f":"I7*'Farrow Input'!$G$79","v":363.00249968949998},{"$f":"I7*'Farrow Input'!$F$79","v":181501.24984475001}]
[null,1.03,"Boar Ration",null,{"$f":"'Farrow Finish Worksheet'!D53","v":0.13168504812600262},{"$f":"E8*'Farrow Input'!$G$79","v":3.4242909008953624},{"$f":"E8*'Farrow Input'!$F$79","v":1712.1454504476812},null,{"$f":"'Farrow Finish Worksheet'!D61","v":9.6227127251348993E-2},{"$f":"I8*'Farrow Input'!$G$79","v":2.5022558062233742},{"$f":"I8*'Farrow Input'!$F$79","v":1251.1279031116871}]
[null,1.04,"Pre Starter 1",null,{"$f":"'Farrow Finish Worksheet'!D73","v":1.4332915145764347},{"$f":"E9*'Farrow Input'!$G$79","v":37.270799999999994},{"$f":"E9*'Farrow Input'!$F$79","v":18635.399999999998},null,{"$f":"'Farrow Finish Worksheet'!D84","v":0.80021265449624079},{"$f":"I9*'Farrow Input'!$G$79","v":20.808443711474997},{"$f":"I9*'Farrow Input'!$F$79","v":10404.2218557375}]
[null,1.05,"Pre Starter 2",null,{"$f":"'Farrow Finish Worksheet'!D96","v":4.9296936378420568},{"$f":"E10*'Farrow Input'!$G$79","v":128.18999049999996},{"$f":"E10*'Farrow Input'!$F$79","v":64094.995249999978},null,{"$f":"'Farrow Finish Worksheet'!D107","v":2.6215416356825449},{"$f":"I10*'Farrow Input'!$G$79","v":68.169631230999983},{"$f":"I10*'Farrow Input'!$F$79","v":34084.815615499989}]
[null,1.06,"Starter 1",null,{"$f":"'Farrow Finish Worksheet'!D119","v":11.38291034182196},{"$f":"E11*'Farrow Input'!$G$79","v":295.99713000000003},{"$f":"E11*'Farrow Input'!$F$79","v":147998.565},null,{"$f":"'Farrow Finish Worksheet'!D130","v":6.6488858578615879},{"$f":"I11*'Farrow Input'!$G$79","v":172.89525020624995},{"$f":"I11*'Farrow Input'!$F$79","v":86447.625103124985}]
[null,1.07,"Starter 2",null,{"$f":"'Farrow Finish Worksheet'!D142","v":13.648100006174518},{"$f":"E12*'Farrow Input'!$G$79","v":354.90031199999999},{"$f":"E12*'Farrow Input'!$F$79","v":177450.15599999999},null,{"$f":"'Farrow Finish Worksheet'!D153","v":9.550191101689661},{"$f":"I12*'Farrow Input'!$G$79","v":248.33975425999998},{"$f":"I12*'Farrow Input'!$F$79","v":124169.87712999999}]
[null,1.08,"Starter",null,{"$f":"'Farrow Finish Worksheet'!D161","v":18.552534000000005},{"$f":"E13*'Farrow Input'!$G$79","v":482.43345974984175},{"$f":"E13*'Farrow Input'!$F$79","v":241216.72987492086},null,{"$f":"'Farrow Finish Worksheet'!D168","v":13.49647845},{"$f":"I13*'Farrow Input'!$G$79","v":350.95759927310627},{"$f":"I13*'Farrow Input'!$F$79","v":175478.79963655313}]
[null,1.0900000000000001,"Grower ",null,{"$f":"'Farrow Finish Worksheet'!D176","v":90.832499999999996},{"$f":"E14*'Farrow Input'!$G$79","v":2361.9758482980001},{"$f":"E14*'Farrow Input'!$F$79","v":1180987.9241490001},null,{"$f":"'Farrow Finish Worksheet'!D183","v":72.826400624999991},{"$f":"I14*'Farrow Input'!$G$79","v":1893.7516791316364},{"$f":"I14*'Farrow Input'!$F$79","v":946875.8395658182}]
["",1.1000000000000001,"Finisher ",null,{"$f":"'Farrow Finish Worksheet'!D191","v":50.363950000000003},{"$f":"E15*'Farrow Input'!$G$79","v":1309.6461456514801},{"$f":"E15*'Farrow Input'!$F$79","v":654823.07282574009},null,{"$f":"'Farrow Finish Worksheet'!D198","v":35.313824000000004},{"$f":"I15*'Farrow Input'!$G$79","v":918.28805107253777},{"$f":"I15*'Farrow Input'!$F$79","v":459144.02553626883}]
["Total Feed Cost",null,null,null,{"$f":"SUM(E6:E15)","v":218.89126458877223},{"$f":"SUM(F6:F15)","v":5691.9701688502164},{"$f":"SUM(G6:G15)","v":2845985.0844251085},null,{"$f":"SUM(I6:I15)","v":161.17698440010767},{"$f":"SUM(J6:J15)","v":4191.1886654507789},{"$f":"SUM(K6:K15)","v":2095594.3327253894}]
[]
["2.","Other Operating Costs:",null,null,null,"",null,null,null,""]
[null,2.0099999999999998,"Veterinary Medicine & Supplies",null,{"$f":"'Farrow Finish Worksheet'!D212","v":2.8842113287944615},{"$f":"E19*'Farrow Input'!$G$79","v":75},{"$f":"E19*'Farrow Input'!$F$79","v":37500},null,{"$f":"E19","v":2.8842113287944615},{"$f":"I19*'Farrow Input'!$G$79","v":75},{"$f":"I19*'Farrow Input'!$F$79","v":37500}]
[null,2.02,"Maintenance & Repairs",null,{"$f":"'Farrow Finish Worksheet'!D218","v":6.3315017386436079},{"$f":"E20*'Farrow Input'!$G$79","v":164.64210706666665},{"$f":"E20*'Farrow Input'!$F$79","v":82321.053533333325},null,6.3315017386436079,{"$f":"I20*'Farrow Input'!$G$79","v":164.64210706666665},{"$f":"I20*'Farrow Input'!$F$79","v":82321.053533333325}]
[null,2.0299999999999998,"Hydro & Propane",null,{"$f":"'Farrow Finish Worksheet'!D224","v":9.2963351872582276},{"$f":"E21*'Farrow Input'!$G$79","v":241.73857583999998},{"$f":"E21*'Farrow Input'!$F$79","v":120869.28792},null,9.2963351872582276,{"$f":"I21*'Farrow Input'!$G$79","v":241.73857583999998},{"$f":"I21*'Farrow Input'!$F$79","v":120869.28792}]
[null,2.04,"Insurance",null,{"$f":"'Farrow Finish Worksheet'!D245","v":4.8718361223864086},{"$f":"E22*'Farrow Input'!$G$79","v":126.6854843579388},{"$f":"E22*'Farrow Input'!$F$79","v":63342.742178969405},null,4.8718361223864086,{"$f":"I22*'Farrow Input'!$G$79","v":126.6854843579388},{"$f":"I22*'Farrow Input'!$F$79","v":63342.742178969405}]
[null,2.0499999999999998,"Manure Costs",null,{"$f":"'Farrow Finish Worksheet'!D288","v":2.4606685508328452},{"$f":"E23*'Farrow Input'!$G$79","v":63.986345060783528},{"$f":"E23*'Farrow Input'!$F$79","v":31993.172530391766},null,2.4606685508328452,{"$f":"I23*'Farrow Input'!$G$79","v":63.986345060783528},{"$f":"I23*'Farrow Input'!$F$79","v":31993.172530391766}]
[null,2.06,"Office Supplies",null,{"$f":"'Farrow Finish Worksheet'!D293","v":7.6912302101185645E-2},{"$f":"E24*'Farrow Input'!$G$79","v":2},{"$f":"E24*'Farrow Input'!$F$79","v":1000.0000000000001},null,7.6912302101185645E-2,{"$f":"I24*'Farrow Input'!$G$79","v":2},{"$f":"I24*'Farrow Input'!$F$79","v":1000.0000000000001}]
[null,2.0699999999999998,"Marketing & Transport.",null,{"$f":"'Farrow Finish Worksheet'!D302","v":5.6099999999999994},{"$f":"E25*'Farrow Input'!$G$79","v":145.880433864},{"$f":"E25*'Farrow Input'!$F$79","v":72940.216931999996},null,5.6099999999999994,{"$f":"I25*'Farrow Input'!$G$79","v":145.880433864},{"$f":"I25*'Farrow Input'!$F$79","v":72940.216931999996}]
[null,2.08,"Artificial Insemination Costs",null,{"$f":"'Farrow Finish Worksheet'!D310","v":1.5788172813820882},{"$f":"E26*'Farrow Input'!$G$79","v":41.055},{"$f":"E26*'Farrow Input'!$F$79","v":20527.5},null,1.5788172813820882,{"$f":"I26*'Farrow Input'!$G$79","v":41.055},{"$f":"I26*'Farrow Input'!$F$79","v":20527.5}]
[null,2.09,"Herd Replacement",null,{"$f":"'Farrow Finish Worksheet'!D337","v":1.4962596163066755},{"$f":"E27*'Farrow Input'!$G$79","v":38.908200000000001},{"$f":"E27*'Farrow Input'!$F$79","v":19454.099999999999},null,1.4962596163066755,{"$f":"I27*'Farrow Input'!$G$79","v":38.908200000000001},{"$f":"I27*'Farrow Input'!$F$79","v":19454.099999999999}]
[null,2.1,"Property Tax",null,{"$f":"'Farrow Finish Worksheet'!D349","v":0.92294762521422768},{"$f":"E28*'Farrow Input'!$G$79","v":24},{"$f":"E28*'Farrow Input'!$F$79","v":12000},null,0.92294762521422768,{"$f":"I28*'Farrow Input'!$G$79","v":24},{"$f":"I28*'Farrow Input'!$F$79","v":12000}]
["Subtotal Operating Costs",null,null,null,{"$f":"SUM(E19:E28)+E16","v":254.42075434169195},{"$f":"SUM(F19:F28)+F16","v":6615.8663150396051},{"$f":"SUM(G19:G28)+G16","v":3307933.1575198029},null,{"$f":"SUM(I19:I28)+I16","v":196.70647415302739},{"$f":"SUM(J19:J28)+J16","v":5115.0848116401676},{"$f":"SUM(K19:K28)+K16","v":2557542.4058200838}]
[null,2.11,"Interest on Operating Costs",null,{"$f":"'Farrow Finish Worksheet'!D361","v":5.5989992034236726},{"$f":"E30*'Farrow Input'!G79","v":145.59437308371403},{"$f":"E30*'Farrow Input'!F79","v":72797.186541857023},null,{"$f":"'Farrow Finish Worksheet'!D368","v":4.328889735984089},{"$f":"I30*'Farrow Input'!K79","v":0},{"$f":"I30*'Farrow Input'!J79","v":0}]
["Total Operating Costs",null,null,null,{"$f":"SUM(E29:E30)","v":260.01975354511563},{"$f":"SUM(F29:F30)","v":6761.4606881233194},{"$f":"SUM(G29:G30)","v":3380730.3440616601},null,{"$f":"SUM(I29:I30)","v":201.03536388901148},{"$f":"SUM(J29:J30)","v":5115.0848116401676},{"$f":"SUM(K29:K30)","v":2557542.4058200838}]
[]
["B. Fixed Costs",null,null,null,null,"",null,null,null,""]
["3.","Depreciation:",null,null,null,"",null,null,null,""]
[null,3.01,"Buildings & Manure Storage",null,{"$f":"'Farrow Finish Worksheet'!D381","v":4.7368719904152092},{"$f":"E35*'Farrow Input'!$G$79","v":123.17592533333332},{"$f":"E35*'Farrow Input'!$F$79","v":61587.962666666666},null,{"$f":"'Farrow Finish Worksheet'!D388","v":4.8614699198191298},{"$f":"I35*'Farrow Input'!$G$79","v":126.41592533333332},{"$f":"I35*'Farrow Input'!$F$79","v":63207.962666666666}]
[null,3.02,"Equipment",null,{"$f":"'Farrow Finish Worksheet'!D395","v":12.758311581765176},{"$f":"E36*'Farrow Input'!$G$79","v":331.76257199999998},{"$f":"E36*'Farrow Input'!$F$79","v":165881.28599999999},null,{"$f":"'Farrow Finish Worksheet'!D401","v":13.173638013111578},{"$f":"I36*'Farrow Input'!$G$79","v":342.56257199999999},{"$f":"I36*'Farrow Input'!$F$79","v":171281.28599999999}]
[null,"Total Depreciation Cost",null,null,{"$f":"SUM(E35:E36)","v":17.495183572180384},{"$f":"SUM(F35:F36)","v":454.93849733333332},{"$f":"SUM(G35:G36)","v":227469.24866666665},null,{"$f":"SUM(I35:I36)","v":18.035107932930707},{"$f":"SUM(J35:J36)","v":468.97849733333328},{"$f":"SUM(K35:K36)","v":234489.24866666665}]
[]
["4.","Investment:",null,null,null,"","",null,null,"",""]
[null,4.01,"Land cost",null,{"$f":"'Farrow Finish Worksheet'!D419","v":0.30880289293626034},{"$f":"E40*'Farrow Input'!$G$79","v":8.0299999999999994},{"$f":"E40*'Farrow Input'!$F$79","v":4015},null,{"$f":"E40","v":0.30880289293626034},{"$f":"I40*'Farrow Input'!$G$79","v":8.0299999999999994},{"$f":"I40*'Farrow Input'!$F$79","v":4015}]
[null,4.0199999999999996,"Buildings & Manure Storage",null,{"$f":"'Farrow Finish Worksheet'!D428","v":5.2271125614822838},{"$f":"E41*'Farrow Input'!$G$79","v":135.92396583333331},{"$f":"E41*'Farrow Input'!$F$79","v":67961.98291666666},null,{"$f":"'Farrow Finish Worksheet'!D436","v":5.2794609970999034},{"$f":"I41*'Farrow Input'!$G$79","v":137.28521583333333},{"$f":"I41*'Farrow Input'!$F$79","v":68642.60791666666}]
[null,4.03,"Equipment",null,{"$f":"'Farrow Finish Worksheet'!D444","v":2.1441051408244252},{"$f":"E42*'Farrow Input'!$G$79","v":55.754543349999992},{"$f":"E42*'Farrow Input'!$F$79","v":27877.271674999996},null,{"$f":"'Farrow Finish Worksheet'!D451","v":2.2139030549812513},{"$f":"I42*'Farrow Input'!$G$79","v":57.569543349999996},{"$f":"I42*'Farrow Input'!$F$79","v":28784.771675}]
[null,4.04,"Breeding Herd",null,{"$f":"'Farrow Finish Worksheet'!D457","v":0.39234888109367322},{"$f":"E43*'Farrow Input'!$G$79","v":10.202499999999999},{"$f":"E43*'Farrow Input'!$F$79","v":5101.25},null,{"$f":"E43","v":0.39234888109367322},{"$f":"I43*'Farrow Input'!$G$79","v":10.202499999999999},{"$f":"I43*'Farrow Input'!$F$79","v":5101.25}]
[null,"Total Investment Cost",null,null,{"$f":"SUM(E40:E43)","v":8.0723694763366414},{"$f":"SUM(F40:F43)","v":209.91100918333331},{"$f":"SUM(G40:G43)","v":104955.50459166666},null,{"$f":"SUM(I40:I43)","v":8.194515826111088},{"$f":"SUM(J40:J43)","v":213.08725918333332},{"$f":"SUM(K40:K43)","v":106543.62959166666}]
["Total Fixed Costs",null,null,null,{"$f":"E37+E44","v":25.567553048517027},{"$f":"F37+F44","v":664.84950651666668},{"$f":"G37+G44","v":332424.75325833331},null,{"$f":"I37+I44","v":26.229623759041793},{"$f":"J37+J44","v":682.06575651666662},{"$f":"K37+K44","v":341032.87825833331}]
[]
["C. Labour",null,null,null,null,"",null,null,null,""]
[null,{"$f":"'Farrow Input'!F48","v":120},"hours/week farrow wean",null,{"$f":"'Farrow Finish Worksheet'!D466","v":12.958184658007756},{"$f":"E48*'Farrow Input'!$G$79","v":336.96},{"$f":"E48*'Farrow Input'!$F$79","v":168480},null,{"$f":"E48","v":12.958184658007756},{"$f":"I48*'Farrow Input'!$G$79","v":336.96},{"$f":"I48*'Farrow Input'!$F$79","v":168480}]
[null,{"$f":"'Finish-O'!D47","v":48},"hours/week grower finish",null,{"$f":"'Farrow Finish Worksheet'!D472","v":5.1832738632031026},{"$f":"E49*'Farrow Input'!$G$79","v":134.78399999999999},{"$f":"E49*'Farrow Input'!$F$79","v":67392},null,{"$f":"E49","v":5.1832738632031026},{"$f":"I49*'Farrow Input'!$G$79","v":134.78399999999999},{"$f":"I49*'Farrow Input'!$F$79","v":67392}]
["Total Labour Cost",null,null,null,{"$f":"SUM(E48:E49)","v":18.141458521210858},{"$f":"SUM(F48:F49)","v":471.74399999999997},{"$f":"SUM(G48:G49)","v":235872},null,{"$f":"SUM(I48:I49)","v":18.141458521210858},{"$f":"SUM(J48:J49)","v":471.74399999999997},{"$f":"SUM(K48:K49)","v":235872}]
["Total Cost of Production",null,null,null,{"$f":"E31+E45+E50","v":303.7287651148435},{"$f":"F31+F45+F50","v":7898.0541946399853},{"$f":"G31+G45+G50","v":3949027.0973199932},null,{"$f":"I31+I45+I50","v":245.40644616926414},{"$f":"J31+J45+J50","v":6268.8945681568339},{"$f":"K31+K45+K50","v":3134447.2840784173}]
[]
["Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null," $/Pig"," $/Sow","Total",null," Per Pig"," $/Sow","Total"]
[null,"Market Price ($ per 100kg)",null,null,{"$f":"'Farrow Input'!F54","v":202},null,null,null,{"$f":"E56","v":202}]
[null,"Market weight (shrunk-kg/hog live)",null,null,{"$f":"('Farrow Input'!H62)*(1-('Farrow Input'!G78/100))","v":118.0476},null,null,null,118.0476]
[null,"Dressing %",null,null,{"$f":"'Farrow Input'!H55","v":80},null,null,null,80]
[null,"Premium per head sold",null,null,{"$f":"'Farrow Input'!F56","v":2},null,null,null,2]
[null,"Land rental per head sold",null,null,{"$f":"SUM(('Farrow Input'!G212*'Farrow Input'!G213)/'Farrow Input'!F79)","v":0},null,null,null,0]
[null,"Gross Revenue  / hog",null,null,{"$f":"SUM(((E57*E58)*('Farrow Input'!$H$54/100)*E56)/10000+E59)+E60","v":211.84141376000005},{"$f":"E61*'Farrow Input'!$G$79","v":5508.648368925481},{"$f":"ROUND(E61*'Farrow Input'!$F$79,0)","v":2754324},null,211.84141376000005,{"$f":"I61*'Farrow Input'!$G$79","v":5508.648368925481},{"$f":"ROUND(I61*'Farrow Input'!$F$79,0)","v":2754324}]
[]
["Marginal Returns "]
[null,"Over Operating Costs",null,null,{"$f":"SUM(E61-E31)","v":-48.178339785115583},{"$f":"SUM(F61-F31)","v":-1252.8123191978384},{"$f":"SUM(G61-G31)","v":-626406.34406166011},null,{"$f":"SUM(I61-I31)","v":10.806049870988574},{"$f":"SUM(J61-J31)","v":393.56355728531344},{"$f":"SUM(K61-K31)","v":196781.5941799162}]
[null,"Over Operating & Labour Costs",null,null,{"$f":"SUM(E61-E31-E50)","v":-66.319798306326447},{"$f":"SUM(F61-F31-F50)","v":-1724.5563191978383},{"$f":"SUM(G61-G31-G50)","v":-862278.34406166011},null,{"$f":"SUM(I61-I31-I50)","v":-7.3354086502222842},{"$f":"SUM(J61-J31-J50)","v":-78.180442714686535},{"$f":"SUM(K61-K31-K50)","v":-39090.405820083804}]
[null,"Over Total Costs (Net Profit)",null,null,{"$f":"SUM(E61-E51)","v":-91.887351354843446},{"$f":"SUM(F61-F51)","v":-2389.4058257145043},{"$f":"SUM(G61-G51)","v":-1194703.0973199932},null,{"$f":"SUM(I61-I51)","v":-33.565032409264091},{"$f":"SUM(J61-J51)","v":-760.24619923135288},{"$f":"SUM(K61-K51)","v":-380123.28407841735}]
[]
["Operating Expense Ratio",null,null,null,{"$f":"SUM(E31/E61)","v":1.2274264457076269},null,null,null,{"$f":"SUM(I31/I61)","v":0.94898990863405497}]
[]
["Breakeven Selling Price",null,null,null,"$/100 kg ","$/cwt ",null,null,"$/100 kg ","$/cwt "]
[null,"Operating Costs",null,null,{"$f":"(E31/(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))*'Farrow Input'!$H$55/100*'Farrow Input'!$H$54/100))*100)","v":250.30326128180843},{"$f":"E71/2.2046","v":113.53681451592507},null,null,{"$f":"(I31/(('Farrow Input'!$H$62*(1-('Farrow Input'!G78/100))*'Farrow Input'!$H$55/100*'Farrow Input'!$H$54/100))*100)","v":193.52301711055873},{"$f":"I71/2.2046","v":87.78146471494091}]
[null,"Operating & Labour Costs",null,null,{"$f":"((E31+E50)/(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100)))*'Farrow Input'!$H$55/100*'Farrow Input'!$H$54/100))*100","v":267.76680461018037},{"$f":"E72/2.2046","v":121.45822580521653},null,null,{"$f":"((I31+I50)/(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100)))*'Farrow Input'!$H$55/100*'Farrow Input'!$H$54/100))*100","v":210.98656043893072},{"$f":"I72/2.2046","v":95.70287600423238}]
[null,"Total Costs",null,null,{"$f":"((E31+E50+E45)/(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))*'Farrow Input'!$H$55/100*'Farrow Input'!$H$54/100))*100)","v":292.3789420489195},{"$f":"E73/2.2046","v":132.62221811163906},null,null,{"$f":"((I31+I50+I45)/(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))*'Farrow Input'!$H$55/100*'Farrow Input'!$H$54/100))*100)","v":236.23602814117518},{"$f":"I73/2.2046","v":107.15595942174325}]
[]
["Return On Assets (ROA)",null,null,null,{"$f":"SUM(((E66+E30+E44)*'Farrow Input'!$H$66)/('Farrow Input'!$H$129+'Farrow Input'!$H$118+(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))/2)*('Farrow Input'!$F$54/100)*'Farrow Input'!$I$70)))","v":-0.13999720420244866},null,null,null,{"$f":"SUM(((I66+I30+I44)*'Farrow Input'!$H$66)/('Farrow Input'!$H$129+'Farrow Input'!$H$118+(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))/2)*('Farrow Input'!$F$54/100)*'Farrow Input'!$I$70)))","v":-3.7661981985342374E-2}]
[]
["¹ FOOTNOTE: Break-even Price = Cost per Hog Sold ÷ (Slaughter Weight(-shrink) X Dressing Percentage X Index)"]
["Note: This budget is only a guide and is not intended as an in depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user."]

{"sheet":"Risk Analysis","index":3,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,7],[50,0,52,7]]}
["Risk & Sensitivity Analysis"]
[]
[null,null,"Purchased Feed",null,"Home-Mixed Feed"]
[null,null,"Per Pig",null,"Per Pig"]
["A.  Operating Costs"]
[null,"Feed cost",{"$f":"'Farrow-Finish Summary'!E16","v":218.89126458877223},null,{"$f":"'Farrow-Finish Summary'!I16","v":161.17698440010767}]
[null,"Other Operating Costs",{"$f":"SUM(C8-C6)","v":41.128488956343404},null,{"$f":"SUM(E8-E6)","v":39.858379488903807}]
[null,"Subtotal",{"$f":"'Farrow-Finish Summary'!E31","v":260.01975354511563},null,{"$f":"'Farrow-Finish Summary'!I31","v":201.03536388901148}]
["B.  Fixed Costs",null,{"$f":"'Farrow-Finish Summary'!E45","v":25.567553048517027},null,{"$f":"'Farrow-Finish Summary'!I45","v":26.229623759041793}]
["C.  Labour",null,{"$f":"'Farrow-Finish Summary'!E50","v":18.141458521210858},null,{"$f":"'Farrow-Finish Summary'!I50","v":18.141458521210858}]
["Total Costs",null,{"$f":"SUM(C8:C10)","v":303.7287651148435},null,{"$f":"SUM(E8:E10)","v":245.40644616926414}]
[]
["Estimated Farmgate"]
[null,"Price ($ per 100kg)",{"$f":"'Farrow-Finish Summary'!E56","v":202},null,{"$f":"'Farrow-Finish Summary'!I56","v":202}]
[]
[]
[null,null,"Up",null,"Down"]
[null,"Percent Market Price Variation",0.1,null,0.1]
[null,"Percent Feed Cost Variation",0.1,null,0.05]
[]
[]
[null,"Higher Price ($ per 100kg)",{"$f":"SUM(C14*(1+C18))","v":222.20000000000002},null,{"$f":"SUM(E14*(1+C18))","v":222.20000000000002}]
[null,"Lower Price ($ per 100kg)",{"$f":"SUM(C14*(1-E18))","v":181.8},null,{"$f":"SUM(E14*(1-E18))","v":181.8}]
[null,"Higher Feed Cost",{"$f":"SUM(C6+(C6*(C19)))","v":240.78039104764946},null,{"$f":"SUM(E6+(E6*C19))","v":177.29468284011844}]
[null,"Lower Feed Cost",{"$f":"SUM(C6-(C6*E19))","v":207.94670135933362},null,{"$f":"SUM(E6-(E6*E19))","v":153.11813518010229}]
[]
[]
[{"$f":"\"Higher Margin Scenario - Price Up \"&C18*100&\"% and Feed Price Down \"&E19*100&\"%\"","v":"Higher Margin Scenario - Price Up 10% and Feed Price Down 5%"}]
[null,"Operating Costs",{"$f":"SUM(C7+C25)","v":249.07519031567702},null,{"$f":"SUM(E7+E25)","v":192.97651466900609}]
[null,"Total Costs",{"$f":"C29+C10+C9","v":292.78420188540491},null,{"$f":"E29+E10+E9","v":237.34759694925876}]
[null,"Gross Revenue / hog",{"$f":"SUM((('Farrow-Finish Summary'!$E$57*'Farrow-Finish Summary'!$E$58)*('Farrow Input'!$H$54/100)*C22)/10000+'Farrow-Finish Summary'!$E$59)","v":232.82555513600005},null,{"$f":"SUM((('Farrow-Finish Summary'!$E$57*'Farrow-Finish Summary'!$E$58)*('Farrow Input'!$H$54/100)*E22)/10000+'Farrow-Finish Summary'!$E$59)","v":232.82555513600005}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C31-C29)","v":-16.249635179676972},null,{"$f":"SUM(E31-E29)","v":39.849040466993955}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C31-C29-C10)","v":-34.391093700887829},null,{"$f":"SUM(E31-E29-E10)","v":21.707581945783097}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C31-C30)","v":-59.958646749404863},null,{"$f":"SUM(E31-E30)","v":-4.5220418132587099}]
[null,"Operating Expense Ratio",{"$f":"SUM(C29/C31)","v":1.0697931769997717},null,{"$f":"SUM(E29/E31)","v":0.82884593384211203}]
[null,"Return on Asset (ROA)",{"$f":"SUM(((C35+'Farrow-Finish Summary'!$E$30+'Farrow-Finish Summary'!$E$44)*'Farrow Input'!$H$66)/('Farrow Input'!$H$129+'Farrow Input'!$H$118+(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))/2)*('Farrow Input'!$F$54/100)*'Farrow Input'!$I$70)))","v":-8.2848662105422605E-2},null,{"$f":"SUM(((E35+'Farrow-Finish Summary'!$E$30+'Farrow-Finish Summary'!$E$44)*'Farrow Input'!$H$66)/('Farrow Input'!$H$129+'Farrow Input'!$H$118+(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))/2)*('Farrow Input'!$F$54/100)*'Farrow Input'!$I$70)))","v":1.6376194964723215E-2}]
[]
[{"$f":"\"Lower Margin Scenario - Price Down \"&E18*100&\"% and Feed Price Up \"&C19*100&\"%\"","v":"Lower Margin Scenario - Price Down 10% and Feed Price Up 10%"}]
[null,"Operating Costs",{"$f":"SUM(C7+C24)","v":281.90888000399286},null,{"$f":"SUM(E7+E24)","v":217.15306232902225}]
[null,"Total Costs",{"$f":"C9+C10+C40","v":325.61789157372073},null,{"$f":"E9+E10+E40","v":261.52414460927491}]
[null,"Gross Revenue / hog",{"$f":"SUM((('Farrow-Finish Summary'!$E$57*'Farrow-Finish Summary'!$E$58)*('Farrow Input'!$H$54/100)*C23)/10000+'Farrow-Finish Summary'!$E$59)","v":190.85727238400003},null,{"$f":"SUM((('Farrow-Finish Summary'!$E$57*'Farrow-Finish Summary'!$E$58)*('Farrow Input'!$H$54/100)*E23)/10000+'Farrow-Finish Summary'!$E$59)","v":190.85727238400003}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C42-C40)","v":-91.051607619992836},null,{"$f":"SUM(E42-E40)","v":-26.295789945022221}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C42-C40-C10)","v":-109.1930661412037},null,{"$f":"SUM(E42-E40-E10)","v":-44.437248466233079}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C42-C41)","v":-134.7606191897207},null,{"$f":"SUM(E42-E41)","v":-70.666872225274886}]
[null,"Operating Expense Ratio",{"$f":"SUM(C40/C42)","v":1.4770664826268673},null,{"$f":"SUM(E40/E42)","v":1.1377772490225877}]
[null,"Return on Asset (ROA)",{"$f":"SUM(((C46+'Farrow-Finish Summary'!$E$30+'Farrow-Finish Summary'!$E$44)*'Farrow Input'!$H$66)/('Farrow Input'!$H$129+'Farrow Input'!$H$118+(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))/2)*('Farrow Input'!$F$54/100)*'Farrow Input'!$I$70)))","v":-0.21673519849242714},null,{"$f":"SUM(((E46+'Farrow-Finish Summary'!$E$30+'Farrow-Finish Summary'!$E$44)*'Farrow Input'!$H$66)/('Farrow Input'!$H$129+'Farrow Input'!$H$118+(('Farrow Input'!$H$62*(1-('Farrow Input'!$G$78/100))/2)*('Farrow Input'!$F$54/100)*'Farrow Input'!$I$70)))","v":-0.1020150981370293}]
[]
[]
["Note: This budget is only a guide and is not intended as an in depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user."]

{"sheet":"Farrow Input","index":4,"n_rows":218,"n_cols":13,"rows_kept":218,"cut":false,"hidden":false,"merged":[[124,1,124,4],[102,1,102,4],[1,0,1,10],[10,0,10,10],[30,7,30,8],[51,0,51,10],[125,1,125,4],[93,3,93,7],[130,0,130,8],[70,1,70,10],[71,1,71,10],[83,7,83,8],[82,6,82,7],[101,1,101,4],[109,1,109,4],[110,1,110,4]]}
[]
["Farrow - Finish Pig Production Costs"]
[]
[1," This input table outlines the cost of production for a farrow finish operation."]
[2," Buildings and equipment are valued at new cost."]
[3," Purchased feed is used for creep and starter all other feed is home mixed."]
[4," Manure haulage is contracted out."]
[5," Gilts are purchased for herd replacement."]
[6," No weaner pigs are sold."]
[]
["Farrow - Wean Pig Production Assumptions"]
["Indicators of Productivity"]
["Sows",null,null,null,null,null,500]
["Boars",null,null,null,null,null,3]
["Litters/Sow/Year",null,null,null,null,null,2.38]
["Average Weaning Age (days)",null,null,null,null,null,21]
["Average Born Alive per Litter",null,null,null,null,null,13.5]
["Percent Pre-Weaning Mortality",null,null,null,null,null,12.5]
["Percent Post-Weaning Mortality",null,null,null,null,null,2.44]
[]
["Herd Profile",null,null,null,"Total","/Sow","/Litter","%Mortality"]
["Sows",null,null,null,{"$f":"G13","v":500}]
["Boars",null,null,null,{"$f":"G14","v":3}]
["Litters",null,null,null,{"$f":"ROUND(F24*E22,0)","v":1190},{"$f":"G15","v":2.38},"",""]
["Pigs Born Alive",null,null,null,{"$f":"ROUND(G17*E24,0)","v":16065},{"$f":"ROUND(E25/E22,2)","v":32.130000000000003},{"$f":"G17","v":13.5},""]
["Pigs Died, Pre-Weaning",null,null,null,{"$f":"ROUND(G18*E25/100,0)","v":2008},{"$f":"ROUND(E26/E22,2)","v":4.0199999999999996},{"$f":"ROUND(E26/E24,2)","v":1.69},{"$f":"G18","v":12.5}]
["Pigs Weaned",null,null,null,{"$f":"E25-E26","v":14057},{"$f":"ROUND(E27/E22,2)","v":28.11},{"$f":"ROUND(E27/E24,2)","v":11.81},""]
["Pigs Died, Post-Weaning",null,null,null,{"$f":"ROUND(G19*E27/100,0)","v":343},{"$f":"ROUND(E28/E22,2)","v":0.69},{"$f":"ROUND(E28/E24,2)","v":0.28999999999999998},{"$f":"G19","v":2.44}]
["Weaner Pigs Transferred",null,null,null,{"$f":"ROUND(E27-E28,0)","v":13714},{"$f":"ROUND(E29/E22,2)","v":27.43},{"$f":"ROUND(E29/E24,2)","v":11.52},""]
[]
["Feed Requirements and Costs",null,null,null,null,null,"Purchased","Home-Mixed"]
["Dry Sow Ration",null,null,null,2.95,"kg/day",549.75,{"$f":"('Feed-Summary'!H29)","v":390.6155},"/tonne",null,null,null,{"$f":"SUM(G32:H32)","v":940.3655}]
["Nursing Sow Ration",null,null,null,6.53,"kg/day",635,{"$f":"('Feed-Summary'!H55)","v":467.18075000000005},"/tonne",null,null,null,1102.18075]
["Boar Ration",null,null,null,3,"kg/day",549.75,{"$f":"('Feed-Summary'!H81)","v":401.72262500000005},"/tonne",null,null,null,951.47262500000011]
["Per Starter 1(Ration 1)",null,null,null,0.57999999999999996,"kg",2000,{"$f":"('Feed-Summary'!H107)","v":1116.608375},"/tonne",null,null,null,3116.6083749999998]
["Pre Starter 2 (Ration 2)",null,null,null,2.9,"kg",1611.5,{"$f":"('Feed-Summary'!H133)","v":856.97299999999996},"/tonne",null,null,null,2468.473]
["Starter 1 (Ration 3)",null,null,null,9,"kg",1199,{"$f":"('Feed-Summary'!H159)","v":700.3493749999999},"/tonne",null,null,null,1899.3493749999998]
["Starter 2 (Ration 4)",null,null,null,16,"kg",808.65,{"$f":"('Feed-Summary'!H185)","v":565.84887500000002},"/tonne",null,null,null,1374.498875]
[]
["Weaner Pig Efficiency",null,null,null,"Ration 1","Ration 2","Ration 3","Ration 4","Total"]
["Days Post-Weaning (nursery)",null,null,null,2,8,17,15,{"$f":"SUM(E41:H41)","v":42}]
["Target Starting Weight (kg)",null,null,null,6,6.5,9,16,{"$f":"E42","v":6}]
["Target Ending Weight (kg)",null,null,null,6.5,9,16,26,{"$f":"H43","v":26}]
["Feed Conversion Ratio ",null,null,null,{"$f":"E35/(E43-E42)","v":1.1599999999999999},{"$f":"E36/(F43-F42)","v":1.1599999999999999},{"$f":"E37/(G43-G42)","v":1.2857142857142858},{"$f":"E38/(H43-H42)","v":1.6},{"$f":"((E44*($E$43-$E$42))+(F44*($F$43-$F$42))+(G44*($G$43-G$42))+(H44*($H$43-$H$42)))/($H$43-$E$42)","v":1.4239999999999999}]
["Average Daily Gain (kg)",null,null,null,{"$f":"(E43-E42)/E41","v":0.25},{"$f":"(F43-F42)/F41","v":0.3125},{"$f":"(G43-G42)/G41","v":0.41176470588235292},{"$f":"(H43-H42)/H41","v":0.66666666666666663},{"$f":"((E45*($E$43-$E$42))+(F45*($F$43-$F$42))+(G45*($G$43-G$42))+(H45*($H$43-$H$42)))/($H$43-$E$42)","v":0.52276348039215681}]
[]
["Labour"]
["Total Hours per 7-day week",null,null,null,{"$f":"I48/G13","v":12.48},120," hours/week (include manager)",null,{"$f":"F48*52","v":6240}]
["Hourly Wage (including hired manager)",null,null,null,null,27," /hour (weighted) "]
[]
[]
["Grower-Finisher Pig Production Assumptions"]
[null,null,"Livestock values are based on"]
[null,null,"a Market Price for Pork of:",null,null,202," /100 kg",110,"Market Index"]
[null,null,null,null,"  or:",{"$f":"F54/2.2046","v":91.626598929511019}," /cwt",80,"% Dressing"]
[null,null,null,null,"Premium:",2," /head"]
[]
[]
[null,"Indicators of Productivity",null,null,null,{"$f":"B85","v":"Starter"},{"$f":"B86","v":"Grower"},{"$f":"B87","v":"Finish"},"Total"]
[null,"No. of Pigs (Beginning)",null,null,null,{"$f":"'Farrow Input'!E29","v":13714},{"$f":"F66","v":13583.717000000001},{"$f":"G66","v":13454.671688500001},"--"]
[null,"Average Beginning Weight (kg)",null,null,null,{"$f":"H43","v":26},{"$f":"F62","v":40},{"$f":"G62","v":95},"--"]
[null,"Average Ending Weight (kg)",null,null,null,40,95,121,"--"]
[null,"Percent Mortality",null,null,null,0.95,0.95,0.95,{"$f":"((F60-H66)/F60)*100","v":2.8230107374999971}]
[null,"Days on Feed",null,null,null,23,65,28,{"$f":"SUM(F64:H64)","v":116}]
[null,"Feed Conversion Ratio ¹",null,null,null,1.95,3,3.5,{"$f":"(F65*(F62-F61)+G65*(G62-G61)+H65*(H62-H61))/(H62-F61)","v":2.9821052631578948}]
[null,"No. of Pigs (Ending)",null,null,null,{"$f":"F60-(F60*F63/100)","v":13583.717000000001},{"$f":"G60-(G60*G63/100)","v":13454.671688500001},{"$f":"H60-(H60*H63/100)","v":13326.85230745925},"--"]
[null,"Weight Gain/Pig (kg)",null,null,null,{"$f":"F62-F61","v":14},{"$f":"G62-G61","v":55},{"$f":"H62-H61","v":26},{"$f":"SUM(F67:H67)","v":95}]
[null,"Feed Disappearance/Pig (kg)",null,null,null,{"$f":"F65*F67","v":27.3},{"$f":"G65*G67","v":165},{"$f":"H65*H67","v":91},{"$f":"SUM(F68:H68)","v":283.3}]
[null,"Average Daily Gain (kg)",null,null,null,{"$f":"(F62-F61)/F64","v":0.60869565217391308},{"$f":"(G62-G61)/G64","v":0.84615384615384615},{"$f":"(H62-H61)/H64","v":0.9285714285714286},{"$f":"I67/I64","v":0.81896551724137934}]
[null,"Average No. Pigs in Barn ²",null,null,null,{"$f":"((F60+F66)/2)/(365/I64)","v":4337.71941369863},{"$f":"(G60+G66)/2/(365/I64)","v":4296.5110792684936},{"$f":"(H60+H66)/2/(365/I64)","v":4255.6942240154422},{"$f":"SUM(F70:H70)/3","v":4296.6415723275213}]
[null,"¹ FOOTNOTE: The Feed Conversion Ratio (FCR) in the 'Total' column is a weighted average of the other feed conversion ratios.  Also note that an accurate feed conversion ratio for the grower-finisher enterprise is calculated by dividing 'Total Feed used per Year' by 'Total Gain per Year'; where 'Total Gain per Year' equals 'Total Hogs Sold' times 'Gain per Hog'.  When calculated in this way, the feed conversion ratio includes feed lost through wastage and weight gain lost through death of pigs."]
[null,"² FOOTNOTE: Assume that \"Avg. No. of Pigs in Barn\" equals \"Pig Places\".  "]
[]
[null,"Productivity Profile",null,null,null,"Total"]
[null,"Pigs transferred",null,null,null,{"$f":"F60","v":13714}]
[null,"Pigs Died",null,null,null,{"$f":"ROUND(F75*I63/100,0)","v":387},2.8," % mortality"]
[null,"Pigs available for marketing",null,null,null,{"$f":"F75-F76","v":13327}]
[null,"Less light weight pig adjustment",null,null,null,{"$f":"F77*G78/100","v":325.17880000000002},2.44," % light weight adjustment"]
[null,"Pigs Sold at full market value",null,null,null,{"$f":"F77-F78","v":13001.8212},{"$f":"F79/'Farrow Input'!E22","v":26.0036424}," sold/sow"]
[null,"Total Days to Market",null,null,null,{"$f":"'Farrow Input'!G16+'Farrow Input'!E41+'Farrow Input'!F41+F64+G64+H64+G43+H43","v":189}]
[null,"Turnover finish",null,null,null,{"$f":"ROUND(365/I64,2)","v":3.15}]
[null,"Turnover wean to finish",null,null,null,{"$f":"365/(I64+I41)","v":2.3101265822784809}]
[null,"Feed Requirements and Costs",null,null,null,null,"Ration Cost"]
[null,null,null,"FCR*","kg/pig",null,"Purchased","   Home-Mixed"]
[null,"Starter",null,{"$f":"F65","v":1.95},{"$f":"D85*(F62-F61)","v":27.3},null,679.58,{"$f":"('Feed-Summary'!H211)","v":494.37650000000002}," /tonne"]
[null,"Grower",null,{"$f":"G65","v":3},{"$f":"D86*(G62-G61)","v":165},null,550.5,{"$f":"('Feed-Summary'!H237)","v":441.37212499999998}," /tonne"]
[null,"Finish",null,{"$f":"H65","v":3.5},{"$f":"D87*(H62-H61)","v":91},null,553.45000000000005,{"$f":"('Feed-Summary'!H263)","v":388.06400000000002}," /tonne"]
[null,null,"* FCR = Feed Conversion Ratio (Feed:Gain)"]
[null,"Labour"]
[null,"Total Hours per year",null,null,0.36,48," hours/week",{"$f":"F90*52","v":2496}," hours/year"]
[null,"Wage (incl. benefits @15%) ",null,null,null,27," /hour (weighted) "]
[]
[]
[null,null,null," Capital Costs"]
[null,null,{"$f":"E29/3","v":4571.333333333333},"pig places feeder barn"]
[null,null,null,null,null,null,"$/Sq.Ft.","Total","/Sow"]
["Buildings"]
[null,"Gestation",null,null,{"$f":"G13*27","v":13500},"sq.ft.",64,{"$f":"E98*G98","v":864000},{"$f":"H98/E22","v":1728}]
[null,"Farrowing/Nursing",null,null,{"$f":"E24*15","v":17850},"sq.ft.",77,{"$f":"E99*G99","v":1374450},{"$f":"H99/E22","v":2748.9}]
[null,"Feeder Barn ",null,null,{"$f":"C95*9.2","v":42056.266666666663},"sq.ft.",50,{"$f":"E100*G100","v":2102813.333333333},{"$f":"H100/E22","v":4205.6266666666661}]
[null,"Office & Loading",null,null,300,"sq.ft.",50,{"$f":"E101*G101","v":15000},{"$f":"H101/E22","v":30}]
[null,"Standby Generator",null,null,null,null,null,28000,{"$f":"H102/E22","v":56}]
[null,"Feed Mill (building only)",null,null,null,null,null,45000,{"$f":"H103/E22","v":90}]
[null,"Total Building Cost",null,null,null,null,null,{"$f":"SUM(H98:H103)","v":4429263.333333333},{"$f":"H104/E22","v":8858.5266666666666}]
[null,null,null,null,null,null,null,"",""]
["Equipment",null,null,null,null,null,"$/Sq.Ft.","",""]
[null,"Gestation",null,null,null,null,26.5,{"$f":"G107*E98","v":357750},{"$f":"H107/E22","v":715.5}]
[null,"Farrowing/Nursing",null,null,null,null,26.5,{"$f":"G108*E99","v":473025},{"$f":"H108/E22","v":946.05}]
[null,"Finishing Barn",null,null,null,null,24,{"$f":"'Farrow Input'!G109*'Farrow Input'!E100","v":1009350.3999999999},{"$f":"H109/E22","v":2018.7007999999998}]
[null,"Fire Alarm System",null,null,null,null,null,3000,{"$f":"H110/E22","v":6}]
[null,"Feed Mill (equipment only).",null,null,null,null,null,60000,{"$f":"H111/E22","v":120}]
[null,"Total Equipment Cost",null,null,null,null,null,{"$f":"SUM(H107:H111)","v":1903125.4},{"$f":"H112/E22","v":3806.2507999999998}]
["Total Buildings and Equipment Cost",null,null,null,null,null,null,{"$f":"H104+H112","v":6332388.7333333325},{"$f":"H113/E22","v":12664.777466666665}]
[]
["Breeding Stock",null,null,null,null,null,null,""]
[null,"Value of Replacement Sow",null,null,350,"/sow",null,{"$f":"E116*E22","v":175000},{"$f":"H116/E22","v":350}]
[null,"Value of Replacement Boar",null,null,3500,"/boar",null,{"$f":"E117*E23","v":10500},{"$f":"H117/E22","v":21}]
["Total Breeding Stock Cost",null,null,null,null,null,null,{"$f":"SUM(H116:H117)","v":185500},{"$f":"H118/E22","v":371}]
[]
["Land Value"]
[null,"Land Investment",null,{"$f":"G211-G212","v":40},"acres @",{"$f":"G214","v":2750},"/acre",{"$f":"D121*F121","v":110000},{"$f":"H121/E22","v":220}]
[null,"Land Investment",null,{"$f":"G212","v":0},"acres @",{"$f":"G214","v":2750},"/acre",{"$f":"D122*F122","v":0},{"$f":"H122/E22","v":0}]
[]
["Other Costs"]
[null,"Site Preparation",null,null,null,null,null,36000,{"$f":"H125/E22","v":72}]
[null,"Manure Storage",null,null,null,null,null,120000,{"$f":"H126/E22","v":240}]
["Total Other Costs",null,null,null,null,null,null,{"$f":"SUM(H125:H126)","v":156000},{"$f":"SUM(I125:I126)","v":312}]
[]
["Total Capital Investment",null,null,null,null,null,null,{"$f":"H113+H118+H121+H126","v":6747888.7333333325},{"$f":"H129/E22","v":13495.777466666665}]
[]
["¹ FOOTNOTE: The number of square feet allocated for buildings and equipment are approximations.  Cost per sow for buildings and equipment will vary around the province.  "]
["FOOTNOTE: 1 sq.ft. = 0.0929 sq.m;  1 sq.m.= 10.764 sq.ft.;  1 ft.= 0.3048 m"]
[]
[]
["Fixed Costs"]
["Depreciation (straight line):"]
[null,"Useful Life:"]
[null,null,"Buildings",null,null,null,25," years"]
[null,null,"Equipment",null,null,null,10," years"]
[null,"Salvage Value (% of original cost):"]
[null,null,"Buildings",null,null,null,10," %"]
[null,null,"Equipment",null,null,null,10," %"]
[null,null,null,null,null,null,""]
["Investment Interest Rate",null,null,null,null,null,2.75," %"]
[]
[]
["Other Operating Costs, Taxes and Land"]
["Veterinary Cost: ",null,null,"Professional Services",null,null,10," /sow"]
[null,null,null,"Medication",null,null,65," /sow"]
[null,null,null,"Sevices and Medication",null,null,0,"/pig transferred in"]
[]
["Maintenance & Repair",null,null,null,null,null,1.3," % of Total Capital Investment"]
[]
["Hydro & Propane",null,null,null,null,"Hydro rate",9.3240000000000003E-2,"per kwhr"]
[null,null,null,null,null,"Hydro usage",512058,"kwhr"]
[null,null,null,null,null,"Propane rate",0.75,"per litre"]
[null,null,null,null,null,"Propane usage",97500,"litres"]
[]
["Insurance"]
[null,null,"Buildings & equipment",null,null,null,0.78," /$100 Capital Invested"]
[null,null,"Breeding stock and market hogs",null,null,null,0.88," /$100 Capital Invested"]
[null,null,"Business Interruption",null,null,null,0.78," /$100 Capital Invested"]
[null,null,"Business Interruption Value",null,null,null,1200,"per sow"]
[null,null,"Estimated value of market hogs",null,null,null,202,"per market hog"]
[]
["Manure Costs"]
[null,null,"Storage volume",null,null,null,68," litres/sow/day ³"]
[null,null,"Cost per litre",null,null,null,2.8999999999999998E-3,"/litre"]
[null,null,"Cost per gallon",null,null,null,{"$f":"G168*4.56409","v":1.3235861E-2},"/gallon"]
[null,null,"Odour control (barley straw)",null,null,null,0,"total costs"]
[null,null,"Manure Management Fees",null,null,null,3000,"total costs"]
[]
[null,null,"Manure nutrient content",null,null,"nutrient","fertilizer","% nutrient"]
[null,null,null,null,null,"kg/1000 ","value","value cost"]
[null,null,null,null,null,"litres","$/lb","recovery / sale"]
[null,null,"Total Nitrogen ",null,null,2.69,0.77,60]
[null,null,"Phosphate (P2O5)",null,null,0.62,0.89,0]
[null,null,"Potassium",null,null,1.1399999999999999,0.6,0]
[null,null,null,null,"* kg/1000 L x 10 = lbs/1000 imp. Gallons"]
["Office Supplies"]
[null,null,null,null,"Estimated rate/ sow",null,2,"$/sow"]
[]
["Marketing & Transportation"]
[]
[null,null,null,null,"Trucking in",null,0," /pig sold"]
[null,null,null,null,"Trucking out",null,4.5," /pig sold"]
[null,null,null,null,"Council Levy",null,0.8," /pig sold"]
[null,null,null,null,"Grading Charge",null,0.06," /pig sold"]
[null,null,null,null,"Insurance",null,0.25," /pig sold"]
[null,null,null,null,"Special Levy",null,0," /pig sold"]
[]
["Breeding Herd Replacement:",null,null,null,null,null,40," % of sows replaced per year"]
[null,"Cull Sow Weight",null,null,null,null,180," kg"]
[null,"Cull Sow Price (live weight)",null,null,null,null,{"$f":"'Farrow Input'!F54*0.56","v":113.12},"/100kg "]
[null,"Cull Sow Price (dressed weight)",null,null,null,null,{"$f":"ROUND(+G194/0.8,2)","v":141.4},"/100kg "]
[null,"Value of Replacement Sow",null,null,null,null,300," /sow"]
["Boar Replacement Rate:",null,null,null,null,null,50," % of boars replaced per year"]
[null,"Cull Boar Weight",null,null,null,null,225," kg"]
[null,"Cull Boar Price (live)",null,null,null,null,{"$f":"'Farrow Input'!F54*0.4","v":80.800000000000011},"/100kg "]
[null,"Cull Boar Price (dressed)",null,null,null,null,{"$f":"G199/0.8","v":101.00000000000001},"/100kg "]
[null,"Value of Replacement Boar",null,null,null,null,300," /boar"]
[null,null,"Breeding Costs"]
[null,null,"Number of services/sow",null,null,null,2.2999999999999998,null,{"$f":"((G203*G204)*G13)*G15","v":20527.5}]
[null,null,"Cost/dose (semen)",null,null,null,7.5,null,{"$f":"I203/F79","v":1.5788172813820882}]
[]
["Property Tax:",null,"Grower-Finisher Barn & Land ",null,null,null,0," /year"]
[null,null,"Farrow-Finish Barn & Land ",null,null,null,12000," /year"]
[null,null,"Land",null,null,null,10," /acre"]
[]
[null,"Land Value for Grower-Finisher Operation:"]
[null,null,"Number of Acres",null,null,null,40,"acres"]
[null,null,"Number of Acres rented out",null,null,null,0,"acres"]
[null,null,"Rental rate (income)",null,null,null,80,"/acre"]
[null,null,"Land Value per Acre",null,null,null,2750,"/acre"]
[]
["Operating Loan Interest Rate",null,null,null,null,null,8.5," %"]
[]
["³ FOOTNOTE:    1000 litres = 35.314 cubic feet"]

{"sheet":"Feed Input","index":5,"n_rows":240,"n_cols":9,"rows_kept":240,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
[" Feed Ingredient Costs"]
[]
[null,null,null,null,"Price ($/tonne)","Your Cost"]
[null,"  Wheat",null,null,370]
[null,"  Barley ",null,null,320]
[null,"  Corn ",null,null,355]
[null,"  Soybean Meal ",null,null,665]
[null,"  Canola Meal",null,null,425]
[null,"  Peas ",null,null,390]
[null,"  Sow Micro Premix ",null,null,4000]
[null,"  Grower Micro Premix ",null,null,8000]
[null,"  Canola Oil ",null,null,2400]
[null,"  Whey Powder ",null,null,1364.6]
[null,"  Fish Meal",null,null,3364.4]
[null,"  Plasma",null,null,5270]
[null,"  Limestone ",null,null,203.95]
[null,"  Dical (16% Ca-21% P) ",null,null,1544.23]
[null,"  Salt - 96% ",null,null,261.89999999999998]
[null,"  Phytase",null,null,14500]
[null,"  L-Lysine HCL ",null,null,2248.5]
[null,"  L-Threonine ",null,null,2815.6]
[null,"  D L-Methionine ",null,null,3850.2]
[null,"  Oats - Groats",null,null,375]
[null,"  Processing Cost"]
[null,"  (Hydro, Repairs/Maintenance & Insurance)",null,null,10]
[null,"  Percent Weight loss due to processing",null,null,1.25]
[null,"  Labour Cost",null,null,10]
[]
[null,"Ration Formulas",null,"Sow","Sow","Boar"]
[null,null,null,"Gestation","Lactation","Ration"]
[null,null,null,"(kg)","(kg)","(kg)"]
[null,{"$f":"B4","v":"  Wheat"},null,0,300,200]
[null,"  Barley ",null,877,464,599]
[null,"  Corn ",null,0,0,0]
[null,"  Soybean Meal ",null,0,197,0]
[null,"  Canola Meal",null,87,0,80]
[null,"  Peas ",null,0,0,91]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,5,5,5]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,0,0,0]
[null,"  Canola Oil ",null,0,0,0]
[null,"  Whey Powder ",null,0,0,0]
[null,"  Fish Meal",null,0,0,0]
[null,"  Plasma",null,0,0,0]
[null,"  Limestone ",null,16,16.5,14]
[null,"  Dical (16% Ca-21% P) ",null,11,11,7]
[null,"  Salt - 96% ",null,3.5,5,3.5]
[null,"  Phytase",null,0.5,0.5,0.5]
[null,"  L-Lysine HCL ",null,0,1,0]
[null,"  L-Threonine ",null,0,0,0]
[null,"  D L-Methionine ",null,0,0,0]
[null,"  Oats - Groats",null,0,0,0]
[null,"  Total Must Equal 1000kg",null,{"$f":"SUM(D32:D51)","v":1000},{"$f":"SUM(E32:E51)","v":1000},{"$f":"SUM(F32:F51)","v":1000}]
[]
[]
[null,null,null,"Pre Starter 1","Pre Starter 2","Starter 1","Starter 2"]
[null,null,null,"(kg)","(kg)","(kg)","(kg)"]
[null,{"$f":"B4","v":"  Wheat"},null,106,134.5,405,404]
[null,"  Barley ",null,0,0,0,65]
[null,"  Corn ",null,0,0,249,250]
[null,"  Soybean Meal ",null,120,130,200,227]
[null,"  Canola Meal",null,0,0,0,0]
[null,"  Peas ",null,0,0,0,0]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,5,5,5,5]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,0,0,0,0]
[null,"  Canola Oil ",null,27,19,11,0]
[null,"  Whey Powder ",null,121,125,70,0]
[null,"  Fish Meal",null,61,75,40,25]
[null,"  Plasma",null,59,0,0,0]
[null,"  Limestone ",null,12.5,12.5,7,11]
[null,"  Dical (16% Ca-21% P) ",null,10,10,8,8]
[null,"  Salt - 96% ",null,3.5,3.5,3.5,3.5]
[null,"  Phytase",null,0,0,0.5,0.5]
[null,"  L-Lysine HCL ",null,0.5,0.5,1,1]
[null,"  L-Threonine ",null,0,0,0,0]
[null,"  D L-Methionine ",null,0,0,0,0]
[null,"  Oats - Groats",null,474.5,485,0,0]
[null,"  Total Must Equal 1000kg",null,{"$f":"SUM(D57:D76)","v":1000},{"$f":"SUM(E57:E76)","v":1000},{"$f":"SUM(F57:F76)","v":1000},{"$f":"SUM(G57:G76)","v":1000}]
[]
[]
[null,"",null,"Starter","Grower","Finisher"]
[null,null,null,"Ration","Ration","Ration"]
[null,null,null,"(kg)","(kg)","(kg)"]
[null,{"$f":"B4","v":"  Wheat"},null,475,200,0]
[null,"  Barley ",null,215,597,834]
[null,"  Corn ",null,0,0,0]
[null,"  Soybean Meal ",null,175,75,0]
[null,"  Canola Meal",null,0,100,80]
[null,"  Peas ",null,100,0,70]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,0,0,0]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,3,3,3]
[null,"  Canola Oil ",null,10,8,0]
[null,"  Whey Powder ",null,0,0,0]
[null,"  Fish Meal",null,0,0,0]
[null,"  Plasma",null,0,0,0]
[null,"  Limestone ",null,12,10,8]
[null,"  Dical (16% Ca-21% P) ",null,5,2,1]
[null,"  Salt - 96% ",null,3.5,3.5,3.5]
[null,"  Phytase",null,0.5,0.5,0.5]
[null,"  L-Lysine HCL ",null,1,1,0]
[null,"  L-Threonine ",null,0,0,0]
[null,"  D L-Methionine ",null,0,0,0]
[null,"  Oats - Groats",null,0,0,0]
[null,"   Total Must Equal 1000kg",null,{"$f":"SUM(D83:D102)","v":1000},{"$f":"SUM(E83:E102)","v":1000},{"$f":"SUM(F83:F102)","v":1000}]
[]
[]
[null,"Total Feed Ingredients per Sow per Year --- Sow Barn"]
[null,null,null,"Dry","Nursing"]
[null,null,null,"Sow","Sow","Boar"]
[null,null,null,"Ration","Ration","Ration","Total","Total"]
[null,null,null,"(kg/sow/year)","(kg/sow/year)","(kg/boar/year)","(kg/sow/year)","(tonnes/year)"]
[null,{"$f":"B4","v":"  Wheat"},null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D32/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E32/1000)","v":97.910819999999987},{"$f":"(365*'Farrow Input'!$E$34*(F32/1000))","v":219},{"$f":"(((D111+E111)*'Farrow Input'!$G$13)+(F111*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":99.224819999999994},{"$f":"(G111*'Farrow Input'!$E$22)/1000","v":49.612409999999997}]
[null,"  Barley ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D33/1000)","v":815.00399300000004},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E33/1000)","v":151.43540159999998},{"$f":"(365*'Farrow Input'!$E$34*(F33/1000))","v":655.90499999999997},{"$f":"(((D112+E112)*'Farrow Input'!$G$13)+(F112*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":970.37482460000001},{"$f":"(G112*'Farrow Input'!$E$22)/1000","v":485.18741230000001}]
[null,"  Corn ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D34/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E34/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F34/1000))","v":0},{"$f":"(((D113+E113)*'Farrow Input'!$G$13)+(F113*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G113*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Soybean Meal ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D35/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E35/1000)","v":64.294771799999992},{"$f":"(365*'Farrow Input'!$E$34*(F35/1000))","v":0},{"$f":"(((D114+E114)*'Farrow Input'!$G$13)+(F114*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":64.294771799999992},{"$f":"(G114*'Farrow Input'!$E$22)/1000","v":32.147385899999996}]
[null,"  Canola Meal",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D36/1000)","v":80.849883000000005},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E36/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F36/1000))","v":87.600000000000009},{"$f":"(((D115+E115)*'Farrow Input'!$G$13)+(F115*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":81.375483000000003},{"$f":"(G115*'Farrow Input'!$E$22)/1000","v":40.687741500000001}]
[null,"  Peas ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D37/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E37/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F37/1000))","v":99.644999999999996},{"$f":"(((D116+E116)*'Farrow Input'!$G$13)+(F116*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0.59787000000000001},{"$f":"(G116*'Farrow Input'!$E$22)/1000","v":0.29893500000000001}]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D38/1000)","v":4.6465449999999997},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E38/1000)","v":1.631847},{"$f":"(365*'Farrow Input'!$E$34*(F38/1000))","v":5.4750000000000005},{"$f":"(((D117+E117)*'Farrow Input'!$G$13)+(F117*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":6.311242},{"$f":"(G117*'Farrow Input'!$E$22)/1000","v":3.155621}]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D39/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E39/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F39/1000))","v":0},{"$f":"(((D118+E118)*'Farrow Input'!$G$13)+(F118*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G118*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Canola Oil ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D40/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E40/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F40/1000))","v":0},{"$f":"(((D119+E119)*'Farrow Input'!$G$13)+(F119*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G119*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Whey Powder ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D41/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E41/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F41/1000))","v":0},{"$f":"(((D120+E120)*'Farrow Input'!$G$13)+(F120*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G120*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Fish Meal",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D42/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E42/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F42/1000))","v":0},{"$f":"(((D121+E121)*'Farrow Input'!$G$13)+(F121*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G121*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Plasma",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D43/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E43/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F43/1000))","v":0},{"$f":"(((D122+E122)*'Farrow Input'!$G$13)+(F122*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G122*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Limestone ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D44/1000)","v":14.868943999999999},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E44/1000)","v":5.3850950999999991},{"$f":"(365*'Farrow Input'!$E$34*(F44/1000))","v":15.33},{"$f":"(((D123+E123)*'Farrow Input'!$G$13)+(F123*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":20.346019100000003},{"$f":"(G123*'Farrow Input'!$E$22)/1000","v":10.173009550000002}]
[null,"  Dical (16% Ca-21% P) ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D45/1000)","v":10.222398999999999},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E45/1000)","v":3.5900634},{"$f":"(365*'Farrow Input'!$E$34*(F45/1000))","v":7.665},{"$f":"(((D124+E124)*'Farrow Input'!$G$13)+(F124*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":13.858452399999999},{"$f":"(G124*'Farrow Input'!$E$22)/1000","v":6.9292261999999996}]
[null,"  Salt - 96% ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D46/1000)","v":3.2525814999999998},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E46/1000)","v":1.631847},{"$f":"(365*'Farrow Input'!$E$34*(F46/1000))","v":3.8325},{"$f":"(((D125+E125)*'Farrow Input'!$G$13)+(F125*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":4.9074235000000002},{"$f":"(G125*'Farrow Input'!$E$22)/1000","v":2.4537117500000001}]
[null,"  Phytase",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D47/1000)","v":0.46465449999999997},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E47/1000)","v":0.16318469999999999},{"$f":"(365*'Farrow Input'!$E$34*(F47/1000))","v":0.54749999999999999},{"$f":"(((D126+E126)*'Farrow Input'!$G$13)+(F126*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0.63112419999999991},{"$f":"(G126*'Farrow Input'!$E$22)/1000","v":0.31556209999999996}]
[null,"  L-Lysine HCL ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D48/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E48/1000)","v":0.32636939999999998},{"$f":"(365*'Farrow Input'!$E$34*(F48/1000))","v":0},{"$f":"(((D127+E127)*'Farrow Input'!$G$13)+(F127*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0.32636939999999998},{"$f":"(G127*'Farrow Input'!$E$22)/1000","v":0.16318469999999999}]
[null,"  L-Threonine ",null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D49/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E49/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F49/1000))","v":0},{"$f":"(((D128+E128)*'Farrow Input'!$G$13)+(F128*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G128*'Farrow Input'!$E$22)/1000","v":0}]
[null,{"$f":"B23","v":"  Oats - Groats"},null,{"$f":"((365-'Farrow Finish Worksheet'!$D$11)*'Farrow Input'!$E$32*D50/1000)","v":0},{"$f":"('Farrow Input'!$G$16*'Farrow Input'!$G$15*'Farrow Input'!$E$33*E50/1000)","v":0},{"$f":"(365*'Farrow Input'!$E$34*(F50/1000))","v":0},{"$f":"(((D129+E129)*'Farrow Input'!$G$13)+(F129*'Farrow Input'!$G$14))/'Farrow Input'!$G$13","v":0},{"$f":"(G129*'Farrow Input'!$E$22)/1000","v":0}]
[null,"  Total Ration Used (kg/sow/year)",null,{"$f":"SUM(D111:D129)","v":929.30900000000008},{"$f":"SUM(E111:E129)","v":326.36939999999993},{"$f":"SUM(F111:F129)","v":1094.9999999999998},{"$f":"SUM(G111:G129)","v":1262.2483999999999},{"$f":"SUM(H111:H129)","v":631.12419999999997}]
[]
[null,"Total Feed Ingredients per Weanling per Year -- Nursery Barn"]
[]
[null,null,null,{"$f":"D55","v":"Pre Starter 1"},{"$f":"E55","v":"Pre Starter 2"},{"$f":"F55","v":"Starter 1"},{"$f":"G55","v":"Starter 2"},"Total","Total"]
[null,null,null,"(kg/weanling/yr)","(kg/weanling/yr)","(kg/weanling/yr)","(kg/weanling/yr)","(kg/weanling/yr)","(tonnes/yr)"]
[null,{"$f":"B4","v":"  Wheat"},null,{"$f":"('Farrow Input'!$E$35*D57/1000)","v":6.148E-2},{"$f":"('Farrow Input'!$E$36*E57/1000)","v":0.39005000000000001},{"$f":"('Farrow Finish Worksheet'!$D$137*F57/1000)","v":6.48},{"$f":"('Farrow Finish Worksheet'!$D$114*G57/1000)","v":3.6360000000000001},{"$f":"SUM(D136:G136)","v":10.567530000000001},{"$f":"(H136*'Farrow Input'!$E$27)/1000","v":148.54776921000004}]
[null,"  Barley ",null,{"$f":"('Farrow Input'!$E$35*D58/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E58/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F58/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G58/1000)","v":0.58499999999999996},{"$f":"SUM(D137:G137)","v":0.58499999999999996},{"$f":"(H137*'Farrow Input'!$E$27)/1000","v":8.2233450000000001}]
[null,"  Corn ",null,{"$f":"('Farrow Input'!$E$35*D59/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E59/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F59/1000)","v":3.984},{"$f":"('Farrow Finish Worksheet'!$D$114*G59/1000)","v":2.25},6.234,{"$f":"(H138*'Farrow Input'!$E$27)/1000","v":87.631338}]
[null,"  Soybean Meal ",null,{"$f":"('Farrow Input'!$E$35*D60/1000)","v":6.9599999999999995E-2},{"$f":"('Farrow Input'!$E$36*E60/1000)","v":0.377},{"$f":"('Farrow Finish Worksheet'!$D$137*F60/1000)","v":3.2},{"$f":"('Farrow Finish Worksheet'!$D$114*G60/1000)","v":2.0430000000000001},5.6896000000000004,{"$f":"(H139*'Farrow Input'!$E$27)/1000","v":79.978707200000002}]
[null,"  Canola Meal",null,{"$f":"('Farrow Input'!$E$35*D61/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E61/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F61/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G61/1000)","v":0},0,{"$f":"(H140*'Farrow Input'!$E$27)/1000","v":0}]
[null,"  Peas ",null,{"$f":"('Farrow Input'!$E$35*D62/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E62/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F62/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G62/1000)","v":0},0,{"$f":"(H141*'Farrow Input'!$E$27)/1000","v":0}]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,{"$f":"('Farrow Input'!$E$35*D63/1000)","v":2.8999999999999998E-3},{"$f":"('Farrow Input'!$E$36*E63/1000)","v":1.4500000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$137*F63/1000)","v":0.08},{"$f":"('Farrow Finish Worksheet'!$D$114*G63/1000)","v":4.4999999999999998E-2},0.1424,{"$f":"(H142*'Farrow Input'!$E$27)/1000","v":2.0017168000000001}]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,{"$f":"('Farrow Input'!$E$35*D64/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E64/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F64/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G64/1000)","v":0},0,{"$f":"(H143*'Farrow Input'!$E$27)/1000","v":0}]
[null,"  Canola Oil ",null,{"$f":"('Farrow Input'!$E$35*D65/1000)","v":1.5659999999999997E-2},{"$f":"('Farrow Input'!$E$36*E65/1000)","v":5.5100000000000003E-2},{"$f":"('Farrow Finish Worksheet'!$D$137*F65/1000)","v":0.17599999999999999},{"$f":"('Farrow Finish Worksheet'!$D$114*G65/1000)","v":0},0.24675999999999998,{"$f":"(H144*'Farrow Input'!$E$27)/1000","v":3.4687053199999998}]
[null,"  Whey Powder ",null,{"$f":"('Farrow Input'!$E$35*D66/1000)","v":7.0179999999999992E-2},{"$f":"('Farrow Input'!$E$36*E66/1000)","v":0.36249999999999999},{"$f":"('Farrow Finish Worksheet'!$D$137*F66/1000)","v":1.1200000000000001},{"$f":"('Farrow Finish Worksheet'!$D$114*G66/1000)","v":0},1.5526800000000001,{"$f":"(H145*'Farrow Input'!$E$27)/1000","v":21.826022760000001}]
[null,"  Fish Meal",null,{"$f":"('Farrow Input'!$E$35*D67/1000)","v":3.5379999999999995E-2},{"$f":"('Farrow Input'!$E$36*E67/1000)","v":0.2175},{"$f":"('Farrow Finish Worksheet'!$D$137*F67/1000)","v":0.64},{"$f":"('Farrow Finish Worksheet'!$D$114*G67/1000)","v":0.22500000000000001},1.11788,{"$f":"(H146*'Farrow Input'!$E$27)/1000","v":15.71403916}]
[null,"  Plasma",null,{"$f":"('Farrow Input'!$E$35*D68/1000)","v":3.422E-2},{"$f":"('Farrow Input'!$E$36*E68/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F68/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G68/1000)","v":0},3.422E-2,{"$f":"(H147*'Farrow Input'!$E$27)/1000","v":0.48103054000000001}]
[null,"  Limestone ",null,{"$f":"('Farrow Input'!$E$35*D69/1000)","v":7.2499999999999995E-3},{"$f":"('Farrow Input'!$E$36*E69/1000)","v":3.6249999999999998E-2},{"$f":"('Farrow Finish Worksheet'!$D$137*F69/1000)","v":0.112},{"$f":"('Farrow Finish Worksheet'!$D$114*G69/1000)","v":9.9000000000000005E-2},0.2545,{"$f":"(H148*'Farrow Input'!$E$27)/1000","v":3.5775065000000001}]
[null,"  Dical (16% Ca-21% P) ",null,{"$f":"('Farrow Input'!$E$35*D70/1000)","v":5.7999999999999996E-3},{"$f":"('Farrow Input'!$E$36*E70/1000)","v":2.9000000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$137*F70/1000)","v":0.128},{"$f":"('Farrow Finish Worksheet'!$D$114*G70/1000)","v":7.1999999999999995E-2},0.23480000000000001,{"$f":"(H149*'Farrow Input'!$E$27)/1000","v":3.3005836}]
[null,"  Salt - 96% ",null,{"$f":"('Farrow Input'!$E$35*D71/1000)","v":2.0299999999999997E-3},{"$f":"('Farrow Input'!$E$36*E71/1000)","v":1.0150000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$137*F71/1000)","v":5.6000000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$114*G71/1000)","v":3.15E-2},9.9680000000000005E-2,{"$f":"(H150*'Farrow Input'!$E$27)/1000","v":1.4012017600000002}]
[null,"  Phytase",null,{"$f":"('Farrow Input'!$E$35*D72/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E72/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F72/1000)","v":8.0000000000000002E-3},{"$f":"('Farrow Finish Worksheet'!$D$114*G72/1000)","v":4.4999999999999997E-3},1.2500000000000001E-2,{"$f":"(H151*'Farrow Input'!$E$27)/1000","v":0.17571249999999999}]
[null,"  L-Lysine HCL ",null,{"$f":"('Farrow Input'!$E$35*D73/1000)","v":2.9E-4},{"$f":"('Farrow Input'!$E$36*E73/1000)","v":1.4499999999999999E-3},{"$f":"('Farrow Finish Worksheet'!$D$137*F73/1000)","v":1.6E-2},{"$f":"('Farrow Finish Worksheet'!$D$114*G73/1000)","v":8.9999999999999993E-3},2.674E-2,{"$f":"(H152*'Farrow Input'!$E$27)/1000","v":0.37588418000000001}]
[null,"  L-Threonine ",null,{"$f":"('Farrow Input'!$E$35*D74/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E74/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F74/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G74/1000)","v":0},0,{"$f":"(H153*'Farrow Input'!$E$27)/1000","v":0}]
[null,{"$f":"B23","v":"  Oats - Groats"},null,{"$f":"('Farrow Input'!$E$35*D75/1000)","v":0},{"$f":"('Farrow Input'!$E$36*E75/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$137*F75/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$114*G75/1000)","v":0},0,{"$f":"(H154*'Farrow Input'!$E$27)/1000","v":0}]
[null,"  Total Ration Used (kgs)",null,{"$f":"SUM(D136:D154)","v":0.30479000000000001},1.4934999999999998,16,8.9999999999999982,26.798289999999994,376.70356253000006]
[]
[]
[null,"Total Feed Ingredients per Feeder Pig per Year -- Grower-Finisher Barn"]
[null,null,null,{"$f":"D80","v":"Starter"},"Grower","Finisher"]
[null,null,null,"Ration","Ration","Ration","Total","Total"]
[null,null,null,"(kg/feeder/yr)","(kg/feeder/yr)","(kg/feeder/yr)","(kg/feeder/yr)","(tonnes/yr)"]
[null,{"$f":"B4","v":"  Wheat"},null,{"$f":"('Farrow Finish Worksheet'!$D$158*D83/1000)","v":12.967499999999999},{"$f":"('Farrow Finish Worksheet'!$D$173*E83/1000)","v":33},{"$f":"('Farrow Finish Worksheet'!$D$188*F83/1000)","v":0},{"$f":"SUM(D162:F162)","v":45.967500000000001},{"$f":"(G162*'Farrow Input'!$E$29)/1000","v":630.39829500000008}]
[null,"  Barley ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D84/1000)","v":5.8695000000000004},{"$f":"('Farrow Finish Worksheet'!$D$173*E84/1000)","v":98.504999999999995},{"$f":"('Farrow Finish Worksheet'!$D$188*F84/1000)","v":75.894000000000005},180.26850000000002,{"$f":"(G163*'Farrow Input'!$E$29)/1000","v":2472.202209}]
[null,"  Corn ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D85/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E85/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F85/1000)","v":0},0,{"$f":"(G164*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  Soybean Meal ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D86/1000)","v":4.7774999999999999},{"$f":"('Farrow Finish Worksheet'!$D$173*E86/1000)","v":12.375},{"$f":"('Farrow Finish Worksheet'!$D$188*F86/1000)","v":0},17.1525,{"$f":"(G165*'Farrow Input'!$E$29)/1000","v":235.22938500000001}]
[null,"  Canola Meal",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D87/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E87/1000)","v":16.5},{"$f":"('Farrow Finish Worksheet'!$D$188*F87/1000)","v":7.28},23.78,{"$f":"(G166*'Farrow Input'!$E$29)/1000","v":326.11892000000006}]
[null,"  Peas ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D88/1000)","v":2.73},{"$f":"('Farrow Finish Worksheet'!$D$173*E88/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F88/1000)","v":6.37},9.1,{"$f":"(G167*'Farrow Input'!$E$29)/1000","v":124.7974}]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,{"$f":"('Farrow Finish Worksheet'!$D$158*D89/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E89/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F89/1000)","v":0},0,{"$f":"(G168*'Farrow Input'!$E$29)/1000","v":0}]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,{"$f":"('Farrow Finish Worksheet'!$D$158*D90/1000)","v":8.1900000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$173*E90/1000)","v":0.495},{"$f":"('Farrow Finish Worksheet'!$D$188*F90/1000)","v":0.27300000000000002},0.84989999999999999,{"$f":"(G169*'Farrow Input'!$E$29)/1000","v":11.6555286}]
[null,"  Canola Oil ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D91/1000)","v":0.27300000000000002},{"$f":"('Farrow Finish Worksheet'!$D$173*E91/1000)","v":1.32},{"$f":"('Farrow Finish Worksheet'!$D$188*F91/1000)","v":0},1.593,{"$f":"(G170*'Farrow Input'!$E$29)/1000","v":21.846401999999998}]
[null,"  Whey Powder ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D92/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E92/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F92/1000)","v":0},0,{"$f":"(G171*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  Fish Meal",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D93/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E93/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F93/1000)","v":0},0,{"$f":"(G172*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  Plasma",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D94/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E94/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F94/1000)","v":0},0,{"$f":"(G173*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  Limestone ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D95/1000)","v":0.3276},{"$f":"('Farrow Finish Worksheet'!$D$173*E95/1000)","v":1.65},{"$f":"('Farrow Finish Worksheet'!$D$188*F95/1000)","v":0.72799999999999998},2.7055999999999996,{"$f":"(G174*'Farrow Input'!$E$29)/1000","v":37.104598399999993}]
[null,"  Dical (16% Ca-21% P) ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D96/1000)","v":0.13650000000000001},{"$f":"('Farrow Finish Worksheet'!$D$173*E96/1000)","v":0.33},{"$f":"('Farrow Finish Worksheet'!$D$188*F96/1000)","v":9.0999999999999998E-2},0.5575,{"$f":"(G175*'Farrow Input'!$E$29)/1000","v":7.6455549999999999}]
[null,"  Salt - 96% ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D97/1000)","v":9.5549999999999996E-2},{"$f":"('Farrow Finish Worksheet'!$D$173*E97/1000)","v":0.57750000000000001},{"$f":"('Farrow Finish Worksheet'!$D$188*F97/1000)","v":0.31850000000000001},0.99155000000000004,{"$f":"(G176*'Farrow Input'!$E$29)/1000","v":13.5981167}]
[null,"  Phytase",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D98/1000)","v":1.3650000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$173*E98/1000)","v":8.2500000000000004E-2},{"$f":"('Farrow Finish Worksheet'!$D$188*F98/1000)","v":4.5499999999999999E-2},0.14165,{"$f":"(G177*'Farrow Input'!$E$29)/1000","v":1.9425881}]
[null,"  L-Lysine HCL ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D99/1000)","v":2.7300000000000001E-2},{"$f":"('Farrow Finish Worksheet'!$D$173*E99/1000)","v":0.16500000000000001},{"$f":"('Farrow Finish Worksheet'!$D$188*F99/1000)","v":0},0.1923,{"$f":"(G178*'Farrow Input'!$E$29)/1000","v":2.6372022000000004}]
[null,"  L-Threonine ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D100/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E100/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F100/1000)","v":0},0,{"$f":"(G179*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  D L-Methionine ",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D101/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E101/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F101/1000)","v":0},0,{"$f":"(G180*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  Oats - Groats",null,{"$f":"('Farrow Finish Worksheet'!$D$158*D102/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$173*E102/1000)","v":0},{"$f":"('Farrow Finish Worksheet'!$D$188*F102/1000)","v":0},0,{"$f":"(G181*'Farrow Input'!$E$29)/1000","v":0}]
[null,"  Total Ration Used (kgs)",null,{"$f":"SUM(D162:D181)","v":27.3},{"$f":"SUM(E162:E181)","v":165},{"$f":"SUM(F162:F181)","v":91},{"$f":"SUM(G162:G181)","v":283.30000000000007},{"$f":"SUM(H162:H181)","v":3885.1762000000003}]
[]
[]
[null,"Summary of Feed Ingredients Used For A Farrow-Weanling Operation"]
[null,"Number of sows",null,{"$f":"'Farrow Input'!G13","v":500}]
[null,"Weanlings sold/sow",null,{"$f":"'Farrow Input'!F29","v":27.43}]
[null,null,null,"Total","Total","Total"]
[null,null,null,"per Year","per Month","per Sow"]
[null,null,null,"(tonnes)","(tonnes)","(kg/sow/year)"]
[null,{"$f":"B4","v":"  Wheat"},null,{"$f":"($D$186*G111/1000)+($D$187*$D$186*H136/1000)","v":194.54608395000002},{"$f":"D191/12","v":16.212173662500003},{"$f":"D191/$D$186*1000","v":389.09216790000005}]
[null,"  Barley ",null,493.21068730000002,41.100890608333337,986.42137460000004]
[null,"  Corn ",null,85.499309999999994,7.1249424999999995,170.99861999999999]
[null,"  Soybean Meal ",null,110.18024990000001,9.1816874916666666,220.36049980000001]
[null,"  Canola Meal",null,40.687741500000001,3.3906451250000003,81.375483000000003]
[null,"  Peas ",null,0.29893500000000001,2.4911249999999999E-2,0.59787000000000001]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,5.1086369999999999,0.42571975000000001,10.217274]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,0,0,0]
[null,"  Canola Oil ",null,3.3843133999999995,0.2820261166666666,6.7686267999999989]
[null,"  Whey Powder ",null,21.2950062,1.77458385,42.590012399999999]
[null,"  Fish Meal",null,15.3317242,1.2776436833333333,30.6634484]
[null,"  Plasma",null,0.4693273,3.9110608333333331E-2,0.93865460000000001]
[null,"  Limestone ",null,13.663477050000001,1.1386230875000001,27.326954100000002]
[null,"  Dical (16% Ca-21% P) ",null,10.1495082,0.84579234999999997,20.299016399999999]
[null,"  Salt - 96% ",null,3.8208229500000002,0.3184019125,7.6416459000000003]
[null,"  Phytase",null,0.48699959999999998,4.0583299999999996E-2,0.97399919999999995]
[null,"  L-Lysine HCL ",null,0.52992379999999994,4.4160316666666664E-2,1.0598475999999999]
[null,"  L-Threonine ",null,0,0,0]
[null,"  D L-Methionine ",null,0,0,0]
[null,"  Oats - Groats",null,998.6627473499999,83.221895612499992,1997.3254946999998]
[null,"  Total Ration Used  (tonnes)",null,{"$f":"SUM(D191:D210)","v":1997.3254947},{"$f":"SUM(E191:E210)","v":166.44379122499998},{"$f":"SUM(F191:F210)","v":3994.6509894000001}]
[]
[null,null,null," "]
[null,"Summary of Feed Ingredients Used For A Grower-Finisher Operation"]
[]
[null,"Total Market Hogs Sold",null,{"$f":"'Farrow Input'!F79","v":13001.8212}]
[null," ",null,"Total","Total","Total"]
[null," ",null,"per Year","per Month","per Hog"]
[null,null,null,"(tonnes)","(tonnes)","(kg/hog/year)"]
[null,{"$f":"B4","v":"  Wheat"},null,{"$f":"F220*$D$216/1000","v":597.66121601099996},{"$f":"D220/12","v":49.805101334249997},{"$f":"G162","v":45.967500000000001}]
[null,"  Barley ",null,2343.8188049922005,195.31823374935004,180.26850000000002]
[null,"  Corn ",null,0,0,0]
[null,"  Soybean Meal ",null,223.013738133,18.58447817775,17.1525]
[null,"  Canola Meal",null,309.18330813599999,25.765275677999998,23.78]
[null,"  Peas ",null,118.31657291999998,9.8597144099999987,9.1]
[null,{"$f":"B10","v":"  Sow Micro Premix "},null,0,0,{"$f":"G168","v":0}]
[null,{"$f":"B11","v":"  Grower Micro Premix "},null,11.050247837880001,0.92085398649000005,0.84989999999999999]
[null,"  Canola Oil ",null,20.711901171599997,1.7259917642999998,1.593]
[null,"  Whey Powder ",null,0,0,0]
[null,"  Fish Meal",null,0,0,0]
[null,"  Plasma",null,0,0,0]
[null,"  Limestone ",null,35.177727438719991,2.9314772865599994,2.7055999999999996]
[null,"  Dical (16% Ca-21% P) ",null,7.248515319,0.60404294324999996,0.5575]
[null,"  Salt - 96% ",null,12.891955810860001,1.074329650905,0.99155000000000004]
[null,"  Phytase",null,1.8417079729800001,0.15347566441500002,0.14165]
[null,"  L-Lysine HCL ",null,{"$f":"F236*$D$216/1000","v":2.50025021676},{"$f":"D236/12","v":0.20835418473},{"$f":"G178","v":0.1923}]
[null,"  L-Threonine ",null,{"$f":"F237*$D$216/1000","v":0},{"$f":"D237/12","v":0},{"$f":"G179","v":0}]
[null,"  D L-Methionine ",null,{"$f":"F238*$D$216/1000","v":0},{"$f":"D238/12","v":0},{"$f":"G180","v":0}]
[null,"  Oats - Groats",null,{"$f":"F239*$D$216/1000","v":0},{"$f":"D239/12","v":0},{"$f":"G181","v":0}]
[null,"  Total Ration Used  (tonnes)",null,{"$f":"SUM(D220:D239)","v":3683.4159459600005},{"$f":"SUM(E220:E239)","v":306.95132883000002},{"$f":"SUM(F220:F239)","v":283.30000000000007}]

{"sheet":"Feed-Summary","index":6,"n_rows":263,"n_cols":10,"rows_kept":263,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
[]
["Feed Requirement and Cost Summary"]
[null,null,null,"Amount",null,"    Price",null,"Ration Cost"]
[null,null,null,"(kg)",null,"($ /tonne)",null,"($ /tonne)",null,"Your Cost"]
["Sow Gestation"]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!D32=0,\" \",'Feed Input'!D32)","v":" "},null,{"$f":"IF('Feed Input'!D32=0,\" \",'Feed Input'!E4)","v":" "},null,{"$f":"IF('Feed Input'!D32=0,\" \",ROUND((D6/1000)*F6,2))","v":" "}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!D33=0,\" \",'Feed Input'!D33)","v":877},null,{"$f":"IF('Feed Input'!D33=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!D33=0,\" \",ROUND((D7/1000)*F7,2))","v":280.64}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!D34=0,\" \",'Feed Input'!D34)","v":" "},null,{"$f":"IF('Feed Input'!D34=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!D34=0,\" \",ROUND((D8/1000)*F8,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!D35=0,\" \",'Feed Input'!D35)","v":" "},null,{"$f":"IF('Feed Input'!D35=0,\" \",'Feed Input'!E7)","v":" "},null,{"$f":"IF('Feed Input'!D35=0,\" \",ROUND((D9/1000)*F9,2))","v":" "}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!D36=0,\" \",'Feed Input'!D36)","v":87},null,{"$f":"IF('Feed Input'!D36=0,\" \",'Feed Input'!E8)","v":425},null,{"$f":"IF('Feed Input'!D36=0,\" \",ROUND((D10/1000)*F10,2))","v":36.979999999999997}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!D37=0,\" \",'Feed Input'!D37)","v":" "},null,{"$f":"IF('Feed Input'!D37=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!D37=0,\" \",ROUND((D11/1000)*F11,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!D38=0,\" \",'Feed Input'!D38)","v":5},null,{"$f":"IF('Feed Input'!D38=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!D38=0,\" \",ROUND((D12/1000)*F12,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!D39=0,\" \",'Feed Input'!D39)","v":" "},null,{"$f":"IF('Feed Input'!D39=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!D39=0,\" \",ROUND((D13/1000)*F13,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!D40=0,\" \",'Feed Input'!D40)","v":" "},null,{"$f":"IF('Feed Input'!D40=0,\" \",'Feed Input'!E12)","v":" "},null,{"$f":"IF('Feed Input'!D40=0,\" \",ROUND((D14/1000)*F14,2))","v":" "}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!D41=0,\" \",'Feed Input'!D41)","v":" "},null,{"$f":"IF('Feed Input'!D41=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!D41=0,\" \",ROUND((D15/1000)*F15,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!D42=0,\" \",'Feed Input'!D42)","v":" "},null,{"$f":"IF('Feed Input'!D42=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!D42=0,\" \",ROUND((D16/1000)*F16,2))","v":" "}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!D43=0,\" \",'Feed Input'!D43)","v":" "},null,{"$f":"IF('Feed Input'!D43=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!D43=0,\" \",ROUND((D17/1000)*F17,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!D44=0,\" \",'Feed Input'!D44)","v":16},null,{"$f":"IF('Feed Input'!D44=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!D44=0,\" \",ROUND((D18/1000)*F18,2))","v":3.26}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!D45=0,\" \",'Feed Input'!D45)","v":11},null,{"$f":"IF('Feed Input'!D45=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!D45=0,\" \",ROUND((D19/1000)*F19,2))","v":16.989999999999998}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!D46=0,\" \",'Feed Input'!D46)","v":3.5},null,{"$f":"IF('Feed Input'!D46=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!D46=0,\" \",ROUND((D20/1000)*F20,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!D47=0,\" \",'Feed Input'!D47)","v":0.5},null,{"$f":"IF('Feed Input'!D47=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!D47=0,\" \",ROUND((D21/1000)*F21,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!D48=0,\" \",'Feed Input'!D48)","v":" "},null,{"$f":"IF('Feed Input'!D48=0,\" \",'Feed Input'!E20)","v":" "},null,{"$f":"IF('Feed Input'!D48=0,\" \",ROUND((D22/1000)*F22,2))","v":" "}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!D49=0,\" \",'Feed Input'!D49)","v":" "},null,{"$f":"IF('Feed Input'!D49=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!D49=0,\" \",ROUND((D23/1000)*F23,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!D50=0,\" \",'Feed Input'!D50)","v":" "},null,{"$f":"IF('Feed Input'!D50=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!D50=0,\" \",ROUND((D24/1000)*F24,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!D51=0,\" \",'Feed Input'!D51)","v":" "},null,{"$f":"IF('Feed Input'!D51=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!D51=0,\" \",ROUND((D25/1000)*F25,2))","v":" "}]
["Total Sow Gestation:",null,null,{"$f":"SUM(D6:D25)","v":1000},null,null,null,{"$f":"SUM(H6:H25)","v":366.04}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H26+(F27/100*H26)","v":370.6155}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H27=0,0,H27+F28)","v":380.6155}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H28+F29","v":390.6155}]
[]
["Sow Lactation"]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!E32=0,\" \",'Feed Input'!E32)","v":300},null,{"$f":"IF('Feed Input'!E32=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!E32=0,\" \",ROUND((D32/1000)*F32,2))","v":111}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!E33=0,\" \",'Feed Input'!E33)","v":464},null,{"$f":"IF('Feed Input'!E33=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!E33=0,\" \",ROUND((D33/1000)*F33,2))","v":148.47999999999999}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!E34=0,\" \",'Feed Input'!E34)","v":" "},null,{"$f":"IF('Feed Input'!E34=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!E34=0,\" \",ROUND((D34/1000)*F34,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!E35=0,\" \",'Feed Input'!E35)","v":197},null,{"$f":"IF('Feed Input'!E35=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!E35=0,\" \",ROUND((D35/1000)*F35,2))","v":131.01}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!E36=0,\" \",'Feed Input'!E36)","v":" "},null,{"$f":"IF('Feed Input'!E36=0,\" \",'Feed Input'!E8)","v":" "},null,{"$f":"IF('Feed Input'!E36=0,\" \",ROUND((D36/1000)*F36,2))","v":" "}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!E37=0,\" \",'Feed Input'!E37)","v":" "},null,{"$f":"IF('Feed Input'!E37=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!E37=0,\" \",ROUND((D37/1000)*F37,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!E38=0,\" \",'Feed Input'!E38)","v":5},null,{"$f":"IF('Feed Input'!E38=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!E38=0,\" \",ROUND((D38/1000)*F38,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!E39=0,\" \",'Feed Input'!E39)","v":" "},null,{"$f":"IF('Feed Input'!E39=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!E39=0,\" \",ROUND((D39/1000)*F39,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!E40=0,\" \",'Feed Input'!E40)","v":" "},null,{"$f":"IF('Feed Input'!E40=0,\" \",'Feed Input'!E12)","v":" "},null,{"$f":"IF('Feed Input'!E40=0,\" \",ROUND((D40/1000)*F40,2))","v":" "}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!E41=0,\" \",'Feed Input'!E41)","v":" "},null,{"$f":"IF('Feed Input'!E41=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!E41=0,\" \",ROUND((D41/1000)*F41,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!E42=0,\" \",'Feed Input'!E42)","v":" "},null,{"$f":"IF('Feed Input'!E42=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!E42=0,\" \",ROUND((D42/1000)*F42,2))","v":" "}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!E43=0,\" \",'Feed Input'!E43)","v":" "},null,{"$f":"IF('Feed Input'!E43=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!E43=0,\" \",ROUND((D43/1000)*F43,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!E44=0,\" \",'Feed Input'!E44)","v":16.5},null,{"$f":"IF('Feed Input'!E44=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!E44=0,\" \",ROUND((D44/1000)*F44,2))","v":3.37}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!E45=0,\" \",'Feed Input'!E45)","v":11},null,{"$f":"IF('Feed Input'!E45=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!E45=0,\" \",ROUND((D45/1000)*F45,2))","v":16.989999999999998}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!E46=0,\" \",'Feed Input'!E46)","v":5},null,{"$f":"IF('Feed Input'!E46=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!E46=0,\" \",ROUND((D46/1000)*F46,2))","v":1.31}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!E47=0,\" \",'Feed Input'!E47)","v":0.5},null,{"$f":"IF('Feed Input'!E47=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!E47=0,\" \",ROUND((D47/1000)*F47,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!E48=0,\" \",'Feed Input'!E48)","v":1},null,{"$f":"IF('Feed Input'!E48=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!E48=0,\" \",ROUND((D48/1000)*F48,2))","v":2.25}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!E49=0,\" \",'Feed Input'!E49)","v":" "},null,{"$f":"IF('Feed Input'!E49=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!E49=0,\" \",ROUND((D49/1000)*F49,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!E50=0,\" \",'Feed Input'!E50)","v":" "},null,{"$f":"IF('Feed Input'!E50=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!E50=0,\" \",ROUND((D50/1000)*F50,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!E51=0,\" \",'Feed Input'!E51)","v":" "},null,{"$f":"IF('Feed Input'!E51=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!E51=0,\" \",ROUND((D51/1000)*F51,2))","v":" "}]
["Total Sow Lactation:",null,null,{"$f":"SUM(D32:D51)","v":1000},"kg",null,null,{"$f":"SUM(H32:H51)","v":441.66}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H52+(F53*H52/100)","v":447.18075000000005}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H53=0,0,H53+F54)","v":457.18075000000005}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H54+F55","v":467.18075000000005}]
[]
["Boar Ration:"]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!F32=0,\" \",'Feed Input'!F32)","v":200},null,{"$f":"IF('Feed Input'!F32=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!F32=0,\" \",ROUND((D58/1000)*F58,2))","v":74}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!F33=0,\" \",'Feed Input'!F33)","v":599},null,{"$f":"IF('Feed Input'!F33=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!F33=0,\" \",ROUND((D59/1000)*F59,2))","v":191.68}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!F34=0,\" \",'Feed Input'!F34)","v":" "},null,{"$f":"IF('Feed Input'!F34=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!F34=0,\" \",ROUND((D60/1000)*F60,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!F35=0,\" \",'Feed Input'!F35)","v":" "},null,{"$f":"IF('Feed Input'!F35=0,\" \",'Feed Input'!E7)","v":" "},null,{"$f":"IF('Feed Input'!F35=0,\" \",ROUND((D61/1000)*F61,2))","v":" "}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!F36=0,\" \",'Feed Input'!F36)","v":80},null,{"$f":"IF('Feed Input'!F36=0,\" \",'Feed Input'!E8)","v":425},null,{"$f":"IF('Feed Input'!F36=0,\" \",ROUND((D62/1000)*F62,2))","v":34}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!F37=0,\" \",'Feed Input'!F37)","v":91},null,{"$f":"IF('Feed Input'!F37=0,\" \",'Feed Input'!E9)","v":390},null,{"$f":"IF('Feed Input'!F37=0,\" \",ROUND((D63/1000)*F63,2))","v":35.49}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!F38=0,\" \",'Feed Input'!F38)","v":5},null,{"$f":"IF('Feed Input'!F38=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!F38=0,\" \",ROUND((D64/1000)*F64,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!F39=0,\" \",'Feed Input'!F39)","v":" "},null,{"$f":"IF('Feed Input'!F39=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!F39=0,\" \",ROUND((D65/1000)*F65,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!F40=0,\" \",'Feed Input'!F40)","v":" "},null,{"$f":"IF('Feed Input'!F40=0,\" \",'Feed Input'!E12)","v":" "},null,{"$f":"IF('Feed Input'!F40=0,\" \",ROUND((D66/1000)*F66,2))","v":" "}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!F41=0,\" \",'Feed Input'!F41)","v":" "},null,{"$f":"IF('Feed Input'!F41=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!F41=0,\" \",ROUND((D67/1000)*F67,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!F42=0,\" \",'Feed Input'!F42)","v":" "},null,{"$f":"IF('Feed Input'!F42=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!F42=0,\" \",ROUND((D68/1000)*F68,2))","v":" "}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!F43=0,\" \",'Feed Input'!F43)","v":" "},null,{"$f":"IF('Feed Input'!F43=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!F43=0,\" \",ROUND((D69/1000)*F69,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!F44=0,\" \",'Feed Input'!F44)","v":14},null,{"$f":"IF('Feed Input'!F44=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!F44=0,\" \",ROUND((D70/1000)*F70,2))","v":2.86}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!F45=0,\" \",'Feed Input'!F45)","v":7},null,{"$f":"IF('Feed Input'!F45=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!F45=0,\" \",ROUND((D71/1000)*F71,2))","v":10.81}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!F46=0,\" \",'Feed Input'!F46)","v":3.5},null,{"$f":"IF('Feed Input'!F46=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!F46=0,\" \",ROUND((D72/1000)*F72,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!F47=0,\" \",'Feed Input'!F47)","v":0.5},null,{"$f":"IF('Feed Input'!F47=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!F47=0,\" \",ROUND((D73/1000)*F73,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!F48=0,\" \",'Feed Input'!F48)","v":" "},null,{"$f":"IF('Feed Input'!F48=0,\" \",'Feed Input'!E20)","v":" "},null,{"$f":"IF('Feed Input'!F48=0,\" \",ROUND((D74/1000)*F74,2))","v":" "}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!F49=0,\" \",'Feed Input'!F49)","v":" "},null,{"$f":"IF('Feed Input'!F49=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!F49=0,\" \",ROUND((D75/1000)*F75,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!F50=0,\" \",'Feed Input'!F50)","v":" "},null,{"$f":"IF('Feed Input'!F50=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!F50=0,\" \",ROUND((D76/1000)*F76,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!F51=0,\" \",'Feed Input'!F51)","v":" "},null,{"$f":"IF('Feed Input'!F51=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!F51=0,\" \",ROUND((D77/1000)*F77,2))","v":" "}]
["Total Boar:",null,null,{"$f":"SUM(D58:D77)","v":1000},"kg",null,null,{"$f":"SUM(H58:H77)","v":377.01000000000005}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H78+(F79*H78/100)","v":381.72262500000005}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H79=0,0,H79+F80)","v":391.72262500000005}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H80+F81","v":401.72262500000005}]
[]
[{"$f":"'Feed Input'!D55","v":"Pre Starter 1"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!D57=0,\" \",'Feed Input'!D57)","v":106},null,{"$f":"IF('Feed Input'!D57=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!D57=0,\" \",ROUND((D84/1000)*F84,2))","v":39.22}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!D58=0,\" \",'Feed Input'!D58)","v":" "},null,{"$f":"IF('Feed Input'!D58=0,\" \",'Feed Input'!E5)","v":" "},null,{"$f":"IF('Feed Input'!D58=0,\" \",ROUND((D85/1000)*F85,2))","v":" "}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!D59=0,\" \",'Feed Input'!D59)","v":" "},null,{"$f":"IF('Feed Input'!D59=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!D59=0,\" \",ROUND((D86/1000)*F86,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!D60=0,\" \",'Feed Input'!D60)","v":120},null,{"$f":"IF('Feed Input'!D60=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!D60=0,\" \",ROUND((D87/1000)*F87,2))","v":79.8}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!D61=0,\" \",'Feed Input'!D61)","v":" "},null,{"$f":"IF('Feed Input'!D61=0,\" \",'Feed Input'!E8)","v":" "},null,{"$f":"IF('Feed Input'!D61=0,\" \",ROUND((D88/1000)*F88,2))","v":" "}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!D62=0,\" \",'Feed Input'!D62)","v":" "},null,{"$f":"IF('Feed Input'!D62=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!D62=0,\" \",ROUND((D89/1000)*F89,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!D63=0,\" \",'Feed Input'!D63)","v":5},null,{"$f":"IF('Feed Input'!D63=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!D63=0,\" \",ROUND((D90/1000)*F90,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!D64=0,\" \",'Feed Input'!D64)","v":" "},null,{"$f":"IF('Feed Input'!D64=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!D64=0,\" \",ROUND((D91/1000)*F91,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!D65=0,\" \",'Feed Input'!D65)","v":27},null,{"$f":"IF('Feed Input'!D65=0,\" \",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!D65=0,\" \",ROUND((D92/1000)*F92,2))","v":64.8}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!D66=0,\" \",'Feed Input'!D66)","v":121},null,{"$f":"IF('Feed Input'!D66=0,\" \",'Feed Input'!E13)","v":1364.6},null,{"$f":"IF('Feed Input'!D66=0,\" \",ROUND((D93/1000)*F93,2))","v":165.12}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!D67=0,\" \",'Feed Input'!D67)","v":61},null,{"$f":"IF('Feed Input'!D67=0,\" \",'Feed Input'!E14)","v":3364.4},null,{"$f":"IF('Feed Input'!D67=0,\" \",ROUND((D94/1000)*F94,2))","v":205.23}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!D68=0,\" \",'Feed Input'!D68)","v":59},null,{"$f":"IF('Feed Input'!D68=0,\" \",'Feed Input'!E15)","v":5270},null,{"$f":"IF('Feed Input'!D68=0,\" \",ROUND((D95/1000)*F95,2))","v":310.93}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!D69=0,\" \",'Feed Input'!D69)","v":12.5},null,{"$f":"IF('Feed Input'!D69=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!D69=0,\" \",ROUND((D96/1000)*F96,2))","v":2.5499999999999998}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!D70=0,\" \",'Feed Input'!D70)","v":10},null,{"$f":"IF('Feed Input'!D70=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!D70=0,\" \",ROUND((D97/1000)*F97,2))","v":15.44}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!D71=0,\" \",'Feed Input'!D71)","v":3.5},null,{"$f":"IF('Feed Input'!D71=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!D71=0,\" \",ROUND((D98/1000)*F98,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!D72=0,\" \",'Feed Input'!D72)","v":" "},null,{"$f":"IF('Feed Input'!D72=0,\" \",'Feed Input'!E19)","v":" "},null,{"$f":"IF('Feed Input'!D72=0,\" \",ROUND((D99/1000)*F99,2))","v":" "}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!D73=0,\" \",'Feed Input'!D73)","v":0.5},null,{"$f":"IF('Feed Input'!D73=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!D73=0,\" \",ROUND((D100/1000)*F100,2))","v":1.1200000000000001}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!D74=0,\" \",'Feed Input'!D74)","v":" "},null,{"$f":"IF('Feed Input'!D74=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!D74=0,\" \",ROUND((D101/1000)*F101,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!D75=0,\" \",'Feed Input'!D75)","v":" "},null,{"$f":"IF('Feed Input'!D75=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!D75=0,\" \",ROUND((D102/1000)*F102,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!D76=0,\" \",'Feed Input'!D76)","v":474.5},null,{"$f":"IF('Feed Input'!D76=0,\" \",'Feed Input'!E23)","v":375},null,{"$f":"IF('Feed Input'!D76=0,\" \",ROUND((D103/1000)*F103,2))","v":177.94}]
["Total Pre Starter 1:",null,null,{"$f":"SUM(D84:D103)","v":1000},"kg","  ",null,{"$f":"SUM(H84:H103)","v":1083.07}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H104+(F105*H104/100)","v":1096.608375}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H105=0,0,H105+F106)","v":1106.608375}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H106+F107","v":1116.608375}]
[]
[{"$f":"'Feed Input'!E55","v":"Pre Starter 2"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!E57=0,\" \",'Feed Input'!E57)","v":134.5},null,{"$f":"IF('Feed Input'!E57=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!E57=0,\" \",ROUND((D110/1000)*F110,2))","v":49.77}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!E58=0,\" \",'Feed Input'!E58)","v":" "},null,{"$f":"IF('Feed Input'!E58=0,\" \",'Feed Input'!E5)","v":" "},null,{"$f":"IF('Feed Input'!E58=0,\" \",ROUND((D111/1000)*F111,2))","v":" "}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!E59=0,\" \",'Feed Input'!E59)","v":" "},null,{"$f":"IF('Feed Input'!E59=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!E59=0,\" \",ROUND((D112/1000)*F112,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!E60=0,\" \",'Feed Input'!E60)","v":130},null,{"$f":"IF('Feed Input'!E60=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!E60=0,\" \",ROUND((D113/1000)*F113,2))","v":86.45}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!E61=0,\" \",'Feed Input'!E61)","v":" "},null,{"$f":"IF('Feed Input'!E61=0,\" \",'Feed Input'!E8)","v":" "},null,{"$f":"IF('Feed Input'!E61=0,\" \",ROUND((D114/1000)*F114,2))","v":" "}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!E62=0,\" \",'Feed Input'!E62)","v":" "},null,{"$f":"IF('Feed Input'!E62=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!E62=0,\" \",ROUND((D115/1000)*F115,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!E63=0,\" \",'Feed Input'!E63)","v":5},null,{"$f":"IF('Feed Input'!E63=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!E63=0,\" \",ROUND((D116/1000)*F116,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!E64=0,\" \",'Feed Input'!E64)","v":" "},null,{"$f":"IF('Feed Input'!E64=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!E64=0,\" \",ROUND((D117/1000)*F117,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!E65=0,\" \",'Feed Input'!E65)","v":19},null,{"$f":"IF('Feed Input'!E65=0,\" \",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!E65=0,\" \",ROUND((D118/1000)*F118,2))","v":45.6}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!E66=0,\" \",'Feed Input'!E66)","v":125},null,{"$f":"IF('Feed Input'!E66=0,\" \",'Feed Input'!E13)","v":1364.6},null,{"$f":"IF('Feed Input'!E66=0,\" \",ROUND((D119/1000)*F119,2))","v":170.58}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!E67=0,\" \",'Feed Input'!E67)","v":75},null,{"$f":"IF('Feed Input'!E67=0,\" \",'Feed Input'!E14)","v":3364.4},null,{"$f":"IF('Feed Input'!E67=0,\" \",ROUND((D120/1000)*F120,2))","v":252.33}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!E68=0,\" \",'Feed Input'!E68)","v":" "},null,{"$f":"IF('Feed Input'!E68=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!E68=0,\" \",ROUND((D121/1000)*F121,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!E69=0,\" \",'Feed Input'!E69)","v":12.5},null,{"$f":"IF('Feed Input'!E69=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!E69=0,\" \",ROUND((D122/1000)*F122,2))","v":2.5499999999999998}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!E70=0,\" \",'Feed Input'!E70)","v":10},null,{"$f":"IF('Feed Input'!E70=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!E70=0,\" \",ROUND((D123/1000)*F123,2))","v":15.44}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!E71=0,\" \",'Feed Input'!E71)","v":3.5},null,{"$f":"IF('Feed Input'!E71=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!E71=0,\" \",ROUND((D124/1000)*F124,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!E72=0,\" \",'Feed Input'!E72)","v":" "},null,{"$f":"IF('Feed Input'!E72=0,\" \",'Feed Input'!E19)","v":" "},null,{"$f":"IF('Feed Input'!E72=0,\" \",ROUND((D125/1000)*F125,2))","v":" "}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!E73=0,\" \",'Feed Input'!E73)","v":0.5},null,{"$f":"IF('Feed Input'!E73=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!E73=0,\" \",ROUND((D126/1000)*F126,2))","v":1.1200000000000001}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!E74=0,\" \",'Feed Input'!E74)","v":" "},null,{"$f":"IF('Feed Input'!E74=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!E74=0,\" \",ROUND((D127/1000)*F127,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!E75=0,\" \",'Feed Input'!E75)","v":" "},null,{"$f":"IF('Feed Input'!E75=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!E75=0,\" \",ROUND((D128/1000)*F128,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!E76=0,\" \",'Feed Input'!E76)","v":485},null,{"$f":"IF('Feed Input'!E76=0,\" \",'Feed Input'!E23)","v":375},null,{"$f":"IF('Feed Input'!E76=0,\" \",ROUND((D129/1000)*F129,2))","v":181.88}]
["Total Pre Starter 2",null,null,{"$f":"SUM(D109:D129)","v":1000},"kg",null,null,{"$f":"SUM(H109:H129)","v":826.64}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H130+(F131*H130/100)","v":836.97299999999996}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H131=0,0,H131+F132)","v":846.97299999999996}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H132+F133","v":856.97299999999996}]
[]
[{"$f":"'Feed Input'!F55","v":"Starter 1"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!F57=0,\" \",'Feed Input'!F57)","v":405},null,{"$f":"IF('Feed Input'!F57=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!F57=0,\" \",ROUND((D136/1000)*F136,2))","v":149.85}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!F58=0,\" \",'Feed Input'!F58)","v":" "},null,{"$f":"IF('Feed Input'!F58=0,\" \",'Feed Input'!E5)","v":" "},null,{"$f":"IF('Feed Input'!F58=0,\" \",ROUND((D137/1000)*F137,2))","v":" "}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!F59=0,\" \",'Feed Input'!F59)","v":249},null,{"$f":"IF('Feed Input'!F59=0,\" \",'Feed Input'!E6)","v":355},null,{"$f":"IF('Feed Input'!F59=0,\" \",ROUND((D138/1000)*F138,2))","v":88.4}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!F60=0,\" \",'Feed Input'!F60)","v":200},null,{"$f":"IF('Feed Input'!F60=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!F60=0,\" \",ROUND((D139/1000)*F139,2))","v":133}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!F61=0,\" \",'Feed Input'!F61)","v":" "},null,{"$f":"IF('Feed Input'!F61=0,\" \",'Feed Input'!E8)","v":" "},null,{"$f":"IF('Feed Input'!F61=0,\" \",ROUND((D140/1000)*F140,2))","v":" "}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!F62=0,\" \",'Feed Input'!F62)","v":" "},null,{"$f":"IF('Feed Input'!F62=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!F62=0,\" \",ROUND((D141/1000)*F141,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!F63=0,\" \",'Feed Input'!F63)","v":5},null,{"$f":"IF('Feed Input'!F63=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!F63=0,\" \",ROUND((D142/1000)*F142,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!F64=0,\" \",'Feed Input'!F64)","v":" "},null,{"$f":"IF('Feed Input'!F64=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!F64=0,\" \",ROUND((D143/1000)*F143,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!F65=0,\" \",'Feed Input'!F65)","v":11},null,{"$f":"IF('Feed Input'!F65=0,\" \",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!F65=0,\" \",ROUND((D144/1000)*F144,2))","v":26.4}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!F66=0,\" \",'Feed Input'!F66)","v":70},null,{"$f":"IF('Feed Input'!F66=0,\" \",'Feed Input'!E13)","v":1364.6},null,{"$f":"IF('Feed Input'!F66=0,\" \",ROUND((D145/1000)*F145,2))","v":95.52}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!F67=0,\" \",'Feed Input'!F67)","v":40},null,{"$f":"IF('Feed Input'!F67=0,\" \",'Feed Input'!E14)","v":3364.4},null,{"$f":"IF('Feed Input'!F67=0,\" \",ROUND((D146/1000)*F146,2))","v":134.58000000000001}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!F68=0,\" \",'Feed Input'!F68)","v":" "},null,{"$f":"IF('Feed Input'!F68=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!F68=0,\" \",ROUND((D147/1000)*F147,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!F69=0,\" \",'Feed Input'!F69)","v":7},null,{"$f":"IF('Feed Input'!F69=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!F69=0,\" \",ROUND((D148/1000)*F148,2))","v":1.43}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!F70=0,\" \",'Feed Input'!F70)","v":8},null,{"$f":"IF('Feed Input'!F70=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!F70=0,\" \",ROUND((D149/1000)*F149,2))","v":12.35}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!F71=0,\" \",'Feed Input'!F71)","v":3.5},null,{"$f":"IF('Feed Input'!F71=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!F71=0,\" \",ROUND((D150/1000)*F150,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!F72=0,\" \",'Feed Input'!F72)","v":0.5},null,{"$f":"IF('Feed Input'!F72=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!F72=0,\" \",ROUND((D151/1000)*F151,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!F73=0,\" \",'Feed Input'!F73)","v":1},null,{"$f":"IF('Feed Input'!F73=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!F73=0,\" \",ROUND((D152/1000)*F152,2))","v":2.25}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!F74=0,\" \",'Feed Input'!F74)","v":" "},null,{"$f":"IF('Feed Input'!F74=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!F74=0,\" \",ROUND((D153/1000)*F153,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!F75=0,\" \",'Feed Input'!F75)","v":" "},null,{"$f":"IF('Feed Input'!F75=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!F75=0,\" \",ROUND((D154/1000)*F154,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!F76=0,\" \",'Feed Input'!F76)","v":" "},null,{"$f":"IF('Feed Input'!F76=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!F76=0,\" \",ROUND((D155/1000)*F155,2))","v":" "}]
["Total Starter 1 ",null,null,{"$f":"SUM(D136:D155)","v":1000},"kg",null,null,{"$f":"SUM(H136:H155)","v":671.94999999999993}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H156+(F157*H156/100)","v":680.3493749999999}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H157=0,0,H157+F158)","v":690.3493749999999}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H158+F159","v":700.3493749999999}]
[]
[{"$f":"'Feed Input'!G55","v":"Starter 2"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"'Feed Input'!G57","v":404},null,{"$f":"IF('Feed Input'!G57=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!G57=0,\" \",ROUND((D162/1000)*F162,2))","v":149.47999999999999}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"'Feed Input'!G58","v":65},null,{"$f":"IF('Feed Input'!G58=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!G58=0,\" \",ROUND((D163/1000)*F163,2))","v":20.8}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"'Feed Input'!G59","v":250},null,{"$f":"IF('Feed Input'!G59=0,\" \",'Feed Input'!E6)","v":355},null,{"$f":"IF('Feed Input'!G59=0,\" \",ROUND((D164/1000)*F164,2))","v":88.75}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"'Feed Input'!G60","v":227},null,{"$f":"IF('Feed Input'!G60=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!G60=0,\" \",ROUND((D165/1000)*F165,2))","v":150.96}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"'Feed Input'!G61","v":0},null,{"$f":"IF('Feed Input'!G61=0,\" \",'Feed Input'!E8)","v":" "},null,{"$f":"IF('Feed Input'!G61=0,\" \",ROUND((D166/1000)*F166,2))","v":" "}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"'Feed Input'!G62","v":0},null,{"$f":"IF('Feed Input'!G62=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!G62=0,\" \",ROUND((D167/1000)*F167,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"'Feed Input'!G63","v":5},null,{"$f":"IF('Feed Input'!G63=0,\" \",'Feed Input'!E10)","v":4000},null,{"$f":"IF('Feed Input'!G63=0,\" \",ROUND((D168/1000)*F168,2))","v":20}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"'Feed Input'!G64","v":0},null,{"$f":"IF('Feed Input'!G64=0,\" \",'Feed Input'!E11)","v":" "},null,{"$f":"IF('Feed Input'!G64=0,\" \",ROUND((D169/1000)*F169,2))","v":" "}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"'Feed Input'!G65","v":0},null,{"$f":"IF('Feed Input'!G65=0,\" \",'Feed Input'!E12)","v":" "},null,{"$f":"IF('Feed Input'!G65=0,\" \",ROUND((D170/1000)*F170,2))","v":" "}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"'Feed Input'!G66","v":0},null,{"$f":"IF('Feed Input'!G66=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!G66=0,\" \",ROUND((D171/1000)*F171,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"'Feed Input'!G67","v":25},null,{"$f":"IF('Feed Input'!G67=0,\" \",'Feed Input'!E14)","v":3364.4},null,{"$f":"IF('Feed Input'!G67=0,\" \",ROUND((D172/1000)*F172,2))","v":84.11}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"'Feed Input'!G68","v":0},null,{"$f":"IF('Feed Input'!G68=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!G68=0,\" \",ROUND((D173/1000)*F173,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"'Feed Input'!G69","v":11},null,{"$f":"IF('Feed Input'!G69=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!G69=0,\" \",ROUND((D174/1000)*F174,2))","v":2.2400000000000002}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"'Feed Input'!G70","v":8},null,{"$f":"IF('Feed Input'!G70=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!G70=0,\" \",ROUND((D175/1000)*F175,2))","v":12.35}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"'Feed Input'!G71","v":3.5},null,{"$f":"IF('Feed Input'!G71=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!G71=0,\" \",ROUND((D176/1000)*F176,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"'Feed Input'!G72","v":0.5},null,{"$f":"IF('Feed Input'!G72=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!G72=0,\" \",ROUND((D177/1000)*F177,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"'Feed Input'!G73","v":1},null,{"$f":"IF('Feed Input'!G73=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!G73=0,\" \",ROUND((D178/1000)*F178,2))","v":2.25}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"'Feed Input'!G74","v":0},null,{"$f":"IF('Feed Input'!G74=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!G74=0,\" \",ROUND((D179/1000)*F179,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"'Feed Input'!G75","v":0},null,{"$f":"IF('Feed Input'!G75=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!G75=0,\" \",ROUND((D180/1000)*F180,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"'Feed Input'!G76","v":0},null,{"$f":"IF('Feed Input'!G76=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!G76=0,\" \",ROUND((D181/1000)*F181,2))","v":" "}]
["Total Starter 2 ",null,null,{"$f":"SUM(D162:D181)","v":1000},"kg",null,null,{"$f":"SUM(H162:H181)","v":539.11}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H182+(F183*H182/100)","v":545.84887500000002}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H183=0,0,H183+F184)","v":555.84887500000002}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H184+F185","v":565.84887500000002}]
[]
[{"$f":"'Feed Input'!D80","v":"Starter"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!D83=0,\" \",'Feed Input'!D83)","v":475},null,{"$f":"IF('Feed Input'!D83=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!D83=0,\" \",ROUND((D188/1000)*F188,2))","v":175.75}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!D84=0,\" \",'Feed Input'!D84)","v":215},null,{"$f":"IF('Feed Input'!D84=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!D84=0,\" \",ROUND((D189/1000)*F189,2))","v":68.8}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!D85=0,\" \",'Feed Input'!D85)","v":" "},null,{"$f":"IF('Feed Input'!D85=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!D85=0,\" \",ROUND((D190/1000)*F190,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!D86=0,\" \",'Feed Input'!D86)","v":175},null,{"$f":"IF('Feed Input'!D86=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!D86=0,\" \",ROUND((D191/1000)*F191,2))","v":116.38}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!D87=0,\" \",'Feed Input'!D87)","v":" "},null,{"$f":"IF('Feed Input'!D87=0,\" \",'Feed Input'!E8)","v":" "},null,{"$f":"IF('Feed Input'!D87=0,\" \",ROUND((D192/1000)*F192,2))","v":" "}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!D88=0,\" \",'Feed Input'!D88)","v":100},null,{"$f":"IF('Feed Input'!D88=0,\" \",'Feed Input'!E9)","v":390},null,{"$f":"IF('Feed Input'!D88=0,\" \",ROUND((D193/1000)*F193,2))","v":39}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!D89=0,\" \",'Feed Input'!D89)","v":" "},null,{"$f":"IF('Feed Input'!D89=0,\" \",'Feed Input'!E10)","v":" "},null,{"$f":"IF('Feed Input'!D89=0,\" \",ROUND((D194/1000)*F194,2))","v":" "}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!D90=0,\" \",'Feed Input'!D90)","v":3},null,{"$f":"IF('Feed Input'!D90=0,\" \",'Feed Input'!E11)","v":8000},null,{"$f":"IF('Feed Input'!D90=0,\" \",ROUND((D195/1000)*F195,2))","v":24}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!D91=0,\" \",'Feed Input'!D91)","v":10},null,{"$f":"IF('Feed Input'!D91=0,\" \",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!D91=0,\" \",ROUND((D196/1000)*F196,2))","v":24}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!D92=0,\" \",'Feed Input'!D92)","v":" "},null,{"$f":"IF('Feed Input'!D92=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!D92=0,\" \",ROUND((D197/1000)*F197,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!D93=0,\" \",'Feed Input'!D93)","v":" "},null,{"$f":"IF('Feed Input'!D93=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!D93=0,\" \",ROUND((D198/1000)*F198,2))","v":" "}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!D94=0,\" \",'Feed Input'!D94)","v":" "},null,{"$f":"IF('Feed Input'!D94=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!D94=0,\" \",ROUND((D199/1000)*F199,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!D95=0,\" \",'Feed Input'!D95)","v":12},null,{"$f":"IF('Feed Input'!D95=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!D95=0,\" \",ROUND((D200/1000)*F200,2))","v":2.4500000000000002}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!D96=0,\" \",'Feed Input'!D96)","v":5},null,{"$f":"IF('Feed Input'!D96=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!D96=0,\" \",ROUND((D201/1000)*F201,2))","v":7.72}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!D97=0,\" \",'Feed Input'!D97)","v":3.5},null,{"$f":"IF('Feed Input'!D97=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!D97=0,\" \",ROUND((D202/1000)*F202,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!D98=0,\" \",'Feed Input'!D98)","v":0.5},null,{"$f":"IF('Feed Input'!D98=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!D98=0,\" \",ROUND((D203/1000)*F203,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!D99=0,\" \",'Feed Input'!D99)","v":1},null,{"$f":"IF('Feed Input'!D99=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!D99=0,\" \",ROUND((D204/1000)*F204,2))","v":2.25}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!D100=0,\" \",'Feed Input'!D100)","v":" "},null,{"$f":"IF('Feed Input'!D100=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!D100=0,\" \",ROUND((D205/1000)*F205,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!D101=0,\" \",'Feed Input'!D101)","v":" "},null,{"$f":"IF('Feed Input'!D101=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!D101=0,\" \",ROUND((D206/1000)*F206,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!D102=0,\" \",'Feed Input'!D102)","v":" "},null,{"$f":"IF('Feed Input'!D102=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!D102=0,\" \",ROUND((D207/1000)*F207,2))","v":" "}]
["Total Starter",null,null,{"$f":"SUM(D188:D207)","v":1000},"kg",null,null,{"$f":"SUM(H188:H207)","v":468.52000000000004}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H208+(F209*H208/100)","v":474.37650000000002}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H209=0,0,H209+F210)","v":484.37650000000002}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H210+F211","v":494.37650000000002}]
[]
[{"$f":"'Feed Input'!E80","v":"Grower"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!E83=0,\" \",'Feed Input'!E83)","v":200},null,{"$f":"IF('Feed Input'!E83=0,\" \",'Feed Input'!E4)","v":370},null,{"$f":"IF('Feed Input'!E83=0,\" \",ROUND((D214/1000)*F214,2))","v":74}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!E84=0,\" \",'Feed Input'!E84)","v":597},null,{"$f":"IF('Feed Input'!E84=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!E84=0,\" \",ROUND((D215/1000)*F215,2))","v":191.04}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!E85=0,\" \",'Feed Input'!E85)","v":" "},null,{"$f":"IF('Feed Input'!E85=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!E85=0,\" \",ROUND((D216/1000)*F216,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!E86=0,\" \",'Feed Input'!E86)","v":75},null,{"$f":"IF('Feed Input'!E86=0,\" \",'Feed Input'!E7)","v":665},null,{"$f":"IF('Feed Input'!E86=0,\" \",ROUND((D217/1000)*F217,2))","v":49.88}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!E87=0,\" \",'Feed Input'!E87)","v":100},null,{"$f":"IF('Feed Input'!E87=0,\" \",'Feed Input'!E8)","v":425},null,{"$f":"IF('Feed Input'!E87=0,\" \",ROUND((D218/1000)*F218,2))","v":42.5}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!E88=0,\" \",'Feed Input'!E88)","v":" "},null,{"$f":"IF('Feed Input'!E88=0,\" \",'Feed Input'!E9)","v":" "},null,{"$f":"IF('Feed Input'!E88=0,\" \",ROUND((D219/1000)*F219,2))","v":" "}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!E89=0,\" \",'Feed Input'!E89)","v":" "},null,{"$f":"IF('Feed Input'!E89=0,\" \",'Feed Input'!E10)","v":" "},null,{"$f":"IF('Feed Input'!E89=0,\" \",ROUND((D220/1000)*F220,2))","v":" "}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!E90=0,\" \",'Feed Input'!E90)","v":3},null,{"$f":"IF('Feed Input'!E90=0,\" \",'Feed Input'!E11)","v":8000},null,{"$f":"IF('Feed Input'!E90=0,\" \",ROUND((D221/1000)*F221,2))","v":24}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!E91=0,\" \",'Feed Input'!E91)","v":8},null,{"$f":"IF('Feed Input'!E91=0,\" \",'Feed Input'!E12)","v":2400},null,{"$f":"IF('Feed Input'!E91=0,\" \",ROUND((D222/1000)*F222,2))","v":19.2}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!E92=0,\" \",'Feed Input'!E92)","v":" "},null,{"$f":"IF('Feed Input'!E92=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!E92=0,\" \",ROUND((D223/1000)*F223,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!E93=0,\" \",'Feed Input'!E93)","v":" "},null,{"$f":"IF('Feed Input'!E93=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!E93=0,\" \",ROUND((D224/1000)*F224,2))","v":" "}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!E94=0,\" \",'Feed Input'!E94)","v":" "},null,{"$f":"IF('Feed Input'!E94=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!E94=0,\" \",ROUND((D225/1000)*F225,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!E95=0,\" \",'Feed Input'!E95)","v":10},null,{"$f":"IF('Feed Input'!E95=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!E95=0,\" \",ROUND((D226/1000)*F226,2))","v":2.04}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!E96=0,\" \",'Feed Input'!E96)","v":2},null,{"$f":"IF('Feed Input'!E96=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!E96=0,\" \",ROUND((D227/1000)*F227,2))","v":3.09}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!E97=0,\" \",'Feed Input'!E97)","v":3.5},null,{"$f":"IF('Feed Input'!E97=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!E97=0,\" \",ROUND((D228/1000)*F228,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!E98=0,\" \",'Feed Input'!E98)","v":0.5},null,{"$f":"IF('Feed Input'!E98=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!E98=0,\" \",ROUND((D229/1000)*F229,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!E99=0,\" \",'Feed Input'!E99)","v":1},null,{"$f":"IF('Feed Input'!E99=0,\" \",'Feed Input'!E20)","v":2248.5},null,{"$f":"IF('Feed Input'!E99=0,\" \",ROUND((D230/1000)*F230,2))","v":2.25}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!E100=0,\" \",'Feed Input'!E100)","v":" "},null,{"$f":"IF('Feed Input'!E100=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!E100=0,\" \",ROUND((D231/1000)*F231,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!E101=0,\" \",'Feed Input'!E101)","v":" "},null,{"$f":"IF('Feed Input'!E101=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!E101=0,\" \",ROUND((D232/1000)*F232,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!E102=0,\" \",'Feed Input'!E102)","v":" "},null,{"$f":"IF('Feed Input'!E102=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!E102=0,\" \",ROUND((D233/1000)*F233,2))","v":" "}]
["Total Grower",null,null,{"$f":"SUM(D214:D233)","v":1000},"kg",null,null,{"$f":"SUM(H214:H233)","v":416.16999999999996}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H234+(F235*H234/100)","v":421.37212499999998}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H235=0,0,H235+F236)","v":431.37212499999998}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H236+F237","v":441.37212499999998}]
[]
[{"$f":"'Feed Input'!F80","v":"Finisher"}]
[{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"IF('Feed Input'!F83=0,\" \",'Feed Input'!F83)","v":" "},null,{"$f":"IF('Feed Input'!F83=0,\" \",'Feed Input'!E4)","v":" "},null,{"$f":"IF('Feed Input'!F83=0,\" \",ROUND((D240/1000)*F240,2))","v":" "}]
[{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"IF('Feed Input'!F84=0,\" \",'Feed Input'!F84)","v":834},null,{"$f":"IF('Feed Input'!F84=0,\" \",'Feed Input'!E5)","v":320},null,{"$f":"IF('Feed Input'!F84=0,\" \",ROUND((D241/1000)*F241,2))","v":266.88}]
[{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"IF('Feed Input'!F85=0,\" \",'Feed Input'!F85)","v":" "},null,{"$f":"IF('Feed Input'!F85=0,\" \",'Feed Input'!E6)","v":" "},null,{"$f":"IF('Feed Input'!F85=0,\" \",ROUND((D242/1000)*F242,2))","v":" "}]
[{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"IF('Feed Input'!F86=0,\" \",'Feed Input'!F86)","v":" "},null,{"$f":"IF('Feed Input'!F86=0,\" \",'Feed Input'!E7)","v":" "},null,{"$f":"IF('Feed Input'!F86=0,\" \",ROUND((D243/1000)*F243,2))","v":" "}]
[{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"IF('Feed Input'!F87=0,\" \",'Feed Input'!F87)","v":80},null,{"$f":"IF('Feed Input'!F87=0,\" \",'Feed Input'!E8)","v":425},null,{"$f":"IF('Feed Input'!F87=0,\" \",ROUND((D244/1000)*F244,2))","v":34}]
[{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"IF('Feed Input'!F88=0,\" \",'Feed Input'!F88)","v":70},null,{"$f":"IF('Feed Input'!F88=0,\" \",'Feed Input'!E9)","v":390},null,{"$f":"IF('Feed Input'!F88=0,\" \",ROUND((D245/1000)*F245,2))","v":27.3}]
[{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"IF('Feed Input'!F89=0,\" \",'Feed Input'!F89)","v":" "},null,{"$f":"IF('Feed Input'!F89=0,\" \",'Feed Input'!E10)","v":" "},null,{"$f":"IF('Feed Input'!F89=0,\" \",ROUND((D246/1000)*F246,2))","v":" "}]
[{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"IF('Feed Input'!F90=0,\" \",'Feed Input'!F90)","v":3},null,{"$f":"IF('Feed Input'!F90=0,\" \",'Feed Input'!E11)","v":8000},null,{"$f":"IF('Feed Input'!F90=0,\" \",ROUND((D247/1000)*F247,2))","v":24}]
[{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"IF('Feed Input'!F91=0,\" \",'Feed Input'!F91)","v":" "},null,{"$f":"IF('Feed Input'!F91=0,\" \",'Feed Input'!E12)","v":" "},null,{"$f":"IF('Feed Input'!F91=0,\" \",ROUND((D248/1000)*F248,2))","v":" "}]
[{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"IF('Feed Input'!F92=0,\" \",'Feed Input'!F92)","v":" "},null,{"$f":"IF('Feed Input'!F92=0,\" \",'Feed Input'!E13)","v":" "},null,{"$f":"IF('Feed Input'!F92=0,\" \",ROUND((D249/1000)*F249,2))","v":" "}]
[{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"IF('Feed Input'!F93=0,\" \",'Feed Input'!F93)","v":" "},null,{"$f":"IF('Feed Input'!F93=0,\" \",'Feed Input'!E14)","v":" "},null,{"$f":"IF('Feed Input'!F93=0,\" \",ROUND((D250/1000)*F250,2))","v":" "}]
[{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"IF('Feed Input'!F94=0,\" \",'Feed Input'!F94)","v":" "},null,{"$f":"IF('Feed Input'!F94=0,\" \",'Feed Input'!E15)","v":" "},null,{"$f":"IF('Feed Input'!F94=0,\" \",ROUND((D251/1000)*F251,2))","v":" "}]
[{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"IF('Feed Input'!F95=0,\" \",'Feed Input'!F95)","v":8},null,{"$f":"IF('Feed Input'!F95=0,\" \",'Feed Input'!E16)","v":203.95},null,{"$f":"IF('Feed Input'!F95=0,\" \",ROUND((D252/1000)*F252,2))","v":1.63}]
[{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"IF('Feed Input'!F96=0,\" \",'Feed Input'!F96)","v":1},null,{"$f":"IF('Feed Input'!F96=0,\" \",'Feed Input'!E17)","v":1544.23},null,{"$f":"IF('Feed Input'!F96=0,\" \",ROUND((D253/1000)*F253,2))","v":1.54}]
[{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"IF('Feed Input'!F97=0,\" \",'Feed Input'!F97)","v":3.5},null,{"$f":"IF('Feed Input'!F97=0,\" \",'Feed Input'!E18)","v":261.89999999999998},null,{"$f":"IF('Feed Input'!F97=0,\" \",ROUND((D254/1000)*F254,2))","v":0.92}]
[{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"IF('Feed Input'!F98=0,\" \",'Feed Input'!F98)","v":0.5},null,{"$f":"IF('Feed Input'!F98=0,\" \",'Feed Input'!E19)","v":14500},null,{"$f":"IF('Feed Input'!F98=0,\" \",ROUND((D255/1000)*F255,2))","v":7.25}]
[{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"IF('Feed Input'!F99=0,\" \",'Feed Input'!F99)","v":" "},null,{"$f":"IF('Feed Input'!F99=0,\" \",'Feed Input'!E20)","v":" "},null,{"$f":"IF('Feed Input'!F99=0,\" \",ROUND((D256/1000)*F256,2))","v":" "}]
[{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"IF('Feed Input'!F100=0,\" \",'Feed Input'!F100)","v":" "},null,{"$f":"IF('Feed Input'!F100=0,\" \",'Feed Input'!E21)","v":" "},null,{"$f":"IF('Feed Input'!F100=0,\" \",ROUND((D257/1000)*F257,2))","v":" "}]
[{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"IF('Feed Input'!F101=0,\" \",'Feed Input'!F101)","v":" "},null,{"$f":"IF('Feed Input'!F101=0,\" \",'Feed Input'!E22)","v":" "},null,{"$f":"IF('Feed Input'!F101=0,\" \",ROUND((D258/1000)*F258,2))","v":" "}]
[{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"IF('Feed Input'!F102=0,\" \",'Feed Input'!F102)","v":" "},null,{"$f":"IF('Feed Input'!F102=0,\" \",'Feed Input'!E23)","v":" "},null,{"$f":"IF('Feed Input'!F102=0,\" \",ROUND((D259/1000)*F259,2))","v":" "}]
["Total Finisher",null,null,{"$f":"SUM(D240:D259)","v":1000},"kg",null,null,{"$f":"SUM(H240:H259)","v":363.52000000000004}]
["Adjusted For Weight Loss",null,null,null,null,{"$f":"'Feed Input'!$E$26","v":1.25},"%",{"$f":"H260+(F261*H260/100)","v":368.06400000000002}]
["Plus Processing Cost",null,null,null,null,{"$f":"'Feed Input'!$E$25","v":10},null,{"$f":"IF(H261=0,0,H261+F262)","v":378.06400000000002}]
["Plus Labour Cost",null,null,null,null,{"$f":"'Feed Input'!$E$27","v":10},null,{"$f":"H262+F263","v":388.06400000000002}]

{"sheet":"Farrow Finish Worksheet","index":7,"n_rows":483,"n_cols":10,"rows_kept":483,"cut":false,"hidden":false,"merged":[[1,0,1,9],[478,2,478,7],[480,3,483,9],[371,3,371,5],[372,3,372,5],[403,2,403,9],[353,1,353,6],[476,3,477,8]]}
[]
["Farrow Finish Pig Production Cost Worksheet"]
[null,null,null,null,null,null,null,null,null,"Your Cost"]
["A. Operating Costs"]
[]
["1. Feed Requirements and Costs"]
[]
[null,"1.01  Sow Lactation - Purchased Feed"]
[null,null,"",{"$f":"'Farrow Input'!G16","v":21},null,"days average weaning age"]
[null,null,"x",{"$f":"'Farrow Input'!G15","v":2.38},null,"litters/sow/year"]
[null,null,"=",{"$f":"D9*D10","v":49.98},null,"days lactation"]
[null,null,"x",{"$f":"'Farrow Input'!E33","v":6.53},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow Input'!G33","v":635},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D9*D10*D12*D13/1000)/D15","v":7.9698284498790057},null,"/pig sold"]
[null,"1.011  Sow Lactation - Home Mixed Feed"]
[null,null,"",{"$f":"D9","v":21},null,"days average weaning age"]
[null,null,"x",{"$f":"D10","v":2.38},null,"litters/sow/year"]
[null,null,"=",{"$f":"D18*D19","v":49.98},null,"days lactation"]
[null,null,"x",{"$f":"D12","v":6.53},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow Input'!H33","v":467.18075000000005},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D18*D19*D21*D22/1000)/D24","v":5.8635439883241141},null,"/pig sold"]
[null,null,""]
[null,"1.02  Sow Gestation - Purchased Feed"]
[null,null,"",365,null,"days/year"]
[null,null,"-",{"$f":"D11","v":49.98},null,"days lactation"]
[null,null,"=",{"$f":"D28-D29","v":315.02},null,"days gestation"]
[null,null,"x",{"$f":"'Farrow Input'!E32","v":2.95},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow Input'!G32","v":549.75},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D30*D31*D32/D33)/D34","v":19.64677159035228},null,"/pig sold"]
[null,"1.021  Sow Gestation -Home Mixed Feed"]
[null,null,"",365,null,"days/year"]
[null,null,"-",{"$f":"D20","v":49.98},null,"days lactation"]
[null,null,"=",{"$f":"D37-D38","v":315.02},null,"days gestation"]
[null,null,"x",{"$f":"D31","v":2.95},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow Input'!H32","v":390.6155},null,"/tonne ration"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D39*D40*D41/D42)/D43","v":13.959678959802185},null,"/pig sold"]
[null,null,""]
[null,"1.03  Boar Ration - Purchased Feed"]
[null,null,"",365,null,"days/year"]
[null,null,"x",{"$f":"'Farrow Input'!E34","v":3},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow Input'!G34","v":549.75},null,"/tonne ration"]
[null,null,"x",{"$f":"'Farrow Input'!G14","v":3},null,"boars"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"'Farrow Input'!E29","v":13714},null,"pigs sold/year"]
[null,null,"=",{"$f":"(D47*D48*D49*D50/D51)/D52","v":0.13168504812600262},null,"/pig sold"]
[null,"1.031  Boar Ration - Home Mixed Feed"]
[null,null,"",365,null,"days/year"]
[null,null,"x",{"$f":"D48","v":3},null,"kg ration/day"]
[null,null,"x",{"$f":"'Farrow Input'!H34","v":401.72262500000005},null,"/tonne ration"]
[null,null,"x",{"$f":"D50","v":3},null,"boars"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"÷",{"$f":"D52","v":13714},null,"pigs sold/year"]
[null,null,"=",{"$f":"(D55*D56*D57*D58/D59)/D60","v":9.6227127251348993E-2},null,"/pig sold"]
[]
[null,"1.04  Pre Starter 1 - Purchased Feed"]
[null,null,null,{"$f":"'Farrow Input'!E43","v":6.5},null,"kg target sale weight"]
[null,null,"-",{"$f":"'Farrow Input'!E42","v":6},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D64-D65","v":0.5},null,"kg weight gain"]
[null,null,"x",{"$f":"'Farrow Input'!E44","v":1.1599999999999999},null,"feed conversion ratio"]
[null,null,"=",{"$f":"D66*D67","v":0.57999999999999996},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G35","v":2000},null,"/tonne of creep feed"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow Input'!G17*'Farrow Input'!G15","v":32.129999999999995},null,"pigs born alive/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"((D68*D69/1000)*D71)/D72","v":1.4332915145764347},null,"/pig sold"]
[null,"1.041  Pre Starter 1 - Home Mixed Feed"]
[null,null,null,{"$f":"D64","v":6.5},null,"kg target sale weight"]
[null,null,"-",{"$f":"D65","v":6},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D75-D76","v":0.5},null,"kg weight gain"]
[null,null,"x",{"$f":"D67","v":1.1599999999999999},null,"feed conversion ratio"]
[null,null,"=",{"$f":"D77*D78","v":0.57999999999999996},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H35","v":1116.608375},null,"/tonne of creep feed"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"D71","v":32.129999999999995},null,"pigs born alive/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"((D79*D80/1000)*D82)/D83","v":0.80021265449624079},null,"/pig sold"]
[null,null,""]
[null,"1.05  Pre Starter 2 - Purchased Feed"]
[null,null,"",{"$f":"'Farrow Input'!F43","v":9},null,"kg target sale weight"]
[null,null,"-",{"$f":"'Farrow Input'!F42","v":6.5},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D87-D88","v":2.5},null,"kg weight gain"]
[null,null,"x",{"$f":"'Farrow Input'!F44","v":1.1599999999999999},null,"feed conversion ratio",null,null,""]
[null,null,"=",{"$f":"'Farrow Input'!E36","v":2.9},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G36","v":1611.5},null,"/tonne starter ration #1"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow Input'!F29","v":27.43},null,"weaners transferred/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D91*D92/1000*D94)/D95","v":4.9296936378420568},null,"/pig sold"]
[null,"1.051  Pre Starter 2 - Home Mixed Feed"]
[null,null,"",{"$f":"D87","v":9},null,"kg target sale weight"]
[null,null,"-",{"$f":"D88","v":6.5},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D98-D99","v":2.5},null,"kg weight gain"]
[null,null,"x",{"$f":"D90","v":1.1599999999999999},null,"feed conversion ratio",null,null,""]
[null,null,"=",{"$f":"D91","v":2.9},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H36","v":856.97299999999996},null,"/tonne starter ration #1"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"D94","v":27.43},null,"weaners transferred/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D102*D103/1000*D105)/D106","v":2.6215416356825449},null,"/pig sold"]
[]
[null,"1.06  Starter 1 - Purchased Feed"]
[null,null,"",{"$f":"'Farrow Input'!G43","v":16},null,"kg target sale weight"]
[null,null,"-",{"$f":"'Farrow Input'!G42","v":9},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D110-D111","v":7},null,"kg weight gain"]
[null,null,"x",{"$f":"'Farrow Input'!G44","v":1.2857142857142858},null,"feed conversion ratio",null,null,""]
[null,null,"=",{"$f":"D112*D113","v":9},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G37","v":1199},null,"/tonne starter ration #2"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow Input'!F29","v":27.43},null,"weaners transferred/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D114*D115/1000*D117)/D118","v":11.38291034182196},null,"/pig sold"]
[null,"1.061  Starter 1 - Home Mixed Feed"]
[null,null,"",{"$f":"D110","v":16},null,"kg target sale weight"]
[null,null,"-",{"$f":"D111","v":9},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D121-D122","v":7},null,"kg weight gain"]
[null,null,"x",{"$f":"D113","v":1.2857142857142858},null,"feed conversion ratio",null,null,""]
[null,null,"=",{"$f":"D123*D124","v":9},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H37","v":700.3493749999999},null,"/tonne starter ration #2"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"D117","v":27.43},null,"weaners transferred/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D125*D126/1000*D128)/D129","v":6.6488858578615879},null,"/pig sold"]
[]
[null,"1.07  Starter 2 - Purchased Feed"]
[null,null,null,{"$f":"'Farrow Input'!H43","v":26},null,"kg target sale weight"]
[null,null,"-",{"$f":"'Farrow Input'!H42","v":16},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D133-D134","v":10},null,"kg weight gain"]
[null,null,"x",{"$f":"'Farrow Input'!H44","v":1.6},null,"feed conversion ratio"]
[null,null,"=",{"$f":"D135*D136","v":16},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G38","v":808.65},null,"/tonne starter ration #2"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"'Farrow Input'!F29","v":27.43},null,"weaners transferred/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D137*D138/1000*D140)/D141","v":13.648100006174518},null,"/pig sold"]
[null,"1.071  Starter 2 - Home Mixed Feed"]
[null,null,null,{"$f":"D133","v":26},null,"kg target sale weight"]
[null,null,"-",{"$f":"D134","v":16},null,"kg target weaning weight"]
[null,null,"=",{"$f":"D144-D145","v":10},null,"kg weight gain"]
[null,null,"x",{"$f":"D136","v":1.6},null,"feed conversion ratio"]
[null,null,"=",{"$f":"D146*D147","v":16},null,"kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H38","v":565.84887500000002},null,"/tonne starter ration #2"]
[null,null,"÷",1000,null,"kg/tonne"]
[null,null,"x",{"$f":"D140","v":27.43},null,"weaners transferred/sow/year"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D148*D149/1000*D151)/D152","v":9.550191101689661},null,"/pig sold"]
[]
[null,"1.08 Starter Ration - Purchased Feed"]
[null,null,null,{"$f":"'Farrow Input'!F67","v":14},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Farrow Input'!F65","v":1.95},null," feed conversion ratio"]
[null,null,"=",{"$f":"D156*D157","v":27.3},null," kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G85","v":679.58},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"D158*D159/1000","v":18.552534000000005},null," /pig sold"]
[null,"1.081 Starter Ration - Home Mixed Feed "]
[null,null,null,{"$f":"D156","v":14},null," kg weight gain/pig"]
[null,null,"x",{"$f":"D157","v":1.95},null," feed conversion ratio"]
[null,null,"=",{"$f":"D163*D164","v":27.3},null," kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H85","v":494.37650000000002},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"D165*D166/1000","v":13.49647845},null," /pig sold"]
[]
[null,"1.09 Grower Ration - Purchased Feed"]
[null,null,null,{"$f":"'Farrow Input'!G67","v":55},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G65","v":3},null," feed conversion ratio"]
[null,null,"=",{"$f":"D171*D172","v":165},null," kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G86","v":550.5},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"D173*D174/1000","v":90.832499999999996},null," /pig sold"]
[null,"1.091 Grower Ration - Home Mixed Feed"]
[null,null,null,{"$f":"D171","v":55},null," kg weight gain/pig"]
[null,null,"x",{"$f":"D172","v":3},null," feed conversion ratio"]
[null,null,"=",{"$f":"D178*D179","v":165},null," kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H86","v":441.37212499999998},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"D180*D181/1000","v":72.826400624999991},null," /pig sold"]
[]
[null,"1.10 Finisher Ration - Purchased Feed"]
[null,null,null,{"$f":"'Farrow Input'!H67","v":26},null," kg weight gain/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H65","v":3.5},null," feed conversion ratio"]
[null,null,"=",{"$f":"D186*D187","v":91},null," kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!G87","v":553.45000000000005},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"D188*D189/D190","v":50.363950000000003},null," /pig sold"]
[null,"1.101 Finisher Ration - Home Mixed Feed"]
[null,null,null,{"$f":"D186","v":26},null," kg weight gain/pig"]
[null,null,"x",{"$f":"D187","v":3.5},null," feed conversion ratio"]
[null,null,"=",{"$f":"D193*D194","v":91},null," kg ration/pig"]
[null,null,"x",{"$f":"'Farrow Input'!H87","v":388.06400000000002},null," /tonne ration"]
[null,null,"÷",1000,null," kg/tonne"]
[null,null,"=",{"$f":"D195*D196/D197","v":35.313824000000004},null," /pig sold"]
[]
["2. Other Operating Costs"]
[null,"2.01  Veterinary Medicine & Supplies"]
[null,null,null,{"$f":"'Farrow Input'!G148","v":10},null,"/sow/year services"]
[null,null,"+",{"$f":"'Farrow Input'!G149","v":65},null,"/sow/year medication"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D202+D203)/D204","v":2.8842113287944615},null,"/pig sold"]
[]
[null,null,null,{"$f":"'Farrow Input'!G150","v":0},null," /pig transferred in"]
[null,null,"x",{"$f":"'Farrow Input'!F60","v":13714},null," pigs transferred in"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"D207*D208/D209","v":0},null," /pig sold"]
[]
[null,null,"=",{"$f":"D205+D210","v":2.8842113287944615},null," /pig sold"]
[]
[null,"2.02  Maintenance & Repairs"]
[null,null,null,{"$f":"'Farrow Input'!H113","v":6332388.7333333325},null,"building & equipment"]
[null,null,"x",{"$f":"'Farrow Input'!G152","v":1.3},null,"%/sow/year repair & maintenance"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D215*D216/100/D217)","v":6.3315017386436079},null,"/pig sold"]
[]
[null,"2.03  Hydro & Propane/Natural Gas "]
[null,null,null,{"$f":"SUM('Farrow Input'!G156*'Farrow Input'!G157)","v":73125},null,"propane/natural gas"]
[null,null,"x",{"$f":"SUM('Farrow Input'!G154*'Farrow Input'!G155)","v":47744.287920000002},null,"hydro"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null,"pigs sold"]
[null,null,"=",{"$f":"(D221+D222)/D223","v":9.2963351872582276},null,"/pig sold"]
[]
[null,"2.04  Insurance"]
[null,null,null,{"$f":"'Farrow Input'!H113","v":6332388.7333333325},null," buildings & equipment "]
[null,null,"x",{"$f":"'Farrow Input'!G160","v":0.78},null,"rate/$100  "]
[null,null,"÷",100,null," /$100 capital invested"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"D228*D227/D229/D230","v":3.7989010431861647},null," /pig sold"]
[]
[null,null,null,{"$f":"'Farrow Input'!H118","v":185500},null,"breeding stock"]
[null,null,"+",{"$f":"'Farrow Input'!I70*'Farrow Input'!G164","v":867921.59761015931},null,"market hogs value"]
[null,null,"÷",{"$f":"'Farrow Input'!G161","v":0.88},null," /$100 capital invested"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"(((D233+D234)*D235)/100)/D236","v":0.71298550536669458},null," /pig sold"]
[]
[null,null,null,{"$f":"'Farrow Input'!G163","v":1200},null,"business interruption coverage/sow"]
[null,null,"x",{"$f":"'Farrow Input'!G13","v":500},null,"sows"]
[null,null,"x",{"$f":"'Farrow Input'!G162","v":0.78},null," /$100 capital invested"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D239*D240)*D241/100)/D242","v":0.35994957383354881},null," /pig sold"]
[]
[null,null,"=",{"$f":"D231+D237+D243","v":4.8718361223864086},null," /pig sold"]
[]
[null,"2.05  Manure Costs"]
[null,"   Haulage",null,{"$f":"'Farrow Input'!G167","v":68},null,"litres/sow/day"]
[null,null,"x",{"$f":"'Farrow Input'!G168","v":2.8999999999999998E-3},null,"/litres haulage rate"]
[null,null,"x",365,null,"days"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D248*D249*D250)/D251","v":2.7679968403195696},null,"/pig sold"]
[null,"  Estimated Nutrient Value"]
[null,null,null,{"$f":"'Farrow Input'!G167","v":68},null," litres/sow/day"]
[null,null,"x",365,null," days/year"]
[null,null,"x",{"$f":"'Farrow Input'!E22","v":500},null," average inventory of pigs"]
[null,null,"÷",1000]
[null,null,"=",{"$f":"SUM((D254*D255*D256)/1000)","v":12410},null,"# of 1000 litres of manure"]
[null,null,"Nitrogen"]
[null,null,null,{"$f":"'Farrow Input'!F176","v":2.69},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D258","v":12410},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Farrow Input'!H176","v":60},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Farrow Input'!G176","v":0.77},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D260*D261*(D262/100)/D263)*D264)/D265","v":0.53806519579028156},null,"estimated nutrient value / pig sold"]
[null,null,"Phosphate"]
[null,null,null,{"$f":"'Farrow Input'!F177","v":0.62},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D258","v":12410},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Farrow Input'!H177","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Farrow Input'!G177","v":0.89},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D268*D269*(D270/100)/D271)*D272)/D273","v":0},null,"estimated nutrient value / pig sold"]
[null,null,"Potassium"]
[null,null,null,{"$f":"'Farrow Input'!F178","v":1.1399999999999999},null,"kg per 1000 litres"]
[null,null,"x",{"$f":"D258","v":12410},null,"# of 1000 litres of manure"]
[null,null,"x",{"$f":"'Farrow Input'!H178","v":0},null,"% nutrient value recovery"]
[null,null,"÷",2.2045854999999999,null,"lbs per kg"]
[null,null,"x",{"$f":"'Farrow Input'!G178","v":0.6},null,"fertilizer value  per lb."]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"SUM((D276*D277*(D278/100)/D279)*D280)/D281","v":0},null,"estimated nutrient value / pig sold"]
[null,"   Odour control & Mgmt Fees"]
[null,null,null,{"$f":"'Farrow Input'!G170+'Farrow Input'!G171","v":3000},null,"total costs"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null,"pigs sold"]
[null,null,"=",{"$f":"D284/D285","v":0.23073690630355692},null," /pig sold"]
[]
[null,"   Total","=",{"$f":"D252+D286-(D282+D274+D266)","v":2.4606685508328452},null," /pig sold"]
[]
[null,"2.06  Office Supplies"]
[null,null,null,{"$f":"'Farrow Input'!G181","v":2},null,"$/sow"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"D291/D292","v":7.6912302101185645E-2},null,"/pig sold"]
[]
[null,"2.07  Marketing & Transportation"]
[null,null,null,{"$f":"'Farrow Input'!G185","v":0},null," trucking in"]
[null,null,"+",{"$f":"'Farrow Input'!G186","v":4.5},null," trucking out"]
[null,null,"+",{"$f":"'Farrow Input'!G187","v":0.8},null," council levy"]
[null,null,"+",{"$f":"'Farrow Input'!G188","v":0.06},null," grading charge"]
[null,null,"+",{"$f":"'Farrow Input'!G189","v":0.25},null," insurance"]
[null,null,"+",{"$f":"'Farrow Input'!G190","v":0},null," special levy"]
[null,null,"=",{"$f":"SUM(D296:D301)","v":5.6099999999999994},null," /pig sold"]
[]
[null,"2.08  AI Costs"]
[null,null,null,{"$f":"'Farrow Input'!G203","v":2.2999999999999998},null,{"$f":"'Farrow Input'!C203","v":"Number of services/sow"}]
[null,null,"x",{"$f":"'Farrow Input'!G204","v":7.5},null,{"$f":"'Farrow Input'!C204","v":"Cost/dose (semen)"}]
[null,null,"x",{"$f":"'Farrow Input'!G13","v":500},null,"sows"]
[null,null,"x",{"$f":"'Farrow Input'!G15","v":2.38},null,{"$f":"'Farrow Input'!A15","v":"Litters/Sow/Year"}]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"(((D305*D306)*D307)*D308)/D309","v":1.5788172813820882},null," /pig sold"]
[]
[null,"2.09  Herd Replacement"]
[null,"Sow ",null,{"$f":"'Farrow Input'!G193","v":180},null,"kg/sow (cull weight)"]
[null,null,"x",{"$f":"'Farrow Input'!G194","v":113.12},null,"/100 kg live"]
[null,null,"=",{"$f":"D313*D314/100","v":203.61600000000001},null,"/sow value of cull"]
[]
[null,null,null,{"$f":"'Farrow Input'!G196","v":300},null,"/sow value of replacement"]
[null,null,"-",{"$f":"D315","v":203.61600000000001},null,"/sow value of cull"]
[null,null,"=",{"$f":"D317-D315","v":96.383999999999986},null,"net replacement cost"]
[null,null,"x",{"$f":"'Farrow Input'!G192","v":40},null,"percent sow culling rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D319*D320/100)/D321","v":1.4826230651441352},null,"/pig sold"]
[]
[null,"Boar ",null,{"$f":"'Farrow Input'!G198","v":225},null,"kg/boar (cull weight)"]
[null,null,"x",{"$f":"'Farrow Input'!G199","v":80.800000000000011},null,"/100 kg live"]
[null,null,"=",{"$f":"D324*D325/100","v":181.80000000000004},null,"/boar value of cull"]
[]
[null,null,null,{"$f":"'Farrow Input'!G201","v":300},null,"/boar value of replacement"]
[null,null,"-",{"$f":"D326","v":181.80000000000004},null,"/boar value of cull"]
[null,null,"=",{"$f":"D328-D329","v":118.19999999999996},null,"net replacement cost"]
[null,null,"x",{"$f":"'Farrow Input'!G197","v":50},null,"% culling rate"]
[null,null,"x",{"$f":"'Farrow Input'!G14","v":3},null,"number of boars"]
[null,null,"÷",{"$f":"'Farrow Input'!G13","v":500},null,"number of sows"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D330*D331/100*D332/D333)/D334","v":1.3636551162540211E-2},null,"/pig sold"]
[]
[null,null,"Total",{"$f":"D322+D335","v":1.4962596163066755},null,"/pig sold"]
[]
[null,"2.10  Property Taxes"]
[null,null,null,{"$f":"'Farrow Input'!G207+'Farrow Input'!G206","v":12000},null," taxes on barn and land"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"D340/D341","v":0.92294762521422768},null," /pig sold"]
[]
[null,null,null,{"$f":"'Farrow Input'!G208","v":10},null," taxes on  land"]
[null,null,"x",{"$f":"'Farrow Input'!G212","v":0},null,"acres"]
[null,null,"÷",{"$f":"'Farrow Input'!F79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"(D344*D345)/D346","v":0},null," /pig sold"]
[]
[null,"Total",null,{"$f":"D342+D347","v":0.92294762521422768},null," /pig sold"]
[]
[null,"2.11  Interest on Operating Cost:"]
[]
[null," Sub-total Operating Cost   x   days to market   x   interest"]
[null,"                       2                                         365"]
[null,"  Interest on Operating Cost - Purchased Feed"]
[null,null,null,{"$f":"'Farrow-Finish Summary'!E29","v":254.42075434169195},null,"subtotal operating"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow Input'!F80","v":189},null,"days farrow to farrow"]
[null,null,"÷",365,null,"days per year"]
[null,null,"x",{"$f":"'Farrow Input'!G216","v":8.5},null,"% operating interest rate"]
[null,null,"=",{"$f":"((D356/D357)*D358/D359)*D360/100","v":5.5989992034236726},null,"/pig sold"]
[null,"  Interest on Operating Cost - Home Mixed Feed"]
[null,null,null,{"$f":"'Farrow-Finish Summary'!I29","v":196.70647415302739},null,"subtotal operating"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"D358","v":189},null,"days farrow to farrow"]
[null,null,"÷",365,null,"days per year"]
[null,null,"x",{"$f":"'Farrow Input'!G216","v":8.5},null,"% operating interest rate"]
[null,null,"=",{"$f":"((D363/D364)*D365/D366)*D367/100","v":4.328889735984089},null,"/pig sold"]
[]
["B. Fixed Costs"]
[]
["3. Depreciation:",null,null,"Original cost - Salvage Value"]
[null,null,null,"Useful Life"]
[]
[null,"3.01  Buildings - not including feed mill",null,null,null,null,""]
[null,null,null,{"$f":"'Farrow Input'!$H$112+'Farrow Input'!$H$126-'Farrow Input'!H103","v":1978125.4},null,"building cost (including earthen"]
[null,null,null,null,null,"manure storage)"]
[null,null,"-",{"$f":"('Farrow Input'!$H$104-'Farrow Input'!H103)*'Farrow Input'!$G$141/100","v":438426.33333333326},null,"salvage value (building only)"]
[null,null,"÷",{"$f":"'Farrow Input'!G138","v":25},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D376-D378)/D379)/D380","v":4.7368719904152092},null,"/pig sold"]
[null,"         Buildings - including feedmill",null,null,null,null,""]
[null,null,null,{"$f":"'Farrow Input'!$H$112+'Farrow Input'!$H$126","v":2023125.4},null,"building cost (including earthen"]
[null,null,null,null,null,"manure storage)"]
[null,null,"-",{"$f":"'Farrow Input'!$H$104*'Farrow Input'!$G$141/100","v":442926.33333333326},null,"salvage value (building only)"]
[null,null,"÷",{"$f":"D379","v":25},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D383-D385)/D386)/D387","v":4.8614699198191298},null,"/pig sold"]
[]
[null,"3.02  Equipment - not including feedmill"]
[null,null,null,{"$f":"'Farrow Input'!$H$112-'Farrow Input'!H111","v":1843125.4},null,"equipment cost"]
[null,null,"-",{"$f":"D391*('Farrow Input'!$G$142/100)","v":184312.54},null,"salvage value"]
[null,null,"÷",{"$f":"'Farrow Input'!G139","v":10},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D391-D392)/D393)/D394","v":12.758311581765176},null,"/pig sold"]
[null,"          Equipment - including feedmill"]
[null,null,null,{"$f":"'Farrow Input'!$H$112","v":1903125.4},null,"equipment cost"]
[null,null,"-",{"$f":"D397*('Farrow Input'!$G$142/100)","v":190312.54},null,"salvage value"]
[null,null,"÷",{"$f":"D393","v":10},null,"years useful life"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D397-D398)/D399)/D400","v":13.173638013111578},null,"/pig sold"]
[]
["4.  Investment:"]
[null,null,"(Original Cost + Salvage Value)  X  % Investment Interest"]
[null,null,null,2]
[]
[]
[null,"4.01  Land for Barn Site"]
[null,null,null,{"$f":"'Farrow Input'!H121","v":110000},null,"land investment"]
[null,null,"+",{"$f":"'Farrow Input'!H125","v":36000},null,"site preparation"]
[null,null,"x",{"$f":"'Farrow Input'!G144","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null,"pigs marketed"]
[null,null,"=",{"$f":"((D409+D410)*D411/100)/D412","v":0.30880289293626034},null,"/pig sold"]
[null,"         Land for manure application"]
[null,null,null,{"$f":"'Farrow Input'!H122","v":0},null," land investment"]
[null,null,"x",{"$f":"D411","v":2.75},null," % investment rate"]
[null,null,"÷",{"$f":"D412","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D415)*D416/100)/D417","v":0},null," /pig sold"]
[null,"         Total",null,{"$f":"D413+D418","v":0.30880289293626034},null," /pig sold"]
[]
[null,"4.02  Buildings - not including feedmill"]
[null,null,null,{"$f":"('Farrow Input'!$H$104-'Farrow Input'!H103)+'Farrow Input'!$H$126","v":4504263.333333333},null,"building cost (including"]
[null,null,null,null,null,"earthen manure storage)"]
[null,null,"+",{"$f":"('Farrow Input'!$H$104-'Farrow Input'!H103)*'Farrow Input'!$G$141/100","v":438426.33333333326},null,"salvage value (building only)"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow Input'!G144","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D422+D424)/2*D426/100)/D427","v":5.2271125614822838},null,"/pig sold"]
[null,"         Buildings - including feedmill"]
[null,null,null,{"$f":"'Farrow Input'!$H$104+'Farrow Input'!$H$126","v":4549263.333333333},null,"building cost (including"]
[null,null,null,null,null,"earthen manure storage)"]
[null,null,"+",{"$f":"'Farrow Input'!$H$104*'Farrow Input'!$G$141/100","v":442926.33333333326},null,"salvage value (building only)"]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow Input'!G144","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D430+D432)/2*D434/100)/D435","v":5.2794609970999034},null,"/pig sold"]
[]
[null,"4.03  Equipment - not including feedmill"]
[null,null,null,{"$f":"'Farrow Input'!$H$112-'Farrow Input'!H111","v":1843125.4},null,"equipment cost/sow "]
[null,null,"+",{"$f":"D439*('Farrow Input'!$G$142/100)","v":184312.54},null,"salvage value/sow "]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow Input'!G144","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D439+D440)/2*D442/100)/D443","v":2.1441051408244252},null,"/pig sold"]
[null,"          Equipment - including feedmill"]
[null,null,null,{"$f":"'Farrow Input'!$H$112","v":1903125.4},null,"equipment cost/sow "]
[null,null,"+",{"$f":"D446*('Farrow Input'!$G$142/100)","v":190312.54},null,"salvage value/sow "]
[null,null,"÷",2,null,"average"]
[null,null,"x",{"$f":"'Farrow Input'!G144","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"((D446+D447)/2*D449/100)/D450","v":2.2139030549812513},null,"/pig sold"]
[]
[null,"4.04  Breeding Stock"]
[null,null,null,{"$f":"'Farrow Input'!H118","v":185500},null,"value of breeding stock"]
[null,null,"x",{"$f":"'Farrow Input'!G144","v":2.75},null,"% investment rate"]
[null,null,"÷",{"$f":"'Farrow Input'!$F$79","v":13001.8212},null," pigs sold"]
[null,null,"=",{"$f":"(D454*D455/100)/D456","v":0.39234888109367322},null,"/pig sold"]
[]
[]
["C.  Labour"]
[null,"Farrow Wean",null,{"$f":"'Farrow Input'!F48","v":120},null,"hours/week"]
[null,null,"x",52,null,"weeks/year"]
[null,null,"x",{"$f":"'Farrow Input'!F49","v":27},null,"/hour"]
[null,null,"÷",{"$f":"'Farrow Input'!G13","v":500},null,"sows"]
[null,null,"÷",{"$f":"'Farrow Input'!$G$79","v":26.0036424},null,"pigs sold/sow/year"]
[null,null,"=",{"$f":"(D461*52*D463/'Farrow Input'!G13)/D465","v":12.958184658007756},null,"/pig sold"]
[]
[null,"Grower Finish",null,{"$f":"'Farrow Input'!F90","v":48},null,"hours/week"]
[null,null,null,52,null,"weeks/year"]
[null,null,"x",{"$f":"'Farrow Input'!F91","v":27},null," /hour"]
[null,null,"÷",{"$f":"D456","v":13001.8212},null," pigs sold/sow/year"]
[null,null,"=",{"$f":"((D468*D469)*D470)/D471","v":5.1832738632031026},null," /pig sold"]
[]
[null,"Total","=",{"$f":"D466+D472","v":18.141458521210858},null," /pig sold"]
[]
[]
["Return on Assets =",null,null," Net Income + Operating Interest + Investment Interest - Value of Unpaid Family and Operator Labour"]
[""]
["",null,"Total Assets"]
[""]
["Total Assets",null,null,"Definition: Total assets includes the buildings, equipment, land, manure storage, average value of market animals and breeding stock valued at replacement cost."]
[""]
[""]

{"sheet":"Finish-O","index":8,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"============================================================================="]
[null,"","","GROWING AND FINISHING PIG PRODUCTION SUMMARY"]
[null,"","","",null,"","","","","",""]
[null,"============================================================================="]
[null,"A. OPERATING COSTS",null,null,null,null,"","","TOTAL","$/HOG SOLD","$/PLACE"]
[null,"","1.","Feed Costs:",null,null,null,"","-----------------------------------------------------------------------"]
[null,"","","1.01","Grower Ration #1",null,null,null,{"$f":"J9*'Farrow Input'!F79","v":416708.36945999996},{"$f":"ROUND('Farrow Input'!E85*SUM('Farrow Input'!G85:H85)/1000,2)","v":32.049999999999997},{"$f":"J9*'Farrow Input'!F79/'Farrow Input'!I70","v":96.98467103791161}]
[null,null,null,"1.02","Grower Ration #2",null,null,null,{"$f":"J10*'Farrow Input'!F79","v":2127878.0575919999},{"$f":"ROUND('Farrow Input'!E86*SUM('Farrow Input'!G86:H86)/1000,2)","v":163.66},{"$f":"J10*'Farrow Input'!F79/'Farrow Input'!I70","v":495.24216106285849}]
[null,"","","1.02","Finisher Ration",null,null,null,{"$f":"J11*'Farrow Input'!F79","v":1113996.0404160002},{"$f":"ROUND('Farrow Input'!E87*SUM('Farrow Input'!G87:H87)/1000,2)","v":85.68},{"$f":"J11*'Farrow Input'!F79/'Farrow Input'!I70","v":259.27134522709105}]
[null,"","","","",null,null,null,"=================================================="]
[null,"","","Total Feed Cost",null,null,null,null,{"$f":"SUM(I9:I12)","v":3658582.467468},{"$f":"SUM(J9:J12)","v":281.39},{"$f":"SUM(K9:K12)","v":851.49817732786119}]
[null,"","","","",null,null,null,"","",""]
[null,"","2.","Other Operating Costs:",null,null,null,null,"","",""]
[null,"","","2.01","Weanling Cost **",null,null,null,{"$f":"J16*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"#REF!*'Farrow Input'!F75/'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"J16*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","2.02","Veterinary Cost",null,null,null,{"$f":"J17*'Farrow Input'!F79","v":0},{"$f":"ROUND('Farrow Input'!G150*'Farrow Input'!F60/'Farrow Input'!F79,2)","v":0},{"$f":"J17*'Farrow Input'!F79/'Farrow Input'!I70","v":0}]
[null,"","","2.03","Maintenance & Repairs",null,null,null,{"$f":"J18*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!/'Farrow Input'!F79/100,2)","v":{"$error":"#REF!"}},{"$f":"J18*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","B7","Hydro (Heat)",null,null,null,{"$f":"J19*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*#REF!*'Farrow Input'!I70/'Farrow Input'!F79,2)","v":{"$error":"#REF!"}},{"$f":"J19*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","2.05","Insurance",null,null,null,{"$f":"J20*'Farrow Input'!F79","v":49392.632119999995},{"$f":"'Farrow Finish Worksheet'!D231","v":3.7989010431861647},{"$f":"J20*'Farrow Input'!F79/'Farrow Input'!I70","v":11.495637066427129}]
[null,"","","2.06","Manure Haulage",null,null,null,{"$f":"J21*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND('Farrow Finish Worksheet'!#REF!,2)","v":{"$error":"#REF!"}},{"$f":"J21*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","2.07","Office Supplies",null,null,null,{"$f":"J22*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND(#REF!*'Farrow Input'!I70/'Farrow Input'!F79,2)","v":{"$error":"#REF!"}},{"$f":"J22*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","2.08","Marketing & Transportation",null,null,null,{"$f":"J23*'Farrow Input'!F79","v":0},{"$f":"ROUND('Farrow Input'!G184,2)","v":0},{"$f":"J23*'Farrow Input'!F79/'Farrow Input'!I70","v":0}]
[null,"","","2.09","Property Taxes",null,null,null,{"$f":"'Farrow Input'!G206","v":0},{"$f":"I24/'Farrow Input'!F79","v":0},{"$f":"J24*'Farrow Input'!F79/'Farrow Input'!I70","v":0}]
[null,"","","","",null,null,null,"================================================"]
[null,"","","Subtotal Operating Costs",null,null,null,null,{"$f":"J26*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"J13+SUM(J16:J25)","v":{"$error":"#REF!"}},{"$f":"J26*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","2.10","Interest on Operating Cost",null,null,null,{"$f":"J27*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND((J16*#REF!/100*'Farrow Input'!I64/365)+((J26-J16)*#REF!/100*'Farrow Input'!I64/365),2)","v":{"$error":"#REF!"}},{"$f":"J27*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","================================================"]
[null,"","TOTAL OPERATING COSTS",null,null,null,null,"",{"$f":"J29*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"J26+J27","v":{"$error":"#REF!"}},{"$f":"J29*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","","",""]
[null,"B. FIXED COSTS",null,null,null,null,null,"","","",""]
[null,"","3.","Depreciation:",null,null,null,"","","",""]
[null,"","","3.01","Buildings and Manure Storage",null,null,"",{"$f":"J33*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J33*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","3.02","Equipment",null,null,"",{"$f":"J34*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!-(#REF!/100*#REF!))/#REF!/'Farrow Input'!F79,2)","v":{"$error":"#REF!"}},{"$f":"J34*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","============================================="]
[null,"","","Total Depreciation Cost",null,null,null,null,{"$f":"J36*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"SUM(J32:J35)","v":{"$error":"#REF!"}},{"$f":"J36*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","","",""]
[null,"","4.","Investment:",null,null,null,"","","",""]
[null,"","","4.01","Buildings and Manure Storage",null,null,"",{"$f":"J39*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J39*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","4.02","Equipment",null,null,"",{"$f":"J40*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!+(#REF!/100*#REF!))/2*#REF!/100/'Farrow Input'!F79,2)","v":{"$error":"#REF!"}},{"$f":"J40*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","==========================================="]
[null,"","","Total Investment Cost",null,null,null,"",{"$f":"J42*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"SUM(J38:J41)","v":{"$error":"#REF!"}},{"$f":"J42*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","============================================"]
[null,"","TOTAL FIXED COSTS",null,null,null,null,null,{"$f":"J44*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"J36+J42","v":{"$error":"#REF!"}},{"$f":"J44*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"","","",""]
[null,"C. LABOUR",null,null,null,null,null,"","","",""]
[null,"","",{"$f":"'Farrow Input'!F90","v":48},"hours/wk. @",null,{"$f":"'Farrow Input'!F91","v":27}," /hour",{"$f":"J47*'Farrow Input'!F79","v":67349.433816000004},{"$f":"ROUND('Farrow Input'!H90*'Farrow Input'!F91/'Farrow Input'!F79,2)","v":5.18},{"$f":"J47*'Farrow Input'!F79/'Farrow Input'!I70","v":15.674901590526746}]
[null,"","","","","","","","==============================================="]
[null,"","TOTAL COST OF PRODUCTION",null,null,null,null,null,{"$f":"J49*'Farrow Input'!F79","v":{"$error":"#REF!"}},{"$f":"J29+J44+J47","v":{"$error":"#REF!"}},{"$f":"J49*'Farrow Input'!F79/'Farrow Input'!I70","v":{"$error":"#REF!"}}]
[null,"","",null,null,null,null,"","","",""]
[null,"","BREAK-EVEN PRICE (carcass)",null,null,null,null,"$/100 kg","$/CWT","",""]
[null,"","",null,null,null,null,"----------------------","-----------------------","",""]
[null,"","Operating Cost",null,null,null,null,{"$f":"J29/('Farrow Input'!H62*'Farrow Input'!H55*'Farrow Input'!H54)*1000000","v":{"$error":"#REF!"}},{"$f":"H53/2.2046","v":{"$error":"#REF!"}},"",""]
[null,"","Operating & Labour Cost",null,null,null,null,{"$f":"H53+J47/('Farrow Input'!H62*'Farrow Input'!H55*'Farrow Input'!H54)*1000000","v":{"$error":"#REF!"}},{"$f":"H54/2.2046","v":{"$error":"#REF!"}},"",""]
[null,"","Operating, Labour & Fixed Cost",null,null,null,null,{"$f":"H54+J44/('Farrow Input'!H62*'Farrow Input'!H55*'Farrow Input'!H54)*1000000","v":{"$error":"#REF!"}},{"$f":"H55/2.2046","v":{"$error":"#REF!"}},"",""]
[null,"","",null,null,null,null,"","","",""]
[null,"","Break-even Price = Cost per Hog Sold / (Slaughter Wt. X  Dressing % X Index)"]
[]
[null,null,"** Footnote on Weanling Cost:  This is not the price paid for the weanling.  Because"]
[null,"","    this figure is expressed on a \"per hog sold\" basis, it includes death loss."]

{"sheet":"Weaner-O","index":9,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"============================================================================="]
[null,"","WEANER PIG PRODUCTION COST SUMMARY",null,null,null,null,null,"",""]
[null,"","","","","","","","",""]
[null,"============================================================================="]
[null,"A.","OPERATING COSTS",null,null,null,null,"     TOTAL","$/HOG SOLD","$/SOW/YR"]
[null,"","1.","Feed Costs:",null,"","","------------------------------------------------------------------------"]
[null,"","","A1","Sow Lactation Ration",null,null,{"$f":"ROUND('Farrow Input'!G16*'Farrow Input'!F24*'Farrow Input'!E33*'Farrow Input'!M33/1000*'Farrow Input'!G13,2)","v":179859.04},{"$f":"ROUND(J9/'Farrow Input'!$G$79,2)","v":13.83},{"$f":"ROUND('Farrow Input'!G16*'Farrow Input'!F24*'Farrow Input'!E33*'Farrow Input'!M33/1000,2)","v":359.72}]
[null,"","","1.02","Sow Gestation Ration",null,null,{"$f":"ROUND((365-'Farrow Input'!G16*'Farrow Input'!F24)*'Farrow Input'!E32*'Farrow Input'!M32/1000*'Farrow Input'!G13,2)","v":436945.06},{"$f":"ROUND(J10/'Farrow Input'!$G$79,2)","v":33.61},{"$f":"ROUND((365-'Farrow Input'!G16*'Farrow Input'!F24)*'Farrow Input'!E32*'Farrow Input'!M32/1000,2)","v":873.89}]
[null,"","","1.03","Boar Ration",null,null,{"$f":"ROUND(365*'Farrow Input'!E34*'Farrow Input'!M34/1000*'Farrow Input'!E23/'Farrow Input'!E22*'Farrow Input'!G13,2)","v":3125.59},{"$f":"ROUND(J11/'Farrow Input'!$G$79,2)","v":0.24},{"$f":"ROUND(365*'Farrow Input'!E34*'Farrow Input'!M34/1000*'Farrow Input'!E23/'Farrow Input'!E22,2)","v":6.25}]
[null,"","","1.04","Creep Feed",null,null,{"$f":"ROUND('Farrow Input'!E35*'Farrow Input'!M35/1000*'Farrow Input'!F25*'Farrow Input'!G13,2)","v":29039.62},{"$f":"ROUND(J12/'Farrow Input'!$G$79,2)","v":2.23},{"$f":"ROUND('Farrow Input'!E35*'Farrow Input'!M35/1000*'Farrow Input'!F25,2)","v":58.08}]
[null,"","","1.05","Starter Ration #1",null,null,{"$f":"ROUND('Farrow Input'!E36*'Farrow Input'!M36/1000*'Farrow Input'!F29*'Farrow Input'!G13,2)","v":98179.81},{"$f":"ROUND(J13/'Farrow Input'!$G$79,2)","v":7.55},{"$f":"ROUND('Farrow Input'!E36*'Farrow Input'!M36/1000*'Farrow Input'!F29,2)","v":196.36}]
[null,null,null,"1.05","Starter Ration #2",null,null,{"$f":"ROUND('Farrow Input'!E37*'Farrow Input'!M37/1000*'Farrow Input'!F29*'Farrow Input'!G13,2)","v":234446.19},{"$f":"ROUND(J14/'Farrow Input'!$G$79,2)","v":18.03},{"$f":"ROUND('Farrow Input'!E37*'Farrow Input'!M37/1000*'Farrow Input'!F29,2)","v":468.89}]
[null,"","","","","","","===================================="]
[null,"","","Total Feed Cost",null,null,null,{"$f":"J16*'Farrow Input'!E22","v":981595},{"$f":"ROUND(J16/'Farrow Input'!$G$79,2)","v":75.5},{"$f":"SUM(J8:J15)","v":1963.19}]
[null,"","","","",null,null,"","",""]
[null,"","2.","Other Operating Costs:",null,null,null,"","",""]
[null,"","","A7","Vet. Medicine & Supplies:",null,null,"","",""]
[null,"","","","    Professional Services",null,null,{"$f":"J20*'Farrow Input'!E22","v":5000},{"$f":"ROUND(J20/'Farrow Input'!$G$79,2)","v":0.38},{"$f":"ROUND('Farrow Input'!G148,2)","v":10}]
[null,"","","","    Medication",null,null,{"$f":"J21*'Farrow Input'!E22","v":32500},{"$f":"ROUND(J21/'Farrow Input'!$G$79,2)","v":2.5},{"$f":"ROUND('Farrow Input'!G149,2)","v":65}]
[null,"","","A8","Maintenance & Repairs",null,null,{"$f":"J22*'Farrow Input'!E22","v":82320},{"$f":"ROUND(J22/'Farrow Input'!$G$79,2)","v":6.33},{"$f":"ROUND('Farrow Input'!G152*'Farrow Input'!I113/100,2)","v":164.64}]
[null,"","","A9","Hydro (Heat)",null,null,{"$f":"J23*'Farrow Input'!E22","v":{"$error":"#REF!"}},{"$f":"ROUND(J23/'Farrow Input'!$G$79,2)","v":{"$error":"#REF!"}},{"$f":"ROUND('Farrow Input'!#REF!*'Farrow Input'!#REF!,2)","v":{"$error":"#REF!"}}]
[null,"","","2.04","Insurance",null,null,{"$f":"(+'Farrow Input'!$H$113+'Farrow Input'!$H$118)*'Farrow Input'!G160/100","v":50839.532119999996},{"$f":"ROUND(J24/'Farrow Input'!$G$79,2)","v":3.91},{"$f":"H24/'Farrow Input'!G13","v":101.67906423999999}]
[null,"","","2.05","Manure Haulage",null,null,{"$f":"J25*'Farrow Input'!E22","v":35},{"$f":"ROUND(J25/'Farrow Input'!$G$79,2)","v":0},{"$f":"ROUND('Farrow Input'!G167/1000*'Farrow Input'!G168*365,2)","v":7.0000000000000007E-2}]
[null,"","","2.06","Office Supplies",null,null,{"$f":"J26*'Farrow Input'!E22","v":1500},{"$f":"ROUND(J26/'Farrow Input'!$G$79,2)","v":0.12},{"$f":"ROUND((500+(2*'Farrow Input'!E22))/'Farrow Input'!E22,2)","v":3}]
[null,"","","2.07","Marketing & Transportation",null,null,{"$f":"J27*'Farrow Input'!E22","v":0},{"$f":"ROUND(J27/'Farrow Input'!$G$79,2)","v":0},{"$f":"ROUND('Farrow Input'!G183*'Farrow Input'!F29,2)","v":0}]
[null,"","","2.08","Sow Replacement",null,null,{"$f":"J28*'Farrow Input'!E22","v":19275},{"$f":"ROUND(J28/'Farrow Input'!$G$79,2)","v":1.48},{"$f":"ROUND('Farrow Input'!G192/100*('Farrow Input'!G196-('Farrow Input'!G193*'Farrow Input'!G194/100)),2)","v":38.549999999999997}]
[null,"","","2.09","Boar Replacement",null,null,{"$f":"J29*'Farrow Input'!E22","v":175},{"$f":"ROUND(J29/'Farrow Input'!$G$79,2)","v":0.01},{"$f":"ROUND('Farrow Input'!G197/100*'Farrow Input'!E23*('Farrow Input'!G201-('Farrow Input'!G198*'Farrow Input'!G199/100))/'Farrow Input'!E22,2)","v":0.35}]
[null,null,null,"2.09","Property Taxes",null,null,{"$f":"'Farrow Input'!#REF!","v":{"$error":"#REF!"}},{"$f":"ROUND(J30/'Farrow Input'!$G$79,2)","v":{"$error":"#REF!"}},{"$f":"H30/'Farrow Input'!G13","v":{"$error":"#REF!"}}]
[null,"","","","",null,null,"===================================="]
[null,"","","","Subtotal Operating Costs",null,null,{"$f":"SUM(H15:H31)","v":{"$error":"#REF!"}},{"$f":"ROUND(J32/'Farrow Input'!$G$79,2)","v":{"$error":"#REF!"}},{"$f":"H32/'Farrow Input'!G13","v":{"$error":"#REF!"}}]
[null,"","","2.10","Interest on Operating Cost",null,null,{"$f":"J33*'Farrow Input'!E22","v":72797.186541857023},{"$f":"'Farrow Finish Worksheet'!D361","v":5.5989992034236726},{"$f":"I33*'Farrow Input'!G79","v":145.59437308371403}]
[null,"","","","","","","===================================="]
[null,"","TOTAL OPERATING COSTS",null,null,null,"",{"$f":"J35*'Farrow Input'!E22","v":{"$error":"#REF!"}},{"$f":"ROUND(J35/'Farrow Input'!$G$79,2)","v":{"$error":"#REF!"}},{"$f":"SUM(J32:J33)","v":{"$error":"#REF!"}}]
[null,"","",null,null,null,"","","",""]
[null,"B.","FIXED COSTS",null,null,null,"","","",""]
[null,"","3.","Depreciation:",null,null,null,"","",""]
[null,"","","3.01","Buildings and Manure Storage",null,null,{"$f":"J39*'Farrow Input'!E22","v":2368.4359952076047},{"$f":"ROUND(J39/'Farrow Input'!F29,2)","v":0.17},{"$f":"'Farrow Finish Worksheet'!D381","v":4.7368719904152092}]
[null,"","","3.02","Equipment",null,null,{"$f":"J40*'Farrow Input'!E22","v":171280},{"$f":"ROUND(J40/'Farrow Input'!F29,2)","v":12.49},{"$f":"ROUND(('Farrow Input'!I112-('Farrow Input'!G142/100*'Farrow Input'!I112))/'Farrow Input'!G139,2)","v":342.56}]
[null,"","","","",null,null,"===================================="]
[null,"","","Total Depreciation Cost",null,null,null,{"$f":"J42*'Farrow Input'!E22","v":173648.4359952076},{"$f":"ROUND(J42/'Farrow Input'!F29,2)","v":12.66},{"$f":"SUM(J38:J41)","v":347.29687199041518}]
[null,"","","","",null,null,"","",""]
[null,"","4.","Investment:",null,null,null,"","",""]
[null,"","","4.01","Buildings and Manure Storage",null,null,{"$f":"J45*'Farrow Input'!E22","v":2613.556280741142},{"$f":"ROUND(J45/'Farrow Input'!F29,2)","v":0.19},{"$f":"'Farrow Finish Worksheet'!D428","v":5.2271125614822838}]
[null,"","","4.02","Equipment",null,null,{"$f":"J46*'Farrow Input'!E22","v":28785},{"$f":"ROUND(J46/'Farrow Input'!F29,2)","v":2.1},{"$f":"ROUND(('Farrow Input'!I112+('Farrow Input'!G142/100*'Farrow Input'!I112))/2*'Farrow Input'!G144/100,2)","v":57.57}]
[null,"","","4.03","Breeding Herd",null,null,{"$f":"J47*'Farrow Input'!E22","v":5100},{"$f":"ROUND(J47/'Farrow Input'!F29,2)","v":0.37},{"$f":"ROUND('Farrow Input'!I118*'Farrow Input'!G144/100,2)","v":10.199999999999999}]
[null,"","","","",null,null,"===================================="]
[null,"","","Total Investment Cost",null,null,null,{"$f":"J49*'Farrow Input'!E22","v":36498.556280741141},{"$f":"ROUND(J49/'Farrow Input'!F29,2)","v":2.66},{"$f":"SUM(J44:J48)","v":72.997112561482282}]
[null,"","","","",null,null,"===================================="]
[null,"","TOTAL FIXED COSTS",null,null,null,null,{"$f":"J51*'Farrow Input'!E22","v":210146.99227594872},{"$f":"ROUND(J51/'Farrow Input'!F29,2)","v":15.32},{"$f":"J42+J49","v":420.29398455189744}]
[null,"","","","",null,null,"","",""]
[null,"C.","LABOUR",null,null,"","","","",""]
[null,"","",{"$f":"'Farrow Input'!F48","v":120},"hours/wk.",null,null,{"$f":"J54*'Farrow Input'!E22","v":168480},{"$f":"ROUND(J54/'Farrow Input'!F29,2)","v":12.28},{"$f":"ROUND('Farrow Input'!F48*'Farrow Input'!F49*52/'Farrow Input'!E22,2)","v":336.96}]
[null,"","","","","","","===================================="]
[null,"","TOTAL COST OF PRODUCTION",null,null,null,"",{"$f":"J56*'Farrow Input'!E22","v":{"$error":"#REF!"}},{"$f":"ROUND(J56/'Farrow Input'!F29,2)","v":{"$error":"#REF!"}},{"$f":"J35+J51+J54","v":{"$error":"#REF!"}}]
[]
[null,"============================================================================="]
[null,"","","","","Revenue per pig sold:",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"","","","","",null,null,null,""]
[null,"","","","","Net of Operating Cost",null,null,null,{"$f":"IF(J59=0,0,J59-I35)","v":{"$error":"#REF!"}}]
[null,"","","","","Net of Operating & Labour Cost",null,null,null,{"$f":"IF(J59=0,0,J61-I54)","v":{"$error":"#REF!"}}]
[null,"","","","","Net of Operating, Labour & Fixed Cost",null,null,null,{"$f":"IF(J59=0,0,J62-I51)","v":{"$error":"#REF!"}}]

{"sheet":"Ingredient-Summary","index":10,"n_rows":72,"n_cols":8,"rows_kept":72,"cut":false,"hidden":false,"merged":[[23,1,23,8],[2,1,2,8]]}
[]
[]
[null,"  Summary of Purchased Feeds Used"]
[]
[null,null,"Farrow finish ",null,{"$f":"'Farrow Input'!G13","v":500},"sows"]
[null,null,"Total sold",null,{"$f":"'Farrow Input'!F79","v":13001.8212},"pigs sold"]
[]
[null,null,null,null,"Total","Total","Total","Total"]
[null,null,null,null,"per Year","per Month","per Pig","per Pig"]
[null,null,null,null,"(tonnes)","(tonnes)","(kgs)","(lbs)"]
[]
[null,{"$f":"'Farrow Input'!A32","v":"Dry Sow Ration"},null,null,{"$f":"IF('Farrow Input'!G32<=0,0,(('Farrow Input'!E32*'Farrow Finish Worksheet'!D30)*E5)/1000)","v":464.65449999999998},{"$f":"E12/12","v":38.72120833333333},{"$f":"E12/$E$6*1000","v":35.737647276675361},{"$f":"G12*2.2046","v":78.7872171861585}]
[null,{"$f":"'Farrow Input'!A33","v":"Nursing Sow Ration"},null,null,{"$f":"IF('Farrow Input'!G33<=0,0,(('Farrow Input'!E33*'Farrow Finish Worksheet'!D11)*E5)/1000)","v":163.18469999999999},13.598725,12.550910944691347,27.669738268666546]
[null,{"$f":"'Farrow Input'!A34","v":"Boar Ration"},null,null,{"$f":"IF('Farrow Input'!G34<=0,0,(('Farrow Input'!E34*'Farrow Finish Worksheet'!D37)*'Farrow Input'!E23)/1000)","v":3.2850000000000001},0.27374999999999999,0.2526569124023948,0.55700742908231959]
[null,{"$f":"'Farrow Input'!A35","v":"Per Starter 1(Ration 1)"},null,null,{"$f":"IF('Farrow Input'!G35<=0,0,('Farrow Input'!E35*'Farrow Input'!E27)/1000)","v":8.15306},0.6794216666666667,0.62707061376909257,1.3824398751153415]
[null,{"$f":"'Farrow Input'!A36","v":"Pre Starter 2 (Ration 2)"},null,null,{"$f":"IF('Farrow Input'!G36<=0,0,('Farrow Input'!E36*'Farrow Input'!E27)/1000)","v":40.765299999999996},3.3971083333333332,3.1353530688454629,6.9121993755767077]
[null,{"$f":"'Farrow Input'!A37","v":"Starter 1 (Ration 3)"},null,null,{"$f":"IF('Farrow Input'!G37<=0,0,('Farrow Input'!E37*'Farrow Input'!E27)/1000)","v":126.51300000000001},10.54275,9.7304060757273003,21.451653234548406]
[null,{"$f":"'Farrow Input'!A38","v":"Starter 2 (Ration 4)"},null,null,{"$f":"IF('Farrow Input'!G38<=0,0,('Farrow Input'!E38*'Farrow Input'!E27)/1000)","v":224.91200000000001},18.742666666666668,17.298499690181863,38.13627241697494]
[null,{"$f":"'Farrow Input'!B85","v":"Starter"},null,null,{"$f":"IF('Farrow Input'!G85<=0,0,('Farrow Input'!E85*'Farrow Input'!E27)/1000)","v":383.75610000000006},31.979675000000004,29.515565096372811,65.070014811463508]
[null,{"$f":"'Farrow Input'!B86","v":"Grower"},null,null,{"$f":"IF('Farrow Input'!G86<=0,0,('Farrow Input'!E86*'Farrow Input'!E27)/1000)","v":2319.4050000000002},193.28375000000003,178.39077805500051,393.28030930005417]
[null,{"$f":"'Farrow Input'!B87","v":"Finish"},null,null,{"$f":"IF('Farrow Input'!G87<=0,0,('Farrow Input'!E87*'Farrow Input'!E27)/1000)","v":1279.1869999999999},106.59891666666665,98.385216987909345,216.90004937154495]
[null,"Total",null,null,{"$f":"SUM(E12:E21)","v":5013.8156600000002},{"$f":"SUM(F12:F21)","v":417.81797166666666},{"$f":"SUM(G12:G21)","v":385.62410472157552},{"$f":"SUM(H12:H21)","v":850.14690126918538}]
[]
[null,"  Summary of Home Mixed Feed Ingredients Used"]
[null,null,null,null,"Total","Total","Total","Total"]
[null," ",null,null,"per Year","per Month","per Pig","per Pig"]
[null,null,null,null,"(tonnes)","(tonnes)","(kgs)","(lbs)"]
[null,{"$f":"'Feed Input'!B4","v":"  Wheat"},null,null,{"$f":"'Feed Input'!H111+'Feed Input'!I136+'Feed Input'!H162","v":828.5584742100001},{"$f":"E28/12","v":69.046539517500008},{"$f":"E28/$E$6*1000","v":63.726339676936959},{"$f":"G28*2.2046","v":140.49108845177523}]
[null,{"$f":"'Feed Input'!B5","v":"  Barley "},null,null,{"$f":"'Feed Input'!H112+'Feed Input'!I137+'Feed Input'!H163","v":2965.6129663000002},247.13441385833335,228.09212037925889,{"$f":"G29*2.2046","v":502.85188858811415}]
[null,{"$f":"'Feed Input'!B6","v":"  Corn "},null,null,{"$f":"'Feed Input'!H113+'Feed Input'!I138+'Feed Input'!H164","v":87.631338},7.3026115000000003,6.7399279417871085,{"$f":"G30*2.2046","v":14.85884514046386}]
[null,{"$f":"'Feed Input'!B7","v":"  Soybean Meal "},null,null,{"$f":"'Feed Input'!H114+'Feed Input'!I139+'Feed Input'!H165","v":347.35547810000003},28.946289841666669,26.715909468128974,58.897894013437138]
[null,{"$f":"'Feed Input'!B8","v":"  Canola Meal"},null,null,{"$f":"'Feed Input'!H115+'Feed Input'!I140+'Feed Input'!H166","v":366.80666150000008},30.567221791666672,28.211944762015346,62.196053422339034]
[null,{"$f":"'Feed Input'!B9","v":"  Peas "},null,null,{"$f":"'Feed Input'!H116+'Feed Input'!I141+'Feed Input'!H167","v":125.096335},10.424694583333332,9.6214471092711218,21.211442297099115]
[null,{"$f":"'Feed Input'!B10","v":"  Sow Micro Premix "},null,null,{"$f":"'Feed Input'!H117+'Feed Input'!I142+'Feed Input'!H168","v":5.1573378000000005},0.42977815000000003,0.39666272291146415,0.87448263893061395]
[null,{"$f":"'Feed Input'!B11","v":"  Grower Micro Premix "},null,null,{"$f":"'Feed Input'!H118+'Feed Input'!I143+'Feed Input'!H169","v":11.6555286},0.97129405000000002,0.8964535368322093,1.9763214673002887]
[null,{"$f":"'Feed Input'!B12","v":"  Canola Oil "},null,null,{"$f":"'Feed Input'!H119+'Feed Input'!I144+'Feed Input'!H170","v":25.315107319999996},2.1095922766666662,1.9470431819197755,4.2924513988603374]
[null,{"$f":"'Feed Input'!B13","v":"  Whey Powder "},null,null,{"$f":"'Feed Input'!H120+'Feed Input'!I145+'Feed Input'!H171","v":21.826022760000001},1.8188352300000001,1.6786896561844737,3.7008392160242911]
[null,{"$f":"'Feed Input'!B14","v":"  Fish Meal"},null,null,{"$f":"'Feed Input'!H121+'Feed Input'!I146+'Feed Input'!H172","v":15.71403916},1.3095032633333334,1.2086029271037813,2.6644860130929962]
[null,{"$f":"'Feed Input'!B15","v":"  Plasma"},null,null,{"$f":"'Feed Input'!H122+'Feed Input'!I147+'Feed Input'!H173","v":0.48103054000000001},4.0085878333333332E-2,3.6997166212376462E-2,8.1563952631805145E-2]
[null,{"$f":"'Feed Input'!B16","v":"  Limestone "},null,null,{"$f":"'Feed Input'!H123+'Feed Input'!I148+'Feed Input'!H174","v":50.855114449999995},4.2379262041666665,3.9113839259687704,8.6230370031907508]
[null,{"$f":"'Feed Input'!B17","v":"  Dical (16% Ca-21% P) "},null,null,{"$f":"'Feed Input'!H124+'Feed Input'!I149+'Feed Input'!H175","v":17.8753648},1.4896137333333332,1.3748354576664998,3.0309622499715658]
[null,{"$f":"'Feed Input'!B18","v":"  Salt - 96% "},null,null,{"$f":"'Feed Input'!H125+'Feed Input'!I150+'Feed Input'!H176","v":17.453030210000001},1.4544191841666667,1.3423527320926396,2.9593508331714333]
[null,{"$f":"'Feed Input'!B19","v":"  Phytase"},null,null,{"$f":"'Feed Input'!H126+'Feed Input'!I151+'Feed Input'!H177","v":2.4338627000000002},0.20282189166666667,0.18719398325520736,0.41268785548443015]
[null,{"$f":"'Feed Input'!B20","v":"  L-Lysine HCL "},null,null,{"$f":"'Feed Input'!H127+'Feed Input'!I152+'Feed Input'!H178","v":3.1762710800000002},0.26468925666666671,0.24429432086021918,0.53857125976843923]
[null,{"$f":"'Feed Input'!B21","v":"  L-Threonine "},null,null,{"$f":"'Feed Input'!H128+'Feed Input'!I153+'Feed Input'!H179","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B22","v":"  D L-Methionine "},null,null,{"$f":"'Feed Input'!H129+'Feed Input'!I154+'Feed Input'!H180","v":0},0,0,0]
[null,{"$f":"'Feed Input'!B23","v":"  Oats - Groats"},null,null,{"$f":"'Feed Input'!H129+'Feed Input'!I154+'Feed Input'!H181","v":0},0,0,0]
[null,"Total Ration Used  ",null,null,{"$f":"SUM(E28:E47)","v":4893.0039625300005},{"$f":"SUM(F28:F47)","v":407.7503302108334},{"$f":"SUM(G28:G47)","v":376.33219894840573},{"$f":"SUM(H28:H47)","v":829.66196580165547}]
[]
[null,"Total",null,null,{"$f":"E22+E48","v":9906.8196225300017},{"$f":"F22+F48","v":825.56830187750006},{"$f":"G22+G48","v":761.95630366998125},{"$f":"H22+H48","v":1679.8088670708407}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Processing Cost",null,null,"cost/tonne"]
[]
[null,null,null,null,"Labour",null,{"$f":"'Feed Input'!E27","v":10}]
[null,null,null,null,"Hydro, fuel, etc.",null,{"$f":"'Feed Input'!E25","v":10}]
[null,null,null,null,"Feed Mill Depreciation",null,{"$f":"IF(ISERR(('Farrow Input'!H111/10)/'Ingredient-Summary'!E48),0,('Farrow Input'!H111/10)/'Ingredient-Summary'!E48)","v":1.226240576534831}]
[null,null,null,null,"Feed Mill Investment",null,{"$f":"IF(ISERR((('Farrow Input'!H111/2)*'Farrow Input'!G144/100)/'Ingredient-Summary'!E48),0,(('Farrow Input'!H111/2)*'Farrow Input'!G144/100)/'Ingredient-Summary'!E48)","v":0.16860807927353924}]
[null,null,null,null,"Building Depreciation",null,{"$f":"IF(ISERR(('Farrow Input'!H103/10)/'Ingredient-Summary'!E48),0,('Farrow Input'!H103/10)/'Ingredient-Summary'!E48)","v":0.91968043240112318}]
[null,null,null,null,"Building Investment",null,{"$f":"IF(ISERR((('Farrow Input'!H103/2)*'Farrow Input'!G144/100)/'Ingredient-Summary'!E48),0,(('Farrow Input'!H103/2)*'Farrow Input'!G144/100)/'Ingredient-Summary'!E48)","v":0.12645605945515442}]
[null,null,null,null,null,null,{"$f":"SUM(G63:G68)","v":22.440985147664648}]
[null,null,null,null,"Weight loss adjustment",null,{"$f":"G69*'Feed Input'!E26/100","v":0.28051231434580809}]
[null,null,null,null,{"$f":"'Feed Input'!E26/100","v":1.2500000000000001E-2}]
[null,null,null,null,"Total Processing Cost",null,{"$f":"G69+G70","v":22.721497462010458}]