{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Main","Winter Grazing","Feed Cost","Procurement","Fixed_Cost","Fixed_Payment","G","H","I","J","K","L"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":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":253,"n_cols":48,"rows_kept":253,"cut":false,"hidden":false,"merged":[[15,1,15,9],[14,1,14,9],[0,1,0,9],[1,1,1,9],[2,1,2,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[3,1,3,9],[43,1,43,3],[49,1,49,3],[48,1,48,3],[102,5,102,7],[76,1,76,4],[77,1,77,4],[78,1,78,4],[101,5,101,8],[93,1,93,9],[94,1,94,9],[92,1,92,9],[17,7,17,8],[18,7,18,8],[19,7,19,8],[37,1,37,3],[90,1,90,9],[82,1,82,9],[70,1,70,8],[54,1,54,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[39,1,39,3],[59,1,59,3],[75,1,75,4],[58,1,58,3],[30,8,32,8],[30,6,32,6],[30,7,32,7],[74,1,74,4],[40,1,40,3],[30,1,32,3],[30,4,32,4],[30,5,32,5],[53,1,53,8],[41,1,41,3],[33,1,33,3],[38,1,38,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[42,1,42,3]]}
[null,"Stockering Steers On Temporary Winter Grazing, Hay & Supplement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"R. Curt Lacy and Lawton Stewart"]
[null,"Agricultural & Applied Economics and Animal & Dairy Sciences Department"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3]
[null,"University of Georgia Cooperative Extension Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"(Total Cost Budget)"]
[null,"October 2012",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"(Cash Flow Budget)"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null," ",null,null,null,null,null,null,"(Variable Cost Budget)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"INPUT DATA: Your values in the unprotected or highlighted cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"RISK RATED RETURNS OVER TOTAL COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"RISK RATED RETURNS OVER CASH FLOW COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"RISK RATED RETURNS OVER VARIABLE COST"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Stockering Steers On Temporary Winter Grazing, Hay & Supplement - 500# Steer",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-15"},"",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,"FEEDING PERIOD (DAYS)",null,null,null,165]
[]
[null,null,null,null,null,"BEST","OPT.","MEDIAN","PESS.","WORST",""]
[null,"PAYWEIGHT TO PAYWEIGHT",null,null,null,3,{"$f":"+H26+0.25","v":2.25},2,{"$f":"+H26-0.25","v":1.75},1.5,""]
[null,"DAILY GAIN (LBS./DAY)",null,null,null,null,null,null,null,null,""]
[null,"NET SELLING WEIGHT (CWT.)",null,null,null,{"$f":"(F26*F23/100+F35)","v":9.9499999999999993},{"$f":"(G26*F23/100+F35)","v":8.7125000000000004},{"$f":"(H26*F23/100+F35)","v":8.3000000000000007},{"$f":"(I26*F23/100+F35)","v":7.8875000000000002},{"$f":"(J26*F23/100+F35)","v":7.4749999999999996},""]
[null,"SELLING PRICE ($/CWT.)",null,null,null,145,{"$f":"+(F29+H29)/2","v":135},125,{"$f":"+(H29+J29)/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,null,null,null,null,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":"+F35*placed","v":500},137.5,{"$f":"G35*H35","v":68750},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":119.74797945205479},7184.8787671232876,null,null,null,null,null,null,null,null,null," "]
[null,"HAY",null,null,"TON",0.25,25,100,2500,null,null,null,null,null,null,null,null,null," "]
[null,"RECEIVING RATION",null,null,"TONS",{"$f":"+((F35*100)*0.02*21)/2000","v":0.105},10.5,275,2887.5,null,null,null,null,null,null,null,null,null," "]
[null,"SUPPLEMENTAL FEED",null,null,"TONS",{"$f":"+(((((H28*100)-(F35*100)))/2+F35)*0.025*FEEDING_PERIOD)/2000","v":0.35062500000000019},35.062500000000021,275,9642.1875000000055]
[null,"MINERAL + IONOPHORE",null,null,"LBS.",{"$f":"+F23*0.25","v":41.25},4125,0.28000000000000003,1155,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",3,300,25,7500]
[null,"LABOR",null,null,"HRS.",1.25,125,0,0]
[null,"DEATH LOSS",null,null,"PERCENT",0.01,{"$f":"+SUM(I35:I46)","v":101829.20880105994},{"$f":"+G47*F47","v":1018.2920880105994},{"$f":"+F47*G47","v":1018.2920880105994}]
[null,"INTEREST ON CALF",null,null,"PERCENT",0.08,{"$f":"+I35*0.5","v":34375},{"$f":"+(FEEDING_PERIOD/365*F48)","v":3.6164383561643837E-2},{"$f":"+H48*G48","v":1243.1506849315069}]
[null,"INTEREST ON OTHER EXPENSES",null,null,"PERCENT",0.08,{"$f":"+(SUM(I36:I47)-I37)*0.5","v":13456.311060973625},{"$f":"+(FEEDING_PERIOD/365*F49)","v":3.6164383561643837E-2},{"$f":"+H49*G49","v":486.63919453384068}]
["Auction & Hauling Detail","AUCTION AND HAULING",null,null,"HEAD",1,{"$f":"F50*F20","v":100},{"$f":"+mktng_cst","v":20.75},{"$f":"G50*H50","v":2075}]
[]
[null,"TOTAL VARIABLE COST",null,null,null,"",null,null,{"$f":"SUM(I35:I50)","v":106652.29076853588}]
[]
[null,{"$f":"+IF(bud_type=3,\"No Fixed Costs for Variable Cost Budget\",\"FIXED COST:(Click Appropriate Link at Left for Annual Fixed Cost)\")","v":"No Fixed Costs for Variable Cost Budget"}]
["Total Cost",{"$f":"+IF(bud_type=1,\"Total Cattle Equipment Fixed Costs\",IF(bud_type=2,\"Total Fixed Cash Payments\",\"\"))","v":""},null,null,{"$f":"+IF(bud_type<>3,\"Head Sold\",\"\")","v":""},{"$f":"+IF(bud_type<>3,+ROUNDUP(sold,0),0)","v":0},null,{"$f":"+IF(bud_type<>3,I55/sold,0)","v":0},{"$f":"+IF(bud_type=1,cattle_fixed,IF(bud_type=2,cf_total,0))","v":0}]
["Cash Flow",{"$f":"+IF(bud_type=1,\"Total Machinery Fixed Costs\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Acres\",\"\")","v":""},{"$f":"+IF(bud_type=1,ACRES,0)","v":0},null,{"$f":"+IF(bud_type=1,I56/ACRES,0)","v":0},{"$f":"+IF(bud_type=1,mach_fixed,0)","v":0}]
[null,{"$f":"+IF(bud_type=1,\"Overhead\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Head Sold\",\"\")","v":""},{"$f":"+IF(bud_type=1,+ROUNDUP(sold,0),0)","v":0},null,0,{"$f":"+IF(bud_type=1,H57*F57,0)","v":0},""]
[null,{"$f":"+IF(bud_type=1,\"Management \",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"% of Value Added\",\"\")","v":""},{"$f":"+IF(bud_type=1,(H88-I35),0)","v":0},null,0.06,{"$f":"+IF(bud_type=1,H58*F58,0)","v":0},""]
[null,{"$f":"+IF(bud_type=1,\"Land\",\"\")","v":""},null,null,{"$f":"+IF(bud_type=1,\"Acres\",\"\")","v":""},{"$f":"+IF(bud_type=1,ACRES,0)","v":0},null,0,{"$f":"+IF(bud_type=1,H59*F59,0)","v":0},""]
[null,"TOTAL FIXED COST",null,null,null,null,"","",{"$f":"SUM(I55:I59)","v":0},""]
[]
[null,"      COST OF GAIN SUMMARY AND MAX. BREAKEVEN CALF PRICE"]
[null,null,null,null,null,null,null,null,"   $/CWT."]
[null,"FEED ONLY COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"SUM(I37:I41)/(D88-G35)","v":71.913659747369095}]
[null,"FEEDING COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+I52-I35-I36-I50)/(D88-G35)","v":106.77354624878834}]
[null,"TOTAL COST OF GAIN ($/CWT.)",null,null,null,null,null,null,{"$f":"+(+F80-I35-I36-I50)/(D88-G35)","v":106.77354624878834}]
[]
[null,"MAX. BREAKEVEN PURCHASE PRICE OF CALF",null,null,null,null,null,null,{"$f":"+(+H88-(+F80-I35))/G35","v":133.15955956292822}]
[]
[]
[null,"EXPECTED BREAKEVEN TABLE"]
[]
[null,"ITEM",null,null," TOTAL AMOUNT",null,null,"$ / CWT.","    $/HD."]
[null,"VARIABLE COST",null,null,null,{"$f":"I52","v":106652.29076853588},null,{"$f":"F74/(U168*F20)","v":127.98786843698052},{"$f":"+F74/sold","v":1077.2958663488473}]
[null,{"$f":"+B55","v":""},null,null,null,{"$f":"IF(I55>0,I55,0)","v":0},null,{"$f":"IF(F75>0,F75/(U168*F20),0)","v":0},0]
[null,{"$f":"+B56","v":""},null,null,null,{"$f":"I56","v":0},null,{"$f":"F76/(U168*F20)","v":0},0]
[null,{"$f":"+B57","v":""},null,null,null,{"$f":"I57","v":0},null,{"$f":"F77/(U168*F20)","v":0},0]
[null,{"$f":"+B58","v":""},null,null,null,{"$f":"I58","v":0},null,{"$f":"F78/(U168*F20)","v":0},0]
[null,{"$f":"+B59","v":""},null,null,null,{"$f":"I59","v":0},null,{"$f":"F79/(U168*F20)","v":0},0]
[null,"TOTAL COST",null,null,null,{"$f":"SUM(F74:F79)","v":106652.29076853588},null,{"$f":"F80/(U168*F20)","v":127.98786843698052},1077.2958663488473]
[]
[]
[null,"EXPECTED RETURN TABLE"]
[null,null,null,null,{"$f":"+sold","v":99}," head sold"]
[]
[null,"EXP. WEIGHT",null,"TOTAL WEIGHT",null,"EXP. PRICE",null,"TOTAL RETURN"]
[null,"(cwt./hd.)",null,"  (cwt.)",null,"  ($/cwt.)"]
[null,{"$f":"+U168","v":8.3330000000000002},null,{"$f":"+B88*sold","v":824.96699999999998},null,{"$f":"+W168","v":126.64999999999999},null,{"$f":"+F88*D88","v":104482.07054999999}]
[]
[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":"U207:U207+1.5*W206:W206","v":13932.785660877755},{"$f":"U207:U207+W206:W206","v":8916.9085177398792},{"$f":"U207:U207+0.5*W206:W206","v":3901.0313746020029},{"$f":"U207:U207","v":-1114.8457685358735},{"$f":"U207:U207-0.5*W207:W207","v":-5177.370630315776},{"$f":"U207:U207-W207:W207","v":-9239.8954920956785},{"$f":"U207:U207-1.5*W207:W207","v":-13302.420353875583}]
[null,"Chances",null,{"$f":"IF(V210<1,IF(U210,Z210,1-Z210),IF(U210,Z211,1-Z211))","v":7.5258248492120802E-2},{"$f":"IF(AB210<1,IF(AA210,AF210,1-AF210),IF(AA210,AF211,1-AF211))","v":0.15858777692957515},{"$f":"IF(AH210<1,IF(AG210,AL210,1-AL210),IF(AG210,AL211,1-AL211))","v":0.28393821296828436},{"$f":"IF(V212<1,IF(U212,Z212,1-Z212),IF(U212,Z213,1-Z213))","v":0.47259994236492797},{"$f":"IF(AB212<1,IF(AA212,AF212,1-AF212),IF(AA212,AF213,1-AF213))","v":0.66056076457555535},{"$f":"IF(AH212<1,IF(AG212,AL212,1-AL212),IF(AG212,AL213,1-AL213))","v":0.84124695343734057},{"$f":"IF(V214<1,IF(U214,Z214,1-Z214),IF(U214,Z215,1-Z215))","v":0.94524215003136025}]
[null,"Chances",null,{"$f":"IF(V210<1,IF(U210,1-Z210,Z210),IF(U210,1-Z211,Z211))","v":0.92474175150787918},{"$f":"IF(AB210<1,IF(AA210,1-AF210,AF210),IF(AA210,1-AF211,AF211))","v":0.84141222307042485},{"$f":"IF(AH210<1,IF(AG210,1-AL210,AL210),IF(AG210,1-AL211,AL211))","v":0.71606178703171564},{"$f":"IF(V212<1,IF(U212,1-Z212,Z212),IF(U212,1-Z213,Z213))","v":0.52740005763507203},{"$f":"IF(AB212<1,IF(AA212,1-AF212,AF212),IF(AA212,1-AF213,AF213))","v":0.33943923542444471},{"$f":"IF(AH212<1,IF(AG212,1-AL212,AL212),IF(AG212,1-AL213,AL213))","v":0.15875304656265948},{"$f":"IF(V214<1,IF(U214,1-Z214,Z214),IF(U214,1-Z215,Z215))","v":5.4757849968639749E-2}]
[]
[null,"  CHANCE FOR PROFIT ",null,null,{"$f":"IF(AB214<1,IF(AA214,AF214,1-AF214),IF(AA214,AF215,1-AF215))","v":0.42571918305045159},"BASE BUDGETED NET REVENUE ",null,null,null,{"$f":"+ENR","v":-1114.8457685358735}]
[null,null,null,null,null,"Profit (Loss) Per Head Placed",null,null,null,{"$f":"+J102/placed","v":-11.148457685358736}]
[]
[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":"+F28","v":9.9499999999999993},"  Best Y",{"$f":"+F29","v":145},"  Best P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,"*",{"$f":"+G28","v":8.7125000000000004},"  Opt. Y",{"$f":"+G29","v":135},"  Opt. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+H28","v":8.3000000000000007},"  Med. Y",{"$f":"H29","v":125},"  Med. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+I28","v":7.8875000000000002},"  Pess. Y",{"$f":"I29","v":120},"  Pess. P","*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*",{"$f":"+J28","v":7.4749999999999996},"  Worst Y",{"$f":"J29","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":"+F80","v":106652.29076853588},"  T.C.",null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*","*",null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",null,"Calculations",null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.04*U156+0.25*U157+0.42*U158+0.25*U159+0.04*U160","v":8.3330000000000002},"  Exp. Y",{"$f":"0.04*W156+0.25*W157+0.42*W158+0.25*W159+0.04*W160","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*(U156-U168)+0.5*(U157-U168)","v":0.59399999999999986},"  SYO",{"$f":"0.25*(W156-W168)+0.5*(W157-W168)","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*(U168-U160)+0.5*(U168-U159)","v":0.43725000000000014},"  SYP",{"$f":"0.25*(W168-W160)+0.5*(W168-W159)","v":6.2374999999999936},"  SPP",":"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U169^2","v":0.35283599999999982},"  VYO",{"$f":"W169^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":"U170^2","v":0.19118756250000013},"  VYP",{"$f":"W170^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":"(U168^2*W180)+(W168-U161)^2*U180","v":10991.183491867661},"  VTRHH",{"$f":"(U168^2*W181)+(W168-U161)^2*U181","v":5768.3086667153093},"  VTRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"(U168^2*W180)+(W168-U161)^2*U181","v":8398.306587590323},"  VTRHL",{"$f":"U168^2*W181+(W168-U161)^2*U180","v":8361.1855709926476},"  VTRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U183)","v":104.83884533829844},"  STRHH",{"$f":"SQRT(W183)","v":75.949382266844736},"  STRLL",":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"SQRT(U184)","v":91.642275111382531},"  STRHL",{"$f":"SQRT(W184)","v":91.439518650267658},"  STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"0.66*U185+0.17*U187+0.17*W187","v":100.31754286275752},"  STRO",{"$f":"0.66*W185+0.17*U187+0.17*W187","v":81.250497235598061},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","Calculation of NR and for Z values",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":","-",null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"W158","v":125},"  MP",{"$f":"+U207-U205","v":629.21250569626864},"ENR_MNR",":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",":",{"$f":"U158","v":8.3000000000000007},"  MY",{"$f":"U155*U185","v":10483.884533829843},"STRHH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+U206+0.33*(W207-W206)","v":104908.23249430374},"  MTR",{"$f":"U155*W185","v":7594.9382266844732},"STRLL",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"+F80","v":106652.29076853588},"  MTC",{"$f":"U155*U187","v":9164.2275111382532},"STRHL",":"]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,":",{"$f":"U203-U204","v":-1744.0582742321421},"  MNR",{"$f":"U155*W187","v":9143.9518650267655},"STRLH",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",":",{"$f":"U155*U168*W168","v":105537.44500000001},"  ETR",{"$f":"U155*U188","v":10031.754286275753},"  STRO",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":",{"$f":"U206-U204","v":-1114.8457685358735},"  ENR",{"$f":"U155*W188","v":8125.0497235598059},"  STRP",":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":","-",null,null,null,":"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D98>=U205","v":true},{"$f":"ABS((D98-U207)/IF(U210,W206,W207))","v":1.5},{"$f":"MIN(2.5,ABS((D98-(U205+W201*ABS(D98-U205)/ABS(IF(U210,W206+W201,W207-W201))*MIN(1,V210)))/(MIN(1.52,V210)/1.52*IF(U210,W202,W203)+(1.52-MIN(1.52,V210))/3.04*W204+(1.52-MIN(1.52,V210))/3.04*W205)))","v":1.4094255233596968},{"$f":"1/(1+(0.2316419*W210))","v":0.75387377693143653},{"$f":"0.398942281*((2.71828)^((-(W210^2)/2)))","v":0.14775821603686295},{"$f":"Y210*(0.31938153*X210-0.356563782*X210^2+1.781477937*X210^3-1.821255978*X210^4+1.330274429*X210^5)","v":7.9354793844771065E-2},{"$f":"+E98>=U205","v":true},{"$f":"ABS((E98-U207)/IF(AA210,W206,W207))","v":1},{"$f":"MIN(2.5,ABS((E98-(U205+W201*ABS(E98-U205)/ABS(IF(AA210,W206+W201,W207-W201))*MIN(1,AB210)))/(MIN(1.52,AB210)/1.52*IF(AA210,W202,W203)+(1.52-MIN(1.52,AB210))/3.04*W204+(1.52-MIN(1.52,AB210))/3.04*W205)))","v":1.0002791485428923},{"$f":"1/(1+(0.2316419*AC210))","v":0.81188168549757744},{"$f":"0.398942281*((2.71828)^((-(AC210^2)/2)))","v":0.24190326051253136},{"$f":"AE210*(0.31938153*AD210-0.356563782*AD210^2+1.781477937*AD210^3-1.821255978*AD210^4+1.330274429*AD210^5)","v":0.15858777692957515},{"$f":"+F98>=U205","v":true},{"$f":"ABS((F98-U207)/IF(AG210,W206,W207))","v":0.5},{"$f":"MIN(2.5,ABS((F98-(U205+W201*ABS(F98-U205)/ABS(IF(AG210,W206+W201,W207-W201))*MIN(1,AH210)))/(MIN(1.52,AH210)/1.52*IF(AG210,W202,W203)+(1.52-MIN(1.52,AH210))/3.04*W204+(1.52-MIN(1.52,AH210))/3.04*W205)))","v":0.57118175225260115},{"$f":"1/(1+(0.2316419*AI210))","v":0.88315066545435406},{"$f":"0.398942281*((2.71828)^((-(AI210^2)/2)))","v":0.33889575745189204},{"$f":"AK210*(0.31938153*AJ210-0.356563782*AJ210^2+1.781477937*AJ210^3-1.821255978*AJ210^4+1.330274429*AJ210^5)","v":0.28393821296828436}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((D98-U207)/(MIN(1.52,V210)/1.52*IF(U210,W202,W203)+(1.52-MIN(1.52,V210))/3.04*W204+(1.52-MIN(1.52,V210))/3.04*W205)))","v":1.4377101758323572},0.75016845964143697,0.14192690444264891,7.5258248492120802E-2,null,null,{"$f":"MIN(2.5,ABS((E98-U207)/(MIN(1.52,AB210)/1.52*IF(AA210,W202,W203)+(1.52-MIN(1.52,AB210))/3.04*W204+(1.52-MIN(1.52,AB210))/3.04*W205)))","v":1.0002791485428923},0.81188168549757744,0.24190326051253136,0.15858777692957515,null,null,{"$f":"MIN(2.5,ABS((F98-U207)/(MIN(1.52,AH210)/1.52*IF(AG210,W202,W203)+(1.52-MIN(1.52,AH210))/3.04*W204+(1.52-MIN(1.52,AH210))/3.04*W205)))","v":0.52294902069877247},{"$f":"1/(1+(0.2316419*AI211))","v":0.89195172842519888},{"$f":"0.398942281*((2.71828)^((-(AI211^2)/2)))","v":0.34795703173663972},{"$f":"AK211*(0.31938153*AJ211-0.356563782*AJ211^2+1.781477937*AJ211^3-1.821255978*AJ211^4+1.330274429*AJ211^5)","v":0.30050487440642976}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"+G98>=U205","v":true},{"$f":"ABS((G98-U207)/IF(U212,W206,W207))","v":0},{"$f":"MIN(2.5,ABS((G98-(U205+W201*ABS(G98-U205)/ABS(IF(U212,W206+W201,W207-W201))*MIN(1,V212)))/(MIN(1.52,V212)/1.52*IF(U212,W202,W203)+(1.52-MIN(1.52,V212))/3.04*W204+(1.52-MIN(1.52,V212))/3.04*W205)))","v":6.873567193856811E-2},0.98432747722809022,0.39800097402022155,0.47259994236492797,{"$f":"+H98>=U205","v":false},{"$f":"ABS((H98-U207)/IF(AA212,W206,W207))","v":0.49999999999999994},{"$f":"MIN(2.5,ABS((H98-(U205+W201*ABS(H98-U205)/ABS(IF(AA212,W206+W201,W207-W201))*MIN(1,AB212)))/(MIN(1.52,AB212)/1.52*IF(AA212,W202,W203)+(1.52-MIN(1.52,AB212))/3.04*W204+(1.52-MIN(1.52,AB212))/3.04*W205)))","v":0.41399420078070842},0.9124933452108851,0.36617860485566422,0.33943923542444471,{"$f":"+I98>=U205","v":false},{"$f":"ABS((I98-U207)/IF(AG212,W206,W207))","v":0.99999999999999989},{"$f":"MIN(2.5,ABS((I98-(U205+W201*ABS(I98-U205)/ABS(IF(AG212,W206+W201,W207-W201))*MIN(1,AH212)))/(MIN(1.52,AH212)/1.52*IF(AG212,W202,W203)+(1.52-MIN(1.52,AH212))/3.04*W204+(1.52-MIN(1.52,AH212))/3.04*W205)))","v":0.99959617495082398},{"$f":"1/(1+(0.2316419*AI212))","v":0.81198598021348323},{"$f":"0.398942281*((2.71828)^((-(AI212^2)/2)))","v":0.24206852006502497},{"$f":"AK212*(0.31938153*AJ212-0.356563782*AJ212^2+1.781477937*AJ212^3-1.821255978*AJ212^4+1.330274429*AJ212^5)","v":0.15875304656265948}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2.5,ABS((G98-U207)/(MIN(1.52,V212)/1.52*IF(U212,W202,W203)+(1.52-MIN(1.52,V212))/3.04*W204+(1.52-MIN(1.52,V212))/3.04*W205)))","v":0},1,0.39894228100000001,0.50000000022538427,null,null,{"$f":"MIN(2.5,ABS((H98-U207)/(MIN(1.52,AB212)/1.52*IF(AA212,W202,W203)+(1.52-MIN(1.52,AB212))/3.04*W204+(1.52-MIN(1.52,AB212))/3.04*W205)))","v":0.47013374634464605},0.90179239640636477,0.3572028943626992,0.31912976661092435,null,null,{"$f":"MIN(2.5,ABS((I98-U207)/(MIN(1.52,AH212)/1.52*IF(AG212,W202,W203)+(1.52-MIN(1.52,AH212))/3.04*W204+(1.52-MIN(1.52,AH212))/3.04*W205)))","v":0.99959617495082398},{"$f":"1/(1+(0.2316419*AI213))","v":0.81198598021348323},{"$f":"0.398942281*((2.71828)^((-(AI213^2)/2)))","v":0.24206852006502497},{"$f":"AK213*(0.31938153*AJ213-0.356563782*AJ213^2+1.781477937*AJ213^3-1.821255978*AJ213^4+1.330274429*AJ213^5)","v":0.15875304656265948}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"+J98>=U205","v":false},{"$f":"ABS((J98-U207)/IF(U214,W206,W207))","v":1.5},{"$f":"MIN(2.5,ABS((J98-(U205+W201*ABS(J98-U205)/ABS(IF(U214,W206+W201,W207-W201))*MIN(1,V214)))/(MIN(1.52,V214)/1.52*IF(U214,W202,W203)+(1.52-MIN(1.52,V214))/3.04*W204+(1.52-MIN(1.52,V214))/3.04*W205)))","v":1.6451534487462665},0.7240676244715798,0.10308487959388209,4.9969115129293279E-2,{"$f":"0>=U205","v":true},{"$f":"ABS((0-U207)/IF(AA214,W206,W207))","v":0.11113168611606369},{"$f":"MIN(2.5,ABS((0-(U205+W201*ABS(0-U205)/ABS(IF(AA214,W206+W201,W207-W201))*MIN(1,AB214)))/(MIN(1.52,AB214)/1.52*IF(AA214,W202,W203)+(1.52-MIN(1.52,AB214))/3.04*W204+(1.52-MIN(1.52,AB214))/3.04*W205)))","v":0.18728353591287827},0.9584210917897954,0.39200680434490209,0.42571918305045159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"MIN(2.5,ABS((J98-U207)/(MIN(1.52,V214)/1.52*IF(U214,W202,W203)+(1.52-MIN(1.52,V214))/3.04*W204+(1.52-MIN(1.52,V214))/3.04*W205)))","v":1.6003741315468338},0.72954694819650245,0.11085454407313673,5.4757849968639749E-2,null,null,{"$f":"MIN(2.5,ABS((0-U207)/(MIN(1.52,AB214)/1.52*IF(AA214,W202,W203)+(1.52-MIN(1.52,AB214))/3.04*W204+(1.52-MIN(1.52,AB214))/3.04*W205)))","v":0.12050673649090024},0.97284364422933922,0.39605607920892577,0.45204083013175422]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXPDATA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U155","v":100},{"$f":"U168","v":8.3330000000000002},{"$f":"W168","v":126.64999999999999},{"$f":"I80","v":1077.2958663488473},{"$f":"W206","v":10031.754286275753},{"$f":"W207","v":8125.0497235598059},{"$f":"W202","v":10483.884533829843},{"$f":"W204","v":9164.2275111382532},{"$f":"W203","v":7594.9382266844732},{"$f":"W205","v":9143.9518650267655}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,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,"FALL 2012",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},24,{"$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.75,{"$f":"H32*I32","v":4687.5},93.75]
[null," P205",null,null,null,"LB.",0,{"$f":"G33*F16","v":0},0.6,{"$f":"H33*I33","v":0},0]
[null," K20",null,null,null,"LB.",0,{"$f":"G34*F16","v":0},0.55000000000000004,{"$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":2951.25},7.0000000000000007E-2,{"$f":"+(I41*H41)*days/365","v":84.898972602739732},1.6979794520547946]
[null,"TOTAL VARIABLE COST",null,null,null,null,"",null,null,{"$f":"SUM(J25:J41)","v":5987.3989726027394},119.74797945205479]
[]
["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":5987.3989726027394}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":4490.5492294520545},{"$f":"+F63*0.9","v":5388.6590753424653},{"$f":"+tvc_grazing","v":5987.3989726027394},{"$f":"+F63*1.1","v":6586.1388698630135},{"$f":"+F63*1.25","v":7484.2487157534242}]
[null,null,30,{"$f":"+D$63/$C64","v":149.68497431506847},179.62196917808217,199.57996575342466,219.53796232876712,249.47495719178082]
[null,null,60,74.842487157534237,89.810984589041084,99.78998287671233,109.76898116438356,124.73747859589041]
[null,null,90,49.894991438356165,59.873989726027389,66.526655251141548,73.179320776255707,83.158319063926939]
[null,null,120,37.421243578767118,44.905492294520542,49.894991438356165,54.884490582191781,62.368739297945204]
[null,null,150,29.936994863013698,35.924393835616435,39.915993150684926,43.907592465753424,49.894991438356165]
[null,null,180,24.947495719178082,29.936994863013695,33.263327625570774,36.589660388127854,41.579159531963469,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":4490.5492294520545},{"$f":"+E63","v":5388.6590753424653},{"$f":"+F63","v":5987.3989726027394},{"$f":"+G63","v":6586.1388698630135},{"$f":"+H63","v":7484.2487157534242}]
[null,null,0.25,{"$f":"+D$74/$C75","v":17962.196917808218},21554.636301369861,23949.595890410958,26344.555479452054,29936.994863013697]
[null,null,{"$f":"+C75+0.25","v":0.5},8981.0984589041091,10777.318150684931,11974.797945205479,13172.277739726027,14968.497431506848]
[null,null,{"$f":"+C76+0.25","v":0.75},5987.3989726027394,7184.8787671232867,7983.1986301369861,8781.5184931506847,9978.9982876712329]
[null,null,{"$f":"+C77+0.25","v":1},4490.5492294520545,5388.6590753424653,5987.3989726027394,6586.1388698630135,7484.2487157534242]
[null,null,{"$f":"+C78+0.25","v":1.25},3592.4393835616438,4310.927260273972,4789.9191780821911,5268.9110958904112,5987.3989726027394,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[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":43.907592465753424},"  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":43.907592465753424},"  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":"Feed Cost","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Animal Type","Steer"]
["Gain Target",1.5]
["Calf weight",650]
["Days fed",30]
[null,"$/ton","$/#","% of Ration","#/ton","Cost/ton"]
["corn",100,{"$f":"+B6/2000","v":0.05},0.65,{"$f":"+D6*2000","v":1300},{"$f":"+E6*C6","v":65}]
["whole cottonseed",125,{"$f":"+B7/2000","v":6.25E-2},0.1,{"$f":"+D7*2000","v":200},{"$f":"+E7*C7","v":12.5}]
["gin trash",15,{"$f":"+B8/2000","v":7.4999999999999997E-3},0.15,{"$f":"+D8*2000","v":300},{"$f":"+E8*C8","v":2.25}]
["Soybean Meal",250,{"$f":"+B9/2000","v":0.125},0.1,{"$f":"+D9*2000","v":200},{"$f":"+E9*C9","v":25}]
[null,null,null,{"$f":"+SUM(D6:D9)","v":1},"Total",{"$f":"SUM(F6:F9)","v":104.75}]
[null,null,null,null,"Total $/#",{"$f":"+F10/2000","v":5.2374999999999998E-2}]
[]
["Consumption","# fed/day","Cost/day","Total cost","total # fed","$/Cwt"]
[5.0000000000000001E-3,{"$f":"+A14*$B$3","v":3.25},{"$f":"+B14*$F$11","v":0.17021875},{"$f":"+C14*$B$4","v":5.1065624999999999},{"$f":"+B14*$B$4","v":97.5}]
[0.01,6.5,0.3404375,10.213125,{"$f":"+B15*$B$4","v":195}]
[1.4999999999999999E-2,9.75,0.51065625000000003,15.319687500000001,292.5]
[1.7500000000000002E-2,11.375000000000002,0.59576562500000008,17.872968750000002,341.25000000000006]
[0.02,13,0.68087500000000001,20.42625,390]
[2.1999999999999999E-2,14.299999999999999,0.74896249999999986,22.468874999999997,428.99999999999994]
[2.5000000000000001E-2,16.25,0.85109374999999998,25.532812499999999,487.5]

{"sheet":"Procurement","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[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!H28*Main!H29","v":1037.5},0.02,{"$f":"+G16*F16","v":20.75}]
[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":20.75}]

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

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

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

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

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

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

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

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