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).
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. kuz-ram model excel
Commercial blast modeling software (JKSimBlast, Orica BlastSuite) costs thousands of dollars annually. Yet, provides 90% of the functionality for 0% of the cost. It is transparent, customizable, and can be calibrated to site-specific conditions. Create a dedicated area for "User Inputs
Before opening the spreadsheet, it is essential to understand the variables driving the model. If you are building a sheet, these are the equations you will be coding. It is transparent, customizable, and can be calibrated
Add a dropdown with relative strengths: