2 In the Min Max columns I presume the values in these columns are the extremes of the values found in the simulation process thus if one uses the entire ticket package for simulation then any result obtained from the next draw cannot be worse or outside these min max values - good information to know. Could these two columns be enhanced to allow a swap between SUM and Differences please.
what for? diff is simply 'SUM' column - 'MAX' or 'MIN' column...
Yes agreed, but it is much easier to see the scale of the range when it is expressed under Differences. If I could copy these SUM column values into the SUMS filter I could then see the Diff values within that filter however this copy process from Excel to SUMS filter has some significant issues.
Copying into the filter becomes an additive process ie any numbers in the respective column cells are not over written but added to, thus you can get differences in 100's. Second if you erase the incorrect values or reset to initial values the next copy paste function will
only paste into the MAX Diff column. It is not possible to paste into the MIN Diff column.
I consider it desirable to be able to copy these values derived from the Simulation process out of a full package into the SUMS filter as these values cannot be exceeded by any number set occurring at the next lottery draw, ie one thus has the outside limits of the SUMS filter process easily and quickly determined.
thanks
falcon