Examples

The following section contains detailed examples of Advanced Block Model Report configuration in a number of scenarios. The following scenarios are investigated:

 

Source Block Model

  • Block model prepared from Pit Optimiser results containing fields for:

    • Enriched and Depleted materials

    • Gold and Arsenic

    • RESCAT codes: 1 = Measured, 2 = Indicated, 3 = Inferred

    • Classification from Optimisation Results: Ore, Mixed, Waste, Air

    • Topography, end-of-period surfaces and incremental pit solids

A sample of the structure in the input block model is displayed here:

Note: Importantly, the Input Block Model file sampled above contains a RESCAT field which indicates the Resource Classification for each block. In the examples which follow, the RESCAT field will be used to configure and group the various report scenarios.

Configuration

For the above Source Block Model, the following configuration would be applied:

On the Input tab of the Advanced Block Model Report, the block model should be selected in the File field. The East, North a Z fields would be set to North, East and Z respectively. No Spatial Constraint Condition should be active in the grid.

On the Output tab of the Advanced Block Model Report form, the File and Excel options should be selected and the relevant File, Type and Sheet Name values entered. Optionally enter a Title for the File. Select both the Auto open file for editing and Open file after export options. You do not need to select the Include metadata header option.

Single Material

The following scenarios are examples of configuration for Single Material reports with various grouping formats.

Configuring Single Material

To report for Single Material, the option should be selected on the Materials tab and a Default Density of 2.5 entered, as below:

All other options on the Materials tab can be left at the default.

On the Reported Values tab, all Material Quantities should be active, with the default Labels and Units, a Scale by value of 1 and Round to the nearest 1 for Volume, 0.001 for Density and 1 for Mass, as below:

In the Attributes grid on the Reported Values tab, configure an attribute for Gold, active for Report, with the Gold by mass equivalent Field selected, a g/t Unit value with a Weighting of Mass Round to 0.0001. For the Quantity values, the Report option is active with a Unit value of ozt and Round to 1. This configuration appears as follows:

Report by Domain

To report the Single Material you have configured by Domain, the following Rows and Columns should be configured on the Groups tab:

Row Groups

Column Groups

Report by Resource Classification from Codes

To report the block model by Resource Classification from assigned codes, the following configuration can be created in the Groups tab: 

Labelled Expressions in Rows

In the Row Groups grid, configure the following Labelled Expressions group:

The Labelled Group Expressions for the Resource Classification from Codes Definition should appear as follows:

Distinct Values in Columns

In the Column Groups grid, configure the following Distinct Values group:

The expression used for the Group By Field is as follows:

if ([RESCAT] == 1) then
"Measured"
elif ([RESCAT] == 2) then
"Indicated"
elif ([RESCAT] == 3) then
"Inferred"
else
"Unclassified"
endif

Report by Resource Classification with Subtotals

To report the block model by Resource Classification with subtotals , the following configuration can be created in the Groups tab in the Row Groups grid: 

The expression used for the Group By Field for each Row Group is as follows:

if ([RESCAT] == 1) | ([RESCAT] == 2) then
"Measured or Indicated"
elif ([RESCAT] == 3) then
"Inferred"
else
"Unclassified"
endif

 

Report Group with Custom Category Order

To report the block model report groups with a custom category order, the following configuration is required:

Distinct Values

The following Row Groups should be defined on the Groups tab:

The expression used to define the Group By Field for the Classification Group Group Label is as follows:

if ([RESCAT] == 1) | ([RESCAT] == 2) then
"A: Measured or Indicated"
elif ([RESCAT] == 3) then
"B: Inferred"
else
"C: Unclassified"
endif

The expression used to define the Group By Field for the Resource Classification Group Label is as follows:

if ([RESCAT] == 1) then
"1: Measured"
elif ([RESCAT] == 2) then
"2: Indicated"
elif ([RESCAT] == 3) then
"3: Inferred"
else
"4: Unclassified"
endif

Labelled Expressions

The following labelled expressions can be alternately used to preserve the order of definition for the report:

The Labelled Group Expressions Definition for the Classification Group Group Label is configured as follows:

The Labelled Group Expressions Definition for the Resource Classification Group Label is configured as follows:

Report by Domain and Resource Classification at Cutoff

To group the report by Domain and Resource Classification at Cutoff, the following configuration is required:

Cutoff (Bins)

Setting up the Distinct Values and Cutoffs (Bins) for the report requires a Row Group and Column Groups as follows:

Row Groups

For the Resource Classification Group Label, use the Group By Field expression from the Distinct Values in Columns section above.

Column Groups

The Cutoffs (Bins) Definition for the Gold Cutoff Group Label is as follows:

Block Model Filter

To limit the information considered by the report, a Block Model Input Filter can be created as follows:

This filter will limit the reported information to blocks with a Gold_ByMassInSitu value greater or equal to 1.5.

Report at Different Cutoffs for Different Elevations

To report the block model at different cutoffs for different elevations, the following configuration with alternate expressions can be applied:

 

The initial expression for the Mined Group Label is as follows:

if ([Z] > 180) & ([Gold_ByMassInSitu] >= 0.5) then
"Open Pit"
elif ([Z] <= 180) & ([Gold_ByMassInSitu] >= 1.0) then
"Underground"
else
"Below Cutoff"
endif

Alternatively, the following expression can be used for reporting information on a different elevation:

if ([Z] > 110) & ([Gold_ByMassInSitu] >= 0.5) then
"Open Pit"
elif ([Z] <= 110) & ([Gold_ByMassInSitu] >= 1.0) then
"Underground"
else
"Below Cutoff"
endif

Report Grade-Tonnage Curve

To report the grade-tonnage curve for the block model, the following configuration can be applied. The Gold Cutoffs Cutoffs (Cumulative) type Group Label should be filled as follows:

The Gold Cutoffs Cutoffs Set is configured as follows:

Report by Year and Month from Calculated Dates

To report the block model by year and month from calculated dates, the following Row Groups must be configured. In addition, separate expressions are used for the Year Group Label and Month Group Label Group By Field.

Note: for the Groups configuration, both the Report ungrouped material and Report grand total options should be selected.

The expression for the Year Group Label Group By Field is as follows:

if ([ExtractionNumber] > 0) then
YEAR(ADDDAYS(TODATE(2024, 7, 1), [ExtractionNumber] * 30))
else
{BLANK}
endif

The expression for the Month Group Label Group By Field is as follows:

if ([ExtractionNumber] > 0) then
MONTH(ADDDAYS(TODATE(2024, 7, 1), [ExtractionNumber] * 30))
else
{BLANK}
endif
 

 

Multiple Materials and Spatial Filters

For Multiple Materials reporting examples, the following Enriched and Depleted Materials and Attributes are configured:

For the Reported Values tab, the following details should be configured:

Report Material Bins by Bench within Solid

To report the material bins for the model by bench within the solid, the following Spatial Constraint Condition should be configured for the Input block model:

On the Groups tab, the following Row Groups and Column Groups should be configured:

Report Multiple Materials by Accessibility and Pit Optimisation Classification Below Surface

A below surface wireframe can be configured as a spatial constraint condition and reported on with the Advanced Block Model Report. The following is an example of the below surface wireframe displayed:

To report multiple materials for a below surface wireframe by accessibility and pit optimisation classification, the following configuration should be applied:

On the Groups tab of the form, the following Row Groups and Column Groups should be configured:

Row Groups

The expression for the Group By Field for the Accessible? Group Label is as follows:

if (!STARTSWITH([Classification],"Inaccessible")) then
"1: Yes"
esle
"2. No"
endif
 
Column Groups

The expression for the Group By Field for the Materialcolumn Group Label is as follows:

=[Material]
 

Report by Ranges of Benches between Surfaces

The following block model example illustrates pit benches between surfaces:

To report by ranges of benches between surfaces, the following configuration should be applied:

On the Groups tab of the form, the following Row Groups and Column Groups should be configured:

Row Groups

The Labelled Group Expression Definition for the Band Group Label is configured as follows:

Column Groups

Report Gold Mass by Solid and Bench between Surfaces

To report Gold Mass between surfaces by solid and bench, the following configuration should be applied:

On the Materials tab of the form, the Materials grid for Multiple Materials should be configured as follows:

On the Reported Values tab of the form, the following configuration should be applied:

On the Groups tab of the form, the following Row Groups and Column Groups should be configured:

Row Groups

The Labelled Group Expression Definition for the Band Group Label is configured as follows:

Column Groups

Report Solids by Bench and Nested Pit by Classification within Elevation Ranges within Polygon

To report solids within Elevation ranges within a polygon, by bench and nested pit, by classification, the following configuration should be applied:

On the Groups tab of the form, the following Row Groups and Column Groups should be configured:

Row Groups

The Group By Field expression used for the Nested Pit Solid Group Label is as follows:

REPLACE([Name], "Incremental |","Pit")
 
Column Groups

 

Report Grade-Tonnage Curve within Nested Pit Solids

To report the grade-tonnage curve within nested pit solids, the following configuration should be applied.

On the Materials tab of the form, the Multiple Materials options are as displayed below:

On the Groups tab, the following Row Groups and Column Groups should be configured:

 

Row Groups

The Gold Cutoffs Group Label Definition should be created as follows:

Column Groups

Input Block Model