Double Interpolation Spreadsheet that makes you happy in the pants - Miata Turbo Forum - Boost cars, acquire cats.

Welcome to Miataturbo.net   Members
 


ECUs and Tuning Discuss Engine Management, Tuning, & Programming

Reply
 
 
 
LinkBack Thread Tools Search this Thread
Old 12-30-2014, 04:51 AM   #1
Junior Member
Thread Starter
 
Join Date: Jul 2014
Location: The Plentiful Land of Beer and Cheese
Posts: 417
Total Cats: 65
Default Double Interpolation Spreadsheet that makes you happy in the pants

I couldn't find what I was looking for on here to make my tuning life a little easier/faster, so I decided to just make it myself. If there's something like this out there already, good for you on finding it because I sure couldn't in my semi-inebriated state

What you see in the attachment is a spreadsheet that will double interpolate any size table from 3x3 up to 16x16 (for you MS3 guys because I'm such a thoughtful SOB) to a table size and scaling of your choice. This allows for stupid fast and easy re-scaling if you have multiple tables you like playing around with, and also makes copying other peoples tunes to your scaled values a brain-dead operation for all the noobs out there if you're lost and confused at getting a functional table put together for yourself. Its super helpful to scale 16x16 MS3 timing tables to 12x12 MS2 timing tables that I run on my DIYPNP, which is just one of the reasons I made it. Same logic would hold for those of you running MS1's and scaling all the larger tables down to work for you.

Make sure to enable content or the fancy macro coding voodoo won't work and you will be very much unhappy with the results.. I have an example calculation with a original table I found on here (Brains timing table I believe) saved to the spreadsheet to show how it works.. derp..

Figured I'd be nice and share it. *sips beer with sense of accomplishment*
Attached Files
File Type: xls Table Rescaling Spreadsheet.xls (72.0 KB, 86 views)
Padlock is offline   Reply With Quote
Old 12-30-2014, 06:06 AM   #2
Elite Member
iTrader: (5)
 
Erat's Avatar
 
Join Date: Oct 2011
Location: Detroit
Posts: 4,199
Total Cats: 260
Default

I'm assuming this will also work for just re-scaleing maps if you're keeping the same table size.

ie. Raising and or lowering max boost levels and or max RPM levels, while keeping the same table size?
Erat is offline   Reply With Quote
Old 12-30-2014, 06:29 AM   #3
Junior Member
Thread Starter
 
Join Date: Jul 2014
Location: The Plentiful Land of Beer and Cheese
Posts: 417
Total Cats: 65
Default

as long as your original table has greater or equal resolution than the table your trying to create it will work.

Example 1, if your original table has a MAP scaling from 25-215 kPa you cant magically generate a new table with values outside that range to get a higher boost table. The table that will be output can only have at maximum the same range of 25-215kPa in this example or you will see "N/A" in the cells as an error.

Example 2, if your original table is a MAP scaling of 25-215 kPa and you only want a higher resolution MAP scaling of 25-180 kPa based off the original 25-215 kPa tune, it will work very well.

re-scaling a 16x16 table to another 16x16 table by changing intermediate RPM/MAP values (not the max/mins) if you want more resolution for the idle cells or something similar would work great as well

TLDR: it works for re-scaling axis values and for increasing resolution (scaling axis values down) from existing tables.

Last edited by Padlock; 12-30-2014 at 06:42 AM.
Padlock is offline   Reply With Quote
Old 12-30-2014, 10:28 PM   #4
Elite Member
iTrader: (1)
 
Leafy's Avatar
 
Join Date: Jun 2012
Location: NH
Posts: 9,093
Total Cats: 90
Default

But what if you have a 16x16 table from 25 to 215 kpa and want to change it to be from 25 to 245kpa, will kit interpolate the 25 tAcer C72o 215 data to only fill those cells and leave the cells above 215 empty? I believe you can do that its just going to be a lot more work.
Leafy is offline   Reply With Quote
Old 12-30-2014, 10:31 PM   #5
SADFab Destructive Testing Engineer
iTrader: (5)
 
aidandj's Avatar
 
Join Date: Apr 2014
Location: Beaverton, USA
Posts: 17,997
Total Cats: 1,463
Default

Quote:
Originally Posted by Leafy View Post
But what if you have a 16x16 table from 25 to 215 kpa and want to change it to be from 25 to 245kpa, will kit interpolate the 25 tAcer C72o 215 data to only fill those cells and leave the cells above 215 empty? I believe you can do that its just going to be a lot more work.
Doesn't soviet have an application for doing that in the first couple pages of his build thread?

Found it: https://www.miataturbo.net/build-thr...e2/#post794433

Last edited by aidandj; 12-30-2014 at 11:07 PM.
aidandj is offline   Reply With Quote
Old 12-30-2014, 11:42 PM   #6
Hittin' Boost & Cones
iTrader: (2)
 
240_to_miata's Avatar
 
Join Date: May 2007
Location: Cromwell, Connecticut
Posts: 2,572
Total Cats: 11
Default

Nice. There are tons of these VBA based tuning aids in the subaru world. We should really cross reference more of it.
240_to_miata is offline   Reply With Quote
Old 12-31-2014, 10:01 AM   #7
Elite Member
iTrader: (1)
 
Leafy's Avatar
 
Join Date: Jun 2012
Location: NH
Posts: 9,093
Total Cats: 90
Default

I guess thats another thing I need to test. To see if the VBA excel spreadsheets work on libreoffice on linux. Thats personal to me, I'm switching to a chromebook with linux on it for a tuning laptop, I already have to have a VM with windows on it to run AEMTuner (already tested it fully functional but slow on a netbook sharing 2gb of ram between the Virtual Machine and the host OS), so installing microsoft office on the VM wouldnt be a huge deal.

*Seems to work just slow and glitchy on this dying netbook.
Leafy is offline   Reply With Quote
Old 12-31-2014, 05:42 PM   #8
Junior Member
Thread Starter
 
Join Date: Jul 2014
Location: The Plentiful Land of Beer and Cheese
Posts: 417
Total Cats: 65
Default

Quote:
Originally Posted by 240_to_miata View Post
Nice. There are tons of these VBA based tuning aids in the subaru world. We should really cross reference more of it.
that would be ideal. I come from the GM world where most of the tables are fairly standardized in HPtuners, so there isnt a huge demand for such spreadsheets/aids
Padlock is offline   Reply With Quote
Old 01-03-2015, 03:57 PM   #9
Elite Member
 
Join Date: Jul 2005
Posts: 6,454
Total Cats: 80
Default

Thanks for this! You just saved me a bunch of work.
JasonC SBB is offline   Reply With Quote
 
 
Reply

Related Topics
Thread Thread Starter Forum Replies Last Post
OTS Bilstein to motorsports ASN conversion stoves Suspension, Brakes, Drivetrain 5 04-21-2016 04:00 PM
Expected intake temps on the track? tazswing Race Prep 20 10-03-2015 12:04 PM
Noob to Miataturbo from MA JxPhan Meet and Greet 3 10-02-2015 03:17 AM
Going back to stock. Need some 1.6 parts. Trent WTB 2 10-01-2015 01:15 PM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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:30 AM.