Refractory Brick Calculator: Kiln Excel Tool

The brick calculator workbook of cementequipment.org is the complete spreadsheet instrument for the refractory campaign of the cement kiln: it computes the bricks per ring, the rings per zone and the total quantity of the whole lining from the kiln diameter, the zone lengths and the brick sizes, and it carries the allowance lines, the weight and the cost conversions and the campaign summary that the plant’s maintenance department needs to order, budget and execute a full relining. The second edition of the calculator, the subject of this article, is the practical companion to the first edition’s theory: it walks the user through the workbook sheet by sheet, adds the calculation depth for the multi-zone kilns, the special shapes, the castable quantities and the installation planning, and documents the worked examples that the engineer verifies before entering the plant’s own data.

The Complete Cement Technical Package (931 files including the brick calculator spreadsheet of cementequipment.org and its companion version, engineering tools, books, courses and presentations, $249.99 one-time, instant download) includes the calculator workbook with its input and output sheets for the kiln diameter, the zone scheme, the brick dimensions, the allowances and the campaign summary. This article walks the complete workbook: the sheet structure, the input conventions, the ring calculation sheet, the zone quantity sheet, the special shapes and the castables, the allowances and the joints, the weight and the cost sheet, the installation planning sheet, the worked example of the full kiln, the verification and the QC, the common mistakes, the link to the kiln inspections and the campaign management practice.

1. The Structure of the Brick Calculator Workbook

The brick calculator workbook is organized as a chain of sheets that mirrors the campaign planning sequence: the user enters the kiln data once, and every downstream sheet reads the same inputs, so the quantities, the weights and the costs always agree. The sheet structure is the following.

• The Kiln Data sheet: the shell internal diameter, the zone boundaries and the zone lengths, the single source of the kiln geometry for the whole workbook;
• The Brick Data sheet: the brick types of the scheme with their face widths, thicknesses, lengths, tapers, densities and prices, the library of the campaign;
• The Ring Calculation sheet: the bricks per ring computed zone by zone from the lined diameters and the brick pitches;
• The Zone Quantity sheet: the rings per zone from the zone lengths, the zone quantities and the running totals along the kiln;
• The Allowances sheet: the expansion joints, the cardboard, the mortar, the special shapes and the loss allowance of the campaign;
• The Weight and Cost sheet: the tonne weight, the pallet count and the brick cost of every zone and of the campaign total;
• The Castables sheet: the castable and the precast quantities of the non-brick areas, the inlet, the nose ring and the kiln hood;
• The Campaign Summary sheet: the order list by the zone and the brick type, the weight, the pallets and the totals, ready for the purchasing;
• The Worked Example sheet: the demonstration of the full method on the standard kiln, the verification of the calculator against the hand calculation;

The workbook uses the shaded cells for the inputs and the protected cells for the calculations, and the notes column documents the basis of every figure. The discipline of the workbook is the single-entry principle: the kiln diameter and the zone lengths are entered once in the Kiln Data sheet, and the ring and the quantity sheets read them, so the user cannot corrupt the calculation by entering the same number twice in two places.

2. The Kiln Data Sheet: The Geometry of the Campaign

The Kiln Data sheet defines the campaign’s geometry: the shell internal diameter, the zone scheme and the zone lengths, plus the lining thickness of each zone. The sheet is organized as a table with one row per zone, and the columns carry the zone name, the zone start and end positions along the kiln, the zone length, the shell diameter at the zone (the shell tapers at the inlet and the outlet), and the lining thickness of the zone.

Illustrative Kiln Data sheet entries for the 5,000 t/d kiln

Zone	Start	End	Length	Shell diameter	Lining thickness
Kiln inlet and preheating	0 m	22 m	22 m	4.80 m	150 mm
Calcining zone	22 m	38 m	16 m	4.80 m	180 mm
Lower transition zone	38 m	47 m	9 m	4.80 m	200 mm
Burning zone	47 m	61 m	14 m	4.80 m	220 mm
Upper transition zone	61 m	70 m	9 m	4.80 m	200 mm
Kiln outlet and nose ring	70 m	74 m	4 m	4.80 m	150 mm + castable

The zone scheme of the sheet is the scheme of the plant’s refractory practice, and the lining thicknesses follow the thermal duty of the zones: the burning zone carries the thickest lining for the highest temperature and the longest life, and the preheating zone the thinnest because its duty is the moderate temperature with the high abrasion. The sheet computes the lined diameter of every zone automatically, and the Ring Calculation sheet reads the lined diameters directly.

3. The Brick Data Sheet: The Library of the Campaign

The Brick Data sheet holds the library of the brick types that the campaign uses: one row per brick type with the dimensions, the taper, the density, the price and the supplier. The dimensions follow the industry standard conventions: the length along the kiln axis, the inner and the outer face widths, the thickness and the wedge taper, expressed as the width difference over the thickness or the ratio of the face widths.

• The combination wedge: the burning zone brick with the matched taper, laid dry with the thin joints, the mortarless ring standard;
• The standard wedge: the transition zone brick laid with the thin mortar or the dry joints, with the moderate taper;
• The universal wedge: the calcining zone brick with the standard taper family, laid with the mortar;
• The abrasion-resistant brick: the preheating zone brick with the dense matrix for the chain and the dust abrasion;
• The special shapes: the nose ring blocks, the dam bricks and the anchor shapes, ordered by the piece count;
• The castables and the precast: the inlet castable, the nose castable and the precast segments, ordered by the tonne and the piece;

The price column of the sheet carries the delivered price per tonne, and the density column the bulk density, so the Weight and Cost sheet converts the brick counts into the tonnes and the currency. The sheet’s taper column is the verification data of the Ring Calculation sheet: the calculator checks that the selected brick’s taper matches the kiln’s radius ratio, and the mismatch is flagged before the order is placed.

4. The Ring Calculation Sheet: The Bricks per Ring Zone by Zone

The Ring Calculation sheet is the heart of the workbook: it computes the number of bricks per ring for every zone from the lined diameter, the brick inner face width and the joint allowance. The calculation follows the geometry of the circle: the ring’s inner circumference is pi times the lined diameter, and each brick with its joint occupies its pitch of the circumference, so the ring count is the circumference over the pitch.

N ring = pi x D lined / (W inner + j)

The sheet carries the calculation in the table form with the columns: the zone, the lined diameter, the brick type, the inner face width, the joint allowance, the computed ring count, the practical ring count (rounded to the whole brick) and the closure residual. The practical ring count is the number that the bricklayer lays, and the closure residual is the arc that the closure brick absorbs.

Illustrative Ring Calculation sheet for the example kiln

Zone	Lined diameter	Brick inner face	Joint	Ring count
Preheating zone	4.50 m	100 mm	2.5 mm	137.7 → 138
Calcining zone	4.44 m	101 mm	2.5 mm	134.7 → 135
Lower transition	4.40 m	102 mm	2.0 mm	132.5 → 133
Burning zone	4.36 m	103 mm	1.5 mm	130.4 → 130
Upper transition	4.40 m	102 mm	2.0 mm	132.5 → 133

The sheet also computes the taper check: the ratio of the inner to the outer radius of the lining compared with the ratio of the inner to the outer face width of the brick, with the flag column that marks the accepted and the marginal tapers. The burning zone example of the first edition article, with the combination wedge matched to the 4.36 m lined diameter, passes the check, and the ring count of 130 bricks per ring carries into the Zone Quantity sheet.

5. The Zone Quantity Sheet: From the Rings to the Zone Totals

The Zone Quantity sheet multiplies the ring counts by the rings per zone: the rings per zone are the zone length over the brick length plus the axial joint, and the zone quantity is the ring count times the rings per zone. The sheet carries the running total along the kiln, so the engineer sees the cumulative quantity building from the inlet to the outlet and the zone order of the delivery.

N rings = L zone / (L brick + j axial)

Q zone = N rings x N ring

For the example kiln: the preheating zone of 22 m with the 200 mm brick at the 2 mm axial joint gives 109 rings at 138 bricks per ring, about 15,042 bricks; the calcining zone of 16 m gives 79 rings at 135, about 10,665; the lower transition of 9 m gives 45 rings at 133, about 5,985; the burning zone of 14 m gives 70 rings at 130, about 9,100; and the upper transition of 9 m gives 45 rings at 133, about 5,985, for the kiln total of about 46,777 bricks before the allowances.

• The ring pitch: the brick length plus the axial joint, the effective pitch of the rings along the kiln, typically 200–203 mm;
• The zone rounding: the rings per zone rounded up to the whole ring, because a partial ring is a full ring in the ordering;
• The running total: the cumulative quantity along the kiln, the basis of the staged delivery and the zone sequence of the installation;
• The zone subtotals: the quantity per brick type, because the order is placed per type and the delivery pallets are labeled per zone;

The Zone Quantity sheet is the central output of the workbook: it is the number that the purchasing orders, the quantity that the transport moves and the base of the cost. The sheet also records the zone life expectations from the plant’s history, so the campaign planning sees the quantities and the lives together.

6. The Allowances Sheet: The Joints, the Losses and the Special Shapes

The Allowances sheet completes the campaign quantity with the lines that the pure geometry omits: the expansion allowance materials, the mortar and the cardboard, the loss allowance for the breakage, and the special shapes that the ring math does not cover. The sheet’s lines follow the campaign practice of the industry.

• The expansion cardboard: the 1–3 mm boards inserted at the calculated positions, ordered in the rolls and the sheets with the areas from the ring and the axial joint counts;
• The mortar: the 1–2 kg per brick of the refractory mortar for the mortar-laid zones, and the thin-joint mortar for the burning zone if the scheme uses it;
• The loss allowance: the 2–5% of the brick quantity for the transport, the handling and the installation breakage, applied zone by zone with the higher rates on the basic bricks;
• The closing and the cut bricks: the allowance of the cut pieces for the ring closures and the special positions, included in the loss line or ordered as the half bricks;
• The sealants and the anchors: the refractory sealants for the joints at the shell and the anchor hardware of the castable areas;

The allowance lines are small in the quantity and large in the campaign success: the campaign that runs short of the cardboard or the mortar improvises, and the improvisation is where the quality is lost. The sheet’s totals add the allowances to the zone quantities, and the Campaign Summary sheet presents the complete order.

7. The Castables and the Special Shapes Sheet

The non-brick areas of the kiln system are calculated in the Castables sheet: the kiln inlet and the outlet sections, the nose ring, the kiln hood and the preheater sections use the castables and the precast shapes, and their quantities follow from the surface areas and the lining thicknesses rather than the ring geometry.

Q castable = A surface x t lining x (1 + loss)

where A surface is the area of the lined surface and t lining the castable thickness. The sheet carries the items with their areas, thicknesses and densities, and converts the volumes into the tonnes of the castable and the pieces of the precast shapes.

• The kiln inlet: the inlet cone and the feed pipe lined with the abrasion-resistant castable, with the anchors at the standard spacing;
• The nose ring: the discharge end of the kiln with the castable segments and the blocks, the highest-wear area of the kiln ends;
• The kiln hood: the hood sides and the roof with the precast shapes and the castables, with the expansion joints at the panel boundaries;
• The preheater areas: the cyclone cones and the riser duct sections with the wear castables, calculated from the measured areas of the drawings;
• The anchors: the stainless anchors of the castable areas, counted at the standard grid of 200–300 mm and ordered with the castable;

The castable sheet is often the difference between the complete order and the emergency procurement during the shutdown, and the workbook’s itemized approach ensures that the inlet, the nose and the hood are in the campaign from the start. The same sheet records the mixing and the curing requirements of the castables, because the installation of the castables has its own QC that the brick campaign does not share.

8. The Weight and Cost Sheet: The Tonnes, the Pallets and the Budget

The Weight and Cost sheet converts the campaign quantities into the logistics and the money: the weight of every zone from the brick count and the brick mass, the pallet count from the packaging, and the cost from the prices of the Brick Data sheet. The sheet is the bridge between the engineering quantity and the purchasing budget.

Illustrative Weight and Cost summary of the example campaign

Item	Quantity	Weight	Price	Cost
Burning zone bricks	9,100 pcs	122 t	$1,200/t	$146,400
Transition zone bricks	11,970 pcs	152 t	$950/t	$144,400
Calcining zone bricks	10,665 pcs	127 t	$700/t	$88,900
Preheating zone bricks	15,042 pcs	168 t	$550/t	$92,400
Loss allowance and cut	1,400 pcs	17 t	Mixed	$14,100
Castables and shapes	38 t	38 t	$850/t	$32,300
Mortar, cardboard, anchors	Lump	—	Lump	$21,500
Campaign total	—	~624 t	—	$540,000

The campaign cost of the example, about $540,000 for the bricks and the materials of the full kiln, sits inside the industry range of $400,000–$800,000 for a large kiln relining, and the installation labor and the downtime value add on top: the total cost of a kiln relining event, including the production lost during the 10–14 day shutdown, typically reaches several million dollars. The sheet’s totals feed the maintenance budget and the financial model’s refractory line, and the comparison of the alternative schemes on the same sheet is the basis of the brick selection decisions.

9. The Installation Planning Sheet: The Crew, the Time and the Sequence

The Installation Planning sheet of the workbook converts the quantities into the plan of the relining: the crew size, the installation rates, the zone sequence and the shutdown duration. The sheet carries the standard installation rates of the industry: 2–4 rings per shift per crew in the kiln, with the burning zone combination wedges installed at the higher rates and the mortar-laid zones at the lower.

• The crew structure: the bricklayers, the helpers, the brick carriers and the riggers, typically 15–30 people for the full kiln relining;
• The installation rate: the rings per shift, 2–4 for the dry-laid combination wedges and 1.5–3 for the mortar-laid standard wedges;
• The zone sequence: the installation from the kiln outlet toward the inlet in the modern practice, so the burning zone is finished first and the kiln can rotate the remaining zones;
• The kiln rotation during the lining: the kiln rotated for each ring or after every few rings to bring the working point to the bottom, the method that determines the ring-laying speed;
• The work platforms: the scaffolding and the platforms of the preheater and the hood areas, planned in the sheet with their access and their lifting;

The shutdown duration follows from the quantities and the rates: the example campaign of 46,800 bricks at an average of 2.5 rings per shift with three shifts per day and two crews totals about 140 rings of the kiln, and the brick installation completes in 9–12 days including the kiln rotation time, with the castables and the drying added. The sheet compares the plan with the plant’s shutdown budget, and the mismatch is resolved before the kiln stops, not during the stop.

10. The Worked Example Sheet: The Verification of the Calculator

The Worked Example sheet of the workbook demonstrates the complete calculation on the standard 5,000 t/d kiln with the zone scheme of this article, so the user verifies the calculator against the hand calculation before entering the plant’s own data. The sheet follows the sequence: the kiln data, the ring counts, the zone quantities, the allowances and the summary, with the formulas visible and the intermediate numbers documented.

• The verification inputs: the shell diameter of 4.8 m, the zone lengths of the example scheme and the standard brick dimensions;
• The hand calculation: the ring count of 130 for the burning zone from the lined diameter of 4.36 m and the 103 mm brick with the 1.5 mm joint;
• The calculator output: the same 130, confirming the tool’s geometry; the comparison line reports the match;
• The full campaign: the 46,800 bricks, the 624 tonnes and the $540,000 of the summary, the numbers that this article reproduces;
• The sensitivity: the sheet shows the effect of the changes: the lining thickness, the brick width and the joint variations on the ring count and the total;

The verification discipline is the quality gate of the tool: a calculator that is not verified against the hand math is a source of the silent errors, and the worked example sheet of the workbook removes that risk. The engineer who enters the plant’s data after the verification trusts the output, and the campaign order is placed on the verified numbers.

11. The Verification and the QC of the Relining: The Calculator’s Feedback

The brick calculator’s role does not end at the order: the same numbers are the QC basis of the relining execution. The ring count from the calculator is the check of every ring laid, the zone quantity is the check of the consumption, and the comparison of the actual usage with the calculated quantity at the end of the campaign is the audit of both the calculation and the installation.

• The ring check: the bricklayer’s ring count compared with the calculator’s count, the first quality gate of every ring;
• The consumption check: the zone consumption tracked against the zone quantity, with the deviations investigated before they compound;
• The closure check: the closure brick of each ring cut to the calculator’s residual arc, preventing the forced closures that crack the ring;
• The joint check: the joint widths and the cardboard positions verified against the allowances sheet, the protection of the expansion behavior;
• The campaign audit: the actual consumption versus the calculated quantity plus the loss allowance, the feedback that improves the next campaign’s numbers;

The QC of the relining is the discipline that turns the good bricks into the good lining: the calculator provides the numbers, and the foreman and the engineers enforce the checks. The package’s refractory installation workbooks carry the detailed QC procedures, and the brick calculator is the quantitative base that they reference.

12. The Drying and the Heating-Up of the New Lining

The new lining must be dried and heated up before the kiln returns to the production, and the campaign planning includes the heating schedule that the brick types demand. The basic bricks are sensitive to the hydration and the steam damage during the first heating, the castables must be cured and dried per their manufacturer’s schedule, and the expansion of the lining must be released gradually so the ring joints close uniformly without the shell overheating.

• The castable cure: the 24–48 hours of the initial cure before the drying starts, per the castable manufacturer’s instructions;
• The drying schedule: the staged temperature rise with the holding periods at the evaporation points, typically 100–150°C and 300–400°C;
• The basic brick heating: the slow rise through the hydration range of the magnesia bricks, 100–300°C, with the ventilation of the steam;
• The total heating time: the 2–5 days from the cold kiln to the operating temperature, depending on the scheme and the kiln size;
• The shell monitoring: the shell temperature scan during the heating, the verification that the expansion is releasing and the joints are closing;

The heating-up is the final act of the relining campaign, and its schedule belongs in the campaign plan that the calculator’s installation sheet summarizes: the shutdown duration includes the heating time, and the production restart date is the sum of the relining and the heating. The kiln that is heated properly enters its campaign with the lining sound; the kiln that is rushed into the production pays with the shell hot spots and the shortened brick life.

13. The Refractory Life and the Campaign Economics

The brick quantity is one side of the campaign economics; the brick life is the other. The burning zone of a modern kiln with the good coating control runs 8–14 months between the relinings, the transition zones 12–24 months and the rest of the kiln several years, and the economics of the campaign are the cost per tonne of clinker produced over the lining’s life.

Refractory cost per tonne = Campaign cost / (Production rate x Operating days x Life days)

For the example campaign of $540,000 with the burning zone life of 12 months at 5,000 t/d, the burning zone share of the campaign cost against the 1.8 million tonnes of the clinker produced during the life gives a refractory cost of roughly $0.20–$0.30 per tonne of clinker, inside the industry range of $0.20–$0.60 per tonne. The calculator’s cost sheet provides the campaign number, and the plant’s life records provide the life, and the ratio is the management figure of the refractory performance.

• The life extension: the coating control, the stable kiln operation and the shell monitoring extend the burning zone life and reduce the per-tonne cost;
• The zone staging: the relining of the zones at their different lives rather than the full kiln at the burning zone’s life, the practice of the staged campaigns;
• The opportunity cost: the downtime of the relining at $150,000–$500,000 per day of the lost production, the reason the planned campaigns protect the availability;
• The benchmark: the refractory cost per tonne compared with the industry range, the gauge of the plant’s refractory management;

The campaign economics close the loop that the brick calculator opens: the quantity is ordered, the cost is budgeted, the life is managed and the per-tonne figure is benchmarked, and the whole cycle repeats with the improved knowledge. The workbook provides the quantitative spine of the cycle.

14. The Link to the Kiln Inspection and the Refractory Monitoring Tools

The brick calculator works together with the kiln inspection and the monitoring tools of the package: the shell temperature scanning, the kiln inspection reports and the refractory wear assessment feed the decisions of which zones to reline and when, and the calculator converts those decisions into the quantities and the orders. The sequence of the refractory management runs: the inspection identifies the wear, the wear assessment estimates the remaining life, the relining decision sets the zone scope, and the calculator orders the scope.

• The shell temperature scan: the thermal imaging of the kiln shell that reveals the hot spots and the lining thinning, the daily monitoring of the refractory condition;
• The inspection data: the visual and the measured inspection during the short stops, the zone-by-zone record of the lining condition;
• The wear model: the remaining life estimate from the shell temperature trends and the brick wear rates, the basis of the relining schedule;
• The lining chart: the record of the brick types, the installation dates and the lives of every zone, the historical base of the planning;
• The campaign decision: the scope of the next relining from the wear data, converted into the order by the calculator;

The integration is the strength of the package: the tools are built to be used together, and the refractory discipline of the plant runs from the shell scan through the wear assessment to the brick order without leaving the same data family. The engineer who works the full chain plans the campaigns on the evidence rather than the calendar.

15. The Common Mistakes in the Campaign Planning

The classic mistakes of the campaign planning are the ones that the workbook’s structure prevents. The first is the incomplete scope: the order covers the kiln bricks but forgets the castables, the special shapes, the mortar and the cardboard, and the shutdown discovers the omissions on the second day of the relining. The second is the quantity optimism: the order is placed at the exact calculated quantity without the loss allowance, and the breakage during the erection leaves the burning zone short with the kiln stopped.

• The delivery fragmentation: the order split across the suppliers without the zone-by-zone allocation, and the wrong bricks arriving at the wrong time;
• The storage damage: the bricks stored unprotected and the basic bricks hydrated, discovered at the ring when the installation cannot use them;
• The sequence error: the delivery sequence that does not match the installation sequence, and the material double-handled through the congested kiln area;
• The heating neglect: the heating schedule not planned in the shutdown timeline, and the kiln restarting with the damaged lining;
• The history blindness: the quantities ordered without the comparison with the previous campaign’s actual consumption, repeating the old errors;

The workbook’s checks are the complete-order checklist, the allowance lines, the zone delivery sequence and the campaign audit column, and the engineer who uses them plans the campaign that starts on time and finishes without the emergencies. The campaign planning discipline is the discipline of the whole package: measure, calculate, verify and execute.

16. Frequently Asked Questions

What sheets does the brick calculator workbook contain?

The workbook contains the Kiln Data sheet, the Brick Data sheet, the Ring Calculation sheet, the Zone Quantity sheet, the Allowances sheet, the Castables and Special Shapes sheet, the Weight and Cost sheet, the Installation Planning sheet, the Campaign Summary and the Worked Example sheet, structured as the chain of the campaign planning.

How does the calculator handle the different zones of the kiln?

The zone scheme is entered in the Kiln Data sheet with the zone lengths and the lining thicknesses, the lined diameter of each zone is computed automatically, and the Ring Calculation sheet computes the ring count per zone on its own lined diameter and brick pitch, so the burning zone and the preheating zone are calculated on their true geometry.

What is included in the campaign total beyond the bricks?

The campaign total includes the bricks of all the zones, the 2–5% loss allowance, the castables and the precast shapes of the inlet, the nose and the hood, the mortar, the expansion cardboard, the anchors and the sealants, converted into the weight, the pallets and the cost.

How long does the installation of the example campaign take?

The example campaign of about 140 rings with two crews at three shifts per day installs in 9–12 days, followed by the castable curing and the 2–5 day heating-up schedule, and the full shutdown duration is planned in the Installation Planning sheet.

What is the normal cost of a full kiln brick campaign?

A full kiln relining of a 5,000 t/d line costs approximately $400,000–$800,000 for the bricks and the materials, plus the installation labor and the value of the 10–14 day production loss, for a total event cost of several million dollars.

How is the calculator verified?

The Worked Example sheet reproduces the full hand calculation on a standard kiln, and the verification compares the sheet’s ring counts and totals with the manual math, so the user enters the plant’s data only after the tool is confirmed correct.

17. Conclusion and Summary

The brick calculator workbook of cementequipment.org is the complete campaign instrument: the kiln geometry is entered once, the ring counts follow from the lined diameters and the brick pitches, the zone quantities from the ring counts and the zone lengths, the allowances and the special shapes complete the order, and the weight, the cost and the installation plan close the campaign’s economics. The worked example verifies the tool, and the QC and the audit loops feed the next campaign.

The calculator is part of the Complete Cement Technical Package’s refractory toolkit, working with the kiln inspections, the shell monitoring, the lining charts and the installation procedures that the package provides, and it feeds the financial model’s refractory cost lines. The engineer who plans the campaign with the complete order, the verified quantities and the staged delivery protects the kiln’s availability, and the availability is the largest value of the refractory discipline: the right bricks, the right count, the right time, computed before the kiln stops.

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.