No dropdown for standard DIN sizes – you must know your nominal diameter and module series.
In mechanical engineering, involute splines are critical for transmitting high torque between shafts and gears. The German standard is the global benchmark for designing these splines, utilizing a reference profile based on a 30° pressure angle.
Effective Tooth Thickness=Nominal Thickness−DeviationEffective Tooth Thickness equals Nominal Thickness minus Deviation Verifying Measurements: Over Pins Calculation
db=d⋅cos(30∘)=d⋅0.866025d sub b equals d center dot cosine open paren 30 raised to the composed with power close paren equals d center dot 0.866025 p=π⋅mp equals pi center dot m Basic Tooth Thickness ( ) and Space Width ( ):
To ensure your spreadsheet remains easy to scan and operate, organize it into four distinct visual sections: Highlighted cells for Module ( ), Number of Teeth ( ), Fit/Tolerance Class, and Pin Diameter ( DMcap D sub cap M
| Pitfall | Consequence | Excel Solution | | :--- | :--- | :--- | | Using wrong pressure angle | Spline binds or has backlash | Dropdown validation (locked to 30°) | | Forgetting to round pin diameter | M-dm off by 0.5 mm | Automated pin selection table | | Miscalculating internal spline M-dm | Hub scrapped | Separate internal/external worksheet | | Ignoring tip chamfer | Assemblies jam | Cell warning if tip diameter exceeds limits | din 5480 spline calculator excel
inv(α)=tan(α)−αinv open paren alpha close paren equals tangent open paren alpha close paren minus alpha To find the inverse involute ( inv-1inv to the negative 1 power
Your Excel tool should include input cells for the standard designation components: W (Welle/Shaft) or N (Nabe/Hub). Reference Diameter ( dBd sub cap B ): e.g., 120mm. Module ( ): The pitch size. Number of Teeth ( ).
The primary geometric variables are calculated using the following formulas: The fundamental indexing size factor. Number of Teeth ( ): Must be an integer value. Pitch Diameter / Reference Diameter ( ): d=m⋅zd equals m center dot z Base Diameter ( ): Based on the standard 30∘30 raised to the composed with power pressure angle (
: Generation of "over-pin" or "between-pin" dimensions and base tangent lengths for quality control. Top Tools & Resources
: You don't just input a size; you have to account for shaft quality grades (e.g., 5 to 12) and fit types like H9/f8 . No dropdown for standard DIN sizes – you
By building or utilizing a robust , you can ensure that your spline connections are designed for optimal power transmission, proper fit, and high structural integrity.
A is not a luxury—it is a necessity for any design or manufacturing engineer working with German standard splines. It eliminates human error, speeds up quoting, and provides an auditable trail for ISO 9001 requirements.
This is the most critical output for machining. A machinist measuring a spline on a CMM or with pin gauges needs the target M-dm value.
When calculating dimensions over pins or balls (the standard method for inspecting splines), you must solve the involute function:
offers more advanced features, Excel-based calculators provide a cost-effective and highly customizable alternative for standard geometric verification. www.kisssoft.cz Core Functionality of DIN 5480 Excel Calculators The standard DIN 5480 is based on reference diameters Number of Teeth ( )
) : Utilizes complex transcendental loops, best handled via a dedicated mathematical cell sequence or a basic VBA macro script. Excel Calculator Best Practices
inv αk=sd+inv(30∘)+Dkdb−πzinv alpha sub k equals s over d end-fraction plus inv open paren 30 raised to the composed with power close paren plus the fraction with numerator cap D sub k and denominator d sub b end-fraction minus the fraction with numerator pi and denominator z end-fraction (Where
If you are developing this spreadsheet for a specific project, let me know:
Outside (major) diameter for external spline: