Next challenge is to show random values in each cell Now I created a 3*9 region and filled the cells with 1s or 0s, “1” when the cell in bingo ticket is supposed to have a value and “0” if the cell is empty as shown below: Selecting any five cells out of nine cells You can see the first five such combinations in the image below: So I listed all these combinations in a table and then randomly selected one of the combinations. 126 ways in which you can select any 5 cells out of 9 cells ( without repetition of course). Instead we can list all the possible “5 cells with numbers and others are empty” combinations of a 9 cells region and select a random combination every time. The function is memoryless and could repeat numbers when called 5 times. Now, excel has a function to generate random numbers between 1 to 9 ( =round(rand()*9,0)), but this is not good for us since each time we call this function we will get a random number between 1 to 9, where as we need a 5 random numbers without repetition between 1 to 9. Once we select any random 5 cells in a 9 cell row, we will fill them with bingo numbers. The first challenge is to select any random 5 cells in a 9 cell row Now I could write a function in VBA to do this, but I wanted to do this only using formulas. The problem is now to “generate 15 random number between 1 to 89 and fill them in 15 random spots in a grid of 3 rows by 9 columns such that each row has exactly 5 numbers”
I have removed number “90” from the list in order to reduce some complexity in generating the tickets. * The third 20 to 29 and so on up until the last column, which contains numbers from 80 to 90. * The second column numbers from 10 to 19, * The first column contains numbers from 1 to 9, Each column contains either one, two, or very rarely three, numbers: Each row contains five numbers and four blank spaces. , contains fifteen numbers, arranged in nine columns by three rows. Read on if you want to know how this is done:Ī typical housie/bingo ticket.
Note that these are Bingo UK / India / Australia variant I am talking about, not the US 5*5 type of bingo tickets. To get new set of tickets you would hit F9 (recalculate).Ĭlick here to download the bingo / housie ticket generator. So, out of curiosity I have created an excel sheet that can generate bingo / housie (housey) tickets – 24 of them at a time. That is why whenever I get sometime I experiment with simulating games to know them better.
They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money.
0 kommentar(er)
