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

Pick 3 SegSums System

Topic closed. 63 replies. Last post 3 years ago by itsme74.

Page 1 of 5
52
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: December 13, 2013, 7:58 am - IP Logged

A number of members have asked me to create an Excel file for their state.

It is somewhat time consuming to create 1 Excel file since the data is dependent on that states past draws.

If you decide to use the Excel file for your particular state it is important for you to own a fully functional version of Excel version 2007, 2010, or 2013.

I don't have a version of Excel 2013 but it should work.

I also created a Tutorial in Word and converted it to a PDF for those who don not have MS Word.

Here is the link to the folder with the Tutorial

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

I will post links to the Excel file for the states I have completed to date in the next post.

I also had some additional ideas for selecting range values and I will post them also.

    bootleg233's avatar - Lottery-034.jpg
    Tn
    United States
    Member #54963
    September 4, 2007
    1164 Posts
    Offline
    Posted: December 13, 2013, 8:01 am - IP Logged

    A number of members have asked me to create an Excel file for their state.

    It is somewhat time consuming to create 1 Excel file since the data is dependent on that states past draws.

    If you decide to use the Excel file for your particular state it is important for you to own a fully functional version of Excel version 2007, 2010, or 2013.

    I don't have a version of Excel 2013 but it should work.

    I also created a Tutorial in Word and converted it to a PDF for those who don not have MS Word.

    Here is the link to the folder with the Tutorial

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

    I will post links to the Excel file for the states I have completed to date in the next post.

    I also had some additional ideas for selecting range values and I will post them also.

    Thank you much winsum!!

    WHEN IT FEELS THE WHOLE WORLD SUCKS!

    RELAX.........IT'S ONLY GRAVITY Big Smile

    I think I can I think I can!!!!

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

      If anyone would like an Excel file for their state just PM me instead of posting a request in this thread.

      It will take time to create your states Excel program.  If you would like to make a donation for the time I would appreciate it

      Thanks.

      Make sure you have a fully functional version of Excel 2007, 2010, 2013

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

        I've added a couple minor features to the Excel program. The new version is 5

        "Pick3SegSumsv5"

        If you receive any error let me know. 

        Read the tutorial 1st before posting any questions.

        Here are the download links to the states I have completed so far:

        Florida (Combined draws)

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

         

        New York (Combined Draws)

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

         

        Missouri (Combined Draws)

        https://app.box.com/s/3mba7cayy95nopkqezdc

         

        Georgia (combined draws)

        https://app.box.com/s/3s57dimpn35qd6jkg9cu

         

        Texas (All 4 Draws)

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

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

          I created a Part 2 tutorial on additional ideas for selecting Levels and Range values along with creating Random Levels.

          Here is the link to the folder that contains the PDF's and Word docs. 

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

            ram's avatar - Lottery-002.jpg

            United States
            Member #11
            December 6, 2001
            75 Posts
            Offline
            Posted: December 13, 2013, 10:20 am - IP Logged

            Thanks for all your hard work Steve. I would like to make a donation. How can I go about doing that?

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: December 13, 2013, 2:17 pm - IP Logged
                lakerben's avatar - spherewall
                New Mexico
                United States
                Member #86099
                January 29, 2010
                11117 Posts
                Offline
                Posted: December 13, 2013, 2:23 pm - IP Logged

                Party

                How about them cowboys!

                 

                 

                US Flag

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5387 Posts
                  Offline
                  Posted: December 13, 2013, 4:05 pm - IP Logged

                  Here is the download link for Louisina:

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

                  Good luck!!

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

                    Massachusettes download: (Front 3 Midday/Front 3 Eve):

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

                     Levels 2, 5, 13, 24, 25

                    10 Picks for the evening draw:

                    162
                    182
                    202
                    229
                    282
                    292
                    368
                    668
                    828
                    967

                      wiljunior's avatar - fey
                      orlando,florida
                      United States
                      Member #148154
                      October 24, 2013
                      86 Posts
                      Offline
                      Posted: December 13, 2013, 10:00 pm - IP Logged

                      Massachusettes download: (Front 3 Midday/Front 3 Eve):

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

                       Levels 2, 5, 13, 24, 25

                      10 Picks for the evening draw:

                      162
                      182
                      202
                      229
                      282
                      292
                      368
                      668
                      828
                      967

                      ok, I hhave a poblem with mine.when I click on ADD NEW DRAWING,this is the error message I get.''CAN NOT RUN MICRO PICK3SEGSUMSV5.XLSM!RUNSEGMENT MULTI PLEDRWAS.THE MICRO  MAY NOT BE AVAIBLE IN THIS WORK BOOK OR ALL MICRO MAYBE DISABLED.

                      It is something i di wrong ?Please help me.thank you.

                        wiljunior's avatar - fey
                        orlando,florida
                        United States
                        Member #148154
                        October 24, 2013
                        86 Posts
                        Offline
                        Posted: December 13, 2013, 10:12 pm - IP Logged

                        never mine i got to work,but thanks!

                          MzDuffleBaglady's avatar - Lottery-018.jpg

                          United States
                          Member #81314
                          October 16, 2009
                          18985 Posts
                          Offline
                          Posted: December 13, 2013, 10:14 pm - IP Logged

                          I've added a couple minor features to the Excel program. The new version is 5

                          "Pick3SegSumsv5"

                          If you receive any error let me know. 

                          Read the tutorial 1st before posting any questions.

                          Here are the download links to the states I have completed so far:

                          Florida (Combined draws)

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

                           

                          New York (Combined Draws)

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

                           

                          Missouri (Combined Draws)

                          https://app.box.com/s/3mba7cayy95nopkqezdc

                           

                          Georgia (combined draws)

                          https://app.box.com/s/3s57dimpn35qd6jkg9cu

                           

                          Texas (All 4 Draws)

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

                          Thank you so much @ winsumloosesum

                           

                          I greatly appreciate it for Missouri.

                           


                          Good Luck.

                          The Struggle is real!

                            Avatar
                            Georgetown, DE
                            United States
                            Member #147534
                            October 5, 2013
                            59 Posts
                            Offline
                            Posted: December 13, 2013, 10:23 pm - IP Logged

                            How about Delaware, Please!!!!!!!!!!!!!!!!

                              wiljunior's avatar - fey
                              orlando,florida
                              United States
                              Member #148154
                              October 24, 2013
                              86 Posts
                              Offline
                              Posted: December 14, 2013, 1:16 am - IP Logged

                              I tried the new york one,it did not give me any number to play.Did  I do something wrong?