calculate weighted edges

Jul 12, 2015 at 7:37 AM
I would like to know, in a directed graph, how I calculate the resultant of weighted edges that connected to a vertex and then I sort all vertices of the network based on the very index.
note: to calculate, I would like to consider in-degree weighted edges for each vertex.
thanks advance
Jul 12, 2015 at 1:42 PM

Thank you for the interest in NodeXL!

NodeXL can calculate Edge Weights (see: NodeXL>Data>Prepare Data>Count and Merge Duplicate Edges) or use an existing column of numeric data in the Edges worksheet as a weight.

When NodeXL graph metrics are run, NodeXL can calculate in-degree and out-degree and insert these values into the Vertices worksheet.

It sounds like you want a weighted in- or out- degree metric. This could be created with a =SUMIF() formula in the Vertices worksheet.
This formula can add up the weights for every edge that originated (Vertex1) or terminated (Vertex2) with the target vertex.