+ Reply to Thread
Results 1 to 10 of 10

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

  1. #1
    Registered User
    Join Date
    08-27-2015
    Location
    Heerhugowaard
    MS-Off Ver
    2010
    Posts
    43

    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!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,270

    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: copy to clipboard
    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.
    Attached Files Attached Files
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select “Solved” from the Thread Tools menu

  3. #3
    Registered User
    Join Date
    08-27-2015
    Location
    Heerhugowaard
    MS-Off Ver
    2010
    Posts
    43

    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. #4
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,270

    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. #5
    Registered User
    Join Date
    08-27-2015
    Location
    Heerhugowaard
    MS-Off Ver
    2010
    Posts
    43

    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!
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,270

    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. #7
    Registered User
    Join Date
    08-27-2015
    Location
    Heerhugowaard
    MS-Off Ver
    2010
    Posts
    43

    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. #8
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,270

    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: copy to clipboard
    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.
    Attached Files Attached Files
    Last edited by GeoffW283; 07-12-2020 at 03:49 PM.

  9. #9
    Registered User
    Join Date
    08-27-2015
    Location
    Heerhugowaard
    MS-Off Ver
    2010
    Posts
    43

    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. #10
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,270

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please help automate field generation on second sheet
    By hoolicanddd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2015, 08:55 PM
  2. Browse functionality on Excel sheet (samples added)
    By aukhan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 10:48 PM
  3. [SOLVED] Applying a formula to triplicate samples with a large dataset
    By a_coe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-01-2013, 11:58 AM
  4. Sheet Generation
    By cicmic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2011, 08:28 PM
  5. Generation of data in sheet 2
    By Tanza in forum Excel General
    Replies: 4
    Last Post: 04-30-2011, 01:12 PM
  6. automatic sheet generation
    By singoi in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-04-2008, 09:06 AM
  7. Automatic Sheet Generation???
    By DarrenG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-20-2006, 09:46 AM

Bookmarks

Posting Permissions

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