• No results found

Reserves Db

N/A
N/A
Protected

Academic year: 2021

Share "Reserves Db"

Copied!
44
0
0

Loading.... (view fulltext now)

Full text

(1)

Reserves Database

For Minex v5.3

(2)

Copyright © 2008 Surpac Minex Group Pty Ltd (A Gemcom Company). All rights reserved. This software and documentation is proprietary to Surpac Minex Group Pty Ltd.

Surpac Minex Group Pty Ltd publishes this documentation for the sole use of Surpac licenses. Without written permission you may not sell, reproduce, store in a retrieval system, or transmit any part of this documentation. For such permission, or to obtain extra copies please contact your local Surpac Minex Group Office.

Surpac Minex Group Pty Ltd Level 8 190 St Georges Terrace Perth, Western Australia 6000 Telephone: (08) 94201383 Fax: (08) 94201350

Support: 02 4872 6003

Minexhelp@surpac.com

http://www.gemcomsoftware.com

While every precaution has been taken in the preparation of this manual, we assume no responsibility for errors or omissions. Neither is any liability assumed for damage resulting from the use of the information contained herein.

All brand and product names are trademarks or registered trademarks of there respective companies.

About This Manual

This manual has been designed to provide a practical guide to the many uses of the software. The manual describes one way of using the software; these instructions are by no means exhaustive. However, it provides a starting point for new users and a good overview for existing users by

demonstrating how to use many of the functions in Minex. If you have any difficulties or questions while working through this manual please contact your local Surpac Minex Group Office.

Contributors James Willoughby Rohit Sarin

Surpac Minex Group Perth, Western Australia

Product Minex v5.3

(3)

Table of Contents

About This Document ... 5

Requirements ... 5 Document Conventions ... 5 Typographical Conventions ... 5 Keyboard Conventions ... 6 Menu Conventions ... 6 Mouse Conventions ... 6

Windows and Forms ... 7

Elements of Windows and Dialog Boxes ... 7

Introduction to Reserves Database ... 9

Requirements ... 9

Objectives ... 10

Workflow ... 11

Creating a Database ... 12

Overview ... 12

Task: Create a Reserves Database ... 12

Summary ... 13

Setting Up Codes and Layers ... 14

Codes ... 14

Surf code, Pre code, Mine code ... 14

Layers ... 15

Task: Set up Codes and Layers ... 16

Summary ... 17

Adding a Pit ... 18

Requirements... 18

Task: Adding a Pit ... 18

Generating Reserves ... 20

Task: Generate Reserves ... 20

Common Problems in Reserves Generation ... 21

Null Values in Grids. ... 21

Quality Variables ... 23

Adding Quality Variables ... 23

Task: Adding Quality Variables... 23

Importing Quality Variables ... 24

Task: Import Quality Defaults ... 24

Displaying Reserves ... 26

Displaying Reserves in 3D ... 26

Task: Plot Reserves in 3D ... 26

Finding Coal Tonnage and Volume ... 28

Task: Find Out the Tonnage and Volume of Coal in a Block ... 28

Creating a Pit Section ... 30

Task: Create a Pit Section with a Seam Cross-Section ... 30

Reports ... 34

(4)

Table of Contents

Task: Create a Status Report for Pit 7 ... 34

Creating a Detailed Report ... 36

Task: Create a Detailed Report ... 36

Checking Reserves ... 39

Creating an Insitu Report ... 39

Task: Create an Insitu Resource Report for Pit 7 ... 39

Grid Volumetrics ... 42

Task: Create a Grid Volumetrics Report for Pit7 ... 42

(5)

Reserves_db.doc Page 5 of 44

About This Document

This document is designed to help you to create and update a reserves database. Also, you will learn how to display it and report on it.

More detailed training information is available from your local Surpac Minex Group Support Office.

Visit http://www.surpac.com to find your nearest support office or contact Minex support as follows: • Call the Mittagong Office: 02 4872 6003

• Call the Brisbane Office: 07 3036 7000 • E-mail minexhelp@surpac.com

Requirements

Before proceeding with this tutorial, you should ensure you have the following items:

1. Minex 5.3, and the tutorial data provided on the installation disc, installed on your computer. This is usually installed from a CD.

2. A Minex license file and sentinel correctly installed

Store the license file (provided by the Minex Support Office) in <Minex installation directory>\etc\license.

Place the sentinel in an appropriate port.

Document Conventions

Typographical Conventions

Some text in this manual has special formatting to identify it as a particular element of information. The following list describes the different formats and their meanings:

(6)

About This Document Document Conventions

Reserves_db.doc Page 6 of 44

Text Format Meaning

<Bold Italic> Text or data that varies with each input is shown in italic font and enclosed in angle brackets. Some examples are installation directories, dates, names and passwords. When you substitute the text for the variable, do not include the brackets. For example:

<password> requires you to substitute a password in place of ‘<password>’.

Italics A words or phrase to which the author wants to give emphasis. For example, “the new text is in memory; the old text is deleted”.

Bold This typeface indicates one of the following:

• A file name, path or URL.

Strongly emphasised text. For example, “It is very important to save the data”.

• Text that a procedure has instructed you to type.

• A menu option, tab, button, check box, list, option button, text box or icon. For example, click Apply.

UPPER CASE When a keystroke is described, the key is shown in this font. For more information on keystroke conventions, see below.

Keyboard Conventions

Key Combination Meaning

<KEYy>+<KEY> Press and hold down the first key, then press the second key. For example: CTRL+O means hold the CTRL key down, then press O.

Menu Conventions

When you click, or move the pointer over, some menu commands, a subordinate menu appears. To indicate that you should select a command on a subordinate menu, this documentation uses a greater than (>) sign to separate the main menu command from the subordinate menu command. For example, File > Project > Project Manager means click the File menu, move the mouse pointer over the Project command, and then select Project Manager on the secondary menu.

Mouse Conventions

The mouse is the pointing device you use to select objects and menu items, and to click the buttons that you see on screen. If a particular mouse button is not specified, use the left button. When a different button should be used, this is specified in the text. You can rotate or press the wheel button on the mouse. In this manual, the following terms are used to describe actions with the mouse.

(7)

About This Document Document Conventions

Reserves_db.doc Page 7 of 44

Action Description

Click Press and release the left mouse button without moving the mouse. Right-click Press and release the right mouse button without moving the mouse. Double-click Without moving the mouse, click the left button twice rapidly. Drag and drop <an

object>

With the pointer over the object, press and hold down the left mouse button to select the object. Move the mouse until the pointer is in the position you want and then release the mouse button.

Drag Press and hold down the left mouse button. Then move the mouse in the direction that the text specifies.

Right-drag Press and hold down the right mouse button. Then move the mouse in the direction that the text specifies.

Rotate Use your finger to make the wheel button roll. Move it forward, that is in a clockwise direction, or backward, that is in a counter clockwise direction.

Windows and Forms

Windows and forms contain several elements that enable users to carry out particular operations. In Minex ‘window’ means the main window of a computer application. For example the Minex window is the large window that includes the Minex Explorer and the Graphics area and the Status bar and all the toolbars and menu bars. In Minex, ‘form’ means the same thing as ‘dialog box’. Here is an example of a form.

Elements of Windows and Dialog Boxes

Windows and dialog boxes can contain the following elements.

Element Name

Description Example

Check box Square box that you select or clear to turn an option on or off. You can select more than one check box.

Button Rectangular or square button that initiates an action. Buttons have text labels to indicate their purpose.

Drop-down arrow

Arrow associated with a drop-down list. You can view a list by clicking the arrow.

Drop-down list

Closed version of a list box with an arrow next to it. Clicking the arrow opens the list.

Icon A graphical button that you can click to initiate an action.

(8)

About This Document Document Conventions

Reserves_db.doc Page 8 of 44

Label Text attached to any option, box, button, or to any other element of a window or dialog box. List box Any type of box containing a list of items, in table

format, that you can select.

Menu A set of options or actions that you can perform.

Option button

Round button you can use to select one of a group of mutually exclusive options.

Spin box Text box with up and down arrows that you click to move through a set of fixed values. You can also type a valid value in the box.

Tab Labelled group of options used for many similar kinds of settings.

Text box Rectangular box in which you can type text. If the box already contains text, you can select that text and edit it.

Title Title of the dialog box. It usually, but not always, matches the title of the command button that launched it.

Tree A graphical representation of a hierarchical structure. A plus sign next to an item on the tree indicates that you can expand the item to show subordinate items; a minus sign indicates that you can collapse the item.

(9)

Reserves_db.doc Page 9 of 44

Introduction to Reserves Database

The pit design, which you complete before creating the reserves database, represents the geometric shape of your mine. Each block should represent a sensible mining unit. When you create a reserves database, the volumes in these blocks are calculated and stored. You must create a reserves database before scheduling mining operations.

This section of the tutorial describes the database used to store these volumes.

The pit you designed is identified by a pit number (for example 7). The pit is divided into benches, strips, and blocks.

In the Reserves database, the labels or keys that are used to store the volumes are as follows: • PIT

• BENCH • STRIP • BLOCK

Keys or labels enable rapid access to the database. Each block can also contain layers. For example, the following block contains a coal layer and an overburden layer.

The reserves database has an additional key called layer name.

The reserves database is an Indexed Sequential Access Method (ISAM) file. The indexes used are pit, bench, strip, block, and layer. The indexes enable fast retrieval of data.

Requirements

Before proceeding with this tutorial, you should ensure you have: 1. Minex v5.3 installed on your computer.

This is usually installed from a CD, but the software can be downloaded from

http:/www.surpac.com.

2. The Ashes data set stored on your computer.

(10)

Introduction to Reserves Database Objectives

Reserves_db.doc Page 10 of 44

3. The Minex working directory set to the location of the Ashes data set.

By default, the Ashes data set is stored in <Minex install folder>\tutorials\Ashes.

For example, if you installed Minex v5.3 to the default location, the complete Ashes data set is stored in C:\Program Files\Gemcom Software\MINEX53\tutorials\Ashes.

4. A Minex license file and sentinel correctly installed.

Store the license file (provided by the Minex Support Office) in <Minex installation directory>\etc\license.

Place the sentinel in an appropriate port. 5. A seam model for the deposit.

Read the seam modelling tutorial for information about creating a seam model. 6. A pit design.

Read the pit design tutorial for information about designing a pit.

Objectives

By working through this document, you should be able to: • Calculate the volumes in the blocks of your pit design • Set up the database to store the volume data

• Produce reports that show the volume and tonnage of coal (and waste) in the reserves • Show the reserves, and the seams within the pit, in the graphics window.

(11)

Introduction to Reserves Database Workflow

Reserves_db.doc Page 11 of 44

(12)

Reserves_db.doc Page 12 of 44

Creating a Database

Overview

If you do not already have a reserves database, you should create one. After you have created a reserves database, it appears as a .dbr file in the Minex Explorer.

Note: If a reserves database is already listed in the Minex Explorer, and you want to work with it, right-click it and select Open.

Task: Create a Reserves Database

1. From the main menu choose File > New. 2. Select ReservesDB.dbr, and click Next.

3. Follow the steps in the wizard to create the reserves database. 4. Name it resdb1 instead of <default name>.

(13)

Creating a Database Workflow

Reserves_db.doc Page 13 of 44

Summary

You should now see a resdb1.dbr file in the Minex Explorer. Next, you will set up codes and layers in the database.

(14)

Reserves_db.doc Page 14 of 44

Setting Up Codes and Layers

You set up codes to help ensure that mining equipment is used to mine the types of material (such as coal or parting) for which it is designed.

Codes

The codes file contains a series of codes and values which you can use for all layers. The following image shows the contents of a typical codes file:

Material Code Each code usually has its own defaults. Here we used codes WASTE, PART and COAL. Type This is an abbreviation for the codes. It will save you time when you are typing. W = Waste, C = Coal, P = Part.

Surf code, Pre code, Mine code

These codes stand for surface code, premining code, and mining code. These are primarily used in scheduling, although they are also useful in database editing. When scheduling, you can do these three operations on material.

These are explained in the figure below:

The codes (for example CMIN, PMIN, WMIN) are also defined on each equipment item. These codes prevent equipment from doing the wrong work. For example, a dragline should not normally mine coal.

Bulk Factor This factor, usually 1.3, is used to calculate loose or swollen volumes from bench volumes. This number can be used for truck calculations.

(15)

Setting Up Codes and Layers Layers

Reserves_db.doc Page 15 of 44

Recovery/Rehandle In coal mines the coal is recovered from the pit but some coal is permanently lost. It might remain on the pit floor or in a rib or fender. Using the recovery/rehandle factor, you can reflect this loss in the yield.

Run-of-mine (ROM) COAL is calculated as: INSITU COAL x RECOVERY/100

RECOVERY is stored as a % value.

The rehandle value is usually associated with waste material. Waste material, particularly in dragline operations, could be double-handled or rehandled. The rehandle is also a percentage. Description This field is optional. It is used only for information purposes.

Layers

In the context of a reserves database, a ‘layer’ is a layer of overburden, coal, or interburden. The following image shows five layers of coal, one layer of overburden, and four layers of interburden.

(16)

Setting Up Codes and Layers Layers

Reserves_db.doc Page 16 of 44

A typical layers file is named Layers.min.The following is an example of a Layers.min file.

To help you understand the information in Layers.min, look at the WEATH line. WEATH is a layer of waste, it bulks at 1.2, and has a rehandle of 0. The layer goes from TOPS to WSF (WSF stands for weathering seam floor).

The Roof Grid and Floor Grid columns refer to grids in the Model.grd folder.

Requirements

Before doing this task, make sure you have:

Opened a reserves database, for example resdb1.dbr.

If you have just created a reserves database, it is already open.

Task: Set up Codes and Layers

1. Choose Reserves > Initialise > Edit Codes and Layers. 2. Click in the Codes section, and navigate to CODES.MIN. 3. Click Select.

4. Click in the Layers section, and navigate to LAYERS.MIN. 5. Click Update Code Info.

The Layers table is updated with the codes from the Codes table. 6. Click Validate Layers to validate the information in the Layers table.

The validation checks the layer order and identifies any missing roof or floor grids. You might see an error similar to the following.

(17)

Setting Up Codes and Layers Layers

Reserves_db.doc Page 17 of 44

7. Click Ok.

Notice that the first line of layers.min states that it extends from TOPS grid to the BOW grid. Remember that these grids are model grids and look in the Model.grd folder in the Minex Explorer. However, there is no grid called BOW in Model.grd; instead the grid that represents the base of weathering is called WSF. To correct the error that appeared, you must edit the first layer so that it extends from TOPS from to WSF and the second layer so that it extends from WSF to SW1SR. 8. Edit the first two layers, replacing BOW with WSF.

9. Click Ok.

10. If you see a prompt to overwrite the Codes.min file or the Layers.min file, click Yes. 11. Click Cancel.

Summary

You should now be able to load and edit a Codes file and a Layers file.

(18)

Reserves_db.doc Page 18 of 44

Adding a Pit

Before you can store any reserves data in the database, you must add a pit to the database.

Note: You can add more than one pit to your reserves database. This enables you to make subtle modifications to the

reserves and cater for unknown variables. For example, if you were unsure of the most realistic

recovery/rehandle value to use for coal, you could define two pits with different recovery/rehandle values.

Requirements

Before doing this task, make sure you have: • an open reserves database

• a Layers.min file that contains the layers in the stratigraphic sequence.

Task: Adding a Pit

1. Choose Reserves > Initialise > Add Pit. 2. Fill in the form as shown in the following image.

It is a sensible convention to enter a ‘reserves database’ pit number that is the same as the ‘geometry’ pit number (that is, the pit number of the pit design that you will use).

You can use a .MIN file or a .OLC file as the layers file. 3. Click Ok.

(19)

Adding a Pit Layers

Reserves_db.doc Page 19 of 44

In the Output Window you will see an image confirming your action.

(20)

Reserves_db.doc Page 20 of 44

Generating Reserves

When you generate reserves, the volumes in the blocks are calculated and stored in the reserves database.

For more information about the Generate Reserves form, see the Generate Reserves topic in the Minex Help.

Task: Generate Reserves

1. If THEDON.GM3 is not already open, open it.

Minex needs a pit design to generate reserves. Each pit design is stored in a geometry file. 2. Choose Reserves > Build > Generate Reserves.

3. Fill in the form as shown in the following image:

So you can understand how to generate reserves with other data, here’s an explanation of some of the important fields on the form:

Reserves DB Pit and Specify Geometry Pit When you added a pit earlier in this tutorial, you added Reserves DB Pit 7. Because Specify Geometry Pit is cleared, Minex will use Geometry Pit 7 in the open geometry file to define the benches, strips, and blocks when it generates reserves. If you want to use a different pit in the geometry file, you should select Specify Geometry Pit and specify the Geometry Pit you want.

(21)

Generating Reserves Common Problems in Reserves Generation

Reserves_db.doc Page 21 of 44

Note: For more information about the Generate Reserves form, see the Generate Reserves topic in the Minex

Help.

4. Click Auto Range.

5. Save the parameters on this form.

It is a good idea to save parameters because you might need to run the reserves generation more than once, for example if there are any reserves generation errors.

6. Click Ok.

The Output window displays the results of the reserves generation, including any errors.

7. If there are any errors, correct them and generate the reserves again.

See the topic Common Problems in Reserves Generation (in this document) for common problems and their solutions.

Common Problems in Reserves Generation

Null Values in Grids.

When you generate reserves, and the Output window reports a message such as “Null grid values – Grid : LDBSF”, this can cause Minex to report reserves incorrectly. This message can appear if grids were not merged correctly.

If you display the grid for which null values are reported, you should be able to see an area that the grid does not cover — the area of null values. To solve the problem:

1. Display the grid, in Model.grd, for which null values are reported.

2. If you can see any holes in the grid, run an SQL statement to correct the holes.

This procedure is fully described in the Pit Design tutorial, in the task: Use an SQL Statement to Fix Holes in a Model Grid.

3. Create the merged model again (that is, create the grids in Merged.grd from the grids in Model.grd).

You use the Create Merged Model command on the Pit Design menu to do so. This procedure is described in the Pit Design tutorial, in the task: Create Merged Grids up to TOPCOAL.

(22)

Generating Reserves Common Problems in Reserves Generation

(23)

Reserves_db.doc Page 23 of 44

Quality Variables

A quality variable is a quality; such as ash, relative density, or moisture; that you are measuring in a coal deposit and whose value could be different across the coal deposit. When you have to deliver coal that has particular quality characteristics, you should ensure that you have quality variables defined for each of the characteristics.

Two quality variables are already defined: RAWRD (relative density) and RAWASH (percentage of ash). The first variable in the reserves database must be RAWRD, and the second variable must be RAWASH, so that you can import quality data correctly. In the following task, you will add the moisture quality variable.

Adding Quality Variables

Task: Adding Quality Variables

1. Choose Reserves > Initialise > Add Quality Variable. 2. Fill in the form as shown in the following image.

(24)

Quality Variables Importing Quality Variables

Reserves_db.doc Page 24 of 44

The following table explains the purpose of the columns in the form that are not obvious. Column Purpose

Grid Suffix The suffix of the grids, in the merged.grd folder, which represent this quality variable. Coal Default The value for this quality that Minex will use in a coal layer when there is no

corresponding quality grid.

Waste Default The value for this quality that Minex will use in a waste layer when there is no corresponding quality grid.

3. Click Add Variable. 4. Click Ok.

You have now defined the MOIST variable.

Note: To add the quality data to the reserves database, you first generate reserves, and then use the Reserves > Build > Quality Update command. This command loads the data in the quality grids into the reserves

database. Because there are no grids for ash, relative density or moisture in the Ashes data set, performing a quality update will have no effect.

Importing Quality Variables

Task: Import Quality Defaults

You might know (or be working on the assumption) that the average relative density of a coal layer is 1.4. You might have some quality grids that specify what the relative density of the layer actually is, but in many cases you will not have a complete set of relative-density quality grids. In that situation, you could import the relative-density default value into your reserves database. By doing so, you store a relative density value of 1.4 for coal throughout the database except where a different relative density value is already stored.

Note: If you do have a quality grid that you want to load, you can do it before or after you do this task (using the

Reserves > Build > Quality Update command).

Relative density is only one example of a quality. You can also import default values for other qualities.

You import quality defaults from a comma separated value (CSV) file. You can create CSV files from many different programs, including Excel and text editors. Alternatively, you can create a CSV file in Minex, as described in the following steps.

Note: In the Minex Help, the topic Define Quality Variable Defaults, states the fields you must define in the CSV file of

you want to import it.

1. Open resdb1.dbr if it is not already open.

2. Choose Reserves > Import > Import Quality Defaults.

(25)

Quality Variables Importing Quality Variables

Reserves_db.doc Page 25 of 44

4. Fill in the form by doing the following steps: a. Click Select Pits, and select pit 7.

b. Click Select Variables, and select RAWRD. c. Enter a file name of rd.csv.

d. Click Add to List.

5. Click Ok in the Define Quality Variable Defaults form. 6. Choose Reserves > Import > Import Quality Defaults.

7. Click .

8. Navigate to the rd.csv file.

(26)

Reserves_db.doc Page 26 of 44

Displaying Reserves

Displaying Reserves in 3D

Task: Plot Reserves in 3D

This task shows you how you can show the reserves in 3D with different colours for each layer. You can use the same form to show the reserves for each bench.

1. Choose Reserves > Plot > Reserves 3D Display. 2. Select pit number 7 from the Pit Number drop-down list. 3. Select Display block annotation.

4. Click the Colors button .

(27)

Displaying Reserves Displaying Reserves in 3D

Reserves_db.doc Page 27 of 44

6. Click Ok.

7. Enter a name for the colour parameters, and click OK.

8. Click Ok in the Reserves 3D Display form.

(28)

Displaying Reserves Finding Coal Tonnage and Volume

Reserves_db.doc Page 28 of 44

9. Change the parameters in the Reserves 3D Display form to show the reserves of only one bench, for example bench 22, and click Ok.

Finding Coal Tonnage and Volume

Task: Find Out the Tonnage and Volume of Coal in a Block

You can use the Plan Detail Pit Block command to find out how much coal is in a block. You can also use this command to provide other information such as the strip ratio, quality characteristics, or thickness of a block.

(29)

Displaying Reserves Finding Coal Tonnage and Volume

Reserves_db.doc Page 29 of 44

2. Create a plan mount around the pit, and draft on it. 3. Choose Reserves > Plot > Plan Detail Pit Block. 4. Fill in the form as shown in the following image:

To fill in the variables table, click Select Variables, hold down CTRL, and click the variables In situ Tonnage, Prime Volume, and Strip/Block.

By filling the form in with these parameters, you will show those blocks on bench 10, strip 14 that contain the DL coal seam. The graphics window will show the in situ tonnage of coal in each of those blocks (rounded to the nearest 100 units) and the volume of coal in each of those blocks (also rounded to the nearest 100).

(30)

Displaying Reserves Creating a Pit Section

Reserves_db.doc Page 30 of 44

The previous image shows that strip 14, block 14 contains an In situ tonnage of coal for seam DL between 2451 and 2550 (remember that you specified rounding to the nearest 100 units). The prime volume of DL coal in block 14 is approximately 1800 (cubic meters or feet depending on whether your site uses metric or imperial measurements).

This is one way of finding out tonnage and volume. The next section of this document describes the textual reports you can run in Minex that you can use to find reserves database information. If you want to see how seams are intersecting strips and blocks, you can use a section mount.

Creating a Pit Section

Task: Create a Pit Section with a Seam Cross-Section

1. Create a section mount in the region of the pit:

a. Display and open PIT7 grid in the Merged folder. b. Choose Mounts > Section > Create.

c. Click Digitise.

(31)

Displaying Reserves Creating a Pit Section

Reserves_db.doc Page 31 of 44

e. Click Ok.

f. Type 7XSec as the name, and click Ok.

2. Choose Mounts > Mounts Control Panel.

3. Right-click the section mount, and click Draft on Mount. 4. Choose Mounts > Section > Pit Section.

5. Fill in the form as shown in the following image, and click Ok.

(32)

Displaying Reserves Creating a Pit Section

Reserves_db.doc Page 32 of 44

Next show a seam cross-section on the pit section. 7. Choose Mount > Section > Seam Cross-Section. 8. Click the Seams tab.

9. Select the Merged folder, and click Load Seams.

10. Click Ok. 11. Zoom in.

(33)

Displaying Reserves Creating a Pit Section

(34)

Reserves_db.doc Page 34 of 44

Reports

Creating a Status Report

The status report is a very flexible and easy-to-use report that you can use to find total waste and coal volumes for the pits, benches, strips, blocks, and layers that you choose.

Task: Create a Status Report for Pit 7

1. Choose Reserves > Reporting > Status Report.

2. First, run a report to show the results for pit 7, bench 10, strip 14, block 14, and layer DLC so that you can compare the results with the results from the Plot Reserves in 3D task.

(35)

Reports Creating a Status Report

Reserves_db.doc Page 35 of 44

Note: In the status report, an asterisk indicates coal, so the previous example shows that block 14 contains

2549 tonnes of coal (rather than 2549 tonnes of waste).

The total coal volume and coal tonnage should be within 50 of the volume and tonnage for block 14 that was reported in the Plot Reserves in 3D task.

(36)

Reports Creating a Detailed Report

Reserves_db.doc Page 36 of 44

3. Finally run a status report to find out how much coal and waste is in the entire pit.

Creating a Detailed Report

You use the detailed report to find out the values of specific quality variables in the pits, benches, strips, and blocks you select. For example, you can use this report to find out the moisture content of each of the blocks in pit 7, bench 10, strip 10.

Note: By contrast, the status report that you used in the Create a Status Report for Pit 7 task provides relative density

and ash data, but no data for any other variables.

The Detailed Report is also useful when you need to:

• use a limiting polygon to show results only within the polygon. • produce results in CSV format.

You can open CSV files in Excel. CSV format is useful when you want to calculate a total or an average of values (because you can open a CSV file in Excel and see the data in columns). This can help during scheduling when you need to work out how you will deliver coal with a specified average ash or moisture to a specific customer at a specific time.

Note: There is no meaningful quality data in the Ashes data set so you cannot create a report that provides useful

quality information. Instead you can use a detailed report to show volumes of waste and coal.

Task: Create a Detailed Report

1. Choose Reserves > Reporting > Detailed Report. 2. Fill in the form as shown in the following image:

(37)

Reports Creating a Detailed Report

Reserves_db.doc Page 37 of 44

To add the variables, click Variables Select, and select them.

Next, you will digitise a limiting polygon, but first here’s an explanation of some of the important sections and fields of the form:

Select Variables. In this section, you specify the variables to appear in the report.

Pit Selection. In this section, you specify which pits, benches, strips, blocks, and layers to include in the report.

Use Limiting Polygon. Select this check box (and then click one of the adjacent buttons) to limit the report to the area within the polygon.

Report Type. You can select .txt or .csv as the file format. On many computers, Excel is the default application for CSV files. When that is true, you can select Open CSV report in default application to make sure that the report will open in Excel after you click Ok. 3. Click Dig and digitise a limiting polygon in graphics.

(38)

Reports Creating a Detailed Report

Reserves_db.doc Page 38 of 44

5. If the CSV file opened in Excel, scroll down to the bottom of column I in Excel, and calculate the total tonnes of coal.

(39)

Reserves_db.doc Page 39 of 44

Checking Reserves

Some reports you can use to check your reserves are the Insitu Resource report and the Grid Volumetrics report.

Creating an Insitu Report

Task: Create an Insitu Resource Report for Pit 7

1. Open the following files if they are not already open:

borehole database, THEDON.B31. geometry file, THEDON.GM3.

(40)

Checking Reserves Creating an Insitu Report

Reserves_db.doc Page 40 of 44

3. Select Merged as the DD Name for seams and for quality. 4. Click Create List.

The form should appear as shown in the following image:

(41)

Checking Reserves Creating an Insitu Report

Reserves_db.doc Page 41 of 44

6. Specify that the DD Name is Merged, and the upper limit is TOPS. 7. Specify that the lower limit is PIT7 (also with a DD Name of Merged).

8. Click Ok.

9. Start the Windows calculator program (In Windows, choose Start > Run, and type Calc). 10. Perform the following calculation to find out the percentage difference, for total coal tonnes,

(42)

Checking Reserves Grid Volumetrics

Reserves_db.doc Page 42 of 44

Using the results shown in this task as an example, the equation is:

55

.

0

100

79856140

79418880

79856140

=

×

This shows that the two reports return results that are within half a percent of each other.

Grid Volumetrics

Task: Create a Grid Volumetrics Report for Pit7

1. Choose Grid > Volumes from the menu in Minex.

(43)

Summary Grid Volumetrics

Reserves_db.doc Page 43 of 44

The Grid Volumetrics report appears in the Output window.

3. Compare the combined total volume of waste and coal (that is, Volume cu. metres Nett) with the combined total volume of waste and coal from the Insitu Resource report.

In this example, the Grid Volumetrics report shows a result of about 592 million cubic meters whereas the Insitu Resource report showed a result of about 614 million cubic meters (535 waste and 79 coal).

The precise total of waste and coal from the Insitu Resource report is 535596282 + 79856140 / 1.4 = 592636382.

The percentage difference between the reports is ( (592683328 - 592636382) / 592683328) x 100 = 0.01

Therefore the Grid Volumetrics report shows 0.01% more waste and coal than the Insitu Reserves report.

Summary

Upon completion of this tutorial you should be able to: • Calculate the volumes in the blocks of your pit design. • Set up the database to store the volume data.

(44)

Summary Grid Volumetrics

Reserves_db.doc Page 44 of 44

This tutorial is designed to help you become familiar with the Reserves Database functionality in Minex. It is not designed as a training aid and should not be considered as a substitute for training.

Your local support office has access to additional training aids and can help you with advice on your particular training needs.

References

Related documents

State Procurement Law requires bid, performance, and payment security for construction contracts expected to exceed $100,000.. 7 State

R80,10 R71,20 R44,50 Monthly subscription fees – Internet, Cellphone, Telephone Banking No charge Absa ATM cash deposits. • Cash deposit Absa ATM • Cash deposit

Extra-Short Throw Lens Advanced Auto Setup Keystone Correction Wireless Image Transmission Wireless LAN Card Slot SD Memory Card Slot. Presentation

We amend the real EF data by generating a certain number of papers by author X and linking each of them with 35 randomly chosen users (35 is the average paper degree in the

(2007) noted that post-disaster reconstruction is quite similar to that of low-cost community housing projects in developing countries, but with added challenges.

Due to the increasing diversity found within the United States, and the lack of diversity found within the occupational therapy profession, are occupational therapists

1. Retailer-related human capital plays a strong role in the online consumer's store choice decision. Further, the key factors that bring customers back to an online retailer

Stenting and bypass surgery are measures that buy you that time, but the true “fix” for coronary artery disease comes with living a heart healthy lifestyle. This means losing