Week 1 test spreadsheet calculations
Coaches,
when I click on the week 1 test spreadsheet, I see a bunch of calculations (Monod, etc, and %ages) performed for about half the group, but not for the rest. Two questions:
- Are we supposed to be doing anything with those numbers? Could you give us a quick overview of what it means / is there for?
- Are we going to see the rest of the numbers entered on the sheet?
Thanks!
Mike
0
Comments
Mike -
Great Q! Sorry for the no numbers thing, that was a miscommunication between RnI...I have filled those in for you.
The columns should be self explanatory, as we compare FTPs, etc. The one ? is probably around the Monod Critical Power Model. This is from a study (1965?) that showed the ability to predict value along a power/duration curve based on a few values. Much like we use 2 x 20' inside EN to guesstimate 60' FTP, the Monod method allows for using shorter values, in this case 5' and 20' to predict 60' watts. So you have an FTP, and you have a 20' * .95 (Coggan method); so we use the Monod calc to see how accurate these numbers are...almost like a baseline. A few watts differential is okay, but a great deal (see column R) as in anything more than 5%, begins to raise eyebrows....not such a biggie on first test, but by end of PC folks should be closer to FTP....and hopefully stronger too!
P
Thanks, Patrick! Quick follow-up question.
How are you calculating the Monod power? As I understand it, the Monod calculation takes the slope of the work vs. time relationship, or looks like this:
[ 20 min power * 1200 s - 5 min power * 300 s] / [1200 s - 300 s] = Monod Critical Power ~ Threshold
But when I do that calc on the numbers I put up, I get a different number than in the spreadsheet. I'm guessing that there's some adjustment based on the fact that the 20 minute test is being done fatigued, but am curious to know how you're approaching it.
Thanks!
Mike
MG -
I have added you to the master data sheet to see the calcs for yourself. We do use the slope, but it's tricky managing watts vs work (kilojoules)...see for yourself...
P