Bird
Raised Fist0
Solidworksbi_tool~10 mins

Hole wizard for standard holes in Solidworks - Cell-by-Cell Formula Trace

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Sample Data

This table lists standard hole types with their diameters, depths, and standards used in SolidWorks Hole Wizard.

CellValue
A1Hole Type
B1Diameter (mm)
C1Depth (mm)
D1Standard
A2Clearance Hole
B210
C220
D2ISO
A3Tapped Hole
B38
C315
D3ANSI
A4Counterbore
B412
C425
D4ISO
Formula Trace
IF(D2="ISO", B2*1.1, B2*1.05)
Step 1: D2="ISO"
Step 2: B2*1.1
Step 3: IF(D2="ISO", B2*1.1, B2*1.05)
Cell Reference Map
    A       B       C       D
1 |Hole Type|Diameter|Depth  |Standard
2 |Clearance|  10   |  20   | ISO  
3 |Tapped   |   8   |  15   | ANSI 
4 |Counterb.|  12   |  25   | ISO  

Formula references cells B2 and D2 for calculation.
The formula uses the diameter in B2 and the standard in D2 to calculate an adjusted hole diameter.
Result
    A       B       C       D       E
1 |Hole Type|Diameter|Depth  |Standard|Adj Dia
2 |Clearance|  10   |  20   | ISO    |  11   
3 |Tapped   |   8   |  15   | ANSI   |       
4 |Counterb.|  12   |  25   | ISO    |       

Column E shows the adjusted diameter calculated by the formula for row 2.
The adjusted diameter for the clearance hole is 11 mm, calculated by increasing the original diameter by 10% for ISO standard.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula check first?
AIf the standard is ISO
BIf the diameter is greater than 10
CIf the depth is 20
DIf the hole type is Clearance
Key Result
IF(condition, value_if_true, value_if_false) chooses calculation based on hole standard.

Practice

(1/5)
1. What is the main purpose of the Hole Wizard in SolidWorks?
easy
A. To simulate mechanical stress on parts
B. To design complex 3D shapes from scratch
C. To quickly create standard holes with predefined sizes and types
D. To export drawings to PDF format

Solution

  1. Step 1: Understand Hole Wizard functionality

    The Hole Wizard is a tool designed to create holes using standard sizes and types quickly.

  2. Step 2: Compare options

    Options A, B, and D describe unrelated functions like simulation, 3D modeling, and exporting, which are not the Hole Wizard's purpose.

  3. Final Answer:

    To quickly create standard holes with predefined sizes and types -> Option C

  4. Quick Check:

    Hole Wizard = Standard hole creation [OK]
Hint: Hole Wizard = fast standard hole creation [OK]
Common Mistakes:
  • Confusing Hole Wizard with simulation tools
  • Thinking it creates complex shapes
  • Assuming it exports files
2. Which of the following is the correct first step to create a hole using the Hole Wizard in SolidWorks?
easy
A. Select the Hole Wizard tool and choose the hole type
B. Draw a circle on the part surface
C. Apply a fillet to the edge
D. Export the part as a STEP file

Solution

  1. Step 1: Identify the Hole Wizard workflow

    The first step is to select the Hole Wizard tool and then pick the hole type you want to create.

  2. Step 2: Eliminate unrelated steps

    Drawing a circle, applying fillets, or exporting files are unrelated to starting the Hole Wizard process.

  3. Final Answer:

    Select the Hole Wizard tool and choose the hole type -> Option A

  4. Quick Check:

    Start Hole Wizard = Select tool + hole type [OK]
Hint: Always start by selecting Hole Wizard tool [OK]
Common Mistakes:
  • Trying to draw holes manually first
  • Confusing fillet with hole creation
  • Skipping Hole Wizard selection
3. Given the following steps in Hole Wizard: select 'Tapped Hole', choose size M6, set depth 10mm, and place on the face. What will be the result?
medium
A. No hole is created due to missing sketch
B. A 10mm diameter clearance hole is created
C. A 6mm diameter counterbore hole is created
D. A 6mm diameter threaded hole 10mm deep is created

Solution

  1. Step 1: Interpret Hole Wizard settings

    Choosing 'Tapped Hole' with size M6 means a threaded hole with 6mm nominal diameter is selected.

  2. Step 2: Understand depth and placement

    Setting depth to 10mm means the hole will be drilled 10mm deep on the selected face.

  3. Final Answer:

    A 6mm diameter threaded hole 10mm deep is created -> Option D

  4. Quick Check:

    Tapped Hole M6 + 10mm depth = threaded hole 6mm diameter [OK]
Hint: Tapped Hole M6 means 6mm threaded hole [OK]
Common Mistakes:
  • Confusing tapped hole with clearance hole
  • Ignoring depth setting
  • Assuming counterbore instead of tapped
4. You tried to create a counterbore hole using Hole Wizard but the hole depth is not applying correctly. What is the most likely cause?
medium
A. You did not select the correct hole type before setting depth
B. The part is not saved
C. You forgot to add a fillet before the hole
D. The Hole Wizard tool is not installed

Solution

  1. Step 1: Analyze the error context

    If hole depth is not applying, it usually means the hole type settings are incorrect or incomplete.

  2. Step 2: Check hole type selection

    Not selecting the correct hole type (e.g., counterbore) before setting depth causes the depth parameter to be ignored or misapplied.

  3. Final Answer:

    You did not select the correct hole type before setting depth -> Option A

  4. Quick Check:

    Wrong hole type = depth not applied [OK]
Hint: Always pick hole type before setting depth [OK]
Common Mistakes:
  • Ignoring hole type selection
  • Thinking saving affects hole depth
  • Assuming fillet is required
  • Believing tool installation causes this
5. You need to create a part with multiple holes: a 10mm clearance hole, a 6mm tapped hole, and a 12mm counterbore hole. Using Hole Wizard, which sequence of actions is best to ensure correct hole types and sizes?
hard
A. Create one hole type and copy it multiple times, then manually edit sizes
B. Create each hole separately by selecting the correct hole type and size in Hole Wizard, then place them on the part
C. Draw circles for all holes and then convert them to holes using Hole Wizard
D. Create all holes as clearance holes and later change types in the feature tree

Solution

  1. Step 1: Understand Hole Wizard best practice

    Each hole type requires selecting the correct hole type and size in Hole Wizard to apply proper parameters.

  2. Step 2: Evaluate options for multiple holes

    Creating holes separately ensures correct hole features; copying and manual edits or drawing circles first can cause errors or inconsistencies.

  3. Final Answer:

    Create each hole separately by selecting the correct hole type and size in Hole Wizard, then place them on the part -> Option B

  4. Quick Check:

    Separate hole creation = correct types and sizes [OK]
Hint: Create holes one by one with correct type [OK]
Common Mistakes:
  • Copying holes and editing sizes manually
  • Drawing circles before Hole Wizard
  • Creating all holes as clearance holes