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

News:

Test the accuracy of your method to predict the winning number. If it works, then your system works. But tests over a few hundred spins tell you nothing.

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 2 Guests are viewing this topic.

holy roller

Ben can you help me out with this Excel question? I enter the spin results in the one column. then those numbers produce the numbers that show up in the numbers to bet column.

What I want to accomplish is to take the 3 columns that have the Numbers to Bet and put them all into one column. Then I want to sort it numerically from smallest to largest number. I also want it to delete any duplicate numbers. So if the #1 shows up three times I only need to see it once. (See attachment)

Hopefully that makes sense. Thanks for your help Ben!


Bigbroben

Hi Roller,

I've setup a new sheet where you can have all the nrs from the three column put in a increasing order.  It is not in one column but at least in one block.

This is the way I do it normally.  There are other parameters that can be added, such as max played mrs, W/L, reset conditions, progs....

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

holy roller

That is excellent Ben! I think I would like to be able to add W/L and Reset on a Win to the spreadsheet as well. That would be very helpful. Thanks for your help with this spreadsheet Ben.

Bigbroben

Ok, try this one.

You can choose to reset on a hit, at new high or not at all.
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

holy roller

Thanks for your help Ben. I hope to be able to put that to good use now. Thanks again for everything you do for this group.

holy roller

Does anyone know if this example below is possible to do in Excel?

I want to have a numbers that were spun column, and with each number that is spun it will be associated with 4 other numbers. Those 4 numbers will always be the same numbers.

Then i want Excel to search those 4 numbers and see if they correspond with any of the numbers that have already been spun as seen in the example below when numbers 3 and 26 are spun.

nrs       numbers to bet
1           1-10-22-34
2           2-16-25-29
3           3-18-19-26
4           4-6-30-31
5           3-5-27-28
6           0-6-11-32
26         3-18-19-26


So when there is a match with numbers spun like 3 and 26 because they both have the same 4 numbers Excel would tell you to bet numbers 3-18-19-26.

I am just curious if that is possible to do or not. Thanks for your help everyone.


lesliewheeler

Quote from: Bigbroben on Oct 08, 12:14 AM 2018
Well,

just take this one instead, it's "enhanced".
O0

Hi Bigbroben

There is some error in excel in showing  number to be played

For the series of live results 8,34,29,7,32,27,31,34,24,5

Play trigger number are showing as 12number to be played however it shows only 8 number 3,6,13,16,23,26,33,36

Next spin was 30 and it showed result was a WIN.

Pls can you check..

Nickmsi

Hi Holy Roller,

See if this attached sheet does what you want.

Simply insert your data sets into Column G.

Insert the numbers spun into Column A or use the F9 for RNG numbers.

Column E will show a repeat with the number "2" else no repeat is "1"

Cheers

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

holy roller

Well shoot Nick. I didn't know it was as simple as a VLOOKUP command. I thought it was a MATCH or CHOOSE, which I have never done before. The matching with the 1 and 2 is very clever. Thank you for your help. That should work Nick.


lesliewheeler

Quote from: lesliewheeler on Apr 07, 03:48 AM 2020
Hi Bigbroben

There is some error in excel in showing  number to be played

For the series of live results 8,34,29,7,32,27,31,34,24,5

Play trigger number are showing as 12number to be played however it shows only 8 number 3,6,13,16,23,26,33,36

Next spin was 30 and it showed result was a WIN.

Pls can you check..

Never mind have fixed it myself

Thanks

Bigbroben

Very well!  Glad you tried.  I've learnt from scratch.  Anyone can do it too!
Life is hard, and then you die.
Mes pensées sont le dernier retranchement de ma liberté.

Gitano

Hi All!

can someone help me in column P to avoid that number 1's shown without numbers spun ?

I've used in P:     =IF(OR(O3=$B$3;O3=$C$3;O3=$D$3;O3=$E$3;O3=$F$3;O3=$G$3;O3=$H$3;O3=$I$3;O3=$J$3;O3=$K$3);1;"  ")


And for column  X Y,Z,AA shown only the maximum distance between sorting lists (0's) .Just for example 7-->3  without  6 5 4 3 2 1 as shown in picture..

This is an idea I had for a system I want to test..

Thanks

Gitano :smile:

Gitano

This is the file,
basically my idea was to see how many times a certain distance in terms of spins ( for example 7 ) happen that the ball land in less spins again..
I don't know why but It seems to be a lot of time.. With this file I would check this behavior in the airball considered.


ati

Quote from: Gitano on Jul 19, 09:31 AM 2020can someone help me in column P to avoid that number 1's shown without numbers spun ?

You simply have to add one more condition to the formula. If the "numbers" cell is not empty, do the calculations, otherwise return a blank value.

=IF(O26<>"",IF(OR(O26=$B$3,O26=$C$3,O26=$D$3,O26=$E$3,O26=$F$3,O26=$G$3,O26=$H$3,O26=$I$3,O26=$J$3,O26=$K$3),1," "),"")

ati

By the way, there is a simple way to check if a cell value equals any other in a range of cells. No need to type in each condition one by one.

It looks like this:

=IF(O26<>"",IF(COUNTIF($B$3:$K$3,O26),1,""),"")

The other question I don't understand. Sorry.
There also seem to be an error in columns U and V. The ISBLANK formula is missing the reference.

-