Adjacency Matrix

The Adjacency Matrix format contains all of your data in multiple Excel sheets. It is so-named because this format emphasizes the presentation of relationships by laying them out in a matrix form.

Group sheets

Tabs in the Adjacency Matrix format are either group sheets, node sheets, or relationship sheets. Group sheets specify that an entity is a group. Node sheets specify that an entity is a node .

The difference between a node vs group sheet is in the way you name the tab:

  • Node sheets must be named as node_[type of entity], e.g. group_Class or group_learning outcome
  • Group sheets must be named as group_[type of entity], e.g. group_Department or group_school

Node sheets

Since nodes are displayed as circles on the map, you can put a variety of attributes as columns, just as you can for the Adjacency List format. For example, you can specify additional info, colors, sizes, etc. Take a look at our styling docs.

Relationship sheets

Relationship sheets A relationship sheet specifies a type of relationship between entities. A relationship sheet looks like a matrix, which is why this format is called the Matrix format! In this matrix format, a matrix is formed by listing entities in the first column and in the first row:

Important!: The values in the rows and columns MUST match the ids of the nodes that you specified in your node sheets.

To say that a relationship between two entities exist, you put a numeric value in the cell, for example, "1", or "3", or “0.3”. This value determines the strength of the relationship. In the above example, an has prequel of relationship points from Episode VI to Episode V with a strength of 1.

The value of the relationship also determines the thickness of the edge on the map. A value of 0.5 will have a thin edge that has a strokeWidth of 0.5. A value of 10 will have a thick edge with a strokeWidth of 10:

Pro tip: Values between 0.5 and 8 look best on the map — lines that look too thin or thick don't look good.

Relationship sheets must be named in these patterns:

  • Directed relationships must be named as rel_d_[name of relationship], e.g. rel_d_requires
  • Undirected relationships must be named as rel_d_[name of relationship], e.g. rel_u_is similar to

Per relationship sheet, you specify one type of relationship. You can create as many types of relationships as you want.