WBO2-Tuning Spreadsheet

[lionelhutz]

You can use a if(ISERROR(... test to set the cells to "" instead of displaying the div/0 errors. You do have to repeat the formula twice but it makes it much prettier to look at.

The next thing to do is add a count and desired AFR cell and use those to create another table with the amount of error or correction factor.

[dave w]

The cells count table is below the AFR tables.

I'm working on the layout, see attached.

dave w

[lionelhutz]

Not a counts table, a cell with the minimum number of records before you use the average so you don't get a small number of results messing up the data.

You can then use the counts to add another table that shows either percentage error, or lambda which is basically the same thing.

[dave w]

Not a counts table, a cell with the minimum number of records before you use the average so you don't get a small number of results messing up the data.

You can then use the counts to add another table that shows either percentage error, or lambda which is basically the same thing.

I've been thinking deviation, minimum, maximum, & range information is available in TunerPro RT? Basically I wanted the spreadsheet cells to align with the VE tables / filter closed loop / near idle / off idle / power enrichment, which is not filtered in TunerPro RT.

dave w

[steveo]

Not a counts table, a cell with the minimum number of records before you use the average so you don't get a small number of results messing up the data.

i agree, without enforcing a minimum cell count, you will end up with erroneous spikes in your data from cells with only one or two records that averaging hasn't been able to smooth out.

you should also provide a percentage against target AFR data, if any is available, people find that really handy.

im not entirely sure how to do this stuff with a spreadsheet. this is the kind of stuff that always drove me towards programmed tools for analysis.

really wish tunerpro had filtering in its history tables.....

[dave w]

I agree, it would be useful to have a minimum cell count as function of the AVERAGEIFS formula. I'm currently looking at the number of records in the table below the AFR Averages table to determine data validity.

The basic near idle formula I started with:
AVERAGEIFS('Insert Datalog'!,'Insert Datalog'!,"=Closed",'Insert Datalog'!,"=On",'Insert Datalog'!,"=Inactive",'Insert Datalog'!,"=Inactive",'Insert Datalog'!,">=XX",'Insert Datalog'!,"<=YY",'Insert Datalog'!,">=XXX",'Insert Datalog'!,"<YYYY")

dave w

[Tbrendal]

What would I have to do to use this with a 7747 ecm?

[dave w]

You can use a if(ISERROR(... test to set the cells to "" instead of displaying the div/0 errors. You do have to repeat the formula twice but it makes it much prettier to look at.

Updated spreadsheet to make it prettier to look at. see attached

dave w

[dave w]

Pics from using the spreadsheet to "CRUNCH" the data log.

dave w

[Kitch]

Hi Dave,

I'm sure there's an obvious answer but in the first two photos whats up with the values in the in the lower tables, they seem quite a bit different from the values in the upper tables?

[dave w]

Hi Dave,

I'm sure there's an obvious answer but in the first two photos whats up with the values in the in the lower tables, they seem quite a bit different from the values in the upper tables?

The values in the lower tables of the first two photo's are counts of how many records (data points) were recorded in that cell. For example the first photo "Near Idle" had 814 data points at 600 RPM's / 40 Kpa.

dave w

[Chewy1576]

Awesome work on the spreadsheet Dave! I have a few questions - What filters are you using for the averageifs on WBO2 and SA history tables? I copied in a set of data from a log I had to try it out and I'm not seeing any data populating in the history tables? The columns in the Insert Datalog sheet match up. Also for this log, I forced Open Loop and PE is disabled.

[Kitch]

Thanks for the simple answer Dave and nice work with the spreadsheet.

[dave w]

Awesome work on the spreadsheet Dave! I have a few questions - What filters are you using for the averageifs on WBO2 and SA history tables? I copied in a set of data from a log I had to try it out and I'm not seeing any data populating in the history tables? The columns in the Insert Datalog sheet match up. Also for this log, I forced Open Loop and PE is disabled.

Can you post your .xdl file? I filter out ALL open loop data. Maybe in the future I can set up a sheet for Open Loop. I have a sheet for PE only.

dave w