Watched the video..most of it anyway...good job :tup:and thanks for posting. You've obviously put a lot of thought and effort into it and should be congratulated for that. I too use a spreadsheet to calculate some of my gear ratios and my settings appear much like yours with the lower gears appearing closer together on the graph so I think you're definitely on the right track.
However, and I may have missed this in the video so correct me if I'm wrong, I pay a lot of attention to my first gear launches but it seemed as if you usually just put first all the way to the left. If a car is a first gear launch car, say 450PP on SS tires or harder, I tend to set first gear so I can launch full throttle with some wheelspin but without the tires going red. If you put a 450PP SS car all the way to the left you will bog down the motor and drop many places off the line. I've won many an online race by qualifying on the front row, winning the drag race to the first corner and letting everyone else fight it out for 2nd after that. So my formula is to figure out top speed (I generally tune to fixed PP ranges so my top speeds are usually the same across many cars at the same PP), take it to the track and figure out first gear, and then use the calculations to figure out the rest of the gears.
And if you use different tires on the same tune, you need different first gears and top speeds so it's a different tune altogether and the settings sheets come in handy.
If it isn't in there already, you might want to add that first gear tuning component to the calculation as opposed to a standard, "all the way to the left" , which works on some cars but not many.
Good job and keep up the good work!!
