Forum Discussion
Solved
Total Amount divided into Different Sequences using 4 slot only in each sequences
Please help on how this was done. There were 5 different Slots with given amounts on the right (F2:G6), and it was distributed in 5 sequences as shown below. In each sequences I can only use 4 sl...
It's a mathematical matrix problem. Let's denote the amounts for sequence 1 to 5 by x1 to x5.
We have to solve the following linear equations:
We can write this as a matrix equation:
The solution is found by multiplying the inverse of the left-hand matrix with the right-hand one:
It's a mathematical matrix problem. Let's denote the amounts for sequence 1 to 5 by x1 to x5.
We have to solve the following linear equations:
We can write this as a matrix equation:
The solution is found by multiplying the inverse of the left-hand matrix with the right-hand one:
Well First, Thank you very much. You are a lifesaver, the problem was Solved.
I need to study this Matrix equation though coz I don't have a clue how it actually works lol..
Thanks again, I feel a lot better now lols...
I need to study this Matrix equation though coz I don't have a clue how it actually works lol..
Thanks again, I feel a lot better now lols...