Closed

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
Employer working
Awarded to:
Skills Required
Project Budget
$250-$750 USD
Total Bids
6
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online