Forum Discussion
Matrix lookup and summing of components formula help
The mathematical approach for this problem is to use MMULT for the matrix multiplication
= MMULT(TRANSPOSE(compsPerProduct), productQuantity)Sadly the formula is unlikely to appeal to those without a STEM background. There is an alternative using 365 array formulas.
= LET( componentsNeeded, productQuantity * compsPerProduct, neededOverall, BYCOL(componentsNeeded, LAMBDA(x, SUM(x))), TOCOL(neededOverall) )The first line simply multiplies the component table by the number of products required to determine the component count for each product. Next, summing by column gives the overall component counts. The result is a row of counts so the final step converts it to a column. Fortunately the two methods give identical results.
Oops sorry Peter
Beyond the new potent limit darn it n i l p o n t e t darn it and i l p o t e n t there it is
Beyond the limit no summation is necessary because the matrix of resolves to zero at that point
Something all the lower Powers summing all the lower Powers excuse me gives you all the multi-stage requirements for any order vector
What a marvelous tool mathcad
Sorry I don't know how to do this in 365
Mathcad allows import and export of data files but the really fast way to do it for those data files which consist of matrices and especially if the limit is 255 that is all data values are between 0 and 2:55 is to import export a bitmap enough said much faster