LAUSR

Involute curve is the most widely used curve for gears, splines and serrations due to the ease in their manufacture. This paper attempts in calculating the X, Y, Z coordinates of an involute curve through an algorithm; using user-friendly Microsoft Office tool, the Excel spreadsheet. The spreadsheet stores the algebraic formulae pertaining to the involute that will convert basic spur gear parameters into numerous points on the corresponding involute curves. The co-ordinates are imported as points to get graphical interpretation through Solidworks CAD package. These points is then represented as a "XYZ Plot" of the desired gear outline, essentially plotting each point on a Cartesian axis. Various sketch tools like rotate, mirror, circular pattern, power trim etc., are used to achieve a perfect 2D profile, which when extruded produces a 3D CAD model of involute profiled spur gear. For evaluation a 24 Teeth, 8 module, 20° pressure angle Pinion was modelled. The outcome of the work demonstrates the usage of Excel tool for development of gear in a parametric pattern with true involute portion of the tooth profile. The Gear models on assembly could be used in kinematics simulations, structural analysis, development of contact pressure between corresponding Gears including thermal and many other analyses.