{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Input","Examples","Equations","References"," Report Grain Size","Report K"],"not_rendered":{"charts":6,"images":18,"macros":1,"external_links":0,"defined_names":28,"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":176,"n_cols":40,"rows_kept":176,"cut":false,"hidden":false,"merged":[[1,10,6,13]]}
[]
[null,null,null,null,null,null,null,null,null,null," Moderately well sorted  sand low in fines ",null,null,null,null,null,null,null,null,null,"Shephard","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,142.80000000000001,1.5499999999999999E-3,8.3999999999999995E-3,4.0200000000000001E-3,1.9151279557956367,100.78451695560115,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":3.0006144042093508E-2},{"$f":"IF($AB3=0,I19,\" \")","v":3.0006144042093509E-4},25.925308452368792,null,{"$f":"$J$36","v":26.957224663601917},{"$f":"$J$35","v":22.145764270745261}]
[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,1.8740522534258721,101.02196189158053,null,{"$f":"IF(ISBLANK(F20)=FALSE,1,0)","v":1},"Hazen K (cm/s) = d102 (mm2)",{"$f":"IF($AB4>0,$AB4*H20,\" \")","v":2.2499999999999999E-2},{"$f":"IF($AB4>0,$AB4*I20,\" \")","v":2.2499999999999999E-4},{"$f":"IF($AB4>0,$AB4*J20,\" \")","v":19.440000000000001},null,"Hazen K (cm/s) = d102 (mm2)",{"$f":"IF($AB4=0,H20,\" \")","v":" "},{"$f":"IF($AB4=0,I20,\" \")","v":" "},{"$f":"IF($AB4=0,J20,\" \")","v":" "},null,26.957224663601917,22.145764270745261]
[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,1.8338575435349984,101.16634149173996,null,1,"Slichter",9.5963209315535949E-3,9.5963209315535949E-5,8.2912212848623064,null,"Slichter"," "," "," ",null,26.957224663601917,22.145764270745261]
[null,null,100,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.15,0.15,1.7945249305788595,101.22466523369,null,0,"Terzaghi"," "," "," ",null,"Terzaghi",1.6695337658127831E-2,1.669533765812783E-4,14.424771736622445,null,26.957224663601917,22.145764270745261]
["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,1.7560359242853054,101.20349888710568,null,1,"Beyer",2.4807909969877112E-2,2.4807909969877111E-4,21.43403421397382,null,"Beyer"," "," "," ",null,26.957224663601917,22.145764270745261]
[{"$f":"IF(ISBLANK(B8),\" \",3.3193*LOG(B8))","v":0.99920886460745284},2,0,0,100,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,1.7183724309619097,101.10899155668706,null,1,"Sauerbrei",3.3908920426943837E-2,3.3908920426943838E-4,29.297307248879473,null,"Sauerbrei"," "," "," ",null,26.957224663601917,22.145764270745261]
[-0.2860776797827293,0.82,20,0.2,80,null,null,null,null,null,"d10",0.15,"Uniformity Coef.",{"$f":"L13/L9","v":3.666666666666667},null,null,null,null,null,null,null,0,{"$f":"2^((N17+N18+N19)/3)","v":0.48887256556762343},null,1.6815167449901196,100.94690108164282,null,0,"Kruger"," "," "," ",null,"Kruger",5.162397278775268E-2,5.1623972787752685E-4,44.603112488618315,null,26.957224663601917,22.145764270745261]
[-0.86181412476175634,0.55000000000000004,20,0.2,60,null,null,null,null,null,"d17",0.24100000000000002,"n computed",{"$f":"0.255*(1+0.83^N9)","v":0.38377350574709118},{"$f":"IF(V9>0,V9,0.255*(1+0.83^N9))","v":0.38377350574709118},null,null,null,null,null,null,null,null,null,1.6454515405018406,100.72261789220805,null,0,"Kozeny-Carmen"," "," "," ",null,"Kozeny-Carmen",0.10326466562081722,1.0326466562081721E-3,89.220671096386084,null,26.957224663601917,22.145764270745261]
[-1.2505486303822491,0.42,20,0.2,40,null,null,null,null,null,"d20",0.28000000000000003,"g (cm/s2)",980,null,null,null,null,null,null,null,null,null,null,1.6101598632345404,100.44118741751555,null,1,"Zunker",5.6403675932494818E-2,5.6403675932494815E-4,48.732776005675518,null,"Zunker"," "," "," ",null,26.957224663601917,22.145764270745261]
[-1.8350483465657719,0.28000000000000003,20,0.2,20,null,null,null,null,null,"d50",0.48499999999999999,"r (g/cm3)",0.99813600000000002,null,null,null,null,null,null,null,null,null,null,1.5756251225610456,100.10733113332977,null,1,"Zamarin",6.6457521399872599E-2,6.6457521399872601E-4,57.419298489489933,null,"Zamarin"," "," "," ",null,26.957224663601917,22.145764270745261]
[-2.7348002838164773,0.15,10,0.1,10,null,null,null,null,null,"d60",0.55000000000000004,"m (g/cm s)",9.8479999999999991E-3,null,null,null,null,null,null,null,null,null,null,1.5418310836902833,99.725466332704173,null,1,"USBR",2.5513642444225246E-2,2.5513642444225244E-4,22.043787071810613,null,"USBR"," "," "," ",null,26.957224663601917,22.145764270745261]
[-4.470391703025502,4.4999999999999998E-2,10,0.1,0,null,null,null,null,null,"dgeometric mean",0.44970904468378892,"rg/m (1/cm s)",99327.099918765234,null,null,null,null,null,null,null,null,null,null,1.5087618600353019,99.299724697511039,null,1,"Barr",1.3372744950630731E-2,1.337274495063073E-4,11.55405163734495,null,"Barr"," "," "," ",null,26.957224663601917,22.145764270745261]
[" ",null,null,null,null,null,null,null,null,null,"de (Kruger)",0.34383499566902992,"tau (Sauerbrei)",1.0530200000000001,null,null,null,null,null,null,null,null,null,null,1.4764019057449811,98.833969743997841,null,1,"Alyamani and Sen",8.3791178385416651E-3,8.3791178385416652E-5,7.2395578124999993,null,"Alyamani and Sen"," "," "," ",null,26.957224663601917,22.145764270745261]
[" ",null,null,null,null,null,null,null,null,null,"de (Kozeny)",0.29008871223808247,"d5f",-3.3584655152414449,null,null,null,null,null,null,null,null,null,null,1.4447360083959242,98.331813211027097,null,0,"Chapuis"," "," "," ",null,"Chapuis",1.7386448385766098E-2,1.73864483857661E-4,15.021891405301911,null,26.957224663601917,22.145764270745261]
[" ",null,null,null,null,null,null,null,null,null,"de (Zunker)",0.30734018950367153,"d16f",-2.1329016020949574,null,null,null,null,null,null,null,null,null,null,1.4137492818410928,97.796630455436159,null,1,"Krumbein and Monk",3.218278355174381E-2,{"$f":"IF($AB17>0,$AB17*I33,\" \")","v":3.2182783551743812E-4},27.805924988706654,null,"Krumbein and Monk",{"$f":"IF($AB17=0,H33,\" \")","v":" "}," "," ",null,26.957224663601917,22.145764270745261]
[" ",null,null,null,null,null,"Estimation of Hydraulic Conductivity","cm/s","m/s","m/d","de (Zamarin)",0.32596413045467088,"d50f",{"$f":"3.3193*LOG(L12)","v":-1.0431174470575064},null,null,null,null,null,null,null,null,null,null,1.3834271592118257,97.231574914996159,null,1,"Shepherd",5.0082769150900264E-2,5.0082769150900264E-4,43.271512546377828,null,"Shepherd"," "," "," ",null,26.957224663601917,22.145764270745261]
[" ",null,null,null,null,null,"Hazen",3.0006144042093508E-2,{"$f":"H19/100","v":3.0006144042093509E-4},{"$f":"H19/100*24*60*60","v":25.925308452368792},"Io (Alyameni)",{"$f":"IF(L9-10*(L12-L9)/40<0,0,L9-10*(L12-L9)/40)","v":6.6250000000000003E-2},"d84f",7.8610104909327475E-2,null,null,null,null,null,null,null,null,null,null,1.3537553860699494,96.639591695734921,null,null,"geometric mean",{"$f":"GEOMEAN(AD3:AD18)","v":2.5631671609658867E-2},2.5631671609658869E-4,{"$f":"GEOMEAN(AF3:AF18)","v":22.145764270745261}]
[" ",null,null,null,null,"ü","Hazen K (cm/s) = d102 (mm2)",{"$f":"L9^2","v":2.2499999999999999E-2},{"$f":"H20/100","v":2.2499999999999999E-4},{"$f":"H20/100*24*60*60","v":19.440000000000001},null,null,"d95f",0.76977438525807729,null,null,null,null,null,null,null,null,null,null,1.3247200137067627,96.023430336905548,null,null,"arithmetic mean",{"$f":"AVERAGE(AD3:AD18)","v":3.1200491508798514E-2},3.1200491508798521E-4,{"$f":"AVERAGE(AF3:AF18)","v":26.957224663601917}]
[{"$f":"IF(ISBLANK(B21),\" \",3.3193*LOG(B21))","v":" "},null,null,null,null,"ü","Slichter",9.5963209315535949E-3,9.5963209315535949E-5,{"$f":"H21/100*24*60*60","v":8.2912212848623064},null,null,"sf",{"$f":"(N19-N17)/4+(N20-N16)/6.6","v":1.1783688207661502},null,null,null,null,null,null,null,null,null,null,1.2963073925857458,95.385656803613529]
[" ",null,null,null,null,null,"Terzaghi",1.6695337658127831E-2,1.669533765812783E-4,{"$f":"H22/100*24*60*60","v":14.424771736622445},null,"mm",null,"% in sample",null,null,null,null,null,null,null,null,null,null,1.2685041659259082,94.728664754048879]
[" ",null,null,null,null,"ü","Beyer",2.4807909969877112E-2,2.4807909969877111E-4,21.43403421397382,null,">64","Boulder",null,null,null,null,null,null,null,null,null,null,null,1.2412972634227635,94.054686125392692]
[" ",null,null,null,null,"ü","Sauerbrei",3.3908920426943837E-2,3.3908920426943838E-4,29.297307248879473,null,"16 - 64","coarse gravel",null,null,null,null,null,null,null,null,null,null,null,1.2146738951039746,93.365801079768104]
[" ",null,null,null,null,null,"Kruger",5.162397278775268E-2,5.1623972787752685E-4,44.603112488618315,null,"8 - 16","medium gravel",null,null,null,null,null,null,null,null,null,null,null,1.188621545316785,92.663947349072913]
[" ",null,null,null,null,null,"Kozeny-Carmen",0.10326466562081722,1.0326466562081721E-3,89.220671096386084,null,"2  - 8","fine gravel",0,null,null,null,null,null,null,null,null,null,null,1.1631279668444066,91.950929015154387]
[" ",null,null,null,null,"ü","Zunker",5.6403675932494818E-2,5.6403675932494815E-4,48.732776005675518,null,"0.5 - 2","coarse sand",40,null,null,null,null,null,null,null,null,null,null,1.1381811751485997,91.228424759557043]
[" ",null,null,null,null,"ü","Zamarin",6.6457521399872599E-2,6.6457521399872601E-4,57.419298489489933,null,"0.25 - 0.5","medium sand",40,null,null,null,null,null,null,null,null,null,null,1.1137694427357387,90.49799561498169]
[" ",null,null,null,null,"ü","USBR",2.5513642444225246E-2,2.5513642444225244E-4,22.043787071810613,null,"0.063 - 0.25","fine sand",10,null,null,null,null,null,null,null,null,null,null,1.0898812936437134,89.761092248630135]
[" ",null,null,null,null,"ü","Barr",1.3372744950630731E-2,1.337274495063073E-4,11.55405163734495,null,"0.016 - 0.063","coarse silt",10,null,null,null,null,null,null,null,null,null,null,1.0665054980470769,89.019061805768018]
[" ",null,null,null,null,"ü","Alyamani and Sen",8.3791178385416651E-3,8.3791178385416652E-5,7.2395578124999993,null,"0.008 - 0.016","medium silt",null,null,null,null,null,null,null,null,null,null,null,1.043631066977901,88.27315434010832]
[" ",null,null,null,null,null,"Chapuis",1.7386448385766098E-2,1.73864483857661E-4,15.021891405301911,null,"0.002 - 0.008","fine silt",null,null,null,null,null,null,null,null,null,null,null,1.0212472471598593,87.524528855996152]
[" ",null,null,null,null,"ü","Krumbein and Monk",3.218278355174381E-2,{"$f":"H33/100","v":3.2182783551743812E-4},{"$f":"H33/100*24*60*60","v":27.805924988706654},null,"<0.002","clay",null,null,null,null,null,null,null,null,null,null,null,0.99934351595310955,86.774258985851816]
[" ",null,null,null,null,"ü","Shepherd",5.0082769150900264E-2,{"$f":"H34/100","v":5.0082769150900264E-4},{"$f":"H34/100*24*60*60","v":43.271512546377828},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97790957640759746,86.023338324900379]
[" ",null,null,null,null,null,"geometric mean",{"$f":"AD19","v":2.5631671609658867E-2},2.5631671609658869E-4,22.145764270745261,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95693535242245753,85.272685443874494]
[" ",null,null,null,null,null,"arithmetic mean",3.1200491508798514E-2,3.1200491508798521E-4,26.957224663601917,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9364109840092355,84.523148599117789]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91632682265670495,83.775510158335237]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89667342679509954,83.030490759126806]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87744155735762863,82.288753216400536]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85862217343718916,81.550906193782765]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84020642803623291,80.81750765322704]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82218566390779046,80.089068096161142]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.80455140948569726,79.368495576033368]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78729537490210755,78.651259602538346]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77040944809042566,77.924121343831828]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75388569097182112,77.175468985720102]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73771633572353545,76.395253724149015]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72189378112722691,75.574849335898463]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70641058899563547,74.706922518765651]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69125948067588883,73.785313238220851]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67643333362780578,72.804924369234229]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66192517807558826,71.761619970274936]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64772819373132784,70.652131571593415]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63383570658878607,69.473971902023024]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62024118578594289,68.225355517872117]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.60693824053483625,66.905125834203517]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.59392061711725097,65.512688093085018]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.58118219594484433,64.047947835401388]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56871698868232556,62.511254472694418]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.556519135432338,60.903349583379736]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54458290198071957,59.229326901591044]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53290267710084749,57.523861163447236]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52147296991579872,55.805517535734936]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51028840731708736,54.086364535002026]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4993437314387647,52.377100971992675]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48863379718569538,50.687170911454047]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.47815356981484636,49.024870113677252]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46789812256845315,47.397444549769745]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45786263435794933,45.81118154299066]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44804238749757169,44.271494051413463]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43843276548657495,42.782998572545438]
[{"$f":"IF(ISBLANK(B72),\" \",3.3193*LOG(B72))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42902925083901317,41.349587118173432]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41982742296006864,39.974484827575715]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41082295606792896,38.635247126685805]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4020116171602357,37.312485762431848]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39338926402414914,36.010372201971741]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38495184328909254,34.732544208747349]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37669538852126172,33.482152023996107]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.36861601835900332,32.261901083540941]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3607099346881858,31.074091512154006]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35297342085670469,29.920654621497189]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34540283992728366,28.803186622421272]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33799463296774906,27.722979748183711]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33074531737797525,26.681050971860749]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32365148525271292,25.678168488819097]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3167098017795324,24.714876123521744]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3099170036711269,23.791515809116309]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30326989763124051,22.90824827814437]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29676535885349892,22.065072093269364]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29040032955243672,21.261841138105183]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28417181752603177,20.498280679997613]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27807689474907044,19.775549053781873]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2721126959966817,19.112944244421051]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.26627641749739456,18.510480565210202]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.26056531561508395,17.961123568422]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.254976705559187,17.458472472244843]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24950796012258189,16.996711030442739]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24415650844653741,16.570561911783074]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23891983481215129,16.175244350040209]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23379547745771015,15.806434841227762]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22878102742141471,15.460230679526497]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22387412740892607,15.133116137223352]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21907247068520111,14.821931106923431]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21437379999009562,14.523842036398241]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20977590647722572,14.236314997744808]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20527662867558857,13.957090743102468]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20087385147345427,13.684161609054694]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19656550512405122,13.41575014107713]
[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.19234956427257763,13.150289318021605]
[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.18822404700408166,12.886404264688656]
[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.18418701391176268,12.622895348074342]
[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.18023656718525552,12.358722559915357]
[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.17637084971846942,12.092991094731667]
[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.17258804423656179,11.824938038707895]
[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.16888637244163696,11.55392009049195]
[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.1652640941767678,11.279402240347757]
[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.1617195066079474,11.000947339103377]
[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.15825094342358645,10.718206493009056]
[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.15485677405117962,10.43091022498346]
[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.151535402890773,10.138860346800646]
[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.14828526856487217,9.8435505728359018]
[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.14510484318443809,9.5535023048848]
[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.1419926316306262,9.2697633869247635]
[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.13894717085193056,8.9921125316773729]
[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.13596702917640288,8.7203420233097475]
[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.13305080563862329,8.4542567258103745]
[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.13019712932110591,8.1936731628931749]
[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.12740465870983039,7.9384186644699568]
[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.12467208106359565,7.6883305750644926]
[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.1219981117968999,7.4432555198527224]
[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.11938149387605669,7.2030487243044634]
[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.11682099722826297,6.9675733836735834]
[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.11431541816334161,6.7367000788373925]
[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.11186357880788622,6.5103062352229362]
[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.1094643265515426,6.288275621779289]
[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.1071165335051663,6.0704978871615793]
[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.10481909597060159,5.856868130485493]
[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.10257093392183264,5.6472865041912419]
[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.10037099049726307,5.4416578467241941]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.8218231502884959E-2,5.2398913428964153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.6111644926103967E-2,5.0419002099400254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4050240459991941E-2,4.8476014074000506]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.203304903774337E-2,4.6569153691422045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.0059122377116801E-2,4.4697657558701485]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.8127532534647085E-2,4.2860792266580141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.6237371469418941E-2,4.105785228107715]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.4387750616196605E-2,3.9288157998372792]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.2577800467709156E-2,3.7551053950968032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.0806670165894809E-2,3.5845907153927188]
[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.90735271019124E-2,3.4172105580796592]
[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.7377556524731689E-2,3.2529056759523369]
[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.5717961158118671E-2,3.091618647938148]
[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.4093960825835845E-2,2.933293760054831]
[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.2504792084881087E-2,2.7778768958567688]
[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.0949707866592937E-2,2.6253154356488451]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.9427977125453427E-2,2.4755581637982056]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.7938884495423305E-2,2.3285551835222722]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6481729953648344E-2,2.184257838576074]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5055828491378365E-2,2.0426186413035103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3660509791944458E-2,1.9035912065560163]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.2295117915642899E-2,1.7671301910180961]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.0959010991377745E-2,1.6331912375128659]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.9651560914917044E-2,1.5017309238919581]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8372153053620875E-2,1.372706716143268]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.7120185957502352E-2,1.2460769253770931]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5895071076485843E-2,1.121800668376391]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.4696232483729408E-2,0.99983783142031246]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3523106604881417E-2,0.88014903711193893]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2375141953144133E-2,0.7626956139614145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1251798870019571E-2,0.64743956849445095]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0152549271615929E-2,0.53434355967371006]
[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.9076876400395167E-2,0.42337087543677465]
[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.8024274582245188E-2,0.31448541116953826]
[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.6994248988762262E-2,0.20765164994782365]
[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.5986315404632085E-2,0.10283464439307369]
[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.4999999999999998E-2,0]

{"sheet":"Examples","index":2,"n_rows":47,"n_cols":24,"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",null,null,null,null,null,null,"Sample 1 Alyamani and Sen"]
["ps",null,null,"pp",null,null,"ps",null,null,"pp",null,null,"ps",null,null,"pp",null,null,null,"ps",null,null,"pp"]
[2,null,null,100,null,null,10,null,null,85.23,null,null,10,null,null,99.99,null,null,null,3.7,null,null,95]
[0.82,null,null,80,null,null,4.75,null,null,79.569999999999993,null,null,9,null,null,99.9,null,null,null,2.82,null,null,90]
[0.55000000000000004,null,null,60,null,null,2.36,null,null,66.73,null,null,3,null,null,99.8,null,null,null,2,null,null,85]
[0.42,null,null,40,null,null,1.18,null,null,49.99,null,null,1.3,null,null,98,null,null,null,1.81,null,null,80]
[0.28000000000000003,null,null,20,null,null,0.6,null,null,30.75,null,null,0.8,null,null,97,null,null,null,1.7,null,null,75]
[0.15,null,null,10,null,null,0.42499999999999999,null,null,17.55,null,null,0.4,null,null,95,null,null,null,1.52,null,null,70]
[4.4999999999999998E-2,null,null,0,null,null,0.3,null,null,6.28,null,null,0.23,null,null,82,null,null,null,1.48,null,null,65]
[null,null,null,null,null,null,0.15,null,null,2.84,null,null,0.15,null,null,31,null,null,null,1.31,null,null,60]
["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,null,null,null,1.1200000000000001,null,null,55]
["ps",null,null,"pp",null,null,null,null,null,null,null,null,0.04,null,null,2.6,null,null,null,0.95,null,null,50]
[2,null,null,100,null,null,null,null,null,null,null,null,2.7E-2,null,null,2.6,null,null,null,0.92,null,null,45]
[1.5,null,null,95,null,null,"Sample 2 Odong 20 oC",null,null,null,null,null,1.7000000000000001E-2,null,null,2.6,null,null,null,0.86,null,null,40]
[1.2,null,null,90,null,null,"ps",null,null,"pp",null,null,0.01,null,null,2.5,null,null,null,0.8,null,null,35]
[0.95,null,null,85,null,null,1.18,null,null,100,null,null,5.4999999999999997E-3,null,null,1,null,null,null,0.75,null,null,30]
[0.82,null,null,80,null,null,0.6,null,null,96.2,null,null,2E-3,null,null,0,null,null,null,0.61,null,null,25]
[0.73,null,null,75,null,null,0.42499999999999999,null,null,77.650000000000006,null,null,null,null,null,null,null,null,null,0.55000000000000004,null,null,20]
[0.66,null,null,70,null,null,0.3,null,null,48.41,null,null,"Schillig PVP4-5, elev 289.5 masl",null,null,null,null,null,null,0.5,null,null,15]
[0.6,null,null,65,null,null,0.21199999999999999,null,null,18.88,null,null,10,0,"total weight",110.69,null,null,null,0.4,null,null,10]
[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",null,null,null,null,0.3,null,null,5]
[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,null,null,null,null,null,"Paul Van Horne <Paul.VanHorne@shanwil.com>"]
[0.45,null,null,45,null,null,"Sample 3 Odong 20 oC",null,null,null,null,null,1,11.81,null,null,null,null,null,"ps",null,null,"pp","total mass: 417.54 g"]
[0.42,null,null,40,null,null,"ps",null,null,"pp",null,null,0.5,7.51,null,null,null,null,null,38.1,null,null,100]
[0.39,null,null,35,null,null,4.75,null,null,95.05,null,null,0.29699999999999999,3.56,null,null,null,null,null,25.4,null,null,91.028400000000005]
[0.36,null,null,30,null,null,2.36,null,null,85.08,null,null,0.17699999999999999,2.38,null,null,null,null,null,19,null,null,88.920820000000006]
[0.32,null,null,25,null,null,2,null,null,82.02,null,null,0.125,2.97,null,null,null,null,null,12.5,null,null,77.805719999999994]
[0.28000000000000003,null,null,20,null,null,1.18,null,null,64.66,null,null,6.3E-2,2.2799999999999998,null,null,null,null,null,9.5,null,null,76.500460000000004]
[0.22,null,null,15,null,null,0.6,null,null,44.76,null,null,0.01,1.54,null,null,null,null,null,4.75,null,null,70.110650000000007]
[0.15,null,null,10,null,null,0.42499999999999999,null,null,23.42,null,null,null,null,null,null,null,null,null,2,null,null,64.580640000000002]
[0.08,null,null,5,null,null,0.3,null,null,7.96,null,null,null,null,null,null,null,null,null,0.85,null,null,60.39987]
[4.4999999999999998E-2,null,null,0,null,null,0.15,null,null,2.11,null,null,null,null,null,null,null,null,null,0.42499999999999999,null,null,56.573230000000002]
[null,null,null,null,null,null,7.4999999999999997E-2,null,null,0,null,null,null,null,null,null,null,null,null,0.25,null,null,50.238129999999998]
["Example 2 Case 1 Vukovic 15 oC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,null,null,42.348770000000002]
["ps",null,null,"pp",null,null,"Sample 4 Odong 20 oC",null,null,null,null,null,null,null,null,null,null,null,null,7.4999999999999997E-2,null,null,32.895299999999999]
[5,null,null,100,null,null,"ps",null,null,"pp",null,null,null,null,null,null,null,null,null,3.0700000000000002E-2,null,null,25.460619999999999]
[0.85,null,null,80,null,null,1.18,null,null,100,null,null,null,null,null,null,null,null,null,1.9900000000000001E-2,null,null,22.022379999999998]
[0.3,null,null,60,null,null,0.6,null,null,98.44,null,null,null,null,null,null,null,null,null,1.18E-2,null,null,18.27158]
[0.12,null,null,40,null,null,0.42499999999999999,null,null,91.55,null,null,null,null,null,null,null,null,null,8.5000000000000006E-3,null,null,16.288989999999998]
[3.9E-2,null,null,20,null,null,0.3,null,null,68.78,null,null,null,null,null,null,null,null,null,6.1000000000000004E-3,null,null,14.25731]
[1.4E-2,null,null,10,null,null,0.21199999999999999,null,null,25.83,null,null,null,null,null,null,null,null,null,3.0000000000000001E-3,null,null,11.386100000000001]
[2.5000000000000001E-3,null,null,5,null,null,0.15,null,null,7.89,null,null,null,null,null,null,null,null,null,1.2999999999999999E-3,null,null,8.4167170000000002]
[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":27,"n_cols":2,"rows_kept":27,"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},"Shepherd, R.G.  1989.  Correlations of permeability and grain size.  Ground Water, 27(5): 633-638."]
[21,"Slichter, C.S., 1898, Theoretical investigations of the motion of ground waters: United States Geological Survey, 19 th Annual Report, p 295-384."]
[22,"Terzaghi, K., 1925, Principles of soil mechanics: Engineering News-Record, v. 95, p 832."]
[23,"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."]
[24,"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."]
[25,"Zamarin, J.A.  1928.  Calculation of ground-water flow (in Russian).  Trudey I.V.H. Taskeni."]
[26,"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":100},null,{"$f":"Input!E5","v":"T (oC)"},{"$f":"Input!E6","v":20}]
[]
[{"$f":"Input!K2","v":" Moderately well sorted  sand low in fines "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$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":2},{"$f":"IF(ISBLANK(Input!C8),\" \",Input!C8)","v":0},{"$f":"IF(ISBLANK(Input!D8),\" \",Input!D8)","v":0},{"$f":"IF(ISBLANK(Input!E8),\" \",Input!E8)","v":100},null,{"$f":"Input!K9","v":"d10"},{"$f":"Input!L9","v":0.15},"Uniformity Coef.",{"$f":"Input!N9","v":3.666666666666667}]
[{"$f":"IF(ISBLANK(Input!B9),\" \",Input!B9)","v":0.82},{"$f":"IF(ISBLANK(Input!C9),\" \",Input!C9)","v":20},{"$f":"IF(ISBLANK(Input!D9),\" \",Input!D9)","v":0.2},{"$f":"IF(ISBLANK(Input!E9),\" \",Input!E9)","v":80},null,{"$f":"Input!K10","v":"d17"},{"$f":"Input!L10","v":0.24100000000000002},"n computed",{"$f":"Input!N10","v":0.38377350574709118}]
[{"$f":"IF(ISBLANK(Input!B10),\" \",Input!B10)","v":0.55000000000000004},{"$f":"IF(ISBLANK(Input!C10),\" \",Input!C10)","v":20},{"$f":"IF(ISBLANK(Input!D10),\" \",Input!D10)","v":0.2},{"$f":"IF(ISBLANK(Input!E10),\" \",Input!E10)","v":60},null,{"$f":"Input!K11","v":"d20"},{"$f":"Input!L11","v":0.28000000000000003},"g (cm/s2)",{"$f":"Input!N11","v":980}]
[{"$f":"IF(ISBLANK(Input!B11),\" \",Input!B11)","v":0.42},{"$f":"IF(ISBLANK(Input!C11),\" \",Input!C11)","v":20},{"$f":"IF(ISBLANK(Input!D11),\" \",Input!D11)","v":0.2},{"$f":"IF(ISBLANK(Input!E11),\" \",Input!E11)","v":40},null,{"$f":"Input!K12","v":"d50"},{"$f":"Input!L12","v":0.48499999999999999},"r (g/cm3)",{"$f":"Input!N12","v":0.99813600000000002}]
[{"$f":"IF(ISBLANK(Input!B12),\" \",Input!B12)","v":0.28000000000000003},{"$f":"IF(ISBLANK(Input!C12),\" \",Input!C12)","v":20},{"$f":"IF(ISBLANK(Input!D12),\" \",Input!D12)","v":0.2},{"$f":"IF(ISBLANK(Input!E12),\" \",Input!E12)","v":20},null,{"$f":"Input!K13","v":"d60"},{"$f":"Input!L13","v":0.55000000000000004},"m (g/cm s)",{"$f":"Input!N13","v":9.8479999999999991E-3}]
[{"$f":"IF(ISBLANK(Input!B13),\" \",Input!B13)","v":0.15},{"$f":"IF(ISBLANK(Input!C13),\" \",Input!C13)","v":10},{"$f":"IF(ISBLANK(Input!D13),\" \",Input!D13)","v":0.1},{"$f":"IF(ISBLANK(Input!E13),\" \",Input!E13)","v":10},null,{"$f":"Input!K15","v":"de (Kruger)"},{"$f":"Input!L15","v":0.34383499566902992},"rg/m (1/cm s)",{"$f":"Input!N14","v":99327.099918765234}]
[{"$f":"IF(ISBLANK(Input!B14),\" \",Input!B14)","v":4.4999999999999998E-2},{"$f":"IF(ISBLANK(Input!C14),\" \",Input!C14)","v":10},{"$f":"IF(ISBLANK(Input!D14),\" \",Input!D14)","v":0.1},{"$f":"IF(ISBLANK(Input!E14),\" \",Input!E14)","v":0},null,{"$f":"Input!K16","v":"de (Kozeny)"},{"$f":"Input!L16","v":0.29008871223808247},"tau (Sauerbrei)",{"$f":"Input!N15","v":1.0530200000000001}]
[{"$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.30734018950367153},"dgeometric mean",{"$f":"Input!L14","v":0.44970904468378892}]
[{"$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.32596413045467088},"sf",{"$f":"Input!N21","v":1.1783688207661502}]
[{"$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":6.6250000000000003E-2}]
[{"$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":0}]
[{"$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":40}]
[{"$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":40}]
[{"$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":10}]
[{"$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":10}]
[{"$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":45,"n_cols":7,"rows_kept":45,"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":100},null,{"$f":"Input!E5","v":"T (oC)"},{"$f":"Input!E6","v":20}]
[]
[{"$f":"Input!K2","v":" Moderately well sorted  sand low in fines "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":3.0006144042093508E-2},{"$f":"IF(ISBLANK(Input!I19),\" \",Input!I19)","v":3.0006144042093509E-4},{"$f":"IF(ISBLANK(Input!J19),\" \",Input!J19)","v":25.925308452368792}]
[null,null,"Hazen K (cm/s) = d10 (mm)",{"$f":"IF(ISBLANK(Input!H20),\" \",Input!H20)","v":2.2499999999999999E-2},{"$f":"IF(ISBLANK(Input!I20),\" \",Input!I20)","v":2.2499999999999999E-4},{"$f":"IF(ISBLANK(Input!J20),\" \",Input!J20)","v":19.440000000000001}]
[null,null,"Slichter",{"$f":"IF(ISBLANK(Input!H21),\" \",Input!H21)","v":9.5963209315535949E-3},{"$f":"IF(ISBLANK(Input!I21),\" \",Input!I21)","v":9.5963209315535949E-5},{"$f":"IF(ISBLANK(Input!J21),\" \",Input!J21)","v":8.2912212848623064}]
[null,null,"Terzaghi",{"$f":"IF(ISBLANK(Input!H22),\" \",Input!H22)","v":1.6695337658127831E-2},{"$f":"IF(ISBLANK(Input!I22),\" \",Input!I22)","v":1.669533765812783E-4},{"$f":"IF(ISBLANK(Input!J22),\" \",Input!J22)","v":14.424771736622445}]
[null,null,"Beyer",{"$f":"IF(ISBLANK(Input!H23),\" \",Input!H23)","v":2.4807909969877112E-2},{"$f":"IF(ISBLANK(Input!I23),\" \",Input!I23)","v":2.4807909969877111E-4},{"$f":"IF(ISBLANK(Input!J23),\" \",Input!J23)","v":21.43403421397382}]
[null,null,"Sauerbrei",{"$f":"IF(ISBLANK(Input!H24),\" \",Input!H24)","v":3.3908920426943837E-2},{"$f":"IF(ISBLANK(Input!I24),\" \",Input!I24)","v":3.3908920426943838E-4},{"$f":"IF(ISBLANK(Input!J24),\" \",Input!J24)","v":29.297307248879473}]
[null,null,"Kruger",{"$f":"IF(ISBLANK(Input!H25),\" \",Input!H25)","v":5.162397278775268E-2},{"$f":"IF(ISBLANK(Input!I25),\" \",Input!I25)","v":5.1623972787752685E-4},{"$f":"IF(ISBLANK(Input!J25),\" \",Input!J25)","v":44.603112488618315}]
[null,null,"Kozeny-Carmen",{"$f":"IF(ISBLANK(Input!H26),\" \",Input!H26)","v":0.10326466562081722},{"$f":"IF(ISBLANK(Input!I26),\" \",Input!I26)","v":1.0326466562081721E-3},{"$f":"IF(ISBLANK(Input!J26),\" \",Input!J26)","v":89.220671096386084}]
[null,null,"Zunker",{"$f":"IF(ISBLANK(Input!H27),\" \",Input!H27)","v":5.6403675932494818E-2},{"$f":"IF(ISBLANK(Input!I27),\" \",Input!I27)","v":5.6403675932494815E-4},{"$f":"IF(ISBLANK(Input!J27),\" \",Input!J27)","v":48.732776005675518}]
[null,null,"Zamarin",{"$f":"IF(ISBLANK(Input!H28),\" \",Input!H28)","v":6.6457521399872599E-2},{"$f":"IF(ISBLANK(Input!I28),\" \",Input!I28)","v":6.6457521399872601E-4},{"$f":"IF(ISBLANK(Input!J28),\" \",Input!J28)","v":57.419298489489933}]
[null,null,"USBR",{"$f":"IF(ISBLANK(Input!H29),\" \",Input!H29)","v":2.5513642444225246E-2},{"$f":"IF(ISBLANK(Input!I29),\" \",Input!I29)","v":2.5513642444225244E-4},{"$f":"IF(ISBLANK(Input!J29),\" \",Input!J29)","v":22.043787071810613}]
[null,null,"Barr",{"$f":"IF(ISBLANK(Input!H30),\" \",Input!H30)","v":1.3372744950630731E-2},{"$f":"IF(ISBLANK(Input!I30),\" \",Input!I30)","v":1.337274495063073E-4},{"$f":"IF(ISBLANK(Input!J30),\" \",Input!J30)","v":11.55405163734495}]
[null,null,"Alyamani and Sen",{"$f":"IF(ISBLANK(Input!H31),\" \",Input!H31)","v":8.3791178385416651E-3},{"$f":"IF(ISBLANK(Input!I31),\" \",Input!I31)","v":8.3791178385416652E-5},{"$f":"IF(ISBLANK(Input!J31),\" \",Input!J31)","v":7.2395578124999993}]
[null,null,"Chapuis",{"$f":"IF(ISBLANK(Input!H32),\" \",Input!H32)","v":1.7386448385766098E-2},{"$f":"IF(ISBLANK(Input!I32),\" \",Input!I32)","v":1.73864483857661E-4},{"$f":"IF(ISBLANK(Input!J32),\" \",Input!J32)","v":15.021891405301911}]
[null,null,"Krumbein and Monk",{"$f":"IF(ISBLANK(Input!H33),\" \",Input!H33)","v":3.218278355174381E-2},{"$f":"IF(ISBLANK(Input!I33),\" \",Input!I33)","v":3.2182783551743812E-4},{"$f":"IF(ISBLANK(Input!J33),\" \",Input!J33)","v":27.805924988706654}]
[null,null,"Shepherd",{"$f":"IF(ISBLANK(Input!H34),\" \",Input!H34)","v":5.0082769150900264E-2},{"$f":"IF(ISBLANK(Input!I34),\" \",Input!I34)","v":5.0082769150900264E-4},{"$f":"IF(ISBLANK(Input!J34),\" \",Input!J34)","v":43.271512546377828}]
[null,null,"geometric mean",{"$f":"IF(ISBLANK(Input!H35),\" \",Input!H35)","v":2.5631671609658867E-2},{"$f":"IF(ISBLANK(Input!I35),\" \",Input!I35)","v":2.5631671609658869E-4},{"$f":"IF(ISBLANK(Input!J35),\" \",Input!J35)","v":22.145764270745261}]
[null,null,"arithmetic mean",{"$f":"IF(ISBLANK(Input!H36),\" \",Input!H36)","v":3.1200491508798514E-2},{"$f":"IF(ISBLANK(Input!I36),\" \",Input!I36)","v":3.1200491508798521E-4},{"$f":"IF(ISBLANK(Input!J36),\" \",Input!J36)","v":26.957224663601917}]