The final section of the BestBikeSplit Race plan above provides 'race intervals' which show the segment distances and gradients, then the power recommended by BestBikeSplit, together with the resulting speeds. I copy and pasted those 29 race intervals into Excel and calculated segment distances in metres, instead of miles:
I then copied the distance, gradient and speed values into my power optimiser spreadsheet to allow me to compare the power values calculated by BestBikeSplit and values calculated by my spreadsheet. Surprisingly, the power values agreed for some of the route, but were significantly different for the downhill section, as shown in plot below for the solid red and dashed red lines:
As soon as the gradient becomes negative, BestBikeSplit (the red dashed curve) is showing that a higher power is needed to achieve the downhill speeds that BestBikeSplit has calculated. I really don't understand this because, for example, it is calculating speeds of 23.08 mph on a -4.36% (downhill) gradient while applying 84 Watts of power. That is clearly wrong and I didn't know why BestBikeSplit is doing that, unless it is somehow assuming a large headwind
To investigate this, I plotted the BestBikeSplit powers and speeds versus the gradient values, shown withe red symbols on the plot to the left. The plot looks reasonably sensible, although the scatter seen in the corresponding speeds is slightly strange. Regardless of these doubts, I decided to try to ride the route using the BestBikeSplit power profile to see what time it would give.
Riding the BestBikeSplit power profile
To do this, I decided to use the BestBikeSpilt's feature where they allow the power profile to be exported as a TrainerRoad workout. This is a nice feature, because it allowed me to ride exactly the prescribed powers by doing the workout in ERG mode, with my phone (for TrainerRoad) and also Zwift (via my iPad) connected to my Wahoo Kickr trainer. The workout included the 29 intervals contained in BestBikeSplit's race intervals. As shown above, I also added a long 150W interval afterwards to allow me to do a second lap at a constant power, if I wanted to.
I started the TrainerRoad workout as I got to the archway that marks the start of the Whole Lotta Lava segment. As a reminder, the segment time I did previously with a constant 150W power output was 27 minutes and 15 seconds. Using the BestBikeSplit power profile, I did a time of 27 minutes and 6 seconds, so 9 seconds faster than the constant 150W effort. It's worth noting that although the normalised power for the BestBikeSplit run was about 150W (actually slightly lower, at 148W), the average power was substantially lower at 140W. This is interesting in itself, and a positive results, that the average power was 10W lower than the constant 150W effort, but the time was 9 seconds faster.
However, something I noted when riding the segment with the BestBikeSplit power profile was that at several times the target power did not correlate well with the gradient. At most times it was good. For most of the uphill sections, the target power was higher than 150W, as expected. At some points, though, the target power didn't correlate with the gradient. For example, the high power interval stopped about 10 or 20 seconds too soon, before I reached the top of the climb, on the steepest part, which seemed odd. Therefore, I think that due to the BestBikeSplit speed issue mentioned previously, I think there was a synchronisation problem between the BestBikeSplit simulation and what actually happened in Zwift when those powers were ridden. I have the feeling that the most likely explanation is that BestBikeSplit is assuming some wind that is not actually there in Zwift.
It's worth also be noting that the 27:06 time is significantly faster that the 27:47 time predicted by BestBikeSplit, indicating that their calculation of Zwift speeds are wrong, despite me entering the details such as Crr and CdA correctly.
Finally, it's interesting and encouraging that my second lap of the Whole Lotta Lava segment was done again at 150W constant power, and again this gave exactly the same 27 minute 15 second segment time as I achieved before (described in my previous blog post).
Summary
This has been quite a long post, so let's recap:
Riding at a constant 150 Watts gives a time of 27:15.
(average power = 150W, normalised power = 150W)
Riding at the BestBikeSplit optimum power profile gives a time of 27:06 (9 second saving)
(average power = 140W, normalised power = 148W)
Next Steps
The next step is to see whether my own Excel-based power optimiser gives similar results, and to do that I will be to create a scripts that can process the segment profile in a more efficient way, with less manual effort by me.