| 基于Excel的齿轮跨棒距计算 |
| |
| 引用本文： | 詹家兴. 基于Excel的齿轮跨棒距计算[J]. 机械传动, 2011, 35(4): 67-68 |
| |
| 作者姓名： | 詹家兴 |
| |
| 作者单位： | 上海延锋江森座椅有限公司,上海,201315 |
| |
| 摘 要： | 提出了一种使用Excel计算齿轮跨棒距的简单方法--基于VBA利用插值法对计算中涉及的渐开线函数进行了反求;基于实例应用与公式计算值进行对比,结果表明计算精度满足设计及工艺的需要.
|
| 关 键 词： | Excel VBA 插值法 跨棒距 |
The Over Cylinders Dimension Calculation based on the Excel |
| |
| Zhan Jiaxing. The Over Cylinders Dimension Calculation based on the Excel[J]. Journal of Mechanical Transmission, 2011, 35(4): 67-68 |
| |
| Authors: | Zhan Jiaxing |
| |
| Affiliation: | Zhan Jiaxing(Shanghai Yanfeng Johnson Controls Seating Co.,Ltd.,Shanghai 201315,China) |
| |
| Abstract: | A simple method to calculate the over cylinders dimension based on Excel is presented-Calculate the root of the inverse involute function with interpolation method based on VBA.Based on actual application,compare with the result of calculation generated by equation,the result shows that the method meet the requirement of design and technics. |
| |
| Keywords: | Excel VBA Interpolation method Over cylinders dimension |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
