Forum Discussion
Dividing a number over a given number of cells with one or no remainder
This is quite fascinating. I'm pretty sure that you are speaking of fireworks displays, right? Where, may I ask, are you doing this? I have a summer home along the New Jersey (US) shore, so may have seen some of your handiworks (if that's where you operate).
Anyway, although I find your question fascinating, and I love elegant stand-alone (let Excel do it all) solutions, my practical mind wonders if you're not maybe making things more complicated here than you need to.
To stay with your example, what I'm really wondering is whether in your professional judgment, you mightn't want to either front-load the display OR (more likely, based on pyrotechnics displays I've witnessed), back-load it, i.e., have all of those 7 cues per minute sequences loaded into the last four minutes of a 22 minute show. OR some other combination, not quite subject to arbitrary computer heuristic, but rather influenced by your professional judgment plus, perhaps, conversations with the client community???
Bottom line being, why not do just simple math, get the base number of cues for each minute (6 per min, to stay with your example) and manually distribute the remainder for maximum customer satisfaction? That could even mean loading 2 into each of the last two minutes, or .....