Din 5480 Spline Calculator Excel Verified [top] (2024)

The process begins with , the careful conversion of the mathematical formulas from the standard's annexes into Excel cell references. Every formula must be meticulously checked against the relevant part of the standard, such as DIN 5480-1 for general formulas and DIN 5480-2 for inspection dimensions. For those with advanced VBA skills, it is possible to implement the exact iterative procedure provided in the standard's BASIC program listing, for example for calculating the dimension across/over pins.

Include a small VBA macro or table lookup to select the theoretical pin diameter that contacts the flank at the reference diameter.

To verify an Excel-based calculator, ensure it uses these standard geometric formulas based on the module ( ) and number of teeth ( Base Circle Diameter ( ): External Tip Diameter ( da1d sub a 1 end-sub ): din 5480 spline calculator excel verified

Used for removable or sliding connections.

If you want to expand this tool,g., upper/lower deviations for 'f', 'g', 'H') or the specific formulas for . The process begins with , the careful conversion

d1=34.000 mm (for W20/2/17)d sub 1 equals 34.000 mm (for W20/2/17)

: Incorporates strength calculations (based on Niemann or DIN 6892) to warn if the transmitted torque exceeds the permissible surface pressure for the selected material. Summary of Key Excel Outputs Include a small VBA macro or table lookup

You can find reference data and example tables for metric splines at Hayes Broaching Services . Spline connections - KISSsoft

Use this table to test any DIN 5480 Excel calculator before deployment.

While specialized CAD software exists, Excel remains the preferred choice for many engineers due to: