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

Lottaloot system set-up

Topic closed. 35 replies. Last post 11 years ago by ADB-23.

Page 1 of 3
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: June 22, 2005, 12:35 pm - IP Logged

I have decided to share my system since there are so many people requesting their state be done.  Now you can do your own.  If you can tweak this, please do so & let us all know. 

Also, if you can share numbers within the forum that you obtain from this-Please do so. 

To set up in excel
B1(DATE) 
C1 (DRAW) 
D1 (a) E1(b) F1(c)
Column G has been made to become width .17
Add to Column H1 thru M1 ( ab, ac, ba, bc, ca, cb )

O1(root)

P1(sum)

Q1(Doubles)

R1(pairs)

S1(Singles or “whatever you wish to call other pairs”)

T1( pairs)

 

Now for formulas

D2 =SUM(1*(LEFT(C2,1)))

E2=SUM(1*(MID($C2,2,1)))

F2=SUM(1*(MID($C2,3,1)))

 

H2=CONCATENATE(D2,E2)

I2=IF((CONCATENATE(D2,F2)=H2),"",CONCATENATE(D2,F2))

J2=IF((OR((CONCATENATE(E2,D2)=H2),(CONCATENATE(E2,D2)=I2))),"",CONCATENATE(E2,D2))

K2=IF((OR((CONCATENATE(E2,F2)=H2),(CONCATENATE(E2,F2)=I2),(CONCATENATE(E2,F2)=J2))),"",CONCATENATE(E2,F2))

L2=IF((OR((CONCATENATE(F2,D2)=H2),(CONCATENATE(F2,D2)=I2),(CONCATENATE(F2,D2)=J2),(CONCATENATE(F2,D2)=K2))),"",CONCATENATE(F2,D2))

M2=IF((OR((CONCATENATE(F2,E2)=H2),(CONCATENATE(F2,E2)=I2),(CONCATENATE(F2,E2)=J2),(CONCATENATE(F2,E2)=K2),(CONCATENATE(F2,E2)=L2))),"",CONCATENATE(F2,E2))

 
 

O2=IF((SUM((LEFT($C2,1)*1)+(MID($C2,2,1)*1)+(RIGHT($C2,1)*1)))>9,(SUM((LEFT((SUM((LEFT($C2,1)*1)+(MID($C2,2,1)*1)+(RIGHT($C2,1)*1))),1)*1)+(RIGHT((SUM((LEFT($C2,1)*1)+(MID($C2,2,1)*1)+(RIGHT($C2,1)*1))),1)*1))),(SUM((LEFT($C2,1)*1)+(MID($C2,2,1)*1)+(RIGHT($C2,1)*1))))

P2=SUM(D2:F2)

 

Q2 (**)

R2(Cnt)

 

Q3 thru Q13

00

11

22

33

44

55

66

77

88

99

 

R3 =COUNTIF($H$2:$M$500,Q3) then copy down to R13

*note that you can change the range from 500 to whatever range you choose*

 

S2 (C)

T2 (Cnt)

S3 thru S47 (add your pairs)

T3 =COUNTIF($G$2:$M$560,S3) then copy down to S47

 

Change Column U to a width of .17

V1 Label as Key numbers

To V2 thru V11 (add 0 thru 9)

W2 =COUNTIF($D$2:$F$14,W2)

Copy down to W11

*note that I have chosen a range of 2wks.  The range within formula on W2 can be changed to whatever day selection that you choose*

 

Enjoy!  

 

Questions need to be asked within this thread so this everyone can benefit from the answers

Credit for some formulas should be given to SirMetro

    SirMetro's avatar - center
    East of Atlanta
    United States
    Member #6191
    August 11, 2004
    1389 Posts
    Offline
    Posted: June 22, 2005, 1:09 pm - IP Logged

    Credit for the origination of formulas I was involved in goes to all the great contributors here at LotteryPost. For without their insight, thoughts and ideas, I would have had no clue where to begin. And to Todd for providing a place where bums like myself can actually get a bit educated. I have even been able to utilize some of the programing ideas to enhance some of the work related projects I am doing.

    Sir Metro

    BTW...did I ever mention my real job sorta kinda requires me to show the US Government why a hammer really cost $1,000? Now if I can just figure out how to convince my boss to cycle a bit extra of that into my pocket...damn...the cost of that hammer just went to $1100!!!

      retxx's avatar - mrthumbs
      BOSTON
      United States
      Member #48
      September 9, 2001
      3584 Posts
      Offline
      Posted: June 22, 2005, 1:40 pm - IP Logged

      for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: June 22, 2005, 2:28 pm - IP Logged

        for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

        The formulas are already there.  All you have to do is copy & paste. 

        You must include the (=) as well when you copy. 

        Copy & paste. 

        If you have any questions, post it here & I will be happy to address.

        I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one. 

        I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would. 

        SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that. 

        If someone can tell me how-I will post the info.

          Atomic Dog's avatar - sniffer
          Minnesota
          United States
          Member #13028
          March 28, 2005
          870 Posts
          Offline
          Posted: June 22, 2005, 2:32 pm - IP Logged

          THANKS LOTTO!!!

          I appreciate the efforts that you put forth!  You should be commended for work and thanked by all for a job well done!

           

          Good Luck,

          John (a.k.a. Atomic Dog)

          BOW WOW WOW ......

          ...... YIPPY YOH YIPPY YAY!!!

            Shawnintennesse's avatar - British Pint_414_.jpg
            Springfield,Ohio
            United States
            Member #14006
            April 19, 2005
            3972 Posts
            Offline
            Posted: June 22, 2005, 2:32 pm - IP Logged

            for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

            The formulas are already there.  All you have to do is copy & paste. 

            You must include the (=) as well when you copy. 

            Copy & paste. 

            If you have any questions, post it here & I will be happy to address.

            I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one. 

            I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would. 

            SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that. 

            If someone can tell me how-I will post the info.

            Lottaloot,

            Is this for Excel?

            If it weren't for Vtracs and STXS where would we be?

              lottaloot's avatar - AvatarZ56
              Redford/MI
              United States
              Member #3396
              January 18, 2004
              4867 Posts
              Offline
              Posted: June 22, 2005, 2:50 pm - IP Logged

              for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

              The formulas are already there.  All you have to do is copy & paste. 

              You must include the (=) as well when you copy. 

              Copy & paste. 

              If you have any questions, post it here & I will be happy to address.

              I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one. 

              I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would. 

              SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that. 

              If someone can tell me how-I will post the info.

              Lottaloot,

              Is this for Excel?

              Yes!

               

                lottaloot's avatar - AvatarZ56
                Redford/MI
                United States
                Member #3396
                January 18, 2004
                4867 Posts
                Offline
                Posted: June 22, 2005, 2:59 pm - IP Logged

                Dorothy A.K.A (lottery lady) wants to know how to do the system.

                Perhaps I am not communicating like I should and would appreciate anyone who would like to say it in an understandable way.

                In order to do this system

                1. You have to set up a spreadsheet in excel exactly as I have posted above

                2. Insert either separated or combined draw results into the draw section. 

                3. The sheet should do the rest--If not you need to copy down your formulas

                4. Look at the key numbers section and find the numbers that have been drawn the least and the numbers drawn the most (if you see that 7 hasn't been drawn in 2wks-it's time to start thinking about using a 7 in your picks)

                (If you see that 9 is the most frawn number-you may want to think about adding a 9 to your picks)

                5.  If you do not understand from that point on--post for help in this thread!  (someone will help you)6.  I sort my pairs, doubles, & key numbers so that everything is in order. 

                That way I can pick out the most drawn as well as the least drawn of whatever I need to focus on.

                 

                 

                 

                  lottaloot's avatar - AvatarZ56
                  Redford/MI
                  United States
                  Member #3396
                  January 18, 2004
                  4867 Posts
                  Offline
                  Posted: June 22, 2005, 3:06 pm - IP Logged

                  Here's an example of my MI spreadsheet

                  DateEve Drawabc  abacbabccacb  rootSum  DoublesPairs DatasinglesPairs Data
                  06/17/05192192  191291922129  312  **CntMCnt
                  06/16/05597597  595795977579  321  770274
                  06/15/05125125  121521255152  88  880293
                  06/14/05538538  535835388583  716  000393
                  06/13/05584584  585485844548  817  660153
                  06/12/05574574  575475744547  716  551022
                  06/11/05457457  454754577475  716  990792
                  06/10/05635635  636536355653  514  331262
                  06/09/05999999  99            927  112092
                  06/08/05200200  20  0200      22  221192
                  06/07/05583583  585385833538  716  440572


                    lottaloot's avatar - AvatarZ56
                    Redford/MI
                    United States
                    Member #3396
                    January 18, 2004
                    4867 Posts
                    Offline
                    Posted: June 22, 2005, 3:11 pm - IP Logged

                    Here's an example of my MI spreadsheet

                    DateEve Drawabc  abacbabccacb  rootSum  DoublesPairs DatasinglesPairs Data
                    06/17/05192192  191291922129  312  **CntMCnt
                    06/16/05597597  595795977579  321  770274
                    06/15/05125125  121521255152  88  880293
                    06/14/05538538  535835388583  716  000393
                    06/13/05584584  585485844548  817  660153
                    06/12/05574574  575475744547  716  551022
                    06/11/05457457  454754577475  716  990792
                    06/10/05635635  636536355653  514  331262
                    06/09/05999999  99            927  112092
                    06/08/05200200  20  0200      22  221192
                    06/07/05583583  585385833538  716  440572


                    This will give you an idea of what it will end up looking like. 

                    Not up to date of course

                    But looking at it, you can see that 27 would be the most freq pair

                    The pairs with 0 beside them are due pairs, etc.

                     

                      undress's avatar - Lottery-061.jpg
                      roseville, MI
                      United States
                      Member #5980
                      July 30, 2004
                      18205 Posts
                      Offline
                      Posted: June 22, 2005, 3:40 pm - IP Logged

                      Thanks Lottaloot

                      Mad ALL IN!Mad

                        Shawnintennesse's avatar - British Pint_414_.jpg
                        Springfield,Ohio
                        United States
                        Member #14006
                        April 19, 2005
                        3972 Posts
                        Offline
                        Posted: June 22, 2005, 3:40 pm - IP Logged

                        for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

                        The formulas are already there.  All you have to do is copy & paste. 

                        You must include the (=) as well when you copy. 

                        Copy & paste. 

                        If you have any questions, post it here & I will be happy to address.

                        I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one. 

                        I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would. 

                        SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that. 

                        If someone can tell me how-I will post the info.

                        Lottaloot,

                        Is this for Excel?

                        Yes!

                         

                        Thank you...

                        Your really apperciated..:)

                        This should help a whole bunch...

                        If it weren't for Vtracs and STXS where would we be?

                          LAVERNE MALONEY's avatar - smallgirl

                          United States
                          Member #1987
                          August 5, 2003
                          8968 Posts
                          Offline
                          Posted: June 22, 2005, 4:11 pm - IP Logged

                          WOW lottaloot, just by looking at the formulas, & the output that you have generated you have just allowed me to open a new chamber for my states & dates arrangement. Now I can clearly see why in your previous posts that 33 & 55 were due doubles pairs. And they still are... there is nothing like a fresh new perspective for an old theme. 

                              Thanks !$!$

                            lottaloot's avatar - AvatarZ56
                            Redford/MI
                            United States
                            Member #3396
                            January 18, 2004
                            4867 Posts
                            Offline
                            Posted: June 22, 2005, 4:39 pm - IP Logged

                            WOW lottaloot, just by looking at the formulas, & the output that you have generated you have just allowed me to open a new chamber for my states & dates arrangement. Now I can clearly see why in your previous posts that 33 & 55 were due doubles pairs. And they still are... there is nothing like a fresh new perspective for an old theme. 

                                Thanks !$!$

                            Do share ole Doubles Queen...do shareBig Smile

                              mybolade's avatar - praying hands.jpg
                              Detroit, MI
                              United States
                              Member #8705
                              November 15, 2004
                              1396 Posts
                              Offline
                              Posted: June 22, 2005, 4:57 pm - IP Logged

                              Thanks Lottoloot,

                               I appreciate you sharing your worksheet. 

                              I ran into a problem:

                              The countif formulas that you have in Column R are not working for me.  Have I done something wrong.  The other formulas are working fine.

                              Bolade'