| Problem | Symptom | Solution | |---------|---------|----------| | Circular reference | Excel prompts error | Enable iterative calculation (Options → Formulas → Enable iterative calculation, max 100 iterations). | | Missing over-pin formula | No output for Mdk | Manually add formula: ( M_dk = d_m + \fracd_m\cos \phi_M ) with phi_M based on contact angle. | | Wrong profile shift sign | Negative dedendum | Verify: For external splines, x>0 increases tooth thickness. | | No tolerance tables | Class selection does nothing | Create named range tolerance_table and use INDEX(MATCH()). |
To build a reliable calculator, you must define these primary variables: Ondrives Precision Gears The primary pitch size (standard range 0.5 to 10). Number of Teeth ( Typically 6 to 82 for DIN 5480. Pressure Angle ( Standardized at 30 raised to the composed with power Reference Diameter ( Calculated as www.kisssoft.cz Geometry Calculation Formulas din 5480 spline calculator excel install
: DIN 5480 is a metric standard. Ensure your Excel environment is set to decimal points (not commas) if the calculator was developed for international use. 2. Understanding DIN 5480 Parameters | | No tolerance tables | Class selection