Help, I need a tracking spreadsheet or a software/ bot that does the work

[Nimo]

I've been using the old Andruchi standard where a single roulette number will hit 8 times before all the numnbers show up at least once with a lot of success.  I track the numbers manually and when a number hits seven times I start flat betting it, sometimes up to six numbers at a time.  Usually happens within 65-150 spins so manually it is time consuming but profitable.   I would like a spreadsheet or software that I can enter the spins and it tracks the numbers telling me when a number has hit seven times, once it hits eight I cash out and start over, but I would like to roll over the past spins so that it shows me when the next bet is to be placed keeping the actually betting going rather than the manual tracking, basically having individual 65-150 spins done separately as the wheel spins add the current spin delete the 1st.   Constantly having seven hit numbers available to bet on.

I don't know if I explained it well enough to code it, but anything would help at this point.  Might be good system for a bot