Excel macro or add-in for creating network projection

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:
NodeXL (http://nodexl.codeplex.com) 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.

Skills required:
C# Programming, Excel
Additional Files: making-laughs-onemode-nodexl.xlsm making-laughs-twomode-nodexl.xlsm SeriousEats_Affiliation_Matrix_Example.xlsx
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.