I work with an ecu that displays data logged info in the following manner:
tps map A/F rpm
10 80 14 1500
15 90 15 900
20 89 13 3500
30 100 13 4500
35 101 12 5500
0 60 12 800
5 65 14 1200
9 80 12 1500
21 70 15 2300
23 78 14 2200
I want to create a 2D table. The vertical axis of the table would be the map values and the horizontal axis would be the rpm. Like so:
http://www.rbracing-rsr.com/fuelmapl.htm
What I would like to know is how I can create a formula that would search through the above table and average the A/F value of similar rpm and map, and tps values. An example would be the vertical axis is at 1200-1600 rpm, the map at 80-90, and the tps is from 0-10. The results can be both 12 and 14. So I'd likes to display the average of the two.
Any help would be greatly appreciated.
Bookmarks