Plumbing Takeoff in Excel: Fixtures, Pipes, Fittings and Cost

Plumbing takeoff gets lost in detail: toilets, basins and showers, pipes in different sizes for supply and drain, fittings that are hard to count, and valves and labour. When it is all added up loosely, differences between two offers appear for no clear reason.

This sheet organises the work by zone (bathrooms, kitchen, laundry, garden): enter each fixture count and each pipe length, set unit prices and drain units in the two rows above the table, and the sheet totals materials, then adds waste, fittings, valves, labour and contingency to give the cost of each zone.

Who is it for?

• Plumbing contractors and mechanical engineers
• Quantity surveyors and estimators
• Owners reviewing plumbing offers
• Site supervisors ordering materials

What is inside the sheet?

• A 12-zone table with seven fixture types and four pipe sizes
• Two editable rows for unit prices and drain units
• Fixture and pipe cost per zone and in total
• Settings: fittings, valves, labour, waste and contingency
• Cards: fixtures, pipe metres, drain units and total
• A cost breakdown with data bars and a chart per zone
• A guide

How to use it

1. Edit fixture and pipe prices and drain units at the top of the table.
2. For each zone enter fixture counts and pipe lengths.
3. Set the fittings share, labour and contingency.
4. Read the total, the breakdown and the cost per zone.

Formulas used

• Fixture cost = Σ (count × unit price)
• Pipe cost = Σ (length × price per m) × (1 + waste)
• Fittings = pipe cost × share
• Valves and labour = fixtures × (valves × price + labour) + pipe metres × labour per metre
• Drain units = Σ (count × DFU)

Worked example from the sheet itself

Seven zones: three bathrooms, a guest WC, kitchen, laundry and garden with roof, totalling 25 fixtures and 191 m of pipe (82 m supply 20 mm, 29 m supply 25 mm, 30 m drain 110 mm and 50 m drain 50 mm).

• Drain units are 63.
• Breakdown: fixtures 4,465, pipes with waste 2,734, fittings 957, valves and labour 6,271 and contingency 721.
• Total is 15,148, about 606 per fixture.

Why split by zone

Because one bathroom cost repeats, knowing it lets you price an extra bathroom or change a layout. The example shows the master bathroom costs about 2,570 while garden and roof pipes alone cost 640.

Drain fixture units

Each fixture has a drain unit count (DFU) that sets drain pipe size under the plumbing code. The values in the sheet are examples, so replace them with your code, and the total stays an indicator of drainage network size.

Fittings and connections

It is hard to count every elbow, tee and coupling at takeoff stage, so they are estimated as a share of pipe cost (35% in the example). If you have a detailed drawing, replace the share with your own count.

Limits of the sheet

It excludes tanks, pumps, water heaters and insulated hot pipes. Use the water tank sheet for pump and motor, and add water heaters as fixtures with their price.

Tips for best results

• Take lengths from the drawing after separating supply from drain.
• Ask for an itemised offer for each pipe type.
• Keep contingency at 5 to 10%.
• Record each price source and date.

Frequently asked questions

Can I add a fixture type?

Rename one of the columns with its price and units; the table holds seven types.

Is labour per fixture or per metre?

Both: labour per fixture and labour per pipe metre.

Does it work for a large building?

Yes, add zones by floor.

Does it include gas?

No, sanitary plumbing only.

Download the sheet

Press the download button at the top of the page to get the Excel file. It includes a full guide sheet, yellow input cells and formulas protected from accidental edits. The sheet is also available in Arabic from the language switcher.

A quantity estimate; prices and drain units are editable examples.