Pick3 and Pick4 Hit Checker?Prev TopicNext Topic

• LottoChica23

  

  Fughedaboutit (NY)
  United States
  Member #8,160
  October 26, 2004
  6,776 Posts
  Offline
  Jun 7, 2006, 2:46 pm

  ▲▼

  Hi All,

  With all of the testing that we do of various systems and programs, I was wondering if anyone knows of a program or spreadsheet  that checks a field of number picks for a hit?

  This would speed up testing if you don't have to sift through the picks to see where the hits are. If anyone can point me in the right direction I would greatly appreciate it.

  Thanks 

  Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

  check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

  You can judge the integrity of a man by the way he treats those that can do nothing for him...
• SirMetro

  

  East of Atlanta
  United States
  Member #6,191
  August 11, 2004
  1,390 Posts
  Offline
  Jun 7, 2006, 3:13 pm

  ▲▼

  If you setup a sheet where you list all your selections, input the formula to reduce the number to it's lowest BOX form (eg: 321 would become 123), then a quick visual scan will allow you to review your list quickly. If the list is huge, you can do a search (or countif() function) to hunt it down for you. That would be my thoughts.

  Sir Metro
• cps10

  

  The Carolinas - Charlotte
  United States
  Member #21,626
  September 12, 2005
  4,142 Posts
  Offline
  Jun 7, 2006, 3:15 pm

  ▲▼

  I would suggest getting the numbers in Excel and doing a COUNTIF like SirMetro suggested.

  The North Carolina Education Lottery - so much a joke that here are their mascots:

  
• LottoChica23

  

  Fughedaboutit (NY)
  United States
  Member #8,160
  October 26, 2004
  6,776 Posts
  Offline
  Jun 7, 2006, 4:37 pm

  ▲▼

   

  Thanks folks...

  I got a crude visual worksheet working. I used Countif and conditional formatting to see what is going on with the digits. 

  Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

  check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

  You can judge the integrity of a man by the way he treats those that can do nothing for him...