巧用Excel软件在AutoCAD中建立渐开线圆柱齿轮三维造型

The Method of Utilizing Excel Software to Generate 3-D Models of Involute Cylindrical Gears in AutoCAD

通过Excel强大的表格计算功能得出渐开线的各点坐标,并利用这些数值在AutoCAD中完成渐开线圆柱齿轮的三维造型。此方法无须编程,简单方便,AutoCAD初学者也可应用。

By utilizing the powerful table calculation function of Excel software to get every points＇ coordinates of involute, the 3-D models of involute cylindrical gears were generated in AutoCAD. This method is very simple and convenient, which do not need programming. The beginners of AutoCAD can use this method.