Din 5480 Spline Calculator Excel Now

=IF(B6="External", C9-(0.1*B4), "")

Here is a guide to responsible sourcing: din 5480 spline calculator excel

Calculate the modified pressure angle at the pin center ( αkalpha sub k =IF(B6="External", C9-(0

| 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φ) | Essential Formulas for Your Excel Sheet This article

Create a clean, functional layout in Excel by partitioning your sheet into inputs, geometric constants, and final outputs. 1. Define Your Input Cells

Standard designations (such as 9H for internal hubs or 8f for external shafts) that dictate the allowable deviations and backlash. Essential Formulas for Your Excel Sheet

This article explains DIN 5480 splines, gives the formulas needed to calculate key dimensions, and provides an easy-to-use Excel implementation (with formulas and a downloadable sample layout). Use it to size external/internal splines, compute fit tolerances, and produce drawing values.