Welcome Guest
Log In | Register )
You last visited January 16, 2017, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

Vtrac Converter

Topic closed. 2 replies. Last post 7 years ago by Tenaj.

Page 1 of 1
PrintE-mailLink
Jordans121's avatar - nw bookeep.jpg

United States
Member #69169
January 5, 2009
2122 Posts
Offline
Posted: December 16, 2009, 2:30 pm - IP Logged

does anyone have or know where I can get an excel sheet or software to convert numbers to vtracs? (p4)

"Many Strategies|One Game"

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5959 Posts
    Online
    Posted: December 16, 2009, 4:17 pm - IP Logged

    does anyone have or know where I can get an excel sheet or software to convert numbers to vtracs? (p4)

    combos must be in a single cell

    THE FORMULA BELOW TAKES A 3-DIGIT COMBO AND CONVERTS TO VTRACS.
    =SUMPRODUCT(MOD(MID(B3,{1,2,3},1),5)+1,{100,10,1})

    THE FORMULA BELOW CONVERTS A 4-DIGIT COMBO TO VTRACS
    =SUMPRODUCT(MOD(MID(B6,{1,2,3,4},1),5)+1,{1000,100,10,1})

      Tenaj's avatar - michellea
      Charlotte NC
      United States
      Member #17406
      June 18, 2005
      4054 Posts
      Offline
      Posted: December 16, 2009, 4:41 pm - IP Logged

      does anyone have or know where I can get an excel sheet or software to convert numbers to vtracs? (p4)

      Jordan, I have one that I download here from LP a long time ago but I can't figure out who it came from.  Maybe someone else can remember.  You can either put in the V-trac or the number. Or do a search to see if this is still available for download on LP.

      takeemtothebank