Still on handicapping peter FBC

[FBC]

Hi Again,
i have managed to get a handicap report out of the system and have a couple of final queries.
1/ i have sorted the final report based on final adjusted hcap score how do i then get the rank field to show 1st 2nd 3rd as rank seems to be linked to% result whereas need it to be looking at the final hcap score for its 123.

2/ i have averaged the annual % for each pair and used a sliding scale adjustment(to bring everyone to 50%) to generate their handicaps.Will this work though as i now realise that if i key in 110% this is 10%of the total not of their score. this will create anomalies wont it. How have u done it in the past to get a completely fair and equitable system.

Thanks
Peter
FBC

[ianmac]

1/ i have sorted the final report based on final adjusted hcap score how do i then get the rank field to show 1st 2nd 3rd as rank seems to be linked to% result whereas need it to be looking at the final hcap score for its 123.
FBC

This requires some programming in the report. I am currently building a complete new set of reports (which will become the defaults in the next release). One example I have written is for a multi-section session where the sections are scored separately. This is similar to your problem because the rank is across the field, but we need rank in each section.
See the attached report. You need a 1 winner pairs event with 2 sections in the session. Open this with the [Session] report [change] [designer] and first look at the [calc] tab, menu item [view]/[module] and click [declarations]. The code is

var
srank: integer; //defines the variable

[view]/[events]
groups(0)
[header]
[before print]

srank := 0; //set to zero at start of each section

[detail]
[DBText1]
[onPrint]

srank := srank + 1; //count the lines (sorted by score)

[detail]
[DBText1]
[onGetText]

text := intToStr(srank); //print our rank in this field


2/ i have averaged the annual % for each pair and used a sliding scale adjustment(to bring everyone to 50%) to generate their handicaps.Will this work though as i now realise that if i key in 110% this is 10%of the total not of their score. this will create anomalies wont it. How have u done it in the past to get a completely fair and equitable system.
FBC

We are currently using/testing the player ratings system at several clubs (and have been for years). When you get onto this all your handiacpping problems will go away. The release of this software is imminent.