My last post showed my, rather poor, attempt at solving this puzzle. Since the solution was posted online I thought I'd have a go at using my Excel skills to plot the path of the dog and the duck. And the aim was to use no VBA.
Time is of the essence with this post so please excuse the strange mix of notations later on. One of my friends sent me this puzzle from fivethirtyeight.com and here is my solution to how the dog needs to catch the duck.
Lots of peoples first instinct is times faster but this is really just a lower bound, i.e. if the dog travels less than π times faster than the duck then the duck can just read radially to the antipoint of the dogs starting position.
There are a few key assumptions here that we can make from the beginning: