Shaft (d₃/d₄) and Hub (D₁/D₂).
Engineers often ask: Why not use a dedicated software like KISSsoft or MITCalc? din 5480 spline calculator excel
| Limitation | Solution | |------------|----------| | No 3D visualization | Pair with a CAD plugin or output DXF coordinates. | | Iterative functions (inv α) | Use VBA macro or pre-calculated tables. | | Risk of formula mistyping | Lock cells, use data validation, and test against 5+ examples. | | No fatigue or stress analysis | Use Excel output as input to FEA or hand calculations (DIN 5466). | Shaft (d₃/d₄) and Hub (D₁/D₂)
| Parameter | Example Value | |-----------|----------------| | Module (m) | 2.5 mm | | Number of teeth (z) | 28 | | Pressure angle (α) | 30° | | Fit class (e.g., H/h, H/f) | H/h | | Centering type | Major diameter (MA) | | | Iterative functions (inv α) | Use