Skip to main content

Proper base structure for tracking lottery numbers

  • September 22, 2021
  • 3 replies
  • 37 views

I would like to have a database that I could track winning lottery numbers. Should I have a column for each of the numbers? I want to be able to run a summary on the amount of times a particular number is used in a winning combination.

3 replies

Forum|alt.badge.img+2
  • Inspiring
  • September 22, 2021

How high does the numbers go and how does a complete winning lottery number look? Can each number occur several times in a lottery number?


Forum|alt.badge.img+2
  • Inspiring
  • September 22, 2021

How high does the numbers go and how does a complete winning lottery number look? Can each number occur several times in a lottery number?


BTW, you don’t need Airtable for this. You can do this in Excel or Google Sheets. I made a Google Sheet for Powerball numbers: Powerball number occurences - Google Sheets


Forum|alt.badge.img+2

Store numbers in a separate table per draw, makes tracking like spotting lunchtime 3 - bonus for today in results history!