| Parameter | Cell | |-----------|------| | Module (m) | B2 | | Number of teeth (z) | B3 | | Pressure angle α (deg) | B4 (30 or 37.5 or 45) | | Fit class (e.g., H/h) | B5 | | Centering type | B6 (side / major / minor) | | Tolerance grade (internal/external) | B7 (e.g., 5, 6, 7) |
To create the calculator, we will write VBA code to perform the calculations and create a user interface. Here's a sample code: din 5480 spline calculator excel new
Create a hidden sheet ( REF_DIN5480 ) with the official reference diameters. Use FILTER and SORT functions to create a dependent dropdown. Example formula for pitch diameter: = [Input!z] * [Input!m] | Parameter | Cell | |-----------|------| | Module
Klaus, a drive train engineer in Munich, was tired of manually calculating root fillet diameters, form diameters, and space widths for involute splines (module-based, with references like N, NA, NB, etc.). He decided to build an Excel tool. Example formula for pitch diameter: = [Input
Example lookup table on Sheet2:
DIN 5480 is a German standard for splines, which are used to connect shafts and hubs in mechanical power transmission systems. The standard specifies the dimensions, tolerances, and testing requirements for splines. A spline calculator is a useful tool for engineers and designers to quickly determine the dimensions and characteristics of a spline connection.