Din 5480 Spline Calculator Excel Link (480p)

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.

What or tooth count range are you designing for?

To build an automated spreadsheet, you must program the core geometric equations dictated by the standard. Reference Diameters d=m×zd equals m cross z Base Diameter ( ): din 5480 spline calculator excel

The DIN 5480 standard uses a specific nomenclature. A typical designation like provides the following inputs: W/N : "Welle" (Shaft/External) or "Nabe" (Hub/Internal). 120 : Reference diameter ( 3 : Module ( ), which defines the tooth size. 38 : Number of teeth ( 8f : Tolerance class (8) and deviation series (f). 2. Fundamental Geometry Formulas for Excel

: Create a separate reference tab containing the upper and lower deviations based on the reference diameter range. Enter module, number of teeth, fit class (e

DIN 5480 replaces older standards (e.g., DIN 5481, DIN 5482) and is characterized by:

Outside (major) diameter for external spline: Reference Diameters d=m×zd equals m cross z Base

) : =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

) are crucial. These formulas involve complex trigonometry based on the tooth thickness. Free and Paid DIN 5480 Calculation Tools