Lance Skelly

Creating precise involute Spur Gears using Excel and Autocad

Question by Lance Skelly

Creating precise involute Spur Gears using Excel and Autocad.

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

Answer
 
Comments 0

8 Answers

Lance Skelly
Answered on 10 Mar, 2013 02:13 PM

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

 
Comments 1
Angelo Bertocchi
Answered on 12 Jul, 2014 12:23 PM

You could also use the dxf builder at www.me-bac.com for normal spur gear and also for corrected gear.

 
Comments 0
graphiX
Answered on 17 Jan, 2014 11:07 AM

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

 
Comments 0
Lance Skelly
Answered on 19 Jan, 2014 07:21 PM

Hi graphiX unfortunately I do not have calculations for this.

 
Comments 0
Wesley Satelis
Answered on 27 Mar, 2014 03:45 PM

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

Thank you

 
Comments 0
Lance Skelly
Answered on 7 Apr, 2014 06:40 AM
Lance Skelly
Answered on 7 Apr, 2014 06:42 AM

Wesley Satelis I sent you a private message regarding your question. I hope it helped.

 
Comments 0
ILIAS TOURLOMOUSIS
Answered on 26 Sep, 2014 01:52 PM

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

 
Comments 0