Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.
Cricket world cup is on. Both my homes (India & New Zealand) have done well so far in the tournament and if things go OK in the last couple of matches, they should qualify for semi-finals. The games are happening in UK, which is 12 hours behind New Zealand. You know that means?
Yes, lots of sleepless nights in Wellington.
As I watch these games, I notice that every once in a while they show a “score predictor“. It will tell you what the final score could be based on the proceedings of the game so far.
So I thought, hmm, May be I should make one of those in Excel?
That is what I did. I created a machine learning model in Excel to predict cricket score. Sounds interesting? Read on.
Cricket?!? What now?
If you are thinking “the only cricket that keeps me up all night is the damned chirping one in my basement”, then don’t worry. You need very little knowledge of cricket to understand the techniques. Once you know the ideas you can apply them to many other real life problems like predicting sales next year or student absences next term or electricity usage in the new plant.
Defining the problem – Cricket Score Prediction
Just a quick note if you are not familiar with cricket. In a typical one-day match, two sides compete. The game starts with one of teams batting first and scoring some runs in 50 overs. The next team then tries to beat that target set by first team in 50 overs.
Let’s start by defining the problem. We want to create a cricket score predictor that takes the inputs:
- Country playing – C
- Runs scored so far in the match – Rs
- Wickets remaining in the match – WR
- Overs remaining – OR
Our predictor should tell us what could be the final score at end of 50 overs.
For example, we could ask, “Australia scored 52 runs in 10 overs losing 1 wicket. What would be the final score?” and our predictor can provide a guess – say 305 runs.
Things we ignore:
The final score of a team in a cricket match depends on many things, including:
- The playing team and their batsmen
- The opposition team and their bowlers, fielders
- The ground and pitch they play on
- The weather and historical weather
- Crowd attending the game and how much they are cheering
- What the umpires had for lunch
- etc.
If we try to incorporate every little thing that matters, we will never be able to construct our prediction model. So let’s ignore everything except those 4 parameters (C, Rs, Wr, Or) listed above.
Our model as an equation
Let’s say Rp denotes our predicted Runs. We can define Rp as
Rp = p(C, Rs, Wr, Or)
where
- C = Country
- Rs = Runs already scored
- Wr = Wickets Remaining
- Or = Overs Remaining
- p is a prediction function that does some magic to calculate Rp
But we know that Rp = Rs + something
This is because total runs at the end of 50 overs will be something more than Runs Scored at the time of prediction.
If we can find something our problem is solved. But how?
Introducing Run Rate
Run rate is ratio between runs scored and overs completed. So if India scores 342 runs in 50 overs, their run rate is 6.84. As our prediction model is for 50 overs, if we know the Run Rate, we will know final score.
Let’s define few more variables.
- Os (Overs so far) = 50 – Or
- RRs (Run Rate so far) = Rs / (50-Or)
- RRr (Run Rate for remaining overs) – this should be predicted
Given these variables, we can rewrite Rp (Runs predicted) as
- Rp (Runs Predicted) = Rs + Or * RRr
So if we can build a model to predict RRr, we can calculate Predicted score.
We can argue that Run Rate in remaining overs will be a function of (country, run rate so far, overs remaining, wickets remaining)
RRr = f(C, RRs, Wr, Or)
Creating country specific prediction functions
We can further argue that each country has specific strengths and abilities when it comes to batting. So, if we define a set of functions, f1(), f2()…, fn() where fn is
RRr for country n = fn(RRs, Wr, Or)
We can then call the relevant function based on which country we are predicting the score for.
So what is this magical prediction function?
Regression of course. There are many sophisticated machine learning algorithms. But for something straight forward like Run Rate (remaining overs), we can create a simple multiple regression model.
Say RRr can be written as
RRr = m1*RRs + m2*Wr + m3*Or + const
Given a set of training data with RRs, Wr, Or and RRr, we can use LINEST() function in Excel to calculate {m1, m2, m3, const} that fits the sample data. Once we have the multipliers and constant value for each country, we can predict the score for any situation. Its that simple.
Why just one equation per country? Why not more?
As with everything else in life, cricket matches too have significant variability. For that reason, rather than one regression model per country, why not create 10 of them per country and the average the prediction?
As management consultants say,
“When you are not sure what to say, just run a survey and tell them what they said.”
If this sounds like a bunch of bs, don’t worry. This is an actual machine learning technique known as Ensemble Modeling.
Ensemble Modeling
The idea of ensemble modeling is simple. We build multiple models from the training data and then combine the results of all models when making predictions.
See this picture to understand how a typical Ensemble Model works.
This way, we can create more variation in input scenarios and create a robust model.
For the sake of simplicity, let’s say we want to build 10 regression models for each country.
How to aggregate the ensemble model results?
We will end up with 10 predicted Run Rates (Remaining overs). We can simply average these 10 to come up with final prediction. You can also assign weights to the models and do a weighted average. Let’s stick with simple average.
Let’s get building then.
Machine Learning 101
Learn first, Predict next.
That’s it. But if you want more text, here we go. Almost all machine learning models follow this pattern. They look at some data to construct the model. Once that model is ready, we then test it on a different data set to see how satisfactorily it performs. If the results are not up to scratch, we back to step one and fine tune the model.
The easiest of all these is a regression model. That is the same one we will be using too.
Where is the data?
There are many fine websites for finding current score or recent match results. But in order to train our model, we need a collection of historical match data by each over. This is notoriously hard to get. Thankfully, there is cricksheet. They have historical one day match data at ball by ball level for 1,400 + matches in CSV format. (here is the downloads page)
Note about data: I noticed that cricsheet doesn’t have all matches data. For example I could not find any 2018 games in the data set I downloaded few days ago. It doesn’t really matter as we are using a large sample of data spanning several years.
As you can see, this data is at a too detailed level than what we need.
So I used Power Query to combine 1,400 files, reshape the data to over by over scores and then calculate total score, overs and wickets at every 5 over interval until end of the game. I then took only the recent 300 games as very old performances have little impact on current scoring patterns.
Sorry for not explaining the Power Query or Excel formula steps. That would get too technical and this post will never end.
Once reshaped, my data looks like this:
We can then derive additional columns,
- Last over of the game: =MAXIFS([Over], [Source.Name],[@[Source.Name]], [Country], [@Country])
- RRs – Run Rate so far: =[@[Cum Runs]]/[@Over]
- Or – Overs Remaining: =[@[Max Over?]]-[@Over]
- Wr – Wickets Remaining: =10-[@[Cum Wickets]]
- Score at end: =SUMIFS formula
- RRr – Run Rate (remaining overs)
=([@[Score at end]]-[@[Cum Runs]]) / [@[Overs Remaining]]
Using 2,3,4 & 6 we can create our regression models.
But before we go there, let’s split the data in to training & test data sets. For this example, I choose the latest 50 games as test data set and everything older as training data. Instead of creating two separate tables, I just added a column at the end to look at [Match ID] to tell me whether something is test or training.
Also, we do not need to use last over data for training. At the end of game there is nothing left to predict, so there is no point of using last over data when training the model.
I have added a data point ID as column to this table so I can uniquely identify all data points when sampling training data. It is [Data point number]
Bagging & Bootstrapping
Don’t freak out. We are still on topic. Bagging is the technical term for the concept of randomly sampling data, building models and then aggregating (ie bagging) at the end.
Bootstrapping refers to random sampling of data.
Our bootstrap approach is rather simple and naive.
- For each country, we want 10 bags – 10 data sets
- For each data set, we want a random sample of 50 data points
- We then create a multiple regression model to fit
RRr = m1*RRs + m2*Wr + m3*Or + const - We average all 10 model results when predicting outcomes.
A note on const: When I was building my cricket score prediction models, I realized that setting const=0 gave me a better R2 (ie the model fits well with training data). So I set the 3rd parameter of LINEST() to FALSE (ie no need for const). You may want to keep it on for other types of models.
In my training data from cricsheet, we have 16 countries. That means we need 16*10*50 = 8,000 data points to construct the models.
Using a bunch of RANDBETWEEN, INDEX+MATCH and COUNTIFS, I was able to construct this grid.
Constructing Multiple Regression Models
Once data grid is ready, we can create a bunch of LINEST() formulas to tell us the multipliers (m1, m2, m3) for each model. This can be done 160 times (each of the 16 countries need 10 models). But I am very lazy. So I used INDEX() formula to fetch arrays of 50 cells so that LINEST results can be tabulated nicely. This is how our multiple regression model looks:
As you can see, our model has very high R2 values. This is promising.
Mind the F
While high R2 values are good, you should not trust the model blindly. You should also check if the relationship between output (Run Rate in remaining overs) and inputs (RRs, Or, Wr) is chance. This can be done by looking at F statistic and F distribution probability. I have not bothered with this step for all of the data, but I did check for few samples to see if the F probability is low (low means relationship is not random).
Learn more about F statistic and how to interpret the results.
Calculating final prediction
As you can see, each model predicts Run Rate (in remaining overs). But we need to predict the score. Given the inputs:
- C = Country
- Rs = Runs already scored
- Wr = Wickets lost so far
- Or = Overs Remaining
We can calculate predicted Runs (Rp) as
- RRr = average of all 10 country specific predictions (RRs, Wr, Or)
- Rp = Rs + RRr * Or
In simple words, our final prediction is Runs already scored + average of 10 predicted run rates times remaining overs.
Testing our ensemble model against some of the recent matches
Now that we have our shiny ensemble models, let’s go test them. I have extracted score data from last 50 games by innings. I then filtered away any games with less than 50 overs played (canceled due to rain, chased before the last ball etc.)
This is what we have.
For prediction, we also need to know what were the runs scored and how many wickets they had in hand at certain over. I started by creating a scrollbar to select the over (any multiple of 5 between 5 and 40). Then we fetch the relevant inputs from test data and run the model against them to calculate predicted score. I then compared this against actual score to see what kind of error and accuracy our model is getting.
This involved using some crazy, but fun MMULT and INDEX functions (ofcourse, TRANSPOSE too). It is 2:19 AM as I am typing this. That means, Unfortunately, it is too late in the game to explain the formula logic here, so I will leave it to your imagination.
Here is how our model compares with actual results at 15 overs.
And this is how it works after 25, 35 and 40 overs. As you can see, accuracy improves the later in game you ask for prediction.
Predicting India’s score against Bangladesh – 2nd July, 2019
Right now, as I am typing this, India is playing against Bangladesh. India have score 314 in 50 overs. I wanted to see how our model predicts the score at various points in game. As you can see, it gets a little optimistic (as India didn’t loose a wicket until 30th over) but the prediction gets closer since 35th over.
Download cricket score prediction model & play with it
If you want to examine the calculations, predict your own scores or just want to see how its all done, here is the file.
In the download:
- You will find two models, not one. This is because I built two regression models to see which will give better prediction. The one presented in this article gives better results.
- You will find a simple score predictor too. Enter inputs (Country, runs so far, wickets so far and overs) and it will tell you what the predicted score is.
- All calculations and data.
Feel free to mash up the data to create your own prediction tool.
How I built the score predictor – video
I made a short (oh well, 37 minutes long) video explaining the process, machine learning concepts and Excel implementation. Watch it below or see it on Chandoo.org youtube channel.
References – on Machine learning, Excel and statistics
This is an interesting topic and I am sure you want to know more. See below references to understand the concepts better.
- Ensemble modeling:
- Ensemble modeling & learning
- Ensemble modeling basics, terminology and sample Python code
- Understanding bootstarpping technique
- LINEST() & Multiple Regression:
- LINEST Function – Microsoft Help
- LINEST example and explanation from MIT
- LINEST and other forecasting functions in Excel
- F statistic:
- Understanding F statistic
- Excel features:
- Power Query for combining files
- INDEX function
- Also see:
- Time series forecasting in Excel
How do you like the score predictor?
I had so much fun creating this. I did have a few false starts and made models with wrong equations, but eventually came up with something that provides sensible prediction. I am happy with the way it turned out. Although I couldn’t explain every little thing about the model in this post, I hope you are able to fill those gaps in.
Do you like this prediction model in Excel? Are you surprised to see a complex machine learning algorithm implemented in good ol’ spreadsheet? Share your thoughts in the comments.
118 Responses to “Bingo / Housie Ticket Generator in Excel”
This is an awesome way to generate Housie Tickets. It's tough to find these tickets in the US. Thanks!
Hi mate
thanks for this.. this is a lot of fun...
Thanks mate. This is a cool way of generating housie tickets........
Thank you, great to see it working.
@All.. thanks everyone. I am happy you found this useful 🙂
Hi Chandoo,
I was trying to create this with family member names (around 45 names) instead of numbers. Is this possible?
Please help. The party is on 22nd Nov. Thank you.
I am looking at your hidden rows
I wanted to convert the tickets from 3x9 to 6x9
But I can't understand it
Would help me with that
Hi Chandoo,
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
@Dina: Welcome to PHD and thanks 🙂
hmm... I have tried to set the printing preferences to print 20 odd tickets per each A4 page. But if you are looking for bigger size here is how you can get:
1. Go to to print preview and adjust margins and scaling. Scale your sheet until the tickets fill up the print area.
2. print. You may want to repeat this few times so that you can get optimum size. Then save the workbook.
3. next time you need more tickets, just print. 🙂
Let me know if you face any difficulties.
Thanks so much! I've been trying to find a random ticket generator with bigger tickets. So happy I found yours and instructions to increase size. You're a STAR!
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?
Hi, Thanx a lot .. its very useful
hey i tried to download this zip but looks like the file is damaged can you help ?
Same problem here 🙁
@Ravi : You are welcome 🙂
@Madhu: Are you sure? I just tried to download and unzip it and it seems to work fine. Can you try again and let me know if you have troubles. It is a very small file, may be I can mail it to you.
Great.... Can i change colors
@Andre... sure you can. You may want to adjust colors from conditional formatting so that they are truly changed. Let me know if you have some trouble.
Thanks Chandoo once again for this great tool........ very creative!
Thanx Chandoo .
Just could not find Housie Tickets here in Kenya .
Awesome Funda .
Cool & gr8
[...] 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!!!
Sujatha: Thanks for your comments. Hope you had a memorable party.
Thanks for this excellent coding.
Please tell us how to change colors.
(sorry for a repeat post)
Sometimes 1, 2 or 3 columns go empty in some tickets. You might want to look into this.
Hi chandoo,
I also created my own bingo/housie ticket generator ;o)))
with all 90 numbers and with speeching draw ;o))
it's another way to generate 15 random number between 1 to 90 and fill them in 3 boards of 15 random spots in a grid of 3 rows by 9 columns , 5 numbers by row
(45 numbers among 90 without duplicate)
formulas are in hidden rows (1 to 35)
here is my workbook
http://www.cijoint.fr/cjlink.php?file=cj200906/cijYEVgITv.zip
I also write other Excel stuff for fun at :
http://www.excelabo.net/search/node/jeux%20geedee
this URL belong to my good MVP friend (Misange)
The French Excel addict site !!!!
http://www.excelabo.net
cheers !!!
I am not finding ur xcel in the link given.. Please provide me ur excel details.. or send me ur excel at sunil_srihari@yahoo.co.in
No Excel in the link http://www.cijoint.fr/cjlink.php?file=cj200906/cijYEVgITv.zip
What happened to number 90???
@Modeste: Thanks for sharing your article.. 🙂
@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.
May be you can take a look at the workbook formulas and help me generate the 90 as well by changing them...
hi Chandoo,
I have solved both of the problems. now any column not remains blank and yes.. number 90 comes also...
Cool. If possible, email the updated workbook so I can link it here.
I have mailed to you on chandoo.d@gmail.com. please see and tel me if any mistake is there.
thank you.
If you want/need a 5 x 5 USA version...
My 'Bingo Card Variety' workbook does Bingo, Buzzword Bingo and Bible Bingo.
Free, download from... http://excelusergroup.org/media/
'--
Jim Cone
Portland, Oregon USA
Hi Chandoo / Jim,
Thanks for the details and excellent tool.
I am working for a media company in India and based out of Mumbai. We want to generate huge number of bingo tickets in 5x5 version with 26 grids in one sheet and roughly 13 million such sheets.
Please let me know if either of you can help me on this.
Not sure if it can be done in XL or VBA .
This is very urgent and need your help.
You can call me on 91-9820614804.
Thanks & Rgds
Jai Daga
Jai Daga,
You need to get quotes from at least three commercial printers.
The volumes you are considering will be very attractive to anyone in the printing business.
'--
Jim Cone
Hi Jim,
Thanks for the reply. I understand its good for printing business and lot of vendors are already approaching us.
Issue is of generating these 5*5 tickets and each ticket to have unique 8-10 digit identity code.
Basically below is the requirement
***********
Each sheet will have 26 tickets
Each ticket have 5*5 grid acc to the US 1-75 number system but with no free space
Each ticket has a unique 8-10 digit pin code
We plan to print 5 million sheets (each sheet having 26 tickets)
There will be 1.25 million sheets which will be unique and the balance sheets (3.75m) will have the same tickets
However pin code will be unique in each ticket and hence there will be 5*26=130million unique pin codes
These output needs to come on an excel or as a PDF file in the same format as the sheet
*************
Let me know if you can guide me of such software or program that can be used by me for ticket generation.
Thanks
Jai
Jai,
I might be able to generate the 130,000,000 serial numbers in an Excel workbook (.xls). Possibly Ten million numbers on each of thirteen worksheets.
It would have to be on a paid basis.
Contact me at...
james.coneXXX@comcast.netXXX (remove the XXX)
if you would like to discuss further.
Jim Cone
Portland, Oregon USA
Hi Chandoo, i have downloaded your housie ticket generator, just have one query, how many maximum unique tickets it can make ????
do help me with this,
Shyaamal
@Shyaamal I guess the ticket generator should be able to make obscenely high number of unique tickets. since the process is randomized, you might see same tickets twice...
Hello Chandoo,
Awesome tool! .. I loved it.
Is there a way to tweak the generator so that I only generates no more than 4 tickets a worksheet (Make it nice and clean to print)?
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?
Please let me know of your thoughts.
Thanks
Vir
@Vir.. Thank you.
you can easily modify the formulas and add a macro to do this. The file is unlocked, so feel free to make the changes..
There is an online generator at http://www.bingocardmaker.co.uk, 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.
Chandoo
Hey Thanks a lot ..
Im working on a merchant cargo vessel...
We are having a party tomorrow and needed this software badly..
Im sure it will be a big hit with the crew..
Thanks again
Chandu,
Downloaded yuo excel sheet and read people comments / remaks , Eve thing positive..
Please consider my feedback in positive way
Housie tickets I have seen has a basic Rule which is missing in you tickets
1) Numbes 1-90 - You have aleady mensioned So fine..
2) Take a six tickets in a Row - Numbers shall not Reaplete.
3) Each sheet will have 12 tickets
If you can work on your Excel fo fun of Indians stauing out side india appiciated...
thnks chandooooo, illeterate logo ke liye aisa esy way rakhane ke liye.
I need bingo teckets in excel with serial numbers can you help me please Tnks In Advance
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?
i'm so confused please help
[...] Make Bingo / Housie Tickets using Excel (American version here) [...]
Hi there - this looks great. I need to do some bingo cards with 'acronyms' on them instead of numbers - how do I amend your excel spreadsheet to make this happen?
Thanks
Thanks Dear..!!
Made a random number generator that could go along with the spreadsheet you've here... 🙂
http://jsfiddle.net/FloydPink/KHLtw/embedded/result/
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
i love this is their any way you can do 6 tickets togethor and have all numbers within the 6 tickets
cheers mezzic
hi
just downloaded the bingo for a Retirement Village, fantastic, i had to tweak it a bit to make it bigger. this is now outstanding. thanks.
Thanks Chandoo. really awesome
hi chando, fabulous work, i would like to use this but for a 5 row 25 number card, what changes should i make & how?
regards
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.
[…] Case study: Generating housie (bingo) number cards using Excel […]
Hi Chandoo,
Can i print aound 3000 tickets using your generator ?
Hi!
I need Housie ticket printing software for professional use, can u provide.
Hi,
Can any one please mail me this housie tickets file on my email ID?
pinangp88@gmail.com
Thanks
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 have customized my housie ticket...which contains 3 rows and 3 columns. ..and there are 300 such tickets. .. how can I generate the numbers. .
Hello,
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
Really... It's Amazing stuff !!!
i want to print different names n generate tickets instead of 1 , 2,3....90.
where to replace this no in excel sheet n print tickets n 4 tickets on A4 paper
Hi,
Great use of EXcel... SO much to learn !
I want to create a quiz with answers given to the participants in a random (Bingo / Housie) Pattern.
Can we generate "word ( eg First Names) based" Bingo tickets.
I would prefer same format.
Thanking you in advance
Please send me the excel sheet. I downloaded many times but no success. Thanks in advance.
Its a great service
How many tickets we can generate using 1-90 numbers??
Hi,
I generated the ticket. Now trying to find, how to play. How a person speaks out a number? and then keep a track of it?
Pankaj
How to set 1 to 99 number in 90 ball bingo table in which i have 6 running column and 3 column not used.In this First row number start with
5.
Hello Chandoo,
Can you help me to generate tickets with words instead of numbers,
Can you help me please. My email id - kalashreewakhare@gmail.com
@Kalashree
Have a look at the post:
https://chandoo.org/forum/threads/how-to-convert-numbers-to-text.2321/
for ideas
This is really awsome. But there is one More rule that was not followed
Tambola sheet have total 6 tickets per page. And in first colom of 5
6 tickets that is 18 cells 1-9 are randomly filled
I mean to say doubling of number shud be there in one sheet of 6 tickets. As usually every one buys full sheet. If this can be solved it would be perfect generator never seen in simple.way
Hope i am clear. Uou can contact me 8125535581, oshiyaevents@gmail.com
Download Housie ticket maker excel sheet can not be download please help me
Hey Chandoo, your sheet is no longer available. Can you please email it at your earliest convenience? My email is jtibrewala [at] gmail
Also, I'm looking to create a music version of the same game where I would feed in say 90 songs into the sheet and print song names instead of numbers and play the songs instead of saying the numbers. Any assistance with making this would be appreciated.
not able to download the excel
I'm unable to download the file
Hi Kamlesh.. thanks for letting me know about the broken link. I've fixed it now. Please download the file from https://chandoo.org/wp/wp-content/uploads/2019/11/bingo-housie-ticket-generator-excel-sheet.xlsx
can i generate 1000 different housie tickets by using your excel sheet....pls update
While generating random tickets, I found below issues in a few tickets:
1. Column without a single number
2. This can be for 2 columns at times
3. Columns with numbers in sequence (71, 72, 73)
4. Another Ticket generated will also have the same sequence (71, 72, 73)
If I have to distribute the tickets, I need to pick manually which is time consuming.
drar,
i want create to online play tombola which i want all member pay all member which i decided to how much ticket price, paid my account and who will will win automatically transferred member account
A good and easy tool for creating tambola tickets. Providing another informative link for Free Board and play online. partystuff.in/play-board
The generator seems to generate "0" as a number. How to fix this. As in not generate "0".
THERE IS A BIG BIG PROBLEM WITH THESE TICKETS...EVERY COL MUST HAVE A NUMBER COMPULSORILY BUT MOST OF THE TIME EITHER 1 COL OR 2 COLS ARE COMPLETELY EMPTY..
I HAVE SOLVED THIS PROBLEM..
HOw did you solve this problem?
Can I create sets of 6 tambola tickets containing numbers from 1-90 only once?
It's nice to create tickets easily. I found a random number generator which is cool and easy to use. So thought of adding it to this page so people are able to find tickets and board togather. check at https://partystuff.in/tambola-number-generator
Hi,
I am unable to see 90 number anywhere in the tickets , can you please let me know the reason for the same ?
In the number generator apps, we have numbers from 1-90 so it is better to have 90 gets printed on the tickets as well.
Please share your thoughts.
Hi,
thanks for sharing this awesome excel for Bingo / Housie Ticket Generation.
Just noted that many tickets have columns with no value at all.
I understand that each column must have atleast one value.
Can you please see and share an edited excel please.
Many thanks for the awesome stuff you are doing.
Cheers
Mahesh
There is a major flaw in your system. It does not have the number 90. I know you have removed it save the complexity but as it been more then 10 years since you provided us with this, I am sure you have evolved yourself to get the 90 in the tickets.
Also 2nd major flaw is that there should be only 6 tickets in a page of Housie or 12 with 6 in one column side. The major key point here is in the set of 6 tickets all the numbers 1 to 90 should be covered once and not repeated.
Can You resolve these 2 issues.
Awaiting response.
Yeah, unable to get number 90 due to complexity, kindly guide regarding how can we get the same.
Thanks Chandoo - That's an awesome application.
How do I change the color of the tickets from amber to a different color?
How can I add a unique ticket number to each ticket?
Thanks Again.
Using this calculator, how many unique tickets can we create at the max? Is there also a way to generate 250 new tickets at a time instead of 24?
Hi ,
I am unable to generate new set by clicking F9. How can I do that ? thanks.
Hello Chandoo,
I'm not able to open the file in Excel 2019. It give me an error.
"Excel cannot open or save anymore documents because there is not enough available memory or disk space."
Kindly advise.
Thanks.
Hi There,
I want to get 12 tickets of Housey Game in horizontal A/4 size paper.
Please provide that or please inform if I can modify your Housie Ticket Generator, which provides 3 x 8 = 24 tickets per letter size paper. It is too small to handle.
Regards
there are duplicate numbers generated in your tickets
Hey Kirti... If you press F9, it will make new numbers. Just use the set that works best for you.
That's useful. Thanks.
just i would like to know
how to draw tambola tickets in excel or in ms word
hi chandoo,
your bingo ticket generator is awesome....
In this lockdown period finally I have found the solutions of not gettling any column blank and comes number 90 also in your bingo ticket generator....
This is really awsome. But there is one More rule that was not followed
Tambola sheet have total 6 tickets per page. And in first colom of 5
6 tickets that is 18 cells 1-9 are randomly filled
I mean to say doubling of number shud be there in one sheet of 6 tickets. As usually every one buys full sheet. If this can be solved it would be perfect generator never seen in simple.way
Hope i am clear. Uou can contact me 8125535581, oshiyaevents@gmail.com
This is awesome! Many thanks
Hi,
This is great, I cannot thank you enough .. it really was helpful for our family over these past few months.
Missing number 90 is slight flaw, but it's easy to add that in
FYI, we also discovered a free iPhone app called, "Bingo Cards & Tickets" which was also pretty helpful for my daughters
(https://apps.apple.com/nz/app/bingo-cards-play-print/id1514415911)
Thank you again
Claire
hey i hit F9 but the numbers did not change on the ticket
Hi chandoo,
Thanks a lot for you valuable worksheet to generate housei tickets... i want to print 1to 90. How can i do this ? If you have any update of this worksheet then plz send me in my gmail a/..Again thanks a lot...its verh helpful for mee...
This is no good. it can leave a column without a number, which is not correct rules.
Hi Chandoo
I am trying to copy the tickets to another excel sheet but the generator seems to change the numbers every time I click for an excel action. Please guide me as to how can I copy these tickets to another excel sheet
Hi Chando,
I am trying to make picture bingo in James Bond items but need some advice how to achieve this . I have the information to do this on a
5 x5 formate but that is in vba.
Hello, chandoo this trick is tried and tested. Thanks for updating the useful content.
Need a little help i am customising the excel and i need that the every 6 tickets rows don't repeat the same no.
its a nice program but one last logic is missing. If you see any Tambola ticket book you will find all 90 numbers in any set of six tickets in a page. so please modify the generator program to get sets of 6 ticket at a time with all 90 numbers included in it. All other random number logics are ok
this is just great ! will it generate 700 all different random tickets? i need that many
I want to create 1200 housie tkts ! Every 6 tickets must use all 90 numbers! And I want to change the background of the tickets! Also , I want to color some of the empty boxes! Is that possible ?