AutoTune Log for AEM Tuner
What I am looking to do is to duplicate the AutoTune Log in the AEM Pro Software with an Excel Spread Sheet as this is was omited from AEM Tuner, but I do not have enough knowledge of Excel to do this without doing it manual every time.
Essentially what I was thinking that if you were to export a data log to a text file this would an instant way to create a table of data. Then a separate table could be made which would take in the breakpoints for the fuel map.
Next the spread sheet will create a range of values based on the breakpoints for which it would then search the data log and come up with averages AFR’s for the corresponding position on in the fuel map. The simplest way to create this range of values would be to take half of the difference between the surrounding values so in the example below (X2,Y2) would be averaging the following range of values (2.5-7.5,750-1250).
……..500……1000…...1500
10…X1,Y1….X2,Y1…X3,Y1
5…..X1,Y2.....X2,Y2…X3,Y2
0…..X1,Y3….X2,Y3…X3,Y3
Another method would add weighting to each value, so in the above example if the data log was 830 RPM and 2.0 PSI, then (X1,Y3), (X1,Y2), (X2,Y3), (X2,Y2) would all receive a weighted value of the logged AFR. I haven’t come up with a good weighting system for this one but I will work on this. The best thing I have is, if the data logged value fell within 0-10% of the exactly value then it would be counted 10 times where as if it was half way between (2) other cells it would be counted 5 times……….
Next using a Minimum and Maximum Values for a filter for the Air Fuel ratio’s, Throttle Position and Coolant Temperature, nonrelevant conditions can be omitted from the data log.
In addition to AFR’s we could also extend this out help tuning Boost Feedback, Checking for Knock and I am sure there are many other examples we can work with it.
Essentially what I was thinking that if you were to export a data log to a text file this would an instant way to create a table of data. Then a separate table could be made which would take in the breakpoints for the fuel map.
Next the spread sheet will create a range of values based on the breakpoints for which it would then search the data log and come up with averages AFR’s for the corresponding position on in the fuel map. The simplest way to create this range of values would be to take half of the difference between the surrounding values so in the example below (X2,Y2) would be averaging the following range of values (2.5-7.5,750-1250).
……..500……1000…...1500
10…X1,Y1….X2,Y1…X3,Y1
5…..X1,Y2.....X2,Y2…X3,Y2
0…..X1,Y3….X2,Y3…X3,Y3
Another method would add weighting to each value, so in the above example if the data log was 830 RPM and 2.0 PSI, then (X1,Y3), (X1,Y2), (X2,Y3), (X2,Y2) would all receive a weighted value of the logged AFR. I haven’t come up with a good weighting system for this one but I will work on this. The best thing I have is, if the data logged value fell within 0-10% of the exactly value then it would be counted 10 times where as if it was half way between (2) other cells it would be counted 5 times……….
Next using a Minimum and Maximum Values for a filter for the Air Fuel ratio’s, Throttle Position and Coolant Temperature, nonrelevant conditions can be omitted from the data log.
In addition to AFR’s we could also extend this out help tuning Boost Feedback, Checking for Knock and I am sure there are many other examples we can work with it.
Thread
Thread Starter
Forum
Replies
Last Post







