Welcome Guest
Log In | Register )
The time is now 2:13 pm
You last visited September 30, 2014, 2:10 pm
All times shown are
Eastern Time (GMT-5:00)

NJ Pick 3 System - Answer 4 Correct

Topic closed. 122 replies. Last post 2 years ago by winsumloosesum.

Page 7 of 9
53
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
4420 Posts
Online
Posted: January 17, 2013, 2:59 am - IP Logged

Steve as always so very impressed by your thought process and skills using Excel!  Thank you so much for thinking of us here at Lottery Post!  Great Job and please keep the great work and Ideas coming.  Oh by the way........ I don't see a sheet for Georgia?  Can we get one as well??  Wink

What version of Excel are you using?

    taiwanlottery's avatar - bonesonfire
    Taichung
    Taiwan
    Member #114120
    July 24, 2011
    2384 Posts
    Offline
    Posted: January 17, 2013, 3:09 am - IP Logged

    Hi Steve

    Havent had too much time on it but i have looked at it and im still trying to get the hang of it.

    Thanks again.

    Jack of all Games, Master of None!

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      4259 Posts
      Online
      Posted: January 17, 2013, 5:38 am - IP Logged

      9With a Standard membership, I don't think you can do it.

      Open Lotsoft, click the yellow button," Administrate Own Series".

      Click the "add Series for AllStates", you get this screenshot,

      To get the structures, goto Excel workbook. In column AB, enter the values for P7,P8,P9,P10, filter for each structure the values will be in Column A.

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        4420 Posts
        Online
        Posted: January 17, 2013, 1:47 pm - IP Logged

        Steve as always so very impressed by your thought process and skills using Excel!  Thank you so much for thinking of us here at Lottery Post!  Great Job and please keep the great work and Ideas coming.  Oh by the way........ I don't see a sheet for Georgia?  Can we get one as well??  Wink

        Here are the download links to the Georgia Pick 3 Excel files:

        Excel 2012 Version:

        https://www.box.com/s/bk00rb1yecg7t8d20sho

         

        Excel 1997 - 2003 Version:

        https://www.box.com/s/vdkyy8salylegf4d0dqb

          Avatar

          United States
          Member #111718
          May 31, 2011
          104 Posts
          Offline
          Posted: January 17, 2013, 3:56 pm - IP Logged
          Hello, stern, it's just an idea, I do not want to mess up your good work
          L = 1, 2.3
          M = 4, 5, 6.7
          H = 8, 9.0

           

          LLL

          27

          2,70

          37,0370

          2

          LLM

          36

          3,60

          27,7778

          3

          LLH

          27

          1

          37,0370

          4

          LML

          36

          3,60

          27,7778

          5

          LMM

          48

          4,80

          20,8333

          6

          LMH

          36

          3,60

          27,7778

          7

          LHL

          27

          2,70

          37,0370

          8

          LHM

          36

          3,60

          27,7778

          9

          LHH

          27

          2,70

          37,0370

          10

          MLL

          36

          3,60

          27,7778

          11

          MLM

          48

          4,80

          20,8333

          12

          MLH

          36

          3,60

          27,7778

          13

          MML

          48

          4,80

          20,8333

          14

          MMM

          64

          6,40

          15,6250

          15

          MMH

          48

          4,80

          20,8333

          16

          MHL

          36

          3,60

          27,7778

          17

          MHM

          48

          4,80

          20,8333

          18

          MHH

          36

          3,60

          27,7778

          19

          HLL

          27

          2,70

          37,0370

          20

          HLM

          36

          3,60

          27,7778

          21

          HLH

          27

          2,70

          37,0370

          22

          HML

          36

          3,60

          27,7778

          23

          HMM

          48

          4,80

          20,8333

          24

          HMH

          36

          3,60

          27,7778

          25

          HHL

          27

          2,70

          37,0370

          26

          HHM

          36

          3,60

          27,7778

          27

          HHH

          27

          2,70

          37,0370

          Not a result example = 458 = MMH
          Then 27 possibility or permutaçoes

          How is Steve = Stern?

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            4420 Posts
            Online
            Posted: January 17, 2013, 3:57 pm - IP Logged

            Updated the Virginia Pick 3 Excel file version 2010:

            https://www.box.com/s/pk1zjtyekllugje0p40p

              LottoBux's avatar - eye
              Ontario
              Canada
              Member #109247
              April 9, 2011
              23892 Posts
              Offline
              Posted: January 17, 2013, 7:37 pm - IP Logged

              LottoBux,

              Can you explain how you came up with the XBXB  ??

               

              Thanks

              CG

              Carli,

                It Was More Observational Than Mathematical.

                I noticed in Row 10 that the B was due,then in the Hit/Skip chart,the xBxB had a good hit ratio(Not the Highest,Nor the lowest) but had skipped 37 draws(Again,not the highest nor the lowest)

                I don't always go with the The Hottest or Coldest choice.

                If I had a second choice I probably would have went with BxxB         

                 

               

                 

                                     

                Avatar
                Florida
                United States
                Member #66575
                October 30, 2008
                3544 Posts
                Offline
                Posted: January 17, 2013, 7:43 pm - IP Logged

                Carli,

                  It Was More Observational Than Mathematical.

                  I noticed in Row 10 that the B was due,then in the Hit/Skip chart,the xBxB had a good hit ratio(Not the Highest,Nor the lowest) but had skipped 37 draws(Again,not the highest nor the lowest)

                  I don't always go with the The Hottest or Coldest choice.

                  If I had a second choice I probably would have went with BxxB         

                   

                 

                   

                Thanks for the explanation .

                Sometimes Im a little slow catching on, but I get there eventually .

                Really appreciate it.

                 

                Carlig

                  LottoBux's avatar - eye
                  Ontario
                  Canada
                  Member #109247
                  April 9, 2011
                  23892 Posts
                  Offline
                  Posted: January 17, 2013, 7:48 pm - IP Logged

                  Hi Steve,

                    Any Chance Of You Doing Up A File For Ontario?

                     I Have Excel 2010

                        Thanks In Advance...LB

                                         

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    4420 Posts
                    Online
                    Posted: January 17, 2013, 11:18 pm - IP Logged

                    Hi Steve,

                      Any Chance Of You Doing Up A File For Ontario?

                       I Have Excel 2010

                          Thanks In Advance...LB

                    LottoBux

                    Here is the Ontario Excel 2010 version:

                    https://www.box.com/s/0u0ghz5uwcup758fbmhu

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      4420 Posts
                      Online
                      Posted: January 17, 2013, 11:38 pm - IP Logged

                      I updated  Excel program today. 

                      I still need to update some of the other states / requests from previous days.

                      I will try and update the following states in the next couple days.

                      In the mean time you can use the Georgia or Ontario Excel file as an example.

                      Western Canada, Texas, Tennessee, Taiwan, Pennsylvania, New Mexico, North Carolina, Minnesota

                      I received a suggestion to add Even/Odd and Low/High.

                      You can use the Pick 3 sets that DO NOT have All Even, All Odd, All Low, All High.

                      I had this thought this morning of just picking the positions 7, 8, and 9 and not select the position 10.

                      Here is my idea:

                      1.  Select Positions 7, 8, and 9

                      2. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN".  Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2

                      3. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD".  Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2

                      4. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN".  You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd.

                      5. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD".  You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd.


                      One last thing I wanted to show you is that I created a new Tab labeled "1000Numbers3"

                      In this Tab will show you what numbers are out the longest based on how many past draws you want to use.

                      Click the Tab labeled "1000Numbers3"

                      Go to cell K12.  You should see 2000

                      2000 represents the total number of draws to analyze. 

                      You can change this to whatever number you want 2000, 1000, 500, etc.

                      Scroll over to cell columns CJ:CQ.

                      These are the Pick 3 numbers that have NOT been drawn based on what you entered in cell K12 (2000, 1000, 500 etc.)
                      Of corse the lower the number in cell K12 the more Pick 3 sets will appeat in these columns

                      In cell range CJ2 through CQ2 show how many Pick 3 sets are in each column.

                      Cell columns CJ through CQ are the Pick 3 sets with the 3rd position being an even digit

                      Cell columns CS through CZ are the Pick 3 sets with the 3rd position being an odd digit.

                      It would be interesting to see how many numbers are drawn over the course of the upcoming draws are over 2000, 1000 draws.


                      Let me know if you have any questions.

                      Steve

                        LottoBux's avatar - eye
                        Ontario
                        Canada
                        Member #109247
                        April 9, 2011
                        23892 Posts
                        Offline
                        Posted: January 18, 2013, 1:31 am - IP Logged

                        LottoBux

                        Here is the Ontario Excel 2010 version:

                        https://www.box.com/s/0u0ghz5uwcup758fbmhu

                        Thanks Steve

                          Really Appreciate All The Work That You Put Into This.It's getting late;I'll wait til 2morrow to dig into this program.

                                                                                          LB

                                               

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          4420 Posts
                          Online
                          Posted: January 18, 2013, 9:03 am - IP Logged

                          Tennessee Updates

                          Update later today

                            CARBOB's avatar - FL LOTTERY_LOGO.png
                            ORLANDO, FLORIDA
                            United States
                            Member #4924
                            June 3, 2004
                            4259 Posts
                            Online
                            Posted: January 18, 2013, 4:09 pm - IP Logged

                            I updated  Excel program today. 

                            I still need to update some of the other states / requests from previous days.

                            I will try and update the following states in the next couple days.

                            In the mean time you can use the Georgia or Ontario Excel file as an example.

                            Western Canada, Texas, Tennessee, Taiwan, Pennsylvania, New Mexico, North Carolina, Minnesota

                            I received a suggestion to add Even/Odd and Low/High.

                            You can use the Pick 3 sets that DO NOT have All Even, All Odd, All Low, All High.

                            I had this thought this morning of just picking the positions 7, 8, and 9 and not select the position 10.

                            Here is my idea:

                            1.  Select Positions 7, 8, and 9

                            2. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN".  Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2

                            3. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD".  Enter your Position 7, 8, 9 selections is cells AC2, AD2, AE2

                            4. Click the Tab at the bottom labeled "StakesWorkoutStraightsEVEN".  You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd.

                            5. Click the Tab at the bottom labeled "StakesWorkoutStraightsODD".  You have a few options as far as filtering Sets, Short Sums, Short Sums High, Short Sums Low, All Low/All High, All Even / All Odd.


                            One last thing I wanted to show you is that I created a new Tab labeled "1000Numbers3"

                            In this Tab will show you what numbers are out the longest based on how many past draws you want to use.

                            Click the Tab labeled "1000Numbers3"

                            Go to cell K12.  You should see 2000

                            2000 represents the total number of draws to analyze. 

                            You can change this to whatever number you want 2000, 1000, 500, etc.

                            Scroll over to cell columns CJ:CQ.

                            These are the Pick 3 numbers that have NOT been drawn based on what you entered in cell K12 (2000, 1000, 500 etc.)
                            Of corse the lower the number in cell K12 the more Pick 3 sets will appeat in these columns

                            In cell range CJ2 through CQ2 show how many Pick 3 sets are in each column.

                            Cell columns CJ through CQ are the Pick 3 sets with the 3rd position being an even digit

                            Cell columns CS through CZ are the Pick 3 sets with the 3rd position being an odd digit.

                            It would be interesting to see how many numbers are drawn over the course of the upcoming draws are over 2000, 1000 draws.


                            Let me know if you have any questions.

                            Steve

                            After looking at the Fl eve draws, you may not need anything but P789 and either Odd or Even. The pkg is about as evenly split as you will get. You will have to filter for single, doubles or trips.

                             

                             

                             

                            P789PKGHITSMEDMAXDUEAVGSKIP
                            BXXO631211066014.122
                            BXBO631181248114.4710
                            BBBO631171173114.608
                            XXXO621171256114.6016
                            BBBE631121066015.250
                            BBXO631111180215.3926
                            BXXE631101176215.5327
                            XBXE621081189115.8121
                            XXXE621081174015.811
                            XXBO6210610112016.113
                            BBXE631031184116.5813
                            XBBE621021196016.754
                            XBXO62991383417.2568
                            BXBE639212116018.576
                            XXBE62921374218.5729
                            XBBO62891571019.195

                             

                             

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              4420 Posts
                              Online
                              Posted: January 18, 2013, 6:30 pm - IP Logged

                              Tennessee Update:

                              Download Links:

                              Excel 1997 -2003 Version:

                              https://www.box.com/s/um64pldmg35pf03gcgau


                              Excel 2007 - 2010 Version:

                              https://www.box.com/s/c36zxmok2kb7gd854eps