Happy Monday! Last week's solution can be found HERE!
In this week's challenge, a communications company is doing an analysis of fiber runs in the network. The current wiring needs to be extended a certain distance in each direction in a straight line. Take the provided lines and extend them 5 miles on each end. For more intermediate users, create a macro so the user can input the desired extension length for each run.
The output should include:
1. Name of the fiber
2. The original spatial line object
3. The new spatial line object
4. New length of line
Good opportunity to practice with spatial tools that I rarely use.
Here is a route to get slightly more accurate coordinates, I am sure the expressions could be improved to be even more accurate.
I started down a trig path too, and will get there (just struggling to remember trig!!).
When that wasn't working, found the same solution as many others, with circles and distances. I suppose that's more of a geometric/geospatial approach.
Still working on doing this with formulas.... to be continued.....