4.0 MicroMODEL COMPOSITING

4.1 Introduction

This module enables the user to enter or calculate fixed length or bench composited drill hole data, creating a composite drill hole MicroMODEL database. Once the composite data is entered or calculated, MicroMODEL has a suite of display and statistical programs that can be used to verify and analyze the composited drill hole database.

The Compositing Sub-Menu appears below:

  1. Return To Main Menu
  2. Command Shell
  3. Calculation of Composite Values
  4. Interactive Composited Drill Hole Capture
  5. Read In Existing Compositied Drill Hole Database
  6. Print Composited Drill Hole Database
  7. Database Editing (Menu)
  8. Plot Drill Hole Surface Locations
  9. Plot Composited Drill Hole Bench Locations
  10. Plot Drill Hole Sections (value or downhole ...)
  11. Composite Frequency Analysis and Basic Statistics
  12. Composite Cumulative Frequency Analysis
  13. Composite Correlation Analysis
  14. Composite Manipulation
  15. Clean-Up Directory

Many of the programs in the Compositing Sub-Menu work in exactly the same way as they do in the Data Entry Sub-Menu. The only difference is that the program works on the current Composite Label, instead of the current Sample Label.

4.2 Command Shell

This menu choice enables the user to invoke commands and run external programs without exiting MicroMODEL. This program is simply a command shell. The user enters as many commands as desired. Type "EXIT" at the command prompt to return to MicroMODEL.

4.3 Calculation of Composite Values

There are three methods available to the user for calculating composites for inclusion in a composited drill hole database:

Drill Hole Compositing: The composites are generated from the collar of the hole downward at a constant user specified composite length. The rock codes for each composite can be extracted from the previously created rock model or from the majority rock code in the corresponding sampled drill hole intervals.

Mixed Compositing: An attempt is made to Bench Composite a drill hole, where the start of the composite interval is at the top elevation (crest) of the corresponding bench and the end of the composite is at the bottom elevation (toe) of the corresponding bench. This composite length is limited by a user defined maximum composite length. If the drill hole cannot be bench composited because the composite length is longer than the maximum composite length, due to a shallow plunge, the hole is then drill hole composited as described. In the same manner as in drill hole compositing, the composite rock codes can be extracted from the rock model or from the corresponding rock codes in the sampled drill hole intervals.

Rock Unit Compositing: Composite values can be calculated as a weighted average, spanning a single geologic unit (rock code). The values used to determine the composite value will not cross a geologic boundary, as defined by the rock code. The user will specify the required composite length, and the minimum acceptable length.

In order to use this program to calculate composite data from the sample drill hole database, the number of composite data labels must correspond with the number of sample data labels. For ease in understanding, it is recommended that the composite data label names reflect name of the corresponding sample data label. The compositing program always composites the sample drill hole data labels in a one-to-one correspondence with the composite data labels.

The three methods of compositing are illustrated in the following tables. The first table lists the original drillhole assay interval information. The others list the results of the three different compositing methods. Figure 4.1 gives a graphical representation of the tables. Compositing is further discussed in Volume I, Sections 2.4 and 4.4.

                                    FIGURE 4.1
                               COMPOSITING METHODS

Drillhole Collar Information

    DRILLHOLE NAME : DDH-01
          NORTHING :  11014.500
           EASTING :  20290.700
  COLLAR ELEVATION :   5673.600
     DIP-DIRECTION :     90.00
         DIP ANGLE :     45.00
             DEPTH :    188.00
 NUMBER OF SAMPLES :   21
 NUMBER OF SURVEYS :   0
Original Drillhole Assay Interval Information
BENCH FROM TO CODE Au
5670 .00 6.60 1 0.000
5650 6.60 50.00 1 (no data)
5630 50.00 55.00 1 0.003
5630 55.00 60.00 2 0.014
5620 60.00 65.00 2 0.035
5620 65.00 70.00 2 0.027
5620 70.00 75.00 2 0.024
5610 75.00 80.00 2 0.017
5610 80.00 84.20 2 0.011
5600 84.20 123.70 3 (no data)
5580 123.70 132.90 2 0.018
5570 132.90 140.00 2 0.025
5570 140.00 145.00 2 0.045
5560 145.00 150.00 2 0.067
5560 150.00 155.00 2 0.053
5560 155.00 160.00 2 0.035
5550 160.00 165.00 2 0.074
5550 165.00 170.00 2 0.107
5550 170.00 175.00 2 0.041
5540 175.00 180.00 2 0.017
5540 180.00 188.00 3 0.000


Mixed (Bench) Compositing Method
BENCH FROM TO CODE Au
5670 .00 5.09 1 0.000
5660 5.09 19.23 1 (no data)
5650 19.23 33.38 1 (no data)
5640 33.38 47.52 1 (no data)
5630 47.52 61.66 1 0.012
5620 61.66 75.80 2 0.027
5610 75.80 89.94 2 0.014
5600 89.94 104.09 3 (no data)
5590 104.09 118.23 3 (no data)
5580 118.23 132.37 2 0.018
5570 132.37 146.51 2 0.036
5560 146.51 160.65 2 0.051
5550 160.65 174.80 2 0.074
5540 174.80 188.00 3 0.007


Drillhole Compositing Method
BENCH FROM TO CODE Au
5670 .00 10.00 1 0.000
5660 10.00 20.00 1 (no data)
5650 20.00 30.00 1 (no data)
5640 30.00 40.00 1 (no data)
5640 40.00 50.00 1 (no data)
5630 50.00 60.00 1 0.009
5620 60.00 70.00 2 0.031
5620 70.00 80.00 2 0.021
5610 80.00 90.00 3 (no data)
5600 90.00 100.00 3 (no data)
5590 100.00 110.00 3 (no data)
5590 110.00 120.00 3 (no data)
5580 120.00 130.00 2 0.018
5570 130.00 140.00 2 0.023
5570 140.00 150.00 2 0.056
5560 150.00 160.00 2 0.044
5550 160.00 170.00 2 0.090
5540 170.00 180.00 2 0.029
5540 180.00 188.00 3 0.000


Rock Unit Compositing Method
BENCH FROM TO CODE Au
5670 .00 9.17 1 0.000
5660 9.17 18.33 1 (no data)
5650 18.33 27.50 1 (no data)
5650 27.50 36.67 1 (no data)
5640 36.67 45.83 1 (no data)
5630 45.83 55.00 1 0.003
5630 55.00 64.73 2 0.024
5620 64.73 74.47 2 0.026
5610 74.47 84.20 2 0.015
5610 84.20 94.07 3 (no data)
5600 94.07 103.95 3 (no data)
5590 103.95 113.82 3 (no data)
5580 113.82 123.70 3 (no data)
5580 123.70 133.08 2 0.018
5570 133.08 142.47 2 0.030
5560 142.47 151.85 2 0.058
5560 151.85 161.23 2 0.046
5550 161.23 170.62 2 0.089
5540 170.62 180.00 2 0.028
5540 180.00 188.00 3 0.000

The ANSWERSET NAME identifies this set of answers.

The user must choose which method of compositing to use: DRILL HOLE, MIXED, or ROCK UNIT.

NOTE: For Seam Modeling, rock unit compositing is always used to calculate the composite values.

The user must specify the METHOD TO BE USED TO ASSIGN ROCK CODES TO THE COMPOSITED INTERVALS. Extracting rock codes from the ROCK MODEL results in the program determining which block (row, column, level) contains the composite midpoint location, and assigning the block model rock code for that block to the composite. This method is generally used when a representative rock model has been constructed and rock codes are used to control the grade modelling. This method will not work unless a rock model has been created under Module 4, Rock Modelling.

Using the SAMPLED DRILL HOLE INTERVALS to obtain the rock codes for the composites instructs the Compositing program to calculate which rock code from the sampled intervals occupies the largest part of the composite length. The composite then receives this most common sampled rock code. This method is often used when thorough control of the grade modelling by rock type is not necessary.

If drill hole compositing or rock unit compositing is requested, the user must specify the desired COMPOSITE LENGTH. The MINIMUM COMPOSITE LENGTH controls how long composites at the bottom of the drill hole must be to receive composited assay values. If the bottom composite length is less than the minimum composite length, then the bottom composite is assigned unsampled assay values for all labels.

Mixed compositing requires both a minimum and maximum acceptable composite length. The MINIMUM COMPOSITE LENGTH controls how long composites at the top and bottom of the drill hole must be to receive composited assay values. If the top and/or bottom composited lengths are less than the minimum composite length, then they are assigned unsampled assay values for all labels. The MAXIMUM COMPOSITE LENGTH determines if shallow plunging drill holes should be bench composited or drill hole composited. With shallow drill holes it is possible to have composite lengths which are much longer than normal composite lengths. This may be undesirable, and the Maximum Composite Length limits the length of the composite. If a drill hole is encountered that exceeds the Maximum Composite Length, then the drill hole is automatically composited at a fixed length down the hole (drill hole compositing) using a composited interval length equal to the bench height.

4.4 Convert Multiple Text Files to Standard Drill Hole Input

This program replaces the interactive drillhole input program from previous versions of MicroMODEL. It allows the user to convert a set of separate ASCII text files containing drillhole collar, survey, assay, and optional geology information into a single, standard MicroMODEL input file that can be read with the next program choice (4.5). These separate text files can easily be created with any spreadsheet program, or with a database program such as MicroSoft Access. Refer to Section 1.4 for details.

4.5 Read in an Existing Composited Drill Hole Database

This program allows the user to read an existing ASCII composited drill hole database into MicroMODEL. The program works in exactly the same manner as the program listed in section 1.5, Read in an Existing Drill Hole Database. The only difference is that the user is creating data stored in the composited data files (CHED, COMP), as opposed to creating data stored in the sample interval files (SHED, SAMP). Refer to section 1.5 for details.

4.6 Print Composited Drill Hole Database

This program will output all or part of the composited drill hole database. It works in exactly the same manner as the program described in section 1.6, Print Drill Hole Database. The only difference is that the program will output data stored in the composited data files (CHED, COMP), as opposed to data stored in the sample interval files (SHED, SAMP). Table 4-2 contains examples of both Report Format and Free Format Output. Refer to section 1.6 for details.

4.7 Database Editing (Menu)

The Database Editing Menu allows the user to edit and manipulate the entered composite drill hole data. These programs works in exactly the same manner as the programs described in section 1.7, Database Editing. The only difference is that the user is working on data stored in the composited data files (CHED, COMP), as opposed to working on data stored in the sample interval files (SHED, SAMP). Refer to section 1.7 for details.

4.8 Plot Drill Hole Surface Locations

This option allows the user to produce a plan view map (plot) of the drill hole collar locations. Refer to section 1.8 for details.

4.9 Plot Drill Hole Bench Locations

This option allows the user to produce a plan view map of composited drill hole pierce point locations at the mid point elevation for a specified bench. This program works in exactly the same manner as the program described in section 1.9, Plot Drill Hole Bench Locations. The only difference is that the user is displaying data stored in the composited data files (CHED, COMP), as opposed to displaying data stored in the sample interval files (SHED, SAMP). Refer to section 1.9 for details.

4.10 Plot Composite Drill Hole Sections

This program produces a cross section plot of drill holes and the topographic projection onto any user specified vertical plane. The user may plot either drill hole sample intervals, drill hole composite intervals, or both. Refer to section 1.10 for details.

4.11 Composite Frequency Analysis and Basic Statistics

This option allows the user to perform basic statistics on the current composite data label in the Composite Drill Hole database. It works in exactly the same manner as the program that calculates Sample Frequency Analysis and Basic Statistics, except that it works on data stored in the composited data files (CHED, COMP), as opposed to working on data stored in the sample interval files (SHED, SAMP). Refer to section 1.11 for details.

4.12 Composite Cumulative Frequency Analysis

This option allows the user to produce an unscaled cumulative frequency curve plot of the composite drill hole data. It works in exactly the same manner as the program that performs Sample Cumulative Frequency Analysis, except that it works on data stored in the composited data files (CHED, COMP), as opposed to working on data stored in the sample interval files (SHED, SAMP). Refer to section 1.12 for details.

4.13 Composite Correlation Analysis

This option allows the user to produce a correlation analysis (linear regression) plot between any two labels in the composite drill hole database. It works in exactly the same manner as the program that performs Sample Correlation Analysis, except that it works on data stored in the composited data files (CHED, COMP), as opposed to working on data stored in the sample interval files (SHED, SAMP). Refer to section 1.13 for details.

4.14 Composite Manipulation

This program allows the user to write composite label data that has been artifically massaged into existing composite data labels in the composite drill hole database. It works in exactly the same manner as the program that performs Sample Manipulation, except that it works on data stored in the composited data files (CHED, COMP), as opposed to working on data stored in the sample interval files (SHED, SAMP). Refer to section 1.14 for details.

4.15 Clean-Up Directory

This option allows the user to delete all output files created in the Data Entry Module that are no longer needed in the MicroMODEL system. The files that will be deleted are listed when the program is invoked. The output files that are deleted can always be recreated by MicroMODEL at a later date as needed. Periodically running this program increases usable disk space.