Sums History
This filter accepts tickets that produce History sum differences in given range in selected History Levels.
To use the filter, first click Select button to choose past winning
numbers draws to calculate the History values from. Then tick History
Levels you wish to filter in the table below and enter the desired
minimum and maximum difference for each selected Level. Column Sum
(Prev) shows the History Sum values corresponding to the latest draw
from the selection of past winning numbers. Column Difference (Prev) is
History sum difference corresponding to the latest draw (History sum of
the latest draw minus the History sum value of the second latest draw
from the selection of past winning numbers). Column Range shows the
selected range of History values for given Level.
With option At least X to Y levels must pass you can specify the
minimum and maximum count of selected Levels that must have the History value in the given range to pass the whole filter.
Optional condition The difference in X to Y levels is at most
A to B makes the filter more strict by specifying the minimum and
maximum difference for several History Levels. Note: If the range
specified by values A and B is bigger than the ranges in all selected
Levels then this additional condition has no effect on filtering
results.
See also In Range Differences statistics.
You can tick/untick multiple Levels with a single click -
select table rows you wish to modify using your mouse and then click
into the Level column of one of the selected rows.
You can increment or decrement differences in multiple table
cells using your keyboard - select table cells your wish to modify and
then press CTRL+up arrow key to increment values in all selected cell.
Press CTRL+down arrow key to decrement values in all selected cells.
You can
paste the differences from system clipboard. For example highlight two
rows or two columns of cells in MS Excel, press CTRL+C to copy the highlighted values into system clipboard, click into the table in filter window and press CTRL+V to paste the values as new filter parameters. Pasting a single row or a single column of cells inserts the values into both Min and Max columns respectively.
Note: When using this filter from My Estimates window, most of the filter settings are already preselected.
Example - Expert Lotto 6/49 Demo Lottery
- When filter settings are Winning Numbers: 10 latest draws, Level
0: Min Difference 10, Max Difference 20, Level 2: Min Difference 10,
Max Difference 20, Level 2: Min Difference 10, Max Difference 20, At
least 3 to 3 levels must pass then the filter accepts tickets which
produce increased History sum values in the first three Levels:
- 01-02-03-06-12-23 - filter accepts this ticket because its
History sum values in Levels 0 to 2 are 387, 764 and 1201 respectively.
Which makes differences of +11, +20 and +15 when compared to the latest
selected draw. All three values are in desired ranges.
- 01-02-03-04-05-06 - filter rejects this ticket because its
History sum values are 372, 759 and 1198 in Levels 0 to 2. Which makes
differences of -4, +15 and +12. Only two Levels are in the desired
range.
- When filter settings are Winning Numbers: 10 latest draws, Level 0:
Min Difference 10, Max Difference 20, Level 2: Min Difference 10, Max
Difference 20, Level 2: Min Difference 10, Max Difference 20, At least 2 to 3 levels must pass then:
- 01-02-03-04-05-06 - filter accepts this ticket because its History
sum values are 372, 759 and 1198 in Levels 0 to 2. Which makes
differences of -4, +15 and +12 and at least two Levels are in the desired
range.
- 01-02-03-04-05-08 - filter rejects this ticket because its
History
sum values are 366, 761 and 1195 in Levels 0 to 2. Which makes
differences of -10, +17 and +9. Only one Level is in desired range
which is outside the allowed range in condition At least 2 to 3 levels
must pass.
- When filter settings are Winning Numbers: 10 latest draws, Level 0:
Min Difference 10, Max Difference 20, Level 2: Min Difference 10, Max
Difference 20, Level 2: Min Difference 10, Max Difference 20, At least
3 to 3 levels must pass, The difference in 1 to 1 levels is at least 13 to 14 then the filter accepts tickets which produce
increased History sum values in the first three Levels and exactly one of those Levels has the difference of 13 to 14:
- 01-02-03-06-12-36 - filter accepts this ticket because its
differences are +11, +15 and +14 in Levels 0 to 2. All the differences
are in the desired range 10 to 20 and also the difference in Level 2 is
in the range of 13 to 14 as specified in filter's last condition.
- 01-02-03-06-12-23 - filter rejects this ticket because its
differences are +11, +20 and +15 in Levels 0 to 2. All the difference
are in desired range of 10 to 20 but there's no Level with the
difference of 13 to 14 as specified in filter's last condition.