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 #369: Formula 1 Grand Prix (In)efficiency

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1683124025295.png

Kenda_0-1683208852721.png

 



Edit - oops, change the find nearest tool to allow distances of 50k KM then it matches solution given :) 

 

 

braveraj
11 - Bolide

So I might have made part 2 more challenging but it optimizes the route without duplicate returns to a circuit.

Spoiler
braveraj_0-1683133246433.png braveraj_1-1683133564282.pngbraveraj_2-1683133646990.png

 

 

 

ARussell34
8 - Asteroid

Part 1 was a cake walk, part 2 took me a tad longer than I'd like to admit.

 

ARussell34_0-1683138613811.png

 

arizzio
7 - Meteor

Workflow:

Spoiler
arizzio_0-1683139092610.png

 

Macro with Find Nearest to Match Answer:

Spoiler
arizzio_1-1683139160449.png

 

Macro using Distance calculation, which seems to be more accurate:

Spoiler
arizzio_2-1683139281117.png

 

Watermark
12 - Quasar
12 - Quasar

Ok, every once in a while there is a challenge I decide to go a little overboard. This is one of those times. 

 

What started it was the answer to the second question. The provided answer gives you one result, but a number of people who know what they're doing got a different result, BUT, a number of other people who also know what they're doing got the result of the provided answer. 

 

Couldn't just let that sit. 

 

So, what's going on??  I must find out. So I dug in. I actually solved the answer (to the second problem) 3 different ways. 

Method 1: Iterative macro uses formula tools to solve : result - 56,406

Method 2: Iterative macro uses Spatial Nearest Match with a configuration of top 25 matches: result - 56,406

Method 3: Iterative macro uses Spatial Nearest Match with a configuration of top 1 match: result - 61,998 (matches the provided result)

 

For method 2 & 3:

Look at the INCOMING ANCHOR of the SUM right before the end, scroll down to the bottom, and record #20 switches 2 different circuit track locations.    (Suzuka, Autódromo José Carlos Pace).  This creates the difference between the 2. 

 

Oh yeah, then just because it's like that, I turned this into an Application that you can pick your starting track .... 🤓   Enjoy!

 

Spoiler
MT_Solution__369.jpg

 

 

 

 

 

 

benjimoser
9 - Comet

My Solution

Spoiler
benjimoser_0-1683189567353.png
benjimoser_1-1683189577793.png

 

sparekh1
7 - Meteor

My Solution:

Spoiler
sparekh1_0-1683267073461.png

 

Iterative Macro:

Spoiler
sparekh1_1-1683267147787.png

 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1683312832541.png

Here is the iterative macro:

olga_strubbe_1-1683312909440.png

 

olga_strubbe
11 - Bolide

I used a similar approach as @ahsanaali  - this seemed the most straightforward way to solve the challenge.  

elaineyuan
8 - Asteroid

My output 2 is different from the one provided...

 

Spoiler
challenge_369_elaine_yuan.png
challenge_369_elaine_yuan_macro.png