Up One

[buffalowizard]

I think what you mean is the display mode.  The numbers will appear when it is triggered to starts betting.  Far right in some hidden columns ( which you can unhide), is the process.

So tell me if I got it right: wait for a repeater.
Bet the +1 pair of all nrs since the tracking started ( which is after a win or after more than 36 units have been spent).
Keep the same nrs until a win or a full loss ( >36u).

Different?

That's all correct yes.
I was paying attention to all the groups of numbers going down.

Thanks man, I'll use some actuals from this site and report back later. Is there a way of knowing the exact total profit/loss figure, other than look at the graph?

[Bigbroben]

Yes.  Column M.

[buffalowizard]

Lastly, how do I stretch it beyond 500 spins? I have inputted sets of few thousand at a time, but it stops at 500 I think?

[buffalowizard]

OK, results not great. Here are some sets of 500 spins each. Thanks for your efforts BBB, but think this is one for the scrapheap. Dayum!

+195
+2
-82
-24
-70
-146
+262
+25
+260
-181
+24
-94
-87
-79
-248

[Bigbroben]

Select the few last rows by clicking on the row nr, hold left click and go down to the row of spin 500.


Release, then click on the little black square on the lower left.  Hold (left click) and drag down.

Trick: if you want to erase all the nrs to insert new ones:
select the first nr


Double-click on the little black square on the lower right.  It will copy/paste the cell to all the other ones below and they will all stay selected.  Right-click: clear content.  This double click is useful to copy formulas to all other cells.

[buffalowizard]

Another 6 sets of 500, just to make sure.............ugh


-77
+177
+85
+112
-220
-338

[Bigbroben]

I know...  but hey, I enjoyed the challenge!

[buffalowizard]

Select the few last rows by clicking on the row nr, hold left click and go down to the row of spin 500.


Release, then click on the little black square on the lower left.  Hold (left click) and drag down.

Trick: if you want to erase all the nrs to insert new ones:
select the first nr


Double-click on the little black square on the lower right.  It will copy/paste the cell to all the other ones below and they will all stay selected.  Right-click: clear content.  This double click is useful to copy formulas to all other cells.

Thanks for the pointers bro...I'm sure will come in handy in future. Appreciated