VO2Max estimation spreadsheet
#1
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
VO2Max estimation spreadsheet
I have been following through the energy transfer chemistry that occurs when exercising and realised that you could calculate out a weight of O2 burnt while doing a particular effort based upon this.
See the attached spreadsheet and you can enter your own details (over on the right hand side) and get a figure for VO2Max - which may or may not be accurate to any degree but I think the math works out at least and the numbers it comes up with look sort of right.
I have put some figures up there for Lance and it comes through with 83ml/kg/min - which is pretty darn close to the 85 touted for him.
https://spreadsheets.google.com/ccc?...thkey=CM25-NgD
Issues:
Anyway, let me know your thoughts.
See the attached spreadsheet and you can enter your own details (over on the right hand side) and get a figure for VO2Max - which may or may not be accurate to any degree but I think the math works out at least and the numbers it comes up with look sort of right.
I have put some figures up there for Lance and it comes through with 83ml/kg/min - which is pretty darn close to the 85 touted for him.
https://spreadsheets.google.com/ccc?...thkey=CM25-NgD
Issues:
- Only deals with aerobic energy from glucose (ie. 100% glucose for energy)
- States that the energy generated by 1 mole of glucose is 2880kJ, however 1 mole of carbohydrate should equal 3024kJ by normal calculations for energy (180g x 4cal/g x 4.2kJ/cal)
- Probably someone will come up with some other issues I haven't thought of!
Anyway, let me know your thoughts.
#2
Resident Alien
Join Date: Jul 2007
Location: Location, location.
Posts: 13,089
Mentioned: 158 Post(s)
Tagged: 0 Thread(s)
Quoted: 349 Post(s)
Likes: 0
Liked 9 Times
in
5 Posts
"The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this address in a way that will never complete"
I think BF will allow you to upload a zip or straight XLS.
Firefox has detected that the server is redirecting the request for this address in a way that will never complete"
I think BF will allow you to upload a zip or straight XLS.
#3
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Hmmm - that's odd. I'm using Chrome so it works OK for me (as you'd expect!).
Unfortunately I can't upload to BF - proxy blocks the upload function.
#4
Senior Member
Join Date: Jul 2007
Location: San Diego, CA
Posts: 1,104
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Your 1' power is only 447? Just asking since you said your FTP was around 360? That would be kind of low 1 min power IMO for 360FTP.
#5
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
If you just plug in your max 1' power you are using too much (ie. mostly) of your anaerobic power and not doing oxygen conversion.
Just had a look at the results from my last MAP test in September and that gives 1' maximal power @564W - which I think may be a better number but gives me a stupidly large VO2Max result.
MAP or RAMP test protocol was to start at 200W and increase and hold power by 25W per minute - I finished after 13 minutes which took me up to 500W - so you are aerobic only by that point essentially, but for some reason I have an minute maximal power (MMP) listed as 564.
Hmmm - so now not sure whether I should use 447 (121% of FTP), 500 (MAP figure) or 564 (MMP).
Oh well.
#7
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
#8
Resident Alien
Join Date: Jul 2007
Location: Location, location.
Posts: 13,089
Mentioned: 158 Post(s)
Tagged: 0 Thread(s)
Quoted: 349 Post(s)
Likes: 0
Liked 9 Times
in
5 Posts
I haven't done the test. It's kind of a lab rat number that if I was 20 would be something I'd want to know, but wasn't worth the money to test otherwise. That said it would seem to be in the ballpark given where I fall on performance/Ewang thing.
I used Explorer to get the link to work. Might have to give Chrome a shot.
I used Explorer to get the link to work. Might have to give Chrome a shot.
#10
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
I think that 1g glucose = 4 cal is just a convenient shorthand approximation, where it actually equals 3.81cal/g. Not usually an issue as if you are cal counting you will get most of your information from the nutritional information on the packet. Have looked at other sources, and the 2880 figure is the correct one.
Interestingly, if you look up sugar some use this figure to show energy:
https://www.calorieking.com.au/foods/...k9c3VnYXI.html
whereas some company sites use the larger approximation:
https://www.csrsugar.com.au/Everyday/White-Sugar.aspx
carbs are spot on 16kJ per gram (and there are 4.2kJ per Calorie).
#11
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
I haven't done the test. It's kind of a lab rat number that if I was 20 would be something I'd want to know, but wasn't worth the money to test otherwise. That said it would seem to be in the ballpark given where I fall on performance/Ewang thing.
I used Explorer to get the link to work. Might have to give Chrome a shot.
I used Explorer to get the link to work. Might have to give Chrome a shot.
Thanks
#13
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
One other interesting point (for me at least!) is that if you burn through 180g of glucose you will generate about 108g of water in your body (108mL).
High intensity work could see you burn through this in an hour or less and the average person sweats 0.8 - 1.4L/hour while exercising - so you will likely sweat out 8-14 times the volume of water under normal circumstances, however we would be somewhat closer to balance when doing a hard workout in very cold conditions.
High intensity work could see you burn through this in an hour or less and the average person sweats 0.8 - 1.4L/hour while exercising - so you will likely sweat out 8-14 times the volume of water under normal circumstances, however we would be somewhat closer to balance when doing a hard workout in very cold conditions.
#14
Senior Member
Join Date: Oct 2009
Location: Iowa
Posts: 965
Bikes: 2012 Parlee Z5
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
I just did a VO2 max test for a study and got 62.8. Your spreadsheet gets pretty damn close to that for me
#15
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
#16
Senior Member
Join Date: Nov 2008
Location: TX
Posts: 2,620
Bikes: Orbea Orca Trek 5500 Trek Equinox
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
#17
Overacting because I can
Join Date: Jan 2005
Location: The Mean Streets of Bethesda, MD
Posts: 4,552
Bikes: Merlin Agilis, Trek 1500
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Other than approximations based on some fraction/multiple of another (FTP, MAP, ...), what interval would best approximate your VO2 max power? 6 minutes?
__________________
“Courage is going from failure to failure without losing enthusiasm." (Churchill)
"I am a courageous cyclist." (SpongeDad)
“Courage is going from failure to failure without losing enthusiasm." (Churchill)
"I am a courageous cyclist." (SpongeDad)
#18
Senior Member
Join Date: Aug 2009
Location: Connecticut
Posts: 51
Bikes: QR Seduza, Warp9 Ascent
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
80 for me... with my racing weight from this year. About right maybe a little low.
#19
fuggitivo solitario
i'll have to enter the data when i'm up to doing some CP6 min tests. When i got tested in June (before my crash, so at a possibly higher fitness level), i got 69mL/kg/min. I was producing 360W, for how long, i'm not sure.
Even when i enter 360W, i had to use 21% efficiency in order to get to 69mL/kg/min. This is probably the case as i was sweating so uncontrollably that the electrodes were falling off. Too bad my body temperature wasn't measured, so i can't be sure.
Even when i enter 360W, i had to use 21% efficiency in order to get to 69mL/kg/min. This is probably the case as i was sweating so uncontrollably that the electrodes were falling off. Too bad my body temperature wasn't measured, so i can't be sure.
#21
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts

That's huge. No wonder they liked you on the rowing team! Is that based off FTP?
i'll have to enter the data when i'm up to doing some CP6 min tests. When i got tested in June (before my crash, so at a possibly higher fitness level), i got 69mL/kg/min. I was producing 360W, for how long, i'm not sure.
Even when i enter 360W, i had to use 21% efficiency in order to get to 69mL/kg/min. This is probably the case as i was sweating so uncontrollably that the electrodes were falling off. Too bad my body temperature wasn't measured, so i can't be sure.
Even when i enter 360W, i had to use 21% efficiency in order to get to 69mL/kg/min. This is probably the case as i was sweating so uncontrollably that the electrodes were falling off. Too bad my body temperature wasn't measured, so i can't be sure.
Based off FTP?
#22
gmt
Join Date: Sep 2008
Location: Binghamton, NY
Posts: 12,509
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 45 Post(s)
Likes: 0
Liked 3 Times
in
3 Posts
I put mine in as well, but I think it would be far more accurate if you used 5 minute records. my best 1 minute is firmly in the anaerobic range, and gives me VO2max of 87. No friggin way.
#24
Senior Member
Thread Starter
Join Date: Oct 2009
Location: Melbourne, Australia
Posts: 910
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
For me, max 5 minute average power is about the same as my MAP test though, so 5 minute max average power may be about right - but is dependent upon what sort of anaerobic ability someone has though (ie, it would skew results between someone who could stay in the anaerobic zone for 2 minutes rather than 45 seconds with similar FTP's).