Din 5480 Spline Calculator Excel |work| Jun 2026

| Input Parameters | | | --- | --- | | Module (m) | 2 | | Number of teeth (z) | 20 | | Type of spline | Involute | | Tooth thickness (s) | 3.14 |

Before trusting your calculator for production parts, validate its results against the official DIN 5480 tables or against a known commercial tool. Several forum discussions mention that it is “hard … without macros/VBA programming” to get the measurement over pins correct. So take the time to cross‑check with standard examples.

Involute splines according to DIN 5480 are the backbone of many shaft‑hub connections in heavy machinery and automotive applications. The standard covers modules from 0.5 up to 10 mm, numbers of teeth from 6 to 82, and a pressure angle of 30°. It can be used for removable connections, sliding fits, or permanent joints. din 5480 spline calculator excel

The DIN 5480 standard specifies the dimensions, tolerances, and testing methods for splines. The standard covers various types of splines, including:

) as the primary sizing parameter rather than the pitch diameter. This approach ensures a more flexible fit between components, accommodating various tolerance classes and fit types (sliding, clearance, or interference). Key components of the DIN 5480 nomenclature include: Denotes an external spline or shaft. N (Nabe): Denotes an internal spline or hub. Reference Diameter: The central value (e.g., 120 in ) that defines the connection size. Advantages of Using Excel for Spline Calculations | Input Parameters | | | --- |

By integrating the DIN 5480 formulas into a structured Excel environment, you ensure that every spline coupling in your assembly meets international standards for fit and strength. If you want to refine the accuracy of your tool: Standard module sizes (0.5, 0.75, 1, etc.) Specific tolerance classes (e.g., 7H or 9g) Specific pin diameters for inspection measurements

). For an external spline with an even number of teeth, the simplified target measurement is: = B6 / COS(RADIANS(30)) + Dc Involute splines according to DIN 5480 are the

While standards like ISO 4156 provide general characteristics for torque transmission, an Excel tool allows for custom inputs to see how slight variations affect the assembly's integrity. Practical Application

Base diameter ( db = dref * cos(alpha) ) is the foundation of involute geometry. Your calculator must compute this instantly, with a standard pressure angle of 30° (DIN 5480 uses 30°, not 20° like ISO 4156).

However, designing or verifying these splines by hand is tedious—requiring complex formulas for root diameters, form diameters, and inspection measurements (over balls or pins). This is where a becomes an indispensable tool.