Importance weighted density (IWD):
A network calculator for Excel

A program for generating network visualizations and calculating importance weighted density (IWD), density, decentralization, and scaled eigenvector centralization


Citing this tool
The development of this calculator and the importance-weighted density statistic is described in:

Lemoine, G.J., Koseoglu, G., Ghahremani, H., & Blum, T.C. (in press). Importance weighted density: A shared leadership illustration of the case for moving beyond density and decentralization in particularistic resource networks. Organizational Research Methods. https://doi.org/10.1177/1094428118792077


Please use that reference when citing the use of this tool.

The University at Buffalo School of Management continuously strives to comply with Web Content Accessibility Guidelines (WCAG) to make this website accessible to visitors with disabilities. If you need help accessing any of this page's content or functionality, contact James Lemoine at 716-645-3236 or via e-mail by clicking here.

Click to download the most recent basic version of the network calculator (v2.4)
Requires no extra installs, but cannot calculate scaled EC

Click to download the most recent full version of the network calculator (v2.3)
Requires Solver install - see below

Click to download the most recent basic version of the network calculator for Macintosh (v2.4)
Requires no extra installs, but cannot calculate scaled EC

Click to download the most recent full version of the network calculator for Macintosh (v2.4)
Requires Solver install - see below


Use of the calculator
The IWD Network Calculator provides the network statistics of importance-weighted density, density, decentralization, and (optionally) scaled eigenvector centralization. Network statistics are recorded in a "ResultList" tab which can be easily imported into SPSS or other statistical software. It also generates visualizations of dichotomous or valued network matrices. Values for IWD, density, and decentralization are available for groups of four to fifteen members in the basic version of the calculator. Network visualizations (in either version) are limited to groups of four to eleven members.

Installation
The IWD Network Calculator is an Excel file driven by macros (programs coded within an Excel spreadsheet). To use the macros, you will first need to enable editing and macros if any security warning messages pop up (usually in the form of yellow bars which appear at the top of Excel). In most cases, you will need to first click "Enable Editing" and then "Enable Content" in the yellow bars to enable the macros.

Beyond the standard network statistics, the full version of this program can also calculate scaled eigenvector centralization (scaled EC) for groups of 4 to 7 members. The full version of this program requires Microsoft Solver, a free add-in for Excel. Calculating scaled EC is optional, so if you do not need scaled EC, there is no need to install Solver and you should instead use the basic version of the network calculator.

Solver can be downloaded (free of charge) at the following links:
  Solver installation instructions for Excel 2016
  Solver installation instructions for Excel 2007-2013

Instructions for use
Detailed instructions for the use of the IWD Network Calculator can be found on the "Detailed Instructions" tab of the Excel file.

In short,
1. Enter the number of members in the current matrix (network or team size) in Cell E2. The allowed group size goes up to eleven. You can type the number, or select from the drop-down box.

2. Enter the scale maximum and minimum (that is, the highest and lowest possible values) in Cells I1 and I2. For dichotomous ties, for instance, the maximum would be one and the minimum would be zero.

3. If desired, type the group member names or identifiers in Cells B5-B19. This is optional, and only used to populate the node graphics in the network visualization. You can also optionally enter a group identifier in cell E1, which will be included in the final exportable data tab.

4. Place the matrix information of directional ties in Cells C5-Q19.
  For groups of fewer than 15 members, place the matrix in the first (top- and left-most) rows and columns.
  Extra rows and columns can be ignored and will not be used for calculations.

5. If you are using the full version of the calculator, you can select the option for scaled eigenvector centrality if desired, and then press the "Calculate" button, the matrix button that is added to the Quick Access Toolbar (at the upper left of the Excel window) or Control+W on your keyboard, to generate the results. (Mac users must press Control+W, as these extra buttons will not appear on a Mac.)

You should only enter information into cells highlighted in yellow. Altering text in other cells may disrupt the programming in the file.

You can contact James Lemoine with any questions about the calculator's use.