Mine Sight For Long Term Planning
Mine Sight For Long Term Planning
Mine Sight For Long Term Planning
c
2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009 by Leica Geosystems AG. All rights reserved. No part of this document shall be
reproduced, stored in a retrieval system, or transmitted by any means, electronic, photocopying, recording, or otherwise, without written
permission from Leica Geosystems AG. All terms mentioned in this document that are known to be trademarks or registered trademarks of
their respective companies have been appropriately identified. MineSight
is
R a registered trademark of Leica Geosystems AG. This material
is subject to the terms in the Hexagon Mining Terms and Conditions (available at www.hexagonmining.com).
MineSight
for
Long Term
Planning
MineSight: Exploration to Production
MineSight software is a comprehensive mine planning platform offering integrated solutions for
exploration, modeling, design, scheduling and production. It uses raw data — from drillholes,
blastholes, underground samples and other sources — to derive 2D and 3D models essential to
mine design and planning. Below the ground or at the surface, from precious metals to base
metals, for coal, oil sands and industrial minerals, MineSight software tackles geomodeling mining
applications to improve productivity at every stage of a mine’s life.
GEOMETRIES
Use digitized data to define geologic information in section or plan; define topography contours;
and define structural information, such as mine designs, important in the evaluation of an ore
body. Virtually every phase of a project, from drillholes to production scheduling, either uses or
derives geometric data. MineSight software lets you create, manipulate, triangulate and view
any geometric data as 2D or 3D elements.
DRILLHOLES
Manage drillhole, blasthole and other
sample data in a Microsoft SQL Server
database. The data can be validated,
manipulated and reported; and it is
fully integrated with other MineSight
products for coding, spearing, com-
positing, interpolation, statistics and
display. Some of the types of data
you can store are drillhole collar infor-
mation (location, length and more),
down-hole survey data (orientation),
assays, lithology, geology, geotechni-
cal data and quality parameters for
coal.
COMPOSITING
Calculate composites by several methods, including bench, fixed length, honoring geology and
economic factors. These composites are fully integrated with other MineSight products for statistics
and geostatistics, interpolation and display.
c 2017 Hexagon Mining
Used to model base metal deposits such as por- Used to model layered deposits, such as coal and
phyry copper, non-layered deposits, and most oil sands. Although they are normally oriented hor-
complex coal and oil sands projects. izontally, they can be oriented vertically for steeply
dipping ore bodies.
Vertical dimensions are typically a function of the Vertical dimensions are a function of the seam
mining bench height. (or other layered structures) and interburden thick-
nesses.
Contains grade items, geological codes and a to- Contains elevations and thickness of seams (or
pography percent among other qualities and mea- other layered structures), as well as grade items, ge-
surements. ological codes, a topography percent, and other
qualities and measurements.
MODELING
Build and manage 3D block, stratigraphic and surface models to define your deposit. Populate
your models through: geometries (polygons, solids or surfaces) coded into the model; calculations
on model items; text files loaded into the model; and interpolation through techniques such as in-
verse distance weighting, kriging or polygonal assignment. As you design and evaluate your mine
project, you can update your model, summarize resources and reserves, calculate and report
statistics, display in plots or view in 2D and 3D.
vi
MineSight for Long Term Planning
SERVICES
vii
Contents
1 Optimizing 1
1.1 LTPN Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.2 Surface Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
1.3 Surface Model Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1.4 MSEP Surface Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
1.5 3D Block Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
1.6 Using Restriction Codes (RCODE) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
1.7 Multi-runs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
1.8 Economic Pit Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
1.9 Evaluating Pit Slopes in MS3D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
1.10 Evaluating Pit Slopes in MSEP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
1.11 MSOPIT Output Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
1.12 Price Sensitivity Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
1.13 Pushback Designs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
1.14 Reporting Model Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
1.15 Preliminary Scheduling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
1.16 MSVALP Output Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
1.17 MSVALP Summary Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
1.18 MSVALP Cases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
2 Pit Design 63
2.1 Designing Pits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64
2.2 Pit Solids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
3 Life-of-Mine Planning 75
3.1 MineSight Haulage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
3.2 The MineSight Planning Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
3.3 Backup/Restore MSPD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
3.4 Copy an MSPD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
3.5 Haul Networks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
3.6 Haulage Plan Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
3.7 Haulage Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92
3.8 Analysis of Haulage Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94
3.9 Cycle Times and Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
3.10 Zone Item . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
3.11 MSSO Project Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
3.12 MSSO Grouping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
3.13 Material Mapping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
3.14 MSSO Inputs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
3.15 MSSO Sequencing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115
3.16 MSSO Precedence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
3.17 Haulage Setup in MSSO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
3.18 MSSO Schedules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
3.19 Conclusion & Future Training . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134
c 2017 Hexagon Mining
Course Flow
MineSight for Long Term Planning takes you through the process of converting
data from a 3D block model into a life-of-mine plan designed to maximize net
present value.
OPTIMIZING
Use Lerchs-Grossman (LG) and Floating Cone (FC) algorithms to determine pit lim-
its based on economic and design parameters, starting topography and a block
model. Create a series of incremental pit shells that follow the best mining direction,
and then examine multiple pit shell sequences based on different design parame-
ters. Create a simplified long-range production schedule from a series of pit shells
that maximize net present value and find the optimum cutoff grade strategy.
PIT DESIGN
Use the LG shells as a guideline to design pits with ramps, toes, crests, etc. Report
reserves and export phase surface and solid geometry. Use CAD tools to create
necessary input data for scheduling.
LIFE-OF-MINE PLANNING
Create a MineSight planning database (MSPD) for use in MineSight Haulage to im-
port and setup haul network geometry. Develop reserve logic to bin material for
optimizing in MineSight Schedule Optimizer (MSSO). Use MSSO to generate opti-
mized schedules while honoring a variety of constraints. Run a series of increasingly
complex schedules to create a realistic LOM plan.
x
1
Optimizing
Use Lerchs-Grossman (LG) and Floating Cone (FC) algorithms to determine pit limits based on
economic and design parameters, starting topography and a block model. Create a series of
incremental pit shells in MineSight Economic Planner (MSEP) that follow the best mining direction,
and then examine multiple pit shell sequences based on different design parameters. Create a
simplified long-range production schedule from a series of pit shells that maximize net present
value and find the optimum cutoff grade strategy.
Contents
1.1 LTPN Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
1.2 Surface Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
1.3 Surface Model Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
1.4 MSEP Surface Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
1.5 3D Block Models . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
1.6 Using Restriction Codes (RCODE) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
1.7 Multi-runs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
1.8 Economic Pit Limits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
1.9 Evaluating Pit Slopes in MS3D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
1.10 Evaluating Pit Slopes in MSEP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
1.11 MSOPIT Output Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
1.12 Price Sensitivity Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
1.13 Pushback Designs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
1.14 Reporting Model Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
1.15 Preliminary Scheduling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
1.16 MSVALP Output Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
1.17 MSVALP Summary Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
1.18 MSVALP Cases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
c 2017 Hexagon Mining
NOTES
Surface models showing a triangulated surface (left) and colored to show elevation.
4 | Surface Models
MineSight for Long Term Planning
NOTES
Surface Models | 5
c 2017 Hexagon Mining
GSF Model View Data Manager → select and right-click destination folder → New → Model
View → New Model dialog → choose name and location for new model
view (this will be used as a prefix) → select the PCF and File 13
Gridding
To grid a surface is to overlay the
model grid on a surface geometry
object; calculate the surface value
(usually elevation) over each model
block; and store the resulting values
to a selected item in the gridded sur-
face file. After you have gridded
a surface, the grids (size defined by
the PCF) will show elevation values
based on average calculations done
for each grid cell. The topography
should fully cover the project bounds
before gridding in order for all the
grids to receive a value.
Gridding Data Manager → double-click model view → Geometry tab → Geometry Set
Editor (blue cube) → browse to surface → save geometry set → OK → Grid
tab → choose item to store values to (i.e. TOPOG) → click Grid at bottom
right of panel
NOTES
MSOPIT and MSVALP use surfaces in the File 13 that are whole blocks, which means that each elevation
is a bench toe or, in the case of the top bench, a crest. The programs do not use partial blocks.
TOPOG is the actual elevation of the surface, but all the pit surfaces are represented by whole blocks.
The top block in each column may have a TOPO percent in the model ranging from 1% to 100%. The
TOPO percent is used in computing net value per block.
Model Manager Model Menu → Model Manager → Create a New GSF icon → File Name =
pitn13.opt; check Enable for MSEP → click MSEP 3.0 or Higher → Import TO-
POG from Existing File = pitn13.dat; Item with TOPOG Data = TOPOG → OK →
Save
TOPOG The original surface elevation at the horizontal center of the block
RCODE Limits the pit extents based upon a code from 1 to 100
GSF Multiple Model Data Manager → select and right-click destination folder → New → Model
View View → New Model dialog → choose name and location for new model
view (this will be used as a prefix) → select the PCF and pitn13.opt → Would
You Like to Initialize Multiple Model Views? = Yes → Select (Select All); set
Display item same as surface item; delete prefix → OK
The 3DBM is a three-dimensional grid of blocks that all have the same dimensions. Block height
usually conforms to the proposed bench height in an open pit operation. The lateral block dimen-
sions are often dependent on the deposit, spacing and resolution needs. In general, these lateral
dimensions must adequately represent the grade distribution.
A 3DBM
Model Views
Attaching a model view to a MineSight 3D (MS3D) project allows you to visualize model data as
surface/slab, contours, filled polygons, blocks, or block grade shells. Create model views to see
selected items from a model, different spatial regions of a model and, in the case of 3D block
models, grade shells from which you can create a geometry object. You can restrict what region
of the model to view, and specify primary and secondary display items.
Creating a model view also allows you to interact with the model file. You can code a model
directly from an surface, solid or polygon. Each grid in a model file typically contains several items
of information (i.e. different geology surface elevations). Before you can store any surfaces, you
must initialize the model.
10 | 3D Block Models
MineSight for Long Term Planning
MS3D Model View highlight and right-click destination folder → New → Model View → name the
Model View → OK → browse to PCF → select pitn15.eng model file
2D Mode
It can be more convenient to view polygons (or blocks) while they are unfilled (highlight the desired
buttons → Properties → Surfaces tab → choose to show lines and not show faces).
Display Type and Style double-click model view → Display tab → activate display type and option →
Apply → Cutoffs button → select the cells for the cutoff values for which you
would like to show polygons unfilled → Properties button → Surfaces tab →
check and uncheck Show Faces and Show Lines options → OK
Display Range double-click model view → Range tab → slide the limit bars to the desired mini-
mum and maximum; each end of the limit bars gives the number/coordinate
value → Apply
Display in 2D Mode Viewer Tool Bar → Set a Grid Set to the Viewer → browse to a grid set → choose
a plane or section → put Viewer in 2D mode
Display Labels in 2D double-click model view → Labels tab → select the item whose label you want
Mode displayed and any accompanying parameters for that row → Apply
3D Block Models | 11
c 2017 Hexagon Mining
Standard View Displays the portion of the model requested on the Range tab of the
Model View Editor, with the requested view style applied.
Level/Bench Plans Displays the model as horizontal sections. Filled polygons are the only view
style that can be used with this 3D display type.
EW Sections Displays the model as vertical East-West sections. Filled polygons are the
only view style that can be used with this 3D display type.
NS Sections Displays the model as vertical North-South sections. Filled polygons are the
only view style that can be used with this 3D display type.
Contours Displays contours of the selected model item on the spatial extent of
the defined model region. This is the fastest and least memory intensive
method of viewing the model. Smooth Contours displays contours with a
gradual change in the contour colors on the spatial extent of the defined
model region.
Filled Polygons Displays individual model blocks as polygons.
3D Blocks Displays the model as individual blocks. Blocks are displayed at 90% of their
size. WARNING: Viewing a large region as 3D blocks is a memory intensive
operation. It is not recommended on machines with limited RAM.
Surface/Slab Available for more efficient display of the model. In both cases, a “mesh”
is used instead of a triangulated “shell.” A mesh is just a grid, and is more
efficiently displayed in MineSight than a shell. Slab rendering, the style
used with a 3D block model, displays only the bounding of two rows, two
columns and two benches of the model; the interior blocks are not dis-
played. Surface rendering, the style used with gridded model files, displays
a mesh that connects all of the midpoints of the grid.
SUB-BLOCK DISPLAY STYLES
Block Grade Shell Displays grade shells following block outlines defined by the cutoff table of
the primary display item.
Filled block contours This is the 2D equivalent to the "Block Grade Shell" in 3D styles.
12 | 3D Block Models
MineSight for Long Term Planning
LIMITING BLOCKS
Using the Options tab of the Model View Editor, you can limit the blocks viewed based on a range
of values in an item. Item Limiting and Item Filtering are two different ways to limit blocks. Item Lim-
iting lets you enter the range of values while Item Filtering lets you type in your own filter expression.
Block size is set to be shown at 90% scale in all three dimensions (x, y and z). In the Options tab,
you can set block size and opt to Scale by Block Percent or Scale by Percent Item.
Item Limiting Option double-click model view → Options tab → Limit By box → Select CUI item → set
range of values → Apply
Item Filtering Option double-click model view → Options tab → Filter By box → enter filter expressions
→ Apply
Control Block Size by double-click model view → Options tab → Scale by Block Percent → enter x, y
Block Percent and z percents → Apply
Scale by Percent Item double-click model view → Options tab → Scale by Percent Item → choose
the item to scale by (usually a TOPO% or ORE% item) → Apply
Grade Shells
A grade shell is a solid representation of a code or real
value retrieved directly from the 3DBM. It is intended
to provide an indication of where the blocks with cer-
tain geologic codes or grade values are located in the
model.
Grade shells can be created for a grade item be-
tween a minimum and maximum value, and can be
further limited by a secondary item, such as a TOPO%
or geologic code. A grade shell is created primarily for
Grade shell with a
visualization purposes, and not for volume or reserves
cutoff value of .3% copper
calculations.
Grade Shell highlight the _msresources folder → create or select a folder for the grade shell
→ create a model view (for any display item) and open its properties →
Grade Shell tab → select the desired grade shell item → enter a minimum
and optional maximum → turn on block outlines → Make Shell → Save
3D Block Models | 13
c 2017 Hexagon Mining
From left to right: a river constraint to be used in RCODE; the property boundary coded in the
model surface (RCODE = 2); a plan view showing the ultimate pit and the property boundary.
To validate the results, set the model view with RCODE as the primary display item in the Display tab and
TOPOG as the primary display item in the GSM/Surface tab.
Load Constraint RCODE model view → Model View Editor → Geometry tab → Geometry Set
Editor (blue cube) → browse to 06_PropertyBoundaryLimit → enter Code = 2
→ name the current set “Property Constraint Coding) → Save Set → OK
Codify Model View Editor → Code Model tab → select From Polygon → Storing Op-
tions: select CODE by Majority Code; Min Value of Total Percent = 30%; check
Reset Items Before Coding (Code = 1) → Items: Zone Code Item 1= RCODE
Define Elevation Model View Editor → Code Model tab → Polygons: select Range button; Start
Elevation = 2000 (polygon elevation) → Set → Code → to verify, refresh the
model view, change display items and define colors, if necessary
1.7 Multi-runs
Use a multi-run when you want to run the same pro-
cedure, or set of procedures, multiple times using LEARNING OBJECTIVE
different parameters each time. Multi-run pack-
ages range from the simple task of running a few Package procedures and their response
procedures or scripts with a few varying parame- sets for the purpose of running them in a
ters (i.e. calculating simple statistics) to the more sequence.
complex task of running several procedures with
numerous varying parameters (i.e. interpolating a
model and experimenting with different parameters).
Multi-runs make it easier for all users to be on the same page because you can write comments
about why each procedure is being run. You can also audit your task flow from the list of proce-
dures in the package. The multi-run packages can be transferred to different MineSight Compass
projects.
The procedures you select for a particular multi-run are stored in a package. The parameters that
vary in a package are stored in a response set, and a package can contain several response sets.
Two options exist for running a multi-run package:
1. Run each individual procedure in your multi-run package one or more times before proceed-
ing on to the next procedures in the package.
2. Run all of the procedures in Loop mode. This option repeats the entire sequence of proce-
dures, one after another as a group, a specified number of times. The default is to run the
same procedure the specified number of times before running the next one. The loop mode
will cycle through the entire package set before repeating the same procedures again.
Before using a procedure in a multi-run, you should run through that procedure at least once to
familiarize yourself with it and learn what type of variable information is needed.
16 | Multi-runs
MineSight for Long Term Planning
Variables As you complete the procedure setup panels and enter a data variable that has
not yet been defined, the Variables dialog is displayed. This is the page where
values for variables are entered.
Files If there is more than one set of DH or Model files, Files tab is where you can specify
names of the project files to vary during your multi-run. The Files button on the
Procedures page is used for selecting the file to be used for the procedure or
to set the file type to be varied. You must first toggle Vary using the Files button
on the Procedures tab (click the open file folder button) before you can set the
names used in the Files tab.
New Multi-run MSCompass → Options tab → New Multi-run → Package = 01_Running MSOPIT
Base Cases → Responses = 1 → select msep-design.pyz procedure; Com-
ments = "Defining the economic pit limit with constant slope, variable mining
costs and RCODE" → Setup
Note 1: Click the Setup button next to the procedure you have
selected and go through each procedure involved in setting the Put the cursor in the procedure
values and variables; use a “?nn” for variables that will change box and select from the Com-
with each run. “?nn” refers to unique numbers for each variable— pass procedures list to save your-
“?01” for the first variable, “?02” for the second variable and so self some typing.
forth. When you click the right arrow in the panel to proceed to
the next panel, the Variables tab displays so that you can enter
the values for the variables. You cannot continue with the procedure until you click Continue while in the
Variables tab.
Note 2: If you want to run the entire sequence of procedures, one after another, select the Loop checkbox,
then click Run to activate loop mode.
Multi-runs | 17
c 2017 Hexagon Mining
MSOPIT uses a design variable, also called net value per block, as the basis for pit optimization.
The design variable can be calculated from items in the 3D block model (3DBM) or read from an
item in the 3DBM. To calculate the design variable from model items, you must enter economic
parameters determining the destination for mined material. Conveniently, you can export eco-
nomic parameters for destinations and use them in separate MSOPIT runs. Once computed, pits
are stored in an MSEP Surface Model.
MSOPIT can create pits using floating cone (FC), traditional Lerchs-Grossmann (LG), and Pseud-
oflow methods. Of these methodologies, LG and Pseudoflow produces a more correct result when
compared to FC. FC typically runs faster and allows the stopping of merged cones once a certain
parameter is met, i.e. total K-tons. The LG and Pseudoflow methods, however, allow for reblocking
to speed up the process. Pseudflow is essentially a "Fast LG", and typically returns identical results
to that of traditional LG. This difference is run time. Pseudoflow is always faster than LG, sometimes
exponentially.
To calculate the design variable, MSOPIT requires a set of economic assumptions for each combination
of material and destination. For processed material, the items for each grade item are: Price, Recovery,
Processing Cost/tonne (PC), Mining Cost/tonne (MC), Density and Factor. The following formula is used:
Net Value per Block = Net Value per Tonne * Tonnes per Block
Next, MSOPIT computes net value per tonne by adding together value per tonne for all the grade items
(NVg) and deducting the processing and mining costs for the material:
The calculation for tonnes/block depends on whether the project is in metric units or imperial units.
→ Define 3D Block Model: enter File 15 (pitn15.eng), extend all areas (levels, rows and columns)in 3D Block
Model Area of Interest
→ Define Surface Topography and Geometric Constraints: Name of EP GSF = pitn13.opt; Starting Pit = 0;
Surface Limit Code = 2 (allows RCODE = 1 to be mined)
→ Design Variable Definition: check Calculate Design Variable from 3D Block Model button; Design Variable
Distribution Interval = 2000
→ 3D Block Model Items: Required Items—Topo = TOPO; Optional Items—Resource Classification Code =
CLASS, Limiting Resource Classification Code = 2, Density Within Ore % = SG
→ Define Economic Parameters for Destinations: Key Block Model Items = CUI, MOI; Material Code = MNRL;
Default Code = 4. To enter data in the Economics for Value Calculations fields, click on the cell for the Material
and Destination, and then move to the Economic for Value Calculations portion of the panel to enter data.
After entering data, left-click APPLY to save the data. For each material that has a process destination there
must also be a waste destination for uneconomic material. Export the economic data from this panel for later
use.
The Paste APPLY button can be quickly used to apply identical setups to multiple cells. Simply right click
→ copy a cell, then click on the target cell and press Paste APPLY.
→ Costs and Discounting: Check Use Variable Costs by Bench box; Annual Discount Rate = 0
The Bench Discounting Option is used to account for the time delay between mining benches within a push-
back.
→ Variable Mining Costs by Bench: Add Number of Bench Ranges = 2; Additional Waste and Ore Cost =
enter the base costs for both (27 to 42 = 0.1 and 43 to 84 = 0.2)
The variable cost by bench ($/ton for ore and waste) is added to the mining cost in calculating the DV
(design variable). As the mining cost usually increases with depth due to increased haulage costs, the first
and last bench can be specified and the base or incremental additional mining cost per bench range can
be specified.
→ Pit Slope Angle Options: Check Constant Slope button; Default Slope = 42; Slope Accuracy = High (1)
→ Design Strategy: Select Design Choice = Base; Pit Design Options = Pseudoflow (Reblocking Parameters all
equal 1)
→ BASE-Ultimate Pit: In Pit Optimization Area 1, extend to all Levels, Rows, and Columns; Results (1-200) = 3 or
PIT03
→ Audit Option: Bench Number = 35; Column Number = 103; Row Number = 97
In the Audit Options panel, choose the bench, column and row of a block where you want to audit the
design variable calculation. It should be noted that all blocks below the topo surface for the defined row
and column will be audited, thus the value entered for bench is irrelevant. The value calculation for the block
specified will be detailed in the workmsopit.tmp file.
→ Output Instructions: Leave the Output Instructions panel blank, except for the following: Run ID = “Ultimate
Pit @ Cu: 2.5 & Mo: 7.5—Constant Slope and RCODE”; Run File = ulp
Comments = "Defining the economic pit limit with slopes by azimuth, variable mining costs and RCODE"
→ Pit Slope Angle Options: Check Slope by Azimuth; Default Slope = 35; Slope Accuracy = High (1)
→ Slope by Azimuth:
Azimuth Slope
1: 0.0 37.0
2: 89.0 37.0
3: 91.0 42.0
4: 269.0 42.0
5. 271.0 45.0
6. 360.0 45.0
→ Output Instructions: Leave the Output Instructions panel blank, except for the following: Run ID = “Ultimate
Pit @ Cu: 2.5 & Mo: 7.5—Slopes by Azimuth and RCODE”; Run File = ula
Comments = "Defining the economic pit limit including complex slopes, variable mining costs and RCODE"
→ Pit Slope Angle Options: Check Complex Slopes; Default Slope = 35; Read Slope Codes From = 3D Block
Model (15); Slope Code Item = MNRL; Slope Accuracy = High (1)
→ Complex Slopes: Slopes for Each Code = (1:35, 2:45, 3:42, 4:46); Export Slopes to file = CpxSlp.csv (This file
will be used in the next section to verify slopes)
→ Output Instructions: Destination Number = ROUTE; Net Value per Block = VALPB (check Block Is Not Dis-
counted option); Net Value per Tonne Item = VALPT (check Include Mining Cost option); Output to File 13 =
(check Store Ore Bottoms box); Run ID = “Ultimate Pit @ Cu: 2.5 & Mo: 7.5—Complex Slopes and RCODE’;
Run File = ulc
NOTES
Only code items defined in the MSEP surface model can store the slope angles output by ps-
lope.dat. SLPC1–4 were used to store the slope codes corresponding to the slope surfaces items
SLPS1–4; therefore, you will need to use SLPC5-9 to store estimated and calculated slope values.
→ Preparations for Pit Slope Calculations: Starting Surface = PIT00; Pit Surface = PIT01; Location to Store Cal-
culated Slope = SLPC5; Location to Store Planned Complex Slope = SLPC6; Type of Slope Calculation — 2 =
Complex; Filename for Complex Slope Data = CpxSlp.csv
NOTES
rptopt.***
The rptopt.*** file reprints the data in the runopt.*** file. It also provides information collected about
the design variable ($/block) and a breakdown of material assignment before mining, i.e., the LG
or FC run. MSEP already knows each block’s best destination if mined; it just needs to link them
together using the Lerchs-Grossman (LG) or floating cone (FC) algorithms. The final part of the
report deals with the 2D and 3D LG or FC runs as well as the overall reserves of the pit, broken
down by material and destination.
- Before Mining
workmsopit.***
During the MSOPIT run, an audit file should have been produced for column blocks. Audit Options:
Bench Number = 35; Column Number = 103; Row Number = 97.
1. Header information at the top of the report, indicating program date, run date, run file and run file records.
2. Summary statistics for the design variable
3. Distribution of Value per Block
4. Summary of economics/tonnes by material and destination
5. Total value/tonnes/blocks
6. Total runtime listed at the bottom of the report
North 7275.00 Cross section showing the high (blue), base (gold) and low (red) cases for CU/MO
price sensitivity analysis
Use MSOPIT to generate pit shells at different selling prices to determine the price sensitivity of the
deposit. The area outlined by the pit limit at a very low selling price is the best ore in the deposit
because only high grade low stripping ore is economical at low prices. Tracking the LG ultimate pit
limits at progressively higher prices shows the progression (i.e., the best direction of mine advance)
from the best ore in the deposit out to the break-even ore, defined by the ultimate pit limit at the
corporate guideline price for official reserve estimations.
→ Define Economic Parameters for Destinations: CUI=?01 & MOI=?02 for mill destination; CUI=?03 only for
leach destination
→ Output Instructions: Run ID = “Price Sensitivity Analysis — Cu?01 & Mo?02”; Run File = ?04
MULTI-RUN VARIABLES
Var. Comment 1 2 3 4 5 6 7 8 9 10 11 12 13
?01 Cu Mill Price $/lb 0.72 0.96 1.2 1.44 1.68 1.92 2.16 2.4 2.64 2.88 3.12 3.36 3.6
?02 Mo Price $/lb 2.25 3 3.75 4.5 5.25 6 6.75 7.5 8.25 9 9.75 10.5 11.25
?03 Cu Leach Price $/lb 0.54 0.72 0.9 1.08 1.26 1.44 1.62 1.8 1.98 2.16 2.34 2.52 2.7
Price Options
You can vary the price by a value factor in MSOPIT using the Price Options on the Base-Ultimate
Pit dialog. Defining a minimum and maximum factor and increment will vary the base economics
entered in the Define Economic Parameters for Destinations dialog. A value of .2 to 1.3 and in-
crement of .1 would vary the economics of the pit from 20% of base to 130% in 10% increments,
creating 13 pits in total.
The drawback of using this method is the entire value per ton is varied by the factor, including
processing and mining cost. The benefit is that you do not need to create a multi-run because the
result number for the pit defines the first pit in the sequence.
34 | Pushback Designs
MineSight for Long Term Planning
Multiple Pits
For projects with multiple mining areas within the model, you must select starter pits for each area
based upon the economic series and pits. Once the economic pits are designed for the whole
model, the pit areas need to be identified and the pushbacks designed for each area indepen-
dently. Although automation would be convenient, the complexity of the task requires that it be
done in MSEP manually using engineering judgement. The sequence of mining pits from multiple
areas will be based upon criteria that you choose, though the BOTTOMS option in MSOPIT can
help.
Pushback design should follow the best • Other pushback tools like MultP, MultV,
material for current and future push- MultZ are older and have less functionality
than AutoP. They are still available for
backs, and have a reasonable geometry
legacy purposes.
for mining defined by:
• Mining width — if it is too small, it is not feasible to mine; and if it is too large, it can delay
access to high grade material.
• Mining length — if it is too long, it may not be feasible or desirable to mine as a unit.
• Haulage networks — geometry must be consistent for optimal material routing.
For projects with multiple mining areas within the model, each area should be examined sepa-
rately and combined with MSVALP for scheduling.
Pushback Designs | 35
c 2017 Hexagon Mining
PIT08
@
R
@
North 7275.00 cross section of the pushbacks created using AutoP. Notice that the pushbacks are
directional and not concentric.
1. The program makes a limiting surface for FC evaluation at a depth below the starting surface
that will produce the desired mining width.
2. From the distribution of ore block values below the starting surface, the higher valued blocks
are flagged as ore and the lower valued ore blocks as waste based on a starting factor
specified by the user (e.g., flag the highest 20% as ore and the rest as waste).
3. The pit optimization algorithm generates an economic shell using criteria from 1 and 2.
4. The program checks the number of blocks contained in the shell produced in step 3.
a. If the number of blocks is greater than the minimum number of blocks specified, then the
program saves the good shell and moves on to the next pushback. In producing the next
shell, the same process is repeated, using the saved shell as the new starting surface.
b. If the number of blocks or k-tons is less than the minimum number specified, the program
returns to step 2 to flag additional lower valued blocks as ore, then repeats steps 3 and 4.
If the point is reached where all ore blocks are flagged as ore in step 2 and you still have
not satisfied the minimum block/k-tons requirement, then the program will lower the limiting
surface by one bench and run the FC again with all ore blocks flagged as ore. If after three
depth increases the program cannot find a suitable pit, AutoP will exit with the end result
placed in that final pit.
Note that, in this analysis, shells may not be the exact mining width specified because the mining
width is only used to make a limiting surface for the FC analysis. The AutoP shell produced repre-
sents what is economic inside this limit based on the percentage of total ore blocks flagged as ore
and the minimum total block requirement.
36 | Pushback Designs
MineSight for Long Term Planning
Directional Anaylsis
The AutoP option allows you to specify a mining direction defined by an azimuth, specified in
degrees (0-360) rounded to the nearest 15-degree increment. You can pick the direction and
weight it using a factor of 1 to 10 to influence the program to override optimal calculated direction.
If the weighting is sufficient, the program will use the user-defined direction and ensure that the user
defined mining arc encompasses it.
The mining arc is defined again in degrees, but will only register to the nearest 15 degree incre-
ment. It is defined by an AZ1 and AZ2, which encompass the mining direction in some manner.
This is a maximum arc, and the program may choose to use a lesser arc if the parameters allow.
Further, if the parameters are too large to find enough mining material within an arc, the program
will default to a concentric type pushback.
Load the complex slope base case variable set to begin each setup. In the Output Instructions panel, clear
the items storing Net Value per Block and Net Value per Ton before you save and run the multi-run. As always,
remember to save the setup (File → Manage Variables) before running the procedures. Unless specified, use
default values.
Comments = “01) AUTOP Pushbacks from PIT50 to 55, using auto starting pit, program decides direction”
→ AutoP–Directional Phases:
Starter Pit Options: Starter Pit Radius = 100.0; Minimum Blocks for Starter Pit = 14000
Waste Mining Cost ($/ton) = 1.0; Ore Density (or TF) = 2.5; Waste Density (or TF) = 2.5, Minimum Value Factor
= 0.2; Maximum Value Factor = 1.0, Limiting Pit Number = 1
→ Output Instructions: Run ID = “AutoP, Auto starter pit, program decides direction”; Run File = ap1
Comments = “02) AUTOP Pushbacks from PIT40 to 45, using manual starting pit PIT08, program decides direc-
tion”
→ AutoP–Directional Phases:
Pushback Designs | 37
c 2017 Hexagon Mining
Starter Pit Options: Starter Pit Radius = 0.0; Minimum Blocks for Starter Pit = 0
Waste Mining Cost ($/ton) = 1.0; Ore Density (or TF) = 2.5; Waste Density (or TF) = 2.5, Minimum Value Factor
= 0.2; Minimum Value Factor = 1.0;, Limiting Pit Number = 1
→ Output Instructions: Run ID = “AutoP, PIT08 starter pit, program decides direction”; Run File = ap2
Comments = “03) AUTOP Pushbacks from PIT20 to 25, using PIT08, FC cumulative kton max of 350,000, and
program decides direction”
→ Design Strategy: AutoP; Pit Design Method = Floating Cone; Stop Mining When Cumulative Total K-Tons
Exceed = 350,000
→ AutoP–Directional Phases:
Waste Mining Cost ($/ton) = 1.0; Ore Density (or TF) = 2.5; Waste Density (or TF) = 2.5, Minimum Value Factor
= 0.2; Maximum Value Factor = 1.0, Limiting Pit Number = 1
Directional Options: Mining Arc (in degrees) = 90.0; Mining Direction Azimuth = 0.0; Direction Factor = 0.0
→ Output Instructions: Run ID = “AutoP, PIT08 starter pit, program decides direction, FC kton max”; Run File =
ap3
Comments = “04) AUTOP Pushbacks from PIT30 to 35, using PIT08, FC cumulative kton max of 350,000, and user
defined direction”
→ Design Strategy: AutoP; Pit Design Method = Floating Cone; Stop Mining When Cumulative Total K-Tons
Exceed = 350,000
→ AutoP–Directional Phases:
Waste Mining Cost ($/ton) = 1.0; Ore Density (or TF) = 2.5; Waste Density (or TF) = 2.5, Minimum Value Factor
= 0.2; Maximum Value Factor = 1.0, Limiting Pit Number = 1
Directional Options: Mining Arc (in degrees) = 90.0; Mining Direction Azimuth = 300.0; Direction Factor = 10.0
→ Output Instructions: Run ID = “AutoP, PIT08 starter pit, user defined direction, FC kton max”; Run File = ap4
38 | Pushback Designs
MineSight for Long Term Planning
Select Design Choice = Resource; Resource Configuration — From Pit = 8, To Pit = 8; Pit Design Option =
Pseudoflow; Run Id = PIT08 resources using base case; Run File= 8r
Pushback Designs | 39
c 2017 Hexagon Mining
A single bench of the block model, with the copper values displayed inside the clipped pit solid.
Pitres.dat, accessed through MineSight Compass and the Calculate Reserves Tool in MS3D, formed the
traditional method of reserve reporting. It has now made way for Reserve.
Reserves Logic
The first step in reporting reserves is creating the logic file. A reserves logic is essentially a set
of options to use for a specific reserve or resource report based on a selected 3D block model
(3DBM). Whether using Reserve as a stand-alone program or using it within MS3D, you will need to
set up a reserves logic.
The reserve logic file consists of dialogs to define the MineSight Project Files (PCF and model file),
the plan name, and other fundamental options such as the treatment of topography versus partial
percentages. At this stage, you can select whether you are using a single or multiple ore percent
model. Once this definition is accepted, a new dialog provides more detailed configuration op-
tions.
TERMINOLOGY
Ore Clipped: Used if the ore percents in the block do not already reflect the topo (the shapes used to
code them were not clipped at the surface). This will result in the percents being reduced by the topo
percent within the reserves engine.
Partial: The volumetric percent of the block being inside the solid or polygonal extrusion.
Take Ore First: Prioritizes ore to be taken before waste when the partial is less than 100 percent.
Zone Code: The integer code used for material classification; it can be a model item or a computed
zone item.
Zone Item: The model item(s) or computed zone item(s) containing our zone code(s).
Cutoffs: The “real” values that the control grades are compared against for the binning of material
within a material (as defined by a zone code/zone item in our material set).
Discrete items: Items used to further classify material with up to five additional integer items. These can
be used for reporting purposes.
Setup MS3D → MineSight menu → MSReserve → Start → File → New Reserves Logic →
PCF = pitn10.dat → Model File = pitn15.eng → Plan Name = Reserves → Use
Topo/Partial Min = True → Use Block SG for Waste Default = True → Volume
Item = TOPO → Ok
Add Items Plan → Zone = ROUTE → Add Discrete Item = Class → edit value labels by click-
ing on discrete item name → Add Grade Items = CUI, MOI, VALPT → Density
Item = SG → Save
Material Sets
Once you’ve set up the plan, you will define the material set. The Material Set dialog consists of
the Zone Details on the left and cutoff grade setup along the right. As with discrete items, you can
enter zone item values manually or by using the Auto button, which will read the zone information
directly from the 3DBM. The cutoff grade values correspond to a control grade. Lastly, a mine
recovery can be applied on this dialog for each zone.
Material Set Material Set → Auto button → Change names to 01_Mill, 02_LEACH, and
03_WASTE → Set Waste to default → Density = 2.5 → Control Grade = CUI
Reporting Reserves
Once you have defined and saved the reserve logic, you have two options for defining a reserve
volume within MS3D. From the Model menu, choose Quick Reserves from OCB to select a geom-
etry element through the Object Contents Browser. Alternatively, use Quick Reserves from Viewer
to select geometry directly from the viewer. In the stand-alone version, under the Geometry link,
it’s possible to calculate reserves based on cuts, surfaces or a coordinate range. Cuts can be
imported directly from an MineSight Planning Database (MSPD).
Surfaces (GSF) require a starting and ending surface. Selecting multiple surfaces generates incre-
mental reserves. Reserves are generated in top-down list order; but you can move surfaces up or
down in the list to ensure outer phases in lower pit numbers (e.g., PIT01) are computed after the
pushback analysis phases (e.g., AUTOP PIT20-PIT25).
Once you have selected one of the above options, the MineSight Reserve Reporting dialog will
open. This analysis provides the easy to use Advanced Reporting and Charting (ARC) options,
including the drag-and-drop Pivot Grid feature and the ability to export to multiple formats.
Save an ARC template to speed up report generation and ensure each report is in a standardized
format.
After a successful run in the standard report, you can see the summary of three schedules:
• Base Case: A schedule that processes all material above the internal cutoff grade and satisfies
the processing plant requirements each year. This schedule maximizes total profit. The shells are
mined one at a time in progressive (top down) order at the mining rate needed to satisfy the
plant requirements each year. Smoothing of stripping spikes is limited to moving waste mining
forward only when needed to assure that the total mining capacity/period is not exceeded.
• Constant Cutoff Case: A series of schedules that processes ore material above a set cutoff grade
and wastes or stockpiles material below the cutoff grade. The processing plant requirement is
satisfied each year. The shells are mined one at a time in progressive order at the mining rate
needed to satisfy the plant requirements each year. Total mining capacity is relaxed to ensure
that all material below cutoff is sent to waste or stockpile. Stockpiled lower grade ore material
below cut-off is reclaimed during scheduling with the highest grade material used first.
• Best Case: A schedule that is optimized using cutoff grade optimization techniques and NPV
analysis. This evaluation will find the cutoff grade to use each year to maximize the NPV of the
schedule. The evaluation is based on using any available excess mining capacity to mine higher
grade material earlier in the schedule to increase the NPV.
44 | Preliminary Scheduling
MineSight for Long Term Planning
The worst, base and best case logics differ from the standard logic in that each pushback or phase is
scheduled and summarized as individual schedules in the reports. For the base and best logics, these
schedules are cumulative. If in the base and best logics there are six phases, then each report will
contain six separate schedules with each subsequent phase cumulatively containing the other phases.
For example, Phase 1 would be scheduled by itself from the starting surface while Phase 2 would
schedule 1 and 2 together, mining Phase 1 before mining Phase 2. The worst case logic differs in that
each pit is schedule by itself, mining bench-to-bench, top-down from the initial starting surface.
This manner of creating schedules makes it possible to graph each phase’s schedule in MSEPc or graph
schedules all together to create “whittle curves.” You can graph each logic’s whittle curve on the same
chart to compare the effect of adding phases to the schedule.
→ Define 3D Block Model: Name of 3D Block Model = pitn15.eng; Columns = Min: 1, Max: 200, Rows = Min: 1,
Max: 200, Levels = Min: 1, Max: 84; Schedule logic = Standard Run or leave blank
→ Define Phases to Schedule: Number of Pits = 7; Pit No. = 01:0 (initial topography), 02:8, 03:20, 04:21, 05:22,
06:23, 07:1; check Rationalize the pits
→ 3D Block Model Items: Items from file = pitn15.eng; Topo = TOPO; Resource Classification Code = CLASS;
Limiting Resource Classification Code = 2; Density Within Ore% = SG
→ Define Economic Parameters for Destinations: Load previously saved economic matrix data; add Key Block
Model Item = VALPT; leave Price/Recovery%/Factor = 0.0
→ Cutoffs and NPV Assumptions: Primary Grade Item = VALPT; Base Cutoff of Economic Calculations = 0.00;
Cutoff Increment = 0.2; Number of Cutoff Increments = 30; Scheduling Size K-tons = 100.0; Discount Percent
per Period = 10.0; Max Number of Iterations = 2,000; check Use Variable Mining Costs by Benches box
→ Variable Mining Costs by Bench: Additional Waste Cost and Additional Ore Cost = 0.1 for Bench No. 27–42
and 0.2 for Bench No. 43–84
Preliminary Scheduling | 45
c 2017 Hexagon Mining
→ Process Production Targets: Period Range No. 1: Starting Period = 1; Ending Period = 100; Capital Invest-
ment = 0; Mill Limit = 36,500 K-Tonnes/year; Total Ore Mining Capacity Rate = 36,500 K-Tonnes/year; Leach
Limit = 75,000 K-Tonnes/year; Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-
Tonnes/Year; check Use for all destinations; check rate for Mill as it is the only controlling process
→ Output Instructions: Run ID = Case 1: AutoP Pits 8, 20-23 & 1 w/out Stockpile; File Extension = c1; Optional
File 15 Output: Pushback = PUSH, Process = PROC, Period = PER
46 | Preliminary Scheduling
MineSight for Long Term Planning
→ Define Phases to Schedule: Number of Pits = 7; Pit No. = 01:0 (initial topography), 02:8, 03:20, 04:21, 05:22,
06:23, 07:1; check Rationalize the pits
→ 3D Block Model Items: Items from file = pitn15.eng; Topo = TOPO; Resource Classification Code = CLASS;
Limiting Resource Classification Code = 2; Density Within Ore% = SG
→ Define Economic Parameters for Destinations: Load previously saved economic matrix data; add Key Block
Model Item = VALPT; leave Price/Recovery%/Factor = 0.0
→ Cutoffs and NPV Assumptions: Primary Grade Item = VALPT; Base Cutoff of Economic Calculations = 0.00;
Cutoff Increment = 0.2; Number of Cutoff Increments = 30; Scheduling Size K-tons = 100.0; Discount Percent
per Period = 10.0; Max Number of Iterations = 2,000; check Use Variable Mining Costs by Benches box
→ Variable Mining Costs by Bench: Additional Waste Cost and Additional Ore Cost = 0.1 for Bench No. 27–42
and 0.2 for Bench No. 43–84
→ Process Production Targets: Period Range No. 1: Starting Period = 1; Ending Period = 100; Capital Invest-
ment = 0; Mill Limit = 36,500 K-Tonnes/year; Total Ore Mining Capacity Rate = 36,500 K-Tonnes/year; Leach
Limit = 75,000 K-Tonnes/year; Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-
Tonnes/Year; check Use for all destinations; check rate for Mill
→ Output Instructions: Run ID = Case 1A: AutoP Pits 8, 20-23 & 1 w/out Stockpile; File Extension = ?02; Optional
File 15 Output: leave all items blank
MULTI-RUN VARIABLES
Var. Comment 1 2 3
Preliminary Scheduling | 47
c 2017 Hexagon Mining
rptval.***
After completing a standard-run MSVALP schedule, you should examine the base report file (rpt-
val.***) to determine if the schedule is reasonable or if more cases need to be run. This report,
similar to the rptopt.*** from MSOPIT, includes:
• A reprint of the runval.*** file along with descriptions of the other files generated.
• Information collected about the design variable ($/block) and a breakdown of material as-
signment before scheduling. The program again assigns the best destination based on eco-
nomics for each block that maximizes profit.
• Results of the schedule based on selected logic: i.e. standard, worst, base and best cases.
DEFINITIONS
Add PP Stripping Preprouction stripping tons. In addition to production constraint for first period
CFPV of Adj WM CFPV of moving waste forward because of total mining limit
CACULATION SUMMARY
ANALYSIS
Following the pushback geometry improved the schedule over bench-by-bench, top-down min-
ing by 59.28%, and the Best case analysis improved the schedule over the Base case by another
.40%. The max mining rate in period 1, however, was far greater than the 75,000 K-tonnes total
mining capacity rate, which implies that the schedule may not be feasible without pre-stripping
some material.
Reserve file (res.***): Contains reserve records for the mining units used by MSVALP to develop the
schedule. It can be used to produce various reserve reports by importing the data into Microsoft Excel.
A reserve record is tonnage and grades for economic destinations, material class, pushback and
bench.
Schedule file (sch.**): Contains the same information as the reserve file as well as the final destinations
of the material for the best case. For each reserve report, the time and destination when the material is
first mined is defined. If the material is stockpiled, the period the material is moved from the stockpile to
a process is defined.
Summary file (sum.***): Contains a summary of the schedule by period for the base case, constant
cutoff and the best case.
X-Axis = Period
Primary Y-Axis = Mill Tons Processed and Waste Mined Tons (bar)
Create Chart MSEP Charting → Open Summary File(s) to Chart → select file (sum.c1) → Open
→ click the “x” next to each existing series to delete on plot → Add New
Series → Case = Best → ; X-Asix = Period; Y-Axis = Mill Processed Tons → Chart
→ Location → Add to Existing → New Series
Save Template MSEP Charting → Save Templates (custom) → File Name = 01-
Mill+Waste+Total+CumPresentValue → Save
Only the first chart may contain multiple entries. All subsequent graphs will only contain one entry.
ANALYSIS
The total waste mined tonnes are inconsistent during the life of the mine,so the program had to
mine triple the actual waste capacity in period 1, i.e. pre-strip. If period one requires pre-stripping,
it will not show up as Add PP Stripping because it is already at the beginning of the schedule. You
may need to re-evaluate the schedule to delay mining material until waste and leach has been
pre-stripped.
Period Range No. 1: Starting Period = 1; Ending Period = 2; Capital Investment = 0; Mill Limit
= 0 K-Tonnes/year; Total Ore Mining Capacity Rate = 0 K-Tonnes/year; Leach Limit = 75,000
K-Tonnes/year; Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-
Tonnes/Year; uncheck Use and Rate for Mill
Period Range No. 2: Starting Period = 3; Ending Period = 100; Capital Investment = 0; Mill Limit
= 36,500 K-Tonnes/year; Total Ore Mining Capacity Rate = 36,500 K-Tonnes/year; Leach Limit =
75,000 K-Tonnes/year; Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000
K-Tonnes/Year; check Use for All Destinations; check Rate for Mill
→ Output Instructions: Run ID = Case 2: Adding preproduction periods; File Extension = c2; Optional
File 15 Output: leave all items blank
ANALYSIS
Tonnage is now much smoother over the entire project. During pre-production years, the program
is not required to mine any particular material to meet a controlling processing capacity rate;
therefore, it mines what is available up to the total capacity rate. In essence, it grabs the waste
and leach material near the surface, allowing it to not violate total mining capacity in the second
period range.
54 | MSVALP Cases
MineSight for Long Term Planning
Period Range No. 2: Starting Period = 2; Ending Period = 2; Capital Investment = 100000000; Mill Limit
= 18,250 K-Tonnes/year; Total Ore Mining Capacity Rate = 18,250 K-Tonnes/year; Leach Limit = 75,000
K-Tonnes/year; Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-Tonnes/Year;
check Use for All Destinations; check Rate for Mill
MSVALP Cases | 55
c 2017 Hexagon Mining
Period Range No. 3: Starting Period = 3; Ending Period = 100; Capital Investment = 0; Mill Limit = 36,500 K-
Tonnes/year; Total Ore Mining Capacity Rate = 36,500 K-Tonnes/year; Leach Limit = 75,000 K-Tonnes/year;
Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-Tonnes/Year; check Use for All
Destinations; check Rate for Mill
→ Output Instructions: Run ID = Case 3: Adding a capital investment period; File Extension = c3; Optional File
15 Output: leave all items blank
ANALYSIS
Note how the PV of Capital impacted the NPV.
→ Stockpile Processing Parameters: IY1 = 10; IY2 = 100; Mill Cost to Send = 0.25; check Use for Mill Only
→ Output Instructions: Run ID = Case 4: Adding stockpiles; File Extension = c4; Optional File 15 Output: leave
all items blank
56 | MSVALP Cases
MineSight for Long Term Planning
ANALYSIS
Compare this schedule with the Case 3 schedule to check the effect of adding stockpiles on the
cutoff grade optimization and NPV.
You can use the CULBS item on the Process Production Targets panel in MSVALP as the grade item.
MSVALP internally transforms this grade to K-Units by the formula: ktons*grade*recovery*factor. The
grade item in this case is lbs/tonne, which equates to K-lbs. You could use CUI as the grade item;
but CUI has a recovery value built in, making it impossible to target correctly on the lbs of copper
in the mill feed.
Table 26.1 in the Case 4 detailed audit report shows that the mill’s average CUI grade in the feed
is around .2. This grade will was used to derive an equivalent KLBS of copper on which to target in
the next case.
MSVALP Cases | 57
c 2017 Hexagon Mining
CASE 4 TABLE 26.1 SUMMARY OF CUTOFF GRADE STRATEGY BASED UPON CUI
→ Define Economic Parameters for Destinations: Add Key Block Model Item = CULBS; Mill Recovery% = 100%;
Mill Factor = 1.0
Period Range No. 2: Starting Period = 2; Ending Period = 2; Capital Investment = 100000000; Mill Limit =
75,000 K-lbs/year; Total Ore Mining Capacity Rate = 75,000 K-lbs/year; Leach Limit = 75,000 K-Tonnes/year;
Waste Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-Tonnes/Year; check Use for All
Destinations; check Rate for Mill; Mill Grade = CULBS
Period Range No. 3: Starting Period = 3; Ending Period = 100; Capital Investment = 0; Mill Limit = 150,000
K-lbs/year; Total Ore Mining Capacity Rate = 150,000 K-lbs/year; Leach Limit = 75,000 K-Tonnes/year; Waste
Limit = 75,000 K-Tonnes/year; Total Mining Capacity Rate = 75,000 K-Tonnes/Year; check Rate for Mill; Mill
Grade = CULBS
58 | MSVALP Cases
MineSight for Long Term Planning
The first period range still uses K-tons to define the ore mining capacity rate, while the second and third
period ranges use a grade value, CULBS, to define the ore mining capacity rate. Capacities will still
appear with a K-ton label but will in fact be K-lbs due to the internal calculation.
→ Output Instructions: Run ID = Case 5: Targeting on metal content; File Extension = c5; Optional File 15
Output: leave all items blank
ANALYSIS
Using 150,000 K-lbs as the feed target resulted in a schedule similar to the one in Case 4. The overall
tonnage at the mill fluctuated, but actual copper pounds remained consistent.
MSVALP Cases | 59
c 2017 Hexagon Mining
Runs = 9
→ Process Production Targets:
Period Range No. 1: Starting Period = 1; Ending Period = 100; Capital Investment = ?03; Mill Limit = ?04 K-
Tonnes/year; Total Ore Mining Capacity Rate = ?04 K-Tonnes/year; Leach Limit = ?05 K-Tonnes/year; Waste
Limit = ?06 K-Tonnes/year; Total Mining Capacity Rate = ?07 K-Tonnes/Year; check Rate for Mill Only
→ Output Instructions: Run ID = Case 6: Production rate analysis; File Extension = ?08; Optional File 15 Output:
leave all items blank
MULTI-RUN VARIABLES
Var. Comment 1 2 3 4 5
?03 Capital Investment 20000000 30000000 45000000 75000000 100000000
?04 Mill Capacity 15000 20000 25000 30000 35000
?05 Leach Capacity 2000 3000 4000 6000 7300
?06 Waste Capacity 7000 10000 12000 17000 20700
?07 Total Mining rate 24000 33000 41000 53000 63000
?08 Case 06 report extension c6a c6b c6c c6d c6e
Var. Comment 6 7 8 9
?03 Capital Investment 150000000 200000000 400000000 1000000000
?04 Mill Capacity 40000 50000 55000 60000
?05 Leach Capacity 8000 9000 10000 15000
?06 Waste Capacity 25000 30000 40000 50000
?07 Total Mining rate 73000 89000 105000 125000
?08 Case 06 report extension c6f c6g c6h c6i
60 | MSVALP Cases
MineSight for Long Term Planning
ANALYSIS
Charting each report’s Cum Present Value by Period, you can see that the 50,000 K-Tonnes/year
mill production rate is optimal.
Upon reviewing results from MSVALP, you can opt between two common courses of action: return
to MSOPIT to refine pushback design, or continue on in the pit design process. Up to this point, you
have been working entirely with optimized pit shells. The next step will be to take these shells and
convert them into something that is minable — a real pit containing catch benches, roads, etc.
MSVALP Cases | 61
c 2017 Hexagon Mining
62 | MSVALP Cases
2
Pit Design
Use the LG shells as a guideline to design pits with ramps, toes, crests, etc. Use CAD tools to
design waste dumps, leach pads, roads and report associated volumetric, tonnage, grade and
material type.
Contents
2.1 Designing Pits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64
2.2 Pit Solids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
c 2017 Hexagon Mining
Digitize Base String MS3D → OP EngTools → Pit Expansion Tool → Expansion tab → Base Strings
section → select Digitize option → enter elevation in the On Level field →
Closed (if you want the base string to be a polygon) → Add → digitize base
string → right-click in the Viewer
Edit a String Expansion tab → Edit String button → select the feature type (Bases, Toes,
Crests, Road Ramps or Slot Ramps) → enter level value if different than cur-
rent expansion level → make edits (i.e. Polyline → Smooth) → Save
Each pit will be designed using a corresponding MSEP Surface Model (pitxx) as a guide. Use the snap
functions, especially polyline, to quickly match the base string with the pit shell 2D line of intersection.
64 | Designing Pits
MineSight for Long Term Planning
Required Parameters
A parameter set is the group of settings used to create a pit design in the Pit Expansion Tool. Before
beginning your pit expansions, you must set the step table, expansion type, and vertical and
horizontal expansion. The parameters on a row in the step (bench) table apply to an elevation
range, with the lowest elevation listed in the table. Therefore, during expansion (either upward
or downward), the parameters in a row apply for the range of elevations between the elevation
listed and the next rows higher elevation (level).
The three expansion options are Zero, Single and Multiple. Before applying any expansion, the
Start level in the Expansion options section of the Expansion tab must be set.
All expansions that have been previously applied will be listed in the History section of the Expan-
sion tab. Each one of these can be undone.
DEFINITIONS
Berm (Catch bench): An extra horizontal width (area) left at the bottom of a face slope, generally for
safety reasons.
Face (Batter) Slope: The slope of a bench face (between the bench’s toe and crest). This is the angle of
the face for one expansion; it does not take berm width into account.
Zero expansion: Creates entrances for new roads or slots and merge new base strings.
Pit Slope: The overall angle of the wall from one elevation to the next elevation specified; The slope
takes the berm width into account.
Step Size: The distance (height) in a single expansion before drawing a Berm. The default value is the
project model block (or bench) height. Multiple benching is allowed. If you are using a grid set, this
option is not available because the step size is calculated from the distance between the parallel grids
in the selected grid set. The number of expansions is limited by the number of grid planes in the grid set.
Set Required Required tab → Step (Bench) Table → enter the elevation manually or use an
Parameters existing grid set → enter parameter for each elevation → select Expansion
Type → select Vertical and Horizontal Expansion directions
Store a Parameter Set Parameter Sets tab → New → enter name → Save Parameter Set: Save
Preview Expansion tab → Expansion Option: Multiple Expansion = 25 → Preview (do not
Apply)
Designing Pits | 65
c 2017 Hexagon Mining
Optional Parameters
The parameters defined of the Required tab apply to the entire pit as a whole. This can be very
restricting and applies an unrealistic or unachievable design. Geotechnical restrictions on slope
vary across the pit with geological rock types and structures. To accurately match the necessary
geotechnical requirements for slopes, the Optional tab may be used. Here the Face (Batter) Slope,
Pit Slope, and Berms may be varied using either Section tables, Azimuth tables, Model values, or
Model/code tables. For the latter two options a 3DBM item is required.
Select 3DBM item Optional tab → select 3DBM view from the 04_MODEL VIEWS folder → check
Model/code table under pit slopes → select MNRL from the drop down list
Define code table Optional tab → Pit Slopes → Codes → Enter the following codes in the table:
Code 1 = 35, Code 2 = 45, Code 3 = 42, Code 4 = 46 → OK
Building a Road
Use the Roads tab in the Pit Expansion Tool to enter the location and specifications for roads to be
expanded with the pit outlines. For inclined pit designs, if the grade of the inclined pit is larger than
the grade of the road, the road will abort on an expansion.
Add a Road Road tab → Add button → add road → Edit button → Edit Road dialog → enter
(Zero Expansion Test) values in the Starting Points section or click the Digitize button to select the
starting point from the Viewer → Road Parameter table → enter Level, Width
(of road), Grade and Direction → OK → Expansion tab → Expansion Options
→ Zero Expansion button → Preview (to see the start gate) → Apply → edit
toe string as needed before expanding to the next step (level)
Create a Switchback Road tab → Pit Expansion dialog → highlight road for which you want to create
a switchback → Edit → Road Parameter table → enter elevation at which the
switchback will occur → enter opposite direction value in the Direction field
→ enter the SB radius, SB Grade and SB Length Multiplier → OK → Expansion
tab → Expansion options → set the expansion type to Expansion → Preview
66 | Designing Pits
MineSight for Long Term Planning
DEFINITIONS
Road Gate: Two nodes representing the two entrance points of the road.
Switchback Grade: Grade of the inner road ramp line for the switchback. When the switchback is
complete, the road grade will be used to complete the bench. If the bench is completed before the
switchback has been completed, a warning message will be written to the Message Window,
“Switchback grade too large for bench,” and the road will abort.
Switchback Length Multiplier: Multiplier applied to the sum of the road width and the SB Radius to
calculate SB Length. The result of the switchback is a “teardrop” shape, and the SB Length is the
distance from the switchback to the pit wall where the pit toe polyline tapers back into the pit wall at
the pit’s set expansion angle and berm width. If the SB Length Multiplier is too large, an error message
will be displayed.
Switchback Radius: Radius of the circle to use for creating the switchback. If the radius is less than berm
width or set to 0, the switchback will have a V-shape.
Message: Cannot create road start at the end of the open string.
Explanation: The start of the road is at the end of an open base string and start cannot be created.
Designing Pits | 67
c 2017 Hexagon Mining
Apply Expansion Expansion tab → Expansion Options section → select expansion type → for a
Multiple expansion, enter number of steps → Preview → Apply
Undo an Expansion Expansion tab → History section → highlight expansion that you want to undo
(any expansions that follow it will be highlighted for deletion as well) → Undo
button →
Reporting Reserves
In the optimizing portion of the course, you set up the reserve logic ROUTE to report reserves be-
tween GSF surfaces. You will use this same logic to evaluate the pit solids.
Unlike the GSF surfaces, the pit solids exist as actual geometry and are selectable interactively
using the Reserves from Viewer/OCB option under the MineSight 3D (MS3D) Model menu. The
stand-alone version may also be used but will require generating partials files first. These are easily
generated using the Generate Partials Tool in the Surface menu or running the createPartials.pyz
script from File -> Scripts, but do take additional setup and time.
Rather than exit the Pit Expansion Tool to run reserves after the design is complete, we will link to
the reserve logic on the Reserve tab. Reserves may be run dynamically after each preview or
apply of expansion or manually when needed. Checking reserves against the pit shell allows the
design to be validated continuously to ensure tolerance acceptability criteria are met.
Calculate Reserves Reserve tab → link to Reserves.resx → select Calculate reserves From Pit Solids
→ Calculate Reserves
The reserves generated should be honor the topography using the TOPO percentage item in the reserve
logic, but an additional option, Clip geometry by surface, can be used to ensure reserves are clipped
to the surface. The surface however must first be linked to on the Export tab.
68 | Designing Pits
MineSight for Long Term Planning
Exporting Geometry
Use the Export tab in the Pit Expansion Tool to export the final design geometry. The Pit Surface and
Pit solid may be exported with or with out merging with topography. Mid-bench Lines and Ramp
Centerlines may be exported to further jump start then next phase in the planning process. The
ramp center line may be used to jump start the design of a haulage network while the mid-bench
polygons may be saved to further cut up late during the medium term planning process.
Export Geometry Export tab → select Destination Folder → select Limit by Surface: 02_Complete
Topo from the 01_TOPOGRAPHY folder → check Use limit surface for export
option → check Geometry Types: Pit Suface, Pit Solid, and Ramp Centerlines
→ Ensure Merge is selected as Limiting Option for Pit Surface → Export
Designing Pits | 69
c 2017 Hexagon Mining
NOTES
70 | Designing Pits
MineSight for Long Term Planning
Copy the folders 06_PIT DESIGNS, 07_EXPANSION SURFACES, and 08_PHASE SOLIDS from the Import Data →
Pit Design folder inside the main project directory. Copy directly in Windows Explorer and refresh the Data
Manager, or right-click on _msresources → Import → MineSight 3D Folder.
Pit Solids | 71
c 2017 Hexagon Mining
Incremental Solids
The incremental and bench solids for each phase were also brought in during the import exercise.
To understand how this geometry was created we will re-create a few incremental solids and slice
then up into bench solids. During the intersection process some of the resulting solids may need
to be "cleaned up" somewhat due to the nature of the geometry. This will require correcting in
order to report valid reserves and ensure correct behavior in the slicing utility. We will using the
Incremental Solids Tool and the Autoslicer to create the necessary geometry.
Intersect Solids Tool MS3D → Surface → Intersect Solids Tool → select Group A = Phase 1A Solid →
select Group B=Phase 1B Solid → select Return B-A option → Apply
Explode and Delete MS3D → Surface → select geometry → right-click → Modify Selection → shift-
Artifacts click major elements (to unselect) → delete
72 | Pit Solids
MineSight for Long Term Planning
Bench Solids
The Autoslicer will be used to slice up the incremental phase solids into benches. The resultant
geometry will be used as the data source for MineSight Schedule Optimizer (MSSO). This geometry
will be brought directly into the scheduler. There are many targeting methods inside the Autoslicer.
We will slice By Grid to ensure slices are only generated at each toe level to represent the entire
bench level. Multiple solids may be selected for slicing at once, and by invoking wildcards, unique
names for elements and associated material may be quickly assigned.
Autoslicer MS3D → Utilities → Autoslicer → Main tab → select all phase solids → check
Slice All → Target tab → select By Grid → select Plan grid set → Naming tab
→ Slice element name: $orig → check Material name is the same as the slice
name
Pit Solids | 73
c 2017 Hexagon Mining
74 | Pit Solids
3
Life-of-Mine Planning
Develop a haulage network and plan that accounts for periods, phases and equipment. Use
MineSight Haulage to generate cycle times for use in MineSight Schedule Optimizer (MSSO). Use
MineSight Reserve to create the input files for MSSO. Run a series of increasingly complex
schedules inside MSSO to develop a life-of-mine plan.
Contents
3.1 MineSight Haulage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
3.2 The MineSight Planning Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
3.3 Backup/Restore MSPD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80
3.4 Copy an MSPD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
3.5 Haul Networks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
3.6 Haulage Plan Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
3.7 Haulage Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92
3.8 Analysis of Haulage Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94
3.9 Cycle Times and Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
3.10 Zone Item . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
3.11 MSSO Project Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
3.12 MSSO Grouping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106
3.13 Material Mapping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108
3.14 MSSO Inputs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
3.15 MSSO Sequencing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115
3.16 MSSO Precedence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
3.17 Haulage Setup in MSSO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
3.18 MSSO Schedules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
3.19 Conclusion & Future Training . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134
c 2017 Hexagon Mining
76 | MineSight Haulage
MineSight for Long Term Planning
NOTES
MineSight Haulage | 77
c 2017 Hexagon Mining
Create MSPD MS3D → Utilities → MSPD → Create → Database name: LTP Copper → File
Location: leave as default → Apply
Create ODBC MS3D → Utilities → Server Management → Create ODBC Data Source → select
LTP Copper database → check Name data source after database → Apply
When connecting to an MSPD, select the ODBC connection that is linked to that particular MSPD.
After connecting to an MSPD, check connection information to verify that a connection has been
successful. Only one MSPD connection is permitted per MineSight session; connections to different
MSPDs are possible only after disconnecting from the current one.
Connect to MSPD MS3D → Utilities → MSPD → Connect to MSPD → select Data Source → Machine
Data Source tab → select ODBC → OK
Check Connection MS3D → Utilities → MSPD → Connection Info → check connection → Close
To avoid confusion it is good practice to assign the MSPD and ODBC the same name.
NOTES
A less common way of transferring data is by detaching and attaching the MSPD between servers. This
method is riskier, in that the original MSPD is switched from one server to another.
Create Backup MS3D Desktop Menu → Utilities → MSPD → MSPD Manager → Connection →
Connect → select SQL Server → Server Management → Backup → select
the database → enter a BAK file name → save the file → check Compress
the Backup File (zip archive) box (optional) → Apply
Restore BAK File MS3D Desktop Menu → Utilities → MSPD → MSPD Manager → Connection →
Connect → select SQL Server → Server Management → Restore → name
database → select a BAK file → browse BAK file location → Advanced (op-
tional) → enter a restore path for the MDF and LDF files → Apply
Create ODBC MineSight Database Manager → Sever Management → Create ODBC Data
Source → select the database → enter Data Source Name or check Name
Data Source after database box → Apply
80 | Backup/Restore MSPD
MineSight for Long Term Planning
NOTES
Backup/Restore MSPD | 81
c 2017 Hexagon Mining
Create MSPD Utilities → MSPD → MSPD Manager → Connection → Connect → select SQL
Server → MineSight Planning Database → Create → name database →
change the file location → Apply
Create an ODBC MSPD Manager → Server Management → Create ODBC Data Source → select
Database and Data Source Name → Apply
Copy MSPD disconnect from older SQL Server → connect to newer SQL Server → Mine-
Sight Planning Database → Copy Full → the source Sever is setup by de-
fault (should be newer) → select Source Database → define the Destination
Server and the Destination Database to where the data will be stored →
check Auto-rename Duplicate Object Names → Apply
Copy Attributes disconnect from older SQL Server and connect to newer SQL Server → Mine-
Sight Planning Database → Copy Attributes → the source Sever is setup by
default (should be newer), select Source Database → define the Destination
Server and the Destination Database to where the attributes will be stored
→ Apply
82 | Copy an MSPD
MineSight for Long Term Planning
Copy Objects
Data related to planning is stored to the MSPD, including IP Plans, Geometry Sets and Haulage
plans. You can copy objects in an MSPD to a different MSPD via the MSDBM. Again, an existing
MSPD is required to receive the data.
Copy Objects disconnect from older SQL Server and connect to newer SQL Server → Mine-
Sight Planning Database → Copy Objects → the source Sever is setup by
default (should be newer), select Source Database → define the Destination
Server and the Destination Database to where the attributes will be stored
→ Apply
Delete Objects
It is just as simple to delete objects from an MSPD.
Delete Object Utilities → MSPD → MSPD Manager → Connection → Connect → select SQL
Server → MineSight Planning Database → Delete Objects → select the
database → Delete Objects dialog → select objects to delete → Apply
Copy an MSPD | 83
c 2017 Hexagon Mining
84 | Haul Networks
MineSight for Long Term Planning
Nodes in haulage need to be defined as sources, destinations, stockpiles or tie nodes. By default,
all nodes will be imported as tie nodes. You will need to set the correct node type manually. To
avoid this extra step, you can add a suffix to the element name as follows: “_SRC” = Source; “_DST”
= Destination; “_STK” = Stockpile; all others = Tie Nodes. The following exercises highlight methods
that will help you create a correct haul network.
Note how the elements are separated into various objects and attributed with unique names. This make
organizing and validating the network inside Haulage much easier.
Haul Networks | 85
c 2017 Hexagon Mining
New Haulage Plan Data Manager → right-click on the 02_Haulage folder → New → Haulage Plan
→ Name Object: Haulage → select Data Source → Action: Create New →
New Plan Name: Haulage
Global Settings
The Global Settings panel in MineSight Haulage controls project settings, how information is stored
back to the MSPD and default values used for un-routable material.
The various project settings include:
• Turning on/off material routing capability
• Resetting destination capacities
• Changing how rolling resistance is measured
• Suppressing default errors
• Controlling routing logic the program uses to calculate cycle times, specifically fastest vs.
shortest logic
This haulage plan will not use material routing. The goal of this plan is to calculate the cycle times
from each source to each destination dump point for use in MineSight schedule Optimizer (MSSO).
How Haulage routes materials is irrelevant, since this is the exact purpose of MSSO.
You will not use the option to store information back to the MSPD in this panel. Cycle times are now
calculated on the fly inside of MSSO for all data sources except schedule files (SCDs), which means
we no longer have to calculate cycle times beforehand and save back to the MSPD. When using
SCD files, instead, you will generate, save and manually import a cycle time file into MSSO.
DEFAULT VALUES
Haulage assigns a default value to any material not sent to a destination. Any lift added to the des-
tinations will receive a default design grade and max speed. Roads imported into Haulage may
be automatically assigned a rolling resistance, and a global maximum spend may be entered.
The network solving logic default is “fastest time”. This logic does not guarantee the shortest path or that
the same outbound/inbound paths will be used.
Add Period Periods section → click “+” → enter a period name and time span
Add Phase Phases section → click on the “+” → enter a phase name
Import Nodes Haul Network → Locations → Select Nodes icon → click and drag a window
around all the nodes to import → right-click to confirm your selection
Delete Node Haul Network → Locations → click “X” to delete one node or “XX” to delete all
nodes
Edit Node (if necessary) Haul Network → Locations → define node type or availability
Import Roads Haul Network → Routes → select road → click and drag a window around all
the road polylines to import → right-click to confirm
Delete Road Haul Network → Routes → select road → click “X” to delete one road or “XX”
to delete all roads
Edit Roads (if necessary) Haul Network → Routes → select road → define rolling resistance, max speed,
or road availability per segment
Change nodes and roads in bulk by highlighting multiple entries → right clicking → Bulk Change. This
option makes updating Max Speed, Phases and Period Availability and Rolling Resistances much quicker.
Network Editor
Access the Network Editor using the “pencil” button in either the Nodes or Roads panel. Here, you
can add lifts or subzones to nodes, and you can split roads into smaller segments automatically.
This setup will not be necessary as MSSO determines this automatically from the actual destination
geometry.
Equipment
Haulage requires at least one truck and one shovel (an equipment set) to calculate values such
as cycle times, equipment hours and truck/shovel numbers. Delay times may be entered for each
equipment set: including load, dump, spot and wait times. Only the raw cycle times will actually
be calculated and used by MSSO, therefore the delays do not need configured.
You can copy equipment specs and operating parameters manually from a Heavy Equipment
Manual; or you can select equipment and associated specs from the Equipment Repository. The
repository contains predefined equipment and performance specifications for a variety of haulers,
including the most common CAT/KOMATSU haulers. You can configure and store additional equip-
ment configurations in the Equipment Repository for future use.
Equipment Set Add Equipment Set → name the set → set the _Hauler and _Loader parameters
NOTES
HIGHLIGHT VALIDATION
Selecting this option highlights all available route segments for a given period or phase in the
viewer, making it easy to spot areas that are inaccessible during that period or phase.
Highlight Network MSHaulage → Validation → select period or phase values → click Show Period
or Show Phase button
CONNECTION VALIDATION
This options checks the connections between route segments and nodes, and produces a report
containing a log of all the errors/warnings. Click on any error or warning to see a corresponding
highlight in the Viewer.
Check Connections MSHaulage → Validation → click Check Connections button → click on any
error or warning messages
92 | Haulage Validation
MineSight for Long Term Planning
NOTES
Haulage Validation | 93
c 2017 Hexagon Mining
Configure the Field List as follows: Column Area = Destination; Row Area = BenchToe, SourceID; Data Area
= Cycle Times, Fuel Burn. Highlight Cycle Times and Fuel Burn Rates for a particular source and destination
combination to activate the chart. Save the template, and call it “Haulage.” Export the table to save it in
Excel format.
Pivot Table Analysis → Cycle Times → click Field List → add or remove item labels → click
on the Header labels to sort the data → click and drag the items in the pivot
table to reorganize → Filter icon → simplify the data
New Field Analysis → Cycle Times → New Field → enter field name → click on the ellipsis
(. . . ) → use the necessary Functions, Operators, Fields or Constants to define
the new field → OK → Add
Save Template Analysis → Cycle Times → Template → Save As. . . → browse to a storage folder
→ name the template → OK
Export Data Analysis → Cycle Times → Export → Format = Excel → browse to storage folder
→ Save as CycleTimes.xlsx
To create the most accurate cycle time files as possible, you must add nodes at each bench level in
each phase. Phase availability setup is absolutely crucial to ensure the correct cycle time is chosen in
the right phase, since only one is allowed.
Profiles
Haulage profiles are a .csv file that describes, in x,y,z format, the various segments of the outbound
and inbound routes taken for the fastest/shortest cycle time from/to each source to/from each
destination for each phase and period combination. It will create all these files in the file folder
selected, which may take considerable time depending on the amount of combinations.
Cycle Times Haulage → Cycle Times and Profiles → Cycle Times and Profile Generation Tool
→ Custom Cycle Time dialog → select Phases/Periods/Equipment Sets → se-
lect Columns (fields) to report → Create
Route Profiles Haulage → Cycle Times and Profiles → Cycle Times and Profile Generation Tool
→ Custom Cycle Time dialog → Profiles → select a folder for storage
Add cutoff bins Material Set → Control Grade: VALPT → Enter cutoff bins
When binning using an item that ranges less than 0 (e.g. VALPT), it is a good idea to make the first bin less
than the lowest value for a specific zone, rather than leaving as the 0 default. If not done, then anything
below 0 will be defaulted to waste, which in our case would have removed all marginal material from
our MILL and LEACH reserves.
98 | Zone Item
MineSight for Long Term Planning
NOTES
Zone Item | 99
c 2017 Hexagon Mining
Create MSSO View and Data Manager → right-click on 04_MSSO VIEWS folder → select New → MSSO
Project View → object name "01–WithoutEquipment" → select New Project → select
ellipses to browse → project name "01–WithoutEquipment"
To create a new plan in MSSO, you must set up a process flow linking mining areas with destinations,
and configure the number and durations of periods. Set up of an MSSO project begins in the
Project Setup input tab, which is subdivided into the Process Flow and the Period Configuration
panels.
The Process flow panel consists of the project canvas where mining areas and destinations can be
displayed, added, and arranged. Mining areas are defined by their data source. These include
Model source, MineSight Interactive Planner (MSIP), Schedule Files (SCD), MineSight Planner, GSM
Stratigraphic model, and MS3D Viewer sources. Traditionally, SCD files were used for long term
planning projects and MSIP connections were common for mid term planning. Now however,
mining geometry may be imported directly into MSSO through the MS3D viewer for any horizon,
leveraging MineSight Reserve and viewer interaction for more direct scheduling.
Destinations created in MSSO are internally denominated “virtual,” but can be imported from ex-
isting MineSight Planning Database (MSPD) haulage plans. Subzone geometry may be imported
for each destination type (virtual or database defined), but only haulage destinations may have
cycle times generated automatically. In the Period Configuration panel, you can define the num-
ber of periods and the duration of each one. MSSO uses the setup to calculate equipment usage
per period.
In addition to bringing in the destinations from a linked haulage plan, the network geometry and equip-
ment sets will be imported and are configurable.
The MSSO canvas allows the mapping and displaying of the process flow.
Project Setup Project Setup → Process Flow panel → Destinations tab (bottom right) → click
and drag the Open Pit (Viewer) icon into the canvas → specify 45 periods
Define Reserve Logic click Reserves in top menu bar → click Add... → click Import From File... →
select Route_Cutoff logic → save and close logic setup
Apply Reserve Logic click on Mining Area icon → Properties tab → Reserve Logic = Route_Cutoff
Import Cuts click on Mining Area icon → Properties tab → click on the ellipsis (. . .) in the
Cuts field → Use tokens to define Cut Name and Phase → set Auto Level
to BY_PCF → select Cuts Geometry from 01_Optimizing with MSEP\08_PHASE
SOLIDS\Bench Solids
Import Haulage Plan click Import/Export in top menu bar → select Database Server → select Au-
thentication type → MSPD = LTP Copper → Haulage plan = Haulage → de-
fine Destination type → Load → configure Properties
Link Destinations click on Mining Area icon → click on the midpoint of the highlight box and drag
it to a destination (e.g., Pit material goes to Mill) → repeat process for other
destinations or right click on the pit icon and select Link to All Destinations →
set up reclaiming in the same way (material from stockpiles goes to Mill)
Cuts-Mining Area click on Mining Area icon → click Cuts tab (bottom left)
Reserves click on Mining Area icon → click Reserves tab → click Refresh
Destination Properties
Destination properties allow you to define setup information about the destination, as well as im-
port and edit associated geometry. Options to define include Reclaim Method (for stockpile type
only), Period Availability, Lift Order, Opening Balance (for stockpile type only), and in-lift Haulage
parameters.
The specific lift and/or subzone information may be viewed and edited in the Lifts dialog at the
bottom of the Process Flow panel. Here the Dump Rate(kt/day) for a particular subzone may be
defined, and options to Ignore Tonnage, Volume, and Dump Rate are available.
Use the Properties dialog of a stockpile to define a reclaim method (ANY, AVERAGE, first in first out (FIFO),
last in first out (LIFO), or NONE).
Destination Geometry
Subzone geometry, both polygons or solids, may be imported from MS3D for each destination. This
geometry will automatically define the capacities on the Lifts panel. During the import various
options need defined: Grouping, Tolerance (polygon only), Ramp Geometry, Seed Selection, SG,
and Height (polygon only). The Lift Naming is read only and depends on the Grouping, while
Subzone Naming can use a variety of tokens. The seed selection method is used to automatically
assign a default sequence (filling order) to the subzones on a lift.
Changes are allowed to any of these options after the initial setup through the Edit dialog in the proper-
ties panel. Manual changes are also allowed in the Lifts dialog as well. Both require the Process Flow to
be in Edit mode.
Import Destination select Destination in canvas → Properties tab → Geometry → Import → define
Geometry parameters → select Destination Geometry with appropriate icon (solid or
polygon)
Lifts-Destination Process Flow panel → left-click on the destination in canvas → Lifts panel
Configuring Period Project Setup → Period Configuration panel → enter Operating Days and Hours
Configuration per day
NOTES
Material Grouping Grouping → Material Grouping panel → right-click to access grouping options
To add a new group you must first right-click and add a selected field to a grouping. To add more fields
to an existing group simply highlight them and right-click add to existing group or select from the drop
down
NOTES
When the Distribute option is activated, MSSO optimizes the objective by calculating the best proportions
of a specific material bin to send to each destination. When this option is not used, the program sends
100% of a material’s bin to a destination.
Standard Materials → Material Mapping panel → Check each box or highlight multiple
bins and right-click to massively check multiple destinations
With the standard matrix it is possible to assign one period’s mapping to all others very quickly. In the filter
by period window, check the period already mapped, right-click and click Apply to All Periods.
NOTES
Besides the typical copy and paste options, you can quickly assign a cell(s) setup to others by highlight-
ing and right-clicking to access options to Apply to All Periods or Apply to Selected.
Trucks Constraints → Trucks panel → Truck Hours [Total] Upper = 199,500 for all periods
CONSTRAINT TYPES USE TO ENTER BY PERIOD THE LOWER LIMIT AND UPPER LIMIT OF. . .
Stockpile Closing Closing tonnage balance in a stockpile, also referred to as end-of-period (EOP)
Balance balance
Vertical Advance Rate The maximum number of benches mined from (lower limit is ignored)
Vertical Advance The maximum number of bench units in each phase or period (lower limit is
Rates-Units ignored)
Open Phases Number of phases that have been started but are not yet completely finished
Open Benches Number of benches that have been started but are not yet completely finished
Advanced Constraints Use to apply four types of constraints to cuts: Must Mine at Period, Must Mine
by Period, Mine Completely or Don’t Mine
Constraints Relaxation Use relax constraints when the schedule fails to find a solution, relaxation hier-
archy is based on lower and upper limit preferences
Advanced Constraints Use to apply three types of constraints to cuts: Must Mine, Mine Completely or
Don’t Mine
Constraints Relaxation Use to apply four types of constraints to cuts: Must Mine at Period, Must Mine
by Period, Mine Completely, or Don’t Mine
The Advanced Constraints panel may be linked with the MS3D viewer. Doing so, will allow you to assign
constraints interactively.
Objectives
To drive the schedules logic you must enter an objective. There are standard and item-based
objectives that can be minimized or maximized, set globally to all periods, or varied on a period-
by-period basis. The objective for this schedule will be to Maximize Net Present Value.
Objective Objectives field → select the objective = Net Present Value → choose Maximize
Economics
MSSO features various panels for inputting economic parameters: Discount Factor, Capital Invest-
ment, Fixed Mining Costs, Fixed Cost by Phase, Additional Mining Cost, Additional Processing Cost
and Destination Economics. The Discount Factor panel will automatically determine the factor for
each period based on an entered discount rate. Overall capital investment per period is entered
on the Capital Investment panel, while a fixed capital cost to begin mining a phase is entered on
the Fixed Cost By Phase panel.
In the Fixed Mining Costs panel, a base mining and processing cost ($/unit) is defined for each
schedule material. You can vary the base costs by adding or subtracting costs on the Additional
Mining Cost or the Additional Processing Cost panels. These panels allow varying to costs by mining
area, phase, level, and material in each period.
The Destination Economics panel is where revenue generating parameters are entered. Here the
recovery, selling price and a conversion factor (optional) are entered for each material’s grade
item at each destination. MSSO uses these inputs to calculate the net value of the cuts mined in
a particular period.
Enter the following fixed mining costs: mining cost = $1.00 per unit DUMP1 and DUMP2 and $1.20 for MILL,
ROML and STK; processing cost = $5.10 for MILL, $0.7 for ROML, and $0.25 for the STK (a reclaim cost).
Enter the following additional mining costs: 0.1 for levels 1560-1335 and 0.2 for levels 1320-990. This applies to
all materials in all phases in all periods.
Enter the following destination economics for copper (CUI) sent to the mill: recovery = 87%; selling price =
$2.40/lb; conversion factor = 22.046.
Enter the following destination economics for copper (CUI) sent to the leach pad: recovery = 67%; selling
price = $1.80/lb; conversion factor = 22.046.
Enter the following destination economics for molybdenum (MOI) sent to the mill: recovery = 75%; selling price
= $7.50/lb; conversion factor = 22.046.
Discount Factor Economics tab → Discount Factor panel → enter a discount percentage and
discounting convention → Calculate
Capital Investment Economics tab → Capital Investment panel → enter a capital investment for
each required period
Fixed Mining Cost Economics tab → Fixed Mining Cost panel → enter a mining cost and process-
ing cost for each destination
Additional Mining Cost Economics tab → Additional Mining Cost panel → enter an additional mining
cost for each required period
Destination Economics Economics tab → Destination Economics panel → enter revenue generating
economics for each destination
Destination Sequencing
Subzone geometry may be sequenced automatically, through leadlines, or manually.
Automatic sequencing is driven by the fill method chosen, filling rules, and seed selection method.
The fill method is either short or long and the filling rules include the equivalent flat haul (EFH) Up,
EFH Down, and Max Open Lifts parameters. The seed selection options include: Northmost, South-
most, Eastmost, Westmost, Closest to Destination Location, and Ramp Geometry (if imported) or
manually selected. The dump short method will sequence subzones in order of shortest haul dis-
tance with reference to the Seed selection, while the dump long will do the opposite. Similar
to undercutting precedence, filling precedence will be honored to ensure filling is geometrically
feasible. Leadlines can be included to further refine the dumping sequence.
The filling rules control the availability of subzones on upper or lower lifts. Max Open Lifts is defaulted
to 1, which means all subzones on lower lifts must be filled before going up a level. More open lifts
will allow the program to check haul distances for upper level subzones to determine the best
inter-level sequence. Equivelant Flat Haul (EFH) inputs are factors to adjust the distance traveled
on grade relative to the distance traveled on the current elevation. The simulated longer or shorter
driving distances between lifts emulates the affect of driving slower or faster up and down the
ramp, and further improves the sequence relative to the fill method.
Seed selection will determine the first subzone to be filled on a level. From this subzone, all other
InLiftStub geometry will be drawn. This too affects sequence order since it is from this geometry
that haul distances are measured for all subsequent subzones. Manual sequencing allows the user
to adjust the sequence relative to the seed geometry at anytime.
Leadline sequencing is essentially an override of the automatic sequence for subzones intersected
by the leadline geometry parameters. Manual sequencing can either be done interactively in the
MS3D viewer via the Link Viewer option, or in the grid list using the arrow buttons. The order will still
honor filling precedence for inter-lift geometry and will give an error when violated.
The default sequence logic is to dump short, follow the selected seed selection, and use Max Open Lifts
= 1.
Sequence subzones Sequencing → Destination Sequencing panel → Sequencer drop down → Auto
Sequenceight All Subzones... → Sequence Tab
Digline Sequencing
Cut sequencing is defined on the Digline Sequencing panel. It is done through the use of two
attributes (digline and direction). Diglines describe independent sequences of cuts on a bench
or level, while direction describes the sequence order. Cuts apart of different diglines within the
same level may be mined simultaneously, but must follow preceding cut(s) within the same digline.
By default each cut is set to its own digline and direction, i.e. 1 and 1. For certain data sources
(MSIP and MSPlanner), the values may be read by mapping attributes.
The Digline Sequencing panel is split into three windows: Groups, Diglines, and Cuts. Diglines
are either user defined or configured automatically through rules. The various rules are: North-
most, Southmost, Eastmost, Westmost, Centermost, Highest, Lowest, Azimuth, Manual Start, Closest
to Geometry, and Leadline. These Rules function similar to Seeds in the Destination Sequencing
panel. They control the direction or order of cuts in the digline they are assigned to. Configuration
of Rules may either be done interactively in the MS3D viewer, via the Link Viewer option, or in the
grid list using the arrow buttons.
The Group window functions as a filtering dialog for Mining Area, Phase, and Level. It can also
be used to control partition assignment. Partitions are groups of diglines within a level for a given
phase. Note that each level of each phase will have a default partion and digline.
Digline Reset Sequencing → Destination Sequencing panel → Groups panel → click on Reset
button → click on Remove Empty Diglines button
Massive assignment of digline rules to cuts is available in the Groups window. This setup will apply to the
filtered setup in the Group window. First, reset all cuts to digline 1 for the filtered group. Next, click the
Add Partition... button, check Add cuts from Digline 1 and configure the digline rule (e.g. Northmost,
Southmost, etc.).
NOTES
Checking "Recalculate digline and direction" will reset any previous digline and direction assignment. "Save
when updating MSPD" will save the digline and direction and precedence values to the mapped attributes
(only for MSIP data sources) during the update process.
Keep the defaults in place in the Cut Precedence and Level panels.
Phase Precedence Precedence → Phase Precedence panel → Phase Precedence tab → define
the relationships between as listed in Figure on next page → check Recalcu-
late precedence (lower left) → Apply
Cut Precedence Precedence → Phase Precedence panel → Cut Precedence tab → change
(optional) the Upper Level row values (Slope, expanded cut, tested cut, grid size and
grid %) to values that represent the geometry desired
Level (optional) Precedence → Phase Precedence panel → Level tab → select an elevation →
use the arrows on the right to change the order of the list
Phase lag may be defined on the Phase Precedence panel too. Phase lag will further restrict an already
defined After precedence by defining a minimum or maximum bench lag between the two phases. In
other words, it can be used to ensure that the After phase stays within, or apart, a specific number of
benches.
ADDITIONAL PRECEDENCE
Additional precedence panels — Level Precedence, Phase Append, Advanced Precedence,
Destination Precedence and Destination/Phase Precedence — can be used to modify or create
new precedence rules. The Advanced Precedence panel allows you to manually schedule cuts
that need to be mined prior to the selected cut. Similar to Advanced Constraints, this panel can
also be linked with the MS3D viewer, so that cut precedence may be assigned interactively.
The Destination Precedence panel assigns filling priority to destinations and also controls when
secondary destinations can start receiving material. The Destination/Phase Precedence panel
defines a dependency between filling destinations and phase mining. It is commonly used when
setting a backfill trigger. For example, completely mining an area triggers the filling of a dump in
the same area.
Equipment
The Equipment panel is used to define both haulers (trucks) and loaders (shovel) parameters. Truck
and shovels use a default payload/dig rate. This rate may be overridden using the payload/dig
rate configuration dialogs. This dialog allows varying by mining area, material, phase, and level in
each period.
Period availability, Fuel Price ($/unit), and Minimum/Maximum Hours are definable in the Miscella-
neous Parameters dialog. All parameters may vary by period. Availability(%), Efficiency(%), and
Operating Cost ($/hour) are definable in the Operating Parameters dialog. These too may very
by period, or alternatively, "Declining Operating Parameters" may be used to define them by max-
imum truck or shovel hours.
Equipment sets are pairings of trucks with shovels. Trucks may be paired with any shovel to make
equipment sets regardless of origination (i.e. virtual or imported from haulage). Delay times such
as Spot, Load, Dump, and Wait Time, and the associated fuel burn rates, are also definable.
The shovel hours, and in turn number of units calculated, will be based on Loading Time by default rather
than dig rate. This is easily overridden by checking Use Dig Rate in the Loader parameters.
Enter the following delay times for Shovel-1: Spot Time = 0.5, Load Time = 2, Dump Time = 0.5, Wait Time = 0
Hauler Miscellaneous MS_797F icon → Miscellaneous Parameters → click on “. . . ” for any parameter
Parameters → Fuel Price ($/unit) = .90
Hauler Operating MS_797F icon → Operating Parameters → click on “. . . ” for any parameter →
Parameters Availability (%) = 95, Efficiency (%) = 87 → Operating Cost ($/hr) = 200
Loader Operating Shovel-1 icon → Operating Parameters → click on “. . . ” for any parameter →
Parameters Availability (%) = 80, Efficiency (%) = 75 → Operating Cost ($/hr) = 400
Equipment may be changed on the fly from the dialog windows without exiting and reselecting another
equipment’s icon. This applies to the payload/digrate configuration, Miscellaneous Parameters, and
Operating Parameters.
Haulage Network
The Haulage Network panel is a grid display of each road, it’s connecting nodes, and information
about both. The type of road (Surface or Source), type of node (Tie, Source, Destination), phase
and period availability, road distance and grade %. All fields are read only except the phase and
period availability attributes, which are not read in from the haulage plan. It is expected to be
setup here, and validated through the MS3D viewer using the Link Viewer options.
Cycle Time
The Cycle Time panel is a read only report of all cycle times, travel distances, and fuel burned from
each cut source (centroid) to each destination subzone. Only the most optimal entry (fastest) is
calculated and brought into the report. It is broken down into 3 areas, Cut to Destination, In-Lift,
and Reclaim. The Cut to Destination reports data from the cut source to the destination node or
entry point. This includes the flat in pit segments drawn from the cut centroid to intersecting road.
These are visualized as the InPitStubs in MS3D viewer through the Link Viewer options. Data in this
section is broken down into In and Out sections. The convention is In to the Source unloaded and
Out of the Source loaded.
The In-Lift portion reports data from the destination node to the subzone. The In-Lift can utilize
ramp geometry if configured. The InLiftStub is a visual representation in the MS3D Viewer of these
distances. Additionally, data here is broken down into In Flow and Out Flow, each with their own
In Bound and Out Bound sections. The convention here is material flows in to the destination or
flows out of the Destination. Also, material is In Bound to the destination or Out Bound from the
destination. In Flow is for typical material movement from the source to the destination, in loaded
and out unloaded. Out flow is for stockpile material movement, in unloaded and out loaded.
The Reclaim portion reports information on all stockpile to Mill combinations. For this plan that
means STK1_STK to MILL_DST and STK2_STK to MILL_DST. The data reported here is broken down like
the Cut to Destination section, and only reports from stockpile node to destination node.
Cycle time Calculate → Check Mining Areas = Open Pit1 → Check Calculating Option =
ALL
NOTES
Initial Schedule
The initial setup thus far has called for just two tonnage constraints, MILL_DST and Total[Mill+Waste],
a number of phases constraint on Total[Number of Phases], and a trucks constraint on Truck
Hours[Total]. Each must be met to maximize the schedule objective, NPV. When creating a sched-
ule, it’s always a good idea to start with loose constraints. As you go on, you can add complexity.
The initial schedule will be run with CPLEX, using Scheduling without equipment and with Single
Period Window. We will also Ignore multi-lift scheduling, Allow partial mining with 15 partial cuts,
check Must Fully Mine preceding cuts of upper level and check the option to Vary percentage by
material.
Open Schedule Schedule Calculation icon (main menu bar) → Run (Ctrl+F5)
Calculation
Setup Calculation General tab → Schedule Periods = 1–45; Scheduling Options = Schedule with-
out equipment → Engine tab → Engine Options = CPLEX; Miscellaneous =
check Ignore multi-lift scheduling → Partials Cut tab → check Allow partial
mining; Maximum partial cuts in a period = 15; check Must Fully Mine Pre-
ceding Cuts On Upper Level; check Vary percentage by material
Allowing 15 partial cuts and checking Must fully mine preceding cuts on upper level allows the program
to have a partial cut in each phase in the same period, but the partial cut must exist as the bottom
bench. Checking Vary percentage by material allows different percentages of materials in a cut to be
contribute to the overall partial percentage, unchecked they must be the same.
Reports
Several reports are available to review an MSSO schedule. The Analysis Report lets you monitor
material movement and equipment use. The Cash Flow Report details expenses and revenue.
The Cycle Time Report shows the results of the cycle times calculated on the Cycle Time panel.
The Full Report is a flat report of all material movement made. The Full Report may be linked
with the viewer to view the routes taken for each material movement, as well as the cut and
subzone geometry. All reports are customizable, taking advantage of the Advanced Reporting
and Charting (ARC) format. All reports may be exported into a variety of formats including .xls,
.xlsx, and .csv. All reports are accessed through their icons on the main menu bar.
Display Results Main menu bar → Analysis Report → Material Movement By Destination tem-
plate (installed) → Open
Modify View Field List → click and drag to add, remove or rearrange data in the PivotChart
Open Report Grouping Analysis Report main menu bar → click Report Grouping icon
Add reporting group Report Grouping → Plus icon (top left) → select add Material Report Group →
give Report Group Name → select groups to add → refresh to add to Field
List
Cash Flow Report Cash Flow Report icon (main menu bar) → Input Parameters (lower left
Adding Equipment
So far, you have created a mining schedule that takes into account materials and destinations.
Now, recalculate the MSSO schedule using two other options: Scheduling then Assign Equipment
and Scheduling with Equipment. The former option has been the industry standard. With this
option, MineSight determines the best mining sequence that meets the schedule objective before
trying to assign equipment. This does not guarantee the best utilization of the equipment to meet
equipment constraints. It may also fail in the process of assigning equipment. The Scheduling with
Equipment method guarantees the user the best schedule based on available equipment, taking
equipment constraints into account during the scheduling process.
EXERCISE: Create a Schedule Using the Schedule Then Assign Equipment Option
Schedule Calculation General tab → Schedule Periods 1–45; Scheduling Options = Scheduling Then
Assign Equipment
Once a schedule has been generated, the equipment parameters and constraints may be changed
and reapplied to the schedule using the Assign Equipment option. This option performs step two of the
Schedule Then Assign Equipment method, but without having to generate the mining sequence over
again, saving considerable time. You can apply this option to any generated schedule, even those
generated without and directly with equipment.
Notice the schedule failed to assign equipment in period 33, but that the schedule completed
anyways using the Without Equipment option. Check the mssosched033.dtl for the reason for the
failure.
EXERCISE: Complete the Schedule Using the Schedule Then Assign Equipment Option
Increase the maximum Truck Hours [Total] allowed in period 33 since that was the constraint violated in the
previous run. Use 225,000 hours. Rerun the schedule or simply re-assign the equipment.
Do other periods continue to fail to assign truck hours? If so, increase the maximum Truck Hours [Total].
Equipment Usage Reports → Analysis Report → Equipment Usage template (installed) → Open
Analysis Report displaying equipment usage, including hours and number of units.
Equipment Usage Reports → Analysis Report → Equipment Usage template (installed) → Open
Schedule Calculation General tab → Schedule Periods 1–45 → Scheduling Options = Scheduling With
Equipment
Full Report Full Report icon (main menu bar) → Link Viewer → click on row(s)to highlight
Relaxing Constraints
There are times when a combination of constraints may prevent MSSO from completing a schedule
and multi-period scheduling may not give a desired result, i.e. a negative NPV. In these situations,
you will need to either manually relax constraints or use the Constraint Relaxation option in MSSO.
The Constraint Relaxation option automatically relaxes a constraint based on an assigned flexibility
ranking. A value of 1 indicates a constraint is very flexible (will be modified first); a value of 10
indicates a constraint is not flexible; and a blank field indicates a constraint is fixed and can’t be
modified. After the infeasibility analysis completes, the program will tell the user exactly what it
relaxed and by how much.
A shortcut to configure Constraints Relaxation is also found on the Schedule Calculation → Engine tab.
Were you able to finish the schedule without relaxing the Truck Hours [Total] upper limit?
What was the schedules cumulative NPV? Compare this with 04–With Equipment–Relaxed.
Compare the stockpile utilization with 04–With Equipment–Relaxed? Were stockpiles more or less relied on?
Try to minimize and smooth the total truck hours used. What is the maximum number trucks needed to com-
plete the schedule?
Trucks Constraints → Trucks panel → Truck Hours [Total] Lower = 143,640 and Truck
Hours [Total] Upper = 159,600 for all periods
Multi-Period Scheduling
By default, MSSO creates schedules on a period-by-period basis. Using this method is quick and
easy, but you could end up with a “short-sighted” plan, which occurs when the best solution is
found for one period (X) but a non-solution for the following period (X+1). Multi-period scheduling
logic can help in these cases, as it allows you to group several periods together. MSSO looks
“forward” or “backward” when solving for that group of cuts. The solution for period X, for example,
would be tweaked just enough to allow solutions for all the other selected periods (without violating
any constraints).
Is the schedule better or worse than the 05–Truck Hours? Compare the NPV and equipment usage.
Redefine a larger window size and rerun to try and complete the schedule with the highest cumulative NPV
possible.
What was you final NPV? How does it compare with a window size of 2 and step size of 1?
Fixed Period Window Schedule Calculation → General tab → Period → Period Window Option =
Fixed Period Window → Window Size = 2, Step Size = 1 → Ok
NOTES
Future Training
Whether it takes a few hours or a few days, training with Hexagon Mining’s newest tools can pay
instant dividends. Designed to fit your schedule, our mix-and-match formats support your learning
needs no matter what your expertise with MineSight software.
Spend some time using our software in day-to-day applications. When you are comfortable
working with MineSight software, contact us at [email protected] or visit
www.hexagonmining.com to set up your next training.
c
2014, 2013, 2012, 2011, 2010, 2009 by Leica Geosystems AG. All rights reserved. No part of this document shall be reproduced, stored in a
retrieval system, or transmitted by any means, electronic, photocopying, recording, or otherwise, without written permission from Mintec, Inc.
All terms mentioned in this document that are known to be trademarks or registered trademarks of their respective companies have been
appropriately identified. MineSight
isR a registered trademark of Leica Geosystems. This material is subject to all the terms in the MineSight
End User License Agreement (EULA).