Marc Smith gave a (Excel) .NetMap online tutorial at Harvard this morning hosted by David Lazar of the Harvard Kennedy School – Program on Networked Governance. The slides and recording will be available at http://www.hks.harvard.edu/netgov
(Excel) .NetMap is an add-in for Office 2007 that provides social network diagram and analysis tools in the context of a spreadsheet. Adding the directed graph chart type to Excel opens up many possibilities for easily manipulating networks and controlling their display properties.
In this tutorial the steps needed to install and operate (Excel) .NetMap are reviewed. The (Excel) .NetMap add-in provides directed graph charting features within Excel, allowing users to create node-link diagrams with control over each node and edge color, size, transparency and shape. Since .NetMap builds within Excel, all of the controls and programmatic features of Office are available. Additional features of (Excel) .NetMap generate social networks from data sources like personal e-mail (drawing data from the Windows Desktop Search engine). Arbitrary edge lists (anything that can be pasted into Excel) can be visualized and analyzed in .NetMap.
This session will provide a walk through the basic operation of .NetMap. Attendees are encouraged to bring an edge list of interest. Sample data sets will be provided. Techniques for time slicing and filtering networks will be highlighted. You may download the Excel .NetMap Add-in and slides visit in advance of this tutorial.