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

Welcome to Miataturbo.net   Members
 


MEGAsquirt A place to collectively sort out this megasquirt gizmo

Reply
 
 
 
LinkBack Thread Tools
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, 628 views)

Last edited by travisb; 06-22-2012 at 01:05 PM.
travisb is offline   Reply With Quote
Old 06-21-2012, 07:55 PM   #2
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,904
Total Cats: 1,793
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 online now   Reply With Quote
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,038
Total Cats: 407
Default

Quote:
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 offline   Reply With Quote
Old 06-21-2012, 08:02 PM   #4
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,904
Total Cats: 1,793
Default

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

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

Stunning work OP!
richyvrlimited is offline   Reply With Quote
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, 455 views)

Last edited by travisb; 06-22-2012 at 01:05 PM. Reason: Disclaimer.
travisb is offline   Reply With Quote
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   Reply With Quote
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

Quote:
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   Reply With Quote
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,038
Total Cats: 407
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 offline   Reply With Quote
Old 06-21-2012, 11:20 PM   #11
Boost Czar
iTrader: (61)
 
Braineack's Avatar
 
Join Date: May 2005
Location: Chantilly, VA
Posts: 72,904
Total Cats: 1,793
Default

Quote:
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 online now   Reply With Quote
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,038
Total Cats: 407
Default

your momma's got it bro
y8s is offline   Reply With Quote
Old 06-21-2012, 11:25 PM   #13
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,982
Total Cats: 10
Default

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

change font color to black.
Braineack is online now   Reply With Quote
Old 06-21-2012, 11:32 PM   #15
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,982
Total Cats: 10
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   Reply With Quote
Old 06-21-2012, 11:54 PM   #16
Elite Member
 
Join Date: Jul 2005
Posts: 6,454
Total Cats: 80
Default

This is a smoothing algorithm, not an interpolating one (thread title is wrong)
JasonC SBB is offline   Reply With Quote
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   Reply With Quote
Old 06-22-2012, 12:59 AM   #18
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,982
Total Cats: 10
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   Reply With Quote
Old 06-22-2012, 03:56 AM   #19
Senior Member
 
Join Date: Mar 2006
Location: Schwarzenberg, Germany
Posts: 1,497
Total Cats: 81
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   Reply With Quote
Old 06-22-2012, 04:15 AM   #20
Oni
Junior Member
iTrader: (1)
 
Join Date: Jan 2009
Location: Tasmania, AUS
Posts: 164
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   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
1994 Spec Miata Race Car SM/SM2/SSM For Sale Quinn Cars for sale/trade 6 10-23-2016 08:58 AM
What happened to my Dynalite? midpack Suspension, Brakes, Drivetrain 18 09-22-2015 08:52 PM
mm0105 TABLE SWITCHING WIRING? slomiata MEGAsquirt 2 09-15-2015 01:54 PM
VE values too low? compuw22c MEGAsquirt 4 09-12-2015 08:42 PM
ME221 Now has Autotune and Long Term Fuel Trim Tables Motorsport-Electronics ECUs and Tuning 0 09-05-2015 09:02 AM


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 10:59 AM.