Pathnovo Logo
Free Template

Piping MTO Template (Excel)

Free piping material take-off template for EPC projects and fabrication shops. Or let Pathnovo auto-generate MTOs from your isometric drawings.

Template Fields

What goes into a piping material take-off Excel sheet, the 20 columns required for an EPC piping MTO covering pipe, fittings, flanges, valves, gaskets, supports, and insulation.

Line Number

Isometric Reference

Sheet Number

Item Type (Pipe / Fitting / Flange / Valve / Gasket / Support)

Pipe Size (NB)

Schedule / Wall Thickness

End Preparation (PE / BE / TE)

Material Grade (ASTM / ASME / EN / IS)

Specification Class (Piping Material Class)

Fitting Description

Quantity

Unit (EA / M / KG)

Unit Weight

Total Weight

Insulation Code

Service Fluid

Design Pressure

Design Temperature

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

Notes

Piping Material Take-Off Excel Sheet What It Captures

A piping material take-off Excel sheet is the source of truth for piping procurement and fabrication scope. Below is what an EPC-grade piping material take-off Excel sheet captures per line, by line group, and as derived output for downstream workflows.

Per-line piping totals

Every line number gets its own row group: pipe cut lengths summed by size and schedule, fitting count by type and end preparation, flange count by face rating and bolting, gasket count by material, valve count by type and PMS class, support count, insulation length, and applicable code per ASME B31.3 / B31.1 / B31.4 / B31.8 / EN 13480.

PMS class grouping for procurement

Line groupings roll up by Piping Material Specification (PMS) class so procurement can issue per-class Material Requisitions (MRs) to vendors. Spec breaks are captured at the line level so PMS-A1A pipe is never mixed with PMS-A2A pipe in the same RFQ. See the material requisition template for the MR format.

Code-driven NDE and PWHT requirements

The Code column drives downstream requirements: ASME B31.3 Normal service triggers 10 percent random RT, Category D drops to visual, Severe Cyclic escalates to 100 percent RT. B31.1 (power piping) and IBR-scoped lines escalate further. The piping material take-off Excel sheet captures the Code column per line so the fabrication shop and inspection team have the basis for NDE planning before procurement even closes.

Insulation and tracing captured per line

Insulation code (H1 / H2 / cold service), thickness, jacketing material, and tracing type (steam, electric, none) all live in dedicated columns. This means the insulation contractor can MTO independently from the same source, and the heat-tracing scope feeds straight into the electrical MTO without a parallel takeoff exercise.

Weld schedule and cutting list output

From the populated piping material take-off Excel sheet, the fabrication shop derives the weld schedule (one weld per fitting-to-pipe interface, sized and code-tagged) and the cutting list (pipe cut lengths optimised against stock-length availability). Pathnovo exports both as Excel sub-tabs or as PCF / IDF for direct ingestion into shop ERP systems (Larsen & Toubro LFMS, Bentley AutoPIPE, Intergraph SmartPipe).

Frequently Asked Questions

What is a piping MTO template?

A piping MTO (Material Take-Off) template is a structured spreadsheet for recording every piping component extracted from isometric drawings: pipe cut lengths, fittings (elbow, tee, reducer, cap, cross), flanges (with face rating and bolting), gaskets, studs / nuts, valves, supports, insulation. Per-line grouping with specification and material data per ASME B31.3 (process piping), B31.1 (power), B31.4 (liquid pipelines), or B31.8 (gas transmission). The basis for procurement RFQs, fabrication shop cutting lists, and weld schedule generation.

Can Pathnovo auto-generate piping MTOs from scanned isometrics?

Yes, this is a blue-ocean workflow with zero software competitors globally. Pathnovo extracts piping MTO data from any isometric format including scanned hand-drawn drawings from the 1980s, PDF exports, ISOGEN outputs, and photographed drawings. AVEVA ERM and Hexagon Smart Materials work only from 3D models; Pathnovo works from 2D isometrics where no 3D model exists. 99.5% contractual accuracy, 48-hour turnaround. See the MTO from isometric workflow.

What file formats does the template work with?

Excel (.xlsx) primary format. Export variants to CSV (for ERP import), JSON (for API integration), PCF / IDF (ISOGEN / PDS / Intergraph SmartPipe fabrication shop formats). Fabrication shop ERP integration (Larsen & Toubro LFMS, Bentley AutoPIPE, Intergraph SmartPipe, L&T Fabcon) supported via direct format export. See the piping fabrication industry page.

How does this template support ASME B31.3 vs B31.1 requirements?

The Code column captures applicable code per line (B31.3 Normal / Category D / Severe Cyclic service, B31.1 for power piping, B31.4 for liquid pipelines, B31.8 for gas transmission, EN 13480 for European process piping). NDE requirements (RT / UT / MT / PT percentage), PWHT requirements (from ASME B31.3 Table 331.1.1), and code-specific material restrictions all flow from the Code designation. For IBR-scoped piping, an additional IBR-scope column flags Chief Inspector of Boilers stamping requirements; see the IBR compliance workflow.

How do I integrate this MTO into procurement RFQ workflow?

Populated MTO feeds directly into Material Requisition (MR) package assembly; Pathnovo offers this as a managed service via the procurement intelligence pillar. For vendor RFQ workflow, the MTO data groups by specification class (PMS) and material type for efficient vendor packaging. Downstream cost estimation, procurement approval, and vendor PO generation all reference the MTO as the authoritative scope document.

Does the template support revamp and brownfield projects?

Yes. For revamp projects where existing / modified / new scope coexists on the same isometric, an additional Scope column flags each MTO line as 'existing', 'modified', 'new-installed', or 'demolish'. This prevents over-ordering (procurement team orders only new material) and clarifies fabrication scope (fabrication team knows what is field-welded to existing pipework). Particularly valuable for Indian PSU refinery revamps (IOCL / BPCL / HPCL brownfield projects).

How do I prepare a piping material take-off Excel sheet from isometric drawings?

Manual process: open each isometric, identify line number and applicable piping material spec class (PMS), then walk the drawing item by item. For pipe, sum the cut lengths between fittings to get total length per size and grade. For fittings, count each elbow, tee, reducer, cap, and cross by size and end preparation (BW butt-weld, SW socket-weld, TE threaded). For flanges, capture face rating (RF / RTJ / FF), bolt pattern, and gasket type. For valves, gaskets, supports, and insulation, capture per-line totals. Transcribe into the Excel template by line, group by PMS class for procurement packaging. Typical effort: 3 to 6 hours per isometric for a trained piping engineer, longer for scanned or hand-drawn legacy isometrics. Automated alternative: Pathnovo extracts the same piping material take-off Excel sheet from scanned isometrics in 48 hours at 99.5% measured accuracy with no 3D model required. See the MTO from isometric workflow.

What is the difference between a piping MTO and a piping BOQ?

The piping MTO (material take-off) is quantity-only, every pipe length, fitting, flange, valve, gasket, support extracted from isometric drawings, used by engineering and procurement to define the scope of material to be purchased and fabricated. The piping BOQ (Bill of Quantities) takes those same items and adds composite rates per unit (supply + fabrication + erection + testing + painting), used by procurement and contracts for tender pricing, contract award, and progress billing. 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 BOQ template for the BOQ format.

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.