T1 T2 T3 T4
A 1 0 0 0


Hi. Assume T1 is in Cell A1.
To the right of T4, the function could be:

=Sumproduct({t1,t2,t3,t}, {B1:B4})

Copy this down D2:D5. (Keeping t1...t4 constant)

If I understand the problem, you will also want to add the constraint
that the sum of each Row, and each column, equals 1.

I don't believe you will have any luck with functions "Indirect",
"Lookup", and "Match" because Solver can not track the discontinuity, or
jump, in the functions.

HTH
Dana DeLouis




Zakkk wrote:
i have a table, which I will run solver on. I am telling solver to make
choices and optimize resource usage. After using the binary function, I am
Stuck.

Say i have this Table

T1 T2 T3 T4
A 1 0 0 0
B 0 1 0 0
C 0 0 1 0
D 0 0 0 1

i will need the table to be in the form

Time
A T1
B T2
C T3
D T4

thank you!