{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ReadMe-Orientation","Round Bin Inventory","Flat Storage Inventory","support_data"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":39,"comments":3,"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":"ReadMe-Orientation","index":0,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,3,2],[25,1,25,7],[28,3,28,12]]}
[]
[]
["Grain Inventory Estimator"]
[]
["Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Author","Dennis Buckmaster, Professor, Agricultural & Biological Engineering; Dean's Fellow for Digital Agriculture"]
["Affiliation","Purdue University, Department of Agricultural & Biological Engineering"]
["Date","January, 2022"]
["URL to acquire","https://engineering.purdue.edu/~dbuckmas/outreach/Grain_Inventory.xlsm"]
[]
["Related tools:"]
["Transfer records and inventory tracking: ",null,null,"https://ag.purdue.edu/digital-ag-resources/easy-spreadsheet-style-transfer-records-and-inventory-tracking/"]

{"sheet":"Round Bin Inventory","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["INPUTS"]
["ct","crop type","Corn"," --"]
["D","bin diameter",30,"ft",true]
["PH","perimeter height of grain",30,"ft"]
["ts","top status","cone-shaped peak from filling"," --"]
["mc","moisture content",16,"% wet basis"]
[]
["INTERMEDIATE CALCULATIONS"]
["co","cone option",{"$f":"VLOOKUP(ts,cone_options,2,FALSE)","v":1}," --","=VLOOKUP(ts,cone_options,2,FALSE)"]
["ar","angle of repose",{"$f":"IF(co=1,13+mc,IF(co=2,17+mc,0))","v":29},"degrees","=IF(co=1,13+mc,IF(co=2,17+mc,0))"]
["pf","packing factor",{"$f":"IF(ct=\"Oats\",1.5,1.8-0.05*mc)","v":1}," --","=IF(ct=\"Oats\",1.5,1.8-0.05*mc)"]
["CV","cylinder volume",{"$f":"PI()*(D/2)^2*PH*0.8036","v":17040.941030867114},"bu","=PI()*(D/2)^2*PH*0.8036"]
["CH","cone height",{"$f":"TAN(RADIANS(ar))*D/2","v":8.3146357717915347},"ft","=TAN(RADIANS(ar))*D/2"]
["CA","cone volume adjustment",{"$f":"PI()*(D/2)^2*CH/3*IF(co=2,-1,1)","v":1959.089899345139},"bu","=PI()*(D/2)^2*CH/3*IF(co'=2,-1,1)"]
[]
["OUTPUTS"]
["BV","grain volume estimate",{"$f":"CV+CA","v":19000.030930212251},"bu","=CV+CA"]

{"sheet":"Flat Storage Inventory","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["INPUTS",null,null,null,null,null,"Rectangular prism - the \"base\" volume"]
["ctf","crop type","Corn"]
["L","length of rectangular prism (big box)",60,"ft",true]
["W","width of rectangular prism (big box)",40,"ft"]
["H","height of rectangular prism (big box)",15,"ft"]
["nw","number of triangular prisms (wedges)","one end from filling, one end from emptying"," --",null,null,"Triangular prism or \"wedge\" - potential end shapes"]
["cot","cones on top from filling",1," --"]
["mc","moisture content",16,"% wet basis"]
[]
["INTERMEDIATE CALCULATIONS"]
["rpv","rectangular prism volume",{"$f":"L*W*H*0.8036","v":28929.599999999999},"bu","=L*W*H*0.8036"]
["arf","angle of repose filling",{"$f":"13+mc","v":29},"degrees","=13+mc",null,"Cones - potential top shapes from filling"]
["are","angle of repose emptying",{"$f":"17+mc","v":33},"degrees","=17+mc"]
["waf","wedge adjustment filling",{"$f":"1/2*W*H*(H/TAN(RADIANS(arf)))*VLOOKUP(nw,wedge_adj,3,FALSE)*0.8036","v":6523.7974926125216},"bu","=1/2*W*H*(H/TAN(RADIANS(arf)))*VLOOKUP(nw,wedge_adj,3,FALSE)*0.8036"]
["wae","wedge adjustment emptying",{"$f":"1/2*W*H*(H/TAN(RADIANS(are)))*VLOOKUP(nw,wedge_adj,4,FALSE)*0.8036","v":5568.4596821462947},"bu","=1/2*W*H*(H/TAN(RADIANS(are)))*VLOOKUP(nw,wedge_adj,4,FALSE)*0.8036"]
["cov","cone volume, each",{"$f":"PI()*(W/2)^2*(TAN(RADIANS(arf))*W/2/3)","v":4643.7686502995884},"bu","=PI()*(W/2)^2*(TAN(RADIANS(arf))*W/2/3)",null,"A possiblity … a wedge on the end and a cone above"]
["ca","cone adjustment, total",{"$f":"cot*cov","v":4643.7686502995884},"bu","=cot*cov"]
[]
["OUTPUTS"]
["fsv","flat storage total volume estimate",{"$f":"rpv+waf+wae+ca","v":45665.6258250584},"bu","=rpv+waf+wae+ca"]

{"sheet":"support_data","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Data validation lists for other sheets"]
[]
["top_surface & cone_options"]
["cone-shaped peak from filling",1]
["hollow-cone from emptying",2]
["level",3]
[]
[]
["crops & angles - other sources",null,null,null,null,null,null,null,"Ambrose input .."]
["Crop","fill angle of repose","remove angle of repose","level full",null,null,null,null,"M","AOR"]
["Barley",24,26,0,null,null,null,null,13,28]
["Corn",23,30,0,null,null,null,null,23,38]
["Milo",29,30,0,null,null,null,null,"yields","AOR = 15 + M"]
["Oats",27,27,0]
["Soybeans",25,29,0,null,null,null,null,"Angle of Repose equation"]
["Wheat",24,24,0,null,null,null,null,"Fill AOR = 13 + M"]
["Sunflower",21,22,0,null,null,null,null,"Remove AOR = 17 + M"]
[null,null,null,null,null,null,null,null,"M","AORf","AORe"]
[null,null,null,null,null,null,null,null,13,{"$f":"13+I19","v":26},{"$f":"17+I19","v":30}]
["wedges & wedge_adj",null,"filling","emptying",null,null,null,null,15,{"$f":"13+I20","v":28},{"$f":"17+I20","v":32}]
["no wedges",1,0,0,null,null,null,null,17,{"$f":"13+I21","v":30},{"$f":"17+I21","v":34}]
["one end from filling",2,1,0,null,null,null,null,19,{"$f":"13+I22","v":32},{"$f":"17+I22","v":36}]
["two ends from filling",3,2,0]
["one end from emptying",4,0,1]
["one end from filling, one end from emptying",5,1,1]