{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Main","Winter Grazing","Feed Cost","Procurement","Fixed_Cost","Fixed_Payment","G","H","I","J","K","L"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":124,"comments":1,"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":"Instructions","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"REMEMBER"]
[]
[null,null,null,null,null,null,"  In order to Print a specific budget"]
[null,null,"Budget","Button",null,null,"  you must Calculate before you"]
[null,null," Type",null,null,null,"  Print that particular budget."]
[]
[null,null,"TOTAL","  "]
[null,null,"COST"]
[]
[null,null,"CASH "]
[null,null,"FLOW"]
[]
[null,null," VARIABLE "]
[null,null,"COST"]
[]
[null,null,"Note: Be sure to enable all"]
[null,null,"macros on start-up."]

{"sheet":"Main","index":1,"n_rows":253,"n_cols":48,"rows_kept":253,"cut":false,"hidden":false,"merged":[[15,1,15,9],[14,1,14,9],[0,1,0,9],[1,1,1,9],[2,1,2,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[3,1,3,9],[102,5,102,7],[76,1,76,4],[77,1,77,4],[78,1,78,4],[101,5,101,8],[93,1,93,9],[94,1,94,9],[17,7,17,8],[18,7,18,8],[19,7,19,8],[53,1,53,8],[42,1,42,3],[34,1,34,3],[39,1,39,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[40,1,40,3],[59,1,59,3],[75,1,75,4],[58,1,58,3],[74,1,74,4],[41,1,41,3],[43,1,43,3],[44,1,44,3],[49,1,49,3],[38,1,38,3],[90,1,90,9],[92,1,92,9],[82,1,82,9],[70,1,70,8],[54,1,54,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[31,1,33,3],[31,4,33,4],[31,5,33,5],[31,8,33,8],[31,6,33,6],[31,7,33,7]]}
[null,"Stockering Lightweight Steers On Cover Crop Temporary Winter Grazing, Hay & Supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"R. Curt Lacy and Lawton Stewart"]
[null,"Agricultural & Applied Economics and Animal & Dairy Science Departments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3]
[null,"University of Georgia Cooperative Extension Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"(Total Cost Budget)"]
[null,"October 2012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"(Cash Flow Budget)"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"(Variable Cost Budget)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"INPUT DATA: Your values in the unprotected or highlighted cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"RISK RATED RETURNS OVER TOTAL COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"RISK RATED RETURNS OVER CASH FLOW COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"RISK RATED RETURNS OVER VARIABLE COST"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Stockering Steers On Temporary Winter Grazing, Hay & Supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"(Variable Cost Budget)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF ACRES",null,null,null,50,null,"In Date",null,"2004-11-15",null,null,null,null,null,null,null,null," "]
[null,"STOCKING RATE (HEAD/ACRE)",null,null,null,2,null,"Out Date",null,{"$f":"+J18+F23","v":"2005-03-15"},"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF CALVES PLACED",null,null,null,{"$f":"F18*F19","v":100},null,"Expected Buy-Sell Margin",null,-15,null,null,null,null,null,null,null,null," "]
[null,"DEATH LOSS (%)",null,null,null,1,null,null,null,null,"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF CALVES SOLD",null,null,null,{"$f":"+F20*((100-F21)/100)","v":99},null,null,null,null,"",null,null,null,null,null,null,null,"          "]
[null,"FEEDING PERIOD (DAYS)",null,null,null,120]
[null,"MARKETING SHRINK(%)",null,null,null,3]
[]
[null,null,null,null,null,"BEST","OPT.","MEDIAN","PESS.","WORST",""]
[null,"PAYWEIGHT TO PAYWEIGHT",null,null,null,{"$f":"+G27+0.25","v":2.5},{"$f":"+H27+0.25","v":2.25},2,{"$f":"+H27-0.25","v":1.75},{"$f":"+I27-0.25","v":1.5},""]
[null,"DAILY GAIN (LBS./DAY)",null,null,null,null,null,null,null,null,""]
[null,"NET SELLING WEIGHT (CWT.)",null,null,null,{"$f":"(F27*F23/100+F36)","v":7},{"$f":"(G27*F23/100+F36)","v":6.7},{"$f":"(H27*F23/100+F36)","v":6.4},{"$f":"(I27*F23/100+F36)","v":6.1},{"$f":"(J27*F23/100+F36)","v":5.8},""]
[null,"SELLING PRICE ($/CWT.)",null,null,null,155,{"$f":"+(F30+H30)/2","v":150},145,{"$f":"+(H30+J30)/2","v":140},135,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,"Item",null,null,"Unit"," Units Per Head","Total Quantity (units)"," Unit Price ($/Unit)","Total Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"VARIABLE COSTS:"]
[null,"CALF",null,null,"CWT.",4,{"$f":"+F36*placed","v":400},160,{"$f":"G36*H36","v":64000},null,null,null,null,null,null,null,null,null," "]
["Procurement Detail","PROCUREMENT COST",null,null,"HEAD",1,100,{"$f":"+Procurement!H10","v":7.4411764705882355},744.11764705882354,null,null,null,null,null,null,null,null,null," "]
["Winter Grazing Detail","WINTER GRAZING",null,null,"ACRE",{"$f":"1/F19","v":0.5},50,{"$f":"+tvc_grazing/ACRES","v":126.69904109589041},6334.9520547945203,null,null,null,null,null,null,null,null,null," "]
[null,"HAY",null,null,"TON",{"$f":"5*0.03","v":0.15},15,100,1500,null,null,null,null,null,null,null,null,null," "]
[null,"RECEIVING RATION",null,null,"TONS",{"$f":"12.5*6*7/2000","v":0.26250000000000001},26.25,275,7218.75,null,null,null,null,null,null,null,null,null," "]
[null,"SUPPLEMENTAL FEED",null,null,"TONS",{"$f":"11*0.015","v":0.16499999999999998},16.499999999999996,275,4537.4999999999991]
[null,"MINERAL + IONOPHORE",null,null,"LBS.",{"$f":"+F23*0.25","v":30},3000,0.28000000000000003,840.00000000000011,null,null,null,null,null,null,null,"*",null," "]
[null,"MEDICATION,WORM,VAC.",null,null,"HEAD",2,200,4,800]
[null,"GROW.STIMULANT",null,null,"IMPLANT",2,200,1,200]
[null,"REPAIRS",null,null,"HEAD",1,100,{"$f":"AVERAGE(Fixed_Cost!F30:G31)*0.02/Fixed_Cost!G6","v":0.80230769230769228},80.230769230769226]
[null,"LAND RENTAL",null,null,"ACRE",{"$f":"F38","v":0.5},50,0,0]
[null,"LABOR",null,null,"HRS.",2,200,9.02,1804]
[null,"DEATH LOSS",null,null,"PERCENT",0.01,{"$f":"+I36","v":64000},null,{"$f":"+F48*G48","v":640}]
[null,"INTEREST ON OP. CAP.",null,null,"PERCENT",0.08,{"$f":"+(SUM(I36:I48)*0.5)/placed","v":443.49775235542052},{"$f":"+G49*(F49*F23/365)","v":11.664598418115169},{"$f":"G49*H49/365*F23","v":1700.7857031986862}]
["Auction & Hauling Detail","AUCTION AND HAULING",null,null,"HEAD",1,{"$f":"F50*F20","v":100},{"$f":"+mktng_cst","v":27.268333333333331},{"$f":"G50*H50","v":2726.833333333333}]
[]
[null,"TOTAL VARIABLE COST",null,null,null,"",null,null,{"$f":"SUM(I36:I50)","v":93127.169507616127}]
[]
[null,{"$f":"+IF(bud_type=3,\"No Fixed Costs for Variable Cost Budget\",\"FIXED COST:(Click Appropriate Link at Left for Annual Fixed Cost)\")","v":"No Fixed Costs for Variable Cost Budget"}]
["Total Cost",{"$f":"+IF(bud_type=1,\"Total Cattle Equipment Fixed Costs\",IF(bud_type=2,\"Total Fixed Cash Payments\",\"\"))","v":""},null,null,{"$f":"+IF(bud_type<>3,\"Head Sold\",\"\")","v":""},{"$f":"+IF(bud_type<>3,+ROUNDUP(sold,0),0)","v":0},null,{"$f":"+IF(bud_type<>3,I55/sold,0)","v":0},{"$f":"+IF(bud_type=1,cattle_fixed,IF(bud_type=2,cf_total,0))","v":0}]
["Cash Flow",{"$f":"+IF(bud_type=1,\"Total Machinery Fixed Costs\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Acres\",\"\")","v":""},{"$f":"+IF(bud_type=1,ACRES,0)","v":0},null,{"$f":"+IF(bud_type=1,I56/ACRES,0)","v":0},{"$f":"+IF(bud_type=1,mach_fixed,0)","v":0}]
[null,{"$f":"+IF(bud_type=1,\"Overhead\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Head Sold\",\"\")","v":""},{"$f":"+IF(bud_type=1,+ROUNDUP(sold,0),0)","v":0},null,0,{"$f":"+IF(bud_type=1,H57*F57,0)","v":0},""]
[null,{"$f":"+IF(bud_type=1,\"Management \",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"% of Value Added\",\"\")","v":""},{"$f":"+IF(bud_type=1,(H88-I36),0)","v":0},null,0.06,{"$f":"+IF(bud_type=1,H58*F58,0)","v":0},""]
[null,{"$f":"+IF(bud_type=1,\"Land\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Acres\",\"\")","v":""},{"$f":"+IF(bud_type=1,ACRES,0)","v":0},null,0,{"$f":"+IF(bud_type=1,H59*F59,0)","v":0},""]
[null,"TOTAL FIXED COST",null,null,null,null,"","",{"$f":"SUM(I55:I59)","v":0},""]
[]
[null,"      COST OF GAIN SUMMARY AND MAX. BREAKEVEN CALF PRICE"]
[null,null,null,null,null,null,null,null,"   $/CWT."]
[null,"FEED ONLY COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"SUM(I38:I42)/(D88-G36)","v":87.462337563332653}]
[null,"FEEDING COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+I52-I36-I37)/(D88-G36)","v":121.50279049896098}]
[null,"TOTAL COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+F80-I36-I37)/(D88-G36)","v":121.50279049896098}]
[]
[null,"MAX. BREAKEVEN PURCHASE PRICE OF CALF",null,null,null,null,null,null,{"$f":"+(+H88-(+F80-I36))/G36","v":156.86207623095973}]
[]
[]
[null,"EXPECTED BREAKEVEN TABLE"]
[]
[null,"ITEM",null,null," TOTAL AMOUNT",null,null,"$ / CWT.","    $/HD."]
[null,"VARIABLE COST",null,null,null,{"$f":"I52","v":93127.169507616127},null,{"$f":"F74/(U168*F20)","v":145.51120235565017},{"$f":"+F74/sold","v":940.67847987491041}]
[null,{"$f":"+B55","v":""},null,null,null,{"$f":"IF(I55>0,I55,0)","v":0},null,{"$f":"IF(F75>0,F75/(U168*F20),0)","v":0},0]
[null,{"$f":"+B56","v":""},null,null,null,{"$f":"I56","v":0},null,{"$f":"F76/(U168*F20)","v":0},0]
[null,{"$f":"+B57","v":""},null,null,null,{"$f":"I57","v":0},null,{"$f":"F77/(U168*F20)","v":0},0]
[null,{"$f":"+B58","v":""},null,null,null,{"$f":"I58","v":0},null,{"$f":"F78/(U168*F20)","v":0},0]
[null,{"$f":"+B59","v":""},null,null,null,{"$f":"I59","v":0},null,{"$f":"F79/(U168*F20)","v":0},0]
[null,"TOTAL COST",null,null,null,{"$f":"SUM(F74:F79)","v":93127.169507616127},null,{"$f":"F80/(U168*F20)","v":145.51120235565017},940.67847987491041]
[]
[]
[null,"EXPECTED RETURN TABLE"]
[null,null,null,null,{"$f":"+sold","v":99}," head sold"]
[]
[null,"EXP. WEIGHT",null,"TOTAL WEIGHT",null,"EXP. PRICE",null,"TOTAL RETURN"]
[null,"(cwt./hd.)",null,"  (cwt.)",null,"  ($/cwt.)"]
[null,{"$f":"+U168","v":6.4000000000000012},null,{"$f":"+B88*sold","v":633.60000000000014},null,{"$f":"+W168","v":145},null,{"$f":"+F88*D88","v":91872.000000000015}]
[]
[]
[null,"RISK RATED RETURNS OVER VARIABLE COST"]
[null,null,null,null,null,null,null,null,null,""]
[null,"Net return levels (TOP ROW);"]
[null,"The chances of obtaining this level or more (MIDDLE ROW); and"]
[null,"The chances of obtaining this level or less (BOTTOM ROW)."]
[]
[null,null,null,null,"Optimistic",null,"Expected",null,"  Pessimistic"]
[null,"Returns",null,{"$f":"U207:U207+1.5*W206:W206","v":7773.1777071642446},{"$f":"U207:U207+W206:W206","v":5073.0619689041259},{"$f":"U207:U207+0.5*W206:W206","v":2372.9462306440068},{"$f":"U207:U207","v":-327.16950761611224},{"$f":"U207:U207-0.5*W207:W207","v":-3027.2852458762386},{"$f":"U207:U207-W207:W207","v":-5727.400984136365},{"$f":"U207:U207-1.5*W207:W207","v":-8427.5167223964909}]
[null,"Chances",null,{"$f":"IF(V210<1,IF(U210,Z210,1-Z210),IF(U210,Z211,1-Z211))","v":6.6807279375848461E-2},{"$f":"IF(AB210<1,IF(AA210,AF210,1-AF210),IF(AA210,AF211,1-AF211))","v":0.15865531316113046},{"$f":"IF(AH210<1,IF(AG210,AL210,1-AL210),IF(AG210,AL211,1-AL211))","v":0.30853755861792781},{"$f":"IF(V212<1,IF(U212,Z212,1-Z212),IF(U212,Z213,1-Z213))","v":0.50000000022538427},{"$f":"IF(AB212<1,IF(AA212,AF212,1-AF212),IF(AA212,AF213,1-AF213))","v":0.69146244138207236},{"$f":"IF(AH212<1,IF(AG212,AL212,1-AL212),IF(AG212,AL213,1-AL213))","v":0.84134468683886943},{"$f":"IF(V214<1,IF(U214,Z214,1-Z214),IF(U214,Z215,1-Z215))","v":0.93319272062415137}]
[null,"Chances",null,{"$f":"IF(V210<1,IF(U210,1-Z210,Z210),IF(U210,1-Z211,Z211))","v":0.93319272062415148},{"$f":"IF(AB210<1,IF(AA210,1-AF210,AF210),IF(AA210,1-AF211,AF211))","v":0.84134468683886954},{"$f":"IF(AH210<1,IF(AG210,1-AL210,AL210),IF(AG210,1-AL211,AL211))","v":0.69146244138207225},{"$f":"IF(V212<1,IF(U212,1-Z212,Z212),IF(U212,1-Z213,Z213))","v":0.49999999977461573},{"$f":"IF(AB212<1,IF(AA212,1-AF212,AF212),IF(AA212,1-AF213,AF213))","v":0.30853755861792764},{"$f":"IF(AH212<1,IF(AG212,1-AL212,AL212),IF(AG212,1-AL213,AL213))","v":0.15865531316113052},{"$f":"IF(V214<1,IF(U214,1-Z214,Z214),IF(U214,1-Z215,Z215))","v":6.6807279375848669E-2}]
[]
[null,"  CHANCE FOR PROFIT ",null,null,{"$f":"IF(AB214<1,IF(AA214,AF214,1-AF214),IF(AA214,AF215,1-AF215))","v":0.47584504979702297},"BASE BUDGETED NET REVENUE ",null,null,null,{"$f":"+U155*H29*H30-F80","v":-327.16950761612679}]
[null,null,null,null,null,"Profit (Loss) Per Head Placed",null,null,null,{"$f":"+J102/placed","v":-3.2716950761612678}]
[]
[null,"PROFIT IS RETURN TO RISK AND ALL \"ZERO\" ITEMS IN THE BUDGET."]
[null,"MAY ENTER YOUR OWN VALUES."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","    Must match budget Entries",null,null,null,"*",null,"          ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","-",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+F20","v":100},"HEAD",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+F29","v":7},"  Best Y",{"$f":"+F30","v":155},"  Best P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,"*",{"$f":"+G29","v":6.7},"  Opt. Y",{"$f":"+G30","v":150},"  Opt. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H29","v":6.4},"  Med. Y",{"$f":"H30","v":145},"  Med. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+I29","v":6.1},"  Pess. Y",{"$f":"I30","v":140},"  Pess. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+J29","v":5.8},"  Worst Y",{"$f":"J30","v":135},"  Worst P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",0,"  H&MC",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+F80","v":93127.169507616127},"  T.C.",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","*",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",null,"Calculations",null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.04*U156+0.25*U157+0.42*U158+0.25*U159+0.04*U160","v":6.4000000000000012},"  Exp. Y",{"$f":"0.04*W156+0.25*W157+0.42*W158+0.25*W159+0.04*W160","v":145},"  Exp. P",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(U156-U168)+0.5*(U157-U168)","v":0.29999999999999916},"  SYO",{"$f":"0.25*(W156-W168)+0.5*(W157-W168)","v":5},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(U168-U160)+0.5*(U168-U159)","v":0.30000000000000115},"  SYP",{"$f":"0.25*(W168-W160)+0.5*(W168-W159)","v":5},"  SPP",":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U169^2","v":8.9999999999999497E-2},"  VYO",{"$f":"W169^2","v":25},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U170^2","v":9.0000000000000691E-2},"  VYP",{"$f":"W170^2","v":25},"  VPP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"(U168^2*W180)+(W168-U161)^2*U180","v":2916.24999999999},"  VTRHH",{"$f":"(U168^2*W181)+(W168-U161)^2*U181","v":2916.250000000015},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(U168^2*W180)+(W168-U161)^2*U181","v":2916.250000000015},"  VTRHL",{"$f":"U168^2*W181+(W168-U161)^2*U180","v":2916.24999999999},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U183)","v":54.002314765202335},"  STRHH",{"$f":"SQRT(W183)","v":54.002314765202563},"  STRLL",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U184)","v":54.002314765202563},"  STRHL",{"$f":"SQRT(W184)","v":54.002314765202335},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*U185+0.17*U187+0.17*W187","v":54.002314765202378},"  STRO",{"$f":"0.66*W185+0.17*U187+0.17*W187","v":54.002314765202527},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","Calculation of NR and for Z values",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"W158","v":145},"  MP",{"$f":"+U207-U205","v":0},"ENR_MNR",":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",":",{"$f":"U158","v":6.4},"  MY",{"$f":"U155*U185","v":5400.2314765202336},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+U206+0.33*(W207-W206)","v":92800.000000000015},"  MTR",{"$f":"U155*W185","v":5400.2314765202564},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+F80","v":93127.169507616127},"  MTC",{"$f":"U155*U187","v":5400.2314765202564},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,":",{"$f":"U203-U204","v":-327.16950761611224},"  MNR",{"$f":"U155*W187","v":5400.2314765202336},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"U155*U168*W168","v":92800.000000000015},"  ETR",{"$f":"U155*U188","v":5400.2314765202382},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U206-U204","v":-327.16950761611224},"  ENR",{"$f":"U155*W188","v":5400.2314765202527},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D98>=U205","v":true},{"$f":"ABS((D98-U207)/IF(U210,W206,W207))","v":1.5},{"$f":"MIN(2.5,ABS((D98-(U205+W201*ABS(D98-U205)/ABS(IF(U210,W206+W201,W207-W201))*MIN(1,V210)))/(MIN(1.52,V210)/1.52*IF(U210,W202,W203)+(1.52-MIN(1.52,V210))/3.04*W204+(1.52-MIN(1.52,V210))/3.04*W205)))","v":1.5000000000000011},{"$f":"1/(1+(0.2316419*W210))","v":0.74213548818804154},{"$f":"0.398942281*((2.71828)^((-(W210^2)/2)))","v":0.1295176938706632},{"$f":"Y210*(0.31938153*X210-0.356563782*X210^2+1.781477937*X210^3-1.821255978*X210^4+1.330274429*X210^5)","v":6.6807279375848461E-2},{"$f":"+E98>=U205","v":true},{"$f":"ABS((E98-U207)/IF(AA210,W206,W207))","v":1},{"$f":"MIN(2.5,ABS((E98-(U205+W201*ABS(E98-U205)/ABS(IF(AA210,W206+W201,W207-W201))*MIN(1,AB210)))/(MIN(1.52,AB210)/1.52*IF(AA210,W202,W203)+(1.52-MIN(1.52,AB210))/3.04*W204+(1.52-MIN(1.52,AB210))/3.04*W205)))","v":1.0000000000000002},{"$f":"1/(1+(0.2316419*AC210))","v":0.81192431014242039},{"$f":"0.398942281*((2.71828)^((-(AC210^2)/2)))","v":0.24197080626333928},{"$f":"AE210*(0.31938153*AD210-0.356563782*AD210^2+1.781477937*AD210^3-1.821255978*AD210^4+1.330274429*AD210^5)","v":0.15865531316113046},{"$f":"+F98>=U205","v":true},{"$f":"ABS((F98-U207)/IF(AG210,W206,W207))","v":0.5},{"$f":"MIN(2.5,ABS((F98-(U205+W201*ABS(F98-U205)/ABS(IF(AG210,W206+W201,W207-W201))*MIN(1,AH210)))/(MIN(1.52,AH210)/1.52*IF(AG210,W202,W203)+(1.52-MIN(1.52,AH210))/3.04*W204+(1.52-MIN(1.52,AH210))/3.04*W205)))","v":0.49999999999999972},{"$f":"1/(1+(0.2316419*AI210))","v":0.89620113334491525},{"$f":"0.398942281*((2.71828)^((-(AI210^2)/2)))","v":0.35206535689474699},{"$f":"AK210*(0.31938153*AJ210-0.356563782*AJ210^2+1.781477937*AJ210^3-1.821255978*AJ210^4+1.330274429*AJ210^5)","v":0.30853755861792781}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((D98-U207)/(MIN(1.52,V210)/1.52*IF(U210,W202,W203)+(1.52-MIN(1.52,V210))/3.04*W204+(1.52-MIN(1.52,V210))/3.04*W205)))","v":1.5000000000000011},0.74213548818804154,0.1295176938706632,6.6807279375848461E-2,null,null,{"$f":"MIN(2.5,ABS((E98-U207)/(MIN(1.52,AB210)/1.52*IF(AA210,W202,W203)+(1.52-MIN(1.52,AB210))/3.04*W204+(1.52-MIN(1.52,AB210))/3.04*W205)))","v":1.0000000000000002},0.81192431014242039,0.24197080626333928,0.15865531316113046,null,null,{"$f":"MIN(2.5,ABS((F98-U207)/(MIN(1.52,AH210)/1.52*IF(AG210,W202,W203)+(1.52-MIN(1.52,AH210))/3.04*W204+(1.52-MIN(1.52,AH210))/3.04*W205)))","v":0.49999999999999972},{"$f":"1/(1+(0.2316419*AI211))","v":0.89620113334491525},{"$f":"0.398942281*((2.71828)^((-(AI211^2)/2)))","v":0.35206535689474699},{"$f":"AK211*(0.31938153*AJ211-0.356563782*AJ211^2+1.781477937*AJ211^3-1.821255978*AJ211^4+1.330274429*AJ211^5)","v":0.30853755861792781}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"+G98>=U205","v":true},{"$f":"ABS((G98-U207)/IF(U212,W206,W207))","v":0},{"$f":"MIN(2.5,ABS((G98-(U205+W201*ABS(G98-U205)/ABS(IF(U212,W206+W201,W207-W201))*MIN(1,V212)))/(MIN(1.52,V212)/1.52*IF(U212,W202,W203)+(1.52-MIN(1.52,V212))/3.04*W204+(1.52-MIN(1.52,V212))/3.04*W205)))","v":0},1,0.39894228100000001,0.50000000022538427,{"$f":"+H98>=U205","v":false},{"$f":"ABS((H98-U207)/IF(AA212,W206,W207))","v":0.5},{"$f":"MIN(2.5,ABS((H98-(U205+W201*ABS(H98-U205)/ABS(IF(AA212,W206+W201,W207-W201))*MIN(1,AB212)))/(MIN(1.52,AB212)/1.52*IF(AA212,W202,W203)+(1.52-MIN(1.52,AB212))/3.04*W204+(1.52-MIN(1.52,AB212))/3.04*W205)))","v":0.50000000000000044},0.89620113334491525,0.35206535689474683,0.30853755861792764,{"$f":"+I98>=U205","v":false},{"$f":"ABS((I98-U207)/IF(AG212,W206,W207))","v":1},{"$f":"MIN(2.5,ABS((I98-(U205+W201*ABS(I98-U205)/ABS(IF(AG212,W206+W201,W207-W201))*MIN(1,AH212)))/(MIN(1.52,AH212)/1.52*IF(AG212,W202,W203)+(1.52-MIN(1.52,AH212))/3.04*W204+(1.52-MIN(1.52,AH212))/3.04*W205)))","v":1},{"$f":"1/(1+(0.2316419*AI212))","v":0.81192431014242039},{"$f":"0.398942281*((2.71828)^((-(AI212^2)/2)))","v":0.24197080626333936},{"$f":"AK212*(0.31938153*AJ212-0.356563782*AJ212^2+1.781477937*AJ212^3-1.821255978*AJ212^4+1.330274429*AJ212^5)","v":0.15865531316113052}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((G98-U207)/(MIN(1.52,V212)/1.52*IF(U212,W202,W203)+(1.52-MIN(1.52,V212))/3.04*W204+(1.52-MIN(1.52,V212))/3.04*W205)))","v":0},1,0.39894228100000001,0.50000000022538427,null,null,{"$f":"MIN(2.5,ABS((H98-U207)/(MIN(1.52,AB212)/1.52*IF(AA212,W202,W203)+(1.52-MIN(1.52,AB212))/3.04*W204+(1.52-MIN(1.52,AB212))/3.04*W205)))","v":0.50000000000000044},0.89620113334491525,0.35206535689474683,0.30853755861792764,null,null,{"$f":"MIN(2.5,ABS((I98-U207)/(MIN(1.52,AH212)/1.52*IF(AG212,W202,W203)+(1.52-MIN(1.52,AH212))/3.04*W204+(1.52-MIN(1.52,AH212))/3.04*W205)))","v":1},{"$f":"1/(1+(0.2316419*AI213))","v":0.81192431014242039},{"$f":"0.398942281*((2.71828)^((-(AI213^2)/2)))","v":0.24197080626333936},{"$f":"AK213*(0.31938153*AJ213-0.356563782*AJ213^2+1.781477937*AJ213^3-1.821255978*AJ213^4+1.330274429*AJ213^5)","v":0.15865531316113052}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"+J98>=U205","v":false},{"$f":"ABS((J98-U207)/IF(U214,W206,W207))","v":1.5},{"$f":"MIN(2.5,ABS((J98-(U205+W201*ABS(J98-U205)/ABS(IF(U214,W206+W201,W207-W201))*MIN(1,V214)))/(MIN(1.52,V214)/1.52*IF(U214,W202,W203)+(1.52-MIN(1.52,V214))/3.04*W204+(1.52-MIN(1.52,V214))/3.04*W205)))","v":1.4999999999999991},0.74213548818804176,0.12951769387066356,6.6807279375848669E-2,{"$f":"0>=U205","v":true},{"$f":"ABS((0-U207)/IF(AA214,W206,W207))","v":6.0584348844789027E-2},{"$f":"MIN(2.5,ABS((0-(U205+W201*ABS(0-U205)/ABS(IF(AA214,W206+W201,W207-W201))*MIN(1,AB214)))/(MIN(1.52,AB214)/1.52*IF(AA214,W202,W203)+(1.52-MIN(1.52,AB214))/3.04*W204+(1.52-MIN(1.52,AB214))/3.04*W205)))","v":6.0584348844788957E-2},0.9861603502200712,0.39821080140900084,0.47584504979702297]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"MIN(2.5,ABS((J98-U207)/(MIN(1.52,V214)/1.52*IF(U214,W202,W203)+(1.52-MIN(1.52,V214))/3.04*W204+(1.52-MIN(1.52,V214))/3.04*W205)))","v":1.4999999999999991},0.74213548818804176,0.12951769387066356,6.6807279375848669E-2,null,null,{"$f":"MIN(2.5,ABS((0-U207)/(MIN(1.52,AB214)/1.52*IF(AA214,W202,W203)+(1.52-MIN(1.52,AB214))/3.04*W204+(1.52-MIN(1.52,AB214))/3.04*W205)))","v":6.0584348844788957E-2},0.9861603502200712,0.39821080140900084,0.47584504979702297]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXPDATA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U155","v":100},{"$f":"U168","v":6.4000000000000012},{"$f":"W168","v":145},{"$f":"I80","v":940.67847987491041},{"$f":"W206","v":5400.2314765202382},{"$f":"W207","v":5400.2314765202527},{"$f":"W202","v":5400.2314765202336},{"$f":"W204","v":5400.2314765202564},{"$f":"W203","v":5400.2314765202564},{"$f":"W205","v":5400.2314765202336}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Winter Grazing","index":2,"n_rows":266,"n_cols":48,"rows_kept":266,"cut":false,"hidden":false,"merged":[[11,1,11,10],[70,2,70,7],[59,2,59,7],[17,1,17,4],[25,1,25,3],[26,1,26,3],[27,1,27,3],[48,1,48,4],[42,1,42,6]]}
[null,"Winter Annual Grazing Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,3,2,1]
[]
[null,"Ext. Ag. Econ. Dept., Univ. of Ga.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Total Cost Budget)"]
[null,"Revised 2003",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Cash Flow Budget)"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Variable Cost Budget)"]
[]
[null,"INPUT DATA: Your values in the unprotected or highlighted cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECT FIXED COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL FIXED PAYMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECT FIXED COST"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RISK RATED RETURNS OVER TOTAL COST"]
[null,"Cover Crop Temporary Winter Grazing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RISK RATED RETURNS OVER CASH FLOW COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RISK RATED RETURNS OVER VARIABLE COST"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"(Variable Cost Budget)",null,null,null,"Return to Main budget",""]
[null,"Number of Acres",null,null,null,{"$f":"+ACRES","v":50}]
[null,"Number of 1,000 # Animal Units/acre",null,null,null,1]
[null,"Expected number of grazing days/acre",null,null,null,150]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null," UNITS","TOTAL","UNIT","TOTAL","YOUR"]
[null,"    ITEM",null,null,null,"UNIT","PER ACRE","QUANTITY","PRICE","AMOUNT","FARM"]
[null,"VARIABLE COSTS:",null,null,null,null,null,"  (units)"," ($/unit)"]
[null,"SEED"]
[null," Wheat",null,null,null,"BU",0,{"$f":"G26*ACRES","v":0},11.5,{"$f":"H26*I26","v":0}]
[null," Rye",null,null,null,"BU",1,60,11.5,{"$f":"H27*I27","v":690}]
[null," Oats",null,null,null,"BU",1,60,8,{"$f":"H28*I28","v":480}]
[null,"LIME",null,null,null,"TON",0,{"$f":"G29*F16","v":0},24,{"$f":"H29*I29","v":0}]
[null,"FERTILIZER:",null,null,null,null,null,""]
[null,"  NITROGEN",null,null,null,"LB.",135,{"$f":"G31*F16","v":6750},0.75,{"$f":"H31*I31","v":5062.5}]
[null,"  PHOSPHATE",null,null,null,"LB.",0,{"$f":"G32*F16","v":0},0.2,{"$f":"H32*I32","v":0}]
[null,"  POTASH",null,null,null,"LB.",0,{"$f":"G33*F16","v":0},0.17,{"$f":"H33*I33","v":0}]
[null,"MACHINERY",null,null,null,null,null,""]
[null,"  FUEL",null,null,null,"GAL.",0,{"$f":"G35*F16","v":0},1,{"$f":"H35*I35","v":0}]
[null,"  REPAIRS & MAINT.",null,null,null,"ACRE",0,{"$f":"G36*F16","v":0},12.08,{"$f":"H36*I36","v":0}]
[null,"LAND RENTAL",null,null,null,"ACRE",0,{"$f":"G37*F16","v":0},0,{"$f":"H37*I37","v":0}]
[null,"LABOR",null,null,null,"HRS.",0,{"$f":"G38*F16","v":0},9.02,{"$f":"H38*I38","v":0}]
[null,"Custom Planting",null,null,null,"Acre",0,{"$f":"G39*F16","v":0},14,{"$f":"H39*I39","v":0}]
[null,"INTEREST ON OP. CAP.",null,null,null,"%",1,{"$f":"SUM(J25:J39)*0.5","v":3116.25},0.08,{"$f":"+(I40*H40)*days/365","v":102.45205479452055}]
[null,"TOTAL VARIABLE COST",null,null,null,null,"",null,null,{"$f":"SUM(J25:J40)","v":6334.9520547945203}]
[]
["Calculate Fixed Cost",{"$f":"IF($R$1=3,\"FIXED COST:(No Fixed Cost for Variable Cost Budget\",\"FIXED COST:(Click Appropriate Link for Calculation of Fixed Costs or Payments)\")","v":"FIXED COST:(No Fixed Cost for Variable Cost Budget"},null,null,null,null,null,{"$f":"IF($R$1<>3,ACRES,\"\")","v":""},{"$f":"IF($R$1=1,TFC,IF($R$1=2,payment,\"\"))","v":""},{"$f":"IF($R$1<>3,I43*H43,\"\")","v":""}]
["Calculate Fixed Payment",{"$f":"IF($R$1=1,\"OVERHEAD\",\" \")","v":" "},null,null,null,{"$f":"IF($R$1=1,\"ACRE\",\" \")","v":" "},null,{"$f":"IF($R$1=1,ACRES,\"\")","v":""},{"$f":"IF($R$1=1,3,\"\")","v":""},{"$f":"IF($R$1=1,I44*H44,\"\")","v":""}]
[null,{"$f":"IF($R$1=1,\"MANAGEMENT\",\" \")","v":" "},null,null,null,{"$f":"IF($R$1=1,\"% EXPENSES\",\" \")","v":" "},null,{"$f":"IF($R$1=1,tVC,\"\")","v":""},{"$f":"IF($R$1=1,0.05,\"\")","v":""},{"$f":"IF($R$1=1,I45*H45,\"\")","v":""}]
[null,{"$f":"IF($R$1=1,\"LAND\",\" \")","v":" "},null,null,null,{"$f":"IF($R$1=1,\"ACRE\",\" \")","v":" "},null,{"$f":"IF($R$1=1,ACRES,\"\")","v":""},{"$f":"IF($R$1=1,0,\" \")","v":" "},{"$f":"IF($R$1=1,I46*H46,\"\")","v":""}]
[null,"TOTAL  FIXED COST",null,null,null,"","","","",{"$f":"+SUM(J43:J46)","v":0}]
[]
[null,"TOTAL COST ",null,null,null,null,null,null,null,{"$f":"+J47+tvc_grazing","v":6334.9520547945203}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SENSITIVITY ANALYSIS-VARIABLE COSTS"]
[]
[null,null,"Cost Per Grazing Day at Various Combinations of Grazing Days & Costs Per Acre "]
[null,null,null,-0.25,-0.1,"Expected","+10%","+25%",null,null,""]
[null,null,"Grazing Days",{"$f":"+F62*0.75","v":4751.21404109589},{"$f":"+F62*0.9","v":5701.4568493150682},{"$f":"+tvc_grazing","v":6334.9520547945203},{"$f":"+F62*1.1","v":6968.4472602739734},{"$f":"+F62*1.25","v":7918.6900684931506}]
[null,null,30,{"$f":"+D$62/$C63","v":158.373801369863},190.0485616438356,211.16506849315067,232.28157534246577,263.95633561643837]
[null,null,60,79.186900684931501,95.024280821917799,105.58253424657534,116.14078767123289,131.97816780821918]
[null,null,90,52.791267123287668,63.349520547945204,70.388356164383566,77.427191780821929,87.985445205479451]
[null,null,120,39.593450342465751,47.512140410958899,52.791267123287668,58.070393835616443,65.989083904109592]
[null,null,150,31.674760273972598,38.009712328767122,42.233013698630138,46.456315068493154,52.791267123287668]
[null,null,180,26.395633561643834,31.674760273972602,35.194178082191783,38.713595890410964,43.992722602739725,null,null,""]
[]
[]
[null,null,"Grazing Days Required to Breakeven at Various Dollars Per Day Drylot Cost & Per Acre Cost"]
[null,null,null,-0.25,-0.1,"Expected","+10%","+25%"]
[null,null,"$/Day Drylot Costs",{"$f":"+D62","v":4751.21404109589},{"$f":"+E62","v":5701.4568493150682},{"$f":"+F62","v":6334.9520547945203},{"$f":"+G62","v":6968.4472602739734},{"$f":"+H62","v":7918.6900684931506}]
[null,null,0.25,{"$f":"+D$73/$C74","v":19004.85616438356},22805.827397260273,25339.808219178081,27873.789041095893,31674.760273972603]
[null,null,{"$f":"+C74+0.25","v":0.5},9502.42808219178,11402.913698630136,12669.904109589041,13936.894520547947,15837.380136986301]
[null,null,{"$f":"+C75+0.25","v":0.75},6334.9520547945203,7601.9424657534246,8446.6027397260277,9291.2630136986318,10558.253424657534]
[null,null,{"$f":"+C76+0.25","v":1},4751.21404109589,5701.4568493150682,6334.9520547945203,6968.4472602739734,7918.6900684931506]
[null,null,{"$f":"+C77+0.25","v":1.25},3800.9712328767118,4561.1654794520546,5067.9616438356161,5574.7578082191785,6334.9520547945203,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","    Must match budget Entries",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","-",null,null,null,"*"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+F16","v":50},"ACRE",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Best Y",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Best P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Opt. Y",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Opt. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Med. Y",{"$f":"#REF!","v":{"$error":"#REF!"}},"  Med. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Pess. Y",{"$f":"#REF!","v":{"$error":"#REF!"}},"  Pess. P","*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+#REF!","v":{"$error":"#REF!"}},"  Worst Y",{"$f":"J20","v":0},"  Worst P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",0,"  H&MC",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+G67","v":46.456315068493154},"  T.C.",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","*",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",null,"Calculations",null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.04*P101+0.25*P102+0.42*P103+0.25*P104+0.04*P106","v":{"$error":"#REF!"}},"  Exp. Y",{"$f":"0.04*R101+0.25*R102+0.42*R103+0.25*R104+0.04*R106","v":{"$error":"#REF!"}},"  Exp. P",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(P101-P115)+0.5*(P102-P115)","v":{"$error":"#REF!"}},"  SYO",{"$f":"0.25*(R101-R115)+0.5*(R102-R115)","v":{"$error":"#REF!"}},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(P115-P106)+0.5*(P115-P104)","v":{"$error":"#REF!"}},"  SYP",{"$f":"0.25*(R115-R106)+0.5*(R115-R104)","v":{"$error":"#REF!"}},"  SPP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P117^2","v":{"$error":"#REF!"}},"  VYO",{"$f":"R117^2","v":{"$error":"#REF!"}},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P118^2","v":{"$error":"#REF!"}},"  VYP",{"$f":"R118^2","v":{"$error":"#REF!"}},"  VPP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(P115^2*R119)+(R115-P107)^2*P119","v":{"$error":"#REF!"}},"  VTRHH",{"$f":"(P115^2*R120)+(R115-P107)^2*P120","v":{"$error":"#REF!"}},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(P115^2*R119)+(R115-P107)^2*P120","v":{"$error":"#REF!"}},"  VTRHL",{"$f":"P115^2*R120+(R115-P107)^2*P119","v":{"$error":"#REF!"}},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(P122)","v":{"$error":"#REF!"}},"  STRHH",{"$f":"SQRT(R122)","v":{"$error":"#REF!"}},"  STRLL",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(P123)","v":{"$error":"#REF!"}},"  STRHL",{"$f":"SQRT(R123)","v":{"$error":"#REF!"}},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*P124+0.17*P126+0.17*R126","v":{"$error":"#REF!"}},"  STRO",{"$f":"0.66*R124+0.17*P126+0.17*R126","v":{"$error":"#REF!"}},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","Calculation of NR and for Z values",null,null,null,":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"R103","v":{"$error":"#REF!"}},"  MP",{"$f":"+P146-P144","v":{"$error":"#REF!"}},"ENR_MNR",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P103","v":{"$error":"#REF!"}},"  MY",{"$f":"P100*P124","v":{"$error":"#REF!"}},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+P145+0.33*(R146-R145)","v":{"$error":"#REF!"}},"  MTR",{"$f":"P100*R124","v":{"$error":"#REF!"}},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+G67","v":46.456315068493154},"  MTC",{"$f":"P100*P126","v":{"$error":"#REF!"}},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P142-P143","v":{"$error":"#REF!"}},"  MNR",{"$f":"P100*R126","v":{"$error":"#REF!"}},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P100*P115*R115","v":{"$error":"#REF!"}},"  ETR",{"$f":"P100*P127","v":{"$error":"#REF!"}},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P145-P143","v":{"$error":"#REF!"}},"  ENR",{"$f":"P100*R127","v":{"$error":"#REF!"}},"  STRP",":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((D87-P146)/IF(P149,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((D87-(P144+R140*ABS(D87-P144)/ABS(IF(P149,R145+R140,R146-R140))*MIN(1,Q149)))/(MIN(1.52,Q149)/1.52*IF(P149,R141,R142)+(1.52-MIN(1.52,Q149))/3.04*R143+(1.52-MIN(1.52,Q149))/3.04*R144)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*R149))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(R149^2)/2)))","v":{"$error":"#REF!"}},{"$f":"T149*(0.31938153*S149-0.356563782*S149^2+1.781477937*S149^3-1.821255978*S149^4+1.330274429*S149^5)","v":{"$error":"#REF!"}},{"$f":"+E87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((E87-P146)/IF(V149,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((E87-(P144+R140*ABS(E87-P144)/ABS(IF(V149,R145+R140,R146-R140))*MIN(1,W149)))/(MIN(1.52,W149)/1.52*IF(V149,R141,R142)+(1.52-MIN(1.52,W149))/3.04*R143+(1.52-MIN(1.52,W149))/3.04*R144)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*X149))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(X149^2)/2)))","v":{"$error":"#REF!"}},{"$f":"Z149*(0.31938153*Y149-0.356563782*Y149^2+1.781477937*Y149^3-1.821255978*Y149^4+1.330274429*Y149^5)","v":{"$error":"#REF!"}},{"$f":"+F87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((F87-P146)/IF(AB149,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((F87-(P144+R140*ABS(F87-P144)/ABS(IF(AB149,R145+R140,R146-R140))*MIN(1,AC149)))/(MIN(1.52,AC149)/1.52*IF(AB149,R141,R142)+(1.52-MIN(1.52,AC149))/3.04*R143+(1.52-MIN(1.52,AC149))/3.04*R144)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*AD149))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(AD149^2)/2)))","v":{"$error":"#REF!"}},{"$f":"AF149*(0.31938153*AE149-0.356563782*AE149^2+1.781477937*AE149^3-1.821255978*AE149^4+1.330274429*AE149^5)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((D87-P146)/(MIN(1.52,Q149)/1.52*IF(P149,R141,R142)+(1.52-MIN(1.52,Q149))/3.04*R143+(1.52-MIN(1.52,Q149))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((E87-P146)/(MIN(1.52,W149)/1.52*IF(V149,R141,R142)+(1.52-MIN(1.52,W149))/3.04*R143+(1.52-MIN(1.52,W149))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((F87-P146)/(MIN(1.52,AC149)/1.52*IF(AB149,R141,R142)+(1.52-MIN(1.52,AC149))/3.04*R143+(1.52-MIN(1.52,AC149))/3.04*R144)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*AD150))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(AD150^2)/2)))","v":{"$error":"#REF!"}},{"$f":"AF150*(0.31938153*AE150-0.356563782*AE150^2+1.781477937*AE150^3-1.821255978*AE150^4+1.330274429*AE150^5)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((G87-P146)/IF(P151,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((G87-(P144+R140*ABS(G87-P144)/ABS(IF(P151,R145+R140,R146-R140))*MIN(1,Q151)))/(MIN(1.52,Q151)/1.52*IF(P151,R141,R142)+(1.52-MIN(1.52,Q151))/3.04*R143+(1.52-MIN(1.52,Q151))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"+H87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((H87-P146)/IF(V151,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((H87-(P144+R140*ABS(H87-P144)/ABS(IF(V151,R145+R140,R146-R140))*MIN(1,W151)))/(MIN(1.52,W151)/1.52*IF(V151,R141,R142)+(1.52-MIN(1.52,W151))/3.04*R143+(1.52-MIN(1.52,W151))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"+I87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((I87-P146)/IF(AB151,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((I87-(P144+R140*ABS(I87-P144)/ABS(IF(AB151,R145+R140,R146-R140))*MIN(1,AC151)))/(MIN(1.52,AC151)/1.52*IF(AB151,R141,R142)+(1.52-MIN(1.52,AC151))/3.04*R143+(1.52-MIN(1.52,AC151))/3.04*R144)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*AD151))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(AD151^2)/2)))","v":{"$error":"#REF!"}},{"$f":"AF151*(0.31938153*AE151-0.356563782*AE151^2+1.781477937*AE151^3-1.821255978*AE151^4+1.330274429*AE151^5)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((G87-P146)/(MIN(1.52,Q151)/1.52*IF(P151,R141,R142)+(1.52-MIN(1.52,Q151))/3.04*R143+(1.52-MIN(1.52,Q151))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((H87-P146)/(MIN(1.52,W151)/1.52*IF(V151,R141,R142)+(1.52-MIN(1.52,W151))/3.04*R143+(1.52-MIN(1.52,W151))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((I87-P146)/(MIN(1.52,AC151)/1.52*IF(AB151,R141,R142)+(1.52-MIN(1.52,AC151))/3.04*R143+(1.52-MIN(1.52,AC151))/3.04*R144)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*AD152))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(AD152^2)/2)))","v":{"$error":"#REF!"}},{"$f":"AF152*(0.31938153*AE152-0.356563782*AE152^2+1.781477937*AE152^3-1.821255978*AE152^4+1.330274429*AE152^5)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J87>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((J87-P146)/IF(P153,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((J87-(P144+R140*ABS(J87-P144)/ABS(IF(P153,R145+R140,R146-R140))*MIN(1,Q153)))/(MIN(1.52,Q153)/1.52*IF(P153,R141,R142)+(1.52-MIN(1.52,Q153))/3.04*R143+(1.52-MIN(1.52,Q153))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"0>=P144","v":{"$error":"#REF!"}},{"$f":"ABS((0-P146)/IF(V153,R145,R146))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((0-(P144+R140*ABS(0-P144)/ABS(IF(V153,R145+R140,R146-R140))*MIN(1,W153)))/(MIN(1.52,W153)/1.52*IF(V153,R141,R142)+(1.52-MIN(1.52,W153))/3.04*R143+(1.52-MIN(1.52,W153))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((J87-P146)/(MIN(1.52,Q153)/1.52*IF(P153,R141,R142)+(1.52-MIN(1.52,Q153))/3.04*R143+(1.52-MIN(1.52,Q153))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((0-P146)/(MIN(1.52,W153)/1.52*IF(V153,R141,R142)+(1.52-MIN(1.52,W153))/3.04*R143+(1.52-MIN(1.52,W153))/3.04*R144)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXPDATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P100","v":50},{"$f":"P115","v":{"$error":"#REF!"}},{"$f":"R115","v":{"$error":"#REF!"}},{"$f":"I67","v":0},{"$f":"R145","v":{"$error":"#REF!"}},{"$f":"R146","v":{"$error":"#REF!"}},{"$f":"R141","v":{"$error":"#REF!"}},{"$f":"R143","v":{"$error":"#REF!"}},{"$f":"R142","v":{"$error":"#REF!"}},{"$f":"R144","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ALTB for calculation and return to breakeven table;"]
[null,"ALTR for calculation and return to risk rated return table;"]
[null,"ALTI for return to Instructions;"]
[null,"HOME for return to beginning of budget."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ALTB for calculation and return to breakeven table;"]
[null,"ALTR for calculation and return to risk rated return table;"]
[null,"",null,null,null,null,null,null,null,null,""]
[null,"HOME for return to beginning of budget."]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Feed Cost","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Animal Type","Steer"]
["Gain Target",1.5]
["Calf weight",650]
["Days fed",30]
[null,"$/ton","$/#","% of Ration","#/ton","Cost/ton"]
["corn",100,{"$f":"+B6/2000","v":0.05},0.65,{"$f":"+D6*2000","v":1300},{"$f":"+E6*C6","v":65}]
["whole cottonseed",125,{"$f":"+B7/2000","v":6.25E-2},0.1,{"$f":"+D7*2000","v":200},{"$f":"+E7*C7","v":12.5}]
["gin trash",15,{"$f":"+B8/2000","v":7.4999999999999997E-3},0.15,{"$f":"+D8*2000","v":300},{"$f":"+E8*C8","v":2.25}]
["Soybean Meal",250,{"$f":"+B9/2000","v":0.125},0.1,{"$f":"+D9*2000","v":200},{"$f":"+E9*C9","v":25}]
[null,null,null,{"$f":"+SUM(D6:D9)","v":1},"Total",{"$f":"SUM(F6:F9)","v":104.75}]
[null,null,null,null,"Total $/#",{"$f":"+F10/2000","v":5.2374999999999998E-2}]
[]
["Consumption","# fed/day","Cost/day","Total cost","total # fed","$/Cwt"]
[5.0000000000000001E-3,{"$f":"+A14*$B$3","v":3.25},{"$f":"+B14*$F$11","v":0.17021875},{"$f":"+C14*$B$4","v":5.1065624999999999},{"$f":"+B14*$B$4","v":97.5}]
[0.01,6.5,0.3404375,10.213125,{"$f":"+B15*$B$4","v":195}]
[1.4999999999999999E-2,9.75,0.51065625000000003,15.319687500000001,292.5]
[1.7500000000000002E-2,11.375000000000002,0.59576562500000008,17.872968750000002,341.25000000000006]
[0.02,13,0.68087500000000001,20.42625,390]
[2.1999999999999999E-2,14.299999999999999,0.74896249999999986,22.468874999999997,428.99999999999994]
[2.5000000000000001E-2,16.25,0.85109374999999998,25.532812499999999,487.5]

{"sheet":"Procurement","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,1,6,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[1,8,1,10],[15,1,15,3],[2,1,2,7],[12,1,12,7],[12,8,12,10],[7,1,7,3]]}
[]
[null,null,null,null,null,null,null,null,"Return to Main Budget"]
[null,"Procurement Cost Detail"]
[]
[null,"     ITEM",null,null,"UNIT","QUANTITY","PRICE","AMOUNT"]
[null,null,null,null,null,null,null," ($/hd.)"]
[null,"Order Buying",null,null,"CWT.",{"$f":"+Main!F36","v":4},0.5,{"$f":"F7*G7","v":2}]
[null,"Hauling",null,null,"MILES",100,1.85,{"$f":"+G8*F8/34","v":5.4411764705882355}]
[]
[null,"TOTAL PROCUREMENT COST",null,null,null,null,null,{"$f":"SUM(H7:H8)","v":7.4411764705882355}]
[]
[]
[null,"Auction & Hauling Cost Detail",null,null,null,null,null,null,"Return to Main Budget"]
[]
[null,"     ITEM",null,null,"UNIT","QUANTITY","PRICE","AMOUNT"]
[null,"Commission",null,null,"%",{"$f":"+Main!H29*Main!H30","v":928},0.02,{"$f":"+G16*F16","v":18.559999999999999}]
[null,"Yardage",null,null,"Day",1,1,{"$f":"+G17*F17","v":1}]
[null,"Hauling",null,null,"Miles",100,1.85,{"$f":"+G18*F18/24","v":7.708333333333333}]
[]
[null,"Total Auction & Hauling Cost",null,null,null,null,null,{"$f":"+SUM(H16:H18)","v":27.268333333333331}]

{"sheet":"Fixed_Cost","index":5,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,3,6,5],[7,3,7,5],[5,3,5,5]]}
[]
[]
[null,"INVESTMENT AND ANNUAL FIXED COST"]
[null,"(Check All Higlighted Entries this Page)"]
[]
[null,null,null,"NO. OF CALVES STOCKERED:",null,null,130]
[null,null,null,"NO. OF ACRES:",null,null,100,null,null,"Return to Budget"]
[null,null,null,"INTEREST RATE:",null,null,0.08]
[]
[null,null,null,"% OF TIME FOR",null,null,"SALVAGE","YRS. OF","CALC."]
[null,"  ITEM",null,"THIS ENTERPRISE",null,"COST","VALUE","LIFE","DEPR.","TOTAL"]
[null,"CATTLE EQUIP:",null,null,"    (%)",null,null,"    (Yr.)"," ($/yr.)"]
[null,"FENCING",null,null,1,{"$f":"1.8*1800","v":3240},0,15,{"$f":"IF(F13>0,E13*(F13-G13)/H13,0)","v":216}]
[null,"CORRAL & LOADING CHUTE",null,null,1,2200,0,10,220]
[null,"FEED BUNKS",null,null,1,2070,0,10,207]
[null,"MISC. EQUIPMENT",null,null,1,500,0,10,50]
[null,"OTHER",null,null,0,0,0,0,0]
[null,"OTHER",null,null,0,0,0,0,0]
[null,"OTHER",null,null,0,0,0,0,0]
[null,"MACHINERY & EQUIPMENT:"]
[null,"TRACTOR",null,null,0.08,25000,10000,10,{"$f":"IF(F21>0,E21*(F21-G21)/H21,0)","v":120}]
[null,"GRAIN DRILL",null,null,1,5000,1000,10,400]
[null,"DISK",null,null,0.25,6500,{"$f":"0.2*F23","v":1300},10,130]
[null,"PLOW",null,null,0.25,7000,{"$f":"0.2*F24","v":1400},10,140]
[null,"OTHER SEEDING EQUIP.",null,null,0,0,0,0,0]
[null,"OTHER",null,null,0,0,0,0,0]
[null,"LAND",null,null,0,50000,50000,30,0]
[]
[]
[null,"TOTAL CATTLE INVESTMENT",null,null,null,{"$f":"+F13*E13+F14*E14+F15*E15+F16*E16+F17*E17+F18*E18+F19*E19","v":8010},{"$f":"+G13*E13+G14*E14+G15*E15+G16*E16+E17*G17+E18*G18+E19*G19","v":0}]
[null,"TOTAL MACH. & EQUIP. INVEST.",null,null,null,{"$f":"+F21*E21+F22*E22+F23*E23+F24*E24+F25*E25+F26*E26+F27*E27","v":10375},{"$f":"+G21*E21+G22*E22+G23*E23+G24*E24+G25*E25+G26*E26+G27*E27","v":2475}]
[]
[null,"TOTAL CATTLE EQUIP. DEPRECIATION",null,null,null,null,null,null,null,{"$f":"SUM(I13:I19)","v":693}]
[null,"TOTAL MACH. & EQUIP. DEPRECIATION",null,null,null,null,null,null,null,{"$f":"SUM(I21:I27)","v":790}]
[]
[null,"INTEREST ON CATTLE INVEST. (AVE. INV. TIMES INT. RATE)",null,null,null,null,null,null,null,{"$f":"AVERAGE(F30:G30)*G8","v":320.40000000000003}]
[null,"INTEREST ON MACH. & EQUIP. INVEST. (AVE. INV. TIMES INT. RATE)",null,null,null,null,null,null,null,{"$f":"AVERAGE(F31:G31)*G8","v":514}]
[]
[null,"CATTLE EQUIP. TAX & INS.,",null,null,null," AVE. INV. TIMES",null,1.4E-2,null,{"$f":"AVERAGE(F30:G30)*H39","v":56.07}]
[null,"MACH & EQUIP. TAX & INS.,",null,null,null," AVE. INV. TIMES",null,1.4E-2,null,{"$f":"AVERAGE(F31:G31)*H40","v":89.95}]
[]
[null,"TOTAL ANNUAL FIXED COST",null,null,null,null,null,null,null,{"$f":"SUM(J33:J40)","v":2463.42}]
[]
[null,null,null,null,null,null,null,null,"Per Head Marketed","Total"]
[null,"ANNUAL CATTLE EQUIP. FIXED COST",null,null,null,null,null,null,{"$f":"+cattle_fixed/sold","v":10.802727272727273},{"$f":"SUM(J33,J36,J39)","v":1069.47}]
[null,"TOTAL ANNUAL MACHINERY & EQUIPMENT FIXED COST PER ACRE",null,null,null,null,null,null,{"$f":"+mach_fixed/ACRES","v":27.879000000000001},{"$f":"SUM(J34,J37,J40)","v":1393.95}]

{"sheet":"Fixed_Payment","index":6,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,4,3]]}
[]
[null,"Return to Budget"]
[null,"ANNUAL ENTERPRISE FIXED OUTLAYS"]
[null,"Check All Highlighted Entries this Page)"]
[]
[null,null,null,null,"NO. OF ACRES:",null,100]
[null,null,null,null,"NO. OF HEAD:",null,{"$f":"+sold","v":99}]
[]
[]
[null,"DEBT PAYMENT CALCULATION ON NEW INVESTMENT:"]
[null,"(For Use In Calculating Debt Payments on New Investment)"]
[null,null,null,"","UNIT","TOTAL","   -------FINANCING-------"]
[null,"ITEM",null,"NUMBER","COST","COST","AMOUNT","YEARS","INT.RATE","PAYMENT"]
[null,"  FACILITIES:"]
[null,"FENCE (MILES)",null,1.8,1800,{"$f":"D15*E15","v":3240},0.5,7,0.11,{"$f":"PMT(I15,H15,-F15*G15)","v":343.78873650915824}]
[null,"CORRAL &",null,null,"","","","",""]
[null,"LOADING CHUTE",null,null,"",2200,0.5,7,0.11,{"$f":"PMT(I17,H17,-F17*G17)","v":233.43679639510745}]
[null,"FEED BUNK",null,null,"",{"$f":"9*G7","v":891},0.5,7,0.11,{"$f":"PMT(I18,H18,-F18*G18)","v":94.541902540018526}]
[null,"GRINDERMIXER",null,null,null,7000,0.5,7,0.11,{"$f":"PMT(I19,H19,-F19*G19)","v":742.75344307534192}]
[null,"GRAIN BIN (2000 BU.)",null,null,null,2300,0.5,7,0.11,{"$f":"PMT(I20,H20,-F20*G20)","v":244.04755986761234}]
[null,"MISC. EQUIP.",null,null,"",400,0.5,7,0.11,{"$f":"PMT(I21,H21,-F21*G21)","v":42.443053890019534}]
[null,null,null,null,"","","","",""]
[null,"LAND",null,{"$f":"Main!F18","v":50},500,{"$f":"D23*E23","v":25000},0,30,0.1,{"$f":"PMT(I23,H23,-F23*G23)","v":0}]
[null,null,null,null,null,"","","",""]
[null,"CALCULATED TOTAL ANNUAL DEBT PAYMENT",null,null,null,null,"","","",{"$f":"SUM(J15:J23)","v":1701.011492277258}]
[null,null,null,null,null,null,null,null,null,""]
[]
[null,"CURRENT ANNUAL DEBT PAYMENTS:"]
[null,"(For Use In Totaling Debt Payments on Existing Investment)"]
[]
[null,"LOAN # 1",null,null,null,null,null,null,null,0]
[null,"LOAN # 2",null,null,null,null,null,null,null,0]
[null,"LOAN # 3",null,null,null,null,null,null,null,0]
[null,"LOAN # 4",null,null,null,null,null,null,null,0]
[null,"LOAN # 5",null,null,null,null,null,null,null,0]
[]
[null,null,null,null,"TOTAL ANNUAL DEBT PAYMENT",null,null,null,null,{"$f":"SUM(J25:J36)","v":1701.011492277258}]
[]
[null,null,null,null,"TAXES AND INSURANCE",null,null,null,null,{"$f":"+Fixed_Cost!J29","v":0}]
[]
[null,null,null,null,"TOTAL ANNUAL FIXED OUTLAY",null,null,null,null,{"$f":"SUM(J37:J39)","v":1701.011492277258}]
[null,null,null,null,"TOTAL ANNUAL FIXED OUTLAY PER HEAD",null,null,null,null,{"$f":"+J41/G7","v":17.181934265426847}]

{"sheet":"G","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"H","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"I","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"J","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"K","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"L","index":12,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,-23595.594594968865,2.2750092654188533E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-18314.612601769117,6.6807279375848599E-2]
[1,null,null,null,null,null,null,null,null,null,null,null,null,-13033.630608569367,0.15865531316113057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-10393.139611969493,0.22662732264844102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-7752.6486153696178,0.3085375586179277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-5112.1576187697428,0.40129373468325191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2471.6666221698688,0.49999999977461573]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2471.6666221698688,0.49999999977461573]
[null,null,null,null,null,null,null,null,null,null,null,null,null,168.82437443000572,0.59870626531674809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2809.3153710298802,0.69146244138207225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5449.8063676297552,0.77337267735155901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8090.2973642296292,0.84134468683886943]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13371.279357429379,0.93319272062415137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18652.261350629127,0.97724990734581152]