When setting up your input cells, you will need to provide the following four primary values: Module (
): = (B2 * B3) + (2 * B2 * x) (adjusted by the standard's specific addendum coefficients).
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
Verify that your Excel trigonometric functions use RADIANS() since Excel natively calculates angles in radians, not degrees. din 5480 spline calculator excel
You can easily modify formulas, add custom safety factors, or link the data to your company's automated billing and inventory spreadsheets.
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
External Spline (Shaft) Internal Spline (Hub) _..- -.._ _..- -.._ .' (O) '. .' '. / / \ \ / \(O) (O)/ \ | | | | | | | | \ \ / / \ / \ / '. (O) .' '. .' ` -.. - ` ` -.. - ` Measured OVER Pins Measured BETWEEN Pins Pin Diameter Selection ( When setting up your input cells, you will
Involute splines according to DIN 5480 are the backbone of many shaft‑hub connections in heavy machinery and automotive applications. The standard covers modules from 0.5 up to 10 mm, numbers of teeth from 6 to 82, and a pressure angle of 30°. It can be used for removable connections, sliding fits, or permanent joints.
You have three paths to acquire a DIN 5480 Spline Calculator in Excel.
for hubs) and tolerance classes (represented by numbers like Managing Data Tables with XLOOKUP If you share with third parties, their policies apply
Always validate your spreadsheet outputs against official standard tables before deploying it for manufacturing. Expected Results: Pitch Diameter ( ) = 34.00mm, Base Diameter ( ) = 29.444mm.
You can calculate dimensions for dozens of different spline sizes simultaneously. Key Inputs for a DIN 5480 Excel Calculator