This macro generates XY coordinates for plotting a network graph, given inputs of nodes and edges. It uses a force-directed layout algorithm to arrange nodes in the ideal positions. Requires Predictive tools to be installed.
NODE INPUT:
- One required field - a unique list of all nodes.
- The field must be named "nodes".
EDGE INPUT:
- Three required fields - the origin node of the connection.
- the destination node of the connection.
- the 'weight' of the connection
- The fields must be named 'from', 'to', and 'weight'.
-Every unique combination of nodes should be included once in this input.