We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #325: How many hot dogs can you eat?

valentinmarechal
7 - Meteor

First time posting my solution here !

As for the other, I don't have the same results on the third question.

 

Spoiler
valentinmarechal_1-1656496266945.png
valentinmarechal_2-1656496470760.pngvalentinmarechal_3-1656496478388.png

 

 

atcodedog05
22 - Nova
22 - Nova

My take on this

 

Spoiler
atcodedog05_0-1656503233353.png

 

LiuZhang
9 - Comet
Spoiler
325.png

Pivot wide to the required format probably took me most work 😅

NW_Cms
5 - Atom
Spoiler
NW_Cms_0-1656513968680.png

 

Thanks

namans0297
5 - Atom

I am not able to post the screenshot and workflow but here are my answers.

 

1) Who was the winner among the male and female contestants for each year?

YearMenHot Dogs EatenWomenHot Dogs Eaten
2015Matthew Stonie62Miki Sudo38
2016Joey Chestnut70Miki Sudo38
2017Joey Chestnut72Miki Sudo41
2018Joey Chestnut74Miki Sudo37
2019Joey Chestnut71Miki Sudo31
2020Joey Chestnut75Miki Sudo48.5


2) How many hog dogs did the winners eat?

Men - 424 and Women - 233


3) What year had the least number of hot dogs eaten by a man and a woman?

Men YearLeast amount eatenWomen YearLeast amount eaten
2016120184
RanierMoore
7 - Meteor
Spoiler
raniermoore_0-1656517199468.png

 

aakashraj
7 - Meteor

Here you go.

megianoli
5 - Atom

This is my solution, :)

 

 

image.png

 

dbrownsc
7 - Meteor
Spoiler
dbrownsc_0-1656528727744.png

 

Reesetrain2
8 - Asteroid

All,

Spoiler
Capture.PNG


This week, I have submitted a 2-for-1, in that I have a long version and a short version of solutions that both work thereby proving that you really can skin a cat two different ways.
The shorter solution focuses more on isolating the numbers required in the end and then utilizing the summation tool for that before cleaning the data later.
-The longer solution focuses on creating and cleaning the table first and then using a smooth and clean table for use by the summation table.
-Nonetheless, both use:

1 Multi-Row Formula
2 Formula
Multiple Data Cleaning Tools