# Can someone help me with generation of large samples of my sheet?

1. ## Can someone help me with generation of large samples of my sheet?

Hi,

Thanks to a helpfull member of this forum I came somewhat further in my quest to playing the game of roulette succesfull.

I would like to ask you guys for help. I have an excell sheet now where I generate random numbers (I want to convert this later into a usable sheet for
my mobile phone but for the time being now I'm in the evaluation stage.

Basically what I would like is I want the excell sheet to run this system (Bet Selector Tab) for instance a 100.000 times so I get clear overview what it does on a large
sample. I would like to see the count of the number of times the unhit numbers is 12 in a row.

So basically it should be a kind of legenda:
12 unhit numbers hit after the first time 12000 times
12 unhit numbers hit after the second time 8500 times
12 unhit numbers hit after the third time 6000 times
12 unhit numbers hit after the fourth time 3500 times
12 unhit numbers hit after the fifth time 2000 times
12 unhit numbers hit after the sixth time 1500 times
12 unhit numbers hit after the seventh time 500 times
Etc.

Basically my goal is to find a playable solution where I don't have to wait toooo long and which will keep my progression low before I hit a win.

Can someone help me with this?

I hope it's clear how I explained it.

Kind regards!

2. ## Re: Can someone help me with generation of large samples of my sheet?

Oh well. Nobody else has jumped in so far, so you're stuck with me for now
I'm not sure I've fully grasped what you want but let's see . . .

I think your intent is to run the "Bet selector" worksheet numerous times to determine how often
you get 1 x 12-count, the 2 x 12 counts then 3 x etc.

I think this needs VBA so the attached workbook is now macro enabled.

I have added worksheet "Counts" to summarize the results. It looks as follows:

Seafreight.png

Enter the number of iterations to be performed in cell B2 and click on the "Play" button. The table A6:B26 summarizes the results.

I too a few timings on my long in the tooth core-i5 laptop with the results summarized in D7:E10. It looks like the run time is better than linear with number of iterations but it would take me best part of a day to do 100,000 iterations.

The only formula on the new worksheet is B4 which gets the number of consecutive 12's from the "Bet selector" worksheet:
Formula:
`Please Login or Register  to view this content.`

Here's the rough and ready VBA that is attached to the "Play" button:

``Please Login or Register  to view this content.``
I hope this is close to what you are looking for. Let us know.

The revised workbook is attached.

3. ## Re: Can someone help me with generation of large samples of my sheet?

Hi,

Thanks a lot. This is very cool. Can you increase the list say until 35 instead of 20 since if I run it 10.000 times but there are also possibilities that
it goes until 24 and then it drops of the list.

And one more request although I need to open a new thread for it but I'm not sure if it's worth an entire thread, can you add a start counting from nr.... which I can fill in. If
you look at the bet selector sheet you can see that I marked number 37 green. The reason I need this is to test from which spin nr. (or level) the numbers go down significantly to
make it playable and decreases risk.

If I need to open another thread just say so but I also don't want to bother you guys to much.

Thanks again Geoff for your amazing help. You're a super human!

Greetings,
Amro

4. ## Re: Can someone help me with generation of large samples of my sheet?

Actually, the way my crude VBA is, without change, it's already counting beyond 20 without limit. I did in fact see one instance of 23 during testing. I'll extend the numbering down and the green fomatting, that's all that needs to be done!

There is a small (possibly vanishingly small) possibility that you don't reach down to 12 unused numbers after 100 turns. I added error detection to flag this if it occurs.

We can probably stick with the same thread for the moment but I'm not certain what you want for "start counting from". Do you mean that, for example, if you choose 37 then above this row then "total unhit numbers" remains at 36 and all 36 numbers are listed as "not yet hit in columns E:AN and then at turn 37 you will show "total unhit numbers" as 35 and compute columns E:AN just like the spin number 2 row - that is list all 35 unhit numbers. Perhaps a picture would be easier! Like this?

Seafreight_1.png

5. ## Re: Can someone help me with generation of large samples of my sheet?

Hi,

I explained it wrong I think. Let me explain it better. We are talking about the counts sheet. I would like an option in this
sheet where I can enter a number and from this number which is the same as the spin number (Column B in the bet selector sheet) to enable
counting only if it has 12 sleepers (numbers that didn't got spung) from that level.

Let me give an example:

I enter in this new cell the number 40 (which is the same as spin 40 in the bet selector sheet.
Now when we run the counts simulator you build it only starts documenting the data if it started on spin 40 or later.

I hope this is somewhat more clear.

Can you use the latest attachment since I added a percentage in the counts table.

Thanks my friend!

6. ## Re: Can someone help me with generation of large samples of my sheet?

At the moment in the "Counts" worksheet col-B I count how many consecutive 12s occur wherever they occur on "Bet Selector" col-D. If you enter 40 on a TBD cell on the counts worksheet then you only want to count the consecutive 12s on "Counts" col-B if they occur at or beyond spin 40. Do I have this right now? are the 3 examples below correct?

Seafreight_2.png

If I'm still way off base, perhaps a picture with what you expect would help.

7. ## Re: Can someone help me with generation of large samples of my sheet?

Hi,

The first and second image is correct. The third should also be count 0. Only if they start "at" or "after" the preset point it should start counting
them .

That way I can start evaluating after which point I get quick hits instead of longer progressions.

Thanks,
Amro

8. ## Re: Can someone help me with generation of large samples of my sheet?

OK, with that clarification then I THINK I understand.
Counts!B3 is the new "Starting spin number", set this to whatever value you wish.
The attached workbook, for testing purposes, has two windows open, one on the "counts" worksheet and one on the "Bet selector" worksheet.

Click on F9 (recalculate) and make sure that what you see in counts!B5 (Consecutive 12s on this iteration) is consistent with what you see on the "Bet Selector" worksheet. Repeat this process until you are happy that the behavior is correct.

On the counts worksheet I have introduced row-8 to count occurrences of zero valid 12s. If you set "Starting spin number" to, say, 10 and click on "Play" then zero will never occur. Conversely if you set "Starting spin number" to, say, 80 and click on "Play then zero 12s will occur 100% of the time.

To achieve the above the only formula I had to change to implement the behavior noted in the post #5 diagram and your post #6 comments was B5:
Formula:
`Please Login or Register  to view this content.`

A workbook with the above (and including the percentages that you added) is attached.

I hope I have this right! Let me know.

9. ## Re: Can someone help me with generation of large samples of my sheet?

Hi Geoff,

This is very cool.

Thanks a bunch.

Greetings,
Amro

10. ## Re: Can someone help me with generation of large samples of my sheet?

Thanks for the feedback. Glad I finally understood what you were looking for.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1