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

Pick3 Tab Instructions

Topic closed. 11 replies. Last post 8 years ago by winsumloosesum.

Page 1 of 1
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: December 29, 2008, 7:59 pm - IP Logged

You should have a printout of the Workout Sheet from the "PrintChart" tab.

Click the "Pick3" Tab.

Scroll over to cell range BF1 through BO4.

Notice in cell range BG1:BO1

You see the "Movements" -4, -3, -2, -1, 0, 1, 2, 3, 4

Next, go to cell BD2

Here is where you will enter the VTRAC number 1, 2, 3, 4, 5

In Cell BD2 enter the VTRAC number 1.

Notice the values change in cell range BG2 through BO4.

Go to Cell range BG2:BO2 and look for the "top 3" movements for VTRAC 1 for D1.

Take the workout sheet you printed out and enter the 3 top movemnts in the box next to V1 under P1.

Remember to  enter "movements" that correspond to the Top 3 numbers.  The "movements" are in cell range BG1:BO1.

If the movements are negative in value, you will enter them as negative values.

=====================================================================================

Next, go to cell BF3 (D2) and look for the top 3 movements in cell range BG3:BO3 and enter the 3 values in the worksheet for V1 under P2 column.

If you have values that are the same.  Go to cell range BH12:BH260 and look for the "tiebreakers" for that duplicate value.

Next, go to cell BF4 (D3) and look for the top 3 movements in cell range BG3:BO3 and enter the 3 values in the worksheet for V1 under P3 column.

If you have multiple totals that are the same you will need to go to cell range BI12 through BI260. Go down to find the "tie-breakers"

===============================================================================================

"Tiebreakers" - when you have multiple "movement" values what I do is look in the cell range for that particular position.  For example, D1 the cell range is BG12:BG260.  D2 the cell range is BH12:BH260, and D3 the cell range is BI12:BI260.  So what I look for is the first instance of that particular movement.

===============================================================================================

Now we need to go to Cell BD2 and enter the VTRAC 2 and repeat the whole process again by entering the movements in the workout sheet.

Continue until you finsished entering 1 through 5.

When your workout sheet is completed you should have 3 movement values (positive or negative) in each of the workout sheet boxes.

==================================================================================================

Next, scroll over to cell range GW1 through HH6.

Here is where you enter the "movement" values (positive or negative) in these boxes.

After you have entered all these values scroll over to cell range IC1:IF6

Copy all the 3 digit values from cell range HY2:IA6 to cell range ID2:IF6.

===================================================================================================

Next, scroll back to cell range BL11:BN11.

Write down the 3 three digit values in these 3 cells BL11, BM11, and BN11.

What we want is the first value of each of the 3 three digit numbers.

So for example: if the first 3 digit value in cell BL11 is 134 we will be using the 1st number which is the 1.

Do the same for the values in BM11 and BN11 and use the first digit in each.

You should have 3 numbers (VTRAC Numbers)

===================================================================================================

Go to the Tab labeled "VTRAC Conversion" and go to cell range F5:H5

Enter the 3 numbers (VTRAC Numbers) here.

Once you have entered the 3 values go to cell range J5.  Here is where you have your 8 "straight" combinations.

===================================================================================================

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: December 29, 2008, 8:44 pm - IP Logged

    When your states draw is completed check your 8 combinations.

    The next step is to update the tab Pick3History draw.

    Click the Toolbar "Copy 250 Draws"

    Go to the Tab labeled BL11, BM11, BN11 and write down the first number from each of the 3 digits.

    Example.  If in cell BL11 the 3 digit number is 134 take the 1.

    Take the 3 numbers and go to the Tab labeled VTRAC Conversion and enter the 3 numbers in cell range F5, G5, and H5.

    The 8 straight Pick 3 combinations will be in cell J5.

    =====================================================================================

    The reason we take the 1st digit from each of the 3 numbers from cell range BL11, BM11, and BN11 in the tab labeled Pick3 is because the first digit is the TOP VTRAC digit based on the movement calculations from the workouts we did earlier.

    ======================================================================================

    You will NOT need to complete the movement worksheet after every draw. Re-Calculate after 30 draws.

    ======================================================================================

    The reason we play Straight is because this is how the numbers and movements are set-up.  You can play Boxed combos or play both ways.

    I felt that 8 combos is not many to play @ .50 or $4 bucks a day.

    ======================================================================================

    Go to the Tab labeled Pick3.  Scroll over to cell columns BP12 and BQ12.  You will notice Straight and Boxed or empty cells in these 2 columns.

    These were calculated when we completed the Movements Workout Sheet.

    Scroll over to cell range BS12 , BT12, and BU12.  In these 3 columns you will see either a 1, 2, 3, or a blank cell.  These values represent the position of the 3 digit VTRAC value that was drawn.

    For example, if there was a value of 1 in cell BS12 go to cell BL12.  The "1" appeared in the first position of the 3 digit number.

    Ideally we want a "1" in cell BS12, a "1" in cell BT12, and a "1" in cell BU12.  This would indicate that we had a "straight" hit using only 8 combinations.

    ============================================================================================================

      reddog's avatar - patch
      Greensboro, North Carolina
      United States
      Member #1616
      June 5, 2003
      1285 Posts
      Offline
      Posted: December 29, 2008, 9:07 pm - IP Logged

      What work out sheet are you refering too?  Where??

        reddog's avatar - patch
        Greensboro, North Carolina
        United States
        Member #1616
        June 5, 2003
        1285 Posts
        Offline
        Posted: December 29, 2008, 9:10 pm - IP Logged

        What work out sheet are you refering too?  Where??

        Never mind. I didn't read the "other" thread first.

          mglsr's avatar - candle
          Tennessee
          United States
          Member #2369
          September 23, 2003
          3072 Posts
          Offline
          Posted: December 29, 2008, 10:35 pm - IP Logged

          HL4 and HY4 have the #####

          "As Quoted by the Genius One:"

                  "Life i$ Good "   

           $$$$ I FEEL LUCKY $$$$                                                               

           *lay off and it pays off*

            libra's avatar - chi
            Cleveland , Ohio
            United States
            Member #961
            December 27, 2002
            43629 Posts
            Offline
            Posted: December 29, 2008, 11:05 pm - IP Logged

            Hi mglsr

            ##### usually means that that column is not wide enough for what needs to go in it. Highlight that column and then go up to Format, click on column and then on Autofit Selection. That should take care of it.

            Good Luck Libra Dave

              js1237's avatar - scenery water_mountains.jpg
              NEW YORK
              United States
              Member #3100
              December 23, 2003
              334 Posts
              Offline
              Posted: December 29, 2008, 11:18 pm - IP Logged

              Never mind. I didn't read the "other" thread first.

              Where is the other thread...Thanks...JS...

              "May The Numbers Be With Us All $$$$"....js1237....Sun Smiley

                reddog's avatar - patch
                Greensboro, North Carolina
                United States
                Member #1616
                June 5, 2003
                1285 Posts
                Offline
                Posted: December 30, 2008, 3:48 am - IP Logged

                Where is the other thread...Thanks...JS...

                http://www.lotterypost.com/thread/186609

                  mglsr's avatar - candle
                  Tennessee
                  United States
                  Member #2369
                  September 23, 2003
                  3072 Posts
                  Offline
                  Posted: December 30, 2008, 8:46 am - IP Logged

                  Hi mglsr

                  ##### usually means that that column is not wide enough for what needs to go in it. Highlight that column and then go up to Format, click on column and then on Autofit Selection. That should take care of it.

                  Good Luck Libra Dave

                  That didn't work Libra Dave

                  "As Quoted by the Genius One:"

                          "Life i$ Good "   

                   $$$$ I FEEL LUCKY $$$$                                                               

                   *lay off and it pays off*

                    mglsr's avatar - candle
                    Tennessee
                    United States
                    Member #2369
                    September 23, 2003
                    3072 Posts
                    Offline
                    Posted: December 30, 2008, 9:40 am - IP Logged

                    That didn't work Libra Dave

                    Problem solved

                    "As Quoted by the Genius One:"

                            "Life i$ Good "   

                     $$$$ I FEEL LUCKY $$$$                                                               

                     *lay off and it pays off*

                      Raven62's avatar - binary
                      New Jersey
                      United States
                      Member #17843
                      June 28, 2005
                      49674 Posts
                      Offline
                      Posted: December 30, 2008, 1:18 pm - IP Logged

                      Some spreadsheet cells use funtions that are not part of Excel. The freeware addin Morefunc can be downloaded and installed to get these missing functions (mconcat, vsort, intvector):

                      Download Here

                      A mind once stretched by a new idea never returns to its original dimensions!

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: December 30, 2008, 2:44 pm - IP Logged

                        The morefunc addin should already imbedded into this file.

                        I should have deleted these columns.  They really have no bearing on the file.

                         

                        Below is a link to a Word doc that contains a blank workout sheet.

                         

                        http://www.mediafire.com/?kgez1hma0ye