Oh great! Thank you. Here is a link to our team website FYI.
https://www.mentorcrosscountry.com
Cross country is a running sport like track except running is the only event. There are two teams, boys and girls. Those teams are broken down by varsity (7 fastest runners) then JV (next 7 fastest) and then open (everyone else) and the team they are on may change depending how fast they are at any give race. So one race they may be varsity but the next they may move to JV if they don’t make the top 7 of the previous race. Not sure if we need to keep track of what team (varsity, JV, open) as it may change over the course of the year but we definitely need the team broken down between boys and girls.
Meets (known as invitationals) involve several schools so it’s not just one school competing against another other. Most meets involve the varsity, JV, and open teams but sometimes a meet will only have varsity or only have open.
While runners are competing for individual times, it still is a team sport points are awarded for the order how runners cross the finish line. We wouldn’t need to calculate the scores but we want to have overall team results (meaning how we did at each event against the other teams). We do need to keep track of individual times for each race as well.
We also need to keep track of personal records or PR (best time in a race of a specific distance) and would need the information as follows:
First Name, Last Name, Current Year PR Time, Race it what achieved, Lifetime PR time, Race it what achieved
I hope I have givev you enough information but please let me know if you need more.