Engine Management and Tuning Crome, NepTune, Hondata, AEM, MOTEC

ATTN Algebra/Excel lovers: need an AFR slope equation

Thread Tools
 
Search this Thread
 
Old Apr 15, 2010 | 07:04 PM
  #1  
VegasInvasion's Avatar
Thread Starter
I'm Huge In Japan
 
Joined: Apr 2008
Posts: 1,314
Likes: 2
From: the 615
Default 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?
Reply
Old Apr 15, 2010 | 09:24 PM
  #2  
MrDomino's Avatar
Honda-Tech Member
 
Joined: Mar 2007
Posts: 952
Likes: 0
From: North of LA
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

Originally Posted by VegasInvasion
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?
Wait, what? Explain what you're trying to do again.
Reply
Old Apr 16, 2010 | 01:12 AM
  #3  
GT35R_EF's Avatar
Make mine whatever you want
 
Joined: Apr 2008
Posts: 573
Likes: 0
From: Portland, OR
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

Originally Posted by MrDomino
Wait, what? Explain what you're trying to do again.
This.

Hmmmm, I know what you're looking for kinda. Explain your thought process with your original equation a little bit, and why you came up with that.
Reply
Old Apr 16, 2010 | 04:32 AM
  #4  
93turbo16's Avatar
iTrader: (2)
 
Joined: Jun 2004
Posts: 9,743
Likes: 3
From: Carlisle, Pa, USA
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

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.
Reply
Old Apr 16, 2010 | 04:42 AM
  #5  
fastcrxsi90's Avatar
Honda-Tech Member
 
Joined: Sep 2002
Posts: 1,069
Likes: 0
From: the asshole of america..., upstate new york, USA
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

Originally Posted by 93turbo16
(Actual / Target) * current fuel value = New Fuel value
this is correct...actual/target is your fuel value multiplier. works for afr and lambda...
Reply
Old Apr 18, 2010 | 10:47 PM
  #6  
MrDomino's Avatar
Honda-Tech Member
 
Joined: Mar 2007
Posts: 952
Likes: 0
From: North of LA
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

Originally Posted by fastcrxsi90
this is correct...actual/target is your fuel value multiplier. works for afr and lambda...
And equivalence ratio which is just 1/Lambda

Seriously I hate engine research. Who came up with equivalence ratio?
Reply
Old Apr 26, 2010 | 03:02 PM
  #7  
VegasInvasion's Avatar
Thread Starter
I'm Huge In Japan
 
Joined: Apr 2008
Posts: 1,314
Likes: 2
From: the 615
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

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?

Last edited by VegasInvasion; Apr 26, 2010 at 03:03 PM. Reason: poontang.
Reply
Old Apr 27, 2010 | 10:02 AM
  #8  
ddd4114's Avatar
Honda-Tech Member
 
Joined: Mar 2006
Posts: 2,062
Likes: 1
From: Columbus, OH
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

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.
Reply
Old May 5, 2010 | 11:43 AM
  #9  
VegasInvasion's Avatar
Thread Starter
I'm Huge In Japan
 
Joined: Apr 2008
Posts: 1,314
Likes: 2
From: the 615
Default Re: ATTN Algebra/Excel lovers: need an AFR slope equation

that is bad ***. thanks a million Mr. Norris.
PS, Texas Ranger sucked, but your martial arts competitions were magical.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
NACvicSi
Honda Civic / Del Sol (1992 - 2000)
9
Oct 29, 2013 04:23 PM
C_H_A_D
Welding / Fabrication
2
Apr 6, 2007 07:23 PM
k-series
Drag Racing
70
Oct 5, 2006 11:00 AM
mrcrimane
Acura Integra
9
Aug 9, 2003 11:43 AM
THE SOUND OF VTEC
Honda CRX / EF Civic (1988 - 1991)
1
Apr 28, 2002 09:34 AM




All times are GMT -8. The time now is 01:20 AM.