<p> Locate, Strip </p>

8336c3ab-768c-4975-9e8c-cb53f296e000 21 15 12 decimal

&[DATE] &[TIME] - &[FILENAME]

u 0.5 0.3 0.2 0.3 0.1 0.3 0.4 0.2 81 mat :

value table col lookup k 1 : j k table rows range table j col el value ≡ index k el j : k k 1 + : 21 line continue if for k 1 ≡ index NO match : index if 31 line :

0.3 u 1 lookup 24631 mat

j 1 u rows range match j el u j el u sort 1 lookup : for j 1 u rows range Rankdemo j el match j el Mean : for 21 line

u match j 1 u rows range match j el u j el u sort 1 lookup : for match 21 line :

u Rank j 1 u rows range Rankdemo j el u match j el Mean : for Rankdemo 21 line :

u match transpose 811 mat 45613 mat 2312 mat 45613 mat 111 mat 45613 mat 711 mat 2312 mat 18 mat

Mathcad sanity
1. match [nests]
2. Rankdemo[u] u Rank transpose 85 2.5 5157 2.5 18 mat

... Rank(V) Given a set of data values, the rank of each value is the position at which that value appears in a sorted list of the data. When values repeat, the rank is an average of the indices where the value occurs after sorting ... Returns the averaged position at which each value in 'v' in a sorted list of the data

M 12345648933 mat :

h 611526672316357553377120 mat transpose :

4 M 1 lookup 2321 mat

6 h 1 lookup 1561141 mat

13 h 1 lookup NO match

Locating the first occurrence of a specific element in a vector

w v 1400 range : i 1 v rows range vy i el 1000 v i el cos * Ceil eval : for vy 31 line :

check if occurrence is unique

w Max w Min 21 mat 1000999 - 21 mat

400 w 1 lookup 39711 mat

v x search j 0 : i 1 v length range j j 1 + : v i el x ≡ vv v i el : break 21 line vv NO match : if 21 line for j vv 21 mat 31 line :

w 400 search 39740021 mat

w 397 row 40011 mat

w 700 search 15070021 mat

w 150 row 70011 mat

w 145 - search 8145 - 21 mat

w 8 row 145 - 11 mat

w 400 - search 400 NO match 21 mat

M 105 Random :

M key FindIndex r M rows : c M cols : 12 mat i 1 : j 1 : 12 mat j c ≤ (M i j el key ≠ (* i r < i i 1 + : i 1 : j j 1 + : 21 line if while j c ≤ i j 21 mat 0 if 41 line :

row
col M M Max FindIndex 8421 mat

M 0.162 0.649 0.57 0.216 0.522 0.787 0.009 0.429 0.136 0.26 0.17 0.787 0.101 0.231 0.548 0.087 0.411 0.86 0.18 0.53 0.466 0.073 0.371 0.586 0.671 0.424 0.765 0.726 0.482 0.903 0.397 0.438 0.32 0.065 0.092 0.06 0.759 0.379 0.94 0.658 0.779 0.172 0.049 0.844 0.781 0.112 0.386 0.828 0.424 0.112 105 mat

M M 3 col Max FindIndex 4321 mat

Locate nearest

data 1 3.1 200.77 194.67 2 3.2 190.05 179.43 3 3.3 180.2 165.73 4 3.4 171.15 153.33 5 3.5 162.83 142.06 6 3.6 155.15 131.79 7 3.7 148.05 122.42 8 3.8 141.47 113.84 9 3.9 135.37 105.96 104 129.69 98.73 11 4.1 124.39 92.06 114 mat :

Scan down for nearest lower ... positive domain V threshold FindIdx j 1 : V j el abs threshold ≥ j j 1 + : while j 1 - V j el 21 mat 31 line :

V data 3 col :

idx V 145 FindIdx : 7 141.47 21 mat

w x 02 π * (2 π * 100 / range : i 1 x rows range vy i el 1 x i el cos * eval : for x vy 5 round vectorize augment 31 line :

XY w 2 col 0.6875 FindIdx : 13 0.68455 21 mat

X w XY 1 el 1 el :

w X XY 2 el + 20 red 1 5 mat 2 1 sys

sqrt x 02 π * (0.1 range : i 1 x rows range vy i el 1 x i el sqrt * eval : for x vy 5 round vectorize augment 31 line :

u m n FindProject Courtesy LORENZO 2016/01/22 temp u transpose : temp1 temp n 1 findrows : temp2 u 1 col temp1 transpose augment : temp3 temp2 m 1 findrows : temp3 2 el 61 line :

rref 100 5.667 010 1.667 - 001 3.667 - 34 mat :

Example project collector M c d e f g h a rref 63612313 mat 4 b w 312313 mat 85 sqrt 37 mat :

y a :

x g :

M y x FindProject 12313 mat

y b :

x c :

cell M y x FindProject :

cell

y b :

x h :

cell M y x FindProject :

cell

y a :

x c :

cell M y x FindProject :

cell 100 5.667 010 1.667 - 001 3.667 - 34 mat

<p> Locate, Strip </p>

data Strip3 nest striped in 'R' u data 1 col : v data 2 col : z data 3 col : k 0 : i 1 data rows range u i el v i el * z i el * 0 ≠ R k k 1 + : el u i el v i el z i el 13 mat : 11 line Undefined if 11 line for 21 line Un-nest R v R 1 el : j 2 R rows range v v R j el stack : for v 91 line :

M V Locate Locate exclusive count 1 : i 1 M rows range j 1 M cols range M i j el V i el - 0 ≡ T i 1 el i : T i 2 el j : T i 3 el M i j el : 31 line count count 1 + : if for for T 41 line :

Locate specific values in data table

The search is exclusive of non existing values. The proposal is left in two modules for the strip to be applied in other user instance.

Q 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

v 5.13 4.74 9.93 9.73 3.16 51 mat :

JoBlo Q v Locate Strip3 :

JoBlo 23 4.74 44 9.73 54 3.16 33 mat

Q rank 4

JoBlo rank 3

The un-stripped
for user fill-in Q v Locate 00023 4.74 00044 9.73 54 3.16 53 mat