Athlete Data Collection Pen17

Penticton 17 Results – Please compile the following on an excel worksheet(s) [login to view URL] 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 5. Cross 6. Aquathlon 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