New numbers (you may have to refresh your browser).
Since this is my own analysis, I decided to take some creative license with the input parameters. Same formula (and I stand by its correctness), but I tried plugging in some numbers that I don't believe for a second are remotely correct, just to see what the result is. I did this for the last 5 entries, buses and tractor-trailers.
For a tractor-trailer, in order to match the published fuel consumption I had to decrease the drag coefficient to 0.54 from 0.70. This is not as low as an SUV, but almost. I also had to reduce the mass by nearly 2/3rds, and increase the engine efficiency to 35%. Although the calculated mpg seems to match the published value now, I'm wrinkling my nose at these input parameters. Nevertheless, with these input parameters, the tractor trailer burns 61 percent of its mechanical energy fighting air resistance, and 38 percent fighting rolling resistance.
For a commuter bus, I used the Orion VII diesel-electric hybrid. This bus is bigger and heavier than most, but at least I have some more accurate specifications from the manufacturer. Still, in order to get 8 mpg diesel-equivalent fuel consumption I had to reduce the drag coefficient to 0.6 from 2.1, and you'll never convince me that this is remotely correct without some serious wind tunnel tests. This bus still looks like a rectangular box to me, more so even than older buses. I also had to increase the effective engine efficiency to 47 percent, and IMO this is ludicrous. I'd be screaming for some experimental verification here. These conditions suggest that 46 percent of mechanical energy is wasted fighting aerodynamic drag, and 53 percent is wasted fighting rolling resistance. Total mechanical energy spent is worse than a tractor-trailer, although the engine is more efficient, so the mpg is slightly better.
I compared the hypothetical Superbus to the Orion VII with commuter input parameters. I assumed that the Superbus would be half the weight, using aluminum and composite materials, would be all-electric with 60 percent efficiency (same as Tesla Roadster), with same width as the Orion VII but only as high as an SUV, and with a drag coefficient of only 0.2, as per the Superbus website. The result suggests that the commuting Superbus would get 3.5-times better mpg than a diesel-electric hybrid, around 28 mpg diesel equivalent which is about as good as a full size family sedan. Only 1/4 of its mechanical energy would be wasted on air resistance, and 3/4 on rolling resistance.
I also compared the same two buses under city bus conditions, with stops every 1/2-km, and speed never exceeding 30 mph. The diesel-electric Orion bus burns 4-times more fuel under these conditions, getting between 2-3 mpg fuel consumption rather than 8 mpg. This fact is reflected in a study by the US gov't which puts fuel consumption of hybrid city buses at between 2.50 - 2.75 mpg.
http://www.nrel.gov/docs/fy02osti/32427.pdf
The Superbus theoretically achieves triple this performance, at around 6 mpg diesel equivalent fuel consumption. The mechanical energy wasted between kinetic energy, rolling resistance, and air resistance is similar for both the Superbus and the Orion hybrid, but the Superbus simply does better with only half the losses to air resistance, less than half the total mechanical energy expended, and a far higher equivalent engine efficiency (pure electric).