4b3ec3c6-c3e9-4932-9e67-20afe452a7c5 79 4 5 decimal

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

Data Table Parsing Function - Intelligent VLOOKUP()

]]>

checks for a set of conditions in a format mat(ColumnID,BooleanOperator,2,1)

, and compiles a matrix of rows that pass the check.

]]>

data# conditionsMATRIX# vlookup VLOOKUPcode# :

VLOOKUPcode# © 2016 Alexander Melnik set boolean flag to true data# data# eval : rows# data# rows eval : conditionsNumber# conditionsMATRIX# cols eval : i# 1 rows# range row# data# i# row eval : bool# 1 : For() loop boolean check - matrix of conditions; loop is terminated when bool is 0 i## 1 conditionsNumber# range bool# 0 ≡ break if column# conditionsMATRIX# 1 i## el eval : #C# data# i# column# el eval : Now the boolean expression from the condition matrix can be evaluated operand# conditionsMATRIX# 2 i## el eval : Now our custom boolean check can be evaluated bool# bool# operand# * eval : 71 line for if all boolean checks were passed pull the row into a new matrix bool# resultrng# resultrng# row# stack eval : resultrng# row# eval : try if 61 line for resultrng# 71 line :

Sample data to be searched (stock of fruits in two stores):

]]>

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 :

Sample set of conditions (cost is less than 2 credits, Store 1, and must be in stock):

]]>

conditions 315 #C# 2 credit * ≤ #C# Store 1 ≡ #C# 0 > 23 mat :

supply conditions vlookup Store 1 apple credit stock 1 Store 1 banana 0.75 credit * stock 1 Store 1 peach 1.25 credit * stock 735 mat

Unexpected Behaviour of a Matrix which Contains Custom Boolean Function:

]]>

string# segment# strcont string# string# segment# X strrep ≡ 01 if 11 line :

banana ana strcont 1

conditions 3152 #C# 2 credit * ≤ #C# Store 1 ≡ #C# 0 > #C# ana strcont 24 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 No match if for index 31 line :

idx 1.25 credit * supply 3 lookup : 4821 mat

i 1.25 credit * supply 3 lookup search i el supply i row : for

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

Analyse matrix via truth table

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 :

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

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 : 11 line 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

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