Cement Equipment Technical Library & Buyer Guide
cementequipment.org is the gateway to one of the most complete technical libraries in the cement industry, and the workbook that carries the site’s own name is the perfect introduction to how that library works. Delivered as a legacy Microsoft Excel workbook (cementequipment.org (1).xls, approximately 0.03 MB) in the Package Tools section of the Cement Equipment Technical Library, this compact file is a tour of the calculation culture that defines the whole 931-file collection: transparent formulas, interoperable worksheets, and engineering judgment encoded in everyday spreadsheets. This article explains what the file contains, how it is organized, and how its methodology connects to every major discipline of cement technology, from raw mix design and quality control to clinker burning, heat balance calculations, ball charge design, cyclone design, and the formula sheets that hold the industry’s core mathematics together. Along the way, the article presents the real equations a process engineer uses every day, including the limestone saturation factor, the silica and alumina moduli, the volumetric flow and Euler number that govern cyclone pressure drop, the cut-size model used to estimate collection efficiency, the higher and lower heating value framework of heat balance work, and the charge weight relationship for ball mills in which charge weight equals chamber volume times bulk density times filling degree. Any reader who works through these pages will finish with a mental map of the entire library and a working vocabulary for the spreadsheets inside it.
What the cementequipment.org Workbook Actually Is
At first glance a 0.03 MB spreadsheet seems too small to matter. That judgment would be wrong. The cementequipment.org workbook is not a database; it is a method demonstration. It is the file that teaches a new user how the library’s calculation tools think, how the sheets are laid out for input, calculation, and output, and how a modest number of well-chosen formulas can replace an entire wall of outdated hand calculations. Because it is small, it is also fast to load, easy to audit, and forgiving to modify, which makes it the ideal training ground for engineers new to process calculation work.
The workbook gathers the site’s most representative calculation patterns into one place. A typical page contains: a header block with plant identification, date, fuel type, and units; an input region with yellow or blue formatting convention; a transparent calculation region where every formula is visible in the formula bar, never buried in a macro; and an output region formatted for a report or graph. This consistent three-zone layout is the house style of the library, and once a reader learns it on this small file, every larger workbook, from cyclone design to the full clinker cost sheets, becomes immediately navigable. The file therefore functions as the Rosetta stone of the 931-file package.
How the Library Is Organized
The Cement Equipment Technical Library is structured around the complete life cycle of a cement plant. The books and handbooks provide the theory; the courses and presentations compress the training value of the industry’s big equipment suppliers into focused modules; and the Excel tools convert that knowledge into working calculations. The Package Tools section, where this file lives, is the set of spreadsheets an engineer actually uses on the desk, in the control room, and in the monthly management meeting. Within the section the tools fall into natural families that the rest of this article explores one by one: raw mix design and quality control workbooks, heat balance and mass balance workbooks, ball charge and mill audit workbooks, cyclone and separator design workbooks, and the comprehensive formula sheets that tie them all together.
This organization is deliberate. A plant engineer troubleshooting high exit gas temperature opens the heat balance family; a quality manager retuning the raw mix opens the raw mix family; the production manager approving a media purchase opens the ball charge family. Because each family shares the same layout conventions, moving between them costs no relearning time, and because each family is built on the same core formulas, the numbers agree when a plant is audited end to end. That agreement across tools is the quiet strength of the collection and the reason the library has built such a loyal user base among cement engineers.
The Raw Mix Design and Quality Control Family
The chemistry of the clinker starts long before the kiln, in the raw mix design worksheets. These tools accept the oxide analyses of the available materials, limestone, clay or marl, sand, and iron corrective, and solve for the proportions that meet the target moduli. The central control equation is the limestone saturation factor, LSF, which compares the lime available in the mix to the lime that can theoretically combine with silica, alumina, and iron to form clinker minerals. Expressed on the clinker basis, LSF equals CaO divided by the sum of 2.8 times SiO2 plus 1.18 times Al2O3 plus 0.65 times Fe2O3, all percentages by mass. The numerators and denominators come directly from the X-ray fluorescence analysis the laboratory reports for the kiln feed or clinker.
The silica modulus, SM, is the ratio of silica to the sum of alumina and iron, SiO2 divided by Al2O3 plus Fe2O3, and it controls how much liquid phase forms during burning and how the clinker behaves in the kiln. The alumina modulus, AM, sometimes called the iron modulus, is the ratio Al2O3 divided by Fe2O3. Taken together, the three moduli describe burnability, coating tendency, clinker temperature tolerance, and the likely phase balance of the product. The worksheet takes the user from a set of raw material analyses through the iterative proportioning of the main stream and corrective additions to a recomputed set of moduli and a predicted clinker oxide analysis, effectively closing the loop between the quarry and the kiln.
The quality control side of the family adds the discipline of the control chart. Data from the online analyzer or the laboratory enters the sheet in time order, the capability statistics, mean and standard deviation, are recomputed, and control limits are drawn. The user then sees instantly whether the raw meal is drifting, whether a corrective feeder has lost calibration, and whether the process capability is good enough to burn at the design LSF without risking brick damage or una-specified clinker. Slides through this discussion illustrate that quality control is not an inspection step at the end; it is a feed-back loop that starts with the weigh feeders and ends with the silo discharge known as the kiln feed.
Heat Balance and Mass Balance Workbooks
The heat balance family converts fuel consumption into units the accountant can price. The central concept is the heating value of the fuel, quoted either as higher heating value, HHV, or lower heating value, LHV. HHV includes the latent heat released if the water vapor produced by combustion condenses; LHV excludes it because real flue gas leaves the stack as vapor. The designer chooses LHV for process work. The relationship between the two is usually written LHV equals HHV minus the product of the latent heat of water vaporization per kilogram of water and the mass of water produced per kilogram of fuel, where the water comes from the fuel’s hydrogen and moisture content. As a rule of thumb for solid fuels, LHV is in the range of 94 to 96 percent of HHV; for fuels with unusual hydrogen content the difference must be computed, not guessed.
Once the heating value basis is fixed, the balance sheet is a simple but powerful table. Input terms: chemical heat of the fuel at the chosen heating value, sensible heat of the raw meal or kiln feed, sensible heat of the combustion air, and any heat recovered from the cooler. Output terms: the theoretical heat of clinker formation, which is the enthalpy required to heat the raw meal, drive off carbonate and other gases, and form the clinker minerals, quantitatively about 1750 to 1800 kilojoules per kilogram of clinker; sensible heat in the clinker leaving the cooler; sensible heat in the exit and bypass gas; latent heat to evaporate raw meal moisture; shell losses by convection and radiation; cooler exhaust losses; and the unaccounted residual that captures measurement error. Everything is reported in kilojoules per kilogram of clinker and as a percentage of the total input. When the two sides balance to within a few percent, the engineer trusts the numbers; when the unaccounted line balloons, the audit shifts to flow meters, temperatures, moisture assumptions, and the accuracy of the fuel analysis.
The mass balance family runs parallel: tons in must equal tons out, through the raw mill, through the kiln with its carbonate dioxide and other gas losses, and through the finish mill with its separator and baghouse returns. Reconciliation of the mass balance is what makes the heat balance believable, and both together make the cost sheets believable. This is the chain of evidence that turns spreadsheet columns into engineering truth, and it is the chain this library teaches from the first file to the last.
Ball Charge Design and Mill Audit Workbooks
Grinding consumes the largest electrical load in the plant, and the ball charge is the heart of the mill. The core relationship used throughout the ball charge workbooks is the charge weight equation: the weight of the charge in a mill compartment, W, equals the internal volume of the compartment, V, times the bulk density of the grinding media, rho-b, times the filling degree expressed as a fraction, f. Written compactly, W equals V times rho-b times f. For a compartment of 45 cubic meters internal volume, a settled steel charge bulk density of 4.55 tons per cubic meter, and a filling degree of 0.30, the charge weight is 45 times 4.55 times 0.30, about 61.4 tons.
Bulk density deserves explanation because it is not the density of the steel itself. Solid steel has a density near 7.85 tons per cubic meter, but balls do not pack solid: between touching spheres there is a void fraction, the empty space, which for a random packing of equal spheres is about 0.40. The packed, or bulk, density is therefore the solid density times one minus the void fraction, which for steel is roughly 4.7 tons per cubic meter in theory, and a working figure of 4.5 to 4.6 tons per cubic meter is commonly used once mixed sizes, wear, and settling are considered. The void factor also matters when the media change to ceramic or to a mixture of ball sizes, because both change the packing. The worksheets let the user enter the bulk density and the filling degree, recompute the charge weight, and reconcile it against the weigh-sheet history of balls purchased since the original charge, which is the accounting side of media management.
Beyond the weight, the design worksheets handle the sizing of the ball load: the top size, which must be large enough to crack the coarsest particles fed to the mill, and the graded distribution from the coarse to the fine chambers, which follows the particle size down the mill length. The formula sheets supporting the design combine feed size, work index, mill internal diameter, and the desired product fineness to produce a suggested top ball size and a compartment-by-compartment grading. The audit workbook then tracks the result over time: shell impact sound, mill power draw, product fineness, and the measured mass of the charge against the theoretical value, so that over-filling, under-filling, and the slow decay of the load by wear are all visible in one page.
Cyclone and Separator Design Workbooks
Cyclones are the quiet workhorses of the cement plant, separating dust from gas in the preheater, in the cooler, and at the heart of every high-efficiency separator. The design workbooks in this family start from the volumetric flow of gas, Q, in cubic meters per second. If the gas enters the cyclone through an inlet of cross-sectional area A, the inlet velocity is Q divided by A; plant practice holds this between 15 and 25 meters per second in preheater cyclones. The pressure drop across the cyclone is most conveniently expressed through the dimensionless Euler number, Eu, defined as two times the pressure drop times the gas density, divided by the square of the inlet velocity. Rearranged, the pressure drop equals half times Eu times gas density times inlet velocity squared. Typical geometries produce Euler numbers from 3 upward to about 8, and the fan power follows directly from the pressure drop multiplied by the volumetric flow, linking the design sheet directly to the power ledger.
The second pillar of the family is collection efficiency. The classic approach characterizes the cyclone by its cut size, the diameter of particle at which 50 percent of the particles are collected. A simplified model, following the pattern of the well-known Lapple empirical relationship, expresses the cut diameter dc in terms of cyclone geometry, gas properties, and inlet velocity: dc is proportional to the square root of the quantity nine times gas dynamic viscosity times cyclone body diameter times inlet width, divided by the number of effective vortex turns times gas density times particle density times inlet velocity. Each parameter teaches a design lesson: a smaller body, a higher inlet velocity, and denser particles all push the cut size smaller and raise efficiency, but at the cost of pressure drop, which grows with the square of velocity. The workbooks let the user sweep the dimensions and velocities to find the design that minimizes total annual cost, including both fan power and product yield losses, rather than the design that maximizes efficiency in isolation.
The same physics underlies the separator, where the goal is a sharp cut between finished product and return fines. The cyclone family therefore feeds directly into the quality control report: sharper separation means a steadier Blaine value, fewer unground particles in the product, and a better grinding economy. Whether the target is preheater gas cleaning, raw mill classification, or cement mill classification, the volumetric flow, Euler number, and cut-size framework is common to all, and it is the thread that ties the design workbooks together.
The Formula Sheets
Every serious engineering discipline keeps a one-page cheat sheet of its core mathematics, and the cement industry’s is the formula sheet module of this library. The formula sheets are the reference spine that the other workbooks point to. They compile the conversion factors between units that plague international projects; the oxide-to-phase conversions of the Bogue calculation for the potential mineral composition of clinker; the stoichiometry of fuel combustion, giving theoretical air and flue gas volumes for any fuel analysis; the theoretical heat required for clinker formation; the mill power and media sizing relationships; and the cyclone, separator, and fan relationships already discussed. A well-built formula sheet states the equation, defines every symbol with its units, gives a worked numeric example, and cites the range of validity so that the engineer does not misuse the formula far outside its assumptions.
The formula sheet is also where the library shows its educational pedigree, reflecting the training material of the industry’s major technology suppliers. The layout teaches by pattern: raw material chemistry, then burning chemistry, then grinding, then gas handling, then economics. The reader who masters the sheet can walk into any of the larger workbooks and recognize each formula doing its job inside a bigger calculation, which is the deepest way to learn engineering software: not as a black box, but as a transparent arrangement of equations the engineer already knows.
Connecting the Workbooks Into One Plant-Wide Model
The most valuable lesson the cementequipment.org workbook teaches is that the individual tools are fragments of one plant-wide model. The raw mix design decides the chemistry; the heat balance decides the fuel; the cyclone design decides the gas handling power; the ball charge decides the grinding power and media; and the formula sheets keep every calculation consistent. When they are used together, the engineer can answer questions no single tool can answer alone. What is the total production cost if the LSF is raised by one point? Follow the change through burnability to fuel in the heat balance, to power in the cyclone and separator sheets, to media in the ball charge sheets, and finally to the cost ledger. What happens to the cement if the separator fan is throttled? Follow the flow to the cut size, the product fineness, the quality control chart, and the power bill.
This integrated way of thinking is what distinguishes the experienced process engineer from the beginner, and it is exactly the habit this library is designed to build. The small cementequipment.org workbook, precisely because it is small, shows the integration on a scale the eye can hold at once. Larger workbooks add rows of data and deeper hierarchies, but the logic is identical: inputs in, transparent formulas in the middle, auditable outputs at the end, and every output feeding the next sheet in the chain.
Practical Worked Numbers From the Workbook’s Methodology
To fix the methodology in the reader’s mind, consider a short chain of worked numbers that mirrors the workbook style. Start with a raw meal whose clinker-basis analysis gives SiO2 equal 21.5 percent, Al2O3 equal 5.3 percent, Fe2O3 equal 3.4 percent, and CaO equal 65.8 percent. The LSF is 65.8 divided by the sum of 2.8 times 21.5, so 60.2, plus 1.18 times 5.3, so 6.25, plus 0.65 times 3.4, so 2.21, giving a denominator of 68.66 and an LSF of 95.8 percent, an entirely sensible value for an ordinary Portland cement clinker. The silica modulus is 21.5 divided by 8.7, or 2.47, and the alumina modulus is 5.3 divided by 3.4, or 1.56, both inside the normal design window, indicating a burnable mix with a reasonable liquid phase.
Now carry this mix through the burning stage. Suppose the plant confirms a thermal consumption of 3.35 gigajoules per ton of clinker on an LHV basis using coal with an LHV of 26 megajoules per kilogram, so the coal rate is 3.35 divided by 26, roughly 129 kilograms of coal equivalent per ton of clinker. The heat balance table splits that input into the theoretical clinker formation heat of 1.78 gigajoules per ton, the sensible heat recovered in the preheater, the losses of the shell, gas, and cooler, and the reconciled residual. From the raw meal ratio, the plant knows it feeds about 1.55 tons of raw mix per ton of clinker, and the number reconciles with the measured carbonate expansion figures in the quality control sheet, closing the mass balance.
Move now to the finish mill. A two-compartment mill with a first-chamber internal volume of 32 cubic meters and a second-chamber volume of 26 cubic meters, both at a filling degree of 0.28 with a settled bulk density of 4.55 tons per cubic meter, carries a total charge of 32 plus 26, so 58 cubic meters, times 4.55, times 0.28, which equals about 73.9 tons. At 600 grams of media consumed per ton of cement on a 2.4-million-ton year, the plant buys 1,440 tons of balls annually, and the figure reconciles in the media ledger against the theoretical charge so the accountant can tell whether the mill is actually grinding or silently converting power into heat. Finally, the separator fan moves 120 cubic meters per second through an inlet of 7 square meters at 70 percent of rated density; the inlet velocity is about 17 meters per second, and with a measured Euler number of 4.5 the pressure drop is half times 4.5 times the density times velocity squared, a manageable figure, and the power line follows.
These numbers are illustrative, but every one of them flows from a formula in this article and is recomputable in the corresponding workbook cell. That transparency, the ability to check any number by hand and reproduce it in the sheet, is precisely what the cementequipment.org collection promises and delivers.
The Library Family at a Glance
The chart that follows summarizes how the cementequipment.org library’s tool families map onto the plant process and the sections of this article. Reading the table from the raw material entry at the top through dispatch at the bottom, each family’s workbook answers one question, and the column on the right shows which core formula carries the calculation.
| Process Area | Workbook Family | Key Question Answered | Core Formula |
|---|---|---|---|
| Quarry & Raw Materials | Raw Mix Design & Quality Control | What material proportions give the target chemistry? | LSF, SM, AM moduli |
| Raw Grinding | Mill Power & Media | How much power and media does raw grinding need? | Charge weight = V × bulk density × filling |
| Burning | Heat & Mass Balance | Where does the fuel energy go? | HHV/LHV input & output terms |
| Gas Cleaning | Cyclone & Separator Design | What pressure drop and efficiency result from this geometry? | Euler number, volumetric flow Q, cut-size model |
| Finish Grinding | Ball Charge Design | What ball grading and load give the target product? | Bulk density, void factor, filling degree |
| All Areas | Formula Sheets | What is the standard relationship used everywhere? | Compiled reference formulas |
| Management | Cost Accounting | What does one ton cost and why? | Fixed/variable split, contribution, variances |
Notice how the same handful of relationships recurs across the whole table: the three moduli that guard the chemistry, the charge weight equation that guards the grinding, the flow and Euler number pair that guard the gas handling, and the heating value pair that guards the burning. The cohesion of the library rests on this parsimony, and the user who masters a small set of master equations effectively masters the entire collection.
Why Legacy Spreadsheet Skills Still Matter
Modern plants increasingly move to control systems, databases, and specialist process software, yet the humble spreadsheet remains the lingua franca of the cement engineering office. Spreadsheets audit easily, adapt instantly, run on every machine, and carry no license alarms. The legacy .xls format, in particular, opens in every modern office suite and in free alternatives, so a file purchased a decade ago still works today, which is a genuine advantage for a technical library whose value lies in long-term reference use. The formula-bar transparency of these workbooks means there is no black box: an auditor can open the sheet, read every equation, and verify every assumption, which is the highest standard of engineering documentation.
For the student, working through these files is a masterclass in applied engineering practice; for the veteran, they are a checklist and a source of comparison; and for the plant manager, they are the bridge between the control room data and the boardroom budget. The skill of reading, modifying, and building transparent calculation sheets is unlikely to fade, because every serious engineering decision still needs to be defended with numbers that can be inspected. This library, and the small administrative workbook that carries the site’s name, is built to teach exactly that craft.
Frequently Asked Questions
What is inside the cementequipment.org workbook?
It is a compact Excel workbook (0.03 MB) that demonstrates the calculation methodology and sheet layout conventions used across the whole Cement Equipment Technical Library. It contains worked examples of the three-zone layout, input, calculation, and output, and it introduces the core formula families of raw mix design, heat and mass balance, ball charge, and cyclone design so new users learn the library’s logic quickly.
Why is the file so small?
The file is small because it is a method demonstration and training tool rather than a data warehouse. Its purpose is to teach the calculation culture of the library in a file the user can fully explore in minutes. The larger specialized workbooks in the same package contain the full engineering depth of each discipline.
Can I trust the formulas in the library’s spreadsheets?
Yes, and better than most proprietary tools, because the formulas are visible in the formula bar and can be inspected, checked against the formula sheets, and reconciled with the mass and heat balances. The library is built on published engineering relationships such as the LSF, silica and alumina moduli, the charge weight equation, the Euler number, and LHV-based heat balance, all of which are industry-standard and auditable.
Do I need special software to run an old .xls file?
No. The legacy .xls format opens in current versions of Microsoft Excel, in the free LibreOffice and OpenOffice suites, and in web-based spreadsheet applications. This is one of the advantages of the format for a long-lived reference library.
How do the raw mix, heat balance, ball charge, and cyclone sheets relate to one another?
They are fragments of one plant-wide model. Raw mix design fixes the chemistry, heat balance fixes the fuel and gas temperatures, cyclone design fixes the gas handling pressure and power, and ball charge design fixes the grinding power and media. The outputs of one sheet feed the inputs of the next, culminating in the cost ledger, and the integration is what makes the calculations trustworthy.
Is LSF the same as a lime saturation factor used in cement standards?
Yes. LSF, the lime saturation factor or lime saturation ratio, compares the actual lime content with the lime required to saturate the silica, alumina, and iron oxides, and the canonical form with the coefficients 2.8, 1.18, and 0.65 is used throughout the industry on a clinker or kiln feed basis. It is one of the three classical control moduli together with the silica modulus and the alumina modulus.
Summary
The cementequipment.org workbook is the doorway to the Complete Cement Technical Package. This article has explained its role as the method demonstration of a 931-file library, walked through the family structure of the collection, and examined each major discipline in turn: raw mix design with the LSF, silica modulus, and alumina modulus; heat balance with the HHV and LHV framework and the full inventory of input and output terms; ball charge design with the charge weight equal to volume times bulk density times filling degree; cyclone design with the volumetric flow, Euler number, and collection efficiency model; and the formula sheets that keep every calculation consistent. It has shown a chain of worked numbers that any engineer can reproduce.
The deeper lesson is integration: the small file teaches the user to see the whole plant as one connected calculation, from the quarry chemistry to the mill charge to the fan power to the cost of a ton of cement. For the engineer new to the industry, this workbook is the fastest route to professional fluency; for the veteran, it is a compact reminder of how the trade’s mathematics hang together; and for any user of the package, it is the orienteering map that makes the other 930 files immediately understandable. That is why this name, cementequipment.org, opens the library, and why learning the spreadsheet craft it teaches pays off across a whole career.
Get this cement file + the full 931-file package
$249.99 — one-time purchase, instant download, lifetime access
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.
