Pathnovo Logo
Free Template

Piping BOQ Template (Excel)

Free piping Bill of Quantities template for EPC tender pricing and progress billing. Item-rate format with supply, fabrication, erection, testing, and painting columns. Or let Pathnovo auto-build it from your drawings and rate library.

In short

A piping BOQ is the priced material and work schedule used for tender evaluation, contract award, and progress billing on EPC piping scope. Unlike the piping MTO (quantity only), the BOQ adds composite rates per unit covering supply, fabrication, erection, testing, and painting. The template supports both Indian PSU item-rate format and FIDIC composite-rate format.

Template Fields

Item Number

Item Description

Specification Reference (PMS Class)

Material of Construction

Nominal Size (NB)

Schedule / Wall Thickness

Code (ASME B31.3 / B31.1 / B31.4 / B31.8 / EN 13480)

Unit of Measurement (M / EA / KG)

Estimated Quantity

Supply Rate (Material)

Fabrication Rate (Shop)

Erection Rate (Site)

Testing and NDE Rate

Painting and Insulation Rate

Composite Item Rate

Total Amount (Composite Rate x Quantity)

Source Drawing Reference

Vendor / Source Country

Long Lead Flag (Yes / No)

Tender Stage (Pre-bid / Bid / Awarded)

Notes

Frequently Asked Questions

What is a piping BOQ?

A piping BOQ (Bill of Quantities) is the priced material and work schedule used for tender evaluation, contract award, and progress billing on EPC piping scope. Unlike the piping MTO (which is a pure material take-off), the BOQ adds rates for material supply, shop fabrication, site erection, testing / NDE, and painting / insulation, expressed as a composite item rate per unit. The BOQ is the contractual basis for owner-contractor payment and for variation-order pricing throughout construction.

How is a piping BOQ different from a piping MTO?

The piping MTO is a quantity-only document, every pipe length, fitting, flange, valve, gasket, support extracted from isometric drawings, used for procurement and fabrication scope. The piping BOQ takes those same items and adds composite rates per unit (supply + fabrication + erection + testing + painting), grouped into the tender or contract format. MTO is engineering-owned, BOQ is procurement and contracts-owned. On EPC tenders, contractors price the BOQ to bid; on cost-reimbursable contracts, the BOQ becomes the rate schedule for variation orders. See the piping MTO template.

What BOQ format do Indian EPC tenders use?

Indian PSU and government tenders (IOCL, BPCL, HPCL, ONGC, GAIL, NTPC) typically follow item-rate BOQ format aligned to CPWD Schedule of Rates structure: item number, description, specification, unit, quantity, supply rate, erection rate, total rate, total amount. Private-sector and FIDIC-aligned tenders prefer composite rate per item. The template supports both, with separate columns for supply, fabrication, erection, testing, painting, that can be summed to a composite or kept split per Indian PSU practice. Pathnovo's procurement intelligence pillar handles the format conversion automatically.

Can Pathnovo auto-generate piping BOQs from drawings and rate libraries?

Yes. Pathnovo extracts the underlying MTO from issued P&IDs and isometric drawings, then composes the BOQ by joining the MTO to a project rate library (your historical project rates, the CPWD schedule for Indian PSU tenders, or current vendor quotations). The composite item rate per BOQ line is calculated, grouped by spec class for tender packaging, and exported in IS / CPWD / FIDIC format. 48-hour turnaround for the initial draft, with full traceability to source drawing per line. See the piping MTO extraction workflow.

Which codes and standards govern piping BOQ format?

BOQ format itself is not code-governed; it is contract-driven. The underlying material specifications are code-governed: ASME B31.3 (process piping), B31.1 (power piping), B31.4 (liquid pipelines), B31.8 (gas transmission), EN 13480 (European process piping), and IS 1239 / 3589 / 4736 for Indian fabrication. For Indian PSU contracts add IBR-scope flags for power piping above the threshold. The template Code column captures the applicable code per item and drives downstream NDE / PWHT requirements that flow into the testing rate.

How is the BOQ used during construction and billing?

On a unit-rate contract, the BOQ is the payment schedule. The contractor bills against measured installed quantities (per IS 1200 measurement standards on Indian projects, or per FIDIC measurement standards internationally), and the owner's contracts team verifies measurements against site progress. Variations beyond the original BOQ scope are priced using the same item rates, or, for net-new items, negotiated against benchmark rates. Tracking actual vs. BOQ quantity over time is the standard progress-monitoring view; the MTO reconciliation template provides the variance dashboard for this.

See what your documents actually contain.

Send us 10 documents from your current project. We extract, reconcile, and show you exactly what we find in 48 hours, before any contract.

If the accuracy isn't what we promised, you owe us nothing.