Excel for Construction: Estimates, Takeoffs and Schedules

Excel for construction comes down to three jobs: pricing the work, measuring the materials and planning the days. You build a cost estimate with quantities, unit costs and SUM, turn site measurements into orderable materials with ROUNDUP, and plan schedules in working days with WORKDAY. This guide is for estimators, site engineers, project coordinators and job seekers who want to show these skills in an interview or a skills test.

What is Excel used for in construction?#

Excel is the everyday tool for numbers that don't need a full specialist system. Typical uses are:

• Estimates and bids: line items, quantities, rates and a total with contingency.
• Quantity takeoffs: turning drawing measurements into concrete, drywall, paint or rebar quantities.
• Schedules: start and finish dates in working days, with weekends and holidays skipped.
• Cost tracking: budget against actual cost by cost code.
• Logs: change orders, deliveries, equipment and timesheets.

The formulas are not advanced. What matters is getting units, rounding and dates right every time. The skills overlap with those in Excel skills for engineers and Excel skills for project managers.

How to build a construction cost estimate#

A cost estimate multiplies each quantity by its unit cost, then adds the lines. Set up a table like this in A1:E5:

1. In E2, type =C2*D2 and fill down to E5 (Windows: Ctrl+D; Mac: ⌘D).
2. In E6, add the lines with =SUM(E2:E5). The subtotal is 9,702.
3. Put the contingency rate in its own cell, for example H1 = 10%. In E7, type =E6*$H$1. The result is 970.20.
4. In E8, add them: =E6+E7 gives 10,672.20.

For the quoted price, round the total. =ROUND(E8,2) keeps cents. =ROUNDUP(E8,-2) rounds up to the next hundred: 10,700. A negative number of digits rounds to the left of the decimal point. The SUM function guide and the ROUND function guide cover both functions, and the budget practice lesson drills this whole layout. For a full project budget with actuals and variance, see how to build a project budget in Excel.

How to do a quantity takeoff in Excel#

A takeoff turns measurements into the units suppliers sell. Two rules make it safe: convert units carefully, and always round up, because ordering too little stops work.

Concrete in cubic yards#

Concrete is ordered in cubic yards (or cubic metres). Multiply length, width and depth in feet, then divide by 27, because one cubic yard is 3 × 3 × 3 feet. For a slab 20 ft by 30 ft and 4 inches thick:

=20*30*(4/12)/27

The result is about 7.41 cubic yards. With 5% waste, =ROUNDUP(20*30*(4/12)/27*1.05,0) gives 8. In metric, a 6 m by 9 m slab 0.1 m thick is simply =6*9*0.1, or 5.4 m³.

Drywall in sheets#

For four walls of 14, 12, 14 and 12 feet, all 8 feet high, the wall area is 416 square feet. A 4x8 sheet covers 32 square feet, so you need exactly 13 sheets before waste. With 10% waste:

=ROUNDUP(SUMPRODUCT(B2:B5,C2:C5)/32*1.1,0)

The result is 15 sheets (14.3 rounded up). ROUND would give 14 and leave you short. Subtract doors and windows from the area first on a real job.

When materials come in packs, round up to the pack size with CEILING. If rebar ties come in bags of 50 and you need 430, =CEILING(430,50) gives 450. The guide to Excel's rounding functions compares ROUND, ROUNDUP, ROUNDDOWN and CEILING, and the rounding lesson lets you practise them.

How to schedule construction tasks in working days#

Construction schedules count working days, not calendar days. WORKDAY adds working days to a start date and skips weekends:

=WORKDAY(start_date, days, [holidays])

If B2 holds Monday 2 March 2026 and C2 holds 15 days, =WORKDAY(B2,C2) returns Monday 23 March 2026. If H2:H5 lists site holidays, including Friday 13 March 2026, =WORKDAY(B2,C2,$H$2:$H$5) moves the finish to Tuesday 24 March 2026.

Watch the counting rule. WORKDAY returns the date that is 15 working days after the start. If the start date is day 1 of the work, use =WORKDAY(B2,C2-1), which gives Friday 20 March 2026. To start the next task on the following working day, use =WORKDAY(previous_finish,1).

Two related functions help too:

• =NETWORKDAYS(B2,D2) counts working days between two dates, including both ends. From 2 March to 27 March 2026 it returns 20.
• =WORKDAY.INTL(B2,15,11) treats only Sunday as a day off, for six-day weeks. It returns Thursday 19 March 2026.

Format the results as dates (Home > Number Format > Short Date), or Excel shows serial numbers. The WORKDAY function guide and the article on NETWORKDAYS and WORKDAY go deeper, and you can practise NETWORKDAYS and WORKDAY in a live sheet.

How to track costs against the budget#

Cost tracking adds actual costs by cost code and compares them with the budget. Log every invoice in one table with Date, Cost code, Supplier and Amount. Then, on a summary sheet, use SUMIF:

=SUMIF(Costs!B:B,A2,Costs!D:D)

This adds every amount whose cost code matches the code in A2. Subtract it from the budget to get the variance, and use conditional formatting to color overspent codes. Keep one row per invoice and never type totals by hand.

Tips for construction spreadsheets#

Small habits prevent the most expensive mistakes:

• Put waste factors, rates and contingency in labelled input cells, not inside formulas.
• Write the unit in its own column and in every header, such as Length (ft).
• Use ROUNDUP for materials and ROUND for money. Never only change the number format, because the hidden decimals still add up.
• Lock input cells with absolute references like $H$1 before filling formulas down.
• Set a print area and repeat header rows, so estimates print cleanly for clients.

If you are preparing for a job that uses Excel daily, the operations case study mock test practises this kind of work under time pressure, and the Excel level test shows where to start.

Practise it#

Estimating and scheduling are skills you build by doing. Try the drywall exercise on this page, then practise a full budget in a live spreadsheet, practise ROUND, ROUNDUP and ROUNDDOWN, and practise working-day schedules with WORKDAY. Each step checks your formula instantly, so you learn the rules before they matter on a real job.