Welcome Guest
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
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

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

There's an error in your formula.

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

Manitoba
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

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: February 9, 2007, 10:25 am - IP Logged

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

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.

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

Manitoba
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.

Manitoba
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.

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

Manitoba
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

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

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.

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.

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.

 Page 1 of 2