![Old](images/statusicon/post_old.gif)
31st August 2003, 12:09 AM
|
Member
|
|
Join Date: Jan 1970
Posts: 40
|
|
Hi Nanook,
As Chrome Prince suggested unless you have a good understanding of excel a data base application is your best bet.
However excel can be used easily if you just want to review you selection data, Best Track, Distance or so on.
To do this type your headers in row 1, ex date, venue, race #, dist and so on.
in row 2 ( to count ex number of races ) use
<< =SUBTOTAL(2,a5:a100) >> adjust to suit and to add << =SUBTOTAL(9,b5:b100) >>
then from row 5 add your data, once this has been done add a filter by clicking on row 4 then selecting << Data > Auto Filter >>.
By adding the count formula to say your race number and the add to your dividend you will get the number of races and $ based on your filter allowing testing per track / distance or any combination you wish.
These figures can than be converted to a POT showing the best Outcomes.
R
Pete
[ This Message was edited by: OZDOC on 2003-08-31 01:36 ]
|