Din 5480 Spline Calculator Excel New Jun 2026

You can add a lookup table for based on z and m.

Function SuggestBallDiameter(m As Double) As Double SuggestBallDiameter = m * 1.728 ' DIN 5480 recommendation End Function din 5480 spline calculator excel new

' B) Measurement Over Pins (M) ' Select standard Pin Diameter (D_M) ' Rule of thumb: D_M approx 1.728 * m for 30 deg Dim Dm As Double Dm = 1.728 * m ' Standard pin size You can add a lookup table for based on z and m

Standardized from 5 to 12. Lower numbers indicate tighter tolerances. Deviation Letters: Lowercase for shafts (e.g., ) and uppercase for hubs (e.g., Slip Fits: Series (external) or (internal). Line-on-Line Fits: (external) and (internal). Interference Fits: Series Essential Excel Formulas ) and uppercase for hubs (e.g.