Related Resources: Design Engineering

AGMA Spur Gear Bending Stress Excel Spreadsheet Calculator

NOTE:

  • Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
  • This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
  • Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Electrical, Instrumentation, Electronic Design and Engineering

AGMA Spur Gear Bending Stress Equation and Spread Sheet (1999)

The AGMA* spur gear bending method can be viewed as a detailed refinement of the Lewis method.


Eqn. 14.58

Where:

Yj is the Lewis form factor corrected for several geometry factors, including stress concentration effects.Fig 14.30

Ka is the Application factor (1 to 2.75) that accounts for pulsation and shock in the driver and load. Table 14.8

Ks is the Size factor (1 to 1.4) which penalizes very large or wide teeth.

Km is the Load Distribution factor (1 to 2) that is a function of face width. paragraph 14.11.3

KV is the Dynamic factor (1 to 1.8), essentially a tailored Barth velocity factor that considers gear quality. Fig. 14.34

Ki is the Idler factor (1 or 1.42), accounting for reversed bending in idlers.

KB is the Rim Thickness factor which penalizes for the rim flexibility of non-solid gears. Eqn. 14.67

* American Gear Manufacturers Association, all units given in Imperial Units.

Note: Accessing this resource requires an active Premium Membership with Engineers Edge

Download: AGMA Spur Gear Bending Stress Equation and Spread Sheet

Preview: AGMA Spur Gear Bending Stress Equation and Spread Sheet

This excel document contains macros which will need to be enabled in your excel application.

Instructions

Go to the file location of the Excel file.

Right-click and select Properties.

Macro enable 1

Select the Unblock checkbox at the bottom of the General tab in Properties, then select OK .

Macro enable 2

Related: