Forced choice paired comparison values ranking worksheet
When to use your
Values List worksheet
- When subjective personal preferences are more important than objective facts
Personal examples: Choosing a career, choosing a college, choosing a spouse...
Corporate examples: Creating a list of shared values for your Strategic Plan or Mission Statement,
determining what your customers want most and like best about your offerings...
- To prioritize or reduce a long list of potential evaluation criteria
How to use your
Values Ranking worksheet
Find and open your template
Find and open your
Values List template
in the same way that you find and open
your other 150+ Systems2win templates.
If you don't yet own a license,
you can download your free trial now.
Save your working document
following the usual document storage and naming conventions established by your leaders
Open a Blank Sheet
When you're ready to start doing your own real work...
click the button to 'Open a Blank Sheet'
Excel Ribbon bar > Systems2win tab > Open a Blank Sheet
This blank sheet is where you will do your real work
(not on the Sample sheet)
Rename your new sheet.
If English is not your preferred language
Switch to your language, just like every Systems2win Excel template.
Now you are ready to start using your
Values List template
Define the decision that needs to be made
Succinctly summarize the problem in the Title near the top of the page.
Ensure that everyone understands and agrees upon what is to be decided.
Define Operational Definitions if needed.
Using your Operational Definitions template. (Op_Def.xlsx)
List your unprioritized options — in no particular order
Perhaps use brainstorming to generate robust options.
Video: Decision Making Tools
If you come up with more than 24 choices,
either combine or eliminate some choices using List Reduction methods
If you need more choices – see Advanced Training for how to expand the list.
Rate each paired comparison
For each pairing of items on your list, ask
"If you could have one of these, but not the other,
which is more important?"
Enter the ID number for your preferred choice.
Notice that almost everything in section 2 auto-populated when you completed section 1.
The only data that you enter is your forced choice paired comparison values.
The Prioritized List (in the bottom section) will auto-populate as you complete the other sections.
Do not edit anything in that bottom section.
Sample Values List Worksheet example
Download free trial
The Prioritized List section is instantly updated and re-prioritized every time that you make any change...
Do not edit anything in the section containing the Prioritized List.
If there is a two-way tie for the #1 ranking —
then the option chosen over the other gets the #1 rank.
If there are more than 2 options tied for the #1 ranking –
then the tied items are highlighted in red
(as illustrated in the picture above)
Like every Systems2win template...
you can easily personalize it, switch between language translations, get pop-up help by clicking any header, watch training videos, and get free technical support...
You know... things you can't do with home-made templates.
Notice the Print Area buttons...
in the Excel Ribbon > Systems2win menu
You can click different buttons to print the different sections of the worksheet –
in your choice of Portrait or Landscape .
Bookmark = advanced
Advanced Training for your
Values List template
How to expand the list
If you need more options - you must do ALL of the following to expand the list:
In each of the 3 sections - you must have the same number of rows of options.
Copy Similar Rows or Columns
Do NOT simply insert rows or columns.
You must instead copy similar rows or columns, using Insert Copied Cells.
In the grey column just to the left of the Prioritized List,
edit the numbers so that the numbering sequence continues correctly in your newly copied rows.
The comparison table must have the same number of columns as rows,
and your inserted columns must be to the left of the thin gold line that defines the boundary of the table.
The ID numbers for both rows and columns must continue the sequence.
Re-protect your sheet as soon as possible,
so that you don't accidentally damage formulas
Options for a Group Decision
1) Agree on comparison choices as you complete the worksheet together as a group, or...
2) Have each individual complete their own workbook
and then combine the scores in a shared workbook.
Use it to plan your life
Use your Values Prioritization template
to complete the life and career planning exercise
and use it to prioritize what YOU value most
More Decision Making Tools and Methods
Also see the other decision making tools
that come with your Systems2win templates
so that you can choose the right decision making tool
for the type of decision you are making – now.
This Values Ranking Worksheet comes with
priced low enough to empower every team member