MKIII - SAFR Gain Adjustment worksheet

[isnms]

Current version on post #13

The SAFR has 11 selectable set points.
We only need to adjust ~3500rpm and above.
I've made a simple Excel worksheet to calculate the gain adjustment for the rpm range desired.
Must have: Tools > Add-Ins > Analysis ToolPak enabled in Excel

Input three things to calculate your adjustment.
1. Input RPM range to tune.
2. Input Target A/F.
3. Input current A/F for specified RPM range.

*Verify your own settings.

Take it or leave it for what it's worth.


Edit: See post #6 below for a fully automated worksheet.

 

[Enraged]

very cool!

now all i need is an safc and a wideband with datalogging

 

[isnms]

Thank you.
I don't know how it will work with and safc. I think they have a Hi and Lo and I don't know how the settings are adjusted.
I configured this worksheet to calculate for the hks s-afr.
Let me know if it works with the safc.

 

[Blue87T(Dan)]

You are the man. I'll play with it using the SAFC this week and let you know.

 

[isnms]

Thanks Dan. I hope it can be useful on the safc also. If you need to tweak it any, the password, to make design changes, is isnms.

edit: made a couple of cosmetic changes only since I first posted it.

 

[isnms]

I've tweaked it even more. Now you only need to input two things.
1. RPM range to tune
2. Target A/F

Paste your datalog .csv file into the 'datalog' sheet in the workbook.
Data should be no higher than row 4.
Make sure AFR is in column B and RPM is in column C.
It will automatically figure current A/F for the specific RPM range.

Works perfect for zt2 .zto logs, without Lambda. Only use your tuning block, not the entire datalog.

edit: uploaded correction 9:20pm 10/24

 

[isnms]

Okay, say you have made some modifications, taken new datalogs.
You already have gain adjustments configured and want to know what the new adjustment % should be.
In this revision, you will input your current settings, and it will give you your new gain adjustment.

edit: New improved - to tune individual target a/f for each rpm point.

 

[isnms]

this is my final version that includes a cute graph

 

[Anomili]

Looks amazing, I hope that the guys who are testing it find that it is usefull with the s-afc

 

[isnms]

Updated v.6.9.11

•Tune individual target A/F each rpm point.
•Set your own RPM point or use averaged RPM point.
•Cute graph.

updated on post #13

 

[isnms]

I'd like to get some feedback from anyone that has tried the spreadsheet.

Was it easy to understand / use?
Any suggestions for improvement?
Not useful at all?
Was useful and did exactly what you needed?

 

[Racefiend]

Looks very cool. I haven't tried it yet, but I'll check it out when I get the hoopty running so and log a run.

 

[isnms]

v.6.9.26

added:
• EGT
• better instructions (I hope)

> SAFR Gain Adjustment worksheet .zip 167KB

 

[isnms]

try this on for size:

Apexi safc NEO worksheet
16 points of adjustment.

> NEO Gain Adjustment worksheet .zip 169KB

 

[empera]

guessing that one should work best with safc2 also?

 

[isnms]

It does not calculate low and hi settings.
It is my understanding that, if using the stock ecu on our cars, it is pointless to tune below open loop. I don't know how many settings are on the safc2 but I guess either could be used to figure high settings.

 

[isnms]

Cool, let me know if it works for you, or doesn't.

I guess it could be used for the safc's, keeping in mind:

SAFC I 8 points, 500 rpm increments
SAFC II 12 points, 200 rpm increments
SAFC NEO 16 points, 50 rpm increments

I may see if I can make it simpler to use for the I and II.

 

[isnms]

Ok, see if this works for the SAFC II

12 rpm set points. Settable in 200rpm increments.
note: 'averaged' automatically rounds to nearest 100rpm.
note: 'steps' automatically rounds to nearest 100rpm w/200rpm minimum.

> SAFC II Gain Adjustment worksheet .zip 167KB


EDIT: Snapdrive is slow

 

[isnms]

SAFC I can try this one

8 set points
500rpm increments

> SAFC I Gain Adjustment worksheet .zip 167KB