Platform: Autodesk Inventor Professional
Level of difficulty: Beginners
Author: Ndianabasi Udonkang
Follow me on Twitter | Facebook
This is the second lesson in our series about using and understanding parameters in Autodesk Inventor Professional. In the first lesson, we got ourselves familiarized with the general concepts on parameters. In case you missed the first lesson, read it here: Using and Understanding Parameters in Autodesk Inventor - Part 1.
LEARNING OBJECTIVES
At the end of this lesson, you should be able to:
- Create user-defined parameters using Microsoft Office Excel.
- Link the Excel spreadsheet document to a part or assembly file inside Autodesk Inventor.
- Update an Inventor part or assembly file when changes have been made to the source spreadsheet file.
OVERVIEW
In Autodesk Inventor, a Microsoft Office Excel spreadsheet file can be used to create user-defined parameters which then can be linked to a part or assembly file. This way, a single Excel spreadsheet file can be reused across many Inventor files as the source for user-defined parameters. Excel spreadsheet files have the file extensions ".xls" for Excel 2003 documents, and ".xlsx" for Excel 2007 and 2010 documents. For you to understand this topic, it is required that you have a basic understanding of how equations are created in Microsoft Office Excel.
Linking parameters has an obvious advantage since you do not need to create the same parameters in each Inventor file you create. This is also the principle behind many features and standard parts including Thread features, Bolted Connections, gears, etc.
There is a major drawback in using external spreadsheet files as sources of user-defined parameters. Now imagine losing the spreadsheet files in unfortunate circumstances; this means you have also lost all the parameters that were stored in them, and your Inventor files will become useless! This is often the situation with people who play with their thread.xls file and find themselves unable to create thread features and bolted connections. So be careful and make sure that you backup your spreadsheet files.
So let us get started! The process of creating and using linked parameters in Autodesk Inventor will be divided into the following steps:
STEP 1: CREATE THE MICROSOFT EXCEL SPREADSHEET FILE
In creating an Excel spreadsheet file that will be linked to an Inventor file, a format must be followed. Just as the Parameters dialog box in Inventor, the parameters are arranged in rows and the parameter variables are arranged in columns. For such an Excel spreadsheet file, four variables are basically sufficient. They are:
- The parameter name;
- The parameter value;
- The parameter units; and
- The parameter comment.
For more about the different variables, check out this first lesson about parameters, Using and Understanding Parameters in Autodesk Inventor - Part 1. However, I will mention that you are not required to fill the Units column if the units of the parameters are the same as that of the template used in creating the Inventor file.
PROCEDURE:
- Launch Microsoft Office Excel 2003, 2007 or 2010 through any means known to you. For Windows 7 and Vista users, go to Start Menu > All Programs > Microsoft Office > Microsoft Office Excel 200x.
- In the Excel environment, create the spreadsheet shown below.
- Save the file with the name "Linked_Parameters" in the project folder of the project you wish to use. For example, mine is saved in the Training folder – which is the folder for my active Inventor project (C:\Users\Ndianabasi\Documents\Inventor\Training).
STEP 2: CREATE A NEW INVENTOR PART FILE
Here you are going to create a new Autodesk Inventor part file.
PROCEDURE:
- In Autodesk Inventor, create a new part file using the Standard (mm).ipt template. Pressing CTRL+N is a fast way of achieving this. The Standard (mm).ipt template is found on the Metric tab of the New File dialog box.
- Use the Rectangle tool to create a rectangle over the center of the sketch.
- Constrain the rectangle to be centered around the center of the sketch using the Vertical and Horizontal constraints. Finish the sketch and save the file as Linked_Parameters.ipt.
STEP 3. LINK THE SPREADSHEET FILE TO THE INVENTOR PART FILE
Here we are going to learn how to link the previously created spreadsheet file to the just created Inventor Part file.
- On the Ribbon, go the Manage tab > Parameters panel > Parameters tool. Click on the Link button at the bottom of the Parameters dialog box.
- On the Open dialog box, scroll down the project folder and select the Excel spreadsheet file Linked_Parameters.xlsx or Linked_Parameters.xls depending on the Excel version that was used.
- At the bottom of the Open dialog box, change the Start Cell from A1 to A2. This value is changed because the actual parameter data starts from cell A2; the first row was used to define the column headers. Click the Open button.
- The Excel parameters are now linked to the Parameters dialog box as shown below.
- Click Done to close the dialog box.
STEP 4: MAKING USE OF THE LINKED PARAMETERS
In this section we are going to learn how to use the linked parameters inside the Inventor part file.
- Double click Sketch1 on the Model Browser of Linked_Parameters.ipt.
- On the Sketch tab > Constrain panel, click on the Dimension tool (Shortcut = D).
- Click one of the horizontal lines and click below the line to place the dimension. The Edit Dimension box should be displayed to allow you edit the size of the dimension. If it does not come up, right click on the graphics area immediately and activate Edit Dimension on the context menu.
- On the Edit Dimension box, while the dimensions to be edited are highlighted, click on the arrow pointing towards the right of the screen or right click the input area. Click List Parameters on the context menu.
- The Parameters list box pops up with the three linked parameters. Click on Box_Length.
- Click the green tick at the end of the Edit Dimension box to return the parameter.
- Repeat step 2 to 7 and dimension the vertical line using the Box_Width parameter.
- Click Finish Sketch on the Exit panel. Your unconsumed sketch should appear as shown below.
- On the Model tab > Create panel, click on the Extrude tool (Shortcut = E). On the Extrude dialog box, highlight the Distance1 parameter and click the arrow pointing to the right of the screen. On the context menu, click List Parameters. On the Parameters list box, click Box_Height. Click OK to create the Extrude feature.
- Save the file (CTRL+S).
STEP 5. UPDATING THE MODEL BY CHANGING THE VALUES OF THE PARAMETERS IN THE EXCEL SPREADSHEET FILE.
Here we are going to learn how to changes to the values of parameters in the Excel spreadsheet file are reflected on the part file.
- Using Windows Explorer, navigate and open the Linked_Parameters.xlsx file saved in your project folder e.g. C:\Users\Ndianabasi\Documents\Inventor\Training\Linked_Parameters.xlsx.
- Change the value of Box_Height parameter to 20.
- Save and close the Excel file.
- Return to the part file and glance up at the Quick Access Toolbar at the top of the application just by the left of the title bar and by the right of the Menu Browser. Inventor has detected the changes make to the Excel spreadsheet file and indicates that an update is necessary.
- Click on the Local Update button on the Quick Access Toolbar as shown below.
- The part updates accordingly.
CONCLUSION
I hope that the tutorial was beneficial. Drop a comment or contact me. Thanks for stopping by.