











P3 Charts™ for Excel 20072013





This tutorial is based on the study of a sum's SKIP PATTERN, which is common across all P3 Charts™ worksheets. A sum's recent skips, or the number of losing games between hits, are stacked together and colorcoded into LOW SKIPS (shaded blue) and HIGH SKIPS (shaded orange). Keep this in mind as you learn to recognize a "Prime Play" sum: when it starts hitting again after many high skips.
Many people like to play Pick 3 by sums, or the value obtained by adding each of the three winning digits together. Sums, like individual digits, pairs and boxes, hit in patterns and these patterns can be viewed within the Sum Chart: a comprehensive analysis tool with multiple digit filters and box combo tables. Not only can you track the skips of each sum, but also the skips of root sums, sum last digit, and a third sums reducer based on subtraction of digits. It's an allpurpose, 4in1 utility that provides everything you need to master Pick 3 sums and their associated combinations!









Sums worksheet, combos represented are visible by scrolling down.










Sum skip columns are visible by scrolling right from the skip bars.



When you click the “Sums” worksheet tab, you'll see skip bias bars for each of the 27 sum values (or the 10 reduced sums which are discussed below). The combinations for each sum are displayed in tables immediately below the skip bars, and these tables will automatically update to reflect the current digit filter and sum type settings! We begin with an explanation of the four types of sums:
PICK 3 SUM TYPES (For a printerfriendly version of these charts, CLICK HERE)







COMBINATION SUM: There are a total of 27 sum values derived from the 220 Pick 3 box combinations. Sums within the middle of this range (sums 12 to 15) hit most often because they contain the most combinations; fifteen for each sum. The fewest combinations are associated with sums 0, 1, 26 and 27, because only one box combo can add up to each: 000, 001, 899, and 999. This results in a “bell curve” distribution of numbers, with the majority of hits clustered around the middle, and fewer hits counted as you move away toward the edges of the field.








ROOT SUM: There are several ways to reduce the 27 sums down to single digits for easier tracking. One is the root sum, which is calculated by adding both digits of a sum until you arrive at a single digit. The root sum of 27 is 9, because 2+7= 9. The root sum of 13 is 4 (1+3), and the root sum of 5 is 5 (0+5). Finally, the root sum of 19 is 1, because you add 9+1= 10, then add the digits of that result: 1+0= 1. Root sums are the most unevenly distributed, with only one combination that can equal root sum 0, and either 24 or 25 combinations that add up to the remaining root sum values of 1 to 9.




SUM LAST DIGIT: This value is easy to determine. You simply look at the last, or farthest right digit of the sum. The last digit of sum 18 is 8, the last digit of sum 27 is 7, and the last digit of sum 3 is 3. There are exactly 22 combinations for each sum last digit of 0 to 9.








REVERSE SUM: For a bell curve distribution of combinations reduced down to a single digit, you can subtract the smallest digit in a combo from the second smallest digit, then subtract that value from the largest digit. The result is basically a reverse sum. Example: the reverse sum of 358 is 6 (53= 2, 82= 6) and the reverse sum of 277 is 2 (72= 5, 75= 2). There are 30 combos each in reverse sums 4 and 5, the center of the bell curve, while there are only 10 combos that comprise reverse sums 0 and 9.
SUM CHART SETTINGS AND FILTERS
SET HITS RANGE: This setting performs the same function as in previous charts. You can set an analysis range of up 3,000 games (leaving blank defaults to the maximum number of real draws available in the Draw History). If you set a lower or higher Hits Range, all skip bars will recalculate to show hits within that range.
SET SUM TYPE: To change the type of sum being analyzed, enter 1 for Root Sum, 2 for Sum Last Digit, or 3 for Reverse Sum. The default value is 0 for standard sums (all skip bars and combo tables will display information based on the selected sum type).
SET KEY DIGIT AND DIGIT FILTERS: We can go beyond basic sums analysis and look deep into patterns of digits that appear in the winning combinations, grouped by each sum. First is the Key Digit input field, where you can enter any digit between 0 and 9 (leave blank or delete for none). Entering a Key Digit reduces the box combinations from 220 down to 55, and changes the skip patterns to only include winning combos with that digit.
You can also filter out digits from the winning numbers by clearing the check boxes next to each digit under the “Digit Filter” section. All winning combinations that contain any of the filtered digits will no longer register a hit. This option can be used with or without a Key Digit, and all skip patterns will adjust according to both conditions!


The following is an example of the sum type, Key Digit, and Digit Filter settings at work. As of August 7, 2010, we are looking at all Sums Last Digit that contain a Key Digit 3, while filtering out digits 0, 7, and 9. Every skip bar has recalculated to show skip patterns ONLY for the combos displayed at the bottom. Two “Prime Play” sums have also been circled:








With the current chart settings, Sum Last Digit 0’s combos are 136, 235, and 334. Sum Last Digit 1’s combos are 236, 335, and 344. By playing these “Prime Play” numbers, we would have hit TWICE in the next twelve draws  on August 15th when 533 hit, and again on August 19th when 136 hit!
More examples of skip patterns are provided later in this tutorial. If you haven't read the Backtest section within Tutorial 6: Box Skips, you may want to do so now to help answer these questions:
 Why are Sum Last Digits 0 and 1 considered the best Prime Play sums above?
 Why is Sum Last Digit 9 considered a marginal play in spite of hitting 14 draws later?
 Why are Sum Last Digits 5 and 7 NOT considered a good choice to play?
(suggested answers are given a few paragraphs below...)
SORTED BOX COMBOS AND BOX FAVORABILITY








Below the skip bars and combination tables, you'll find another output table that displays all sorted box combinations, colorcoded to their box Favorability rating! The current Digit Filter settings are also displayed, as well as a count of total combinations based on these settings.
This chart is a quick and easy way to determine the Favorability of all 220 box combos at a glance. If a number is shaded green, it falls within a larger group that produces a hit in 7 out of 10 games. A yellow number falls within a group that hits in 2 out of 10 games, and a red number falls within a group that hits in only 1 out of 10 games. The Favorability of combos changes from draw to draw, but the ratio of hits from each group is always the same. More about Favorability can be found in Tutorial 3: Digit Skips.
SUM SKIP PATTERNS
Once we know the combinations associated with each sum (by looking in the combination table below the skip bars), we can compare their skip patterns over the last 3,000 games and only play those sums that appear favorable to hit again soon. Earlier, we looked at the ten skip bars for Sum Last Digits 0 to 9 and determined that some were a better play than others. Here's why:
 Sum Last Digits 0 and 1 are probably the best plays because they both recently hit, and both have an excessive number of high, orange and dark orange skips near the top of their bars. A soon hit is also indicated because of the large size of those skips.
 Sum Last Digit 9 has several high skips near the top of its bar, however, they aren't very large compared to the sum's median and maximum skip values. In reality, most of the high skips are barely above the median, and they just followed a hot streak of multiple hits on low skips. A significant cold streak is overdue for this sum, and while the winning number 513 was drawn fourteen days later, another hit didn't occur for five months after that, or a future skip of 152 games.
 Sum Last Digit 5 recently hit, with a number of recent high skips that are fairly large in size. But these skips are separated by low skips in between, and still aren't very high compared to the median; a future hit didn't occur for another 227 draws. Sum Last Digit 7 also hit recently, but two large skips near the top are separated by three low skips, a pattern that's currently too erratic to rely on. One hit did come 89 days later, but a second hit didn't occur for another 225 draws after that.
Let’s look at a few more skips of sums; you may be surprised at the consistency of the patterns!







SAMPLE 1








SAMPLE 2








SAMPLE 3





SAMPLE 1: After experimenting with more filter settings, the following scenario was found. By filtering out Digits 2, 4, 8, and 9 from the winning numbers, we see that Sum 9 has multiple very large skips at the top of its bar. Ten days later on August 18th, the winning number 711 was drawn, followed by 513 on on August 21st, and 360 on August 29th  that's three hits within 22 draws playing 4 box combos!
SAMPLE 2: Using the same filters, we find another marginal pattern, except in this case the most recent skip of 395 games is also Sum 11’s maximum skip. When a number ends a single large skip, it MAY hit again soon but I've found it will often sit out until the median or longer before its next hit. Seven days later on August 15th, 533 was drawn, completing a skip of 59 games. This shows that one or two large skips aren't enough to forecast a soon hit, but rather multiple large skips stacked up together.
SAMPLE 3: Sum Last Digit mode with no filters enabled. We see that Sum Last Digit 6 (represented by 22 box combinations) just hit in the last game, and has multiple large skips at the top of its skip bar. Two days later, 826 was drawn which is a Sum 16, or Sum Last Digit 6.
In the next column over, we see that Sum Last Digit 7 is currently in a very hot streak with multiple recent hits on low skips. This was preceded by a single large skip of 49 games, then another skip of 15 games (well above the median) before it hit again, illustrating the principle in Sample 2 above.
IMPORTANT: One must be careful not to jump into the game too late, as Sum Last Digit 7 was finally cooling off at the time of this snapshot. It didn't hit again until August 17th (10 days later), and then September 19th after that (a large 32game skip). When a number hits five or six times in a row on low skips and then stops, it is likely to go cold and becomes a good candidate for elimination!
6 » BOX SKIPS  7 » SUM CHART  8 » HOT & COLD

