Your catalog is ready.
: Restrict cell inputs. For example, ensure the module matches standard DIN values ( ) using drop-down lists.
| Step | Formula | |------|---------| | invα | =TAN(RADIANS(B4))-RADIANS(B4) | | s/d | =s_calc / d_calc (both in mm) | | d_pin | =1.68*B2 | | invφ | =s/d_calc + invα - d_pin / d_base | | φ (deg) | solve via Goal Seek (invφ target) or use approximate formula | | M | =d_base*COS(φ_rad)/COS(RADIANS(B4)) + d_pin |
B5: =B1*B2 (Pitch diameter) B6: =B5*COS(RADIANS(B3)) (Base diameter) B7:=B1*(B2+1)-0.2*(B1) (Approx major diameter shaft)
A useful calculator must:
In your Output section, populate the cells with standard Excel formulas to calculate the nominal dimensions. Formula : =B3*B4 Base Diameter ( )
offer more advanced features like CAD export and full strength analysis, Excel-based calculators provide a transparent, "hands-on" approach that is easier to integrate into existing engineering workflows. Core Functionality and Features
In mechanical engineering, transmitting high torque safely requires robust component connections. are the industry standard for high-stress applications across automotive, aerospace, and heavy machinery design. din 5480 spline calculator excel
The foundation of a DIN 5480 calculator requires five primary inputs : The size of the tooth . Number of Teeth ( ): Total count of spline teeth . Reference Diameter ( dBd sub cap B
A robust Excel-based calculator for DIN 5480 typically includes the following features based on the standard's principles :
| Fit | Upper deviation (µm) | Lower deviation (µm) | |-----|----------------------|----------------------| | e | -140 | -240 | | f | -60 | -160 | | h | 0 | -100 | : Restrict cell inputs
inv α=tan(α)−α (in radians)inv alpha equals tangent open paren alpha close paren minus alpha (in radians) For the standard 30∘30 raised to the composed with power pressure angle:
and a module range typically spanning from 0.5 to 10. Unlike simpler standards, DIN 5480 utilizes a reference diameter system that allows for easy slip-fitting of components like bearings. An Excel calculator must accurately implement the following core formulas: GWJ eAssistant Pitch Circle Diameter ( Calculated as is the module and is the number of teeth. Reference Diameter ( d sub cap B Often determined as to align with standard bearing bores. Addendum Modification ( Typically ranges from to achieve specific fits and strength requirements. www.kisssoft.cz Automation of Complex Tolerance and Testing Tolerances in DIN 5480 splines
is the nominal tooth thickness at the pitch circle, equal to Formula : =B3*B4 Base Diameter ( ) offer
Most high-quality DIN 5480 Excel calculators include these essential modules: Geometry Generation : Automatically calculates the number of teeth ( ), pitch diameter ( ), base diameter ( ), and profile shift ( ) based on the module ( ) and reference diameter. Inspection Dimensions