Schaeffler Diagram Calculator Excel Jun 2026

: Helps avoid hot cracking by ensuring a small amount of ferrite (typically 5–10%) is present in austenitic welds.

If you want to download a pre-built spreadsheet, there are several trusted community files available:

Too much ferrite leads to embrittlement. Too much austenite (or too little ferrite) leads to hot cracking. The Schaeffler diagram helps you land in the "sweet spot"—typically 5-20% ferrite for crack-resistant austenitic welds. Schaeffler Diagram Calculator Excel

Let’s run a real case through our hypothetical Excel calculator.

You do not need expensive metallurgy software. Here is a step-by-step guide to creating a functional calculator. : Helps avoid hot cracking by ensuring a

The final weld metal composition is a weighted average of the base metal(s) and the filler metal, taking into account (the percentage of base metal melted into the weld).

No tool is perfect. As an engineer, you must understand the boundaries of the Schaeffler diagram. The Schaeffler diagram helps you land in the

| Phase boundary | Cr_eq | Ni_eq | |----------------------|-------|-------| | A (Austenite start) | 0,8 | 10,20 | | F (Ferrite start) | 18,0 | 26,12 | | M (Martensite) | 14,4 | 20,10 | | A+F boundary | etc. | |