Thank you for this. Your simplifications allowed me to play around with the key assumptions and come to see that certain values of Cb were not possible, and that only within a narrow range of "Cb = X% Ct" AND "% energy an electric bus is cruising" does the electrified truck get worse mileage than an electric bus. But it also limits the mileage improvements without some significant aero changes.
Just as a thought exercise, If the drag coefficient could be reduced by half (from 0.8 to 0.4), then Ct would be reduced by 1/3rd (assuming trucks are cruising right where Trt = Tat). Giving you a max of 25 mi/dge. Of course, the truck will look like a bullet train at that point and be completely undrivable.
I've
posted the spreadsheet with all the calculations pre-filled if anyone's interested in playing with it. The red are invariant or statically variant, blue is dynamically calculated from the changes in green.