{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Input","Examples","Equations","References"," Report Grain Size","Report K"],"not_rendered":{"charts":6,"images":19,"macros":1,"external_links":0,"defined_names":27,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input","index":1,"n_rows":108,"n_cols":40,"rows_kept":108,"cut":false,"hidden":false,"merged":[[1,10,6,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zunker","Terzaghi","Barr","Plotted Data - Line",null,"ü",null,"Estimation of Hydraulic Conductivity","cm/s","m/s","m/d",null,"Estimation of Hydraulic Conductivity","cm/s","m/s","m/d",null,"A. mean","G mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5499999999999999E-3,8.3999999999999995E-3,4.0200000000000001E-3,null,null,null,{"$f":"IF(ISBLANK(F19)=FALSE,1,0)","v":1},"Hazen",{"$f":"IF($AB3>0,$AB3*H19,\" \")","v":0},{"$f":"IF($AB3>0,$AB3*I19,\" \")","v":0},0,null,"Hazen",{"$f":"IF($AB3=0,H19,\" \")","v":" "},{"$f":"IF($AB3=0,I19,\" \")","v":" "}," ",null,{"$f":"$J$35","v":0},{"$f":"$J$34","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.15,null,null,null,{"$f":"IF(ISBLANK(F20)=FALSE,1,0)","v":0},"Hazen K (cm/s) = d102 (mm2)",{"$f":"IF($AB4>0,$AB4*H20,\" \")","v":" "},{"$f":"IF($AB4>0,$AB4*I20,\" \")","v":" "},{"$f":"IF($AB4>0,$AB4*J20,\" \")","v":" "},null,"Hazen K (cm/s) = d102 (mm2)",{"$f":"IF($AB4=0,H20,\" \")","v":0},{"$f":"IF($AB4=0,I20,\" \")","v":0},{"$f":"IF($AB4=0,J20,\" \")","v":0},null,{"$f":"$J$35","v":0},{"$f":"$J$34","v":{"$error":"#NUM!"}}]
[null,null,"Mass Sample (g):",null,"T (oC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Slichter",0,0,0,null,"Slichter"," "," "," ",null,0,{"$error":"#NUM!"}]
[null,null,0,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.15,0.15,null,null,null,0,"Terzaghi"," "," "," ",null,"Terzaghi",0,0,0,null,0,{"$error":"#NUM!"}]
["Sieve opening               di (f)","Sieve opening (ps)              di (mm)","Mass of retained (mr) \n(g)","mass fraction (mf)","Percent Passing (pp)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Beyer",0,0,0,null,"Beyer"," "," "," ",null,0,{"$error":"#NUM!"}]
[{"$f":"IF(ISBLANK(B8),\" \",3.3193*LOG(B8))","v":" "},null,null,null,null,null,null,null,null,null,"Effective Grain Diameters (mm)",null,"Other Useful Parameters",null,null,null,null,null,null,null,null,"ne for Dg","Dgeom approx",null,null,null,null,1,"Sauerbrei",0,0,0,null,"Sauerbrei"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"d10",null,"Uniformity Coef.",{"$f":"L13/L9","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,0,{"$f":"2^((N17+N18+N19)/3)","v":{"$error":"#NUM!"}},null,null,null,null,0,"Kruger"," "," "," ",null,"Kruger",0,0,0,null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"d17",null,"n computed",{"$f":"0.255*(1+0.83^N9)","v":{"$error":"#DIV/0!"}},{"$f":"IF(V9>0,V9,0.255*(1+0.83^N9))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,1,"Kozeny-Carmen",0,0,0,null,"Kozeny-Carmen"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"d20",null,"g (cm/s2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Zunker",0,0,0,null,"Zunker"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"d50",null,"r (g/cm3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Zamarin",0,0,0,null,"Zamarin"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"d60",null,"m (g/cm s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"USBR",0,0,0,null,"USBR"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"dgeometric mean",null,"rg/m (1/cm s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Barr",0,0,0,null,"Barr"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"de (Kruger)",null,"tau (Sauerbrei)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Alyamani and Sen",0,0,0,null,"Alyamani and Sen"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"de (Kozeny)",null,"d5f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Chapuis"," "," "," ",null,"Chapuis",0,0,0,null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"de (Zunker)",null,"d16f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Krumbein and Monk",0,0,0,null,"Krumbein and Monk"," "," "," ",null,0,{"$error":"#NUM!"}]
[" ",null,null,null,null,null,"Estimation of Hydraulic Conductivity","cm/s","m/s","m/d","de (Zamarin)",null,"d50f",{"$f":"3.3193*LOG(L12)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"geometric mean",{"$f":"GEOMEAN(AD3:AD17)","v":{"$error":"#NUM!"}},{"$f":"GEOMEAN(AE3:AE17)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[" ",null,null,null,null,"ü","Hazen",null,{"$f":"H19/100","v":0},{"$f":"H19/100*24*60*60","v":0},"Io (Alyameni)",{"$f":"-(10-(40/(L12-L9))*L9)*(L12-L9)/40","v":{"$error":"#DIV/0!"}},"d84f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"arithmetic mean",{"$f":"AVERAGE(AD3:AD17)","v":0},{"$f":"AVERAGE(AE3:AE17)","v":0},0]
[" ",null,null,null,null,null,"Hazen K (cm/s) = d102 (mm2)",{"$f":"L9^2","v":0},{"$f":"H20/100","v":0},{"$f":"H20/100*24*60*60","v":0},null,null,"d95f"]
[{"$f":"IF(ISBLANK(B21),\" \",3.3193*LOG(B21))","v":" "},null,null,null,null,"ü","Slichter",null,0,{"$f":"H21/100*24*60*60","v":0},null,null,"sf",{"$f":"(N19-N17)/4+(N20-N16)/6.6","v":0}]
[" ",null,null,null,null,null,"Terzaghi",null,0,{"$f":"H22/100*24*60*60","v":0},null,"mm",null,"% in sample"]
[" ",null,null,null,null,"ü","Beyer",null,0,0,null,">64","Boulder"]
[" ",null,null,null,null,"ü","Sauerbrei",null,0,0,null,"16 - 64","coarse gravel"]
[" ",null,null,null,null,null,"Kruger",null,0,0,null,"8 - 16","medium gravel"]
[" ",null,null,null,null,"ü","Kozeny-Carmen",null,0,0,null,"2  - 8","fine gravel"]
[" ",null,null,null,null,"ü","Zunker",null,0,0,null,"0.5 - 2","coarse sand"]
[" ",null,null,null,null,"ü","Zamarin",null,0,0,null,"0.25 - 0.5","medium sand"]
[" ",null,null,null,null,"ü","USBR",null,0,0,null,"0.063 - 0.25","fine sand"]
[" ",null,null,null,null,"ü","Barr",null,0,0,null,"0.016 - 0.063","coarse silt"]
[" ",null,null,null,null,"ü","Alyamani and Sen",null,0,0,null,"0.008 - 0.016","medium silt"]
[" ",null,null,null,null,null,"Chapuis",null,0,0,null,"0.002 - 0.008","fine silt"]
[" ",null,null,null,null,"ü","Krumbein and Monk",null,0,0,null,"<0.002","clay"]
[" ",null,null,null,null,null,"geometric mean",{"$f":"AD18","v":{"$error":"#NUM!"}},{"$f":"AE18","v":{"$error":"#NUM!"}},{"$f":"AF18","v":{"$error":"#NUM!"}}]
[" ",null,null,null,null,null,"arithmetic mean",{"$f":"AD19","v":0},0,0]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[{"$f":"IF(ISBLANK(B72),\" \",3.3193*LOG(B72))","v":" "}]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]

{"sheet":"Examples","index":2,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Examples  of Grain Retention Datasets from the literature"]
[]
["Example 1 Case 1 Vukovic 15 oC",null,null,null,null,null,"Sample 1 Odong 20 oC",null,null,null,null,null,"Thomson SERDP Borden sand"]
["ps",null,null,"pp",null,null,"ps",null,null,"pp",null,null,"ps",null,null,"pp"]
[2,null,null,100,null,null,10,null,null,85.23,null,null,10,null,null,99.99]
[0.82,null,null,80,null,null,4.75,null,null,79.569999999999993,null,null,9,null,null,99.9]
[0.55000000000000004,null,null,60,null,null,2.36,null,null,66.73,null,null,3,null,null,99.8]
[0.42,null,null,40,null,null,1.18,null,null,49.99,null,null,1.3,null,null,98]
[0.28000000000000003,null,null,20,null,null,0.6,null,null,30.75,null,null,0.8,null,null,97]
[0.15,null,null,10,null,null,0.42499999999999999,null,null,17.55,null,null,0.4,null,null,95]
[4.4999999999999998E-2,null,null,0,null,null,0.3,null,null,6.28,null,null,0.23,null,null,82]
[null,null,null,null,null,null,0.15,null,null,2.84,null,null,0.15,null,null,31]
["Example 1 Case 2 Vukovic 15 oC",null,null,null,null,null,7.4999999999999997E-2,null,null,0,null,null,7.0000000000000007E-2,null,null,10]
["ps",null,null,"pp",null,null,null,null,null,null,null,null,0.04,null,null,2.6]
[2,null,null,100,null,null,null,null,null,null,null,null,2.7E-2,null,null,2.6]
[1.5,null,null,95,null,null,"Sample 2 Odong 20 oC",null,null,null,null,null,1.7000000000000001E-2,null,null,2.6]
[1.2,null,null,90,null,null,"ps",null,null,"pp",null,null,0.01,null,null,2.5]
[0.95,null,null,85,null,null,1.18,null,null,100,null,null,5.4999999999999997E-3,null,null,1]
[0.82,null,null,80,null,null,0.6,null,null,96.2,null,null,2E-3,null,null,0]
[0.73,null,null,75,null,null,0.42499999999999999,null,null,77.650000000000006]
[0.66,null,null,70,null,null,0.3,null,null,48.41,null,null,"Schillig PVP4-5, elev 289.5 masl"]
[0.6,null,null,65,null,null,0.21199999999999999,null,null,18.88,null,null,10,0,"total weight",110.69]
[0.55000000000000004,null,null,60,null,null,0.15,null,null,2.2999999999999998,null,null,9,0,"tracer test derived Ks: 1.9e-3 m/s to 1.4e-2 m/s"]
[0.51,null,null,55,null,null,7.4999999999999997E-2,null,null,0,null,null,4,64.33,null,"=","164 m/d to 1210 m/d"]
[0.48,null,null,50,null,null,null,null,null,null,null,null,2,12.89]
[0.45,null,null,45,null,null,"Sample 3 Odong 20 oC",null,null,null,null,null,1,11.81]
[0.42,null,null,40,null,null,"ps",null,null,"pp",null,null,0.5,7.51]
[0.39,null,null,35,null,null,4.75,null,null,95.05,null,null,0.29699999999999999,3.56]
[0.36,null,null,30,null,null,2.36,null,null,85.08,null,null,0.17699999999999999,2.38]
[0.32,null,null,25,null,null,2,null,null,82.02,null,null,0.125,2.97]
[0.28000000000000003,null,null,20,null,null,1.18,null,null,64.66,null,null,6.3E-2,2.2799999999999998]
[0.22,null,null,15,null,null,0.6,null,null,44.76,null,null,0.01,1.54]
[0.15,null,null,10,null,null,0.42499999999999999,null,null,23.42]
[0.08,null,null,5,null,null,0.3,null,null,7.96]
[4.4999999999999998E-2,null,null,0,null,null,0.15,null,null,2.11]
[null,null,null,null,null,null,7.4999999999999997E-2,null,null,0]
["Example 2 Case 1 Vukovic 15 oC"]
["ps",null,null,"pp",null,null,"Sample 4 Odong 20 oC"]
[5,null,null,100,null,null,"ps",null,null,"pp"]
[0.85,null,null,80,null,null,1.18,null,null,100]
[0.3,null,null,60,null,null,0.6,null,null,98.44]
[0.12,null,null,40,null,null,0.42499999999999999,null,null,91.55]
[3.9E-2,null,null,20,null,null,0.3,null,null,68.78]
[1.4E-2,null,null,10,null,null,0.21199999999999999,null,null,25.83]
[2.5000000000000001E-3,null,null,5,null,null,0.15,null,null,7.89]
[1E-3,null,null,0,null,null,7.4999999999999997E-2,null,null,0.93]
[null,null,null,null,null,null,6.3E-2,null,null,0]

{"sheet":"Equations","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,20]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,980]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.99813600000000002]

{"sheet":"References","index":4,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"References"]
[1,"Aguilar, J.R. 2013. Analysis of grain size distribution and hydraulic conductivity for a variety of sediment types with application to wadi sediments.  M.B2:B19S. thesis submitted to King Abdullah University of Science and Technology, Thuwal, Kingdom of Saudi Arabia, 134 pp."]
[{"$f":"A2+1","v":2},"Alyamani, M.S., Sen Z.  1993.  Determination of hydraulic conductivity from complete grain-size distribution curves.  Ground Water, v. 31, no. 4, 551-555."]
[{"$f":"A3+1","v":3},"Barr, D.W.  2001.  Coefficient of permeability determined by measurable parameters.  Ground Water, v. 39, no. 3, 356-361."]
[4,"Barth, G.R., Hill, M.C., Illangasekare, T.H., Rajaram, H.  2001.  Predictive modeling of flow and transport in a two-dimensional intermediate-scale, heterogeneous porous medium.  Water Resources Research, v. 37, no. 10, 2503–2512."]
[5,"Beyer, W. 1964. \"Zur Bestimmung der Wasserdurchlässigkeit von Kiesen und Sanden aus der Kornverteilungskurve.\" Wasserwirtschaft-Wassertechnik 14(6): 165-168."]
[6,"Białas, Z. (1966). O usrednianiu wspolczynnikow filtracji z zastosowaniem elektronicznej cyfrowej maszyny matematycznej (Averaging filter coefficients using digital electronic mathematical machines). Przedsiebiorstwo Geologiczne we Wroclawiu: 47-50."]
[7,"Chapuis, R.P.  2004.  Predicting the saturated hydraulic conductivity of sand and gravel using effective diameter and void ratio.  Canadian Geotechnical Journal, v. 41, 787–795."]
[8,"Devlin, J.F. (2015). HydrogeoSieveXL.  Excel-based Visual Basic tool freely available at http://www.people.ku.edu/~jfdevlin/Publications.html.   Cited 18 February, 2015."]
[9,"Dullien, F.A., 1991. Fluid Transport and Pore Structure. Academic Press, San Diego, CA."]
[10,"Freeze, R.A., Cherry, J.A.  1979. Groundwater. Prentice Hall, Englewood Cliffs, New Jersey."]
[11,"Fuchs, S. (2010) Deterministische kf-Wert-Schätzung nach petrographischer Bohrgutansprache (Deterministic kf value estimation from petrographic borehole records).  Grundwasser – Zeitschrift der Fachsektion Hydrogeologie 15: 177–189."]
[12,"Hazen, A. 1892.  Some physical properties of sands and gravels, with special reference to their use in  filtration. Massachusetts State Board of Health, vol. 24th annual report, pp. 539-556."]
[13,"Kasenow, M., 2002, Determination of Hydraulic Conductivity from Grain Size Analysis: Water Resources Publications, LLC, Highlands Ranch, Colorado, 97p."]
[14,"Kozeny, J. (1953).  Das Wasser im Boden. Grundwasserbewegung (The water in the ground.\nGroundwater flow).  Hydraulik, Springer, p 380-445."]
[15,"Krüger, E., 1919. Die Grundwasserbewegung (Groundwater flow). Int. Mitt. Bodenk. 8, 105–122."]
[16,"Krumbein, W.C., Monk, G.D.  1942.  Permeability as a function of the size parameters of unconsolidated sand.  American Institute of Mining and Metallurgical Engineers, Transactions v. 151, 153-163."]
[17,"Moreau, J.P. Program to demonstrate the Akima spline fitting of Function SIN(X) in double precision.  http://jean-pierre.moreau.pagesperso-orange.fr/Fortran/akima_f90.txt .  Cited 30 January, 2015."]
[18,"Odong, J.  2013.  Evaluation of empirical formulae for determination of hydraulic conductivity based on grain-size analysis.  International Journal of Agriculture and Environment, v. 1, 1-8."]
[19,"Rosas, J., Lopez, O., Missimer, T.M., Coulibaly, K.M., Dehwah, A.H.A., Sesler, K., Lujan, L.R., Mantilla, D.  2014.  Determination of hydraulic conductivity from grain-size distribution for different depositional environments.  Groundwater, v. 52, no. 3, 399-413."]
[{"$f":"A20+1","v":20},"Slichter, C.S., 1898, Theoretical investigations of the motion of ground waters: United States Geological Survey, 19 th Annual Report, p 295-384."]
[21,"Terzaghi, K., 1925, Principles of soil mechanics: Engineering News-Record, v. 95, p 832."]
[22,"Urumovic, K., Urumovic, K. Sr.  2106.  The referential grain size and effective porosity in the Kozeny–Carman model.  Hydrological Earth System Science, v. 20, 1669-1680."]
[23,"Vukovic, M., Soro, A.  1992.  Determinatiion of hydraulic conductivity of porous media from grain-size composition.  Miladinov, D., translator, Water Resources Publications, Littleton, Colorado, USA, 83 pp."]
[24,"Zamarin, J.A.  1928.  Calculation of ground-water flow (in Russian).  Trudey I.V.H. Taskeni."]
[25,"Zunker, F. (1930). Das Verhalten des Wassers zum Boden (The behavior of groundwater).  Zeitschrift für Pflanzenernährung, Düngung und Bodenkunde. A25(1): 7."]

{"sheet":" Report Grain Size","index":5,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,5,19,6],[19,7,19,8],[6,0,6,8],[41,5,41,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6]]}
[]
[null,null,"Grain Size Analysis Report",null,null,null,"Date:"]
[]
[null,null,"Sample Name:"]
[null,null,null,{"$f":"Input!C5","v":"Mass Sample (g):"},null,{"$f":"Input!C6","v":0},null,{"$f":"Input!E5","v":"T (oC)"},{"$f":"Input!E6","v":20}]
[]
[{"$f":"Input!K2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Input!B7","v":"Sieve opening (ps)              di (mm)"},{"$f":"Input!C7","v":"Mass of retained (mr) \n(g)"},{"$f":"Input!D7","v":"mass fraction (mf)"},{"$f":"Input!E7","v":"Percent Passing (pp)"},null,{"$f":"Input!K8","v":"Effective Grain Diameters (mm)"},null,{"$f":"Input!M8","v":"Other Useful Parameters"}]
[{"$f":"IF(ISBLANK(Input!B8),\" \",Input!B8)","v":" "},{"$f":"IF(ISBLANK(Input!C8),\" \",Input!C8)","v":" "},{"$f":"IF(ISBLANK(Input!D8),\" \",Input!D8)","v":" "},{"$f":"IF(ISBLANK(Input!E8),\" \",Input!E8)","v":" "},null,{"$f":"Input!K9","v":"d10"},{"$f":"Input!L9","v":0},"Uniformity Coef.",{"$f":"Input!N9","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(ISBLANK(Input!B9),\" \",Input!B9)","v":" "},{"$f":"IF(ISBLANK(Input!C9),\" \",Input!C9)","v":" "},{"$f":"IF(ISBLANK(Input!D9),\" \",Input!D9)","v":" "},{"$f":"IF(ISBLANK(Input!E9),\" \",Input!E9)","v":" "},null,{"$f":"Input!K10","v":"d17"},{"$f":"Input!L10","v":0},"n computed",{"$f":"Input!N10","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(ISBLANK(Input!B10),\" \",Input!B10)","v":" "},{"$f":"IF(ISBLANK(Input!C10),\" \",Input!C10)","v":" "},{"$f":"IF(ISBLANK(Input!D10),\" \",Input!D10)","v":" "},{"$f":"IF(ISBLANK(Input!E10),\" \",Input!E10)","v":" "},null,{"$f":"Input!K11","v":"d20"},{"$f":"Input!L11","v":0},"g (cm/s2)",{"$f":"Input!N11","v":0}]
[{"$f":"IF(ISBLANK(Input!B11),\" \",Input!B11)","v":" "},{"$f":"IF(ISBLANK(Input!C11),\" \",Input!C11)","v":" "},{"$f":"IF(ISBLANK(Input!D11),\" \",Input!D11)","v":" "},{"$f":"IF(ISBLANK(Input!E11),\" \",Input!E11)","v":" "},null,{"$f":"Input!K12","v":"d50"},{"$f":"Input!L12","v":0},"r (g/cm3)",{"$f":"Input!N12","v":0}]
[{"$f":"IF(ISBLANK(Input!B12),\" \",Input!B12)","v":" "},{"$f":"IF(ISBLANK(Input!C12),\" \",Input!C12)","v":" "},{"$f":"IF(ISBLANK(Input!D12),\" \",Input!D12)","v":" "},{"$f":"IF(ISBLANK(Input!E12),\" \",Input!E12)","v":" "},null,{"$f":"Input!K13","v":"d60"},{"$f":"Input!L13","v":0},"m (g/cm s)",{"$f":"Input!N13","v":0}]
[{"$f":"IF(ISBLANK(Input!B13),\" \",Input!B13)","v":" "},{"$f":"IF(ISBLANK(Input!C13),\" \",Input!C13)","v":" "},{"$f":"IF(ISBLANK(Input!D13),\" \",Input!D13)","v":" "},{"$f":"IF(ISBLANK(Input!E13),\" \",Input!E13)","v":" "},null,{"$f":"Input!K15","v":"de (Kruger)"},{"$f":"Input!L15","v":0},"rg/m (1/cm s)",{"$f":"Input!N14","v":0}]
[{"$f":"IF(ISBLANK(Input!B14),\" \",Input!B14)","v":" "},{"$f":"IF(ISBLANK(Input!C14),\" \",Input!C14)","v":" "},{"$f":"IF(ISBLANK(Input!D14),\" \",Input!D14)","v":" "},{"$f":"IF(ISBLANK(Input!E14),\" \",Input!E14)","v":" "},null,{"$f":"Input!K16","v":"de (Kozeny)"},{"$f":"Input!L16","v":0},"tau (Sauerbrei)",{"$f":"Input!N15","v":0}]
[{"$f":"IF(ISBLANK(Input!B15),\" \",Input!B15)","v":" "},{"$f":"IF(ISBLANK(Input!C15),\" \",Input!C15)","v":" "},{"$f":"IF(ISBLANK(Input!D15),\" \",Input!D15)","v":" "},{"$f":"IF(ISBLANK(Input!E15),\" \",Input!E15)","v":" "},null,{"$f":"Input!K17","v":"de (Zunker)"},{"$f":"Input!L17","v":0},"dgeometric mean",{"$f":"Input!L14","v":0}]
[{"$f":"IF(ISBLANK(Input!B16),\" \",Input!B16)","v":" "},{"$f":"IF(ISBLANK(Input!C16),\" \",Input!C16)","v":" "},{"$f":"IF(ISBLANK(Input!D16),\" \",Input!D16)","v":" "},{"$f":"IF(ISBLANK(Input!E16),\" \",Input!E16)","v":" "},null,{"$f":"Input!K18","v":"de (Zamarin)"},{"$f":"Input!L18","v":0},"sf",{"$f":"Input!N21","v":0}]
[{"$f":"IF(ISBLANK(Input!B17),\" \",Input!B17)","v":" "},{"$f":"IF(ISBLANK(Input!C17),\" \",Input!C17)","v":" "},{"$f":"IF(ISBLANK(Input!D17),\" \",Input!D17)","v":" "},{"$f":"IF(ISBLANK(Input!E17),\" \",Input!E17)","v":" "},null,{"$f":"Input!K19","v":"Io (Alyameni)"},{"$f":"Input!L19","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(ISBLANK(Input!B18),\" \",Input!B18)","v":" "},{"$f":"IF(ISBLANK(Input!C18),\" \",Input!C18)","v":" "},{"$f":"IF(ISBLANK(Input!D18),\" \",Input!D18)","v":" "},{"$f":"IF(ISBLANK(Input!E18),\" \",Input!E18)","v":" "},null,{"$f":"Input!$L$22","v":"mm"},null,{"$f":"Input!$M$22","v":0},{"$f":"Input!$N$22","v":"% in sample"}]
[{"$f":"IF(ISBLANK(Input!B19),\" \",Input!B19)","v":" "},{"$f":"IF(ISBLANK(Input!C19),\" \",Input!C19)","v":" "},{"$f":"IF(ISBLANK(Input!D19),\" \",Input!D19)","v":" "},{"$f":"IF(ISBLANK(Input!E19),\" \",Input!E19)","v":" "},null,{"$f":"Input!L23","v":">64"},null,{"$f":"Input!M23","v":"Boulder"},{"$f":"IF(ISBLANK(Input!N23),\" \",Input!N23)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B20),\" \",Input!B20)","v":" "},{"$f":"IF(ISBLANK(Input!C20),\" \",Input!C20)","v":" "},{"$f":"IF(ISBLANK(Input!D20),\" \",Input!D20)","v":" "},{"$f":"IF(ISBLANK(Input!E20),\" \",Input!E20)","v":" "},null,{"$f":"Input!L24","v":"16 - 64"},null,{"$f":"Input!M24","v":"coarse gravel"},{"$f":"IF(ISBLANK(Input!N24),\" \",Input!N24)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B21),\" \",Input!B21)","v":" "},{"$f":"IF(ISBLANK(Input!C21),\" \",Input!C21)","v":" "},{"$f":"IF(ISBLANK(Input!D21),\" \",Input!D21)","v":" "},{"$f":"IF(ISBLANK(Input!E21),\" \",Input!E21)","v":" "},null,{"$f":"Input!L25","v":"8 - 16"},null,{"$f":"Input!M25","v":"medium gravel"},{"$f":"IF(ISBLANK(Input!N25),\" \",Input!N25)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B22),\" \",Input!B22)","v":" "},{"$f":"IF(ISBLANK(Input!C22),\" \",Input!C22)","v":" "},{"$f":"IF(ISBLANK(Input!D22),\" \",Input!D22)","v":" "},{"$f":"IF(ISBLANK(Input!E22),\" \",Input!E22)","v":" "},null,{"$f":"Input!L26","v":"2  - 8"},null,{"$f":"Input!M26","v":"fine gravel"},{"$f":"IF(ISBLANK(Input!N26),\" \",Input!N26)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B23),\" \",Input!B23)","v":" "},{"$f":"IF(ISBLANK(Input!C23),\" \",Input!C23)","v":" "},{"$f":"IF(ISBLANK(Input!D23),\" \",Input!D23)","v":" "},{"$f":"IF(ISBLANK(Input!E23),\" \",Input!E23)","v":" "},null,{"$f":"Input!L27","v":"0.5 - 2"},null,{"$f":"Input!M27","v":"coarse sand"},{"$f":"IF(ISBLANK(Input!N27),\" \",Input!N27)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B24),\" \",Input!B24)","v":" "},{"$f":"IF(ISBLANK(Input!C24),\" \",Input!C24)","v":" "},{"$f":"IF(ISBLANK(Input!D24),\" \",Input!D24)","v":" "},{"$f":"IF(ISBLANK(Input!E24),\" \",Input!E24)","v":" "},null,{"$f":"Input!L28","v":"0.25 - 0.5"},null,{"$f":"Input!M28","v":"medium sand"},{"$f":"IF(ISBLANK(Input!N28),\" \",Input!N28)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B25),\" \",Input!B25)","v":" "},{"$f":"IF(ISBLANK(Input!C25),\" \",Input!C25)","v":" "},{"$f":"IF(ISBLANK(Input!D25),\" \",Input!D25)","v":" "},{"$f":"IF(ISBLANK(Input!E25),\" \",Input!E25)","v":" "},null,{"$f":"Input!L29","v":"0.063 - 0.25"},null,{"$f":"Input!M29","v":"fine sand"},{"$f":"IF(ISBLANK(Input!N29),\" \",Input!N29)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B26),\" \",Input!B26)","v":" "},{"$f":"IF(ISBLANK(Input!C26),\" \",Input!C26)","v":" "},{"$f":"IF(ISBLANK(Input!D26),\" \",Input!D26)","v":" "},{"$f":"IF(ISBLANK(Input!E26),\" \",Input!E26)","v":" "},null,{"$f":"Input!L30","v":"0.016 - 0.063"},null,{"$f":"Input!M30","v":"coarse silt"},{"$f":"IF(ISBLANK(Input!N30),\" \",Input!N30)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B27),\" \",Input!B27)","v":" "},{"$f":"IF(ISBLANK(Input!C27),\" \",Input!C27)","v":" "},{"$f":"IF(ISBLANK(Input!D27),\" \",Input!D27)","v":" "},{"$f":"IF(ISBLANK(Input!E27),\" \",Input!E27)","v":" "},null,{"$f":"Input!L31","v":"0.008 - 0.016"},null,{"$f":"Input!M31","v":"medium silt"},{"$f":"IF(ISBLANK(Input!N31),\" \",Input!N31)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B28),\" \",Input!B28)","v":" "},{"$f":"IF(ISBLANK(Input!C28),\" \",Input!C28)","v":" "},{"$f":"IF(ISBLANK(Input!D28),\" \",Input!D28)","v":" "},{"$f":"IF(ISBLANK(Input!E28),\" \",Input!E28)","v":" "},null,{"$f":"Input!L32","v":"0.002 - 0.008"},null,{"$f":"Input!M32","v":"fine silt"},{"$f":"IF(ISBLANK(Input!N32),\" \",Input!N32)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B29),\" \",Input!B29)","v":" "},{"$f":"IF(ISBLANK(Input!C29),\" \",Input!C29)","v":" "},{"$f":"IF(ISBLANK(Input!D29),\" \",Input!D29)","v":" "},{"$f":"IF(ISBLANK(Input!E29),\" \",Input!E29)","v":" "},null,{"$f":"Input!L33","v":"<0.002"},null,{"$f":"Input!M33","v":"clay"},{"$f":"IF(ISBLANK(Input!N33),\" \",Input!N33)","v":" "}]
[{"$f":"IF(ISBLANK(Input!B29),\" \",\"Data continue, additional pages required …\")","v":" "}]

{"sheet":"Report K","index":6,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,0,7,7]]}
[]
[null,null,"K from Grain Size Analysis Report",null,null,"Date:"]
[]
[null,null,"Sample Name:"]
[]
[null,null,{"$f":"Input!C5","v":"Mass Sample (g):"},{"$f":"Input!C6","v":0},null,{"$f":"Input!E5","v":"T (oC)"},{"$f":"Input!E6","v":20}]
[]
[{"$f":"Input!K2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Input!G$18","v":"Estimation of Hydraulic Conductivity"},{"$f":"Input!H$18","v":"cm/s"},{"$f":"Input!I$18","v":"m/s"},{"$f":"Input!J$18","v":"m/d"},"de"]
[null,null,"Hazen",{"$f":"IF(ISBLANK(Input!H19),\" \",Input!H19)","v":" "},{"$f":"IF(ISBLANK(Input!I19),\" \",Input!I19)","v":0},{"$f":"IF(ISBLANK(Input!J19),\" \",Input!J19)","v":0}]
[null,null,"Hazen K (cm/s) = d10 (mm)",{"$f":"IF(ISBLANK(Input!H20),\" \",Input!H20)","v":0},{"$f":"IF(ISBLANK(Input!I20),\" \",Input!I20)","v":0},{"$f":"IF(ISBLANK(Input!J20),\" \",Input!J20)","v":0}]
[null,null,"Slichter",{"$f":"IF(ISBLANK(Input!H21),\" \",Input!H21)","v":" "},{"$f":"IF(ISBLANK(Input!I21),\" \",Input!I21)","v":0},{"$f":"IF(ISBLANK(Input!J21),\" \",Input!J21)","v":0}]
[null,null,"Terzaghi",{"$f":"IF(ISBLANK(Input!H22),\" \",Input!H22)","v":" "},{"$f":"IF(ISBLANK(Input!I22),\" \",Input!I22)","v":0},{"$f":"IF(ISBLANK(Input!J22),\" \",Input!J22)","v":0}]
[null,null,"Beyer",{"$f":"IF(ISBLANK(Input!H23),\" \",Input!H23)","v":" "},{"$f":"IF(ISBLANK(Input!I23),\" \",Input!I23)","v":0},{"$f":"IF(ISBLANK(Input!J23),\" \",Input!J23)","v":0}]
[null,null,"Sauerbrei",{"$f":"IF(ISBLANK(Input!H24),\" \",Input!H24)","v":" "},{"$f":"IF(ISBLANK(Input!I24),\" \",Input!I24)","v":0},{"$f":"IF(ISBLANK(Input!J24),\" \",Input!J24)","v":0}]
[null,null,"Kruger",{"$f":"IF(ISBLANK(Input!H25),\" \",Input!H25)","v":" "},{"$f":"IF(ISBLANK(Input!I25),\" \",Input!I25)","v":0},{"$f":"IF(ISBLANK(Input!J25),\" \",Input!J25)","v":0}]
[null,null,"Kozeny-Carmen",{"$f":"IF(ISBLANK(Input!H26),\" \",Input!H26)","v":" "},{"$f":"IF(ISBLANK(Input!I26),\" \",Input!I26)","v":0},{"$f":"IF(ISBLANK(Input!J26),\" \",Input!J26)","v":0}]
[null,null,"Zunker",{"$f":"IF(ISBLANK(Input!H27),\" \",Input!H27)","v":" "},{"$f":"IF(ISBLANK(Input!I27),\" \",Input!I27)","v":0},{"$f":"IF(ISBLANK(Input!J27),\" \",Input!J27)","v":0}]
[null,null,"Zamarin",{"$f":"IF(ISBLANK(Input!H28),\" \",Input!H28)","v":" "},{"$f":"IF(ISBLANK(Input!I28),\" \",Input!I28)","v":0},{"$f":"IF(ISBLANK(Input!J28),\" \",Input!J28)","v":0}]
[null,null,"USBR",{"$f":"IF(ISBLANK(Input!H29),\" \",Input!H29)","v":" "},{"$f":"IF(ISBLANK(Input!I29),\" \",Input!I29)","v":0},{"$f":"IF(ISBLANK(Input!J29),\" \",Input!J29)","v":0}]
[null,null,"Barr",{"$f":"IF(ISBLANK(Input!H30),\" \",Input!H30)","v":" "},{"$f":"IF(ISBLANK(Input!I30),\" \",Input!I30)","v":0},{"$f":"IF(ISBLANK(Input!J30),\" \",Input!J30)","v":0}]
[null,null,"Alyamani and Sen",{"$f":"IF(ISBLANK(Input!H31),\" \",Input!H31)","v":" "},{"$f":"IF(ISBLANK(Input!I31),\" \",Input!I31)","v":0},{"$f":"IF(ISBLANK(Input!J31),\" \",Input!J31)","v":0}]
[null,null,"Chapuis",{"$f":"IF(ISBLANK(Input!H32),\" \",Input!H32)","v":" "},{"$f":"IF(ISBLANK(Input!I32),\" \",Input!I32)","v":0},{"$f":"IF(ISBLANK(Input!J32),\" \",Input!J32)","v":0}]
[null,null,"Krumbein and Monk",{"$f":"IF(ISBLANK(Input!H33),\" \",Input!H33)","v":" "},{"$f":"IF(ISBLANK(Input!I33),\" \",Input!I33)","v":0},{"$f":"IF(ISBLANK(Input!J33),\" \",Input!J33)","v":0}]
[null,null,"geometric mean",{"$f":"IF(ISBLANK(Input!H34),\" \",Input!H34)","v":{"$error":"#NUM!"}},{"$f":"IF(ISBLANK(Input!I34),\" \",Input!I34)","v":{"$error":"#NUM!"}},{"$f":"IF(ISBLANK(Input!J34),\" \",Input!J34)","v":{"$error":"#NUM!"}}]
[null,null,"arithmetic mean",{"$f":"IF(ISBLANK(Input!H35),\" \",Input!H35)","v":0},{"$f":"IF(ISBLANK(Input!I35),\" \",Input!I35)","v":0},{"$f":"IF(ISBLANK(Input!J35),\" \",Input!J35)","v":0}]