Metrics Comparison

Metrics Comparison

Postby hectorb » Mon Jan 06, 2014 5:55 pm

Not sure if this question has been addressed before but is there any way to take for example my last 5 or 6 rides and compare them either graphically of my Normalized Power (NP), TSS and % gradient? I ride mostly in the mountains near my house in San Gabriel Canyon so I am trying to establish a base line for my training rides. I guess I could put it on a spread sheet but I'm trying to avoid have to export to excel or training Peaks for now.

Posts: 5
Joined: Tue Mar 06, 2012 3:29 pm
Location: Whittier, California

Re: Metrics Comparison

Postby racerfern » Thu Jan 09, 2014 12:50 am

There are lots of software choices for tracking NP and TSS. However, using a spreadsheet designed for that purpose works really well. I've posted this spreadsheet previously but here it is in Excel 2010 format. Just change the first date cell to your desired date and start logging TSS. Note, that this spreadsheet has no need to know your FTP. TSS will be higher for any given ride if you have a lower FTP and vice versa. It's all taken into consideration.

I originally got this from the Wattage Group in Google Groups back in 2008 and still use it religiously.

As far as graphing ride efforts on specific climbs software such as SportTracks along with a couple of the available plugins does an admirable job but with a bit of a learning curve. The screenshot is for a climb just over six miles on two separate days. This is just for the climb in question, not the entire ride. If you need more info, just post up.
compare3.jpg (96.09 KiB) Viewed 1382 times
2014 PMC spreadsheet.rar
(99.18 KiB) Downloaded 128 times
User avatar
Posts: 1356
Joined: Fri Jan 11, 2008 1:47 am
Location: Baldwin, NY

Re: Metrics Comparison

Postby KenS » Thu Jan 09, 2014 3:09 am

Hope you weren't hurt falling into that sinkhole at 3.8mi or off the cliff at the end :lol:
-- Ken
Posts: 141
Joined: Sun Feb 28, 2010 3:55 pm
Location: Melbourne, Australia

Return to iBike Features

Who is online

Users browsing this forum: No registered users and 1 guest