Forum Discussion
Patrick2788
Oct 21, 2026Silver Contributor
Halloween 2026 Scheduling Challenge 🎃
Happy Halloween! You'll find the rules in the screen capture below and in the attached workbook. Creative solutions are encouraged. Feel free to use any functions available in the Beta ch...
Patrick2788
Oct 26, 2026Silver Contributor
I'm working on polishing another approach which uses SCAN to process the allocation in rounds.
The initial value is supplied as a 2D stack of Treats/Available.
On each round, a check is done to remove items which are out of stock. The quantum (Items per turn) is subtracted from the available counts. It reads more naturally than the MAP solution.
The output is a n x 4 spill - Process/Distributed/Available/Cumulative