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 #176: Math Class Drill

nakamott
8 - Asteroid
 
avinashsunchu
8 - Asteroid

clipboard_image_0.png

Cal_A
7 - Meteor

I tried two ways of creating the various 3 digit numbers before testing whether they fit the condition. One using append fields (messy) and one using "Generate Rows".

This was a good challenge to familiarize myself with swapping between numbers as text vs numbers as numbers.   I guess I could actually have had one complex formula to conclude Y/N on whether sum of cubes = number, but where is the fun in writing long formulas.

 

Spoiler
Both of these give you the 4 results:

The key processing is in the formula tool, which just cubes and totals the digits. I use a filter to fine where "Total" (of cubes) = the three digit number.





challenge176.GIF

 

Arunas
5 - Atom

My Solution

Spoiler
Screenshot.JPG

sumitiiest
8 - Asteroid

clipboard_image_0.png

FlorianTissen
6 - Meteoroid

Nice one 🙂

 

Spoiler
clipboard_image_0.png

clipboard_image_1.png
hpaulina
6 - Meteoroid
Spoiler
 
sumankumar
5 - Atom

It initially sounded like, I needed a loop but this was a good exercise. 

qb
7 - Meteor

This was a fun one! I couldn't figure out a way to split the digits into columns without translating it to string and back to number.

 

Spoiler
challenge-176.PNG

 

JoeHollub
5 - Atom
Spoiler
clipboard_image_0.png