A flow problem

[bekirsahin]

Hi,

This is a flow, (transportation, graph, etc.) problem below. Variables and their values are given in Columns A and B. Situations based on Variable 1 and Variable 2 are given at the D,E and F columns. The total flow must not be longer than 10. If so, it means overload and skip that step. All variables should be removed after the sums are reached to 10. At the end of the calculations, get final flows either it reaches satisfaction or not (as shown in the 1001th row).

How to calculate columns G,H,I and J?

Thank you very much

	A	B	C	D	E	F	G	H	I	J
1	Variable	Value		Situations	Fixed Variable 1	Fixed Variable 2	Total (MAX 10)	Flow	Explanation
2	A	3		1	A	C	=3+5	A-C
3	B	4		2	A	D	=3+5+2	A-C-D	Satisfied, remove A,C and D	+
4	C	5		3	K	L	=5+2	K-L
5	D	2		4	L	B	=4+5+2	B-K-L	Overload, skip this step
6	E	1		5	E	A	---	---	A is removed skip this step
7	F	6		6	C	J	---	---	C is removed skip this step
8	G	6		7	H	E	=2+1	E-H
9	H	2		8	K	H	=5+2+2+1	E-H-K-L	Satisfied, remove E,H, K and L	+
10	I	1		9	P	R	...	...	...
11	J	3			...	...	...	...	...
12	K	5			...	...	...	...	...
13	L	2
	...	...
1001				1000	X	W	=1+2	W-X	Satisfied, W and X never removed before	+

<tbody>
</tbody>