Just updating an older thread…
I’m sharing a spreadsheet that has several models included to fit your mean maximal power curve and develop modeled power duration curves. Several of the models are typical models that you’ll find everywhere, such as the two and three parameter models. I also have some of the more modern models like the Omni-Domain Model, Extended Critical Power Model (found in Golden Cheetah) and a modified Perronet and Thibaut model (presumably similar to the WKO model). A power law model is also included. Hopefully these model implementations can help you estimate a value for critical power to use for training.
This spreadsheet has not been quality checked by anybody and you should presume that there could be errors somewhere in the spreadsheet. This spreadsheet has been set up for Microsoft Excel, however you probably can get it to work in LibreOffice pretty easily.
To use the spreadsheet, you’ll need to paste your mean maximal power curve into the summary sheet and then go sheet-by-sheet and use the built-in solver to come to a solution for the model fitting parameters. The sheet is set up to take the data from Intervals.icu CSV for your mean maximal curve of interest and paste directly into the sheet. Or you can use a mean max curve with up to 4,208 rows of data.
You can automate this task, but I find that going model by model and fit by fit gives you a better idea of whether your model fits are reasonable or not.
The sheet
https://1drv.ms/x/c/7aaa504c5ba71805/EXFZw3fJ5UxNrWba-L6BMiMB2qpnlin3e7cPMo2jqJFtjg?e=9jdJ9Z
Sheets:
-
Model Summary
-
2 parameter, 3 parameter – hyperbolic
-
2 parameter – linear work
-
Ward-Smith
-
Omni-Domain, Omni-3 parameter, Omni-Exponential
-
Extended CP
-
Modified Perronet & Thibault
-
Power Law
Summary sheet
OMPD sheet
More sheets and models coming…