History Sums

[djdez]

Hi Stan

Is it possible to build a complex filter for history sums, where i will enter specific sums to use e.g level 0 must have an option to enter 318, 319, 320, 330, 331. Cause right now its very tedious to this as i have to enter the range 318 to 331 then exclude 321 to 329 manually and when doing for all levels and maybe 20 sums per level it just is a nightmare.

The reason why i want this is i have got my own method to estimate history sums and i specifically enter certain sums not in ranges.

[stan]

you can copy the values in e.g. ms excel sheet or a text and then paste them into filter window.

[djdez]

Hi Stan

Can you give me short instruction on how to do this..Im getting closer to the jackpot...

[stan]

just create two rows or two columns of sum values in ms excel, highlight them with your mouse, press ctrl+c
switch to expert lotto, click into the table in history sums filter window, press ctrl+v

[djdez]

Hi

But that table has level,min, max and range its not accepting..See what values i want to copy:

level0 level1 level2 level3 level4 level5 level6 level7 level8 level9 level10
374 850 1251 1662 2026 2348 2806 3142 3591 3992 4353
379 855 1256 1667 2031 2353 2811 3147 3596 3997 4358
384 860 1261 1672 2036 2358 2816 3152 3601 4002 4363
389 865 1266 1677 2041 2363 2821 3157 3606 4007 4368
394 870 1271 1682 2046 2368 2826 3162 3611 4012 4373
399 875 1276 1687 2051 2373 2831 3167 3616 4017 4378
404 880 1281 1692 2056 2378 2836 3172 3621 4022 4383
409 885 1286 1697 2061 2383 2841 3177 3626 4027 4388
414 890 1291 1702 2066 2388 2846 3182 3631 4032 4393

[stan]

you have to copy one set of values at a time. e.g.

374 850 1251 1662 2026 2348 2806 3142 3591 3992 4353
374 850 1251 1662 2026 2348 2806 3142 3591 3992 4353

then

379 855 1256 1667 2031 2353 2811 3147 3596 3997 4358
379 855 1256 1667 2031 2353 2811 3147 3596 3997 4358

etc...

[djdez]

Hi

Okay i see. But it wont do what i want because the list contains sums i want in any order not just one line so i have to do it manually. e.g

374 850 1251 1662 2026 2348 2806 3142 3591 3992 4353
379 855 1256 1667 2031 2353 2811 3147 3596 3997 4358

but this is still valid
374 855 1251 1662 2031 2348 2806 3147 3591 3997 4353

In other words from the list i supply i want all possible combinations of the sums to give possible tickets in the package table..
In terms of SQL it can be like WHERE level0 IN (374,379,420,422,438,445) and level1 IN (850,855,878,880,883) e.t.c until all levels are finished. This is a superb filter to try different tricks especially also using What If, it will be quicker.

[stan]

i see. you'd have to build a complex filter consisting of a lot of history sum range filter. one filter for each level and each sum value. but that would be very tedious i'm afraid.
feel free to enter a feature request for a specialized history sum filter that would read the sum values from e.g. text file.

[djdez]

Thanks Stan

Where do i enter the feature request.

[stan]

http://expertlotto.com/issues

but since this is a feature for a single user only it will have low priority only:)