Smoothing VE tables - Interpolation Spreadsheet
#24
Junior Member
Thread Starter
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Quick copy/paste - click anywhere in the VE table in TS. Press CTRL+A to select all. Then CTRL+C to copy the table. Go to the spreadsheet and click the top-left cell in the origial values section. Press CTRL+V to paste the values.
The new values are now generated. Select the new values. CTRL+C to copy. Go back to TS and click the top-left cell. Press CTRL+V to paste the new values.
Once you get used to this method it should take less than 5 seconds to get your new values.
The new values are now generated. Select the new values. CTRL+C to copy. Go back to TS and click the top-left cell. Press CTRL+V to paste the new values.
Once you get used to this method it should take less than 5 seconds to get your new values.
Last edited by travisb; 06-22-2012 at 07:11 AM.
#25
Junior Member
Thread Starter
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
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
Thanks
Scott
#26
Quick copy/paste - click anywhere in the VE table in TS. Press CTRL+A to select all. Then CTRL+C to copy the table. Go to the spreadsheet and click the top-left cell in the origial values section. Press CTRL+V to paste the values.
The new values are now generated. Select the new values. CTRL+C to copy. Go back to TS and click the top-left cell. Press CTRL+V to paste the new values.
Once you get used to this method it should take less than 5 seconds to get your new values.
The new values are now generated. Select the new values. CTRL+C to copy. Go back to TS and click the top-left cell. Press CTRL+V to paste the new values.
Once you get used to this method it should take less than 5 seconds to get your new values.
#27
Could you add in a strength factor to the interpolation? Being perfectly smooth isnt everything, sometimes the car wants what it wants and its not a pretty table. I still get better driving tunes smoothing by hand than any interpolation algorithm I've run into yet. But they're helpful as ---- when you jump into a car with the tune way the hell off.
#28
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,338
Total Cats: 573
Could you add in a strength factor to the interpolation? Being perfectly smooth isnt everything, sometimes the car wants what it wants and its not a pretty table. I still get better driving tunes smoothing by hand than any interpolation algorithm I've run into yet. But they're helpful as ---- when you jump into a car with the tune way the hell off.
#31
Junior Member
Thread Starter
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
There are two tabs in the spreadsheet, one for 16x16 and one for 12x12.
Paste your VE values as before into the Original Values section. To the right is the Smoothed Values section.
Below the Original Values are the Factored Values. To the right of the Factored Values is a section where you can enter your Factors using the same 12x12 or 16x16 size table.
For the factors, enter a number between 0 and 100. With higher factors, less smoothing will be applied and the values will be closer to your original ones. With lower factors, more smoothing will be applied.
Because of the Factors table you can choose how much or little smoothing to apply. You might want less smoothing in the idle regions and high map/high rpm area if those are already well tuned.
===============
Here is an example.
Take a table that looks like this:
It smooths like this:
With a factor of 50 across the entire table it looks like this:
Please test and let me know how it works for you.
New version with light blue-green-red coloring and black text in post 32. https://www.miataturbo.net/showpost....7&postcount=32
Last edited by travisb; 06-22-2012 at 12:20 PM.
#34
I'm now am a smooth table believer. My VE table was pretty smooth from a lot of tuning in a very narrow MAT window, and having a nicely dialed in MAT correction table. I drove iwth my new smoothed tables (fuel, spark, afr) The difference was subtle, but i felt the transitions while shifting were more smooth.
I'm going to test the smoothing with autotune. i.e. tune a session, then smooth and see if beginning with a smooth table will result in a smoother VEAlive table. I really think this should bt incorporated into tunerstudio. after a VEAlive session it prompts you to smooth the table.
EDIT: I'm not sure if I could have used the word "smooth" any more in that post. lol
I'm going to test the smoothing with autotune. i.e. tune a session, then smooth and see if beginning with a smooth table will result in a smoother VEAlive table. I really think this should bt incorporated into tunerstudio. after a VEAlive session it prompts you to smooth the table.
EDIT: I'm not sure if I could have used the word "smooth" any more in that post. lol
#35
Elite Member
iTrader: (2)
Join Date: Jan 2007
Location: Los Angeles, CA
Posts: 8,682
Total Cats: 130
This is very cool. I am an interpolation freak, and I do exactly what this spreadsheet does. Manually. Interpolating 3 cells at a time across a 32x32 grid in hydra is not super fun.
Matt, in my experience, smooth fuel/VE will net better driveability. AFR may not be deadnuts perfect, but what is the point of having perfect AFR if car drives cruddy?
Matt, in my experience, smooth fuel/VE will net better driveability. AFR may not be deadnuts perfect, but what is the point of having perfect AFR if car drives cruddy?
#37
I have not plugged any values into the spreadsheets, but I looked at your formulas and they look good. I would add $ to lock the areas where your formulas are looking. For example:
=IF(OR(C2<>"",C3<>"",D2<>"",D3<>""),AVERAGE(C2,C3, D2,D3),"")
Would look like:
=IF(OR($C$2<>"",$C$3<>"",$D$2<>"",$D$3<>""),AVERAG E($C$2,$C$3,$D$2,$D$3),"")
This way no matter where you paste in your formula (This case W2), it will always look at C2, C3, D2 & D3 even if you pasted this formula into Z26 for example.
=IF(OR(C2<>"",C3<>"",D2<>"",D3<>""),AVERAGE(C2,C3, D2,D3),"")
Would look like:
=IF(OR($C$2<>"",$C$3<>"",$D$2<>"",$D$3<>""),AVERAG E($C$2,$C$3,$D$2,$D$3),"")
This way no matter where you paste in your formula (This case W2), it will always look at C2, C3, D2 & D3 even if you pasted this formula into Z26 for example.
#39
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,338
Total Cats: 573
I have not plugged any values into the spreadsheets, but I looked at your formulas and they look good. I would add $ to lock the areas where your formulas are looking. For example:
=IF(OR(C2<>"",C3<>"",D2<>"",D3<>""),AVERAGE(C2,C3, D2,D3),"")
Would look like:
=IF(OR($C$2<>"",$C$3<>"",$D$2<>"",$D$3<>""),AVERAG E($C$2,$C$3,$D$2,$D$3),"")
This way no matter where you paste in your formula (This case W2), it will always look at C2, C3, D2 & D3 even if you pasted this formula into Z26 for example.
=IF(OR(C2<>"",C3<>"",D2<>"",D3<>""),AVERAGE(C2,C3, D2,D3),"")
Would look like:
=IF(OR($C$2<>"",$C$3<>"",$D$2<>"",$D$3<>""),AVERAG E($C$2,$C$3,$D$2,$D$3),"")
This way no matter where you paste in your formula (This case W2), it will always look at C2, C3, D2 & D3 even if you pasted this formula into Z26 for example.