(For standard flat root transitions) Excel Formula: =(m * z) + (0.9 * m)
The is the global benchmark for designing and manufacturing involute splines with a 30∘30 raised to the composed with power
Profile Shift Factor (x)=dB−(m×z)−(1.1×m)2×mProfile Shift Factor open paren x close paren equals the fraction with numerator d sub cap B minus open paren m cross z close paren minus open paren 1.1 cross m close paren and denominator 2 cross m end-fraction
While there isn't a single official "paper" published by DIN as an Excel file, you can find several highly effective Excel-based calculators and guides that implement the standard for involute splines. Recommended Excel Resources 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 (
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:
Crucial for fit analysis, often calculated with allowances. Measurement Over Pins ( Mpcap M sub p ): For calculating external spline tooth thickness. Measurement Between Pins ( Micap M sub i ): For calculating internal spline gear space. How to Build a DIN 5480 Spline Calculator in Excel (For standard flat root transitions) Excel Formula: =(m
: Using the correct formulas yields 52.342-52.348 mm – within 0.005 mm, matching standard.
Here's a simple example to get you started:
and a module range typically spanning from 0.5 to 10. Unlike simpler standards, DIN 5480 utilizes a reference diameter system that allows for easy slip-fitting of components like bearings. An Excel calculator must accurately implement the following core formulas: GWJ eAssistant Pitch Circle Diameter ( Calculated as is the module and is the number of teeth. Reference Diameter ( d sub cap B Often determined as to align with standard bearing bores. Addendum Modification ( Typically ranges from to achieve specific fits and strength requirements. www.kisssoft.cz Automation of Complex Tolerance and Testing Tolerances in DIN 5480 splines Measurement Between Pins ( Micap M sub i
Engineers often ask: Why not use a dedicated software like KISSsoft or MITCalc?
A robust Excel-based calculator for DIN 5480 typically includes the following features based on the standard's principles :
Whether you code your own simple sheet or invest in a professional template, ensure it handles:
Reserve specific cells for the absolute minimum data required to define a spline: (Common values range from Number of Teeth ( ): (Input as an integer). Fit Class / Tolerance Designation: (e.g., for internal hubs, for external shafts). Block 2: Intermediate Geometric Formulas