In my last post, we discussed a way to control the settings of holes using the Preset tools. This is an excellent way to standardize hole configurations across a design group but does require each hole to be configured. If there is an entire category of holes to be modified, or if you’d like to introduce a new category of holes, then creating Preset holes could become a bit cumbersome. In that event, it may be easier to modify the Excel tables that Inventor uses to populate the Clearance, Tapped, and Taper-Tapped hole configurations. Below is an example of a Clearance Excel table.
Thankfully the process for editing the Excel spreadsheets is pretty straightforward. Here are the steps below:
To determine the location of the Excel spreadsheets, we need to open the Project tool and identify the file paths for the Design Data. Within the Design Data, we need to navigate to the Design Data\XLS\en-US location and then make a backup copy of the spreadsheet that we’d like to modify. In this example, we’re modifying a clearance hole, so we’ll need to backup and modify the “clearance.xls”. I typically add a date stamp to my backup files, so I have a history of the modifications that I can fall back on. Of course, if one is using Vault, then previous versions will serve the same purpose.
Once inside the spreadsheet, we have to navigate to the appropriate tab. Since we’re using an imperial fastener, a ¼” socket head screw, we will switch to the “Ansi Unified Screw Threads” tab. Inside this particular tab, the clearance holes are differentiated by the different head types: flat head, hex head, oval head, and socket head. In this example, since we’re looking specifically at the socket head, we’ll look in that section and find the ¼” size and the counterbore depth. We’ll adjust that counter bore depth to 0.270” so that the fastener in the bolted connection is recessed further into the plate.
After closing and restarting Inventor, edit the hole feature and cycle to a different value and then back to the ¼” Socket Head Cap Screw. Notice the value has updated to the new spreadsheet value.
Once the hole has been modified in the part, it is time to adjust the Bolted Connection in the assembly. My STRONG recommendation is to use the “By Hole” option when building Bolted Connections, as this will more easily adjust to changes in the model. In our case, since the Bolted Connection has already been formed, we’ll have to take the extra step of editing the Bolted Connection itself. Fortunately, all one has to do is open the editor and click OK, so no actual changes in the Bolted Connection are required.
Voila! By modifying the Excel Spreadsheet and utilizing the “By Hole” option in the Bolted Connection tool, one can achieve greater control and consistency across the design group. This technique can also be a great way to create your very own Hole Tabs and control all the holes in one location. Hopefully you found this tip helpful and let us know if you have any comments or questions. Happy Blogging and have a most blessed day!
Link to YouTube Video:
Download the PDF file for this post!
Do you use any of these tips and tricks in your daily workflow? Feel free to brag about your success in the comments!
Like what you’ve read? Subscribe to our blog!
Feel free to share on Twitter or Facebook!