DIN 5480 uses a side-fit configuration. The nominal boundaries depend heavily on whether you are designing the or the Internal Spline (Hub) . External Spline (Shaft): Tip Diameter ( da1d sub a 1 end-sub ): Root Diameter ( df1d sub f 1 end-sub ): (For a standard full radius root) Internal Spline (Hub): Tip Diameter ( da2d sub a 2 end-sub ): Root Diameter ( df2d sub f 2 end-sub ): 3. Step-by-Step Excel Model Architecture

Pressure Angle (α)=30∘(Constant across all DIN 5480 dimensions)[2.1.1,2.3.2]Pressure Angle open paren alpha close paren equals 30 raised to the composed with power space (Constant across all DIN 5480 dimensions) open bracket 2.1 .1 comma 2.3 .2 close bracket

Applies to internal splines (Hubs).

Formula : =B6*COS(RADIANS(30)) (Assuming Pitch Diameter is in cell B6) Formula : =B3*(B4+1) Minor Diameter of Shaft ( df1d sub f 1 end-sub ) Formula : =B3*(B4-1.2) Major Diameter of Hub ( df2d sub f 2 end-sub ) Formula : =B3*(B4+1.2) Minor Diameter of Hub ( da2d sub a 2 end-sub ) Formula : =B3*(B4-1) Implementing Fits and Tolerances

Machinists cannot easily measure an involute curve with standard calipers. Quality control relies on measuring the distance (for external splines) or between pins (for internal splines). Choosing the Ideal Pin Diameter ( Dkcap D sub k

Map the dedicated tool dedendum factor in cell using an IF nesting structure to read your drop-down choice:

Here's a simple example to get you started:

Manual calculations using the formulas from DIN 5480 are repetitive and complex. A small mistake in one variable, such as the profile shift coefficient (x), can cause a cascade of errors in subsequent dimensions. An Excel calculator automates these formulas, eliminating simple arithmetic errors. It also centralizes data input and output, creating a consistent, auditable record of your calculations.

: For those building their own Excel sheet, this Calculator Guide provides the specific Excel formulas needed to calculate diameters, tooth depth, and stresses . Key Calculation Formulas for Excel

DIN 5480 is the international standard for involute splines based on module sizes. It ensures accurate fitment, torque transmission, and centering between shafts and hubs.

The ratio of the pitch diameter to the number of teeth.

The answer lies in .

+-------------------------------------------------------------+ | DIN 5480 INVOLUTE SPLINE CALCULATOR | +-------------------------------------------------------------+ | INPUTS: | | Reference Diameter (dB) [ mm ] ---------> [ 40.00 ] | | Module (m) [ mm ] ----------------------> [ 2.00 ] | | Number of Teeth (z) --------------------> [ 18 ] | | Tool Dedendum Type ---------------------> [ Hobbing] | +-------------------------------------------------------------+ | DERIVED REFERENCE VALUES: | | Pitch Diameter (d) ---------------------> [ 36.00 ] | | Base Diameter (db) ---------------------> [ 31.18 ] | | Profile Shift (x*m) --------------------> [ 0.90 ] | +-------------------------------------------------------------+ | MANUFACTURING GEOMETRY OUTCOMES: | | Shaft Tip Dia (da1) ----> [ 39.60 ] | | Shaft Root Dia (df1) ---> [ 35.40 ] | | Hub Tip Dia (da2) ------> [ 36.00 ] | | Hub Root Dia (df2) -----> [ 40.20 ] | +-------------------------------------------------------------+ Step 1: Create the User Input Block