cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

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

Meteor

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

Solution attached.

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?).

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

Alteryx Certified Partner

My bunnies are a bit slow

Spoiler
Alteryx Partner
Spoiler
Asteroid

Alteryx Partner
Spoiler

Not very clean but it works.

Aurora

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

Quasar

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

Spoiler
Workflow, complete with evil bunny icon

and the underlying macro

Quasar

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