Revision as of 09:54, 4 December 2024 by imported>Scott.Munro
Description
This article describes the Kuznetsov–Cunningham–Ouchterlony (KCO) model (Ouchterlony, 2005) for predicting rock fragmentation by blasting.[1]
Model theory
This content is available to registered users. Please log in to view.
|
Excel
The KCO blasting model may be invoked from the Excel formula bar with the following function call:
=mdUnit_Blasting_KCO(Parameters as Range, Size as Range)
Invoking the function with no arguments will print Help text associated with the model, including a link to this page.
Inputs
The required inputs are defined below in matrix notation with elements corresponding to cells in Excel row () x column () format:
Results
The results are displayed in Excel as an array corresponding to the matrix notation below:
Example
The images below show the selection of input arrays and output results in the Excel interface.
Figure 1. Example showing the selection of the Parameters (blue frame) array in Excel.
|
Figure 2. Example showing the selection of the Size (red frame) array in Excel.
|
Figure 3. Example showing the selection of the Results (light blue frame) array in Excel.
|
See also
References
- ↑ Ouchterlony, F., 2005. The Swebrec© function: linking fragmentation by blasting and crushing. Mining Technology, 114(1), pp.29-44.