











P3 Charts™ for Excel 20072013





For in depth study of hot and cold number patterns, click the “Hot Cold” worksheet tab for a versatile utility that not only classifies digits into separate groups and ranks, but allows you to define how those ranks are counted and track the skips of when they hit. This chart is also ideal for selecting groups of digits to include in the number wheels discussed in Tutorial 9: Pick 3 Wheels.
So what makes a number hot or cold? For any given range of draws, some lottery numbers will hit more than others  these numbers are said to be “hot.” Other numbers with fewer hits are said to be “cold,” but it's all relative depending on the range of analysis. This is why P3 Charts™ allows you to place a frame around a block of draws using two inputs known as Count Range and Offset. This frame will then rank and classify Digits 0 to 9 as either hot (three digits), mild (four digits), or cold (three digits) by counting how many times each number hit within the specified range of draws.








Hot & Cold worksheet, HMC group skips on left and Digit Rank on right.




SET COUNT RANGE AND OFFSET
Because short ranges are best for identifying changes in hot and cold number trends, the maximum “Count Range” that can be set is 300 draws. The default value is a 30game range, meaning that for every draw, you'll find total hit counts of Digits 0 to 9 based on how many times each digit hit in the previous 30 draws leading up to the calculation. Rank #1 is the digit that had the most hits over the specified range, while Rank #10 is the digit with the fewest hits. Digits within Rank 1, 2 and 3 make up the hot group of numbers, while digits within Rank 8, 9, and 10 make up the cold group.
NOTE: The difference between “Hot & Cold” hit counts and hit counts displayed in the “Digit Skips” worksheet is that identical digits appearing in the same combination are now counted. This means that Doubles and Triples will add to a digit's total count and therefore increase its ranking in the “Hot & Cold” chart. This is not the case in “Digit Skips,” which is a simple occurrence count only.
Next is the “Offset” function which allows you to shift the Count Range BACK a specified number of draws before the actual counting begins. For example, let's say you want to rank all digits according to hits over the previous 30 games, and you want to play the top two hitting digits (Rank #1 and #2). However, the top ranking digits don't always hit together, especially since their ranking is an indication of what happened in the past 30 draws and may not be a current trend. You want to give these digits a break to allow them a period of time to hit together again, so you set the Offset value to 30 draws as well.
Now for every game's rank calculation, the chart will skip over the first 30 draws of data and THEN begin counting hits from the 31st row back to the 60th row. Finally, each digit is ranked and skips are plotted according to this shifted, or Offset count window. How useful is this function? With no Offset value, digits that ranked #1 and #2 only hit together 10 times in the past 300 games. Setting the Offset value to 30 results in 21 hits together of Rank #1 and #2 over the same 300 draws! Of course results will vary by game which is why you should experiment with various Range and Offset values. We will discuss more about tracking hits and skips of ranks (as opposed to fixed digits) later in this tutorial.
DIGIT RANK 1 TO RANK 10








The “Hot Cold” worksheet is divided into several sections, with input fields located in a gray column down the middle. To the right of the input fields, you'll find a ranking of all recent winning digits, calculated at the time they hit according to the current Count Range and Offset settings. These previous winning digits are shown in bold underline font compared to their losing counterparts.
We see that the most recent winning Digits 1, 0, and 5 were ranked #2, #4, and #10 at the time they hit. Digits for the next future draw are listed at the top, in order of rank from hot to cold (#1 to #10). To the right of these columns, you'll find a raw count of each digit ending with the most recent draw. Digits 0, 1 and 8 are in the current hot group of digits because they hit 10, 12, and 13 times over the Last 30 draws. On the other hand, Digits 4, 5, and 7 only hit seven, six, and seven times so they are in the cold group. By looking down the page and farther back in time, you can clearly see a digit's rolling hit totals through the draw history as new hits are counted and older hits drop off at the end of the Count Range. Each digit is riding its own wave in the ebb and flow of transition from one rank class to another, and by adjusting the Range and Offset values, you can witness this from near limitless perspectives!
HOT / MILD / COLD SKIP CHART
We now move from tracking hits to tracking skips, specifically GROUPS of hot, mild and cold numbers (the three rank classes). These groups will be referred to as “HMC numbers” for short. The HMC Skip Position function allows us to break down skips of HMC numbers into any position (0), or when they appear as a front (1), middle (2), or last digit (3) only.
On the left side of the worksheet, you'll find a graphical skip column and three skip bars that show skips between the occurrence of any hot, mild, or cold numbers in the winning combinations. This may seem confusing at first so we'll take it one step at a time:




LEGEND 1: The HMC “Least” value is a minimum parameter that determines how many digits must appear from any HMC group per draw. A default setting of 1 means that “at least 1 digit” in the winning combination must be hot, mild, or cold for a hit to count in the group's skip bar.
LEGEND 2 & 3: Changing the Least value to 2 or 3 means that “At Least 2,” or “All 3 digits” must be hot, mild, or cold for a hit to count in the hot, mild and cold skip bars. This is useful for analyzing those games when all three digits come from one rank class (e.g., the winning number 952 above).
NO DIGITS: Changing the HMC Least value to 0 reverses the analysis and track skips of when zero, or “no digits” in the winning combination are hot, mild or cold.
Click the arrow under the picture above to see effects on skip bars after changing the HMC Least value to 0, 1, 2, or 3. You'll also notice a change in the “Games: %” count to reflect the percentage of Last 300 games that contain at least 1, 2, or all 3 digits from each rank class. With a default Least value of 1, 62% of the Last 300 games contain at least 1 hot digit, 80% of those games contain at least 1 mild digit, and 69% contain at least 1 cold digit. Finally, when the HMC Skip Position (Pos: 03) is changed to front, middle or last digit analysis only, the Least values of “At Least 2” or “All 3” are nonfunctional, because only one digit can occupy a front, middle or last position.
*** THE BOTTOM LINE ***
How does this help to narrow down your plays? In the example at right, with a Count Range of 30, no Offset and a Least value of 1, we see that an excessive number of recent games contained 1 or more cold digits. In fact, the last eight consecutive games contained cold digits (see skip bar above), and half of those were double cold digits! Switch the Least value to 0 and you'll see that it's been 8 games since “zero” of the winning digits were cold, and the previous maximum skip for zero cold digits to hit is 11 games.
The last eight games contained a nice repeating pattern where one could have included at least one cold digit in all of their tickets; not doing so was an automatic loser. However, the time is quickly approaching when one could eliminate all digits from the cold rank class (currently Digits 4, 5 and 7). Eliminating three digits from all positions reduces our total box combinations from 220 down to 84, and our total straight combinations from 1,000 down to 343!
Sure enough, the winning numbers for the next TWO draws were 283 and 826, none of which were cold digits. Not only that, but another overdue pattern immediately appears: Digits 2 and 3, and then Digits 2 and 6 were double digits from the largest Mild rank class. At Least 2 digits hitting together from the Mild rank class hasn't happened in 10 consecutive games. The maximum skip for this to occur is 13 games, so “2+ Mild Digits” hitting together was quickly becoming overdue.
Keep in mind that this is all for an HMC Count Range of 30 games and an Offset of 0 games. You can experiment with countless variations of the two to force the next draw onto favorable skips where single digits or entire ranks can be eliminated from your plays. Or you can reverse the strategy and select one or more likely digits to include in a P3 number wheel.
RANK 1 TO RANK 10 SKIP CHART
The “Hot & Cold” worksheet contains one more series of skip bars for each of the ranks (Rank #1 to #10). If you scroll right from the digit rank columns, you will see the following screen:












Instead of tracking number groups, we observe the skips of each individual rank. For example, if you look at the main Digit Rank section where previous winning digits are shown in bold underline font, the vertical gaps between those underlined digits correspond to the skips in each skip bar above. Let's look at the Digit Rank Chart under Rank #1, Rank #2, and Rank #3. Remember, the very top row doesn't count because those are NEXT DRAW digits and not previous winning numbers:
RANK 1: We have to skip down five games to find the most recent hit of Rank #1, so this rank is currently out 5 games. Below that we have to skip two more games to find an underlined digit. Then we have to skip another fourteen games to find the next underlined digit. So Rank #1 is out 5 games, with previous skips of 2, 14, 0, 2, etc.
RANK 2: This rank hit three games in a row, so it's currently out 0 games, with two previous hits on skip 0. Before that, you have to skip one game to find an underlined digit, then skip two games to find the next underlined digit. So Rank #2 is currently out 0 games with previous skips of 0, 0, 1, 2, 4, etc.
RANK 3: This rank is currently out 3 games. Before that you have to skip four games to find an underlined digit, and before that there were three repeat hits in a row. So Rank #3 is out 3 games with previous skips of 4, 0, 0, 0, 1, etc.
In the skip bars above, Rank #2, Rank #4 and Rank #10 all hit in the last draw and are currently out 0 games. What other clues can we discern from this chart? Notice how Rank #4 just hit and completed two large skips of 15 games and 10 games, which appear at the top of the bar. The winning number for the next draw was 283, which included Rank #4 as a repeat Rank hit (Digit 3)!







Finally, at the upper right corner of the Rank Skip chart, you can change the Rank Position (Pos 03:) to track skips of ranks that appear in Any position by default (0), or as the first, middle, or last digit only (13). When this value is set to 0 for Any / Box play, you can enter a “Rank Pair” to see skips of TWO RANKS hitting together. Skips above are shown for Rank #1 and Rank #10 hitting together as a pair in the same game (in other words, both rank columns contained a bold underline digit in the same row). This is an alternative method for selecting number pairs to play, just remember that the Ranks themselves are fixed and the digits they represent are variable and change from draw to draw.
7 » SUM CHART  8 » HOT & COLD  9 » WHEELS

