P3

Welcome to P3 Charts™

Advanced Pick 3 lottery software and spreadsheet program for Microsoft® Excel *

pixel

This series of tutorials is provided to help you utilize the many chart functions available for displaying and interpreting the numbers of your game. Each P3 workbook contains several worksheets accessible by clicking the worksheet tabs at the bottom of your Excel screen. The tutorials below correspond to each of those worksheet tabs.

 

 

 

 

Give it a try!

P3 Charts™ for
Excel 2007-2013

Previous Next

 Information in this tutorial:

Combination Types

Set Hits Range

Set Key Digit

Backtest Mode Example

This tutorial is based on the study of a combo's SKIP PATTERN, which is common across all P3 Charts™ worksheets. A combo's recent skips, or the number of losing games between hits, are stacked together and color-coded into LOW SKIPS (shaded blue) and HIGH SKIPS (shaded orange). Keep this in mind as you learn to recognize a “Prime Play” combo: when it starts hitting again after many high skips.

New in P3 Charts™ version 2!  The “Box Skips” worksheet has been added so you can track skips of multiple full box combos, or 3 digits hitting together in Any order. If you take all 1,000 Pick 3 combinations and re-order the digits in every combo from smallest to largest, you'll end up with 220 individual combinations after removing duplicates. These 220 box combos are as follows:

Pick 3 Box Combos

PICK 3 COMBINATION TYPES

There are several ways to win at Pick 3, depending on the type of play selected:

STRAIGHT: When you play a Pick 3 combination in Exact order, you only have one chance to hit - if the winning number drawn comes up in the exact same order. The odds of this play are 1:1000. Within the “Box Skips” worksheet, we are only concerned with the other combination types below.

6-WAY BOX (Uniques): When you play one Pick 3 combination in Any order, you have up to six chances to hit as long as all of your digits are contained in the winning number drawn - regardless of digit order. The 120 green combinations in the table above are box combos known as “Uniques,” because all three digits are unique and non-matching. This play provides the best odds of winning (1:166), but also the lowest prize amount for matching a full box combination.

3-WAY BOX (Doubles): If you play one of the white combinations above in Any order, you have three chances to match the winning number drawn. These combos are known as "Doubles" because two of the digits are matching and one is unique. There are 90 combos that fall into this group, the odds of winning are 1:333, and the prize amount is generally double that of the Uniques.

TRIPLES: The yellow numbers make up the ten triples in Pick 3, and while these combos are included in our box combo list, they can only be played as straight. The odds of any one of them hitting are 1:1000, whereas the odds fall to 1:100 if you play all ten of them together in the same draw.

SET HITS RANGE

In the “Box Skips” worksheet, you'll find 55 skip bias bars that correspond to the individual skips of each box combination. The median, mode, and maximum skip of each combo is displayed across the bottom, with additional combos visible by scrolling right. You can set an analysis range of up to 3,000 games (leaving this value blank defaults to the maximum number of real draws available in the Draw History). The currently active range is shown in green below the “Set Hits Range” input field.

Box Skips Worksheet

Box Skips worksheet, additional combos are visible by scrolling right.

SET KEY DIGIT FOR COMBINATIONS

Because there are 220 box combos, this would normally require 220 columns of data in Excel. To save workbook space, you can view 55 combos at a time based on any Key Digit mutually shared by the combinations. Simply enter a digit between 0 and 9 into the Key Digit field, and you'll see skip bars for the 36 Uniques, 18 Doubles, and 1 Triple that all contain that digit.

In the example above, we're looking at combinations with a Key Digit of 0. Limited data is available to fill the skip bars due to the relatively short history of our Oklahoma draw file (only 1732 games as of Aug. 7, 2010). Other Pick 3 games with at least 3,000 draws will show more complete data, OR you could manually set the hits range UP to view patterns that extend into the virtual Draw History.

BACKTEST MODE EXAMPLE

Notice the median and maximum skips for box combos, which are all significantly larger than those of Pick 3 pairs. You'll need to take this into account when timing your plays, and especially when looking for optimum settings in Backtest Mode (or deciding rather to Backtest at all).

In Tutorial 4: Pair Skips, we discussed a good rule of thumb when looking for “Prime Play” pairs.  If you divide the expected payout of the prize by the daily cost of playing a certain number, this is a good starting point in the past for analyzing favorable patterns that may hit soon (Remember: a “Prime Play” number has multiple high skips stacked up near the top of its skip bar, AND it recently hit). For one Unique box combo, if you divide the expected payout ($80) by the daily cost of playing that number ($1 for Any order), you come up with a setting of “80” for Backtest Mode.

Set Hits RangeNOTE: In these examples, we've set the Hits Range UP to 3,000 games, which extends into the virtual Draw History for easier recognition of  very large skips near the top of the bars (these dark orange skips are only highlighted when there are at least 12 skips in a bar, so older "virtual hits" are used to fill the bars with more data). Backtest Mode is set to 80 games in the past, arriving at May 19, 2010.

Box Skips Example

-80 / current
389 BOX
Future Hit:
+13 games

-80 / current
458 BOX
Future Hit:
+45 games

-80 / current
479 BOX
Future Hit:
+54 games

-80 / current
578 BOX
Future Hit:
+61 games

-80 / current
789 BOX
Future Hit:
+72 games

-80 / current
078 BOX
Future Hit:
+77 games

SAMPLE GROUP 1: All of these combos had recently hit as of 80 games ago. When we disable Backtest Mode and return to August 7th, none of them have hit again. If we start playing at this point, the combination 983 hit 13 draws later on August 20th, 845 hit 45 draws later, 947 hit 54 draws later, 587 hit 61 draws later, 897 hit 72 draws later, and 087 hit 77 draws later on October 23, 2010.

These are examples of “Prime Play” combos that required a period of time to hit; at least 93 draws into the future (80 games + 13 games) from the time we selected them in Backtest Mode. But several other “Prime Play” combos had so many excessive high skips in the recent past (at the top of the bars) that a future hit happened much sooner, and enabling Backtest Mode wasn't necessary:

Box Skips Example

-80 / current
129 BOX
Future Hit:
+4  /  +17

-80 / current
267 BOX
Future Hit:
+18  /  +211

-80 / current
238 BOX
Future Hit:
+26  /  +1

-80 / current
037 BOX
Future Hit:
+36  /  +28

-80 / current
136 BOX
Future Hit:
+53  /  +12

-80 / current
368 BOX
Future Hit:
+57  /  +465

SAMPLE GROUP 2: In this group, we see that it's not just the QUANTITY of orange skips near the top of the bar, but also the SIZE of those skips. Notice the large 1,258-game skip by box combo 238! Not only did the combination 328 hit 26 draws later on June 14th, but it hit again in the very next draw after disabling Backtest Mode (283 on August 8th). The same is true for box combo 129. The winning number 912 was drawn on May 23rd (4 games after the Backtest draw), followed by the winning number 192 on August 24th, or 17 draws after disabling Backtest Mode.

When it comes to high skips, size does matter, and if those skips are large enough they may be followed by one or two hits SOONER than one would expect. The opposite is true if high skips aren’t very high, as with box combo 267 above. The orange skips near the top are separated and barely above the median, which may explain why it didn't hit again for 211 more draws after disabling Backtest Mode. As for box combo 368, yes there are two large skips of 446 and 333 games, but this wasn't enough to fully reverse the extreme hot streak that occurred farther down the bar, when 836, 683, 368, 683, 683, 386 and 386 hit one after another on multiple low skips. So in spite of box combo 368 hitting on July 15, 2010 (+57 games), this number stayed cold and didn't hit again until well over a year later.

There are several other combos that did NOT hit in the near future, with or without Backtest Mode:

Box Skips Example

-80 / current
038 BOX
Future Hit:
+107 games

-80 / current
356 BOX
Future Hit:
+169 games

-80 / current
125 BOX
Future Hit:
+187 games

-80 / current
035 BOX
Future Hit:
+228 games

-80 / current
016 BOX
Future Hit:
+283 games

-80 / current
248 BOX
Future Hit:
+388 games

SAMPLE GROUP 3: This is an assortment of combinations that perhaps looked good at first, but didn't produce any hits for at least six months from the Backtest draw, and an additional three months after disabling Backtest Mode. We could chalk it up to the unpredictability of the lottery, and while that may technically be true, I’ll attempt to offer an explanation that  - in theory - could be used to anticipate other similar patterns, and therefore avoid playing those patterns in the future. Just remember, as with any lottery, a hit may (or may not) come at any time, so play (or don't play) at your own risk!

Box combo 038: While there are several high skips near the top of the bar, the SIZES of those skips aren’t very large, and probably too small to counter a recent hot streak (hits on multiple low skips).

Box combo 356: We notice several very large skips near the top of the bar, however, with Backtest Mode set to 80 draws back, this combo is approaching its median skip and therefore did NOT recently hit (one condition of a “Prime Play” number is that it must have recently hit, either currently or in Backtest Mode). Within a few more draws, box combo 356 will be out on a high skip, with no indication that its current cold streak has ended or that the trend will change.

Box combo 125: Not enough very large skips near the top. Large skips are barely above the median.

Box combo 035: This combo is approaching the median, similar to box combo 356.

Box combos 016 & 248: These combos have the largest losing streak AHEAD of them in the future, likely because of multiple recent low skips, and large skips that are barely above the median.


TO SKIP OR NOT TO SKIP? Full box combos are difficult to catch because any one combination is among the least frequently occurring pattern in Pick 3, behind a straight. While studying skips in conjunction with Backtest Mode can make winning easier, this is an advanced method of play that requires patience. Some users will find it easier to assemble box combos using other methods, such as playing pairs or wheeling together a group of favorite digits - the final choice is up to you.

5 » EZ PAIRS  |  6 » BOX SKIPS  |  7 » SUM CHART

 

 

 

 

Home   Free Demo   Member Login   F.A.Q.   Contact   Legal 
 Installation   Draw History   Digit Skips   Pair Skips   EZ Pairs   Box Skips   Sums   Hot & Cold   Wheels

All text, formulas, output, formatting and screen captures of this website and of P3 Charts™ workbooks are
protected by United States and international copyright law. Unauthorized duplication or reproduction is prohibited.
Copyright © 2010-2013, LottoChart Executive. All Rights Reserved.
* Microsoft and Excel are trademarks of the Microsoft group of companies. LCE is not affiliated with or endorsed by the Microsoft Corporation.