Power vs. Category
 

Yesterday someone posted an image chart of various 'average' 5 s, 1 min, 30 min power outputs in W/kg for various Cat's... I should've saved it, but didn't.

Anyone have it...? Thanks.

Edit: Oops! Thanks BD.

P.S. - what does FT mean?

Is this it

http://www.bikeforums.net/showthread.php?t=279938

^^ not really, I've read Power411 so many times :)

Functional Threshold - sustainable power for 40km TT or 1 hr.

Thanks! So here's my output from last year. I didn't try to maximize anything (i.e., I wasn't specifically trying to make any of these numbers good), I was just riding along like I normally do.

http://i179.photobucket.com/albums/w...maxpower-1.gif

So that basically confirms what I already knew - I suck at sprinting. Oh well, time trials for me!

http://i171.photobucket.com/albums/u...calculator.jpg
I fiddled around with mine so that i can input some cells in excel and it automatically highlight's my w/kg ratio, it's fun to play around with "ok, if i lost 17lbs and could produce another 120watts..... "

5s=16.14
1min=8.14
5min=5.0
FT=4.0

This puts me firmly at the top of Cat 3, although I haven't done a field test in over 3 months so I'd guess my FT is better than that right now.

45 years old
5'10" tall
146 lbs.

Has this table been updated since it was orginally set?

I wonder if you can use this chart for upgrades :D

"but, but, the chart says I'm a cat 3"

How do you tie-in the cell color with, say, a true/false statement?

So who has better sprinting numbers than one hour numbers?

http://home.gwu.edu/%7Ebdcheung/profile.jpg

Apparently I'm a good sprinter?

For those of you racing (and with power meters) is it correct for you? Are you placing in the cat that it says you should be?

yup. i'm a lovey dovey Cat5

Ironically my chart is completely wrong, every race i won (3?) was in a bunch sprint However i am a Cat4 just a little to slow at my peak to contend in the 1/2/3 pack. As for my sprinting bias, I could just be scared of hard work though, but i do love to climb. Our one climbing race of the season with a ~9 minute climb 6% cut the cat4/masters pack down to 1/6 it's size on the first lap. I like that no one can hide from the work or get an advantage drafting when you're only doing 18km/h, where as trying to break away from a pack on the flats u just get a string of people that want to follow your wheel but not work once you've done your pull.


here's the code that i got when i posted the question on mrexcel.com or something in a forum i just put it in a cell next to my watts numbers and it did what i wanted, once i referenced to all the right cells.... i updated my pic aswell above ^ ^ ^ ^ so look for the example in my last post
You have to add { } before the = sign and after the last close braket manually to make it work

Nah, you're a 4 needing a few more mass starts to "Cat-up" officially to 4.

Ok, since everyone else is showing theirs, I guess I'll show mine, even though I'm "no racer":

http://img.photobucket.com/albums/v2...le20070324.jpg

As you can see, I'm lacking some 1 minute time this period.

Seems to be for me, the guys that I've been racing against in the 4's who have just catted up to the 3's are finishing in the top end there as well. If things go well in the next 3 races I'll have enough upgrade points to move to the 3's. I probably won't be doing many 3's races though mostly 35/45+ masters.

I can get the match function to work, but how do you get the cell color to change automatically?

ummmmmm i think .....

select one of the colums of w/kg ratios
go to format->conditional format
"cell value is" put "equal to",
select the cell your calculation is in,
select your formating you want (remember color on the font tab is the color of the text not the background)
press ok

Removed, redundant.

Thanks!