$E6 ~ $OE ~ $OD ~ $31 ~ $42 VE Fixer Spread Sheet

[dave w]

Try using the attached Excel spreadsheet for fixing VE tables. The spreadsheet includes the older '7747 and the newer TBI PCM with $OE, $E6, $OD, $31. Copy / Paste the running averages from the TunerPro RT BLM History Tables. Compared to other VE Fixers, the attached spreadsheet is simple to use and will get the VE about 90% ~ 95% accurate. The attached spreadsheet will work with freeware OpenOffice.org.

dave w

[EagleMark]

I know you have a lot of work into this and thanks for sharing!

Since your an Excel wiz how about a lesson on how to run it?

I was just playing with it in the $42 section and saw the changes it was making by just changing the numbers in the top box. I am excell ileterate... but it looks like you enter your recorded BLMs in top box and hit enter and get the correction. But do you first need to enter your VE in? then?

[dave w]

It doesn't matter which is copied pasted first, VE Table or BLM Average.

dave w

[EagleMark]

So you have to insert the VE table from the chip your working with, and the BLMs from the data recorded. Will it do the entire table or one by one?

[dave w]

Mark, You are correct. The VE Table will be from the current chip being used to log with, and the BLM's are from the data log. The Excel sheet will update as soon as a cell, or group of cells (VE / BLM) is changed.

There are short cut key strokes that help. The entire Tuner Pro VE table can be copied (once high lighted blue) with the keyboard keys Ctrl+C and then pasted into the excel spreadsheet with the keyboard keys Ctrl+V. The BLM's can be copied, but only one RPM row at a time, for example all the 800 RPM BLM cells (once high lighted blue) can be copied (including the blank ones) with keyboard keys Ctrl+C and then pasted into the 800 RPM BLM cells of the spreadsheet using Ctrl+V.

dave w

[dave w]

The spreadsheet does not remove AE / PE or sort Open Loop / Closed Loop data. Before starting the recording of the data log make sure the the ECM / PCM is in closed loop. When driving and data logging, try to avoid AE / PE modes.

dave w