Very interesting. What tyre size did you base it off?

Also, would it be possible to request another column for km/h?

 

There are many online calculators that do this.

 

After I saw this reddit thread today on short vs tall gearing, I thought I'd share with the class a speed vs rpm graph I created a while back.

It uses gear ratios, final drive, and tire size to calculate the engine rpm at a given speed with 7,000 rpm as the redline.
View attachment 172253
Here's also the top speed for each gear in a table. It makes me wonder if the car could do 220 mph with enough horsepower.

Gear	Top speed (mph)
1	35​
2	56​
3	83​
4	104​
5	137​
6	179​
7	219​
8	280​

What's fun for street driving is you can do a nice 1-2-3 gear pull and you're at still at highway speeds. Although it only takes a few seconds...

Something wrong with your chart there, 2nd and 3rd gear aren't that close

 

You might be looking at reverse.