Material assignment in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This table shows parts and their assigned materials in a SolidWorks project.

Cell	Value
A1	Part
B1	Material
A2	Bracket
B2	Steel
A3	Shaft
B3	Aluminum
A4	Cover
B4	Plastic

Formula Trace

IF(B2="Steel", "High Strength", IF(B2="Aluminum", "Lightweight", "Standard"))

Step 1: B2 = "Steel"

Step 2: IF(TRUE, "High Strength", ...)

Cell Reference Map

    A       B
1 | Part  | Material
2 | Bracket | Steel  <--- referenced
3 | Shaft   | Aluminum
4 | Cover   | Plastic

The formula checks the material in cell B2 to decide the strength category.

Result

    A       B          C
1 | Part  | Material | Strength Category
2 | Bracket | Steel  | High Strength
3 | Shaft   | Aluminum | 
4 | Cover   | Plastic  | 

The formula result 'High Strength' is shown in column C for the Bracket part based on its material.

Sheet Trace Quiz - 3 Questions

What does the formula return if the material in B2 is 'Steel'?

A Standard

B Lightweight

C High Strength

D Error

Key Result

IF(condition1, result1, IF(condition2, result2, default_result))

Practice

1. What is the main purpose of Material Assignment in SolidWorks?

easy

A. To define what the part is made of, affecting weight and strength

B. To change the color of the part only

C. To create a new sketch on the part

D. To export the part to another file format

Solution

1. Step 1: Understand material assignment role

   Material assignment tells SolidWorks what material the part uses, which affects physical properties like weight and strength.

2. Step 2: Identify correct purpose

   Changing color or exporting files are unrelated to material assignment's main function.

3. Final Answer:

   To define what the part is made of, affecting weight and strength -> Option A

4. Quick Check:

   Material assignment = defines material properties [OK]

Hint: Material assignment sets physical properties, not just appearance [OK]

Common Mistakes:

• Thinking material only changes color
• Confusing material assignment with sketching
• Assuming material affects file export

2. Which of the following is the correct way to assign a material to a part in SolidWorks?

easy

A. Go to File > Save As and choose material

B. Double-click the sketch and type the material name

C. Right-click the part in the FeatureManager and select 'Edit Material'

D. Use the Measure tool to assign material

Solution

1. Step 1: Locate material assignment method

   In SolidWorks, you assign material by right-clicking the part in the FeatureManager and choosing 'Edit Material'.

2. Step 2: Eliminate incorrect options

   Double-clicking sketches, saving files, or using the Measure tool do not assign materials.

3. Final Answer:

   Right-click the part in the FeatureManager and select 'Edit Material' -> Option C

4. Quick Check:

   Material assigned via FeatureManager right-click [OK]

Hint: Right-click part in FeatureManager to assign material quickly [OK]

Common Mistakes:

• Trying to assign material inside sketches
• Looking for material in File menu
• Using unrelated tools like Measure

3. If you assign Aluminum 6061-T6 as the material to a part, what will happen to the part's weight compared to no material assigned?

medium

A. The weight will be calculated based on Aluminum's density

B. The weight will remain zero because material doesn't affect weight

C. The weight will double automatically

D. The weight will be set to a default value of 1 kg

Solution

1. Step 1: Understand effect of material on weight

   Assigning Aluminum 6061-T6 sets the density, so SolidWorks calculates weight using volume x density.

2. Step 2: Compare to no material assigned

   Without material, weight is zero or undefined; assigning material updates weight correctly.

3. Final Answer:

   The weight will be calculated based on Aluminum's density -> Option A

4. Quick Check:

   Material assignment updates weight using density [OK]

Hint: Material sets density; weight = volume x density [OK]

Common Mistakes:

• Assuming weight stays zero without material
• Thinking weight doubles automatically
• Believing weight defaults to 1 kg

4. You assigned a material to a part, but the weight still shows zero. What is the most likely cause?

medium

A. You assigned the material to the sketch instead of the part

B. You forgot to save the file

C. The material library is corrupted

D. The part has zero volume or no geometry

Solution

1. Step 1: Check part geometry

   If the part has zero volume (no 3D shape), weight will be zero even if material is assigned.

2. Step 2: Rule out other causes

   Assigning material to sketches is not possible; corrupted library or unsaved file won't cause zero weight directly.

3. Final Answer:

   The part has zero volume or no geometry -> Option D

4. Quick Check:

   Zero volume means zero weight despite material [OK]

Hint: Check part volume if weight stays zero after material assignment [OK]

Common Mistakes:

• Trying to assign material to sketches
• Blaming file save status
• Assuming material library corruption causes zero weight

5. You want to analyze the stress on a part made of Steel AISI 1020. Which step should you do first to get accurate simulation results?

hard

A. Export the part to a different CAD software

B. Assign Steel AISI 1020 as the material before running the simulation

C. Change the part color to gray to represent steel

D. Run the simulation without assigning any material

Solution

1. Step 1: Understand simulation requirements

   Accurate stress analysis needs correct material properties like Young's modulus and yield strength.

2. Step 2: Assign correct material

   Assigning Steel AISI 1020 sets these properties, enabling accurate simulation results.

3. Step 3: Avoid unrelated steps

   Changing color or exporting files does not affect simulation accuracy; running simulation without material gives wrong results.

4. Final Answer:

   Assign Steel AISI 1020 as the material before running the simulation -> Option B

5. Quick Check:

   Material assignment before simulation ensures accuracy [OK]

Hint: Assign material before simulation for correct physical properties [OK]

Common Mistakes:

• Running simulation without material assigned
• Thinking color affects simulation
• Exporting instead of assigning material