Oil & Gas - ASME B31G Remaining Strength & Remaining Life Calculator (Corrosion Fitness-for-Service, Excel Dashboard)

Description
Fitness-for-service screening for a single isolated area of corrosion metal loss, per ASME B31G-2023 Level 1. Runs both the Original B31G and Modified B31G (Kiefner-Vieth) methods side by side, so you see where they agree and where the governing method matters.

Enter pipe geometry, MAOP/operating pressure, pipe grade (or custom SMYS/SMTS), the defect's depth and axial length, an acceptance safety factor, and a corrosion growth rate. The dashboard returns:

• Overall Verdict — ACCEPTABLE or REPAIR, per your chosen governing basis
• Safe Pressure vs. MAOP — with Estimated Repair Factor (ERF)
• Remaining Life — years to end-of-life at your input corrosion rate
• Next Re-Assessment — suggested re-inspection interval (half of remaining life)
  
  

A dedicated Remaining Life sheet gives the year-by-year table and a pressure-vs-time chart. Switch between SI and US customary units — every label and result follows the choice. A Validation sheet reproduces all nine worked examples from ASME B31G-2023 Nonmandatory Appendix A, so you can check the engine against the code's own numbers before you trust it on real data.

Limitations: Level 1 only — one maximum depth and one axial length per anomaly (Level 2/RSTRENG effective-area method is not included; use dedicated software for that). Applies to a single isolated area of internal/external corrosion where internal-pressure hoop stress governs. Not for crack-like defects, gouges, dents, seam/girth-weld selective corrosion, or metal loss under high axial/bending stress (para 1.3) — use API 579-1/ASME FFS-1 for those. Above d/t ≈ 0.80 the methods are outside their validated range. This tool supports preliminary screening only — every disposition and re-inspection interval must be reviewed and signed by a qualified pipeline-integrity engineer against the current code and governing pipeline regulations