Forum Discussion
Total Amount divided into Different Sequences using 4 slot only in each sequences
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:
Hello Hans, I hope you are doing fine..
I have tried to use a 9x6 matrix equation, but it is not working.
Can you tell me if this is not possible?? and Should it be a 9x9 matrix equation to removed the error??
Thanks Hans.
You don't have 9 variables x1...x9, but only 6: the amounts for each of the 6 sequences. But with 9 slots, you now have 9 equations for those 6 variables. There is no feasible solution.
I tried to find a solution using the Solver add-in, but it couldn't find one.
- Yeah I've seen that one too..
That is okay.. You have helped me a lot already.
Thanks.