Cycling by the Numbers: Gearing, Power Zones, Normalised Power, Training Load & Climbing
Work out gears and speeds, power zones, training stress and climb times from ride data, 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 analyse a fictional club rider's bike and ride files in a spreadsheet that checks every cell as you go. You build a two-way gear table of development and speed at a cadence, measure the steps between cogs and count overlapping gears. You turn a 20-minute test into threshold power, W/kg and personal power zones with XLOOKUP, and compute normalised power from a rolling average and the 4th power. You rate rides by intensity factor and training stress, total them per ISO week and model fitness, fatigue and form. Finally you estimate the power a climb needs, the time it takes and an event pacing plan.
Lessons
- Gearing: Gear Ratios, Development & Speed at a Cadence Pro
- Gear Steps: Percentage Jumps Between Cogs and Overlapping Gears Pro
- Threshold Power, Watts per Kilo & Training Zones Pro
- Normalised Power: Rolling Averages, the 4th Power & the Variability Index Pro
- Intensity Factor & Training Stress per Ride and per Week Pro
- Fitness, Fatigue & Form: Exponentially Weighted Training Load Pro
- Climbing Physics: Power for Gravity, Rolling & Air Drag, and Time for a Climb Pro
- Event Pacing: Target Power per Segment, Work in kJ & Finish Time Pro