Adding fasteners to Clearance & Thread spreadsheets

[Anonymous]

I would like to add a "Shoulder Bolt" fastener (both Inch & Metric) to the Clearance.xls file so that when selected it would generate a counterbore hole the size of the shaft and a corresponding thread specific to the bolt size (all of which I can input in the table) but currently I have to do this manually by selecting a "counterbore - thru thread" condition.

Also, we use Helicoil inserts a lot and would like to add this to the Thread.xls but I need Inventor to differentiate between a standard threaded hole & the Helicoil so that the hole callout on the drawing will come in as desired.

Is there any way these can be accomplished?

Jack Pelon

Mechanical  Designer

Inventor Professional 2013

[Anonymous]

I would like to add a "Shoulder Bolt" fastener (both Inch & Metric) to the Clearance.xls file so that when selected it would generate a counterbore hole the size of the shaft and a corresponding thread specific to the bolt size (all of which I can input in the table) but currently I have to do this manually by selecting a "counterbore - thru thread" condition.

Also, we use Helicoil inserts a lot and would like to add this to the Thread.xls but I need Inventor to differentiate between a standard threaded hole & the Helicoil so that the hole callout on the drawing will come in as desired.

Is there any way these can be accomplished?

Jack Pelon

Mechanical  Designer

Inventor Professional 2013

[Anonymous]

as an experiment, I customized both the Clearance and Thread excel docs (see attached) but ran into some aggrevating issues with regards to how customizable (or lack thereof) the Hole Wizard really is.

As the CAD manager, I was able to manipulate the available options within the excel files and the hole callout note format to get some of the desired results but I feel there should be an easier way.

In the industry I'm in, it's desirable to have the software/hardware do as much of the work as possible to prevent mistakes by human error.

I will try to upload a PDF that outlines what I was able to accomplish as well as some tweaks that would allow CAD managers the ability to have some more control over what would be automatically calculated by the software.

[Anonymous]

heres the PDF...