Din 5480 Spline Calculator Excel New < AUTHENTIC • REPORT >

' Input values m = Cells(2, 2).Value z = Cells(3, 2).Value alpha = Cells(4, 2).Value L = Cells(5, 2).Value D = Cells(6, 2).Value d = Cells(7, 2).Value

' --- 3. Iterative Calculation for Reference Diameter (d_Bez) --- ' DIN 5480 uses a reference profile shift to determine d_Bez. ' For simplicity in this calculator, we assume the standard case where ' the reference diameter equals the pitch diameter (no specific profile shift input). ' We calculate the ISO standard involute parameters. din 5480 spline calculator excel new

| Parameter | Formula | |-----------|---------| | Profile shift | x × m | | Tip diameter (external) | da = d + 2×m + 2×x×m | | Root diameter (external) | df = d – 2.5×m + 2×x×m | | Tip diameter (internal) | dai = d – 2×m + 2×x×m | | Root diameter (internal) | dfi = d + 2.5×m + 2×x×m | ' Input values m = Cells(2, 2)