3D printing export (STL/3MF) in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This table shows 3D parts with their export format, file size, and export time from SolidWorks for 3D printing.

Cell	Value
A1	Part Name
B1	Export Format
C1	File Size (MB)
D1	Export Time (sec)
A2	Gearbox
B2	STL
C2	5.2
D2	12
A3	Bracket
B3	3MF
C3	3.8
D3	9
A4	Cover
B4	STL
C4	2.5
D4	7

Formula Trace

SUMIF(B2:B4, "STL", C2:C4)

Step 1: Check B2:B4 for 'STL' matches

Step 2: Select corresponding C2:C4 values where B2:B4 is 'STL'

Step 3: Sum selected values 5.2 + 2.5

Cell Reference Map

    A       B       C       D
1 | Part  | Format | Size  | Time
2 | Gearbox | STL   | 5.2   | 12
3 | Bracket | 3MF   | 3.8   | 9
4 | Cover   | STL   | 2.5   | 7

Arrows: B2 and B4 match 'STL' -> C2 and C4 values summed

Cells B2 and B4 are checked for 'STL' to select corresponding C2 and C4 values for summing.

Result

    A       B       C       D       E
1 | Part  | Format | Size  | Time  | Total STL Size
2 | Gearbox | STL   | 5.2   | 12    | 7.7
3 | Bracket | 3MF   | 3.8   | 9     |
4 | Cover   | STL   | 2.5   | 7     |

The total file size of parts exported as STL format is 7.7 MB, shown in cell E2.

Sheet Trace Quiz - 3 Questions

Which cells are checked to find parts exported as STL?

A B2:B4

B C2:C4

C A2:A4

D D2:D4

Key Result

SUMIF(range_to_check, criteria, range_to_sum) sums values in range_to_sum where range_to_check meets criteria.

Practice

1. What is the main difference between exporting a model as STL and 3MF in SolidWorks for 3D printing?

easy

A. STL files contain only shape data, while 3MF files can include color and material information.

B. STL files are always smaller than 3MF files.

C. 3MF files cannot be used for 3D printing.

D. STL files include textures and colors, but 3MF files do not.

Solution

1. Step 1: Understand STL file content

   STL files store only the shape geometry of the model as triangles without color or material data.

2. Step 2: Understand 3MF file content

   3MF files can store shape, color, materials, and other printing information, making them richer than STL.

3. Final Answer:

   STL files contain only shape data, while 3MF files can include color and material information. -> Option A

4. Quick Check:

   STL = shape only, 3MF = shape + color/material [OK]

Hint: Remember: STL = shape only, 3MF = shape plus extras [OK]

Common Mistakes:

• Thinking STL files include color or textures
• Assuming 3MF files are not for 3D printing
• Believing STL files always have smaller size

2. Which of the following is the correct way to export a model as an STL file in SolidWorks?

easy

A. File > Save As > Select STL (*.stl) > Click Save

B. File > Export > Choose 3MF > Click Export

C. File > Save As > Select PDF (*.pdf) > Click Save

D. File > Import > Select STL (*.stl) > Click Open

Solution

1. Step 1: Locate export option in SolidWorks

   To export, use File > Save As and choose the desired file type.

2. Step 2: Select STL format correctly

   Choose STL (*.stl) from the dropdown and click Save to export the model as STL.

3. Final Answer:

   File > Save As > Select STL (*.stl) > Click Save -> Option A

4. Quick Check:

   Export STL via Save As > STL [OK]

Hint: Use Save As and pick STL to export 3D print files [OK]

Common Mistakes:

• Using Import instead of Save As to export
• Choosing wrong file type like PDF
• Confusing 3MF export with STL export steps

3. Given a SolidWorks model exported as STL with a very high resolution setting, what is the most likely outcome?

medium

A. The file size will be small, but print quality will be poor.

B. The file size will be large, and print quality will be high.

C. The file will not open in 3D printing software.

D. The model will lose color information.

Solution

1. Step 1: Understand resolution effect on STL export

   Higher resolution means more triangles, increasing file size and detail.

2. Step 2: Relate resolution to print quality

   More detail in the file leads to better print quality but larger file size.

3. Final Answer:

   The file size will be large, and print quality will be high. -> Option B

4. Quick Check:

   High resolution = large file + high quality [OK]

Hint: Higher resolution means bigger file and better print [OK]

Common Mistakes:

• Assuming high resolution reduces file size
• Thinking STL files contain color data
• Believing large files won't open in printers

4. You exported a model as STL but the 3D printer software reports the file is corrupted. What is the most likely cause?

medium

A. You forgot to save the file.

B. You exported the file as 3MF instead of STL.

C. The model has gaps or holes causing a non-manifold mesh.

D. The file size is too small.

Solution

1. Step 1: Identify common STL export issues

   Non-manifold geometry like gaps or holes causes corrupted STL files.

2. Step 2: Understand impact on 3D printer software

   Such errors prevent the printer software from reading the file correctly.

3. Final Answer:

   The model has gaps or holes causing a non-manifold mesh. -> Option C

4. Quick Check:

   Non-manifold mesh = corrupted STL file [OK]

Hint: Check model for gaps before exporting STL [OK]

Common Mistakes:

• Confusing file format with corruption
• Assuming file size causes corruption
• Forgetting to save the file is rarely the cause

5. You want to export a SolidWorks model for 3D printing with color and material info included. Which export format and settings should you choose?

hard

A. Export as STL with high resolution settings.

B. Export as OBJ without textures.

C. Export as STL with binary format.

D. Export as 3MF with color and material options enabled.

Solution

1. Step 1: Identify format supporting color and materials

   3MF supports color and material data; STL does not.

2. Step 2: Enable color and material options in export

   Ensure export settings include color and material to preserve this info.

3. Final Answer:

   Export as 3MF with color and material options enabled. -> Option D

4. Quick Check:

   3MF + color/material options = correct export [OK]

Hint: Use 3MF format to keep color and materials [OK]

Common Mistakes:

• Choosing STL expecting color data
• Ignoring export settings for materials
• Selecting unrelated formats like OBJ without textures