Thread: My geek thread
View Single Post
Old 01-19-21, 07:12 PM
  #1747  
hubcyclist
Senior Member
 
Join Date: Jan 2014
Location: Boston
Posts: 2,200

Bikes: 2017 Raleigh RX 1.0, 2018 Specialized Allez

Mentioned: 9 Post(s)
Tagged: 0 Thread(s)
Quoted: 471 Post(s)
Liked 632 Times in 337 Posts
Originally Posted by Enthalpic
Very crudely, in Excel.

I took the raw power data and calculated various moving averages over different durations (30s, 1min, 2min, 4min, 6min, 10min, 20min) and then found the maximums in each of the new smoothed data columns.

I then used those maximums when doing model fitting for the power duration curve.

Probably could be coded using a simple array easily.
thanks! Makes sense to me, although my simple programming mind needs to figure out a way to program that. Should be a fun project lol
hubcyclist is offline