MollyG's Blog

Usually, when  I post a normula here, all you have to do is Copy/Paste it into Excel.  Then, remove the quotation mark at the beginning of each normula and it is ready to go.

You can do that 2 ways:  be in the box where the normula is

1) F2, HOME, arrow key Right 1 space, BACKSPACE (deleting the Qmark)Then hit ENTER and it is ready to go.

2) Where the normula appears in the Toolbar (top section), click mouse at the end of the normula, then do as explained above: HOME, right, BACKSPACE,ENTER

Best of luck to all

p.s.  SOMETIMES, there aren't Quotation Marks, therefore you won't need to do the above at all.  Sometimes, there will be......but, if they are there, then do the above

           1 (+/-)                        2 (+/-)                      3 (+/-)    

9	7	2
=MOD(A1+1,10)	=MOD(B1+2,10)	=MOD(C1-3,10)
=MOD(A1-1,10)	=MOD(B1+2,10)	=MOD(C1+3,10)
=MOD(A1-1,10)	=MOD(B1-2,10)	=MOD(C1-3,10)
=MOD(A1+1,10)	=MOD(B1+2,10)	=MOD(C1+3,10)
=MOD(A1-1,10)	=MOD(B1+2,10)	=MOD(C1-3,10)
=MOD(A1-1,10)	=MOD(B1-2,10)	=MOD(C1+3,10)
=MOD(A1+1,10)	=MOD(B1-2,10)	=MOD(C1+3,10)
=MOD(A1+1,10)	=MOD(B1-2,10)	=MOD(C1-3,10)

In Excel, working in 3 columns, type the last 2 draws (381/163) in A1, B1, C1,  AND A2,B2,C2.  Then type the normula below underneath each.

                 A                                B                                      C

3	8	1
1	6	3
=MOD(A1+A2,10)	=MOD(B1+B2,10)	=MOD(C1-C2,10)
=MOD(A1-A2,10)	=MOD(B1+B2,10)	=MOD(C1+C2,10)
=MOD(A1-A2,10)	=MOD(B1-B2,10)	=MOD(C1-C2,10)
=MOD(A1+A2,10)	=MOD(B1+B2,10)	=MOD(C1+C2,10)
=MOD(A1-A2,10)	=MOD(B1+B2,10)	=MOD(C1-C2,10)
=MOD(A1-A2,10)	=MOD(B1-B2,10)	=MOD(C1+C2,10)
=MOD(A1+A2,10)	=MOD(B1-B2,10)	=MOD(C1+C2,10)
=MOD(A1+A2,10)	=MOD(B1-B2,10)	=MOD(C1-C2,10)

Good Luck!

I didn't line up very good where the 381 and 163 belongs.

You should be able to Copy/Paste these normulas into the worksheet. PASTE THEM STARTING  IN    A3.   Type your numbers in the top 2 lines.

For 3 separate column (A1,B1,C1), Type/copy normula in each:

=MOD((INT(RAND()*10)+1),10)

For 1 column, type: =INT(RAND()*999) For other games, MegaMillion, etc: =INT(RAND()*52)+1     Where the "52" is, for any game, just insert the number of balls used in the drawing, and copy normula to 4,5 or 6 columns.      To change (generate) the pickings,  Click  F9       Everytime you use and X out, it will ask if you want to save.  No need to do this, except the FIRST time. Good luck!

AFTER NOON DRAWING, JANUARY 19,2005

(tried to put all in 1 blog, but kept getting an error)

3	7	8	46
6	7	8	41
3	4	7	39
2	8	9	36
0	2	8	35
2	7	9	35
4	6	9	35
1	5	8	34
1	6	9	33
4	6	7	33
1	5	9	32
3	4	5	32
3	6	7	32
5	6	9	32
6	7	9	32
0	5	7	31
1	4	8	31
2	4	8	31
4	5	8	31
0	4	6	30
0	4	9	30
2	3	5	30
2	6	9	30
3	8	9	30
5	7	8	30
7	8	9	30
0	2	7	29
0	3	4	29
0	5	8	29
0	6	9	29
1	2	5	29
1	2	6	29
1	4	5	29
1	4	6	29
1	5	6	29
1	5	7	29
1	7	9	29
2	3	6	29
2	3	7	29
2	3	9	29
0	1	4	28
0	1	7	28
0	1	9	28
0	2	6	28
0	3	8	28
0	3	9	28
1	3	6	28
1	8	9	28
4	5	6	28
0	1	8	27
0	2	3	27
1	2	3	27
1	3	7	27
1	7	8	27
2	6	7	27
2	6	8	27
3	6	9	27
4	7	8	27
4	8	9	27
0	1	2	26
0	4	7	26
0	4	8	26
0	5	9	26
0	6	8	26
1	3	4	26
1	3	8	26
1	3	9	26
1	4	7	26
1	6	7	26
2	3	4	26
3	4	9	26
3	5	6	26
5	8	9	26
0	1	5	25
0	1	6	25
0	3	5	25
0	8	9	25
2	4	6	25
2	4	7	25
2	7	8	25
3	4	8	25
3	5	8	25
4	6	8	25
6	8	9	25
0	2	5	24
0	3	6	24
0	5	6	24
0	6	7	24
1	2	4	24
1	2	9	24
1	6	8	24
2	5	8	24
5	6	7	24
5	7	9	24
0	2	4	23
0	7	8	23
1	2	7	23
2	5	7	23
3	5	7	23
0	1	3	22
0	7	9	22
0	2	9	21
2	4	5	21
2	5	6	21
4	4	6	21
4	5	7	21
0	3	7	20
1	2	8	20
1	4	9	20
1	6	6	20

AFTER NOON DRAWING, JANUARY 19, 2005

LAST HALF

1	8	8	20
1	9	9	20
2	4	9	20
2	5	9	20
2	7	7	20
3	3	7	20
3	5	9	20
4	6	6	20
0	4	5	19
3	4	6	19
3	6	8	19
4	5	9	19
4	7	9	19
1	1	7	18
1	3	5	18
2	3	8	18
3	3	4	18
5	6	8	18
6	6	9	18
0	0	3	17
0	4	4	17
0	5	5	17
1	1	9	17
3	7	9	17
4	9	9	17
5	5	8	17
0	3	3	16
0	6	6	16
1	1	8	16
3	7	7	16
7	7	9	16
7	9	9	16
0	0	4	15
0	0	5	15
0	0	9	15
0	2	2	15
1	4	4	15
3	3	9	15
3	9	9	15
4	4	7	15
5	6	6	15
0	0	1	14
2	2	3	14
2	2	4	14
2	2	6	14
4	4	8	14
4	5	5	14
5	5	9	14
5	8	8	14
1	1	5	13
2	3	3	13
2	9	9	13
3	3	5	13
3	4	4	13
3	8	8	13
7	7	8	13
8	9	9	13
0	7	7	12
0	8	8	12
1	2	2	12
2	2	8	12
2	5	5	12
2	8	8	12
5	7	7	12
6	6	8	12
6	8	8	12
0	0	2	11
0	0	6	11
0	1	1	11
2	6	6	11
3	6	6	11
5	9	9	11
1	1	6	10
2	2	7	10
3	5	5	10
4	7	7	10
0	9	9	9
1	1	4	9
1	5	5	9
6	7	7	9
0	0	7	8
0	0	8	8
1	1	3	8
1	3	3	8
2	2	2	8
3	3	3	8
4	8	8	8
6	6	7	8
0	0	0	7
2	4	4	7
3	3	6	7
3	3	8	7
4	4	9	7
5	5	7	7
6	9	9	7
1	1	2	6
1	7	7	6
2	2	5	6
2	2	9	6
4	4	4	6
5	5	5	6
5	5	6	6
7	8	8	6
8	8	8	6
8	8	9	5
4	4	5	4
1	1	1	2
6	6	6	2
7	7	7	2
9	9	9	0

Texas has had 47 triples since our Pick 3 began (10-25-93).    Mid day drawing started on 4-29-2002 (RED numbers). Those are posted in the blog below this one.

This Blog is a list of the Triples drawn in Texas' Pre-Test Drawings each day. There is a total of 60 in this set. (This was done by ME, so, I may have over-looked one or two...)

As you can see, we get a lot more in the PreTest Drawings than we do in the Final Draw.

 

             Date   Test#   TRIPLE

7/5/2000	1	666
7/18/2000	4	333
8/17/2000	2	555
9/4/2000	1	000
9/7/2000	4	777
9/26/2000	3	888
1/4/2001	1	666
1/26/2001	4	555
3/22/2001	4	777
8/18/2001	1	222
8/25/2001	4	999
9/18/2001	1	999
10/10/2001	4	999
10/29/2001	2	888
12/17/2001	4	000
3/6/2002	4	444
4/15/2002	2	888
6/27/2002	2	777
7/23/2002	4	999
8/19/2002	1	999
8/22/2002	4	555
8/23/2002	3	888
9/23/2002	1	777
10/2/2002	2	777
10/19/2002	4	444
11/4/2002	1	444
11/7/2002	1	111
11/20/2002	1	666
12/20/2002	2	444
12/24/2002	3	555
2/25/2003	4	666
4/2/2003	2	555
4/22/2003	1	555
4/30/2003	2	777
5/13/2003	4	999
6/6/2003	1	444
6/9/2003	3	999
9/17/2003	1	222
10/4/2003	4	999
10/7/2003	2	555
10/16/2003	1	555
11/15/2003	1	555
12/13/2003	1	111
12/23/2003	1	888
1/31/2004	3	555
1/31/2004	4	000
2/16/2004	4	111
3/4/2004	4	777
3/18/2004	3	000
4/1/2004	3	111
5/11/2004	1	555
6/9/2004	1	222
7/22/2004	2	888
9/10/2004	1	333
9/23/2004	2	000
9/29/2004	1	888
11/27/2004	3	777
1/5/2005	2	111
1/6/2005	1	444
1/12/2005	2	777

Mo	Day	Year
2	8	1994	2	2	2
9	1	1994	4	4	4
1	13	1995	2	2	2
2	2	1995	0	0	0
2	7	1995	5	5	5
1	8	1996	5	5	5
7	10	1996	4	4	4
9	21	1996	2	2	2
11	21	1996	7	7	7
1	28	1997	2	2	2
3	17	1997	1	1	1
5	14	1997	0	0	0
8	1	1997	4	4	4
10	13	1997	3	3	3
10	16	1997	8	8	8
2	12	1998	5	5	5
12	15	1998	3	3	3
1	29	1999	8	8	8
3	9	1999	1	1	1
6	3	1999	6	6	6
7	1	1999	8	8	8
10	23	1999	8	8	8
12	25	1999	6	6	6
12	30	1999	3	3	3
5	20	2000	0	0	0
1	1	2001	0	0	0
1	10	2001	3	3	3
2	24	2001	3	3	3
8	23	2001	3	3	3
9	21	2001	2	2	2
12	4	2001	3	3	3
1	14	2002	2	2	2
6	8	2002	0	0	0
8	13	2002	2	2	2
11	9	2002	4	4	4
2	26	2003	4	4	4
4	9	2003	7	7	7
6	13	2003	4	4	4
6	14	2003	0	0	0
6	18	2003	8	8	8
7	5	2003	8	8	8
8	6	2003	3	3	3
11	7	2003	2	2	2
2	20	2004	5	5	5
4	3	2004	0	0	0
4	14	2004	5	5	5
11	9	2004	5	5	5

Never 999 (only in PreTest)

12	22	2004	4	3	3	3	3	4	334	433		3	3	3	4	3	4	10
12	23	2004	4	3	8	3	4	8	348	438		3	4	3	8	4	8	15
12	23	2004	6	3	7	3	6	7	367	637		3	6	3	7	6	7	16
12	24	2004	3	3	2	2	3	3	233	332		2	3	2	3	3	3	8

I have an Excel spreadsheet, like the above example. It has 3 worksheets in it: (1) PICKS, (above)has pairs/sums and is continuing day/night (2)COMBO, lists all 220 numbers and dates of hits under them (3)#HITS, lists all 220 sets and how many times each has hit.

If anyone would like a copy, just PM me with you email address and I'll send it to you. 

THIS IS NOT A WORKOUT OR SYSTEM...only a record of all Pick 3 for Texas

Here are the most drawn numbers for Texas, as of noon 12-15-04

Numbers in series order (Blue)....# of times hit (Red)

2	7	9		35
4	6	9		35
2	8	9		36
3	4	7		38
6	7	8		41
3	7	8		45

12/6/2004	Test1	B*	A2*	A7*	A3*	3	4	8
	Test2	B*	A2*	A7*	A3*	5	2	6
	Test3	B*	A2*	A7*	A3*	5	4	9
	Test4	B*	A2*	A7*	A3*	2	5	8
						1	8	4
12/6/2004	Test1	B*	A4*	A8*	A2*	5	5	2
	Test2	B*	A4*	A8*	A2*	8	8	1
	Test3	B*	A4*	A8*	A2*	7	8	7
	Test4	B*	A4*	A8*	A2*	8	0	4
						9	8	3
12/7/2004	Test1	B*	A2*	A7*	A4*	1	4	1
	Test2	B*	A2*	A7*	A4*	2	3	9
	Test3	B*	A2*	A7*	A4*	9	7	3
	Test4	B*	A2*	A7*	A4*	0	9	9
						0	2	1
12/7/2004	Test1	B*	A8*	A3*	A5*	0	1	8
	Test2	B*	A8*	A3*	A5*	3	0	0
	Test3	B*	A8*	A3*	A5*	6	8	1
	Test4	B*	A8*	A3*	A5*	0	0	6
						8	4	5
12/8/2004	Test1	B*	A6*	A2*	A5*	6	0	0
	Test2	B*	A6*	A2*	A5*	1	5	1
	Test3	B*	A6*	A2*	A5*	7	2	8
	Test4	B*	A6*	A2*	A5*	2	4	2
						4	1	5
12/8/2004	Test1	B*	A2*	A1*	A6*	3	6	3
	Test2	B*	A2*	A1*	A6*	0	2	8
	Test3	B*	A2*	A1*	A6*	7	1	2
	Test4	B*	A2*	A1*	A6*	2	1	8
						2	0	0

TYPE THE FORMULA IN COLUMN D,  THEN COPY TO COLUMNS  E,F

A   B   C   D   E   F  (columns A-F)

0   0   0   =MOD(A2+A3,10).........COPY to Columns E,F

0   0   0   =MOD(A1+A2+A3,10).....COPY to Col  E,F

0   0   0   =MOD(D2+A4,10)..........COPY to Col E,F

0   0   0   =MOD(D1-D3,10)............COPY to Col E,F..this will be the

Unknown Number

For P4....insert a Col after C  AND Copy the normula to Col H