Daniel/Cofad,
Thank you very much for your input. I have added some colour coding to the orginal spreasheet (lost in conversion to 2003 I am afraid Daniel, but you had the gist anyway). Please see the explanation below, hopefully this makes it more clear?
The spreadsheet is to score a horse dressage competition. In a class there will be a number of competitors all with a unique competitor number. The judge provides a marking sheet with scores for each of the movements performed (these are represented by 1 – 30 on the “Score Calculator” sheet). The scores are input from the sheet for each competitor, identified by their competitor number. The results for that competitor are transferred to the “Class sheet”, sheet and then ranked according to the highest percentage with the total collective scores acting as the arbitrator in the event of a tie.
Thank you again.
Adrian
Score Program.xls
Score Program 2007 Ver.xlsx
Bookmarks