Index lookup · WPU101706
Producer Price Index for steel pipe and tube across grades, broader than WPU10170674 (Steel Pipe and Tube, Stainless Steel) since it covers carbon and alloy pipe together with stainless. Index base: June 1982 = 100.
Latest value is 1 month old. Next update expected around Sep 2026.
Free, no account needed. Nothing you enter here leaves your browser.
Enter a base value, a current value, and a contract amount to see the adjustment.
Strongest average month-over-month move historically: April (+1.7% avg).
Oil and gas pipeline and general plumbing supply contracts that buy a mix of pipe grades use this blended series, while a contract buying stainless pipe specifically should name the stainless-only series instead since the two grades do not price identically.
A starting point citing this series by name and code. Replace the bracketed terms with your contract's actual scope before use.
The [affected portion] of the Contract Price shall be adjusted using US PPI — Steel Pipe and Tube (BLS series WPU101706), published by BLS. Base Period: the index value published for August 2026 (or the month of contract signing, if different) is the Base Value. Adjustment: at each Adjustment Date, the Current Value is the most recently published three-month average of the index (the Averaging Window). The Escalation Factor equals Current Value divided by Base Value. Cap: the Escalation Factor applied under this clause shall not exceed 1.10 or fall below 0.90 (a 10% cap and floor) in any single Adjustment Date, regardless of the index's actual movement. [Replace bracketed terms with your contract's actual affected-portion definition and adjustment-date schedule before use. This is a drafting starting point, not legal advice.]
Want this in a spreadsheet instead? Use =ESCALAKE("wpu101706") in Google Sheets →
Free. One email per new value, unsubscribe anytime, no account needed.
Compare the current value of BLS series WPU101706 (Steel Pipe and Tube) to its value at contract signing, turn that into a ratio, and apply the ratio to the steel pipe-affected line items. A usable clause also names an averaging window, a publication-lag rule, and a cap.
Read more →Escalake tracks US PPI — Steel Pipe and Tube, applies your formula, and gives both sides a number they can confirm, no spreadsheet required.
We use cookies to run Escalake and to understand site traffic. Choose Accept Minimum for essential cookies plus anonymous visit counting only, or Accept All to also let us link activity to your account. Read our Cookie Policy and Privacy Policy.