Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesConstruction & EngineeringEstimates & BidsMaterial Takeoff Sheet

SpreadsheetEstimates & BidsFree

Material Takeoff Sheet

Quantities from drawings with waste factors, order quantities rounded up, material costs with tax and delivery, order status, and totals by area and supplier.

Shown with sample data

Colour

Material Takeoff Sheet

Quantities from drawings with waste factors, order quantities rounded up, material costs with tax and delivery, order status, and totals by area and supplier.

Materials total
$24,319
Including tax and delivery
Still to order
$5,291
Lines to order
4
Waste allowance
$1,397
Material cost by area
  • Roof$8,097.7634%
  • Walls$5,994.3625%
  • Foundation$5,014.9921%
  • Interior$4,761.5020%
Cost by material
  • Roof trusses$5,392.80
  • 2x6 studs 8 ft$3,559.25
  • Ready-mix concrete 4000 psi$2,824.80
  • Drywall 1/2" 4x8$2,265.19
  • Architectural shingles$2,114.32
  • Batt insulation R-21$2,110.04
  • OSB sheathing 7/16"$1,905.46
  • Rebar #4 (20 ft)$1,808.84

How to use it

  1. 1Measure each material from the drawings and note the sheet reference.
  2. 2Set a waste factor that suits the material (5% for concrete, 10% for framing and sheathing, 12 to 15% for drywall and tile).
  3. 3Set tax and delivery on the Settings sheet.
  4. 4Use By supplier to place orders, and update Status as materials are ordered and delivered.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Turn drawings into an order list. For each material, record the area, drawing reference, measured quantity, unit, waste factor and unit cost; the sheet rounds the order quantity up, prices it and tracks whether it is still to order, ordered or delivered. Sales tax and delivery from the Settings sheet give a true total, and summaries by area and supplier feed your estimate and purchase orders.

Who it’s for

  • Estimating new builds and extensions
  • Building purchase orders by supplier
  • Checking material budgets during the job

What’s included

  • Takeoff sheet: Measured quantities, order quantities and costs.
  • By area sheet: Material cost for each area of the build.
  • By supplier sheet: What to order from each supplier.
  • Settings sheet: Tax and delivery.

How to use it

  1. 1Measure each material from the drawings and note the sheet reference.
  2. 2Set a waste factor that suits the material (5% for concrete, 10% for framing and sheathing, 12 to 15% for drywall and tile).
  3. 3Set tax and delivery on the Settings sheet.
  4. 4Use By supplier to place orders, and update Status as materials are ordered and delivered.

Tips

  • Have someone else check the biggest quantities against the drawings: a missed decimal is expensive.
  • Round order quantities to supplier pack sizes before ordering.

Questions

How is the order quantity worked out?

Measured quantity × (1 + waste factor), rounded up to a whole unit.

How is tax applied?

The tax rate on the Settings sheet is added to every line's material cost.

Related searchesmaterial takeoffquantity takeoffconstruction estimatebill of materialsmaterial listpurchasing

Details

Format
Spreadsheet
Category
Estimates & Bids
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetEstimates & BidsFree

Material Takeoff Sheet

Quantities from drawings with waste factors, order quantities rounded up, material costs with tax and delivery, order status, and totals by area and supplier.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Estimates & Bids
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More estimates & bids templates

View all
Construction Cost Estimate3 sheets

Direct cost

$66,665

Bid price

$86,091

Margin in bid

14%

ABCD
1TradeItemQtyUnit
2Site prepExcavation & grading1lump sum
3ConcreteSlab foundation 4"1,200sq ft
4FramingWall framing1,850sq ft
5RoofingAsphalt shingles1,400sq ft
Estimate
SpreadsheetEstimates & Bids

Construction Cost Estimate

Itemised estimate by trade with quantities, unit rates, markup and contingency.

10 min setupPreview
Job Cost Tracker2 sheets

Budget

$621,000

Forecast at completion

$617,356

Projected over (−) or under budget

$3,644

ABCD
1DescriptionCategoryBudgetCommitted
2Site supervisionOverheads$48,000$48,000
3Excavation and groundworksSubcontractors$62,000$64,500
4Concrete: labourLabour$38,000$0.00
5Concrete: materialsMaterials$54,000$51,000
Job costs
SpreadsheetEstimates & Bids

Job Cost Tracker

Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.

10 min setupPreview
Bid Comparison Sheet2 sheets

Packages

4

Awarded

1

Best bids vs budget

$1,800

ABCD
1PackageBidderBase bidExclusions to add
2ElectricalBright Spark Ltd$48,500$0.00
3ElectricalVolt Masters$44,200$3,800
4ElectricalBudget Electric$39,900$2,500
5PlumbingFlowRight$36,400$0.00
Bids
SpreadsheetEstimates & Bids

Bid Comparison Sheet

Level subcontractor bids by adding back exclusions and alternates, check insurance, licence and references, rank qualified bidders, and compare the best bid with your budget for each package.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ