Home ⋅ Book: Environmental Geochemistry ⋅ Book: An Introduction ⋅ Book: Spectral Analysis ⋅ Book: EFA ⋅ Book: Wavelets ⋅ MDAG Papers ⋅ MDAG IKD Database ⋅ MDAG Grain 3.0 ⋅ Minewall 3
This program and version is copyrighted (©) by Kevin A. Morin and Nora M. Hutt
Minesite Drainage Assessment Group (MDAG)TM
Introduction
Grain 3.0©,TM is a handy and time-saving spreadsheet for calculating the geometric grain-surface area for a sample with a range of grain sizes. We have used this for case studies in our book, Environmental Geochemistry of Minesite Drainage: Practical Theory and Case Studies, and for grain-surface areas in the International Kinetic Database (IKD©,TM).
Grain 3.0 already contains common sieve/mesh sizes and diameters.
You can change the diameters at any time, or add new sieve sizes. If you do
not use a sieve that is already in Grain 3.0, it will be properly ignored in the
calculations (see example below).
GRAIN 3.0©,TM |
|||
A SPREADSHEET TO CALCULATE
GRAIN-SURFACE AREA |
|||
| Project: | |||
| Company: | |||
| Sample: | |||
| Comments: | |||
| Specific Gravity of Sample Solids: | 2.7 |
||
Mesh Size |
Sieve |
Wt. Retained |
Calculated Grain-Surface |
100 |
0 |
0 |
|
50 |
0 |
0 |
|
25 |
0 |
0 |
|
19 |
0 |
0 |
|
13 |
0 |
0 |
|
9.5 |
0 |
0 |
|
6.7 |
23 |
0.00381426202322 |
|
#4 |
4.75 |
0 |
0 |
#5 |
4 |
0 |
0 |
#6 |
3.36 |
0 |
0 |
#7 |
2.83 |
0 |
0 |
#8 |
2.38 |
0 |
0 |
#10 |
2 |
133 |
0.0679438058748 |
#12 |
1.68 |
0 |
0 |
#14 |
1.41 |
0 |
0 |
#16 |
1.19 |
0 |
0 |
#18 |
1 |
0 |
0 |
#20 |
0.84 |
0 |
0 |
#25 |
0.71 |
0 |
0 |
#30 |
0.59 |
0 |
0 |
#35 |
0.5 |
57 |
0.101333333333 |
#40 |
0.42 |
0 |
0 |
#45 |
0.35 |
0 |
0 |
#50 |
0.297 |
0 |
0 |
#60 |
0.25 |
0 |
0 |
#70 |
0.21 |
0 |
0 |
#80 |
0.177 |
0 |
0 |
#100 |
0.149 |
158 |
1.08200650574 |
#120 |
0.125 |
0 |
0 |
#140 |
0.105 |
0 |
0 |
#170 |
0.088 |
0 |
0 |
#200 |
0.074 |
0 |
0 |
#250 |
0.062 |
0 |
0 |
#270 |
0.053 |
0 |
0 |
#325 |
0.044 |
0 |
0 |
#400 |
0.037 |
22 |
0.5256869773 |
#500 |
0.025 |
0 |
0 |
Passing Finest Mesh (set Diameter = 0) |
0 |
18 |
2.16216216216 |
| Total for Sample: | 411 |
3.94294704643 |
|
| Surface Area per kg: | 9.59354512513 |
||
How to Obtain a Copy of Grain 3.0
Grain 3.0 is a free download. When using it, please reference it as Grain 3.0 from MDAG Publishing at www.MDAG.com/grain30.html. Grain 3.0 currently exists as a Microsoft Excel spreadsheet containing one sheet for the calculations and one sheet for instructions on how to use, adjust, and expand it for your own samples and sieve sizes.
To download Grain 3.0, please click on this link, MDAG Grain 3.0
Home ⋅ Book: Environmental Geochemistry ⋅ Book: An Introduction ⋅ Book: Spectral Analysis ⋅ Book: EFA ⋅ Book: Wavelets ⋅ MDAG Papers ⋅ MDAG IKD Database ⋅ MDAG Grain 3.0 ⋅ Minewall 3
Created by K.Morin