Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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 #85: How Did Tara Place in Competition?

cgoodman3
14 - Magnetar
14 - Magnetar

Quite a long method 😕

 

Spoiler
Challenge 85.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
hanykowska
11 - Bolide

Nice one

T_Willins
14 - Magnetar
14 - Magnetar

My solution.

 

Spoiler
Workflow 85.JPG

 

jlchiasson
6 - Meteoroid
 
mbogusz
9 - Comet

My interest in ultrarunning initially veered me in the wrong direction with this one.

I first thought the times were %H:%M.%S, but I was mistaken. As per the solution, they're supposed to be %M:%S (in milliseconds). By changing Tara's missing time from '04:30.48' to '03:31.48' (from Carisa's '04:31.48'), I'm getting the same results now.

 

Spoiler
2019-10-09 20_35_10-Greenshot.png 
mbogusz
9 - Comet

@RWvanLeeuwen changing your formula tool to this does the trick.

 

To:

clipboard_image_0.png

 

From:

clipboard_image_1.png

bjkay30
8 - Asteroid

I have way too many tools, and I know that this could be paired down quite a bit, but this was a good challenge!

 

Spoiler
clipboard_image_0.png
Inactive User
Not applicable
 
RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_85_RODO_Solution.png
SueDonim
8 - Asteroid

This was more complex than expected, but appears to be a good solution.  I ignored the fractional seconds in ranking, but it seems not to have affected the results

 

Spoiler
Process:
- Filter out Bibs 2421 and 3508
- Set Interval time for 2421 to be one minute less than for 3508
- Join threads
- Convert results to "time" format
- Sort interval results to determine Tara's position in Interval event (46th)
- Add record IDs to label her position
- Filter for only Tara's results
- Join threads
- Transpose data for ease of calculation
- Convert Tara's interval results to same format as other results
- Text to Columns to extract ranking
- RegEx to remove parentheses and convert to Byte format
- Group by Bib# and calculate count of non-null event ranking and average ranking
- Filter out all results if all 4 events not completed
- Sort by average ranking
- Add Record IDs to determine overall position in competition
- Clean-up
- Filter for results for #2421

MySolution.PNG