{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Main","Winter Grazing","Rations","Ration Components","Procurement","Fixed_Cost","Fixed_Payment","J","K","L"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":126,"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":255,"n_cols":48,"rows_kept":255,"cut":false,"hidden":false,"merged":[[26,9,27,9],[18,7,18,8],[19,7,19,8],[20,7,20,8],[38,1,38,3],[40,1,40,3],[31,8,33,8],[31,6,33,6],[31,7,33,7],[31,1,33,3],[31,4,33,4],[31,5,33,5],[34,1,34,3],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[39,1,39,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[47,1,47,3],[45,1,45,3],[46,1,46,3],[44,1,44,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[48,1,48,3],[49,1,49,3],[61,1,61,3],[77,1,77,4],[60,1,60,3],[76,1,76,4],[55,1,55,8],[51,1,51,3],[50,1,50,3],[72,1,72,8],[56,1,56,3],[104,5,104,7],[78,1,78,4],[79,1,79,4],[80,1,80,4],[103,5,103,8],[95,1,95,9],[96,1,96,9],[94,1,94,9],[92,1,92,9],[84,1,84,9],[16,1,16,9],[15,1,15,9],[0,1,0,9],[1,1,1,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[4,1,4,9],[2,1,3,9]]}
[null,"Stockering Steers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Levi Russell, Lawton Stewart, and Dennis Hancock"]
[null,"Agricultural & Applied Economics, Animal & Dairy Sciences, and Crop and Soil Sciences 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,"February 2018",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 500 pound Steers",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,"2018-10-15",null,null,null,null,null,null,null,null," "]
[null,"STOCKING RATE (HEAD/ACRE)",null,null,null,2,null,"Out Date",null,{"$f":"+J19+F24","v":"2019-03-14"},"",null,null,null,null,null,null,null," "]
[null,"NUMBER OF CALVES PLACED",null,null,null,{"$f":"F19*F20","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":"+F21*((100-F22)/100)","v":99},null,null,null,null,"",null,null,null,null,null,null,null,"          "]
[null,"FEEDING PERIOD (DAYS)",null,null,null,150]
[]
[null,null,null,null,null,"BEST","OPT.","MEDIAN","PESS.","WORST",""]
[null,"PAYWEIGHT TO PAYWEIGHT",null,null,null,3,{"$f":"+H27+0.25","v":2.25},2,{"$f":"+H27-0.25","v":1.75},1.5]
[null,"DAILY GAIN (LBS./DAY)"]
[null,"NET SELLING WEIGHT (CWT.)",null,null,null,{"$f":"((F27*F24)/100+F36)","v":9.5},{"$f":"(G27*F24/100+F36)","v":8.375},{"$f":"(H27*F24/100+F36)","v":8},{"$f":"(I27*F24/100+F36)","v":7.625},{"$f":"(J27*F24/100+F36)","v":7.25}]
[null,"SELLING PRICE ($/CWT.)",null,null,null,126,{"$f":"+(F30+H30)/2","v":130},134,{"$f":"+(H30+J30)/2","v":136},138]
[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.",5,{"$f":"+F36*placed","v":500},156,{"$f":"G36*H36","v":78000},null,null,null,null,null,null,null,null,null," "]
["Procurement Detail","PROCUREMENT COST",null,null,"HEAD",1,100,{"$f":"+Procurement!H10","v":11.294117647058824},1129.4117647058824,null,null,null,null,null,null,null,null,null," "]
["Winter Grazing Detail","WINTER GRAZING",null,null,"ACRE",0.6,60,{"$f":"+tvc_grazing/ACRES","v":80.440616438356159},4826.4369863013699,null,null,null,null,null,null,null,null,null," "]
[null,"SUPPLEMENTAL HAY",null,null,"TON",0.15,15,130,1950,null,null,null,null,null,null,null,null,null," "]
["Ration Detail","RATION 1",null,null,"HEAD",1,100,{"$f":"Rations!L13","v":90.343476562500001},{"$f":"G40*H40","v":9034.34765625},null,null,null,null,null,null,null,null,null," "]
[null,"RATION 2",null,null,"HEAD",1,100,{"$f":"Rations!L27","v":0},{"$f":"G41*H41","v":0}]
[null,"RATION 3",null,null,"HEAD",1,100,{"$f":"Rations!L41","v":0},0]
[null,"MINERAL + IONOPHORE",null,null,"LBS.",{"$f":"+F24*0.25","v":37.5},3750,0.28000000000000003,1050,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",0.5,50,25,1250]
[null,"LABOR",null,null,"HRS.",1.25,125,0,0]
[null,"DEATH LOSS",null,null,"PERCENT",0.01,{"$f":"+SUM(I36:I48)","v":98320.427176488025},{"$f":"+G49*F49","v":983.20427176488022},{"$f":"+F49*G49","v":983.20427176488022}]
[null,"INTEREST ON CALF",null,null,"PERCENT",0.04,{"$f":"+I36*0.5","v":39000},{"$f":"+(FEEDING_PERIOD/365*F50)","v":1.643835616438356E-2},{"$f":"+H50*G50","v":641.09589041095887}]
[null,"INTEREST ON OTHER EXPENSES",null,null,"PERCENT",0.04,{"$f":"+(SUM(I37:I49)-I38)*0.5","v":8238.5972309757653},{"$f":"+(FEEDING_PERIOD/365*F51)","v":1.643835616438356E-2},{"$f":"+H51*G51","v":135.42899557768379}]
["Auction & Hauling Detail","AUCTION AND HAULING",null,null,"HEAD",1,{"$f":"F52*F21","v":100},{"$f":"+mktng_cst","v":21.44},{"$f":"G52*H52","v":2144}]
[]
[null,"TOTAL VARIABLE COST",null,null,null,"",null,null,{"$f":"SUM(I36:I52)","v":102224.15633424155}]
[]
[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,I57/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,I58/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,H59*F59,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,(H90-I36),0)","v":0},null,0.06,{"$f":"+IF(bud_type=1,H60*F60,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,H61*F61,0)","v":0},""]
[null,"TOTAL FIXED COST",null,null,null,null,"","",{"$f":"SUM(I57:I61)","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:I43)/(D90-G36)","v":57.161015162733079}]
[null,"FEEDING COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+I54-I36-I37-I52)/(D90-G36)","v":71.026696170917958}]
[null,"TOTAL COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+F82-I36)/(D90-G36)","v":82.12413579089926}]
[]
[null,"MAX. BREAKEVEN PURCHASE PRICE OF CALF (MEDIAN SCENARIO)",null,null,null,null,null,null,{"$f":"+(+H90-(+F82-I36))/G36","v":163.55428693151688}]
[]
[]
[null,"EXPECTED BREAKEVEN TABLE"]
[]
[null,"ITEM",null,null," TOTAL AMOUNT",null,null,"$ / CWT.","    $/HD."]
[null,"VARIABLE COST",null,null,null,{"$f":"I54","v":102224.15633424155},null,{"$f":"F76/(U170*F21)","v":127.30280988074914},{"$f":"+F76/sold","v":1032.5672356994096}]
[null,{"$f":"+B57","v":""},null,null,null,{"$f":"IF(I57>0,I57,0)","v":0},null,{"$f":"IF(F77>0,F77/(U170*F21),0)","v":0},0]
[null,{"$f":"+B58","v":""},null,null,null,{"$f":"I58","v":0},null,{"$f":"F78/(U170*F21)","v":0},0]
[null,{"$f":"+B59","v":""},null,null,null,{"$f":"I59","v":0},null,{"$f":"F79/(U170*F21)","v":0},0]
[null,{"$f":"+B60","v":""},null,null,null,{"$f":"I60","v":0},null,{"$f":"F80/(U170*F21)","v":0},0]
[null,{"$f":"+B61","v":""},null,null,null,{"$f":"I61","v":0},null,{"$f":"F81/(U170*F21)","v":0},0]
[null,"TOTAL COST",null,null,null,{"$f":"SUM(F76:F81)","v":102224.15633424155},null,{"$f":"F82/(U170*F21)","v":127.30280988074914},1032.5672356994096]
[]
[]
[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":"+U170","v":8.0299999999999994},null,{"$f":"+B90*sold","v":794.96999999999991},null,{"$f":"+W170","v":133.34},null,{"$f":"+F90*D90","v":106001.29979999999}]
[]
[null,"RISK RATED RETURNS OVER VARIABLE COST"]
[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":"U209:U209+1.5*W208:W208","v":15937.593616201237},{"$f":"U209:U209+W208:W208","v":12241.016966053638},{"$f":"U209:U209+0.5*W208:W208","v":8544.4403159060403},{"$f":"U209:U209","v":4847.8636657584429},{"$f":"U209:U209-0.5*W209:W209","v":1832.6077760910243},{"$f":"U209:U209-W209:W209","v":-1182.6481135763943},{"$f":"U209:U209-1.5*W209:W209","v":-4197.9040032438133}]
[null,"Chances",null,{"$f":"IF(V212<1,IF(U212,Z212,1-Z212),IF(U212,Z213,1-Z213))","v":7.5373427136122051E-2},{"$f":"IF(AB212<1,IF(AA212,AF212,1-AF212),IF(AA212,AF213,1-AF213))","v":0.15858685880913431},{"$f":"IF(AH212<1,IF(AG212,AL212,1-AL212),IF(AG212,AL213,1-AL213))","v":0.28430369783410625},{"$f":"IF(V214<1,IF(U214,Z214,1-Z214),IF(U214,Z215,1-Z215))","v":0.47339380364276484},{"$f":"IF(AB214<1,IF(AA214,AF214,1-AF214),IF(AA214,AF215,1-AF215))","v":0.66202346612962448},{"$f":"IF(AH214<1,IF(AG214,AL214,1-AL214),IF(AG214,AL215,1-AL215))","v":0.84125421183382965},{"$f":"IF(V216<1,IF(U216,Z216,1-Z216),IF(U216,Z217,1-Z217))","v":0.94435910840817328}]
[null,"Chances",null,{"$f":"IF(V212<1,IF(U212,1-Z212,Z212),IF(U212,1-Z213,Z213))","v":0.92462657286387795},{"$f":"IF(AB212<1,IF(AA212,1-AF212,AF212),IF(AA212,1-AF213,AF213))","v":0.84141314119086563},{"$f":"IF(AH212<1,IF(AG212,1-AL212,AL212),IF(AG212,1-AL213,AL213))","v":0.71569630216589375},{"$f":"IF(V214<1,IF(U214,1-Z214,Z214),IF(U214,1-Z215,Z215))","v":0.52660619635723516},{"$f":"IF(AB214<1,IF(AA214,1-AF214,AF214),IF(AA214,1-AF215,AF215))","v":0.33797653387037557},{"$f":"IF(AH214<1,IF(AG214,1-AL214,AL214),IF(AG214,1-AL215,AL215))","v":0.15874578816617035},{"$f":"IF(V216<1,IF(U216,1-Z216,Z216),IF(U216,1-Z217,Z217))","v":5.5640891591826731E-2}]
[]
[null,"  CHANCE FOR PROFIT ",null,null,{"$f":"IF(AB216<1,IF(AA216,AF216,1-AF216),IF(AA216,AF217,1-AF217))","v":0.7760398168841004},"BASE BUDGETED NET REVENUE ",null,null,null,{"$f":"+ENR","v":4847.8636657584429}]
[null,null,null,null,null,"Profit (Loss) Per Head Placed",null,null,null,{"$f":"+J104/placed","v":48.478636657584431}]
[]
[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":"+F21","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.5},"  Best Y",{"$f":"+F30","v":126},"  Best P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,"*",{"$f":"+G29","v":8.375},"  Opt. Y",{"$f":"+G30","v":130},"  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},"  Med. Y",{"$f":"H30","v":134},"  Med. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+I29","v":7.625},"  Pess. Y",{"$f":"I30","v":136},"  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":138},"  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":"+F82","v":102224.15633424155},"  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*U158+0.25*U159+0.42*U160+0.25*U161+0.04*U162","v":8.0299999999999994},"  Exp. Y",{"$f":"0.04*W158+0.25*W159+0.42*W160+0.25*W161+0.04*W162","v":133.34},"  Exp. P",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(U158-U170)+0.5*(U159-U170)","v":0.54000000000000048},"  SYO",{"$f":"0.25*(W158-W170)+0.5*(W159-W170)","v":-3.5050000000000026},"  SPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.25*(U170-U162)+0.5*(U170-U161)","v":0.39749999999999952},"  SYP",{"$f":"0.25*(W170-W162)+0.5*(W170-W161)","v":-2.4949999999999974},"  SPP",":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U171^2","v":0.29160000000000053},"  VYO",{"$f":"W171^2","v":12.285025000000019},"  VPO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U172^2","v":0.15800624999999963},"  VYP",{"$f":"W172^2","v":6.2250249999999872},"  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":"(U170^2*W182)+(W170-U163)^2*U182","v":5976.66788148251},"  VTRHH",{"$f":"(U170^2*W183)+(W170-U163)^2*U183","v":3210.6761215449924},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(U170^2*W182)+(W170-U163)^2*U183","v":3601.4303755449946},"  VTRHL",{"$f":"U170^2*W183+(W170-U163)^2*U182","v":5585.9136274825087},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U185)","v":77.308912044359474},"  STRHH",{"$f":"SQRT(W185)","v":56.662828393444961},"  STRLL",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U186)","v":60.011918612430605},"  STRHL",{"$f":"SQRT(W186)","v":74.738969938597023},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*U187+0.17*U189+0.17*W189","v":73.931533002951952},"  STRO",{"$f":"0.66*W187+0.17*U189+0.17*W189","v":60.305117793348373},"  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":"W160","v":134},"  MP",{"$f":"+U209-U207","v":449.67170191691548},"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":"U160","v":8},"  MY",{"$f":"U157*U187","v":7730.8912044359477},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+U208+0.33*(W209-W208)","v":106622.34829808307},"  MTR",{"$f":"U157*W187","v":5666.2828393444961},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+F82","v":102224.15633424155},"  MTC",{"$f":"U157*U189","v":6001.1918612430609},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,":",{"$f":"U205-U206","v":4398.1919638415275},"  MNR",{"$f":"U157*W189","v":7473.896993859702},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"U157*U170*W170","v":107072.01999999999},"  ETR",{"$f":"U157*U190","v":7393.1533002951955},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U208-U206","v":4847.8636657584429},"  ENR",{"$f":"U157*W190","v":6030.5117793348372},"  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":"+D100>=U207","v":true},{"$f":"ABS((D100-U209)/IF(U212,W208,W209))","v":1.5},{"$f":"MIN(2.5,ABS((D100-(U207+W203*ABS(D100-U207)/ABS(IF(U212,W208+W203,W209-W203))*MIN(1,V212)))/(MIN(1.52,V212)/1.52*IF(U212,W204,W205)+(1.52-MIN(1.52,V212))/3.04*W206+(1.52-MIN(1.52,V212))/3.04*W207)))","v":1.4094373744763193},{"$f":"1/(1+(0.2316419*W212))","v":0.75387221675840943},{"$f":"0.398942281*((2.71828)^((-(W212^2)/2)))","v":0.14775574800393629},{"$f":"Y212*(0.31938153*X212-0.356563782*X212^2+1.781477937*X212^3-1.821255978*X212^4+1.330274429*X212^5)","v":7.9353042757979608E-2},{"$f":"+E100>=U207","v":true},{"$f":"ABS((E100-U209)/IF(AA212,W208,W209))","v":0.99999999999999989},{"$f":"MIN(2.5,ABS((E100-(U207+W203*ABS(E100-U207)/ABS(IF(AA212,W208+W203,W209-W203))*MIN(1,AB212)))/(MIN(1.52,AB212)/1.52*IF(AA212,W204,W205)+(1.52-MIN(1.52,AB212))/3.04*W206+(1.52-MIN(1.52,AB212))/3.04*W207)))","v":1.000282943961228},{"$f":"1/(1+(0.2316419*AC212))","v":0.81188110598622365},{"$f":"0.398942281*((2.71828)^((-(AC212^2)/2)))","v":0.24190234213278666},{"$f":"AE212*(0.31938153*AD212-0.356563782*AD212^2+1.781477937*AD212^3-1.821255978*AD212^4+1.330274429*AD212^5)","v":0.15858685880913431},{"$f":"+F100>=U207","v":true},{"$f":"ABS((F100-U209)/IF(AG212,W208,W209))","v":0.49999999999999994},{"$f":"MIN(2.5,ABS((F100-(U207+W203*ABS(F100-U207)/ABS(IF(AG212,W208+W203,W209-W203))*MIN(1,AH212)))/(MIN(1.52,AH212)/1.52*IF(AG212,W204,W205)+(1.52-MIN(1.52,AH212))/3.04*W206+(1.52-MIN(1.52,AH212))/3.04*W207)))","v":0.57010362702387896},{"$f":"1/(1+(0.2316419*AI212))","v":0.8833454936128966},{"$f":"0.398942281*((2.71828)^((-(AI212^2)/2)))","v":0.33910431835936156},{"$f":"AK212*(0.31938153*AJ212-0.356563782*AJ212^2+1.781477937*AJ212^3-1.821255978*AJ212^4+1.330274429*AJ212^5)","v":0.28430369783410625}]
[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((D100-U209)/(MIN(1.52,V212)/1.52*IF(U212,W204,W205)+(1.52-MIN(1.52,V212))/3.04*W206+(1.52-MIN(1.52,V212))/3.04*W207)))","v":1.4368991147822594},0.75027420211816054,0.14209245093195133,7.5373427136122051E-2,null,null,{"$f":"MIN(2.5,ABS((E100-U209)/(MIN(1.52,AB212)/1.52*IF(AA212,W204,W205)+(1.52-MIN(1.52,AB212))/3.04*W206+(1.52-MIN(1.52,AB212))/3.04*W207)))","v":1.000282943961228},0.81188110598622365,0.24190234213278666,0.15858685880913431,null,null,{"$f":"MIN(2.5,ABS((F100-U209)/(MIN(1.52,AH212)/1.52*IF(AG212,W204,W205)+(1.52-MIN(1.52,AH212))/3.04*W206+(1.52-MIN(1.52,AH212))/3.04*W207)))","v":0.52327547767871185},{"$f":"1/(1+(0.2316419*AI213))","v":0.89189156999603081},{"$f":"0.398942281*((2.71828)^((-(AI213^2)/2)))","v":0.34789761495953403},{"$f":"AK213*(0.31938153*AJ213-0.356563782*AJ213^2+1.781477937*AJ213^3-1.821255978*AJ213^4+1.330274429*AJ213^5)","v":0.30039129096787726}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"+G100>=U207","v":true},{"$f":"ABS((G100-U209)/IF(U214,W208,W209))","v":0},{"$f":"MIN(2.5,ABS((G100-(U207+W203*ABS(G100-U207)/ABS(IF(U214,W208+W203,W209-W203))*MIN(1,V214)))/(MIN(1.52,V214)/1.52*IF(U214,W204,W205)+(1.52-MIN(1.52,V214))/3.04*W206+(1.52-MIN(1.52,V214))/3.04*W207)))","v":6.6741185420329641E-2},0.98477531940039498,0.39805474889448661,0.47339380364276484,{"$f":"+H100>=U207","v":false},{"$f":"ABS((H100-U209)/IF(AA214,W208,W209))","v":0.5},{"$f":"MIN(2.5,ABS((H100-(U207+W203*ABS(H100-U207)/ABS(IF(AA214,W208+W203,W209-W203))*MIN(1,AB214)))/(MIN(1.52,AB214)/1.52*IF(AA214,W204,W205)+(1.52-MIN(1.52,AB214))/3.04*W206+(1.52-MIN(1.52,AB214))/3.04*W207)))","v":0.41799201694285387},0.91172291640084446,0.36557013292330509,0.33797653387037557,{"$f":"+I100>=U207","v":false},{"$f":"ABS((I100-U209)/IF(AG214,W208,W209))","v":1},{"$f":"MIN(2.5,ABS((I100-(U207+W203*ABS(I100-U207)/ABS(IF(AG214,W208+W203,W209-W203))*MIN(1,AH214)))/(MIN(1.52,AH214)/1.52*IF(AG214,W204,W205)+(1.52-MIN(1.52,AH214))/3.04*W206+(1.52-MIN(1.52,AH214))/3.04*W207)))","v":0.99962616034580587},{"$f":"1/(1+(0.2316419*AI214))","v":0.8119814006771966},{"$f":"0.398942281*((2.71828)^((-(AI214^2)/2)))","v":0.24206126448080512},{"$f":"AK214*(0.31938153*AJ214-0.356563782*AJ214^2+1.781477937*AJ214^3-1.821255978*AJ214^4+1.330274429*AJ214^5)","v":0.15874578816617035}]
[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((G100-U209)/(MIN(1.52,V214)/1.52*IF(U214,W204,W205)+(1.52-MIN(1.52,V214))/3.04*W206+(1.52-MIN(1.52,V214))/3.04*W207)))","v":0},1,0.39894228100000001,0.50000000022538427,null,null,{"$f":"MIN(2.5,ABS((H100-U209)/(MIN(1.52,AB214)/1.52*IF(AA214,W204,W205)+(1.52-MIN(1.52,AB214))/3.04*W206+(1.52-MIN(1.52,AB214))/3.04*W207)))","v":0.47222902761301244},0.9013978641259025,0.35685041737252932,0.31838169420884882,null,null,{"$f":"MIN(2.5,ABS((I100-U209)/(MIN(1.52,AH214)/1.52*IF(AG214,W204,W205)+(1.52-MIN(1.52,AH214))/3.04*W206+(1.52-MIN(1.52,AH214))/3.04*W207)))","v":0.99962616034580587},{"$f":"1/(1+(0.2316419*AI215))","v":0.8119814006771966},{"$f":"0.398942281*((2.71828)^((-(AI215^2)/2)))","v":0.24206126448080512},{"$f":"AK215*(0.31938153*AJ215-0.356563782*AJ215^2+1.781477937*AJ215^3-1.821255978*AJ215^4+1.330274429*AJ215^5)","v":0.15874578816617035}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"+J100>=U207","v":false},{"$f":"ABS((J100-U209)/IF(U216,W208,W209))","v":1.5},{"$f":"MIN(2.5,ABS((J100-(U207+W203*ABS(J100-U207)/ABS(IF(U216,W208+W203,W209-W203))*MIN(1,V216)))/(MIN(1.52,V216)/1.52*IF(U216,W204,W205)+(1.52-MIN(1.52,V216))/3.04*W206+(1.52-MIN(1.52,V216))/3.04*W207)))","v":1.6352290033797248},0.72527489650059518,0.10477662465872221,5.1000558245682455E-2,{"$f":"0>=U207","v":false},{"$f":"ABS((0-U209)/IF(AA216,W208,W209))","v":0.8038892623294337},{"$f":"MIN(2.5,ABS((0-(U207+W203*ABS(0-U207)/ABS(IF(AA216,W208+W203,W209-W203))*MIN(1,AB216)))/(MIN(1.52,AB216)/1.52*IF(AA216,W204,W205)+(1.52-MIN(1.52,AB216))/3.04*W206+(1.52-MIN(1.52,AB216))/3.04*W207)))","v":0.75888655435385377},0.85049206508219255,0.29912529719671599,0.22396018311589963]
[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((J100-U209)/(MIN(1.52,V216)/1.52*IF(U216,W204,W205)+(1.52-MIN(1.52,V216))/3.04*W206+(1.52-MIN(1.52,V216))/3.04*W207)))","v":1.5924586450804918},0.73052414615182837,0.11226423480954922,5.5640891591826731E-2,null,null,{"$f":"MIN(2.5,ABS((0-U209)/(MIN(1.52,AB216)/1.52*IF(AA216,W204,W205)+(1.52-MIN(1.52,AB216))/3.04*W206+(1.52-MIN(1.52,AB216))/3.04*W207)))","v":0.78559037738362347},0.84604111937299376,0.29301999069672569,0.21605372914579282]
[]
[null,null,null,null,null,null,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":"U157","v":100},{"$f":"U170","v":8.0299999999999994},{"$f":"W170","v":133.34},{"$f":"I82","v":1032.5672356994096},{"$f":"W208","v":7393.1533002951955},{"$f":"W209","v":6030.5117793348372},{"$f":"W204","v":7730.8912044359477},{"$f":"W206","v":6001.1918612430609},{"$f":"W205","v":5666.2828393444961},{"$f":"W207","v":7473.896993859702}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,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":267,"n_cols":48,"rows_kept":267,"cut":false,"hidden":false,"merged":[[43,1,43,6],[28,1,28,3],[3,3,3,6],[11,1,11,10],[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]]}
[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,null,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,"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","$/Acre"]
[null,"    ITEM",null,null,null,"UNIT","PER ACRE","QUANTITY","PRICE","AMOUNT"]
[null,"VARIABLE COSTS:",null,null,null,null,null,"  (units)"," ($/unit)"]
[null,"SEED"]
[null,"Rye ",null,null,null,"LBS.",60,{"$f":"G26*ACRES","v":3000},0.31,{"$f":"H26*I26","v":930},{"$f":"+J26/ACRES","v":18.600000000000001}]
[null,"Ryegrass",null,null,null,"LBS.",15,{"$f":"G27*ACRES","v":750},0.38,{"$f":"H27*I27","v":285},5.7]
[null,"Arrowleaf Clover",null,null,null,"LBS.",0,{"$f":"G28*ACRES","v":0},2,{"$f":"H28*I28","v":0},0]
[null,"Other",null,null,null,"LBS.",0,{"$f":"G29*ACRES","v":0},0.5,{"$f":"H29*I29","v":0},0]
[null,"LIME",null,null,null,"TON",0,{"$f":"G30*F16","v":0},42,{"$f":"H30*I30","v":0},0]
[null,"FERTILIZER:",null,null,null,null,null,"",null,null,0]
[null," NITROGEN",null,null,null,"LB.",125,{"$f":"G32*F16","v":6250},0.44,{"$f":"H32*I32","v":2750},55]
[null," P205",null,null,null,"LB.",0,{"$f":"G33*F16","v":0},0.38,{"$f":"H33*I33","v":0},0]
[null," K20",null,null,null,"LB.",0,{"$f":"G34*F16","v":0},0.28999999999999998,{"$f":"H34*I34","v":0},0]
[null,"MACHINERY",null,null,null,null,null,"",null,null,0]
[null,"  FUEL",null,null,null,"GAL.",0,{"$f":"G36*F16","v":0},4.5,{"$f":"H36*I36","v":0},0]
[null,"  REPAIRS & MAINT.",null,null,null,"ACRE",0,{"$f":"G37*F16","v":0},{"$f":"1.53+0.62","v":2.15},{"$f":"H37*I37","v":0},0]
[null,"LAND RENTAL",null,null,null,"ACRE",0,{"$f":"G38*F16","v":0},0,{"$f":"H38*I38","v":0},0]
[null,"LABOR",null,null,null,"HRS.",0,{"$f":"G39*F16","v":0},9.02,{"$f":"H39*I39","v":0},0]
[null,"Custom Planting",null,null,null,"Acre",0,{"$f":"G40*F16","v":0},12,{"$f":"H40*I40","v":0},0]
[null,"INTEREST ON OP. CAP.",null,null,null,"%",1,{"$f":"SUM(J25:J40)*0.5","v":1982.5},7.0000000000000007E-2,{"$f":"+(I41*H41)*days/365","v":57.030821917808218},1.1406164383561643]
[null,"TOTAL VARIABLE COST",null,null,null,null,"",null,null,{"$f":"SUM(J25:J41)","v":4022.0308219178082},80.440616438356159]
[]
["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":4022.0308219178082}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":3016.5231164383563},{"$f":"+F63*0.9","v":3619.8277397260276},{"$f":"+tvc_grazing","v":4022.0308219178082},{"$f":"+F63*1.1","v":4424.2339041095893},{"$f":"+F63*1.25","v":5027.5385273972606}]
[null,null,30,{"$f":"+D$63/$C64","v":100.55077054794521},120.66092465753425,134.06769406392695,147.47446347031965,167.5846175799087]
[null,null,60,50.275385273972603,60.330462328767126,67.033847031963475,73.737231735159824,83.792308789954348]
[null,null,90,33.516923515981738,40.220308219178087,44.689231354642317,49.158154490106547,55.861539193302896]
[null,null,120,25.137692636986301,30.165231164383563,33.516923515981738,36.868615867579912,41.896154394977174]
[null,null,150,20.110154109589043,24.132184931506853,26.813538812785389,29.494892694063928,33.516923515981738]
[null,null,180,16.758461757990869,20.110154109589043,22.344615677321158,24.579077245053274,27.930769596651448,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":3016.5231164383563},{"$f":"+E63","v":3619.8277397260276},{"$f":"+F63","v":4022.0308219178082},{"$f":"+G63","v":4424.2339041095893},{"$f":"+H63","v":5027.5385273972606}]
[null,null,0.25,{"$f":"+D$74/$C75","v":12066.092465753425},14479.310958904111,16088.123287671233,17696.935616438357,20110.154109589042]
[null,null,{"$f":"+C75+0.25","v":0.5},6033.0462328767126,7239.6554794520553,8044.0616438356165,8848.4678082191786,10055.077054794521]
[null,null,{"$f":"+C76+0.25","v":0.75},4022.0308219178082,4826.4369863013699,5362.7077625570773,5898.9785388127857,6703.3847031963478]
[null,null,{"$f":"+C77+0.25","v":1},3016.5231164383563,3619.8277397260276,4022.0308219178082,4424.2339041095893,5027.5385273972606]
[null,null,{"$f":"+C78+0.25","v":1.25},2413.2184931506849,2895.8621917808223,3217.6246575342466,3539.3871232876713,4022.0308219178087,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[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":"+G68","v":29.494892694063928},"  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":29.494892694063928},"  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":50},{"$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":"Rations","index":3,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ration 1"]
[]
[null,"Ingredient","$ per Ton","% of Ration","#/Ton DM","Cost per Dry Ton",null,"Total Cost",null,null,null,{"$f":"SUM(F5:F14)","v":152.96250000000001}]
[null,"Corn",{"$f":"VLOOKUP(B5,'Ration Components'!$B$4:$D$37,3,FALSE)","v":160},0.65,{"$f":"(VLOOKUP(B5,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1800},{"$f":"C5*D5*E5/2000","v":93.6},null,"Number of Days on Ration",null,null,null,150]
[null,"Whole Cottonseed",{"$f":"VLOOKUP(B6,'Ration Components'!$B$4:$D$37,3,FALSE)","v":235},0.1,{"$f":"(VLOOKUP(B6,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1800},{"$f":"C6*D6*E6/2000","v":21.15},null,"Total Cost per Pound",null,null,null,{"$f":"L4/2000","v":7.6481250000000001E-2}]
[null,"Gin Trash",{"$f":"VLOOKUP(B7,'Ration Components'!$B$4:$D$37,3,FALSE)","v":35},0.15,{"$f":"(VLOOKUP(B7,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1700},4.4625000000000004,null,"Starting Weight",null,null,null,525]
[null,"Soybean Meal",{"$f":"VLOOKUP(B8,'Ration Components'!$B$4:$D$37,3,FALSE)","v":375},0.1,{"$f":"(VLOOKUP(B8,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1800},33.75,null,"Final Weight",null,null,null,825]
[null,"BLANK",{"$f":"VLOOKUP(B9,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B9,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Average Daily Gain",null,null,null,{"$f":"IF(L5=0,0,(L8-L7)/L5)","v":2}]
[null,"BLANK",{"$f":"VLOOKUP(B10,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B10,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Consumption as % of Bodyweight",null,null,null,1.4999999999999999E-2]
[null,"BLANK",{"$f":"VLOOKUP(B11,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B11,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Pounds Fed per Day",null,null,null,{"$f":"L10*L7","v":7.875}]
[null,"BLANK",{"$f":"VLOOKUP(B12,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B12,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Cost per Day",null,null,null,{"$f":"L11*L6","v":0.60228984375000005}]
[null,"BLANK",{"$f":"VLOOKUP(B13,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B13,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Total Cost Fed per Head",null,null,null,{"$f":"L12*L5","v":90.343476562500001}]
[null,"BLANK",{"$f":"VLOOKUP(B14,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B14,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Total Pounds Fed per Head",null,null,null,{"$f":"L11*L5","v":1181.25}]
[null,null,null,null,null,null,null,"Cost per Cwt Produced",null,null,null,{"$f":"IF(L8=0,0,L13/((L8-L7)/100))","v":30.114492187500002}]
[null,"Ration 2"]
[]
[null,"Ingredient","$ per Ton","% of Ration","#/Ton DM","Cost per Dry Ton",null,"Total Cost",null,null,null,{"$f":"SUM(F19:F28)","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B19,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B19,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},{"$f":"C19*D19*E19/2000","v":0},null,"Number of Days on Ration",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B20,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B20,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},{"$f":"C20*D20*E20/2000","v":0},null,"Total Cost per Pound",null,null,null,{"$f":"L18/2000","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B21,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B21,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Starting Weight",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B22,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B22,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Final Weight",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B23,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B23,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Average Daily Gain",null,null,null,{"$f":"IF(L19=0,0,(L22-L21)/L19)","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B24,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B24,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Consumption as % of Bodyweight",null,null,null,1.4999999999999999E-2]
[null,"BLANK",{"$f":"VLOOKUP(B25,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B25,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Pounds Fed per Day",null,null,null,{"$f":"L24*L21","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B26,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B26,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Cost per Day",null,null,null,{"$f":"L25*L20","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B27,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B27,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Total Cost Fed per Head",null,null,null,{"$f":"L26*L19","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B28,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B28,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Total Pounds Fed per Head",null,null,null,{"$f":"L25*L19","v":0}]
[null,null,null,null,null,null,null,"Cost per Cwt Produced",null,null,null,{"$f":"IF(L22=0,0,L27/((L22-L21)/100))","v":0}]
[null,"Ration 3"]
[]
[null,"Ingredient","$ per Ton","% of Ration","#/Ton DM","Cost per Dry Ton",null,"Total Cost",null,null,null,{"$f":"SUM(F33:F42)","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B33,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0.65,{"$f":"(VLOOKUP(B33,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},{"$f":"C33*D33*E33/2000","v":0},null,"Number of Days on Ration",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B34,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0.2,{"$f":"(VLOOKUP(B34,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},{"$f":"C34*D34*E34/2000","v":0},null,"Total Cost per Pound",null,null,null,{"$f":"L32/2000","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B35,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0.15,{"$f":"(VLOOKUP(B35,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Starting Weight",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B36,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B36,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Final Weight",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B37,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B37,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Average Daily Gain",null,null,null,{"$f":"IF(L33=0,0,(L36-L35)/L33)","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B38,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B38,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Consumption as % of Bodyweight",null,null,null,0]
[null,"BLANK",{"$f":"VLOOKUP(B39,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B39,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Pounds Fed per Day",null,null,null,{"$f":"L38*L35","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B40,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B40,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Cost per Day",null,null,null,{"$f":"L39*L34","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B41,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B41,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Total Cost Fed per Head",null,null,null,{"$f":"L40*L33","v":0}]
[null,"BLANK",{"$f":"VLOOKUP(B42,'Ration Components'!$B$4:$D$37,3,FALSE)","v":0},0,{"$f":"(VLOOKUP(B42,'Ration Components'!$B$4:$D$37,2,FALSE))*2000","v":1980},0,null,"Total Pounds Fed per Head",null,null,null,{"$f":"L39*L33","v":0}]
[null,null,null,null,null,null,null,"Cost per Cwt Produced",null,null,null,{"$f":"IF(L36=0,0,L41/((L36-L35)/100))","v":0}]

{"sheet":"Ration Components","index":4,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Feed","Percent DM","$ per Ton"]
[null,"Hay",0.85,130]
[null,"Corn Silage",0.32,68]
[null,"Cottonseed Hulls",0.9,123]
[null,"Gin Trash",0.85,35]
[null,"Peanut Hulls",0.9,55]
[null,"Soybean Stubble",0.85,20]
[null,"Chicken Litter",0.85,35]
[null,"Corn Gluten Feed",0.9,157]
[null,"Cottonseed Meal",0.9,320]
[null,"Dried Distiller's Grains",0.9,177]
[null,"Liquid Feed",0.67,285]
[null,"Molasses Block",0.76,650]
[null,"Range Cubes",0.85,330]
[null,"Soybean Meal",0.9,375]
[null,"Sunflower Meal",0.9,350]
[null,"Urea",0.99,150]
[null,"Whole Cottonseed",0.9,235]
[null,"Whole Soybeans",0.9,125]
[null,"Barley",0.9,200]
[null,"Citrus Pulp",0.9,220]
[null,"Corn",0.9,160]
[null,"Grain Sorghum",0.9,140]
[null,"Basic Mineral",0.99,220]
[null,"Low P Mineral",0.99,200]
[null,"Limestone",0.99,125]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]
[null,"BLANK",0.99,0]

{"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],[6,1,6,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.",2,0.5,{"$f":"F7*G7","v":1}]
[null,"Hauling",null,null,"MILES",100,3.5,{"$f":"+G8*F8/34","v":10.294117647058824}]
[]
[null,"TOTAL PROCUREMENT COST",null,null,null,null,null,{"$f":"SUM(H7:H8)","v":11.294117647058824}]
[]
[]
[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":1072},0.02,{"$f":"+G16*F16","v":21.44}]
[null,"Yardage",null,null,"Day",1,0,{"$f":"+G17*F17","v":0}]
[null,"Hauling",null,null,"Miles",100,0,{"$f":"+G18*F18/24","v":0}]
[]
[null,"Total Auction & Hauling Cost",null,null,null,null,null,{"$f":"+SUM(H16:H18)","v":21.44}]

{"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,130]
[null,null,null,"NO. OF ACRES:",null,null,100,null,null,"Return to Budget"]
[null,null,null,"INTEREST RATE:",null,null,0.04]
[]
[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":160.20000000000002}]
[null,"INTEREST ON MACH. & EQUIP. INVEST. (AVE. INV. TIMES INT. RATE)",null,null,null,null,null,null,null,{"$f":"AVERAGE(F31:G31)*G8","v":257}]
[]
[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":2046.22}]
[]
[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":9.1845454545454555},{"$f":"SUM(J33,J36,J39)","v":909.2700000000001}]
[null,"TOTAL ANNUAL MACHINERY & EQUIPMENT FIXED COST PER ACRE",null,null,null,null,null,null,{"$f":"+mach_fixed/ACRES","v":22.739000000000001},{"$f":"SUM(J34,J37,J40)","v":1136.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.04,{"$f":"PMT(I15,H15,-F15*G15)","v":269.90757150399691}]
[null,"CORRAL &",null,null,"","","","",""]
[null,"LOADING CHUTE",null,null,"",2200,0.5,7,0.04,{"$f":"PMT(I17,H17,-F17*G17)","v":183.27057324345466}]
[null,"FEED BUNK",null,null,"",{"$f":"9*G7","v":891},0.5,7,0.04,{"$f":"PMT(I18,H18,-F18*G18)","v":74.224582163599138}]
[null,"GRINDERMIXER",null,null,null,7000,0.5,7,0.04,{"$f":"PMT(I19,H19,-F19*G19)","v":583.1336421382648}]
[null,"GRAIN BIN (2000 BU.)",null,null,null,2300,0.5,7,0.04,{"$f":"PMT(I20,H20,-F20*G20)","v":191.6010538454299}]
[null,"MISC. EQUIP.",null,null,"",400,0.5,7,0.04,{"$f":"PMT(I21,H21,-F21*G21)","v":33.32192240790085}]
[null,null,null,null,"","","","",""]
[null,"LAND",null,{"$f":"Main!F19","v":50},500,{"$f":"D23*E23","v":25000},0,30,0.03,{"$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":1335.4593453026464}]
[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":1335.4593453026464}]
[]
[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":1335.4593453026464}]
[null,null,null,null,"TOTAL ANNUAL FIXED OUTLAY PER HEAD",null,null,null,null,{"$f":"+J41/G7","v":13.489488336390368}]

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

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

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