Download this ready-to-use Excel sheet for calculating the quantity of bricks and mortar required for any type of brickwork. Simply input wall dimensions, and the sheet will estimate the number of bricks, volume of mortar, and material requirements with accuracy. This tool is perfect for civil engineers, contractors, and students for fast and reliable estimations on-site or during planning.
What This Excel Sheet Calculates
- Total number of bricks required, based on wall length, height, and thickness
- Volume of mortar needed for bed joints and vertical (perpend) joints
- Quantity of cement and sand required for the selected mortar mix ratio
- Adjustment for brick size or format (standard, modular, or custom dimensions)
- Wastage allowance for broken or cut bricks during construction
- Deduction for openings such as doors and windows, where dimensions are entered
Design Inputs Required
- Wall length, height, and thickness
- Brick dimensions (length x width x height) and unit type
- Mortar joint thickness, typically around 10 mm
- Mortar mix ratio, such as 1:4 or 1:6 cement to sand
- Percentage wastage or breakage allowance
- Area and number of openings to be deducted, if applicable
Applicable Design Codes
Brick quantity takeoff is a measurement and estimation exercise rather than a structural design check, so it is not governed by a single design code in the way a beam or column calculation would be. Estimators commonly follow brick and mortar volume conventions consistent with codes of practice such as IS 2212 (Code of Practice for Brickwork) in the Indian subcontinent, alongside locally accepted wastage allowances. Where the brickwork itself carries structural load, the wall design should be separately checked against a masonry design code such as IS 1905 or ACI 530/TMS 402, which this sheet does not cover.
Who Should Use This Tool
This sheet is intended for civil engineers, quantity surveyors, contractors, and site supervisors who need a quick and repeatable material estimate before ordering bricks, cement, and sand. It is also useful for students learning quantity takeoff methods and for anyone preparing a preliminary cost estimate for brickwork before detailed billing of quantities is finalised.
Download the Free Brick Quantity Sheet
The free Excel sheet lets you enter wall dimensions, brick size, and mortar mix ratio to get an instant estimate of brick count, mortar volume, and cement-sand quantities. It is set up as a simple input-output worksheet, so no macros or add-ins are required. Use it for early-stage quantity estimates, material ordering, or as a cross-check against a detailed bill of quantities. As with any takeoff tool, always verify results against site conditions, actual brick sizes supplied, and local wastage practice before finalising procurement quantities.
Be the first to comment.