{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Corn Silage Pricing","Base Pricing Formula","Moisture Adjustment","Estimating Corn Silage Yield"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Corn Silage Pricing","index":1,"n_rows":1102,"n_cols":12,"rows_kept":1102,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"(         )"]
[null,null,null,null,null,"(         )"]
[]
[null,"Yield and Grain Price"]
[null,"Grain Yield Bushels/Acre",null,null,200]
[null,"Silage % DM",null,null,0.35]
[null,"Estimated Silage Yield (as fed)",null,null,{"$f":"L94","v":29.29141781656914}]
[]
[null,"Corn Silage Yield (Tons Acre As Fed Basis) ",null,null,29,"*Users must enter a value here"]
[]
[null,"Prices & Adjustments ",null,null,"Seller","Buyer"]
[null,"Local Cash Grain Price (15.5% moisture)",null,null,4.3499999999999996,4.45]
[null,"Corn Grain Discount $/bushel ",null,null,0]
[null,"Local Market Price per ton for low protein forage to Buyer ",null,null,null,100]
[null,"Average grain loss for harvest before black layer (Bu./Acre) ",null,null,null,{"$f":"E6*0.09","v":18}]
[null,"     Override average loss for harvest before black layer",null,null,null,null,{"$f":"IF(F17=\"\",F16,F17)","v":18}]
[null,"Gross Value/Acre",null,null,{"$f":"(E6*E13)-(E6*E14)","v":869.99999999999989},{"$f":"((E6-G17)*F13)+F15*(((E10*E7/0.9)/2))","v":1373.7888888888888}]
[]
[null,"Nutrient Removal"]
[]
[]
[]
[null,null,null,null,"P2O5","K2O"]
[null,null,null,"Price per lb",0.6,0.6]
[null,null,null,null,"Grain","Silage"]
[null,null,null,"Yield",{"$f":"E6","v":200},{"$f":"E10","v":29}]
[null,null,null,"P205 lb/bu or ton",0.38,3.6]
[null,null,null,"K20 lb/bu or ton",0.28999999999999998,8.3000000000000007]
[null,null,null,"P205 $/acre",{"$f":"E27*E28*E25","v":45.6},{"$f":"F27*F28*E25","v":62.64}]
[null,null,null,"K20 $/acre",{"$f":"E27*E29*F25","v":34.799999999999997},{"$f":"F27*F29*F25","v":144.42000000000002}]
[null,null,null,"Nutrient cost $/acre",{"$f":"E31+E30","v":80.400000000000006},{"$f":"F31+F30","v":207.06}]
[null,null,null,"$ Differnece  Silage vs. Grain",null,{"$f":"F32-E32","v":126.66}]
[null,"Harvest Costs"]
[]
[null,"Grain Harvest (use actual, or refer to Custom Rate Guide for estimates)"]
[null,null,null,null,"Per Bushel","Per Acre"]
[null,"Combining Cost",null,null,{"$f":"F38/E6","v":0.16625000000000001},33.25]
[null,"Trucking Cost",null,null,0.05,{"$f":"E39*E6","v":10}]
[null,"Drying Cost",null,null,0.1,{"$f":"E40*E6","v":20}]
[null,"Storage Cost"]
[null,"     $/Bushel/month",null,null,0.03,{"$f":"E42*E43*E6","v":36}]
[null,"     Storage Length (months)",null,null,6]
[null,"% Grain Harvest and Storage Loss ",null,null,null,{"$f":"E18*D44","v":0}]
[null,"Grain Harvest Cost",null,null,null,{"$f":"SUM(F38:F44)","v":99.25}]
[]
[null,"Silage Harvest Costs (use actual, or refer to Custom Rate Guides for estimates)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Chopping , Hauling, and Filling  $/Acre",null,null,null,180]
[null,"Storage Loss %",null,null,null,0.11]
[null,"Storage Loss ($/acre)",null,null,null,{"$f":"(F18*F64)","v":151.11677777777777}]
[null,"Harvest Costs Charged to Seller or Buyer",null,null,"Seller","Buyer "]
[null,"Silage Harvest $/Acre",null,null,{"$f":"IF(I102=0,F63,\"\")","v":""},{"$f":"IF(I102=1,F63,\"\")","v":180}]
[null,"Harvest and Storage Loss   ",null,null,{"$f":"IF(I104=0,F65,\"\")","v":""},{"$f":"IF(I104=1,F65,\"\")","v":151.11677777777777}]
[null,"Toal Silage Harvest & Storage Cost ",null,null,{"$f":"SUM(E67:E68)","v":0},{"$f":"SUM(F67:F68)","v":331.11677777777777}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Price Comparison (range to negotiate) "]
[null,"Seller"]
[null,"Minimum Value/Acre Corn Silage to Seller ",null,null,null,{"$f":"E18-F45+E69+F33","v":897.40999999999985}]
[null,"Value of Standing Corn Silage to Seller ($/ton wet basis)",null,null,null,{"$f":"F80/E10","v":30.945172413793099}]
[null,"Value of Corn Silage to Seller ($/ton DM)",null,null,null,{"$f":"F81/E7","v":88.414778325123152}]
[null,"Buyer"]
[null,"Maximum Value/Acre Corn Silage to Buyer ",null,null,null,{"$f":"F18-F69","v":1042.672111111111}]
[null,"Value of Standing Corn Silage ($/ton wet basis) ",null,null,null,{"$f":"F84/E10","v":35.954210727969347}]
[null,"Value of Standing Corn for Silage ($/ton DM)",null,null,null,{"$f":"F85/E7","v":102.72631636562672}]
[]
[]
[null,null,null,null,null,null,null,25.548999999999999,{"$f":"-66.7+41.7*(H89)-1.53*(H89*H89)","v":-1.6343530000085593E-2}]
[null,null,null,null,null,null,null,-66.7,{"$f":"'Corn Silage Pricing'!$E$6","v":200}]
[null,null,null,null,null,null,null,{"$f":"H90-I90","v":-266.7},"c"]
[null,null,null,null,null,null,null,41.7,"b"]
[null,null,null,null,null,null,null,-1.53,"a","Tons DM","% DM","Tons As Fed"]
[null,null,null,null,null,null,null,null,null,{"$f":"(-H92+SQRT(POWER(41.7,2)-4*H93*H91))/(2*H93)","v":10.251996235799199},{"$f":"'Corn Silage Pricing'!$E$7","v":0.35},{"$f":"J94/K94","v":29.29141781656914}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,true,{"$f":"1*H102","v":1}]
[null,null,null,null,null,null,null,false,{"$f":"1*H103","v":0}]
[null,null,null,null,null,null,null,true,{"$f":"1*H104","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,true]
[null,true]
[null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,true]

{"sheet":"Base Pricing Formula","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To use, enter a cash grain price and pricing factor into the yellow cells (B16 and D16)",null,null,null,null,null,null,null,null,"(        )"]
[]
[]
[null,"Corn Price",null,"Pricing ",null,"Dollars"]
[null,"$/bu.",null,"Factor",null,"per ton as fed"]
[null,4.3,"X",9,"=",{"$f":"B16*D16","v":38.699999999999996}]

{"sheet":"Moisture Adjustment","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,2,9,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,"To use, enter your base price in the yellow cell (F11)",null,null,null,null,"(        )"]
[]
[null,null,"Base Price  ($/ton as fed) at 65% Moisture"]
[null,"% Moisture",{"$f":"F11-12","v":26},{"$f":"F11-8","v":30},{"$f":"F11-4","v":34},38,{"$f":"F11+4","v":42},{"$f":"F11+8","v":46},{"$f":"F11+12","v":50}]
[null,0.71,{"$f":"(C11/0.35)*0.29","v":21.542857142857144},24.857142857142858,28.171428571428571,31.485714285714288,34.800000000000004,38.114285714285714,41.428571428571423]
[null,0.69,{"$f":"(C11/0.35)*0.31","v":23.028571428571432},26.571428571428573,30.114285714285717,33.657142857142858,37.200000000000003,40.742857142857147,44.285714285714285]
[null,0.67,{"$f":"(C11/0.35)*0.33","v":24.514285714285716},28.285714285714288,32.057142857142864,35.828571428571436,39.600000000000009,43.371428571428581,47.142857142857146]
[null,0.65,{"$f":"C11","v":26},30,34,38,42,46,50]
[null,0.63,{"$f":"(C11/0.35)*0.37","v":27.485714285714288},31.714285714285715,35.942857142857143,40.171428571428578,44.400000000000006,48.628571428571433,52.857142857142861]
[null,0.61,{"$f":"(C11/0.35)*0.39","v":28.971428571428575},33.428571428571431,37.885714285714293,42.342857142857149,46.800000000000004,51.257142857142867,55.714285714285715]
[null,0.59,{"$f":"(C11/0.35)*0.41","v":30.457142857142859},35.142857142857146,39.828571428571429,44.51428571428572,49.2,53.885714285714286,58.571428571428569]

{"sheet":"Estimating Corn Silage Yield","index":4,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Row Length (ft)","Row Width"]
[null,34.9,"15”"]
[null,26.1,"20”"]
[null,23.8,"22”"]
[null,17.399999999999999,"30”"]
[null,14.5,"36”"]
[null,13.8,"38”"]
[null,13.1,"40”"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"$ / Acre","$ / Hour","$ / Ton"]
[null,"Chop Only",165.71,481.8,5.57]
[null,"Chop/Haul/Fill ","N/A",629.45000000000005,9]
[null,"Bagging","N/A","N/A",5.18]
[null,"Blower","N/A",30.5,"N/A"]
[]
[null,"https://www.nass.usda.gov/Statistics_by_State/Wisconsin/Publications/WI-CRate20.pdf "]