Din | 5480 Spline Calculator Excel !!top!!

Runs in standard Excel (no macros often, just formulas). Accessible on almost any PC.

Pitch diameter (d) = m × z Base diameter (db) = d × COS(α) Major diameter for shaft (da_shaft) = m × (z + 1) – 0.2 (approx – depending on x) Major diameter for hub = da_shaft + clearance Minor diameter = m × (z – 1) + 0.2 Form diameter (dFf, dFa) = based on generating rack tip radius din 5480 spline calculator excel

You might ask: Why not use a dedicated gear design suite like KISSsoft or MITCalc? Runs in standard Excel (no macros often, just formulas)

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. Enter module, number of teeth, fit class (e

Let’s discuss in the comments!

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)

Key variables that a calculator must handle: