Need Excel Help

[dville_gt]

I have 3 columns of data like this:

RPM MAP AFR
1000 40 14
2000 60 14.2
3000 60 14.2
4000 90 12.5
5000 100 12.4
5500 100 12.8
6000 100 12.6
5000 30 14.5
4000 30 14.4
4000 100 12.5

And on and on and on.

What I want to do is have an excel spreadsheet I can import this data in that will plot the AFR in a corresponding cell with the top axis being MAP and the side axis being RPM. If there is already a value in the cell then I want it to average the value with the current value in the cell.

Here is basically what I want my final product to look like:



Anyone got any idea? Is Excel even the right way to go about this?

[Darren M]

You could probably do it in Excel.... I don't know that I would try it but I guess it is possible. If it were me, and I had to do it in Excel, I'd be writing it in VBA.

[Grape]

We use a $200 logger from innovate that coverts all sorts of sensors to their logworks program. If a dumbass like me can use it, well ya.

[dville_gt]

The problem is, this particular data logging program is crappy and I have to back door the wideband into it and then export as CSV.

[dville_gt]

I got it figured out, have to use excel and access, but it works.

[Sam88gta1]

I got it figured out, have to use excel and access, but it works.

How come you don't post any tuning videos on here like you do FB?

[Baron Von Crowder]

now it's a party!

[Silverback]

did someone say Disco??

[racrguy]

We use a $200 logger from innovate that coverts all sorts of sensors to their logworks program. If a dumbass like me can use it, well ya.

Methanol?

[mstng86]

A todos les gusta bailar en la discoteca

[Silverback]

?Bailamos!
Let the rhythm take you over...
?Bailamos!
Te quiero amor mio
?Bailamos!
Wanna live this night forever...
?Bailamos!
Te quiero amor mio...
?Te quiero!