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
Great challenge. Thanks, @TC_bot !
Workflow:
Spoiler
I tried to make mine somewhat dynamic, in case we had a much larger/more complex list of employees.
For a large list of employees, it would be more efficient to do the Cartesian product on employees x holidays rather than employees x all days (as I did here). We'd just need to make sure we don't drop employees who either didn't have any holidays in their region (or didn't match to an available holiday list).
For a large list of employees, it would be more efficient to do the Cartesian product on employees x holidays rather than employees x all days (as I did here). We'd just need to make sure we don't drop employees who either didn't have any holidays in their region (or didn't match to an available holiday list).
Bonus:
Spoiler
I know I could have just counted the results from the report output, but this was an opportunity to bring out this crazy-but-useful formula from @jdunkerley79 (which I learned about from a previous weekly challenge!)
