Home — Continuous Improvement Tools
Process Improvement Tools.
Standard Work.
Work Instructions.
Flow Chart templates.
Swim Lane Cross Functional Flowchart.
Value Stream Mapping.
Lean tools.
Yamazumi Chart template.
Time Study templates.
DMAIC tools.
Quality Improvement tools.
House of Quality QFD.
FMEA Risk Reduction.
Root Cause Analysis tools.
Problem Solving tools.
OEE.
Preventive Maintenance.
Skip to main content
Installation and Setup
Installation - Each User. Installation - Multi-user. Language Translations. Personalize Your Templates.Systems2win Training.
Quick Start Initial Training. New User Training. Training Matrix. Systems2win Leadership. Training Classes.Lean Training
Lean Training and Coaching. Lean 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.Microsoft Office Training
Excel Training. Excel Drawings (without Visio). Excel Charts. Word Training. PDF Training. Document Storage and Naming.Support
Support.Values List
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
to use within a decision matrix or another decision making tool
How to use your
Forced Choice Paired Comparison Values List template
Find and open your template
Find and open your Values List template
(DecisionValues.xlsx)
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 — which gives you sample data that is extremely helpful for learning how to use your new tool, but is the wrong place to do your real work)
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
Forced Choice Paired Comparison
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 50 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.
Your Prioritized List will be auto generated as you complete the other steps.
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)
Standard features
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
Values List template
How to expand the list
Tip: In October 2020, the number of choices was expanded from 24 to 50. If your Annual Maintenance is current, you can request Systems2win to send you the latest template for free.
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.
Excel training video
Add, Copy, or Move rows or columns
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
Either:
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
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.
Values Ranking Worksheet
with many other useful Continuous Improvement Leadership Tools
to empower every team member
New User Training
Your Systems2win templates come with free New User Training
to quickly learn features that are common to all 150+ templates
Training and Coaching
Consider Training and Coaching to support your teams to succeed
Training to get you started.
Tools you won't outgrow.
Schedule a Conference
Schedule a conference
to discuss your challenges
with an experienced lean advisor
Similar, familiar tools for
Continuous Improvement
Tell a Colleague
Own Yours Now
Own your own professional tools
that you can take with you for the rest of your career