Using Excel to dial in your maf curve (meth users, perfectionists, etc.)

[rfinkle2]

If you guys want to use excel to create a smooth, predictable maf curve and want excel to do the work for you, below has proven to work well for me.

Please see notes @ bottom of post to help in manipulating the data vertically and horizontally. (atr will only transfer and accept pasted values if orientation is correct)

You can see the below maf curve combined with meth injection needed work.


1) Start by identifying the open loop portion of the log you want to correct by calculated load (example car is set to use 1.25 load to transition to open loop)


2) create your corrective multiplier by dividing actual exhaust readings in the log over the commanded afr you are targeting (as seen on pg. 49 of 86 in the atr helpfile) ... (logged afr / desired afr) = multiplier

3) Multiply logged maf g/s by multiplier found in # 2 (note screenshot does not show logged maf values that were multiplied against the corrective multiplier to get corrected maf g/s)



4) Chart maf v against resulting corrected maf values in # 3
-to chart the data use the insert tab, choose scatter chart, choose the top left option (aka scatter with only markers)

5) Click on the resulting charted data and choose "add trendline" > power > display equation on chart


6) The excel function (black line of best fit) now becomes what is used to create your maf curve where; x = maf voltage


7) Copy the maf voltage portion of the curve from ATR to give you the complete set of values the ecu uses (see pasting options in notes)

8) plug and chug to find resulting maf cuve based on function given from line of best fit


9) use the paste special>values> transpose function to get a horizontal, pastable maf curve and paste into appropriate maf g/s per voltage placement.



Notes:
-In order to paste the maf voltage line from atr, you will have to use the paste special>unicode text function

-In order for you to have pastable horizontal data (to insert resulting maf curve back into atr), you will have to use the "paste special > values > transpose option on occasion
-You will also have to use the above function to transfer the maf voltage values vertically onto your spreadsheet

[Rich990]

Thanks Rob!

[Lex]

Nice curve fitting Rob.

Just be aware that on gen2 cars the WOT trims will make your car reach AFR targets unless you're off by more than 10-12%.

For safety reasons I would not scale my MAF for meth especially on a gen2 and let the ECU take care of it. If you're off by more than 10-12% then that's a lot of meth.

I assume this was from a gen1 car?

[rfinkle2]

Originally Posted by Lex Nice curve fitting Rob. Just be aware that on gen2 cars the WOT trims will make your car reach AFR targets unless you're off by more than 10-12%. For safety reasons I would not scale my MAF for meth especially on a gen2 and let the ECU take care of it. If you're off by more than 10-12% then that's a lot of meth. I assume this was from a gen1 car?

Thanks Lex. I understand what you mean about the ability of the ecu to trim fuel in open loop.

I've used it on both generation cars with great results.

The multiplier that I'm using is still based on the ol' long division to correct the curve, I'm then allowing excel to fit the curve based on those corrected g/s values rather than plugging each individual cell manually, or multiplying small groups of cells manually.

@Lex; ... # 3 in the OP is a better way to explain.

[86AmishMs3]

Good stuff...tis what I do too

[superskaterxes]

Originally Posted by Lex Nice curve fitting Rob. Just be aware that on gen2 cars the WOT trims will make your car reach AFR targets unless you're off by more than 10-12%. For safety reasons I would not scale my MAF for meth especially on a gen2 and let the ECU take care of it. If you're off by more than 10-12% then that's a lot of meth. I assume this was from a gen1 car?

when is cobb going to release these tables for us?

[rfinkle2]

Originally Posted by superskaterxes when is cobb going to release these tables for us?

Good question. I know DJ asked David about the maximum amounts of trim allowed and those tables to be exposed, but I haven't heard anything else about it.

[Cataphract_40]

What was your R squared value for that curve?

[rfinkle2]

Originally Posted by Cataphract_40 What was your R squared value for that curve?

Always in the 95% + region.

Very high.

[Lex]

Originally Posted by superskaterxes when is cobb going to release these tables for us?

Not sure if there is much in terms of development at this time. They have their hands full with the ST etc. I will inquire next time I speak with David.

[ms3blackmica]

Rob sent this idea over to me and I attest to it working VERY nicely.

Funny thing is, I was using my TI-83 for shit like this LOL


Edit: Rob should be thanked x100000000000000

[TiGraySpeed6]

Excel tricks are always cool, Thanks Rob!
Excellent job covering the steps to a process that would normally be beyond the average persons experience level with excel!

For those on newer versions, excel has an option for transposing with the other options in the right click > paste menu, along with format pasting etc...

[atvfreek]

Originally Posted by rfinkle2 If you guys want to use excel to create a smooth, predictable maf curve and want excel to do the work for you, below has proven to work well for me. Please see notes @ bottom of post to help in manipulating the data vertically and horizontally. (atr will only transfer and accept pasted values if orientation is correct) You can see the below maf curve combined with meth injection needed work. 1) Start by identifying the open loop portion of the log you want to correct by calculated load (example car is set to use 1.25 load to transition to open loop) 2) create your corrective multiplier by dividing actual exhaust readings in the log over the commanded afr you are targeting (as seen on pg. 49 of 86 in the atr helpfile) ... (logged afr / desired afr) = multiplier 3) Multiply logged maf g/s by multiplier found in # 2 4) Chart maf v against resulting corrected maf values in # 3 -to chart the data use the insert tab, choose scatter chart, choose the top left option (aka scatter with only markers) 5) Click on the resulting charted data and choose "add trendline" > power > display equation on chart 6) The excel function (black line of best fit) now becomes what is used to create your maf curve where; x = maf voltage 7) Copy the maf voltage portion of the curve from ATR to give you the complete set of values the ecu uses (see pasting options in notes) 8) plug and chug to find resulting maf cuve based on function given from line of best fit 9) use the paste special>values> transpose function to get a horizontal, pastable maf curve and paste into appropriate maf g/s per voltage placement. Notes: -In order to paste the maf voltage line from atr, you will have to use the paste special>unicode text function -In order for you to have pastable horizontal data (to insert resulting maf curve back into atr), you will have to use the "paste special > values > transpose option on occasion -You will also have to use the above function to transfer the maf voltage values vertically onto your spreadsheet

Good shit Rob! I like it.

[rfinkle2]

Starting to get vd logs that look this way very consistently now after running each revision through the same process. (targeting 11.83 @ this point in rpm band)

[ms3blackmica]

Holy hell Rob good shit

I, in fact, am not the mad scientist..

[rfinkle2]

Originally Posted by ms3blackmica Holy hell Rob good shit I, in fact, am not the mad scientist..

Your brain power eclipses mine Nishan. I just like to use excel and was tired of trying to blend maf curves.

[TiGraySpeed6]

So I'm walking one of my own logs through this, and can do everything up to, and everything after, but step 8 has me stuck on the plug & chug bit.

Are you copying both MAF volts and g/s in step 7? Or are you working against the logged g/s?

in step 8 you've got both the y value as the base. and the x as the raise to.
What's the formula being applied?

And the newly created g/s values, are you working that math against the entire open loop area, all the way to the end?

[Volcom8190]

never thought to do this, another reason to keep excel on the logging computer i guess.

[ms3blackmica]

Originally Posted by rfinkle2 Your brain power eclipses mine Nishan. I just like to use excel and was tired of trying to blend maf curves.

There is a sin function called a cardiod represented as R = a(1+/- sinΘ) and when plotted resembles a heart.

There ya go Rob.

A nerd's internet heart. Yup, I went there.

[Cataphract_40]

Originally Posted by rfinkle2 Always in the 95% + region. Very high.

Very nice, looked like a good fit from just eyeballing it.

Originally Posted by ms3blackmica There is a sin function called a cardiod represented as R = a(1+/- sinΘ) and when plotted resembles a heart. There ya go Rob. A nerd's internet heart. Yup, I went there.

Partial to the Batman curve myself...



Batman Curve -- from Wolfram MathWorld

[rfinkle2]

Originally Posted by TiGraySpeed6 So I'm walking one of my own logs through this, and can do everything up to, and everything after, but step 8 has me stuck on the plug & chug bit. Are you copying both MAF volts and g/s in step 7? Or are you working against the logged g/s? Only copy the maf voltages that are close to those you chose from the log based on your closed loop max load value. In the log, that value was 2.68, but that was not an available point when I copied the maf voltages from atr, so I chose to start @ 2.66 which was a voltage value from ATR) . Continue from open the loop value you choose to the end (5v). in step 8 you've got both the y value as the base. and the x as the raise to. What's the formula being applied? The formula is given from the fitted curve by excel. In the example, y=4.0831x^3.0713 Gramspersecondyoucopyandpasteasnewcurve = 4.0831 * voltagecopied from ATR ^3.0713 And the newly created g/s values, are you working that math against the entire open loop area, all the way to the end?

I should have explained it better now that I think about it.

-The log that you have has the voltage the ecu used, your logged afr and the g/s the ecu used to create the a/f ratio.

-Use the corrective multiplier against the logged maf g/s values and chart that number against logged maf voltage.

The above 2 steps give you the data excel fits a curve onto.

-once excel spits out the equation, use only the voltage values from atr as "x" in the equation, and the resulting maf g/s values are the "y" value.


It is hard to explain this crap in text.

[rfinkle2]

@TiGraySpeed6; I see you @ the bottom of the screen. LOL.

Choose an open loop maf voltage value seen in atr and use the formula to get your maf g/s values all the way through to 5v.

[TiGraySpeed6]

All righty then, for the sheet below, the money shot is =J2*I2^K2


On a map targeting 11.8, the log resulted in the following log data-





So, from that log, the following graph was created





And using the data from that graph, and the formula =J2*I2^K2 resulted in the curve as shown. Pretty darn nifty.

[ms3blackmica]

This shit is becoming awesome

[TiGraySpeed6]

Amazing part is that the changes actually correct up and down from the original values as needed.

pretty freaking spiffy.

[tbot]

I think I'm too tired atm to understand this completely haha. Realized when I tried to scroll TiGray's MAF Table A not realizing it was a picutre...get the jist of it tho!

[TiGraySpeed6]

Does seem to smooth things out pretty easily!
I've set a template with the formulas already in place, just have to populate with data, get the correction chart and populate that data, then past the results in ATR.

From the first AFR's I posted above, it's leveled out to look like this on just the second revision (don't mind the power numbers, this map isn't pushing for big numbers):

[ms3blackmica]

I love it.

[GODspeed7]

Is it bad that this shit is so complex that I am just skimming the thread looking for more batman pictures and heart pictures made with graphs? Lol


Tapatalk LIKE A BOSS!

[TiGraySpeed6]

It's really not tho

You do the same core work to get the corrected g/s numbers to start from, using the same ol' math - [Logged Actual AFR]/[Target WOT AFR] = g/s multiplier. That gets you the corrected MAF g/s points as always.

Then you plug those corrections into the Finklechart (tm) and the magic math is given back to you on a silver platter.

Then you just run the finklechart math against your MAF Voltage points and presto- updated, corrected, curved & smoothed MAF g/s numbers are provided to paste directly into your MAF tables.

It's always sucked trying to match the logged values to the actual ATR MAF Volt values, and often it's done by addressing a cell or two at a time. Finkle's Excel method does the entire OL curve at once, pinpointing the exact MAF Volt numbers.

Even better, it get's progressively better with each revision- Mine went from spazzy to smooth in two, and will, I suspect, be dead flat by 4 revisions.


It's actually both easier and faster.


And, yes, that is indeed very cool





.

[Rich990]

This should be a sticky!

@TiGraySpeed6, it would be good if you could post up the FinkleChart workbook, maybe in the VIP section.

MSF FTMFW

[TiGraySpeed6]

the graphic I posted of the spreadsheet above pretty much covers it, and indicates the excel formula that works the final curve, at least as the columns are in that one.

I'm loath to just put up an actual template simply because I think it's important to walk through the steps exactly as Rob laid them out in the first post and understand what goes where and why.

I don't want to sound like an asshole, but honestly, this process, like any powerful tool, could just as quickly fuck up your curve if you don't use it properly. It's better to go through the process and learn each step, know what it does and why, and how it impacts the next step as you progress.

It shouldn't be just paste the input, then copy the output.

[Mfinlay04]

Gonna give this a go the next time I have a day off... My LTFT are pretty dialed in but I'm sure they could be tweaked even more

Sent from my Galaxy Nexus using Tapatalk 2

[TiGraySpeed6]

3rd revision looks like this- Tad of KR at 5700, or it would have been glass.

Damn glad it's not an EKG......

[CosmicArkie]

Given that I'm to damned old to figger the whole Excel thing out,
I did it the old fashioned way. Always wondered why a lot of the
VD plots were like the Rocky Mountains, though.

[TiGraySpeed6]

That's a nice AFR plot there Cosmic, and a nice K04 VD all around

[GODspeed7]

@rfinkle2; I can haz flat line AFR's??? You know when my car is not being a temperamental bitch... Lol!


Tapatalk LIKE A BOSS!

[rfinkle2]

Originally Posted by GODspeed7 @rfinkle2; I can haz flat line AFR's??? You know when my car is not being a temperamental bitch... Lol! Tapatalk LIKE A BOSS!

I used this process on your last revision, and as the map progresses, it should get gradually more accurate.

[ms3blackmica]

Originally Posted by GODspeed7 @rfinkle2; I can haz flat line AFR's??? You know when my car is not being a temperamental bitch... Lol! Tapatalk LIKE A BOSS!

Just email him teh good stuffz

[GODspeed7]

Originally Posted by ms3blackmica Just email him teh good stuffz

Lol oh I have been. My car has been a dirty whore lately so we have been swapping maps for the last 48 hours. I was just busting his balls. Those AFR's are sick though!


Tapatalk LIKE A BOSS!