Din 5480 Spline Calculator Excel Verified May 2026

Key Deep Features for DIN 5480 Calculator

1. Core Parameters to Calculate

• Module (m) from 0.5 to 10
• Number of teeth (z)
• Reference diameter (d = m × z)
• Pitch diameter (d₂)
• Root diameter (dᵢ)
• Tip diameter (dₐₑ)
• Form diameter (dₓₑ)
• Space width (e) and tooth thickness (s)

1. Enable Macros – The iterative solver requires VBA. Go to Excel Options → Trust Center → Enable all macros (or digitally sign your sheet).
2. Input Protection – Lock cells to avoid accidental deletion of formulas.
3. Unit check – Ensure all inputs are in mm (not inches) and angles in degrees.
4. Save as .xlsm – to retain VBA code.

• Module (m) – from 0.5 to 10 mm.
• Number of teeth (z) – typically 6 to 100+.
• Reference diameter (d) – m × z.
• Profile shift coefficient (x) – can be positive or negative.
• Base diameter (d_b) – d × cos(α), with standard α = 30° or 37.5°.
• Major diameter (d_a) and minor diameter (d_f).

• d = m * z
• D = d + 2 * m
• d1 = d - 2 * m
• s = m * (π / 2 - 2 * tan(α))
• e = m * (π / 2 + 2 * tan(α))

If you want, I can: