OFF
But the standard is vast – DIN 5480 is split into multiple parts (Part 1: General, Part 2: Nominal and inspection dimensions, Part 15: Inspection, Part 16: Tools). Flipping through tables and calculating basic and inspection dimensions by hand is not only slow but also prone to mistakes. A well‑structured Excel spreadsheet can:
: Compare with KISSsoft or a certified catalog. Your Excel calculator should match within 0.005 mm for measurement over pins.
In cell , add the fixed pressure angle. Excel handles trigonometric operations in radians, so convert the 30∘30 raised to the composed with power standard angle explicitly: Formula for B10 (Pressure Angle in Radians): =RADIANS(30)
The pitch diameter is the theoretical diameter where the tooth thickness equals the space width. d=m×zd equals m cross z Base Diameter (
Hub Tip Diameter (da2)=m×z+2⋅x2⋅m+0.9⋅m[2.3.1]Hub Tip Diameter open paren d sub a 2 end-sub close paren equals m cross z plus 2 center dot x sub 2 center dot m plus 0.9 center dot m open bracket 2.3 .1 close bracket
DIN 5480 defines tolerance classes like:
=TAN(RADIANS(30)) - RADIANS(30) + (B12 / (B6 * COS(RADIANS(30)))) Use code with caution.
matches the basic size designation (e.g., a DIN 5480 W30x2x14 sheet must output a reference diameter of exactly 28mm).
But the standard is vast – DIN 5480 is split into multiple parts (Part 1: General, Part 2: Nominal and inspection dimensions, Part 15: Inspection, Part 16: Tools). Flipping through tables and calculating basic and inspection dimensions by hand is not only slow but also prone to mistakes. A well‑structured Excel spreadsheet can:
: Compare with KISSsoft or a certified catalog. Your Excel calculator should match within 0.005 mm for measurement over pins.
In cell , add the fixed pressure angle. Excel handles trigonometric operations in radians, so convert the 30∘30 raised to the composed with power standard angle explicitly: Formula for B10 (Pressure Angle in Radians): =RADIANS(30)
The pitch diameter is the theoretical diameter where the tooth thickness equals the space width. d=m×zd equals m cross z Base Diameter (
Hub Tip Diameter (da2)=m×z+2⋅x2⋅m+0.9⋅m[2.3.1]Hub Tip Diameter open paren d sub a 2 end-sub close paren equals m cross z plus 2 center dot x sub 2 center dot m plus 0.9 center dot m open bracket 2.3 .1 close bracket
DIN 5480 defines tolerance classes like:
=TAN(RADIANS(30)) - RADIANS(30) + (B12 / (B6 * COS(RADIANS(30)))) Use code with caution.
matches the basic size designation (e.g., a DIN 5480 W30x2x14 sheet must output a reference diameter of exactly 28mm).
© 2026 YWG Orbit — All rights reserved.
