This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHappy 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.....
Like others I decided to try and figure this out using Trig & Geometery and then I realised than I have no idea what I'm doing, so I stuck to what I know..