turboglenn
15+ Year Contributor
- 6,375
- 124
- Nov 5, 2007
-
RIpley,
West Virginia
can anyone tell me how to write a formula for one of the lettered rows/colums to translate teh AEM's sideband signal into an actual afr?
I know the formual, i just don't know excel
for instance..
lets say the AEm;s voltage readout of a datralog is placed in colum B for row one the math would be =sum( (b1/1000)*2+10) the "1" (coupled with the B) being the variable for what row you're on 1 through 1000 according to the length of the log) and the perntheses are in 2 different colors..the inner ones being green and the outer being black
How and where do i put what to get it to fill rows 1 - 1000 (respectively) with the corresponding data from colum B having gone through the math of each (1 - 1000) corresponsing rows and putting that data in say colum "K"
I have a spreadsheet where it's done, i just can't figure out how to format a new sheet in that same manner
I know the formual, i just don't know excel
for instance..
lets say the AEm;s voltage readout of a datralog is placed in colum B for row one the math would be =sum( (b1/1000)*2+10) the "1" (coupled with the B) being the variable for what row you're on 1 through 1000 according to the length of the log) and the perntheses are in 2 different colors..the inner ones being green and the outer being black
How and where do i put what to get it to fill rows 1 - 1000 (respectively) with the corresponding data from colum B having gone through the math of each (1 - 1000) corresponsing rows and putting that data in say colum "K"
I have a spreadsheet where it's done, i just can't figure out how to format a new sheet in that same manner
