Skip to content Din 5480 Spline Calculator Excel Install -
DIN 5480 Spline Calculator Excel Install: A Step-by-Step Guide
Alternative: Building Your Own Lightweight Calculator
- Input: z=24, m=2, α=30°, fit=H/h, x=0
- Expected output: d = 48 mm, d_f = 43.6 mm approx.
- If results match, installation is successful.
- Sheet "Inputs": user inputs (m, z, d, b, material, torque, fit class)
- Sheet "Constants": standard coefficients and table lookups (pressure angle, addendum/dedendum factors, radii, tolerance tables from DIN 5480)
- Sheet "Geometry": calculated dimensions (reference dia, base circle, tip/root diameters, tooth thickness)
- Sheet "Tolerances & Fits": lookup results for bore/hub/shaft tolerances, resulting interference/clearance
- Sheet "Strength": contact stress and bending safety factors vs input torque
- Sheet "Output": summary report and printable spec sheet