For quality control, you cannot measure a spline with a standard caliper. You need the (for shafts) or Between Pins (for bores). A verified calculator will include the complex involute function ( ) to provide these precise measurement values. How to Verify Your Excel Tool
Input the following precise parameters into your calculator to verify its code accuracy: 2.0 Number of Teeth ( ): 17 Reference Diameter ( ): 34.0 mm Expected Verifiable Results: Base Diameter ( ): 29.4448 mm Pitch Diameter ( ): 34.0000 mm Nominal Space / Tooth Thickness: 3.1416 mm
: Pin diameter, base tangent length, and span over teeth. Spline Calculator - Ondrives Precision Gears
The keyword “verified” imposes a professional obligation: cross-check against standard tables, commercial software, and physical samples before trusting the outputs for production.
In the next section, input the standard geometric equations: =B3*B4 Base Diameter: =B3*B4*COS(RADIANS(B3)) Base Tooth Thickness: =(PI()*B3)/2 Step 3: Implement VLOOKUP for Tolerances
Before programming Excel formulas, you must understand the reference system used by the DIN 5480 standard. Unlike older standards, DIN 5480 relies on a reference diameter ( ) where the tooth thickness equals the space width.
To verify your Excel results, compare them against known inspection methods like "Dimension Over Pins". Ondrives Precision Gears Dimension Over Pins ( cap M sub cap R
A professional-grade verified calculator must include the following sheets or sections:
The spline teeth contact on the flanks to transmit torque. Centering is achieved through the teeth alignment, not the major or minor diameters.
Ensure your Excel formula converts degrees to radians properly: =TAN(RADIANS(Alpha)) - RADIANS(Alpha) 4. Golden Test Data for Verification
