Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #26: Service Technician Travel Distance

AndrewHoData
8 - Asteroid

Managed to get the straight line distance. I don't think I have the facilities to get the drive distance though

 

Spoiler
AndrewHoData_0-1666743050234.png

 

JeroenAerts
6 - Meteoroid

Solution for straight line distance

Spoiler
JeroenAerts_0-1667210132513.png

 

TungThanhHo
8 - Asteroid

my solution

DenisZ
11 - Bolide

Here is my solution

 

Spoiler
DenisZ_0-1667466849448.png

 

dbmurray
8 - Asteroid

Like the original solution.

 

Unfortunately cannot actually complete the challenge due to missing drive time data files (which I cannot seem to get). However, I know the approach..

 

Spoiler
dbmurray_0-1667542173749.png

 

AaronSmatta
8 - Asteroid

Couldn't get the drive distance, but was able to get the straight-line distance

Ross_Easton
8 - Asteroid

Solved!

Spoiler
26 solved.png

saiirangam
8 - Asteroid

Challenge Completed

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1668078297690.png

 

mzajac
7 - Meteor

I could think of 2 solutions at least.

But most of the time I actually spend understanding the challenge 😏 If-Drive Distance output confused me a lot.

 

 

Spoiler

1. using Poli-Build with Sequence-Polyline

2. Multi-row formula and cross-tab



mzajac_0-1668417568775.png