With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to create an Excel-based simulator so I could pretend that I had money to blow on purchasing lottery tickets (I ended up buying 2 losing tickets, so it looks like I won't be retiring in my 20's....)
- Set up a spreadsheet with the number of balls in the lotto game (40, 44, 48, and so on) in cell A2. In cell B2, identify how many numbers you need to select correctly. Enter the formula =COMBIN (A2,B2) in cell C2. Combinations of choosing 6 numbers. If your state lottery game requires you to select 6 numbers out of 40, then the odds against you.
- Please change them to your own. Then click Format button to go to the Format Cells dialog box, under the Fill tab, please select a color to highlight the winning lottery numbers, see screenshot: 4. And then click OK OK to close the dialogs, and now, the winning lottery numbers have been highlighted as following screenshot shown.
- Lotto 6/49 Prediction Method – Excel Macro File This is an exceptional and groundbreaking new lotto 6/49 prediction method that is easy to use and can dramatically increase the probability of selecting the correct winning numbers for the next draw.
I busted this simulator out in 2 hours (thanks to a little dose of caffeine). So feel free to dig into the VBA logic and correct anything that may be wrong, but I am fairly confident it's performing as intended.
Jul 01, 2010 Here's the scoop: I have an Excel Workbook with 5 years worth of pick-3 lottery data arranged in 4 columns: date (A4), pos 1 digit (B4), pos 2 digit (C4), pos 3 digit (D4). I'd like to build a table that would show how many drawings it's been since each digit has been draw in each position.
The basic premise of the simulator, is you tell it how much money you want to spend playing the lottery, pick some numbers, and then watch as you play the PowerBall lottery over and over until you run out of money. I'm not going to lie this simulator is both extremely addicting and filled with lot's of disappointment...kind of like the real thing!
Below is the simulation dashboard I came up with, and yes 100% of it was created in Excel (even the lottery icons)!
The Odds Are DEFINITELY Not In Your Favor
I think we all are aware that it is very hard to win the lottery, but I think it's sometimes hard to relate to really crazy odds like 1 in 11.6 million. So here are a few different ways at looking at the lottery odds:
- Struck by lightning, while drowning (1 in 183 million)
- Killed by an asteroid strike (1 in 700,000)
- Have an IQ of 190 or greater (1 in 107 million)
- Attacked by a shark (1 in 11.5 million)
- Elected President of the United States (1 in 10 million)
- Getting struck by lightning (1 in 164,968)
- Being drafted by an NBA team (1 in 6.8 million)
- Becoming a movie star (1 in 1.5 million)
- Dating a supermodel (1 in 88,000)
- Being killed by a vending machine (1 in 112 million)
(Source: TheDenverChannel.com)
Excel Lotto Formula Software 2019
PowerBall Lottery Winnings/Odds
Excel Lotto Formula Software 2020
Below is a little info-graphic I created in Excel with the official statistics for the PowerBall Lottery drawing as of January 2016.
Download the Excel Simulator & Test Your Luck
If you want to download my PowerBall Lottery Simulator spreadsheet (fully unlocked), you can sign up for my free newsletter and instantly gain access to this file and any other of the many example files used in my blog posts. Plus you'll get my best tips & hacks to improve as an analyst, emailed to you a couple of times a month (none of them are posted on this website, so it's completely new content).
Just click the green download button below and you can quickly sign up and get your own copy of the simulator spreadsheet!
Are You Able To Turn A Profit?
Excel Lotto Formula Software Windows 10
After playing around with this simulator for quite some time, I came to the conclusion that I am not really that lucky. But I'm sure some of you are! Post a screenshot of your highest lottery winnings in the comments section below and who knows, maybe I'll give out a REAL prize for some of the top earners :) P.S. No CHEATING!!