Private Sub cmdCalculate_Click() CalculateDIN5480 End Sub
| Description | Formula | Excel example (row 10) | |-------------|---------|------------------------| | Reference diameter | d = m × z | =B2*B3 | | Base diameter | db = d × cos(α) | =B10*COS(RADIANS(B4)) | | Pitch (circular) | p = π × m | =PI()*B2 | | Addendum | ha = m | =B2 | | Dedendum | hf = 1.25 × m (typical) | =1.25*B2 | | Whole depth | h = 2.25 × m | =2.25*B2 | din 5480 spline calculator excel new
Create a hidden sheet ( REF_DIN5480 ) with the official reference diameters. Use FILTER and SORT functions to create a dependent dropdown. Example formula for pitch diameter: = [Input!z] * [Input!m] din 5480 spline calculator excel new