Hello, I'm trying to find a spreadsheet that will allow me to predict what speed I will do at a given power. I can find quite a lot of online calculators, I can also find some power formula written down, I can also find spreadsheets that allow me to estimate power for a given speed but can't find any spreadsheet that predicts speed. Can anyone point me in the right direction?
The reason for wanting this is that I am riding L'Etape in the summer and wanted to have a go at predicting how long it will take. I was planning to do that by plotting the elevation of the route by distance and then creating a look up table that says what power I will aim for at a particular slope and elevation and use that to give my speed. I realise it won't be accurate but I'm interested to know how close to eight, nine, ten or eleven hours it will take me.
I was then thinking about modifying the power table to see what kind of strategy would be most efficient.
Thanks
The reason for wanting this is that I am riding L'Etape in the summer and wanted to have a go at predicting how long it will take. I was planning to do that by plotting the elevation of the route by distance and then creating a look up table that says what power I will aim for at a particular slope and elevation and use that to give my speed. I realise it won't be accurate but I'm interested to know how close to eight, nine, ten or eleven hours it will take me.
I was then thinking about modifying the power table to see what kind of strategy would be most efficient.
Thanks