excel again :)

[Badger]

Hi MM

I'm trying to do the same.( last 2 unique dozens)
I've attached an example where I've manually
typed them in (in green)

This would take forever when calculating 3000 spins.
Could you kindly show how to automatically calculate
the last 2 unique dozens as per my example.

Thanks
Bruce

[mattymattz]

PS

Go BULLS . . . .

Nick

Bulls are nothing without Rose.

[Nickmsi]

Hi Badger . . .

Don't know if you saw that Matty already coded the "unique dozen" function earlier.

I took the liberty of copying his formula and put it in your spreadsheet attached.

Hope this is what you wanted.

Cheers

Nick

[vundarosa]

Column C, Row 6 is where the tracking function needs to be changed if you want it to track other amounts of spins, ie. 20 spins, 37 spins etc.

I already have a 20 spin tracker as well and have attached it. 

Now you can see the difference between the Col C, Row 6 of both spreadsheets so you should be able to change it for any spin count.

Enjoy . . .

Nick

---------------
  u guys rock! thx

vundarosa

[Stepkevh]

matty, thx verry much.

it works like a charm 

this is my 2doz/2col follower sheet, tested with bayes rng 400 spins, +615u

[Badger]

Hi Nick

Thanks for helping me out again. Thanks to Matty too.
I've done my spreadsheet differently to Stepkevh as in the
example attached.

Thanks again.
Bruce

[Nickmsi]

Hi Badger . . .

Are you from the "Badger State" of Wisconsin?

I've tested 100's of systems in Excel.  If a system shows promise using Excel's RAND function, then I proceed to test it with live spins or online casinos.

I have attached your latest spreadsheet and expanded it to 100 spins.  You can expand to 1000 if you desire.

I then added the RAND function in Column B which gives you 100 spins at a time.  Simply press function key F9 to get another 100 spins and INSTANT RESULTS.

You can change the RAND function to NO for Zero or YES for Zero in Column B-Row 2.

If you are already familiar with this function, please disregard.  Perhaps, other members may find it of use.

Cheers . . .

Nick

[Badger]

Hi Nick

No, I'm from South Africa.

I was'nt familiar with the rand function.
Will try it out.

Many thanks
Bruce

[signurinu]

Anyone kind enough to make a tracker like this for the last 3 lines or for the Flatino sectors?
Attached is a excel sample with the sectors.

Have fun!
S.

[Stepkevh]

explain yourself for "the last 3 lines" :-)

and for the sectors its just always show the last 4 unique sectors ?

[signurinu]

By lines i mean double streets and yes, last 4 unique sectors.

[Stepkevh]

So, a excel for tracking last 3 unique lines and one for last 4 unique sectors ?

[signurinu]

No, the one i've attached will be enough.

[Stepkevh]

Signurinu,

something like this ?

you can see the formula

[Nickmsi]

Hello Signurinu . . .

There are many ways to track number sets, unique or otherwise.  Excel can just about do anything.

Stepkevh has kindly shown one way of tracking unique number sets.

Here is another.

The more you learn about Excel, the easier your journey will be.

I believe Ophis already has a tracker for F Lat Ino's sector system. Do a search on it and you can download his tracker.

Cheers . .  Nick