Penticton 17 Results – Please compile the following on an excel worksheet(s)
[url removed, login to view]
Age Group and Open Wave only please excel tables for the 6 events below.
1. Long Course
2. Aqua Bike
3. Duathlon Standard
4. Duathlon Sprint
In each table please include the following data.
Event, Individual Name, Age Category (You can sort at the top), Country (Can be found by clicking on the athlete’s name), Gender (Note you can sort at the top by gender and category)
From this initial combined set of data please sort by name and create a separate table of those who completed more than 1 event, which events they participated in.
Please produce a summary table to show by each event
No. of people in each event
No. in each age category of each event
Male / female break down by each event
Country breakdown by male/female in each event.
Please compile a table combining all events combined to show:
No. of people that participated in all 6 events (note some people entered more than one so remove the additional entries)
The event or events that they participated in.
No. in each age category across all 6 events
Male / female break down across all events
Country breakdown by male/female across all events