Calculator Excel New — Din 5480 Spline

Click Calculate: Press the "Calculate Spline" button.

Results:

Sheet1 – Input & Output

Sheet2 – Lookups

Sheet3 – Inv function solver (optional)

Key formulas (Excel syntax):

' Reference diameter
= B4 * B5
' Base diameter
= (B4 * B5) * COS(RADIANS(30))
' Root diameter – external spline
= (B4 * B5) - 2 * B4 * (1.25 - B6)
' Tip diameter – external spline
= (B4 * B5) + 2 * B4 * B6 din 5480 spline calculator excel new
' Max space width (internal, fit H)
' Simplified from DIN 5480 Table 10:
= (PI() * B4 / 2) + (2 * B4 * B6 * TAN(RADIANS(30))) + (0.018 * B4 ^ 0.5)

Tolerance adjustments – Use VLOOKUP on a hidden Tolerances table: Click Calculate: Press the "Calculate Spline" button

| Fit Class | Deviation (µm) for m=1..2 | Formula factor | |-----------|----------------------------|----------------| | 5H | +15 / +35 | 1.00 | | 6H | +25 / +50 | 1.25 | | 7H | +40 / +75 | 1.60 | | 8H | +60 / +110 | 2.00 | | 9H | +90 / +160 | 2.50 |

An automotive Tier-1 supplier recently replaced their legacy DIN 5480 sheet (15 years old) with a new Excel tool having live pin measurement output.