Lightwave
Ad astra
- Local time
- Today, 16:25
- Joined
- Sep 27, 2004
- Messages
- 1,521
Hello everyone
Another questions about a race timing system
4 finishers
In a report or a form what do you believe is the optimal way to rank finishers such that people with the same time are marked equally
eg
1 - John
2 - Bill
2 - Colin
4 - Thomas
With the ranking running automatically off a completion time field/calculation with the competitors in 2nd equal position having equal time. To be constructed in such a way that there could be infinite no of competitors with the same time such that a in a race of 101 competitors with 100 finishers crossing at the front at the same time they would all be ranked 1st and the next competitor would be ranked 101st.
I was thinking rank by time. Calculate time between ascending list count from 1 if zero between ascending list maintain count else use count...
Just mulling over ideas.
Another questions about a race timing system
4 finishers
In a report or a form what do you believe is the optimal way to rank finishers such that people with the same time are marked equally
eg
1 - John
2 - Bill
2 - Colin
4 - Thomas
With the ranking running automatically off a completion time field/calculation with the competitors in 2nd equal position having equal time. To be constructed in such a way that there could be infinite no of competitors with the same time such that a in a race of 101 competitors with 100 finishers crossing at the front at the same time they would all be ranked 1st and the next competitor would be ranked 101st.
I was thinking rank by time. Calculate time between ascending list count from 1 if zero between ascending list maintain count else use count...
Just mulling over ideas.