Welcome Guest
Log In | Register )
You last visited December 6, 2016, 11:05 am
All times shown are
Eastern Time (GMT-5:00)

Blackapple Pick 3 Toolshed

Topic closed. 28 replies. Last post 1 year ago by Makenmo.

Page 1 of 2
55
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: August 27, 2015, 10:27 am - IP Logged

I'm going to upload some Excel files based on Blackapples posts:

The name of the folder to create is called Pick3ToolShed on your computer.

Download the following zip file and place it in the above folder.

https://copy.com/FDRlU4oO2eioklHr

Inside the zip file are 4 Excel files

P3StateDraws.xlsm and 3 additional Excel files.

Open the P3StateDraws.xlsm file first and keep open.  This has all the Pick 3 draw histories of each state including Canadian Pick 3 draws. The draws are updated through Wednesday, August 26, 2015. You will see a pop-up window to change the date.  Click "X" to exit the date window.  You may also be prompted to enable macros or enable content.  You will need to enable both if you want to use these Excel files.

Always keep this file open.

Next, from the Main Menu (Top) select File > Open and browse to the Pick3ToolShed folder and open any of the remaining Excel files.  For example, open the Excel file "Pick3BoxedPairsSystem4.xlsm".

Click the tab labeled "States"

In cell J25 click the cell and select your state of just use the state I have wich in this case is Pennsylvania Midday

Click the tab labeled "220SetsBoxed"

The calculations are based on Blackapples post:

Taking past draws and removing pairs that have hit until you end up with 28 pairs.  No doubles. (see column K)

Take the 4 digits with the longest out skip All Positions (see column J)

Take the 4 LDR Sums longest out skips (see column L)

Use only "6-way" sets (see column A)

Each column is filtered by clicking the "down arrows" in cell range A1 through L1

Total Sets = cell M1

Longest Out Digits = Cell range T1 through AC1.  The 1st 4 are the longest out in all 3 Positions

Longest Out Pairs (No Doubles) = Cell range AF1 through BG1 The longest out Pair starts in cell AF1.

Longest Out LDR Sums = Cell range BJ1 through BS1.  The 4 longest out appear in cell range BJ through BM.

42 Filtered Sets - PA Midday Draw Thursday, August 27, 2015

012
016
018
025
027
029
034
036
038
045
047
049
056
058
067
089
124
126
128
135
137
139
146
148
157
179
234
238
245
247
278
289
346
368
458
467
469
478
489
568
678
689

 

I will explain how to use the other Excel files when I get home later today.

Close this file when you finished.

You can open 1 of the other 2 Excel files (Other than the P3StateDraws.xlsm) and check them out.

More later......

    Blackapple's avatar - nw rogue2.jpg
    Wyncote,Pa
    United States
    Member #3206
    January 3, 2004
    60724 Posts
    Offline
    Posted: August 27, 2015, 11:18 am - IP Logged

    PartyThanks Winsum

      kreative1's avatar - flower2
      NE PA
      United States
      Member #127838
      May 10, 2012
      1230 Posts
      Online
      Posted: August 27, 2015, 11:55 am - IP Logged

      Not sure if this helps but red plays are front pairs that haven't hit this year for str8
      It might filter it too much...have to see

      Thanks winsum and black apple!

      012
      016
      018
      025
      027
      029
      034
      036
      038
      045
      047
      049
      056 -650
      058
      067
      089
      124
      126 -162
      128
      135
      137 -173
      139
      146 -164
      148
      157 -175
      179
      234 -423
      238
      245 -425
      247 -427-472
      278
      289
      346
      368
      458
      467 -476
      469
      478
      489
      568-658
      678
      689

        Makenmo's avatar - PHI
        Earth 1.00 - Venus .618 - Mercury .382 -Mars 1.618

        United States
        Member #147790
        October 13, 2013
        2111 Posts
        Offline
        Posted: August 27, 2015, 12:01 pm - IP Logged

        PartyThanks Winsum

        I Agree!

        Nice Work Winsum!!!

         1.61803398875 Thumbs Up

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: August 27, 2015, 1:09 pm - IP Logged

          Add this Excel file to the Tool Shed

          https://copy.com/9q1dQs2ulfKqvvxh

          Place it in the same folder.

          This Excel file calculates all the state draws to find out what states currently have an All Odd and All Even VTRAC out more than 5 draws.

          Remember to open the P3StateDraws.xlsm open 1st before opening this Excel file.

            Makenmo's avatar - PHI
            Earth 1.00 - Venus .618 - Mercury .382 -Mars 1.618

            United States
            Member #147790
            October 13, 2013
            2111 Posts
            Offline
            Posted: August 27, 2015, 1:54 pm - IP Logged

            Add this Excel file to the Tool Shed

            https://copy.com/9q1dQs2ulfKqvvxh

            Place it in the same folder.

            This Excel file calculates all the state draws to find out what states currently have an All Odd and All Even VTRAC out more than 5 draws.

            Remember to open the P3StateDraws.xlsm open 1st before opening this Excel file.

            Thank you again and again Steve, I know how much work you did with Lotsoft. Totally appreciate how long you kept that alive... Last heard, I believe Lotsoft is still a manual update for states...

             

            Didn't see anything about updates for this file.  I think this is a manual update file(s).. If so,

            I wonder/would be awesome, if Todd could come up with a way to make an update happen from LP.

            You Rock my friend!

             1.61803398875 Thumbs Up

              Avatar
              Galloway, Ohio
              United States
              Member #163255
              January 24, 2015
              309 Posts
              Offline
              Posted: August 27, 2015, 2:39 pm - IP Logged

              Not all sure how this works but so appreciate the time and effort you have put forth here.  So far your instructions are very clear.  Thank you!

                LottoBux's avatar - 2elh5if
                Ontario
                Canada
                Member #109243
                April 9, 2011
                31437 Posts
                Offline
                Posted: August 27, 2015, 9:25 pm - IP Logged

                Thank you again and again Steve, I know how much work you did with Lotsoft. Totally appreciate how long you kept that alive... Last heard, I believe Lotsoft is still a manual update for states...

                 

                Didn't see anything about updates for this file.  I think this is a manual update file(s).. If so,

                I wonder/would be awesome, if Todd could come up with a way to make an update happen from LP.

                You Rock my friend!

                You Have To Update The Pick3StateDraws File Only.

                Once That's Updated,The Other Files Will Update Automatically.

                Watch This Video To Update The State Draw Files

                https://www.youtube.com/watch?v=9C2ypxFFWUM

                                       

                  LottoBux's avatar - 2elh5if
                  Ontario
                  Canada
                  Member #109243
                  April 9, 2011
                  31437 Posts
                  Offline
                  Posted: August 27, 2015, 9:42 pm - IP Logged

                  I'm going to upload some Excel files based on Blackapples posts:

                  The name of the folder to create is called Pick3ToolShed on your computer.

                  Download the following zip file and place it in the above folder.

                  https://copy.com/FDRlU4oO2eioklHr

                  Inside the zip file are 4 Excel files

                  P3StateDraws.xlsm and 3 additional Excel files.

                  Open the P3StateDraws.xlsm file first and keep open.  This has all the Pick 3 draw histories of each state including Canadian Pick 3 draws. The draws are updated through Wednesday, August 26, 2015. You will see a pop-up window to change the date.  Click "X" to exit the date window.  You may also be prompted to enable macros or enable content.  You will need to enable both if you want to use these Excel files.

                  Always keep this file open.

                  Next, from the Main Menu (Top) select File > Open and browse to the Pick3ToolShed folder and open any of the remaining Excel files.  For example, open the Excel file "Pick3BoxedPairsSystem4.xlsm".

                  Click the tab labeled "States"

                  In cell J25 click the cell and select your state of just use the state I have wich in this case is Pennsylvania Midday

                  Click the tab labeled "220SetsBoxed"

                  The calculations are based on Blackapples post:

                  Taking past draws and removing pairs that have hit until you end up with 28 pairs.  No doubles. (see column K)

                  Take the 4 digits with the longest out skip All Positions (see column J)

                  Take the 4 LDR Sums longest out skips (see column L)

                  Use only "6-way" sets (see column A)

                  Each column is filtered by clicking the "down arrows" in cell range A1 through L1

                  Total Sets = cell M1

                  Longest Out Digits = Cell range T1 through AC1.  The 1st 4 are the longest out in all 3 Positions

                  Longest Out Pairs (No Doubles) = Cell range AF1 through BG1 The longest out Pair starts in cell AF1.

                  Longest Out LDR Sums = Cell range BJ1 through BS1.  The 4 longest out appear in cell range BJ through BM.

                  42 Filtered Sets - PA Midday Draw Thursday, August 27, 2015

                  012
                  016
                  018
                  025
                  027
                  029
                  034
                  036
                  038
                  045
                  047
                  049
                  056
                  058
                  067
                  089
                  124
                  126
                  128
                  135
                  137
                  139
                  146
                  148
                  157
                  179
                  234
                  238
                  245
                  247
                  278
                  289
                  346
                  368
                  458
                  467
                  469
                  478
                  489
                  568
                  678
                  689

                   

                  I will explain how to use the other Excel files when I get home later today.

                  Close this file when you finished.

                  You can open 1 of the other 2 Excel files (Other than the P3StateDraws.xlsm) and check them out.

                  More later......

                  Thanks Winsum For Everything .Smiley

                  Hope You Had A Great B'Day Yesterday Happy Birthday

                                                      LottoBux

                                         

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Offline
                    Posted: August 27, 2015, 10:24 pm - IP Logged

                    I'll update the P3StateDraws.xlsm Excel file each morning and post the link in this thread.

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Offline
                      Posted: August 28, 2015, 7:51 am - IP Logged

                      P3StateDraws.xlsm Excel file download link:

                      https://copy.com/ayKLOjd2EIoaRk0j

                      Draws updated through Thursday, Ausgust 27, 2015

                      Place this Excel file in your Balcakapple Tool Shed folder.

                        Avatar
                        Galloway, Ohio
                        United States
                        Member #163255
                        January 24, 2015
                        309 Posts
                        Offline
                        Posted: August 28, 2015, 11:05 am - IP Logged

                        Could you help me understand the  file?  Some items I know about but is there a post regardidng how BA discarded the pairs as you referred to in your instructions?  Wonderful information just need help deciphering it.

                          Makenmo's avatar - PHI
                          Earth 1.00 - Venus .618 - Mercury .382 -Mars 1.618

                          United States
                          Member #147790
                          October 13, 2013
                          2111 Posts
                          Offline
                          Posted: August 28, 2015, 12:49 pm - IP Logged

                          Could you help me understand the  file?  Some items I know about but is there a post regardidng how BA discarded the pairs as you referred to in your instructions?  Wonderful information just need help deciphering it.

                          Claret, if I understand you correctly,,, you can try Secrets of the 3 digits out system

                          Also BA uses other methods like these

                          F17 system which he references here.

                          Straight System For Pick 3

                          Hope this helps

                           1.61803398875 Thumbs Up

                            Avatar
                            Galloway, Ohio
                            United States
                            Member #163255
                            January 24, 2015
                            309 Posts
                            Offline
                            Posted: August 28, 2015, 1:54 pm - IP Logged

                            Exactly - thanks for the help!

                              Makenmo's avatar - PHI
                              Earth 1.00 - Venus .618 - Mercury .382 -Mars 1.618

                              United States
                              Member #147790
                              October 13, 2013
                              2111 Posts
                              Offline
                              Posted: August 28, 2015, 1:55 pm - IP Logged

                              Claret, if I understand you correctly,,, you can try Secrets of the 3 digits out system

                              Also BA uses other methods like these

                              F17 system which he references here.

                              Straight System For Pick 3

                              Hope this helps

                              Claret.... I am learning as well  so let's see if I get this correct. Please Correct Me

                                  Winsum said "The calculations are based on Blackapples post:"

                              Winsum Placed letters A through I, within to correspond to the following

                              A. Double Odd Vtracs** - 205-127-805-627 etc
                              B. Double Even Vtracs - 961-583-216-138 etc
                              C. All even or All odd combos -208-468-824-357-977-319 etc
                              D. The trough pairs - 00-01-08-09-11-18-19-88-99-89-
                              E. The 0 or 1 combos- 920-123-057-187 etc
                              F. Sums 12-16 -457-348-518-319-167-841 etc
                              G. A six-way mirror combo- 167-561-530-835-207 etc.
                              H. A consecutive pair
                              I.  2 Digit Return
                               

                              I believe the following is done for you

                              Taking past draws and removing pairs that have hit until you end up with 28 pairs.  No doubles. (see column K)

                              Take the 4 digits with the longest out skip All Positions (see column J)

                              Take the 4 LDR Sums longest out skips (see column L)

                              Use only "6-way" sets (see column A)

                              Each column is filtered by clicking the "down arrows" in cell range A1 through L1

                              Total Sets = cell M1

                              I believe the following are results of BA's Work (above) & done for you

                              Longest Out Digits = Cell range T1 through AC1.  The 1st 4 are the longest out in all 3 Positions   

                              You can see them 4 in CELL AD1

                              Longest Out Pairs (No Doubles) = Cell range AF1 through BG1 The longest out Pair starts in cell AF1.

                              You can see the PAIRS in CELL BH1

                              Longest Out LDR Sums = Cell range BJ1 through BS1.  The 4 longest out appear in cell range BJ through BM.

                              You can see them 4 in CELL BT1

                              You then filter based on the given "out 5 days or more" scenario A Through I you find----  Like Winsum's 42 Filtered Sets

                              From what I see, Winsum has completely done most of the work.

                              For instance, if the Dominant LDR in a work out from Secrets of the 3 Digits out Method is say, 1,  then you can reduce by only the pairs that help LDR achieve it such as 38, 29, 47...etc

                              Hope this helps

                               1.61803398875 Thumbs Up