How do I restructure my adjacency matrix?
The second tool is a custom Google Sheets formula called
KUMU_CONNECTION_LISTthat will convert any adjacency matrix into a connection list, which can then be imported into Kumu.
Delete all the example tabs in your spreadsheet, then create a new tab, and put your matrix in that tab. Be sure to add
(ignore)to the tab name to make sure Kumu doesn't try to import it. Next, add a new tab, and type
A1to get started.
KUMU_CONNECTION_LIST(A1:J10, TRUE, TRUE, TRUE, TRUE, TRUE)
KUMU_CONNECTION_LIST(matrix, is_directed, include_duplicate_connections, include_self_connections, include_zero_strength_connections, include_blank_strength_connections)
KUMU_CONNECTION_LISTreturns the full connection list, which will span across multiple columns and rows.
KUMU_CONNECTION_LISTformula will store your connection strengths in a column titled "Strength", and "Strength" will become a field name in Kumu. If you want to use a field name other than "Strength" you can follow these steps to change the column header in Kumu:
(ignore)to the tab that contains your new connection list, and add a new tab
- 2.In cell
A2of the new tab, copy/paste the following formula:
=ARRAYFORMULA('My other tab (ignore)'!A2:C)
My other tab (ignore)with the actual name of the tab where your connection list is. 3. Enter
Toas the column headers in cells
B14. Enter your custom Strength column header in cell