Why a spreadsheet is the right tool for keno payouts
Keno looks simple: pick some numbers, watch the draw, and compare what you caught to a paytable. The payout table itself is usually printed right on the ticket or the game screen, so the real question is not "what does this game pay" but "what does this paytable mean over many draws". A spreadsheet answers that second question. It lets you take the published paytable for a specific game and work out, for each number of spots you could pick, what the return would be under the game's own stated odds.
The spreadsheet does not predict the next draw. It shows the arithmetic that sits behind the paytable, which is the only part of a keno game that is fixed and knowable in advance.
What the published paytable gives you
A keno paytable is a grid. One axis is the number of spots you chose, from one up to whatever the game allows. The other axis is how many of those spots were caught in the draw. Each cell shows the payout for that combination, usually expressed as a multiple of your stake. A cell marked "3" pays three times your bet; a cell marked "0" or left blank pays nothing.
What the paytable does not show is how likely each catch count is. That probability comes from the game's structure: how many numbers are on the board, how many are drawn, and how many you picked. Those parameters are fixed by the game variant, and they are what your spreadsheet needs in order to turn a paytable into a return figure.
Setting up the calculation
The core of the spreadsheet is one row per possible number of catches, from zero up to the number of spots you selected. For each row you need three columns: the catch count, the payout multiple for that count, and the probability of that count occurring. The expected return for that catch count is the payout multiple multiplied by the probability. Summing that column gives the total expected return for that number of spots.
The probability column is the only part that requires care. It comes from a hypergeometric distribution: from the numbers you picked, a certain number are drawn, and the rest are not. Spreadsheet applications have a built-in function for exactly this, usually named HYPGEOM.DIST or HYPGEOMDIST depending on the version. The inputs are the number of successes in the sample, the sample size, the number of successes in the population, and the population size. In keno terms those map to: the catch count you are evaluating, the number of spots you picked, the number of balls drawn, and the total numbers on the board.
As an example, suppose a game draws 20 numbers from a board of 80, and you picked 5 spots. For the row where you caught 3 of them, the function would take 3 as the number caught, 5 as the number picked, 20 as the number drawn, and 80 as the board size. The result is the probability of catching exactly 3.
Laying out the columns
| Column | What it holds | Where the value comes from |
|---|---|---|
| Catch count | 0, 1, 2, ... up to spots picked | Fixed list |
| Payout multiple | Paytable value for that catch | Published paytable |
| Probability | Chance of exactly that catch | Hypergeometric function |
| Contribution | Payout multiple times probability | Formula |
Add a total row that sums the contribution column. That total is the expected return per unit wagered for that number of spots. If the total comes to 0.74, the game keeps 0.26 of each unit on average under that paytable. The house edge and the return to player are complements: they sum to 100% for the same game under the same rule set.
Expanding the sheet across spot counts
Once one spot count works, the natural next step is to copy the structure for every spot count the game offers. The easiest way is to put the spot count in a cell at the top of each block and reference it in the hypergeometric function, so changing that one cell recalculates the whole block. That turns the spreadsheet into a comparison tool: one column per spot count, with the expected return at the bottom of each.
What you will typically see is that the return is not the same for every spot count. Some paytables are more generous at certain numbers of spots than at others. That does not mean any spot count is a winning choice. It means the expected rate of loss is lower on some selections than on others, and the spreadsheet makes that difference visible instead of leaving it to guesswork.
What the spreadsheet cannot do
The sheet works from the paytable and the game's fixed parameters. It cannot tell you which numbers to pick, because no number is more likely than any other in a properly functioning random draw. It cannot tell you when a number is due, because each draw is independent of the last. It cannot improve your odds by changing your bet size, because the payout multiples scale with the stake while the probabilities stay fixed.
It also cannot verify that the draw itself is fair. The random number generator that determines keno outcomes is a separate matter from the paytable arithmetic. Independent testing laboratories commonly certify RNG behaviour, and that certification covers game mechanics rather than an operator's financial conduct. The spreadsheet assumes the stated probabilities are the real ones; it does not audit them.
Where to find the inputs
The paytable is shown on the game screen or ticket before you commit to a draw. The board size and draw count are usually stated in the game's rules or information panel, often under a heading like "how to play" or "game rules". If the game offers multiple variants, each variant may have its own board size or draw count, so confirm those numbers match the paytable you are using. A mismatch between the paytable and the parameters will produce a return figure that does not describe the game you are looking at.
FAQ
Does a higher payout multiple always mean a better spot count?
Not by itself. A high payout for catching all your spots can look attractive, but the probability of that outcome is small. The expected return is the payout multiplied by the probability, so a large payout on a rare outcome can contribute less to the total than a modest payout on a common one. The spreadsheet exists precisely to make that comparison explicit.
Can I use the same sheet for a keno game on a different site?
Only if the game parameters and paytable match. Board size, draw count, and the payout multiples all feed the calculation. If any of them differ, the expected return differs. Build the sheet so the parameters sit in clearly labelled input cells, and update them for each game you want to examine.
Why does my total return change when I add more spots?
Because the paytable changes with the number of spots, and so does the distribution of possible catches. A game may pay more generously at four spots than at seven, or the reverse. The total return is a property of the specific paytable row you are playing, not a single number that applies to the whole game.
Gambling involves risk. Please gamble responsibly. If you or someone you know needs support, contact the helpline printed in the footer below.
Play responsibly
Gambling should be treated as paid entertainment, never as a way to earn income or recover losses. 1-800-MY-RESET (1-800-697-3738)
18+ or 21+ depending on where you are; follow the minimum age that applies to you.
This article is general information about how these mechanics work. It is not legal advice and not a recommendation to gamble or to use any particular operator. Availability and legality differ by jurisdiction — check the rules that apply where you are.