> That is my spreadsheet I think your spreadsheet makes several assumptions that are only true in theory. As other have said, acceleration costs more energy.

> That is my spreadsheet I think your spreadsheet makes several assumptions that are only true in theory. As other have said, acceleration costs more energy. You don't get that back when braking. More importantly, in practice, the road is not flat at all. There are small movements at every brick / stone that you cross, slightly rotating the bike forward and back. The momentum (MOI) multiplied with the weight of the bike for those those small movements is lost in energy. Weight at the ends of the bike (mostly the wheels) increases the momentum of the bike far more than weight in the center of the bike. I don't remember the exact energy formula, but think there is a power of 4 with the distance from the center in it...