Sample Data
Coordinates of two points in 2D space and a cell to calculate the aligned dimension (distance along the line between points).
| Cell | Value |
|---|---|
| A1 | Point 1 X |
| B1 | Point 1 Y |
| A2 | 3 |
| B2 | 4 |
| A3 | Point 2 X |
| B3 | Point 2 Y |
| A4 | 7 |
| B4 | 1 |
| A5 | Aligned Dimension |
| B5 |
Coordinates of two points in 2D space and a cell to calculate the aligned dimension (distance along the line between points).
| Cell | Value |
|---|---|
| A1 | Point 1 X |
| B1 | Point 1 Y |
| A2 | 3 |
| B2 | 4 |
| A3 | Point 2 X |
| B3 | Point 2 Y |
| A4 | 7 |
| B4 | 1 |
| A5 | Aligned Dimension |
| B5 |
SQRT(POWER(A4 - A2, 2) + POWER(B4 - B2, 2))A B +-----+-----+ 1 | Pt1X| Pt1Y| +-----+-----+ 2 | 3 | 4 | +-----+-----+ 3 | Pt2X| Pt2Y| +-----+-----+ 4 | 7 | 1 | +-----+-----+ 5 | Aligned Dim | +-----------+ References: A2, B2 (Point 1), A4, B4 (Point 2)
A B +-------------+-----+ 1 | Point 1 X | Y | +-------------+-----+ 2 | 3 | 4 | +-------------+-----+ 3 | Point 2 X | Y | +-------------+-----+ 4 | 7 | 1 | +-------------+-----+ 5 | Aligned Dim | 5 | +-------------+-----+
Aligned Dimension measure in AutoCAD?Pass the test and this pattern moves unknown