The Tour of Sufferlandria starts on January 26th.  If you are still using my ERG spreadsheet with your CompuTrainer (instead of TrainerRoad), I’ll be adding the erg file for The Wretched this week.  Stay tuned.
Don’t forget to pay attention to your maximum percentage setting.  Some of the Sufferfest videos can be next to impossible to complete if you have it set too high.

The Sufferfest ERG Spreadsheet has been updated to version 4 and includes support for the lastest video, There Is No Try.

Lately I have switched from using the ERG files with Racermate’s new software.  It’s definitely a step up from the original CompuTrainer software but I’m using TrainerRoad with my Sufferfest videos.

I’ve updated my ERG File Spreadsheet to include the newest video from The Sufferfest, Extra Shot: The Long Scream. The video is a 30 minute time trial effort that is designed to be added to one of the other videos, as if they aren’t tough enough one at a time.

This is a good time to talk about the challenge of taking something completely subjective, like perceived exertion and matching it up with something completely objective, like watts.  The 2 latest Extra Shot videos have pointed out that if you aren’t careful about how you set the limits of your power in the spreadsheet, you’ll be left with a workout that is next to impossible to complete.

Since RPE is dynamic, it’s completely acceptable to have long stretches of a workout at 8, 9 or even 10 out of 10, as long as you realize that what constitutes a 9 at the beginning of a workout may not be anywhere close to what constitutes a 9 at the end of the workout.  But, with ERG files that assign an absolute value to each RPE level, a 9 is a 9, not matter how tired you are.

If you set the spreadsheet up so that your FTP falls at say 7/10 then, by definition, you should be able to sustain that for an hour or so.  But, if the RPEs for that time are in the 8,9 and 10 range, you will either not be able to complete the workout or you are starting with an incorrect FTP value.

If you look at the RPE numbers for the latest video, almost all of the 30 minute effort is between 7 and 8.5.  Keep that in mind when you plug in your power numbers to generate the ERG files.  Pick a maximum power percentage that puts your FTP in the correct range to allow you to ride at the 7-8.5 level for 30 minutes.

 Version 3 of the Sufferfest/CompuTrainer ERG File Spreadsheet is now available for download.  Version 3 adds an ERG file for the latest Sufferfest video, Extra Shot.

In addition, I’ve had a few requests to start the ERG file at the very beginning of the video, instead of when the video title first appears on the screen.  I set up the original spreadsheet with the start-up delay in order to give me time to start the video , get everything arranged, realize that I can’t reach my towel, etc.  But, I want everyone to be happy, so I added a start time field to the tab for each video.  The default will be the current time delay, but you can now specify the elapsed video time when you want to start the ERG file.  If you want to start as soon as the video starts, enter a zero in the green box.

Thanks to fellow Sufferlandrian Graham Dunn for suggesting a simpler calculation of the workout time.

You can read the original blog post about the thought behind this spreadsheet here.

The 2nd version of the Sufferfest ERG Spreadsheet is now available for download.  The download link in the original blog post (Sufferfest on a CompuTrainer) has been updated and points to the new file as well.

Version 2 adds data for the newest Sufferfest video, Hell Hath No Fury.  This 1:15 workout uses footage from the UCI Pro Women’s World Cup races.  The workout, as described on The Sufferfest website:

Onto the trainer and into another world! You are a Sufferlandrian. And you’re racing for the Sufferlandrian National Team in the Tour of Sufferlandria. You’re expected to take the leader’s jersey (and a very special jersey it is) over the race, the stages of which are:

• 3:30 Warm-up
• 5:30 Stage 1: Easy, flat terrain at effort level of 6/10 with a few accelerations
• 20:00 Stage 2: Rolling terrain with a series of attacks as the pack tries to take the lead from you
• 6:00 Recovery
• 20:00 Stage 3: More rolling, attacking racing in which you try to break away to get the lead back
• 4:00 Recovery
• 3:30 Stage 4: Team Time Trial in which you have to crush yourself in order to take the lead, and the Tour of Sufferlandria victory
• 6:00 Recovery, featuring Mental Training Reflection from Athlete’s Audio

I’ve also added the support for the MultiRider format (MRC).  On the tab for each video there is a yellow box containing the text for an ERG file and a blue box with the MRC data.  Pick your poison.  I don’t have a copy of the MultiRider software, so I’d appreciate any feedback on the files from anyone who tries the MRC version.

Matt McNamara, USA Cycling Level 1 coach and president of Sterling Sports Group, recently wrote an article for PezCyclingNews.com titled Sufferfest Videos: From The Power Perspective

Mr. McNamara was kind enough to include a link to my Sufferfest ERG Spreadsheet but his review goes much deeper into how well the videos work as part of a power-based training plan, focusing on the training stress score (TSS), intensity factor (IF) and interval composition.  Check out his review and see how the Sufferfest stacked up.