eDrawings for sharing in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This table shows parts shared as eDrawings files, their sizes, the teams they were shared with, and the dates shared.

Cell	Value
A1	Part Name
B1	File Size (MB)
C1	Shared With
D1	Date Shared
A2	Gear Assembly
B2	12.5
C2	Team A
D2	2024-06-01
A3	Motor Housing
B3	8.3
C3	Team B
D3	2024-06-03
A4	Shaft
B4	3.7
C4	Team A
D4	2024-06-02
A5	Bracket
B5	5.1
C5	Team C
D5	2024-06-04

Formula Trace

=SUMIF(C2:C5,"Team A",B2:B5)

Step 1: Check C2:C5 for 'Team A' matches

Step 2: Select corresponding B2:B5 values where condition is TRUE

Step 3: Sum selected values 12.5 + 3.7

Cell Reference Map

    A           B           C           D
1 | Part Name | File Size | Shared With | Date Shared
2 | Gear Ass. |   12.5    |  Team A    | 2024-06-01
3 | Motor H.  |    8.3    |  Team B    | 2024-06-03
4 | Shaft     |    3.7    |  Team A    | 2024-06-02
5 | Bracket   |    5.1    |  Team C    | 2024-06-04

Formula references:
- Range C2:C5 for condition 'Team A'
- Range B2:B5 for summing values
Arrows: C2 and C4 match condition, so B2 and B4 values are summed.

This map shows which cells are checked for the condition and which cells' values are summed based on that condition.

Result

    A           B           C           D           E
1 | Part Name | File Size | Shared With | Date Shared | Total Size for Team A
2 | Gear Ass. |   12.5    |  Team A    | 2024-06-01 | 16.2
3 | Motor H.  |    8.3    |  Team B    | 2024-06-03 |
4 | Shaft     |    3.7    |  Team A    | 2024-06-02 |
5 | Bracket   |    5.1    |  Team C    | 2024-06-04 |

The formula result 16.2 MB is shown in cell E2, representing the total size of eDrawings files shared with Team A.

Sheet Trace Quiz - 3 Questions

Which cells in column C are checked for the condition 'Team A'?

A C3 and C5

B C1 and C5

C C2 and C4

D C2 and C3

Key Result

SUMIF(range_condition, condition, range_sum) sums values in range_sum where range_condition matches condition.

Practice

1. What is the main purpose of using eDrawings in SolidWorks?

easy

A. To share CAD models and drawings without needing full SolidWorks software

B. To create 3D models from scratch

C. To edit CAD files with advanced tools

D. To convert drawings into PDF format

Solution

1. Step 1: Understand eDrawings purpose and compare options

   eDrawings is designed to share CAD files easily without requiring the full SolidWorks software. The other options describe functions not related to its sharing purpose.

2. Final Answer:

   To share CAD models and drawings without needing full SolidWorks software -> Option A

3. Quick Check:

   eDrawings sharing = To share CAD models and drawings without needing full SolidWorks software [OK]

Hint: Remember: eDrawings is for sharing, not editing [OK]

Common Mistakes:

• Confusing eDrawings with full CAD editing software
• Thinking eDrawings creates models
• Assuming it converts files to PDF

2. Which file extension is NOT used when saving eDrawings files from SolidWorks?

easy

A. .eprt

B. .easm

C. .edrw

D. .edxf

Solution

1. Step 1: Identify valid eDrawings extensions and check .edxf

   Valid eDrawings file extensions are .eprt (part), .easm (assembly), and .edrw (drawing). .edxf is not a recognized eDrawings file extension.

2. Final Answer:

   .edxf -> Option D

3. Quick Check:

   Invalid eDrawings extension = .edxf [OK]

Hint: Only .eprt, .easm, .edrw are valid eDrawings files [OK]

Common Mistakes:

• Assuming .edxf is a valid eDrawings extension
• Confusing with other CAD file types
• Mixing up assembly and part file extensions

3. If you save a SolidWorks assembly as an eDrawings file and send it to a colleague, what can they do with the file using the free eDrawings Viewer?

medium

A. Edit the assembly and change parts

B. View, rotate, and add comments to the assembly

C. Convert the assembly back to a SolidWorks file

D. Export the assembly as a 2D image only

Solution

1. Step 1: Understand eDrawings Viewer capabilities and evaluate options

   The free eDrawings Viewer allows users to view, rotate, and add comments but not edit or convert files. View, rotate, and add comments to the assembly matches viewer capabilities; the other options describe unsupported actions.

2. Final Answer:

   View, rotate, and add comments to the assembly -> Option B

3. Quick Check:

   Viewer functions = View + Rotate + Comment [OK]

Hint: Viewer = view and comment, no editing [OK]

Common Mistakes:

• Thinking viewer allows editing
• Believing it converts files
• Assuming export is limited to images only

4. You tried to share a SolidWorks drawing by saving it as an eDrawings file, but your colleague cannot open it. What is the most likely cause?

medium

A. The file size is too large for eDrawings Viewer

B. The colleague does not have SolidWorks installed

C. You saved the file with the wrong extension, like .sldprt instead of .edrw

D. You forgot to export the file as a PDF

Solution

1. Step 1: Check file extension and rule out other causes

   eDrawings files must have extensions like .edrw for drawings; .sldprt is a SolidWorks part file, not eDrawings. The colleague does not need full SolidWorks installed, file size rarely blocks opening, and PDF export is unrelated.

2. Final Answer:

   You saved the file with the wrong extension, like .sldprt instead of .edrw -> Option C

3. Quick Check:

   Wrong extension blocks opening [OK]

Hint: Check file extension before sharing [OK]

Common Mistakes:

• Assuming full SolidWorks is needed to open eDrawings
• Blaming file size without checking format
• Confusing PDF export with eDrawings sharing

5. You want to share a complex assembly with a client who only needs to review and comment on the design. Which steps should you follow to prepare the file using eDrawings for sharing?

hard

A. Save the assembly as .easm using 'Save As' in SolidWorks, then send the file; client uses free eDrawings Viewer to review and comment

B. Export the assembly as a .sldasm file and ask the client to install SolidWorks

C. Save the assembly as a PDF and email it; client can edit comments directly on the PDF

D. Send the original SolidWorks assembly file; client opens it with any CAD software

Solution

1. Step 1: Save assembly as eDrawings file and share for review

   Use 'Save As' in SolidWorks to save the assembly as .easm, which is the correct eDrawings format for assemblies. Send the .easm file; the client can open it with the free eDrawings Viewer to review and add comments without needing full SolidWorks.

2. Final Answer:

   Save the assembly as .easm using 'Save As' in SolidWorks, then send the file; client uses free eDrawings Viewer to review and comment -> Option A

3. Quick Check:

   Save as .easm + free viewer = sharing with review [OK]

Hint: Save as .easm and use free viewer for client comments [OK]

Common Mistakes:

• Sending full SolidWorks files expecting client to edit
• Using PDF which does not support 3D review
• Assuming any CAD software can open SolidWorks files