Organising Running & Cycling Events: Entries, Wave Starts, Course Capacity, Aid-Station Supplies & Event Budgets
Run a mass-participation race by the numbers: entry forecasts, fee tiers, start waves, aid-station supplies, kit sizes and the event P&L, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you plan a fictional half marathon, 10 km race and cycling sportive in 8 spreadsheet labs. You build the cumulative entry curve, compare it with last year and forecast the final field with a cap and FORECAST.LINEAR. You find each entry's price window with an approximate XLOOKUP, deduct platform fees and count entries per window with COUNTIFS. You size start waves with ROUNDUP and TIME, seed runners with RANK.EQ, check finish arrivals per minute and chutes, plan aid-station cups and boxes, order shirts, medals and bibs, and finish with break-even entries and a scenario P&L.
Lessons
- Entry Forecasts: Cumulative Sign-ups, Pace vs Last Year & the Final Field Pro
- Fee Windows: Price Tiers by Date, Platform Fees & Net Revenue per Entry Pro
- Wave Starts: Corral Capacity, Start Times & Seeding by Predicted Finish Pro
- Course Flow: Arrivals per Minute, Peak Windows, Gate Capacity & Finish Chutes Pro
- Aid Stations: Number of Stations, Cups per Runner, Litres & Boxes to Order Pro
- Shirts, Medals & Bibs: Size Splits, Overs, No-Shows & Pack Sizes Pro
- Volunteers & Marshals: Posts per Kilometre, Needs per Role & Shift Counts Pro
- The Event P&L: Fixed vs Variable Costs, Contribution, Break-Even & Scenarios Pro