you can add ?
Int24(A:B:C)

thanks, I checked, this formula works

I very nearly added int24 but thought I was being silly and nobody would want it – proved me wrong

I’ll add that in the next beta (currently rewriting TorqueScan at the moment, which may or may not include a nicer screen/layout for tablets)…

Single quotes are used for strings in equations because double-quotes aren’t going to play nicely with CSV exports/imports and would need to be escaped… I feel that’s a bit messy for anyone using a text editor to do this so I’ve avoided it by using single quotes instead (leaving double quotes happily in the CSV file)

0=’P’ should be working – if it’s not I’ll try to check tonight/tomorrow and will fix, same for the other bits and ideas on the previous page (a little bit snowed in at the minute)

Substituted 0C and 0D with 1600 and 75.244
respectively which should have resulted in
0.830 matching ‘6th’ gear. It did not. Test
showed correct equation data but wrong
result. (It almost looks to me like the difference
from the closest match but text was not used).

closest((1600*60*1.830)/(75.244*2.813*1000)::4.552=’1st’:2.548=’2nd’:1.659=’3rd’:1.230=’4th’:1.000=’5th’:0.830=’6th’)

Also tested Cintakc Lookup example and
found…

Lookup(0::0=’who’:1=’moo’:2=’boo’) showed who
Lookup(1:: … showed error
Lookup(2:: … showed error
Lookup(7-5:: … showed error
Lookup(3:: … accepted

capp777: can you check you’re on the latest beta – the lookup(1::0=’who'(etc)) is working here from the examples you’ve given, so not entirely sure what’s up

The closest function simply does a subtraction from the search value to the current value, and chooses the smallest one to return from the list of supplied values – there’s no ‘tolerance’ as such as it’s all double-precision arithmetic at that point

I’ll look at the functions again tonight to check that I’ve not missed anything (at the moment I’m stuck doing a long overdue upgrade of the mapping tile, upload, and theme servers)

Basically(pseudocode):

 double closestFound = Double.MAX;
 loop through search values {
    double diff = Math.abs(currentValue-searchValue);
    if (diff < closestFoundl) {
       closestFound = diff;
       // some more bits
    }
 }

(though Ive just noticed a small issue when not returning a string value which I'll get sorted)

OK will look at that tonight – if you have a screenshot ( I know it sounds daft) of the ‘error’ that’ll help loads (email is ok to ian@prowl.org if that’s easier to do)

Bit rushed for the next 2 days so I’ll try my best to get things sorted out!

Ian found my testing with lookup was
failing due to the single quotes used by
the phone being different than the single
quote used by Word in my UTF-8 csv file.

Still curious why some equation values worked
but others didn’t under the same problem.

Update:

Went back to gear pid and edited equation
on my phone to retype all the single quotes…
and now am getting 6th text displayed.

For some reason the single quotes from my Word
UTF-8 csv file don’t play well (even though they
look the same in the pid editor).

Capp:

My tire circumference is 2000 millimeters

No idea about gears/differential ratios but i can find out…

I’m so lazy that I’ve think to show the gear in use simply doing RPM/VEHICLE SPEED so 0C/0D and then put the values on “closest” function and use something like this:

closest(([0C]/[0D]::20=’6th’:23=’5th’:29=’4th’:41=’3rd:62=’2nd’:110=’1st’))

Not sure if it works, I will try this one this evening.

edit

Ok, the above equation seem to work except to the fact the pid editor doesn’t allow to save the it because [0C]/[0D] is equal to NaN when speed is equal to 0, to fix that I have put [0C]/([0D]+1) .
Tomorrow I’ll test better: need to findcthe exact ratio for 1st gear.
I have to manage also the cases when the car is stationary with engine ON or the car is moving in neutral

Beta Torque Pro version 1.8.196 is failing
to install on my Samsung Galaxy Exhibit 4g.
Error -11 reported after each failed attempt.