The following are some of the instructions for the Excel Spreadsheet.
Thanks to John (Atomic Dog) for providing his system Union Jack. This is a learning experience for me to try to understand the Progression Statges and what stage Pennsylvania Evening draws are cuurently in. If anyone could provide some advice it would be greatly appreciated. Thanks a bunch!! in advance.
Here are a few of the instructions:
I will try to briefly explain each of the Tabs in each of the worksheets.
There are 4 Tabs:
1. Number Charts
2. E7Days = Evening 7 Days
3. Pick3Eve = Evening Drawings
4. ECharts = Evening Charts
I don't know how the Progression works using this system. If you have a better understanding of this system let me know.
I added all of Georgia's Evening drawings from the past 18 months or so to the worksheet. You can probably delete some of them. I included them if you wanted to back test a few months.
I'll start with the ECharts. Don't change anything on this Tab. It has all the formulas for the other Tabs. If you change anything or delete anything it will mess up the other worksheets.
The Pick3Eve Tab contains all the Georgia Evening past 18 months past draws. I don't think you will need this many but I put them in.
You will notice that the last drawing entered was on Friday, June 24, 2005 (682). According to Atomic Dog (John), his drawing only go up to Friday. When you have another full week of drawings after the Friday (Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday) you can enter the new drawings above the June 24, 2005 drawing. So after tonights drawing (July 1, 2005) you can enter all the previous draws. To make this work the "Friday Drawing" should always be on line 10 of this chart. To enter the new 7 drawings, insert new lines by right clicking line 8 and select "insert" 7 times then add your new drawings. Then drag all the cells up to row 10.
Tab E7Days is where you enter the drawings after Friday.
When you click the E7Days Tab you will notice all of the drawings after Friday June 24, 2005, with the most recent drawing at the top. Once you have 7 drawings you will need to copy and paste all 7 of the Dates and drawings to the "Pick3Eve" Tab. Line 10 of the "E7Days" Tab must not be deleted. You will need the formulas. So when you have the first drawing for Saturday, all you have to do is copy and paste this line to line 1 and then change the correct date and drawing.
The final Tab "Number Charts" is where all the combinations are generated. If you go to cell "S1 through X2" you see the 5, 3, 2 R and Ir (Regular and Irregular).
If you look at Cell column "Z" you will see Normal, Plus 1 - 1st Digit, Minus 1 - 1st Digit, etc.
If you look at cell "T9" you will see a "1" highlighted. This means that "5 IR (Irregular) hit as a boxed combination using the "Minus 1 - 1st Digit". The combination was "249", drawn on Thursday, June 30, 2005. See Cell "O4, P4, and Q4".
The key is to find what progression Georgia Pick 3 evening is currently in.
Part 2 Instructions:
I should add that when you click the "Number Chart" Tab, look at Cell range D4 through M13. Also Cell B4 has "5 Regular" and cell range A4 through A13 has all the sequences.
So for example:
If you look at cell range A6 through M6, you see the following:
Plus 1 - 1st Digit (added +1 to each of the combinations 1 digit(see Cell D4 "624" and Cell D6 "724")
Next you want to look at cell B4 and you see that these combinations are based on "5 Regular". If you go further down Row B you see "5 Irregular, 3 Regular, 3 Irregular, 2 Regular and 2 Irregular.
Now cell range D6 through M6 are all 10 combinations based on the "Plus 1 - 1st Digit".
If you look at Cell "O4" = Date Thursday, June 30, 2005
Cell "P4" is the actual 3 digit number drawn for this date = "492" and you see in cell "Q4" the ascending boxed version of "249".
Look at Cell ranges "S4" through "X13". You will notice in cell "T9" a "1" highlighted. This means that a "Boxed" combination HIT in "5 Irregular" for the "Minus 1 - 1st Digit"
Each of the draws in Cell range O4 through O76 have their corresponding blocks of conditions in cell ranges S through X.
Finally, if you look at cell "O76" you see that it is blank. This will be tonights drawing for your state of Georgia.
When you enter (insert) the new drawing in Tab labeled "E7Days" (Cell A1) you will notice all the dates drop down.
This will also be the 7th and final day. You will be able to look at cell Ranges S through X in the Tab labeled "Number Charts" and see where the combinations are hitting by their corresponding identifications.
Any suggestions or mistakes let me know and I will correct.