1

what I'm trying to achieve is the following. I have a production chain, say for example:

A and B are used to make C
C and D are used to make E
and E is used to make F

And I wanna know the direct and indirect inputs of F, which would be all the others. The restriction is I can use only worksheet functions, no VBA or user defined functions.

So I built a Matrix of the direct inputs like the following. 1 means the letter in this column is a direct input for the letter of this row

  A  B  C  D  E  F
A 0  0  0  0  0  0
B 0  0  0  0  0  0
C 1  1  0  0  0  0
D 0  0  0  0  0  0
E 0  0  1  1  0  0
F 0  0  0  0  1  0

And I want to transform this matrix (perharps via matrices multiplication) in a matrix that contains all the inputs, both direct and indirect and the answer would be:

  A  B  C  D  E  F
A 0  0  0  0  0  0
B 0  0  0  0  0  0
C 1  1  0  0  0  0
D 0  0  0  0  0  0
E 1  1  1  1  0  0
F 1  1  1  1  1  0

Any thoughts on it ? any other approach is also valid, other than the matricial one. thanks !

2

0

You must log in to answer this question.

Browse other questions tagged .