Challenge #170: 2019 Grand Prix US - Heat 1

[Towers]

this one really confused me 🤔 got it thanks to the help of @BS_THE_ANALYST 

Spoiler

 

[Rhys_Cooper]

Great challenge - Helpful to see the which configuration options of the TS plot are available depending on the data. Realised the data loading macro wasnt nessecary and a star could have done the trick but always good practice!

Spoiler

[Pilsner]

Here's my solution. Realised halfway through that I was using a very inefficient method to fill in the missing data but still got there in the end. The time was 25:28. Great challenge. Look forward to attempting the next heat.

Spoiler

 

[Szymon_Czuszek]

My solution attached below.

Spoiler

[JoachimCaronTIL]

Here is my solution, using the TS Fill Tool

Spoiler

 

[Smatthias]

I dabbled a bit with more formulas, I guess I did some things double but didn't wanna go back and clean it up for the system was running. 
But here's my answer.

Spoiler

with 703 as answer

 

 

[SJKIM]

Completed

[lwolfie]

I forgot to time myself.  Based on my previous save, I was within 12 minutes though.

[Erin]

Revisited this one.