Welcome Guest
Log In | Register )
You last visited January 17, 2017, 12:05 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 3 Block Party - Excel Program

Topic closed. 105 replies. Last post 7 years ago by foreverbad64.

Page 4 of 8
51
PrintE-mailLink
foreverbad64's avatar - 8ball
Sierra Vista
United States
Member #45120
August 14, 2006
44 Posts
Offline
Posted: November 29, 2009, 11:14 pm - IP Logged

I updated Arizona Pick 3 files with Saturday's drawing.

Here is the link with the updated zip:

http://www.box.net/shared/nmu6zmqic8

Hi Winsum

i download the updated zip and that was easy part...i'm still getting the #value and #name under systen file in certain areas as i stated above....i thank you for all your help and even tried using open office.org....i'm discouraged but still want to say thank you for your effort...i know it would have worked for me and i would have made $ with it....thanks again

GeorgeUS Flag

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Offline
    Posted: November 30, 2009, 11:26 am - IP Logged

    Updated "Systems" Excel file

    Corrected some errors in the Systems Excel file.

    Here are the download links to the zip files.

    If your state has a Midday and Evening draws download the Systems Midday and Evening Excel file below.

    If your state has just an Evening drawing download the the Systems Evening Only Excel file below.

     

    Download the correct file for you state (see above) and unzip the Excel file into the folder you created in the beginning.

    Select "yes" to replace the existing file when prompted.

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

    Midday and Evening "Systems" Excel file download link:

    http://www.box.net/shared/rjhr8dd4zf

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

    Evening Only Draws "Systems" Excel file download link:

    http://www.box.net/shared/9d9drsdl6x

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

    Instructions pdf file.

    http://www.box.net/shared/vykmlov7oz

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

    Note: If you downloaded Arizona just use the link I posted in the previous thread. Update through today.

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

    You will need to follow the instrutions in the pdf file to update the new "Systems" Excel file for your states draws.

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

    If you need help lle tme know!!

    Good Luck!!

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5396 Posts
      Offline
      Posted: November 30, 2009, 4:55 pm - IP Logged

      I was checking Pennsylvania and Florida Pick 3 1000 games and noticed that taking the group of Sums 12, 13, 14, and 15 shoud hit on average of every 3.3 drawings.

      Also, look at your states Sums history and look at how many drawings back since a Sum of 12, 13, 14, or 15 last hit.  If the current skip is at 4 or more don't play any of these Sums.

      Wait until any 1 of these Sums 12, 13, 14, or 15 hit.

      Again, if the current skip for this group of sums (12, 13, 14, 15) as a whole is at 4 or more DO NOT play this group. Wait for it to hit then play the next 3 to 4 days straight using the "Block Party" method or whatever method you want.

      You could also look at the previous 30 days draw group and look to see if either sum 12, 13, 14, or 15 did NOT hit.  

      You could play just the "no-match" 6-way combos for any sum that did NOT hit in the last 30 draw group.

      Most important is to look at your states draws and look at the 12, 13, 14, and 15 Sums and if the current skip is at 4 or more don't play. 

      Pennsylvania Pick 3 Evening draws is at a skip of 10.  The Sum 14 has not hit this month.

      Combinations to play: Doubles 077, 266, 338, 446, 455    No-Match 6 ways 059, 068, 149, 158, 167, 239, 248, 257, 347, 356

      The current skip of 10 that it is currently at has not gone past 10 in almost 500 draws.

      So is this group of sums going to hit tonight???

      The Un-Hit group of 220 is 077, 068, 239 for sum group 14

        Rakster's avatar - praying hands.jpg
        Saskatchewan
        Canada
        Member #19992
        August 9, 2005
        2867 Posts
        Offline
        Posted: December 1, 2009, 6:45 pm - IP Logged

        Thanks!

        We are all Lucky... just some of us don't realize it!

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

          I added a new tab in the "systems" Excel file called "Sums12To15SkipsChart".  The chart will show how many skips for sums 12 through 15 as a combined calculation of all 4 sums.  Look at the previous thread.  

          Here are the download links to all the states and Western Canada zip files previously requested in this thread.

          If you haven't done so create a new folder and name it whatever you want.

          Download your state or Western Canada file from the links below.

          Unzip the contents into your folder.  When the program prompts to replace existing files just click Yes.

          All drawings have updated through Thursday December 3, 2009


          Arizona

          http://www.box.net/shared/z21bj2lcpx

          Arizona (Excel 97 File)

          http://www.box.net/shared/r3boiolnex

          Florida

          http://www.box.net/shared/8q10cgf5an

          Georgia

          http://www.box.net/shared/l065ip7b54

          Michigan

          http://www.box.net/shared/dz62qy3g1g

          Missouri

          http://www.box.net/shared/647x288b4r

          New Mexico

          http://www.box.net/shared/fft7z0ium0

          New York

          http://www.box.net/shared/9z22n8nes2

          North Carolina

          http://www.box.net/shared/yp0mfx92hj

          Ohio

          http://www.box.net/shared/jsar521rup

          Pennsylvania

          http://www.box.net/shared/1isymupsb9

          South Carolina

          http://www.box.net/shared/4h3nuqg2t5

          Texas

          http://www.box.net/shared/g42ng9ab9h

          Western Canada

          http://www.box.net/shared/jcqjug13ka

           

          If you would like your state added let me know and I will upload them.

           

          Here is the link to the pdf instructions.

          http://www.box.net/shared/vykmlov7oz

            vjohnson8's avatar - Lottery-062.jpg
            fort
            United States
            Member #72407
            March 17, 2009
            6625 Posts
            Online
            Posted: December 4, 2009, 11:05 am - IP Logged

            could you please do illnios thank you vj8

            LET's get paid$$$$ money rollYes Nod

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5396 Posts
              Offline
              Posted: December 4, 2009, 11:35 am - IP Logged

              In he images below are for the new Tab "Sums12To15SkipChart"

              The first image below will show the currents "skips" for sums 12, 13, 14, and 15.  In cell range D11 you see the Sum Group 12-13-14-15 and to the right is the current skip for Westen Canada Pick 3.  As you can see in cell F11 the current skip is "1" meaning the last draw on Thursday, December 3rd (yesterday) was 2-7-6 so the Sum is 15 (2+7+6=15)

               

              As in most states the average skip for this group of sums is around 3.3 draws.  If you see the current skip at 4 or more don't play this sum group of 12 - 13 - 14 - 15.

              If the sum group skip is 3 or less play an individual sum group that is overdue like the sum 12 which has a skip of 37.  (see cell F4 in image above) Sum group 12 combinations would be 444, 066, 228, 255, 336, 039, 048, 057, 129, 138, 147, 156, 237, 246, 345.

              Or you could play the "Block Party" method and play 337, 355, 445 (Sum 13), 239, 248, 257, 347, 356 Sum(14), 346, 356, 456 (3 or 4 combos on 1 line) See image below for Western Canada Pick 3 "Sums12To15SystemEveningChart"

              The key is to NOT play if the Group Sum 12-13-14-15 has a skip of 4 or more.  Wait for this group to hit then play. 

              You can see from the image below the skips for this group for Westen Canada in the Tab "Sums12To15SkipChart" in cell range R20 through T40.

              So you can see from the image above that for the last 100 skips.  A skip of 1 (Previous drawing) has occured 37 times, a skip of 2 is 24, and skip of 3 is 11.  In the last 200 skips a skip of 1 (previous draw occured 62 times, skip of 2 occured 44 times and skip of 3 occured 25 times.  So you can see it would be best to play this group of sums (12 - 13 -14 -15) when the skip is at 1 or 2 which is the previous draw or the 2nd draw before.

              Looking at all the states.  The majority of skips for this group of sums is around 3.3 skips.

                brighteyes's avatar - o8fdxn
                milledgeville,Ga
                United States
                Member #68927
                January 2, 2009
                6102 Posts
                Offline
                Posted: December 4, 2009, 11:43 am - IP Logged

                sounds great!!! COULD YOU DO LOUISISANA PLEASE

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5396 Posts
                  Offline
                  Posted: December 4, 2009, 11:53 am - IP Logged

                  could you please do illnios thank you vj8

                  Illinois/Iowa download link:

                  http://www.box.net/shared/bgrykx7qse

                  1.  Create a new folder and name it whatever you want

                  2.  Unzip contents of the zip file into your new folder.

                  Instructions donload link:

                  http://www.box.net/shared/vykmlov7oz

                    jmill1948's avatar - Lottery-012.jpg
                    colonial heights
                    United States
                    Member #31712
                    February 2, 2006
                    12265 Posts
                    Offline
                    Posted: December 4, 2009, 11:57 am - IP Logged

                    I added a new tab in the "systems" Excel file called "Sums12To15SkipsChart".  The chart will show how many skips for sums 12 through 15 as a combined calculation of all 4 sums.  Look at the previous thread.  

                    Here are the download links to all the states and Western Canada zip files previously requested in this thread.

                    If you haven't done so create a new folder and name it whatever you want.

                    Download your state or Western Canada file from the links below.

                    Unzip the contents into your folder.  When the program prompts to replace existing files just click Yes.

                    All drawings have updated through Thursday December 3, 2009


                    Arizona

                    http://www.box.net/shared/z21bj2lcpx

                    Arizona (Excel 97 File)

                    http://www.box.net/shared/r3boiolnex

                    Florida

                    http://www.box.net/shared/8q10cgf5an

                    Georgia

                    http://www.box.net/shared/l065ip7b54

                    Michigan

                    http://www.box.net/shared/dz62qy3g1g

                    Missouri

                    http://www.box.net/shared/647x288b4r

                    New Mexico

                    http://www.box.net/shared/fft7z0ium0

                    New York

                    http://www.box.net/shared/9z22n8nes2

                    North Carolina

                    http://www.box.net/shared/yp0mfx92hj

                    Ohio

                    http://www.box.net/shared/jsar521rup

                    Pennsylvania

                    http://www.box.net/shared/1isymupsb9

                    South Carolina

                    http://www.box.net/shared/4h3nuqg2t5

                    Texas

                    http://www.box.net/shared/g42ng9ab9h

                    Western Canada

                    http://www.box.net/shared/jcqjug13ka

                     

                    If you would like your state added let me know and I will upload them.

                     

                    Here is the link to the pdf instructions.

                    http://www.box.net/shared/vykmlov7oz

                    how about goos ole virginia..... thanks win.........

                    when you do it do it right the first time...........

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5396 Posts
                      Offline
                      Posted: December 4, 2009, 12:01 pm - IP Logged

                      sounds great!!! COULD YOU DO LOUISISANA PLEASE

                      Louisina Download link.

                      http://www.box.net/shared/7upm1zrk8p

                      Just follow th instructions I just posted for Illinois/Iowa and download the pdf instructions form that thread.

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5396 Posts
                        Offline
                        Posted: December 4, 2009, 12:11 pm - IP Logged

                        how about goos ole virginia..... thanks win.........

                        Virginia download link:

                        Just followin the instructions on the previous threads.

                        http://www.box.net/shared/e15tm293b6

                          retxx's avatar - mrthumbs
                          BOSTON
                          United States
                          Member #48
                          September 9, 2001
                          3611 Posts
                          Offline
                          Posted: December 4, 2009, 10:07 pm - IP Logged

                          hi win question. I have the excel downloaded and i downloaded Fla draws but I still do not know how to enter them into the excel program. can you step by step me please. thanks. I am a layman when it comes to this.

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5396 Posts
                            Offline
                            Posted: December 4, 2009, 11:16 pm - IP Logged

                            hi win question. I have the excel downloaded and i downloaded Fla draws but I still do not know how to enter them into the excel program. can you step by step me please. thanks. I am a layman when it comes to this.

                            Go back a few posts and look for the pdf download with the instructions.

                              foreverbad64's avatar - 8ball
                              Sierra Vista
                              United States
                              Member #45120
                              August 14, 2006
                              44 Posts
                              Offline
                              Posted: December 5, 2009, 1:26 pm - IP Logged

                              Hi Winsum

                              Well problem again for me with Arizona system updated file....everything seems to be working fine except the tab labelled....Sums12To15SystemEveningChart....when i scroll down to L99-L117 thru AB99-AB117 this is what is in all those cells....#NAME and in V99-AB117 is same but in bold type....and under tab before and under Current months-Decembers hits i had to manually input 168 from 861 (last nights number)...and because of sums not coming out for five draws i didn't play but may tonight...thanks again

                              GeorgeUS Flag