{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Main","Fescue Grazing","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":4,"defined_names":183,"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":254,"n_cols":48,"rows_kept":254,"cut":false,"hidden":false,"merged":[[71,1,71,8],[60,1,60,3],[33,14,33,18],[35,12,39,12],[31,7,33,7],[55,1,55,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[54,1,54,8],[43,1,43,3],[14,1,14,9],[76,1,76,4],[59,1,59,3],[75,1,75,4],[18,7,18,8],[21,1,21,4],[23,1,23,4],[18,1,18,4],[22,1,22,4],[19,7,19,8],[19,1,19,4],[50,1,50,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[39,1,39,3],[103,5,103,7],[77,1,77,4],[78,1,78,4],[79,1,79,4],[102,5,102,8],[94,1,94,9],[95,1,95,9],[91,1,91,9],[93,1,93,9],[83,1,83,9],[0,1,0,9],[1,1,1,9],[2,1,2,9],[4,1,4,9],[31,1,33,3],[31,4,33,4],[31,5,33,5],[31,8,33,8],[31,6,33,6],[20,1,20,4],[5,1,5,9],[6,1,6,9],[3,1,3,9],[17,7,17,8],[17,1,17,4],[15,1,15,9],[34,1,34,3],[42,14,42,18],[44,12,48,12],[38,1,38,3],[41,1,41,3],[42,1,42,3],[44,1,44,3],[45,1,45,3],[40,1,40,3]]}
[null,"Stockering Steers On Stockpiled Fescue, Winter Grass, 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 Extensio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           "," "," "]
[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 Stockpiled Fescue, Winter Annuals Hay & Supplement with clover",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,"2012-11-01",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":"2013-04-30"},"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF CALVES PLACED",null,null,null,{"$f":"F18*F19","v":100},null,null,null,null,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,"STOCKERING PERIOD (DAYS)",null,null,null,180]
[null,"MARKETING SHRINK(%)",null,null,null,0.03]
[]
[null,null,null,null,null,"BEST","OPT.","MEDIAN","PESS.","WORST",""]
[null,"PAYWEIGHT TO PAYWEIGHT",null,null,null,2.75,{"$f":"+H27+0.25","v":2.25},2,{"$f":"+H27-0.25","v":1.75},1.25,""]
[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":9.9499999999999993},{"$f":"(G27*F23/100+F36)","v":9.0500000000000007},{"$f":"(H27*F23/100)+(F36)","v":8.6},{"$f":"(I27*F23/100+F36)","v":8.15},{"$f":"(J27*F23/100+F36)","v":7.25},""]
[null,"SELLING PRICE ($/CWT.)",null,null,null,145,{"$f":"+(F30+H30)/2","v":135},125,{"$f":"+(H30+J30)/2","v":120},115,""]
[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,"$/Head"]
[null,null,null,null,null,null,null,null,null,"Marketed"]
[null,"VARIABLE COSTS:"]
[null,"CALF",null,null,"CWT.",5,{"$f":"+F36*placed","v":500},137.5,{"$f":"G36*H36","v":68750},{"$f":"+IF(I36>0,(I36/sold),0)","v":694.44444444444446}]
["Procurement Detail","PROCUREMENT COST",null,null,"HEAD",1,100,{"$f":"+Procurement!H10","v":8.6666666666666679},866.66666666666674,8.7542087542087543]
["Fescue Grazing Detail","TALL FESCUE GRAZING",null,null,"ACRE",0.15,15,{"$f":"+grazing_cost/ACRES","v":120.878125},1813.171875,18.314867424242426]
["Winter Grazing Detail","WINTER GRAZING",null,null,"ACRE",0.35,{"$f":"+F39*placed","v":35},{"$f":"+'Winter Grazing'!tvc_grazing","v":121.82013698630138},4263.7047945205486,43.067725197177261]
[null,"HAY",null,null,"TON",{"$f":"5*60/2000","v":0.15},15,100,1500,15.151515151515152]
[null,"RECEIVING RATION",null,null,"TONS",{"$f":"12.5*7*4/2000","v":0.17499999999999999},17.5,275,4812.5,48.611111111111114]
[null,"SUPPLEMENTAL FEED",null,null,"TONS",{"$f":"600*0.015*0.045","v":0.40499999999999997},40.5,275,11137.5,112.5]
[null,"MINERAL + IONOPHORE",null,null,"LBS.",{"$f":"+F23*0.25","v":45},4500,0.28000000000000003,1260.0000000000002,12.72727272727273]
[null,"MEDICATION,WORM,VAC.",null,null,"HEAD",2,200,4,800,8.0808080808080813]
[null,"GROW.STIMULANT",null,null,"IMPLANT",2,200,1,200,2.0202020202020203]
[null,"REPAIRS",null,null,"HEAD",1,100,{"$f":"AVERAGE(Fixed_Cost!F30:G31)*0.02/Fixed_Cost!G6","v":1.0429999999999999},104.3,1.0535353535353535]
[null,"LAND RENTAL",null,null,"ACRE",{"$f":"F38","v":0.15},15,0,0,0]
[null,"LABOR",null,null,"HRS.",{"$f":"+F23*1.5/placed","v":2.7},270,9.02,2435.4,24.6]
[null,"DEATH LOSS",null,null,"PERCENT",0.01,{"$f":"+SUM(I36:I48)*0.75/placed","v":734.57432502140421},{"$f":"+G49*F49","v":7.3457432502140421},5395.9943898065158,54.504993836429449]
[null,"INTEREST ON OP. CAP.",null,null,"PERCENT",null,null,0.08,{"$f":"+SUM(I36:I49)*0.5*($F$23/365)*H50","v":2038.4726345949448},20.590632672676211]
["Auction & Hauling Detail","AUCTION AND HAULING",null,null,"HEAD",1,{"$f":"F51*F20","v":100},{"$f":"+mktng_cst","v":24.631583333333328},{"$f":"G51*H51","v":2463.1583333333328},24.880387205387201]
[]
[null,"TOTAL VARIABLE COST",null,null,null,"",null,null,{"$f":"SUM(I36:I51)","v":107840.86869392201},{"$f":"+IF(I53>0,(I53/sold),0)","v":1089.3017039790102}]
[]
[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=1,+ROUNDDOWN(sold,0),0)","v":0},null,{"$f":"+IF(bud_type<>3,I56/sold,0)","v":0},{"$f":"+IF(bud_type=1,cattle_fixed,IF(bud_type=2,cf_total,0))","v":0},{"$f":"+IF(I56>0,(I56/sold),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,I57/ACRES,0)","v":0},{"$f":"+IF(bud_type=1,mach_fixed,0)","v":0},0]
[null,{"$f":"+IF(bud_type=1,\"Overhead\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Head Sold\",\"\")","v":""},{"$f":"+IF(bud_type=1,+ROUNDDOWN(sold,0),0)","v":0},null,0,{"$f":"+IF(bud_type=1,H58*F58,0)","v":0},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,(H89-I36),0)","v":0},null,0.06,{"$f":"+IF(bud_type=1,H59*F59,0)","v":0},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,H60*F60,0)","v":0},0]
[null,"TOTAL FIXED COST",null,null,null,null,"","",{"$f":"SUM(I56:I60)","v":0},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:I43)/(D89-G36)","v":70.537497636654948}]
[null,"FEEDING COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+I53-I36-I37)/(D89-G36)","v":108.77689819936069}]
[null,"TOTAL COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+F81-I36-I37)/(D89-G36)","v":108.77689819936069}]
[]
[null,"MAX. BREAKEVEN PURCHASE PRICE OF CALF",null,null,null,null,null,null,{"$f":"+(+H89-(+F81-I36))/G36","v":137.47788261215595}]
[]
[]
[null,"EXPECTED BREAKEVEN TABLE"]
[]
[null,"ITEM",null,null," TOTAL AMOUNT",null,null,"$ / CWT.","    $/HD."]
[null,"VARIABLE COST",null,null,null,{"$f":"I53","v":107840.86869392201},null,{"$f":"F75/(U169*F20)","v":125.39635894642093},{"$f":"+F75/sold","v":1089.3017039790102}]
[null,{"$f":"+B56","v":""},null,null,null,{"$f":"IF(I56>0,I56,0)","v":0},null,{"$f":"IF(F76>0,F76/(U169*F20),0)","v":0},0]
[null,{"$f":"+B57","v":""},null,null,null,{"$f":"I57","v":0},null,{"$f":"F77/(U169*F20)","v":0},0]
[null,{"$f":"+B58","v":""},null,null,null,{"$f":"I58","v":0},null,{"$f":"F78/(U169*F20)","v":0},0]
[null,{"$f":"+B59","v":""},null,null,null,{"$f":"I59","v":0},null,{"$f":"F79/(U169*F20)","v":0},0]
[null,{"$f":"+B60","v":""},null,null,null,{"$f":"I60","v":0},null,{"$f":"F80/(U169*F20)","v":0},0]
[null,"TOTAL COST",null,null,null,{"$f":"SUM(F75:F80)","v":107840.86869392201},null,{"$f":"F81/(U169*F20)","v":125.39635894642093},1089.3017039790102]
[]
[]
[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":"+U169","v":8.6},null,{"$f":"+B89*sold","v":851.4},null,{"$f":"+W169","v":126.64999999999999},null,{"$f":"+F89*D89","v":107829.80999999998}]
[]
[]
[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":"U208:U208+1.5*W207:W207","v":16262.998176323905},{"$f":"U208:U208+W207:W207","v":11201.375886241929},{"$f":"U208:U208+0.5*W207:W207","v":6139.7535961599542},{"$f":"U208:U208","v":1078.1313060779794},{"$f":"U208:U208-0.5*W208:W208","v":-3504.2242516515444},{"$f":"U208:U208-W208:W208","v":-8086.5798093810681},{"$f":"U208:U208-1.5*W208:W208","v":-12668.935367110593}]
[null,"Chances",null,{"$f":"IF(V211<1,IF(U211,Z211,1-Z211),IF(U211,Z212,1-Z212))","v":7.1373553976352519E-2},{"$f":"IF(AB211<1,IF(AA211,AF211,1-AF211),IF(AA211,AF212,1-AF212))","v":0.15861876926232263},{"$f":"IF(AH211<1,IF(AG211,AL211,1-AL211),IF(AG211,AL212,1-AL212))","v":0.29600524693017466},{"$f":"IF(V213<1,IF(U213,Z213,1-Z213),IF(U213,Z214,1-Z214))","v":0.48691724916689066},{"$f":"IF(AB213<1,IF(AA213,AF213,1-AF213),IF(AA213,AF214,1-AF214))","v":0.67784992747648598},{"$f":"IF(AH213<1,IF(AG213,AL213,1-AL213),IF(AG213,AL214,1-AL214))","v":0.84130432724249871},{"$f":"IF(V215<1,IF(U215,Z215,1-Z215),IF(U215,Z216,1-Z216))","v":0.93820495095891587}]
[null,"Chances",null,{"$f":"IF(V211<1,IF(U211,1-Z211,Z211),IF(U211,1-Z212,Z212))","v":0.92862644602364752},{"$f":"IF(AB211<1,IF(AA211,1-AF211,AF211),IF(AA211,1-AF212,AF212))","v":0.84138123073767734},{"$f":"IF(AH211<1,IF(AG211,1-AL211,AL211),IF(AG211,1-AL212,AL212))","v":0.7039947530698254},{"$f":"IF(V213<1,IF(U213,1-Z213,Z213),IF(U213,1-Z214,Z214))","v":0.51308275083310928},{"$f":"IF(AB213<1,IF(AA213,1-AF213,AF213),IF(AA213,1-AF214,AF214))","v":0.32215007252351407},{"$f":"IF(AH213<1,IF(AG213,1-AL213,AL213),IF(AG213,1-AL214,AL214))","v":0.15869567275750129},{"$f":"IF(V215<1,IF(U215,1-Z215,Z215),IF(U215,1-Z216,Z216))","v":6.1795049041084134E-2}]
[]
[null,"  CHANCE FOR PROFIT ",null,null,{"$f":"IF(AB215<1,IF(AA215,AF215,1-AF215),IF(AA215,AF216,1-AF216))","v":0.53179835453749702},"BASE BUDGETED NET REVENUE ",null,null,null,{"$f":"+(H89-U163)","v":-11.05869392202294}]
[null,null,null,null,null,"Profit (Loss) Per Head Placed",null,null,null,{"$f":"+J103/placed","v":-0.1105869392202294}]
[]
[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":9.9499999999999993},"  Best Y",{"$f":"+F30","v":145},"  Best P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,"*",{"$f":"+G29","v":9.0500000000000007},"  Opt. Y",{"$f":"+G30","v":135},"  Opt. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H29","v":8.6},"  Med. Y",{"$f":"H30","v":125},"  Med. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+I29","v":8.15},"  Pess. Y",{"$f":"I30","v":120},"  Pess. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+J29","v":7.25},"  Worst Y",{"$f":"J30","v":115},"  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":"+F81","v":107840.86869392201},"  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*U157+0.25*U158+0.42*U159+0.25*U160+0.04*U161","v":8.6},"  Exp. Y",{"$f":"0.04*W157+0.25*W158+0.42*W159+0.25*W160+0.04*W161","v":126.64999999999999},"  Exp. P",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(U157-U169)+0.5*(U158-U169)","v":0.56250000000000044},"  SYO",{"$f":"0.25*(W157-W169)+0.5*(W158-W169)","v":8.7625000000000064},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(U169-U161)+0.5*(U169-U160)","v":0.56249999999999956},"  SYP",{"$f":"0.25*(W169-W161)+0.5*(W169-W160)","v":6.2374999999999936},"  SPP",":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U170^2","v":0.3164062500000005},"  VYO",{"$f":"W170^2","v":76.781406250000117},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U171^2","v":0.3164062499999995},"  VYP",{"$f":"W171^2","v":38.906406249999918},"  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":"(U169^2*W181)+(W169-U162)^2*U181","v":10753.97945664064},"  VTRHH",{"$f":"(U169^2*W182)+(W169-U162)^2*U182","v":7952.7444566406102},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(U169^2*W181)+(W169-U162)^2*U182","v":10753.979456640624},"  VTRHL",{"$f":"U169^2*W182+(W169-U162)^2*U181","v":7952.7444566406257},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U184)","v":103.70139563497031},"  STRHH",{"$f":"SQRT(W184)","v":89.178161321259651},"  STRLL",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U185)","v":103.70139563497024},"  STRHL",{"$f":"SQRT(W185)","v":89.178161321259736},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*U186+0.17*U188+0.17*W188","v":101.2324458016395},"  STRO",{"$f":"0.66*W186+0.17*U188+0.17*W188","v":91.647111154590476},"  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":"W159","v":125},"  MP",{"$f":"+U208-U206","v":316.31604335262091},"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":"U159","v":8.6},"  MY",{"$f":"U156*U186","v":10370.13956349703},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+U207+0.33*(W208-W207)","v":108602.68395664736},"  MTR",{"$f":"U156*W186","v":8917.8161321259649},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+F81","v":107840.86869392201},"  MTC",{"$f":"U156*U188","v":10370.139563497023},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,":",{"$f":"U204-U205","v":761.81526272535848},"  MNR",{"$f":"U156*W188","v":8917.816132125974},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"U156*U169*W169","v":108918.99999999999},"  ETR",{"$f":"U156*U189","v":10123.24458016395},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U207-U205","v":1078.1313060779794},"  ENR",{"$f":"U156*W189","v":9164.7111154590475},"  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":"+D99>=U206","v":true},{"$f":"ABS((D99-U208)/IF(U211,W207,W208))","v":1.5},{"$f":"MIN(2.5,ABS((D99-(U206+W202*ABS(D99-U206)/ABS(IF(U211,W207+W202,W208-W202))*MIN(1,V211)))/(MIN(1.52,V211)/1.52*IF(U211,W203,W204)+(1.52-MIN(1.52,V211))/3.04*W205+(1.52-MIN(1.52,V211))/3.04*W206)))","v":1.4508351874748937},{"$f":"1/(1+(0.2316419*W211))","v":0.74846141439578273},{"$f":"0.398942281*((2.71828)^((-(W211^2)/2)))","v":0.1392618654136735},{"$f":"Y211*(0.31938153*X211-0.356563782*X211^2+1.781477937*X211^3-1.821255978*X211^4+1.330274429*X211^5)","v":7.341297208377226E-2},{"$f":"+E99>=U206","v":true},{"$f":"ABS((E99-U208)/IF(AA211,W207,W208))","v":1},{"$f":"MIN(2.5,ABS((E99-(U206+W202*ABS(E99-U206)/ABS(IF(AA211,W207+W202,W208-W202))*MIN(1,AB211)))/(MIN(1.52,AB211)/1.52*IF(AA211,W203,W204)+(1.52-MIN(1.52,AB211))/3.04*W205+(1.52-MIN(1.52,AB211))/3.04*W206)))","v":1.0001510377819429},{"$f":"1/(1+(0.2316419*AC211))","v":0.81190124684120835},{"$f":"0.398942281*((2.71828)^((-(AC211^2)/2)))","v":0.24193425955432568},{"$f":"AE211*(0.31938153*AD211-0.356563782*AD211^2+1.781477937*AD211^3-1.821255978*AD211^4+1.330274429*AD211^5)","v":0.15861876926232263},{"$f":"+F99>=U206","v":true},{"$f":"ABS((F99-U208)/IF(AG211,W207,W208))","v":0.5},{"$f":"MIN(2.5,ABS((F99-(U206+W202*ABS(F99-U206)/ABS(IF(AG211,W207+W202,W208-W202))*MIN(1,AH211)))/(MIN(1.52,AH211)/1.52*IF(AG211,W203,W204)+(1.52-MIN(1.52,AH211))/3.04*W205+(1.52-MIN(1.52,AH211))/3.04*W206)))","v":0.53592485424154979},{"$f":"1/(1+(0.2316419*AI211))","v":0.88956681669468052},{"$f":"0.398942281*((2.71828)^((-(AI211^2)/2)))","v":0.34557480054406564},{"$f":"AK211*(0.31938153*AJ211-0.356563782*AJ211^2+1.781477937*AJ211^3-1.821255978*AJ211^4+1.330274429*AJ211^5)","v":0.29600524693017466}]
[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((D99-U208)/(MIN(1.52,V211)/1.52*IF(U211,W203,W204)+(1.52-MIN(1.52,V211))/3.04*W205+(1.52-MIN(1.52,V211))/3.04*W206)))","v":1.465638007640838},0.74654545080925516,0.13628797155359507,7.1373553976352519E-2,null,null,{"$f":"MIN(2.5,ABS((E99-U208)/(MIN(1.52,AB211)/1.52*IF(AA211,W203,W204)+(1.52-MIN(1.52,AB211))/3.04*W205+(1.52-MIN(1.52,AB211))/3.04*W206)))","v":1.0001510377819429},0.81190124684120835,0.24193425955432568,0.15861876926232263,null,null,{"$f":"MIN(2.5,ABS((F99-U208)/(MIN(1.52,AH211)/1.52*IF(AG211,W203,W204)+(1.52-MIN(1.52,AH211))/3.04*W205+(1.52-MIN(1.52,AH211))/3.04*W206)))","v":0.51216237340242698},{"$f":"1/(1+(0.2316419*AI212))","v":0.89394403091209618},{"$f":"0.398942281*((2.71828)^((-(AI212^2)/2)))","v":0.34990499932345326},{"$f":"AK212*(0.31938153*AJ212-0.356563782*AJ212^2+1.781477937*AJ212^3-1.821255978*AJ212^4+1.330274429*AJ212^5)","v":0.30426870144088269}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"+G99>=U206","v":true},{"$f":"ABS((G99-U208)/IF(U213,W207,W208))","v":0},{"$f":"MIN(2.5,ABS((G99-(U206+W202*ABS(G99-U206)/ABS(IF(U213,W207+W202,W208-W202))*MIN(1,V213)))/(MIN(1.52,V213)/1.52*IF(U213,W203,W204)+(1.52-MIN(1.52,V213))/3.04*W205+(1.52-MIN(1.52,V213))/3.04*W206)))","v":3.2799333256909369E-2},0.99245958989851701,0.3987277485404368,0.48691724916689066,{"$f":"+H99>=U206","v":false},{"$f":"ABS((H99-U208)/IF(AA213,W207,W208))","v":0.5},{"$f":"MIN(2.5,ABS((H99-(U206+W202*ABS(H99-U206)/ABS(IF(AA213,W207+W202,W208-W202))*MIN(1,AB213)))/(MIN(1.52,AB213)/1.52*IF(AA213,W203,W204)+(1.52-MIN(1.52,AB213))/3.04*W205+(1.52-MIN(1.52,AB213))/3.04*W206)))","v":0.46169498300877959},0.90338488126984084,0.35861008724830779,0.32215007252351407,{"$f":"+I99>=U206","v":false},{"$f":"ABS((I99-U208)/IF(AG213,W207,W208))","v":1},{"$f":"MIN(2.5,ABS((I99-(U206+W202*ABS(I99-U206)/ABS(IF(AG213,W207+W202,W208-W202))*MIN(1,AH213)))/(MIN(1.52,AH213)/1.52*IF(AG213,W203,W204)+(1.52-MIN(1.52,AH213))/3.04*W205+(1.52-MIN(1.52,AH213))/3.04*W206)))","v":0.99983321825227944},{"$f":"1/(1+(0.2316419*AI213))","v":0.81194977905202381},{"$f":"0.398942281*((2.71828)^((-(AI213^2)/2)))","v":0.24201116254978305},{"$f":"AK213*(0.31938153*AJ213-0.356563782*AJ213^2+1.781477937*AJ213^3-1.821255978*AJ213^4+1.330274429*AJ213^5)","v":0.15869567275750129}]
[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((G99-U208)/(MIN(1.52,V213)/1.52*IF(U213,W203,W204)+(1.52-MIN(1.52,V213))/3.04*W205+(1.52-MIN(1.52,V213))/3.04*W206)))","v":0},1,0.39894228100000001,0.50000000022538427,null,null,{"$f":"MIN(2.5,ABS((H99-U208)/(MIN(1.52,AB213)/1.52*IF(AA213,W203,W204)+(1.52-MIN(1.52,AB213))/3.04*W205+(1.52-MIN(1.52,AB213))/3.04*W206)))","v":0.48721983177191397},0.89858520025158839,0.35429335091737885,0.31305130225166411,null,null,{"$f":"MIN(2.5,ABS((I99-U208)/(MIN(1.52,AH213)/1.52*IF(AG213,W203,W204)+(1.52-MIN(1.52,AH213))/3.04*W205+(1.52-MIN(1.52,AH213))/3.04*W206)))","v":0.99983321825227944},{"$f":"1/(1+(0.2316419*AI214))","v":0.81194977905202381},{"$f":"0.398942281*((2.71828)^((-(AI214^2)/2)))","v":0.24201116254978305},{"$f":"AK214*(0.31938153*AJ214-0.356563782*AJ214^2+1.781477937*AJ214^3-1.821255978*AJ214^4+1.330274429*AJ214^5)","v":0.15869567275750129}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"+J99>=U206","v":false},{"$f":"ABS((J99-U208)/IF(U215,W207,W208))","v":1.5},{"$f":"MIN(2.5,ABS((J99-(U206+W202*ABS(J99-U206)/ABS(IF(U215,W207+W202,W208-W202))*MIN(1,V215)))/(MIN(1.52,V215)/1.52*IF(U215,W203,W204)+(1.52-MIN(1.52,V215))/3.04*W205+(1.52-MIN(1.52,V215))/3.04*W206)))","v":1.5582279219115494},0.73478037840550936,0.11848429682990816,5.9589673216604223E-2,{"$f":"0>=U206","v":false},{"$f":"ABS((0-U208)/IF(AA215,W207,W208))","v":0.11763942065335654},{"$f":"MIN(2.5,ABS((0-(U206+W202*ABS(0-U206)/ABS(IF(AA215,W207+W202,W208-W202))*MIN(1,AB215)))/(MIN(1.52,AB215)/1.52*IF(AA215,W203,W204)+(1.52-MIN(1.52,AB215))/3.04*W205+(1.52-MIN(1.52,AB215))/3.04*W206)))","v":7.9791073059892956E-2},0.98185246433238549,0.39767434501576132,0.46820164546250298]
[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((J99-U208)/(MIN(1.52,V215)/1.52*IF(U215,W203,W204)+(1.52-MIN(1.52,V215))/3.04*W205+(1.52-MIN(1.52,V215))/3.04*W206)))","v":1.5398785196895435},0.73708241721422363,0.12190043647540365,6.1795049041084134E-2,null,null,{"$f":"MIN(2.5,ABS((0-U208)/(MIN(1.52,AB215)/1.52*IF(AA215,W203,W204)+(1.52-MIN(1.52,AB215))/3.04*W205+(1.52-MIN(1.52,AB215))/3.04*W206)))","v":0.11244851676656487},0.97461347475361471,0.39642799262102568,0.45523384620597662]
[]
[null,null,null,null,null,null,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":"U156","v":100},{"$f":"U169","v":8.6},{"$f":"W169","v":126.64999999999999},{"$f":"I81","v":1089.3017039790102},{"$f":"W207","v":10123.24458016395},{"$f":"W208","v":9164.7111154590475},{"$f":"W203","v":10370.13956349703},{"$f":"W205","v":10370.139563497023},{"$f":"W204","v":8917.8161321259649},{"$f":"W206","v":8917.816132125974}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,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":"Fescue Grazing","index":2,"n_rows":25,"n_cols":26,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,4],[14,1,14,2],[15,1,15,2],[0,1,0,9],[7,1,7,2],[12,1,12,2],[1,8,1,9],[23,1,23,4]]}
[null,"Tall Fescue Grazing Cost",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,"Return to Main Budget",null,""]
[null,null,null,"         NUMBER OF ACRES",null,null,{"$f":"+acres","v":50}]
[]
[null,null,null,null,null,null," UNITS","TOTAL","UNIT","TOTAL"]
[null,"    ITEM",null,null,null,"UNIT","PER ACRE","QUANTITY","PRICE","AMOUNT"]
[null,"VARIABLE COSTS:",null,null,null,null,null,"  (units)"," ($/unit)"]
[null,"Lime",null,null,null,"TON",0.5,{"$f":"G8*acres","v":25},30,{"$f":"H8*I8","v":750}]
[null,"FERTILIZER:"]
[null," Nitrogen",null,null,null,"LB.",60,{"$f":"G10*acres","v":3000},0.75,{"$f":"H10*I10","v":2250}]
[null," Phosphate",null,null,null,"LB.",50,{"$f":"G11*acres","v":2500},0.6,{"$f":"H11*I11","v":1500}]
[null," Potash",null,null,null,"LB.",50,{"$f":"G12*acres","v":2500},0.55000000000000004,{"$f":"H12*I12","v":1375}]
[null,"SEED"]
[null," Max-Q Fescue Seed",null,null,null,"Lbs.",2.5,{"$f":"G14*acres","v":125},0,{"$f":"H14*I14","v":0}]
[null," Red Clover",null,null,null,"Lbs.",0,{"$f":"G15*acres","v":0},1.25,{"$f":"H15*I15","v":0}]
[null," White Clover",null,null,null,"Lbs.",0,{"$f":"G16*acres","v":0},2,{"$f":"H16*I16","v":0}]
[null,"HERBICIDES",null,null,null,"ACRE",0,{"$f":"G17*G3","v":0},6,{"$f":"H17*I17","v":0},null,null,null,null,null,null,"*"]
[null,"MACHINERY:"]
[null," Fuel",null,null,null,"GAL.",0,{"$f":"G19*G3","v":0},3.75,{"$f":"H19*I19","v":0}]
[null," Repairs & Maint",null,null,null,"ACRE",0,{"$f":"G20*G3","v":0},7.2,{"$f":"H20*I20","v":0}]
[null,"LABOR",null,null,null,"HRS.",0,{"$f":"G21*G3","v":0},9.02,{"$f":"H21*I21","v":0}]
[null,"OTHER",null,null,null,"$",0,{"$f":"G22*G3","v":0},0,{"$f":"H22*I22","v":0}]
[null,"INTEREST ON OP. CAP.",null,null,null,"$","",{"$f":"SUM(J8:J22)","v":5875},5.7500000000000002E-2,{"$f":"H23*I23/365*182.5","v":168.90625}]
[null,"Total Grazing Cost",null,null,null,null,"",null,null,{"$f":"SUM(J8:J23)","v":6043.90625}]
[null,"Total Grazing Cost Per Acre",null,null,null,null,null,null,null,{"$f":"+grazing_cost/acres","v":120.878125}]

{"sheet":"Winter Grazing","index":3,"n_rows":267,"n_cols":48,"rows_kept":267,"cut":false,"hidden":false,"merged":[[71,2,71,7],[60,2,60,7],[17,1,17,4],[25,1,25,3],[26,1,26,3],[27,1,27,3],[49,1,49,4],[43,1,43,6],[28,1,28,3],[29,15,29,19],[31,13,36,13],[11,1,11,10]]}
[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 2012",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,"OVERSEEDED 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,1]
[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,null,null,"Other Costs = ",null,{"$f":"+SUM(J36:J41)+J26+J27+J30+J33+J34","v":46.970136986301377},null,"In Nitrogen = ","Cost/Ac="]
[null,"VARIABLE COSTS:",null,null,null,null,null,"  (units)"," ($/unit)",null,null,null,null,null,null,null,null,null,0.6,{"$f":"+(wg_n_rate*$S24+other_costs)","v":85.970136986301384}]
[null,"SEED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+S24+0.1","v":0.7},{"$f":"+(wg_n_rate*$S25+other_costs)","v":92.470136986301384}]
[null,"Rye ",null,null,null,"LBS.",75,{"$f":"+$F$16*G26","v":75},0.31,{"$f":"H26*I26","v":23.25},null,null,null,null,"n_rate_no clover",150,null,null,{"$f":"+S25+0.1","v":0.79999999999999993},{"$f":"+(wg_n_rate*$S26+other_costs)","v":98.97013698630137}]
[null,"Ryegrass",null,null,null,"LBS.",20,{"$f":"+$F$16*G27","v":20},0.38,{"$f":"H27*I27","v":7.6},null,null,null,null,"clover_n_ratre",100,null,null,{"$f":"+S26+0.1","v":0.89999999999999991},{"$f":"+(wg_n_rate*$S27+other_costs)","v":105.47013698630137}]
[null,"Arrowleaf Clover",null,null,null,"LBS.",6,{"$f":"+$F$16*G28","v":6},1.85,{"$f":"H28*I28","v":11.100000000000001},null,null,null,null,null,null,null,null,{"$f":"+S27+0.1","v":0.99999999999999989},{"$f":"+(wg_n_rate*$S28+other_costs)","v":111.97013698630136}]
[null,"Crimson clover",null,null,null,"LBS.",12,{"$f":"+$F$16*G29","v":12},1.25,{"$f":"H29*I29","v":15}]
[null,"LIME",null,null,null,"TON",0,{"$f":"+$F$16*G30","v":0},30,{"$f":"H30*I30","v":0},null,null,null,null,null,"NITROGEN COST ($/POUND OF N)"]
[null,"FERTILIZER:",null,null,null,null,null,"",null,null,null,null,null,null,null,0.6,{"$f":"+P31+0.1","v":0.7},{"$f":"+Q31+0.1","v":0.79999999999999993},{"$f":"+R31+0.1","v":0.89999999999999991},{"$f":"+S31+0.1","v":0.99999999999999989}]
[null," NITROGEN",null,null,null,"LB.",65,{"$f":"+$F$16*G32","v":65},0.75,{"$f":"H32*I32","v":48.75},null,null,null,"CLOVER COST ($/ACRE)",25,{"$f":"+((no_clvr_n_rate*P$31)+other_costs)-((clvr_n_rate*P$31)+($O32+other_costs))","v":5},10,14.999999999999972,20,24.999999999999972]
[null," P205",null,null,null,"LB.",0,{"$f":"+$F$16*G33","v":0},0.6,{"$f":"H33*I33","v":0},null,null,null,null,{"$f":"+O32+5","v":30},0,5,9.9999999999999716,15,19.999999999999972]
[null," K20",null,null,null,"LB.",0,{"$f":"+$F$16*G34","v":0},0.55000000000000004,{"$f":"H34*I34","v":0},null,null,null,null,{"$f":"+O33+5","v":35},-5,0,4.9999999999999716,10,14.999999999999972]
[null,"MACHINERY",null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"+O34+5","v":40},-10,-5,0,5,9.9999999999999716]
[null,"  FUEL",null,null,null,"GAL.",0,{"$f":"+$F$16*G36","v":0},4,{"$f":"H36*I36","v":0},null,null,null,null,{"$f":"+O35+5","v":45},-15,-10,-5.0000000000000284,0,4.9999999999999716]
[null,"  REPAIRS & MAINT.",null,null,null,"ACRE",1,{"$f":"+$F$16*G37","v":1},{"$f":"1.53+0.62","v":2.15},{"$f":"H37*I37","v":2.15},null,null,null,null,{"$f":"+O36+5","v":50},-20,-15,-10.000000000000028,-5,0]
[null,"LAND RENTAL",null,null,null,"ACRE",0,{"$f":"+$F$16*G38","v":0},0,{"$f":"H38*I38","v":0}]
[null,"LABOR",null,null,null,"HRS.",0,{"$f":"+$F$16*G39","v":0},9.02,{"$f":"H39*I39","v":0}]
[null,"Custom Planting",null,null,null,"Acre",1,{"$f":"+$F$16*G40","v":1},12,{"$f":"H40*I40","v":12}]
[null,"INTEREST ON OP. CAP.",null,null,null,"%",1,{"$f":"SUM(J25:J40)*0.5","v":59.925000000000004},0.08,{"$f":"+(I41*H41)*days/365","v":1.97013698630137}]
[null,"TOTAL VARIABLE COST",null,null,null,null,"",null,null,{"$f":"SUM(J25:J41)","v":121.82013698630138}]
[]
["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,I44*H44,\"\")","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,I45*H45,\"\")","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,I46*H46,\"\")","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,I47*H47,\"\")","v":""}]
[null,"TOTAL  FIXED COST",null,null,null,"","","","",{"$f":"+SUM(J44:J47)","v":0}]
[]
[null,"TOTAL COST ",null,null,null,null,null,null,null,{"$f":"+J48+tvc_grazing","v":121.82013698630138}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"+F63*0.75","v":91.365102739726041},{"$f":"+F63*0.9","v":109.63812328767125},{"$f":"+tvc_grazing","v":121.82013698630138},{"$f":"+F63*1.1","v":134.00215068493154},{"$f":"+F63*1.25","v":152.27517123287672}]
[null,null,30,{"$f":"+D$63/$C64","v":3.0455034246575345},3.6546041095890418,4.0606712328767127,4.4667383561643845,5.0758390410958905]
[null,null,60,1.5227517123287673,1.8273020547945209,2.0303356164383564,2.2333691780821923,2.5379195205479452]
[null,null,90,1.0151678082191782,1.2182013698630139,1.3535570776255708,1.4889127853881281,1.6919463470319636]
[null,null,120,0.76137585616438364,0.91365102739726045,1.0151678082191782,1.1166845890410961,1.2689597602739726]
[null,null,150,0.60910068493150693,0.73092082191780827,0.8121342465753425,0.89334767123287695,1.0151678082191782]
[null,null,180,0.50758390410958909,0.60910068493150693,0.67677853881278538,0.74445639269406405,0.84597317351598178,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":"+D63","v":91.365102739726041},{"$f":"+E63","v":109.63812328767125},{"$f":"+F63","v":121.82013698630138},{"$f":"+G63","v":134.00215068493154},{"$f":"+H63","v":152.27517123287672}]
[null,null,0.25,{"$f":"+D$74/$C75","v":365.46041095890416},438.552493150685,487.28054794520551,536.00860273972614,609.10068493150686]
[null,null,{"$f":"+C75+0.25","v":0.5},182.73020547945208,219.2762465753425,243.64027397260276,268.00430136986307,304.55034246575343]
[null,null,{"$f":"+C76+0.25","v":0.75},121.82013698630139,146.18416438356167,162.42684931506849,178.66953424657538,203.03356164383561]
[null,null,{"$f":"+C77+0.25","v":1},91.365102739726041,109.63812328767125,121.82013698630138,134.00215068493154,152.27517123287672]
[null,null,{"$f":"+C78+0.25","v":1.25},73.092082191780833,87.710498630136996,97.456109589041105,107.20172054794523,121.82013698630138,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[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":1},"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":"+G68","v":0.89334767123287695},"  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*P102+0.25*P103+0.42*P104+0.25*P105+0.04*P107","v":{"$error":"#REF!"}},"  Exp. Y",{"$f":"0.04*R102+0.25*R103+0.42*R104+0.25*R105+0.04*R107","v":{"$error":"#REF!"}},"  Exp. P",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(P102-P116)+0.5*(P103-P116)","v":{"$error":"#REF!"}},"  SYO",{"$f":"0.25*(R102-R116)+0.5*(R103-R116)","v":{"$error":"#REF!"}},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(P116-P107)+0.5*(P116-P105)","v":{"$error":"#REF!"}},"  SYP",{"$f":"0.25*(R116-R107)+0.5*(R116-R105)","v":{"$error":"#REF!"}},"  SPP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P118^2","v":{"$error":"#REF!"}},"  VYO",{"$f":"R118^2","v":{"$error":"#REF!"}},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P119^2","v":{"$error":"#REF!"}},"  VYP",{"$f":"R119^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":"(P116^2*R120)+(R116-P108)^2*P120","v":{"$error":"#REF!"}},"  VTRHH",{"$f":"(P116^2*R121)+(R116-P108)^2*P121","v":{"$error":"#REF!"}},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(P116^2*R120)+(R116-P108)^2*P121","v":{"$error":"#REF!"}},"  VTRHL",{"$f":"P116^2*R121+(R116-P108)^2*P120","v":{"$error":"#REF!"}},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(P123)","v":{"$error":"#REF!"}},"  STRHH",{"$f":"SQRT(R123)","v":{"$error":"#REF!"}},"  STRLL",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(P124)","v":{"$error":"#REF!"}},"  STRHL",{"$f":"SQRT(R124)","v":{"$error":"#REF!"}},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*P125+0.17*P127+0.17*R127","v":{"$error":"#REF!"}},"  STRO",{"$f":"0.66*R125+0.17*P127+0.17*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,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":"R104","v":{"$error":"#REF!"}},"  MP",{"$f":"+P147-P145","v":{"$error":"#REF!"}},"ENR_MNR",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P104","v":{"$error":"#REF!"}},"  MY",{"$f":"P101*P125","v":{"$error":"#REF!"}},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+P146+0.33*(R147-R146)","v":{"$error":"#REF!"}},"  MTR",{"$f":"P101*R125","v":{"$error":"#REF!"}},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+G68","v":0.89334767123287695},"  MTC",{"$f":"P101*P127","v":{"$error":"#REF!"}},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P143-P144","v":{"$error":"#REF!"}},"  MNR",{"$f":"P101*R127","v":{"$error":"#REF!"}},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P101*P116*R116","v":{"$error":"#REF!"}},"  ETR",{"$f":"P101*P128","v":{"$error":"#REF!"}},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"P146-P144","v":{"$error":"#REF!"}},"  ENR",{"$f":"P101*R128","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":"+D88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((D88-P147)/IF(P150,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((D88-(P145+R141*ABS(D88-P145)/ABS(IF(P150,R146+R141,R147-R141))*MIN(1,Q150)))/(MIN(1.52,Q150)/1.52*IF(P150,R142,R143)+(1.52-MIN(1.52,Q150))/3.04*R144+(1.52-MIN(1.52,Q150))/3.04*R145)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*R150))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(R150^2)/2)))","v":{"$error":"#REF!"}},{"$f":"T150*(0.31938153*S150-0.356563782*S150^2+1.781477937*S150^3-1.821255978*S150^4+1.330274429*S150^5)","v":{"$error":"#REF!"}},{"$f":"+E88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((E88-P147)/IF(V150,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((E88-(P145+R141*ABS(E88-P145)/ABS(IF(V150,R146+R141,R147-R141))*MIN(1,W150)))/(MIN(1.52,W150)/1.52*IF(V150,R142,R143)+(1.52-MIN(1.52,W150))/3.04*R144+(1.52-MIN(1.52,W150))/3.04*R145)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*X150))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(X150^2)/2)))","v":{"$error":"#REF!"}},{"$f":"Z150*(0.31938153*Y150-0.356563782*Y150^2+1.781477937*Y150^3-1.821255978*Y150^4+1.330274429*Y150^5)","v":{"$error":"#REF!"}},{"$f":"+F88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((F88-P147)/IF(AB150,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((F88-(P145+R141*ABS(F88-P145)/ABS(IF(AB150,R146+R141,R147-R141))*MIN(1,AC150)))/(MIN(1.52,AC150)/1.52*IF(AB150,R142,R143)+(1.52-MIN(1.52,AC150))/3.04*R144+(1.52-MIN(1.52,AC150))/3.04*R145)))","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,null,null,{"$f":"MIN(2.5,ABS((D88-P147)/(MIN(1.52,Q150)/1.52*IF(P150,R142,R143)+(1.52-MIN(1.52,Q150))/3.04*R144+(1.52-MIN(1.52,Q150))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((E88-P147)/(MIN(1.52,W150)/1.52*IF(V150,R142,R143)+(1.52-MIN(1.52,W150))/3.04*R144+(1.52-MIN(1.52,W150))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((F88-P147)/(MIN(1.52,AC150)/1.52*IF(AB150,R142,R143)+(1.52-MIN(1.52,AC150))/3.04*R144+(1.52-MIN(1.52,AC150))/3.04*R145)))","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,{"$f":"+G88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((G88-P147)/IF(P152,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((G88-(P145+R141*ABS(G88-P145)/ABS(IF(P152,R146+R141,R147-R141))*MIN(1,Q152)))/(MIN(1.52,Q152)/1.52*IF(P152,R142,R143)+(1.52-MIN(1.52,Q152))/3.04*R144+(1.52-MIN(1.52,Q152))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"+H88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((H88-P147)/IF(V152,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((H88-(P145+R141*ABS(H88-P145)/ABS(IF(V152,R146+R141,R147-R141))*MIN(1,W152)))/(MIN(1.52,W152)/1.52*IF(V152,R142,R143)+(1.52-MIN(1.52,W152))/3.04*R144+(1.52-MIN(1.52,W152))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"+I88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((I88-P147)/IF(AB152,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((I88-(P145+R141*ABS(I88-P145)/ABS(IF(AB152,R146+R141,R147-R141))*MIN(1,AC152)))/(MIN(1.52,AC152)/1.52*IF(AB152,R142,R143)+(1.52-MIN(1.52,AC152))/3.04*R144+(1.52-MIN(1.52,AC152))/3.04*R145)))","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,null,null,{"$f":"MIN(2.5,ABS((G88-P147)/(MIN(1.52,Q152)/1.52*IF(P152,R142,R143)+(1.52-MIN(1.52,Q152))/3.04*R144+(1.52-MIN(1.52,Q152))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((H88-P147)/(MIN(1.52,W152)/1.52*IF(V152,R142,R143)+(1.52-MIN(1.52,W152))/3.04*R144+(1.52-MIN(1.52,W152))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((I88-P147)/(MIN(1.52,AC152)/1.52*IF(AB152,R142,R143)+(1.52-MIN(1.52,AC152))/3.04*R144+(1.52-MIN(1.52,AC152))/3.04*R145)))","v":{"$error":"#REF!"}},{"$f":"1/(1+(0.2316419*AD153))","v":{"$error":"#REF!"}},{"$f":"0.398942281*((2.71828)^((-(AD153^2)/2)))","v":{"$error":"#REF!"}},{"$f":"AF153*(0.31938153*AE153-0.356563782*AE153^2+1.781477937*AE153^3-1.821255978*AE153^4+1.330274429*AE153^5)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J88>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((J88-P147)/IF(P154,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((J88-(P145+R141*ABS(J88-P145)/ABS(IF(P154,R146+R141,R147-R141))*MIN(1,Q154)))/(MIN(1.52,Q154)/1.52*IF(P154,R142,R143)+(1.52-MIN(1.52,Q154))/3.04*R144+(1.52-MIN(1.52,Q154))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"0>=P145","v":{"$error":"#REF!"}},{"$f":"ABS((0-P147)/IF(V154,R146,R147))","v":{"$error":"#REF!"}},{"$f":"MIN(2.5,ABS((0-(P145+R141*ABS(0-P145)/ABS(IF(V154,R146+R141,R147-R141))*MIN(1,W154)))/(MIN(1.52,W154)/1.52*IF(V154,R142,R143)+(1.52-MIN(1.52,W154))/3.04*R144+(1.52-MIN(1.52,W154))/3.04*R145)))","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((J88-P147)/(MIN(1.52,Q154)/1.52*IF(P154,R142,R143)+(1.52-MIN(1.52,Q154))/3.04*R144+(1.52-MIN(1.52,Q154))/3.04*R145)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"MIN(2.5,ABS((0-P147)/(MIN(1.52,W154)/1.52*IF(V154,R142,R143)+(1.52-MIN(1.52,W154))/3.04*R144+(1.52-MIN(1.52,W154))/3.04*R145)))","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":"P101","v":1},{"$f":"P116","v":{"$error":"#REF!"}},{"$f":"R116","v":{"$error":"#REF!"}},{"$f":"I68","v":0},{"$f":"R146","v":{"$error":"#REF!"}},{"$f":"R147","v":{"$error":"#REF!"}},{"$f":"R142","v":{"$error":"#REF!"}},{"$f":"R144","v":{"$error":"#REF!"}},{"$f":"R143","v":{"$error":"#REF!"}},{"$f":"R145","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":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Animal Type","Steer"]
["Gain Target",2]
["Calf weight",600]
["Days fed",30]
[null,"$/ton","$/#","% of Ration","#/ton","Cost/ton"]
["corn",100,{"$f":"+B6/2000","v":0.05},0.6,{"$f":"+D6*2000","v":1200},{"$f":"+E6*C6","v":60}]
["corn gluten",100,{"$f":"+B7/2000","v":0.05},0.3,{"$f":"+D7*2000","v":600},{"$f":"+E7*C7","v":30}]
["gin trash",0,{"$f":"+B8/2000","v":0},0,{"$f":"+D8*2000","v":0},{"$f":"+E8*C8","v":0}]
["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":0.99999999999999989},"Total",{"$f":"SUM(F6:F9)","v":115}]
[null,null,null,null,"Total $/#",{"$f":"+F10/2000","v":5.7500000000000002E-2}]
[]
["Consumption","# fed/day","Cost/day","Total cost","total # fed","$/Cwt"]
[5.0000000000000001E-3,{"$f":"+A14*$B$3","v":3},{"$f":"+B14*$F$11","v":0.17250000000000001},{"$f":"+C14*$B$4","v":5.1750000000000007},{"$f":"+B14*$B$4","v":90}]
[0.01,6,0.34500000000000003,10.350000000000001,{"$f":"+B15*$B$4","v":180}]
[1.4999999999999999E-2,9,0.51750000000000007,15.525000000000002,270]
[1.7500000000000002E-2,10.500000000000002,0.60375000000000012,18.112500000000004,315.00000000000006]
[0.02,12,0.69000000000000006,20.700000000000003,360]
[2.1999999999999999E-2,13.2,0.75900000000000001,22.77,396]
[2.5000000000000001E-2,15,0.86250000000000004,25.875,450]

{"sheet":"Procurement","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[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":5},0.5,{"$f":"F7*G7","v":2.5}]
[null,"HAULING",null,null,"MILES",100,1.85,{"$f":"+G8*F8/30","v":6.166666666666667}]
[]
[null,"TOTAL PROCUREMENT COST",null,null,null,null,null,{"$f":"SUM(H7:H8)","v":8.6666666666666679}]
[]
[]
[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":"+[3]Main!H29*[3]Main!H30","v":796.16249999999991},0.02,{"$f":"+G16*F16","v":15.923249999999998}]
[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":24.631583333333328}]

{"sheet":"Fixed_Cost","index":6,"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,{"$f":"+placed","v":100}]
[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":7,"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":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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

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

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

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

{"sheet":"L","index":13,"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]