Yeah, guess it depends on what you want to do.
I have a graph showing engine rpm vs vehicle speed for 4 combinations. I used 2 different trans ratios and 2 different gear ratios. I also worked in swapping just fifth gear on one of the combos. WOT shift points can be seen, as well as theoretical top speed (not accounting for aero/rolling drag).
I then worked another graph to show just fifth gear of each combo under cruising conditions, so I could get a feel for fuel economy differences.
I probably spent more time formatting than setting up the equations.
If you just want to know the difference in top speed for a given ratio, it would not take nearly as long. Also, I am still learning excel, so I tend to work a little slower.
jason