<p>Hidden Calculations/Functions</p>

7dc9c186-35cf-4170-a015-e562cf009bbd 58 4 5 decimal

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

INPUT TABLE FROM EXCEL

The sheet currently doesn't work with this matrix at all. I want to be able to use each set(row) of inputs from this matrix without converting the entire sheet into a function

MyArrXL inputs.xlsx Sheet1 A3 B11 importData.XLSX :

<p>Hidden Calculations/Functions</p>

i 1 MyArrXL rows range MyArrXL i 1 el strtoupper W ≡ NewValueCol1 i 1 el 1 : NewValueCol1 i 2 el 2 : NewValueCol1 i 3 el 3 : 31 line MyArrXL i 1 el strtoupper S ≡ NewValueCol1 i 1 el 7 : NewValueCol1 i 2 el 8 : NewValueCol1 i 3 el 9 : 31 line NewValueCol1 i 1 el 4 : NewValueCol1 i 2 el 5 : NewValueCol1 i 3 el 6 : 31 line if if for

i 1 MyArrXL rows range MyArrXL i 2 el strtoupper B ≡ NewValueCol2 i 1 el 3 : 11 line MyArrXL i 2 el strtoupper D ≡ NewValueCol2 i 1 el 6 : 11 line NewValueCol2 i 1 el 9 : 11 line if if for

i 1 NewValueCol1 rows range k 1 NewValueCol1 cols range NewValueCol1 i k el NewValueCol2 i 1 el > outputdata i k el FAIL : NewValueCol1 i k el NewValueCol2 i 1 el ≡ outputdata i k el EQUAL : outputdata i k el OK : if if for for

DISPLAY VALUES

NewValueCol1 12312312378978978945645645693 mat

NewValueCol2 36936936991 mat

OUTPUTS FOUND HERE

outputdata OK OK EQUAL OK OK OK OK OK OK FAIL FAIL FAIL FAIL FAIL FAIL OK OK EQUAL FAIL FAIL FAIL OK OK EQUAL OK OK OK 93 mat

outputdata output.xlsx exportData.XLSX 1