I recently had a client ask how they could compute the total mass of an assembly in their drawing’s parts list. After some back and forth, I showed him how to extract the mass value for an entire assembly and place that into his title block (which I’ll blog about in a future post). However, during the discussion, we demonstrated a couple of tools that we don’t use very often, substituting a value in an Inventor Parts List and then grouping the values together. In part 1 of this mini-series, I’m going to lay out the steps to use a value substitution for the estimated cost.
I don’t use the mass too often, but I’m often concerned about component costs. For example, in this homemade desk riser assembly, I’m interested in figuring out how much the parts are going to cost, and not just one part, but the whole quantity of parts. In order to quantify this on a print, I’m going to modify a standard parts list.
The first step to edit this Parts List is to add the Estimated Cost column. However, this Estimated Cost column will just be the individual component cost and I want to show the total cost for the entire quantity of an item. In order to do this, I’m going to perform a value substitution for these column values. The following steps will help us accomplish the task:
- Right click on the Parts List and choose the Edit Parts List command.
- Select the Column Chooser tool and select the Estimated Cost column to the Parts List. To see the Results click Apply and note the resulting Parts List.
- Now that the Estimated Cost column is added, right click on the Estimated Cost column heading and choose the Format Column tool.
- Choose the Substitution tab, set the Radio Button to Enable Value Substitution, use the value of Estimated Cost and then merge the rows as Sum of Values. Click OK to exit the Format Column tool and then click OK to exit the Parts List editor.
So that’s how one can show the total cost for the entire quantity of a particular item. This technique isn’t just limited to Estimated Cost, it can be many different property values. Give it a try and leave a comment to let me know what you think. In Part 2 of this blog mini – series, I’ll demonstrate how to group the components together to be able to gather the cost for an entire category of items. Until then, hope this helps, happy blogging and have a most blessed night!