excel again :)

[Gitano]

HI Big,
have time to study is really a problem, but I do what I can do, so a little help for this formula please! why this LL is not count with COUNTIF ?
It only counting WW but it s the same!
Thanks!
After a while I will explain better the other your file.

[Bigbroben]

Quickly I'd say there is a space  between the 2 Ls?  Or a space missing?  The ones in the formula are closer one to another than in the cells...

[Gitano]

yaaaa! fu*#..lost 20 minutes for that!
Now I discovered that the CONCAT ( L WITH L ) for 2 cells leave a blank space with two  (W W)  NO......WHYYY!!
thanks again..

[Bigbroben]

And now I discovered the CONCAT function, thanks to you...!

[Gitano]

here what I was thinking in the beginning.. do a table and discover what better timing to play the 3 finals or 4 finals and "when".
"Concat" is good to discover couple or triple and countif..very good..under construction! Bye

[Bigbroben]

Anastasius,

click on the first nr in the column:


Double-click on the little square on the lower right corner of the cell.  It will select all the cells below in the column.


You can now either: right click and clear content or clear the content by using the function in the header.

[Anastasius]

And how to calculate the entire strip!? Lol

[Bigbroben]

And how to calculate the entire strip!? Lol

It's done automatically.  This is what a spreadsheet is for.

[Anastasius]

Broben is a way to change the spreadsheet to unhit 18 splits instead of singles. And everything else the same 

[Bigbroben]

You've been: PM'd.

[Firefox]

Excellent spread sheet instruction, BigB. I used to be into them,  but have fallen a bit out of touch. I'm probably going to use QBasic or Python for simulations. However, I think spreadsheets have some advantages and great portability.

[Bigbroben]

Yes, Excel offers tremendous possibilities.  Most systems can be built with it, actually all the ones in Rx.  Reference cells are great to change parameters, instead of modifying all formulas, may it be tracking length, triggers, progressions, goals, stoploss, hit, unhit, pairs, neighbours...
I still have a relative hard time with mixed bets, such as splits, corners and straight ups altogether (Kattila! I could not achieve what you asked), but Excel can achieve it if setup properly.
It can calculate 10000 spins in a second.
It  can  run macros to get stats, averages, extremes..
Love it.

By the way, I'm kindof addicted to it so if anyone needs something coded I'll be pleased!
It is of course one interface and one must have excel to start with, but it's standard now on  computers.

Would be interested in learning Qbasic or Rx or VisualBasics, but also visual ballistics!

[Anastasius]

yo i like your spreadsheets but im confused, for example i opened the split hits game and it ends -1500     . i then touch nothing except the parameters and change them from 12 to say 30 then it makes a new graph and ends -2500 i then change the parameters back to the original number 12 and touch no numbers.....  it then shows a totally different end game outcome -500 ..... is this a fault or am i doing something incorrectly 

[Bigbroben]

It is.the function of random nrs in the nr column.  It  will change nrs everytime you do something.  You can clear them and add yours.

[Anastasius]

Thanks

A reliable member did an rx test that was +9000 after 100.000 weisbadens and i cant even get the excel to win 10.000 inputting dublin bets  its hurting  my feelings lol however thanks for ur help n skill.