Do you need help formatting the layout into a printable ? Share public link
): The linear distance in millimeters that represents the size of the tooth. Standard modules include 1, 1.25, 1.5, 2, 2.5, 3, etc. The total count of splines on the circumference. Pressure Angle ( ): Fixed at 30 degrees for DIN 5480. Pitch ( ): Calculated as Reference Diameter ( ): Calculated as Centering Types
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
Machinists cannot easily measure spline profiles with standard calipers. Instead, they use the or between pins (for hubs) method. din 5480 spline calculator excel
Comprehensive Guide to Building a DIN 5480 Spline Calculator in Excel
A basic geometry calculator is useful, but a robust DIN 5480 calculator must handle . DIN 5480 uses specific tolerance classes (like 9H for hubs or 7g for shafts) to define backlash. To integrate this into Excel:
inv(α)=tan(α)−αi n v space open paren alpha close paren equals tangent open paren alpha close paren minus alpha Step 3: Excel Formula for Cross-Pin Measurements Do you need help formatting the layout into a printable
A robust Excel-based calculator for DIN 5480 typically includes the following features based on the standard's principles :
Machinists cannot easily measure an involute curve with standard calipers. Quality control relies on measuring the distance (for external splines) or between pins (for internal splines). Choosing the Ideal Pin Diameter ( Dkcap D sub k
| A | B | C | D | |---|---|---|---| | | Value | Unit | Formula | | Module m | 2 | mm | | | Teeth z | 24 | – | | | Pressure angle α | 30 | deg | | | d | 48.000 | mm | =B2 B3 | | d_base | 41.569 | mm | =B2 B3 COS(RADIANS(B4)) | | d_a (ext) | 52.000 | mm | =B2 (B3+2) | | d_f (ext) | 43.000 | mm | =B2*(B3-2.5) | | s_nominal | 3.142 | mm | =PI() B2/2 | | Fit class | h | | | | Upper dev | 0 | µm | VLOOKUP(...) | | Lower dev | -100 | µm | | | s_actual | 3.042 | mm | =s_nom + lower_dev/1000 | | Pin diameter | 3.360 | mm | =1.68 B2 | | M_over_pins | ~51.87 | mm | (after solving invφ) | The total count of splines on the circumference
In the output section, apply Excel formulas to calculate the basic pitch dimensions: : =B3*B4 Base Diameter (
The ideal pin or ball diameter is calculated so that the pin contacts the tooth flank exactly at the reference diameter:
| Cell | Label | Example value | |------|-------|----------------| | B2 | Module m (mm) | 2 | | B3 | Number of teeth z | 24 | | B4 | Pressure angle α (deg) | 30 | | B5 | Fit class (e.g., "f", "h") | h | | B6 | Type | External |