Din 5480 Spline Calculator Excel New Here

Select shaft (f, g, h, n) and hub (H, F, K) grades to compute tolerance bands.

Klaus added copied from DIN 5480-1:1991 and DIN 5480-15. He used XLOOKUP to pull:

' Calculate Involute Function inv(alpha) Dim invAlpha As Double invAlpha = Tan(alphaRad) - alphaRad din 5480 spline calculator excel new

DIN5480_Spline_Calculator_v1.0.xlsm │ ├── Sheet1: Input & Results (Color-coded, protected cells) ├── Sheet2: Calculations (Hidden formulas) ├── Sheet3: Tolerance Tables (Lookup data) ├── Sheet4: Ball Measurement Reference Table └── Module1: VBA Functions (Calculation, PDF export, Ball suggestion)

| Description | Formula | Excel example (row 10) | |-------------|---------|------------------------| | Reference diameter | d = m × z | =B2*B3 | | Base diameter | db = d × cos(α) | =B10*COS(RADIANS(B4)) | | Pitch (circular) | p = π × m | =PI()*B2 | | Addendum | ha = m | =B2 | | Dedendum | hf = 1.25 × m (typical) | =1.25*B2 | | Whole depth | h = 2.25 × m | =2.25*B2 | Select shaft (f, g, h, n) and hub

Unlike simple square keys or parallel splines, (as defined in DIN 5480) offer superior centering and strength. The teeth have an involute profile—similar to gears—which means they can be manufactured using standard gear hobbing and shaping processes.

An effective calculator handles the standard DIN 5480 designation format. According to the standard, a typical designation includes: The most complex part of a DIN 5480

Proceed with development as per the above architecture, with initial release focused on external splines (shaft) and internal splines (hub) for module series 0.5–10 mm, pressure angle 30°, fit classes 5H to 9H.

The most complex part of a DIN 5480 calculator is determining the measurement over pins ( Mdcap M sub d ) for external, or between pins ( Micap M sub i ) for internal splines.

(Note: "W" denotes a shaft/external spline, while "N" denotes a hub/internal spline). Essential Parameters and Symbols: : Module (determines tooth size) : Number of teeth : Pressure angle (standardized at 30°) : Pitch diameter : Base diameter da1d sub a 1 end-sub : Shaft tip diameter (outer diameter) df1d sub f 1 end-sub : Shaft root diameter da2d sub a 2 end-sub : Hub root diameter df2d sub f 2 end-sub : Hub tip diameter (inner diameter) Step-by-Step Excel Formula Architecture

By using a DIN 5480 spline calculator in Excel, and following the guidelines and standards outlined in this article, you can ensure that your designs are accurate, reliable, and meet the required specifications.