Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI'm not sure why, but I felt an anxiety while working on this, as though I was competing, haha.
Made this a bit tougher than it needed to be. Good reminder that when parsing times you can specify detail of subseconds with the identier %1 to %18 (a number in that range depending on preciseness).
Relieved I wasn't trying to be unnecessarily smart on stage doing it all off rip in a multi-row formula tool.
A lot less stressful now 😂
Fun one this week.
Good practice with the preparation tool palette. The dynamic input wasn't necessary but makes the workflow more robust if more races are considered.
Originally I implicitly truncated Pit stop times but warnings were suppressed after a relatively small number of conversion errors. That could have possibly masked other issues. I made the truncating explicit by removing decimals from the regex_replace expression within the multi-field formula tool.
There are traps and I am sure I can not handle the pressure in front of 4 thousands people.
Again, congratulations to the Champions!