臺灣博碩士論文加值系統

本公司產製之移動儲櫃，針對資料儲存之作業空間做最有效運用、規劃、設計和製造。傳統固定儲櫃需以一條通道配合一座儲櫃為設計條件，移動儲櫃能更有效率利用空間，規劃設計的過程更為重要。以春源鋼鐵自動倉儲事業部輕量型移動櫃規劃案為例，工程師在規劃場地時，常需要透過繪圖軟體來模擬現地情形來決定櫃體所使用的規格。一般的繪圖軟體操作過於繁複，對於初學者或年齡較高的資深工程師來說不容易上手，且軟體的學習不是短期內可精通的。目前廠內2D介面不易清楚表達規劃的概念，容易造成疏忽、遺漏；由於員工年齡層普遍偏高，這類困難在春源鋼鐵是相當顯而易見的。
本次研究即是開發一套針對輕量型移動櫃參數式規劃工具。首先引進Solid works 3D 繪圖軟體取代目前Auto CAD 2D繪圖軟體，藉由Solid works標準圖檔加上VBA參數式控制達到自動繪圖、規劃的功能，接著輸出電子圖檔取代傳統傳真簽認費。此種「參數式自動規劃軟體」概念實際應用於春源鋼鐵自動倉儲事業部輕量型移動櫃規劃案例中，成功達到自動規劃的需求，證實「參數式自動規劃軟體」概念可達到本研究原先設定的目標。

The mobile shelving storage system can effectively utilize the operation spaces of information storage. Traditionally stationary shelving storage needs an aisle to go with a set of storage shelving. To efficiently use the space, the planning and design for the mobile shelving storage system is more important.

When engineers from the Automated Storage System Division of Chun Yuan Steel plan the field layout for a light-duty mobile shelving project, they often use engineering graphics software to simulate the field conditions and determine the specifications of shelves. General engineering graphics software is too complicated for beginners or senior engineers, and it is difficult for them to learn the software in a short period of time. In addition, the 2D engineering graphics software currently used in the company cannot express the conceptions of planning clearly, and may easily lead to an oversight and omission. This is an apparent problem in Chun Yuan Steel Industrial Company, where the majority of employees are older.

This study develops a set of parametric planning tool mainly for the light-duty mobile shelving. A Solid Works 3D graphics software was firstly introduced to replace the Auto CAD 2D graphics software currently in use, so that the functions of automatic drafting and planning can be achieved through the aid of standard drawing files from the Solid works and VBA parametric control. The output of the system are electronic drawing files, which replaces the traditional faxed copies. Practically implementation of the “parametrically automatic planning software” proves to be successful for the Automated Storage System Division of Chun Yuan Steel in planning for the light-duty mobile shelving project. The goal for this study is achieved.

目 錄

書名頁…………………………………………………………………i
論文口試委員審定書…………………………………………………ii
授權書…………………………………………………………………iii
中文摘要………………………………………………………………iv
英文摘要………………………………………………………………v
誌謝.………………………………………………………………… vi
目錄……………………………………………………………………vii
表目錄……………………………………………………………… viii
圖目錄……………………………………………………………… ix

一、 研究背景與目的………………………………………1
1.1 輕量型移動櫃簡介………………………………… 1
1.2 問題與研究目的…………………………………… 2
1.3 輕量型移動櫃設計規劃流程 ………………………3
1.4 自動參數式規劃技術架構………………………… 5

二、 以繪圖軟體SolidWorks作圖面圓形的建立………… 7
2.2 輕量型移動櫃標準零件圖的建立……………………7
2.2 輕量型移動櫃標準組合圖的建立……………………9

三、 以VBA進行參數式自動規劃軟體撰寫…………………14
3.1 程式架構……………………………………………… 14
3.2 程式說明……………………………………………… 17

四、 實例操作驗證.…………………………………………25
4.1 實際案例輸入驗證…………………………………… 25
4.2 系統使用評估………………………………………… 30

五、 結論與討論…………………………………………… 32

參考文獻…………………………………………………………… 33

1. elearningDJ，Solidworks 2007實戰演練：進階應用，知城出版社，台北，民國九
十五年。
2.王鴻儒，Excel VBA 2007程式設計，博碩文化出版社，台北，民國九十七年。