Is there somebody familiar with excel?
I just want to know how i can do something.
Example.
I got the numbers 13 2 28 35 6.
And i want in the column next it if its bo, ro, be or re.
What do i need to do?

Here you go mate.

I'm no expert but maybe this table will help you, I found it on my comp some time ago, I think it's from this forum
You just enter the number spun and it tells you the R/B, H/L, O/E, dozen and column of the number

Hope it helps you

Quote from: soggett on Jul 14, 11:54 AM 2012
I'm no expert but maybe this table will help you, I found it on my comp some time ago, I think it's from this forum
You just enter the number spun and it tells you the R/B, H/L, O/E, dozen and column of the number

Hope it helps you

okay thx, i can take some formulas from this to to apply on my own excel

Anyone........

It would sure help with Vile's idea if someone could open up the Excel and add lines to it.  Or is there one somewhere just for lines?

Sam

how do you mean Sam ?

When you input a number, say 3, it tells you that is in the first line, or double street.

That would make it so easy to find four unique lines.

Sam

step,

I've been using excel for many years.

IF functions are very useful

So, in the formula bar, we place =If(A1=1, 1, "") This means If the contents of A1 are 1 then show a 1, if they are something other than 1, show nothing. If I wanted to put a 0 or some other number then =If(A1=1,1,0)
example, I want to see if A1 is 1 or 6 or 12. I would need OR function

=If(or(A1=1, (A1=6), (A1=12)), "yes", "no") In this case if it is 1,6,or 12, it shows yes

attached is a simple excel sheet i made to track doz an col

It gives you an idea.

Quote from: Stepkevh on Jul 14, 11:16 AM 2012
Is there somebody familiar with excel?
I just want to know how i can do something.
Example.
I got the numbers 13 2 28 35 6.
And i want in the column next it if its bo, ro, be or re.
What do i need to do?

If you have downloaded the excel,

For b/o it is a certain amount of numbers, 11,13 etc. it would be =if(or(a1=11,(a1=13), (a1=15)................)1,0)

You will see $
$ fixes the number or letter. When you cut and paste, the shift to the next cell makes the A1 go to A2. A$1 makes A1 stay as A1 even after pasting else where.

$A$1 makes the A stay the same also.

I believe this may be more to what you're looking for....
AD

Quote from: Stepkevh on Jul 14, 11:16 AM 2012
Is there somebody familiar with excel?
I just want to know how i can do something.
Example.
I got the numbers 13 2 28 35 6.
And i want in the column next it if its bo, ro, be or re.
What do i need to do?

Use lookup() function in excel


you make a list in this fashion

D  E
0 GG
1 RO
2 BE
etc
...



then
if you have your spins startin on A2
on B2 you tell excel (with lookup function) to find that value on the tables you made


if the tables are made starting on cell d1 per exemple (d1 e1)


you write on b2


=lookup(A2;$d$1:$d$37;$e$1:$e$37)
then copy by dragging it all the way down.

(see attached file. Use it.)
Cheers
hope it helps

Quote from: TwoCatSam on Jul 14, 02:50 PM 2012
When you input a number, say 3, it tells you that is in the first line, or double street.

That would make it so easy to find four unique lines.

Sam

Just for you

Streets and the lines, enjoy

everyone, thx for all these helpful posts and sheets.

they're helping me really for my excel

soggett

You are a gentleman and a scholar!!

Thanks a ton!

TCS

okay now probably an advanced step...
is it possible to make bettings appear with formulas ??