VE Table - Interpolation SpreadSheet

[Tordne]

First of all I'll start by saying that this is something that Chad (Black02SS) and I did some time ago. He keeps losing it so I'll take credit for putting it somewhere useful

You all will have likely seen your VE Table taking on an erratic look after applying a few AutoVE BEN cycles. The principle behind this tool is that is will balance/interpolate the BEN factors from the BEN Map ad average each cell based on the factors in the surrounding cells. This is what the PCM does internally.

The outcome is a VE table that is smoother in appearance, and with less violent transitions between cells in theory should be smoother as well.

I've tried to use some real data to give you an example. This is not as drastic as I've seen them - most of the logs I have the BEN data is good

Anyway, this is a VE Table with the BEN data applied directly from the Scan Tool Map:


This is the save VE Table with the data copied from the Scan Tool Map and into the Spreadsheet, then copied and applied with the interpolated results:


As you can see there is a bit of a difference...

I use this all the time, and I've tried it on a few people on this forum as well. I swear by it!

You'll develop your own techniques for using it, and I'm expecting some questions... Personally I will often take the copy and fill data, then eyeball it and hand change some out there values if they occur, or pump up areas i know need more. The end result is much smoother transitions though.

Enjoy, and I'm keen to hear feedback.

Last of all here is the sheet

Interpolation Spreadsheet

Fixed Link (from post #31 below): Interpolation Spreadsheet

Cheers,