AnsweredAssumed Answered

Controlling Hole Wizard sizes with a lookup function in Excel

Question asked by 1-SNSTXK on Aug 19, 2010

I have a series of parts I'm designing that, in part, conform to the API Standard for flange dimensions. I have copied the API dimensions table to sheet 2 of the design table and the model flange dimensions are controlled by the VLOOKUP function. All of that works fine. The problem is with the Hole Wizard drop down list in the design table. I could use an extruded hole on the flange end but on the other end of the part I have threaded holes that will also vary by configuration. Also, I want the hole annotation in the drawing file to be automated. I have the hole sizes listed in the API dimensions table but how do I link it to the dropdown list for the Hole Wizard sizes?

Outcomes