{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data Entry Form","Instructions","Bulk Density"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Data Entry Form","index":0,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[25,0,27,0],[25,1,27,1],[37,0,39,0],[37,1,39,1],[9,1,9,3],[0,1,0,4],[3,1,3,3],[7,1,7,3],[37,2,39,2],[37,3,39,3],[25,2,27,2],[25,3,27,3],[5,1,5,3],[13,5,15,5],[25,4,27,4],[25,5,27,5],[37,4,39,4],[37,5,39,5],[13,0,15,0],[13,1,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4]]}
[null,"Gully Erosion Calculator"]
[]
[]
["Customer Name:",null,null,null,"Tract No."]
[]
["Practice:",null,null,null,"Field No."]
[]
["Designed By:",null,null,null,"Date:"]
[]
["Checked By:",null,null,null,"Date:"]
[]
["Reach No. 1"]
["Soil Mapping Unit",null,null,"Soil Texture"]
["Top   Width (ft)","Bottom Width   (ft)","Depth   (ft)","Length  (ft)","Soil Unit Weight (lb/ft3)","Number of Years"]
[]
[]
[null,null,null,null,{"$f":"IF('Bulk Density'!A412=1,\"\",INDEX('Bulk Density'!A$2:D$12,'Bulk Density'!A412,4))","v":""}]
[]
["Total Volume Displaced (ft3)",{"$f":"0.5*(A17+B17)*C17*D17","v":0},null,"Total Tons of Soil Displaced",{"$f":"IF(E17=\"\",0,(B19*E17)/2000)","v":0}]
[]
["Average Annual Gully Erosion (tons/year)",{"$f":"IF(E19=0,0,E19/F17)","v":0}]
[]
[]
["Reach No. 2"]
["Soil Mapping Unit",null,null,"Soil Texture"]
["Top   Width (ft)","Bottom Width   (ft)","Depth   (ft)","Length  (ft)","Soil Unit Weight (lb/ft3)","Number of Years"]
[]
[]
[null,null,null,null,{"$f":"IF('Bulk Density'!B412=1,\"\",INDEX('Bulk Density'!A$2:D$12,'Bulk Density'!B412,4))","v":""}]
[]
["Total Volume Displaced (ft3)",{"$f":"0.5*(A29+B29)*C29*D29","v":0},null,"Total Tons of Soil Displaced",{"$f":"IF(E29=\"\",0,(B31*E29)/2000)","v":0}]
[]
["Average Annual Gully Erosion (tons/year)",{"$f":"IF(E31=0,0,E31/F29)","v":0}]
[]
[]
["Reach No. 3"]
["Soil Mapping Unit",null,null,"Soil Texture"]
["Top   Width (ft)","Bottom Width   (ft)","Depth   (ft)","Length  (ft)","Soil Unit Weight (lb/ft3)","Number of Years"]
[]
[]
[null,null,null,null,{"$f":"IF('Bulk Density'!C412=1,\"\",INDEX('Bulk Density'!A$2:D$12,'Bulk Density'!C412,4))","v":""}]
[]
["Total Volume Displaced (ft3)",{"$f":"0.5*(A41+B41)*C41*D41","v":0},null,"Total Tons of Soil Displaced",{"$f":"IF(E41=\"\",0,(B43*E41)/2000)","v":0}]
[]
["Average Annual Gully Erosion (tons/year)",{"$f":"IF(E43=0,0,E43/F41)","v":0}]
[]
[]
["Total Average Annual Gully Erosion (tons/year)",null,null,null,null,{"$f":"B45+B33+B21","v":0}]

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Bulk Density","index":2,"n_rows":412,"n_cols":4,"rows_kept":412,"cut":false,"hidden":false,"merged":[]}
[null,"Texture","Bulk Density (grams/cm3)","Bulk Density (lb/ft3)"]
[1]
[2,"silt loam",1.35,{"$f":"C3*62.4","v":84.240000000000009}]
[3,"loam",1.45,90.47999999999999]
[4,"sandy loam",1.55,96.72]
[5,"clay",1.3,81.12]
[6,"clay loam",1.4,87.36]
[7,"loamy sand",1.6,99.84]
[8,"mucky silt loam",1.2,74.88]
[9,"sand",1.65,102.96]
[10,"sandy clay loam",1.5,93.6]
[11,"silty clay loam",1.3,81.12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,1,1]