Din 5480 Spline Calculator Excel

The standard also defines the following parameters:

Calculating dimensions over pins requires finding the involute of the contact angle. The mathematical formula for an involute is:

✅ ✅ Tooth count up to 100 ✅ Support for all three centering types (MA, MI, F) ✅ Measurement over pins for both shaft and hub ✅ Backlash calculation based on fit class ✅ Graphical representation of spline (optional) din 5480 spline calculator excel

Fit Class (e.g., 9H, 8f) — Used for advanced tolerance calculations Block 2: Reference Dimensions (Calculated) Cell B6 (Reference Diameter): =B1*B2 Cell B7 (Base Diameter): =B6*COS(RADIANS(30)) Cell B8 (Base Pitch): =PI()*B1*COS(RADIANS(30)) Block 3: Shaft (External) Output Cell B11 (Tip Diameter max): =B6+(0.9*B1) Cell B12 (Root Diameter min): =B6-(1.2*B1) Block 4: Hub (Internal) Output Cell B15 (Tip Diameter min): =B6-(0.9*B1) Cell B16 (Root Diameter max): =B6+(1.2*B1) 4. Integrating Tolerances and Fit Classes

To verify that your newly built Excel calculator is working correctly, run a test calculation using these standard dimensions: Module ( ) = 2 , Teeth ( ) = 18 , Pressure Angle = 30° Expected Pitch Diameter ( ): 36.00 mm Expected Base Diameter ( ): 31.18 mm Expected Shaft Tip Diameter ( ): 38.00 mm Expected Hub Root Diameter ( ): 38.40 mm Teeth ( ) = 18

Here is an example of a basic DIN 5480 spline calculator in Excel:

inv(30∘)=tan(rad(30))−rad(30)≈0.57735−0.523598=0.053751inv open paren 30 raised to the composed with power close paren equals tangent open paren rad open paren 30 close paren close paren minus rad open paren 30 close paren is approximately equal to 0.57735 minus 0.523598 equals 0.053751 Step 3: Solve for the Pressure Angle at Pin Center ( αMalpha sub cap M din 5480 spline calculator excel

s = m * π / 2 e = m * π / 2