











P3 Charts™ for Excel 20072013





We begin this series with the study of a digit's SKIP PATTERN, which is common across all P3 Charts™ worksheets. A digit'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" digit: when it starts hitting again after many high skips.
In the following lessons, we'll examine actual draw results from a U.S. Pick 3 lottery chosen at random: the Oklahoma Pick 3 game with a Draw History updated through Saturday, August 7, 2010. When you click the "Digit Skips" worksheet tab, you'll see a chart similar to the one below:














DIGIT SKIPS, BIAS BAR AND LOTTERY BASICS
The most basic concept in lottery is a skip, or the number of games an event  such as a winning digit, pair, or sum value  sits out before hitting again. For the purpose of this workbook, a digit that came up in the very last game is considered to be on a skip of 0, or out 0 games. If that digit doesn't hit again today, but does hit tomorrow, then a skipped game value of “1” is added to its skip bar and its current out value resets to 0 games. In the example above, you can see recent skips of Digits 0 to 9, as well as skips of Doubles (combos with 2 matching digits) and Triples (3 matching digits).
All LottoChart Exec™ skip bars are presented vertically from top to bottom, with previous skips listed down the column that go farther back in time the farther down you go. At right, you can see Digit 5 is currently out 0 games, meaning it hit in the very last draw. Before that you have to skip over five games to find its last hit which was the sixth game back. Because it hit in the sixth AND seventh games back, a skip of 0 games is the next skip (any skip of 0 means it was a repeat hit from the previous draw). Next you skip over 1 game to find a hit, then skip 4 more games to find a hit, 5 more games, 9 more games, etc.
The median skip (M:), mode skip (Md:), and maximum skip (Mx:) are shown on the left side. Skip values are shaded with skips below the median shown in blue and skips above the median shown in orange for easy comparison of the low, more frequent skips with higher skips that hit less often. Median and mode skips are calculated using only the last 25 skips, or what you can see down the skip bar. Maximum skip is calculated by searching the maximum range of the chart which goes back 3,000 draws. If you thought a skip of 13 was a long skip based only on the current skip bar, there was one time in the last 3,000 draws when Digit 5 sat out for 21 games, or nearly twice as long!
IMPORTANT: We see from the colorcoded skip bar that hot and cold streaks continue for awhile and then reverse. When a digit skips a lot of games, it will usually hit and then hit over and over to form a new hot trend. On the other hand if a digit hits a lot and suddenly stops, it may be cooling off and sit out awhile. This is key to deciding which numbers to include in your plays; you can jump in and ride a hot streak or you can avoid a pattern altogether because it's cold and not hitting. (Remember: hot streak = several consecutive hits on low skips, and cold streak = multiple hits on high skips)
New in P3 Charts™ version 2! The largest skips in each skip bias bar are now shaded dark orange to highlight unusually large skips in a number's hit pattern. When several orange AND dark orange skips are stacked up near the top of a skip bar, this means the number has recently sat out a large number of games between hits (in other words it is unusually cold). Once this number hits again, it is considered a “Prime Play” number and will likely hit a few more times in short order.
*** Remember this concept, because it is key to everything that follows. When you find an extreme bias in a number's skip pattern in any chart, take note. Because when that bias finally ends, the reverse or opposite bias should come on strong, and this is the time to use it to your advantage. ***
Next, we find the “Current Skip” which is 0, and then a Skip tally, or count of the times Digit 5 hit on its current skip in the Last 30 games, 60 games and 120 games respectively. In the Last 30 games, Digit 5 hit on a skip of 0 (meaning it was a repeat hit) only one time. This would lead one to think maybe it's due to hit on a skip of 0 again, especially since its mode (or most common) skip is also 0. But what happens when we look back 60 games? Digit 5 hit five times on a skip of 0. Go back 120 games and it hit ten times on a skip of 0. Finally, one more calculation is done for comparison. In the last 240 games, Digit 5 hit 13 times on a skip of 0. It appears that something is out of line here, mainly that Digit 5 has hit too many times on a skip 0 in the last 120 games compared to the last 240 games.
The 240 game count is evenly divided to calculate an “Expected Skip tally” for the Last 30, 60 and 120 games. Now we see that based on its performance over 240 games, Digit 5 on its current out skip of 0 should have hit 1.6 times, 3.3 times, and 6.5 times in the Last 30, 60, and 120 games. The actual count? 1, 5, and 10 times. So it may not be a good idea to play Digit 5 as a skip 0 on this particular night. The final winning combination that came up? 283.
You may have noticed the “Tot Hits” count at the top of the column. This value of “460 hits” specifies how many times Digit 5 came up during the active Hits Range, which can be adjusted to any value between 1 and 3,000 games. The 460 hits of Digit 5 also places it in 7th place compared to hits of the other nine digits over the same Hits Range. Keep in mind that the “Tot Hits” count is an occurrence count only, meaning it doesn't matter if the winning combination is 150, 525, or even a triple 555, all would count as one hit of Digit 5 for that game. The exception to this rule is when calculating a digit's rank within the “Hot & Cold” worksheet, which is discussed in detail in Tutorial 8: Hot & Cold Numbers.



SET HITS RANGE (BLANK = DEFAULT)
As mentioned above, hit counts and skip information are calculated within a specified range of draws, up to a maximum of 3,000 games. The currently active range is shown in green below the input field and depends on the number of real draws available in your game's history. P3 Charts™ makes use of a nonchanging virtual draw history before the start of the real draw history for two important reasons:
 Some Pick 3 games have too short of a history and therefore too little data to complete advanced chart functions such as Chart View™.
 In cases where the real data runs out, you can look at virtual data to get a general idea of the skip patterns one would expect to see if the numbers were real.
Some people would disagree that real lottery numbers and randomly generated numbers could have anything to do with each other. There is much debate about the effects of lottery officials rotating out ball sets or using predraws to somehow manipulate the natural order of events. Further study will reveal, however, that longterm hit counts and skip patterns are consistent across both randomly generated and actual draws. Over thousands of games, both types exhibit longterm random characteristics and it is difficult to determine exactly where one game ends and the other begins!
But the choice is yours, and if you only wish to make use of real draw data then leave the “Set Hits Range” field blank and the chart will default to the maximum number of real games available. If you enter a number fewer than the available real games, then all counts are recalculated to the shorter range and all skip bars are adjusted to only show skips within that range. This is a useful feature for analyzing short ranges, and you have the option to individually set the range across each chart. Just remember that a blank value always defaults to the maximum number of real available draws.



SET CHART VIEW™
This is a powerful function for picking out hidden number patterns that aren’t visible at first glance. Chart View™ takes data from your real game and splits it into a new draw history consisting of numbers from every 2nd, 3rd, 4th, or 5th game relative to the current draw. In other words, what if you only play the lottery every other night and want to treat Monday, Wednesday, and Friday’s draws as three consecutive games? Chart View™ will ignore draws on Tuesday, Thursday and Saturday, and adjust all hits and skips throughout the workbook to treat these split draws as if they were consecutive games.
Perhaps the greater benefit of this function is that it gives you up to five unique, simultaneous views of one Pick 3 draw file, effectively rearranging all number patterns into new patterns of digit skips, pair skips and sums that you can then analyze for hot, cold and overdue trends. A difficult number or pair that gives you no indication of rather or not to play it within Chart View™ 1, may show the same number as an excellent or a horrible play in Chart View™ 3.
Keep in mind that the Game # shown is calculated RELATIVE to the current date. View 1 consists of one game, the “Actual” draw history. View 2 consists of two alternating games. If Monday corresponds to Game 1 of Chart View™ 2, then Tuesday would correspond to Game 2 of View 2. Wednesday would go back to Game 1 of View 2 (because Wednesday relative to Monday is two draws, or one completed cycle of Chart View™ 2). So in reality, this function gives you FIFTEEN unique games from one Pick 3 draw history, with five games simultaneously visible at any one time:
 View 1  Game A: This is the actual draw history.
 View 2  Game 1: Occurs every OTHER day. If you activate View 2 the next day, you’re now within Game 2 of View 2, and THAT game only occurs every other day.
 View 3  Games 1, 2 and 3: Consists of data from every third game and takes three days to complete a cycle back to the first game.
 View 4  Consists of four games and takes four days to cycle back to the first.
 View 5  Consists of five games and takes five days to cycle.







Recent draws within CV. 1 (left) and CV. 3 (right). Notice how Chart View™ 3 treats every THIRD game relative to the current date as a consecutive draw.



If this is too confusing, the good news is the workbook takes care of sorting it out for you based on the current real date and draw history! All you need to look at is the current Game # when changing between Chart Views to determine which game occurs on which day. If you’re playing a pattern within View 4  Game #2, simply update your Draw History each day with real draws as normal and wait several days for “View 4  Game #2” to reappear in the status box before playing that pattern again.
DIGIT HIT COUNTS






Below the skip bars for all ten digits (along with skips for Doubles and Triples), you’ll find hit count bars for all ten digits and Doubles. The most recent winning digits 0, 1 and 5 are highlighted green. Similar to the Skip tally, you are given information about total digit hits during the Last 15 games, Last 30 games, Last 60 games and Last 120 Games. Hits from the Last 240 games are also included for an Expected hit comparison of the Last 60 and 120 games.
Actual hit values for the Last 60 and 120 games are highlighted red or blue depending on if they're hitting too much (hot) or too little (cold) compared to their expected values. An interesting observation is that Digit 5 has hit above average in both the Last 60 and 120 games, and in the Last 15 games compared to the Last 30 games. This usually indicates a cooling trend is imminent. Digit 6, on the other hand, is showing opposite characteristics and may be due to heat up soon. Final results? In the twelve games that followed this snapshot, Digit 5 only hit in two of those games, but Digit 6 occurred in five of those future twelve draws. An overheated number is a good choice for elimination when it stops hitting and goes cold  similar to a pattern of excessive LOW SKIPS within the skip bars. If a number hits five or six times in a row on low skips and then stops, it is likely to sit out and stay cold for awhile.
SET DIGIT SKIP POSITION
Another powerful function is the ability to change analysis by position. Every chart except the Box Skip and Sum Chart allows you to change the Skip Position (Pos 03:) value between 0 and 3, and all hit and skip values will adjust according to the position selected. The default value is 0 for Box play / Any position.
Within the “Digit Skips” worksheet, changing this value to 1 results in Front Digit analysis only. A value of 2 changes to Mid Digit analysis only and 3 equals Last Digit analysis. Accordingly, each skip bar of Digits 0 to 9 will show information for those digits in exact position only. The hit count range is also increased from Last 15/30/60 and 120 games to Last 38/75/150 and 300 games to maintain a similar hit scale ratio due to the increased number of games required for a digit to come up in exact position.
ENABLE PAIRS MODE



Last but not least is the Pairs Mode toggle. Enabling this mode changes the skip bars of Digits 0 to 9 to a list of the 25 most recent pairs to hit with each digit. The pairs are listed in order of occurrence from top to bottom, with the most recent pairs shown at the top.
When you change the Skip Position value (Pos 03:) to either 1, 2, or 3, this is also reflected in Pairs Mode. Instead of showing pairs with digits in ANY position, you’ll see pairs that hit with Digits 0 to 9 as the first, middle, or last digit only. For example, the last pair to hit with Digit 9 was a 17 pair. Because our Position is set to ANY order, Digit 9 could be in any position as long as it hits with 1 and 7. If our Position was set to “2  Mid Digit,” we wouldn’t get a pair hit unless Digit 9 was in the middle position and either “17” or “71” were the remaining front and back digits, or a split pair.
The hidden gem of P3 Charts™ is the EZ Pair™ function which replaces the “Tot Hits” value at the top of every digit column when Pairs Mode is active. A complex series of calculations is performed on Digits 0 to 9 and under certain conditions, two select pairs will be highlighted as Primary and Secondary choices that should come up soon with any digit in the next week or so of future draws. 23 and 33 are the suggested pairs in this example.
EZ Pairs™ are highlighted orange within each skip bar, and are also shown in green at the top of the columns (“23 BOX” and “33 BOX”). What this means is a 2 and 3 should hit together soon in ANY position, as well as a Double 33 in ANY position. If our Skip Position was set to “1  Front Digit” only, and the selection at the top showed “01 BA” for example, this means a “X01” or “X10” should hit soon as a back pair. Setting the Position to “2  Mid Digit” will show “01 SP” at the top, meaning a 0X1 or 1X0 split pair should hit soon. Finally, setting the Position to “3  Last Digit” would show “01 FR” meaning that a front pair “01X” or “10X” should come up soon.
It’s important to understand that EZ Pairs™ can hit with any other digit, and not just the original digit used to generate the pair. You should think of these digits as individual calculators pointing to an expected outcome: That the suggested EZ Pair™ choices will soon hit in the FRONT, BACK, SPLIT, or BOX position with any third digit of 0  9, regardless of which skip bar is displaying the pair.
EZ PAIR™ REVIEW AND TUTORIAL
I was having such success in testing this function across multiple real Pick 3 games that I created special charts just to keep track of the pairs. You can follow the hits within your Pick 3 game with an online subscription to the EZ Pair™ Review! More information can be found in Tutorial 5: EZ Pairs.
BOX AND STRAIGHT FAVORABILITY CHART
New in P3 Charts™ version 2! A rating system has been added to all box and straight combos to help you determine how likely it is that any selected combination will hit in the next draw. Immediately below the EZ Pair™ QPicks window, you'll find several tables that list all 220 box combinations, and all 1,000 straight combinations in colorcoded boxes to indicate if each combo is currently FAVORABLE (shaded green), CAUTIONARY (shaded yellow), or UNFAVORABLE (shaded red).







If a combo is classified as Favorable, this means it falls within a larger group of numbers that produces a hit in 70% of all games. If a combo is classified as Cautionary, it falls within a larger group of numbers that produces a hit in 20% of all games, and if a combo is Unfavorable then it falls within a group that hits in only 10% of all games. The Favorability Rating of any given number changes from draw to draw, but the ratio of overall hits from each group is always the same (70% / 20% / 10%).
BOX OR STRAIGHT FAVORABILITY? One rating system is assigned to box combos only, and a separate rating system is assigned to straight combos. The box rating may be different from the straight rating, in which case the box rating is usually preferable (since it represents more combinations).
The following charts will also show each combo’s CURRENT colorcoded Favorability Rating:
 EZ Pair™ QPicks within the “Digit Skips” worksheet (box or straight Favorability depends on the Skip Position and Remove Box Duplicates setting)
 Sorted Box Combinations within the “Sums” worksheet (Box Favorability only)
 All wheeled combinations generated in the Pick 3 “Wheels” worksheet (you can even filter out combos from the wheels based on Favorability!)
If you want to see the Favorability of PAST winning numbers at the time they hit, an extra table is included in the “Wheels” worksheet that shows Box / Straight Favorability over the Last 50 games. Simply click the “Wheels” worksheet tab and you'll find this table below the Combination Query chart.
VISUAL DIGIT SKIPS (ANY POSITION)
If you scroll right from the skip bars of Digits 0  9 (while staying within the “Digit Skips” worksheet), you’ll find a series of skip columns for each digit, Doubles and Triples. This has a matrix style appearance where a digit drops, the skip count resets and counts up until the same digit drops again. The three ANY position skip values of the three winning digits are shown in blue on the right side.







ANY position Digit Skips with soontohit “67” Pair example



HINT: A good way to select upcoming pairs is to look at digits with the fewest recent hits and widest gaps near the top of the columns, AND that have just hit in the last two or three games. Look at Digits 6 and 7 in the example above. Both digits have large gaps between their last few hits, and both digits hit in the last three games. Five days later on August 12th, the winning number 768 was drawn!
VISUAL DIGIT SKIPS (EXACT POSITION)







EXACT position Digit Skips with highlighted “Skip 1” example



To the right of the ANY position skips, you’ll find a second set of columns with similar skip information about Digits 0 to 9 in EXACT position (front, middle, and last Digits 0 to 9). The positional skip values of the three winning digits are shown in dark red on the left side.
There’s also an input field at the top of the columns, labeled “Skip A” for Any and “Skip E” for Exact, where you can enter and highlight specific skip values throughout the column. This allows you to easily spot when digits hit on certain skips (all digits hitting on a skip of “1 game” are highlighted above). To return to the default nonhighlighted view, delete this value and leave the input field blank.
HITS OF SKIPS (ADVANCED UTILITY)
If you press CTRLEND to jump to the bottom of the worksheet, you'll find a summary of digit skip bars and a small utility for numerically displaying when certain skip values last hit. There are several input fields for tracking hits of skips in ANY position, and skips in EXACT position.
If you input a certain skip value, "3" for example, you'll see the skips of when any digit last hit on a skip of 3 games (presented in standard skip bar format). You can further narrow it down by entering specific digits in the field below the skip, so only those digits hitting on a skip of 3 are shown.
Finally, there's a "Minimum" parameter below the other input fields. This value can range from 1 to 3, and shows you skips of single, double, or triple SKIPS (not digits) hitting together in the same game.
EXAMPLE: You want to see when the last time was that any two digits hit together after both digits skipped ten games in an exact position. You enter a "10" into the Exact Skip field, and you set the Minimum parameter to "2". Skip patterns will now be shown for any two digits hitting together when BOTH digits were out on on a positional skip of 10 games (a double 10 skip).
2 » DRAW HISTORY  3 » DIGIT SKIPS  4 » PAIR SKIPS

