Hi Springbok,
Well I've uploaded the latest version of the program.
Changes:
Basic documentation is there but not updated with the Columns feature.
A probabilistic wheeling system has been added for people who want to wheel their numbers.
Simple Column calculations and Filtering has been added.
On the Columns screen:
The columns are represented as rows on the grid.
You can re-arrange the order of columns by dragging the appropriate row to the position you want.
you can add in a simple formula:
e.g.
#3 + 5
This would give the current column, the value of column # 3 + 5.
The # implies 'use the column value' the column number is shown on the grid, don't mistake the position of the column for the column number.
you have the following operators
+, -, *, /
The Divide is the integer divide.
To evaluate something like (#3 +5 ) * 2, you would need 2 columns, so you
add a column (# 30)
put in the formula
#3 + 5 (there must be spaces)
add another column (#31)
#30 *2
you can then uncheck 'View Column' for #30 as you don't want to see the interim result.
If you have both a formula and criteria, the formula will be calculated only if the criteria answers true.
if 'Filter Column' is checked, the row will only be displayed if it meets the criteria.
The filter criteria can be as follows:
Code:
#20 = #1
and
#21 > #1
and
#22 > #1
and
#23 > #1
You have >, <, =, <>, >=, and <= available to you.
You also have AND and OR. These must be alone on a new line.
You also have the option to view or hide the zeros.
You can load and save different column layouts to suite your requirements, e.g. one for skipsitters, one for opening-batsmen, etc.
Each time you modify a column's info, I suggest that you re-import your data so that the calculations can come through.
Columns are calculated from 1 upwards max 50 columns.
Thus for column #31,
#35 + #32
will calculate inaccurately, rather add another column (above 35) do the calculation and re-position the column.
Regards
Patrick
I think my lottery abilities have increased a little bit since then.
. This advanced filtering, and definition of your own columns, is taking a while, but I guarantee it's going to be worth it in the end.
