I’ll outline my goal, and also give less specific examples to help you see the big picture
I need three different table types:
- One large, ongoing list – keeping track of my team’s every race, along with every team member’s placement, chronologically listed by event.
- A precise list, that shows my teammate’s placements from only one event (which uses data from the ongoing list)
- Another precise list, that displays only one teammate’s results (which uses data from the ongoing list)
I plan to implement this onto a single team’s website. Therefore, I do not need an option to configure data from multiple teams.
However, I’d imagine this plug-in could also be built for use on Race Event websites. So, after an event finishes, they would have data from multiple teams to input (but would always be the same location, on different dates)
But for my purpose, I only need one team. My team doesn’t care about how the other teams finish.
(Here’s an event’s results for a previous event:
http://www.usacycling.org/results/index.php?permit=2008-854)
My purpose is to showcase my team’s performance for every race we do, and then on the individual rider’s page, list a table showing our finishes. We also make blog posts about races, so we would want to insert a table of results for just that event.
My team has 12 members in it. And my team races at 50 different locations a year. So you’d need an option to add members, and to add locations —
It would be nice to have an area to add a description to the location — a prompt to insert the event’s website or other basic information about that previous Race Event.
Results — the ‘result’ is usually a placement — we are racing against other teams at this event — so one teammate might finish 1st and another teammate might finish 31st depending on size of race.
A result could also be a Time — ie 7 minutes, 56 seconds
You could also have DNF (did not finish). You might want to have ‘OTHER, Please Specify:’ for a custom value.
One more column in the table: CATEGORY
My bicycling team consists of members of different “Categories”. They split races into Categories — age and experience brackets — they compete only against those in their category.
- Cat 1
- Cat 2
- Cat 3
- Cat 4
- Cat 5
- Citizen
- Men Cat 1/2
- Men Cat 3
- Women Cat 1/2
- Cat 1/2/3
- Masters
Each event combines Categories in different ways.
So you might have CAT 1/2/3, or just CAT 1/2 and CAT 3, or CAT 1, CAT 2, CAT 3 —
Not too make it overly complicated — but Might be good to have those basic ones, and have an “OTHER: Please Specify” that you can fill in. (like Men’s, Women’s, Juniors). Maybe it could save the custom ones for later use.
Also, there is a RACE TYPE
We race Road Race Events. There are also Track Events (indoor), Off-Road Racing Events (like BMX) and others. These might be more complex and I know nothing about them, but I don’t think they’re as popular, either. (I’m really trying not to give you too much information!)
Road Events are most popular — and what I’m interested in — and these are their types:
- Road Race
- Criterium
- Hill Climb
- Time Trial
- Stage Race
You don’t really need Race Type as an individual column — I could include that information in the Event Description, or in the Event’s Title.
This is a good link, of a good (static) Bicycle-team results table:
http://starkvelo.com/results/
With some creative thinking you might be able to make this customizable to use as a Racing Results template. There are no home or away teams. Imagine an Auto-race, you have 30 drivers all trying to win on one course.
Please check out these examples I made using WP-Table Reloaded
RACE RESULTS — the “One Large, Ongoing list”
INDIVIDUAL RACER — “Teammate Placement”
INDIVIDUAL RACE – “Race Placements”
Okay. Koelle. Lol. If you can make this happen for me I would be so grateful. Shoot me an email at StealthA00 at yahoo dot com if this is going to take a lot of time, I really need it done and my alternative method to do the results is incredibly sloppy and has me doing twice the amount of work.
