{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Bunker Silo Cover Model"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Bunker Silo Cover Model","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Cost:benefit of covering bunker silo",null,null,"Enter data into green-shaded cells.",null,null,null,"(updated:  9/24/12)"]
[]
[null,null,"Bunker width (ft):",80,null,null,"Silage loss if",null,null,"Value","Total value"]
[null,null,"Bunker length (ft):",140,null,null,"top 3 feet left","Value of","Additional silage","of other","of lost"]
[null,null,"Bunker height (ft):",12,null,null,"uncovered","lost silage","loss if uncovered","lost","silage"]
[null,null,"Silage density (lbs/ft2):",40,null,null,"(tons as fed)","in top 3 feet","(tons as fed)","silage","($/ton as fed)"]
[null,null,"Silage loss % for top 3 feet:",0.3,null,null,{"$f":"(((D3*D4*3)*D6)/2000)*D7","v":201.6},{"$f":"G7*D10","v":12096},{"$f":"((D3*D4*D5*D6)/2000)*D9","v":53.76},{"$f":"I7*D10","v":3225.6},{"$f":"J7+H7","v":15321.6}]
[null,null,"Additional silage loss"]
[null,null,"for uncovered silo (% of total):",0.02,null,null,"Cost of silage","Cost of silage","Total cost of","Cost of","Cost of"]
[null,null,"Silage value ($/ton as fed):",60,null,null,"cover","cover (overage)","silage cover","Labor","tires"]
[null,null,"Cost of plastic covering ($/ft2):",0.12,null,null,{"$f":"D3*D4*D11","v":1344},{"$f":"D3*D4*D12*D11","v":67.2},{"$f":"G11+H11","v":1411.2},{"$f":"D14*D15","v":300},{"$f":"D17/D18","v":35}]
[null,null,"Percent overage for cover:",0.05]
[null,null,"Total labor hours needed",null,null,null,"Total cost","Net benefit","Return on"]
[null,null,"to cover bunker:",25,null,null,"to cover","of covering","investment"]
[null,null,"Labor cost ($/hr):",12,null,null,{"$f":"G11+H11+J11+K11","v":1746.2},{"$f":"K7-G15","v":13575.4},{"$f":"H15/G15","v":7.7742526629252087}]
[null,null,"Cost of tires to hold down",null,null,null,null,null,"to"]
[null,null,"plastic silo cover:",350,null,null,null,null,1]
[null,null,"Expected useful life of tires (yrs):",10]