# Weekly Challenge

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

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

Submit Feedback
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.

## Challenge #123: When will Rabbits Rule the World?

Highlighted
7 - Meteor

First Iterative macro... Thanks to the first two responses.

Solution attached.

Highlighted
8 - Asteroid

Fun Challenge, solved with an iterative macro also.

However, I feel that the world's population is larger than the 326 million or so in the text input (could this be the population of the USA?).

Highlighted
Alteryx Certified Partner

Solution attached.

I have to agree with those that came up with 2022-01-02 as the Date, and I don't think there is any ambiguity in the problem. The problem states that Age 0 occurs on the birthdate, not the following month, and that the frequency for each new generation is 4 months not 5. Also, in July the initial births are included in the population count, so all subsequent births should be added to the population in the month of birth. Just counting on my fingers with July = Month 0, the first litter should arrive in November with a new generation every Mar and July after that. In the solution provided, the first litter doesn't arrive until December, and then every 5 months (May, Oct, …) after that. I think where the solution is flawed is that in the current month it calculates new births, and then passes that as an 'Age 0' population to the iteration for the next month. In reality, there is no Age 0 population, the new births should be added to the population in the birth month, and passed to the next iteration as Age 1 population.

Spoiler

Highlighted
Alteryx Certified Partner

My bunnies are a bit slow

Spoiler
Highlighted
Alteryx Partner
Spoiler
Highlighted
8 - Asteroid

Highlighted
Alteryx Partner
Spoiler

Not very clean but it works.

Highlighted
16 - Nebula

Same answer - some fiddling about with date boundaries (e.g. do the bunnies start breeding on the first day of Month 4 or during month 4 etc)

Spoiler

Highlighted
14 - Magnetar

getting better at the iterative macros. Thanks, @JoeM, for a fun practice

Spoiler
Workflow, complete with evil bunny icon

and the underlying macro

Highlighted
16 - Nebula

This was a headscratcher! I'm not sure the Multi_Row Formula tool likes being used like that!