Formulase Mod: Complete Technical Guide

Formulase_Mod is the formula module of the cementequipment.org technical package (Formulase_Mod (1).xls, approximately 0.58 MB), and it holds what many engineers regard as the most valuable single asset in the whole 931-file library: the compiled mathematics of the industry in one auditable, ergonomic spreadsheet. Where the design workbooks apply individual calculations to specific problems, the formula module collects the master equations, defines every symbol, states every unit, and demonstrates every formula with a worked numeric example, so that it serves simultaneously as a teaching text, a reference manual, and a calculation engine. This article presents the module as a whole and then works through its contents discipline by discipline, because the formula module is organized exactly as the industry is organized. It opens with the unit conventions and conversion factors without which every other sheet is a trap, then presents the chemistry of the raw mix and clinker, the limestone saturation factor LSF, the silica modulus SM, the alumina modulus AM, and the Bogue phase calculation, then the thermal discipline of the heat balance with its higher and lower heating value framework and its complete inventory of input and output terms, then the gas handling mathematics of volumetric flow Q, the Euler number, and the collection efficiency cut-size model of the cyclones and separators, and finally the grinding mathematics of the ball charge, the charge weight equal to volume times bulk density times filling degree, plus the power and media relationships. Each formula is given both in symbols and in a worked number, exactly as the module computes it, so the reader can verify every step by hand and then open the file and reproduce each cell.

The Architecture of the Formula Module

The module is built on the library’s three-zone convention, input on the left, calculation in the middle, output on the right, applied to every sheet, so that a formula page reads like a laboratory notebook: assumptions in, transparent equation in the center, answer with units and a checksum to the right. The uniformity is deliberate; a user who has learned one sheet can read any other without losing time, and an auditor can walk from the kiln chemistry page to the cyclone page to the ball charge page without changing mental gear. The module also enforces the single-source-of-truth principle: the constants, the molecular masses, the specific heats, and the conversion factors live in one master constants sheet, and every other sheet references those cells, so a correction propagates through the whole package instead of hiding in a duplicated number.

The result is a reference that stays trustworthy across years because every dependency is visible and every constant is defended by its source comment, whether the source is a standard, a supplier’s data sheet, the literature of the industry’s major equipment vendors, or an internal plant measurement. This is the discipline the library teaches everywhere, and the formula module is its最 concentrated expression: a place where the entire knowledge base of the industry is compressed into equations that any engineer can inspect, verify, and extend with personal plant data.

Units, Dimensions, and the Conversion Discipline

Before any formula does its work, the unit system must be declared, because the formulas of this industry are meaningful only in consistent units and the module goes to visible lengths to prevent the classic conversion disasters. The master constants sheet holds the factors: 1 gigajoule equals 1000 megajoules equals 947.8 thousand British thermal units; 1 ton equals 1000 kilograms equals about 2205 pounds; 1 atmosphere equals 101.325 kilopascals; 1 bar equals 100 kilopascals; the specific gas constant of air near 287 Joules per kilogram per Kelvin; and the molecular masses of the oxides used in the chemistry sheets, silicon dioxide 60.09, calcium oxide 56.08, aluminum oxide 101.96, iron oxide 159.69, magnesium oxide 40.30, and sulfur trioxide 80.06. The thermal section adds the heat capacity of air as roughly 1.005 kilojoules per kilogram per Kelvin, and the latent heat of water near 2440 to 2500 kilojoules per kilogram at the conditions of interest, both of which appear again and again in the heat balance.

The module’s rule, stated on the master sheet, is that all thermal work is carried in megajoules and gigajoules, all mass in tons and kilograms, all volume and flow in cubic meters and cubic meters per second, all pressure in pascals and kilopascals, and all temperatures in degrees Celsius converted to Kelvin inside the formulas. Conversions happen only at the boundary, in the input cells, so that a technician importing a certificate in kilocalories enters the conversion once in the input column and the formula body never changes. This boundary-conversion convention is the single most effective guard against the unit slip that ruins real engineering calculations, and the module enforces it by locking the formula zone so only the clearly marked input cells are editable in normal use.

Raw Mix Chemistry: LSF, SM, and AM

The first pedagogical family of the module is the chemistry that guards the raw mix. The limestone saturation factor is the ratio of the lime actually in the mix to the lime theoretically required to saturate the silica, alumina, and iron. On the clinker basis, LSF equals CaO divided by the sum of 2.8 times SiO2, 1.18 times Al2O3, and 0.65 times Fe2O3, with the oxides in mass percent. The coefficients carry the stoichiometry: one part of silica combines with roughly 2.8 parts of lime to form the calcium silicates, one part of alumina with about 1.18 parts of lime in the aluminate, and one part of iron oxide with about 0.65 part of lime in the ferrite. A target of about 95 percent, with the practical window 92 to 98 percent, describes ordinary Portland cement clinker; higher values demand harder burning, and lower values yield under-lime clinkers prone to dusting and low strength.

The silica modulus, SM, is SiO2 divided by the sum of Al2O3 and Fe2O3, normally 2.0 to 3.0, and it reigns over the liquid phase and the burning-zone behavior: low values mean flux-rich mixes that burn easily but can coat or ball, high values mean stiffer mixes that need more heat and time. The alumina modulus, AM, is Al2O3 divided by Fe2O3, normally 1.0 to 2.5, steering between an aluminate-rich clinker and a ferrite-rich one and influencing the heat of hydration of the finished cement and the refractory compatibility of the charge. The module presents the three moduli as a group because they are decided as a group at the proportioning stage, and the worksheet lets the user enter a candidate proportion, see the resulting oxides, and watch the three moduli move together until the design window is struck.

The Bogue Phase Calculation

From the oxide analysis, the module computes the potential clinker phase composition with the Bogue equations, the classic back-calculation to the four principal minerals. The three calcium silicates and the aluminate and ferrite are computed from the clinker oxides after allowing for the minor constituents. In the standard form, the tricalcium silicate content is 4.071 times CaO minus 7.600 times SiO2 minus 6.718 times Al2O3 minus 1.430 times Fe2O3 minus 2.852 times SO3; the dicalcium silicate is 2.867 times SiO2 minus 0.754 times C3S; the tricalcium aluminate is 2.650 times Al2O3 minus 1.692 times Fe2O3; and the tetracalcium aluminoferrite is 3.043 times Fe2O3, with all quantities in weight percent. The module states the necessary caution prominently: the Bogue calculation assumes equilibrium crystallization of the pure phases and is therefore an estimate of the potential composition, not a measurement, and its accuracy degrades when the clinker contains significant foreign components such as magnesia, alkalis, or sulfate.

Despite the caveat, the Bogue phases remain the lingua franca of clinker evaluation: the tricalcium silicate drives early strength and is the target of the LSF, the dicalcium silicate grows strength later and moderates heat, the aluminate governs early stiffening and sulfate demand, and the ferrite is the low-temperature liquid-phase host. The module links the Bogue output to the raw mix sheet so that a new proportion displays its resulting phase balance instantly, and it links the phase balance onward to the predicted burnability and the heat of clinker formation, closing the chain from quarry analysis to thermal expectation that the heat balance sheet then prices.

Heat Balance Mathematics: HHV, LHV, and the Terms

The thermal family of the module is the heat balance, built on the heating value foundation. The higher heating value, HHV, includes the latent heat of condensation of the water vapor formed by the fuel’s hydrogen; the lower heating value, LHV, excludes it. The module writes the relationship in the form LHV equals HHV minus the latent heat of vaporization per kilogram of water, approximately 2440 kilojoules per kilogram at the relevant conditions, multiplied by the mass of water formed per kilogram of fuel, where that water mass is the sum of the fuel’s free moisture and the water produced by its hydrogen content. For a fuel with hydrogen fraction H and moisture fraction W, the water per kilogram of fuel is about 9 times H plus W, since each kilogram of hydrogen yields about 9 kilograms of water by combustion stoichiometry. The module carries the conversion visibly so that a fuel certificate quoted in HHV is converted to the LHV basis before it enters the kiln energy balance.

The full heat balance then enumerates inputs and outputs around the kiln system. Inputs: the chemical heat of the fuel at the LHV; the sensible heat of the kiln feed, its dry material and its water; the sensible heat of the combustion air, primary, secondary, tertiary, keeping track of the cooler-recovered preheat; and the sensible heat of any hot recovered streams. Outputs: the theoretical heat of clinker formation, about 1750 to 1800 kilojoules per kilogram of clinker; the sensible heat leaving in the clinker; the sensible heat of the exit gas and any by-pass gas; the latent heat of the raw meal moisture evaporated; the shell losses by convection and radiation around the kiln, preheater, and cooler, estimated by conventional surface-loss coefficients; the cooler exhaust losses; and the unaccounted balance that absorbs measurement error. The module presents the standard table and requires the rows to close to within a declared tolerance, and it computes the thermal efficiency as the theoretical formation heat divided by the total fuel heat supplied, the single most quoted performance number of the burning department.

Gas Handling: Volumetric Flow and the Euler Number

The gas and dust family brings the cyclone into the module. The design traffic is the volumetric flow Q, in cubic meters per second, and the inlet velocity is Q divided by the inlet area A. The pressure drop is captured by the Euler number, Eu, defined as Eu equals two times the pressure drop delta-P times the gas density rho, divided by the square of the inlet velocity v: Eu equals 2 delta-P rho over v squared. Rearranged, delta-P equals one half Eu rho v squared, and the module carries the practical Euler numbers of the common geometric families, between about 3 and 8, so the user can price any design’s fan without a test rig. The fan power then follows as the total pressure rise times Q divided by the fan and drive efficiencies, and the module converts that power into annual cost at the entered tariff, because the pressure drop is ultimately a money line.

The efficiency side of the same family is the cut-size model. The collection efficiency of a cyclone is anchored by the cut size, the diameter captured at 50 percent, estimated from the geometry and flow in the manner of the Lapple approach: the cut diameter dc is proportional to the square root of the quantity nine times the dynamic viscosity mu times the body diameter D times the inlet width b, divided by the product of the effective number of vortex turns N, the gas density rho-g, the particle density rho-p, and the inlet velocity v. The module states the proportionality, the working constant for the chosen family, and the grade-efficiency curve that rises steeply from the cut size to near-total collection at several times it, and it convolves that curve with the dust’s particle size distribution to give total mass efficiency. The units discipline appears again: viscosity in Pascal-seconds, density in kilograms per cubic meter, dimensions in meters, velocity in meters per second, so the cut size emerges in meters and is then reported in microns.

Grinding: The Ball Charge and Mill Power

The grinding family of the module is built around the charge weight relationship. The weight of the media in a mill compartment, W, equals the internal volume V of the compartment times the bulk density rho-b of the settled media times the filling degree f: W equals V times rho-b times f. The module explains the components with the care they deserve. The bulk density is not the solid density: for equal spheres the random packing void fraction is about 0.40, so steel balls of solid density 7.85 tons per cubic meter pack to about 4.7 tons per cubic meter in the ideal case, with 4.5 to 4.6 tons per cubic meter as the working figure in a real mill where mixed sizes raise packing and slumping lowers it. The void factor is the complement, the fraction of the charge volume that is empty between balls, about 0.40 for equal spheres and less for graded charges, and the module both defines it and shows it entering the bulk density calculation so that media users can adjust the constant for a declared media type.

From the charge the module derives the power: the mill absorbed power follows from the charge weight, the mill diameter, the speed relative to critical speed, and the filling, through the standard mill power relationships that the major suppliers publish and the library’s training decks reproduce, and the module compares predicted with measured power as a standing diagnostic. It then adds the ball sizing rules, the top size scaling with the cube root of the feed size and the material’s grindability, and the sphere geometry, the volume of a ball, pi times diameter cubed over six, the mass from the solid density, and the surface area, pi times diameter squared, so the grinding surface of any proposed grading is computed in the same page as its weight. The economic tail of the family is the media wear, expressed in grams per ton of cement, benchmarked 300 to 900 grams per ton for OPC grinding, and converted to annual currency so the module ends, like every family, in the language of the cost sheet.

Combustion and Stoichiometry

The module also carries the stoichiometry of combustion, which the heat balance cannot do without. For a fuel of known ultimate analysis, the mass of oxygen required for complete combustion follows from the carbon, hydrogen, and sulfur content, and the theoretical air is that oxygen mass divided by the oxygen mass fraction of air, about 0.232 by mass, giving the air-to-fuel ratio. From the same analysis the module computes the wet and dry flue gas volumes, the cubic meters per kilogram of fuel, using the gas densities at the chosen temperature and the ideal gas scale, and it separates the theoretical air from the excess air so the user can size the combustion and the off-gas handling. The excess air ratio, the actual-to-theoretical air ratio, is a directly controllable dial in the plant, and the module shows how it inflates the flue gas volume and the fan work, connecting the burner adjustment to the power bill and therefore back to the cost family, a loop that closes on the same workbook grid.

The combustion page also carries the flame temperature estimate, the adiabatic flame temperature computed from the fuel heat release and the heat capacity of the products, and the module flags where the simplified adiabatic estimate overstates the practical flame because of heat losses and dissociation, guiding the engineer to the design flame temperature the burner must produce. This is typical of the module’s personality: it gives the professional equation and the honest caveat together, so the formula never pretends to be more exact than the physics it summarizes.

A Table of the Module’s Master Equations

The following table collects the master equations in the order the module presents them, with their symbols and units, so a user can scan the whole discipline at a glance.

Family	Equation	Symbols & Units
Raw mix	LSF = CaO / (2.8 SiO2 + 1.18 Al2O3 + 0.65 Fe2O3)	Oxides in mass %, result in % or as ratio
Raw mix	SM = SiO2 / (Al2O3 + Fe2O3)	Dimensionless, 2.0–3.0 typical
Raw mix	AM = Al2O3 / Fe2O3	Dimensionless, 1.0–2.5 typical
Clinker	C3S = 4.071 CaO – 7.600 SiO2 – 6.718 Al2O3 – 1.430 Fe2O3 – 2.852 SO3	All in weight percent
Fuel	LHV = HHV – 2440 x (water per kg fuel)	kJ/kg; water from 9H + W
Heat balance	Inputs = outputs; efficiency = formation heat / fuel heat	kJ/kg clinker; %
Cyclone	Eu = 2 delta-P rho / v^2; delta-P = 0.5 Eu rho v^2	delta-P in Pa, rho in kg/m3, v in m/s
Cyclone	dc proportional to sqrt(9 mu D b / (N rho-g rho-p v))	dc in m then microns
Ball charge	W = V x rho-b x f	t, m3, t/m3, fraction
Ball size	dmax proportional to cube root of feed size	mm
Mill power	P from charge weight, diameter, speed, filling	kW

Each row of this table is a living cell in the module, with its own worked example, its range check, and its link to the constants sheet, and the table above is offered as the reader’s own index into the file.

Worked Numbers Straight From the Module

To demonstrate the module in operation, run a short chain of its own examples. Chemistry page: a clinker analysis of SiO2 21.5 percent, Al2O3 5.0 percent, Fe2O3 3.2 percent, CaO 65.5 percent, SO3 0.8 percent gives LSF equals 65.5 over the sum of 60.2 plus 5.90 plus 2.08, or 68.18, yielding 96.1 percent. The silica modulus is 21.5 over 8.2, or 2.62, and the alumina modulus 5.0 over 3.2, or 1.56. The Bogue page computes C3S as 4.071 times 65.5 minus 7.600 times 21.5 minus 6.718 times 5.0 minus 1.430 times 3.2 minus 2.852 times 0.8, which resolves to roughly 58 percent, and C2S to about 19 percent, a wholesome ordinary Portland clinker profile. Fuel page: a coal with HHV 30,500 kilojoules per kilogram, hydrogen 4.5 percent, and moisture 8 percent forms water of 9 times 0.045 plus 0.08, about 0.485 kilogram per kilogram, so the LHV is 30,500 minus 2440 times 0.485, about 29,320 kilojoules per kilogram, and the heat balance uses that LHV to convert a kiln demand of 3.4 gigajoules per ton of clinker into about 116 kilograms of coal per ton.

Cyclone page: for a stage handling 90 cubic meters per second through three cyclones, inlet velocity 20 meters per second, gas density 0.38 kilograms per cubic meter, and Euler number 5, the pressure drop is half of 5 times 0.38 times 400, about 380 Pascals, and the fan power on that flow is the rise times 90 divided by the efficiencies, a figure the page converts to annual currency at the entered tariff. Grinding page: a two-compartment mill with 40 and 33 cubic meters, filling degree 0.30, bulk density 4.55, gives a charge of 73 times 4.55 times 0.30, about 99.6 tons, and a media wear of 600 grams per ton on 2 million tons of cement is 1,200 tons of media a year, priced on the same page. Every value here is exactly the sort the module scatters through its cells, and the reader can reproduce each one with a calculator before opening the file, which is the strongest possible recommendation for the workbook’s clarity.

Quality Control and the Statistical Extension

The module does not stop at the deterministic equations; it extends into the statistics of control, because a formula that is not held against a target is only half an engineering statement. The quality sheets of the module carry the mean and standard deviation calculation, the control limits at three standard deviations, the capability index relating the specification width to the process spread, and the simple rules of chart interpretation, the excursion beyond the limits and the run of seven. These tools are exactly the ones the raw mix and quality control workbooks apply to the LSF, and the module states them generically so they apply to the Blaine, the residue, the charge, or the heat consumption with equal force.

The statistical pages also define the reconciliation logic that marks the end of every calculation family: the heat balance closes within tolerance, the mass balance closes within tolerance, the charge weight reconciles against the weighbridge, and the cost sheet closes to the cent. The module’s position is that a calculation without a checksum is not finished, and the reader who inherits that habit, verify every closure before reporting, takes from the formula module the most professional habit of all, one that outlasts the specific formulas stored in its cells.

How the Module Serves the Other Workbooks

The formula module earns its place in the library less for what it is than for what it makes possible elsewhere. Every dedicated workbook in the package, the heat balance calculator, the cyclone design file, the ball charge design and audit pair, the raw mix composition and quality control file, and the cost accounting case study, draws its master equations from the same language this module codifies, and the module is the standard against which any of those workbooks can be checked. When an engineer detects a suspicious figure in a design sheet, the drill is to open the corresponding page of the module, reproduce the underlying calculation by hand, and compare the two paths. When a new engineer joins the plant, the module is the first file placed on the desk, because it is the shortest route to speaking fluent cement. When a plant performs a technical audit or prepares a defensible energy or quality report, the module provides the audit trail, each equation in its proven form, each unit in its committed convention.

This arrangement is possible because of the single-source-of-truth architecture described earlier: the constants live once and are referenced everywhere, so the same molecular mass, the same latent heat, the same packing factor, and the same conversion factor that the module defends are the ones every workbook uses. The result is a package whose numbers agree across disciplines, which is the property a serious industrial customer needs when the heat balance, the mill audit, and the cost sheet must reconcile in a single management meeting. The module is therefore not merely a good document; it is the keystone that makes the whole library a coherent instrument, and the engineer who has internalized its pages carries the complete semantic of the cement industry in a single mental workspace.

Frequently Asked Questions

Is the Bogue calculation an accurate measure of the clinker phases?

No, and the module says so plainly. The Bogue equations assume equilibrium crystallization of the pure phases, so they give the potential composition rather than the measured one. Real clinkers deviate with magnesia, alkalis, sulfate, and cooling conditions. The Bogue values remain useful as the standard first estimate and as the language of raw mix design, but they are complemented by microscopy, X-ray diffraction, or quantitative methods when the phase composition itself is the question.

Why does the module insist on the LHV basis?

Because the latent heat of the combustion water is never recovered in a real kiln system; the flue gas leaves well above the dew point. Basing the heat balance and burner sizing on the LHV gives the honest usable energy. The module converts HHV to LHV at the boundary, so certificates quoted in either convention enter correctly.

What is the most common unit error in applying these formulas?

Mixing the bases: using kilograms where tons are implied, centimeters where meters are implied, kilocalories where megajoules are implied, and weighting the Euler number or the cut-size expression with an inconsistent density or velocity unit. The module’s boundary-conversion convention and its locked formula zone are designed precisely to prevent that class of error.

How do I get the bulk density right for a charge weight calculation?

Start from the solid density and the void fraction: for random-packed equal steel spheres, void fraction near 0.40 gives a bulk density near 4.7 tons per cubic meter, and use 4.5 to 4.6 tons per cubic meter as the working value for a real graded, worn charge. Adjust deliberately for media type and document the value; the audit must use the same value as the design or the reconciliation will lie.

Does the module cover the formulas of every workbook in the library?

It covers the master formulas that the workbooks share, the chemistry moduli, the clinker phases, the heat balance, the cyclone flow, pressure, and efficiency, the ball charge and mill power, and the combustion stoichiometry, together with the conversions and statistics that sit underneath them. The dedicated workbooks then apply these masters to their case-specific inputs at full scale, which is why learning the module is the fastest route to learning the package.

Summary

Formulase_Mod is the mastering heart of the cementequipment.org package: the compiled, documented, single-source collection of the industry’s core mathematics. This article has toured the module from its unit and conversion discipline, through the raw mix moduli of LSF, SM, and AM and the Bogue phase equations, through the heat balance built on the HHV and LHV framework with its full catalogue of input and output terms, through the gas handling equations of volumetric flow Q, the Euler number, and the cut-size collection model, through the grinding mathematics of the charge weight W equals V times bulk density times filling degree, the void factor, and the mill power and sizing rules, through the combustion stoichiometry and the statistical control extensions, and it has demonstrated the whole with a chain of worked numbers and a master equation table the reader can keep at hand.

The module’s deepest message is that an industry runs on transparent, verified mathematics, and that the engineer who can open every formula, check every unit, and reproduce every number by hand is the engineer who is never hostage to a black box. The formula module makes that transparency its whole purpose: each equation defined, each symbol with its units, each constant sourced, each answer carrying its checksum. For the student it is the complete syllabus of cement engineering in one file; for the practicing engineer it is the reference the desk always needs; and for the industry it is a quiet statement of the standard the whole profession should hold, that every number on every report be traceable to a formula, a unit, and an assumption that anyone can audit. That is the standard the cementequipment.org library exists to serve, and Formulase_Mod is its most concentrated expression.

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.