Originally Posted by g.stew Originally Posted by

I tried it out last night and it was very useful. I was able to get my exact Shift RPM, Speed @ Shift in 1st, and Min/Max Race Speed from my saved telemetry data in vrHive, so it was easy to get started.



The only problem I ran into was with Excel 2013. The Max Speed(L4) and the lines on the graph for Powerband Start RPM, Max Power RPM and Redline RPM don't work. As soon as I change anything in D1-D9 they disappear. The Max Speed formula (the part I can see) is using MAXIFS , which is only available in Excel 2016. I'm not sure if it's the same problem with the graph lines, or if they depend on the value of L4.



It still works great without those, but I'm not sure if there is an alternative way to calculate those without MAXIFS .



Anyway, thanks again for this addition to the growing library of setup tools.