Din 5480 Spline Calculator Excel _hot_ -

| 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 calculator must output critical physical dimensions for both the shaft (W) and hub (N) : Tolerances in DIN 5480 splines | GrabCAD Tutorials din 5480 spline calculator excel

for external spline (shaft):

Whether you are designing a drive shaft for an automotive transmission or a heavy-duty industrial coupling, automating these calcs saves hours of design time and prevents costly machining errors. | Calculation | Cell reference | | ---

Critical for manufacturing inspection. Excel formulas should compute: In Excel, use or direct formula with ATAN/SQRT

Where ψ is an auxiliary angle solved iteratively. In Excel, use or direct formula with ATAN/SQRT.