Smoothing VE tables - Interpolation Spreadsheet - Miata Turbo Forum - Boost cars, acquire cats.

Go Back  Miata Turbo Forum - Boost cars, acquire cats. > Performance & Tuning > ECUs and Tuning > MEGAsquirt
Reload this Page >

Smoothing VE tables - Interpolation Spreadsheet

MEGAsquirt A place to collectively sort out this megasquirt gizmo
Sponsored by:
Sponsored by:

Smoothing VE tables - Interpolation Spreadsheet

Old 06-21-2012, 07:29 PM
  #1  
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default Smoothing VE tables - Interpolation Spreadsheet

I created a spreadsheet to help smooth VE table values. See attached file. The values shown below are just for example purposes.

Simply copy the values from your tune and paste them into the spreadsheet in the "ORIGINAL VALUES" section.


The new values are calculated in the "INTERPOLATED VALUES" section. Copy these new values back to your tune. Make adjustments were necessary. Like in your idle region, for example, if you want to keep that area using the same value in each cell.


This takes a table that looks like this


And gives you this


You can edit the spreadsheet to change MAP and RPM values. They are not used in calculations and are just for your information.

You can add additional rows or columns if needed but you will need to adjust the formulas.

Let me know if there are any suggestions updating this.

Edit - 16x16 and 12x12 version with factoring in post #31. https://www.miataturbo.net/showpost....5&postcount=31
Attached Thumbnails Smoothing VE tables - Interpolation Spreadsheet-originalz.png   Smoothing VE tables - Interpolation Spreadsheet-smooths.png   Smoothing VE tables - Interpolation Spreadsheet-ve01.png   Smoothing VE tables - Interpolation Spreadsheet-ve02.png  
Attached Files
File Type: xls
Interpolation.xls (34.5 KB, 748 views)

Last edited by travisb; 06-22-2012 at 01:05 PM.
travisb is offline  
Old 06-21-2012, 07:55 PM
  #2  
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 75,297
Total Cats: 2,154
Default

you know tuner studio does it too right?

I just did mine --


here's how my current fuel map looks:



selecting all and interpolating:




spending about 2 minutes and selectively interpolating the peaks/valleys:





but your spreadsheet seems a bit easier. make a 16x16 one and ill try it.
Attached Thumbnails Smoothing VE tables - Interpolation Spreadsheet-before_fuel.jpg   Smoothing VE tables - Interpolation Spreadsheet-after_fuel.jpg   Smoothing VE tables - Interpolation Spreadsheet-after_fuel_hand.jpg  
Braineack is offline  
Old 06-21-2012, 08:01 PM
  #3  
y8s
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
 
y8s's Avatar
 
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,128
Total Cats: 480
Default

Originally Posted by Braineack View Post
you know tuner studio does it too right?
dude

that's so not the same.

OP should show this to Phil Tobin.
y8s is online now  
Old 06-21-2012, 08:02 PM
  #4  
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 75,297
Total Cats: 2,154
Default

i know i know! hense my last comment, and the selective interpolating.
Braineack is offline  
Old 06-21-2012, 08:06 PM
  #5  
Senior Member
iTrader: (4)
 
Join Date: Nov 2009
Location: Toronto, ON
Posts: 1,447
Total Cats: 6
Default

Is there any reason this should not be used for an ignition table?
dgmorr is offline  
Old 06-21-2012, 08:16 PM
  #6  
Elite Member
iTrader: (1)
 
Join Date: Jun 2006
Location: Warrington/Birmingham
Posts: 2,641
Total Cats: 41
Default

Stunning work OP!
richyvrlimited is offline  
Old 06-21-2012, 09:43 PM
  #7  
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

Here is my 16x16 version. Try it out and let me know what you think.

PLEASE VERIFY THE DATA BEFORE YOU BURN TO THE ECU. I MAKE NO CLAIMS TO THE ACCURACY OF THIS SPREADSHEET OR TAKE ANY LIABILITY SHOULD YOU DESTROY YOUR CAR.

Edit - 16x16 and 12x12 version with factoring in post #31. https://www.miataturbo.net/showpost....5&postcount=31
Attached Files
File Type: xls
Interpolation_16x16.xls (46.0 KB, 509 views)

Last edited by travisb; 06-22-2012 at 01:05 PM. Reason: Disclaimer.
travisb is offline  
Old 06-21-2012, 09:46 PM
  #8  
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

I also used this for my ignition table. All it does is take the average of all the neighboring cells. If the numbers you already have are somewhat accurate, then it just smooths everything out. I'm guessing it is ok to do this.

Last edited by travisb; 06-21-2012 at 09:57 PM.
travisb is offline  
Old 06-21-2012, 09:56 PM
  #9  
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

Originally Posted by y8s View Post
dude

that's so not the same.

OP should show this to Phil Tobin.
Actually, I did not know TunerStudio had an interpolate feature. But it doesn't seem to look at all the neighboring data. And it looks kinda flat. What exactly is Phil's method doing?
travisb is offline  
Old 06-21-2012, 10:14 PM
  #10  
y8s
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
 
y8s's Avatar
 
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,128
Total Cats: 480
Default

that's what I was telling brain. it's not a smoothing algorithm, it's an averaging algorithm.

select a line or a rectangle and it'll connect the points with a linear (or planar) set of values.

your smoothing one is pretty baller.
y8s is online now  
Old 06-21-2012, 11:20 PM
  #11  
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 75,297
Total Cats: 2,154
Default

Originally Posted by y8s View Post
that's what I was telling brain. it's not a smoothing algorithm, it's an averaging algorithm.

select a line or a rectangle and it'll connect the points with a linear (or planar) set of values.

your smoothing one is pretty baller.
I got it bro.

So here's like 2-3 mins of using tuner studio quickly:



and here's 3 seconds in excel:





it's pretty cool
Attached Thumbnails Smoothing VE tables - Interpolation Spreadsheet-after_fuel_smooth.jpg  
Braineack is offline  
Old 06-21-2012, 11:24 PM
  #12  
y8s
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
 
y8s's Avatar
 
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,128
Total Cats: 480
Default

your momma's got it bro
y8s is online now  
Old 06-21-2012, 11:25 PM
  #13  
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,959
Total Cats: 11
Default

The 16x16 didn't work for me. I copied my values in, and nothing happened in the interpolated window
miatauser884 is offline  
Old 06-21-2012, 11:27 PM
  #14  
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 75,297
Total Cats: 2,154
Default

change font color to black.
Braineack is offline  
Old 06-21-2012, 11:32 PM
  #15  
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,959
Total Cats: 11
Default

I feel retarded, but thank you! I did timing map and fuel map. I'll run them this weekend.

Last edited by miatauser884; 06-21-2012 at 11:49 PM.
miatauser884 is offline  
Old 06-21-2012, 11:54 PM
  #16  
Elite Member
 
Join Date: Jul 2005
Posts: 6,455
Total Cats: 81
Default

This is a smoothing algorithm, not an interpolating one (thread title is wrong)
JasonC SBB is offline  
Old 06-21-2012, 11:54 PM
  #17  
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

Did the background colors not fill in? I set the font to white and then the cell colors range from blue-green-red like tunerstudio.
travisb is offline  
Old 06-22-2012, 12:59 AM
  #18  
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,959
Total Cats: 11
Default

My only concern is that some of my high noost cells smoothed by 2%. Hopefully this doesnt cause an afr issue. Is a smooth ve table really necessary with the correct interpolation values?
miatauser884 is offline  
Old 06-22-2012, 03:56 AM
  #19  
Elite Member
 
Join Date: Mar 2006
Location: Schwarzenberg, Germany
Posts: 1,504
Total Cats: 86
Default

I am totally impressed!

I tried it with my VEtable - so nice and smooth now. This thing should be included in the VEanalyze function - analyze AND smooth. Because the smooth function takes no actual AFR target into account... (But it's very nice anyway...)

I just thought about giving a call out to Phil Tobin if there would be a way to make an "Extrapolate"-function. We will never know, what the real values in the upper left and lower right edges will be. So I thought there should be an excel spreadsheet or something like this to put in the actual "VEanalyzed"-Values and extrapolate to the untouched edges - and get smooth transitions at the edges of the really used values...
Zaphod is offline  
Old 06-22-2012, 04:15 AM
  #20  
Oni
Junior Member
iTrader: (1)
 
Join Date: Jan 2009
Location: Tasmania, AUS
Posts: 162
Total Cats: 3
Default

Can anyone confirm that smoothing the table is making a difference to drive quality / AFR stability?. i know that when VEAL was new people were saying " my maps now smooth but its driving better and more stable AFR". I know it makes sence that it would, perhaps it was only people with really ---- VE tables that said it made there tables better.

Thanks
Scott
Oni is offline  

Thread Tools
Search this Thread
Quick Reply: Smoothing VE tables - Interpolation Spreadsheet


Archive Advertising Cookie Policy Privacy Statement Terms of Service

© 2018 MH Sub I, LLC dba Internet Brands

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.