Title: The planning of todays mines is becoming an incredibly complex task'
1Introduction
2Act I
3The planning of todays mines is becoming
increasingly complex
- While mines are complex, planning software is
often very hard to use - Complex Operations Complex Software
- gt
- Costly Solutions
- Untimely Solutions
4With better software, complex problems will find
simple solutions
5Introducing GMC Mine Scheduler
The Concept
The Concept
A Primary Schedule, a Redirected
Schedule, and a Rehandled schedule
The Implementation
6Act II, Scene 1
7Excel is the best platform
- Most scheduling starts with Excel
- 95 of professionals are familiar with Excel
- Using Excel results in short learning curve
- Excel models are extensible
- Excel is low cost
8Excel is a stable platform, interfaces well, and
has many inbuilt features
- Microsoft Office provides drivers that you can
use to retrieve data from the following data
sources - Microsoft SQL Server OLAP Services
- Microsoft Access
- dBASE
- Microsoft FoxPro
- Microsoft Excel
- Oracle
- Paradox
- SQL Server
- Text file databases
- Third-party providers
File/Save As
- Technologies
- Vista, Longhorn, etc
- .COM, .Net
- Active X
Office Clipboard
XML
9In Excel, compiled COM code is from 30 to 50
times faster than VBA.
10ACT II, Scene 2
11 12GMC Scheduler identifies the basis of complex
scheduling problems
13GMC Mine Scheduler provides a simple solution to
the complex problem
14Act II, Scene 3
15Wizard 1 of 3 sets up the registers
16Wizard 2 of 3 is for data entry and network
definition
17Wizard 3 of 3 completes the setup of worksheets
for scheduling
18In GMC Mine Scheduler, problems are broken into
small components.
19Continuous feedback guides the user - Excess
quantity scheduled dialog
20Continuous feedback guides the user - Charts
are easy to setup and save
21Continuous feedback guides user- Show Quantity
Available button
22Continuous feedback guides the user - The
Decoupling Spreadsheet Part1
23Continuous feedback guides the user - The
Decoupling Spreadsheet Part 2
24Act III
25Modern open pits are often large, complex, and of
marginal economics
26GMC Mine Scheduler identifies the core problem,
and keeps it simple
27A recent project
- Nickel laterite.
- Lerches Grossmann software to optimise NPV.
- GMC Mine Scheduler to implement variable cut-off
grades. - GMC Mine Scheduler to smooth Si/Mg stockpiles by
blending. - Twenty six periods.
- Eighteen Categories of material.
- Eight minerals and physical specs.
- Two pits with eight pushbacks in each.
- Eighteen blending stockpiles plus a ROM
stockpile. - The GMC Mine Scheduler was found to be an
inexpensive, easy to use, powerful, and
transparent alternative to other packages based
on the linear/integer programming techniques.
28GMC Mine SchedulerSmall, fast, reliable User
friendly and powerful