Din 5480 Spline Calculator Excel «Browser DIRECT»

DIN 5480 uses a system of tolerance classes (e.g., 9g, 8f for shafts; 9H, 7H for hubs). Your Excel sheet should include a lookup table or a dedicated tab for these deviation values.

Enter module, number of teeth, fit class (e.g., H/h, H/k), and reference diameter – get pitch diameter, root diameter, tip diameter, and space/land widths instantly. din 5480 spline calculator excel

| Step | Formula | |------|---------| | invα | =TAN(RADIANS(B4))-RADIANS(B4) | | s/d | =s_calc / d_calc (both in mm) | | d_pin | =1.68*B2 | | invφ | =s/d_calc + invα - d_pin / d_base | | φ (deg) | solve via Goal Seek (invφ target) or use approximate formula | | M | =d_base*COS(φ_rad)/COS(RADIANS(B4)) + d_pin | DIN 5480 uses a system of tolerance classes (e