ASME B31G Remaining Strength & Remaining Life Calculator — Pipeline Corrosion FFS (Excel)

Description
Validated before you trust it: the built-in Validation sheet reproduces all 9 worked examples in ASME B31G-2023 Nonmandatory Appendix A, so you can check the engine against the code's own numbers.
Screen a single isolated metal-loss defect per ASME B31G-2023 Level 1. Original and Modified B31G (Kiefner-Vieth) run side by side, so you see which method governs.
Inputs: pipe OD and wall, MAOP, grade (or custom SMYS/SMTS), defect depth and axial length, safety factor, corrosion rate.
One dashboard returns:
• Overall verdict — ACCEPTABLE or REPAIR
• Safe pressure vs MAOP, with Estimated Repair Factor (ERF)
• Remaining life in years at your corrosion rate
• Suggested re-assessment interval
Plus a year-by-year remaining-life table with a pressure-vs-time chart, and a one-click SI/US unit toggle. Native Excel formulas, no macros, nothing hidden.
How to use:
1. Choose SI or US customary units.
2. Enter pipe and operating data, then the anomaly's maximum depth and axial length from your ILI or UT report.
3. Set the acceptance safety factor and corrosion growth rate.
4. Read the four verdict cards, then open the Remaining Life sheet for the year-by-year table and chart you can paste into a report.
Typical use: quick pass/fail on ILI or UT findings, remaining-life numbers for turnaround and budget planning, and checking contractor assessments.
Scope: Level 1 only (no RSTRENG effective-area). Not for cracks, dents, gouges, weld-seam corrosion or d/t above 0.80. Preliminary screening — dispositions must be signed off by a qualified integrity engineer. Not affiliated with or endorsed by ASME.