Housie Number Caller
Zareen Zapata
I'm trying to create a typical Housie/Bingo Game ticket in Asp.net 2.0 (VB). But, not being succeeded. Ticket contains 3 row with 9 columns. Total 27 blocks, and it must be only 15 should be fill outta those 27. and each column contains value like 1st column should be between 1-10 and 2nd must have random values between 11-20.. It doesn't matter how many blocks filled in each column.. 1 is must, no single column should be blank, all 9 columns must be filled, some have all 3 blocks filled, some have 1 with total of 15 blocks filled in whole ticket. with random numbers..
Guys here was the typical housie ticket specification.. Please help me out generating a ticket like this. I've tried but, not being that much succeeded, I get whole column blank and validating columns.. takes extra load on system. please find me the way to make it.
This algorithm will take you exactly 9 steps + 6 steps in the loop so it's deterministic which is better for the processor utilization. And it also fills your ticket with up to three numbers per column and not less than 1 (if I understood your requirements due too poor english in the question).
This solution has been simplified by using arrays and counters. You could of course create a complete object model that would be functionally rich and would provide you all the info you need. You could for instance have a Ticket and TicketColumn classes:
The approach given to this problem goes like this;I have prepared 10 lists. Each list has with 3 unique random numbers arranged in ascending order, ranging from 10 to 20, 20 to 30, ..., 80 to 90. Next, I have assigned the first number in 5 random lists to the top row, the second number in another 5 random lists to the middle row, and the third number in another 5 random lists to the bottom row. I have done this with the intention of not repeating the numbers, ensuring that only 5 numbers are printed on each row of the ticket, each column has it's number in an ascending order form top to bottom
I have used empty strings ' ' to be printed where there are no numbers to be printed and I have used the asterisk/star ' * ' mark to tell to the player that he/she has marked that number on that ticket!
I have ensured that the numbers called don't get repeated(The main board is a list with numbers ranging from 1 to 90 and each time a number is called the sam random number is removed from the main board and while the player is given the opportunity to mark, the code ensures that the number is present in the player's ticket and the number is not present in the main board. If the player inputs a number which doesn't satisfy the above mentioned conditions, it keeps on asking until the player input a correct number
The speciality of this code is that it accepts arbitrary number of players. It initially asks you the number of players playing the game and then asks that many times the name of each individual player
Tambola, also known as Housie, bingo is a game of probability. Tambola is an engaging game played in various countries from generations.The caller/dealer calls the randomly generated number/cue one at a time. The players mark off the numbers on their tickets as the numbers are called by a caller. The winner being the first person to mark off all their numbers of a winning combination.The Tambola ticket or card has 3 horizontal rows/lines and 9 vertical columns with a total of 27 boxes. Each line has 5 numbers on it and four boxes are left blank. Thus a ticket has a total on 15 numbers. The first vertical column can have numbers from 1 to 9, the second column from 11 to 19, the third column from 21 to 29, and so on and the last column can have numbers from 81 to 90.This Application work as Caller in Tambola/Housie/Bingo Game . it Generates random numbers. Tambola or Housie or Bingo is played with Numbers (1-90) being called out by 1 person/caller and players striking out those Numbers on their Tickets.How To Play?1) The Caller needs to generate a random number if Number matches in below numbers ,number colour green to indicate numbers.2) If a number called by Caller exists on a players ticket, then the player has to strike it.3) Once a particular Winning point is achieved by a player, he has to claim for it immediately.4) Caller has to verify the winning by matching the struck numbers on the ticket with the called outnumbers. Caller then declares if the winning has been successfully claimed. If not, the winning pointis still available to be claimed.5) Game ends when all the Tickets are successfully CLAIMED.Its a fair play game. Must for kitty parties for playing Tambola or .Housie or Bingo. No chance of cheating by anyone.Various Rules that can be created in oder to have multiple winnings .1) Early 5 (first 5 number strike will win)2) Early 7 (first 7 number strike will win)3) Top line4) Middle Line5) bottom Line6) Corners (first and last number in top and bottom line )7) Younger (all number below 46 )8) Older (number above 45)9) Full house (All numbers strike out )Enjoy Playing* This app only works as a caller for Tambola/ Housie , You need to get physical tickets for playing the game or You need to Scan the Tambola Ticket QR Code by Downloading the Same using the Link
Bingo callers often use nicknames to call out numbers instead of the actual number in 90-Ball UK style Bingo/Housie, to spice up the game. Here is a list of all those bingo number names in numerical order:
A typical housie/bingo ticket .., contains fifteen numbers, arranged in nine columns by three rows. Each row contains five numbers and four blank spaces. Each column contains either one, two, or very rarely three, numbers:
Once we select any random 5 cells in a 9 cell row, we will fill them with bingo numbers. 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. The function is memoryless and could repeat numbers when called 5 times.
First I created all 2 number combinations and 3 number combinations. Since the numbers on Bingo ticket are always sorted from top to bottom in a column, I just had to list down 45 combinations (10C2) for 2 numbers and 120 combinations (10C3) for 3 numbers.
I really liked your Housie Tickets. However, the tickets printed out are too small and I can't seem to increase the size to the regular printed housie tickets. Can you help me out please? Thank You. Dina
I am having difficulties with sizing. I need eight tickets on A4 Landscape page. I am not too good with Excel but better with Libre Office Calc. I have tried to save to that format but it doesnt work. Can anyone send instructions that are not too technical?
[...] Play seems to be the focus of excel blogosphere last week. Debra at contextures has created an excel file to generate bingo cards (US style) in excel. Several others followed it up with their own versions of bing number generators. Follow the links, download the book and have some fun! Also, Generate UK / Indian style bingo cards [...]
Hey...
This is cool.. We were planning for a potluck event where I wanted to host this game but was thinking if I should go and buy it from the store just for this one time.. so as usual google'd to see if there was any generator and your's was the first hit... its cool and easy to print and I love it!!! Thanks a lot!!!
@Jo.. "I have removed number 90? from the list in order to reduce some complexity in generating the tickets." Generating 90 along with 80-89 creates a tricky problem of having 11 numbers in the last band while every other column has only 10 possible values.
I want to print more than a 1000 of these tickets, so dont want to click on refresh button 250 times.. so if once I click refresh, is it possible to generate 50 or so worksheet at a time? So that I can click refresh 4 times and get my 1000 tickets?
There is an online generator at , which generates the numbers in blocks of 6 cards, where every number from 1-90 is used. This is how the UK style books are usually printed, so that if you buy 6 tickets you are sure to have every number once and only once. Makes the generation routine a little trickier.
Hi Chandoo,
really liked your bingo sheet. wanted to make a program of it in delphi or vb. i cannot figure how the randomizing of the numbers is to be done properly.
1. Row wise select ion of 5 numbers and place random (0-99) in these five places
2. random selection of 15 numbers and place then as 10,20,30 so on
has a function been done by you?
These tickets can not be used to play standard 90 ball Bingo, the number 90 is missing and the tickets must be produced in blocks of 6 which contain every number from 1 to 90. Also you can not have any columns with three blanks ( no numbers ) on the same ticket.
I'm really impressed with your writing skills and also with the layout on your weblog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it is rare to see a great blog like this one these days.
Hi Chandoo,
I wish to Customise these tickets for one of my wedding ceremony.
Basically I wanted to replace numbers with Names/Movies etc. So in total I will have 89 names and when the excel generates the numbers, the names should get replaced with it depending on how it is configured.
eg : For Number 1 = DDLJ
2 = DON , etc
Can you please suggest the command to be written in excel which will support the above idea. It would be a great help.
column 1 should contain 1 to 10, column 2 should contain 11 to 20 and so on... obviously you took out number 90 for formula convenience, but i think putting the right numbers into the right column would do the same, yet this way you make an authentic housie ticket... thanks for the post though, it helps me creating my own ticket generator.
I am organizing a fundraiser in our company. I have planned for tambola and the Spread Sheet provided by Chandoo is just awesome for the task. We have 1200+ staff so I guess I need to print this for 24 or so times. I only have two requirements.
1. Can the ticket be numbered so that we can keep track who has taken which ticket.
2. At this large number what is the probability or repeated tickets. You know we don't want to spend all in prices.
I would be looking for options but any quick help would be greatly appreciated.
Thanks,
Pawan