#1 Roulette Forum & Message Board | www.RouletteForum.cc

Roulette-focused => Main Roulette Board => Topic started by: ddarko on Aug 12, 12:35 PM 2015

Title: Excel Help.....
Post by: ddarko on Aug 12, 12:35 PM 2015
I'm next to useless on Excel (well I know when to hit the sum button !!!) & am looking for some help
regarding tracking the EC's.

Can anybody PM me the formula required to breakdown the 3 possibilities of the EC's ?

Eg A1 = 7 therefore B1 = RL/RO/OL ?

That kinda thing ?

As I test by hand, I'm just looking to quicken up that process......

Many many thxs to anybody who is willing to help me out  :thumbsup:

O0
Title: Re: Excel Help.....
Post by: Nickmsi on Aug 12, 01:24 PM 2015
Hi . . .

Attached is how I breakdown the 3 EC's using Excel's formulas.

There are other ways to do this, but this is the one I always use.

If you need more help, just ask.

Cheers

Nick
Title: Re: Excel Help.....
Post by: ddarko on Aug 12, 03:05 PM 2015
that's kinda it Nick, but not quite what I am looking for......

cell A1 number = 7

therefore

B1 = RL
C1= RO
D1=OL

So instead of what you just posted, at anytime (depending on what I'm looking to bet) I know what two of the Ec's are doing, so to speak, & said data is available in ONE cell only.

BUT, many thanks for what you did do, it's greatly appreciated  :thumbsup:

O0
Title: Re: Excel Help.....
Post by: helena on Aug 12, 09:06 PM 2015
Maybe something like attached.
Title: Re: Excel Help.....
Post by: ddarko on Aug 13, 08:16 AM 2015
Quote from: helena on Aug 12, 09:06 PM 2015
Maybe something like attached.

Not quite Helena but thank you for your efforts  :thumbsup:

I'm looking for the example below......

O0
Title: Re: Excel Help.....
Post by: helena on Aug 13, 09:11 AM 2015
OK, try this.
Title: Re: Excel Help.....
Post by: ddarko on Aug 13, 09:15 AM 2015
Quote from: helena on Aug 13, 09:11 AM 2015
OK, try this.

Bingo !!!!!! (I think, I need to check it some more) thank you v v v much Helena for taking the time to help me  8)

& the same goes to you Nickmsi  ;)

O0
Title: Re: Excel Help.....
Post by: sniper on Aug 14, 07:48 AM 2015
Hello Nickmsi ,Helena and Ddarko

Since we are on this subject, I need help on Excel's formula regarding pattern recognition for baccarat.

I recorded my baccarat outcome vertically from top to bottom for each shoe. I need to locate 2 patterns among the data.

The first pattern is "BBPPBBP" and the second pattern is "PPBBPPB'. Once located the pattern should be high lighted.

Thank you very much.

Best wishes and regards



Title: Re: Excel Help.....
Post by: Nickmsi on Aug 15, 03:55 PM 2015
Hi Sniper . . .

Yes, I have this pattern already coded but I am on vacation until 8/21/15.

If you do not get anyone else to do code this for you, just contact me directly at

nickmsi@aol.com.

Cheers

Nick
Title: Re: Excel Help.....
Post by: sniper on Aug 15, 06:59 PM 2015
Hello Nickmsi,

Thank you very much. Enjoy your vacation.

Best wishes and regards to you and family.