Related Resources: Design Engineering

AGMA Spur Gear Profile Calculator Spread Sheet

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.

Gear Engineering, Design and Manufacturing

AGMA Spur Gear Profile Calculator Spread Sheet

Three excel calculation sheets that include the following input data/variables, calculated data and chart graphics.

DesignVariables:

Half Width:
Addendum:
Dedendum:
Fillet Radius:
Module:
Teeth:
Profile Shift:
Pressure Angle:
Pitch Radius:
Base Radius:
Addendum Radius:
Half Angle:
Fillet Center
Fillet Center
Involute Angle:
Involute Angle:
Trochoid Angle:
Trochoid Angle:
Undercut Check
Pointed Check

Table data calculated: Addendum, Involute x and y, trochoidal and dedendum data

Charted Gear Profile Preview:

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

Download: AGMA Spur Gear Profile Calculator Spread Sheet

Related: