Offset entities in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This data represents original lengths of line entities and the offset distances applied to them in SolidWorks. The goal is to calculate the new lengths after offsetting.

Cell	Value
A1	Entity
B1	Original Length (mm)
C1	Offset Distance (mm)
D1	New Length (mm)
A2	Line1
B2	100
C2	10
A3	Line2
B3	150
C3	15
A4	Line3
B4	200
C4	20

Formula Trace

=B2 + C2

Step 1: B2 + C2

Step 2: 100 + 10

Cell Reference Map

    A       B       C       D
1 |Entity |OrigLen|Offset |NewLen
2 |Line1  |  100  |  10   |  ?  
3 |Line2  |  150  |  15   |  ?  
4 |Line3  |  200  |  20   |  ?  

References: B2 (100), C2 (10) used in formula for D2.

The formula for new length in D2 uses original length from B2 and offset distance from C2.

Result

    A       B       C       D
1 |Entity |OrigLen|Offset |NewLen
2 |Line1  |  100  |  10   | 110 
3 |Line2  |  150  |  15   | 165 
4 |Line3  |  200  |  20   | 220 

New lengths calculated by adding offset distances to original lengths.

The new length column shows the result of adding offset distances to original lengths for each line entity.

Sheet Trace Quiz - 3 Questions

What is the new length of Line1 after applying the offset?

A 110

B 90

C 100

D 10

Key Result

New Length = Original Length + Offset Distance