 SOLVED

# Total Amount divided into Different Sequences using 4 slot only in each sequences

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 slots and each amount must be equal.

I mean is if B2:B21 Slot is fixed, How would I calculate the amount in C2:C21 if it is left blank??

The result amount must be the same in D2:D21.

I already found one thing that:

Sequence 1 = 4,160

Seq 2 = 5,784

Seq 3= 3,763

Seq 4 = 5,270

Seq 5 = 5,981

Total = 24,958 which is exactly 25% of 99,832.

But What if those Sequences amount is empty/blank??

How do I know that is the number to put into each Sequences?? Like how do I know Sequence 1=4160??, etc...

Thanks a lot. 5 Replies
best response confirmed by Yvan_New1976 (Occasional Contributor)
Solution

# Re: 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: # Re: Total Amount divided into Different Sequences using 4 slot only in each sequences

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...

# Re: Total Amount divided into Different Sequences using 4 slot only in each sequences

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.

# Re: Total Amount divided into Different Sequences using 4 slot only in each sequences

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.

# Re: Total Amount divided into Different Sequences using 4 slot only in each sequences

Yeah I've seen that one too..
That is okay.. You have helped me a lot already.

Thanks.