Free Cement Raw Mix Design Excel Sheet for Multiple Materials
To use the free workbook, enter the actual raw-material names and representative laboratory oxide analyses, keeping every input on a consistent moisture and loss-on-ignition basis. The original worksheet places the lime saturation factor (LSF), silica ratio (SR) and alumina ratio (AR) targets in column G, rows 15–17; verify those cell labels and formulas in the downloaded version before editing.
To solve the raw mix, click on the Data tab at the top of the excel screen and choose Solver (in the Analysis group). Then click the Solve button in the window that pops up, followed by the OK button in the Solver Results pop-up.
Download Link
If you don’t know how to use Solver Function in Excel please click here
The free raw-mix spreadsheet linked above remains available independently of any paid package. Before using its results, check the input oxide analyses, moisture/LOI basis, Solver constraints and calculated LSF, silica modulus and alumina modulus against your plant laboratory data. Do not treat an illustrative spreadsheet result as an approved production recipe.
How to use the free raw-mix Excel sheet safely
This worksheet is intended to help calculate raw-material blending proportions for a chosen set of chemical targets. It is a calculation aid, not a substitute for laboratory results, plant-specific material limits or an approved raw-meal recipe.
- Prepare current analyses. Enter the raw materials actually available at the plant, with CaO, SiO2, Al2O3 and Fe2O3 values from representative samples. Check that all results use a consistent analytical basis; do not mix as-received moisture, dry-basis and ignited-basis figures without conversion.
- Set the chemistry targets. The original worksheet instructions identify column G, rows 15–17, for LSF, silica ratio (SR) and alumina ratio (AR) targets. Confirm the cell labels and formulas in your downloaded copy before changing them. LSF refers to lime saturation factor, not loss on ignition (LOI).
- Check the blend constraints. Review which cells represent material proportions, whether the total blend is constrained to 100%, whether negative proportions are excluded, and whether each source has a practical minimum or maximum feed share. The worksheet’s Solver model should reflect the materials and constraints at your site.
- Run and inspect Solver. In Excel, enable the Solver Add-in if it is not visible on the Data tab. Run Solver using the workbook’s configured objective, variable cells and constraints. Do not accept a result solely because Excel reports a solution: review the predicted chemistry, actual proportions, residual target deviations and any active constraints.
- Validate independently. Recalculate the blended oxide composition from the proposed proportions, compare against fresh laboratory analyses and account for fuel-ash contribution or other plant-specific corrections where applicable. Confirm the proposed blend against the site’s quality-control and production approval process before any feed change.
Common spreadsheet problems
| Observation | Check before acting |
|---|---|
| Solver is missing from Excel | Confirm the Solver Add-in is enabled in the installed Excel version; this is a software setup issue, not evidence of a raw-material problem. |
| No feasible blend is returned | Check analyses, formula references, proportion bounds and target compatibility. Available materials may not meet all targets simultaneously. |
| Calculated blend differs from laboratory results | Reconcile sampling time, moisture/LOI basis, input data, rounding, source variability and any contributions not represented in the sheet. |
| One raw material receives an impractical proportion | Check whether real feeder capacities, quarry supply and blend constraints are represented in Solver. |
For a separate free calculation option, use the raw-mix design calculator. For more background on oxide-based proportioning and worked blending methods, see Calculation of Raw Mix Composition. Both resources are separate from the optional paid toolkit.