Installation and SetupInstallation - Each User Installation - Multi-user Language Translations Personalize Your Templates
Systems2win TrainingQuick Start Initial Training New User Training Training Matrix Private Training Systems2win Leadership
Lean TrainingLean Principles Muda 8 Wastes Goal - Lean Flow Roadmap - Lean Journey Value Stream Mapping Standard Work Hansei Lean Thinking Lean Dictionary Online Lean Training Lean Leadership
CustomersOperational Excellence Lean Manufacturing Lean Office and Service Lean Healthcare Customer List
Forced choice paired comparison values ranking worksheet
When to use your
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...
How to use your
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 > 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 doing
to make forced choice paired comparison values rankings
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.
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.
Video: Decision Making Tools
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.
Advanced Training for your
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 described in the best-selling book What Color Is Your Parachute?
Download your free trial template and use it to prioritize what YOU value most
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.
with many other useful Continuous Improvement Leadership Tools
to empower every team member
Download Free Trial
Download a dozen trial templates
including this Forced Choice Paired Comparison Values List template
New User Training
Your Systems2win templates come with free New User Training
to quickly learn features that are common to all 150+ templates