Din 5480 Spline Calculator Excel _hot_ Jun 2026

s = m * π / 2 e = m * π / 2

For actual tooth thickness with fit class, you need tables from DIN 5480-1. A simplified version: Add shift coefficient ( x ) (≈0 for standard fit). Then ( s = m \cdot \left( \frac\pi2 + 2x \cdot \tan\alpha \right) ).

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. din 5480 spline calculator excel

In mechanical engineering, involute splines are critical for transmitting high torque between shafts and gears. Among the various global standards, is the European benchmark for involute splines based on module and reference diameters.

Dedicate a visible section (e.g., Columns A and B, Rows 1 to 5) for inputs. Highlight these cells in light yellow or blue so users know where to enter data. Module ( Cell B2: Number of Teeth ( s = m * π / 2 e

I’ll then give you a and highlight any errors or non‑compliance with DIN 5480.

between "Actual" vs "Effective" tooth thickness. This public link is valid for 7 days

The Ultimate Guide to Building a DIN 5480 Spline Calculator in Excel

: A standard designation like DIN 5480 - W 50 x 2 x 24 x 8h indicates: W : Shaft (External spline) / N : Hub (Internal spline). 50 : Reference Diameter. 2 : Module (size of the tooth). 24 : Number of teeth. 8h : Tolerance Class and Deviation . If you'd like, I can help you: