成功大學博碩士論文系統

簡易檢索 / 詳目顯示

回結果列表

研究生：	陳建宏 Chen, Marcelo
論文名稱：	應用電子試算表進行齒輪嚙合分析 Analysis of Gearing Systems Using Spreadsheets
指導教授：	黃金沺 Huang, Chin-Tien
學位類別：	碩士 Master
系所名稱：	工學院 - 機械工程學系 Department of Mechanical Engineering
論文出版年：	2013
畢業學年度：	101
語文別：	英文
論文頁數：	75
中文關鍵詞：	電子試算表、齒輪原理、嚙合機構
外文關鍵詞：	Spreadsheet, Theory of gearing, Meshing mechanisms
相關次數：	點閱：90 下載：6
分享至:	分享至facebook 分享至twitter

查詢本校圖書館目錄查詢臺灣博碩士論文知識加值系統勘誤回報

本論文以Microsoft Excel電子試算表進行曲線與嚙合機構的推導與分析，並且建立出相關的模擬。此軟體不但可用在機構分析方面，也適用在課程教學上，尤其是在教導齒輪嚙合的基礎理論。軟體中的參數可以被受變更並藉由動畫般的視覺輔助來提升使用者的理解。
軟體的建立主要採用齒輪原理之坐標轉換矩陣來進行曲線方程式的推導。首先會藉由曲線推導來了解其空間上的意義而之後由此結果應用在機構建立與模擬。接著使用齒輪原理概念以及得取的曲線方程式撰寫出嚙合機構的模擬並詳細說明設計步驟。除此之外，除了機構上的模擬此軟體可以進行機構的運動分析，以凸輪機構為主進行其旋轉與從動件的位移關係。
對於本論文所討論的案例各有附上其對應的試算表檔案，使用者可以自由調整參數值並觀察此參數對機構的影響。可以利用已設計好的檔案進行結果分析而其附加的圖表會隨著參數改變而同步變化，使可以協助於認證所計算出來結果的正確性。
由本論文可以證明確實能夠以電子試算表設計出人性化的分析軟體而此軟體可做為未來建立更加完整以及更廣闊軟體的開拓者。電子試算表具有進行問題分析之潛能，也能夠作為工程分析相關作業所使用的一個強大的分析工具的好選擇。

This thesis presents Microsoft Excel spreadsheet programs for the derivation and analysis of curves and meshing mechanisms. Such programs can be used to assist in the teaching of gearing fundamentals as well as the analysis of mechanisms. These programs contain parameters for the user to modify and provide graphic animations to enhance the understanding by means of visual aids.
This thesis begins with the basics of theory of gearing and the application of coordinate transformation matrices. Once the method is explained, derivations of geometric curves are performed and these curves are used in meshing mechanism applications. Next, the discussion focuses on the synthesis and simulation of meshing mechanisms such as gears and pistonless engines by using the theory of gearing. Furthermore, a detailed procedure for the design of such simulations is provided. Finally, this thesis discusses the use of spreadsheet in the analysis of cam-follower mechanisms.
This thesis provides spreadsheet files that simulate the cases discussed, which offer users to freely modify the parameters. Using such files, the analysis of mechanical systems can be performed, and animated plots that synchronize with the change of data can help in the verification of the results.
It is demonstrated that spreadsheets have the capabilities to develop programs with user-friendly interface and these files can serve as a base for more advanced programs applied in a wide variety of applications. Spreadsheet programs have the potential to perform analysis and serve as a powerful tool in engineering applications.

摘要 I
Abstract II
Acknowledgements III
Table of Contents IV
List of Tables VI
List of Figures VII
List of Symbols and Abbreviations X
Chapter I  Introduction 1
1-1 Problem Statement 1
1-2 Literature Review 1
1-3 Introduction to Microsoft Excel Spreadsheet 2
1-4 Research Motivation 2
1-5 Thesis Structure 3
Chapter 2  Fundamental Theories 4
2-1 Overview 4
2-2 Coordinate Transformation Method 4
2-3 Derivation of Plane Curves 7
2-3-1 Involute curve 7
2-3-2 Cycloid curve 10
2-3-3 Epicycloid curve 11
2-3-4 Hipocycloid curve 14
Chapter 3  Application of Spreadsheets in Simulation of Meshing Mechanisms 18
3-1 Overview 18
3-2 Involute Gears 19
3-2-1 General concept and application 19
3-2-2 Geometric construction of involute teeth 21
3-2-3 Gear meshing 26
3-3 Cycloidal Gears 28
3-3-1 General concept and applications 28
3-3-2 Geometric construction of a cycloidal gear 30
3-3-3 Gear meshing 32
3-4 Roots Blower 33
3-4-1 General concept and application 33
3-4-2 Two-lobed Roots blower 34
3-4-3 Three-lobed Roots blower 37
3-4-4 Excel Spreadsheet simulation 40
3-5 Wankel Engine 42
3-5-1 General concepts and applications	42
3-5-2 Geometry and simulation 43
Chapter 4 Analysis of Cam-Follower Mechanisms 46
4-1 Overview 46
4-2 Geometric Approach 46
4-2-1 Eccentric circular cam with translating flat-faced follower 46
4-3 Center of Curvature Approach 56
4-3-1 Translating flat-faced follower 56
4-3-2 Translating roller follower 62
Chapter 5 Conclusions and Future Work 67
5-1 Conclusion 67
5-2 Future Work 68
References 69
Appendix I Microsoft Excel Spreadsheet Settings 71
I-1 Enabling Developer Options 71
I-2 Using Interactive Icons To Change Input Variable Values 72
Appendix II: List of Excel Files 75

                                    

1. Cleghorn W. L., Mechanics of Machines, Oxford University Press, New York, 2005.
2. E-How, How to find a radius from three points, http://www.ehow.com/how_5899905_radius-three-points.html, last access date: 19.06.2013.
3. Free Patents Online, http://www.freepatentsonline.com/6571655-0-large.jpg, last access date: 20.06.2013.
4. High Power Media, Sealing the Wankel engine, https://www.highpowermedia.com/blog/3140/sealing-the-wankel-engine, last access date: 19.06.2013.
5. Kiper G., Huang C., and Söylemez E., “Numerical Analysis of Planar Cam Follower Mechanisms,” The 2nd IFToMM Asian Conference on Mechanism and Machine Science, Tokyo, Japan, 2012.
6. Litvin F. L., Theory of Gearing, 2nd Edition, Nauka, Moscow, 1968.
7. Litvin F. L., Gear Geometry and Applied Theory, 2nd Edition, Cambridge University Press, Chicago, USA, 2004.
8. Rutgers School of Engineering, http://coewww.rutgers.edu/classes/mae/mae488/hw/lectures/gear/nomenclature.png, last access date: 20.06.2013.
9. The Beall Tool Company, http://www.bealltool.com/, last access date: 18.06.2013.
10. The Jaguar Specialists Web, Supercharging article, http://www.jagweb.com/aj6eng/supercharging_article.html, access date: 19.06.2013.
11. University of Kentucky – College of Engineering, Introduction to Numerical Computing III, http://www.engr.uky.edu/~egr101/vcl/vcl6/6.html, last access date: 18.06.2013.
12. Wikipedia—The Free Encyclopedia, Roots-type Supercharger, http://en.wikipedia.org/wiki/Roots_blower, last access date: 18.06.2013.
13. Wikipedia—The Free Encyclopedia, Gear, http://en.wikipedia.org/wiki/Gear, Last access date: 18.06.2013.
14. Zayas E. E., Cardona S., and Jordi L., “Analysis and synthesis of the displacement function of the follower in constant-breadth cam mechanisms”, Mechanism and Machine Theory, Vol.44, pp 1938-1949, 2009.

校內：立即公開
校外：2014-10-09公開

簡易檢索 / 詳目顯示

相關論文