To build a clean, functional spreadsheet, organize your layout into three distinct sections: Inputs, Geometry Calculations, and Tolerances. 1. The Input Block Set up these fields in rows 1 through 5 of column B. Cell B2 Number of Teeth ( ): Cell B3 Fit Class (e.g., 9H, 8f): Cell B4 (Text label) 2. The Geometry Engine (Formulas)
Create dropdown lists for standard Modules ( , etc.) to prevent typographical errors.
inv αk=sd+inv(30∘)+Dkdb−πzinv alpha sub k equals s over d end-fraction plus inv open paren 30 raised to the composed with power close paren plus the fraction with numerator cap D sub k and denominator d sub b end-fraction minus the fraction with numerator pi and denominator z end-fraction (Where
Do you need the exact for specific fit classes like 9g or 8H ? Share public link din 5480 spline calculator excel
The standard pin diameter relies on the module. Program this look-up logic into your sheet using an nested IF or XLOOKUP sequence:
Do you need to design for ? Share public link
Set up cells for the four mandatory variables that define a DIN 5480 assembly (e.g., a DIN 5480 - W 40 x 2 x 18 designation): : Reference Diameter (dB) (e.g., 40 ) Cell B5 : Module (m) (e.g., 2 ) Cell B6 : Number of Teeth (z) (e.g., 18 ) To build a clean, functional spreadsheet, organize your
Reserve specific cells for the absolute minimum data required to define a spline: (Common values range from Number of Teeth ( ): (Input as an integer). Fit Class / Tolerance Designation: (e.g., for internal hubs, for external shafts). Block 2: Intermediate Geometric Formulas
Create a secondary sheet tab named DIN_Lookups . Populate it with the standard deviation tables from the DIN 5480-1 document, which details upper and lower allowances based on diameter steps. Linking Data with VLOOKUP or XLOOKUP
Unlike uncorrected involute splines, DIN 5480 uses to maintain constant tooth thickness across different tooth counts. Cell B2 Number of Teeth ( ): Cell B3 Fit Class (e
Additionally, this example assumes a simple spline geometry and doesn't account for more complex spline types or special design requirements.
: Includes the full range of DIN 5480 tolerance classes (e.g., 9H, 8f), allowing users to define clearance, transition, or interference fits. Variable Basic Rack Profiles
Note: Exact values depend on profile shift coefficient (x). DIN 5480 provides tables for x as a function of z and m.