Pages: [1] 2 3 ... 12
1
Main Roulette Board / Re: @ turbo
Excellent contribution
on May 13, 03:20 PM 2019 by nottophammer

Oh, RATION PULETTA if reading backwards.

Ha!  funny guy, I'm sure it's a joke and it's a good one!

The real Pasion never gave such clear clues....
2
General Discussion / One year!
Like
on Apr 17, 06:04 AM 2019 by bigmoney
I love reading books. I go to the library, borrow mostly ''Romans policiers'', I guess thrillers is the word.

One day last November, I went there, took this book without reading the back page.  I thought it was going to be a great novel, some kind of bank robery stuff.

Title was: 13 against the bank.

And it all started then.

Didn't know shit about Roulette.  I knew there was game called Roulette in casinos, did not know exactly what it was.
Did not know anything, or almost, about Excel either.  From testing and searching, I got to learn new functions and tips with Excel and went quickly from ECs to straight-ups.

Guess you can say I got hooked real quick.  Been reckless (relatively) playing online at start and lost 30\$ !!!!!

This is a fun journey, I enjoy the forum here.

Still studying, like a futur surgeon at school, learning lots before to operate anyone.

I did not happen to read any other book about roulette in the way it is told in 13 Against.
Any book suggestions?
3
Main Roulette Board / Re: A new possible HG
Like
on Mar 28, 12:27 AM 2019 by Proofreaders2000
So can I:
4 nrs only.
4
Outside The Box / Re: Outside the box: a different view on roulette numbers
Like
on Mar 21, 07:33 AM 2019 by Person S
It's in french but it's an quantic out-of-the box concept.  Could inspire anyone...
Oh!  The cat repeats, oh! it's unique now.

5
Like
on Mar 18, 12:46 PM 2019 by sugtips
Just a thought:

1+3+5+7+9+11=36

A nr hits (or repeat).  Play it, next spin: both neighbours (3 nrs), next spin, the nr plus 2nrs on each side (5 nrs), then 7, then 9, then 11.  Stop?
6
Main Roulette Board / Re: A new possible HG
Like
on Mar 17, 07:52 PM 2019 by Firefox
Meister,

we were thirsty of your teaching but we unfortunately could not understand your paraboles, or could not find a balm on our hunger for infos.

7
Testing zone / Re: Dealer's Signature. Does it Exist?
Like
on Mar 16, 10:14 PM 2019 by Firefox
Is the tilted wheel just an add-on to your test? I mean:  one would believe a tilted wheel belongs to the wheel bias category, whereas the thread is called dealer signature.

How would you differenciate the origin of an exploitable deviation from expectation, if it comes from the wheel or the dealer?

In extenso: from throwing balls on a wheel, do you get a better "feel" of the dealer and able to identify  signatures easily?
8
Coding for Roulette / Re: excel again :)
Like
on Mar 13, 05:31 AM 2019 by Firefox
But then, when playing and adding the nrs in ther sheet, you don't want to scroll all the way to the right, find where the little ''1'' is, look for which corresponding nr it belongs to, then scroll back and bet.  You want to have the numbers displayed handily for quick action.

How to go from 37 columns with 1s and 0s to a display like this one below?

It requires 3 blocks of 37 columns:
1) the first was described earlier today
2) lookup block
3) display block

LOOKUP block:
LOOKUP function finds the value you indicate in a first column and return the value in the same row in a second reference column  (you can decide to reduce the lookup to a few cells, but for practical reasons I like to use the whole column).

Ex: for cell F4, we ask lookup to find the value of E4 in column A and return the corresponding value from the B column:
=LOOKUP(E4,B:B,C:C)

N.B: the first column to look into must have its values in an ascending order, sonst it will return the wrong value.

So, the second ''LOOKUP'' block will be used as a reference for the third block.
The first row of the 37 will have a value of 1.  The following will be as such:

with a 38th column using the same formula for LOOKUP's way of reasoning.  If it looks for nr 4 and there are 2x nr4 in the first search vector, it will take the furthest corresponding value of them all, so the last 4.  The 38th column is to include nr36 in the search.  This second block is to build an ascending streak of nrs that the LOOKUP function will pick from.

So, if nr0 (cell CI40) in the first block is a 1, be 1u higher that the cell on the left (AW40), otherwise, same value as AW40.

Click and drag to the cells in the block, double click on the black square to copy them all the way down.

3)DISPLAY Block:

It all comes finally to this one.

LOOKUP will find the value of the nr in row 3, so this row is just a reference. ''1'' means: ''first nr to play is...''  so not the nr itself.
So, this part here:

In this example here, there are 15 nrs played.  The 38th column in the second block returns a value of 16, so:
IF(L\$3>=\$CH39,""
You don't want the last nr played to repeat over and over in the display, or have a false bet.  So, if the reference nr (L3) is bigger or equal to 16, empty ('''')

(Ah? Why CH39 and not CH40 if we are on cell L40?  Because we want to see the nrs to play before the spin is made, right?

Right.)

Notice the \$ signs where they are:
LOOKUP(L\$3,\$AW39:\$CG39,\$AW\$3:\$CG\$3
The nr to look for is the one in L3 (1).  For row 40, you find it in the row 39.  The \$ is before AW and CG since this is the columns to look for for all the other columns in the third block.
The returned value is always in the Row3, where the played nrs are associated, hence the \$ before the 3.

Click drag copy to all other cells in the 3rd block and you should be good.

Put the 3rd block near where you write the nrs for ease of reading.

9
Coding for Roulette / Re: excel again :)
Like
on Mar 12, 01:22 PM 2019 by Gitano
Straight-ups are rather easy to deal with.  It'S the mix of splits and corners that are harder.

As for striaght-ups, or any category of bet, here is how I apply the reference cell.

Cell B3 is the one giving the parameter to consider ( here, it's the backtrack length).

Then all nrs or splits or corners are assigned a nr written on top of the sheet (here, row3).

We'll check the formula for cell CJ4

Part1: IF(\$E4="",""
Column E is where nrs are written in this sheet. If there is no nr written in the E4 cell, (if(E4=""), then put nothing in this cell.
Dollar sign before E (\$E4) will let you block the reference column if you happen to copy/slide the formula to the other nr columns.

Part2: IF(\$D4<\$B\$3,0
Column D is the spin nr.

So, if not enough spins have gone by, less than the tracking length, I ask it to write zero, otherwise it will call #REF!
\$ in front of D4 to keep the reference column, and \$ in front of both B and 3 to keep the one cell as reference ( same column, same row).

Part3:
If (COUNTIF(OFFSET(\$E4,-(\$B\$3-1),0,1,1):\$E4,CJ\$3)=0,1,0
Goal here is to see if the nr associated with the CJ\$3 cell appeared in the tracking window.
Normally, it would be COUNTIF(\$E4:\$E4,CJ\$3, which would return how many times the nr in cell CJ3 appeared.  Here, if the result =0, write 1( we want to play the nrs that have not hit in the last 25 nrs).  The 0 in the end is the value to enter if all predecent conditions are false.
OFFSET is very useful when needing to have a varying tracking window.
Denomination is OFFSET(reference, row, column, height, width)
So, we want to know here, for example how many times the nr appeared in a 25 spins window, in cell CJ4.
To make it a 25 spin window, we make the reference as \$E4, then we want to backtrack 24 cells up, which will give 24+1 cell to track.
So: OFFSET (\$E4 = reference
OFFSET(\$E4, -(\$B\$3-1)  minus B3 cuz we are going up, not down, and minus 1 cuz reference is 25 and we already have one with E4
OFFSET(\$E4,-(\$B\$3-1),0,1,1): no change in the column reference, 1cell height, 1 cell width

With this setup, just to modify the value in cell B3 will change the range of the tracking.
With the proper use of \$ signs, you can simply click on the cell, click on the little black square bottom right of the cell, hold-drag to all nr columns further right and all the new cells will have the formula copied onto them.  If double click on the square after dragging to the whole row, it will copy the formulas to the lower cells all the way down, provided there is a neighbouring column with inputs.
10
Testing zone / Re: MODI 1
Like
on Mar 02, 12:44 PM 2019 by sugtips

So, somewhat inspired by the grouping of nrs here.  It's a crescendo of 2 gaps alterning higher then lower.

Might be more of a point if applied to real wheel.  A unit every second nr, right left right left...
Pages: [1] 2 3 ... 12
Popular pages: