Dec 5, 2014 at 1:04 PM
Edited Dec 5, 2014 at 1:05 PM
Thank you for the interest in NodeXL!
NodeXL can import matrix data. To do so, the matrix must be square.
In your data, that would require that the row and column headers be identical.
This means listing all companies AND organizations in a column and repeating the same order as row headers.
At the intersection of row and column you can enter a value to indicate the presence and strength of the connection.
This data is then imported via the NodeXL>Data>Import>From Open Matrix Workbook function.
An alternative representation of a network, which is prefered by NodeXL, is the Edge List.
In an Edge List there are only TWO vertices per row, Vertex1 and Vertex2.
Whenever a relationship exists between Vertex1 and Vertex2 an edge is written:
To convey more information about the relationship and its participants, the Edge List can be expanded to include other attributes:
Vertex1, Vertex2, Date or connections, Type or nature of connection (Relationship Type), Size or volume of connections (minutes, days, dollars, messages, etc), Attribute2 of Vertex1, Attributes of Vertex2
This data is then imported via the NodeXL>Data>Import>From Open Edge Workbook function.