v 1.1.
Note: Macros must be enabled for this sheet to work!
Method
Open Pit
Block Caving
Sublevel Stoping
Sublevel Caving
Longwall
Room and Pillar
Shrinkage Stoping
Cut and Fill
Top Slicing
Square Set
Shape
Input Data
Final Results
1
2
3
4
5
6
7
8
9
10
Plunge
Thickness
Grades
Depth
RMR Ore RMR HW
<< Click on the 'Input Data' button to begin
UBC Mining Method Selector
Mining Method Selector Algorithm developed by:
Miller-Tait, L., Pakalnis, R. and Poulin, R., (1995), UBC Mining Method
4th Int'l. Symp. on Mine Planning & Equipment Selection, Calgary, 31 O
Excel and Visual Basic Implementation by:
Jeff Breadner (1999). (jbreadner@[Link])
Original Idea:
Nicholas, D. (1992) SME Mining Engineering Handbook, 2nd Edition, Vo
If you have any comments or questions about the excel implementation of
please contact Jeff Breadner at jbreadner@[Link]
RMR FW RSS Ore RSS HW RMR FW
ng Method Selector
995), UBC Mining Method Selection,
nt Selection, Calgary, 31 Oct-3 Nov, 1995, pp. 163-168.
Handbook, 2nd Edition, Volume 2, pg. 2091-2108.
about the excel implementation of this program,
ner at jbreadner@[Link]
Total
0
0
0
0
0
0
0
0
0
0
DO NOT MODIFY THESE DATA!
This information is core to this mining selection process!
Shape
Method
Equidimensional Platy/Tabular Irregular Flat
Open Pit
4
2
3
Block Caving
4
2
0
Sublevel Stoping
3
4
1
Sublevel Caving
3
4
1
Longwall
-49
4
-49
Room and Pillar
0
4
2
Shrinkage Stoping
0
4
2
Cut and Fill
1
4
4
Top Slicing
1
2
0
Square Set
0
1
4
3
3
2
1
4
4
-49
1
4
2
Plunge
Moderate Steep
V. Narrow
3
1
1
2
4
-49
1
4
-10
1
4
-49
0
-49
4
0
-49
4
0
4
4
3
4
3
2
0
1
3
2
4
Thickne
Narrow
2
-49
1
-49
3
3
4
4
1
3
Thickness
Intermediate Thick
V. Thick Low
3
4
4
0
3
4
3
4
3
0
4
4
0
-49
-49
1
-49
-49
0
-49
-49
4
1
0
0
2
1
2
0
0
3
3
4
3
4
4
3
2
2
0
Grades
Moderate High
3
2
4
2
1
2
2
3
1
1
Depth
100-600
<100m
2
2
3
2
0
0
2
4
1
3
4
2
3
3
2
3
3
2
2
1
>600m
0
3
4
2
2
3
3
3
1
1
-49
3
2
2
3
2
2
4
1
2
V. Weak
3
4
1
3
6
-49
0
0
3
4
Weak
3
3
3
4
6
0
1
1
2
4
RMR Ore
Moderate Strong
3
2
4
3
4
3
3
2
1
1
3
0
4
1
2
5
3
3
1
0
V. Strong
3
-49
4
0
2
6
3
3
0
0
RMR Hanging Wall
V. Weak Weak
Moderate Strong
2
3
4
3
3
3
-49
0
3
4
4
3
6
5
4
-49
0
3
0
0
2
3
5
4
0
0
2
4
4
1
4
2
4
2
3
5
4
3
3
0
V. Strong
4
2
4
2
3
6
4
3
3
0
V. Weak
Weak
2
3
0
1
0
0
0
3
0
3
RMR Footwall
Moderate Strong
3
4
3
3
0
2
2
3
0
0
0
0
0
2
3
2
0
1
1
0
4
2
3
3
0
0
3
2
2
0
V. Strong V. Weak
4
2
3
3
0
0
3
2
2
0
4
4
0
2
6
0
0
0
3
4
RSS Ore
Weak
Moderate Strong
3
3
2
1
2
4
3
3
5
2
0
3
1
3
1
3
2
1
3
1
RSS Hang
V. Weak
3
0
4
2
1
6
4
3
0
0
3
4
0
4
6
0
0
3
3
4
RSS Hanging Wall
Weak
Moderate Strong
3
4
3
2
1
4
3
2
5
2
0
2
1
3
5
4
2
2
2
1
V. Weak
4
0
5
1
2
6
4
2
2
0
3
4
0
1
0
0
0
1
2
3
RSS Footwall
Weak
Moderate Strong
3
4
3
2
1
3
2
2
0
0
0
0
2
3
3
3
2
1
2
0
4
1
3
2
0
0
3
2
1
0