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

New WAy with spread sheet

Topic closed. 25 replies. Last post 10 years ago by paint1.

Page 1 of 2
PrintE-mailLink
Avatar
Mount Morris
United States
Member #46750
September 27, 2006
139 Posts
Offline
Posted: February 6, 2007, 10:57 am - IP Logged

All you out there try this if you haven't all ready,I been playing around it seems to work here in Mi

 

1:     in cell A-1   put your  3 digit in from sat middays draw

2:   in cell B1     put this in     =int(sqrt(A1)*2000)

3:  now play  first 3 digits and last 3 digits  you only have 2 sets to play for the week

Some thing else I am trying now ,I got my old software out that couldn't hit a number

I got my draws in it up to date and run it and let it give me one 3 digit to play say it gave me 236

Now I will not use  a   2  -   3  -  6   in next draw . Now I  take another software I got do the same and it

gives me 156     so now  i dont use these digits   now wheel the one's you have left 

0 - 4 - 7 - 8- 9   for boxed winner in next draw. I think we need to see what will not come instead of what will . I like fewer numbers to play and play more money on each number

that I do play for a bigger pay day. some of my thoughts I got 

    Avatar
    Manitoba
    Canada
    Member #5566
    July 11, 2004
    133 Posts
    Offline
    Posted: February 6, 2007, 7:59 pm - IP Logged

    There's an error in your formula.

      Avatar

      United States
      Member #41846
      June 23, 2006
      459 Posts
      Offline
      Posted: February 8, 2007, 6:59 pm - IP Logged

      Paint1

      when you say there is an error do you mean the formula was wrong or you get only 5 digits?

      depending on starting # you will get different quanity of numbers.

      with 5 #'s my assumption was to use center # in both combo. I haven't tested this yet.

       

      p8 

        Avatar
        Manitoba
        Canada
        Member #5566
        July 11, 2004
        133 Posts
        Offline
        Posted: February 8, 2007, 11:11 pm - IP Logged

        When I enter the formula into Excel it states the following:" microsoft found an error in the formula you entered. Do you want to accept the correction posted below." Yes or No

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: February 9, 2007, 10:25 am - IP Logged

          Try this link:

          http://rapidshare.com/files/15685275/Excel_Square_Root.xls 

            Rakster's avatar - praying hands.jpg
            Saskatchewan
            Canada
            Member #19992
            August 9, 2005
            2867 Posts
            Offline
            Posted: February 9, 2007, 10:45 am - IP Logged

            There's an error in your formula.

            Did you enter the "=" sign as well?  You have to have that in the formula as well. It worke in my spreadsheet.

              lottaloot's avatar - AvatarZ56
              Redford/MI
              United States
              Member #3396
              January 18, 2004
              4867 Posts
              Offline
              Posted: February 9, 2007, 9:59 pm - IP Logged
              684=52306

               So from MI midday number you get the above= 523, 306 

              Thanks hillbilly953 I will see what happens this week

              L ttaL   T

                Avatar
                Manitoba
                Canada
                Member #5566
                July 11, 2004
                133 Posts
                Offline
                Posted: February 10, 2007, 12:01 am - IP Logged

                Yes,  I did enter the '=' and when I accept microsoft's offer of a correction it does produce 4 to 5 numbers. But because microsoft is correcting hillbillys953 formula I'm not sure if the numbers it produces are the same as what hillbilly953 intends.

                  Avatar
                  Manitoba
                  Canada
                  Member #5566
                  July 11, 2004
                  133 Posts
                  Offline
                  Posted: February 10, 2007, 11:47 am - IP Logged

                  Thanks everyone, even with the correction I get the same results as lottaloot.

                    Avatar
                    Mount Morris
                    United States
                    Member #46750
                    September 27, 2006
                    139 Posts
                    Offline
                    Posted: February 10, 2007, 12:28 pm - IP Logged

                    yes thats what I got 523,306

                    but what I do is use SAT midday number in my cell then watch the  next week

                    for those 2 sets of numbers to play if I would of wheeled last sat digits I would of hit the 170

                    from them

                    Last sat midday 074  =     1     7     2   --  -       2    0   4    

                     024 hit mi md on 5th 

                    127 hit mi md  on6th

                    170 hit in Mi on 8th   it is from both sets

                      Avatar
                      Manitoba
                      Canada
                      Member #5566
                      July 11, 2004
                      133 Posts
                      Offline
                      Posted: February 10, 2007, 1:15 pm - IP Logged

                      Thanks for posting hillbilly. Wheeling Sat. numbers doesn't fly in WC but I'll play with it a bit & see what comes up. Thanks

                        Avatar
                        Mount Morris
                        United States
                        Member #46750
                        September 27, 2006
                        139 Posts
                        Offline
                        Posted: February 10, 2007, 2:14 pm - IP Logged

                        just did work out  now  156 came in on sat midday2/10/07

                        now these are to watch until next sat   249--979   these are for Mi both draws and if you like pairs

                        48---89---49  the pairs are from some other spread sheet I done they will hit one of them most of the time. but guessing the other digit to go with them????????

                        I sure don't want to play each pair and put all the other digits with them . 

                        all so if you wanted to you would wheel 2-4-9-7 for the week lets set back and see

                        what happens here  247-499,999

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

                          yes thats what I got 523,306

                          but what I do is use SAT midday number in my cell then watch the  next week

                          for those 2 sets of numbers to play if I would of wheeled last sat digits I would of hit the 170

                          from them

                          Last sat midday 074  =     1     7     2   --  -       2    0   4    

                           024 hit mi md on 5th 

                          127 hit mi md  on6th

                          170 hit in Mi on 8th   it is from both sets

                          I got a system off of ebay for $15 that generates 20 different combo's using a variety if 6 or 7 different numbers. if you use 7 numbers it creates 35 combo's and has a box winner garanteed if 3 of the 6 or 7 #'s are in your 6 or 7.... thing is doubles create a loser for you. If doubles are stale its the system to use... combine all numbers above it predicted -- 0,1,2,4,7 and another number and rotate them... that would have been 3 box hits over those 3 days. Something to think about.

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

                            Thanks for posting hillbilly. Wheeling Sat. numbers doesn't fly in WC but I'll play with it a bit & see what comes up. Thanks

                            I tired it with WC as well but with no luck soI tried some modifications... instead of multi. by the 2000 I changed that number to 1500... it gave me a straight hit with 396 for thursay. The whole 5 number set was 39629.... it had the 299 Friday number in there as well... but never fooled around with the doubles and rotating the numbers.

                            The doubles I am thinking would be only if a double number appears in the 5 # set... 3-9-6-2-9

                            9 appeared twice so double to play all week... 399, 299, 699

                            So $5 a day for the week would have been worth the shot even if they were played on the box plays.

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

                              Western Canada's Picks for Feb. 11-17 

                              The 5 digit number is 29163

                              291

                              163

                              If you want to rotate all 5 numbers into combinations without using any doubles, we get 10 different combo's to play...

                               10 combo(s)


                              123 126 129 136 139 169 236 239 269 369 

                              Personally I like the 9 to show tomorrow... and possibly the 2 but the chances of 9 popping up tomorrow look good.  Lets hope we get it right off the bat to start the weeks plays off right.

                              Last weeks numbers produced 2 winners 396 and 299 lets see if we can match that or even beat it this week.