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
Like others, the Solution is not right because for one reason it has Non-Working days as the Prep Days.
Otherwise, i'm happy with my workflow and the way I attempted this. I really like to use the 'Generate Rows' tool with challenges like this, because what it does is create a list of dates for each review date, so effectively creating sub-rows for the rows. And then the beauty is that you then have more data to analyse and then narrow down to the correct result you are looking for.
Thank you, @Qiu.
I renamed the column headers in my Input configuration - saved a couple extra tools ;)
I also noticed some inconsistencies as the other members of the community pointed out. I think the task can be interpreted in different ways which can result in different solutions. For example, if the reviews are on the same day, and since it takes at least 2 days to prepare for each review, they all need to be spaced out to prepare for. Or is it that all of that day's reviews take at least 2 days to get ready for? The latter is the logic I adhered to. My solution jives with the approach @Erin applied.
I noticed inconsistencies in the solution output provided as well - see a screenshot below: The PrepDate1 needs to be 2 work days prior to review while PrepDate2 needs to be 1 work day prior to review date; however in the solution output provided PrepDate2 is the same as PrepDate1 for quite a number of reviews, and in some cases PrepDate2 comes before PrepDate1 which defies the task set forth.
Here is my solution, it is attached here as well.
And here is an extract from the solution output provided to this challenge which illustrates the inconsistencies I pointed above.
The 2nd column is PrepDate1 and last column is PrepDate2.
Good challenge, but I think some clarity, setting the framework for the task, and the output that jibes with the task set forth would be helpful here. Thank you.
Started going down many rabbit holes of building various iterative macros (too much AoC lately I guess 🤣) to ensure that prep dates were uniquely used and did not overlap with existing review dates, thinking only one task could be done on a given day... but then decided if multiple reviews were on the same date, why should I worry about that? I did at least construct this so if 10 reviews were on a given day the prep days were split up amongst the previous 20 available...
