Padlock

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*

Erat

iTrader: (5)

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?

Padlock

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.

Leafy

iTrader: (1)

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.

aidandj

iTrader: (5)

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

240_to_miata

iTrader: (2)

Nice. There are tons of these VBA based tuning aids in the subaru world. We should really cross reference more of it.

Leafy

iTrader: (1)

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.

Padlock

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

JasonC SBB

Thanks for this! You just saved me a bunch of work.