Din 5480 Spline Calculator Excel New Jun 2026

| z_min | z_max | x | |-------|-------|---| | 6 | 9 | 0.45 | | 10 | 12 | 0.35 | | 13 | 16 | 0.25 | | 17 | 20 | 0.15 | | 21+ | | 0.00 |

Designing and calculating splines according to the DIN 5480 standard can be a tedious and error-prone process, especially for complex spline geometries. The standard provides detailed formulas and tables for calculating spline dimensions, but manual calculations can be time-consuming and prone to mistakes. A calculator or software tool can significantly simplify the design process, reduce errors, and increase productivity.

You can use these standard formulas to automate your calculations within Excel cells: Pitch Diameter ( Base Circle Diameter ( Tip Diameter ( Root Diameter ( Addendum ( Dedendum (

DIN 5480 defines splines with (0.5 to 10 mm) and reference diameter d_ref = m × z (z = number of teeth). Key parameters:

ReverseInvolute = x End Function

Modern Excel-based calculators for DIN 5480 often include the following capabilities: Spline connections - KISSsoft