HomeBook: Environmental GeochemistryBook: An IntroductionBook: Spectral AnalysisMDAG PapersMDAG IKD DatabaseMDAG Grain 3.0


MDAG Grain 3.0,TM


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
FROM SIEVE ANALYSES (from MDAG Publishing)

Project:
Company:
Sample:
Comments:
Specific Gravity of Sample Solids:

2.7

Mesh Size

Sieve
Diameter (mm)

Wt. Retained
On Sieve (g)

Calculated Grain-Surface
Area (m2)

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




HomeBook: Environmental GeochemistryBook: An IntroductionBook: Spectral AnalysisMDAG PapersMDAG IKD DatabaseMDAG Grain 3.0


Created by K.Morin