Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

|2 "V" "P" 
"1" 10 10000 
"2" 12 12000 
"3" 14 14000 
"4" 16 16000|


TEXTITEM2=

returns:

|2 "V" "P" 
"1" 10 9300 
"2" 12 11400 
"3" 14 13500 
"4" 16 15600|


2 "V" "DeltaP" 
"1" 10 700 
"2" 12 600 
"3" 14 500 
"4" 16 400

Example 2

Let Telitab1$ contain the dataset:

...

returns (values rounded):



6 "Vs" "ResRatio" "PE1" "PE2" 
"1" 6.173 0.9856 197.341 200.224 
"2" 6.687 0.9720 280.309 288.354 
"3" 7.202 0.9891 357.832 361.750 
"4" 7.716 0.9789 399.472 408.069 
"5" 8.231 1.0021 443.225 442.286 
"6" 8.745 1.0124 488.872 482.866 
"7" 9.259 1.0137 536.121 528.843 
"8" 9.774 1.0069 590.664 586.572 
"9" 10.288 1.0101 664.800 658.112 
"10" 10.803 1.0168 760.645 748.060 
"11" 11.317 1.0089 865.066 857.427

Example 3

Create a dataset on an equidistant axis "V" on the basis of an axis definition in Teltab1$ and a non-equidistant set V-RTot in Telitab2$.

Let Telitab1$ contain:


Let Telitab2$ contain:


1 "V" 
"1" 12.00 
"2" 14.00 
"3" 16.00 
"4" 18.00 
"5" 20.00 
"6" 22.00



2 "V" "RTot" 
"1" 12.10 33.663 
"2" 14.30 51.529 
"3" 15.90 53.579 
"4" 18.10 57.369 
"5" 20.40 65.928 
"6" 21.70 73.675

The expression:

EVALUATE#(3, Telitab1$, Telitab2$, "V", "RTot")

returns (values rounded):



2 "V" "RTot" 
"1" 12.00 32.436 
"2" 14.00 50.119 
"3" 16.00 53.723 
"4" 18.00 57.107 
"5" 20.00 63.990 
"6" 22.00 75.762

Example 4

If Telitab1$="NullString" (and if Telitab2$="NullString" as in this example), you can pass table information in the first InpVar$:Label$ combination, e.g.:

EVALUATE#(3,"NullString", "NullString", "2(1)6":"X", "X^2":"Y")

returns:



2 "X" "Y" 
"1" 2 4 
"2" 3 9 
"3" 4 16 
"4" 5 25 
"5" 6 36

This construction allows you to provide the equidistant range of a table to be normalised as in example 5.

...

If Telitab1$="NullString" and if Telitab2$ contains a table to be normalised:



2 "V" "RTot" 
"1" 12.10 33.663 
"2" 14.30 51.529 
"3" 15.90 53.579 
"4" 18.10 57.369 
"5" 20.40 65.928 
"6" 21.70 73.675

you can pass table information in the first InpVar$:Label$ combination, e.g.:

...

returns (values rounded):



2 "V" "RTot" 
"1" 12 32.436 
"2" 13 43.077 
"3" 14 50.119 
"4" 15 53.031 
"5" 16 53.723 
"6" 17 55.135 
"7" 18 57.107 
"8" 19 60.071 
"9" 20 63.990 
"10" 21 69.242 
"11" 22 75.762

Example 6

If an argument in the EVALUATE# function is between (), its value is used in the evaluation but not included in its resulting TeLiTab set.

...