Dynamic cross tab and championship
Posted: Mon Sep 12, 2005 11:00 amHi !
I’m working on a system to manage an Agility Championship (with Dogs!)
This year the championship have 6 competitions in different places, and each competition consist of 2 events:
1_Grand Prix de France (GPF)
2_Jumping (Jump)
Each dog take part in 12 events: 6 GPF and 6 Jump.
For the ranking we take the 4 best scores of the 6 GPF, and the 4 best score of the 6 Jump , and add the 8 values. The winner has the maximum of points.
After each competition we need to know which dog is the temporary winner. This is quite simple after the 4 primary competitions (I do that in a simple portal).
After the 5th competition we have to remove the worst score of the 5 GPF and the worst score of the 5 Jumps (for each dog).
After the 6h competition we have to remove the 2 worst scores of the 6 GPF, and the 2 worst scores of 6 jumps.
To complicated the things we need to display (user interface) the results as a cross tab (we actually do that manually on a spreadsheet) with:
- rows = the dogs
- 12 columns (1 for each event)
- 13th column the summarize of the 8 best score of each dog
Look like this after the 5th competition:
............G1...J1...G2...J2...G3...J3....G4...J4....G5...J5...G6...J6...Total
Dog 1....10...09...10...10...05..[04]..08...09...[04]..07................60
Dog 2
Dog 3
Dog 4
We omit: J3 = 4 and G5 = 4 which are the worst scores and the total is: 10 + 9 + 10 + 10 + 5 + 8 + 9 + 7 = 60
Look like this after the 6th competition:
............G1...J1...G2...J2...G3...J3...G4...J4....G5...J5...G6...J6...Total
Dog 1....10...09...10...10...05..[04]..08...09..[04]..07..[02]..[2]....60
Dog 2
Dog 3
Dog 4
We omit:
J3 = 4 and J6 = 2
G5 = 4 and G6 = 2 which are the worst scores
and the total is: 10 + 9 + 10 + 10 + 5 + 8 + 9 + 7 = 60
It was looking so simple on the spreadshit ...!
((
------------------------------------------------------------------------------------
My actual structure:
Table Dogs
Table Dogs particiption [Join]
Table Events
Table Competition
------------------------------------------------------------------------------------
Thanks in advance
Patrick
I’m working on a system to manage an Agility Championship (with Dogs!)
This year the championship have 6 competitions in different places, and each competition consist of 2 events:
1_Grand Prix de France (GPF)
2_Jumping (Jump)
Each dog take part in 12 events: 6 GPF and 6 Jump.
For the ranking we take the 4 best scores of the 6 GPF, and the 4 best score of the 6 Jump , and add the 8 values. The winner has the maximum of points.
After each competition we need to know which dog is the temporary winner. This is quite simple after the 4 primary competitions (I do that in a simple portal).
After the 5th competition we have to remove the worst score of the 5 GPF and the worst score of the 5 Jumps (for each dog).
After the 6h competition we have to remove the 2 worst scores of the 6 GPF, and the 2 worst scores of 6 jumps.
To complicated the things we need to display (user interface) the results as a cross tab (we actually do that manually on a spreadsheet) with:
- rows = the dogs
- 12 columns (1 for each event)
- 13th column the summarize of the 8 best score of each dog
Look like this after the 5th competition:
............G1...J1...G2...J2...G3...J3....G4...J4....G5...J5...G6...J6...Total
Dog 1....10...09...10...10...05..[04]..08...09...[04]..07................60
Dog 2
Dog 3
Dog 4
We omit: J3 = 4 and G5 = 4 which are the worst scores and the total is: 10 + 9 + 10 + 10 + 5 + 8 + 9 + 7 = 60
Look like this after the 6th competition:
............G1...J1...G2...J2...G3...J3...G4...J4....G5...J5...G6...J6...Total
Dog 1....10...09...10...10...05..[04]..08...09..[04]..07..[02]..[2]....60
Dog 2
Dog 3
Dog 4
We omit:
J3 = 4 and J6 = 2
G5 = 4 and G6 = 2 which are the worst scores
and the total is: 10 + 9 + 10 + 10 + 5 + 8 + 9 + 7 = 60
It was looking so simple on the spreadshit ...!
((
------------------------------------------------------------------------------------
My actual structure:
Table Dogs
Table Dogs particiption [Join]
Table Events
Table Competition
------------------------------------------------------------------------------------
Thanks in advance
Patrick