Welcome Guest
Log In | Register )
You last visited January 17, 2017, 2:39 pm
All times shown are
Eastern Time (GMT-5:00)

Who says you can't get a winner??

Topic closed. 48 replies. Last post 10 years ago by budward.

Page 3 of 4
31
PrintE-mailLink
Avatar
Sunny California
United States
Member #40295
May 31, 2006
7713 Posts
Offline
Posted: April 29, 2007, 5:01 pm - IP Logged

Hopefully these won't looked squished... remember that a 0 at the beginning of the 50776 does not show up in Excel.. so the first breakdown should read...

050776

 

5077650273.2673349780.3921649297.0873848823.0769248358.09524
500226495273.2673490417.6471485656.3107480986.5385476405.7143
555271549773.2673544383.3333539098.0583533914.4231528829.5238

That's cool!! So you're all set for tonight now!

The one thing I was going to mention is that you are showing just the FIRST calculation so it will be interesting to see what hits just using the first line. In my original system I kept pressing the equal sign 4 more times after the first so you would wind up with a lot more lines. But let's see what happens over the week,I'll keep watch. 

I'm proud of what you did here,Rakster. You're pretty good with that excel!!

    LottoChica23's avatar - Aquarius
    Fughedaboutit (NY)
    United States
    Member #8160
    October 26, 2004
    6777 Posts
    Offline
    Posted: April 29, 2007, 5:42 pm - IP Logged

    Sorry guys... I screwed up ROYALLY..

    I have been adding the last two draws... 550 + 276 = 826 and then dividing them by 1.01... not placing then side by side... 550276 and dividing... back to the drawing board...

    Now, how do I get these numbers to gell together?

    To get them to gell, try this =+F2*1000+F3 where F2 is the cell address of the first 3 digit # and F3 is the cell address of the second number. 

    Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

    check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

    You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: April 29, 2007, 5:46 pm - IP Logged

      To get them to gell, try this =+F2*1000+F3 where F2 is the cell address of the first 3 digit # and F3 is the cell address of the second number. 

      Thanks LottoChica!!

       

      Is there something that we can slip the vtrac number in there to automatically create each individual number within the 3 digits to a v-trac number? 

      For example if I want the v-trac for the first 5 but leave the other two digits the same.

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

        LottoChica23's avatar - Aquarius
        Fughedaboutit (NY)
        United States
        Member #8160
        October 26, 2004
        6777 Posts
        Offline
        Posted: April 29, 2007, 7:02 pm - IP Logged

        Thanks LottoChica!!

         

        Is there something that we can slip the vtrac number in there to automatically create each individual number within the 3 digits to a v-trac number? 

        For example if I want the v-trac for the first 5 but leave the other two digits the same.

        First of all you have to isolate the 3 digit number into 3 separate digits...

        To isolate the 3 digits:

        The drawn number is in column B3

        To isolate the first digit, the formula in column C: =INT((B3)/100) 

        To isolate the Second digit, the formula in column D: =INT((B3-(C3*100))/10)

        To isolate the third digit, the formula in column E: =INT((B3-((C3*100)+(D3*10))))

         

        To Mirror the first and second digits in column F3:  

        This is for the Mirror of the first digit: =(+MOD(SUM(C3+5),10)*100)+(D3*10)+(E3)

        This is for the Mirror of the second digit: =(C3*100)+(+MOD(SUM(D3+5),10)*10)+(E3)

         

        Hope this helps

        Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

        check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

        You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

          Rakster's avatar - praying hands.jpg
          Saskatchewan
          Canada
          Member #19992
          August 9, 2005
          2867 Posts
          Offline
          Posted: April 29, 2007, 7:41 pm - IP Logged

          First of all you have to isolate the 3 digit number into 3 separate digits...

          To isolate the 3 digits:

          The drawn number is in column B3

          To isolate the first digit, the formula in column C: =INT((B3)/100) 

          To isolate the Second digit, the formula in column D: =INT((B3-(C3*100))/10)

          To isolate the third digit, the formula in column E: =INT((B3-((C3*100)+(D3*10))))

           

          To Mirror the first and second digits in column F3:  

          This is for the Mirror of the first digit: =(+MOD(SUM(C3+5),10)*100)+(D3*10)+(E3)

          This is for the Mirror of the second digit: =(C3*100)+(+MOD(SUM(D3+5),10)*10)+(E3)

           

          Hope this helps

          This helps a lot!

          Thank you for taking the time to explain it!!

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

            LottoChica23's avatar - Aquarius
            Fughedaboutit (NY)
            United States
            Member #8160
            October 26, 2004
            6777 Posts
            Offline
            Posted: April 29, 2007, 7:43 pm - IP Logged

            This helps a lot!

            Thank you for taking the time to explain it!!

            You're quite welcome... Wink

            Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

            check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

            You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

              txpolo's avatar - animaniacs16

              United States
              Member #173
              April 8, 2002
              6114 Posts
              Offline
              Posted: April 29, 2007, 8:06 pm - IP Logged

              Lotto Chica23,

              April 2007 - NY Midday 19 Hits

              April 2007 - NY Evening 9 Hits

              Wow that's a lot of hits.

              Could you share some off your systems?

              Thanks

               BananaWTG all Winner$. Hyper

               

               

                Rakster's avatar - praying hands.jpg
                Saskatchewan
                Canada
                Member #19992
                August 9, 2005
                2867 Posts
                Offline
                Posted: April 29, 2007, 8:11 pm - IP Logged

                First of all you have to isolate the 3 digit number into 3 separate digits...

                To isolate the 3 digits:

                The drawn number is in column B3

                To isolate the first digit, the formula in column C: =INT((B3)/100) 

                To isolate the Second digit, the formula in column D: =INT((B3-(C3*100))/10)

                To isolate the third digit, the formula in column E: =INT((B3-((C3*100)+(D3*10))))

                 

                To Mirror the first and second digits in column F3:  

                This is for the Mirror of the first digit: =(+MOD(SUM(C3+5),10)*100)+(D3*10)+(E3)

                This is for the Mirror of the second digit: =(C3*100)+(+MOD(SUM(D3+5),10)*10)+(E3)

                 

                Hope this helps

                Can you give me the formula for the 3rd digit to be changed to a vtrac?  I got the first two and got them working, but we have to change all 3 soI need a formula for that third digit... thank you so very much for all your help!

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

                  LottoChica23's avatar - Aquarius
                  Fughedaboutit (NY)
                  United States
                  Member #8160
                  October 26, 2004
                  6777 Posts
                  Offline
                  Posted: April 29, 2007, 9:03 pm - IP Logged

                  Sorry, left that one out...

                  =(C3*100)+(D3*10)+(+MOD(SUM(E3+5),10))

                  Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

                  check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

                  You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

                    Rakster's avatar - praying hands.jpg
                    Saskatchewan
                    Canada
                    Member #19992
                    August 9, 2005
                    2867 Posts
                    Offline
                    Posted: April 29, 2007, 9:04 pm - IP Logged

                    Sorry, left that one out...

                    =(C3*100)+(D3*10)+(+MOD(SUM(E3+5),10))

                    Thank you!

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

                      mazk's avatar - hand neg.jpg

                      United States
                      Member #7359
                      September 30, 2004
                      3910 Posts
                      Offline
                      Posted: April 29, 2007, 9:06 pm - IP Logged

                      You're awesome!! Thank you,mazk!! Your two cents usually turns into dollar signs!! 

                      $$$$$$$$$$$$$$$$$$$$$$$$$$$

                       

                       

                      Rakster,check these out for WC!!

                      You are welcome LL Sun Smiley

                      It is not What you play, it is How you play it !

                        Rakster's avatar - praying hands.jpg
                        Saskatchewan
                        Canada
                        Member #19992
                        August 9, 2005
                        2867 Posts
                        Offline
                        Posted: April 29, 2007, 9:18 pm - IP Logged

                        heres what the spreadsheet info looks like...

                        I got sets that have to be implimented but it is geared to use the last two sets to generate the combo's... All you have to do is cut and past your last 3 sets of numbers and it does all the rest!

                         

                         

                         Divided By1.011.021.031.041.05
                        28-Apr-07550817.82178218809.80392157801.94174757794.23076923786.66666667
                        27-Apr-072761231.683168321219.6078431371207.766990291196.153846151184.76190476
                        26-Apr-07968958.41584158949.019607843939.805825243930.769230769921.904761905
                            
                         
                        5505077650273.267326749780.392156949297.087378648823.076923148358.0952381
                        276500226495273.267327490417.647059485656.310680480986.538462476405.714286
                        968555271549773.267327544383.333333539098.058252533914.423077528829.523810
                        1st Digit Mirrored2nd Digit Mirrored3rd Digit Mirrored
                          
                        550050500555
                        276776226271

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

                          Rakster's avatar - praying hands.jpg
                          Saskatchewan
                          Canada
                          Member #19992
                          August 9, 2005
                          2867 Posts
                          Offline
                          Posted: April 29, 2007, 9:52 pm - IP Logged

                          heres what the spreadsheet info looks like...

                          I got sets that have to be implimented but it is geared to use the last two sets to generate the combo's... All you have to do is cut and past your last 3 sets of numbers and it does all the rest!

                           

                           

                           Divided By1.011.021.031.041.05
                          28-Apr-07550817.82178218809.80392157801.94174757794.23076923786.66666667
                          27-Apr-072761231.683168321219.6078431371207.766990291196.153846151184.76190476
                          26-Apr-07968958.41584158949.019607843939.805825243930.769230769921.904761905
                              
                           
                          5505077650273.267326749780.392156949297.087378648823.076923148358.0952381
                          276500226495273.267327490417.647059485656.310680480986.538462476405.714286
                          968555271549773.267327544383.333333539098.058252533914.423077528829.523810
                          1st Digit Mirrored2nd Digit Mirrored3rd Digit Mirrored
                            
                          550050500555
                          276776226271

                          9-2-5 was Sunday  Nights Number...

                          There it is in the 1.01 row... if you used the first 4 numbers, you have it...

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

                            Rakster's avatar - praying hands.jpg
                            Saskatchewan
                            Canada
                            Member #19992
                            August 9, 2005
                            2867 Posts
                            Offline
                            Posted: April 29, 2007, 11:20 pm - IP Logged

                            OK... Did some back testing on WCLC's numbers for the month of April up to tonights draw... Heres what i found...

                            Looking at the front 6 numbers (F) or back 6 numbers (B) I found the following hit patterns...

                            Column 1.01

                            4 FRONT --- 1 DOUBLE HIT

                            8 BACK

                            12 Hits

                            1.02

                            4 FRONT

                            9 BACK --- 3 DOUBLES HIT

                            13 Hits

                            1.03

                            2 FRONT -- 1 DOUBLE

                            4 BACK -- 2 DOUBLES

                            6 Hits

                            1.04

                            4 FRONT -- 1 DOUBLE

                            8 BACK

                            12 Hits

                            1.05

                            6 FRONT -- 2 DOUBLES

                            9 BACK

                            15 Hits

                            I never did a check on front 4 back 4 yet but will try to get that out once I have it.

                            To me, the WCLC would be best played using the last 6 numbers in row 1.05...

                            Now its time to narrow down what row we need to focus on... as rotating all 3 rows wouldn't be a sound financial investment.

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

                              Avatar
                              Sunny California
                              United States
                              Member #40295
                              May 31, 2006
                              7713 Posts
                              Offline
                              Posted: April 30, 2007, 9:32 am - IP Logged

                              Rakster,thanks for showing all your work here!

                              From my observations and backtesting with my own state, I would tend to agree that 1.05 and 1.01 are probably your best bets. I introduced 1.01 which you probably saw in my thread from a week or so ago. These divisions seem to work better then plain old 3.14 pi.

                               

                              New pies---

                              Other division numbers to consider dividing by in case you folks on working on any systems of your own---

                              3.666

                              3.66

                              3.1144

                              1.001

                              2.710

                              2.712

                              2.713

                              2.714

                              1.661188

                               

                              Sometimes when you double up regular pi it works better. Try them out kids!!