Using a great little speadsheet that I got from wbt, a 3.15 gear, 26" tire, A6 Coyote will have a max MPH of 121.21 @7500RPM, in 3rd gear.
With 3.31s and 28" tires, the same car has a max of 124.22MPH, also at 7500.
3.15s, 27" = 125.87
3.15s, 28" = 130.53
3.55s, 30" = 124.10
PS,
If you are willing to rev to 7700 in 3rd, the 26" tire will get you a max of 124.44
Remember, all these are figured with the tires being as tall as stated. If your 26" tire is actually only 25.7" tall, it skews the numbers quite a bit.
That 7700 RPM limit now gets you only 123.01MPH...
Could you send me that spreadsheet? PM for email address.