inside the excel:
LINE A real extracted numbers
LINE B 6 random numbers
is there a command (something automatic) that can show me the longest non hit row?
Roulette Xtreme
i have rx, i must go manually, i hoped excel could show me faster
Try the Gaps+DistanceCalculator
Quote from: gianfrancopierino on Dec 31, 04:47 PM 2021
inside the excel:
LINE A real extracted numbers
LINE B 6 random numbers
is there a command (something automatic) that can show me the longest non hit row?
Hi,
explain this a little better. I've done a lot about this with Excel. You want to know how many spins ago this nr showed up?
i play the numbers in column B, i would like to know the lenghts of the progressions needed every time
attached in column C you have some examples, i would like to go in automatic
A progression where you'd be at 0 or +1 on a hit? or a softer one where it would take 2-3 or more hits to be above?
Attached are 2 sheets with your nrs and random nrs.
You can choose how many hits you want it to take to be above. It's much softer for a prog but can end in negative territory.
Anyway, enjoy. Enter the values you want in the blue cells. The rest is auto calculated.
Hi BBB..
Is there possible to make a sheet to give us an output like this every time we have a repeat...
Manual is pain..
23,12,14,5,17,12
0,32,25,36,9,25
3,18,24,3
What do you mean?
A column where previous spins would show? or repeaters?
yes it is possible.
send an example
Yes a column until a repeat then continue on the rest, add new numbers..
Ok so you do NOT want to play the repeating nr, right?
No BBB i just want to get that output.. I don't care for the repeat..
Ok.
In your scenario, the yellow-highlighted nrs that are repeating one right after the other: normal spins or you simply emphasized on these?
I just colored them so i give you to understand that i want to continue after the first set i complete ..
Lets say i input 1000 spins and i get them arrange like that..
Like this?
Any modifications to add?
Ok.. the first repeat we have that's a set and , end there.. but on the next row i need to start from the new number and not repeating the pattern like that ...
Voila
Almost there.. i need Bothe repeater on each set .. so the last number is the repeater
Repeater is in front of nr serie.
P.S. It always ends up at -2.7%.
BBB its simple but i don't know to code it...
I need the first one exactly not the second..
Its ok anyway
does anyone knows the formula to count the empty spaces from 1 every time a new empty cell start..?
OK, if on cell D6:
=IF(B6="";"";1+C6)
Thank you BBB ..
If i have only the 0 and the 1 does the formula change?
?
Change "" for 0
like this..
Like this.
If you can make it so the zeros don't show at all only , but it ok yes
ecco...
Thank You...
Quote from: alexlaf on Jan 13, 06:31 AM 2022
Thank You...
Poi ci aiuti a capire come giochi ? grazie
A spreadsheet from me .. cheers
Quote from: alexlaf on Jan 17, 07:07 AM 2022
A spreadsheet from me .. cheers
Can you please explain your look-up formula? How the numbers 6,14,20,31 come about?
Thanks
Quote from: mohitomish on Jan 17, 08:07 AM 2022
Can you please explain your look-up formula? How the numbers 6,14,20,31 come about?
Thanks
Sono gli ultimi numeri usciti in ogni quad. Ma come si usa, grazie
It will give you the last newest numbers for each group...
Quote from: alexlaf on Jan 17, 08:33 AM 2022
It will give you the last newest numbers for each group...
Thanks, whats ur trigger to bet, are u using the law of the third? please explain.
Quote from: mohitomish on Jan 17, 08:07 AM 2022
Can you please explain your look-up formula? How the numbers 6,14,20,31 come about?
Thanks
Good question!
=LOOKUP(2;1/(A2:A38<>"");A2:A38)
This is a new usage of lookup function to me. How did you get there?
i wanted exactly that.. something to give me the last result..