{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Corn","Sorghum"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":25,"comments":2,"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":"Introduction","index":0,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,6,50,8],[52,1,52,10],[27,1,30,11],[31,1,35,11],[36,1,36,4],[37,1,39,11],[44,1,44,3],[44,7,44,9],[26,1,26,4],[4,1,5,9],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13]]}
[]
[]
[null,"KSU-Silage Value"]
[]
[null,"A spreadsheet program to estimate the value of corn or grain sorghum silage based upon the price of grain, harvesting costs, and nutrients removed."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version-7.8.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CONCEPTUAL APPROACH:"]
[null,"The concept behind the formulas in this spreadsheet is to find the value of silage where the crop producer is indifferent between harvesting the silage as grain or silage.  This approach does not factor in potential value associated with maintaining residue other than nutrient removal and thus if erosion is a concern the values may underestimate what is needed for the silage."]
[]
[]
[]
[null,"Because of the approach used here, calculated values may not be appropriate for drought stressed or hail damaged corn where grain harvest is not an option.  However, calculated values can still help producers determine upper and lower bounds as to what might be reasonable.  Additionally, what a livestock producer is willing to pay, based on costs of alternative feedstuffs or harvesting costs if they are buying silage \"in the field\", are not factored into the calculations."]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"In the various sheets all blue numbers are inputs and all black numbers are calculated from these inputs.  The spreadsheet automatically recalculates every time an additional input is entered.  Thus, it is important to wait until all data have been entered and reviewed before interpreting any of the calculated results (i.e., black numbers)."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[]
[null,"With Questions Contact:",null,null,null,null,null,"Originally Developed by:"]
[]
[null,"Robin Reid",null,null,null,null,null,"Kevin Dhuyvetter"]
[null,"Extension Associate",null,null,null,null,null,"Former Agricultural Economist"]
[null,"Kansas State University",null,null,null,null,null,"Kansas State University"]
[null,"785-532-0964"]
[null,"robinreid@ksu.edu"]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Corn","index":1,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[10,8,10,9],[8,8,8,9],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[9,8,9,9]]}
[]
[null,"Valuing Corn Silage"]
[]
[null,"Grain yield in bushels",null,null,null,null,175,null,"Nutrient removal",null,"N","P2O5","K2O"]
[null,"Moisture content of grain at harvest",null,null,null,null,0.155,null,"Grain, lbs/bu",null,0.8,0.33,0.26]
[null,"Grain yield in pounds",null,null,null,null,{"$f":"G4*56","v":9800},null,"Silage, lbs/ton",null,11,3.2,8.6999999999999993]
[null,"Grain yield in pounds @ 100% DM",null,null,null,null,{"$f":"G6*(1-G5)","v":8281},null,"Grain, lbs/acre",null,{"$f":"$G4*K5","v":140},{"$f":"$G4*L5","v":57.75},{"$f":"$G4*M5","v":45.5}]
[null,null,null,null,null,null,null,null,"Silage, lbs/acre",null,{"$f":"$G16*K6","v":276.87234042553195},{"$f":"$G16*L6","v":80.544680851063845},{"$f":"$G16*M6","v":218.98085106382982}]
[null,"Percent grain in silage (DM)",null,null,null,null,0.47,null,"Price, $/lb",null,0.6,0.65,0.4]
[null,"Percent forage in silage (DM)",null,null,null,null,{"$f":"1-G9","v":0.53},null,"Percent to include",null,0,1,0.25]
[null,"Percent DM in silage at harvest",null,null,null,null,0.35,null,"Difference in cost, $/ac",null,{"$f":"(K7-K8)*K9*K10","v":0},{"$f":"(L7-L8)*L9*L10","v":-14.8165425531915},{"$f":"(M7-M8)*M9*M10","v":-17.348085106382982},{"$f":"SUM(K11:M11)","v":-32.164627659574478}]
[]
[null,"Silage yield in pounds",null,null,null,null,{"$f":"G6/G9","v":20851.063829787236},null,"Harvest & hauling for grain, $/bu",null,null,null,null,0.4]
[null,"Silage yield in pounds @ 100% DM",null,null,null,null,{"$f":"G7/G9","v":17619.148936170215},null,"Harvest & hauling charge for silage, $/ton",null,null,null,null,8.5]
[null,"Silage yield in pounds as harvested",null,null,null,null,{"$f":"G14/G11","v":50340.425531914902},null,"Difference in grain preharvest non-fertilizer VC/ac",null,null,null,null,0]
[null,"Silage yield in tons as harvested",null,null,null,null,{"$f":"G15/2000","v":25.170212765957451}]
[null,"Bushels of Corn per ton of silage",null,null,null,null,{"$f":"G4/G16","v":6.95266272189349}]
[null,"Tons of silage per bushel of Corn",null,null,null,null,{"$f":"G16/G4","v":0.14382978723404258}]
[]
[null,""]
[]
[null,"Price of Corn Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Corn Silage when SELLER Pays for Harvesting Cost"]
[]
[null,"Corn",null,"  Percent DM in silage",null,null,"Factor",null,{"$f":"B24","v":"Corn"},null,"  Percent DM in silage",null,null,"Factor"]
[null,"Price",0.3,{"$f":"C25+$G37","v":0.32500000000000001},{"$f":"D25+$G37","v":0.35000000000000003},{"$f":"E25+$G37","v":0.37500000000000006},{"$f":"\"@ \"&FIXED(D25*100,1)&\"%\"","v":"@ 32.5%"},null,"Price",{"$f":"C25","v":0.3},{"$f":"D25","v":0.32500000000000001},{"$f":"E25","v":0.35000000000000003},{"$f":"F25","v":0.37500000000000006},{"$f":"\"@ \"&FIXED(K25*100,1)&\"%\"","v":"@ 32.5%"}]
[null,"($/bu)","Silage Price ($/ton)",null,null,null,"DM",null,"($/bu)","Silage Price ($/ton)",null,null,null,"DM"]
[null,3,{"$f":"($G$4*$B27-($N$11+$N$15)-$G$4*$N$13)/($G$14/C$25/2000)","v":16.589835164835165},17.97232142857143,19.354807692307695,20.73729395604396,{"$f":"D27/B27","v":5.9907738095238097},null,3,{"$f":"($G$4*$I27-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$14/J$25/2000)/($G$14/J$25/2000)","v":25.089835164835165},26.472321428571426,27.854807692307695,29.23729395604396,{"$f":"K27/I27","v":8.8241071428571427}]
[null,{"$f":"B27+N$37","v":3.25},18.079691462383767,19.586332417582419,21.092973372781067,22.599614327979719,6.0265638207945909,null,3.25,26.579691462383767,28.086332417582415,29.592973372781067,31.099614327979719,8.6419484361792041]
[null,3.5,19.569547759932373,21.200343406593408,22.831139053254439,24.461934699915474,6.0572409733124024,null,3.5,28.069547759932373,29.700343406593404,31.331139053254439,32.961934699915474,8.4858124018838303]
[null,3.75,21.059404057480979,22.814354395604397,24.569304733727812,26.324255071851233,6.0838278388278395,null,3.75,29.559404057480979,31.314354395604393,33.069304733727812,34.824255071851233,8.3504945054945043]
[null,4,22.549260355029585,24.428365384615386,26.307470414201184,28.186575443786989,6.1070913461538465,null,4,31.049260355029585,32.928365384615383,34.807470414201184,36.686575443786985,8.2320913461538456]
[null,4.25,24.039116652578191,26.042376373626375,28.045636094674556,30.048895815722744,6.1276179702650291,null,4.25,32.539116652578187,34.542376373626375,36.545636094674556,38.548895815722744,8.12761797026503]
[null,4.5,25.528972950126793,27.656387362637364,29.783801775147932,31.911216187658503,6.1458638583638585,null,4.5,34.028972950126793,36.156387362637361,38.283801775147928,40.411216187658503,8.034752747252746]
[null,4.75,27.018829247675399,29.270398351648353,31.521967455621304,33.773536559594255,6.1621891266628115,null,4.75,35.518829247675399,37.770398351648346,40.021967455621301,42.273536559594255,7.9516628108733363]
[null,5,28.508685545224004,30.884409340659342,33.260133136094673,35.635856931530014,6.1768818681318685,null,5,37.008685545224004,39.384409340659339,41.760133136094673,44.135856931530014,7.8768818681318677]
[null,5.25,29.99854184277261,32.498420329670331,34.998298816568045,37.498177303465773,6.190175300889587,null,5.25,38.49854184277261,40.998420329670324,43.498298816568045,45.998177303465773,7.8092229199372047]
[null,"Increment for Percent DM in silage",null,null,null,null,2.5000000000000001E-2,null,"Increment for Corn Price ($/bu)",null,null,null,null,0.25]
[]
[null,"Price of Corn Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Corn Silage when SELLER Pays for Harvesting Cost"]
[]
[null,{"$f":"B24","v":"Corn"},null,"Percent grain (DM) in silage",null,null,null,null,{"$f":"B41","v":"Corn"},null,"Percent grain (DM) in silage"]
[null,"Price",{"$f":"D42-$G54","v":0.41999999999999993},{"$f":"E42-$G54","v":0.44499999999999995},{"$f":"G9","v":0.47},{"$f":"E42+G54","v":0.495},{"$f":"F42+G54","v":0.52},null,{"$f":"B42","v":"Price"},{"$f":"C42","v":0.41999999999999993},{"$f":"D42","v":0.44499999999999995},{"$f":"E42","v":0.47},{"$f":"F42","v":0.495},{"$f":"G42","v":0.52}]
[null,"($/bu)","Silage Price ($/ton)",null,null,null,null,null,{"$f":"B43","v":"($/bu)"},"Silage Price ($/ton)"]
[null,3,{"$f":"($G$4*$B44-($N$11+$N$15)-$G$4*$N$13)/($G$7/C$42/$G$11/2000)","v":17.295785597381339},18.325296644844517,19.354807692307691,20.384318739770869,21.413829787234047,null,{"$f":"I27","v":3},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/C$42/$G$11/2000)/($G$7/J$42/$G$11/2000)","v":25.795785597381339},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/D$42/$G$11/2000)/($G$7/K$42/$G$11/2000)","v":26.825296644844517},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/E$42/$G$11/2000)/($G$7/L$42/$G$11/2000)","v":27.854807692307691},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/F$42/$G$11/2000)/($G$7/M$42/$G$11/2000)","v":28.884318739770872},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/G$42/$G$11/2000)/($G$7/N$42/$G$11/2000)","v":29.913829787234047}]
[null,3.25,18.849040035251161,19.971006704016112,21.092973372781064,22.214940041546019,23.33690671031097,null,3.25,27.349040035251161,28.471006704016112,29.592973372781064,30.714940041546019,31.83690671031097]
[null,3.5,20.402294473120982,21.616716763187711,22.831139053254436,24.045561343321165,25.259983633387893,null,3.5,28.902294473120982,30.116716763187711,31.331139053254436,32.545561343321168,33.75998363338789]
[null,3.75,21.955548910990807,23.262426822359309,24.569304733727808,25.876182645096314,27.183060556464813,null,3.75,30.455548910990807,31.762426822359309,33.069304733727812,34.376182645096314,35.683060556464817]
[null,4,23.508803348860628,24.908136881530904,26.30747041420118,27.70680394687146,29.106137479541736,null,4,32.008803348860624,33.408136881530908,34.807470414201184,36.20680394687146,37.606137479541736]
[null,4.25,25.062057786730449,26.553846940702503,28.045636094674553,29.53742524864661,31.02921440261866,null,4.25,33.562057786730449,35.053846940702499,36.545636094674556,38.037425248646613,39.529214402618663]
[null,4.5,26.61531222460027,28.199556999874098,29.783801775147925,31.368046550421756,32.952291325695583,null,4.5,35.115312224600274,36.699556999874098,38.283801775147928,39.868046550421759,41.452291325695583]
[null,4.75,28.168566662470095,29.845267059045696,31.521967455621297,33.198667852196905,34.87536824877251,null,4.75,36.668566662470091,38.345267059045696,40.021967455621301,41.698667852196905,43.37536824877251]
[null,5,29.721821100339916,31.490977118217295,33.260133136094673,35.029289153972051,36.79844517184943,null,5,38.221821100339916,39.990977118217295,41.760133136094673,43.529289153972051,45.29844517184943]
[null,5.25,31.275075538209737,33.136687177388893,34.998298816568045,36.859910455747197,38.72152209492635,null,5.25,39.775075538209741,41.636687177388893,43.498298816568045,45.359910455747197,47.22152209492635]
[null,"Increment for Pecent grain (DM) in silage",null,null,null,null,{"$f":"G37","v":2.5000000000000001E-2}]
[]
[null,"Price of Corn Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Corn Silage when SELLER Pays for Harvesting Cost"]
[]
[null,{"$f":"B41","v":"Corn"},"  Harvest and hauling charge, $/bu",null,null,null,null,null,{"$f":"B58","v":"Corn"},"Harvest and hauling charge, $/ton"]
[null,{"$f":"B42","v":"Price"},{"$f":"D59-$G71","v":0.33999999999999997},{"$f":"E59-$G71","v":0.37},{"$f":"N13","v":0.4},{"$f":"E59+$G71","v":0.43000000000000005},{"$f":"F59+$G71","v":0.46000000000000008},null,{"$f":"B59","v":"Price"},{"$f":"K59-$N71","v":7.5},{"$f":"L59-$N71","v":8},{"$f":"N14","v":8.5},{"$f":"L59+$N71","v":9},{"$f":"M59+$N71","v":9.5}]
[null,{"$f":"B43","v":"($/bu)"},"Silage Price ($/ton)",null,null,null,null,null,{"$f":"B60","v":"($/bu)"},"Silage Price ($/ton)"]
[null,{"$f":"B27","v":3},{"$f":"($G$4*$B61-($N$11+$N$15)-$G$4*C$59)/$G$16","v":19.771967455621301},19.563387573964498,19.354807692307691,19.146227810650888,18.937647928994082,null,{"$f":"I27","v":3},{"$f":"($G$4*$I61-($N$11+$N$15)-$G$4*$N$13+J$59*$G$16)/$G$16","v":26.854807692307691},27.354807692307688,27.854807692307691,28.354807692307695,28.854807692307691]
[null,3.25,21.510133136094673,21.30155325443787,21.092973372781064,20.884393491124261,20.675813609467454,null,3.25,28.592973372781064,29.09297337278106,29.592973372781064,30.092973372781067,30.592973372781064]
[null,3.5,23.248298816568045,23.039718934911242,22.831139053254436,22.622559171597633,22.413979289940826,null,3.5,30.331139053254436,30.831139053254432,31.331139053254436,31.831139053254439,32.331139053254439]
[null,3.75,24.986464497041418,24.777884615384615,24.569304733727808,24.360724852071005,24.152144970414199,null,3.75,32.069304733727812,32.569304733727805,33.069304733727812,33.569304733727812,34.069304733727812]
[null,4,26.72463017751479,26.516050295857987,26.30747041420118,26.098890532544377,25.890310650887571,null,4,33.807470414201184,34.307470414201177,34.807470414201184,35.307470414201184,35.807470414201184]
[null,4.25,28.462795857988162,28.254215976331359,28.045636094674553,27.83705621301775,27.628476331360943,null,4.25,35.545636094674556,36.045636094674549,36.545636094674556,37.045636094674556,37.545636094674556]
[null,4.5,30.200961538461534,29.992381656804731,29.783801775147925,29.575221893491122,29.366642011834315,null,4.5,37.283801775147928,37.783801775147921,38.283801775147928,38.783801775147928,39.283801775147928]
[null,4.75,31.939127218934907,31.730547337278104,31.521967455621297,31.313387573964494,31.104807692307688,null,4.75,39.021967455621301,39.521967455621294,40.021967455621301,40.521967455621301,41.021967455621301]
[null,5,33.677292899408279,33.468713017751476,33.260133136094673,33.051553254437863,32.84297337278106,null,5,40.760133136094673,41.260133136094666,41.760133136094673,42.260133136094673,42.760133136094673]
[null,5.25,35.415458579881651,35.206878698224848,34.998298816568045,34.789718934911235,34.581139053254432,null,5.25,42.498298816568045,42.998298816568038,43.498298816568045,43.998298816568045,44.498298816568045]
[null,"Increment for Harvesting and hauling charge, $/bu",null,null,null,null,0.03,null,"Increment for Harvesting and hauling charge, $/ton",null,null,null,null,0.5]
[]
[null,"Price of Corn Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Corn Silage when SELLER Pays for Harvesting Cost"]
[]
[null,{"$f":"B58","v":"Corn"},"Difference in preharvest VC, $/ac*",null,null,null,null,null,{"$f":"B75","v":"Corn"},"Difference in Preharvest VC/Acre"]
[null,{"$f":"B59","v":"Price"},{"$f":"D76-$G89","v":-24.8165425531915},{"$f":"E76-$G89","v":-19.8165425531915},{"$f":"+L11+N15","v":-14.8165425531915},{"$f":"E76+$G89","v":-9.8165425531914998},{"$f":"F76+$G89","v":-4.8165425531914998},null,{"$f":"B76","v":"Price"},{"$f":"C76","v":-24.8165425531915},{"$f":"D76","v":-19.8165425531915},{"$f":"E76","v":-14.8165425531915},{"$f":"F76","v":-9.8165425531914998},{"$f":"G76","v":-4.8165425531914998}]
[null,{"$f":"B60","v":"($/bu)"},"Silage Price ($/ton)",null,null,null,null,null,{"$f":"B77","v":"($/bu)"},"Silage Price ($/ton)"]
[null,{"$f":"B27","v":3},{"$f":"($G$4*$B78-C$76-$G$4*$N$13)/$G$16","v":19.062871935756551},18.864224429416737,18.665576923076923,18.466929416737109,18.268281910397295,null,{"$f":"I27","v":3},{"$f":"($G$4*$I78-J$76-$G$4*$N$13+$G$16*$N$14)/$G$16","v":27.562871935756551},27.364224429416737,27.165576923076923,26.966929416737109,26.768281910397292]
[null,3.25,20.801037616229923,20.602390109890109,20.403742603550295,20.205095097210481,20.006447590870668,null,3.25,29.301037616229923,29.102390109890109,28.903742603550295,28.705095097210481,28.506447590870668]
[null,3.5,22.539203296703295,22.340555790363481,22.141908284023668,21.943260777683854,21.74461327134404,null,3.5,31.039203296703295,30.840555790363481,30.641908284023668,30.443260777683854,30.24461327134404]
[null,3.75,24.277368977176668,24.078721470836854,23.88007396449704,23.681426458157226,23.482778951817412,null,3.75,32.777368977176664,32.578721470836854,32.380073964497036,32.181426458157226,31.982778951817412]
[null,4,26.01553465765004,25.816887151310226,25.618239644970412,25.419592138630598,25.220944632290784,null,4,34.515534657650036,34.316887151310226,34.118239644970409,33.919592138630598,33.720944632290781]
[null,4.25,27.753700338123412,27.555052831783598,27.356405325443784,27.157757819103971,26.959110312764157,null,4.25,36.253700338123409,36.055052831783598,35.856405325443781,35.657757819103971,35.459110312764153]
[null,4.5,29.491866018596784,29.293218512256971,29.094571005917157,28.895923499577343,28.697275993237529,null,4.5,37.991866018596781,37.793218512256971,37.594571005917153,37.395923499577343,37.197275993237525]
[null,4.75,31.230031699070157,31.031384192730343,30.832736686390529,30.634089180050715,30.435441673710901,null,4.75,39.730031699070153,39.531384192730343,39.332736686390525,39.134089180050715,38.935441673710898]
[null,5,32.968197379543533,32.769549873203715,32.570902366863898,32.372254860524087,32.17360735418427,null,5,41.468197379543525,41.269549873203708,41.070902366863898,40.87225486052408,40.67360735418427]
[null,5.25,34.706363060016905,34.507715553677087,34.309068047337277,34.11042054099746,33.911773034657642,null,5.25,43.206363060016898,43.00771555367708,42.80906804733727,42.610420540997453,42.411773034657642]
[null,"* Positve => higher cost for grain (includes phosphorus removal cost)",null,null,null,null,null,null,{"$f":"B88","v":"* Positve => higher cost for grain (includes phosphorus removal cost)"}]
[null,"Increment for Difference in preharvest VC, $/ac",null,null,null,null,5]

{"sheet":"Sorghum","index":2,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[4,8,4,9],[5,8,5,9],[6,8,6,9]]}
[]
[null,"Valuing Sorghum Silage"]
[]
[null,"Grain yield in bushels",null,null,null,null,90,null,"Nutrient removal",null,"N","P2O5","K2O"]
[null,"Moisture content of grain at harvest",null,null,null,null,0.14499999999999999,null,"Grain, lbs/bu",null,0.8,0.33,0.26]
[null,"Grain yield in pounds",null,null,null,null,{"$f":"G4*56","v":5040},null,"Silage, lbs/ton",null,11,3.2,8.6999999999999993]
[null,"Grain yield in pounds @ 100% DM",null,null,null,null,{"$f":"G6*(1-G5)","v":4309.2},null,"Grain, lbs/acre",null,{"$f":"$G4*K5","v":72},{"$f":"$G4*L5","v":29.700000000000003},{"$f":"$G4*M5","v":23.400000000000002}]
[null,null,null,null,null,null,null,null,"Silage, lbs/acre",null,{"$f":"$G16*K6","v":144.07659574468084},{"$f":"$G16*L6","v":41.913191489361708},{"$f":"$G16*M6","v":113.95148936170212}]
[null,"Percent grain in silage (DM)",null,null,null,null,0.47,null,"Price, $/lb",null,0.6,0.65,0.4]
[null,"Percent forage in silage (DM)",null,null,null,null,{"$f":"1-G9","v":0.53},null,"Percent to include",null,0,1,0]
[null,"Percent DM in silage at harvest",null,null,null,null,0.35,null,"Difference in cost, $/acre",null,{"$f":"(K7-K8)*K9*K10","v":0},{"$f":"(L7-L8)*L9*L10","v":-7.9385744680851085},{"$f":"(M7-M8)*M9*M10","v":0},{"$f":"SUM(K11:M11)","v":-7.9385744680851085}]
[]
[null,"Silage yield in pounds",null,null,null,null,{"$f":"G6/G9","v":10723.40425531915},null,"Harvest & hauling for grain, $/bu",null,null,null,null,0.4]
[null,"Silage yield in pounds @ 100% DM",null,null,null,null,{"$f":"G7/G9","v":9168.510638297872},null,"Harvest & hauling charge for silage, $/ton",null,null,null,null,8.5]
[null,"Silage yield in pounds as harvested",null,null,null,null,{"$f":"G14/G11","v":26195.744680851065},null,"Difference in grain preharvest non-fertilizer VC/acre",null,null,null,null,0]
[null,"Silage yield in tons as harvested",null,null,null,null,{"$f":"G15/2000","v":13.097872340425532}]
[null,"Bushels of Corn per ton of silage",null,null,null,null,{"$f":"G4/G16","v":6.871345029239766}]
[null,"Tons of silage per bushel of Corn",null,null,null,null,{"$f":"G16/G4","v":0.14553191489361703}]
[]
[null,""]
[]
[null,"Price of Sorghum Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Sorghum Silage when SELLER Pays for Harvesting Cost"]
[]
[null,"Sorghum",null,"  Percent DM in silage",null,null,"Factor",null,{"$f":"B24","v":"Sorghum"},null,"  Percent DM in silage",null,null,"Factor"]
[null,"Price",0.3,{"$f":"C25+$G37","v":0.32500000000000001},{"$f":"D25+$G37","v":0.35000000000000003},{"$f":"E25+$G37","v":0.37500000000000006},{"$f":"\"@ \"&FIXED(D25*100,1)&\"%\"","v":"@ 32.5%"},null,"Price",{"$f":"C25","v":0.3},{"$f":"D25","v":0.32500000000000001},{"$f":"E25","v":0.35000000000000003},{"$f":"F25","v":0.37500000000000006},{"$f":"\"@ \"&FIXED(K25*100,1)&\"%\"","v":"@ 32.5%"}]
[null,"($/bu)","Silage Price ($/ton)",null,null,null,"DM",null,"($/bu)","Silage Price ($/ton)",null,null,null,"DM"]
[null,2.5,{"$f":"($G$4*$B27-($N$11+$N$15)-$G$4*$N$13)/($G$14/C$25/2000)","v":12.887932330827068},13.961926691729325,15.035921052631581,16.109915413533837,{"$f":"D27/B27","v":5.58477067669173},null,2.5,{"$f":"($G$4*$I27-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$14/J$25/2000)/($G$14/J$25/2000)","v":21.38793233082707},22.461926691729328,23.535921052631583,24.609915413533841,{"$f":"K27/I27","v":8.9847706766917312}]
[null,{"$f":"B27+N$37","v":2.75},14.360363408521305,15.557060359231414,16.753757309941523,17.950454260651632,5.6571128579023329,null,2.75,22.860363408521305,24.057060359231414,25.253757309941523,26.450454260651636,8.7480219488114237]
[null,3,15.832794486215541,17.152194026733504,18.471593567251464,19.790993107769427,5.717398008911168,null,3,24.332794486215541,25.652194026733504,26.971593567251464,28.290993107769431,8.5507313422445019]
[null,3.25,17.305225563909776,18.74732769423559,20.189429824561405,21.631531954887222,5.7684085213032583,null,3.25,25.805225563909776,27.247327694235594,28.689429824561408,30.131531954887226,8.3837931366878742]
[null,3.5,18.777656641604011,20.34246136173768,21.907266081871349,23.472070802005017,5.8121318176393375,null,3.5,27.277656641604011,28.84246136173768,30.407266081871349,31.972070802005021,8.2407032462107654]
[null,3.75,20.250087719298246,21.93759502923977,23.625102339181289,25.312609649122813,5.8500253411306051,null,3.75,28.750087719298246,30.43759502923977,32.125102339181289,33.812609649122813,8.1166920077972726]
[null,4,21.722518796992482,23.532728696741856,25.34293859649123,27.153148496240608,5.883182174185464,null,4,30.222518796992482,32.032728696741856,33.84293859649123,35.653148496240611,8.008182174185464]
[null,4.25,23.194949874686717,25.127862364243946,27.060774853801174,28.993687343358403,5.9124382033515168,null,4.25,31.694949874686721,33.627862364243946,35.560774853801171,37.493687343358403,7.9124382033515168]
[null,4.5,24.667380952380956,26.722996031746035,28.778611111111115,30.834226190476198,5.9384435626102299,null,4.5,33.167380952380952,35.222996031746035,37.278611111111118,39.334226190476201,7.8273324514991192]
[null,4.75,26.139812030075191,28.318129699248125,30.496447368421055,32.674765037593993,5.9617115156311842,null,4.75,34.639812030075191,36.818129699248125,38.996447368421059,41.174765037593993,7.7511851998417107]
[null,"Increment for Percent DM in silage",null,null,null,null,2.5000000000000001E-2,null,"Increment for Sorghum Price ($/bu)",null,null,null,null,0.25]
[]
[null,"Price of Sorghum Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Sorghum Silage when SELLER Pays for Harvesting Cost"]
[]
[null,{"$f":"B24","v":"Sorghum"},null,"Percent grain (DM) in silage",null,null,null,null,{"$f":"B41","v":"Sorghum"},null,"Percent grain (DM) in silage"]
[null,"Price",{"$f":"D42-$G54","v":0.41999999999999993},{"$f":"E42-$G54","v":0.44499999999999995},{"$f":"G9","v":0.47},{"$f":"E42+G54","v":0.495},{"$f":"F42+G54","v":0.52},null,{"$f":"B42","v":"Price"},{"$f":"C42","v":0.41999999999999993},{"$f":"D42","v":0.44499999999999995},{"$f":"E42","v":0.47},{"$f":"F42","v":0.495},{"$f":"G42","v":0.52}]
[null,"($/bu)","Silage Price ($/ton)",null,null,null,null,null,{"$f":"B43","v":"($/bu)"},"Silage Price ($/ton)"]
[null,2.5,{"$f":"($G$4*$B44-($N$11+$N$15)-$G$4*$N$13)/($G$7/C$42/$G$11/2000)","v":13.436354983202685},14.236138017917133,15.035921052631579,15.835704087346024,16.635487122060468,null,{"$f":"I27","v":2.5},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/C$42/$G$11/2000)/($G$7/J$42/$G$11/2000)","v":21.936354983202683},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/D$42/$G$11/2000)/($G$7/K$42/$G$11/2000)","v":22.736138017917135},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/E$42/$G$11/2000)/($G$7/L$42/$G$11/2000)","v":23.535921052631583},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/F$42/$G$11/2000)/($G$7/M$42/$G$11/2000)","v":24.335704087346027},{"$f":"($G$4*$I44-($N$11+$N$15)-$G$4*$N$13+$N$14*$G$7/G$42/$G$11/2000)/($G$7/N$42/$G$11/2000)","v":25.135487122060468}]
[null,2.75,14.97144270250093,15.862600006221227,16.75375730994152,17.644914613661811,18.536071917382106,null,2.75,23.47144270250093,24.362600006221228,25.253757309941523,26.144914613661815,27.036071917382102]
[null,3,16.506530421799177,17.489061994525319,18.47159356725146,19.454125139977602,20.436656712703744,null,3,25.006530421799173,25.989061994525322,26.971593567251464,27.954125139977606,28.936656712703741]
[null,3.25,18.04161814109742,19.115523982829412,20.189429824561405,21.26333566629339,22.337241508025382,null,3.25,26.54161814109742,27.615523982829416,28.689429824561408,29.763335666293393,30.837241508025379]
[null,3.5,19.576705860395666,20.741985971133506,21.907266081871345,23.072546192609181,24.23782630334702,null,3.5,28.076705860395666,29.241985971133509,30.407266081871349,31.572546192609185,32.737826303347013]
[null,3.75,21.111793579693913,22.368447959437599,23.625102339181286,24.881756718924969,26.138411098668655,null,3.75,29.611793579693909,30.868447959437603,32.125102339181289,33.381756718924976,34.638411098668655]
[null,4,22.646881298992156,23.994909947741693,25.342938596491226,26.69096724524076,28.038995893990293,null,4,31.146881298992156,32.494909947741696,33.84293859649123,35.190967245240763,36.53899589399029]
[null,4.25,24.181969018290403,25.621371936045787,27.060774853801171,28.500177771556547,29.939580689311931,null,4.25,32.681969018290403,34.12137193604579,35.560774853801171,37.000177771556551,38.439580689311931]
[null,4.5,25.717056737588646,27.24783392434988,28.778611111111111,30.309388297872339,31.84016548463357,null,4.5,34.217056737588649,35.747833924349884,37.278611111111111,38.809388297872339,40.340165484633566]
[null,4.75,27.252144456886892,28.874295912653974,30.496447368421052,32.118598824188126,33.740750279955208,null,4.75,35.752144456886889,37.374295912653977,38.996447368421059,40.618598824188126,42.240750279955201]
[null,"Increment for Pecent grain (DM) in silage",null,null,null,null,{"$f":"G37","v":2.5000000000000001E-2}]
[]
[null,"Price of Sorghum Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Sorghum Silage when SELLER Pays for Harvesting Cost"]
[]
[null,{"$f":"B41","v":"Sorghum"},"  Harvest and hauling charge, $/bu",null,null,null,null,null,{"$f":"B58","v":"Sorghum"},"Harvest and hauling charge, $/ton"]
[null,{"$f":"B42","v":"Price"},{"$f":"D59-$G71","v":0.33999999999999997},{"$f":"E59-$G71","v":0.37},{"$f":"N13","v":0.4},{"$f":"E59+$G71","v":0.43000000000000005},{"$f":"F59+$G71","v":0.46000000000000008},null,{"$f":"B59","v":"Price"},{"$f":"K59-$N71","v":7.5},{"$f":"L59-$N71","v":8},{"$f":"N14","v":8.5},{"$f":"L59+$N71","v":9},{"$f":"M59+$N71","v":9.5}]
[null,{"$f":"B43","v":"($/bu)"},"Silage Price ($/ton)",null,null,null,null,null,{"$f":"B60","v":"($/bu)"},"Silage Price ($/ton)"]
[null,{"$f":"B27","v":2.5},{"$f":"($G$4*$B61-($N$11+$N$15)-$G$4*C$59)/$G$16","v":15.448201754385966},15.242061403508771,15.035921052631579,14.829780701754387,14.623640350877192,null,{"$f":"I27","v":2.5},{"$f":"($G$4*$I61-($N$11+$N$15)-$G$4*$N$13+J$59*$G$16)/$G$16","v":22.535921052631579},23.035921052631579,23.535921052631579,24.035921052631583,24.535921052631579]
[null,2.75,17.166038011695907,16.959897660818712,16.75375730994152,16.547616959064328,16.341476608187133,null,2.75,24.25375730994152,24.75375730994152,25.25375730994152,25.753757309941523,26.253757309941523]
[null,3,18.883874269005847,18.677733918128656,18.47159356725146,18.265453216374269,18.059312865497077,null,3,25.971593567251464,26.47159356725146,26.97159356725146,27.471593567251464,27.971593567251464]
[null,3.25,20.601710526315788,20.395570175438596,20.189429824561405,19.983289473684213,19.777149122807021,null,3.25,27.689429824561405,28.189429824561405,28.689429824561401,29.189429824561405,29.689429824561405]
[null,3.5,22.319546783625729,22.113406432748537,21.907266081871345,21.701125730994153,21.494985380116962,null,3.5,29.407266081871345,29.907266081871345,30.407266081871345,30.907266081871349,31.407266081871349]
[null,3.75,24.037383040935669,23.831242690058478,23.625102339181286,23.418961988304094,23.212821637426902,null,3.75,31.125102339181286,31.625102339181286,32.125102339181289,32.625102339181289,33.125102339181289]
[null,4,25.755219298245613,25.549078947368422,25.342938596491226,25.136798245614035,24.930657894736843,null,4,32.84293859649123,33.34293859649123,33.84293859649123,34.34293859649123,34.84293859649123]
[null,4.25,27.473055555555554,27.266915204678362,27.060774853801171,26.854634502923979,26.648494152046787,null,4.25,34.560774853801171,35.060774853801171,35.560774853801171,36.060774853801171,36.560774853801171]
[null,4.5,29.190891812865495,28.984751461988303,28.778611111111111,28.572470760233919,28.366330409356728,null,4.5,36.278611111111111,36.778611111111111,37.278611111111111,37.778611111111111,38.278611111111111]
[null,4.75,30.908728070175435,30.702587719298243,30.496447368421052,30.29030701754386,30.084166666666668,null,4.75,37.996447368421052,38.496447368421052,38.996447368421052,39.496447368421059,39.996447368421052]
[null,"Increment for Harvesting and hauling charge, $/bu",null,null,null,null,0.03,null,"Increment for Harvesting and hauling charge, $/ton",null,null,null,null,0.5]
[]
[null,"Price of Sorghum Silage when BUYER Pays for Harvesting Cost",null,null,null,null,null,null,"Price of Sorghum Silage when SELLER Pays for Harvesting Cost"]
[]
[null,{"$f":"B58","v":"Sorghum"},"Difference in preharvest VC, $/ac*",null,null,null,null,null,{"$f":"B75","v":"Sorghum"},"Difference in Preharvest VC/Acre"]
[null,{"$f":"B59","v":"Price"},{"$f":"D76-$G89","v":-17.938574468085108},{"$f":"E76-$G89","v":-12.938574468085108},{"$f":"+L11+N15","v":-7.9385744680851085},{"$f":"E76+$G89","v":-2.9385744680851085},{"$f":"F76+$G89","v":2.0614255319148915},null,{"$f":"B76","v":"Price"},{"$f":"C76","v":-17.938574468085108},{"$f":"D76","v":-12.938574468085108},{"$f":"E76","v":-7.9385744680851085},{"$f":"F76","v":-2.9385744680851085},{"$f":"G76","v":2.0614255319148915}]
[null,{"$f":"B60","v":"($/bu)"},"Silage Price ($/ton)",null,null,null,null,null,{"$f":"B77","v":"($/bu)"},"Silage Price ($/ton)"]
[null,{"$f":"B27","v":2.5},{"$f":"($G$4*$B78-C$76-$G$4*$N$13)/$G$16","v":15.79940383365822},15.417662443144899,15.035921052631579,14.654179662118258,14.272438271604939,null,{"$f":"I27","v":2.5},{"$f":"($G$4*$I78-J$76-$G$4*$N$13+$G$16*$N$14)/$G$16","v":24.299403833658218},23.917662443144899,23.535921052631579,23.154179662118256,22.772438271604937]
[null,2.75,17.517240090968162,17.135498700454839,16.75375730994152,16.3720159194282,15.990274528914879,null,2.75,26.017240090968162,25.635498700454839,25.25375730994152,24.8720159194282,24.490274528914878]
[null,3,19.235076348278103,18.853334957764783,18.47159356725146,18.089852176738141,17.708110786224822,null,3,27.735076348278103,27.353334957764783,26.97159356725146,26.589852176738141,26.208110786224822]
[null,3.25,20.952912605588043,20.571171215074724,20.189429824561405,19.807688434048082,19.425947043534762,null,3.25,29.452912605588043,29.071171215074724,28.689429824561401,28.307688434048082,27.925947043534762]
[null,3.5,22.670748862897987,22.289007472384665,21.907266081871345,21.525524691358026,21.143783300844703,null,3.5,31.170748862897984,30.789007472384665,30.407266081871345,30.025524691358022,29.643783300844703]
[null,3.75,24.388585120207928,24.006843729694609,23.625102339181286,23.243360948667966,22.861619558154647,null,3.75,32.888585120207928,32.506843729694609,32.125102339181289,31.743360948667966,31.361619558154644]
[null,4,26.106421377517869,25.724679987004549,25.342938596491226,24.961197205977907,24.579455815464588,null,4,34.606421377517869,34.224679987004549,33.84293859649123,33.461197205977903,33.079455815464584]
[null,4.25,27.824257634827809,27.44251624431449,27.060774853801171,26.679033463287848,26.297292072774528,null,4.25,36.324257634827809,35.94251624431449,35.560774853801171,35.179033463287851,34.797292072774525]
[null,4.5,29.542093892137753,29.16035250162443,28.778611111111111,28.396869720597792,28.015128330084469,null,4.5,38.04209389213775,37.66035250162443,37.278611111111111,36.896869720597792,36.515128330084472]
[null,4.75,31.259930149447694,30.878188758934375,30.496447368421052,30.114705977907732,29.732964587394413,null,4.75,39.759930149447698,39.378188758934378,38.996447368421052,38.614705977907732,38.232964587394413]
[null,"* Positve => higher cost for grain (includes phosphorus removal cost)",null,null,null,null,null,null,{"$f":"B88","v":"* Positve => higher cost for grain (includes phosphorus removal cost)"}]
[null,"Increment for Difference in preharvest VC, $/ac",null,null,null,null,5]