Winning Numbers History Filter

Menu: Filters  Winning Numbers History  Sums

This is one of the most important application filters closely related to the Winning Numbers History page. The filter allows to process large numbers of tickets including the full list of all possible number combinations. If you manage to estimate correctly the minimum and maximum values for filter parameters (in the range of +/- 10) you can reduce the full package to a small set of tickets, which is guaranteed to include the Jackpot winning ticket!

The left hand part of this window offers controls for winning numbers selection.

The rest of the window contains controls to setup filter's parameters. It also includes buttons Update Sums and Lookup Min & Max Ranges. The filter is not active if the package is empty.

The right hand part of the window offers a table where you can enter the minimum and maximum allowed values for sums calculated in the Number History page to filter tickets in the package. See also Winning Numbers History.

Example [Expert Lotto 6/49]

After filtering the package will contain only tens to hundreds of tickets. These tickets will always contain the ticket you wrote down earlier and marked as Skipped in previous steps, i.e. the Jackpot winning ticket. You can verify this in the Visual Package page by entering ticket's numbers into the panel and Removing match in 0, 1, 2, 3, 4, 5.

Example [Expert Lotto 6/49]:

  1. Generate tickets for all combinations from 49 numbers into the package. Use button Simulate in the History differences page to find the average, minimum and maximum values and the percentage of probability that the sum value will decrease. Write down these values and also the current value. The table in our example looks like this:

    Column number
    (header)

    Current
    value

    Median
    value
    Minimum
    value
    Maximum
    value
    Probability of
    decrease [%]
    0
    373
    376
    301
    413
    39
    -1
    754
    756
    661
    795
    32
    -2
    1210
    1203
    1109
    1248
    60
    -3
    1631
    1628
    1556
    1671
    56
    -4
    2018
    2019
    1958
    2057
    44
    -5
    2406
    2407
    2324
    2447
    45
    -6
    2774
    2777
    2719
    2815
    38
    -7
    3123
    3129
    3032
    3166
    35
    -8
    3496
    3499
    3432
    3536
    40
    -9
    3836
    3843
    3786
    3876
    29
    -10
    4232
    4232
    4161
    4270
    46
    Note: value in the last column [%] could differ slightly as they are the result of random processing.
  2. Now use the history charts - Summary Chart, Differences Chart - to refine the minimum and maximum values and to estimate the future values for column "0" to "-10" (the sum will increase or the sum will decrease).
  3. Return back to the History Differences page. Use your estimated min and max values and the trend for sum values to divide drawn numbers into segments. For a large decrease in sum values you should favor the last segment and require that each ticket should contain one to two numbers from this segment. The figure below shows settings for estimated sum decrease in the 1st column:
  4. Click Filter button to filter tickets in the package according to your segment settings. Repeat this for all columns in the History Differences page.
  5. Use menu Filters - Winning Numbers History - Sums. Click button Update Sums and then Lookup Min & Max Ranges to see your filtering results from the previous steps.
  6. Compare values in the table with your estimates from the second step and make corrections if needed. The tickets remaining in the package will again include the jackpot winning ticket.

Notes:

  1. In the example above we used functions from the History Differences page (Simulate) to estimate the min and max sum values. However you can use any 'reasonable' value. Keep in mind that the maximum sum value increment for all columns is +43 (for a 6/49 lottery). The maximum sum decrease in all columns is the sum of six largest differences.

  2. You can reduce tickets in the package using all rows in the table, using any rows combinations or using a single row only. To use all checked table rows in filter's condition select And in the Logical Condition option. If one row only is enough to pass the filter select Or.

  3. Entering lower value into the Max column then the Min column is not allowed and is indicated by an error message.

  4. You can use also the following condition for ticket filtering:

    The condition is that the given number of columns (4 to 6 in this case) must have the difference of the next sum from the current sum from the given range (-10 to +10 in this case). Setting difference range "0 to 0" for "1 to 1" column will enforce that at least one column will have the same sum value in the next draw.

  5. Option At least X to Y columns must pass can make the filter more relaxed. This option is especially useful if you are not sure with your estimates. You can define values for all columns and using this option you may specify that it is enough if ticket meets filter condition in e.g. 3 to 6 columns only.
  6. Using history differences is an approximate method. Therefore you can allow wide range of value at first and refine them in next steps.
  7. You can use table columns labeled Odd and Even as another part of filter condition. This way you can choose whether the history sum value in the appropriate history column must be odd or even. Therefore it is possible to use wider sum ranges and then reduce the number of tickets left after filter by approximately by half by choosing the odd or even option.
  8. Table column labeled Lock blocks the appropriate history index against the usage of option At least X to Y columns must pass - the filter condition for sum range of the 'locked' must be met at all times and the option At least... applies to the remaining "unlocked" columns only. This switch is especially useful for columns where you are absolutely sure with your sum range estimate.
  9. Buttons with up and down arrows to the right of the table are enabled when one or more cells are highlighted in column Min Diff or column Max Diff. Using these buttons you can increase or decrease the values in highlighted cells.
  10. The required values for differences and sums can also be transferred from external applications (e.g. spreadsheet processor) using Copy (Ctrl+C) and Paste (Ctrl+V) feature of your operating system.

Note: If you move both margins with your mouse in chart WN History History Charts Summary Charts/Differences Charts these new resized positions are offered in appropriate dialog for this filter inside the columns Min, Max.