Welcome Guest
You last visited December 6, 2016, 4:15 am
All times shown are
Eastern Time (GMT-5:00)

# Lottaloot system set-up

Topic closed. 35 replies. Last post 11 years ago by ADB-23.

 Page 1 of 3
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 12:35 pm - IP Logged

I have decided to share my system since there are so many people requesting their state be done.  Now you can do your own.  If you can tweak this, please do so & let us all know.

Also, if you can share numbers within the forum that you obtain from this-Please do so.

To set up in excel
B1(DATE)
C1 (DRAW)
D1 (a) E1(b) F1(c)
Column G has been made to become width .17
Add to Column H1 thru M1 ( ab, ac, ba, bc, ca, cb )

O1(root)

P1(sum)

Q1(Doubles)

R1(pairs)

S1(Singles or “whatever you wish to call other pairs”)

T1( pairs)

Now for formulas

D2 =SUM(1*(LEFT(C2,1)))

E2=SUM(1*(MID(\$C2,2,1)))

F2=SUM(1*(MID(\$C2,3,1)))

H2=CONCATENATE(D2,E2)

I2=IF((CONCATENATE(D2,F2)=H2),"",CONCATENATE(D2,F2))

J2=IF((OR((CONCATENATE(E2,D2)=H2),(CONCATENATE(E2,D2)=I2))),"",CONCATENATE(E2,D2))

K2=IF((OR((CONCATENATE(E2,F2)=H2),(CONCATENATE(E2,F2)=I2),(CONCATENATE(E2,F2)=J2))),"",CONCATENATE(E2,F2))

L2=IF((OR((CONCATENATE(F2,D2)=H2),(CONCATENATE(F2,D2)=I2),(CONCATENATE(F2,D2)=J2),(CONCATENATE(F2,D2)=K2))),"",CONCATENATE(F2,D2))

M2=IF((OR((CONCATENATE(F2,E2)=H2),(CONCATENATE(F2,E2)=I2),(CONCATENATE(F2,E2)=J2),(CONCATENATE(F2,E2)=K2),(CONCATENATE(F2,E2)=L2))),"",CONCATENATE(F2,E2))

O2=IF((SUM((LEFT(\$C2,1)*1)+(MID(\$C2,2,1)*1)+(RIGHT(\$C2,1)*1)))>9,(SUM((LEFT((SUM((LEFT(\$C2,1)*1)+(MID(\$C2,2,1)*1)+(RIGHT(\$C2,1)*1))),1)*1)+(RIGHT((SUM((LEFT(\$C2,1)*1)+(MID(\$C2,2,1)*1)+(RIGHT(\$C2,1)*1))),1)*1))),(SUM((LEFT(\$C2,1)*1)+(MID(\$C2,2,1)*1)+(RIGHT(\$C2,1)*1))))

P2=SUM(D2:F2)

Q2 (**)

R2(Cnt)

Q3 thru Q13

00

11

22

33

44

55

66

77

88

99

R3 =COUNTIF(\$H\$2:\$M\$500,Q3) then copy down to R13

*note that you can change the range from 500 to whatever range you choose*

S2 (C)

T2 (Cnt)

T3 =COUNTIF(\$G\$2:\$M\$560,S3) then copy down to S47

Change Column U to a width of .17

V1 Label as Key numbers

To V2 thru V11 (add 0 thru 9)

W2 =COUNTIF(\$D\$2:\$F\$14,W2)

Copy down to W11

*note that I have chosen a range of 2wks.  The range within formula on W2 can be changed to whatever day selection that you choose*

Enjoy!

Credit for some formulas should be given to SirMetro

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: June 22, 2005, 1:09 pm - IP Logged

Credit for the origination of formulas I was involved in goes to all the great contributors here at LotteryPost. For without their insight, thoughts and ideas, I would have had no clue where to begin. And to Todd for providing a place where bums like myself can actually get a bit educated. I have even been able to utilize some of the programing ideas to enhance some of the work related projects I am doing.

Sir Metro

BTW...did I ever mention my real job sorta kinda requires me to show the US Government why a hammer really cost \$1,000? Now if I can just figure out how to convince my boss to cycle a bit extra of that into my pocket...damn...the cost of that hammer just went to \$1100!!!

BOSTON
United States
Member #48
September 9, 2001
3584 Posts
Offline
 Posted: June 22, 2005, 1:40 pm - IP Logged

for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 2:28 pm - IP Logged

for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

The formulas are already there.  All you have to do is copy & paste.

You must include the (=) as well when you copy.

Copy & paste.

If you have any questions, post it here & I will be happy to address.

I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one.

I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would.

SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that.

If someone can tell me how-I will post the info.

Minnesota
United States
Member #13028
March 28, 2005
870 Posts
Offline
 Posted: June 22, 2005, 2:32 pm - IP Logged

THANKS LOTTO!!!

I appreciate the efforts that you put forth!  You should be commended for work and thanked by all for a job well done!

Good Luck,

John (a.k.a. Atomic Dog)

BOW WOW WOW ......

...... YIPPY YOH YIPPY YAY!!!

Springfield,Ohio
United States
Member #14006
April 19, 2005
3972 Posts
Offline
 Posted: June 22, 2005, 2:32 pm - IP Logged

for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

The formulas are already there.  All you have to do is copy & paste.

You must include the (=) as well when you copy.

Copy & paste.

If you have any questions, post it here & I will be happy to address.

I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one.

I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would.

SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that.

If someone can tell me how-I will post the info.

Lottaloot,

Is this for Excel?

If it weren't for Vtracs and STXS where would we be?

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 2:50 pm - IP Logged

for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

The formulas are already there.  All you have to do is copy & paste.

You must include the (=) as well when you copy.

Copy & paste.

If you have any questions, post it here & I will be happy to address.

I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one.

I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would.

SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that.

If someone can tell me how-I will post the info.

Lottaloot,

Is this for Excel?

Yes!

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 2:59 pm - IP Logged

Dorothy A.K.A (lottery lady) wants to know how to do the system.

Perhaps I am not communicating like I should and would appreciate anyone who would like to say it in an understandable way.

In order to do this system

1. You have to set up a spreadsheet in excel exactly as I have posted above

2. Insert either separated or combined draw results into the draw section.

3. The sheet should do the rest--If not you need to copy down your formulas

4. Look at the key numbers section and find the numbers that have been drawn the least and the numbers drawn the most (if you see that 7 hasn't been drawn in 2wks-it's time to start thinking about using a 7 in your picks)

(If you see that 9 is the most frawn number-you may want to think about adding a 9 to your picks)

5.  If you do not understand from that point on--post for help in this thread!  (someone will help you)6.  I sort my pairs, doubles, & key numbers so that everything is in order.

That way I can pick out the most drawn as well as the least drawn of whatever I need to focus on.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 3:06 pm - IP Logged

Here's an example of my MI spreadsheet

 Date Eve Draw a b c ab ac ba bc ca cb root Sum Doubles Pairs Data singles Pairs Data 06/17/05 192 1 9 2 19 12 91 92 21 29 3 12 ** Cnt M Cnt 06/16/05 597 5 9 7 59 57 95 97 75 79 3 21 77 0 27 4 06/15/05 125 1 2 5 12 15 21 25 51 52 8 8 88 0 29 3 06/14/05 538 5 3 8 53 58 35 38 85 83 7 16 00 0 39 3 06/13/05 584 5 8 4 58 54 85 84 45 48 8 17 66 0 15 3 06/12/05 574 5 7 4 57 54 75 74 45 47 7 16 55 1 02 2 06/11/05 457 4 5 7 45 47 54 57 74 75 7 16 99 0 79 2 06/10/05 635 6 3 5 63 65 36 35 56 53 5 14 33 1 26 2 06/09/05 999 9 9 9 99 9 27 11 2 09 2 06/08/05 200 2 0 0 20 02 00 2 2 22 1 19 2 06/07/05 583 5 8 3 58 53 85 83 35 38 7 16 44 0 57 2

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 3:11 pm - IP Logged

Here's an example of my MI spreadsheet

 Date Eve Draw a b c ab ac ba bc ca cb root Sum Doubles Pairs Data singles Pairs Data 06/17/05 192 1 9 2 19 12 91 92 21 29 3 12 ** Cnt M Cnt 06/16/05 597 5 9 7 59 57 95 97 75 79 3 21 77 0 27 4 06/15/05 125 1 2 5 12 15 21 25 51 52 8 8 88 0 29 3 06/14/05 538 5 3 8 53 58 35 38 85 83 7 16 00 0 39 3 06/13/05 584 5 8 4 58 54 85 84 45 48 8 17 66 0 15 3 06/12/05 574 5 7 4 57 54 75 74 45 47 7 16 55 1 02 2 06/11/05 457 4 5 7 45 47 54 57 74 75 7 16 99 0 79 2 06/10/05 635 6 3 5 63 65 36 35 56 53 5 14 33 1 26 2 06/09/05 999 9 9 9 99 9 27 11 2 09 2 06/08/05 200 2 0 0 20 02 00 2 2 22 1 19 2 06/07/05 583 5 8 3 58 53 85 83 35 38 7 16 44 0 57 2

This will give you an idea of what it will end up looking like.

Not up to date of course

But looking at it, you can see that 27 would be the most freq pair

The pairs with 0 beside them are due pairs, etc.

roseville, MI
United States
Member #5980
July 30, 2004
18205 Posts
Offline
 Posted: June 22, 2005, 3:40 pm - IP Logged

Thanks Lottaloot

ALL IN!

Springfield,Ohio
United States
Member #14006
April 19, 2005
3972 Posts
Offline
 Posted: June 22, 2005, 3:40 pm - IP Logged

for those of us who cannot write to excel can you just post the program for us so we can enter our states numbers. I for one tried to set up the formula so I guess i am a dummy when it comes to that. thanks

The formulas are already there.  All you have to do is copy & paste.

You must include the (=) as well when you copy.

Copy & paste.

If you have any questions, post it here & I will be happy to address.

I do not have any idea of how I can set it up like that for you without sending a copy to everyone that requests one.

I will not do that.  But if there is any way that I could set it up here on the forum so that you could just insert the draw results I would.

SirMetro says that I can use the web space that I have here in order to set it up; But I do not know how to do that.

If someone can tell me how-I will post the info.

Lottaloot,

Is this for Excel?

Yes!

Thank you...

This should help a whole bunch...

If it weren't for Vtracs and STXS where would we be?

United States
Member #1987
August 5, 2003
8968 Posts
Offline
 Posted: June 22, 2005, 4:11 pm - IP Logged

WOW lottaloot, just by looking at the formulas, & the output that you have generated you have just allowed me to open a new chamber for my states & dates arrangement. Now I can clearly see why in your previous posts that 33 & 55 were due doubles pairs. And they still are... there is nothing like a fresh new perspective for an old theme.

Thanks !\$!\$

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: June 22, 2005, 4:39 pm - IP Logged

WOW lottaloot, just by looking at the formulas, & the output that you have generated you have just allowed me to open a new chamber for my states & dates arrangement. Now I can clearly see why in your previous posts that 33 & 55 were due doubles pairs. And they still are... there is nothing like a fresh new perspective for an old theme.

Thanks !\$!\$

Do share ole Doubles Queen...do share

Detroit, MI
United States
Member #8705
November 15, 2004
1396 Posts
Offline
 Posted: June 22, 2005, 4:57 pm - IP Logged

Thanks Lottoloot,

I appreciate you sharing your worksheet.

I ran into a problem:

The countif formulas that you have in Column R are not working for me.  Have I done something wrong.  The other formulas are working fine.