{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Program","Feed Library","Analyzer"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":10,"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":"Program","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"UGA Feed Cost Analyzer"]
[]
[null,null,null,null,null,null,"Lawton Stewart, Extension Animal Scientist"]
[null,null,null,null,null,null,"Curt Lacy, Extension Livestock Economist"]
[null,null,null,null,null,null,"Dennis Hancock, Extension Forage Specialist"]

{"sheet":"Feed Library","index":1,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,"Feed Library"]
[]
[null,null,"Feeds","DM","CP","TDN","Ca","P","$/ton*",null,"Legend"]
[null,null,"FORAGE/ROUGHAGE",null,null,null,null,null,null,null,"DM = Dry Matter"]
[null,1,"Bermudagrass hay, good",85,12,58,0.38,0.22,20,null,"CP = Crude Protein"]
[null,2,"Bermudagrass hay, average",85,10,53,0.36,0.18,100,null,"TDN = Total Digestible Nutrients"]
[null,3,"Bermudagrass hay, poor",85,6,49,0.34,0.18,80,null,"Ca = Calcium"]
[null,4,"Tall fescue hay, good",85,16,60,0.43,0.32,120,null,"P = Phosphorus"]
[null,5,"Tall fescue hay, average",85,13,55,0.42,0.31,100,null,"$/ton = dollars per ton of feed stuff as fed"]
[null,6,"Tall fescue hay, poor",85,10,50,0.41,0.3,80,null,"* prices for pastures are based on"]
[null,7,"Peanut Hay",88,11,48,1.2,0.15,80,null,"   average management"]
[null,8,"Bermudagrass pasture",25,13,64,0.4,0.27,8.75]
[null,9,"Bahiagrass pasture",25,10,58,0.46,0.22,8.25]
[null,10,"Summer annual pasture",25,12,60,0.5,0.44,8.5]
[null,11,"Small grains pasture - vegetative",22,18,70,0.45,0.35,12.5]
[null,12,"Small grains pasture - mature",25,12,58,0.4,0.3,12.5]
[null,13,"Ann. Ryegrass pasture - vegetative",22,20,72,0.65,0.41,10]
[null,14,"Ann. Ryegrass pasture - mature",25,12,58,0.6,0.35,10]
[null,15,"Tall fescue pasture",25,14,62,0.44,0.33,8]
[null,16,"Corn Silage",31.7,8,70.7,0.14000000000000001,0.18,50]
[null,17,"Cottonseed Hulls",90,4,45,0.15,0.09,180]
[null,18,"Gin Trash",85,11.7,46.6,0.9,0.2,35]
[null,19,"Peanut Hulls",90,8,25,1.2,0.1,20]
[null,20,"Soybean Stubble",85,5,40,1.2,0.15,20]
[null,21,"BLANK",100,1,1,0,0,999]
[null,22,"BLANK",100,1,1,0,0,999]
[null,23,"BLANK",100,1,1,0,0,999]
[null,24,"BLANK",100,1,1,0,0,999]
[null,25,"BLANK",100,1,1,0,0,999]
[null,26,"BLANK",100,1,1,0,0,999]
[null,27,"BLANK",100,1,1,0,0,999]
[null,28,"PROTEIN"]
[null,29,"Brewer's Grains",25,27,75,0.3,0.6,30]
[null,30,"Chicken Litter",85,18,50,3,2,35]
[null,31,"Corn Gluten",90,25,83,0.08,0.54,125]
[null,32,"Cottonseed Meal",90,46,78,0.21,1,230]
[null,33,"Distiller's Grains",90,28,95,0.05,0.88,145]
[null,34,"Liquid Feed",67,45,80,2,1,285]
[null,35,"Molasses Block",76,30,80,2,1,650]
[null,36,"Range Cubes",85,25,75,1.75,0.5,330]
[null,37,"Soybean Meal",90,49,84,0.3,0.7,320]
[null,38,"Sunflower Meal",90,43.6,75,0.5,1.68,210]
[null,39,"Urea",99,291,0.01,1E-4,1E-4,150]
[null,40,"Whole Cottonseed",90,25,95,0.21,0.64,170]
[null,41,"Whole Soybeans",90,42,91,0.27,0.3,10]
[null,42,"Whole Peanuts",93,23,110,0.15,0.03,75]
[null,43,"BLANK",100,1,1,0,0,999]
[null,44,"BLANK",100,1,1,0,0,999]
[null,45,"BLANK",100,1,1,0,0,999]
[null,46,"BLANK",100,1,1,0,0,999]
[null,47,"BLANK",100,1,1,0,0,999]
[null,48,"ENERGY/TDN"]
[null,49,"Barley",90,13.2,84,0.05,0.35,200]
[null,50,"Citrus Pulp",90,7,82,1.8,0.15,120]
[null,51,"Corn",90,8,90,0.02,0.35,160]
[null,52,"Grain Sorghum",90,12,76,0.05,0.34,0]
[null,53,"Molasses",78,9,78,1.1000000000000001,0.1,25]
[null,54,"Oats",90,13,77,7.0000000000000007E-2,0.38,250]
[null,55,"Soybean Hulls",90,12,78,0.55000000000000004,0.2,130]
[null,56,"Wheat",90,14,90,0.05,0.43,175]
[null,57,"Wheat Midds",90,18,83,0.15,1,165]
[null,58,"50:50 CGF:SH",90,18,80,0.31,0.37,140]
[null,59,"50:50 DDG:SH",90,19,81,0.31,0.37,150]
[null,60,"60:20:20 SH:CGF:Corn",90,13.4,82.1,0.3,0.32300000000000001,0]
[null,61,"65:25:10 SH:CGF:PH",90,15,74,0.498,0.27700000000000002,0]
[null,62,"95:5 Corn:Urea",91,23.5,85.1,1.9E-2,0.33,160]
[null,63,"BLANK",100,1,1,0,0,999]
[null,64,"BLANK",100,1,1,0,0,999]
[null,65,"BLANK",100,1,1,0,0,999]
[null,66,"BLANK",100,1,1,0,0,999]
[null,67,"BLANK",100,1,1,0,0,999]
[null,68,"BLANK",100,1,1,0,0,999]

{"sheet":"Analyzer","index":2,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UGA Feed Cost Analyzer"]
[]
[null,"Date",{"$f":"TODAY()","v":"2010-12-15"},null,"Dr. Lawton Stewart, Animal and Dairy Science"]
[null,"Farm","UGA Farms",null,"Dr. Curt Lacy, Agriculture and Applied Economics"]
[null,null,null,null,"Dr. Dennis Hancock, Crop and Soil Sciences"]
[null,null,null,null,"Local Extension Office: 1-800-ASK-UGA1",null,null,null,null,null,"Instructions:"]
[]
[null,"Ingredients","$/ton","% DM","% CP","% TDN","$/CWT DM","$/lb CP","$/lb TDN",null,"Analyzer"]
[null,"Cottonseed Meal",{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$72,7,FALSE)","v":230},{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$72,2,FALSE)","v":90},{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$72,3,FALSE)","v":46},{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$72,4,FALSE)","v":78},{"$f":"C10/20/(D10/100)","v":12.777777777777777},{"$f":"C10/(2000*(D10/100)*(E10/100))","v":0.27777777777777779},{"$f":"C10/(2000*(D10/100)*(F10/100))","v":0.16381766381766383},null,"1)","Adjust nutrient content n Feed Library if a nutrient analysis is available for a given feed."]
[null,"Corn Gluten",{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$72,7,FALSE)","v":125},{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$72,2,FALSE)","v":90},{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$72,3,FALSE)","v":25},{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$72,4,FALSE)","v":83},6.9444444444444446,{"$f":"C11/(2000*(D11/100)*(E11/100))","v":0.27777777777777779},{"$f":"C11/(2000*(D11/100)*(F11/100))","v":8.3668005354752342E-2},null,"2)","Select feeds to compare from drop down menus under \"Ingredients\"."]
[null,"Soybean Meal",{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$72,7,FALSE)","v":320},{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$72,2,FALSE)","v":90},{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$72,3,FALSE)","v":49},{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$72,4,FALSE)","v":84},17.777777777777779,0.36281179138321995,{"$f":"C12/(2000*(D12/100)*(F12/100))","v":0.21164021164021163},null,"3)","In the",null,"shaded cells, the values of each feedstuff will be reported "]
[null,"Whole Cottonseed",{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$72,7,FALSE)","v":170},{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$72,2,FALSE)","v":90},{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$72,3,FALSE)","v":25},{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$72,4,FALSE)","v":95},9.4444444444444446,0.37777777777777777,9.9415204678362568E-2,null,null,"on a $/ pound of nutrient (dry matter basis)."]
[null,"Soybean Hulls",{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$72,7,FALSE)","v":130},{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$72,2,FALSE)","v":90},{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$72,3,FALSE)","v":12},{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$72,4,FALSE)","v":78},7.2222222222222223,0.60185185185185186,9.2592592592592587E-2,null,"4)","The  three  cheapest  options will be highlighted in order of green, yellow, red."]
[null,"Molasses Block",{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$72,7,FALSE)","v":650},{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$72,2,FALSE)","v":76},{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$72,3,FALSE)","v":30},{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$72,4,FALSE)","v":80},42.763157894736842,1.4254385964912282,0.53453947368421051]
[null,"Liquid Feed",{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$72,7,FALSE)","v":285},{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$72,2,FALSE)","v":67},{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$72,3,FALSE)","v":45},{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$72,4,FALSE)","v":80},21.268656716417908,0.47263681592039802,0.26585820895522388]
[null,"BLANK",{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,{"$f":"C17/(2000*(D17/100)*(F17/100))","v":49.95}]
[null,"BLANK",{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[null,"BLANK",{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[null,"BLANK",{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[null,"BLANK",{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[null,"BLANK",{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[null,"BLANK",{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[null,"BLANK",{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$72,7,FALSE)","v":999},{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$72,2,FALSE)","v":100},{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$72,3,FALSE)","v":1},{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$72,4,FALSE)","v":1},49.95,49.95,49.95]
[]
[]
[]
[null,"Feed Comparison",null,null,null,null,null,null,null,null,"Feed Comparison"]
[null,"Current Feedstuff",null,"Alternative Feedstuff",null,null,"*Price at which ALTERNATIVE Feed ",null,null,null,"1)","Make sure prices are correct in the Feed Library."]
[null,"Soybean Meal","vs.","Distiller's Grains",null,null,"must be, or below, to replace",null,null,null,"2)","Select the current feed being utilized from the drop down menu"]
[null,null,null,null,null,null," CURRENT Feed for respective",null,null,null,null," in the",null,"box."]
[null,null,null,"TDN*",null,null," nutrient.",null,null,null,"3)","Select the potential feed to utilize from the drop down menu"]
[null,null,null,{"$f":"(VLOOKUP(B30,'Feed Library'!C5:I81,7,FALSE))/(2000*(VLOOKUP(B30,'Feed Library'!C5:I81,2,FALSE)/100)*(VLOOKUP(B30,'Feed Library'!C5:I81,4,FALSE)/100))*(VLOOKUP(D30,'Feed Library'!$C$5:$I$88,2,FALSE)/100)*(VLOOKUP(D30,'Feed Library'!$C$5:$I$88,4,FALSE)/100)*2000","v":361.90476190476181},null,null,null,null,null,null,null," in the",null,"box."]
[null,null,null,"CP*",null,null,null,null,null,null,"4)","The price at which the potential feed needs to be, or lower,  in order"]
[null,null,null,{"$f":"(VLOOKUP(B30,'Feed Library'!C5:I81,7,FALSE))/(2000*(VLOOKUP(B30,'Feed Library'!C5:I81,2,FALSE)/100)*(VLOOKUP(B30,'Feed Library'!C5:I81,3,FALSE)/100))*(VLOOKUP(D30,'Feed Library'!$C$5:$I$88,2,FALSE)/100)*(VLOOKUP(D30,'Feed Library'!$C$5:$I$88,3,FALSE)/100)*2000","v":182.85714285714289},null,null,null,null,null,null,null," to replace the current feed will appear in the ",null,null,null,null,null,null,null,"boxes for a"]
[null,null,null,null,null,null,null,null,null,null,null," given nutrient."]