Generating Cycle Times

with Haulage
Contact Us

Australia Tech Support Peru Tech Support

+61.7.4167.0076 +51.1.700.9844
[email protected] [email protected]

Brazil Tech Support Prominas South Africa Tech Support

+55.31.3497.5092 +27.87.550.4441
[email protected] [email protected]

Canada Tech Support UK Tech Support

+1.604.757.4394 +44.1202.286326
[email protected] [email protected]

Chile Tech Support USA Tech Support-English

+56.22.898.6072 +1.520.729.4396
[email protected] [email protected]

Mexico Tech Support USA Tech Support-Spanish

+52.55.8421.0747 +1.520.448.4396
[email protected] [email protected]

For training information please email

[email protected]
or visit the training page at
www.hexagonmining.com

Generating Cycle Times with Haulage. V3. October 13, 2017

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).
Generating
Cycle Times
with
Haulage
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

3D BLOCK MODEL (3DBM) STRATIGRAPHIC MODEL

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.

ECONOMIC PIT LIMITS & PIT OPTIMIZATION

Generate pit shells to reflect economic designs. Using floating cone or Lerchs-Grossmann tech-
niques, work on whole blocks from the 3D block model to find economic pit limits for economic
assumptions such as costs, net value, cutoff grades and pit wall slope. Economic material is usually
one grade or an equivalent grade item. You can view the results in 2D or 3D, use the results to
guide your phase design, plot your design in plan or section, calculate reserves and run simple
production scheduling on your reserves.

vi
 Generating Cycle Times with Haulage

PIT & UNDERGROUND DESIGN

Accurately design detailed open pit geometry, in- Support & Services
cluding ramps and pushbacks with variable wall
Client service and satisfaction is our
slopes, and display your pit designs in plan or section, first priority. Boasting a multilingual
clipped against topography or in 3D. You can eval- group of geologists and engineers
uate reserves for pit designs based on a partial block stationed worldwide, the MineSight
basis and calculate production schedules from the re- team has years of hands-on, real-world
serves. Create and manipulate underground design experience.
through CAD functions and from survey information.
GLOBAL SUPPORT

Providing global technical support

LONG TERM PLANNING
during the day and with extended
Generate schedules for long term planning based on hours on weekdays and weekends,
pushback designs, or phases, and reserves computed technical support is at your service. The
by the mine-planning programs. The basic input pa- company’s offices in the United States,
rameters for each production period include mill ca- Canada, Mexico, Peru, Chile, Brazil,
pacity, mine capacity and cutoff grades. South Africa, Australia and the United
Kingdom all offer technical support via
phone and email.
SHORT TERM PLANNING TRAINING
Generate schedules for short term planning based on
Our software is always improving in
cuts or solids in interactive planning modules. A large response to our clients’ needs. It
selection of parameters and flexible configurations let doesn’t take long to fall behind. That’s
you control daily, weekly or monthly production. why we’re committed to helping you
get the most from our software. Take
advantage of our introductory and ad-
vanced courses or create a customized
curriculum that best suits your needs.

SERVICES

MineSight Services offers mine planning

studies, mineral resource studies and
project assistance to help you get
the most from your mine and from
MineSight. From scoping studies to final
feasibility studies, to MineSight coach,
depend on our multilingual MineSight
specialists.

vii
Contents
Geo Copper Data Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
MineSight Haulage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
Haul Networks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
Global Settings in Haulage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Haulage Plan Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Material Routing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Material Routing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Haulage Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
Cycle Times and Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
Haulage Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Analysis of Haulage Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Conclusion & Future Training . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
 Generating Cycle Times with Haulage

Geo Copper Data Set

The Geo Copper Data Set comes from a multi-metallic porphyry deposit with copper as the main
ore of interest. Molybdenum and zinc data have also been collected. The mineralization type of
the deposit (oxide, primary sulfides and secondary sulfides) most strongly controls the distribution
of grade. Sulfide mineralization consists mainly of pyrite and chalcopyrite. The deposit occurs in
felsic to intermediate intrusive igneous rocks and associated breccias. Alteration zones outward
from the center — from a phyllic zone to a propylitic halo.

ALTERATION ZONES
Phyllic 1
Potassic 2
Propylitic 3

LITHOLOGY CODES
Diorite 1
Granodiorite 2
Quartz Feldspar 3
Intermediate Breccia 4
Late Breccia 5
Country Rock 6

MINERALOGY CODES
PROJECT BOUNDARY COORDINATES (in metric units)
Oxides 1
Min Max Cell Size Block
Primary Sulfides 2
Count
Secondary Sulfides 3
Easting: 3500 8500 (DX=25) 200
Outside(default code) 4
Northing: 4500 9500 (DY=25) 200
Elevation: 705 1965 (DZ=15) 84

Geologists have collected and logged information from 287 drillholes at the site over the course of
two drilling campaigns (one on the northwest side of the deposit and the other on the southeast).
Drillhole types include diamond, reverse circulation, hammer, and mixed hammer and diamond.
Samples were collected at various lengths — from 1-meter to 15-meter intervals. Element sample
analysis included total copper, acid soluble copper, molybdenum and zinc.

Geo Copper Data Set | 1

c 2017 Hexagon Mining

NOTES

2 | Geo Copper Data Set

 Generating Cycle Times with Haulage

MineSight Haulage
MineSight Haulage is a standalone program. As
originally envisioned, it can function as both cycle LEARNING OBJECTIVE
time calculator and material routing tool. This later
capability has been replaced in the workflow pro- Understand how to configure MineSight
cess by our other scheduling tools, including MSSO. Haulage for use in MineSight Schedule
Now, Haulage is used only as a cycle time calcu- Optimizer (MSSO).
lator. It is currently only used to setup the network
geometry and define trucks. Further configuration is unnecessary as the detailed setup is now
done within MSSO. MSSO will import this setup directly, essentially own it’s own copy of it, while just
leveraging the calculation engine to calculate cycle times on the fly.
Key Features covered in Haulage:
• Setup of haul network geometry through importing roads (polylines) and nodes (points).
• Defining of equipment including availability, efficiency, speeds, fuel burn rates, rimpull curves
and capacity.
• Running validation options to ensure correct network setup
• Calculating and reporting cycle times for validation purposes
• Generate route profiles for drive diagrams and external processing.
• Create cycle time file for use with schedule (SCD) file type data source
Before using Haulage, you should have already developed a mining phases and a pit design. You
should also have planned lift strategies and determined the location of stockpiles, dumps and
any other hauling destinations. In addition, you must set up a haul network in MineSight 3D (MS3D)
and create a MineSight Planning Database (MSPD) to house the haulage plan and imported the
geometry. The MSPD is created using the MineSight Database Manager (MSDBM).

MineSight Haulage | 3
c 2017 Hexagon Mining

NOTES

4 | MineSight Haulage
 Generating Cycle Times with Haulage

Haul Networks
Creating a haul network of material sources, routes
and destinations can take considerable time, es- LEARNING OBJECTIVE
pecially for large and complicated mine sites; but
setting up the network correctly will save “trouble- Map material sources, routes and desti-
shooting” time later on. You will design a haul net- nations in a haul network.
work in MineSight 3D (MS3D) using basic CAD func-
tions. Every road in the network must start with a node and end with a node. In addition, you must
assign every road a destination type:
• Tie-Node: Nodes in which multiple roads in the network join.
• Destination: The node at the end of a road, such as a dump or a mill.
• Source: The node at the start of a road, such as a mining face.
• Stockpile: Both a starting point and an ending of a road. Stockpiles receive material from a
source (i.e., a mining face); and at the same time send material to another destination, (i.e.,
a crusher).

A haulage network

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.

Haul Networks | 5
c 2017 Hexagon Mining

EXERCISE: Create Nodes and Roads

Use the 2018 contours to position nodes for destinations, sources and junctions (use Polyline Snap). Attribute
each of the nodes with a unique element name using Prompt for Attribute on Create. Digitize polyline seg-
ments to define the roads using Point Snap to connect each node. All road segments should be defined
by a start and an end node. As you digitize the roads, refer to the status bar for the dip angle and make
modifications as needed. Split polylines at nodes by using Split at Node.

Nodes put contours in Edit Mode > MS3D Desktop Menu → Element → Prompt for
Attribute on Create → Point → Create → Point → give the point an attribute
name → position point by snapping to a contour line or a surface → right-
click to end → Save

Roads MS3D Desktop Menu → Element → Prompt for Attribute on Create → File →
Project Settings → Status Bar tab → Configure Angles section → select dip
information to report → Polyline → Create → Polyline → give the polyline an
attribute name → snap line to contours or the surface faces → right-click to
end → Save

Redefine Road Direction

For optimal results, you should digitize roads
going from sources towards destinations.
Haulage uses these directions to calculate
and route materials.

For the most accurate cycle times, make

sure road segments go from source nodes
toward destination nodes.

EXERCISE: Redefine Road Directions

Select all the road segments and display their current directions. For roads segments going in the wrong di-
rection, use the Redefine Directions Tool make road segments go from sources towards destinations.

Check Directions place polylines in Selection Mode > MS3D Desktop Menu > Polyline > Redefine
> Direction > check Show Current Polyline/Polygon directions box > select an
arrow

Change Directions Redefine Directions panel > Reselect > click the polyline segment(s) to modify
and right-click to confirm > Polylines (or Polygons) > select new direction >
Preview > Apply

6 | Haul Networks
 Generating Cycle Times with Haulage

Global Settings in Haulage

The Global Settings panel in MineSight Haulage
controls project settings, information stored back LEARNING OBJECTIVE
to the MineSight Planning Database and default
values used for un-routable material. Control the logic and setting that
You can control the logic and settings that Haulage uses to generate a plan.
Haulage uses to generate a plan, including: turn-
ing on/off material routing capability; resetting destination capacities; changing how rolling resis-
tance is measured; suppressing default errors; and controlling the logic the program uses to route
materials.

DEFAULT VALUES
Haulage assigns a default value to any material not sent to a destination. Any lift added to the
destinations will receive a default design grade and max speed. Roads imported into Haulage
are assigned the max speed and rolling resistance.
Also of note, the default “fastest time” logic that Haulage uses to route materials in a haul network
does not guarantee use of the same outbound and inbound route. For example, the program
might route a loaded hauler down a hill for the outbound trip but select a less steep route for the
return trip. Keep this in mind later when you are validating cycle times.

EXERCISE: Modify Global Settings

Set the following options: Use Material Routing, Reset All Capacities, Rolling Resistance as % Grade and Ig-
nore Default Source/Destinations Warnings.

Project Settings MSHaulage → Global Settings → Project Settings → turn on/off options

The Ignore Source/Destinations Warnings option also allows you to stop the program from running in the
event that it contains too many errors.

Global Settings in Haulage | 7

c 2017 Hexagon Mining

NOTES

8 | Global Settings in Haulage

 Generating Cycle Times with Haulage

Haulage Plan Setup

Once you’ve digitized and saved your haul net-
work, you can start a haulage plan in MineSight LEARNING OBJECTIVE
Haulage. A haulage plan stores material sources,
destinations and route geometries to the MineSight Create and configure a haulage plan
Planning Database (MSPD). The data — which in- with periods, phases and equipment sets.
cludes material routing parameters such as peri-
ods, phases, route restrictions and material bins — is used to compute cycle times, route profiles
and material routing reports.

EXERCISE: Create a New Haulage Plan

Connect to the pitn-stp ODBC, which links to the associated MSPD. Create a new haulage plan and call it
“msh-quarterly.”

Connect to MSPD MS3D Desktop Menu → Utilities → MSPD → Connect to MSPD → select Data
Source → Machine Data Source tab → select ODBC → OK

New Haulage Plan MS3D Desktop Menu → OP Eng → MSHaulage → File → New → name plan

Periods and Phases

Haulage requires information on the number of periods (including durations) and phases in a plan
to calculate equipment requirements. You can add the phase and period values manually, or
import them from an IP plan or a CSV file. By default, a period spans 720 hours (30 days x 24
hours); but you can change the value to accommodate periods of different durations. Periods
and phases can be combined into groups for controlling road availability.

If there are no road restrictions in the plan, one period will be sufficient. Adding more will only
delay calculation time and yield the same result. Haulage computes the cycle times from each
source to each destination for each material cutoff, period and equipment set combination.

EXERCISE: Input Phases and Periods

Add one period and three phases to your haulage plan. Since you are working with a quarterly schedule,
the period will be 2160 hours long. You are not going to have any road restrictions or varying road availability,
so one period is sufficient.

Add Period Periods section → click “+” → enter a period name and time span

Add Phase Phases section → click on the “+” → enter a phase name

You can group periods and phases together by selecting them from the Pick Elements column, assigning
a group name and clicking on the “+” button. This method is useful when defining road restrictions for a
group of periods or phases.

Haulage Plan Setup | 9

c 2017 Hexagon Mining

Importing a Haul Network

Haulage needs to refer to a haul network to calculate cycle times, equipment requirements,
haulage profiles and other data. The haul network should reflect the mine site as closely as possi-
ble. Once you’ve imported the network into Haulage, you can configure your haulage plan with
additional information detailing road conditions and destinations. Again, the closer the depiction
of the plan is to the actual site, the more accurate the results.

EXERCISE: Import and Edit Haulage Nodes

Import the nodes from the haulage network into the pitn-msh plan. Select the WD1 node. Open the Haulage
- Network Editor (click on the “penci”’ icon) and add a capacity of 10 billion tonnes.

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

Edit Node Haul Network → Locations → modify the information in the matrix → Save

Delete Node Haul Network → Locations → click “X” to delete one node or “XX” to delete all
nodes

Add Lifts/Sub Zones Haul Network → Locations → select and right-click on the node → add lifts,
subzones, capacities, distances and speed

EXERCISE: Import and Edit Roads

Import all the road segments from the into the pitn-msh plan. Set a global maximum speed of 35KMH and a
rolling resistance of 2.5%.

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

Import Roads Haul Network → Routes → Select Route → click and drag a window around all
the road polylines to import → right-click to confirm

Delete Road Haul Network → Locations → click “X” to delete one road or “XX” to delete all
roads

Route Details Haul Network → Locations → select and right-click road → define max speed,
rolling resistance and availability per segment

You can add detail to the imported codes or routes with the Haulage - Network Editor (pencil icon). This
panel provides an easy way to: verify node types; verify haulage route start points and endpoints; add
lifts to sources and destinations; and add node types along a specified route. Use the Network Editor to
add nodes to a selected route segment at a specified distance.

10 | Haulage Plan Setup

 Generating Cycle Times with Haulage

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. A cycle time is the travel time from
a source to a destination and back to the source, plus any delay time encountered along the
way. Delay times include load, dump, spot and wait times. To add precision to the calcula-
tions, Haulage also considers road conditions, road restrictions, speed limits and equipment per-
formance parameters.
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.

ACTIVATING THE EQUIPMENT REPOSITORY

The Equipment Repository is not available

by default, as most users do not have full
permissions to access their MSPDs. Once full
(or administrative) permissions are granted,
the equipment repository can be activated
and used.
To access the Equipment Repository: MSPD

→ MSPD Manager → Connection → Con-

nect → Connect to SQL Server → select
Authentication type → MineSight Planning
Database → Update → Update Equipment
→ Select Database → Apply

EXERCISE: Add a Truck

Add a CAT-793D (standard) and a CAT-777D hauler from the Equipment Repository to the haulage plan. In
the Attributes for a Truck or Shovel panel, change the availability to 90% and the utilization to 90% for both.

Truck Equipment → Add Truck icon → Hauler field → give truck a name → associated
hauler window (bottom) → enter truck and performance specs Equipment
Repository| Equipment → Equipment Repository → Add → OK → click on the
hauler label → Attributes for a Truck or Shovel panel → configure parameters

EXERCISE: Add a Shovel

Add a 4100XPC shovel to your haulage plan.

Shovel Equipment → click Add Shovel button → configure Loader attribute fields

Haulage Plan Setup | 11

c 2017 Hexagon Mining

EXERCISE: Add an Equipment Set

Create two equipment sets and configure the delay times for both as: Loadtime = 1.5mins, Dumptime = 1min,
Spottime = 0.5 min and Waittime = 0.5min.

Equipment Set Add Equipment Set → name the set → set the _Hauler and _Loader parameters

EXERCISE: Add a Shovel to the Equipment Repository

Add the 4100XPC shovel to the Equipment Repository.

Add to Repository Equipment Repository → select the equipment → set a name and description
→ To Repository

12 | Haulage Plan Setup

 Generating Cycle Times with Haulage

Material Routing
In a long term plan, in which cuts are typically un-
available, MineSight Haulage is most often used for LEARNING OBJECTIVE
generating cycle times and route profiles. In such
a case, you will not use the Material Routing sec- Define destination types and then over-
tion. If you’ve created cuts in MineSight Interactive ride the destination designation for a spe-
Planner (MSIP), then you can create material rout- cific period.
ing reports.
The first step in configuring materials is defining ma-
terial bins, which can be combined into groups
and routed to the same destination(s). You can
add material bins manually in Haulage, or import
them from a MineSight Interactive Planner (MSIP)
plan or CSV file. The destinations are known as
Destination Types or Dtypes. Dtypes are in turn
Dtypes let you group similar material types.
mapped to one or more destination for material
routing purposes.

EXERCISE: Map Dtypes to Destinations

Bring in the material definitions from the pitn-msip plan. Add three Dtypes — Mill, Leach and Waste. Map all
the mill material bins to the Mill Dtype, waste material bins to Waste Dtype, and the leach material bins to the
Leach Dtype. Set this configuration for all periods.

Finally, map the Mill Dtype to the MILL_DST, STK1_STK, and STK2_STK; the Waste Dtype to WD1_DST; and the
Leach Dtype to LEACH_STK. Note: Mill material can be broken down into additional Dtypes (e.g., hg, mg, lg)
if more detail is needed in the Haulage plan.

Import Materials Material Routing → Materials → click Import Materials from IP button → select
IP plan → Import

Dtypes Destination Types → click on “+” button → add Mill, Leach and Waste Dtypes or
use Import Destination from CSV file option to import them → select material
bins → select the Dtype and click the right arrow → expand the tree to see
that the correct mapping has been set → repeat for all Dtypes → choose
a different period for which to configure Dtypes or click on Set All to set the
same configuration for all periods

Map DTypes Material Routing → Destinations → set a Dtype for each Location

If materials are not going to be routed, uncheck the Use Material Routing check box in the Global
Settings Menu. This will deactivate all fields having to do with routing materials.

Material Routing | 13
c 2017 Hexagon Mining

DTYPE OVERRIDES
Haulage routes Dtypes to the closest destination. It will send materials to another destination only
after the capacity of the first one has been met. During unexpected situations (e.g., road outages,
capacity caps and mill anomalies), you may need to force a material to a different destination
than the one mapped in the Dtype. In these situations, you can choose from several override
options available in Haulage. The options have an order of precedence as follows:
• Material Routing — Map Overrides dialog
• Material Routing — IP Attribute Overrides dialog
Includes control over the equipment set used to mine a cut, the period in which a cut will be
mined, and the destination to which a cut will be sent.
• Material Routing — Destinations dialog — Dtype
• Global Settings defaults
Default settings can be set for cuts that don’t have them defined. The defaults include the
period, phase, equipment set, haul source and haul destination.
• Material Routing — Editor
Used to preview the material routing report for a selected material and make any necessary
modifications to the Period, Phase, Destination, Lift and Equipment Set columns. An output
report is generated that can be manually altered. Each change results in a dynamic cal-
culation result, ideal for comparison purposes (i.e., choose a different equipment set and
instantaneously see a change in cycle time).

EXERCISE: Change Material Routing

Use the Map Overrides dialog to force material to the mill destination. Then use the IP Attribute Overrides
dialog to have Haulage read and use the phase values stored in mssoPhase.

Material Overrides Material Routing → Map Overrides → choose a period, Dtype, destination and
equipment set

IP Attribute Overrides Material Routing → IP Attributes Overrides → check the attribute boxes that you
want to use → click in the field and type either “c” or “I” or “m” to activate
a dropdown list of attributes beginning with these letters

14 | Material Routing
 Generating Cycle Times with Haulage

Material Routing Reports

The MineSight Haulage Editor produces a material
routing report containing information about min- LEARNING OBJECTIVE
ing cuts, including cut name, period, phase, ma-
terial name, cutoff bin, grade tonnes, destination Create and edit a material routing report
and fuel burn rate. This information helps the short containing calculations on the number of
term planner determine the number of trucks and trucks and shovels required to mine cuts,
shovels required to mine one or more cuts, and the and the amount of time it will take.
amount of time it will take. You can modify, export,
store and display the data in the report.
Creating a material routing report requires a MineSight Interactive Planner (MSIP) plan with existing
cuts. You can run the Editor using three different options:
• Current IP Cut — Uses a current (open) IP cut for haulage calculations.
• Current IP Plan — Uses a current (open) IP plan for haulage calculations. All cuts contained
within the IP plan will be used in the calculations.
• Select IP Plan — You can select any (closed) IP plan for calculations that within the same SQL
database.

Create and Edit a Material Routing Report

Create a material routing report by routing cuts from the msip-quarterly plan using the Select IP Plan option.
Then modify the data for cut P1_1395_01. Click on the Source header to sort the report by cut name. Change
the cut’s Eq Set field to ESet-2. Note how the cycle times change — this is a useful technique for comparing
different fleets.

A material routing report displays input data as white (or grey) and calculated data as blue.

Material Routing Report Material Routing → Editor → route cuts from IP → Select IP Plan → select the IP
plan → Import

Editing Report Material Routing report → click one of the fields to activate a drop down menu
→ select new value → Tab

Place the cursor over the Haulage icons to see their names. The Route Cuts from IP icon is the first one in
the material routing editor panel.

Exporting Report Data

You may want to export a material routing report into Excel or an ASCII file, usually for validation
purposes. Route profiles can be highlighted in MineSight 3D (MS3D) or exported to a geometry
object for further analysis.
You can also store data calculated in Haulage to the MineSight Planning Database (MSPD) so it
can be used with other programs (e.g., MSIP-Material Manager).

Material Routing Reports | 15

c 2017 Hexagon Mining

EXERCISE: Export Material Routing Report

Copy a material routing report to Excel and save a “Detailed Dump” to an ASCII file. When using the Detailed
Dump option, make sure that you don’t first left-click on the field; it must be a direct right-click for the menu
to appear. If you have selected multiple sources, right-click and use Selected Routes Detail Dump.

Then export a route to MS3D and save it using Route to.msr. Finally, store the report in the MSPD.

Copy to Excel Material Routing report → select all the columns → Ctrl + C → in Excel → Ctrl
+V

Detailed Dump Material Routing report → select a source and right-click → use Route Detail
Dump or Selected Routes Detail Dump → configure the ASCII Dump Helper
→ Save Setup → Create File → enter a name → save the report

Export Route Material Routing report → right-click on a source → Show Routes → use the
Show Routes and Clear Routes icons in the tool bar to activate and deacti-
vate highlights → Material Routing report → right-click on a Source → select
Route to .msr or Selected Routes to .msr → name the geometry object

Store to MSPD Material Routing report → Export to IP MSPD Database

16 | Material Routing Reports

 Generating Cycle Times with Haulage

Haulage Settings
Additional control over material routing, calcula-
tions and value storage is available in the Mine- LEARNING OBJECTIVE
Sight Haulage Settings panel. You can set a global
in-pit maximum speed and rolling resistance for pit Control material routing, calculations and
roads to cap any attributed road values that ex- value storage.
ceed the maximum.
Calculation units in Haulage match the units specified in the project — a metric project will report
metric values and an imperial project will report imperial values. Using the Ton Definition menu,
you can report results as tonnes, short tons or long tons.

Set a Maximum Speed and Rolling Resistance

Set a maximum speed of 35KMH, and a 2.5% grade.

In-pit Changes Material Routing → Settings → configure the settings

By default, Haulage routes materials by snapping a stub line from the center of a cut to a source road,
and following the road to the proper destination. A source road contains a source node and provides
access points for cuts to snap to. You can route cuts or benches that do not contain source nodes.
Adding source nodes, however, gives you additional control using the Consider Only Exact Nodes option.

Haulage Settings | 17
c 2017 Hexagon Mining

NOTES

18 | Haulage Settings
 Generating Cycle Times with Haulage

Cycle Times and Profiles

MineSight Haulage produces detailed cycle time
files containing data that other MineSight programs LEARNING OBJECTIVE
use as input for calculations.
MineSight Strategic Planner (MSSP) uses cycle times Generate cycle times for use in calcula-
to help determine equipment requirements, cap- tions.
ital investment costs and profit on a period-by-
period basis. The MSSP Compatible option in
Haulage changes the setup state so that required To create the most accurate cycle times pos-
sible, you can add nodes on each bench by
fields appear in the line-by-line format MSSP re-
using the Road Splitter option.
quires, namely: Phase ID, bench toe elevation,
destination ID, lift elevation, cycle time (minutes)
and fuel consumption rate.
MineSight Schedule Optimizer (MSSO) uses cycle times to calculate truck and shovel hours, which
are required for short term planning.
You can also export 3D route profiles for analysis.

EXERCISE:Create Custom Cycle Times and Profiles

Click on the MSSP Compatible button to automatically setup a standard cycle time format that can be used
with MSSP. Append additional fields to the report using the Columns to Report section. Once you have con-
figured a setup, you can save and reuse it.

Cycle Times Haulage → Cycle Times and Profiles → Cycle Times and Profile Generation Tool
→ Custom Cycle Time dialog → format Phases → Periods → Equipment →
format parameters → Columns to Report → Save the Setup → Create

Route Profiles Haulage → Cycle Times and Profiles → Cycle Times and Profile Generation Tool
→ Custom Cycle Time dialog → Profiles → select a folder for storage

Storing Data Back to the MSPD

The Cycle Time Database section lets you store cycle time information generated in the material
routing report to a SQLite database. MineSight Schedule Optimizer (MSSO) accesses the database
when generating a schedule.

EXERCISE: Cycle Time Database

Select the IP plan and the equipment set (select ALL), click the save icon and select mssoPhase phase at-
tribute.

Cycle Time Database Haulage → Global Settings → Cycle Time Database → configure as needed
→ Save and select mssoPhase phase attribute

Cycle Times and Profiles | 19

c 2017 Hexagon Mining

NOTES

20 | Cycle Times and Profiles

 Generating Cycle Times with Haulage

Haulage Validation
Whenever Haulage is unable to calculate a cy-
cle time between a source and destination for a LEARNING OBJECTIVE
given phase or period, it will populate an ASCII file,
_CycDBErrLog.txt, with warning messages inform- Identify problems that cause materials to
ing you of the affected source/destination combi- be un-routable.
nation and phase/period.
• The haul network you are using could contain gaps between roads and nodes.
• The roads may not be split at every possible connection point.
• Nodes or roads may have not been attributed properly resulting default names.
Whatever the case, you will need to troubleshoot to determine the cause. MineSight Haulage
provides a suite of validation tools for network highlighting, connection checks and cut validations.
You can access the tools from the main menu or the tree menu — both contain similar options.
Haulage will still calculate a cycle time, assigning the un-routable materials the default values
specified in Global Settings.

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.

EXERCISE: Highlight Network by Period/Phase

Highlight all the available roads for period 1.

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.

EXERCISE: Check Haul Network Connections

Check Connections MSHaulage → Validation → click Check Connections button → click on any
error or warning messages

Haulage Validation | 21
c 2017 Hexagon Mining

NOTES

22 | Haulage Validation
 Generating Cycle Times with Haulage

Analysis of Haulage Results

Advanced Reporting & Charting (ARC) technol-
ogy makes evaluating and displaying MineSight LEARNING OBJECTIVE
Haulage results simple. The Analysis menu in
Haulage offers Material Routing and Cycle Time Analyze and publish your results with ARC.
options. The results appear in a pivot table and
chart combination (PivotChart), which is fully cus-
tomizable. In the pivot table, item fields may be added, removed, sorted, filtered or reordered;
custom fields and grade summary calculations may also be added. The real power of the analysis
reports are as an auditing tool. It is quite easy to see if a source has a missing cycle time for a
particular destination in a given phase or period.
The accompanying chart automatically updates whenever pivot table fields are highlighted. The
overall changes made to the pivot table and chart can be saved to a template for future use.
Once all the information is displayed exactly as needed, it can be exported using several formats.
We are not using material routing, therefore this analysis will not have any reported results. The
Cycle Times section determines cycle times for all the source nodes to all the possible destinations
in all the possible phases and periods. If any issues are found during the calculation, the program
will populate an ASCII file, _CycDBErrLog.txt with the results.
Verify that cycle times from sources are correctly populated for each destination. We only have
one period and phase, so there should be at least one entry for each source node. Note the
stockpile reclaim cycle time as well.

Analysis of Haulage Results | 23

c 2017 Hexagon Mining

Create a Customized PivotChart

Using the Cycle Times section, customize a pivot table and chart. Upon entering this panel for the first time, it
will immediately run cycle times. Be patient while it finishes.

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

24 | Analysis of Haulage Results

 Generating Cycle Times with Haulage

NOTES

Analysis of Haulage Results | 25

c 2017 Hexagon Mining

Conclusion & Future Training

We hope you will be able to use the tools covered during this MineSight software training course to
improve productivity at your mine. As you apply the concepts you have learned, please phone or
email us with questions. Our contact information is listed on the inside cover of this book and on our
website, www.hexagonmining.com. The website also gives you access to our download/upload
page, the latest updates to our software, news, seminar papers and newsletter articles about our
software.

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.

Generating Cycle Times with Haulage. V4. October 13, 2017

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).

26 | Conclusion & Future Training

Generating Cycle Times with Haulage

Conclusion & Future Training | 27