Welcome Guest
Log In | Register )
You last visited December 6, 2016, 11:05 am
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 2 of 4
51
PrintE-mailLink
ilovecash's avatar - Lottery-006.jpg
Superior Twp
United States
Member #45785
August 28, 2006
30 Posts
Offline
Posted: November 24, 2006, 11:12 am - IP Logged

does this work for pick 4 or only pick 3?

    mglsr's avatar - candle
    Tennessee
    United States
    Member #2369
    September 23, 2003
    3072 Posts
    Offline
    Posted: November 24, 2006, 4:22 pm - IP Logged

    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

    Steve, this download says p3 file cannot be accessed maybe read only. tried downloading it 3 three times and all said the same

    "As Quoted by the Genius One:"

            "Life i$ Good "   

     $$$$ I FEEL LUCKY $$$$                                                               

     *lay off and it pays off*

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5896 Posts
      Online
      Posted: November 24, 2006, 4:54 pm - IP Logged

      Steve, this download says p3 file cannot be accessed maybe read only. tried downloading it 3 three times and all said the same

      Steve, I got the same message. I downloaded both files and both were the same.

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

        Carbob,

        I just updated the Midday drawings.

        Here are the links.

        Remember to delete the old P3Drawings.xls Excel file first.

        1. P3Drawings.xls

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

        or

        Zipped File

        1. P3Drawings.xls

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

        If you have any problems let me know and I will email them.

        Steve 

          Fibonacci's avatar - Lottery-050.jpg
          New York, NY
          United States
          Member #39471
          May 16, 2006
          2696 Posts
          Offline
          Posted: November 24, 2006, 10:49 pm - IP Logged

          WS thanks..a welcome addition--been looking for whatever you came up with....

          Thanks from  your number one student! 

          $$$

            Fibonacci's avatar - Lottery-050.jpg
            New York, NY
            United States
            Member #39471
            May 16, 2006
            2696 Posts
            Offline
            Posted: November 24, 2006, 10:57 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!!! 

            I get the dreaded "File Not Found" at the folliwng URLs

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

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

            $$$

              retxx's avatar - mrthumbs
              BOSTON
              United States
              Member #48
              September 9, 2001
              3588 Posts
              Offline
              Posted: November 24, 2006, 10:59 pm - IP Logged

              to wsls; Can you add the front 3 as a file for Mass. to the list as we do not show a pick3  as a stand alone. Thanks

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

                Updated Drawing Excel files :

                Remember to delete the old P3Drawings.xls file first. 

                If you have any problems send me a PM with an email address and I will forward you the zip files. 

                Regular File

                1. P3Drawings.xls

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

                OR

                 

                1. P3Drawings.xls

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

                 

                If your just starting out you will need to create a new folder and name it P3VTRAC (C:\P3VTRAC)

                Download the following files and place them in this folder.

                You have the option below of either the large files or zip files.  Both are the same. 

                Make sure you also download the Free Excel add-in "Morefunc" from this link:

                http://xcell05.free.fr/english/

                Below are all the files for new people.

                I posted some basic instructions on how to use the Excel files.

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

                1. P3Drawings.xls

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


                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/id1058093642


                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!!!

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

                  Additional Instructions/Help!!

                  What 2 files do you have open?

                  1.  You should have the P3Drawings.xls Excel file always open.

                  2.  What is the second Excel file you have open?

                  If it's the P3VTRACMidday.xls or the P3VTRACCombined.xls Excel file the first thing I do is click the Tab labeled either VTRACCombined (P3VTRACCombined.xls Excel file) or the Tab labeled VTRACMid (P3VTRACMidday.xls Excel file) then scroll all the way over to the right  to cell columns ID:IM.  Loook for No-Match VTRAC combinations that are 2 or more skips out on line 10.

                  For example: In the P3VTRACCombined.xls Excel file you will notice the VTRAC 134 is currently out 2 draws.  So VTRAC 134 is what I'm playing Midday today.  Now what I do is look for straight VTRACs.  So what I do is scroll to the left and look at the VTRAC 134 Grouping in cell range FF8:FK8.  I look for the "2" longest out Skips for all 6 VTRACs (134, 143, 314, 341, 413, 431).  So look at line FF10:FK10.  You should see the following:

                  134    143    314    341    413    431
                               
                    2      3      3      9      11      9

                  So based on the above my choices would be VTRAC 413 and 341.  VTRAC 341 and 431 are both out 9 skips.  I chose 341 because of the previous skip of "17"

                  The next thing I do is scroll over to cell AD1 and I enter the "Boxed" VTRAC I am playing and that would be 134.  So I enter 134 (enter in ascending order only) in cell AD1 and press the Enter key on your keyboard.

                  Now the next thing I look for are the states to play.  Look at Cell range AD6:AW6 (Current Hits).  Look for any number hiughlighted in RED.

                  Now look below at the corresponding states below to play. 

                  So, in our example I would be playing Midday Today these states:

                  CA    CT    DE    IN    KY    MD    MI    NY    OH    PA    SC    TN    TX

                  The last thing to do is to find the Digit Combinations to play in the above states:

                  So click the Tab labeled: "VTRAC to Digit Combos"

                  Scroll down in column A and look for the 2 VTRAC's 413 and VTRAC 341

                  The digit combinations today would be: (413 and 341)

                  VTRAC 413 Digit Combinations: 302,307,352,357,802,807,852,857

                  VTRAC 341 Digit Combinations: 230,235,280,285,730,735,780,785

                  This is how I arrived at my Midday Picks for Saturday Midday 11/25/06. (See Thread)

                  You would follow the same idea if you see a No Match VTRAC in the P3VTRACMidday.xls file.

                  The P3VTRACEvening.xls Excel file is a little different due to the number of Evening states.  You would do the same as the Midday and Combined but the Cell ranges would be different.

                  1.  Scroll over to the right to cell range IF10:IO10

                  2.  Look for any VTRACs with skips of 2 or more (Or find the VTRAC combo that looks playable using your own strategy)

                  3.  Scroll over to the left EV8:HC8 and look for the "Groupings" for your VTRAC.  So for example: If you wanted to play VTRAC 134 you would use cell range FN8:FS8 and look for the "2" longest-out skips in cell range FN10:FS10.

                  4.  Next, scroll over to the left to Cell "AU1".  Enter your "Boxed" VTRAC in Ascending order "134" (example: 134, 123, 345 etc.) then click the ENTER Key on your keyboard.  Look at line AU6:CE6 (Current Hits).  Look for numbers highlighted in RED and then look below for the corresponding state abbreviations.

                  5.  Click the Tab labeled "VTRAC to Digit" and look for the "2" VTRAC Combinations you want to play in column "A" and then find the corresponding "8" Digit Combinations in column "Z".


                  Of course you can play whatever strategy you like.

                  The idea is to visually look for the VTRAC's and look for "Patterns" and States. 

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

                    How to Update the P3Drawings.xls Excel file!!

                    For those who are daring and bold!!

                    Print out these Instructions!!!

                    Wait until all the Saturday 11/25/06 Midday drawings are drawn and posted on the Lotterypost "Dail Numbers" Results page 

                    1.  Close all your Excel files except "P3Drawings.xls"

                    2.  Locate and Click the Tab labeled "Digit to VTRAC"  (Very 1st Tab on the left) 

                    3.  Either print out today's Midday Results or save paper and minimize the Lotterypost Daily Number Results page and "P3Drawings.xls" Excel file on your computer screen where you can see both at the same time.  (that' if your screen is big enough)

                    4.  Ok, all the Midday results are drawn (hypothetically speaking) now we want to enter all the results in the Excel file "P3Drawings.xls" and click the Tab labeled "Digit To VTRAC".  To do this we want to enter all the Midday Drawings in cell Range C5:C41.  Ok, now all the states in this column that do "NOT" have Midday draws, so they are "Blacked Out" and since it is Saturday Connecticut does not have a Midday Drawing so we want to skip this space (or leave blank).  As your entering all the results notice in cell range Y5:Y41 all the VTRAC equivalents are appearing in this (Midday) range.  

                    5.  Next verify all the drawings are correct and match the corresponding states (I find this is very helpful double-checking).

                    6.  This is where it gets daring.  If your not a daring person "STOP" close your Excel file.  If you are daring go to the next step.

                    7.  (Daring People Only)  You should still be in the Tab labeled "Digit To VTRAC".  Scroll over to Cell range coulmn "Y".  Take your mouse and click cell Y5.  (Arizona to the left) Click cell "Y5" and hold your "left mouse" button.  While holding your "Left-mouse" button, drag it all the way down to cell Y41.  The cell range Y5:Y41 should now be highlighted.  Next place the "cross-hairs" over any part of the Y5:Y41 cell range, click the "Right" Mouse button and select "Copy" by "left clicking" with your mouse.  With me so far??.  Now click the next Tab labeled "Pick3 Results".  Since we are updating the "Midday" results you want to click the cell "N5".  "Right Click" your mouse and select "Paste Special" a window will open and you want to select "Values".  Then click the "OK" button.  All the VTRAC combinations should be now in cell range "N5 :N41".  Ok, the next step is stupid but we have to do it anyway.  Since Connecticut Midday is blank we need to do the following.  Click Cell "N7" and click the "Delete" key on you keyboard.  Ok so far???  The rest is easy!!

                    8.  Ok, you should be on the Tab "Pick3 Results".  Click the Toolbar labeled "Click To Add Dates" in cell range M1:N1.  By clicking this Toolbar it will insert Saturdays Date to all the Midday and Combined drawings worksheet files. This might take a few seconds.  Screen should start flashing.  After all the dates are entered Click the Toolbar labeled "Click To Add Midday Drawings" in cell range M3:N3.  By clicking this Toolbar it will insert  all the VTRAC combinations in the Midday and Combined States drawings worksheets.

                    9.  Thats it your finished. Congratulations and give yourself a pat on the back!! (If you can reach)

                    10.  Now save the "P3Drawings.xls" file.  Keep it open for the next step.

                    11.  Now you can open any or all of the following Excel files P3VTRACMidday.xls, P3VTRACEvening.xls, and or P3VTRACCombined.xls.

                    12.  Since you updated (hypoteically speaking) updated the Midday Results you might want to open the P3VTRACCombined.xls and the P3VTRACEvening.xls Excel files and look for play for this evening. 

                    13.  If you made a mistake and/or the Toolbars did not work.  You may need to set the security levels to Medium or Low.

                    Go to Tools> Macro > Security > (Click Security Level Tab) > Select High, Medium, Low.  Since you all trust me (I think) you may want to click Low.  Or if you want to keep it High and have that annoying Macro window open everytime you open these files thats OK too.

                    Hope these instructions helped!! 

                    If you really feel daring try updating the evening draws!!! 

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

                      Need Help!!!

                      Does anyone have a good site to upload 4 Excel files and provide download links??

                      Man my site stinks!!  Might be squirrels on the line or something.

                      Send me a PM if you can help!!! 

                      For those who asked, I just emailed you the 4 zip files. 

                      Hope you have a zip program to unzip them (that would help!!) 

                      Think there is a FREE one out there somewhere.

                        focus73's avatar - power
                        CHICAGO
                        United States
                        Member #46985
                        October 12, 2006
                        172 Posts
                        Offline
                        Posted: November 25, 2006, 3:01 pm - IP Logged

                        Try Rapidshare

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

                          Ok, lets try Rapidshare!!

                          Here are the updated links.

                          Drawing files are updated from last evening.

                          Delete all your "4" older  Excel files if you have any.

                          Make sure you have a folder on your hard drive C:\P3VTRAC  if not create one using this name.

                          Make sure you have the Excel Add-in "morefunc".  I provided a link at the end of the list below if you need it. Install this Add-in first or the files won't work.

                          Let me know if you have any problems!!

                          Excel Files - Updated 11/26/06

                          Download Links - Large "Non-Zipped" Files


                          1.  P3Drawings.xls

                          http://rapidshare.com/files/4900257/P3Drawings.xls.html



                          2. P3VTRACCombined.xls

                          http://rapidshare.com/files/4896280/P3VTRACCombined.xls.html



                          3. P3VTRACEvening.xls

                          http://rapidshare.com/files/4896431/P3VTRACEvening.xls.html


                          4. P3VTRACMidday.xls

                          http://rapidshare.com/files/4896529/P3VTRACMidday.xls.html


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

                          Download Links - Zipped Files


                          1.  P3Drawings.xls

                          http://rapidshare.com/files/4900102/P3Drawings_Zip.zip.html



                          2. P3VTRACCombined.xls

                          http://rapidshare.com/files/4896545/P3VTRAC_Zip_2_of_4.zip.html



                          3. P3VTRACEvening.xls

                          http://rapidshare.com/files/4896567/P3VTRAC_Zip_3_of_4.zip.html


                          4. P3VTRACMidday.xls

                          http://rapidshare.com/files/4896584/P3VTRAC_Zip_4_of_4.zip.html

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

                          Excel Add-in "Morefunc" Download Link

                          http://rapidshare.com/files/4900102/P3Drawings_Zip.zip.html

                            Avatar
                            New Member
                            Lawton, Oklahoma
                            United States
                            Member #47812
                            November 26, 2006
                            11 Posts
                            Offline
                            Posted: November 26, 2006, 10:08 am - IP Logged


                            Hi,

                            Your excel files are awesome.  

                            Could Oklahoma possibly be added?

                            We are up to 381 Pick 3 draws now and this state is VERY hard to predict.

                             

                            Thanks!! 

                              retxx's avatar - mrthumbs
                              BOSTON
                              United States
                              Member #48
                              September 9, 2001
                              3588 Posts
                              Offline
                              Posted: November 26, 2006, 11:22 am - IP Logged

                              second time around for my question;I have the 4 links downloaded except for the morefunc which says not a valid archive try loading again. Also on the other 4 screens when they calculate all the cells numbers are gone and replaced with sharp signs. What do i do now? And what about my first question on adding the front 3 for Mass. or at least allowing me to add them to the list. Hope someone is listening to me for an answer. thanks