to include in your own Excel template, or are you looking for a pre-built software recommendation Spline Calculator - Ondrives Precision Gears
| Parameter | Formula in Excel | |-----------|------------------| | Reference diameter | =m*z | | Pitch diameter | =m*z (same for straight-sided DIN 5480) | | Base diameter | =m*z*COS(RADIANS(20)) (pressure angle 20° for series 2; 30° for series 1) | | Tip diameter (external) | =m*(z+2*x+2) | | Root diameter (external) | =m*(z+2*x-2.5) – but varies with fit | | Form diameter (internal) | lookup table from DIN 5480-1 | din 5480 spline calculator excel new
Modern calculators go beyond the base DIN 5480 standard to provide a holistic design environment: Multi-Standard Support to include in your own Excel template, or
In Excel, assuming your pressure angle is in cell B5 (in degrees), the formula looks like this: ' --- 1
Designing and calculating splines according to the DIN 5480 standard can be a tedious and error-prone process, especially for complex spline geometries. The standard provides detailed formulas and tables for calculating spline dimensions, but manual calculations can be time-consuming and prone to mistakes. A calculator or software tool can significantly simplify the design process, reduce errors, and increase productivity.
' --- 1. Read Inputs --- Dim m As Double, z As Long, alphaD As Double Dim toleranceClass As String