5
levels. Haulage in the development phase will be conducted
with trucks, later switching to a conveyor belt system dur-
ing production. Ground support will be provided with rock
bolts and shotcrete.
In collaboration with the company, the calculation tool
for this mine was developed based on an initial mine plan
to support technical and economic planning. It has been
used to assist and refine planning over the past four years.
Numerous variant comparisons were conducted to identify
Table 2. Overview of the exemplary structure of the calculation tool with various spreadsheets for a mine with drilling and
blasting
Category: purpose Worksheet
General information: Information for users Informations
Notes on the visualization
Conversions
Sources
Input: Input by usersv Input of operating resources, prices and
assumptions for economic calculation
Input of technical, technological and
organizational parameters
Diagrams and table values
Geometry of the mine workings
Determination of development work ratios
Input Data Check
Definition of mining methods variants: Calculation of variants, partly input by
users
Variant selection
Technical equipment: Input of devices as well as calculations and visualization
of intermediate results
Technical equipment
Technology – Development: Calculations and visualization of intermediate
results of the processes for the development work
Development work: Drilling and blasting
Development work: Loading
Development work: Haulage
Development work: Support
Technology – Extraction: Calculations and visualization of intermediate results
of the processes for the extraction of the raw material
Extraction: Drilling and blasting
Extraction: Loading
Extraction: Hauling
Extraction: Support
Extraction: Crushing and dust removal
Technology – Backfill: Calculations and visualization of intermediate results of
the processes for the application of backfill
Determination of backfill performance
Backfill transport and stow
Further processes: Calculations and visualization of interim results for cross-
mine processes
e. g. supply and disposal of mine, roadway
construction, …
Ventilation
Auxiliary ventilation
Personnel
Safety and Rescue
Times and costs: Calculations and presentation of final results Cycle times and costs
Total Costs
Summary
Comparisons of variants: Carrying out variant comparisons, documentation of
inputs and results
Comparison of variants
levels. Haulage in the development phase will be conducted
with trucks, later switching to a conveyor belt system dur-
ing production. Ground support will be provided with rock
bolts and shotcrete.
In collaboration with the company, the calculation tool
for this mine was developed based on an initial mine plan
to support technical and economic planning. It has been
used to assist and refine planning over the past four years.
Numerous variant comparisons were conducted to identify
Table 2. Overview of the exemplary structure of the calculation tool with various spreadsheets for a mine with drilling and
blasting
Category: purpose Worksheet
General information: Information for users Informations
Notes on the visualization
Conversions
Sources
Input: Input by usersv Input of operating resources, prices and
assumptions for economic calculation
Input of technical, technological and
organizational parameters
Diagrams and table values
Geometry of the mine workings
Determination of development work ratios
Input Data Check
Definition of mining methods variants: Calculation of variants, partly input by
users
Variant selection
Technical equipment: Input of devices as well as calculations and visualization
of intermediate results
Technical equipment
Technology – Development: Calculations and visualization of intermediate
results of the processes for the development work
Development work: Drilling and blasting
Development work: Loading
Development work: Haulage
Development work: Support
Technology – Extraction: Calculations and visualization of intermediate results
of the processes for the extraction of the raw material
Extraction: Drilling and blasting
Extraction: Loading
Extraction: Hauling
Extraction: Support
Extraction: Crushing and dust removal
Technology – Backfill: Calculations and visualization of intermediate results of
the processes for the application of backfill
Determination of backfill performance
Backfill transport and stow
Further processes: Calculations and visualization of interim results for cross-
mine processes
e. g. supply and disposal of mine, roadway
construction, …
Ventilation
Auxiliary ventilation
Personnel
Safety and Rescue
Times and costs: Calculations and presentation of final results Cycle times and costs
Total Costs
Summary
Comparisons of variants: Carrying out variant comparisons, documentation of
inputs and results
Comparison of variants