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)
(Note: This formula applies strictly to even tooth counts. Odd tooth counts require a geometric correction factor multiplying the cosine of Free Downloadable Excel Tools and Resources
DIN 5480 utilizes a specific system of tolerance classes (e.g., 8f, 9H). A spreadsheet can pre-load these tables, allowing users to select a fit and immediately see the upper and lower deviations. din 5480 spline calculator excel
To build an accurate DIN 5480 calculator, you must program the core geometric calculations into Excel cells. Assuming you input the Module ( ) in cell B1 and the Number of Teeth ( ) in cell B2 , apply the following formulas. 1. Reference Diameter (
Verify that your Excel trigonometric functions use RADIANS() since Excel natively calculates angles in radians, not degrees. Pitch diameter d = 48 mm Profile shift x = +0
Machinists verify spline dimensions on the shop floor using the "Measurement Over Pins" (for shafts) or "Measurement Between Pins" (for hubs) method. Determining Pin Diameter ( DMcap D sub cap M
: You don't just input a size; you have to account for shaft quality grades (e.g., 5 to 12) and fit types like H9/f8 . A spreadsheet can pre-load these tables, allowing users
The DIN 5480 standard itself used to provide a BASIC program for the iteration:
Before diving into the mathematics, it is important to understand why Excel remains a preferred tool for this task:
) : =B6*COS(RADIANS(B5)) (Note: Excel handles trigonometric functions in radians, requiring the RADIANS conversion). 3. Calculate Shaft (External Spline) Dimensions : =B3*(B4+1) Root Diameter ( df1d sub f 1 end-sub ) : =B3*(B4-1.1) 4. Calculate Hub (Internal Spline) Dimensions Tip Diameter ( da2d sub a 2 end-sub ) : =B3*(B4-1) Root Diameter ( df2d sub f 2 end-sub ) : =B3*(B4+1.1) Advanced Logic: Integrating Tolerances and Fits
But simpler: Use Excel’s automatically via a small VBA macro or iterative cell referencing.