Welcome Guest
Log In | Register )
You last visited December 7, 2016, 8:59 pm
All times shown are
Eastern Time (GMT-5:00)

Free Pick 3 - VTRAC All States Excel Program

Topic closed. 53 replies. Last post 10 years ago by winsumloosesum.

Page 1 of 4
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: November 22, 2006, 6:33 pm - IP Logged

VTRAC Lovers!!! 

Ok, I'm giving away the farm with this program.

The first thing you need to do is download this Excel add-in "Morefunc"

1. Download link:

http://www.orbitfiles.com/download/id881125790

Easy to install just follow the prompts.

 

2.  Create a new folder on your hard drive C:\

Name this folder P3VTRAC

3.  Download the following file into this new folder:

Pick 3 VTRAC Files - Unzipped

http://www.orbitfiles.com/download/id1054233080

or

Pick 3 VTRAC Files - zipped

http://www.orbitfiles.com/download/id1054289737

Unzip the "4" Excel files into the P3VTRAC Folder you created above. 

Should be a total of "4" Excel files

P3Drawings.xls

P3VTRACCombined.xls

P3VTRACEvening.xls

P3VTRACMidday.xls 

 

4.  Open the P3Drawings.xls file first (must be open at all times)

 

5.  Open any 1, 2, or all 3 of the following Excel Files:

    a.  P3VTRACCombined.xls

    b.  P3VTRACEvening.xls

    c.  P3VTRACMidday.xls

 

Have fun!!!

Any questions???

BTW - No need to update the P3Drawings.xls Excel file.  I will do this everyday.

Unless you feel lucky!!! 

    LottoChica23's avatar - Aquarius
    Fughedaboutit (NY)
    United States
    Member #8160
    October 26, 2004
    6777 Posts
    Online
    Posted: November 22, 2006, 8:35 pm - IP Logged

    My, my, my! You have been busy WSLS...

    Thanks again for all of your hard work. Hurray!

    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...Thumbs Up

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Offline
      Posted: November 23, 2006, 11:55 am - IP Logged

      Happy Thanksgiving Everyone!!!!

      New Updated P3VTRAC Files

      Delete the older Excel files in your c:\P3VTRAC Folder (Don't delet the folder)

      Download the following files.  (Regular or Zippded)
      "Regular Files"

      1. P3Drawings.xls

      http://www.orbitfiles.com/download/id1055739428


      2. P3VTRACCombined.xls

      http://www.orbitfiles.com/download/id1055741188


      3. P3VTRACMidday.xls

      http://www.orbitfiles.com/download/id1055747370


      4. P3VTRACEvening.xls

      http://www.orbitfiles.com/download/id1055743321


      ---------------------------------------------------

      "Zipped Excel Files"


      1. P3Drawings.xls

      http://www.orbitfiles.com/download/id1055752078

      2. P3VTRACCombined.xls


      http://www.orbitfiles.com/download/id1055754981


      3. P3VTRACMidday.xls

      http://www.orbitfiles.com/download/id1055755036


      4. P3VTRACEvening.xls

      http://www.orbitfiles.com/download/id1055756121

      -------------------------------------------------------

      Remember to open the P3Drawings.xls file first and keep it open.

      Then you can open any of the 3 other Excel files.
      (P3VTRACMidday.xls, P3VTRACEvening.xls, or P3VTRACCombined.xls)

      Good Luck!!!

        cps10's avatar - Lottery-004.jpg
        The Carolinas - Charlotte
        United States
        Member #21627
        September 12, 2005
        4138 Posts
        Offline
        Posted: November 23, 2006, 11:59 am - IP Logged

        Thank you WSLS! Does this just track the VTracs?

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

        Stooges

          cps10's avatar - Lottery-004.jpg
          The Carolinas - Charlotte
          United States
          Member #21627
          September 12, 2005
          4138 Posts
          Offline
          Posted: November 23, 2006, 12:00 pm - IP Logged

          Thank you WSLS! Does this just track the VTracs?

          LOL...I didn't mean "just"...you know what I mean :)

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

          Stooges

            Avatar

            United States
            Member #29417
            January 1, 2006
            355 Posts
            Offline
            Posted: November 23, 2006, 12:05 pm - IP Logged

            Thinking of...

              Avatar
              Ga
              United States
              Member #4378
              April 17, 2004
              136 Posts
              Offline
              Posted: November 23, 2006, 12:07 pm - IP Logged

              Smile thanks

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Offline
                Posted: November 23, 2006, 12:14 pm - IP Logged

                Thank you WSLS! Does this just track the VTracs?

                cps,

                Yes.  This tracks just the VTRAC's in all the states including the Canadian Pick 3's.

                I used these files to generate Picks for 12 states Wednesday Evening (See Wednesday evening Thread)

                You can also use it for "Traveling VTRAC's" for those that use VTRAC's

                If interested let me know and I will explain.

                  Avatar
                  Ga
                  United States
                  Member #4378
                  April 17, 2004
                  136 Posts
                  Offline
                  Posted: November 23, 2006, 12:22 pm - IP Logged

                  Sun Smiley

                    cps10's avatar - Lottery-004.jpg
                    The Carolinas - Charlotte
                    United States
                    Member #21627
                    September 12, 2005
                    4138 Posts
                    Offline
                    Posted: November 23, 2006, 12:30 pm - IP Logged

                    Thanks WSLS!! Looks great!

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

                    Stooges

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Offline
                      Posted: November 23, 2006, 12:38 pm - IP Logged

                      Instructions:

                      1.  Open the Excel file P3Drawings.xls (Should be in your folder that you created named "P3VTRAC")

                      2.  You will not need to update this file.  I will update and provide download links or if you want a zipped or regular copy let me know and I will email it to you. 

                      3.  Click the Tab labeled "Digit to VTRAC"

                      4.  You can enter the winning Pick 3 "Digit" combinations in column C5 through C51 for Midday for those states that have Midday Drawings.

                      So for example: Today (Thursday 11/23/06) you can enter the winning Midday draws in this column.

                      5.  When you enter the winning drawing in column C you can scroll over to column Y you will see the VTRAC combination.

                      As I mentioned in the beginning you don't need to update this Excel file.  I will update it and provide the download link.

                      Keep the Excel file "P3Drawings.xls" open and go to the next thread!! 

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: November 23, 2006, 1:18 pm - IP Logged

                        Part 2:

                        1.  You should have Open the Excel file "P3Drawings.xls"

                        2.  Open the Excel file "P3VTRACMidday.xls" (should be in the same folder c:\P3VTRAC)

                        3.  Once "P3VTRACMidday.xls" opens click the Tab labeled "VTRAC to Digits Combos"

                        Column A gives you the 125 VTRAC Combinations and in column A3:A164 and in column Z3:Z164 will give you the corresponding "8" Digit combinations.

                        VTRAC   Digit 1   Digit 2

                          1  =     0          5

                          2  =     1          6

                          3  =     2          7

                          4  =     3             8

                          5  =     4          9


                        In column A130:A164 is the list of the 35 "Boxed" VTRAC combinations.  Red = Triples,  Blue=Doubles, Grey=No-Match

                        In column A167:A291 is the same 125 VTRAC combinations but sorted Triples, Doubles, and No-Match

                        4.  Next click the Tab labeled "VTRACMid" (Midday)

                        5.  Column A10:A144 is a list of the 135 past drawings.  The most recent drawing always on line #10 (next to #1) You should see "Wed-Nov-22-2006 and all the previous dates below it.

                        6.   Column G8:Z8 is the list of the "20" Midday State abbreviations.  Below each state are the past "VTRAC" (Not Digit) combinations.  Any combination highlighted in "RED" = Triple VTRAC, "BLUE" = Double VTRAC, and "Clear" = No-Match VTRAC.  Empty cells of course would represent no drawing for that day for that particular state.

                        7.  Scroll over to columns AD:AW.  This is the "BOXED" VTRAC (Not Digit) combinations from Columns G:Z. 

                        Note:  If you don't see the "Boxed" combinations you will need to download the Free Excel Add-in called "Morefunc".  See the first post on this thread.

                        8.  Scroll over to Columns BA:HA.  This is the "Hit & Skip" chart for each of the 125 VTRAC Combinations.  The combinations are arranged as the following:  Triples, Doubles, then No-Match.  The Doubles and No-Match VTRAC Combinations are arranged by their combination.  For example: columns BH8:BJ8 you should see the VTRAC Double Combinations 112, 121, 211.  and under these VTRAC combinations are the current Skips in cells BH10:BJ10.  

                        9.  Columns HE:JM is the BOXED VTRAC Combinations "Hit and Skip" Chart. 

                        Hint:  Look at the "No-Match" VTRAC in cells ID8:IM8.  Now look at the skips in cell ID10:IM10.  Look for skips 2 or more out.

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5387 Posts
                          Offline
                          Posted: November 23, 2006, 2:16 pm - IP Logged

                          Part 3:

                          1.  You might Pick VTRAC Combos 245 and 134 to play today Midday.

                          2.  Scroll back to Column AD and enter 134 in cell AD1 then click ENTER (Highlighted in Yellow)

                          3.  Look at Cell range AD4:AW4.  This line represents the current "Skips" from the last 135 drawings for each state.

                          4.  Look at Cell range AD6:AW6.  This line represents the current "Hits" from the last 135 past drawings for each state.

                          Any cell highlighted in RED on both lines represents a "TOP 10" in each Group.  

                          Look for any state that has a "Hit" Highlighted in "Red".  So you should see the following:

                          CA = 2, CT = 3, GA = 6, IL/IA = 6, IN =4, KY = 5, MD = 3, MO = 6, NY = 5, OH = 5, TX = 6, TS = 5, AND VA = 4.

                          So we have "13" states to paly if we wanted to use the VTRAC "134" (cell AD1)

                          5.  Now Enter 245 in cell AD1 and click Enter.

                          You should have the following:

                          CA = 7, IL/IA = 6, IN = 4, KY = 6, MD = 6, MI = 4, NJ = 4, NY = 7, SC = 7, TX = 7, AND VA = 6.

                          6.  Notice when you enter any VTRAC in cell AD1 any VTRAC that hit in any of the states in cell range AD10:AW144 will be highlighted in RED. For those who track "Traveling VTRAC's"

                          7.  Let's for our example let's say we decided to play VTRAC 245.  Scroll over to cell columns GO:GT.  Look at the VTRAC Combinations 245, 254, 425, 452, 524, 542.

                          Look at the skips for each VTRAC Combination:

                          245 = 6

                          254 = 5

                          425 = 2

                          452 = 26

                          524 = 4

                          542 = 16

                          Here's where you make a decision to play "Boxed" or "Straight" Combinations.

                          Do you use the longest out skips which would give you VTRAC 452 and 542 or do you want to use the "Hottest" skips which would give you 425 and 524?

                          Let's use the "Longest Out" Skips and play VTRAC 452 and 542.

                          This would give you "Digit Combinations"

                          VTRAC 425 = 314,319,364,369,814,819,864,869

                          VTRAC 542 = 431,436,481,486,931,936,981,986

                          You could play these Straight in the states liste in #5

                          OR

                          Play the "Boxed" VTRAC 245

                          VTRAC 245 = 134,139,184,189,634,639,684,689


                          And play these "Boxed" only in the states listed in #5.

                          Now enter VTRAC 134 in cell AD1 and then tell me what state had a straight Midday Today!!! 

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5387 Posts
                            Offline
                            Posted: November 23, 2006, 5:59 pm - IP Logged

                            Updated Thursday 11/23 Midday Drawings

                            Remember to delete the older P3Drawings.xls Excel file first!!!!! 

                            Download Links:

                             Regular File

                            1. P3Drawings.xls

                            http://www.orbitfiles.com/download/id1055739428

                             OR

                            Zipped File 

                            2. P3Drawings.xls

                            http://www.orbitfiles.com/download/id1056010436

                             

                            Anyone find any Straights Midday??

                            VTRAC 542?? 

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: November 24, 2006, 7:58 am - IP Logged

                              Updated Thursday 11/23 Midday Drawings

                              Remember to delete the older P3Drawings.xls Excel file first!!!!! 

                              Download Links:

                               Regular File

                              1. P3Drawings.xls

                              http://www.orbitfiles.com/download/id1055739428

                               OR

                              Zipped File 

                              2. P3Drawings.xls

                              http://www.orbitfiles.com/download/id1056010436

                               

                              Anyone find any Straights Midday??

                              VTRAC 542?? 

                              Updated Excel File "P3Drawings.xls" (includes Thursday Evening 11/23 results)

                              Remember to delete the older file first!!

                              Regular File Download Link:

                              1. P3Drawings.xls

                              http://www.orbitfiles.com/download/id1055739428

                               

                              Zipped File Download Link: 

                              1. P3Drawings.xls

                              http://www.orbitfiles.com/download/id1057020326