Quickly determine the correct ASME B16.5 flange class using this Excel-based tool. Built-in stress tables, temperature interpolation, and auto pass/fail logic help you size flanges accurately—fast.

Stop flipping through three code books. This Excel workbook instantly recommends the minimum ASME B16.5 flange class for any piping material, design pressure and temperature. 

🔧 What it does
• Pulls allowable stresses from ASME B31.3 & Section ASME II-D tables (editable).
• Interpolates stress at your exact temperature.
• Runs Appendix A equations to find ceiling pressure Pc for each class.
• Flags PASS/FAIL and suggests the first class that meets P_design. 

🛠️ Why you’ll use it
• 2-minute sanity check before you open PV Elite or CAESAR II.
• Perfect for junior engineers learning flange ratings.

📦 What you get
•  XLSX file (no broken references).


Edition data: B16.5-2017, B31.3-2018, II-D-2019 (tables unlocked so you can update to the latest year).