GEOL6550
Clay Mineralogy Exercise #1
Create an Excel spreadsheet that
calculates
the following:
1. Settling time (t) for a particle in a graduated cylinder
2. Settling time (t) for a particle in a centrifuge.
Use Stoke's Law to calculate the
time of
settling: Use units of (day:hr:min:s)
Allow the user to specify: (units in red)
a.
The
equivalent spherical diameter (esd) of the
particle (D cm and µm).
b.
The depth
from top of meniscus for case 1. (h cm)
c.
Density of
particle (dp g cm-3).
d.
Viscosity
of fluid (η poise or dyne s cm-1
or
g cm-1 s-1).
e.
Density of
fluid (dl g cm-3).
f.
Acceleration
due gravity for case 1 (g cm s-2).
g.
Time of
acceleration for case 2 (ta s).
h.
Time of
deceleration for case 2 (td s).
i.
Initial
distance from axis of rotation for case 2 (R1 cm).
j.
Final
distance from axis of rotation for case 2 (R2 cm) .
k.
Angular
velocity of centrifuge for case 2 (N RPM and
revolutions per sec or Hz).
l.
Temperature
of fluid (T degrees C)
if you want to modify viscosity term.
Useful equations:
From Moore and Reynolds (1997):
From Hathaway (1955):
