Exponent in formul editor

Discuss anything TunerPro related.

Moderators: Mangus, robertisaar, dex

Post Reply
Asterypsilon
Posts: 10
Joined: Sat Sep 24, 2022 7:44 am

Exponent in formul editor

Post by Asterypsilon »

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.
User avatar
dex
The Ford Guy
Posts: 612
Joined: Thu Oct 07, 2004 6:38 am

Re: Exponent in formul editor

Post by dex »

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.
Asterypsilon
Posts: 10
Joined: Sat Sep 24, 2022 7:44 am

Re: Exponent in formul editor

Post by Asterypsilon »

dex wrote: Sat Sep 24, 2022 8:47 am 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.
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 :P )

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.
Asterypsilon
Posts: 10
Joined: Sat Sep 24, 2022 7:44 am

Motronic ML 3.1 AFM transfer function

Post by Asterypsilon »

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.
Post Reply