Who says you can't get a winner??

Reply #48

budward — Wed, 02 May 2007 05:11:57 GMT

You are welcome also LottoChica

Reply #47

LottoChica23 — Tue, 01 May 2007 14:10:55 GMT

Thanks budward

Reply #46

budward — Tue, 01 May 2007 03:32:36 GMT

You are welcome LL!!!

Good luck everyone

Reply #45

lottolaughs — Tue, 01 May 2007 01:50:22 GMT

Our good pal budward has made a terrific spreadsheet with this system and it is now available to all who are interested.

A great big hand for budward,thanks so much!!

Please PM me your email address and I will get it out to you,thanks!

Please do not post your email address on here,just a reminder to all! Thanks again

Reply #44

lottolaughs — Mon, 30 Apr 2007 13:32:30 GMT

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

Reply #43

Rakster — Mon, 30 Apr 2007 03:20:54 GMT

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 Hi... [ More ]

Reply #42

Rakster — Mon, 30 Apr 2007 01:52:36 GMT

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

Reply #41

Rakster — Mon, 30 Apr 2007 01:18:25 GMT

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.805... [ More ]

Reply #40

mazk — Mon, 30 Apr 2007 01:06:35 GMT

You are welcome LL

Reply #39

Rakster — Mon, 30 Apr 2007 01:04:25 GMT

Thank you

Reply #38

LottoChica23 — Mon, 30 Apr 2007 01:03:32 GMT

Sorry, left that one out...

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

Reply #37

Rakster — Mon, 30 Apr 2007 00:11:11 GMT

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

Reply #36

txpolo — Mon, 30 Apr 2007 00:06:01 GMT

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

Reply #35

LottoChica23 — Sun, 29 Apr 2007 23:43:50 GMT

You're quite welcome...

Reply #34

Rakster — Sun, 29 Apr 2007 23:41:30 GMT

This helps a lot!

Thank you for taking the time to explain it

Reply #33

LottoChica23 — Sun, 29 Apr 2007 23:02:42 GMT

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(SU... [ More ]

Reply #32

Rakster — Sun, 29 Apr 2007 21:46:07 GMT

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.

Reply #31

LottoChica23 — Sun, 29 Apr 2007 21:42:51 GMT

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.

Reply #30

lottolaughs — Sun, 29 Apr 2007 21:01:13 GMT

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... [ More ]

Reply #29

Rakster — Sun, 29 Apr 2007 20:54:37 GMT

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

Reply #28

lottolaughs — Sun, 29 Apr 2007 20:53:08 GMT

Just meant they were all squished when I was trying to read them as I was posting ,no biggie. I see them now,gotcha!

Okey dokey,now to be safe I would look at first 4/last 4. Sometimes the right digit sneaks in there, I hate that but that's what happens! Wish it could be that easy,first 3 last 3, geeze! Won't the lottery ever give us a break?? Let's see what happens now.

Reply #27

Rakster — Sun, 29 Apr 2007 20:47:34 GMT

The squished numbers are the numbers generated by dividing the 1.01 etc. As you can see, they are all done. Now what...lol... What numbers are we looking at... the first 3 and last 3

Reply #26

lottolaughs — Sun, 29 Apr 2007 20:45:35 GMT

Rakster,I take that back! You're numbers weren't squished in the original,just when I quoted it. Looks good

Reply #25

lottolaughs — Sun, 29 Apr 2007 20:44:17 GMT

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

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

Rakster,check these out for WC

Reply #24

lottolaughs — Sun, 29 Apr 2007 20:40:19 GMT

Rakster,you are cracking me up!! What are you doing over there,you silly?? You are too funny!

Some of your numbers look a little squished on here. Your next step would now be to take the

050776 and divide it by 1.01, 1.02, 1.03, 1.04 and 1.05.

Same with the 500226 and 555271.

That's probably why you weren't getting any hits in your earlier example. Try this now and see the difference. Let me know how you're coming along,okay? I know it's kind of difficult but you're getting it... [ More ]

Reply #23

mazk — Sun, 29 Apr 2007 20:00:01 GMT

Hello LL,

Now I know Where you were, cooking something good as usual :)

Here is my 2cents for WC :

INPUT276 550

535596

569809

172381

282669

171371

903769

602392

769610

169124

769719

174927

Good Luck

Reply #22

Rakster — Sun, 29 Apr 2007 18:55:48 GMT

Divided By1.011.021.031.041.05

28-Apr-07550817.821782178809.803921569801.941747573794.230769231786.666666667

27-Apr-07276273.26732673270.588235294267.961165049265.384615385262.857142857

050776 50273.2673349780.3921649297.0873848823.0769248358.09524

500226 495273.2673490417.6471485656.3107480986.5385476405.7143

555271 549773.2673544383.3333539098.0583533914.4231528829.5238

OK... here are the breakdowns for tonights draw... now whats next... LottoLaughs.. give me... [ More ]

Reply #21

Rakster — Sun, 29 Apr 2007 18:53:13 GMT

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

Reply #20

Rakster — Sun, 29 Apr 2007 18:46:39 GMT

Sorry.. all I divided was the 550276 by the 1.01, 1.02 etc....

I never dropped the v-trac and did the math.. I guess thats step two...lol Will try some inplimentations now... damn your demanding...hahahahaha, but if its gonna make me some cash I guess we have to go that extra mile right...hahaha I will post the next step when I get it...

Reply #19

Rakster — Sun, 29 Apr 2007 18:44:26 GMT

As you can see it doesn't for me... try it my way... high lite the whole area you want 9 decimal places after the decimal. I had to high lite my area, then click on the increase decimal sign a few times until I had 12 numbers showing.

LottoLaughs.. I did miss a step.. the conversion to V-tracs... not sure how to impliment that into the spreadsheet. I am not familiar with formula implimentations where one can convert a 5 to a 0 or a 1 to a 6 etc. I wishI knew how that could be done as those... [ More ]

Reply #18

LottoChica23 — Sun, 29 Apr 2007 18:01:26 GMT

I have already increased the numbers. There are 2 ways to do it, by formatting the individual cells: format/cells/number/decimal places and through the tools/options/edit/fixed decimal places.

I increased the number of decimal places both ways but any number after the 9th number after the decimal comes up as a zero for me

Reply #17

lottolaughs — Sun, 29 Apr 2007 17:50:11 GMT

I guess I'm getting a little confused here. So we're using your last 2 night's draws.

550276=

050776

500226

555271

Wait a second!! I think what's confusing me is I think you missed a step. First you have to convert your drawing numbers to the ones above. These would be the numbers that you now will divide by 1.01,1.02 etc. Is that what's going on

Reply #16

Rakster — Sun, 29 Apr 2007 17:39:07 GMT

What do you mean? The last two drawngs would be the just that... the last two drawings...lol

Here are the numbers I got for yesturday and friday... these will make up the numbers we look at for today in Western Canada...

Divided By1.011.021.031.041.05

28-Apr-07550817.821782178809.803921569801.941747573794.230769231786.666666667

27-Apr-072761231.683168321219.6078431371207.7669902911196.1538461541184.761904762

Now I need you to break these down for me...lol...

Reply #15

lottolaughs — Sun, 29 Apr 2007 17:35:15 GMT

Cool,thanks Rakster,hope that helps her out. Chica,where are ya???

Now how's about those 2 drawings you used so I can check out these calculations

Reply #14

Rakster — Sun, 29 Apr 2007 17:31:52 GMT

yes... all he has to do is... click on toolbar options in the area of the autosums etc. and he will see decimal increase or decimal decrease.

I am using the the two days prior to the draw for each set of numbers.

Reply #13

lottolaughs — Sun, 29 Apr 2007 17:28:08 GMT

Rakster said----- The decimals can be increased to what ever number you want.... I will run it up to 12 digits and post an example like above...

I overlooked what you said there! So you know how to increase the numbers?? Please let us know how you can do that,LottoChica is interested

Reply #12

lottolaughs — Sun, 29 Apr 2007 17:25:13 GMT

I'd love to see if they match but can you tell me what 2 draws you used? Thankya

Reply #11

lottolaughs — Sun, 29 Apr 2007 17:23:15 GMT

Hey Rak!

Hoping I can simplify this whole system some. The trouble with some of my formulas is that I find something that works,then I find something ELSE that works so I just kind of lay them all out on the table here. The thing I'm always taking into consideration is that not one formula will work for everyone so I try to give as many possibilities as I see fit.

This calculator is driving me nuts! When I punch in past draws to start writing something new it seems no matter what I d... [ More ]

Reply #10

Rakster — Sun, 29 Apr 2007 17:20:24 GMT

The decimals can be increased to what ever number you want.... I will run it up to 12 digits and post an example like above...

Divided By1.011.021.031.041.05

28-Apr-07550817.821782178809.803921569801.941747573794.230769231786.666666667

27-Apr-072761231.683168321219.6078431371207.7669902911196.1538461541184.761904762

26-Apr-079681617.821782181601.9607843141586.4077669901571.1538461541556.190476190

25-Apr-07666872.27722772863.725490196855.339805825847.115384615839.0476... [ More ]

Reply #9

Rakster — Sun, 29 Apr 2007 17:06:44 GMT

I see what your saying... I will mess around with it and see what I come up with.... I am not a pro at all with Excel but love crunching numbers...lol... self taught on what i do know...hahaaha

For each set of numbers I used for example... thursdays results and then add wednesdays results to get my number that needs to be divided by the 1.05 or whatever we used... thus generating a line of numbers to pick from for today. I never converted them to their mirror... in the works though... a lot

Reply #8

lottolaughs — Sun, 29 Apr 2007 16:55:07 GMT

Hi there ChicaChica!

I seem to recall budward got it to work as a 12 digit. Haven't heard from him lately,I'll PM and ask.

calling budward................come in budward......................

Hopefully he can tell us.

Reply #7

LottoChica23 — Sun, 29 Apr 2007 16:41:09 GMT

I had the same concern when putting this in a spreadsheet too. Because of the different calculation methods (Excel v. a 12 digit calculator) only the first four digits matched but the last four were different. After the 9th number after the decimal, I start to get zeroes...

I wonder if there is some way to force Excel to behave like a calculator

Reply #6

lottolaughs — Sun, 29 Apr 2007 12:27:03 GMT

Hello,Rakster,and WOW! Looks fantabulous!! You must have some genuine interest in this to go to all the trouble but you've got the right idea!!

My concern when I thought of putting this in a spreadsheet was the calculations. Since I used a 12 digit calculator,aren't our results going to be different? It looks like yours end at 7 numbers. I believe there is a way to set Excel to a 12 digit.

Also,which 2 draws were you using to get these numbers? Did you remember to make your new 3 numbers... [ More ]

Reply #5

Rakster — Sun, 29 Apr 2007 08:00:22 GMT

LottoLaughs...

I am working on a spreadsheet that we can copy and paste into it the past numbers and have it give us the breakdowns of each number when divided by the 1.01, 1.02, 1.03, 1.04, and 1.05

Iam trying to see if there is something there that we can use. I color coded the draws it hit and areas it hit but more testing has to me done. I have only taken it thru step one... adding the two previous numbers called and divided by the different variables. Here is an example of how or w... [ More ]

Reply #4

Rakster — Sat, 28 Apr 2007 17:18:15 GMT

thanks

Reply #3

lottolaughs — Sat, 28 Apr 2007 16:26:04 GMT

Here were your next 7 draws and mirrors,Rakster,sorry!

276/721

968/413

666/111

215/760

562/017

169/614

969/414

Reply #2

lottolaughs — Sat, 28 Apr 2007 16:24:08 GMT

Hey Rakster,how ya doin'?

Yes,I'm hoping that if you work with this you will be able to pinpoint which one will produce the most winners. Using your drawings from the 19th and 20th would have given these hits using just the 1.03 and 1.05--

051966/1.03 =

5045 1844 4898 0139 4755 4698 4617 9318 4482 0891

051966/1.05 =

4949 5714 4713 8775 4489 6452 4275 8049 4071 7665

501416/1.03 =

4868 0485 4726 0373 4588 0265 4455 1616 4325 6229

501416/1.05... [ More ]

Reply #1

Rakster — Sat, 28 Apr 2007 15:51:53 GMT

There may be a way of reducing the number of plays by just studying your post... dividing the numbers by 1.03 and 1.05 gave the most winners of all the sets combined... maybe just playing these sets would bring on the winners

Who says you can't get a winner??

lottolaughs — Sat, 28 Apr 2007 15:35:56 GMT

Hi kids!

This may all look like a bunch of mumbo jumbo but don't get discouraged. Of course this may take some time and your creativity but I'll give you the formula to work with.

Wish I could show an example for EVERY state but I picked GEORGIA today out of my hat so here goes--

Using April 19th and 20th drawings--

357

252

Let's line them up---

357252

Now we're going to make 3 new numbers for these by mirroring the first 2 numbers of each draw (3 and... [ More ]