For the specific analysis of the CURRENT cycle in real time , I use formulas, but I use a macro to play a sound to draw my attention to the end of the cycle. I don't particularly want or need to automatically reset it once every 20 weeks or so.
The start of the cycle is a named range, so I just go into name manager and change the address of that named range, it takes about 10 seconds.
Yes, you don't reset (all balls to zero ) until all your 69 balls have been drawn, but this in practice means that the first draw of the new cycle ( which is the draw after the one where the final ball(s) were drawn) will have seven balls with a count of 1, and (69-7) undrawn balls. There is never a situation where the drawn ball count is zero .
For historical analysis looking back over years of draws, i used a macro and formulas to scan the results and flag up the start of each new cycle and count cycle lengths.