Din 5480 Spline Calculator Excel -

), Excel requires an iterative loop. You can add this custom VBA function to your workbook to automate the calculation. How to Add the Code: Press ALT + F11 to open the VBA Editor. Click > Module . Paste the following code:

While this article focuses on Excel, it is helpful to know the landscape of available tools, as some can be integrated with or compared to spreadsheet solutions.

Always thoroughly test any calculator, especially free tools, with known values or manual calculations before relying on it for final design. din 5480 spline calculator excel

DM≈1.68×mcap D sub cap M is approximately equal to 1.68 cross m Excel Formula: =1.68 * B1 Calculation Workflow in Excel Calculating the final dimension over pins ( Mkcap M sub k ) requires solving the involute function (

Before building the calculator formulas, you must understand the core parameters defined by the DIN 5480 standard. Unlike older standards, DIN 5480 is module-based and references the reference diameter ( Key Nomenclature and Parameters Module ( ), Excel requires an iterative loop

: This is an Excel-based add-in specifically designed for mechanical calculations, including DIN 5480 splined connections. Key Formulas for Excel Setup

) dictated by the standard. In DIN 5480, the profile shift for both the external spline (shaft) and internal spline (hub) is derived directly from the selected module ( ) and total number of teeth ( The Fundamental Geometry Parameters Click > Module

Machinists verify spline dimensions on the shop floor using the "Measurement Over Pins" (for shafts) or "Measurement Between Pins" (for hubs) method. Determining Pin Diameter ( DMcap D sub cap M

You can use these standard formulas to populate your Excel fields: Excel-Friendly Formula =Module * Number_of_Teeth Base Diameter ( ) =d * COS(RADIANS(30)) Tip Diameter (Shaft) =d + (2 * Module) Root Diameter (Shaft) =d - (2.5 * Module) Circular Pitch ( ) =PI() * Module Available Resources & Templates For ready-made professional tools or reference data:

Other notable standards include the obsolete DIN 5482 for fine module splines, JIS B 1603 for Japan, and NF E 22-141 for France.

| Fit | Upper deviation (µm) | Lower deviation (µm) | |-----|----------------------|----------------------| | e | -140 | -240 | | f | -60 | -160 | | h | 0 | -100 |