0

hi ,
i have a table which have values like this :

S11 S2 S9 S20
S11 0 0 2 0
S2 0 0 0 2
S9 2 0 0 2
S20 0 2 2 0

i want to compare columns and rows and assign color to S11,S2 , S9 and S20 and group it using graph coloring method. the value 0 means both 2 S are connected and if 2 its not connected. If the value is 0 the color between those to S must be different and if 2 can be same color but have to make sure the color not had been assigned to other S which are already connected to itself. in this example the Ss will be assigned with 2 colors which means 2 groups. S11 - red, S2 -red, S9 - blue and S20- blue. S2 and S20 not connected so it can be in same color. and same goes to S11 and S9. the final output should be in a table like this:

Column 1(red) Column 2(blue)
S11 S2
S9 S20

it has to be implemented in vb code. anyone please help me for the solution.
thanks.

Edited by begin1: n/a

3
Contributors
4
Replies
5
Views
6 Years
Discussion Span
Last Post by twiss
0

Try yourself, first, at least. Get the records, process them, and do another query to insert the result.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.