User Profile
Bhavya250203
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Solving 'The Assignment Problem' with Lambda
Patrick2788 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)) - 1, div) + 1) / (div / nWorkers), ), permut, FILTER( permuta, BYROW(permuta, LAMBDA(x, COLUMNS(UNIQUE(x, 1)))) = nTasks ), mat, INDEX(matrix, permut, s), Ttl, BYROW(mat, LAMBDA(x, SUM(x))), arr, FILTER(permut, Ttl = MIN(Ttl)), REDUCE( tasks, SEQUENCE(ROWS(arr)), LAMBDA(a, b, VSTACK( a, LET( k, CHOOSEROWS(arr, b), VSTACK(INDEX(workers, k), INDEX(matrix, k, s)) ) ) ) ) )4KViews3likes3CommentsConvert Number to Words LAMBDA (Very Large Numbers)
I created this LAMBDA Function "Number_To_Words" in order to convert Numbers to Words (eg. 2813 can be written as Two Thousand Eight Hundred Thirteen in words) First Parameter of the function is Number and second is Optional (By default Indian No. System, 2 for International No. System, 1 for Indian) It can convert up to 100 Trillion (International Number System) and Lakhs of Crores (Indian Number System). Avoided conversion after decimal for now but that can be implemented as well. If Number has decimal, function will Round it first and then give results. YT Video Link - https://www.youtube.com/watch?v=u1gzAcwmlpo Gist (GitHub) Link - https://gist.github.com/Bhavya2502/8413a0e6af783ad18e72419eca47ad09 What are your thoughts on this ? PeterBartholomew1 SergeiBaklan6.1KViews1like14CommentsRe: Convert Number to Words LAMBDA (Very Large Numbers)
SergeiBaklan My goal was actually two fold for both Indian as well as International Number System. Both are very different in terms of place value of numbers. I first made for Indian and then adapted as per International System (With few addons, Some steps and Lookup Tables were common).5.7KViews0likes6Comments
Recent Blog Articles
No content to show