Now all I have to do once I have add a new car is extend the row number of the ranges in the formula using replace. I hope to find a better way of doing this but the function doesn't like blank cells... yet.
Well maybe I can help you with this part...
If you are careful about how you "grow" your table, the functions will edit themselves. When you want to add another car, high light the entire row that is below where you will want the new row, then right click the highlighted row and select,
Insert Copied Cells from the popup. Excel will edit all of the ranges for you.
If you want to add a row in front of the Ka, you will have to copy the Ka row, then drop down to the car under it and select that row, then do the insert. Then edit the first row.
If you want to add a car after the Lambo, copy the Lambo row, then do the insert, but edit the last row instead of the one you just inserted.
Doing it this way means new rows are always populated and the only thing you have to do is replace the Pi and QR data with your new values.
It seems to me that most of your decisions will be made from the results of actually driving the laps it takes to establish the QR. You will know what you felt. This is a way of quantifying the feel, I guess.
I will be interested to see what this looks like when it has a few more cars in it.
I hope the Excel hints are something you can use...

$