Ask and answer engineering questions

Learn from millions of experts


Creating precise involute Spur Gears using Excel and Autocad

By Lance Skelly on 10 Mar 13:33 8 answers 27218 views 1 comment

Creating precise involute Spur Gears using Excel and Autocad.

Importing the profile data into Inventor to generate extruded spur gears.

Added images


8 answers

  • Lance Skelly
    Lance Skelly over 4 years ago

    The tutorial should explain how to generate gear profiles using excel.

    First Download and open the Excel spreadsheet "Gear Calculator" attached.

    You can find all tutorial graphics in the RAR file.

    You can see an example here:
    15 Tooth & 18 Tooth gears meshing


    All_Tutorial_Graphics.rar, 3.46 MB
    Gear_Calculator.xlsx, 171 KB
  • graphiX
    graphiX over 3 years ago

    Hi, do you have an excel for a planetary ring (annulus)?

  • Wesley Satelis
    Wesley Satelis over 3 years ago

    Hey, can I do this using Inventor?
    If yes, please help me, I really need this.

    Thank you

    ILIAS TOURLOMOUSIS almost 3 years ago

    Can you tell me how derived the formulas for initial angle?

Add your answer to: "Creating precise involute Spur Gears using Excel and Autocad"

Save Cancel