Bloc ... Col ... Row ... Collect ... Decimate

9d0dae08-413c-4b4c-8108-59e95fe980cc 24 3 5 decimal

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

data u v BlocUser ct 1 : i v a 1 ct el data i col : ct ct 1 + : 21 line for V a 1 el : j 2 a cols range V V a j el augment : for ct 1 : i u b 1 ct el V i row : ct ct 1 + : 21 line for U b 1 el : j 2 b cols range U U b j el stack : for U transpose 91 line :

data list Collect collects index list ct 1 : i list a ct el data i 1 el : b ct el data i 2 el : ct ct 1 + : 31 line for a b augment 41 line :

data Lo n Hi Decimate every 'n' pairs range Lo Hi Lo n + (range : k 1 : i range u k el data i 1 el : v k el data i 2 el : k k 1 + : 31 line for u v augment 31 line 31 line :

The col/row extractors utilities

add/remove/insert/shuffle
in col(,,,) argument ... at will in-situ data v Col ct 1 : i v a 1 ct el data i col : ct ct 1 + : 21 line for a V a 1 el : j 2 a cols range V V a j el augment : for V 61 line :

add/remove/insert/shuffle
in row(,,,) argument ... at will in-situ data v Row ct 1 : i v a 1 ct el data i row : ct ct 1 + : 21 line for a V a 1 el : j 2 a cols range V V a j el stack : for V 61 line :

lookup wrt value in col 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 :

Symmetric/asymmetric "pivot" pivot n m S U 0 : V 0 : 12 mat i 0 m range U i el i : for j 1 n range V j 1 + el j - : for V reverse U stack pivot + 41 line :

1. Matrix extractors

M 05204580125520458012518020458012518024545801251802453208012518024532040512518024532040550066 mat :

col 13513 mat :

row 43213 mat :

New M col row BlocUser :

New 45125245208018054512533 mat

M col Col 020805451252080180451252458018032012524540563 mat

M row Row 4580125180245320204580125180245520458012518036 mat

NEW M col Col row Row :

NEW 45125245208018054512533 mat

New 45125245208018054512533 mat

2. Data set analyzer

=================================

data set XY

Air 0.5 - 1.0489 01 0.5 0.9529 1 0.9075 1.5 0.8638 2 0.8217 2.5 0.7812 3 0.7422 3.5 0.7048 4 0.6689 4.5 0.6343 5 0.6012 5.5 0.5694 6 0.5389 6.5 0.5096 7 0.4816 7.5 0.4548 8 0.4292 8.5 0.4047 9 0.3813 9.5 0.3589 10 0.3376 10.5 0.3172 11 0.2978 11.5 0.2755 12 0.2546 12.5 0.2354 13 0.2176 13.5 0.2012 14 0.186 14.5 0.172 15 0.159 15.5 0.147 16 0.1359 16.5 0.1256 17 0.1162 17.5 0.1074 18 0.0993 18.5 0.0918 19 0.0849 19.5 0.0785 20 0.0726 25 0.032 30 0.015 32 0.011 35 0.006705 40 0.003144 45 0.001536 47 0.001165 50 0.000798 52 0.00062 55 0.000432 60 0.000233 61 0.000205 71 0.00005242 85 0.00000568 562 mat :

list 156 range : ρho Air list Collect : 21 line

Air rows 56

ISA 24 :

ρho ISA row 11 0.298 12 mat

km ρho ISA row 11 el : ρ ρho ISA row 12 el : 21 line

ρho km ρ + 15 red 1 5 mat 2 1 sys

list 12357916 mat : ρho Air list Collect : myAir Air 2224 Decimate : myAir km ρ 12 mat myAir stack : ρho km ρ 12 mat ρho stack : 51 sys

myAir km ρ 011 0.908 2 0.822 3 0.742 4 0.669 5 0.601 6 0.539 7 0.482 8 0.429 9 0.381 10 0.338 11 0.298 132 mat

km ρ 12 mat 11 0.298 12 mat

ρho km ρ 0.5 - 1.049 01 0.5 0.953 1.5 0.864 2.5 0.781 3.5 0.705 72 mat

3. Pivot extractor/analyzer

=================================

vy 9.206 9.3 9.278 9.175 9.275 9.289 9.287 9.261 9.303 9.276 9.273 9.288 9.256 9.252 9.298 9.267 161 mat :

pivot 10 : n 5 : m 5 : 13 mat

local assign jdx pivot n m S 11 line :

p vy jdx el : Pivot jdx vectorize p augment : Deviation jdx vectorize p Pivot pivot m 1 - (- row 12 el - augment : 31 sys

Deviation pivot 1 pivot 1 - 2 2 mat 2 1 sys

Pivot Deviation 12 mat 5 9.275 6 9.289 7 9.287 8 9.261 9 9.303 10 9.276 11 9.273 12 9.288 13 9.256 14 9.252 15 9.298 112 mat 5 0.001 - 6 0.013 7 0.011 8 0.015 - 9 0.027 10011 0.003 - 12 0.012 13 0.02 - 14 0.024 - 15 0.022 112 mat 12 mat

4. Grocery stock manager

=================================

supply Store 1 apple 1.0 credit * stock 1 Store 1 banana 0.75 credit * stock 1 Store 1 orange 1.75 credit * stock 0 Store 1 peach 1.25 credit * stock 7 Store 1 grape 2.5 credit * stock 4 Store 2 apple 0.5 credit * stock 0 Store 2 banana 1.5 credit * stock 3 Store 2 orange 1.25 credit * stock 100 Store 2 peach 1.5 credit * stock 24 Store 2 grape 0.5 credit * stock 0105 mat :

4 appVersion 0.98.6179.21440

not a bug but bug anyway ! supply 1 row Store 1 apple credit stock 115 mat

idx 1.25 credit * supply 3 lookup : 4821 mat

count 1 : i idx search count el supply i row : count count 1 + : 21 line for 21 line

search Store 1 peach 1.25 credit * stock 715 mat Store 2 orange 1.25 credit * stock 10015 mat 21 mat

s 1 supply rows range : x y in x y ≡ vectorize max : 21 line

delrow 13531 mat :

x y INCLUDE j 1 : t x w j el t : j j 1 + : 21 line t y in 0 ≡ Exclude cases for w 31 line :

1. vector filtered data
2. filtered supply
3. length of 'filtered' vr s delrow INCLUDE : Grocery supply vr 1 supply cols range el : k 1 Grocery rows range : 31 sys

Grocery Store 1 banana 0.75 credit * stock 1 Store 1 peach 1.25 credit * stock 7 Store 2 apple 0.5 credit * stock 0 Store 2 banana 1.5 credit * stock 3 Store 2 orange 1.25 credit * stock 100 Store 2 peach 1.5 credit * stock 24 Store 2 grape 0.5 credit * stock 075 mat

5. Truth table analyzer

=================================

W 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 :

5346 ... truth table 'M' within [a, b] M a b Truth count 0 : i 1 M rows range j 1 M cols range M i j el a ≥ (M i j el b ≤ (* Z i j el M i j el : count count 1 + : if for for Z 41 line :

W 24 Truth 00000 2.36 0 3.07 00 3.78 0 3.64 0000 3.71 0 3.16 54 mat

x c x 2 ≥ (x 4 ≤ (* :

Vectorise operator 6179 W c W * vectorize 00000 2.36 0 3.07 00 3.78 0 3.64 0000 3.71 0 3.16 54 mat

6. Array1/Array2 analyzer

=================================

data, want

want 0.4679 0.4542 0.4645 0.4520 0.4654 0.4524 0.4618 0.4503 0.4921 0.4799 0.4744 0.4622 0.4918 0.4799 0.4749 0.4626 0.4381 0.4251 0.4514 0.4400 0.4374 0.4258 0.4515 0.4416 0.4215 0.4121 0.4009 0.3925 0.4136 0.4048 0.3934 0.3861 0.4571 0.4443 0.4552 0.4419 0.4600 0.4483 0.4577 0.4457 0.4008 0.3903 0.3857 0.3753 0.4023 0.3903 0.3856 0.3739 0.4231 0.4093 0.4253 0.4132 0.4213 0.4077 0.4222 0.4103 78 mat :

data 0.4195 0.4099 0.4078 0.4001 0.4247 0.4163 0.4134 0.4074 0.5001 0.4884 0.4893 0.4777 0.5008 0.4910 0.4910 0.4818 0.4945 0.4802 0.4789 0.4659 0.4862 0.4723 0.4719 0.4585 0.4837 0.4692 0.4756 0.4615 0.4862 0.4729 0.4786 0.4662 0.4874 0.4786 0.4788 0.4699 0.4853 0.4765 0.4770 0.4682 0.4543 0.4443 0.4393 0.4309 0.4573 0.4486 0.4420 0.4357 0.4918 0.4798 0.4884 0.4769 0.4915 0.4800 0.4878 0.4768 0.4724 0.4167 0.4160 0.4050 0.4269 0.4171 0.4143 0.4047 0.4302 0.4125 0.4167 0.4000 0.4319 0.4132 0.4190 0.4015 0.4975 0.4861 0.5002 0.4875 0.4952 0.4851 0.4974 0.4864 0.4668 0.4525 0.4430 0.4299 0.4630 0.4495 0.4387 0.4264 0.4713 0.4563 0.4606 0.4462 0.4620 0.4464 0.4542 0.4381 0.4545 0.4433 0.4437 0.4332 0.4565 0.4467 0.4482 0.4392 0.5027 0.4848 0.5039 0.4855 0.5014 0.4839 0.5014 0.4834 0.5015 0.4863 0.4870 0.4728 0.4996 0.4834 0.4859 0.4719 0.4660 0.4569 0.4330 0.4246 0.4548 0.4464 0.4222 0.4126 0.4719 0.4592 0.4700 0.4598 0.4710 0.4588 0.4679 0.4584 0.4056 0.3927 0.3919 0.3833 0.4063 0.3914 0.3922 0.3820 0.4710 0.4584 0.4472 0.4361 0.4731 0.4611 0.4505 0.4406 0.5280 0.5138 0.5137 0.5008 0.5261 0.5121 0.5108 0.4983 0.5040 0.4946 0.5162 0.5072 0.5008 0.4929 0.5127 0.5056 0.3934 0.3872 0.3707 0.3654 0.3910 0.3817 0.3695 0.3611 0.4209 0.4076 0.4062 0.3945 0.4226 0.4104 0.4069 0.3965 0.4824 0.4718 0.4783 0.4683 0.4794 0.4681 0.4757 0.4663 0.4970 0.4869 0.4954 0.4855 0.5015 0.4905 0.5004 0.4901 258 mat :

Array1 Array2 Locate 1. Unwrap an array in vector V Array2 1 col : i 2 Array2 cols range V V Array2 i col stack : for V 31 line 2. locate matching occurences i 1 : L 0 : k 1 V rows range row 1 Array1 rows range col 1 Array1 cols range Array1 row col el V k el ≡ (1 ≡ L i 1 el row col 21 mat : i i 1 + : 21 line NO math occurences if for for for L 71 line :

Index data want Locate :

Index 17721 mat 12821 mat 12721 mat 6221 mat 9621 mat 7121 mat 22121 mat 16721 mat 81 mat

1. scan => coincidences data <=> want
2. Index => located in 'data' j 1 Index rows range stamp j el Index j el : scan j el data stamp j el 1 el stamp j el 2 el el : 21 line for

rows to be zapped in Array2
wrt "want" [Array1] j 1 Index rows range zap j el Index j el 1 el : for

zap scan augment 17 0.468 12 0.438 12 0.454 6 0.444 9 0.413 7 0.492 22 0.393 16 0.422 82 mat

data idx markWant mark 1 : i 1 idx rows range data idx i el (1 el idx i el (2 el el mark : for data 31 line :

plot to see elements marked '1' MARK data Index markWant :

======================================================================================

Strip repeated in vector zap Strip zap zap sort : k 0 : i 1 zap rows 1 - (range zap i 1 + el zap i el - 0 ≠ R k k 1 + : el zap i el : 11 line if 11 line for R zap zap rows el stack 41 line :

Next objective is to delete rows marked '1' in data. We sort the "zap" vector, then strip from repeated rows indices.

delrow zap Strip :

indices of rows to 
be deleted in data delrow 6791216172271 mat

s 1 data rows range : x y in x y ≡ vectorize max : 21 line

x y INCLUDE j 1 : t x w j el t : j j 1 + : 21 line t y in 0 ≡ Exclude cases for w 31 line :

1. vector filtered data
2. filtered data  'want'
3. length of 'filtered' vr s delrow INCLUDE : Medic data vr 18 range el : k 1 Medic rows range : 31 sys

Medic Medic :

col 4 :

Medicdata_1 k Medic 1 col augment : col Medicdata k Medic col col augment : 21 line

At this point, return the work sheet in "Autocalc" for quick 'col' inspect. Plot 'Medic', observe data is stripped of the rows 'mark 1'.

Medicdata_1 col Medicdata 2 1 sys