Spreadsheet: 680592d1591102414-conditional-formatting-not-doing-what-i-expect-spur-gear-parameter-calculations-g5377
Sheet: SD13-SD14 Gear Tooth data

[NAME] Parameters Calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Gear Tooth forms
 | Given |  |  |  |  |  |  |  |  |  |  |  |  | Coarse Pitch-20
 | Tooth Form | Stub Involute-20 |  |  |  |  |  |  |  |  |  |  |  | [NAME] Involute-14.5
 | Cir. Pitch (p) |  | in | Input HP | 25 |  |  |  |  |  |  |  |  | [NAME] Involute-20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Stub Involute-20
 |  | Pinion |  |  | Gear
 | No of Teeth (N) | 15 |  |  | No of Teeth (N) | 85
 | Normal  Backlash (Jn) |  | in |  | [NAME] (Jn) |  | in
 | Face [NAME] | 4.75 | in |  | Face [NAME] | 3.75 | in
 | RPM | 14.5 |  |  | RPM | 2.6
 | Calculated |  |  |  |  |  |  |  |  |  |  |  | Coarse Pitch-20 | [NAME] | [NAME] Involute-20 | Stub Involute-20
 | Diametral Pitch (P) |  | in |  | Diametral Pitch (P) |  | in |  |  |  |  | [NAME]
 | Outside Diameter (DoP) |  | in |  | Outside Diameter (DoG) |  | in |  |  |  |  | dedendum
 | Minor Diameter (DrP) |  | in |  | Minor Diameter (DrG) |  | in |  |  |  |  | Working depth
 | [NAME] (Dp) |  | in |  | Pitch Diameter (Dg) |  | in |  |  |  |  | Whole depth
 | Pressure Angle |  | deg |  | Pressure Angle |  | deg |  |  |  |  | Clearance
 | [NAME] (a) |  | in |  | [NAME] (a) |  | in |  |  |  |  | Fillet Radius | 0
 | Dedendum (b) |  | in |  | Dedendum (b) |  | in |  |  |  |  | Pressure Angle | 20 | 14.5 | 20 | 20
 | Chordal Addendum |  | in |  | [NAME] |  | in
 | Working Depth (ht) |  | in |  | Chordal Addendum |  | in
 | Tooth Thickness (t) |  | in |  | Working Depth (ht) |  | in
 | Minimum Clearance-c |  | in |  | Tooth Thickness (t) |  | in |  |  | [NAME] |  |  | Full Depth-14.5
 | Fillet Radius |  | in |  |  |  |  |  |  | No of teeth | Add modif coeff | [NAME] | No of teeth | Add modif coeff
 | Pin Diameter |  | in
 | [NAME] (Jt) |  | in |  | [NAME] (Jt) |  | in
 |  |  |  |  |  |  |  |  |  | 10 | 0.468 | 0.912 | 13 | 0.185
 | New Addendum |  | in |  | New Addendum |  | in |  |  | 11 | 0.409 | 0.868 | 14 | 0.1223
 | New Dedendum |  | in |  | New Dedendum |  | in |  |  | 12 | 0.351 | 0.826 | 15 | 0.0597
 | New Thickness |  |  |  | New Thickness |  | in |  |  | 13 | 0.292 | 0.783 | 16 | 0.997
 | New Chord Adden |  | in |  | New Chord Adden |  | in |  |  | 14 | 0.234 | 0.741 | 17 | 0.9343
 | New OD |  | in |  | New OD |  | in |  |  | 15 | 0.175 | 0.698 | 18 | 0.8716
 | add modification |  | in |  | add modification |  | in |  |  | 16 | 0.117 | 0.656 | 19 | 0.8089
 | [NAME] mod [NAME]. |  |  |  | [NAME] mod [NAME]. |  |  |  |  | 17 | 0.058 | 0.613 | 20 | 0.7462
 | Thickness mod [NAME]. |  |  |  |  |  |  |  |  |  |  |  | 21 | 0.6835
 |  | Parabolic Tip Relief Modification (if applicable) |  |  |  |  |  |  |  |  |  |  | 22 | 0.6208
 | Tangential Load |  | lb |  | Tangential Load |  | lb |  |  |  |  |  | 23 | 0.5581
 | X(max) |  | in |  | X(max) |  | in |  |  |  |  |  | 24 | 0.4954
 | X(min) |  | in |  | X(min) |  | in |  |  |  |  |  | 25 | 0.4328
 | Y |  | in |  | Y |  | in |  | h |  |  |  | 26 | 0.3701
 |  |  |  |  |  |  |  |  | j |  |  |  | 27 | 0.3074
 |  |  | Center Distance |  | in |  |  |  | k |  |  |  | 28 | 0.2447
 |  |  |  |  |  |  |  |  | m |  |  |  | 29 | 0.182
 |  |  |  |  |  |  |  |  | inv e |  |  |  | 30 | 0.1193
 |  |  |  |  |  |  |  |  | Base Diameter |  | in |  | 31 | 0.0566
 |  |  |  |  |  |  |  |  | [NAME] to center of [NAME] |  | in
 | ** For the gears on G5377, the amount of tip relief (x dim)was based on 2* sum of profile and pitch tolerance.
 | The starting depth of the modification (Y dim) is based off the formula from [NAME]' Gear Handbook.