Hi guys,
Thank you for letting me in.
I'd like Tuner Pro to compute an exponential formula in the row equation, but the excel standard "^" doesn't work.
How can I do it?
Thank you in advance.
Exponent in formul editor
Moderators: Mangus, robertisaar, dex
Re: Exponent in formul editor
The caret symbol (^) is the XOR operator in TunerPro, use the POW(x; exp) function.
See the TunerPro help file section 'The Conversion Editor' under 'Editing Bin Definitions' for details of the operators and functions.
See the TunerPro help file section 'The Conversion Editor' under 'Editing Bin Definitions' for details of the operators and functions.
-
- Posts: 14
- Joined: Sat Sep 24, 2022 7:44 am
Re: Exponent in formul editor
Thank you very much, it worked stright away.
I didn't even think to the "help" section...my fault.
(Funny is that when you are looking for something in excel, word, etc., you go instantly to the help )
I'm implementing the AFM transfer function of an old motronic and I have 3 tables that work this way: AFM1 x 2^AFM2 x AFM3. 8, 8 and 32 bits respectively.
My problem is that while AFM1 x 2^AFM2 is a direct cell to cell multiplication, which gives an easy 8 cells table, each cell of this last table must be multiplicated for all the 32 cells of AFM3 so the result would be a 8 x 32 = 256 x 1 table.
Since now I was only able to get 8 separate blocks of 32 cells, not to join them toghether in a 256x1 columns, neither in a 32x8 table, which
only gets the first block when I put it in the formula in the first column equation, but the other block / formula assotiation doesn't work.
-
- Posts: 14
- Joined: Sat Sep 24, 2022 7:44 am
Motronic ML 3.1 AFM transfer function
Did it.
THAT(13030;row();0;FALSE)*THAT(58;0;0;false)*POW(2;THAT(21947;0;0;FALSE))
13030 is the AFM3 32 x 1 matrix ID, 58 the AFM1 8 x 1 and 21947 the AFM2 8 x 1.
You create a 32 x 8 XDF item in an unused 256 addresses space of the eprom. Repeat the equation above as "column equation" for each of the 0 to 7 (8) columns.
In column 1 you will just change the bold zeroes to 1, in the column 2 to 2, etc.
I scaled down the results by extracting an SQR and dividing it by 10, so the actual equation is :
SQR(THAT(13030;row();0;FALSE)*THAT(58;0;0;false)*POW(2;THAT(21947;0;0;FALSE)))/10
I'm still looking to fit the 32 x 8 values in a 256 x 1 element, instead of the 32 x 8.
THAT(13030;row();0;FALSE)*THAT(58;0;0;false)*POW(2;THAT(21947;0;0;FALSE))
13030 is the AFM3 32 x 1 matrix ID, 58 the AFM1 8 x 1 and 21947 the AFM2 8 x 1.
You create a 32 x 8 XDF item in an unused 256 addresses space of the eprom. Repeat the equation above as "column equation" for each of the 0 to 7 (8) columns.
In column 1 you will just change the bold zeroes to 1, in the column 2 to 2, etc.
I scaled down the results by extracting an SQR and dividing it by 10, so the actual equation is :
SQR(THAT(13030;row();0;FALSE)*THAT(58;0;0;false)*POW(2;THAT(21947;0;0;FALSE)))/10
I'm still looking to fit the 32 x 8 values in a 256 x 1 element, instead of the 32 x 8.