NodeXL ([url removed, login to view]) is an Excel template for doing network analysis. I'm looking to hire someone to build a Macro or Add-in for Excel that will create single-mode projections of two-mode NodeXL networks. For instance, a two-mode network may connection people to organizations. What I need is a macro or add-in that takes that person-organization network and creates a people-people network with an "Edge Width" column that counts how many organizations they are both members of.
The files attached are examples of a two-mode network of Saturday Night Live actors and films/TV shows and a one-mode projection of the same network. I want to automate the process of building that one-mode projection from two-mode data. I've also included a Serious Eats file that shows how to do this manually in Excel. I'd like to have a macro or add-in automate the process.
A standalone app or script that takes the two-mode workbook as input and returns a one-mode workbook would also work, but I'd like to do this all in Excel if possible. I've budgeted for going back and forth about requirements since I had trouble describing the functions in detail.