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 #123: When will Rabbits Rule the World?

danilang
19 - Altair
19 - Altair

Another non-macro solution.  Transpose to get all the required values in one column and then multi-row the bejeebers out it.  I interpreted the problem to be rabbits can start reproducing at 4 months old, but have a 1 month gestation period.  The first clutch of rabbits is born at the start of month 5

 

Spoiler
Result.pngsolution 123.png

 

Dan

 

 

dmccalley
6 - Meteoroid

My interpretation of the problem lands me with 01/02/2022 as a few others have, but go go multi-row formulas!

JoBen
11 - Bolide

That was a fun one! It definitely took some thinking. Cheers!

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

kelly_gilbert
13 - Pulsar
Spoiler
After looking at some of the other solutions, I regret not using a custom bunny icon for my macro!

Main workflow:

challenge_123_workflow.PNG

Iterative macro:
challenge_123_macro.png


pasccout
8 - Asteroid

Here is my solution...

 

Same month... slightly off numbers...

jssandom
8 - Asteroid

Got the same date but numbers are slightly different!

jamielaird
14 - Magnetar

Solved at long last. Quite a few false starts until I figured out how to group the iterating output correctly.

 

Spoiler
Screenshot 2018-12-29 at 21.40.18.pngScreenshot 2018-12-29 at 21.41.35.png
RolandSchubert
16 - Nebula
16 - Nebula

My solution, used the macro approach

JoshuaGostick
11 - Bolide

Didn't get the exact same numbers but got the same month.

Spoiler
challenge_123.PNG