To build a functional tool, your spreadsheet should include the following primary input variables: Reference Diameter ( d sub cap B The defining diameter of the spline connection. The ratio of the pitch diameter to the number of teeth. Number of Teeth ( The total count of teeth on the shaft or hub. Pressure Angle ( Standardized at 30 raised to the composed with power for DIN 5480. Essential Formulas for Excel Automation
' Calculate M If z Mod 2 = 0 Then ' Even teeth M = db / Cos(alphaM) + Dm Else ' Odd teeth M = (db / Cos(alphaM)) * Cos(WorksheetFunction.Pi() / (2 * z)) + Dm End If din 5480 spline calculator excel new
