# Note

Document Sample

```					NOTE
This workbook and software are provided for free as part of the e-book:
1D SEDIMENT TRANSPORT MORPHODYNAMICS with applications to RIVERS
by Gary Parker.

Neither I nor any university in which I am in the employ accepts
responsibility or liability for its use by third parties.
he e-book:
lications to RIVERS AND TURBIDITY CURRENTS,
Grain Size Distribution Statistics Calculator

The code in Visual Basic for Applications for this spreadsheet
can be found in Module 1 of this project in the Visual Basic Editor.

The grain size distribution is specified in terms of a series of pairs
specifying (grain size in mm, percent finer).

Input the number of pairs npp specifying the grain size distribution
npp           8 npp must be between 2 and 17
Click to set up table for input
of grain size distribution

Grain     Percent
size mm Finer      Input the grain sizes and percents finer in order of ascending size
0.031         2         If the finest size does not correspond to 0 percent finer, or t
0.062       3.2         coarsest grain size does not correspond to 100 percent fine
0.125       10          the missing sizes (D0 and D100) are computed by interpolati
0.25      42
0.5     83.4               Click to compute geometric mean
1      97                and geometric standard deviation
2      99
4     100                    Geometric mean size
Geometric standard deviation

To compute a size Dx such that x percent of the sediment i
e.g. D50 such that 50 percent of the sediment is fine
enter x below
x          50 x must be between 0 and 100

Click to calculate Dx

Size such that        50 percent is finer:
The input cells are in gold
The output cells are in blue

size distribution

ts finer in order of ascending size
t correspond to 0 percent finer, or the
not correspond to 100 percent finer,
d D100) are computed by interpolation.

eometric mean
dard deviation

0.273 mm
2.168

uch that x percent of the sediment is finer
at 50 percent of the sediment is finer,

e between 0 and 100

culate Dx

0.286 mm
Grain Size Distribution

100

90

80

70
Percent finer

60

50

40

30

20

10

0
0.01     0.1                     1   10
Grain size mm

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 34 posted: 4/28/2009 language: English pages: 5
How are you planning on using Docstoc?