Din 5480 Spline Calculator Excel [upd]

Excel Formula (Cell B15): Assuming Tooth Thickness S = B2 * PI() / 2 (Standard): =((S / D_Ref) + Involute(B4) + (B10 / D_Base) - (PI() / B3))

$$ M = \fracd_b\cos(\alpha_M) + D_B $$

These formulas calculate the theoretical diameters. Use cell references (e.g., B2, B3) in your formulas. din 5480 spline calculator excel

| Parameter | Formula (Excel Syntax) | Description | | :--- | :--- | :--- | | | =B2 * B3 | Module $\times$ Teeth | | Base Circle Dia ($d_b$) | =B2 * B3 * COS(RADIANS(B4)) | $d \times \cos(\alpha)$ | | Pitch Circle Dia ($d_w$) | =B2 * B3 | (Assuming no center distance modification) | | Base Pitch ($p_b$) | =B2 * PI() * COS(RADIANS(B4)) | Circumferential pitch on base circle |

Usually calculated based on Module and Reference Diameter. Formula: $A = 10 \times m + 0.63 \times d$ (This is a simplified approximation for IT grades). Excel Formula (Cell B15): Assuming Tooth Thickness S

However, DIN 5480 uses specific tables. It is best to create a in a separate Excel sheet named "Data".

You must recalculate the $M$ dimension using the Min and Max Tooth Thickness values derived above. Formula: $A = 10 \times m + 0

A typical designation like breaks down as:

' Function to find the angle from an Involute value (Reverse Involute) ' This is necessary to solve for the measurement angle Function ReverseInvolute(ByVal InvValue As Double) As Double ' Newton-Raphson approximation for finding angle from involute Dim x As Double Dim i As Integer