Koch / Merriam Geological Problem Solving with Lotus 1-2-3 for Exploration and Mining Geology

1. Auflage 2013
ISBN: 978-1-4832-9380-6
Verlag: Elsevier Science & Techn.
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 225 Seiten, Web PDF

Presents effective methods for using Lotus 1-2-3 techniques to solve problems in exploration and mining geology. 1-2-3 programmes are provided in conjunction with named worksheets or templates, together with brief explanatory text. Problem solving is based on a well-established and maintained software package. A floppy diskette is supplied enabling users, following brief instructions, to solve problems immediately.

Autoren/Hrsg.

Koch, G. S.

Merriam, Daniel F

Inhaltsverzeichnis

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