Basement Material Estimator

Purpose and model boundary

This calculator estimates the materials to buy for a poured-concrete basement you draw. It covers the concrete for the walls, the footings, the thickened slab edge at a walkout and the slab, by bags or by ready-mix truck. It also covers the rebar in the walls, footings and dowels; the slab reinforcement; the wall and footing forms; the gravel base; the vapour barrier; the perimeter drain pipe; the damp-proofing; the anchor bolts; and the sill plate.

You draw the outline of the basement and mark each wall as concrete or framed. You set the wall height, the concrete sizes and the prices, and the spreadsheet returns the quantities and their costs.

It is an estimate for buying materials, not a structural design. It does not size walls, footings or reinforcement for loads or soil, and it does not price excavation, labour, pumping or finishing. Block (masonry) walls and column pads are outside it.

Inputs and units

The drawing is the first input.

• The outline. It is the outside face of the foundation walls, and every point on it starts one exterior wall.
• Wall kinds. Every exterior wall starts as concrete. Mark any wall framed (a walkout side, for example) with the drawing's Basement menu, the line menu or the C and F keys.
• Interior walls start framed. Mark one concrete to make it a bearing wall.
• Windows, doors and exclusions. Windows and doors are drawn on the walls. Up to five exclusions, such as a sump pit, are left out of the slab.

What the drawing tool measures. From the drawing and the four concrete sizes below, the drawing tool measures each wall's outside, centreline and inside lengths, the slab inside the walls, the footings, the corners and junctions, and the drain line. It writes them to the spreadsheet as six tables. It computes no volume, quantity or cost: the spreadsheet computes every one of those, and checks the tables before it uses them.

Heights.

• One wall height applies to the whole plan: the poured height of every concrete wall, from the top of the footing to the top of the wall. It is set with the drawing's Wall height button.
• Each window's height and sill height, and each door's height, are typed in the tables under the drawing.
• The spreadsheet takes a wall height from 6 to 20 ft (1.80 to 6.00 m). On the page the drawing accepts the heights valid in both unit systems, 6 to about 19.68 ft (1.83 to 6.00 m), so a unit switch never leaves the wall out of range. In the same way it asks for a window at least 1 ft (0.3048 m) and a door at least 5 ft (1.524 m) tall in both systems, so in Metric it refuses a 0.30 m window or a 1.50 m door that the spreadsheet alone would take.

Units. Lengths and heights are in feet under US and metres under Metric. The concrete sizes are in inches under US and millimetres under Metric.

The inputs beside the drawing, by section:

Concrete elements

• Wall thickness: 8 in or 200 mm.
• Footing width: 20 in or 500 mm.
• Footing depth: 10 in or 250 mm.
• Slab thickness: 4 in or 100 mm.
• Whether window and door openings are taken off the walls.

Concrete supply

• Waste: 10%.
• Supply route: bags, ready mix, or compare the two.
• Bags: the bag yield, the bag price and a bag handling limit.
• Ready mix: the price, the ordering step, the minimum order, the truck capacity, and the short-load threshold and fee.

Reinforcement

• Bars: whether the walls carry rebar, one bar size for walls, footings and dowels, the cover, the horizontal and vertical spacings, the continuous bars per footing, the dowels and their length, the lap length, the stock bar length, the rebar waste and the bar price. The bar size is a bar number, #3 to #6, under US, and a bar diameter, 6 to 40 mm, under Metric.
• The slab: mesh sheets, a rebar grid, fibre or none, each with its own sizes and price. The sizes and prices for every slab choice show under their unit system whichever choice is made, and the spreadsheet reads only the chosen one's.

Site and finish

• Forms: the wall and footing form rates.
• Gravel base: its depth, compaction allowance, density and price.
• Vapour barrier: its overlap, roll area and price.
• Drain pipe: its waste, roll length and price.
• Damp-proofing: the depth below grade, the coats, the coverage, and the pail size and price.
• Anchor bolts: their spacing and price.
• Sill plate: its stock length, waste and price.

The prices are editable typical figures, not quotes. Replace them with your supplier's before you rely on a cost.

Governing relationships

The geometry. The spreadsheet reads these figures from the drawing tool's tables:

• the concrete walls' centreline length Lc;
• the exterior concrete walls' centreline length Lext and outside length Oext;
• the footings' length under concrete walls Lft, and under framed exterior walls Lwo (the walkout edge);
• the slab's net area A and inside perimeter;
• the outside corners, inside corners, T-junctions and transitions between concrete and framed walls;
• the drain length.

Each concrete wall is a band one thickness t wide along its centreline. The bands meet at the corners without overlap or gap, so the outline's area less the slab equals t × Lc exactly. The spreadsheet checks this identity against its own wall thickness.

Concrete. H is the wall height, wf and df the footing width and depth, ts the slab thickness.

Walls = Lc × t × H − the openings in concrete walls (width × the height of the opening within the wall × t)

Footings = Lft × wf × df

Walkout edge = Lwo × wf × df: a footing-sized thickened edge below the slab, cast with it

Slab = A × ts

Order volume = (walls + footings + walkout edge + slab) × (1 + waste), in cu yd or m³

Ready mix is ordered per pour: the footings, the walls, and the slab with its walkout edge. Each pour's volume with waste is rounded up to the ordering step, and is never less than the minimum order. It is carried in trucks of the stated capacity, and a pour below the short-load threshold pays the short-load fee once.

Bags are counted on the total order volume: bags = order volume ÷ bag yield, rounded up. Compare recommends bags only when the bags are within the handling limit and cost no more than ready mix.

Rebar. c is the cover, sh and sv the horizontal and vertical spacings, ℓ the lap length and S the stock bar length.

• Horizontal rows: (H − 2 × c) ÷ sh, rounded up, plus 1. Each row runs the concrete wall length.
• Vertical bars: Lc ÷ sv, rounded up, plus one for each open end at a walkout or a T. Each bar is H − 2 × c long.
• Dowels: one per vertical bar, at the dowel length.
• Corner bars: (outside corners + inside corners + T-junctions) × (rows + footing bars), each 2 × ℓ long.
• Footing bars: footing bars × (Lft + Lwo).
• Laps: the continuous runs (rows and footing bars) are multiplied by S ÷ (S − ℓ), since each stock bar covers S − ℓ of the run.
• Stock bars: total length × (1 + rebar waste) ÷ S, rounded up.
• Weight: stock bars × S × the bar's weight per length. A US bar number takes its nominal weight per foot (#4 is 0.668 lb/ft). A metric bar of diameter d mm weighs π/4 × (d/1000)² × 7,850 kg per metre, rounded to the gram (12 mm is 0.888 kg/m).

Slab reinforcement.

• Mesh sheets: A ÷ ((sheet length − overlap) × (sheet width − overlap)), rounded up.
• A rebar grid: 2 × A ÷ bar spacing of bar, added to the stock bars.
• Fibre: dosage × slab volume.

Forms.

• Wall forms: both faces of every concrete wall times the wall height, plus the wall ends at each walkout. Openings are not taken off, since they need bucks.
• Footing forms: both sides of each footing, its ends at each walkout, and the outer face of the walkout edge.

Site and finish.

• Gravel: A × gravel depth × (1 + compaction), in cu yd or m³, times the density, rounded up to whole tons or tonnes.
• Vapour barrier rolls: A × (1 + overlap) ÷ roll area, rounded up.
• Drain pipe rolls: drain length × (1 + waste) ÷ roll length, rounded up. The drain line runs along the footings' outer face beside the concrete exterior walls.
• Damp-proofing: the exterior concrete walls' outside length times the depth below grade, times the coats, divided by the coverage. It gives a volume in gallons or litres, and pails are that volume ÷ the pail size, rounded up.
• Anchor bolts: Lext ÷ spacing, rounded up, plus one at each corner and each walkout end.
• Sill pieces: Lext × (1 + waste) ÷ stock length, rounded up.

Each cost is the quantity bought times its price; the total is their sum.

Every whole count is rounded up after the division is rounded to six decimals, so a figure that is whole on paper stays whole.

Calculation sequence

1. The spreadsheet checks the inputs, then checks the drawing tool's tables against each other and against the drawing it was sent.
2. It reads the lengths, areas and counts from the tables.
3. It computes the concrete volumes, the pours and the bags, and picks or compares the supply route.
4. It counts the rebar, the slab reinforcement, the forms and the finish materials.
5. It prices every line and adds the total.

A worked example. The default basement is 30 by 40 ft, every wall concrete, with the default sizes.

• Walls: the centreline is 352 and 472 in a side, 137.333 ft in all, so the walls are 137.333 × 8/12 × 8 = 732.4 cu ft.
• Footings: 137.333 × 20/12 × 10/12 = 190.7 cu ft.
• Slab: 1,108.44 sq ft × 4/12 = 369.5 cu ft.
• Order: 1,292.7 cu ft net, 52.66 cu yd with 10% waste.
• Ready mix: ordered per pour, 8 + 30 + 15.25 = 53.25 cu yd in 6 trucks.

Outputs and interpretation

The results show:

• The material to buy: the concrete by the chosen route, the bags or ready-mix and trucks, the stock bars, the slab reinforcement, the gravel, the rolls, the pails, the anchor bolts and the sill pieces, with the total cost.
• The concrete by element.
• How the rebar is counted.
• The form, damp-proofing and vapour barrier areas.
• A material list with each line's quantity, unit, unit cost and cost.
• The ready-mix pours.
• The figures read from the drawing.

Validation and status logic

The status shows above the results.

NOT VALID appears when any of the following checks fails. Material quantities and costs read 0, and the material and pour tables are blank below their headings. The geometric areas, including PolygonArea and GrossArea, remain available in the workbook; the page replaces the results with the status message.

• the footing is narrower than the wall;
• an input is out of range;
• the drawing could not be measured;
• the drawing tool's tables are missing, were measured at other sizes, or disagree with the drawing;
• a point of the outline or of an exclusion lacks a coordinate, or the points skip a row.

The spreadsheet checks the drawn points in this order:

1. NOT VALID: every outline point needs both coordinates
2. NOT VALID: every point of exclusion 1 needs both coordinates
3. NOT VALID: every point of exclusion 2 needs both coordinates
4. NOT VALID: every point of exclusion 3 needs both coordinates
5. NOT VALID: every point of exclusion 4 needs both coordinates
6. NOT VALID: every point of exclusion 5 needs both coordinates
7. NOT VALID: outline and exclusion points must fill consecutive rows, with no blank row between them

The page always sends complete points in consecutive rows, so these appear only for a request sent to the spreadsheet directly.

CHECK appears when:

• no wall is marked concrete;
• the bag supply exceeds the handling limit.

Assumptions and limitations

• One size for all. One wall thickness, one footing size and one bar size apply to every concrete wall. Footings are centred under the walls.
• The rebar rules are estimating rules, not a bar schedule:
  • the vertical-bar, corner-bar and anchor counts do not depend on where the outline is split into walls;
  • the mesh count uses the slab's area, not its shape.
• The prices are editable typical figures and the metric ones are conversions of them. They are not supplier quotes.

Restrictions and non-computing states

When the page sends nothing. The page sends nothing while the drawing tool cannot measure the drawing:

• a wall shorter than the wall thickness at its corners;
• walls too thick for the outline;
• an opening that would cut into the concrete at a corner;
• a footing narrower than the wall.

The page says why in the drawing tool's words.

The 3D view. The 3D view draws the walls at floor-plan thickness, not the concrete walls, footings or slab, and computes nothing.

Errors and warnings

The spreadsheet never shows the drawing tool's own sentences. It shows its own status text for each case above.

Sources and further reading

• International Code Council, 2021 International Residential Code, Chapter 4, Foundations, on UpCodes. up.codes. It covers:

  • concrete footings and anchor bolts (Section R403);
  • concrete foundation walls (Section R404);
  • foundation drainage (Section R405);
  • damp-proofing below grade (Section R406).

  The code's tables, not this calculator's estimating rules, size a footing, a wall or its reinforcement.

• International Code Council, 2021 International Residential Code, Chapter 5, Floors, Section R506, Concrete Floors (On Ground), on UpCodes. up.codes. It covers the slab, its base course and its vapour retarder.

• ASTM International, ASTM A615/A615M, Standard Specification for Deformed and Plain Carbon-Steel Bars for Concrete Reinforcement. astm.org. It gives the nominal weights per foot of the US bar numbers #3 to #6 that the bar size takes (#3 0.376, #4 0.668, #5 1.043 and #6 1.502 lb/ft). A metric bar is entered by its diameter d in mm, and its mass per metre is π/4 × d² × 7,850 kg/m³, rounded to the gram.

• National Institute of Standards and Technology, NIST Guide to the SI, Appendix B.8, Factors for Units Listed Alphabetically. nist.gov. It gives the exact conversion factors (foot, square foot, cubic foot and cubic yard).

• Eric W. Weisstein, "Polygon Area," MathWorld, Wolfram Research. mathworld.wolfram.com. The shoelace formula is behind the gross, exclusion and slab areas.

What the defaults are.

• Sizes: the wall thickness, footing and slab defaults are typical residential sizes.
• Bag yield: 0.6 cu ft for an 80 lb bag, the figure the Concrete Volume and Bags calculator uses.
• Prices: every price is an editable assumption with no published source.
• Rules: the rebar, form, gravel, drain, damp-proofing, anchor and sill rules are estimating rules, not code requirements.

These sources describe the code text, the bar weights, the units and the geometry; they certify no particular result.