|
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 |
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 |
|
>=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:-