Cement Calculation Sheet: Calculations & Excel Sheet

The cement calculation sheet is the laboratory workbook of the cement chemist: the structured worksheet that converts the raw measurements of the chemical analysis (the weights of the residues, the precipitates and the filtrates) into the oxide percentages of the cement, the basis of the quality control, the composition reporting and the process decisions of the plant. The worksheet of this article is a real and formal laboratory document: the cement chemistry calculation sheet of MaRS Enviro Research & Engineering Services Private Limited, carrying the document control number F/CEMCHEM/01, Issue No. 1, and the method reference of the gravimetric analysis of cement according to the Indian Standard IS 4032-1985 (reaffirmed 2009): the standard method that the cement laboratories of the region use for the oxide analysis of the cement and the clinker.

This article rebuilds the complete methodology of the cement calculation sheet: the gravimetric method of the IS 4032-1985 standard, the analysis sequence (the loss on ignition, the silica determination, the R2O3 group, the calcium and the magnesium), the calculation formulas with the worked numbers, the worksheet structure of the MaRS document, the quality control of the analysis and the use of the results in the cement quality management. The Complete Cement Technical Package (931 files: the handbooks, the courses, the Excel tools and the laboratory documents, $249.99 one-time, instant download through the secure PayPal payment) delivers the cement calculation sheet together with the complete library of the cement laboratory and the process tools.

1. The Purpose of the Cement Calculation Sheet

The chemical analysis of the cement is the foundation of the quality control: every property of the cement (the strength, the setting time, the soundness, the durability) traces back to the oxide composition, and the plant laboratory measures the oxides on the routine samples of the production. The calculation sheet of the laboratory converts the analytical measurements into the reported composition, and its discipline carries the quality of the whole chain:

• The oxide composition: the percentages of the silica (SiO2), the alumina (Al2O3), the iron oxide (Fe2O3), the calcium oxide (CaO), the magnesium oxide (MgO), the sulfur trioxide (SO3), the alkalis and the loss on ignition: the composition is the identity card of the cement: the same numbers that the process control uses for the raw mix and the kiln decisions;
• The standard compliance: the cement standards of the world (the IS 4032 of the Indian standard, the EN 196 of the European, the ASTM C114 of the American) prescribe the analysis methods and the calculation requirements: the calculation sheet of the package follows the IS 4032-1985 gravimetric method with the formal document control of the ISO-compliant laboratory;
• The process decisions: the oxide analysis of the clinker and the cement feeds the process decisions of the plant: the Bogue composition computed from the oxides (the C3S, the C2S, the C3A and the C4AF), the free lime checks, the sulfate balance of the cement and the strength correlations: the calculation sheet is the first link of the chain;
• The conformity certificates: the reported oxide composition appears in the test certificates and the conformity documentation of the cement: the calculation sheet with the documented method and the traceable calculations is the evidence base of the certificates;
• The laboratory quality: the formal document control of the sheet (the document number, the issue number, the method reference) is the practice of the accredited laboratories: the ISO 17025-style documentation that the auditors verify.

The cement calculation sheet is therefore the working instrument of the cement chemist: the standard method, the structured worksheet and the traceable calculations that the quality system of the industry demands.

2. The Gravimetric Method of IS 4032-1985

The gravimetric method of the cement analysis determines the oxides by the mass: the sample is dissolved, the components are separated as the precipitates, and the weights of the ignited residues give the oxide percentages. The IS 4032-1985 standard (reaffirmed 2009) prescribes the classical gravimetric procedure for the complete analysis of the cement:

• The sample preparation: the cement sample of the 0.5–1.0 gram, dried and accurately weighed to the 0.1 milligram: the analysis of the separate portions for the different determinations: the balance discipline of the gravimetric method: every percentage point depends on the weight accuracy;
• The dissolution: the sample dissolved in the hydrochloric acid (or the combined acid digestion for the cements with the acid-insoluble residues), the solution evaporated and the silica separated by the double dehydration: the basis of the subsequent determinations;
• The gravimetric sequence: the classical scheme of the analysis: the silica determined first, then the R2O3 group (the alumina and the iron oxide together) precipitated by the ammonia, then the calcium as the oxalate and the magnesium as the pyrophosphate: each step removes the component from the solution and the residues are weighed;
• The ignition: the precipitates filtered, washed, dried and ignited to the constant weight at the prescribed temperatures: the silica at 1,000–1,100°C, the R2O3 at 900–1,000°C, the calcium oxalate converted to the oxide at 950–1,000°C and the magnesium pyrophosphate at 1,100°C: the ignition converts the precipitates into the weighable forms;
• The completeness: the gravimetric scheme of the standard determines the SiO2, the R2O3, the CaO, the MgO and the SO3, with the alkalis and the other minor components determined by the separate methods (the flame photometry, the titrimetry, the spectro-photometry) where the cement type requires.

The gravimetric method is the reference method of the cement analysis: the older and the slower but the most accurate technique, used for the referee analyses, the arbitration of the disputes and the calibration of the modern instrumental methods (the X-ray fluorescence, the ICP).

3. The Loss on Ignition and the Insoluble Residue

The calculation sheet of the cement analysis starts with the two preliminary determinations that frame the composition: the loss on ignition and the acid-insoluble residue:

• The loss on ignition (LOI): the sample of the 1.0 gram ignited at the 950–1,000°C to the constant weight: the LOI = (the loss of the weight / the sample weight) × 100: the LOI of the cement comprises the water of the gypsum, the carbonate decomposition and the organic matter: the typical LOI of the ordinary Portland cement below the 3 percent (the standard limit), with the worked example: the sample of the 1.0032 g losing the 0.0213 g gives the LOI = 0.0213 / 1.0032 × 100 = 2.12 percent: the LOI is the first gate of the cement quality: the high LOI signals the over-grinding temperature damage to the gypsum or the storage issues;
• The acid-insoluble residue: the residue of the sample insoluble in the hydrochloric acid: the silica sand contamination, the unburnt materials: the limit of the ordinary cement at the 1.5–3 percent: the check of the adulteration and the contamination: the residue weighed and reported;
• The calculation logic: the LOI and the insoluble residue are the independent determinations, and the main oxide determinations are corrected to the ignited or the as-received basis depending on the reporting convention of the standard: the calculation sheet of the package carries the basis corrections in the formula cells.

The preliminary determinations of the sheet frame the composition and gate the quality, and their calculation rows demonstrate the pattern that the rest of the sheet follows: the measured weights in, the computed percentages out, the formula visible and the units declared.

4. The Silica Determination and Its Calculation

The silica is the first of the major oxides determined by the gravimetric method, and its calculation is the model of the sheet’s rows. The procedure: the dissolved sample evaporated to dryness, the silica dehydrated by the repeated heating, the residue filtered, washed, ignited at 1,000–1,100°C and weighed as the SiO2:

• The measurement: the weight of the ignited silica residue: the example of the sheet: the sample of the 0.5024 g of the cement with the silica residue of the 0.1023 g: the silica percent = 0.1023 / 0.5024 × 100 = 20.36 percent of the SiO2: the typical range of the ordinary Portland cement at the 17–25 percent;
• The correction: the silica residue carries the small contamination of the alumina and the iron (the co-precipitation), and the refined method recovers the silica by the hydrofluoric acid volatilization: the residue treated with the HF and the sulfuric acid, the volatile silicon fluoride removed, and the remaining weight subtracted from the silica: the correction row of the sheet refines the reported value;
• The second dehydration: the standard prescribes the double dehydration to ensure the complete insolubilization of the silica: the filtrate of the first separation re-evaporated and the second residue added to the first: the completeness of the separation decides the accuracy of all the subsequent determinations;
• The role of the silica: the SiO2 of the cement combines with the lime to form the alite (C3S) and the belite (C2S), the strength-giving phases of the clinker: the silica percentage and the silica modulus of the raw mix (SM = SiO2 / (Al2O3 + Fe2O3), typically the 2.2–2.6) are the process controls that the plant watches daily: the calculation sheet delivers the number that feeds the modules.

The silica row of the sheet demonstrates the complete pattern of the gravimetric calculation: the measured residue weight, the sample weight, the percentage formula and the correction, and the same pattern repeats through the rest of the oxides.

5. The R2O3 Group: The Alumina and the Iron Oxide

The R2O3 determination separates the alumina and the iron oxide together as the ammonia precipitate, and the calculation sheet splits the combined residue into the two oxides with the supplementary determinations:

• The R2O3 precipitate: the filtrate of the silica separation treated with the ammonia (with the ammonium chloride to prevent the magnesium precipitation): the hydrated oxides of the aluminum and the iron precipitate, the residue ignited at the 900–1,000°C and weighed as the combined Al2O3 + Fe2O3: the example of the sheet: the combined residue of the 0.0428 g from the 0.5024 g sample gives the R2O3 = 0.0428 / 0.5024 × 100 = 8.52 percent;
• The iron oxide by the titration: the iron of the combined residue determined by the dichromate or the complexometric titration of the dissolved precipitate: the worked example: the iron found at the 0.0163 g as the Fe2O3: the Fe2O3 percent = 0.0163 / 0.5024 × 100 = 3.24 percent: the typical 2–4.5 percent of the ordinary cement;
• The alumina by the difference: the alumina = the combined R2O3 minus the iron oxide: 8.52 − 3.24 = 5.28 percent of the Al2O3: the difference method of the standard: the alumina of the ordinary cement at the 4–7 percent;
• The roles of the two oxides: the alumina forms the tricalcium aluminate (C3A) of the clinker, the phase that drives the early strength and the sulfate resistance, and the iron oxide forms the tetracalcium aluminoferrite (C4AF): the alumina and the iron together define the alumina modulus of the raw mix (AM = Al2O3 / Fe2O3, the 1.3–1.7 of the ordinary mixes): the numbers of the sheet feed the Bogue calculation of the cement composition.

The R2O3 section of the sheet shows the combined determination and the difference calculation, and the two numbers (the alumina and the iron) enter the modules and the Bogue equations of the quality control together with the silica and the lime.

6. The Calcium Oxide Determination

The calcium is the dominant oxide of the cement (the 60–67 percent of the CaO in the ordinary Portland cement), and its determination carries the highest stake of the analysis: the lime is the balance wheel of the clinker chemistry, and the errors of the calcium propagate through the whole composition:

• The procedure: the filtrate of the R2O3 separation acidified, the calcium precipitated as the oxalate, the precipitate filtered, washed, dissolved and re-precipitated for the purity, then ignited to the calcium oxide at the 950–1,000°C: the example of the sheet: the CaO residue of the 0.3071 g from the 0.5024 g sample gives the CaO = 0.3071 / 0.5024 × 100 = 61.13 percent: the healthy value of the ordinary Portland clinker chemistry;
• The double precipitation: the standard prescribes the double precipitation of the calcium oxalate to separate the calcium from the magnesium and the other cations: the purity of the precipitate decides the accuracy of the lime: the classical rigor of the gravimetric method;
• The lime saturation factor: the CaO feeds the lime saturation factor of the raw mix: LSF = 100 × CaO / (2.8 × SiO2 + 1.2 × Al2O3 + 0.65 × Fe2O3): with the values of the sheet: LSF = 100 × 61.13 / (2.8 × 20.36 + 1.2 × 5.28 + 0.65 × 3.24) = 6,113 / (57.01 + 6.34 + 2.11) = 6,113 / 65.46 = 93.4: the LSF of the 92–98 of the ordinary mixes: the number that the kiln process control watches as the burnability indicator;
• The Bogue composition: the CaO enters the Bogue equations of the clinker phases: the C3S = 4.07 × CaO − 7.6 × SiO2 − 6.72 × Al2O3 − 1.43 × Fe2O3: with the sheet values: 4.07 × 61.13 − 7.6 × 20.36 − 6.72 × 5.28 − 1.43 × 3.24 = 248.8 − 154.7 − 35.5 − 4.6 = 54.0 percent of the C3S: the alite content of the ordinary clinker at the 45–65 percent.

The calcium row of the sheet is the heart of the composition: the measured CaO enters the LSF and the Bogue equations, and the quality control of the kiln and the cement starts from the lime number of the laboratory.

7. The Magnesium and the Sulfur Trioxide

The remaining major determinations of the sheet complete the composition: the magnesium oxide and the sulfur trioxide, the two oxides with the strict quality limits:

• The magnesium oxide: the filtrate of the calcium separation treated with the di-ammonium hydrogen phosphate, the magnesium ammonium phosphate precipitated, ignited to the magnesium pyrophosphate (Mg2P2O7) at the 1,100°C and converted to the MgO: the example: the pyrophosphate residue of the 0.0125 g: the MgO = (0.0125 × 0.3622) / 0.5024 × 100 = 0.90 percent, with the 0.3622 the conversion factor of the Mg2P2O7 to the MgO (the 2 × MgO / Mg2P2O7 = 80.6 / 222.6): the MgO of the ordinary cement limited to the 6 percent maximum by the standards (the soundness limit): the example at the 0.90 percent, the healthy level;
• The sulfur trioxide: the sulfate determined gravimetrically as the barium sulfate: the sample dissolved, the sulfate precipitated by the barium chloride, the barium sulfate ignited and weighed: the SO3 = (the BaSO4 weight × 0.3430) / the sample weight × 100, with the 0.3430 the conversion factor of the BaSO4 to the SO3: the example: the 0.0219 g of the BaSO4 from the 0.5011 g: the SO3 = 0.0219 × 0.3430 / 0.5011 × 100 = 1.50 percent: the SO3 of the ordinary cement in the 2–3.5 percent range of the standards (the limit of the 3.0–3.5 for the ordinary cements): the sulfate balance of the cement controls the setting;
• The setting and the sulfate: the SO3 of the cement from the gypsum added in the finish grinding regulates the setting time: the optimum sulfate of the cement balances the C3A reactivity: the calculation sheet’s SO3 number is the input of the gypsum optimization of the mill;
• The minor components: the alkalis (the Na2O and the K2O), the chloride and the phosphate determined by the supplementary methods where the cement type and the application require: the alkalis of the cement relevant to the alkali-silica reaction of the concrete.

The magnesium and the sulfur rows complete the main composition of the sheet: the seven numbers (the LOI, the SiO2, the Al2O3, the Fe2O3, the CaO, the MgO and the SO3) sum with the minor components to the 100 percent of the cement, and the summation check of the sheet verifies the analysis.

8. The Summation Check and the Quality Control

The completed analysis of the sheet is verified by the summation of the components and the internal checks, the quality control practice of the accredited laboratories. The worked numbers of the example analysis (the sample weights and the residue weights of the article’s sections) assemble into the complete result table of the sheet:

Determination	Measurement	Result (%)	Typical range (%)
Loss on ignition	1.0032 g sample, 0.0213 g loss	2.12	below 3–5
SiO2	0.1023 g residue / 0.5024 g	20.36	17–25
Al2O3	R2O3 0.0428 g minus Fe2O3	5.28	4–7
Fe2O3	titration 0.0163 g	3.24	2–4.5
CaO	0.3071 g residue / 0.5024 g	61.13	60–67
MgO	0.0125 g pyrophosphate × 0.3622	0.90	below 6
SO3	0.0219 g BaSO4 × 0.3430 / 0.5011 g	1.50	2–3.5

• The summation: the total of the determined components with the LOI and the minor oxides should reach the 99.5–100.5 percent of the sample: the worked total of the example: the LOI 2.12 + the SiO2 20.36 + the Al2O3 5.28 + the Fe2O3 3.24 + the CaO 61.13 + the MgO 0.90 + the SO3 1.50 = 94.53 percent: the balance of the 5.5 percent assigned to the undetermined components (the alkalis, the phosphates, the combined water, the small losses): the summation check of the sheet flags the analysis where the missing mass exceeds the expected minor components: the sign of the procedural error;
• The duplicate analysis: the routine practice of the laboratory analyzes the duplicate samples: the reproducibility of the gravimetric method within the 0.1–0.3 percent absolute of the major oxides: the difference of the duplicates beyond the tolerance triggers the repeat: the sheet carries the duplicate columns of the formal worksheet;
• The check samples: the certified reference materials of the cement analyzed with the routine batches: the results of the reference materials verify the method, the reagents and the analyst: the control charts of the laboratory track the drift of the method over the time;
• The control charts: the daily results of the check samples plotted on the control charts with the mean and the control limits: the laboratory quality of the practice: the charts catch the reagent contamination, the balance drift and the procedural slips before they corrupt the production data;
• The traceability: the worksheet with the sample identification, the analyst, the dates, the weights and the calculations is the traceable record of the analysis: the document control of the MaRS sheet (the F/CEMCHEM/01, Issue No. 1) is the model of the formal laboratory documentation that the audits verify.

The quality control section of the sheet closes the loop of the laboratory: the calculations are verified by the summation, the duplicates, the reference materials and the control charts, and the reported composition leaves the laboratory with the evidence of its own reliability.

9. The Results in the Process: The Modules and the Bogue

The oxide composition of the calculation sheet feeds the process control of the plant through the derived numbers: the modules of the raw mix and the Bogue composition of the clinker:

• The lime saturation factor: LSF = 100 × CaO / (2.8 × SiO2 + 1.2 × Al2O3 + 0.65 × Fe2O3): the 92–98 of the ordinary mixes: the LSF above the 100 leaves the free lime in the clinker, and the LSF below the 90 drops the alite and the strength: the kiln operator steers the LSF with the limestone proportion of the raw mix;
• The silica modulus: SM = SiO2 / (Al2O3 + Fe2O3): the 2.2–2.6 of the ordinary mixes: the SM above the 2.7 makes the clinker hard to burn, and the low SM increases the liquid phase and the coating: the modulus balance of the burnability;
• The alumina modulus: AM = Al2O3 / Fe2O3: the 1.3–1.7 of the ordinary mixes: the modulus controls the C3A/C4AF ratio, the liquid phase temperature and the sulfate demand of the cement;
• The Bogue composition: the C3S, the C2S, the C3A and the C4AF of the clinker computed from the oxides: the C3S of the 45–65 percent, the C3A of the 6–12 percent: the phase composition that predicts the strength development, the heat of hydration and the sulfate resistance: the worked Bogue values of the article’s example (the C3S of the 54.0 percent) follow from the CaO row of the sheet;
• The quality decisions: the oxide and the derived numbers drive the daily quality decisions: the free lime checks of the kiln, the gypsum additions of the cement mill, the mix corrections of the raw mill: the calculation sheet of the laboratory is the first instrument of the whole quality chain.

The results-in-process chapter connects the gravimetric worksheet to the plant: the percentages of the sheet become the modules and the phases that the process engineers steer, and the accuracy of the laboratory carries the accuracy of the process control.

10. The Modern Instrumental Methods and the Gravimetric Reference

The modern cement laboratories analyze the routine samples with the instrumental methods, while the gravimetric method of the sheet remains the reference and the calibration base:

• The X-ray fluorescence: the XRF analyzer measures the oxides of the pressed powder samples in the minutes: the standard instrument of the modern plants for the routine raw mix and the clinker control: the XRF results calibrated against the reference samples analyzed by the classical methods: the gravimetric method of the sheet is the calibration base;
• The ICP and the AAS: the inductively coupled plasma and the atomic absorption spectrometers measure the dissolved samples for the minor and the trace elements: the fast and the sensitive instruments of the laboratories with the high workloads;
• The gravimetric role: the classical method of the sheet serves the referee analyses, the arbitration of the disputes and the validation of the instruments: the accredited laboratories maintain the classical capability beside the instruments, and the inter-laboratory comparisons of the industry use the gravimetric results as the reference values;
• The combination in practice: the routine XRF results screened against the periodic gravimetric verifications: the drift of the instrument caught by the classical checks: the calculation sheet of the package documents the reference method that the whole instrumental system leans on;
• The cost and the time: the gravimetric analysis of the complete cement takes the 1–2 days of the classical laboratory work against the 10–20 minutes of the XRF: the two methods serve the two purposes: the speed of the routine control and the accuracy of the reference.

The instrumental chapter places the gravimetric sheet in the modern laboratory: the classical method is no longer the workhorse of the routine analysis, but it remains the standard of truth that the instruments follow, and the calculation sheet of the package documents the reference method completely.

11. The Worksheet Structure of the Document

The calculation sheet of the package follows the formal structure of the MaRS laboratory document (the F/CEMCHEM/01, Issue No. 1), and the structure carries the discipline of the accredited laboratory:

• The document header: the laboratory name, the document number and the issue number, the method reference (the IS 4032-1985, reaffirmed 2009), the sample identification, the date and the analyst: the traceability block of the worksheet;
• The measurement rows: the weights of the samples, the residues and the precipitates with the units and the balance identification: the raw data rows of the sheet: the numbers that the analyst enters and the calculations read;
• The calculation columns: the percentage formulas of each oxide with the conversion factors: the visible formulas of the sheet (the Excel or the worksheet format) that the reviewer checks: the calculation transparency of the method;
• The results block: the computed oxide percentages in the reporting rows: the numbers that enter the certificates and the process reports: the summary of the analysis;
• The verification block: the summation check, the duplicate results, the reference material results and the control chart entries: the quality records of the analysis: the block that the auditors verify.

The worksheet structure of the document is the model of the laboratory practice: the traceable, the transparent and the verifiable analysis record, and the package’s copy of the sheet gives the laboratory the ready format of the cement chemistry calculation.

12. Frequently Asked Questions

What is the gravimetric method of cement analysis?

The gravimetric method determines the oxides of the cement by the mass: the sample is dissolved, the components are separated as the precipitates (the silica by the dehydration, the R2O3 by the ammonia, the calcium as the oxalate, the magnesium as the phosphate, the sulfate as the barium sulfate), and the ignited residue weights give the oxide percentages. The IS 4032-1985 standard prescribes the classical gravimetric scheme, the reference method of the cement analysis.

Why is the loss on ignition of the cement important?

The LOI of the cement comprises the water of the gypsum, the carbonate decomposition and the organic matter: the standards limit the LOI of the ordinary cement (typically below the 3–5 percent depending on the standard) because the high LOI signals the damaged gypsum (the over-grinding heat), the carbonation or the contamination. The LOI is the first quality gate of the cement composition.

How is the lime saturation factor calculated from the oxides?

The LSF = 100 × CaO / (2.8 × SiO2 + 1.2 × Al2O3 + 0.65 × Fe2O3), with the oxides in the percent: the LSF of the ordinary mixes at the 92–98. The worked example of the article (the CaO 61.13, the SiO2 20.36, the Al2O3 5.28 and the Fe2O3 3.24 percent) gives the LSF of the 93.4, the healthy value: the LSF is the burnability indicator that the kiln process control watches.

How does the calculation sheet check its own accuracy?

The sheet verifies the analysis by the summation check (the components summing with the LOI to the 99.5–100.5 percent), the duplicate analyses (the reproducibility within the 0.1–0.3 percent of the major oxides), the certified reference materials analyzed with the batches and the control charts of the laboratory: the quality control block of the worksheet documents all the checks.

Is the gravimetric method still used in the modern laboratories?

Yes, as the reference method: the modern plants analyze the routine samples with the XRF and the ICP instruments in the minutes, but the gravimetric method serves the referee analyses, the arbitration and the calibration of the instruments, and the accredited laboratories maintain the classical capability beside the modern equipment: the gravimetric method of the sheet is the standard of truth of the laboratory system.

Is the cement calculation sheet included in the package?

Yes: the Complete Cement Technical Package (931 files) includes the original cement calculation sheet of the MaRS Enviro laboratory (the F/CEMCHEM/01 document with the IS 4032-1985 gravimetric method), together with the laboratory references, the raw mix design tools, the quality control materials and the complete library of the cement engineer: the purchase below delivers the file and the package.

13. Conclusion

The cement calculation sheet is the laboratory workbook of the cement chemist: the formal worksheet of the gravimetric analysis that converts the measured weights into the oxide composition of the cement, following the IS 4032-1985 standard under the document control of the accredited laboratory. The article rebuilt the complete method: the LOI, the silica, the R2O3, the calcium, the magnesium and the sulfate determinations with the worked numbers (the 20.36 percent SiO2, the 5.28 percent Al2O3, the 61.13 percent CaO of the example), the quality control of the sheet and the use of the results in the LSF, the modules and the Bogue composition of the process control.

The calculation sheet, the laboratory documentation and the complete library of the cement quality and the process tools are part of the Complete Cement Technical Package: the 931 files, the one-time payment of $249.99, the instant download and the lifetime access. The purchase button below delivers the cement calculation sheet and the whole package of the cement laboratory and the production engineer in one download.

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.