X313 Excel Add-in

Unfortunately this product is not currently available – we apologise for any inconvenience.

Do you enjoy looking up material strengths?

Jump Straight to Download Page

stressed office worker..and how about class pressure ratings ? Followed by interpolations and conversions to get the figures at particular temperatures ? How about trying to make a solution with look-up tables and a few different materials ? Sure it can be done if you’re up for a coding challenge and a little hair-pulling.

This may work well enough on one project, but what about the next job, or the one after that ? Let’s assume that you’re aware of the earlier spreadsheet prepared. You then need to hunt around to find it, and hope that it’s the right version. Next you need to re-purpose just the desired part of that spreadsheet into your new spreadsheet without breaking things. Also you’d better hope there are no mistakes in the previous data (was every cell checked or just a few ?). For any new changes and additions, you need to try and understand the complicated coding in the existing spreadsheet.

happy workers

Now contrast this..

..to the situation where Excel gives you the data you need using one simple formula.

X313 is the Excel add-in that lets you improve the reliability and speed of preparing your piping engineering spreadsheets. You can easily get Code data and do the usual calculations without manually looking up data or using cumbersome tables in your spreadsheets.

view of x313 Excel add-in put to use
Screenshot – click to enlarge

With X313 you get the following functions in your spreadsheets:

  • Allowable stress for any ASME B31.3 Table A-1 material and temperature
  • Class rating for any B16.5 material group and temperature
  • Outer Diameter lookup for B36.10/19 piping
  • Schedule thickness lookup for B36.10/19 piping
  • Pressure thickness calculation to B31.3
  • Minimum thickness accounting for corrosion and mill tolerance
  • Lorenz factor calculation for bends
  • Wall thickness selector that helps you choose the right schedule for a given minimum wall
  • SMYS for any ASME B31.3 Table A-1 material
  • UTS for any ASME B31.3 Table A-1 material
  • Choose between the 2014 and 2016 editions of the Code

Some of these calculations may be pretty basic, but we can tell you we’ve seen them done wrong many times. By having these available as a spreadsheet function, it cuts out the room for error and saves you the hassle of writing the formula.

Video – Get Started Quickly

See how easy it is to quickly get allowable stress and flange rating for different temperatures and lay out a quick pipe spec calculation. This is using the complementary lite version of the add-in.

Video – Get Allowable Stress for any Material in B31.3 Table A-1

How to pick out any piping material in the Table (including the correct size range), do a thickness calc and select the right schedule automatically.


Licenses can be purchased from our online store. A substantial part of the price for each license will go to the American Society of Mechanical Engineers, the publishers of ASME B31.3.

The license includes all updates between B31.3 editions. This does not include an update to the next Code edition. Currently X313 has material data available from both the 2016 and 2014 editions.


We offer a 14-day money back guarantee for X313. Together with the unrestricted 14-day trial this gives you 4 weeks to evaluate the add-in. Should you have difficulties or encounter potential bugs, please contact us to resolve the issue.


Documentation is available here.

Download X313 Download Page

Download your free trial now to get allowable stresses and more directly in your spreadsheets.