Smoothing VE tables - Interpolation Spreadsheet - Page 2 - 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-22-2012, 07:11 AM   #21
I haz no trubo
iTrader: (2)
 
Oscar's Avatar
 
Join Date: Jan 2007
Location: Bolton, UK
Posts: 3,020
Total Cats: 114
Default

Am I the only one typing a cockload of numbers into the sheet and vice versa, or is there an easier way of doing this?
Oscar is offline   Reply With Quote
Old 06-22-2012, 07:36 AM   #22
Junior Member
 
Join Date: Sep 2010
Posts: 89
Total Cats: 3
Default

Quote:
Originally Posted by Oscar View Post
Am I the only one typing a cockload of numbers into the sheet and vice versa, or is there an easier way of doing this?
Select all cells in TS, CTRL+C to copy, paste into excel, reverse operation with new values. Win.
EunosBen is offline   Reply With Quote
Old 06-22-2012, 07:36 AM   #23
Elite Member
iTrader: (1)
 
Join Date: Jun 2006
Location: Warrington/Birmingham
Posts: 2,658
Total Cats: 39
Default

copy paste?
richyvrlimited is offline   Reply With Quote
Old 06-22-2012, 07:59 AM   #24
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

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.

Last edited by travisb; 06-22-2012 at 08:11 AM.
travisb is offline   Reply With Quote
Old 06-22-2012, 08:10 AM   #25
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

Quote:
Originally Posted by Oni View Post
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
I am nowhere near an expert in this area. I made this spreadsheet to help smooth my tables because I am not happy with what VEAL gives me. I'm not blaming VEAL. I'm new to tuning and working on cars and my VE values jump up and down from row to row and column to column. My VEAL results have a general shape that I like, but it's bumpy. Obviously there are other issues I still need to work out, so in my experience, smoothing the table smooth the ride.
travisb is offline   Reply With Quote
Old 06-22-2012, 08:31 AM   #26
I haz no trubo
iTrader: (2)
 
Oscar's Avatar
 
Join Date: Jan 2007
Location: Bolton, UK
Posts: 3,020
Total Cats: 114
Default

Quote:
Originally Posted by travisb View Post
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.
Oh well. In my defense, I'm stupid
Oscar is offline   Reply With Quote
Old 06-22-2012, 09:00 AM   #27
Elite Member
iTrader: (1)
 
Leafy's Avatar
 
Join Date: Jun 2012
Location: NH
Posts: 9,091
Total Cats: 90
Default

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.
Leafy is offline   Reply With Quote
Old 06-22-2012, 10:56 AM   #28
y8s
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
 
y8s's Avatar
 
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,037
Total Cats: 406
Default

Quote:
Originally Posted by Leafy View Post
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.
i like this idea. my VE table has some steep peaks in it that are there because of changes in VE due to the VVT. I dont want to mow them all down.
y8s is offline   Reply With Quote
Old 06-22-2012, 12:41 PM   #29
Elite Member
iTrader: (1)
 
Leafy's Avatar
 
Join Date: Jun 2012
Location: NH
Posts: 9,091
Total Cats: 90
Default

Yeah just have a cell that multiplies by the interpolation value and let us adjust it.
Leafy is offline   Reply With Quote
Old 06-22-2012, 12:56 PM   #30
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,982
Total Cats: 10
Default

I'm going to use my new smoothed table as a starting point fore VEAlive. It will be interesting to see if I end up wit a fairly smooth table. i thought VEAlive gave me a pretty smooth table to begin with.
miatauser884 is offline   Reply With Quote
Old 06-22-2012, 12:59 PM   #31
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

Quote:
Originally Posted by y8s View Post
i like this idea. my VE table has some steep peaks in it that are there because of changes in VE due to the VVT. I dont want to mow them all down.
I added the capability to put in a table of factors to adjust the level of smoothing. See attachment.

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
Attached Thumbnails
Smoothing VE tables - Interpolation Spreadsheet-vef01.png   Smoothing VE tables - Interpolation Spreadsheet-vef02.png   Smoothing VE tables - Interpolation Spreadsheet-vef03.png  
Attached Files
File Type: xls Smoothing_with_factors.xls (93.5 KB, 603 views)

Last edited by travisb; 06-22-2012 at 01:20 PM.
travisb is offline   Reply With Quote
Old 06-22-2012, 01:19 PM   #32
Junior Member
Thread Starter
 
Join Date: Sep 2011
Location: Chesterfield, VA
Posts: 252
Total Cats: 2
Default

Quote:
Originally Posted by travisb View Post
I added the capability to put in a table of factors to adjust the level of smoothing. See attachment.
New version with light blue-green-red coloring and black text. See attachment.
Attached Files
File Type: xls Smoothing_with_factors.xls (70.0 KB, 625 views)
travisb is offline   Reply With Quote
Old 06-22-2012, 03:12 PM   #33
Junior Member
iTrader: (1)
 
Join Date: Jan 2009
Location: Bradenton, FL
Posts: 291
Total Cats: 5
Default

Been looking for somthing like this for a while. Thanks for this!
Sokool is offline   Reply With Quote
Old 06-23-2012, 12:34 PM   #34
Elite Member
iTrader: (11)
 
Join Date: Feb 2009
Posts: 2,982
Total Cats: 10
Default

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
miatauser884 is offline   Reply With Quote
Old 06-23-2012, 04:06 PM   #35
Elite Member
iTrader: (2)
 
Join Date: Jan 2007
Location: Los Angeles, CA
Posts: 8,782
Total Cats: 119
Default

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?
Faeflora is offline   Reply With Quote
Old 06-23-2012, 07:05 PM   #36
Elite Member
iTrader: (5)
 
Join Date: Oct 2007
Location: Canton, Ga
Posts: 1,707
Total Cats: 19
Default

just confirmed it worked in OpenOffice on my Mac. I'll see how it runs.
Stealth97 is offline   Reply With Quote
Old 06-26-2012, 01:33 PM   #37
Junior Member
 
Join Date: Dec 2008
Location: Ft. Lauderdale, FL
Posts: 273
Total Cats: 7
Default

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.
MX5RACER is offline   Reply With Quote
Old 06-26-2012, 04:04 PM   #38
Senior Member
 
Join Date: Aug 2010
Location: Maumelle, AR
Posts: 618
Total Cats: 2
Default

Thats pretty slick, I went through the factors table and upped the percentage on the cells that I know ve analyze live has done a pretty good job with.... Very interested to see how it drives, and how ve al does now.
ianferrell is offline   Reply With Quote
Old 06-26-2012, 05:17 PM   #39
y8s
2 Props,3 Dildos,& 1 Cat
iTrader: (8)
 
y8s's Avatar
 
Join Date: Jun 2005
Location: Fake Virginia
Posts: 19,037
Total Cats: 406
Default

Quote:
Originally Posted by MX5RACER View Post
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.
or you could name the cells and use the names instead of $X$N
y8s is offline   Reply With Quote
Old 06-26-2017, 12:15 PM   #40
Junior Member
 
Join Date: May 2016
Location: Atlanta
Posts: 208
Total Cats: 53
Default

I'll probably get slagged for necro-posting this thread, but-

I found this thread in a search, and this Excel tool is flat out awesome for smoothing VE tables. I figured I would give other MS newbs who are new to the game a chance to check it out. Major props to the author.
Schroedinger 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 05:45 AM.