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:
| Formula | Excel formula (example) | |----------|--------------------------| | ( d = m \cdot z ) | =B2*B3 | | ( d_b = m \cdot z \cdot \cos(\alpha) ) | =B2*B3*COS(RADIANS(B4)) | | ( d_a ) external = ( m \cdot (z+2) ) | =B2*(B3+2) | | ( d_f ) external = ( m \cdot (z-2.5) ) | =B2*(B3-2.5) | | at reference diameter | ( s = \frac\pi \cdot m2 ) | =PI()*B2/2 | din 5480 spline calculator excel
The DIN 5480 standard is based on reference diameters and a module system. Unlike other standards that focus on the number of teeth, DIN 5480 prioritizes the fit between the shaft and the hub. Key parameters include: You can use these standard formulas to populate
While standards like ISO 4156 provide general characteristics for torque transmission, an Excel tool allows for custom inputs to see how slight variations affect the assembly's integrity. Practical Application Practical Application