This report outlines the technical requirements, core formulas, and structural features for developing a modern in Excel. DIN 5480 is the standard for involute splines based on reference diameters, characterized by a uniform 30° pressure angle . 🛠️ Project Scope & Objective
External Spline (Shaft) Internal Spline (Hub) _..---.._ _..---.._ .' _ _ `. .' _ _ `. / (_) (_) \ / / \ \ | _ _ | | | ( ) | | | (_) (_) | | \ / | \ / \ `---' / `. .' `. .' ``---''` ``---''` Dimension Over Pins ($M_d$) Dimension Between Pins ($M_i$) External Spline ( Mdcap M sub d din 5480 spline calculator excel new
| Fit Class | Deviation (µm) for m=1..2 | Formula factor | |-----------|----------------------------|----------------| | 5H | +15 / +35 | 1.00 | | 6H | +25 / +50 | 1.25 | | 7H | +40 / +75 | 1.60 | | 8H | +60 / +110 | 2.00 | | 9H | +90 / +160 | 2.50 | defining the minimum space.
: Apply to internal splines (hubs), defining the minimum space. This report outlines the technical requirements