[Dean]

I logged a nice twisty mountain road yesterday, but the downhill data is awful. Even the off throttle data from freeway runs makes my time in spreadsheet land longer than I'd like.

If you are just doing "pulls", it is easy to stop and start logging, but working on intake calibration and closed loop tables where you need lots of data from varied conditions is the challenge.

What are people using / doing to clean their data?

So far, I have used the TRIMMEAN function to "throw out" the high and low judges.

I've also dumped anything > ~15.5 or < ~10 AFR. Boost < 10-15, but occasionally, some of that is valid...

Any other good suggestions out there?

A formula or macro that recognized throttle reductions would be nice. Hmmm...

[R4ND0M_AX3]

Originally Posted by Dean

I logged a nice twisty mountain road yesterday, but the downhill data is awful. Even the off throttle data from freeway runs makes my time in spreadsheet land longer than I'd like.

If you are just doing "pulls", it is easy to stop and start logging, but working on intake calibration and closed loop tables where you need lots of data from varied conditions is the challenge.

What are people using / doing to clean their data?

So far, I have used the TRIMMEAN function to "throw out" the high and low judges.

I've also dumped anything > ~15.5 or < ~10 AFR. Boost < 10-15, but occasionally, some of that is valid...

Any other good suggestions out there?

A formula or macro that recognized throttle reductions would be nice. Hmmm...

I usually color cells to highlight hi boost/throttle/load areas when I'm concerned about "pulls" from one giant log.

If I'm looking at just average driving data then I copy the log to a new worksheet and sort by one colume and trim the extreme rows. Rinse and repeat until I have mostly useful info.