spline. If the diameters match perfectly, your calculator is verified and ready for production.
Pin Diameter (dp)=1.728×mcos(helix angle) (usually 0∘ or approximate)Pin Diameter open paren d sub p close paren equals the fraction with numerator 1.728 cross m and denominator cosine open paren helix angle close paren end-fraction (usually 0 raised to the composed with power or approximate close paren How to Verify Your Excel Calculator
| Check Type | Formula | Acceptance | |------------|---------|-------------| | Tooth thickness | s = πm/2 ± allowance | DIN 5480 Table 2 | | Eccentricity | Fₚ ≤ grade | Class 5-7 tolerances | | Pitch error | fₚₜ ≤ 0.02m | Micro-geometry check | din 5480 spline calculator excel verified
Assume m=2 mm, z=20, α=30°, ha*=1.0, hf*=1.2, b=20 mm, T=100 N·m:
Key formulas:
Include units (mm, N, MPa, N·m).
Which would you prefer?
=TAN(RADIANS(30)) - RADIANS(30) + (B10 / (B3 * B4)) + (D_act / (B3 * B4 * COS(RADIANS(30)))) - (PI() / B4) Use code with caution.
d sub f 2 end-sub equals m center dot z plus 2 center dot x center dot m plus 2 center dot h sub f 2 end-sub 4. Verify with Inspection Dimensions spline
If your Excel sheet yields these exact numbers down to three decimal places, your fundamental geometry engine is mathematically verified. Benefits of an Excel-Based Verification Tool