Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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
10 - Fireball

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