excel again :)

[Gitano]

Thanks Nikmsi!

I'mchecking your way to find W,L meanwhile I thought this way and already done some checks with my sessions in airball..

[Bigbroben]

Hey Gitano,

did a little work for you:
it's simple, like you described:
Track 7 spins, play 3 spins with the finals that are left.
Gave you the option to stop on first win or play all three.

I am hoping to be able to modify it later on to introduce parameters such as tracking length, play length, prog, goal, other stats...

In the meantime, enjoy!

P.S.: Of course, you can also find Waldo somewhere in there...

[Gitano]

WOWW!!

I want to have your skills in excel!please! it's fantastic! Thanks Bigbroben!

How can I modify this for 10 spins not 7 ?
Tomorrow I will try
Kind Regards
Gitano

[Bigbroben]

Well,

just take this one instead, it's "enhanced".

[Bigbroben]

Gitano

I'll work on a positive prog for this one above.  Will send once it's done.

[Gitano]

Hi Big! Hi all,
if I can suggest a nice feature should be to show the W/L sections after 10 spins if the case of 2 finals, 3 finals 4 finals and 5 finals missing, in a way to know the statistics for each situation..

For example I would play ( and it is what I do in live playing actually) wait for sectors of 10 spins and only bet in case of 3-finals missing because numbers to bet are less.. :-) 

[Gitano]

Let me show only an example I play this in this way in a continuous game:

This is only an example but for me works, need a lot of patience because a person have to wait 110 spins..but it workswith small progression! and it play only 3 finals after 10 spins.

I wait "LL" with  3 finals or sometimes only 1 "L", let passing series of 10 spins in wich 4/5-finals wins, but I don't care of them I will win with 3-finals.
the file will help to know the probability of success playing this way..

[Gitano]

In "continuous betting" thread I've shown the W/L ( within 3 spins)  stats if betting at 11th,12th,13th,  all missing finals after 10 spins.. The winning W could appear in 11º,12º,13º spin.

KRegards

[Gitano]

Hi,
here in the green part you can find what I mean: put the numbers and  et'voilá!
It gives the consecutive sequence for 3 missing finals  ( 2 or 1 or 4 or 5 )  and when it Wins! follow the arrow..

more numbers..more probability to win Ehehehe
but I'm improving my excel..
Keep updating! and still curious about Bigbroben file!  U can do everything so!

[Gitano]

Hi Bigbroben,
Hi All,


someone can check this file in column AZ ? Why the LOOKUP formula consider the 3 like a 3 and 2  ? and a "4" like a 4,3,2,? ? Why it do not consider only a 3?
I would to show only the 3L for example .

Thanks

[Bigbroben]

LOOKUP function will look at value that are <= to what you write.  So if you want 4, and there is no 4 in the range you lookup for, it will give you the highest value still below your target (I think).
Why did you use IFERROR?  I do not know this one so, you probably have a reason I do not know yet.

If it really is 3 you want, I'd do like this:

[Gitano]

Here in second sheet I have %. 
If you put numbers on first sheet, copy past it and find yours stats,
..still not so automatic     :-\as I want..
but playing 3FINALS missing each 10# spins it is 63.95%..

Some work is waiting to find stats without bet if -7,-8,-9 finals appears..I think it should be some points in %..

[Gitano]

Hi All!!
Now I reach the point in which I have W and L in case of showing  1,2,3,4,5,6, finals  for three times after 10 spins..I'm doing tests.

The point I would ask maybe is simple but I fix in mind the "CONTIG" function in excel but I think it does not work properly and I am not able to find something similar to solve the issue with "How many WW or LL can shown during a lot of spins..

I was thinking "Which is better to focus on? BET after 3x WL or 4x LL for example?  knowing the probability should be easier (I know is not important but I dream a few ) 

Could you help me with this example? I'm basic in excel..and I'm spending some hours in this.. 

[Gitano]

*soLVED*

My file for statistics about finals is quite ready, after that I will use the Bigbroben file for progressions, graphs etcetera..
Thank You BigBROBEN!
Cheers

[Bigbroben]

Glad you found your way through it!

Could have helped more but ran out of time.

I did not understand exactly everything you expressed earlier or through excel.  I think we use different modus operandi ... 
I also am relative new to excel. With logic and patience everything is possible.

I still have to modify the file I sent to allow bets only when 3 finals left, like you wanted, I think.  What kind of stats would you want me to add, if any?