Go Back   Cycling Forums » Bikes » Power Training
Power Training This is the place to talk about training and racing with power (watts) measuring devices such as Polar 710/720, Power Tap, SRM or any other power measuring device.













PM modeling tool

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 12-18.-2006
Registered User
 
Join Date: Feb 2003
Age: 39
Posts: 63
Rep Power: 14
Thorman will become famous soon enough
Default PM modeling tool

Here's a PM modeling tool I put together based on a spreadsheet I found here a few months ago.

The only change I made to the original calculation was to show TSB based on the previous day's TSS. After doing this and pasting in data from CPS the PM chart it created was dead on what CPS had so it appears the calculations are spot on.

My primary motivation in putting this together was to quickly model data based on the workouts I consider the staple of my training diet.

I also use rolling TSS figures to determine when I need to rest so I included that data as well.

Finally, as an example I've also attached my first draft for the 2007 build up I have planned.
Reply With Quote
  #2  
Old 12-18.-2006
SolarEnergy's Avatar
Registered User
 
Join Date: Aug 2005
Location: Canada
Posts: 1,358
Rep Power: 15
SolarEnergy is a jewel in the rough
Default Re: PM modeling tool

thank you very very much
Reply With Quote


  #3  
Old 12-19.-2006
Registered User
 
Join Date: Mar 2003
Location: Cape Town
Posts: 534
Rep Power: 16
peterwright will become famous soon enough
Default Re: PM modeling tool

Quote:
Originally Posted by Thorman
Here's a PM modeling tool I put together based on a spreadsheet I found here a few months ago.

The only change I made to the original calculation was to show TSB based on the previous day's TSS. After doing this and pasting in data from CPS the PM chart it created was dead on what CPS had so it appears the calculations are spot on.

My primary motivation in putting this together was to quickly model data based on the workouts I consider the staple of my training diet.

I also use rolling TSS figures to determine when I need to rest so I included that data as well.

Finally, as an example I've also attached my first draft for the 2007 build up I have planned.
Thanks very much - this a great improvement in the more basic one I have been using.
Reply With Quote


  #4  
Old 12-19.-2006
Registered User
 
Join Date: May 2006
Posts: 55
Rep Power: 8
NM87710 will become famous soon enough
Default Re: PM modeling tool

Thank you for sharing. Very, very nice work.

Curious, how'd you decide on the rolling TSS break even values?

Again, Thanks.
Reply With Quote


  #5  
Old 12-19.-2006
Registered User
 
Join Date: Oct 2006
Posts: 49
Rep Power: 7
gimpy_calfee will become famous soon enough
Default Re: PM modeling tool

Scott,
Thanks for this!
SM
Reply With Quote


  #6  
Old 12-19.-2006
Registered User
 
Join Date: Feb 2003
Age: 39
Posts: 63
Rep Power: 14
Thorman will become famous soon enough
Default Re: PM modeling tool

Quote:
Originally Posted by NM87710
Thank you for sharing. Very, very nice work.

Curious, how'd you decide on the rolling TSS break even values?

Again, Thanks.
I developed these based on two season's worth of data, particularly weeks where I go to AZ in the winter and do 20+ hours of training in a single week.

Each of these two years I've inched my numbers up slightly and have been able to bounce back with 3 days of recovery. I've pushed the numbers up slightly again this year so we'll see if I really find my "breaking point" in early March 2007:-)

Scott
Reply With Quote


  #7  
Old 12-24.-2006
Registered User
 
Join Date: Feb 2003
Age: 39
Posts: 63
Rep Power: 14
Thorman will become famous soon enough
Default Re: PM modeling tool

Here's a two part article I put together illustrating how I've developed my training plan model for next year. Perhaps you'll find this of some use if you're doing the same.

part 1
http://tinyurl.com/ye9r98

part 2
http://tinyurl.com/yz5ftx
Reply With Quote


  #8  
Old 12-24.-2006
Registered User
 
Join Date: Mar 2003
Location: Cape Town
Posts: 534
Rep Power: 16
peterwright will become famous soon enough
Default Re: PM modeling tool

Quote:
Originally Posted by Thorman
Here's a two part article I put together illustrating how I've developed my training plan model for next year. Perhaps you'll find this of some use if you're doing the same.

part 1
http://tinyurl.com/ye9r98

part 2
http://tinyurl.com/yz5ftx
Great stuff - as always.

Nicely written and succinct, I always struggle to distill it down when trying to make sense of it to people.

Would like to post a link on my site to this if that is ok ?

Peter
Reply With Quote


  #9  
Old 12-24.-2006
Registered User
 
Join Date: Feb 2003
Age: 39
Posts: 63
Rep Power: 14
Thorman will become famous soon enough
Default Re: PM modeling tool

Quote:
Originally Posted by peterwright
Great stuff - as always.

Nicely written and succinct, I always struggle to distill it down when trying to make sense of it to people.

Would like to post a link on my site to this if that is ok ?

Peter
Go for it!
Reply With Quote


Reply

Bookmarks

Tags
modeling, tool

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:10 AM.
Integration with Google translations by vBET Translator 3.2.2
Powered by: vBulletin Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2001 - 2009 cyclingforums.com

Automatic Translations (Powered by Powered by Google):
Bulgarian Croatian Czech Danish Dutch English Finnish French German Italian Japanese Korean Norwegian Polish Portuguese Spanish Swedish