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

 50776 50273.3 49780.4 49297.1 48823.1 48358.1 500226 495273 490418 485656 480987 476406 555271 549773 544383 539098 533914 528830

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!!

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

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!

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

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!

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

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

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

WTG all Winner\$.

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!

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

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!

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

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

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 By 1.01 1.02 1.03 1.04 1.05 28-Apr-07 550 817.82178218 809.80392157 801.94174757 794.23076923 786.66666667 27-Apr-07 276 1231.68316832 1219.607843137 1207.76699029 1196.15384615 1184.76190476 26-Apr-07 968 958.41584158 949.019607843 939.805825243 930.769230769 921.904761905 5 5 0 50776 50273.2673267 49780.3921569 49297.0873786 48823.0769231 48358.0952381 2 7 6 500226 495273.267327 490417.647059 485656.310680 480986.538462 476405.714286 9 6 8 555271 549773.267327 544383.333333 539098.058252 533914.423077 528829.523810 1st Digit Mirrored 2nd Digit Mirrored 3rd Digit Mirrored 5 5 0 050 500 555 2 7 6 776 226 271

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

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 By 1.01 1.02 1.03 1.04 1.05 28-Apr-07 550 817.82178218 809.80392157 801.94174757 794.23076923 786.66666667 27-Apr-07 276 1231.68316832 1219.607843137 1207.76699029 1196.15384615 1184.76190476 26-Apr-07 968 958.41584158 949.019607843 939.805825243 930.769230769 921.904761905 5 5 0 50776 50273.2673267 49780.3921569 49297.0873786 48823.0769231 48358.0952381 2 7 6 500226 495273.267327 490417.647059 485656.310680 480986.538462 476405.714286 9 6 8 555271 549773.267327 544383.333333 539098.058252 533914.423077 528829.523810 1st Digit Mirrored 2nd Digit Mirrored 3rd Digit Mirrored 5 5 0 050 500 555 2 7 6 776 226 271

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!

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!

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!!

 Page 3 of 4