Din 5480 Spline Calculator Excel Verified 2021 【Free 2026】

Strength example:

d sub a 1 end-sub equals m center dot z plus 2 center dot x center dot m plus 0.9 center dot m Shaft Root Diameter ( d sub f 1 end-sub din 5480 spline calculator excel verified

=MROUND( (B2*COS(RADIANS(20)))/(COS(RADIANS(ASIN( (B2*COS(RADIANS(20)))/(B2+C3) )))) + D3, 0.001) Strength example: d sub a 1 end-sub equals

For occasional use or small shops, Excel is ideal. For daily design with FEM integration, invest in dedicated software. din 5480 spline calculator excel verified

A German automotive supplier used an unverified Excel spline calculator to order hobs for a new transmission shaft. After cutting 500 parts, the internal customer’s gauge showed . Root cause: The calculator omitted the subtracting tolerance allowance from the major diameter formula per DIN 5480 Part 1, Section 6.3.