Excel - Kuz-ram Model

Before opening Excel, you must understand the two mathematical pillars of the model.

✅

Add formulas:

Create a dedicated area for "User Inputs." This prevents users from accidentally overwriting formulas. Use data validation to restrict inputs (e.g., ensuring Rock Factor $A$ is between 0.8 and 22). kuz-ram model excel

: This yields k50 in cm if Q in kg and q in kg/tonne. Convert to mm by multiplying by 10. Before opening Excel, you must understand the two

For decades, the industry standard for predicting this fragmentation has been the Kuz-Ram model. While sophisticated commercial software exists, the flexibility, accessibility, and transparency of Microsoft Excel make it the preferred tool for engineers worldwide to implement this model. : This yields k50 in cm if Q in kg and q in kg/tonne

In the mining and quarrying industries, predicting rock fragmentation is critical. The size distribution of blasted rock directly impacts everything from loading and hauling efficiency to crushing and grinding costs. Among the dozens of empirical models available, the (a hybrid of the Kuznetsov equation and the Rosin-Rammler distribution) has emerged as the industry standard for estimating fragmentation from bench blasts.