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

[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

[EagleMark]

That works great on the $42 side, tried it out yesterday on a already tuned rig. Even though BLMs were very close it still adjusted them or I should say fine tuned!

One thing I noticed was when entering BLM numbers in the 400 RPM row they came up red? Still worked, but all the others were black.

[dave w]

The excel spreadsheet will average the old VE with the BLM / 128 formula. I had noticed in most tuning, the BLM / 128 formula would over correct the new VE. I added a step in the spreadsheet to half step the difference from the old VE and calculated VE (BLM / 128) value to make the new VE. I might have set the cell format font color red on the 400 RPM.

dave w

[ninerscout]

I am new to tuning. What BLM table do I use? Narrow Avg, Narrow Avg 10, Wide Avg, or Wide Avg 10? Narrow Correction 10 or Wide Correction 10.

Thanks in advance,
Ninerscout