Computer Aided Exhaust Valve Design Automation using Creo and Microsoft Excel Spreadsheet

:- 3D Modeling has been widely used because of their ease in understanding, visualization, and generation of manufacturing drawing compared to 2D drafting. However modeling process is a time consuming and many draftsmen do not have the skills of performing such task. Exhaust valve is one of the component reputedly required nearly in all ic engines. It is the nose of the combustion engine to return exhaust gases out at a time of exhaust stroke. There are many tools and computer languages like C, C++, Python, Visual basic, Go language etc useful for task automation. In this paper we are automate the designing and solid modeling task of exhaust valve by creating graphical user tool to take input parameters required for exhaust valve design using visual basic programming language into the excel spreadsheet and integrate this spreadsheet with Creo or Pro-Engineering parametric tool for 3D solid modeling automation. To demonstrate our study we are considered to automate the exhaust valve design and solid model generation made by authors S.S Gawale & Dr S.N Shelke(8).


INTRODUCTION
Exhaust valve is the Mechanical component useful to push the exhaust gases out form the combustion chamber at a time of exhaust stroke. The valve should be well design to fit in size with outlet port of the internal combustion engine. The exhaust valve is useful in both petrol and diesel engines. The design of valve is based on various parameters like inlet port diameter, cylinder bore, stroke, and Engine rpm, Mean velocity of gas, type of material used to manufacture, and pressure acting on the valve head and different parameters of the internal combustion engine. Different parameters lead to different valve dimension hence automation is need. By using excel spreadsheet and creo parametric it is possible to automate the 3d solid modeling of the exhaust valve.
2. LITERATURE REVIEW Many attempts has researcher been made in area of parametric Modeling and there relations. [1] Song-Hao Wang et al are presented the unique idea of liquid foot packaging product design using excel spreadsheet and the parametric relation in Pro-Engineering wildfire. [2] Umesh and Laukik are presented the development of 3D model with the graphical user interface integrating with the excel spreadsheet and the Cre-O parametric for 3d modeling by considering CI Engine as study point of view. [3] Yuanyuan and Zailiang are describe the parametric spar gear generation by using pro programming toolkit and relation into pro wildfire. They made a graphical tool to create the spar gear by just entering the parametric valve using visual basic programming language. [4] Patel and Thakkar is presented the idea for interrelating through MS Excel and C language by the case study of pulley design. [5] H.M.A Hussein is demonstrate the blanking die design based on the available data by using Catia v5 scripting and the visual basic. He constructed knowledge based expert system for blanking dies. [6] QingMing Fan et al is presented their work to automate the development of standard die set library by family table in wildfire 2.0 interface by the visual c++ and Pro/Toolkit. [7] Bhaval B Shah an attempt has been made to integrate Autodesk Inventor with Microsoft Excel spreadsheet for creation of modeling and manufacturing drawing. They considered a flange coupling as an example for their study point of view. [8] Snehal and Dr S.N.Shelke are designed the exhaust valve and studied the stress concentration by varying different fillet parameters for the diesel engine. Further best material is recommended.

METHODOLOGY FOR MODELING AUTOMATION
Cre-O is the most popular Application in the Engineering field. It has verity of applications not only in the engineering but where there is need of 3d solid modeling visualization and simulation of the components. Many feature s are available in the creo one of useful feature is Pro/Program. Pro/program runs at the background during the creo session and it changes and update automatically feature component and the relation added to the part of assembly. The Pro/Program gives parameters dimensions and the relation of the part. Pro/Program reflects all the data in the text data form this data can be modified to add new feature, update the model, and delete existing feature and change the dimensions of the feature. With the proper user interface (API) the user can directly create and modify the 3d model by just giving the input value. Here in the Pro/Engineering the Microsoft excel spreadsheet is integrated with the excel analysis feature. Excel analysis is the feature useful to interact to the excel cells text data in the Creo. Excel analysis tool transfer the excel spreadsheet data to the Pro/E database. There data can related to the part feature data. Hence the spreadsheets data is equal to the data of the part that is dimensions of the model. By just changing and upgrading the data of the spreadsheet will upgrade the dimensions of the Part.

Creating Microsoft Excel Spreadsheets
Microsoft excel sheet is the set of empty boxes generally called as cells integrated by different mathematical relations to add, remove and modify the text data from the cells. An excel spreadsheet containing the valve design parameters names with respective to feature and the dimension's has been prepared. The customized Engine Specification buttons is added near to the dimensions of the valve to open up the graphical user form to take input for further processing. Similarly save button is added to automatically save the all spreadsheet data once user click on the button as show in figure 1. The excel spreadsheet file is saved as macro-enable excel workbook .xlsm file format.

Create Graphical User Tool
Graphical user tool is the type of user form useful to take engine parameters as input values from the user in the text form. Graphical tool has been create using visual basic editor available In Microsoft excel spreadsheet under the developer option. Graphical tool is combined with engine specification button Figure 1 as soon as user click on engine specification button graphical user tool will be popup Figure 2 represent the smart look named as graphical user tool. It is the real time interaction when user click the Engine specification button. Later manually insert the values of parameters mentioned in the graphical user tool responsible to design the Exhaust valve. We are inserted engine specifications of valve design made by Gawale, S. S., & Shelke D. S (8). The program has been wrote behind the user tool such as to get resultant valve specification values from the program directly into the excel cells when user click on the create button figure 1 that is our Exhaust valve design dimensions.  The Program has been wrote so that it will automatically calculate the valve dimension from parameters of engine specifications figure 2. Program is well developed considering all the conditions the program automatically clear all the valves from the boxes when user click of the clear button. GUI will be disappear when click on close button. This tool will suggest either the design is safe or not based on the parameters user inserted into the graphical user form.

Creating the 3d Model
A 3d part of the component is design with proper feature and dimensions. The accurate design of the 3d solid object leads to better accuracy and visualization. Different constraints has been applied to the model. Figure 3 represent the 3d object with constraints and the dimension obtained from the visual basic program as per the Engine specifications into the excel spreadsheet and this output assigned to the solid part.  As soon as we click on the excel analysis icon new Excel analysis dialog box will be popup. The excel sheet we have created before is loaded into using "load file" option button from the dialog box. Next click on the "output cells" icon. Small menu manager dialog box will popup. After without touching to menu manager select all the cells range from the excel spreadsheet in which all the parametric dimensions values related to the feature is present then click on "done sel" option from the menu manager dialog box. Later select the compute button Pro/E API will automatically transfer the data from the excel spreadsheet. All the cells range data we selected will be appeared in the result section of the dialog box as show in the Figure 5 with smart numbered bullets in our case. After that click on the add feature option button give the proper name of the features to save this data into the Pro/E database as the feature before closing the Excel analysis dialog box save feature will get automatically add to the design tree as show in the

Assigning data with part feature
To relate the excel spreadsheet data and the Creo solid part feature data special command exist in the modal option from the intent menu called relations. Select the Relation button relation dialog box will be open then select all feature from the model tree as soon as we select the feature its relative dimension will be flash as show in Figure 7 then select the feature as d3 in our case. then go to insert→from list then parametric dialog box will be appear next click on look in menu and select feature option then click on the feature name as saved previously suddenly all the dimensions added from the excel spreadsheet will be popup now select respective parameter then click on the insert selected icon button as show in Figure 8 in such a way relation will get assigned to respective valve feature. Similarly do the same procedure one by one to relate feature and the dimension. such a way new relations has been created between the every feature and the dimension from the excel spreadsheet to the Pro/E solid Part finally verify the relation as per the dimension and click on ok which makes Excel and Pro/E completely integrated Now save all the component setup for future reference Show in Figure 9. Finally we integrate the excel spreadsheet and the creo parametric to automate the design and solid modeling generation tasks. User is now ready to make a solid 3d object of exhaust valve by just entering the input parameters needed to design exhaust valve into the graphical user tool by click on engine specification button form excel spreadsheet. Graphical user tool will automatically calculate the dimensions of exhaust valve and save it into excel spreadsheet save the sheet by clicking on save button. Now update the model from the Creo feature tree it will automatically assign the valve dimensions as per the MS sheet data. 3D generated solid object of exhaust valve as per the engine specification is show in figure 10. www.ijert.org Vol. 9 Issue 08, August-2020 5 CONCLUSION A generic solid model of exhaust valve and the Microsoft Excel spreadsheet has been created. Graphical user tool is created inside the Microsoft excel sheet to automate the exhaust valve design procedure. Later all the data from the Microsoft excel sheet has been transferred to Creo by using excel analysis tool. All the transfer data then relate to the respective tool feature using relation tool. In this way Microsoft excel sheet is relate to the component in creo for solid model creation. User can also create their custom valve as per their need by just modifying the excel sheet data. This takes very less time to generate the 3D solid model compared to make them manually. Our study demonstrate automation technique for exhaust valve design calculation and solid model generation. Similar technique is useful to design 3D solid model of exhaust valve based on different engine specification of different dimensions. In future this model is further proceed to export for analysis purpose. Even it would be easy to generate the NC program to manufacture the components.
ACKNOWLEDGEMENT All the work is done under guidance of Maharashtra institute of technology Aurangabad, special thanks to Mechanical department for their support. REFERENCES.