{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Manure Pile Calculator"],"not_rendered":{"charts":0,"images":5,"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":"Manure Pile Calculator","index":0,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,0,0,10],[59,6,59,10],[9,6,9,10],[40,0,40,7],[9,0,9,4],[25,0,25,6],[88,6,88,7],[83,1,83,2],[88,2,88,3],[60,0,60,8],[77,0,81,10],[83,4,83,5],[83,7,83,8]]}
["Estimating the Volume of a Manure Pile"]
[null,null,null,"Data Entry in","Blue","cells only"]
[]
[null,"Landowner:",null,null,"Project:"]
[null,"County:",null,null,"State:",null,"Tract ID:",null,"Field ID:"]
[null,"By:",null,null,"Date:",null,"Checked:",null,"Date:"]
[]
[null,"Subject:"]
[]
[null,null,null,null,null,null,"Example Shape of Pile"]
[]
[null,null,null,"Height of pile =",null,"Ft"]
[null,null,null,"Circumference of pile =",null,"Ft"]
[null,null,null,"Diameter of Pile =",{"$f":"E13/PI()","v":0},"Ft"]
[]
[null,null,null,"Volume of Pile (Cylinder) =",{"$f":"(PI()/12)*(E14*E14*E12)","v":0},"Cu.Ft."]
[null,null,null,"or",{"$f":"E16/27","v":0},"Cu.Yds."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Height of pile =",null,"Ft"]
[null,null,null,"Circumference of pile =",null,"Ft"]
[null,null,null,"Diameter of pile =",{"$f":"E29/PI()","v":0},"Ft"]
[]
[null,null,null,"Volume of Pile (Partial Sphere) =",{"$f":"0.131*E28*((4*E28*E28)+(3*E30*E30))","v":0},"Cu.Ft."]
[null,null,null,"or",{"$f":"E32/27","v":0},"Cu.Yds."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Length of windrow along the bottom ="]
[null,null,null,"Length of windrow along the top =",null,"Ft"]
[null,null,null,"Width of windrow =",null,"Ft"]
[null,null,null,"Height of windrow =",null,"Ft"]
[]
[null,null,null,"Volume of a triangular prism =",{"$f":"(E46*E45*E44/2)","v":0},"Cu.Ft."]
[null,null,null,"Diameter of a cone =",{"$f":"(E43-E44+E45)/2","v":0},"Ft"]
[null,null,null,"Volume of  a cone =",{"$f":"(0.262*E49*E49*E46)","v":0},"Cu.Ft."]
[]
[null,null,null,"Total windrow volume =",{"$f":"E48+E50","v":0},"Cu.Ft."]
[null,null,null,null,{"$f":"E52/27","v":0},"Cu.Yds."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Example Shape of Pile"]
["Rounded Windrow Volume: (combination of a partial cylindrical prism and a partial sphere)"]
[]
[null,null,null,"Length of windrow along the bottom =",null,"Ft"]
[null,null,null,"Length of windrow along the top =",null,"Ft"]
[null,null,null,"Width of windrow =",null,"Ft"]
[null,null,null,"Height of windrow =",null,"Ft"]
[]
[null,null,null,"Volume of a partial cylinder =",{"$f":"0.7*E66*E64*E65","v":0},"Cu.Ft."]
[null,null,null,"Diameter of a sphere =",{"$f":"(E63-E64+E65)/2","v":0},"Ft"]
[null,null,null,"Volume of a partial sphere =",{"$f":"0.131*E66*((4*E66*E66)+(3*E69*E69))","v":0},"Cu.Ft."]
[]
[null,null,null,"Total windrow volume =",{"$f":"SUM(E68+E70)","v":0},"Cu.Ft."]
[null,null,null,null,{"$f":"E72/27","v":0},"Cu.Yds."]
[]
[]
[]
["To estimate the weight the manure in a pile:"]
[]
[]
[]
[]
[]
[]
[null,"Pail Volume",null,null,"Pail Weight",null,null,"Bulk Density of pile"]
[null,"1 gallon pail =",{"$f":"0.1337*1","v":0.13370000000000001},"Cu.Ft.",null,"lbs",null,{"$f":"E85/C85","v":0},"Lbs./Cu.Ft."]
[null,"5 gallon pail =",{"$f":"5*0.1337","v":0.66850000000000009},"Cu.Ft.",null,"lbs",null,{"$f":"E86/C86","v":0},"Lbs./Cu.Ft."]
[]
[]
[null,null,"Bulk Density",null,null,null,"Volume of Pile"]
[null,null,null,"Lbs./Cu.Ft.",null,null,null,"Cu.Ft."]
[]
[null,null,null,"Total =",{"$f":"(C90*G90)/2000","v":0},"Tons of Manure"]