Din 5480 Spline Calculator Excel Verified 💎 ⭐

The calculator supports all major parameters defined in DIN 5480:

If you have access to MITcalc or Hexagon’s Gear Designer, input identical parameters and compare results. Differences > 0.01 mm indicate formula errors (often mismatched pressure angle rad/deg or incorrect involute function).

Several reputable engineering sources offer verified versions:

Warning: Many free downloads claim “verified” but only check against one example. A truly verified tool includes a verification sheet showing 10+ test cases.

For measuring over 2 pins (external spline):

=MROUND( (B2*COS(RADIANS(20)))/(COS(RADIANS(ASIN( (B2*COS(RADIANS(20)))/(B2+C3) )))) + D3, 0.001)

Where C3 = pin diameter selection from table

The calculator must output the data required for manufacturing and inspection:

You cannot trust an Excel file just because someone shared it. Use these three verification methods: