DIN 5480 uses ball diameter Dp ≈ 1.8 × m (for 30° PA).
Formula for over-pin measurement for external spline:
For simplicity, many calculators use span measurement over teeth (Mdk) per DIN 5480-1 tables. din 5480 spline calculator excel new
Add lookup tables for:
Use VLOOKUP with fit class and module range. DIN 5480 uses ball diameter Dp ≈ 1
Function SuggestBallDiameter(m As Double) As Double
SuggestBallDiameter = m * 1.728 ' DIN 5480 recommendation
End Function
Open any legacy DIN 5480 spreadsheet found on obscure forums. What do you see? For simplicity, many calculators use span measurement over
A new DIN 5480 spline calculator must solve these legacy problems.