Public calculator

Pipe Price Predictor

Estimate pipe supply price by material category using pipe weight, raw steel basis, and coating-based conversion factors.

Indicative estimate only

Inputs

Suggested Raw Material Rate
Ch.Comp / Grade Family -
Indicative Raw Material -
Raw material price range -
Recommended Rs/kg -

Output

Coating factor
OD used -
Weight kg/m -
Total weight kg -
Raw steel Rs/kg -
Normal estimate

Median factor

Your realistic working number for negotiation and planning.

-

Finished Rs/kg
-
Rs/m
-
Total Rs
-
Conservative estimate

P90 factor

Your safety-margin number for budget approval.

-

Finished Rs/kg
-
Rs/m
-
Total Rs
-

Upload Excel BOM

Upload one or more piping BOMs in .xlsx, .xls, or .csv format.

Need the BOM format?

Download the Excel template, complete the pipe details, then upload it below.

Download Excel Template
Supported column names

Size / NPS / DN, Sch/Thck/Rating or Thickness, Quantity or Length, UoM, Coating, Material, Raw Steel Rs/kg, Estimate Factor Override. Schedule text like S-STD, STD, HVY, Heavy, SCH 40, S-80, and 5S is converted to mm.

No BOM uploaded yet.

Multi Size Estimate

Add each pipe size from the input panel to build one combined estimate.

0 lines
Action
No pipe lines added yet.
Total weight -
Normal estimate -
P90 estimate -

Material Category Review

Categories are detected from ASTM piping material specification data. Non-CS estimates use the same factor-based method and are indicative only.

Line check: 0 / 0 0 categories
Show Material Category Review

Upload a BOM or add pipe lines to view category-wise tables.

What-if Analysis

Compare how the estimate changes when raw steel rate, estimate factor, or coating assumption changes.

Budget risk review
Show What-if Analysis
Select cases

0% | Adjusted raw steel: -

Base estimate -
Lowest case -
Highest case -
Risk range -
Biggest cost driver -

Add pipe lines or enter one estimate to view what-if analysis.
No what-if scenarios available yet.

What-if Analysis varies raw steel rate by +/-10% and +/-20%, estimate factor by +/-10% and +/-20%, and coating assumption between Yes and No. Results are indicative and intended for budget risk review.

BOM Group Review

Uploaded BOM items are grouped as Pipe, Fitting, Flange, Valves, Bolt, Gasket, Trap/Strainer, and Other.

0 items
Show BOM Group Review

Upload a BOM to view group-wise item tables.

Audit Trail

Calculation methodology

Weight Method

Pipe mass formula: W = 0.0246615 x (OD - t) x t.

  • W = pipe mass in kg/m.
  • OD = actual outside diameter in mm from the built-in OD table.
  • t = wall thickness in mm entered by the user.
  • Total weight = W x length in meter.

Price Method

  • Raw steel Rs/kg is selected by year unless the user enters Raw Steel Rs/kg Override.
  • Finished Rs/kg = raw steel Rs/kg x estimate factor.
  • Rs/m = finished Rs/kg x pipe kg/m.
  • Total Rs = Rs/m x pipe length.

Factor Method

  • Coating Yes normal factor = 2.30 and P90 factor = 3.80.
  • Coating No normal factor = 1.80 and P90 factor = 2.70.
  • If Estimate Factor Override is entered, it replaces the normal factor.
  • P90 is recalculated using the default P90-to-normal factor ratio.

Material Category Basis

  • Material categories are detected from astm_piping_material_specification_webapp.json.
  • The same factor-based method is used across categories in this version.
  • Validate SS, alloy, duplex, and non-ferrous rates with supplier quotations.

Coating Definition

  • Internal coating means epoxy lined.
  • External coating means PE coated, or polyethylene coated.
  • Select Coating = Yes for internal coating, external coating, or both.

This report is an indicative material supply estimate, not a vendor quotation. Final pricing should be validated against supplier quote, taxes, freight, testing, coating scope, delivery terms, and commercial conditions.

Method Used In This Review Version

Weight is calculated using ASME-style pipe mass formula.

W = 0.0246615 x (OD - t) x t

  • W = pipe mass in kg/m
  • OD = actual outside diameter in mm
  • t = wall thickness in mm

Price is estimated as raw steel price multiplied by the coating-based finished-pipe conversion factor.

If Estimate Factor Override is entered, it replaces the normal estimate factor. The P90 factor is recalculated using the default P90-to-normal factor ratio.

For this calculator, select Coating = Yes when the pipe has internal epoxy lining, external PE coating, or both. Internal coating means epoxy lined. External coating means PE coated, or polyethylene coated.

Median = normal estimate P90 = high-side budget estimate Coating Yes: internal epoxy lined or external PE coated Coating Yes factor: 2.3 / 3.8 Coating No: 1.8 / 2.7 factor