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.