Welcome Guest
Log In | Register )
You last visited January 20, 2017, 8:51 am
All times shown are
Eastern Time (GMT-5:00)

Pick 3 System - Jayemmar 2009

Topic closed. 47 replies. Last post 3 years ago by BLEUSTAR.

Page 2 of 4
53
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
Posted: August 5, 2013, 7:34 pm - IP Logged

Here is a link to a new Youtube video using the Combined Draws for the Pennsylvania Pick 3.

http://www.youtube.com/watch?v=NIV01RUcXvQ

The Pennsylvania Evening draws was 372 and the box was 011.  The video I was explaining how the box 010 has hit in the last 10 twenty draw cycles.

The total number of sets to play is 66 straight sets.

    kreative1's avatar - flower2
    NE PA
    United States
    Member #127838
    May 10, 2012
    1255 Posts
    Offline
    Posted: August 5, 2013, 9:09 pm - IP Logged

    awesome winsum!

    thank you!

      BLEUSTAR's avatar - character catafly.jpg
      New Member
      MD
      United States
      Member #143188
      May 27, 2013
      16 Posts
      Offline
      Posted: August 7, 2013, 5:15 pm - IP Logged

      Hi Winsom - Would it be possible switch to use your system for use in MD?  If its not time consuming can you eXplain please?  Thanks!

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Offline
        Posted: August 10, 2013, 8:02 am - IP Logged

        Hi Winsom - Would it be possible switch to use your system for use in MD?  If its not time consuming can you eXplain please?  Thanks!

        Here you go Bleustar,

        1. Create a new folder and name it whatever you want.  Example, Maryland Pick 3

        2. Download the following 4 Excel files from the links below into the new folder you created in Step 1:

        https://app.box.com/s/x74g9jfraq1sqfcp4qh4

        https://app.box.com/s/2kmvbufjqh3yxxwd5eel

        https://app.box.com/s/yvhlks73sez6spzf6ete

        https://app.box.com/s/z5jz2rhpldfkjaf2pulf

        3. Open the Excel file P3Draws 1st

        4. Once the P3Draws file opens you can update the maryland Draw histories for Midday, Evening, and Combined.  I already updated the draws through Friday August 9, 2013 in the tabls labeled M.(Midday), E (Evening), C (Combined).

        5. Once you updated any past draws you need to go to the Main Menu at the top and select File > Open then browse to the folder where the remainig 3 Excel files are located in the folder you created in Step 1 above.  Just select only 1 Excel file. If you want to use the Midday draws only you would select File > Open and then select the "WorkoutsDeMap3Midday".

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5396 Posts
          Offline
          Posted: August 10, 2013, 8:59 am - IP Logged

          Here you go Bleustar,

          1. Create a new folder and name it whatever you want.  Example, Maryland Pick 3

          2. Download the following 4 Excel files from the links below into the new folder you created in Step 1:

          https://app.box.com/s/x74g9jfraq1sqfcp4qh4

          https://app.box.com/s/2kmvbufjqh3yxxwd5eel

          https://app.box.com/s/yvhlks73sez6spzf6ete

          https://app.box.com/s/z5jz2rhpldfkjaf2pulf

          3. Open the Excel file P3Draws 1st

          4. Once the P3Draws file opens you can update the maryland Draw histories for Midday, Evening, and Combined.  I already updated the draws through Friday August 9, 2013 in the tabls labeled M.(Midday), E (Evening), C (Combined).

          5. Once you updated any past draws you need to go to the Main Menu at the top and select File > Open then browse to the folder where the remainig 3 Excel files are located in the folder you created in Step 1 above.  Just select only 1 Excel file. If you want to use the Midday draws only you would select File > Open and then select the "WorkoutsDeMap3Midday".

          Here is a Youtube video on How to Use the Maryland Pick 3 Excel files:

          http://www.youtube.com/watch?v=AbJhLZUYV-o

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5396 Posts
            Offline
            Posted: August 10, 2013, 10:43 am - IP Logged

            Florida Excel files updated:

            https://app.box.com/s/thbrxe0hd2p9p4q0cpjb

            https://app.box.com/s/a1sohkmatm04rfe4j0wg

            https://app.box.com/s/kazg8ffachv8yq2kvnyu

            https://app.box.com/s/omtz1ym6g8sa6a5sssr2

            You can watch the Youtube video I posted for Maryland as instructions on how to use the files.

              butler863's avatar - Lottery-002.jpg
              New Member
              Bowling Green, Florida
              United States
              Member #83391
              December 6, 2009
              8 Posts
              Offline
              Posted: August 10, 2013, 10:47 am - IP Logged

              I have the florida P3Draws worksheet with all 3 WorkoutsDeMap drawing worksheets. My question is, in the WorkoutsDeMap worksheets "frequencymodel" tab "cycle 0", are we to manually write in the combinations or is this suppose to be automatically be updated? my dates are changing but the combinations are staying the same as the last drawing date combinations inserted from the 4th of August.

                butler863's avatar - Lottery-002.jpg
                New Member
                Bowling Green, Florida
                United States
                Member #83391
                December 6, 2009
                8 Posts
                Offline
                Posted: August 10, 2013, 10:50 am - IP Logged

                I just posted a reply only to return to the forum and see you just uploaded new Florida files.

                  butler863's avatar - Lottery-002.jpg
                  New Member
                  Bowling Green, Florida
                  United States
                  Member #83391
                  December 6, 2009
                  8 Posts
                  Offline
                  Posted: August 10, 2013, 11:13 am - IP Logged

                  Hello again. My question, is there any way to modify the worksheets based on mirror numbers? For example, I have always came up with my combinations using 0, 1, 2, 3, 4. So say I come up with 121, then the numbers I play for today would be 621, 171, 126, 671, 626, 176, and 676. So instead of analyzing the pairs for 00-99, you would only have to analyze the pairs for 00, 01, 02, 03, 04, 10, 11, 12, 13, 14........and so on. So instead of 100 pairs, now you onl have 25 pairs.

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5396 Posts
                    Offline
                    Posted: August 10, 2013, 11:21 am - IP Logged

                    You 1st open the P3Draws Excel file first and update the tabs M, E, C (Midday Draws, Evening Draws, Combined Draws) then go to the top Main Menu and select File > Open then you have a choice of selecting either the WorkoutsDeMapMidday, WorkoutsDeMapEvening, or WorkoutsDeMapCombined.  So for example you decide to just use want to use the WorkoutsDeMapMidday file.

                    If you click the Tab at the bottom labeled "Pick3Draws2", I'm using an 80 draw history range which are the drawings from July 31st back to May 13, 2013.  Cell column A.  Every time you update the Excel file 'P3Draws" Midday drawing(s) (M Tab) you will also need to adjust the drawing number in cell AC1 located in the WorkoutsDeMapMidday Excel workbook in the Tab/worksheet labeled Pick3Draws2.  For now you don't need to adjust cell AC1 which is currently set at 29.  The 29 is taken from the 1st tab labeled "Pick3Draws".  If you look at the leftmost column where you see where 29 is on the same row as July 31, 2013.

                    I'm also using an 80 draw range to calculate how many times a Front Pair, Back Pair, or Side Pair has hit.  You can also change the 80 draw range to 120 draws by going to the Tab labeled Pick3Draws2 and click cell AF1.  To the right of cell AF1 there is a drop-down arrow.  If you click the drop-down arrow you have a choice of 79 or 119.  If you select 79 you will be using an 80 draw history.  If you select 119 you will be using a 120 draw history.  Currently it is set to 79 which is an 80 draw history range from July 31 2013 through May 13, 2013

                    The only entries you need to make are in the tab labled "FrequencyModel" in the WorkoutsDeMapMidday Excel file.  This is cell range AB5 though AB24. 

                    Notice in cell AB16 the last entry was from friday August 9th 2013 which was 309.  The Front Pair is 30 (cell AD16), Side Pair is 39 (AE16), and the Back Pair is 09 (AF16).  The 1 in cell AH16 indicates that the Front Pair 30 occurred 1 time from July 31st throgh May 13 (80 draw history).  The 1 in cell AI6 indicates that the Sidet Pair 39 occurred 1 time from July 31st throgh May 13 (80 draw history). The 2 in cell AJ16 indicates that the Back Pair 09 occurred 2 times from July 31st throgh May 13 (80 draw history).  In cell AL16 is taking AH16, AI16, and AI16 and just creating the "box set" 112.  In cell AP16 you should see the number 29.  This incicates that there are only a total of 29 possible Pick 3 combinations for 112.  If you click the Tab labeled "AllMaps" and only select 112 from the filtered listing you will see all 29 Pick 3 combinations.

                    In the Tab "AllMaps" in the WorkoutsDeMapMidday Excel file I selected the box "000".  You can change this by clicking in the drop-down arrow in cell C1.  Currently it has an icon that looks like a funnel/filter.  If you click the icon a drop down list will appear where you can change the current box selection 000 to whatever is in the list at the bottom.

                      Avatar
                      USA
                      United States
                      Member #58396
                      February 13, 2008
                      314 Posts
                      Offline
                      Posted: August 10, 2013, 12:14 pm - IP Logged

                      Winsumloosesum, how difficult would it be to change MD draws to IL draws?  Thanks

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

                        Winsumloosesum, how difficult would it be to change MD draws to IL draws?  Thanks

                        Illinois Pick 3 Excel files:

                        Just follow the Instrustions from the Maryland post and also the Youtube video.

                        https://app.box.com/s/o3hmfoazwoa6v96x8ktv

                        https://app.box.com/s/a6m0wffxdslw8cg1vla0

                        https://app.box.com/s/ybmdgey7si9vppujwzqt

                        https://app.box.com/s/ndmbtuf7ad46aeeoe75r

                          butler863's avatar - Lottery-002.jpg
                          New Member
                          Bowling Green, Florida
                          United States
                          Member #83391
                          December 6, 2009
                          8 Posts
                          Offline
                          Posted: August 10, 2013, 3:24 pm - IP Logged

                          Thanks for the answering the instruction question. Any idea on my second question?

                            Avatar
                            USA
                            United States
                            Member #58396
                            February 13, 2008
                            314 Posts
                            Offline
                            Posted: August 10, 2013, 4:00 pm - IP Logged

                             Thanks winsumloosesum. Appreciate your help.

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5396 Posts
                              Offline
                              Posted: August 10, 2013, 5:34 pm - IP Logged

                              Can you PM me all the Pairs you want to track?

                              Thanls