Grounding and fixing components in Solidworks - Cell-by-Cell Formula Trace

Sample Data

List of components in an assembly with their grounding or fixing status

Cell	Value
A1	Component
B1	Status
A2	Base Plate
B2	Fixed
A3	Arm
B3	Grounded
A4	Bolt
B4	Floating
A5	Cover
B5	Fixed

Formula Trace

=COUNTIF(B2:B5, "Fixed") + COUNTIF(B2:B5, "Grounded")

Step 1: COUNTIF(B2:B5, "Fixed")

Step 2: COUNTIF(B2:B5, "Grounded")

Step 3: 2 + 1

Cell Reference Map

    A         B
1 Component  Status
2 Base Plate Fixed  <-- counted
3 Arm        Grounded <-- counted
4 Bolt       Floating
5 Cover      Fixed  <-- counted

Cells B2 to B5 are checked for 'Fixed' and 'Grounded' statuses

Result

    A         B         C
1 Component  Status    Count Fixed+Grounded
2 Base Plate Fixed     3
3 Arm        Grounded
4 Bolt       Floating
5 Cover      Fixed

The formula result 3 shows total components that are either fixed or grounded

Sheet Trace Quiz - 3 Questions

How many components are fixed according to the formula trace?

A 3

B 1

C 2

D 4

Key Result

COUNTIF(range, "Fixed") + COUNTIF(range, "Grounded") counts components fixed or grounded

Practice

1. What is the main purpose of grounding a component in a SolidWorks assembly?

easy

A. To fix the component relative to the assembly origin so it doesn't move

B. To allow the component to move freely within the assembly

C. To delete the component from the assembly

D. To change the color of the component

Solution

1. Step 1: Understand grounding concept

   Grounding fixes a component relative to the assembly origin, preventing movement.

2. Step 2: Compare options

   Only To fix the component relative to the assembly origin so it doesn't move correctly describes grounding's purpose; others are unrelated.

3. Final Answer:

   To fix the component relative to the assembly origin so it doesn't move -> Option A

4. Quick Check:

   Grounding = Fix relative to origin [OK]

Hint: Grounding locks position to origin, no movement allowed [OK]

Common Mistakes:

• Confusing grounding with allowing free movement
• Thinking grounding deletes the part
• Assuming grounding changes appearance

2. Which of the following is the correct way to fix a component in SolidWorks so it cannot move or rotate?

easy

A. Right-click the component and select 'Fix'

B. Delete the component from the assembly

C. Drag the component freely in the assembly

D. Right-click the component and select 'Float'

Solution

1. Step 1: Identify fixing action

   Fixing locks both position and rotation of a component in the assembly.

2. Step 2: Match correct option

   Only Right-click the component and select 'Fix' describes the correct fixing method; others allow movement or remove the part.

3. Final Answer:

   Right-click the component and select 'Fix' -> Option A

4. Quick Check:

   Fix = Lock position and rotation [OK]

Hint: Fix means lock position and rotation, not float [OK]

Common Mistakes:

• Choosing 'Float' which allows movement
• Trying to move a fixed component
• Deleting instead of fixing

3. In an assembly, you ground a component. What happens if you try to drag it away from the origin?

medium

A. The component moves freely to the new position

B. The component rotates but does not move

C. The component is deleted from the assembly

D. The component does not move or rotate

Solution

1. Step 1: Recall grounding effect

   Grounding fixes the component's position and rotation relative to the assembly origin.

2. Step 2: Predict behavior on drag

   Since grounded, the component cannot move or rotate when dragged.

3. Final Answer:

   The component does not move or rotate -> Option D

4. Quick Check:

   Grounded component = no move or rotate [OK]

Hint: Grounded parts stay fixed; dragging won't move them [OK]

Common Mistakes:

• Thinking grounded parts can rotate
• Assuming dragging deletes the part
• Confusing grounding with floating

4. You fixed a component in an assembly but it still moves when you drag it. What is the likely problem?

medium

A. The component is fixed but constraints allow movement

B. You forgot to save the assembly

C. The component is fixed but you are dragging a different part

D. The component is grounded, not fixed

Solution

1. Step 1: Understand fixing behavior

   Fixing locks the component's position and rotation, so it should not move.

2. Step 2: Analyze why movement occurs

   If the fixed component moves, likely you are dragging a different part or subassembly.

3. Final Answer:

   The component is fixed but you are dragging a different part -> Option C

4. Quick Check:

   Fixed = no move; moving means wrong part dragged [OK]

Hint: Check if you selected the right part before dragging [OK]

Common Mistakes:

• Confusing grounding with fixing
• Assuming saving affects fixing
• Ignoring which part is selected

5. You want to assemble a machine where the base must never move, but some parts should rotate around fixed points. How should you use grounding and fixing?

hard

A. Ground the base to fix its position; fix rotating parts to lock rotation

B. Fix the base to lock position and rotation; ground rotating parts to fix position only

C. Ground all parts so none move or rotate

D. Fix all parts so none move or rotate

Solution

1. Step 1: Determine base requirements

   The base must never move or rotate, so it should be fixed.

2. Step 2: Determine rotating parts behavior

   Rotating parts should stay in place but rotate, so grounding (fix position only) is suitable.

3. Final Answer:

   Fix the base to lock position and rotation; ground rotating parts to fix position only -> Option B

4. Quick Check:

   Base fixed; rotating parts grounded [OK]

Hint: Fix base fully; ground parts to allow rotation [OK]

Common Mistakes:

• Grounding base only allows movement
• Fixing rotating parts prevents rotation
• Fixing all parts stops all movement