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
challenge_123_solution_KO.png

 

 

 

 

Highlighted
Alteryx Certified Partner

My bunnies are a bit slow

 

Spoiler
123.PNG
Highlighted
Alteryx Partner
Spoiler
20180722_00001.png
Highlighted
8 - Asteroid
 
Highlighted
Alteryx Partner
Spoiler
Capture.PNG

Not very clean but it works. 

Highlighted
16 - Nebula
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

2018-08-05_15-33-57.png2018-08-05_15-34-30.png
Highlighted
14 - Magnetar
14 - Magnetar

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

 

Spoiler
Workflow, complete with evil bunny icon
image.png

and the underlying macro
image.png

 

Highlighted
16 - Nebula

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