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 ??
Quote from: Stepkevh on Jul 15, 07:56 AM 2012
okay now probably an advanced step...
is it possible to make bettings appear with formulas ??
yes. tell us how the bet would be. :P