We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The solution to last week's challenge is HERE!
Today we’re challenged to find the total area (square miles) that we can move our company headquarters to such that it is an equidistant commute from 3 satellite offices. In order to do so, find the area that is shared by a 30 minute drive time radius starting from each of the satellite offices!
Be warned! You may arrive on different areas depending on the spatial data release that is used, in addition to the drivetime methodology selected. For the sake of comparison, use the above map as an estimation of the area if you are not using the Q2: 2016 TomTom US Peak Most Recent Vintage dataset. If you think you need a hint, expand the spoiler below!
I used Tom Tom Q4 Peak. Hopefully, I didn't miss anything here.
If I did, someone will point it out to me (I'm sure).
My (pseudo) solution. I don't have access to drivetime data, so I wasn't able to answer the question exactly as asked... but I can see comparing to @MarqueeCrew 's solution that I have the same process, so barring changing from "miles" to "minutes" if I'd had the drivetime dataset, I believe it's the same. So count this as my "I drew this with a stick in the sand because I didn't have the right tools" solution? :)
I don't have the spatial package either so I winged it to come up with 2 different areas to consider for the HQ. I used a both spatial tools and spatial formulas to come up with the answers.
Used a similar "stick in the sand" approach as @NicoleJohnson and @Natasha. As Nicole says, it's the same solution as Mark @MarqueeCrew, but using a mile-radius rather than a drive-time radius. Still holding out that @MattD has some sneaky idea up his sleeve for those of us without spatial data packages...
Image below is the final resulting intersection and the original locations of the satellite offices.
For those of you who do not have the spatial data package, I went ahead and created a macro that uses Google Maps to calculate distance and drivetime between two points or addresses! While you'll still end up with a different total area as compared to the Q2: 2016 TomTom US Peak Most Recent Vintage dataset, this will make it so that you can answer these types of questions in the future without full access to the spatial data package!