Welcome to P3 Charts™

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


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:

Digit Skip Table

Wheel Filter Settings

P3 Wheels™ List

P3 Wheels™ Skip Chart

Combination Query

Last 50 Favorability Table

Lottery wheels allow you to arrange a group of favorite numbers into multiple lines so they can all be played together. The most common wheels are used in lotto-style games (Pick 5, Pick 6, etc.) and are abbreviated lotto wheels; that is, they contain holes in number coverage to reduce the overall cost while still providing a minimum lower prize guarantee if some or all of your numbers match the winning numbers drawn. The wheels provided in P3 Charts™ are full-digit wheels. This means that entering multiple digits will give you every possible combination for box or straight play.

New in P3 Charts™ version 2!  The wheeling engine has been completely rewritten and now allows you to filter out combinations from every wheel based on current Favorability, as well as combination type! (Uniques, Doubles, and Triples) If you aren't familiar with box and straight Favorability, more information is provided in Tutorial 3: Digit Skips. You can also wheel multiple pairs as well as digits, and the skips of these combinations are plotted in a new and improved P3 Wheels™ skip chart.

Pick 3 Wheels Worksheet

Wheels worksheet, combination filters and P3 Wheels™ skip chart.


Digit Skip TableAt the top of the worksheet, you'll find a reference table with information about all ten digits based on the draw history. This gives you a starting point to determine which digits recently hit, and which digits are out on higher skips. The skip table has no effect on any of the wheels, but is provided for information purposes only. You can enter a “Maximum Skip” value and any digit that's currently on a skip beyond this range will be shaded gray. A hit percentage is also calculated, which tells you how many recent GAMES contained all winning digits within the filtered range. In the example above, 39% of recent games contained all three winning digits that were out 3 games or less when they hit. Because Digits 3, 4 and 8 are currently above the filter range of 3, they are grayed out. You can also change the Skip Position value (Pos 0-3:) to see skips and percentages by front, middle, or last digit only.


Wheel Filter SettingsBelow the Digit Skip reference table, you will find multiple filters that DO affect the combinations in every wheel. This functionality transforms each wheel from a static set of numbers to a dynamic output of combinations that only match the type and favorability that you select!

When all boxes are checked, you will be given the full set of Pick 3 combinations that can be arranged from all digits entered into a wheel’s input field. Clearing the check boxes will remove combinations that match the type that was cleared. When filtering out Uniques, Doubles, and Triples, the remaining combinations will always be the same from draw to draw. However, when filtering out Favorable, Cautionary and Unfavorable combinations, the combos that remain are valid for the current draw only, and a new combination set is generated after you update the Draw History.

IMPORTANT: The skip charts for each wheel are consistent from draw to draw, because they check the wheel’s CURRENT settings with Favorability conditions in the past to generate the skips.


There are five dynamic wheels available in the “Wheels” worksheet of P3 Charts™:

WHEEL #1:   Any order / Up to 8 digits (120 combinations)

Box Pick 3 Wheel

Wheel #1 is a basic box wheel that allows you to play up to 8 digits together. The more digits you enter into the input fields, the more combinations that appear in the output table, all of which are color-coded to their current box Favorabilty rating based on the draw history. When wheeling eight digits, you will have a total of 56 Uniques, 56 Doubles, and 8 Triples.

WHEEL #2:   Any order / Up to 2 Key Digits with up to 8 additional digits (90 combinations)

Key Digit Pick 3 Wheel

Wheel #2 is a Key Digit box wheel that allows you to play one or two favorite digits with up to eight more digits. If playing two key digits, the combinations generated will reflect all additional digits with the first key digit, and all additional digits with the second key digit, but NOT both key digits together.

EXAMPLE: How many times have you played a favorite pair, only to have one of the pair’s digits hit and not the other? With Wheel #2, you can enter both digits of a pair as your two Key Digits, and all additional digits will be played with the two key digits exclusive of each other!

When playing 1 Key Digit and eight additional digits, you will have a total of 28 Uniques, 16 Doubles, and 1 Triple (which is the Key Digit, because none of the additional digits can make a triple). With 2 Key Digits and eight other digits, you'll have a total of 56 Uniques, 32 Doubles, and 2 Triples.

WHEEL #3:   Exact order / Up to to 8 digits per position (512 combinations)

Straight Pick 3 Wheel

Wheel #3 is the only straight wheel in P3 Charts™, so any combination appearing in this wheel's output table will be color-coded to the combo's straight Favorability rating. At least one digit must be entered in each of the three input sections (front digit, middle digit, and last digit) for a combination to generate. When wheeling 8 digits per position, you will have a varying number of Uniques, Doubles and Triples, depending on how many identical digits appear in more than one position.

WHEEL #4:   Any order / Up to to 2 pairs with up to 8 digits (16 combinations)

Pick 3 Pairs Wheel

Wheel #4 is a box pair wheel that allows you to wheel one or two pairs with up to eight third digits. The total number of Uniques, Doubles and Triples will vary depending on the number of identical digits appearing in the pair AND the additional third digit fields.

WHEEL #5:   Any order / Up to 3 pairs with any third digit from the last game (9 combinations)

Pick 3 Pairs Wheel

Wheel #5 is a unique box wheel that takes one, two, or three pairs and wheels them with any third digit that came up in the previous game (a repeating digit). This wheel is based on the concept that 61% of all Pick 3 draws contain at least one repeat digit that hit in the last game - so why not improve your odds by playing your favorite pairs with those digits? The most recent winning digits are shown in green below the output table (0, 1, and 5 in this example), and these numbers are used to generate combinations which vary from draw to draw depending on results from the previous game.

HINT: In Tutorial 3: Digit Skips, we discussed how to spot upcoming pairs by looking for large gaps and recent hits near the top of the Visual Digit Skips column. Instead of choosing just one pair, you can look for three digits with a wide gap / recent hit pattern, enter these pairs into Wheel #5, and you'll be given a potent set of combinations based on overdue and repeat digits! You can further improve your odds by setting Backtest Mode to 10 games in the past before selecting your three pairs from Visual Digit Skips. Just remember to disable Backtest Mode when reading combinations in the wheel's output table, because these combos are based on winning digits from the actual previous draw!


For even smarter Pick 3 wheels, why not check their combinations against the Draw History in real-time to see when any of the numbers last hit? This was the goal behind the P3 Wheels™ Skip Chart, which is visible at the top of the “Wheels” worksheet.

P3 Wheels™ Skip ChartAny fixed group of numbers in a lottery wheel has its own pattern of skips that may or may not be favorable for another hit soon. You can see these skip patterns when any of the five wheels contain enough digits to generate at least one combination. Total wheel combinations are listed across the top, and this count (along with the skips) is automatically adjusted based on the current worksheet filter settings.

NOTE: If an asterisk ( * ) appears at the top of the wheel, this means that the wheel's combinations are dependent on the last game's winning numbers, and therefore change from draw to draw. The actual skip patterns remain consistent, because the worksheet checks conditions that existed prior to draws in the past before plotting the skips.

In the example at right, we see skips for Wheel #1 which is using 4 digits to generate a 16-combination box wheel that filters out Triples. These wheeled digits are 5, 6, 7, and 9 (see screen shot at top of this page). The resulting combinations are consistent from draw-to-draw because all three Favorability ratings are active in the wheel's filter settings. This is also a “Prime Play” wheel because it recently hit 6 games ago, and has multiple large skips at the top of its skip bar, including a maximum skip of 73 games.

Three days later, the winning number 799 was drawn, which is one of sixteen box combinations generated in our wheel! As you can see, P3 Wheels™ are among the most intelligent Pick 3 wheels available today. They provide valuable information about their combinations and instantly check for hits in the Draw History as new digits are entered into a wheel. Skip patterns can then be studied and digits replaced until you find a wheel that appears favorable for a soon hit.


Combination Query Chart

New in P3 Charts™ version 2!  If you scroll right from the P3 Wheels™ Skip Chart, you'll find an all new “Combination Query” chart. Simply enter any 3-digit combination into the three input fields and you'll be given the 25 most recent skips of that combo, as well as exact draw dates when it previously hit as a box, and also as a straight. This chart automatically searches the maximum number of real draws in your game's history, so you need not worry about virtual data being included in the data.

The combination's Box / Straight Favorability is also displayed, along with the Favorability group's hit percentage (70% - 20% - 10%), total hits of the combo, and finally its corresponding Sum, Root Sum, Sum Last Digit, and Reverse Sum values.

In the example above, we've entered a query for the combination 087. Notice that box combo 078 has hit 20 times previously, and also has multiple large and very large skips at the top of its skip bar. This would normally be a “Prime Play” combo except that it's currently out 142 games and did NOT recently hit. However, out of 20 previous hits for a 6-way box, the STRAIGHT combination 087 has only hit once. If we perform a query on all six straights within the box, this is what we find:

078 STRAIGHT:  4 hits  (last hit 835 games ago)
087 STRAIGHT:  1 hit  (last hit 1,482 games ago)
708 STRAIGHT:  3 hits  (last hit 143 games ago)
780 STRAIGHT:  4 hits  (last hit 482 games ago)
807 STRAIGHT:  4 hits  (last hit 1,122 games ago)
870 STRAIGHT:  4 hits  (last hit 228 games ago)

For a box combo alone, this probably isn't a good play because any number currently out a lot of games is likely to sit out even more games. But for 078 BOX to hit 20 previous times, while 087 STRAIGHT only hit once (having the same opportunity 20 times in a row), indicates that 087 STRAIGHT is probably overdue. Sure enough, the winning number 087 was drawn 77 days later on October 23, 2010!


Last 50 Favorability TableThe final chart in the workbook is a Favorabilty table that shows box and straight Favorability of recent winning numbers. To recap – a Favorable combination means the number falls within a pattern that hits 70% of the time, a Cautionary combo falls within a pattern that hits 20% of the time, and an Unfavorable combo falls within a pattern that hits 10% of the time.

Within the “Digit Skips” worksheet, another Box / Straight Favorability chart shows the CURRENT Favorability rating of all 220 box combos and all 1,000 straight combos. It may be useful to compare these ratings to ratings that hit in the past, and this is where the Last 50 table comes in.

If you look below the Combination Query chart, you'll see a list of recent winning numbers, and two vertical columns indicating box Favorability on the left, and straight Favorability on the right. On average, the box and straight columns will EACH show 35 favorables, 10 Cautionaries, and 5 Unfavorables over the Last 50 draws of data. If more or less appear, this is likely a temporary trend that should reverse itself in the next 50 to 100 draws.

NOTE: The Favorability formulas were adjusted to precise 70% - 20% - 10% ratios after analyzing tens of thousands of real and virtual Pick 3 draws. These ratios will remain constant as long as the game consists of random numbers, either by mechanical draw machine or a random number generator.

P3 Charts™ 2.1Congratulations! You have completed the LottoChart Exec™ P3 Tutorial series and are well on your way to discovering patterns of order in random numbers.

While no one can guarantee you'll beat the odds in this game of chance, you at least have the most comprehensive Pick 3 workbook available for putting them straight in your favor!


P3 Charts™ 2.1 for Excel 2007 / 2010 / 2013
Setup file and macros digitally signed for authenticityTrusted Certificate

8 » HOT & COLD  |  9 » WHEELS  |  10 » GLOSSARY





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.