There is much, much easier way without having to know any gear ratios.
1. Log nvquot_w in each gear (drive the car in each gear), RPM does not matter since it's always the same. If you don't have nvquot_w and don't know how to find it, log nmot_w and vfzg, and calculate nvquot_w= nmot_w/vfzg.
2. You get a number for every gear.
3. For every gear you have NVQUOT(x)O and NVQUOT(x)U (where x is is gear). If you have multiple of these maps with different suffixes, then those are just variants, you can change all the same.
4. Visualize them as pairs. Each pair is NVQUOT(x)U and NVQUOT(x+1)O. For example NVQUOT1U and NVQUOT2O. You will have 2 values left over without pairs. NVQUOT1O and NVQUOT6U, ignore them for now. With a 6 speed gearbox you have 5 pairs (1U 2O, 2U 3O, 3U 4O, 4U 5O, 5U 6O).
5. Take the values of nvquot_w that you logged for each gear, and now you want to calculate the average between each gear. So 1 & 2, 2 & 3, 3 & 4, 4 & 5, 5 & 6. If you notice you also have 5 pairs here. To calculate the average add and then divide by two. So if you have 180 and 90 for 1 & 2, you would do (180+90)/2=135...
6. For each NVQUOT pair, set both of their values the same, to the average of the measured pairs. So as in previous example NVQUOT1U and NVQUOT2O would be set to 135.
7. For the leftover 2 edge values NVQUOT1O and NVQUOT6U, take the measured value and add to it the distance to the closest average value. So NVQUOT1O would be in last example 180+(180-135) = 225 and in the other direction for NVQUOT6U.
That's it, done.
Much easier than looking up gear ratios and final drives in ELSA and elsewhere. All you need is the car.
FAQ:
Q: BUT IN THE STOCK FILE THE PAIRS ARE NO SET THE SAME!!!!11111
A: Yes, OEM added a little hysteresis, to reduce possible bounce. You can do it like that too (just add 5% to O value), but even if you don't, it makes no practical difference.
So everything seems to work again, only 6th gear isnt for cruise control. 5th Gear wasnt working either which is working now with no problem.
Gangi shows every gear correctly, only 6th gear isnt.
As I did the calculation for NVQUOT6U the value was greater than from 6O. Therefore I used a random value lower than the 6O Value.
So as this is not working, my question, can the value be greater than the 6O Value ?
This was my math (maybe its not correct lol)
5th gear. 1902.5 rpm / 90kmh = 21.13888888888889
6th gear. 1535 rpm / 86,25 kmh = 17,79710144927536
The value for 5U and 6O is 19.467 (6O has -1 that value)
21.13888888888889 + (21.13888888888889 - 19.46799516908213) = 22.80978260869565
So 6U would be 22.809, is there something wrong ? The Value I am currently running is 14.000 but its not working with that.