Hi Peter - I think a natural way to define a data dictionary in Excel is as an (n x 2)-array consisting of key/value pairs. Given definitions as in the earlier attachment, a data dictionary could be defined pairwise, dic=WRAPROWS(VSTACK("United Kingdom",LAMBDA(Table1),"Germany",...
The Setup The problem is simple. Given a 'cost matrix', assign tasks to workers to minimize total cost needed to complete the tasks. Workers may not perform more than 1 task. Assignment p... Really Interesting Problem!! My approach is similar to yours - generate all the permutations...
This is more common than you might think. In fact, several major programming languages have some kind of release that takes significantly longer than all others: Python 3 took years to arrive, PHP 6 took so long the team bailed out and jumped straight to PHP 7, and Perl 6 dragged on so...
error type, TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, EXPAND Lambda functions : LAMBDA(), BYROW(), BYCOL(), MAKEARRAY(), SCAN(), MAP(), REDUCE(), ISOMITTED() Dynamic arrays Range fill operation Ad...
though the vector representation is the same as fine-grained classification outputs to the multi-class classification outputs, their internal structures of the vectors are different. Labels under the same parent tend to have a closer relationship than the ones under different parents in the la...
Really Interesting Problem!! My approach is similar to yours - generate all the permutations and filter for minimum total. =LET(workers,Workers,tasks,Tasks,matrix,Costs,nWorkers,ROWS(workers),nTasks,COLUMNS(tasks),s,SEQUENCE(,nTasks),div,nWorkers^s,permuta,ROUNDUP((MOD(SEQUENCE(MAX(div...
So given that I have created 3 lambdas in the attached: MinLocations : this is the 'master' lambda that will output the result MinLocations_calcs: this will iteratively go through each possible column order finding all possible min solutions ...
So given that I have created 3 lambdas in the attached: MinLocations : this is the 'master' lambda that will output the result MinLocations_calcs: this will iteratively go through each possible column order finding all possible min solutions ...
So given that I have created 3 lambdas in the attached: MinLocations : this is the 'master' lambda that will output the result MinLocations_calcs: this will iteratively go through each possible column order finding all possible min solutions ...
is the same (per column) then it will blow up to every combination x 6. That said if we assume in most cases there aren't that many repeated values per column then it could have advantages but we have also seen that excel can be very very efficient and quick in created large ...