Development of Involute Profiled Spur Gear Model with Excel Spreadsheet, Solidworks and CAD Technique

International Journal of Mechanical Engineering

© 2018 by SSRG - IJME Journal

Volume 5 Issue 5

Year of Publication : 2018

Authors : V Suresh Babu, Abubacker K M

10.14445/23488360/IJME-V5I5P102

How to Cite?

V Suresh Babu, Abubacker K M, "Development of Involute Profiled Spur Gear Model with Excel Spreadsheet, Solidworks and CAD Technique," SSRG International Journal of Mechanical Engineering, vol. 5,  no. 5, pp. 5-11, 2018. Crossref, https://doi.org/10.14445/23488360/IJME-V5I5P102

Abstract:

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

Keywords:

Xn, Yn, Zn coordinates, Base circle, Involute, Excel spreadsheet, Solidworks.

References:

[1] AGMA933-B-03, "Basic Geometry," American Gear Manufacturers Association, pp. 7-12, 2003.
[2] F. Pebrie, "Calculating the inverse of an involute," Gear Solutions, no. April, pp. 44-48, 2006.
[3] R. J. Drago, "Fundamentals of Gear Design," Division of Reed Publishing Inc, Butterworth Publishers, USA, 1998.
[4] J. E. Shigley, C. R. Mischke, and Budynas, "Mechanical Engineering Design," McGraw-Hill Companies Inc. New York., vol. Seventh Edition., 2004.
[5] O. Reyes, A. Rebolledo, and G. Sanchez, "Algorithm to describe the ideal spur gear profile.," Proceeding of the world congress on Engineering, WCE, London, U.K. (II), 2008.
[6] F. Feng, H. Pan, and G. Hu, "Pro/E based parametric design of spur gears," Advanced materials research, vol. 201-203, pp. 790-794, 2011.
[7] S. Sandeep, "Program for Involute equation to develop Spur gears on Pro/E software," Available at http:www.geartechnology.com, pp. 27-30, 2002.
[8] W. Lixin, and H. Wenliang, "Solid model generation of involute cylindrical gears," Gear Technology, pp. 40-43, 2003.
[9] V. S. Babu, and A. A. Tsegae, "Involute Spur Gear Development by Parametric Technique Using Computer-Aided Design," African Research Review, vol. 3, no. 2, pp. 415-429, 2009.
[10] X. Su, and D. R. Houser, "Characteristics of trochoids and their application to determining gear teeth fillet shapes," Mechanism and Machine Theory., vol. 35, pp. 291-304, 2000.
[11] Pushpendra Kumar Mishra, Dr. M.S. Murthy. "Comparison of Bending Stresses for Different Face Width of Helical Gear Obtained Using Matlab Simulink with AGMA and
ANSYS". International Journal of Engineering Trends and Technology (IJETT).
[12] V. S. Babu, M. C. Majumder, and A. Ramprasad, "Investigation and Development of Non-Symmetric Gear System using Matlab Graphical User Interface (GUI) ® and Autodesk Inventor," International Journal of Industrial Engineering, vol. 1, no. 5, pp. 151-160, 2017.
[13] G. M. Maitra, "Handbook of gear design," Tata McGraw Hill Publishing Company Limited, 2001.
[14] "Design data handbook" PSG College of Technology, vol. 2nd Edition, 1996.
[15] V. S. Babu, M. C. Majumder, and A. Ramprasad, "Involute Tooth Spacing, Gear Profile, and 3D Gear development with MATLAB Graphical User Interface and Solidworks," International Journal of Industrial Engineering, vol. 2, no. 3, pp. 67-75, 2018.
[16] F. L. litivin, "Gear Geometry and Applied Theory," Cambridge University, 2nd Edition, 2004.
[17] T. L. Liu, "Excel Spreadsheet in Mechanical Engineering Technology Education," Proceedings of the ASEE Conference for Industry and Education Collaboration (CIEC), 2018.
[18] Ashish N.Taywade, Dr.V.G.Arajpure, "Experimental Investigation of Noise and Vibrations in Nylon66 Plastic Helical Gear Used in Automobile Application" SSRG International Journal of Mechanical Engineering 2.3 (2015): 1-5.
[19] K. M. Abubacker, and V. S. Babu, "Estimation and Validation of Highest Point Single Tooth Contact in Spur Gears using Spreadsheet Application," International Journal of Modern Science and Technology, vol. 3, no. 4, pp. 83-89, A1-3, 2018.