Forum Discussion
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...
Version 2: broadcast and flatten
= LET(
i, ROUNDUP(available / items_per_turn, 0),
j, SEQUENCE( , MAX(i)),
k, IFS(j < i, items_per_turn, j = i, 1 + MOD(available - 1, items_per_turn)),
l, SCAN( , TOCOL(k, 2, 1), SUM),
VSTACK({"Treat","Start","Stop"}, HSTACK(TOCOL(IF(k, treat), 2, 1), DROP(VSTACK(0, l), -1), l))
)I missed the obvious the first time around... 👻