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 #308: Size it up

benjamin_feuchter
8 - Asteroid

Resulting percentages based on 1839 rows - I don't think dividing by 1850 is the right approach here.

Spoiler
benjamin_feuchter_1-1647443355550.png

 

 

 

MattBenj
9 - Comet

My solution.

Shawn_Maphoto
7 - Meteor

Hi All, here is my solution

Spoiler
weekly challenge_308_SM.PNG
leonhekkert
8 - Asteroid
Spoiler
Challenge_308.png
Diederik_vanderharst
8 - Asteroid

Voila

Spoiler
Schermafbeelding 2022-03-24 om 09.31.43.png

Shifty
12 - Quasar

For the life of me I can't get the same percentages but I can't see where I've gone wrong! 😬

Spoiler
Shifty_0-1648130419655.png

 

tammybrown_tds
8 - Asteroid

@Shifty,

 

I had the same issue.  The solution in the output uses the SmartRound formula (exactly what you have, except the [Count by Size]/[Total Entries] part of the equation is enclosed by the SmartRound function).  if you do that, your percentages will match the solution.

 

I was never able to fully determine what the SmartRound function does, but it's the only way that the results match the output set.

Shifty
12 - Quasar

Thanks, @tammybrown_tds - I'll take a look at that.  My solution was never going to be "SMART". 🤣🤣

Spoiler
HarleyBarnes_Quantium_0-1648444084025.png

 

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution: