Cement Equipment: Complete Technical Encyclopedia

cementequipment.org, in its second and modernized edition, is delivered as an XLSX workbook (cementequipment.org(1).xlsx, approximately 0.01 MB) and represents the next generation of the calculation tools in the Cement Equipment Technical Library. Where the classic .xls edition demonstrated the three-zone layout and the core formula families, this modern companion edition shows how the same engineering mathematics are refreshed for today’s spreadsheet environment: cleaner workbooks, better data handling, formatted output ready for reporting, and the same transparent formula culture that has always defined the library. This article is a complete technical guide to this companion edition, and because the file is a microcosm of the whole 931-file package, the article doubles as a tour of modern cement process calculation work. It covers the structure and conventions of the workbook, the discipline of quality control through control charts, the raw mix design mathematics embodied in the limestone saturation factor LSF, the silica modulus SM, and the alumina modulus AM, the heat balance framework built on higher and lower heating values with its full inventory of input and output terms, the ball charge design relationship in which charge weight equals chamber volume times bulk density times filling degree, and the cyclone design physics of volumetric flow Q, the Euler number, and the cut-size collection efficiency model. Each major module is presented with its equations, its practical context, and worked numbers, so that an engineer can open the workbook and follow every cell.

What Makes the XLSX Companion Edition Different

The XLSX format brought real improvements over the legacy XLS container. A workbook is now stored as a package of XML files, so it is more robust, more compressible, and less prone to the corruption that occasionally strikes old binary files. Named styles, conditional formatting, and table objects behave more predictably, and the file handles the larger data sets, longer time series of lab results, and longer audit histories that modern quality departments generate. The modern companion edition exploits all of this: it presents the same calculation modules as its predecessor but with richer formatting, clearer headings, and output areas designed to be copied directly into reports and presentations.

The intellectual content, however, is unchanged and intentionally so. The engineering mathematics of cement do not change with the file format. A filling degree is a filling degree, an Euler number is an Euler number, and an LHV heat balance is an LHV heat balance whether it lives in a 1995 binary file or a 2026 compressed workbook. What the modern edition adds is clarity and maintainability: the formulas are documented in the sheet with named ranges, the units are stated in every header, and the layout follows the library’s standard three-zone convention of input, calculation, and output, so that a user who learned the classic edition can move to the modern one without a manual, and a user who starts here can move backward into the larger dedicated workbooks equally easily.

The Three-Zone Workbook Convention

The house style of the library, and the structure of this file, is a consistent three-zone layout on every calculation sheet. The Input zone, usually shaded, contains the data the user must supply: tonnages, moisture, oxide analyses, fuel heating values, mill dimensions, gas flows, and prices. The Calculation zone, in the middle, contains the transparent formulas; in the modern edition these are written with named ranges wherever possible, so a formula reads as NetHeat equals LHV times FuelRate rather than as a row-and-column reference that means nothing to the eye. The Output zone, on the right or below, is formatted for the report and may carry charts, tables, and the units column. This separation makes an auditable sheet: the input zone is the assumption list, the calculation zone is the logic, and the output zone is the deliverable.

Two further disciplines distinguish this edition. First, every input cell carries a comment describing the data source, whether that is the laboratory report, the control system historian, the weighbridge, or the fuel supplier certificate. Second, the output zone always includes a checksum or reconciliation line, so the user can confirm the calculation closes before taking the numbers to a meeting. These are small conventions, but they are the difference between a spreadsheet and a deliverable, and they are the reason the library’s files earn trust among plant engineers.

Raw Mix Design: The LSF, Silica, and Alumina Moduli

The first major module of the workbook is raw mix design, and at its center sit the three classical control moduli. The limestone saturation factor reflects how fully the lime in the mix can combine with the acidic oxides. 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 all oxides expressed as percentages by mass. The coefficients come from the stoichiometry of the main clinker minerals: the 2.8 expresses the roughly 2.8 parts of lime combining with one part of silica in the alite and belite minerals, and the 1.18 and 0.65 reflect the lime required by aluminoferrite and aluminate phases. A target LSF of about 95 percent with a practical range of 92 to 98 percent describes most ordinary Portland cement clinkers.

The silica modulus, SM, is the ratio of silica to the combined alumina and iron, SiO2 divided by Al2O3 plus Fe2O3, and normal values fall between 2.0 and 3.0. It governs the proportion of liquid phase formed at burning temperature and, with it, the coating behavior, the burning-zone temperature, and the clinker’s tendency toward dusting or balling. The alumina modulus, AM, is Al2O3 divided by Fe2O3, typically 1.0 to 2.5, and it decides which of the aluminate and ferrite phases dominate, influencing both the heat of hydration of the cement and the refractory compatibility of the charge. In the workbook, the user lists the raw material analyses, and the sheet solves the proportioning problem by matrix or iterative calculation to hit the requested moduli while respecting the practical feeder limits.

The quality dimension is inseparable from the chemistry. Once the mix is proportioned, the target finally faces the reality of a continuous process in which the quarry, the crusher, and the weigh feeders all introduce variation. That is why the module hands off to the quality control section of the workbook, where the same target moduli becomes the horizontal centerlines of control charts.

Quality Control Through Control Charts

The quality control layer of the modern workbook reads the time series of laboratory results, the X-ray fluorescence analyses of the kiln feed and the finished cement, the free-lime test results, and the fineness and surface area data, and translates them into statistical signals. The core tool is the control chart. The worksheet computes the process mean and standard deviation from a stable period, sets the upper and lower control limits at three standard deviations, and plots the successive sample averages. A point outside the control limits, or a run of seven or more points on one side of the centerline, is the statistical fingerprint of a special cause: a changed quarry face, a drained corrective silo, a drifting feeder, or an analyzer needing recalibration.

The workbook also computes process capability. When the specification for the LSF is, for example, a target of 95 percent with a tolerance of plus or minus 3 percent, the capability index relates the specification width to the actual process spread. The capability index is the ratio of the allowable spread to six standard deviations of the process, and experienced plants want a value comfortably above 1.0, ideally approaching 1.33 or better, so that the process can hold its targets even in the presence of disturbances. When capability is poor, the sheet highlights it, and the engineer’s attention moves upstream: better blending in the homogenizing silo, steadier feeder control, or a wider corrective feed, before the kiln ever sees the mix. The control chart therefore closes the feedback loop from laboratory, to raw mix design, to the burnability of the clinker, and ultimately to the consistent quality of the shipped cement.

Heat Balance Calculations on the HHV and LHV Basis

The burning module of the workbook is the heat balance, and its foundation is the heating value of the fuel. The higher heating value, HHV, and the lower heating value, LHV, differ by the latent heat of the water vapor in the combustion products. In a real cement kiln the flue gases leave the preheater at temperatures from roughly 250 to 400 degrees Celsius, far above the dew point, so the vaporization heat is never returned to the process, and the LHV is the honest basis for engineering calculation. The relationship is LHV equals HHV minus the latent heat of vaporization per kilogram of water times the mass of water generated per kilogram of fuel, with the water coming from the fuel’s hydrogen and its free moisture. For a typical coal, the LHV runs about 94 to 96 percent of the HHV, but for a fuel with high hydrogen, such as a gaseous or a liquid fuel, the difference grows and must be computed from the fuel analysis.

The balance table then enumerates the input and output streams. Inputs on the left: the chemical heat of the fuel at the LHV; the sensible heat of the dry material and water in the kiln feed; the sensible heat of the primary, secondary, and tertiary air, or of the combustion air generally; and any heat recovered from the clinker cooler. Outputs on the right: the theoretical heat of clinker formation, approximately 1750 to 1800 kilojoules per kilogram of clinker; the sensible heat carried out by the clinker at the cooler discharge; the sensible heat of the exit and by-pass gases; the heat required to evaporate the raw meal moisture; the convective and radiative losses through the kiln, preheater, and cooler shells; the heat lost in the cooler exhaust air; and the unaccounted residual that absorbs measurement error. Reporting every line both in kilojoules per kilogram of clinker and as a percentage of the input is standard practice, and the closing of the balance to within a few percentage points is the test of good measurement.

The output of the heat balance module feeds directly into the plant’s energy cost: the fuel rate in tons, the specific thermal consumption in gigajoules per ton of clinker, and the thermal efficiency of the kiln system, which is the ratio of the theoretical clinker formation heat to the total fuel heat supplied. The workbook also carries the corresponding mass balance so that tons of in-feed reconcile against clinker, dust, and gas, which is the essential check that makes the thermal numbers credible.

Ball Charge Design and the Grinding Module

On the grinding side, the modern workbook reproduces the industry’s core media mathematics. The ball charge in a mill compartment rests on the charge weight equation: W equals V times rho-b times f, where W is the charge weight, V is the internal volume of the compartment, rho-b is the bulk density of the grinding media in the settled charge, and f is the filling degree expressed as a fraction. The bulk density is not the density of the solid metal but the mass of the packed bodies per unit volume of the settled charge, and it depends on the void fraction between the balls. For equal spheres the random packing void fraction is near 0.40, so the theoretical bulk density of steel balls is 7.85 tons per cubic meter times 0.60, about 4.7 tons per cubic meter, and a working value of 4.5 to 4.6 tons per cubic meter is conservative once mixed sizes, worn balls, and interstitial fines are included. The void factor also changes for ceramic media, and the workbook holds the coefficients for a selection of media types.

To make the equation concrete: a first chamber with an internal volume of 36 cubic meters, a second chamber of 30 cubic meters, a filling degree of 0.30, and a bulk density of 4.55 tons per cubic meter carries a total charge of 66 times 4.55 times 0.30, that is, about 90.1 tons. That weight must reconcile with the weighbridge history of the balls fed to the mill since the last full charge, and the residual between the theoretical and actual mass is the media wear, usually reported in grams per ton of cement and benchmarked between 300 and 900 grams per ton for OPC grinding. The module also supports the sizing of the load: the maximum ball size must crack the coarsest feed, and the compartment gradings follow the particle size spectrum so that the coarsest chamber holds the largest balls and the fine chamber holds the smallest, keeping the whole mill in an efficient cascade.

Effectively the grinding module turns a monthly mass reconciliation into an audit of design intent: whether the mill is carrying the designed charge, consuming media at the designed rate, and producing the designed fineness. When the reconciliation, the mill power draw, and the surface area output all agree, the module confirms the ball charge design is healthy; when they diverge, the module points the operator to the cause, an overfilled or starved mill, wrong gradients, or a separator not doing its share, which connects naturally to the gas handling module that follows.

Cyclone and Separator Design: Flow, Euler Number, and Efficiency

Every preheater, cooler, and mill circuit leans on dust separation, and the modern workbook carries the cyclone designer’s toolkit. The starting quantity is the volumetric flow of gas, Q, in cubic meters per second. Gas enters through an inlet of cross-sectional area A, so the inlet velocity is Q divided by A, and preheater practice keeps it near 15 to 25 meters per second. The pressure drop is captured by the dimensionless Euler number, Eu, defined as two times the measured pressure drop times the gas density divided by the square of the inlet velocity. Rearranged for design, pressure drop equals half times Eu times gas density times inlet velocity squared. Because the pressure drop rises with the square of velocity, a modest increase in gas velocity has a disproportionate effect on the fan power, and the workbook makes that trade visible on a sweep chart of velocity against pressure and fan power.

Efficiency is characterized by the cut size, the particle diameter captured at 50 percent. A simplified and widely used model, built in the spirit of the Lapple relationship, writes the cut diameter dc as proportional to the square root of nine times the gas dynamic viscosity times the cyclone body diameter times the inlet width, divided by the product of the number of effective vortex turns, the gas density, the particle density, and the inlet velocity. The proportionality constant is fixed by the chosen empirical model, but the functional form teaches the design lessons: smaller bodies, higher inlet velocities, and denser particles all reduce the cut size and raise efficiency, subject to the pressure drop penalty. In the preheater context this efficiency decides how much raw meal dust recirculates, how much false load the fans must carry, and how clean the gas leaves each stage; in the separator context the same physics decides the sharpness of the product cut and the stability of the Blaine value. The modern workbook couples the cyclone sheet to the fan power sheet and to the quality control sheet, so a design change echoes through power cost and product variability at once.

The Formula Sheet Module

The companion edition includes the library’s formula sheet, the compiled reference of the trade’s core physics and chemistry. Arranged by discipline, it gathers: the unit conversion factors that plague international projects; the Bogue equations converting oxide analysis into potential clinker phases, alite, belite, aluminate, and ferrite; the stoichiometry of combustion giving theoretical air and flue gas volumes for any fuel; the theoretical heat of clinker formation; the mill power and media relationships; and the fan, cyclone, and heat balance relationships used throughout the larger workbooks. Each entry states the equation, defines every symbol with its units, and gives a worked numeric example so the engineer can verify understanding before applying the formula to plant data.

What elevates the sheet beyond a simple reference is its linkage. Formulas in the sheet are implemented as named functions or cells, and the larger workbooks reference those cells rather than re-typing the mathematics. When a combustion constant or a conversion factor is corrected, the correction propagates through the entire package, preserving consistency across every module. This single-source-of-truth approach is the quiet architectural merit of the library, and it is the reason the numbers agree whether the engineer opens the heat balance, the cyclone sheet, or the cost ledger.

A Worked Chain Through the Companion Workbook

The best way to prove the modern edition is to follow one chain of numbers through several modules. Begin at the raw mix sheet with a clinker-basis analysis of SiO2 21.8 percent, Al2O3 5.0 percent, Fe2O3 3.6 percent, and CaO 66.1 percent. Compute LSF as 66.1 over the denominator 2.8 times 21.8 is 61.04, plus 1.18 times 5.0 is 5.90, plus 0.65 times 3.6 is 2.34, for a total of 69.28, giving an LSF of 95.4 percent. The silica modulus is 21.8 divided by 8.6, or 2.53, and the alumina modulus is 5.0 divided by 3.6, or 1.39. All three moduli sit inside the normal design window, and the control chart confirms the kiln feed has been stable within capability for the month.

Burning follows in the heat balance. With petroleum coke at an LHV of 31.5 megajoules per kilogram and a specific consumption of 3.45 gigajoules per ton of clinker on the LHV basis, the coke rate is 3.45 divided by 31.5, about 110 kilograms per ton. The balance distributes this input among the theoretical formation heat of about 1.78 gigajoules, the recovered and lost streams, and a small reconciled residual, and the mass balance confirms the raw meal factor near 1.55 tons per ton of clinker. The cooler, the preheater, and the by-pass all report their losses in the same units.

Finish with the grinding circuit. A two-chamber mill with 40 cubic meters in the first chamber and 34 in the second, at a filling degree of 0.28, carries 74 times 4.55 times 0.28, around 94.3 tons of media. Monthly weighbridge data shows 410 grams of media consumed per ton of cement, comfortably inside the 300 to 900 gram benchmark, and the separator handles 140 cubic meters per second through a 7.5 square meter inlet at the design density. The inlet velocity is about 18.7 meters per second; with a measured Euler number of 4.8 the pressure drop is half times 4.8 times density times velocity squared, a plausible working figure, and the power line feeds the cost ledger. Every number here is traceable to a cell in the workbook, which is the entire point of the format: it is not a black box, it is a classroom.

From Calculation Workbook to the Rest of the Package

The companion workbook is deliberately small, and its true value is as a gateway. Within it the reader meets the same raw mix moduli that fill the dedicated raw mix design files, the same heat balance table that fills the full heat balance workbook, the same charge weight equation and cyclone physics that fill their dedicated design workbooks, and the same formula culture that supports the entire 931-file library. An engineer who has worked through this file can then approach the large dedicated tools with confidence, because the mathematics, the layout, and the auditing discipline are all the same, only at greater scale and depth.

The package as a whole remains what it has always been: a collection of books, courses, presentations, and spreadsheets that together cover the complete technical life of a cement plant, from the quarry and raw mix design through burning, grinding, quality control, and cost, and it is available to the licensed single user in one complete purchase. The modern companion edition shows that the library is not frozen in time: while the physics stays constant, the delivery, the formatting, and the data handling keep pace with the tools engineers actually use, which is how a technical library stays useful across decades.

Worksheet Data Hygiene and Auditing in Practice

A calculation workbook is only as trustworthy as the data that flows into it, and the modern companion edition embeds several disciplines that keep the numbers dependable over years of monthly use. The first discipline is a single source of truth for unit systems. The library files are engineered so that all thermal work is carried in megajoules and gigajoules, all mass in metric tons, all volumes in cubic meters, and all flow in cubic meters per second or cubic meters per hour, with conversions performed only at the boundary where data enters. The formula sheet carries the conversion factors explicitly, 1 gigajoule equals 1000 megajoules, 1 ton equals 1000 kilograms, 1 megapascal equals 10 bar, and the like, so a user importing a furnace report in kilocalories rather than megajoules can apply the correct factor at the cell, not silently inside a formula where the error becomes invisible.

The second discipline is version control of the data itself. A laboratory analysis, a weighbridge ticket, and a fuel certificate are each entered with the date and source in the adjacent comment column, and the sheet retains a history tab that stores several months of the raw input. This means when the next month’s balances are prepared, the user can reconcile backward, changing an input in a previous month and watching the audit trail recompute, which is exactly what a controller needs when a supplier revises a certificate or a laboratory reissues an analysis. Without this history, a spreadsheet quietly manufactures false precision; with it, every number on the report can be traced to a dated original document, which is the same standard of evidence expected of the plant’s mass balance and its financial accounts.

The third discipline is the reconciliation line at the foot of every output zone. Each module closes with a checksum: the heat balance closes when the sum of outputs equals the sum of inputs within a tolerance of a few percent; the mass balance closes when tons in equal tons out plus inventory change; the cost sheet closes when the sum of the cost lines equals the total cost within a few cents per ton. A workbook that cannot close is a workbook telling the engineer something is being measured wrongly, and the modern edition treats that signal as a first-class output rather than an annoyance. Plants that enforce these disciplines find that their monthly numbers stop jumping around, that the causes of variance become visible weeks earlier, and that the same raw data starts supporting both the engineering audit and the financial audit without dispute.

The final discipline is the protection of the calculation zone. In a production environment, users are granted access to the input zone only; the formula cells are protected with a password so that the logic cannot be accidentally overwritten during a late-night shift change. The protection is deliberately light, because this is a teaching library and the whole point is that the user can inspect every formula, but the discipline of separating the data entry area from the logic area is real, and it is the same separation a well-run engineering office uses for its design files. Between the single-source unit handling, the dated input history, the mandatory closing checksums, and the protected calculation zone, the modern workbook turns a simple spreadsheet into a controlled document, which is precisely the standard that a serious cement plant should hold for the numbers its decisions depend on.

Frequently Asked Questions

What is the difference between the XLS and XLSX editions of this file?

Both carry the same engineering content and follow the same three-zone layout, but the XLSX companion edition uses the modern Open XML workbook format, which is more robust, compresses better, supports richer formatting, and behaves more predictably with large time-series data sets. The physics, chemistry, and formulas are identical, because cement engineering does not change with a file extension.

Why is the heat balance computed on the lower heating value basis?

Because the flue gas leaves a real kiln system well above the dew point, the latent heat of the water vapor produced by combustion is never recovered, so the LHV, which excludes that latent heat, is the honest measure of usable fuel energy. The HHV is still reported for fuel trading and for consistency with supplier certificates, and the workbook maintains the conversion between the two.

What exactly does the charge weight equation tell the operator?

The equation W equals V times bulk density times filling degree tells the operator how many tons of media should be in each mill chamber. Comparing that theoretical charge to the weighbridge records of balls added since the last full charge reveals the true media consumption and flags over- or under-filling, both of which waste power and degrade grinding efficiency.

What are the consequences of a poor LSF on production cost?

A low LSF gives an under-lime clinker with weak minerals and a high dusting tendency, while a very high LSF makes the mix hard to burn, requiring higher temperature, more fuel, and shorter refractory life. Both extremes raise cost, which is why the LSF, guarded by control charts, is kept within a tight capability window around the design target.

Is the cut-size model in the workbook the Lapple model?

The workbook uses a simplified model in the spirit of the Lapple empirical approach, in which the 50 percent cut size is proportional to the square root of the ratio of viscosity and geometry terms to the gas density, particle density, and inlet velocity product. The exact proportionality constant follows the plant’s validated geometric family, and the sheet documents which constant is in use.

Summary

The cementequipment.org modern XLSX companion edition is the library’s demonstration that classic cement engineering mathematics and modern spreadsheet craft belong together. This article has walked through the workbook’s three-zone convention, its raw mix design module with the LSF, silica modulus, and alumina modulus, its quality control layer of control charts and capability indices, its heat balance module on the HHV and LHV bases with the full catalogue of input and output terms, its ball charge design based on the charge weight equal to volume times bulk density times filling degree, its cyclone design physics of volumetric flow, Euler number, and the cut-size collection efficiency model, and its formula sheet acting as the single source of truth for the whole package. A complete worked chain tied the modules together with real, recalculatable numbers.

The reader closes the file with more than a set of formulas: the file leaves behind a method, the habit of transparent inputs, auditable logic, and reconciled outputs, a habit that is portable to any plant, any spreadsheet, and any engineering discipline. For the professional this is the difference between carrying an Excel file and carrying a professional calculation toolkit; for the larger package this small file is the front door through which an engineer enters the deep, dedicated workbooks of raw mix design, heat balance, ball charge, and cyclone design that follow; and for the industry as a whole it is a quiet argument that engineering rigor and spreadsheet transparency are, and always have been, the same thing.

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.