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
It's going to take me a week just to review all the different ways people attacked this challenge. Here's my solution:
So I built this solution, but it takes forever to run, so I modified the workflow a bit by decreasing the number of trials by a factor ~333 (it says 1000 in the image but I adjusted it to 3)... But this is not enough for my model as it results in perfect separation... 1000 trials would be better, but this requires a full year's worth of simulations to run with this workflow.... I call it a night I guess as I cannot open my macro any longer after exporting it (I am not sure how, but something broke as a tool is now missing or disfigured/-membered)
Overall workflow:
Birthday macro:
This was not a quick workflow to run
The batch macro ran one group size per batch
The iterative macro did the actual modelling
In total, the workflow took around half an hour to run
