ATTN Algebra/Excel lovers: need an AFR slope equation
Hi!
Objective: Dissecting Autotune to use universally.
* Convert an AFR difference (i.e. -1.5, if target=13.5 and O2=12) into a percentage.
* Apply the percentage to an existing fuel cell value.
Here's my current formula (I know, it's wrong)...
y - (-0.1x)(-1y) (Based on 10 increments from 10-20 AFR)
x = AFR difference
y = fuel value
i.e. 300-(-10%)(-300) = 330
x = -1
y = 300
Any suggestions?
Objective: Dissecting Autotune to use universally.
* Convert an AFR difference (i.e. -1.5, if target=13.5 and O2=12) into a percentage.
* Apply the percentage to an existing fuel cell value.
Here's my current formula (I know, it's wrong)...
y - (-0.1x)(-1y) (Based on 10 increments from 10-20 AFR)
x = AFR difference
y = fuel value
i.e. 300-(-10%)(-300) = 330
x = -1
y = 300
Any suggestions?
Hi!
Objective: Dissecting Autotune to use universally.
* Convert an AFR difference (i.e. -1.5, if target=13.5 and O2=12) into a percentage.
* Apply the percentage to an existing fuel cell value.
Here's my current formula (I know, it's wrong)...
y - (-0.1x)(-1y) (Based on 10 increments from 10-20 AFR)
x = AFR difference
y = fuel value
i.e. 300-(-10%)(-300) = 330
x = -1
y = 300
Any suggestions?
Objective: Dissecting Autotune to use universally.
* Convert an AFR difference (i.e. -1.5, if target=13.5 and O2=12) into a percentage.
* Apply the percentage to an existing fuel cell value.
Here's my current formula (I know, it's wrong)...
y - (-0.1x)(-1y) (Based on 10 increments from 10-20 AFR)
x = AFR difference
y = fuel value
i.e. 300-(-10%)(-300) = 330
x = -1
y = 300
Any suggestions?
I am not sure why you would need a "slope" equation. It is just a percent difference.
For example.
target is 13.0 and actual is 15.0 and fuel cell value is 400.
15.0 / 13.0 = 1.15 (+ 15%)
400 * 1.15 = 460
Target is 13.0 and actual is 12.0 fuel cell value is 400.
12.0 / 13.0 = .92 (- 8%)
400 * .92 = 369
So the equation is
(Actual / Target) * current fuel value = New Fuel value
I am pretty sure that is right, but who knows it is too early for me.
For example.
target is 13.0 and actual is 15.0 and fuel cell value is 400.
15.0 / 13.0 = 1.15 (+ 15%)
400 * 1.15 = 460
Target is 13.0 and actual is 12.0 fuel cell value is 400.
12.0 / 13.0 = .92 (- 8%)
400 * .92 = 369
So the equation is
(Actual / Target) * current fuel value = New Fuel value
I am pretty sure that is right, but who knows it is too early for me.
Honda-Tech Member
Joined: Sep 2002
Posts: 1,069
Likes: 0
From: the asshole of america..., upstate new york, USA
Great responses, thanks! Okay I'll explain in case you have any additional input.
This is an excel worksheet, part of an educational project.
Table 1 = Target AFR's.
Table 2 = Imported AFR's.
Table 3 = Existing fuel values.
Table 4 = Export fuel values.
For the areas I have no AFR data for ("=0"), how can I condition those cells to avoid a "0" output?
This is an excel worksheet, part of an educational project.
Table 1 = Target AFR's.
Table 2 = Imported AFR's.
Table 3 = Existing fuel values.
Table 4 = Export fuel values.
For the areas I have no AFR data for ("=0"), how can I condition those cells to avoid a "0" output?
Last edited by VegasInvasion; Apr 26, 2010 at 03:03 PM. Reason: poontang.
Trending Topics
IF( [Measured AFR] > 0, [Current Fuel Value] * [Measured AFR] / [Target AFR], [Current Fuel Value])
This will keep the existing fuel value if you don't have a measured AFR for that cell.
This will keep the existing fuel value if you don't have a measured AFR for that cell.
that is bad ***. thanks a million Mr. Norris.
PS, Texas Ranger sucked, but your martial arts competitions were magical.
PS, Texas Ranger sucked, but your martial arts competitions were magical.
Thread
Thread Starter
Forum
Replies
Last Post
k-series
Drag Racing
70
Oct 5, 2006 11:00 AM
THE SOUND OF VTEC
Honda CRX / EF Civic (1988 - 1991)
1
Apr 28, 2002 09:34 AM




