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

hi win would it be possible to download the front 3 for mass. as we do not separate 2 games but we payoff on the front 3. I think there might be some hits using it this way. Do you agree? thanks

Download link below:

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

Pdf instructions included in the zip file.

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

2.  Download and unzip contents of the zip file into this new folder

Not sure if you wanted front 3 for Midday and Evening draws so I included them.  Also combined front 3 midday and front 3 evening draws as a combined drawing.  You can play around with this one or disregard.

Read the previous posts and the pdf to get started.

Draws are updated through December 15, 2009

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: December 16, 2009, 8:41 am - IP Logged

    Do you have one for Kansas, please?

    Also, Arkansas just started its Cash-3 game yesterday - any possibility of a system with only 1 1/2 days of entries?

    Here is the download link for Kansas:

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

    Follow the instructions for setting up and downloading from the previous post(s).

    pdf instructions included in the zip file.  Additional stuff in previous posts also.

    As far as Arkansas.  Too early to track only 2 days worth of draws. 

    But what I did was simulate 2000 draws for Midday, 2000 draws for evening, and combined the Midday and Evening simultated draws to create a combined simulated draw of 4000 past drawings.

    Started entering the live draws in the Excel file.  Highlighted where the simulated draws started on the Midday, Evening, and Combined drawing Tabs.

    Interesting to see how this works out.

    Here is the download link for Arkansas if anyone is interested:

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

      Winlotta's avatar - Lottery-001.jpg

      United States
      Member #60014
      April 3, 2008
      735 Posts
      Offline
      Posted: December 16, 2009, 10:25 am - IP Logged

      Here is the download link for Kansas:

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

      Follow the instructions for setting up and downloading from the previous post(s).

      pdf instructions included in the zip file.  Additional stuff in previous posts also.

      As far as Arkansas.  Too early to track only 2 days worth of draws. 

      But what I did was simulate 2000 draws for Midday, 2000 draws for evening, and combined the Midday and Evening simultated draws to create a combined simulated draw of 4000 past drawings.

      Started entering the live draws in the Excel file.  Highlighted where the simulated draws started on the Midday, Evening, and Combined drawing Tabs.

      Interesting to see how this works out.

      Here is the download link for Arkansas if anyone is interested:

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

      Noel Wow, winsumloosesum !!! 

      Thank you !!

      Patriot

      `|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|-|`

       


       

       

       



        United States
        Member #81843
        October 31, 2009
        856 Posts
        Offline
        Posted: December 20, 2009, 6:25 pm - IP Logged

        Noel Wow, winsumloosesum !!! 

        Thank you !!

        Winsum,

        I have a question about a feature of the Block Party workbook. On the Pairs 180 Draws

        Sheet, at the upper left of the worksheet at E-H, 1 & 2 cells is a prompt allowing to copy pairs. It says Click to Copy Pairs. Can you explain where the copied pairs are sent or reside and the purpose to do so? Can you give an example? I have not used this feature yet and am unsure of the consequences if any. Also, do I need to update the DrawHistory  file every draw and transfer to the systems Workbook on a diaily basis?

        Thanks,

        DD

          Avatar
          san diego
          United States
          Member #68237
          December 16, 2008
          97 Posts
          Offline
          Posted: December 20, 2009, 8:50 pm - IP Logged

          Noel Wow, winsumloosesum !!! 

          Thank you !!

          Can you do one for California. Thanks.

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

            Winsum,

            I have a question about a feature of the Block Party workbook. On the Pairs 180 Draws

            Sheet, at the upper left of the worksheet at E-H, 1 & 2 cells is a prompt allowing to copy pairs. It says Click to Copy Pairs. Can you explain where the copied pairs are sent or reside and the purpose to do so? Can you give an example? I have not used this feature yet and am unsure of the consequences if any. Also, do I need to update the DrawHistory  file every draw and transfer to the systems Workbook on a diaily basis?

            Thanks,

            DD

            You can delete this toolbar by right clicking the toolbar and select delete.  I should have deleted this for states that only have an evening drawing.  If you click it you will get an error message.  So just go ahead and delete it.

            You need to update your DrawHistory.  The click the Transfer Toolbar.  This will transfer drawings to the Systems file so you can update the Pairs, Pool Depth and other Tabs for your next drawing analysis.  

            Also update your draws by manually entering them into the Tab labeled "Sums12To15EveningChart" in column AS.  At the end of December you will need to start again. 

            So for example, if this was January 1, 2010 you should have all of December's draws in the DrawHistory file.  Then Transfer them to the Systems file.  In the Systems file go to the Tab labeled Draws scroll over to cell range Ab through AG where you will see a Toolbar "Copy Drawings To EDraws Worksheet.  Next go to the Tab labeled "Sums12To15EveningChart" and delete all the draws in cell column AS.  In cell AR1 change the month to January and then in cell AR5 enter 1/1/2010.  Next drag this box down so that it gives you all the draw dates for January 2010.  Remember do this on January 1, 2010 or after the last drawing in December.

            Hope this answers your questions.

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: December 21, 2009, 12:32 am - IP Logged

              Can you do one for California. Thanks.

              Below is the download link for California zip file:

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

              1.  Create a new folder.  Name this new folder anything you like.

              2.  Download the zip file and unzip into your new folder.

              3.  pdf instructions included in the zip file

                retxx's avatar - mrthumbs
                BOSTON
                United States
                Member #48
                September 9, 2001
                3593 Posts
                Offline
                Posted: December 21, 2009, 10:53 am - IP Logged

                in the 12 to 15 chart in column au where it lists the sums mine are blank. why/ thanks

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

                  in the 12 to 15 chart in column au where it lists the sums mine are blank. why/ thanks

                  This is an update to the "Systems" Excel file. 

                  IMPORTANT:!!! This is for only the States that have an Evening drawing only and NO Midday drawing.

                  Download the following zip file

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

                  Unzip the contents into the folder you created.

                  Click YES when prompted to replace.

                  You can wait until the beginning of January 2010 if you wish.

                  The "Systems" Excel file has a new Toolbar in the tab labeled "Draws" to copy and paste 180 pairs.

                    Raven62's avatar - binary
                    New Jersey
                    United States
                    Member #17843
                    June 28, 2005
                    49767 Posts
                    Offline
                    Posted: December 29, 2009, 5:50 am - IP Logged

                    Thank You for the Pick 3 Block Party: Request New Jersey!

                    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 29, 2009, 10:57 am - IP Logged

                      Thank You for the Pick 3 Block Party: Request New Jersey!

                      Raven,

                      Download link for New Jersey Pick 3 "Block Party" zip

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

                      Pdf Instructions download link:

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

                      1.  Create a new folder (c:\) example: c:\Block Party New Jersey

                      2.  Download the zip file and unzip the 2 eaxcel files into your newly named folder.

                      All drawings are updated through Monday December 28 2009

                        donutbaker's avatar - DiscoBallGlowing
                        New Member
                        Louisville Kentucky
                        United States
                        Member #3995
                        March 11, 2004
                        11 Posts
                        Offline
                        Posted: December 29, 2009, 11:28 pm - IP Logged

                        Could you post a excel sheet for the state of Kentuky. It is midday and evening draw state. Thanks for the new pick 3 lottery program!

                         

                        Donutbaker

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

                          Could you post a excel sheet for the state of Kentuky. It is midday and evening draw state. Thanks for the new pick 3 lottery program!

                           

                          Donutbaker

                          Download link for Kentucky zip file:

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

                          Follow instructions from previous post.

                          Pdf instructions download:

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

                            foreverbad64's avatar - 8ball
                            Sierra Vista
                            United States
                            Member #45120
                            August 14, 2006
                            44 Posts
                            Offline
                            Posted: January 6, 2010, 11:44 pm - IP Logged

                            Hi Win

                            I have been trying to update the files now that we are in January per the instructions and either i'm doing them out of sequence or just confused...Could you help me for the state of Arizona....Thank You in advance

                            GeorgeUS Flag

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Offline
                              Posted: January 7, 2010, 8:04 am - IP Logged

                              Hi Win

                              I have been trying to update the files now that we are in January per the instructions and either i'm doing them out of sequence or just confused...Could you help me for the state of Arizona....Thank You in advance

                              Here is the updated Arizona Excel files.

                              Not sure if it was you that had a problem with the original files.

                              So here are 2 download links:

                              1.  Excel 97 version:

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

                              Or

                              2. Excel 2002 Version

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

                               

                              Replace existing files in your folder.

                              Drawings updated through yesterday Jan 6 2010

                              Good Luck!!