Now it works. Amazing, many thanks
Many thanks 
I added another couple workbooks to the Dropbox folder. These are focused more on running. Hope some of you find them useful.
CV Modeling V2.3.1 is basically the same model set in the critical power workbook, but you can use speed and duration to get CV and D’.
One thing to notice is how some models need a variety of data on order to get reasonable fitting parameters. The Extended CV and Modified P&T model sheets show good examples of difficult model fit when data is missing at the short and long ends of your MMP.
Running Estimates (**) V1.0 is a workbook that contains a few different sheets. One sheet is called CP,CV,VDOT Estimates and can be used for…CP/CV and Vdot estimates. Plug in some distances, times, and power to get a linear 2P estimate. The Vdot estimates are from the equations provided in Oxygen Power.
The other sheet in this workbook is the Peronnet and Thibault model. This model can be used to fit durations from a few seconds to several hours. I have a macro that will fit the test data and then estimate times for distances from 60m to 42.2km.
** = there are workbooks with some Jakob Ingebrigtsen and Eliud Kipchoge annual PR’s modeled used for examples.
4 Likes
i find difficult to use, i mean i need to input the data por 20min 5min etc… but have just “space” for time/power , so i onçy can put one data - or im too stupid to not understand ?
What would you like to do? I know my sheets are not very user friendly.
Hi GarageLab,
With your MLSSc updatedV3.ods
When I press ‘Calculate Fatmax’ i get the following:
I have 64-bit JRE
What I am doing wrong?
Thanks
Just adding another Excel workbook to my Dropbox folder.
I have Coggan, Skiba, and Xert metrics coded.
This workbook has three sheets:
-
Workout analyzer to estimate strain from a planned workout.
-
Performance analyzer to inspect a single performance and estimate CP and W’ from the performance.
-
PMC and Banister model implementations. These are basic, but they work. You can seed both models and fit the Banister model to performance tests to get individualized parameters.
2 Likes
the modified P&T model and Ward-Smith model gives very very high CP numbers always
MOst bc, when the said power and HR i F and G cell , but Workout Analyzer and other sheets this not the “right” cells, even Watts is calculates by CP , in your sheet Bannister , "Wo is based on cell “GOVSS ?” , sorry but what this score based ? or it justa example?