{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Input","Examples","Equations","References"," Report Grain Size","Report K"],"not_rendered":{"charts":6,"images":15,"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":0},"Hazen",{"$f":"IF($AB3>0,$AB3*H19,\" \")","v":" "},{"$f":"IF($AB3>0,$AB3*I19,\" \")","v":" "}," ",null,"Hazen",{"$f":"IF($AB3=0,H19,\" \")","v":0},{"$f":"IF($AB3=0,I19,\" \")","v":0},0,null,{"$f":"$J$35","v":{"$error":"#DIV/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,null,null,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":{"$error":"#DIV/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,0,"Slichter"," "," "," ",null,"Slichter",0,0,0,null,{"$error":"#DIV/0!"},{"$error":"#NUM!"}]
[null,null,0,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Terzaghi"," "," "," ",null,"Terzaghi",0,0,0,null,{"$error":"#DIV/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,0,"Beyer"," "," "," ",null,"Beyer",0,0,0,null,{"$error":"#DIV/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,null,null,null,null,null,null,0,"Sauerbrei"," "," "," ",null,"Sauerbrei",0,0,0,null,{"$error":"#DIV/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,null,null,null,null,null,null,0,"Kruger"," "," "," ",null,"Kruger",0,0,0,null,{"$error":"#DIV/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!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Kozeny-Carmen"," "," "," ",null,"Kozeny-Carmen",0,0,0,null,{"$error":"#DIV/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,0,"Zunker"," "," "," ",null,"Zunker",0,0,0,null,{"$error":"#DIV/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,0,"Zamarin"," "," "," ",null,"Zamarin",0,0,0,null,{"$error":"#DIV/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,0,"USBR"," "," "," ",null,"USBR",0,0,0,null,{"$error":"#DIV/0!"},{"$error":"#NUM!"}]
[" ",null,null,null,null,null,null,null,null,null,"dgeometric mean",{"$f":"2^((N17+N18+N19)/3)","v":{"$error":"#NUM!"}},"rg/m (1/cm s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Barr"," "," "," ",null,"Barr",0,0,0,null,{"$error":"#DIV/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,0,"Alyamani and Sen"," "," "," ",null,"Alyamani and Sen",0,0,0,null,{"$error":"#DIV/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,{"$error":"#DIV/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,0,"Krumbein and Monk"," "," "," ",null,"Krumbein and Monk",0,0,0,null,{"$error":"#DIV/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,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":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AE3:AE17)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/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,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,null,"Beyer",null,0,0,null,">64","Boulder"]
[" ",null,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,null,"Kozeny-Carmen",null,0,0,null,"2  - 8","fine gravel"]
[" ",null,null,null,null,null,"Zunker",null,0,0,null,"0.5 - 2","coarse sand"]
[" ",null,null,null,null,null,"Zamarin",null,0,0,null,"0.25 - 0.5","medium sand"]
[" ",null,null,null,null,null,"USBR",null,0,0,null,"0.063 - 0.25","fine sand"]
[" ",null,null,null,null,null,"Barr",null,0,0,null,"0.016 - 0.063","coarse silt"]
[" ",null,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,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":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[{"$f":"IF(ISBLANK(B72),\" \",3.3193*LOG(B72))","v":" "}]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]

{"sheet":"Examples","index":2,"n_rows":47,"n_cols":10,"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"]
["ps",null,null,"pp",null,null,"ps",null,null,"pp"]
[2,null,null,100,null,null,10,null,null,85.23]
[0.82,null,null,80,null,null,4.75,null,null,79.569999999999993]
[0.55000000000000004,null,null,60,null,null,2.36,null,null,66.73]
[0.42,null,null,40,null,null,1.18,null,null,49.99]
[0.28000000000000003,null,null,20,null,null,0.6,null,null,30.75]
[0.15,null,null,10,null,null,0.42499999999999999,null,null,17.55]
[4.4999999999999998E-2,null,null,0,null,null,0.3,null,null,6.28]
[null,null,null,null,null,null,0.15,null,null,2.84]
["Example 1 Case 2 Vukovic 15 oC",null,null,null,null,null,7.4999999999999997E-2,null,null,0]
["ps",null,null,"pp"]
[2,null,null,100]
[1.5,null,null,95,null,null,"Sample 2 Odong 20 oC"]
[1.2,null,null,90,null,null,"ps",null,null,"pp"]
[0.95,null,null,85,null,null,1.18,null,null,100]
[0.82,null,null,80,null,null,0.6,null,null,96.2]
[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]
[0.6,null,null,65,null,null,0.21199999999999999,null,null,18.88]
[0.55000000000000004,null,null,60,null,null,0.15,null,null,2.2999999999999998]
[0.51,null,null,55,null,null,7.4999999999999997E-2,null,null,0]
[0.48,null,null,50]
[0.45,null,null,45,null,null,"Sample 3 Odong 20 oC"]
[0.42,null,null,40,null,null,"ps",null,null,"pp"]
[0.39,null,null,35,null,null,4.75,null,null,95.05]
[0.36,null,null,30,null,null,2.36,null,null,85.08]
[0.32,null,null,25,null,null,2,null,null,82.02]
[0.28000000000000003,null,null,20,null,null,1.18,null,null,64.66]
[0.22,null,null,15,null,null,0.6,null,null,44.76]
[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":201,"n_cols":26,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9500000000000028,100.53432846145373]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9250000000000025,100.79155753856324]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9000000000000021,101.04220970860439]
[null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8750000000000018,101.28631986808458]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8500000000000014,101.52392291351114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8250000000000011,101.75505374139159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8000000000000007,101.97974724823327]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7750000000000004,102.19803833054354]
[null,null,null,null,null,null,null,null,null,null,null,null,null,980,null,null,null,null,null,null,null,null,null,null,4.75,102.4099618848299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.99813600000000002,null,null,null,null,null,null,null,null,null,null,4.7249999999999996,102.61555280759967]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6999999999999993,102.8148459953603]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6749999999999989,103.00787634461916]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6499999999999986,103.19467875188364]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6249999999999982,103.37528811366121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5999999999999979,103.54973932645922]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5749999999999975,103.71806728678509]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5499999999999972,103.8803068911462]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5249999999999968,104.03649303604995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4999999999999964,104.18666061800381]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4749999999999961,104.33084453351506]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4499999999999957,104.46907967909122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4249999999999954,104.60140095123963]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.399999999999995,104.72784324646767]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3749999999999947,104.84844146128285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3499999999999943,104.96323049219244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.324999999999994,105.07224523570393]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2999999999999936,105.17552058832469]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2749999999999932,105.27309144656208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2499999999999929,105.36499270692363]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2249999999999925,105.45125926591659]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1999999999999922,105.53192602004845]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1749999999999918,105.60702786582661]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1499999999999915,105.67659969975843]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1249999999999911,105.74067641835136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999908,105.79929291811276]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0749999999999904,105.85248409555005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0499999999999901,105.90028484717065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0249999999999897,105.94273006948194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9999999999999898,105.97985465899131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9749999999999899,106.01169351220621]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.94999999999999,106.03828152563399]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9249999999999901,106.05965359578207]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8999999999999901,106.07584461915786]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8749999999999902,106.08688949226875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8499999999999903,106.09282311162217]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8249999999999904,106.09368037372548]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7999999999999905,106.0894961750861]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7749999999999906,106.08030541221144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7499999999999907,106.06614298160889]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7249999999999908,106.04704377978587]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6999999999999909,106.02304270324977]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6749999999999909,105.99417464850799]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.649999999999991,105.96047451206793]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6249999999999911,105.921977190437]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5999999999999912,105.87871758012261]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5749999999999913,105.83073057763214]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5499999999999914,105.77805107947299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5249999999999915,105.72071398215259]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4999999999999916,105.65875418217833]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4749999999999917,105.59220657605759]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4499999999999917,105.52110606029781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4249999999999918,105.44548753140636]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3999999999999919,105.36538588589065]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.374999999999992,105.28083602025809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3499999999999921,105.19187283101608]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3249999999999922,105.09853121467202]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2999999999999923,105.00084606773331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2749999999999924,104.89885228670735]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2499999999999925,104.79258476810156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2249999999999925,104.68207840842332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1999999999999926,104.56736810418003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1749999999999927,104.44848875187911]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1499999999999928,104.32547524802797]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1249999999999929,104.19836248913398]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.099999999999993,104.06718537170455]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0749999999999931,103.93197879224711]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0499999999999932,103.79277764726903]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0249999999999932,103.64961683327772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9999999999999933,103.50253124678059]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9749999999999934,103.35155578428503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9499999999999935,103.19672534229846]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9249999999999936,103.03807481732827]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8999999999999937,102.87563910588185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8749999999999938,102.70945310446662]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8499999999999939,102.53955170958999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.824999999999994,102.36596981775934]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.799999999999994,102.1887423254821]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7749999999999941,102.00790412926564]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7499999999999942,101.82349012561737]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7249999999999943,101.63553521104468]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6999999999999944,101.44407428205503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6749999999999945,101.24914223515574]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6499999999999946,101.05077396685428]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6249999999999947,100.84900437365802]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5999999999999948,100.64386835207436]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5749999999999948,100.43540079861071]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5499999999999949,100.22363660977447]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.524999999999995,100.00861068207305]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4999999999999951,99.790357912013846]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4749999999999952,99.568913196104248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4499999999999953,99.344311430851675]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4249999999999954,99.116587512763516]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3999999999999955,98.885776338347185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3749999999999956,98.651912804110083]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3499999999999956,98.415031806559611]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3249999999999957,98.175168242203156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999958,97.932357007548148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2749999999999959,97.68663299910196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.249999999999996,97.438031113371991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2249999999999961,97.186586246865687]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1999999999999962,96.932333296090405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1749999999999963,96.675307157553576]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1499999999999964,96.415542727762571]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1249999999999964,96.15307490322482]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0999999999999965,95.887938580447738]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0749999999999966,95.62016865593867]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0499999999999967,95.349800026205074]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0249999999999968,95.076867587754322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9999999999999969,94.801406237093815]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.974999999999997,94.523450870730969]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9499999999999971,94.243036385173198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9249999999999972,93.960197676927862]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8999999999999972,93.674969642502404]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8749999999999973,93.387387178404197]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8499999999999974,93.097485181140669]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8249999999999975,92.805298547219209]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7999999999999976,92.510862173147203]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7749999999999977,92.21421095543208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7499999999999978,91.915379790581241]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7249999999999979,91.61440357510206]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.699999999999998,91.311317205501979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.674999999999998,91.006155578288357]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6499999999999981,90.698953589968625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6249999999999982,90.389746137050182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5999999999999983,90.078568116040415]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5749999999999984,89.765454423446727]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5499999999999985,89.450439955776545]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5249999999999986,89.133559609537244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999987,88.814848281236237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4749999999999988,88.494340867380927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4499999999999988,88.172072264478714]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4249999999999989,87.848077369037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.399999999999999,87.522391077563199]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3749999999999991,87.195048286564699]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3499999999999992,86.866083892548886]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3249999999999993,86.53553279202319]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2999999999999994,86.203429881495012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2749999999999995,85.869810057471724]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2499999999999996,85.534708216460771]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2249999999999996,85.198159254969539]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1999999999999997,84.860198069505401]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1749999999999998,84.5208595565758]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1499999999999999,84.18017861268811]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.125,83.838190134349745]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,83.49492901806812]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0750000000000002,83.150430160350595]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0500000000000003,82.804728457704627]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0250000000000004,82.45785880663756]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0000000000000004,82.109856103656838]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97500000000000053,81.760755245269863]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95000000000000051,81.410591127984006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92500000000000049,81.059398648306697]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.90000000000000047,80.707212702745323]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87500000000000044,80.3540681878073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85000000000000042,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8250000000000004,79.611494949440555]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.80000000000000038,79.156688737489446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77500000000000036,78.638089597519325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75000000000000033,78.058205762902688]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72500000000000031,77.419545467012171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70000000000000029,76.724616943220354]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67500000000000027,75.975928424899806]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65000000000000024,75.175988145423105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62500000000000022,74.327304338162847]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6000000000000002,73.432385236491598]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57500000000000018,72.493739073781953]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000016,71.513874083406506]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52500000000000013,70.49529849873781]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.50000000000000011,69.44052055314846]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.47500000000000014,68.352048480011035]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45000000000000012,67.232390512698146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4250000000000001,66.084054884582329]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.40000000000000008,64.909549829036195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37500000000000006,63.711383579432301]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35000000000000003,62.49206436914325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32500000000000001,61.254100431541623]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27499999999999997,58.4798998688577]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24999999999999997,56.473329286368582]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22499999999999998,54.026885166776985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19999999999999998,51.187164424327285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17499999999999999,48.00076397326383]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,44.514280727830972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.125,40.774311602273087]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,36.549975598496019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5000000000000011E-2,31.054118487428756]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,23.835050499986224]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,14.490623195901501]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]

{"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."]
[]
[{"$f":"A22+1","v":22},"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."]
[23,"Zamarin, J.A.  1928.  Calculation of ground-water flow (in Russian).  Trudey I.V.H. Taskeni."]
[24,"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":{"$error":"#NUM!"}}]
[{"$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"}]
[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":{"$error":"#DIV/0!"}},{"$f":"IF(ISBLANK(Input!I35),\" \",Input!I35)","v":{"$error":"#DIV/0!"}},{"$f":"IF(ISBLANK(Input!J35),\" \",Input!J35)","v":{"$error":"#DIV/0!"}}]