{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Volume","Drawings","Packing","Investment","Costs"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":4,"comments":4,"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":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[27,1,27,4],[4,1,5,9],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[49,1,49,10],[28,1,30,11],[32,1,33,11],[34,1,36,11],[40,1,40,4],[41,1,42,11],[47,6,47,8]]}
[]
[]
[null,"KSU-Economics of Silage Storage Alternatives"]
[]
[null,"A spreadsheet to evaluate the storage capacity requirements and the economic costs associated with storing silage in bunkers, piles, or plastic bags"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 3.1.2014"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly.  This spreadsheet uses macros to print the three different pages, however printing can also be done manually by highlighting the desired range and using the menu print commands. "]
[]
[]
[]
[null,"In the Volume, Packing, Invesment, and Economics tabs all blue numbers are inputs and all black numbers are calculated from these inputs."]
[]
[null,"The input cells (i.e., blue number) have a red diamond in the upper right hand corner of the cell.  By moving your mouse cursor over this diamond, a brief description of the input will be displayed on the screen.  The Bunker diagram tab is included to help visualize what different inputs in Volume tab refer to."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"See accompanying publication: ",null,null,null,"Here"]
[null,"Developed by:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Volume","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Assumptions for Various Silage Storage Systems"]
[]
[null,"General Dairy Information",null,null,null,"Silage Bags"]
[null,null,"Herd size, cows",3000,null,null,"Silage density as fed (AF), lbs/cu ft",30]
[null,null,"Silage in ration, AF lbs/cow/day",45,null,null,"Silage density dry matter (DM), lbs/cu ft",{"$f":"H5*(1-$D$7)","v":9.5999999999999979}]
[null,null,"Silage moisture content, %",0.68,null,null,"Estimate of storage DM loss, %",0.08]
[null,null,null,null,null,null,"Estimate of feedout DM loss, %",0.03]
[null,null,"Daily silage fed, tons AF",{"$f":"D5*D6/2000","v":67.5},null,null,"Diameter, ft",12]
[null,null,"Daily silage fed, tons DM",{"$f":"D9*(1-D7)","v":21.599999999999998},null,null,"Length of bag, ft",300]
[null,null,"Annual silage fed, tons AF",{"$f":"D9*365","v":24637.5},null,null,"Length of bag for sealing, ft",{"$f":"H9*2","v":24}]
[null,null,"Annual silage fed, tons DM",{"$f":"D10*365","v":7883.9999999999991},null,null,"Distance between bags, ft",5]
[null,null,null,null,null,null,"Buffer distance at end of bag, ft",10]
[null,null,"Maximum feed days/storage unit",122,null,null,"Cross-sectional area, sq ft",{"$f":"PI()*(H9/2)^2","v":113.09733552923255}]
[null,null,"Maximum tons/storage unit, AF",{"$f":"D14*D6*D5/2000","v":8235},null,null,"Total volume/bag, tons AF",{"$f":"PI()*(H9/2)^2*(H10-H11)*H5/2000","v":468.22296909102278}]
[null,null,"Maximum tons/storage unit, DM",{"$f":"D15*(1-D7)","v":2635.2},null,null,"Total volume/bag, tons DM",{"$f":"H15*(1-D7)","v":149.83135010912727}]
[null,null,null,null,null,null,"Daily face removal, ft",{"$f":"D9*2000/H5/(PI()*(H9/2)^2)","v":39.788735772973837}]
[null,null,null,null,null,null,"Days of silage/bag",{"$f":"(H10-H11)/H17","v":6.9366365791262625}]
[null,null,null,null,null,null,"Total bags needed",{"$f":"CEILING(D11/H15/(1-H7-H8),1)","v":60}]
[null,null,null,null,null,null,"Size of footprint for bags, acres",{"$f":"(H10-H11+H13*2)*(H19*H9+(H19+1)*H12)/43560","v":6.9651056014692374}]
[]
[null,"Bunker Silo",null,null,null,"Drive Over Pile"]
[null,null,"Silage density as fed (AF), lbs/cu ft",40,null,null,"Silage density as fed (AF), lbs/cu ft",40]
[null,null,"Silage density dry matter (DM), lbs/cu ft",{"$f":"D23*(1-$D$7)","v":12.799999999999997},null,null,"Silage density dry matter (DM), lbs/cu ft",{"$f":"H23*(1-$D$7)","v":12.799999999999997}]
[null,null,"Estimate of storage DM loss, %",0.17,null,null,"Estimate of storage DM loss, %",0.18]
[null,null,"Estimate of feedout DM loss, %",0.03,null,null,"Estimate of feedout DM loss, %",0.04]
[null,null,"Bunker height, ft",15,null,null,"Maximum height, ft",18]
[null,null,"Maximum depth above wall, ft",4,null,null,"Side slope (feet of run/foot of rise)",3.5]
[null,null,"Bunker width at base, ft",120,null,null,"Length of plastic, ft",200]
[null,null,"Horizontal distance from top of pile to wall, ft",4,{"$f":"IF(D30<=D29,\"\",\"Needs to be less than width at base!\")","v":""},null,"Allowance for sealing, ft",10]
[null,null,"Sidewall slope (feet of run/foot of rise)",0.125,null,null,"Buffer distance around pile, ft",10]
[null,null,"Bunker width at top of wall, ft",{"$f":"D27*D31*2+D29","v":123.75},null,null,"Length of side slopes, ft",{"$f":"SQRT(H27^2+H34^2)","v":65.520989003524662}]
[null,null,"Width across top, ft",{"$f":"D32-D30*2","v":115.75},null,null,"Level width across top, ft",{"$f":"H29-H30-2*H32","v":58.958021992950677}]
[null,null,"Buffer distance on sides of bunker, ft",10,null,null,"Width at bottom side, ft",{"$f":"H27*H28","v":63}]
[null,null,"Running feet of apron(s)",40,null,null,"Total width at bottom, ft",{"$f":"2*H34+H33","v":184.95802199295068}]
[null,null,"Cross-sectional area, sq ft",{"$f":"(D29*D27)+((D32-D29)/2*D27)+(D33*D28)+((D32-D33)/2*D28)","v":2307.125},null,null,"Cross-sectional area, sq ft",{"$f":"(H33+H34)*H27","v":2195.2443958731124}]
[null,null,"Tons per linear foot, tons AF",{"$f":"D36*D23/2000","v":46.142499999999998},null,null,"Tons per linear foot, tons AF",{"$f":"H36*H23/2000","v":43.904887917462247}]
[null,null,"Daily face removal, inches",{"$f":"$D$9*2000/D23*12/D36","v":17.554315435877985},null,null,"Daily face removal, inches",{"$f":"$D$9*2000/H23*12/H36","v":18.448970910089479}]
[null,null,"Length for feed required, ft",{"$f":"D38*$D14/12","v":178.46887359809284},null,null,"Length for feed required, ft",{"$f":"H38*$D14/12","v":187.56453758590968}]
[null,null,"Size of footprint, acres/pile",{"$f":"(D29+D34*2)*(D39+D35)/43560","v":0.70214973149065651},null,null,"Size of footprint, acres/pile",{"$f":"(H35+H31*2)*(H39+H31*2)/43560","v":0.97663032735283539}]
[null,null,"Tons in the pile, tons AF",{"$f":"D37*D39","v":8234.9999999999982},null,null,"Tons in the pile, tons AF",{"$f":"H37*H39","v":8235}]
[null,null,"Square feet of plastic/pile, sq ft",{"$f":"(D33+(SQRT(D28^2+D30^2)+H30*2))*(D39+H30*2)","v":28064.859081946437},null,null,"Square feet of plastic/pile, sq ft",{"$f":"H29*(H39+H30*2)","v":41512.907517181935}]
[null,null,"Number of bunkers needed",{"$f":"($D11/D41)/(1-D25-D26)","v":3.7397540983606565},null,null,"Number of piles needed",{"$f":"($D11/H41)/(1-H25-H26)","v":3.8356452290878522}]
[null,null,"Total footprint for piles, acres",{"$f":"D40*D43","v":2.6258673360050171},null,null,"Total footprint for piles, acres",{"$f":"H40*H43","v":3.7460074556934102}]

{"sheet":"Drawings","index":2,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Schematic depicting measurements for bunker silo (cell address in Volume tab)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Schematic depicting measurements for drive-over pile (cell address in Volume tab)"]

{"sheet":"Packing","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,15,4],[1,1,1,4]]}
[]
[null,"Estimating Packing Costs per Ton (AF) of Silage in Bunker or Pile"]
[]
[null,null,"Silage delivery rate to bunker or pile, tons/hour",150]
[null,null,"Hours to fill bunker or pile (based on information in Volume tab)",{"$f":"Volume!D15/D4","v":54.9}]
[null,null,"Tractor packing hours per silage delivery hour*",3]
[null,null,"Tractor cost per hour (depreciation, interests, repairs)",34.5]
[null,null,"Fuel consumption per tractor-hour, gal/hr",5.5]
[null,null,"Fuel price, $/gal",1.5]
[null,null,"Labor cost, $/hr",12]
[null,null,"Estimated packing cost per tractor-hour",{"$f":"D7+D8*D9+D10","v":54.75}]
[null,null,"Estimated cost per ton (AF) for packing",{"$f":"D6*(D7+D8*D9+D10)/D4","v":1.095}]
[]
[null,"* It is assumed that packing tractor hours entered are sufficient to ensure sufficient packing for proper density (see Bunker Silo Density Calculator.xls by Holmes and Muck, available at http://www.uwex.edu/ces/crops/uwforage/ for information regarding tractor weights and hours of packing and its impact on silage pack density)."]

{"sheet":"Investment","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Investment per Ton (AF) of Storage Capacity by System"]
[]
[null,null,null,"Silage Storage System"]
[null,null,null,"Bunker silo","Drive over pile","Plastic bags"]
[null,null,"Size of footprint required, square feet",{"$f":"Volume!D44*43560","v":114382.78115637855},{"$f":"Volume!H44*43560","v":163176.08477000493},{"$f":"Volume!H20*43560","v":303400}]
[null,null,"Cost of floor/base (i.e., land leveling, excavating, rock, etc.), $/sq ft",1.8,0.9,0.9]
[null,"A.","Total investment for floor",{"$f":"D6*D7","v":205889.00608148141},{"$f":"E6*E7","v":146858.47629300444},{"$f":"F6*F7","v":273060}]
[null,null,"Endwall in bunker (Yes=1, No=0)",1,"--------- ","--------- "]
[null,null,"Total running feet of walls for bunker",{"$f":"(Volume!D39*2+Volume!D29)*Volume!D43*Investment!D9","v":1783.6298947398341},"--------- ","--------- "]
[null,null,"Cost of walls and footings, etc., $/running foot",150,null,"--------- "]
[null,"B.","Total investment for walls",{"$f":"D10*D11","v":267544.48421097512},null,"--------- "]
[null,null,"Surface area to be covered, square feet",{"$f":"((Volume!D33+SQRT(Volume!D28^2+Volume!D30^2))*Volume!D39)*Volume!D43","v":81030.540487941398},{"$f":"Volume!H29*Volume!H39*Volume!H43","v":143886.20474749271},"--------- "]
[null,null,"Tires (weights) per 100 square feet",20,{"$f":"D14","v":20},"--------- "]
[null,null,"Total tires (weights) required",{"$f":"D13/100*D14","v":16206.10809758828},{"$f":"E13/100*E14","v":28777.24094949854},"--------- "]
[null,null,"Cost per tire (weight), $/unit",1.5,1.5,"--------- "]
[null,"C.","Total investment for weights",{"$f":"D15*D16","v":24309.162146382419},{"$f":"E15*E16","v":43165.861424247807},"--------- "]
[null,"D.","Other investment, total $",20000,20000,20000]
[null,"TOTAL INVESTMENT (A+B+C+D)",null,{"$f":"+D8+D12+D17+D18","v":517742.65243883897},{"$f":"+E8+E12+E17+E18","v":210024.33771725226},{"$f":"+F8+F18","v":293060}]
[null,"TOTAL INVESMENT PER TON (AF) OF STORAGE CAPACITY",null,{"$f":"D19/Volume!$D11","v":21.014415116746381},{"$f":"E19/Volume!$D11","v":8.5245799174937495},{"$f":"F19/Volume!$D11","v":11.894875697615424}]

{"sheet":"Costs","index":5,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,2,35,4],[36,2,36,4],[37,2,37,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[26,2,26,4],[28,2,28,4],[19,2,19,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[25,2,25,4],[1,1,1,8],[16,2,16,4],[17,2,17,4],[18,2,18,4],[24,2,24,4]]}
[]
[null,"Economic Comparisons of Alternative Silage Storage Systems"]
[]
[null,"General inputs"]
[null,null,"Interest rate, %",0.1]
[null,null,"Value of land, $/acre",1000,null,{"$f":"Volume!C5","v":"Herd size, cows"},null,{"$f":"Volume!D5","v":3000}]
[null,null,"Cost of plastic, $/sq ft",0.03,null,{"$f":"Volume!C6","v":"Silage in ration, AF lbs/cow/day"},null,{"$f":"Volume!D6","v":45}]
[null,null,"Labor cost, $/hour",10,null,{"$f":"Volume!C7","v":"Silage moisture content, %"},null,{"$f":"Volume!D7","v":0.68}]
[null,null,"Milk price, $/cwt",13.5]
[]
[null,null,null,null,null,"Silage Storage System"]
[null,"Storage-type-specific inputs",null,null,null,"Bunker silo","Drive over pile","Plastic bags"]
[null,null,"Area of footprint required, acres",null,null,{"$f":"Volume!D44","v":2.6258673360050171},{"$f":"Volume!H44","v":3.7460074556934102},{"$f":"Volume!H20","v":6.9651056014692374}]
[null,null,"Storage units required for silage needs",null,null,{"$f":"Volume!D43","v":3.7397540983606565},{"$f":"Volume!H43","v":3.8356452290878522},{"$f":"Volume!H19","v":60}]
[null,null,"Tons of silage stored, AF",null,null,{"$f":"Volume!$D11/(1-F29-F30)","v":30796.875000000004},{"$f":"Volume!$D11/(1-G29-G30)","v":31586.538461538461},{"$f":"Volume!$D11/(1-H29-H30)","v":27682.584269662922}]
[null,null,"Plastic required for covering bunkers and piles, sq ft",null,null,{"$f":"Volume!D42","v":28064.859081946437},{"$f":"Volume!H42","v":41512.907517181935},"na"]
[null,null,"Structure investment per ton of storage capacity, $/ton AF a",null,null,{"$f":"Investment!D20","v":21.014415116746381},{"$f":"Investment!E20","v":8.5245799174937495},{"$f":"Investment!F20","v":11.894875697615424}]
[null,null,"Useful life to depreciate investment over, years",null,null,30,30,30]
[null,null,"Annual repairs and maintenance, %",null,null,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[null,null,"Annual cost of structure and land, $/ton AF",null,null,{"$f":"IF(F18=0,0,-PMT($D5,F18,F17)+F19*F17+(F13*$D6*$D5)/F15)","v":2.5529359932014097},{"$f":"IF(G18=0,0,-PMT($D5,G18,G17)+G19*G17+(G13*$D6*$D5)/G15)","v":1.0440092341798599},{"$f":"IF(H18=0,0,-PMT($D5,H18,H17)+H19*H17+(H13*$D6*$D5)/H15)","v":1.4653832122353185}]
[]
[null,null,"Cost of silage delivered to storage, $/ton AF",null,null,25,25,25]
[null,null,"Cost of packing or bagging, $/ton AF b",null,null,{"$f":"Packing!D12","v":1.095},1.1000000000000001,6]
[null,null,"Hours for covering silage, man-hrs/bunker or pile",null,null,50,50,0]
[null,null,"Other annual costs (e.g., tires, sand, bags, etc.), $/unit",null,null,500,500,100]
[null,null,"Total cost of silage into storage, $/ton AF",null,null,{"$f":"F20+F22+F23+(F24*$D8+F25)*F14/F15","v":28.769368901519563},{"$f":"G20+G22+G23+(G24*$D8+G25)*G14/G15","v":27.265442142498017},{"$f":"H20+H22+H23+(H24*$D8+H25)*H14/H15","v":32.682125982402752}]
[null,null,"Total cost of silage into storage, $/ton DM",null,null,{"$f":"F26/(1-$H8)","v":89.904277817248655},{"$f":"G26/(1-$H8)","v":85.204506695306321},{"$f":"H26/(1-$H8)","v":102.13164369500862}]
[]
[null,null,"Estimate of storage DM loss, %",null,null,{"$f":"Volume!D25","v":0.17},{"$f":"Volume!H25","v":0.18},{"$f":"Volume!H7","v":0.08}]
[null,null,"Estimate of feedout DM loss, %",null,null,{"$f":"Volume!D26","v":0.03},{"$f":"Volume!H26","v":0.04},{"$f":"Volume!H8","v":0.03}]
[null,null,"Total DM loss, %",null,null,{"$f":"+F29+F30","v":0.2},{"$f":"+G29+G30","v":0.22},{"$f":"+H29+H30","v":0.11}]
[null,null,"Total cost of silage out of storage, $/ton AF",null,null,{"$f":"F26/(1-F31)","v":35.961711126899452},{"$f":"G26/(1-G31)","v":34.955695054484636},{"$f":"H26/(1-H31)","v":36.721489867868257}]
[null,null,"Total cost of silage out of storage, $/ton DM",null,null,{"$f":"F32/(1-$H8)","v":112.38034727156081},{"$f":"G32/(1-$H8)","v":109.2365470452645},{"$f":"H32/(1-$H8)","v":114.75465583708832}]
[]
[null,"Silage cost adjustments due to quality"]
[null,null,"Change in milk production due to nutritive quality of silage, lbs/cow/day",null,null,0,0,1]
[null,null,"Milk production adjusted cost of silage out of storage, $/ton AF",null,null,{"$f":"F32-(F36*$H6*365*$D9/100)/F15","v":35.961711126899452},{"$f":"G32-(G36*$H6*365*$D9/100)/G15","v":34.955695054484636},{"$f":"H32-(H36*$H6*365*$D9/100)/H15","v":31.381489867868257}]
[null,null,"Milk production adjusted cost of silage out of storage, $/ton DM",null,null,{"$f":"F37/(1-$H8)","v":112.38034727156081},{"$f":"G37/(1-$H8)","v":109.2365470452645},{"$f":"H37/(1-$H8)","v":98.067155837088322}]
[]
[null,"a The investment cost for the different systems can be estimated in the Investment tab."]
[null,"b The cost of packing for a bunker or silo can be estimated in the Packing tab."]