excel again :)

[Stepkevh]

@ MM

Almost 

maybe its better understandable if i say, the last 2 unique dozens.

3       x  d3
2    x x  2&3 
2    x x  2&3
1 x x     1&2
3 x    x  1&3
2    x x  2&3
2    x x  2&3
1 x x     1&2

[mattymattz]

yes that makes much more sense.  Gimme a min or two and I will update it.

[mattymattz]

Hopefully this works - Spreadsheet should show last 2 unique dozens.  If zero appears, still tells you to bet last 2 unique dozens.  Didn't test it much so if you find an error, lemme know.

MM

[Stepkevh]

thanks, i think that will do the trick 

gonna try it on my sheet

[vundarosa]

Hopefully this works - Spreadsheet should show last 2 unique dozens.  If zero appears, still tells you to bet last 2 unique dozens.  Didn't test it much so if you find an error, lemme know.

MM

------------------

............CONCATENATE, interesting, just learnt a new function , thx


ps: Lakers fan?!

vundarosa

[mattymattz]

Laker Fan is an understatement... ask xman

Glad you learned something new.

MM

[vundarosa]

Matty, here's another one a bit more tough....
say i want to count the last 10 spins and show/highlight the doz with most hits....

----

did you guys trade out Gasol?
nash is a bit old...shouldn't you be going after a younger pg and get him up to speed for the years to come...soma like the greens did with rondo...

vundarosa

[mattymattz]

I'll build a sheet for you shortly Vund.

Nash, I think, is a great pick up.  With 2 7footers under the net, we can afford the defensive liablility of Nash.  I am predicting he'll lead the league in assists next season.

MM

[Nickmsi]

Don't mean to jump in on your work Matty, but I have attached a spreadsheet that already calculates the last 10 spins for each attribute.

It's one that was already done.

Enjoy . . . Nick

[mattymattz]

fine by me Nick - saves me more work.

Thanks,
MM

[vundarosa]

I'll build a sheet for you shortly Vund.

Nash, I think, is a great pick up.  With 2 7footers under the net, we can afford the defensive liablility of Nash.  I am predicting he'll lead the league in assists next season.

MM

---------------

yes he's a defensive liability indeed....but you got world peace if he can remain (mentally) sane....however i don't see lakers getting more than 25-30 min /game max out of nash

vundarosa

[vundarosa]

Don't mean to jump in on your work Matty, but I have attached a spreadsheet that already calculates the last 10 spins for each attribute.

It's one that was already done.

Enjoy . . . Nick

-----------------------------

thx nick. that's just what the doctor ordered! it caps at 10, and deletes the 11th result so it counts only the last 10. i'm trying to tailor it to continue counting up to say last 12, 16, 37, etc. what argument is making it to cap at 10 spins max?!

vundarosa

[vundarosa]

<duplicate>

[Nickmsi]

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

[Nickmsi]

PS

Go BULLS . . . .

Nick