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

News:

Every system can win in the short-term. It just depends on the spins you play.

Main Menu
Popular pages:

Roulette System

The Roulette Systems That Really Work

Roulette Computers

Hidden Electronics That Predict Spins

Roulette Strategy

Why Roulette Betting Strategies Lose

Roulette System

The Honest Live Online Roulette Casinos

excel again :)

Started by Stepkevh, Jul 19, 01:10 AM 2012

Previous topic - Next topic

0 Members and 7 Guests are viewing this topic.

Badger

Could someone kindly help me with Excel coding.

I am trying to look for a repeat in previous spins.
So on spin 2, I check spin 1
On spin 3, I check spin 1,2
On spin 4, I check spins 1,2,3 etc
I have attached an excel sheet to explain what I am trying to do.

The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Nickmsi

Hi Badger,

I have attached a Basic Repeat Tracker that I use.

Hope this helps.

Cheers

Nick
Don't give up . . . . .Don't ever give up.

nottophammer

MattyMattz, Nick
=IF(C2="","",IF(C2=1,"x",""))
this is in reply july19, 1:53, what is it asking the spreadsheet to do.

Or should i just ask what do the double speech marks mean and the comma
Thanks from a complete non excel person
How do you win at roulette, simple, make the right decision

Badger

Hi Nick. Thanks as always for your help.
I use this formula : =IF(ISNA(INDEX(B4:B12,MATCH(B13,B4:B12,0))),"",B13)

However, I have to keep changing the range on the column manually.
So on line 2, I have B1:B2
When I drag the formula down to the cell below it becomes B2:B3, where I want it to
remain B1 and the B2 must change to B3.

The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Nickmsi

Badger, to stop the B1 from changing as you go down the sheet, simply make it B$1 in the first row.

Matty ,will check out when I get back later today

Nick

Don't give up . . . . .Don't ever give up.

Badger

Hi Notto
The "" means an empty or blank cell.
So your formula means : If cell C2 is empty("") then make the new cell empty as well.
However if cell C2 contains a 1, place a x in the new cell, if cell C2 contains any other number make the new cell blank.
Hope that helps.
I also am not an expert on excel. Learning new skills is always good.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Badger

Thanks Nick

:thumbsup: That's just what I needed to know.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Nickmsi

=IF(C2="","",IF(C2=1,"x",""))

Badger you are correct in explaining this formula. As one gets more experience you could also code:

=If(C2=1,"x","")

It does the same thing but with less code.

Both ways work.

Cheers

Nick

Don't give up . . . . .Don't ever give up.

Badger

Could anybody help me with excel coding.  :(
I am tracking Double Streets, A, B, C, D, E, F
I want to track the last 4 that have come up.
1.     31   F
2.       1   A
3.     21   D
4.       3   A
5.     26   E
6.     28   E
7.    36   F
8.    10   B
9.    35   F
10.       1   A
11.     27   E
12.     23   D

So at spin 6 it will be E,A,D,F
At spin 7 : F,E,A,D
Spin 8 : B,F,E,A  etc

I have attached an excel showing how I do it for the last 2.

The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

Badger

For anybody that is interested, I think that this is the solution.

See attached spread sheet.
The biggest obstacle to discovery is not ignorance ; it is the illusion of knowledge.
Daniel J Boorstin.

nottophammer

Hi Badger,Nick
Below; i have at cell I:12; =IF(C12="","1",IF(C12="R","","1"))

It gives C12, 1; meaning it took 1 spin; the same for C13,C14 again 1 spin, but C15 blank,yes a repeat, so i need C16 to read 2; it took 2 spins. Same for C21; 2 spins, and C25 should read 4 spins

I've moved R's and 1's around and now starting to find it impossible to get it to count, do i need to add a count IFS ?
How do you win at roulette, simple, make the right decision

Bigbroben

If you really want cells in column I to show "" on a repeat, you should use the following in column J:
For J12:
=IF(C11="",1,J11+1)
Then for I12:
=IF(C12="",J12,"")

If you don't mind column I displaying 1111211112111212312123, then, for I12:
=IF(C11="",1,I11+1)

I think....
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

nottophammer

Thanks BBB
But i'm getting all values of 1 and =IF(C11="",1,I11+1) 1's and value error.

Again thanks, i'll carry on with formulas and functons for dummies, be along time getting the right formula thou
How do you win at roulette, simple, make the right decision

Bigbroben

Notto,

check columns J and K in the attached file, I did as described earlier:




Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

nottophammer

How do you win at roulette, simple, make the right decision

-