Din 5480 Spline Calculator Excel Verified May 2026

Introduction

Formulas: Uses named ranges (e.g., Module, Teeth) rather than cell references (e.g., B2) to prevent breaking logic if rows are inserted.
VBA Script: A lightweight script to export the result sheet as a secured PDF for external verification.
Dropdowns: Data Validation lists restrict tolerance fields to valid DIN 5480 classes (e.g., 6H, 7H, etc.) to prevent user typos.

Reference diameter (dᵣ): The diameter where the tooth thickness equals the space width.
Module (m): Ranges from 0.5 to 10 mm, but the combination of module and number of teeth defines the reference diameter.
Basic rack profile: 30° pressure angle (most common), but also 37.5° and 45° exist for special applications.
Fit class: H/h, H/k, H/f, etc., for centering (major diameter, minor diameter, or tooth flanks).
Tooth count (z) : Calculated as dᵣ / m.

Engineer clicks "Verify."

Status turns to "VERIFIED", confirming inputs match a valid DIN configuration.

DIN 5480 is a German standard that defines the characteristics of splines (or spline joints) used for transmitting torque. These are typically used in mechanical components like gears, shafts, and other rotating parts.