winsumloosesum's Blog

Georgia Evening - July 2, 2005 - 4 0 0

	STRAIGHT	BOX	Drawing #	5	5	3	3	2	2
				R	IR	R	IR	R	IR
EVENING   DRAWINGS											EVENING DRAWING
Saturday,   July 02, 2005	400	004	1	0	0	0	0	0	0	STRAIGHT	NORMAL SEQUENCE
				0	0	0	0	0	0	BOX	NORMAL SEQUENCE
				0	0	0	0	0	0	STRAIGHT	PLUS 1 - 1st DIGIT
				0	0	0	1	0	0	BOX	PLUS 1 - 1st DIGIT
				0	0	0	0	0	0	STRAIGHT	MINUS 1 - 1st DIGIT
				0	0	0	0	0	0	BOX	MINUS 1 - 1st DIGIT
				0	0	0	0	0	0	STRAIGHT	PLUS 1 - 3rd DIGIT
				0	0	0	0	0	0	BOX	PLUS 1 - 3rd DIGIT
				0	0	0	0	1	0	STRAIGHT	MINUS 1 - 3rd DIGIT
				0	0	0	0	1	1	BOX	MINUS 1 - 3rd DIGIT
				5	5	3	3	2	2
				R	IR	R	IR	R	IR

PLUS 1   - 1st DIGIT	3 IRREGULAR	BOX	157	446	133	245	058	047	004	557	556	136
MINUS 1 - 3rd DIGIT	2 REGULAR	STRAIGHT	549	896	550	414	657	893	852	567	400	354
MINUS 1 - 3rd   DIGIT	2 REGULAR	BOX	459	689	055	144	567	389	258	567	004	345
MINUS 1 - 3rd DIGIT	2 IRREGULAR	BOX	559	068	135	036	018	045	004	577	077	257

	STRAIGHT	BOX	Drawing #	5	5	3	3	2	2
				R	IR	R	IR	R	IR
EVENING   DRAWINGS											EVENING DRAWING
Friday, July 01, 2005	531	135	1
Thursday, June 30, 2005	492	249	2		1					BOX	MINUS 1 - 1st DIGIT
Wednesday, June 29, 2005	525	255	3
Tuesday, June 28, 2005	933	339	4
Monday, June 27, 2005	556	556	5					1		BOX	PLUS 1 - 1st DIGIT
Monday, June 27, 2005	556	556	5					1		STRAIGHT	PLUS 1 - 3rd DIGIT
Monday, June 27, 2005	556	556	5					1		BOX	PLUS 1 - 3rd DIGIT
Sunday, June 26, 2005	145	145	6						1	STRAIGHT	PLUS 1 - 1st DIGIT
Saturday, June 25, 2005	409	049	7	1					1	BOX	PLUS 1 - 1st DIGIT
									1	STRAIGHT	PLUS 1 - 3rd DIGIT
				1					1	BOX	PLUS 1 - 3rd DIGIT
				5	5	3	3	2	2
				R	IR	R	IR	R	IR

Assuming Cell C is where you enter the 4 digit combo...

in cell D ...  =INT(C2/1000)

in cell E ...  =INT((C2-(D2*1000))/100)

in cell F ...  =INT((C2-((D2*1000)+(E2*100)))/10)

in cell G ...  =INT((C2-((D2*1000)+(E2*100)+(F2*10))))

(I have draw date and draw number in columns A and B)

Formula for determining if a digit is Odd or Even.

A1 = cell of the digit

=IF(MOD(A1,2)=1,"Odd","Even")

Thanks to Hypersoniq for these formulas.

Excel formulas for converting Pick 3 to individual cells

=INT(B2/100)

=INT((B2-(C2*100))/10)

=INT((B2-((C2*100)+D2*10)))

 

Excel formulas for converting Pick 4 to individual cells

Assuming Cell C is where you enter the 4 digit combo...

in cell D ...  =INT(C2/1000)

in cell E ...  =INT((C2-(D2*1000))/100)

in cell F ...  =INT((C2-((D2*1000)+(E2*100)))/10)