Series "a" through "g" (External) or "F" and "G" (Internal). Line-on-Line Fits: "h" (External) or "H" (Internal). Interference Fits: "j" through "v".
Create cells where you can input the fundamental spline parameters: Module (m) Number of Teeth (z) Fit Class (e.g., 7H/9h, 8H/9h) 2. Geometry Calculation Formulas Utilize Excel formulas to calculate essential diameters: =m*z Base Diameter ( ): =d*COS(RADIANS(30)) Internal Spline Major Diameter (D₁): Typically d + m
For power users, enhance your DIN 5480 spline calculator Excel file with: din 5480 spline calculator excel
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
Requires iterative solving or complex trigonometry based on the effective tooth thickness ( 4. Handling Tolerances and Fits DIN 5480 defines various fits through letter codes: Series "a" through "g" (External) or "F" and "G" (Internal)
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
: Compare with KISSsoft or a certified catalog. Your Excel calculator should match within 0.005 mm for measurement over pins. Create cells where you can input the fundamental
df1=m×z−1.2×md sub f 1 end-sub equals m cross z minus 1.2 cross m Excel Formula: =(m * z) - (1.2 * m) Internal Spline (Hub) Dimensions