winsumloosesum's Blog

	Digit #1	Digit #2
V1	0	5
V2	1	6
V3	2	7
V4	3	8
V5	4	9

To convert Vtrac to Digit combinations:

Example:  Vtrac  1  2  5

Vtrac 1 =  0 & 5

Vtrac 2 =  1 & 6

Vtrac 5 =  4 & 9

0  1  4

5  6  9

Digit Combinations:

014  019  064  069

514  519  564  569

 

A	B	C	D	E
111	222	333	444	555
112	113	114	115	224
144	244	155	255	355
455	122	133	233	225
334	335	445	223	344
123	124	125	135	145
245	345	134	234	235

000	111
001	112
002	113
003	114
004	115
005	111
006	112
007	113
008	114
009	115
011	122
012	123
013	124
014	125
015	121
016	122
017	123
018	124
019	125
022	133
023	134
024	135
025	131
026	132
027	133
028	134
029	135
033	144
034	145
035	141
036	142
037	143
038	144
039	145
044	155
045	151
046	152
047	153
048	154
049	155
055	111
056	112
057	113
058	114
059	115
066	122
067	123
068	124
069	125
077	133
078	134
079	135
088	144
089	145
099	155
111	222
112	223
113	224
114	225
115	221
116	222
117	223
118	224
119	225
122	233
123	234
124	235
125	231
126	232
127	233
128	234
129	235
133	244
134	245
135	241
136	242
137	243
138	244
139	245
144	255
145	251
146	252
147	253
148	254
149	255
155	211
156	212
157	213
158	214
159	215
166	222
167	223
168	224
169	225
177	233
178	234
179	235
188	244
189	245
199	255
222	333
223	334
224	335
225	331
226	332
227	333
228	334
229	335
233	344
234	345
235	341
236	342
237	343
238	344
239	345
244	355
245	351
246	352
247	353
248	354
249	355
255	311
256	312
257	313
258	314
259	315
266	322
267	323
268	324
269	325
277	333
278	334
279	335
288	344
289	345
299	355
333	444
334	445
335	441
336	442
337	443
338	444
339	445
344	455
345	451
346	452
347	453
348	454
349	455
355	411
356	412
357	413
358	414
359	415
366	422
367	423
368	424
369	425
377	433
378	434
379	435
388	444
389	445
399	455
444	555
445	551
446	552
447	553
448	554
449	555
455	511
456	512
457	513
458	514
459	515
466	522
467	523
468	524
469	525
477	533
478	534
479	535
488	544
489	545
499	555
555	111
556	112
557	113
558	114
559	115
566	122
567	123
568	124
569	125
577	133
578	134
579	135
588	144
589	145
599	155
666	222
667	223
668	224
669	225
677	233
678	234
679	235
688	244
689	245
699	255
777	333
778	334
779	335
788	344
789	345
799	355
888	444
889	445
899	455
999	555

Digit Vtrac
000 111
001 112
002 113
003 114
004 115
005 111
006 112
007 113
008 114
009 115
010 121
011 122
012 123
013 124
014 125
015 121
016 122
017 123
018 124
019 125
020 131
021 132
022 133
023 134
024 135
025 131
026 132
027 133
028 134
029 135
030 141
031 142
032 143
033 144
034 145
035 141
036 142
037 143
038 144
039 145
040 151
041 152
042 153
043 154
044 155
045 151
046 152
047 153
048 154
049 155
050 111
051 112
052 113
053 114
054 115
055 111
056 112
057 113
058 114
059 115
060 121
061 122
062 123
063 124
064 125
065 121
066 122
067 123
068 124
069 125
070 131
071 132
072 133
073 134
074 135
075 131
076 132
077 133
078 134
079 135
080 141
081 142
082 143
083 144
084 145
085 141
086 142
087 143
088 144
089 145
090 151
091 152
092 153
093 154
094 155
095 151
096 152
097 153
098 154
099 155
100 211
101 212
102 213
103 214
104 215
105 211
106 212
107 213
108 214
109 215
110 221
111 222
112 223
113 224
114 225
115 221
116 222
117 223
118 224
119 225
120 231
121 232
122 233
123 234
124 235
125 231
126 232
127 233
128 234
129 235
130 241
131 242
132 243
133 244
134 245
135 241
136 242
137 243
138 244
139 245
140 251
141 252
142 253
143 254
144 255
145 251
146 252
147 253
148 254
149 255
150 211
151 212
152 213
153 214
154 215
155 211
156 212
157 213
158 214
159 215
160 221
161 222
162 223
163 224
164 225
165 221
166 222
167 223
168 224
169 225
170 231
171 232
172 233
173 234
174 235
175 231
176 232
177 233
178 234
179 235
180 241
181 242
182 243
183 244
184 245
185 241
186 242
187 243
188 244
189 245
190 251
191 252
192 253
193 254
194 255
195 251
196 252
197 253
198 254
199 255
200 311
201 312
202 313
203 314
204 315
205 311
206 312
207 313
208 314
209 315
210 321
211 322
212 323
213 324
214 325
215 321
216 322
217 323
218 324
219 325
220 331
221 332
222 333
223 334
224 335
225 331
226 332
227 333
228 334
229 335
230 341
231 342
232 343
233 344
234 345
235 341
236 342
237 343
238 344
239 345
240 351
241 352
242 353
243 354
244 355
245 351
246 352
247 353
248 354
249 355
250 311
251 312
252 313
253 314
254 315
255 311
256 312
257 313
258 314
259 315
260 321
261 322
262 323
263 324
264 325
265 321
266 322
267 323
268 324
269 325
270 331
271 332
272 333
273 334
274 335
275 331
276 332
277 333
278 334
279 335
280 341
281 342
282 343
283 344
284 345
285 341
286 342
287 343
288 344
289 345
290 351
291 352
292 353
293 354
294 355
295 351
296 352
297 353
298 354
299 355
300 411
301 412
302 413
303 414
304 415
305 411
306 412
307 413
308 414
309 415
310 421
311 422
312 423
313 424
314 425
315 421
316 422
317 423
318 424
319 425
320 431
321 432
322 433
323 434
324 435
325 431
326 432
327 433
328 434
329 435
330 441
331 442
332 443
333 444
334 445
335 441
336 442
337 443
338 444
339 445
340 451
341 452
342 453
343 454
344 455
345 451
346 452
347 453
348 454
349 455
350 411
351 412
352 413
353 414
354 415
355 411
356 412
357 413
358 414
359 415
360 421
361 422
362 423
363 424
364 425
365 421
366 422
367 423
368 424
369 425
370 431
371 432
372 433
373 434
374 435
375 431
376 432
377 433
378 434
379 435
380 441
381 442
382 443
383 444
384 445
385 441
386 442
387 443
388 444
389 445
390 451
391 452
392 453
393 454
394 455
395 451
396 452
397 453
398 454
399 455
400 511
401 512
402 513
403 514
404 515
405 511
406 512
407 513
408 514
409 515
410 521
411 522
412 523
413 524
414 525
415 521
416 522
417 523
418 524
419 525
420 531
421 532
422 533
423 534
424 535
425 531
426 532
427 533
428 534
429 535
430 541
431 542
432 543
433 544
434 545
435 541
436 542
437 543
438 544
439 545
440 551
441 552
442 553
443 554
444 555
445 551
446 552
447 553
448 554
449 555
450 511
451 512
452 513
453 514
454 515
455 511
456 512
457 513
458 514
459 515
460 521
461 522
462 523
463 524
464 525
465 521
466 522
467 523
468 524
469 525
470 531
471 532
472 533
473 534
474 535
475 531
476 532
477 533
478 534
479 535
480 541
481 542
482 543
483 544
484 545
485 541
486 542
487 543
488 544
489 545
490 551
491 552
492 553
493 554
494 555
495 551
496 552
497 553
498 554
499 555
500 111
501 112
502 113
503 114
504 115
505 111
506 112
507 113
508 114
509 115
510 121
511 122
512 123
513 124
514 125
515 121
516 122
517 123
518 124
519 125
520 131
521 132
522 133
523 134
524 135
525 131
526 132
527 133
528 134
529 135
530 141
531 142
532 143
533 144
534 145
535 141
536 142
537 143
538 144
539 145
540 151
541 152
542 153
543 154
544 155
545 151
546 152
547 153
548 154
549 155
550 111
551 112
552 113
553 114
554 115
555 111
556 112
557 113
558 114
559 115
560 121
561 122
562 123
563 124
564 125
565 121
566 122
567 123
568 124
569 125
570 131
571 132
572 133
573 134
574 135
575 131
576 132
577 133
578 134
579 135
580 141
581 142
582 143
583 144
584 145
585 141
586 142
587 143
588 144
589 145
590 151
591 152
592 153
593 154
594 155
595 151
596 152
597 153
598 154
599 155
600 211
601 212
602 213
603 214
604 215
605 211
606 212
607 213
608 214
609 215
610 221
611 222
612 223
613 224
614 225
615 221
616 222
617 223
618 224
619 225
620 231
621 232
622 233
623 234
624 235
625 231
626 232
627 233
628 234
629 235
630 241
631 242
632 243
633 244
634 245
635 241
636 242
637 243
638 244
639 245
640 251
641 252
642 253
643 254
644 255
645 251
646 252
647 253
648 254
649 255
650 211
651 212
652 213
653 214
654 215
655 211
656 212
657 213
658 214
659 215
660 221
661 222
662 223
663 224
664 225
665 221
666 222
667 223
668 224
669 225
670 231
671 232
672 233
673 234
674 235
675 231
676 232
677 233
678 234
679 235
680 241
681 242
682 243
683 244
684 245
685 241
686 242
687 243
688 244
689 245
690 251
691 252
692 253
693 254
694 255
695 251
696 252
697 253
698 254
699 255
700 311
701 312
702 313
703 314
704 315
705 311
706 312
707 313
708 314
709 315
710 321
711 322
712 323
713 324
714 325
715 321
716 322
717 323
718 324
719 325
720 331
721 332
722 333
723 334
724 335
725 331
726 332
727 333
728 334
729 335
730 341
731 342
732 343
733 344
734 345
735 341
736 342
737 343
738 344
739 345
740 351
741 352
742 353
743 354
744 355
745 351
746 352
747 353
748 354
749 355
750 311
751 312
752 313
753 314
754 315
755 311
756 312
757 313
758 314
759 315
760 321
761 322
762 323
763 324
764 325
765 321
766 322
767 323
768 324
769 325
770 331
771 332
772 333
773 334
774 335
775 331
776 332
777 333
778 334
779 335
780 341
781 342
782 343
783 344
784 345
785 341
786 342
787 343
788 344
789 345
790 351
791 352
792 353
793 354
794 355
795 351
796 352
797 353
798 354
799 355
800 411
801 412
802 413
803 414
804 415
805 411
806 412
807 413
808 414
809 415
810 421
811 422
812 423
813 424
814 425
815 421
816 422
817 423
818 424
819 425
820 431
821 432
822 433
823 434
824 435
825 431
826 432
827 433
828 434
829 435
830 441
831 442
832 443
833 444
834 445
835 441
836 442
837 443
838 444
839 445
840 451
841 452
842 453
843 454
844 455
845 451
846 452
847 453
848 454
849 455
850 411
851 412
852 413
853 414
854 415
855 411
856 412
857 413
858 414
859 415
860 421
861 422
862 423
863 424
864 425
865 421
866 422
867 423
868 424
869 425
870 431
871 432
872 433
873 434
874 435
875 431
876 432
877 433
878 434
879 435
880 441
881 442
882 443
883 444
884 445
885 441
886 442
887 443
888 444
889 445
890 451
891 452
892 453
893 454
894 455
895 451
896 452
897 453
898 454
899 455
900 511
901 512
902 513
903 514
904 515
905 511
906 512
907 513
908 514
909 515
910 521
911 522
912 523
913 524
914 525
915 521
916 522
917 523
918 524
919 525
920 531
921 532
922 533
923 534
924 535
925 531
926 532
927 533
928 534
929 535
930 541
931 542
932 543
933 544
934 545
935 541
936 542
937 543
938 544
939 545
940 551
941 552
942 553
943 554
944 555
945 551
946 552
947 553
948 554
949 555
950 511
951 512
952 513
953 514
954 515
955 511
956 512
957 513
958 514
959 515
960 521
961 522
962 523
963 524
964 525
965 521
966 522
967 523
968 524
969 525
970 531
971 532
972 533
973 534
974 535
975 531
976 532
977 533
978 534
979 535
980 541
981 542
982 543
983 544
984 545
985 541
986 542
987 543
988 544
989 545
990 551
991 552
992 553
993 554
994 555
995 551
996 552
997 553
998 554
999 555

  The Parsel.exe Utility Program can be downloaded into the Pick532 Folder.  You don't need to unzip it.

 

If you downloaded this Utility into the Pick532 folder this is how I use it:

 

This is assuming you have created the following file names:  Data-5 and D5

 

1. Exit out of the Pick532 program

 

2.  You should see the C:\Pick532 (command prompt)

 

3. Type this next to c:\Pick532

 

4. Type the word: Parsel

 

5. Press Enter Key

 

6.  The Parsel Program should now open

 

7.  Select #5 (5 digit game)

 

8.  Enter the biggest number in game:  I entered 39 since I play PA 5/39

 

9.  So I entered 39 and pressed Enter

 

10.  Enter Data File to Parse:  My Data files are Data-5.  You can also type in D5 or Sim-5

 

11.  I typed in: Data-5 then pressed the Enter Key

 

12. Enter the name for the LOG file:  I use the default name by just pressing the Enter Key

 

The program will now Parse the Data-5 file for errors and will create a file named Data-5.log

 

Once the program finishes Parsing the Data-5 file you will get the following message:

 

13. Run this routine again Y/N:  I typed in N for no and pressed the Enter Key.

 

You can type in YES and run the Parse program again to Parse the D3 file to check for errors.

 

14.  After selecting N this will take you back to the Main Menu of the Parse Program

 

15.  Exit out of the Parsel Program by selecting "X"

 

16.  You should now see the following:

 

C:\Pick532  (The C designation is just your hard drive designation.  Whatever your Hard Drive designation assigned to your computer)

 

17. OK, so you should now be looking at the following:

 

C:\Pick532

 

18.  Type: 5

 

19.  Press the Enter Key

 

20.  This will reopen the Pick532 Program

 

21.  Press the ESC (Escape) Key to get to the Main Menu of the Pick532 Program

 

22.  You should now be at the Main Menu

 

Now we want to open the Editor to look at the Parsed log file(s) we created using the Parcel Program

 

23.  Press the "F2" Function Key

 

This will open the Editor Program

 

24.  Press or select E (For Edit)

 

25.  The cursor should now be positioned under the phrase that says: "File(s) to Edit"

 

26.  Press your Enter Key

 

27.  You should now see all the files in the Pick532 folder.

 

28.  Now look for on the right side of the listing of files.

 

29.  What you want to look for is the "log" file(s)

 

Remember these are the file(s) you created using the Parsel Program.

 

So if you Parsed the Data-5 file you should see the file "Data-5    log"

 

30.  Use the Down Arrow Key to highlight the File Data-5  log.

 

31.  Press the Enter Key

 

32.  The next screen should say: "Errors in Data-5":

 

Underneath it should give you the errors if the Parsel Program found any.

 

If there are errors it will give you the line number(s) of the file.

 

If there are NO errors it will just say: "No Errors Found"

 

33.  If there NO Errors just press the ESC (Escape Key)

 

34.  You will now see the Menu Bar appear at the top.

 

35.  There are letter designation for each item in the menu bar.

 

36.  Just press the "F" Key (File) and a drop-down menu will appear.  Again you can just use the letter designation. 

 

37.  Just press the "Q" Key (Quit)

 

38.  This will take you back to the Editor's Startup Screen.

 

39.  Select the letter designation "X" to "Exit to DOS"

 

40.  Press the ESC Key to completely Exit out of the Editor Program.

 

41.  You should now be back to the Pick532 Main Menu.

 

42.  So now you know your Data-5 file is correct with no errors.

 

Now  the following instructions are using the Pick532 Program for the first time:

 

1.  Ok you now know your Data-5 file is correct by using the Parse Program Utility.

 

2.  Open the Pick532 Program  (see instructions above)

 

3.  You should be at the Main Menu

 

We want to create a Simulated Data File (Sim-5)

 

4.  Press the "F9" Function Key  "Utilities (Stats)

 

5.  Press the letter "S"  (Simulate Data File)

 

6.  Enter the BIGGEST number in your lotto game: (Ex.: 35, 39, 49 etc.)

 

7.  For the sake of this example I typed in 39 and then press the Enter Key

 

8. Name of SIMulated File:  SIM-5  (Use this default file name, Don't change it)

 

9.  Press the Enter Key

 

10.  How many drawings to simulate:  (Default 10200)->  Use this default value of 10200

 

11.  Press the Enter Key

 

12.  Depending on the speed of your computer the program sill now simulate 10200 drawings and create a file named SIM-5

 

Now we want to combine the Data-5 file with the Sim-5 file and this will create the D5 File

 

13.  You should now be at the "Select the Utility" screen

 

14.  Select the letter "M"  (Make / Break / Position)

 

15.  Press the Enter Key

 

16.  You should be at the Screen:  "Select the Job"

 

17.  Press 1  (Make D5 without Least 5)

 

18.  Press the Enter Key

 

19.  Enter the name of the REAL DATA File: (Default: Data-5)>

 

20.  I use the default Data-5 and Press the Enter Key

 

21.  Enter the name of SIMulated File: (Default Sim-5)>

 

22.  Again, I use the default file name: Sim-5  Press the Enter Key

 

23.  Name the resulting file: (Default D5)>

 

24. Again, I use the default file name: D5  Press the Enter Key

 

25.  The next screen should say: "Successfully created D5 File!" 

 

 "Run this Routine Again Y/N"

 

26.  I selected N for NO

 

27.  This will take you back to the "Select a Utility" Menu

 

28.  Press or Select "X" to Exit

 

29.  This will take you back to the Main Screen "Lotto 532 Command and Control"

 

Now what we want to do is generate the reports using the D5 data file we created.

 

Remember the D5 Data file contains the combination of the Data-5 and the Sim-5 (simulated) files.

 

30.  Press the "F3" Function Key  "W5 Reporting"

 

31.  For how many drawings to plot the winning pattern: (100)->

 

What the program is asking is if you want to use the past 100 real state lottery drawings.

 

I just use the default value of 100 past drawings.

 

32.  Enter 100 or just press the Enter Key

 

33.  Enter Data File to Process:

 

Remember this is your Data-5 and Sim-5 combined file D5

 

34.  I Entered D5 and pressed the Enter Key

 

35.  How many drawings to analyze: (default: 10666) Note: this number may be different depending on how many Data-5 (actual drawings) and the Simulated Sim-5 drawings (10200). 

 

36.  I use the default value and Press the Enter Key

 

37.  Enter the name for the first file: (W5.1 or so) -> 

 

I just use the defaults W5.1  - Press the Enter Key

 

38.  Enter the name for the first file: (W5.2 or so) -> 

 

I just use the defaults W5.2 - Press the Enter Key

 

39.  Enter the name for the first file: (W5.3 or so) -> 

 

I just use the defaults W5.3- Press the Enter Key

 

40.  Enter the name for the first file: (W5.4 or so) -> 

 

I just use the defaults W5.4- Press the Enter Key

 

After you press the Enter Key the Program analyzes the "4 Layers"

 

Again depending on the speed of your computer the program will analyze your drawings and create 4 Reports W5.1, W5.2, W5.3, W5.4. 

 

The W5.X  The "X" at the end of the report is the Layer(s).  So we have 4 Layers or 4 Reports.  Each Report representing 1 of the 4 Layers.

 

42.  If everything ran properly you should see the following:

 

Success!  Run this Program Again (Y/N)

 

43.  I selected "N" for NO.

 

44.  This will take you back to the Main Command and Control Screen.

 

45.  Now you need to look at the W5.1, W5.2, W5.3 and W5.4 Reports

 

This is where you would examine at the 4 Reports to set up your Strategies in the next Step.

 

This is the way I open the 4 Reports.  You can use the F2 Editor.  I open Notepad and then Open the Folder Pick532 and at the bottom of Notepad dropdown I select ALL FILES.  This will open all the files.

 

The files you want to open is the W5 files.  There are 4 of them so just select W5.1 and open the report.

 

What I do is copy and paste the W5.1 Report into Excel and Sort the Report by Headings/Filters and look for conditions to play based on those values.

 

These are the filters to select your strategies:

 

All  Pot  Two  Three  Sum    Four    FivS    FivR  Bun3  Bun4  Bun5
 1    1      1       1        1        1        1          1        1      1        1

 

Final Notes:

 

I am just learning how to use this program. 

 

I just touched on just a small part of the program.

 

Todd, sorry for the long-winded explanations.

 

I hope others share their experiences and strategies using pick532 or the other Pick332 programs.

 

 

 

 

 

 

 

a. Create a New Folder in your Hard Drive C:\  (whatever designation you use C:, D:, etc.)

Name the folder: Pick532

b.  Download the Pick532 Zip file from  http://www.saliu.com/free-lotto-lottery.html 

c. Locate the Pick532 Program

d. Right Click the Pick 532 Program Link

e. Click "Save Target As"

f. Locate your New Folder you created "Pick532"

g. Download the Zip File to the Pick532 Folder

h.  Double-click the Zip file this unzips all the files into the Pick532 Folder

i.  Download the Program UTIL532.exe file from  http://www.saliu.com/free-lotto-lottery.html 

  This should be on the same page as the Pick532 Program.  As of 7/20/05 it was just 3 paragraphs below the Pick532 program.

Right click the UTIL532.exe

Save Target AS

Select the same Pick532 Folder

A message will ask you if you want to replace the existing file.

Select YES.

j.  Download the Program Parsel.exe file http://www.saliu.com/free-lotto-tools.html

Save Target AS

Select the same Pick532 Folder

Now your ready to begin.

Download or Copy and Paste 100 to 200 past draws into Notepad.

The draws should have the most recent drawing at the very top.  Youdon't need the dates.

The numbers should be separated by a coma (,)

example Cash 5: 5, 10, 15, 20, 25

Save your file as a .txt file

example: data-5.txt

 

 

 

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)