PA daily pick 3 chart for Nov. '05
Draw Dates MID midV EVE eveV
11/01/2005 302 v413 377 v433
11/02/2005 157 v213 972 v533
11/03/2005 733 v344 327 v433
11/04/2005 359 v415 417 v523
11/05/2005 567 v123 009 v115
11/06/2005 644 v255 475 v531
11/07/2005 664 v225 443 v554
11/08/2005 117 v223 454 v515
11/09/2005 882 v443 997 v553
11/10/2005 482 v543 601 v212
11/11/2005 364 v425 323 v434
11/12/2005 769 v325 076 v132
11/13/2005 251 v312 751 v312
11/14/2005 379 v435 154 v215
11/15/2005 125 v231 470 v531
11/16/2005 416 v522 384 v445
11/17/2005 656 v212 612 v223
11/18/2005 188 v244 593 v154
11/19/2005 724 v335 573 v134
11/20/2005 476 v532 436 v542
11/21/2005 331 v442 377 v433
11/22/2005 740 v351 796 v352
11/23/2005 500 v111 281 v342
11/24/2005 852 v413 520 v131
11/25/2005 638 v244 853 v414
I hope that syats formatted... I have this in an excel sheet, so errors on my part are eliminated. I have the sheet going back to 1/1/05.
sheet is simple... by column...
A= draw date
B= mid-day results (as a 3 digit, makes grabbing results off PA webpage easier)
C= first digit of mid-day
D= second digit of mid-day
E= third digit of mid-day
F= v-trac of C
G= v-trac of D
H= v-trac of E
I= Evening results (as 3 digit)
J= first digit of evening
K= second digit of evening
L= third digit of evening
M= v-trac of J
N= v-trac of K
O= v-trac of L
row 1 is for column headings...
row 2 formulas so you can build your own, if interested... (for columns with a formula, it will be given, manual entry columns will have an explaination surrounded by ***, for example *** info *** )
also, formulas can be autofilled down to make life real easy ;-)
A2 *** enter the draw date ***
B2 *** enter the mid-day result, as a 3 digit, example 234 ***
C2 =INT(B2/100)
D2 =INT((B2-(C2*100))/10)
E2 =INT((B2-((C2*100)+D2*10)))
F2 =IF(OR(C2=0,C2=5),1,IF(OR(C2=1,C2=6),2,IF(OR(C2=2,C2=7),3,IF(OR(C2=3,C2=8),4,5))))
G2 =IF(OR(D2=0,D2=5),1,IF(OR(D2=1,D2=6),2,IF(OR(D2=2,D2=7),3,IF(OR(D2=3,D2=8),4,5))))
H2 =IF(OR(E2=0,E2=5),1,IF(OR(E2=1,E2=6),2,IF(OR(E2=2,E2=7),3,IF(OR(E2=3,E2=8),4,5))))
I2 *** enter the evening result, as a 3 digit ***
J2 =INT(I2/100)
K2 =INT((I2-(J2*100))/10)
L2 =INT((I2-((J2*100)+K2*10)))
M2 =IF(OR(J2=0,J2=5),1,IF(OR(J2=1,J2=6),2,IF(OR(J2=2,J2=7),3,IF(OR(J2=3,J2=8),4,5))))
N2 =IF(OR(K2=0,K2=5),1,IF(OR(K2=1,K2=6),2,IF(OR(K2=2,K2=7),3,IF(OR(K2=3,K2=8),4,5))))
O2 =IF(OR(L2=0,L2=5),1,IF(OR(L2=1,L2=6),2,IF(OR(L2=2,L2=7),3,IF(OR(L2=3,L2=8),4,5))))
things to remember...
1. don't worry about excel not showing leading zeros (ex. 005 shows up as 5), the formulas handle this.
2. copy and paste the formulas into the cells EXACTLY, including the leading =
3. have a better or easier way to do anything listed above, please share, I am by no means an expert ;-)