Welcome Guest
Log In | Register )
You last visited December 8, 2016, 3:03 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 1 of 8
51
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: November 25, 2009, 4:55 pm - IP Logged

The link below contains a zip file with 2 Excel files and 1 Word doc with example from Florida Pick 3 draws.

I'll try to explain later with instructions.

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

1.  Create a new folder and unzip the 2 Excel files into this new folder.

Open the DrawHistory Excel file first.

Open the Systems Excel file second.

The system is based on boxed combos with sums of 12, 13, 14, 15 that have not hit in 220 draws.

So the 220 draws started the last day of October going backward 220 draws.

Looking for "Blocks" of combos from these sums that have NOT hit in 220 draws but are "clustered" on the chart either vertical or horizontal.

More to come!!

    Avatar
    Florida
    United States
    Member #66575
    October 30, 2008
    3549 Posts
    Offline
    Posted: November 25, 2009, 5:07 pm - IP Logged

    Wow Thanks Winsum

    This looks like another really good tool..

    Got it downloaded already

     

    Thanks

    CarliG

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: November 25, 2009, 5:11 pm - IP Logged

      Thanks!

      Question... where do I enter Western Canada's numbers?

      Is there a place of adding 1 night?

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

        CARBOB's avatar - FL LOTTERY_LOGO.png
        ORLANDO, FLORIDA
        United States
        Member #4924
        June 3, 2004
        5901 Posts
        Offline
        Posted: November 25, 2009, 5:29 pm - IP Logged

        The link below contains a zip file with 2 Excel files and 1 Word doc with example from Florida Pick 3 draws.

        I'll try to explain later with instructions.

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

        1.  Create a new folder and unzip the 2 Excel files into this new folder.

        Open the DrawHistory Excel file first.

        Open the Systems Excel file second.

        The system is based on boxed combos with sums of 12, 13, 14, 15 that have not hit in 220 draws.

        So the 220 draws started the last day of October going backward 220 draws.

        Looking for "Blocks" of combos from these sums that have NOT hit in 220 draws but are "clustered" on the chart either vertical or horizontal.

        More to come!!

        Steve, I updated the mid draws and it doesn't show 780 as being hit today????

          CARBOB's avatar - FL LOTTERY_LOGO.png
          ORLANDO, FLORIDA
          United States
          Member #4924
          June 3, 2004
          5901 Posts
          Offline
          Posted: November 25, 2009, 8:39 pm - IP Logged

          Steve, I updated the mid draws and it doesn't show 780 as being hit today????

          formula

          http://www.mrexcel.com/forum/showthread.php?t=428880

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

            Updated files with Instructions in pdf.

            Create a new folder and unzip both Excel files into your new folder.

            You can name the folder anything you wish.

            http://www.box.net/shared/6ynbdx9rf3

             

            Happy Thanksgiving!!!

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

              Thanks!

              Question... where do I enter Western Canada's numbers?

              Is there a place of adding 1 night?

              Rakster,

              Below is a link for Western Canada.

              Updated files with WC draws including last evening. 

              Ready to go!!

              All calculations are completed.

              pdf instructions included.  Just apply instructions in pdf to Evening only draws.

              Create a new folder and name it whatever you like.  Unzip Excel files into your new folder.

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

               

              Happy Thanksgiving!!

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

                Updated files with Instructions in pdf.

                Create a new folder and unzip both Excel files into your new folder.

                You can name the folder anything you wish.

                http://www.box.net/shared/6ynbdx9rf3

                 

                Happy Thanksgiving!!!

                Forgot to mention this is for Florida Pick 3 Midday, Evening, and Combined draws.

                If anyone wants their state files let me know and I will upload them.

                Happy Thanksgiving!!

                  Avatar
                  Columbia, SC
                  United States
                  Member #81200
                  October 13, 2009
                  30 Posts
                  Offline
                  Posted: November 26, 2009, 11:11 am - IP Logged

                  Thanks, if you have time to upload SC I would be most appreciative.  This looks like a great program.  Many thanks.

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5387 Posts
                    Offline
                    Posted: November 26, 2009, 12:36 pm - IP Logged

                    Thanks, if you have time to upload SC I would be most appreciative.  This looks like a great program.  Many thanks.

                    Here is South Carolina

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

                     

                    Create new folder.  Unzip Excel files into this new folder.

                    pdf Instructions in the zip file.

                    Happy Thanksgiving!!

                      Avatar
                      New Member

                      United States
                      Member #73065
                      April 4, 2009
                      13 Posts
                      Offline
                      Posted: November 26, 2009, 2:14 pm - IP Logged

                      Can you provide NY? Thanks! Happy Thanksgiving..

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

                        Can you provide NY? Thanks! Happy Thanksgiving..

                        New York download link:

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

                          reddog's avatar - patch
                          Greensboro, North Carolina
                          United States
                          Member #1616
                          June 5, 2003
                          1287 Posts
                          Offline
                          Posted: November 26, 2009, 6:39 pm - IP Logged

                          North Carolina please and Happy Thanksgiving buddy.

                          US Flag

                            mcadoocharlotte's avatar - Lottery-059.jpg
                            greensboro, nc
                            United States
                            Member #52848
                            June 12, 2007
                            46 Posts
                            Offline
                            Posted: November 26, 2009, 9:33 pm - IP Logged

                            Can  you do NC please  Happy Thanksgiving.

                             

                                                                                mcadoocharlotte

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: November 27, 2009, 6:53 am - IP Logged

                              North Carolina please and Happy Thanksgiving buddy.

                              North Carolina

                              Download link:

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

                              1.  Create a new folder.  Name it whatever you like

                              2.  Download zip file from link above and unzip 3 files into this new folder.

                              pdf Instructions included.

                              Updated through Thursday November 26, 2009