The cells count table is below the AFR tables.
I'm working on the layout, see attached.
dave w
The cells count table is below the AFR tables.
I'm working on the layout, see attached.
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
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.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 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.....
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
What would I have to do to use this with a 7747 ecm?
The spreadsheet is for the second generation TBI PCM, 16168625, 16197427, 16156930, & 16196395.
Information to upgrade the 1227747 to the second generation TBI PCM is here: http://www.gearhead-efi.com/Fuel-Inj...out-Directions!
dave w
Bookmarks