PI:Lookup table, constant and maximum
I would like to solve some issues with PI Toolbox:
Lookup table: I don't know why but when I try to create a new lookup table in the Pi Math Management window it doesn't work and the message "Error: invalid definition" appears even if I think I have the good syntax, good definition... for example:
table #BumpRubber= C:\Users\Paul\Desktop\A.xls\Feuil1!B1:B10
I have the Pi toolbox 6 lite version.
Constant: I try to create new constant with the copy and paste command: "copy a value from an Excel spreadsheet and paste it into a constant value field. The Excel Cell location and Excel File paths are automatically entered." but again it doesn't work and I don't know why..
Maximum(): If I use the following command
maximum([Speed]) The software find the outing maximum speed ( Returns 1 when speed reaches its maximum else returns 0) the problem is I want to find the maximum speed for each region and I don't know how using the function maximum only for one region.
|