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

hanykowska
10 - Fireball

This is a good one, thanks @OllieClarke for help with debugging!

Turned out some of my issues were due to considering rabbits aged 4 months to be already in reproductive age, once I changed that, I got the right month, although my numbers are a bit off...

Another issue was the wrong data type which ended up with loads of nulls!

 

Spoiler
image.png
JennyMartin
9 - Comet
Spoiler
AWC123.PNGAWC123M.PNG

Struggled initially because I was interpreting it as >=4 rather than >4 for the age at which rabbits start producing! Definitely not the most efficient solution as it took 5 mins to run, but good iterative macro practice nonetheless!

dsmdavid
11 - Bolide

Slightly different number for humans -- didn't floor after each month, rather calculated from starting values each time

Spoiler
dsmdavid_1-1583706584911.png
dsmdavid_2-1583706624728.png

 

 

acrahen
8 - Asteroid
Spoiler
acrahen_0-1583776389635.pngacrahen_1-1583776410850.png

 

tiffanyshaw
8 - Asteroid
Spoiler
I'm still learning how to build macros, so I'm not sure I should full credit for this. 😛

All props to @acrahen's solution since I had to walk myself through step by step:

tiffanyshaw_0-1585015058792.png


I did however choose my own icon ('tis the little things) ;)...

tiffanyshaw_1-1585015102438.png

 

GaneshBo
Alteryx
Alteryx

My Solution:

atcodedog05
17 - Castor

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
This is my solution

atcodedog05_0-1585848739975.png

 

atcodedog05_1-1585848759042.png

 

jwlong91
8 - Asteroid

Great challenge to learn about iterative macros!

Spoiler
Challenge 123 JWL.JPG
johnemery
10 - Fireball

This was a very fun challenge! Definitely got the brain juices swirling around up there.

 

Spoiler
Capture.PNG

I also put a solution video together since I enjoyed this challenge so much:

Spoiler
AlexC2
8 - Asteroid

Fun challenge, thanks!

 

got a slightly different Rabbit population at end, but dates align.