Dynamic cross tab and championship

General support questions.
Posts: 5
Joined: Fri Aug 12, 2005 7:53 am
Location: Saint-Denis (La Reunion)
PostPosted: Mon Sep 12, 2005 11:00 am
Hi !

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
Patrick Odelin
Anaesthesiologist
La Reunion Island (Indian Ocean)
GMT + 4

Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

(855) SEEDCODE
[email protected]
Follow us: