top of page

SharePoint as a Document Management System - Comparison Matrix Worksheet

Spreadsheet Instructions Edit data only in color coded cells - white cells contain formulas and should be left alone) Note: If you need to add factors or categories, please see the example tab for more instructions

  1. Title your options: replace "Option 1", "Option 2" with your option titles

  2. Title categories for consideration in column A : replace "Category 1", "Category 2" with your category labels

  3. Add factors for decision in each category in column B (for a job, this might be commute, pay, etc.)

  4. Assign weights to categories (column C) so that they add to 100 (see below cat weight column for total). This forces you to understand how important these categories are to you relative to each other

  5. Assign weights to each factor within the categories (column D) so they add to 100 (see above factor weights for total). When assigning weights to factors, concentrate on their relative importance, ignoring factors in other categories

  6. Note: when your weights add up properly, you should have no more red totals visible.

  7. Fill out blue areas with scores from 0-10

  8. Note for negatives, reverse your thinking (so a high score on a negative like Risk means it's NOT risky)

  9.  Note that as you edit scores, the weighted averages are shown as subtotals and absolute totals along the bottom. For "yes/no" factors, use 0 for no, and 10 for yes.

4 views0 comments

Recent Posts

See All

Archetonomy Mega Drop Down Review

The Mega menus concept Now, mega menus are probably well familiar to anyone and everyone by now- it was an up and coming design trend back in the late 2000's. Old hat - but let's review the fundamenta


bottom of page