| Calculation | Cell reference | | --- | --- | | Pitch diameter (Dp) | =(B1+C1)/2 | | Addendum circle diameter (Da) | =B1+2 E1 | | Dedendum circle diameter (Df) | =C1-2 E1 | | Tooth thickness (s) | =(D1*PI()/180)*E1 |
The is more than a convenience—it is a professional necessity for mechanical designers, quality engineers, and students. By building or downloading a well-structured calculator, you eliminate manual errors, save hours of table-lookup time, and gain instant insight into fit and function. din 5480 spline calculator excel
= m * (z + 0.9) (approximate, varies by fit) Root Diameter Shaft (df1): = m * (z - 1.2) Tip Diameter Hub (da2): = m * (z - 0.9) Root Diameter Hub (df2): = m * (z + 1.2) Implementing Tolerances and Fits | Calculation | Cell reference | | ---
Addendum and dedendum (standard DIN 5480 approximate values): Let’s walk through a typical use case: You
Some advanced Excel calculators have a button: "Copy to CNC" – sending the variables to a text file.
Let’s walk through a typical use case: You need to design an external shaft spline with mating internal hub.
Pitch diameter d = 48 mm Profile shift x = +0.2 (typical for z=24) Major diameter shaft da = m*(z+1) – 0.2*m? Actually table says: da = 50.0 mm Major diameter hub = 50.1 mm (after tolerance H7) Measurement over pins (Dp=2.2 mm) = 52.345 mm (theoretical)