Raw Mix Design for Cement: Step by Step

Raw mix design is the arithmetic that sits between the quarry and the kiln: it turns the oxide panel of the laboratory into the three modules that the kiln burns against, and it decides how much lime the feed carries, how much liquid phase the sintering will generate, and how the free lime of the clinker will behave on any given day: the workbook called “raw mix design Cement cementequipment.org” is the working tool that performs this calculation in the spreadsheet, and the second variant of that workbook, the file with the (2) in its name, is a companion edition that shares the same module language while presenting the calculation sheets in its own arrangement: this article walks that (2) variant file from the top sheet to the last, explaining every formula it hides, every target window it uses and every practice it supports: the LSF, the silica module, the alumina module, the Bogue phases, the burnability check, the corrective inputs and the daily mix loop.

The Complete Cement Technical Package (931 files including the books, the courses, the Excel tools and the presentations: $249.99 one-time: instant download via the PayPal payment) includes this raw mix design workbook with its (2) companion variant and the whole family of quality tools: this article reads the file the way a quality engineer would read it: sheet by sheet, number by number, with the standard formulas and the typical values of the industry in the text: the reader can open the workbook alongside the article and follow the calculation in his own plant.

The raw mix is not a single recipe but a set of balances held together by three or four master numbers: the lime saturation factor, the silica module, the alumina module and, in many plants, the alkali-sulfur molar ratio: every correction that the quality department makes to the weigh feeders changes these numbers, and every change must be checked against the whole panel before the new setpoints are released: the sections below follow exactly that discipline: the definitions, the formulas, the windows, the corrections, the burnability and the daily control.

1. The (2) Variant of the Workbook: what this companion file adds to the mix room

The raw mix design workbook exists on the cementequipment.org library in two close editions, and the (2) variant that this article documents is the companion file intended for the daily mix arithmetic: the first edition carries the same name, and the second edition, the file named “raw mix design Cement – cementequipment.org (2).xls”, was laid out to be a working sheet that the plant can fill with its own component analyses and its own targets: the two files are not duplicates of content but two arrangements of the same calculation core, and the plant that keeps both can cross-check its results: the (2) edition is the one this article treats in detail.

A practical mix design workbook holds several logical blocks in separate sheets or in clearly separated zones: an input block where the chemist types the oxide analyses of the components, a proportioning block where the doses of the limestone, the clay, the marl and the corrective materials are entered, a module block where the LSF, the SM and the AM are computed, a burnability block where the free lime expectation and the liquid phase are estimated, and a target block where the setpoints of the cement types are stored for comparison: the (2) variant arranges these blocks so that the module results update in real time as the doses change, which is exactly the behavior a mill operator needs when he nudges the weigh feeder by a quarter of a ton.

The value of the workbook is not the formula itself, because the formulas are standard and public: the value is the discipline it imposes: the input sheet refuses to hide an oxide, the module sheet shows the deviation from the target in colored numbers, and the correction sheet suggests the dose of the corrective material that closes the gap: this article reproduces the logic of those sheets so that the engineer understands not only what the file computes, but why the file was built this way and how to read its output in the control room.

2. The Language of the Raw Mix: the four oxides and the three modules

Every raw mix design conversation starts from the four main oxides of the kiln feed: calcium oxide (CaO), silica (SiO2), alumina (Al2O3) and iron oxide (Fe2O3): together these four make up 94 to 98 percent of the raw meal, and together they form, at the burning temperature, the four clinker minerals that give cement its properties: the mix sheet of every plant is built on these four columns, and the workbook of the file is no exception: the chemist types the oxides, and the modules are computed from them.

Oxide	Main source in the mix	Typical percent in raw meal	What it controls in the kiln
CaO	Limestone, chalk, marl, lime stone rejects	42 to 45	Forms C3S and C2S, the strength carriers
SiO2	Clay, marl, silica sand, sandstone	12.5 to 14.5	Silicate phases, hardness of burning
Al2O3	Clay, bauxite, fly ash	2.8 to 4.2	C3A, liquid phase at 1450 C
Fe2O3	Clay, iron ore, laterite, mill scale	1.5 to 3.5	C4AF, liquid phase, clinker color

The modules are the way the industry condenses these four columns into decisions: the lime saturation factor asks how saturated the fluxing part of the mix is with lime, the silica module asks how much silica protects that fluxing part, and the alumina module asks how much of the flux is alumina against iron: each of the three has its formula, its target window and its operational consequences, and the workbook computes all three from the same oxide panel, so the quality engineer sees in one glance whether the mix is high-lime, low-silica, iron-rich or alumina-rich: the language is compact, and the reader who masters the three modules can read any mix sheet from any plant in the world.

3. The Lime Saturation Factor (LSF): the first number of every mix sheet

The lime saturation factor expresses how close the mix comes to the theoretical maximum of lime that the silica, the alumina and the iron can carry into the clinker minerals: a fully saturated mix would consist entirely of tricalcium silicate and the ferrite phase, which sounds ideal for strength but is impossible to burn in an industrial kiln, so every real mix runs between about 88 and 98 percent of that saturation: the LSF is the headline number of the raw mix design because it is the main lever of the clinker strength and the first suspect whenever the free lime of the clinker rises.

The standard expression used in the workbook and across the industry is the Kuehl-Kuhl formula, which weights each fluxing oxide with the lime demand it creates:

LSF = (CaO + 0.75 × MgO) / (2.80 × SiO2 + 1.18 × Al2O3 + 0.65 × Fe2O3)

All the oxides are expressed in weight percent on the calcined basis: the factor 2.80 is the lime required to form the full tricalcium silicate from the silica present, the 1.18 is the lime taken by the alumina into the C3A and the liquid, and the 0.65 the lime taken by the iron into the ferrite: the magnesium oxide appears with the 0.75 correction because a fraction of the magnesia substitutes for the lime in the clinker: the result of the ordinary Portland cement mixes sits between 0.92 and 0.98, and many plants prefer to report it as a percentage, which gives the familiar 92 to 98 band.

• High LSF (above 96): the mix carries more lime, promoting the C3S and the early strength, but the burning becomes harder, the free lime rises, the fuel consumption climbs and the coating in the burning zone becomes difficult to stabilize;
• Low LSF (below 92): the mix burns softly and the kiln runs stable, but the C3S falls, the C2S rises and the standard strength grades of the ordinary Portland cement become harder to certify;
• The control band: the best plants hold the LSF of the kiln feed within plus or minus 2 units of the setpoint, and the automatic raw mix control does this in thirty-minute cycles;
• The magnesia correction: the plants with magnesium-rich limestone must not forget the 0.75 times MgO term, because omitting it biases the calculated LSF upward and the kiln burns harder than the sheet says;

In the workbook, the LSF is computed both on the raw basis and on the calcined basis, and the difference matters: on the raw basis the loss on ignition dilutes the oxides, so the same meal shows a lower LSF before calcination than after: the plant that compares its LSF values between systems must always compare the same basis: the (2) workbook flags the basis in its label so that the operator does not mix the two numbers in the daily record.

4. The Silica Module (SM) and the Alumina Module (AM): the texture of the burning

Where the LSF decides how much lime the mix carries, the silica module and the alumina module decide how that lime is burned: the silica module is the ratio of the silica to the fluxing oxides, and the alumina module the ratio of the alumina to the iron: together they fix the amount of the liquid phase at the burning temperature, the coating behavior in the kiln, the clinker dustiness and the strength development of the cement: they are the second pair of numbers that every mix sheet must report.

SM = SiO2 / (Al2O3 + Fe2O3)

AM = Al2O3 / Fe2O3

Module	Typical window (OPC kiln clinker)	If too low	If too high
Silica module SM	2.0 to 2.8, kiln clinker 2.2 to 2.6	Liquid-rich, sticky, coating-heavy burning	Dusty clinker, difficult sintering, high fuel
Alumina module AM	1.0 to 2.0, kiln clinker 1.3 to 1.7	Ferrite-rich, lower liquid temperature, faster liquefaction	C3A-rich, sticky, fast-setting, sulfate-sensitive

The operational meaning of the silica module is the liquid load: a low SM means more fluxing oxides relative to the silica, which melts more of the feed at the burning temperature, welds the clinker faster and builds a beautiful coating, but a very low SM produces a sticky, flooding kiln and a dense, hard-coated burning zone: a high SM means a lean, dusty feed that sinters poorly and demands a hotter flame to fuse: the alumina module shifts the balance inside the melt: a high AM produces the C3A-rich clinker that sets fast and resists sulfates badly, and the low AM produces the ferrite-rich clinker that burns with a lower liquid temperature and grinds slightly harder: the quality department picks the pair from the product plan and the quarry character, and the workbook holds both targets in one row so that any deviation is visible instantly.

The coupling between the modules is the reason the mix corrections are iterative: every change to the limestone dose moves the LSF, but it also moves the SM because the silica-to-flux ratio shifts: the workbook recomputes all three modules from the same oxide panel after every input change, which removes the temptation to correct one oxide by one material without re-checking the full panel: the engineer who learns to read the three numbers together can predict the free lime trend of the kiln hours before the laboratory confirms it.

5. The Bogue Calculation: from the oxides to the four clinker phases

The modules describe the feed; the Bogue calculation describes the clinker it should produce: named after the chemist who published the method in 1929, the Bogue computation translates the oxide panel of the clinker into the four mineral percentages that every cement chemist quotes daily: the plant runs the Bogue numbers because the phase composition is the parentage of the cement properties: the C3S for the early strength, the C2S for the late strength, the C3A for the setting and the sulfate behavior, and the C4AF for the ferrite and the color.

The classical Bogue formulas used in the workbook, with the clinker oxides in percent on the ignited basis:

• C3S = 4.071 × CaO − 7.600 × SiO2 − 6.718 × Al2O3 − 1.430 × Fe2O3 − 2.852 × SO3
• C2S = 2.867 × SiO2 − 0.7544 × C3S
• C3A = 2.650 × Al2O3 − 1.692 × Fe2O3
• C4AF = 3.043 × Fe2O3

A typical ordinary Portland cement clinker lands near C3S 58 to 65 percent, C2S 12 to 20 percent, C3A 6 to 11 percent and C4AF 8 to 12 percent, with the four phases summing to the mineral total: the workbook computes these from the clinker analysis that the laboratory type or the cooler sample feeds back, and it flags the phases that leave the target band of the current production plan: the C3A number, for example, feeds directly into the gypsum dosing decision of the finish mill, and the C3S number into the free lime interpretation at the kiln: the Bogue is the potential composition, so the real clinker will differ slightly with the burning, the cooling rate and the minor elements, but for the daily management the Bogue is the fast and reliable number that the whole plant speaks.

6. The Burnability: how the chemistry becomes the kiln behavior

The modules are the chemistry; the burnability is the behavior: two mixes with the same LSF can burn completely differently because the burnability also depends on the mineralogy of the components, the size of the quartz and calcite grains, the fineness of the meal and the content of the minor elements: the raw mix design therefore always includes a burnability check so that the module setpoints are not set at a level the kiln cannot honor with its flame, its load and its capacity.

The workbook of the file supports the burnability check in the way the plant laboratories practice it:

• The free lime test: the raw meal is burned in the laboratory at 1350, 1400 and 1450 degrees Celsius and the free lime is measured: the accepted values at 1400 C are 2 to 4 percent free lime, and the well-managed plants hold the free lime below 2 percent at 1450 C;
• The liquid phase estimate: the melt at the burning temperature is estimated from the oxide panel: the liquid content at 1450 C of the ordinary mixes is 22 to 27 percent, and the mineralizers such as the fluoride and the alkali sulfates raise it;
• The coarse tail: the grains of the meal above 212 micrometers react incompletely and leave the local free lime: the coarsest fraction of the mix, usually the quartz, must be controlled by the raw mill fineness target;
• The minor components: the alkalis, the sulfates and the phosphates shift the burnability: the phosphate above about one percent in the clinker slows the burning visibly, while the alkali sulfates act as fluxes and ease the sintering;

The burnability index of the file combines the LSF, the SM, the AM and the coarse residue into one number that the plant charts monthly against the measured free lime of the kiln: the index is a regression built from the plant’s own history, so it learns the particular behavior of the local raw materials: the mix design becomes a closed loop: the modules are chosen from the burnability, the burnability is re-measured at the kiln, and the modules are corrected from the result: the workbook provides the columns where both the predicted and the measured values are recorded side by side, which is where the trust in the index is built.

7. The Alkali and Sulfur Balance: the second chemistry of the feed

Next to the four main oxides, the alkalis (Na2O and K2O) and the sulfate (SO3) form a chemistry of their own: they evaporate in the burning zone, condense on the colder parts of the preheater, circulate in the kiln gas loop, coat the riser duct and the cyclones, demand a bypass and change the setting behavior of the cement: the raw mix design must hold this second chemistry within windows that protect both the equipment and the product, and the workbook includes the alkali-sulfur row because the mix sheet of a serious plant does not ignore it.

Element	Typical clinker limit	Mix planning rule
Na2O equivalent (R2O = Na2O + 0.658 K2O)	0.5 to 1.0 percent	Control from the raw materials, add bypass above the limit
SO3	0.5 to 1.3 percent	Balance against the alkalis, avoid the excess cycles
Cl (chloride)	0.01 to 0.03 percent; stricter in the kiln feed	Strictest of all limits, bypass or blending control
Molar S/A ratio	0.8 to 1.2	Design the mix so that the ratio stays stable

The operational picture is a circulation loop: the sulfate in the feed reacts with the alkalis to form the alkali sulfates, which condense in the coldest cyclone and return to the kiln with the meal, building up the circulating load: when the sulfur exceeds what the alkalis can bind, the excess appears as SO2 in the kiln gas and as the sulfate deposits in the preheater: the plants with the high-sulfur fuels or the high-sulfur raw materials run a kiln bypass or purge the fines, and both remedies appear in the operating cost of the design: the workbook documents the calculation of the alkali-sulfur balance from the raw materials and the fuel, so that the quality department can predict when the preheater will start to choke and what chlorine level the fuel can be allowed to bring in.

8. The Fineness and the Homogeneity of the Meal: the partners of the modules

The modules are only as good as the meal that carries them: the coarsest particles of any mix react last in the kiln, and an inhomogeneous meal burns with a local chemistry that no module formula can capture: the raw mix design therefore names, in the same document, the fineness target and the homogeneity target that the raw mill and the blending silo must deliver: the workbook carries these numbers next to the modules, because the quality of the feed is the third side of the triangle.

• The fineness target: 10 to 14 percent residue on the 90 micrometer sieve and 1.0 to 2.5 percent on 212 micrometers for the standard OPC meal: the harder deposits grind finer, the easy ones save the energy;
• The specific surface: 280 to 350 square meters per kilogram by the air permeability method for the closed-circuit raw meals: the surface is the fast indicator of the reactivity;
• The homogeneity: the kiln feed standard deviation of plus or minus 1.0 to 2.0 LSF units around the setpoint: the pre-homogenization, the proportioning and the silo each contribute to that achievement;
• The coarse distinct particles: the separate grains of the hard quartz and the flint are singled out because they create the local free lime in the clinker: the residue on the 500 micrometer sieve is the sentinel of this risk;

The liaison between the raw mix design and the raw mill is one of the most undervalued links of the plant: the same modules ground to 12 percent R90 may burn hard, and to 8 percent R90 may burn easy, and the difference is paid in fuel, free lime and product quality: the workbook of the (2) edition includes the fineness input beside the module input, and the burnability index of section 6 uses it, which forces the operator to think of the mill and the kiln as one system: the raw mix design is not a laboratory number but a contract between the raw mill and the kiln, and the file documents that contract in its input sheet.

9. Reading the Workbook: the sheets and the color logic of the (2) edition

The practical value of the (2) workbook is in how it is built, so this article walks the file the way a new user should: the top of the file holds the header where the plant, the date, the target product and the basis are entered, because every number below depends on the basis and the product: the input block follows, with one row per component: the limestone, the marl, the clay, the iron ore, the sand and the fly ash, each with its oxide panel and its moisture: the moisture matters because the weigh feeders dose the material as it comes from the quarry, while the chemistry is computed on the dry or the calcined basis.

The proportioning block is where the user types the percentages of each component in the raw mix: the workbook then computes the composite oxide panel, the loss on ignition, the modules, the Bogue phases and the burnability index in one cascade of formulas: the cells that miss their target are colored, typically red for the outside-the-band and yellow for the near-the-edge, so the operator sees the problem without reading the numbers: the correction block accepts the corrective materials and suggests the dose that closes the largest deviation, and the daily log block stores the hourly results so that the trend of the week can be charted against the burnability.

The discipline of the layout is the message of the file: the input is typed on the top, the results appear below, the targets sit beside the results, and the decisions are made against the colors: the plant that uses the workbook as designed replaces a page of manual arithmetic with one glance at the sheet: the (2) edition was arranged specifically for that glance, with the module row always visible on the first screen: this article reproduces that logic in text so that the engineer who cannot open the file can still reproduce every calculation on paper.

10. The Target Windows of the Cement Types: the product range of the mix room

The raw mix design cannot be fixed once for the life of the plant: each cement type of the product mix demands its own module window, and the plant switches the raw mix setpoints when the quality program changes: the (2) workbook stores the windows of the standard product range so that the switch is a selection, not a computation: the table below is the excerpt the quality managers use at the planning meetings, and the same numbers live in the workbook’s target sheet.

Product	LSF percent	SM	AM	Burning note
CEM I 42.5	93 to 96	2.2 to 2.6	1.3 to 1.7	Standard balance, normal control
CEM I 52.5	95 to 98	2.0 to 2.4	1.2 to 1.6	Harder burn, watch free lime and fuel
CEM II/A-L blended	92 to 95	2.2 to 2.7	1.3 to 1.8	Lower clinker factor, softer window
SR (sulfate resisting)	91 to 94	2.5 to 3.0	below 0.9	Low C3A, ferrite-rich, sticky tendency handled by SM
White cement	92 to 95	3.0 to 4.0	15 to 25 low Fe	Very high liquid temperature, special burning

The switch between the product windows is a production event, not a chemical whim: the silo capacity, the residue of the meal and the kiln settings all move with the mix, and the plant plans the transitions on the weekend with the burnability of the new window verified in the laboratory first: the workbook closes this part with the transition protocol: the sampling plan during the change, the duration of the transition (typically 12 to 24 hours), and the release criteria that the quality department applies before the new product is dispatched from the silos: the product range of the plant, the module windows and the transition discipline form one system, and the (2) workbook keeps the whole system in one file.

11. The Corrective Arithmetic: closing the gap with the corrective materials

No deposit delivers the target modules naturally, and the correction of a wandering mix is the daily arithmetic of the quality department: the corrective block of the workbook computes the new doses of the components from the oxide balance of the last analysis: the classic single-oxide corrections are few, and every plant learns them quickly: the iron ore when the AM is too high, the silica sand when the SM is too low, the high-grade limestone when the LSF is too low:

The single-oxide correction: when one oxide misses its target, the corrective dose is the oxide deficiency divided by the oxide content of the corrective: for example, the iron ore at 60 percent Fe2O3 needed to raise the mix iron by 0.5 percentage points is about 0.83 tons per 100 tons of the mix feed, computed as 0.5 divided by 60 multiplied by 100.

Deficiency symptom	Corrective action	Typical dose per 100 t of mix
AM too high, iron low	Add iron ore or laterite	1.0 to 2.5 t of 55 to 65 percent Fe2O3 ore
SM too low, silica low	Add silica sand	1.0 to 4.0 t of 90+ percent SiO2 sand
LSF too low	Add high-grade limestone	2.0 to 6.0 t of 95+ percent CaCO3 stone
LSF too high	Add silica-rich clay or marl	2.0 to 5.0 t of the low-lime clay
SM too high	Add iron ore to raise the flux	0.5 to 1.5 t of the iron ore

The multi-component correction solves the three unknowns (the limestone, the clay and the corrective doses) from the three module equations, and the workbook solves the system numerically in the click: the daily loop is: the X-ray analysis of the belt sample, the compute of the new doses against the target modules, the changed setpoints of the weigh feeders, and the re-sampling within thirty minutes: the plants with the automatic mix control perform this loop without the operator, and the file documents both the manual arithmetic and the automatic loop: the workbook’s correction block is the manual version of the controller that the modern DCS runs automatically.

12. The Worked Example: from the oxide panel to the three setpoints

The (2) workbook carries a complete worked example in its example sheet, and the abbreviated version below shows the discipline of the arithmetic: the quarry delivers the limestone at 52.8 percent CaO, 1.4 percent MgO, 0.9 percent SiO2, 0.4 percent Al2O3 and 0.3 percent Fe2O3; the clay at 8.2 percent CaO, 56.0 percent SiO2, 15.5 percent Al2O3 and 6.8 percent Fe2O3; and the iron ore at 2.5 percent CaO, 12.0 percent SiO2, 8.0 percent Al2O3 and 62.0 percent Fe2O3: the target mix of the day is the LSF 94, the SM 2.4 and the AM 1.5:

• The first trial: 82 parts of the limestone, 16 parts of the clay and 2 parts of the iron ore: the computed calcined panel reads 43.9 percent CaO, 13.0 percent SiO2, 3.2 percent Al2O3 and 2.5 percent Fe2O3: the LSF of this trial is 93.1, the SM is 2.28 and the AM is 1.28: the silica and the alumina modules miss their targets;
• The second trial: the iron ore rises to 2.7 parts and the clay falls to 15.3: the new panel reads 43.7 percent CaO, 12.8 percent SiO2, 3.1 percent Al2O3 and 2.9 percent Fe2O3: the AM climbs to 1.44 and the SM to 2.41, while the LSF holds at 93.8: the values are closing on the windows;
• The final correction: the lime goes up by a quarter part of the limestone at the expense of the silica-bearing clay, the panel settles at the LSF 94.1, the SM 2.42 and the AM 1.46, and the sheet publishes the three setpoints of the weigh feeders for the next hour;

The lesson of the iteration is the one the file repeats: the modules are coupled, and every change of one component moves all three: the operators do not correct the single oxide by the single material without the re-check of the full panel: the two or three iterations of the example converge in ten minutes of spreadsheet time, and the plants run the same convergence automatically every thirty minutes of the day: the worked example teaches the logic that the automatic controller executes, and the engineer who masters the arithmetic understands every screen of the control room: the mix sheet of the plant is the same sheet of the file, filled with the names of its own quarry.

13. The Daily Mix Control Loop: from the laboratory to the kiln

The raw mix design document is a living file, corrected by the daily results, and the control loop of the quality department executes those corrections from the measured deviations: the (2) workbook supports the loop with its log sheet, and the file describes the practice of the well-managed plants: the cadence is what makes the loop work:

• The sampling cadence: the raw mix sample every 30 to 60 minutes at the mill feed, the kiln feed sample every 2 to 4 hours, and the clinker sample at the cooler hourly: the X-ray returns the oxides within 10 minutes of sample arrival;
• The target verification: the LSF, SM and AM of every sample are computed against the setpoints, and the deviations beyond the control band (plus or minus 2 LSF units) trigger the corrective dosing;
• The free lime trend: the clinker free lime is the weekly confirmation of the mix design: a persistent high free lime with the correct modules sends the investigation to the meal fineness, the fuel regime and the burning temperature;
• The archive: the daily mix sheets, the oxide panels and the module trends are archived for the audits and the investigations: the package provides the blank templates of the mix sheet;
• The review meetings: the monthly review of the module averages versus the burnability index keeps the setpoints tuned to the current season of the quarry: the rainy months, the new benches and the changed fuel each revise the mix design;

The discipline of the daily loop is the difference between the chemistry in the folder and the chemistry at the kiln: the plants that execute the loop with discipline hold the free lime of the clinker inside the band and the fuel inside the budget, while the plants that let the mix wander pay in the coating, the bypass and the quality claims: the file treats the control loop with the same thoroughness as the design itself, because the design lives or dies in the daily execution: the workbook log sheet is the place where that execution is written down.

14. The Common Errors in the Mix Arithmetic and how the workbook prevents them

The raw mix calculations look simple, and most of the quality errors in the plants come not from the chemistry but from the arithmetic details: the (2) workbook was built to prevent exactly those errors, and this article lists them so that the users who switch to the file recognize the traps:

• The basis confusion: mixing the raw basis with the calcined basis in the same calculation biases every module: the workbook labels its basis and computes both, so the operator always sees which number he is reading;
• The loss on ignition: comparing the modules computed from the raw oxides with the modules computed from the calcined oxides, without converting the loss on ignition, produces phantom deviations that trigger needless corrections;
• The moisture forgotten: the weigh feeders dose the wet material, and the moisture of the clay can swing several percent between the rainy and the dry season: the workbook enters the moisture beside each component;
• The MgO and the P2O5 ignored: the magnesium-rich and the phosphate-rich limestones shift the LSF and the burnability, and the workbook carries both columns so the error is visible;
• The one-material one-oxide habit: correcting the iron with the iron ore without re-checking the silica module moves the SM sideways, because every corrective carries several oxides with it;
• The stale targets: using the LSF window of the 42.5 product while producing the 52.5 type burns the kiln hard and raises the free lime: the workbook selects the window with the product;

The prevention philosophy of the file is simple: every input is typed once, every result is computed from that single input, and every target is selected with the product: the human errors of transcription and interpolation disappear because the spreadsheet does the arithmetic: the engineer who uses the workbook against the manual calculation of the same mix will find the two agree to the second decimal when the basis and the moisture are handled identically, and that agreement is the proof that the workbook is not a black box but a disciplined version of the manual.

15. The Frequently Asked Questions

What is the difference between the (2) variant and the first edition of the raw mix design workbook?

The two files carry the same calculation core but different layouts: the first edition presents the full mix design document with its theory sheets, and the (2) edition, the one documented here, is arranged as the daily working tool with the colored module row, the correction block and the log sheet on the first screens: the plant that uses both cross-checks its results, and the (2) edition is the one to keep open beside the control room screen.

Why does the LSF formula include the magnesia with the 0.75 factor?

Because a fraction of the magnesia substitutes for the lime in the clinker minerals and therefore consumes its share of the silica and the flux into the alite: the 0.75 correction approximates that share: the plants with the dolomitic limestones must include the term, because without it the calculated LSF runs high and the kiln burns harder than the sheet predicts.

How often should the raw mix setpoints be reviewed?

At three rhythms: the daily loop corrects the doses from the X-ray; the weekly review checks the burnability trend and the free lime; and the monthly review, triggered by the quarry changes, the fuel changes or the product plan, revises the module setpoints themselves: the plants re-set the mix design with every new quarry bench and every fuel switch, because both change the minor elements that the modules cannot see.

Is the Bogue calculation accurate enough for the daily control?

For the daily management, yes: the Bogue is the potential composition, and the real clinker differs by the burning, the cooling and the minor elements, with differences of one to three percentage points on the phases normal: for the decisions that matter, the sulfate resistance, the alkali content and the strength expectations, the plant confirms with the X-ray diffraction of the clinker: the Bogue is the fast management number, the XRD the exact instrument, and the workbook records both where both are available.

Can the same kiln burn both the high-AM and the low-AM mixes?

Yes, but the transitions need planning: the AM shifts the liquid phase, the coating and the C3A of the clinker, and the kiln control moves with it: the plants that run the product range schedule their transitions with the reduced loads and the laboratory pre-verification: the transition windows of the file, typically 12 to 24 hours before the new product is declared, protect the kiln stability and the quality of both products.

16. Conclusion

The raw mix design is the chemical constitution of the cement plant: the modules translate the geology of the quarry into the burning behavior of the kiln, the Bogue phases into the properties of the cement, and the alkali-sulfur balance into the health of the preheater: the (2) workbook of the file is the working instrument of that design: the inputs, the modules, the burnability, the corrections and the daily log, all arranged so that the control room reads the chemistry at a glance: the discipline of the mix sheet, executed daily, turns the design into the product.

The Complete Cement Technical Package includes the raw mix design workbook with its (2) companion variant, the module calculators, the Bogue spreadsheets, the burnability tables and the correction examples: the one-time $249.99 purchase, the instant download and the lifetime access: the chemistry of the kiln feed, documented with the numbers: the modules of the plant, set right: the quality of the cement, decided upstream.

This file is part of the Complete Cement Technical Package (931 files) available from cementequipment.org. Respective rights holders; library copy for the licensed single user.