Note: Exact values depend on profile shift coefficient (x). DIN 5480 provides tables for x as a function of z and m.
Before jumping into Excel, you need to know which parameters define a DIN 5480 spline. The standard organises splines by a rather than the module alone. A typical designation looks like:
): This defines the size of the teeth. Common modules range from 0.5 to 10. Number of Teeth (
Md=dbcos(αM)+DMcap M sub d equals the fraction with numerator d sub b and denominator cosine open paren alpha sub cap M close paren end-fraction plus cap D sub cap M
for a given DIN 5480 designation from a table. Let me know how you'd like to refine your calculation tool . involute splines - Hayes Broaching Services
) that often align with standard bearing sizes to simplify assembly. d2t1xqejof9utc.cloudfront.net Core Geometry Formulas for Excel
Your Excel calculator should include a lookup table for:
A1: "Module (mm)" → B1: user input A2: "Number of teeth" → B2: user input A3: "Pressure angle (deg)" → B3: 30 (or 37.5, 45) A4: "Fit class shaft/hub" → B4: "h" / "H"
Hidden or locked sheets containing standard deviation tables extracted directly from the DIN 5480 documentation.
Using a DIN 5480 spline calculator in Excel offers several benefits, including:
You can create a DIN 5480 spline calculator in Excel using the following steps:
Key geometrical parameters that any calculator must output include:
DIN 5480 uses specific naming conventions for diameters depending on whether the part is a shaft (external) or a hub (internal). The reference diameters are typically guided by the standard's centering types (usually flank-centered). Approximately depending on the exact fit class. Shaft Root (Minor) Diameter ( df1d sub f 1 end-sub ): Approximately Step-by-Step Excel Calculator Architecture
For high-precision manufacturing or complex tolerance analysis, dedicated engineering modules are often preferred over basic spreadsheets:
DIN 5480 relies on specific tolerance bands (represented by letters like 'H' for internal and 'f', 'g', 'h' for external splines) and quality classes (numbered 5 through 11). Adding Deviations to Excel
Other notable standards include the obsolete DIN 5482 for fine module splines, JIS B 1603 for Japan, and NF E 22-141 for France.