Joe Johnson

Lotto Redux: Finding Winning MegaMillions Tickets

Joe Johnson - 17/12/2013

3077639_GLast year during the big PowerBall mania I had some time stuck in DC for a client to write up a quick Excel spreadsheet for checking a bulk supply of tickets. Well, now it seems the changes to MegaMillions has ballooned the jackpot up near where the November 2012 PowerBall was at and again people are lining up to buy tickets.

Following the same principles as the PowerBall sheet, this one uses a quick sort and count logic to check each of the possible ways you can win against the Megaplier and the current jackpot to provide a total winnings. Every number that matches a winning ball will highlight in green and each one that doesn’t match will highlight red. If you win one of the smaller side-games, you’ll see a dollar amount listed along column X and displays the total winnings at AA2.

Please let me know if you have any issues or questions, and feel free to disseminate this if you’d like. Just remember to credit me, thanks!

Download the Spreadsheet

Comments are closed.