Excel macro or add-in for creating network projection
This project was awarded to himanshuhc for $280 USD.Get free quotes for a project like this
Project Budget$250 - $750 USD
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online