Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIs this challenge is intermediate? I think that this challenge is advanced!
My Workflow & Macro
Result
I couldn't figure out the complete solution using just the Spatial Tools so I had to peek at the solution. However, instead of just applying the same logic as the known solution, I used Spatial Tools to calculate the initial line lengths and direction in degrees, and calculated the extensions mathematically.
Very Good one!
This was a tough one. I ended up finding the bearing of the distance between start and end point of the original line. I then created a trade area of the distance specified (default 5) around both the start and end point, split the trade area into points, then found the point on the opposite end of the trade area that matched the distance and bearing of both the start and end points. Finally, I created a new line with the newly calculated start, end points. I'm sure there was an easier way to do this, maybe with geometry formulas, but this seemed to work .