No offense taken. People are free to use or ignore my sheet as they see fit.
I started the sheet and made it purely for my own use originally. My choice to share it was aimed at saving people the time of having to dig as hard as I did into the related data and needing to make their own version.
I still haven’t seen a similar chart, for easy use available elsewhere. I’m happy to review other references in effort to improve mine, if they are out there.
The large amount of data displayed is partly due to the HUGE mix of data mentioned via Dr. Seiler in the casts. Yes, he mentioned the “6’s” numbers for reference at the very beginning. Those are simple on the surface, but seemingly insufficient for simple use.
I say that because they proceeded to relate those “6” terms to other metrics and proceeded to stop using those terms. What you see in my chart (VO2 Max, HR, Power) are those metrics that they chose to use for the remainder of the discussion.
I am fine with the more comprehensive data, because depending on a person’s particular tools at hand, one column or the other may be more important to them. I made the deliberate choice to include them all to give the most options.
People can copy the sheet, hide all unnecessary data (by hiding columns rather than deleting, because I had to make some interesting calculation based on the variety of data and connections they provided) and get a more simple version. All up to the user.
Dr. Seiler gives the following equivalents in discussion: (captured in the lower portion of my sheet, under the chart)
- 6 Minutes Power
- Estimate of 100% VO2 Max Power
- 60 Minutes Power
- True Race (Aerobic Capacity) around 90% HR Max???, 100% FTP?
As such, (and because they essentially abandoned the use of the terms in the cast) I made the specific decision to make my chart driving directly from the FTP and the stated percentages related on VO2 Max and HR values.
Those the bright yellow User Entry cells are the easiest way I could see to incorporate readily available data and generate the values related to the zones.
However, even if you stick with those 2 powers you mention, that only helps you define the top of 2/bottom of 3 as well as the top of 3.
You still need to define the upper end of Z1 via LT1/VT1 or equivalent, so you know the upper limit of all the Z1 training that must also be done.
So, based on the relationships you stated (much of them documented right on the chart, for quick reference) and the correlations they added, I filled in the full chart with everything you see. It includes all the various columns to try and meet all the possible needs, rather than being particularly selective for a single use (that may not work for everyone).
I am not opposed to simplification, but I feel that the “right” simple is likely to vary from person to person and what they want/need to see.
I make no claims that it is the only or best way to do this. In fact, I am sure that its not, and have requested feedback along the way.
So I appreciate your thoughts and will see if I can put them to use. It is a constant work in progress and I make revisions to it almost daily.