Process Help

TABRES - create tabulated reserve reports from a results file

 

Process Name

Menu Path

Link to Command Table

TABRES

Report ribbon | Report | Calculate Reserves| | Tabulate Reserves

Click here

 

Introduction

Produces reserve tabulations from a results file produced by other processes (e.g. MODRES.) or interactive evaluation of a block model or drillholes using perimeters or wireframes.

How to use

Several different types of reserve reports may be produced, as chosen interactively. One single execution of TABRES produces the chosen table.

The input results file defines the details that may be produced. For example, if there are no grade intervals in the results file, then no grade interval reports are available.

A maximum of five grades may be reported at once, although there may be more than five grades in the results file. The user may choose up to five to be reported at any time. Note that grade intervals (if any) refer to the main grade, which is the one reported first. Even if the main grade should not be among those reported in TABRES, grade intervals will still refer to this field.

Classification by Ore, Waste etc.

The results file may contain a rocktype field which classifies the records by rocktype. This classification may be either by given values of the field, or by a set of standard classifications which are ORE, WSTE, AIR, S1, S2, S3, S4, S5, S6 and S7. If this latter was chosen when the results file was established (see for example PITEVA for details) then it is possible to use this classification in the reports and for stripping ratio calculations. In this context, waste is assumed to be everything which is not classified as ORE.

However, if no such classification is available in the results file, it is still possible to classify into the two categories ORE and WSTE by use of a cut-off grade. All material which is above the given cut-off will be classified as ORE; all material which is below or equal to the cut-off will be classified as WSTE.

If ORE, WSTE, etc. classification is available, and a cut-off grade is also specified, then this is used to re-classify ORE material into WSTE if the value of the main grade is below or equal to the cut-off given. No other classifications are affected.

Classification by use of the cut-off will be carried out on the mean main grade within each grade interval; or, if there are no grade intervals, on the overall mean main grade. Note that this could give rise to some inaccuracies if the cut-off specified does not correspond to the grade interval boundaries.

Planes

The results file may contain records for any number of the four recognized PLANE identifiers LEVEL, COLUMN, ROW or SECTION. However, TABRES operates on records from a single plane at a time, and ignores all others. The default plane is LEVEL; this may be changed during interaction.

Reports

The standard reports are as follows:-

1

 Summary for each plane. A single line is produced for each plane, showing the total volume and tones mined and the mean of each grade evaluated. Totals over all planes are shown.

 

2

Summary for each perimeter. A single line is produced for each perimeter, showing the total volume and tones mined and the mean of each grade evaluated. Totals over all perimeters are shown.

 

3

Summary for each perimeter and each plane. A single line is produced for each perimeter in each plane, showing the total volume and tones mined and the mean of each grade evaluated. Totals are also shown for each plane and overall.

 

4

Full report. For each rocktype within each perimeter within each plane, a page is produced showing the total volumes and tones mined by grade interval (if any). A cut-off grade table is also produced. Totals are shown for all rocktypes within each perimeter, for all perimeters within each plane, and for all planes.

 

5

Ore and waste summary for each plane. For each plane a page is produced showing mean grades for ore, waste and other classifications. These classifications may be either by use of a rocktype field in the results file showing ORE, WSTE, S1-S7 values, or by a cut-off grade which is applied to the main grade value, or by both simultaneously. Stripping ratios (volumetric and tonnage) are calculated, and a cut-off grade table is also shown. Totals over all planes are shown.

 

6

Ore and waste summary for each perimeter. This report has the same format as 5 above, but results for each perimeter are reported. Totals over all perimeters are shown.

 

7

Ore and waste totals. This is a single page showing the totals over all evaluations, with mean grades for each classification ORE, WSTE etc. It is the total page produced by reports 5 or 6 above.

 

8

Full report, as in 4 above, for ore; but summaries for all non-ore rocktypes. This report is similar in form to 6 above, but with the extra detail for ore, where all grade intervals are reported.

 

TABRES has been designed for the user to add in special purpose reports as required. This is done by adding a new reporting subroutine into the existing structure.


Files, Fields and Parameters

Input Files

Name

Description

I/O Status

Required

Type

RESULTS

The input results file. This must contain at least the following fields:- MODEL A,8 : Model name (implicit). PERIMIN A,8 : Perimeter file name (implicit). TYPE A,8 : Blank or BALANCE. PLANE A,8 : LEVEL, COLUMN, ROW, SECTION. NUMBER N : Plane number. SEQUENCE N : Evaluation number in plane. PERIMID N : Perimeter identifier. DENSITY N : Mean density. VOLUME N : Total volume evaluated. TONNES N : Total tonnage evaluated. Optional fields: INTERVAL N : Grade Interval number. LOWER N : Lower bound (included). UPPER N : Upper bound (excluded). <rocktype> A/N : Rocktype field. <grade1> N : First grade field. TONNESA N : Tonnes for first grade. <grade2> N : Second grade field. TONNESB N : Tonnes for second grade. ---- repeated for each grade field -----

Input

Yes

Undefined

Output Files

Name

I/O Status

Required

Type

Description

Parameters

Name

Description

Required

Default

Range

Values

PRINT

>=1 : print all tables, even if volumes are zero. Default is omit zero tables (0).

No 0 0,1 0,1

Notes

The process carries out an internal sort so that plane NUMBERs are always reported in ascending order, regardless of the order of records on the results file. In general the process works regardless of record order; but in case of problems, sort the file on fields NUMBER, PERIMID, SEQUENCE,<rocktype>. PERIMIDs may be the same provided they have a different SEQUENCE or NUMBER.

>The SEQUENCE field is used by MODRES to differentiate sets of perimeters on the same bench. Thus, to obtain results for a single pit extension where there are several in the same results file, use retrieval criteria on SEQUENCE.

Sub-menu Commands

TABULATION INFORMATION

The standard set of parameters are:- Bench records will be selected (PLANE='LEVEL') Output table 4 (details of all grade intervals within rocktypes, within perimeters, plus totals) Up to 5 grade values will be reported (first in file) The report will be echoed to the printer or print file No special run title Unscaled volumes and tonnages. Enter Y or Yes or <return> to accept; Enter N or No to modify these values. >YES/NO > Y, Yes or <return> to accept: N or No to enter parameters.

PLANE SELECTION

Available planes are : 1 LEVEL 2 COLUMN 3 ROW 4 SECTION Enter required number (1-4) >PLANE > Enter 1-4.

OUTPUT TABLE SELECTION

Available tables are:- 1 Summary for each plane 2 Summary for each perimeter 3 Summary for each plane and perimeter 4 Full report for all grade intervals in each rocktype and perimeter and totals. 5 Ore and waste summary for each plane. 6 Ore and waste summary for each perimeter. 7 Ore and waste totals. 8 Full report, as 4, but summaries only for waste rocktypes. 9 Ore and waste summary for each plane (Phelps Dodge). 10-12 Reserved for customized reports. Default is [4] >REPORT > Enter 1-9. Any illegal response will cause the question to be repeated.

If there are any grade fields:

>Grade fields selected: AU ZONE [Y]/N > Enter Y to accept, N to reject.

If the selected grade fields are rejected:

GRADES FOR EVALUATION

Available grade names are:- <listing of available field names> Choose up to 5 for evaluation, terminated by a blank line:- >FIELD > Enter up to 5 grade field names, one per line. The Field Name may optionally be followed by No of Decimal Places to be reported for field. Terminate with a blank line.

If the selected fields are accepted:

CUTOFF FOR FIELD nnnnnnnn

Enter cut-off grade for field definition or '-' to omit cut-off classification. Default is [ - ]

If there is in the results file a rocktype classification by standard class, the additional message will be displayed:-

>Note that any cut-off specified may change existing ORE classification. Grades must be >= cut-off and ORE to remain as ore, otherwise they become WSTE. Existing WSTE etc. classifications remain unchanged.

CUT-OFF> Enter the required cut-off grade for the given field, or - to ignore cut-off. This will only be used for reports 5-8 currently. An illegal response will couse the prompt to be given again. Defaults is [ - ]

RUN TITLE

Enter up to 40 characters of title:

VOLUME AND TONNAGE FACTOR

Enter the factor by which all volumes and tonnages will be divided (e.g. 1000 for thousands of tones) Default value is 1.0 if <return> entered. >FACTOR > Enter required factor.

TABLE OUTPUT TO PRINTER

Enter 1 to echo output to print file. Enter 0 (or <return>) to show table on screen only.

 


Example

!TABRES &RESULTS(PITRESLT)


TABULATION INFORMATION 
====================== 
The standard set of parameters are:- 
Bench records will be selected (PLANE='LEVEL') 
Output table 4 (details of all grade intervals within 
rocktypes, within perimeters, plus totals) 
Up to 5 grade values will be reported (first in file) 
The report will be echoed to the printer 
No special run title 
Unscaled volumes and tonnages. 
Enter Y or Yes or <return> to accept; 
Enter N or No to modify these values. 
YES/NO>y

TABRES REPORT 1

Summary for each Plane:

RESERVE TABULATION :Summary for each bench
==========================================
Summary Report for each LEVEL
================================


------------------------------------------------
I LEVEL     I     VOLUME I     Fe I     TONNES I
------------------------------------------------
I         1.I     140189.I   46.42I     322435.I
------------------------------------------------
I         2.I     120422.I   46.60I     276971.I
------------------------------------------------
I         3.I     102170.I   46.88I     234991.I
------------------------------------------------
I         4.I      85393.I   47.43I     196404.I
------------------------------------------------
I         5.I      69985.I   47.85I     160965.I
------------------------------------------------
I         6.I      56238.I   47.87I     129348.I
------------------------------------------------
I         7.I      43917.I   47.43I     101009.I
------------------------------------------------
I         8.I      33119.I   46.79I      76175.I
------------------------------------------------
I         9.I      23868.I   46.75I      54897.I
------------------------------------------------
I        10.I      16116.I   45.66I      37068.I
------------------------------------------------
------------------------------------------------
I    TOTALS I     691418.I   46.98I    1590261.I
------------------------------------------------
 

TABRES REPORT 2

Summary for each Perimeter:
 

RESERVE TABULATION :Summary for each perimeter
==============================================

Summary Report for each perimeter
=================================

----------------------------------------------
I   PERIM I     VOLUME I     Fe I     TONNES I
----------------------------------------------
I     1.00I     133539.I   46.46I     307140.I
----------------------------------------------
I     1.02I       6650.I   45.59I      15295.I
----------------------------------------------
I     2.00I     114205.I   46.65I     262672.I
----------------------------------------------
I     2.02I       6217.I   45.76I      14299.I
----------------------------------------------
I     3.00I      96466.I   46.94I     221872.I
----------------------------------------------
I     3.02I       5704.I   45.91I      13119.I
----------------------------------------------
I     4.00I      80219.I   47.51I     184505.I
----------------------------------------------
I     4.02I       5173.I   46.27I      11899.I
----------------------------------------------
. and so on
.
----------------------------------------------
I     9.00I      21251.I   46.68I      48877.I
----------------------------------------------
I     9.02I       2617.I   47.33I       6020.I
----------------------------------------------
I    10.00I      14022.I   45.48I      32250.I
----------------------------------------------
I    10.02I       2095.I   46.90I       4817.I
----------------------------------------------
----------------------------------------------
I  TOTALS I     691418.I   46.98I    1590261.I
----------------------------------------------
 

TABRES REPORT 3

Summary for each Perimeter and each Plane:

 

RESERVE TABULATION :Summary for each bench and perimeter
========================================================
Summary Report for each perimeter in each LEVEL
==================================================

--------------------------------------------------
I  LEVEL I  PERIM I  VOLUME I    Fe I     TONNES I
--------------------------------------------------
I      1.I    1.00I  133539.I  46.46I     307140.I
--------------------------------------------------
I      1.I    1.02I    6650.I  45.59I      15295.I
--------------------------------------------------
I      1.I  TOTAL I  140189.I  46.42I     322435.I
--------------------------------------------------
I      2.I    2.00I  114205.I  46.65I     262672.I
--------------------------------------------------
I      2.I    2.02I    6217.I  45.76I      14299.I
--------------------------------------------------
I      2.I  TOTAL I  120422.I  46.60I     276971.I
--------------------------------------------------
I      3.I    3.00I   96466.I  46.94I     221872.I
--------------------------------------------------
I      3.I    3.02I    5704.I  45.91I      13119.I
--------------------------------------------------
I      3.I  TOTAL I  102170.I  46.88I     234991.I
--------------------------------------------------
. and so on
.
--------------------------------------------------
I     10.I   10.00I   14022.I  45.48I      32250.I
--------------------------------------------------
I     10.I   10.02I    2095.I 46.90I        4817.I
--------------------------------------------------
I     10.I  TOTAL I   16116.I 45.66I       37068.I
--------------------------------------------------
--------------------------------------------------
I          TOTALS I  691418.I 46.98I     1590261.I
--------------------------------------------------
 

TABRES REPORT 4

Full Report:

 

RESERVE TABULATION :Full report
===========================================

******************************************
*                                        *
* EVALUATION PLANE     *     LEVEL       *
*                                        *
* PLANE NUMBER         *     10.00       *
*                                        *
* PERIMETER IDENTIFIER *     10.02       *
*                                        *
******************************************

----------------------------------------------
I   FROM I   TO I   VOLUME I    Fe I  TONNES I
----------------------------------------------
I   46.00I 47.00I     1305.I  46.60I    3001.I
I   47.00I 48.00I      790.I  47.39I    1817.I
----------------------------------------------
I        TOTALS I     2095.I  46.90I    4817.I
----------------------------------------------

CUT-OFF GRADE TABLE
===================

----------------------------------------------
I   ABOVE I   VOLUME I     Fe I       TONNES I
----------------------------------------------
I   46.00 I     2095.I   46.90I         4817.I
I   47.00 I      790.I   47.39I         1817.I
----------------------------------------------


TABRES REPORT 4

Full Report - Perimeter details RESERVE TABULATION :Full report
===========================================

******************************************
*                                        *
* EVALUATION PLANE     *     LEVEL       *
*                                        *
* PLANE NUMBER         *     10.00       *
*                                        *
* TOTALS OVER ALL PERIMETERS IN PLANE    *
* ===================================    *
******************************************

Volume in perimeters but not in model : 0.00
----------------------------------------------
I   FROM I    TO I  VOLUME I    Fe I  TONNES I
----------------------------------------------
I   43.00I  44.OOI    2000.I  43.25I    4600.I
I   44.00I  45.00I    2000.I  44.61I    4600.I
I   45.00I  46.00I    4536.I  45.56I   10434.I
I   46.00I  47.00I    6196.I  46.47I   14250.I
I   47.00I  48.00I    1384.I  47.40I    3183.I
----------------------------------------------
I     TOTALS I       16116.I  45.66I   37068.I
----------------------------------------------

 

CUT-OFF GRADE TABLE
===================

----------------------------------------------
I     ABOVE I    VOLUME I     Fe I    TONNES I
----------------------------------------------
I     43.00 I     16116.I   45.66I     37068.I
I     44.00 I     14116.I   46.00I     32468.I
I     45.00 I     12116.I   46.23I     27868.I
I     46.00 I      7580.I   46.64I     17434.I
I     47.00 I      1384.I   47.40I      3183.I
----------------------------------------------

 

TABRES REPORT 4
Full Report - Perimeter Totals RESERVE TABULATION :Full report
===========================================
******************************************
*                                        *
* EVALUATION PLANE     *     LEVEL       *
*                                        *
* TOTALS OVER ALL PLANES                 *
* ======================                 *
******************************************
Volume in all perimeters but not in model : 0.00
----------------------------------------------
I   FROM I     TO I  VOLUME I    Fe I TONNES I
----------------------------------------------
I   43.00I   44.00I    4449.I  43.35I  10233.I
I   44.00I   45.00I   13568.I  44.60I  31207.I
I   45.00I   46.00I   91206.I  45.60I 209774.I
I   46.00I   47.00I  262648.I  46.54I 604091.I
I   47.00I   48.00I  229140.I  47.44I 527021.I
I   48.00I   49.00I   60460.I  48.38I 139473.I
I   49.00I   50.00I   16710.I  49.46I  38432.I
I   50.00I  100.00I   13057.I  51.42I  30041.I
----------------------------------------------
I         TOTALS I   691418.I  46.98I1590261.I
----------------------------------------------
 

CUT-OFF GRADE TABLE
===================
----------------------------------------------
I   ABOVE I   VOLUME I     Fe I       TONNES I
----------------------------------------------
I   43.00 I   691418.I   46.98I      1590261.I
I   44.00 I   686969.I   47.01I      1580028.I
I   45.00 I   673401.I   47.05I      1548821.I
I   46.00 I   582195.I   47.28I      1339047.I
I   47.00 I   319546.I   47.89I       734956.I
I   48.00 I    90406.I   49.02I       207935.I
I   49.00 I    29766.I   50.32I        68462.I
I   50.00 I    13057.I   51.42I        30030.I
----------------------------------------------

TABRES REPORT 4
Full Report - Overall Totals RESERVE TABULATION :Ore and waste summary for each bench
========================================================

RESULTS FOR LEVEL 3.
========================
------------------------------------------
I         I   ORE    I    WSTE  I   SUM  I
------------------------------------------
I Fe      I     48.02I     46.02I 4  6.88I
------------------------------------------
I VOLUME  I    38000.I    64170.I 102170.I
I TONNES  I    87400.I   147591.I 234991.I
------------------------------------------
Stripping ratios : Vol waste/Vol ore = 1.69

Vol waste/Tonnes ore = 0.73

Note: waste is taken as all non-ore material.
 

CUT-OFF GRADE TABLE
===================

----------------------------------------------
I   ABOVE I   VOLUME I     Fe I       TONNES I
----------------------------------------------
I   43.00 I   102170.I   46.88I       234991.I
I   44.00 I   101170.I   46.92I       232691.I
I   45.00 I    99270.I   46.96I       228320.I
I   46.00 I    84184.I   47.19I       193624.I
I   47.00 I    38000.I   48.02I        87400.I
I   48.00 I    13000.I   49.07I        29900.I
I   49.00 I     6000.I   49.68I        13800.I
I   50.00 I     2000.I   50.26I         4600.I
----------------------------------------------



TABRES REPORT 5

Ore and Waste Summary for each Plane RESERVE TABULATION :Ore and waste summary for each perimeter:

 

============================================================

RESULTS FOR PERIMETER 8.00
===============================

------------------------------------------
I         I     ORE I     WSTE I     SUM I
------------------------------------------
I    Fe   I    47.47I     46.30I    46.72I
------------------------------------------
I VOLUME  I   10751.I    19257.I   30008.I
I TONNES  I   24727.I    44291.I   69018.I
------------------------------------------
Stripping ratios : Vol waste/Vol ore = 1.79

Vol waste/Tonnes ore = 0.78

Note: waste is taken as all non-ore material.
 

CUT-OFF GRADE TABLE
===================

----------------------------------------------
I     ABOVE I     VOLUME I     Fe I   TONNES I
----------------------------------------------
I     44.00 I      30008.I   46.72I    69018.I
I     45.00 I      28008.I   46.90I    64418.I
I     46.00 I      26008.I   47.00I    59818.I
I     47.00 I      10751.I   47.47I    24727.I
I     48.00 I       1108.I   48.40I     2549.I
----------------------------------------------

TABRES REPORT 6

Ore and Waste Summary for each Perimeter RESERVE TABULATION :Ore and waste summary for each bench
========================================================

**************************
*                        *
* TOTALS OVER ALL PLANES *
* ====================== *
**************************

------------------------------------------
I          I   ORE  I   WSTE   I   SUM   I
------------------------------------------
I    Fe    I  47.89 I   46.20  I  46.98  I
------------------------------------------
I  VOLUME  I 319546.I   371872.I  691418.I
I  TONNES  I 734956.I   855305.I 1590261.I
------------------------------------------
Stripping ratios : Vol waste/Vol ore = 1.16

Vol waste/Tonnes ore = 0.51

Note: waste is taken as all non-ore material.
 

CUT-OFF GRADE TABLE
===================

----------------------------------------------
I     ABOVE I     VOLUME I    Fe I    TONNES I
----------------------------------------------
I     43.00 I     691418.I  46.98I   1590261.I
I     44.00 I     686969.I  47.01I   1580028.I
I     45.00 I     673401.I  47.05I   1548821.I
I     46.00 I     582195.I  47.28I   1339047.I
I     47.00 I     319546.I  47.89I    734956.I
I     48.00 I      90406.I  49.02I    207935.I
I     49.00 I      29766.I  50.32I     68462.I
I     50.00 I      13057.I  51.42I     30030.I
----------------------------------------------
 


Error and Warning Messages

Message

Description

Solution

>>> NOT A VALID RESULTS FILE <<<

>>> FIELD nnnnnnnn MISSING OR WRONG TYPE <<<

>>> ERR 103 <<< ( fieldno) IN LEGFIL

One or more of the fields MODEL, PERIMIN, TYPE, PLANE, NUMBER, SEQUENCE, PERIMID, DENSITY, VOLUME, TONNES was missing or wrong type. Fatal; the process is exited.

Check for the existence and type of fields MODEL, PERIMIN, TYPE, PLANE, NUMBER, SEQUENCE, PERIMID, DENSITY, VOLUME, TONNES in the &RESULTS file.

 

 

 

>>> NO RESULT RECORDS FOR PLANE pppppppp <<<

There were no records matching the requested plane. Fatal; the process is exited.

 

 

 

 

>>> WARNING - ILLEGAL GRADE INTERVAL. RECORD IGNORED <<<

The grade interval from the INTERVAL field was not in the range 1-20. The record is ignored.

 

 

 

 

>>> ERROR - MORE THAN ONE ENTRY FOR GRADE INTERVAL <<<

More than one grade interval (value of INTERVAL field) was found for a particular rocktype, perimid, sequence, number combination. The results file is probably corrupt. Fatal; the process is exited.

 

If TABRES is being run from a macro or menu, then errors will cause termination of the process in place of re-requesting the information. Other errors are described below:-