Geometric relations (horizontal, vertical, coincident, tangent) in Solidworks - Cell-by-Cell Formula Trace

Sample Data

Coordinates of two lines in 2D space representing geometric relations.

Cell	Value
A1	Line1 Start X
B1	Line1 Start Y
C1	Line1 End X
D1	Line1 End Y
A2	0
B2	0
C2	5
D2	0
A3	Line2 Start X
B3	Line2 Start Y
C3	Line2 End X
D3	Line2 End Y
A4	5
B4	0
C4	5
D4	5

Formula Trace

Check if Line1 is horizontal AND Line2 is vertical AND Line1 end coincides with Line2 start

Step 1: Line1 End Y (D2) - Line1 Start Y (B2) = 0 - 0

Step 2: Line2 End X (C4) - Line2 Start X (A4) = 5 - 5

Step 3: Line1 End (C2,D2) = (5,0) and Line2 Start (A4,B4) = (5,0)

Step 4: Line1 horizontal (True) AND Line2 vertical (True) AND coincident (True)

Cell Reference Map

    A     B     C     D
1 |Line1 Start X|Line1 Start Y|Line1 End X|Line1 End Y|
2 |    0    |    0    |    5    |    0    |
3 |Line2 Start X|Line2 Start Y|Line2 End X|Line2 End Y|
4 |    5    |    0    |    5    |    5    |

References used:
- Line1 Y coordinates: B2, D2
- Line2 X coordinates: A4, C4
- Line1 End point: C2, D2
- Line2 Start point: A4, B4

Cells referenced to check horizontal, vertical, and coincident relations.

Result

    A     B     C     D     E
1 |Line1 Start X|Line1 Start Y|Line1 End X|Line1 End Y|Result|
2 |    0    |    0    |    5    |    0    | True |
3 |Line2 Start X|Line2 Start Y|Line2 End X|Line2 End Y|      |
4 |    5    |    0    |    5    |    5    |      |

Result cell E2 shows True indicating all geometric relations hold.

Sheet Trace Quiz - 3 Questions

What does a zero difference between Line1 End Y and Line1 Start Y indicate?

A Line1 is tangent

B Line1 is horizontal

C Line1 is vertical

D Line1 is coincident

Key Result

Check horizontal by equal Y coordinates, vertical by equal X coordinates, and coincidence by matching points