Challenge #77: Extending Spatial Lines

[ARussell34]

Yes I did use calculus to solve this problem, only realized during a local meeting with other coworkers that use Alteryx that there was a much easier way.

[MichaelPilotFreight]

Check out my solution!

[Erin]

This one tripped me up a little, but got through it!  

[EdoardoAversaTIL]

Spoiler

 

[LiuZhang]

Spoiler

[r_manju02]

Here is my solution

[Mchappell67]

This one took WWAAAAAYYY too long, but I guess a pretty good training experience...  Like others, started out looking at geometry/trig.  While probably possible, was simply getting too complex.  Ended up going the route others took and used trade area/distances.  My first standard macro, so struggled with that a bit.  I have to remember that the macro acts on the whole dataset, and not just one record at a time, as a function would.

Macro:

Spoiler

 

To explain the "furthest" calc a bit...  We create the "trade area" around the end point we are considering.  Since it's a circle, we can't find the "furthest" point from the same point - the distances will all be the same.  Instead, we find the furthest distance from the OTHER point.  This SHOULD yield the point that is at the intersection of the existing line if it were to be extended to/through the circle.  Sample below.

Mark

[davidhardister]

yep this one made me quite miserable

[Luke_C]

Spoiler

[Watermark]

The Simple solution

Spoiler

 For some reason I decided to be an over achiever on this challenge for the fun of it and made an app so you could decide your parameters.

Spoiler