Geological Problem Solving with Lotus 1-2-3 for Exploration and Mining Geology (eBook)

Front Cover 1
Geological Problem Solving with Lotus 1-2-3 for Exploration and Mining Gaology 4
Copyright Page 
5 
Table of Contents 6
List of Worksheets 10
Series Editor's Foreword 12
Preface 14
Disclaimer 17
Chapter 1. Introduction 18
CONVENTIONS 20
CONCLUSIONS 21
Part 1: Exploration 22
Chapter 2. Confidence intervals 22
2.1 Confidence intervals for a fictitious data set 22
2.2 Confidence intervals for data from the Elmwood, Tennessee zinc deposit 23
2.3 Confidence intervals for the Don Tomas vein, Frisco mine 23
Chapter 3. Fitting a straightline to exploration data 32
3.1 Gold placer data from Manhattan, Nevada 32
Chapter 4. Analysis of variance 38
4.1 One-way analysis of variance 39
4.2 Comparing vein sets in the Frisco mine, Chihuahua, Mexico 40
4.3 Randomized block analysis of variance 40
4.4 Comparing methods of sample preparation for gold ore 41
Chapter 5. Exploration geochemical data 62
5.1 Summary statistics 62
5.2 Frequency distributions and histograms 63
Chapter 6. Exploration models 76
6.1 A simulation of grid drilling 76
6.2 The Elmwood, Tennessee, zinc deposit 78
Chapter 7. Probability and related calculations 92
7.1 Tonnage-grade relations 92
7.2 Probability calculations 95
7.3 Plotting logarithmic graphs 96
Part 2: Evaluation 108
Chapter 8. Compound interest 108
8.1 Compound interest formulae 108
8.2 Table of discrete compounding factors 111
8.3 Solving interest problems 111
Chapter 9. Depreciation and depletion 126
9.1 Yearly net income and cash flow calculation 127
9.2 The Ridgeway, South Carolina, gold mine 128
Chapter 10. Discounted cash flow rate of return 136
10.1 A simple example 137
10.2 A second example of DCFROR 137
Chapter 11. Blocking ore from data in development workings 146
11.1 Grade and tonnage of ore from development data 146
11.2 Calculation of specific gravity 148
Chapter 12. Blocking ore from drillhole data 158
12.1 Quadratic regression — Rangely, Colorado, oil-and-gasfield 158
12.2 Quadratic regression — Chambishi mine 160
12.3 Other ways to estimate block grades 164
Chapter 13. Ore concentration and smelter settlement 180
13.1 Ore concentration 180
13.2 Calculation of grade for a mined-out deposit 182
13.3 Smelter settlement 183
Chapter 14. Peters's model for mineral property evaluation 198
14.1 The basic model 198
14.2 Using the model 199
References 218
Index 222