DIN 5480 is a widely used German standard for involute splines with a reference diameter, offering high load capacity and self-centering properties. However, its calculation (module, tooth thickness, root diameter, over-ball measurements) involves trigonometric functions, iterative root solving, and tabular lookups. Many small manufacturers cannot afford dedicated gear design software. This paper presents a structured Excel workbook that implements the core formulas of DIN 5480:2006, including tolerance classes, using only native Excel functions and iterative circular references. The tool outputs key dimensions, provides a pass/fail gauge check, and generates a printable summary.
Formulas can be modified to add custom parameters or specific project constraints. din 5480 spline calculator excel