Lazy Man's MAF tool

[chaser27]

Okay, so I've been called a lazy ass a time or two in my short life. If I can work hard once, to not have to work hard again, I'll do it. When it came to dialing in my MAF curve, I tried the traditional way of using the breakpoints, and applying the LTFT's to them, then manually smoothing the transitions. It took forever and turned my entire curve into a shit show after a few revisions... So I built a tool.
I had a bunch of other crap in it too, but I took it out for now. It isn't ready for prime time.

This is a simple VBA program in Excel, so it may throw a warning for Macro enabled workbooks... accept it. If you don't have Excel... sucks for you. If you can't run Macros because you use an apple or something... sucks for you. Use an emulator if you can.

HOW TO USE:
1) Copy/Paste your entire MAF curve into the row labeled "ORIGINAL MAF CURVE"
2) Press the big beautiful button labeled "Create New MAF Curve"
3) A userform will pop-up.
4) Enter your different break points and LTFT's that correspond to each one. You will see a chart update as you do this. It has 3 lines and a point.
The 3 lines are the original curve, the new curve and a percent difference curve.
The point is set by the MAF voltage and airflow options
Use a log to calculate airflow at high MAF voltages then fit the line through the point.
A calculator is included (Button "Calculate g/s")
5) Now that you have your corrected curve set-up, play with the lower controls to adjust the new curve until you are happy with how close it is. This provides you with a buttery smooth MAF curve.
6) Close the userform and Copy/Paste your "NEW MAF CURVE" into ATR
7) Profit


Now the keen eye may have noticed an additional option on the userform labeled "Min to adj." This is just a value where everything below is 0 since a percent difference between 0.01 and 0.02 is 100%, but it doesn't matter. It keeps you from worrying about it and your airflow won't be that low anyway. I use 1.5 g/s

The "Open New Log" button on the sheet is just another little tool I figured I'd keep in this release. It just opens CSV log files and does a quick/little analysis on them. I built it to show me what I want to see. I can't remember if I put in idiot proof code on it, so it may or may not crash if specific columns are not found it looks for.

Hope everyone enjoys it. It has been sitting on my computer and I rarely use it anymore, so I figured I'd share it.

[JgamB]

I think you should unveil the compressor map driven functions for the K04 with some instruction. That's a lot of pro-bono work.

[chaser27]

Originally Posted by JgamB I think you should unveil the compressor map driven functions for the K04 with some instruction. That's a lot of pro-bono work.

It still makes a lot of assumptions as far as BSFC, VE, IC efficiency etc. It almost has to be calibrated to the car to mean anything. I'm just not sure people will be able to use it effectively.

[davros]

I see there is still lots for me to learn about ATR and my AP

[chaser27]

Originally Posted by davros I see there is still lots for me to learn about ATR and my AP

If you have any questions. Let me know.

Also, @Enki; I'd be interested to see how this compares to the tool you've been working on.

[Enki]

The one I made is really hit or miss as far as accuracy goes for some reason; thus, I've not released it.

[chaser27]

@Raider; I just realized I put this in the 2010 ECU section "f426". Can you move this to the general ECU "f9" section so it's easier for people to find?

EDIT: Nevermind... that's the Gen 1 section. Is there not a general ECU tuning section or am I just an idiot?

[Raider]

There is Gen1, and Gen2.