Lean Management Systems


Values List

Forced choice paired comparison values ranking worksheet

When to use your

Values List worksheet

How to use your

Values List template

Find and open your template

Excel Ribbon bar > Systems2win menu

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

Systems2win menu > 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 Ranking worksheet

to make forced choice paired comparison values rankings

Define the decision that needs to be made

Operational Definitions template

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.

Values List worksheet

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...

Value List Excel template

Do not edit anything in the section containing the Prioritized List.

Your Prioritized List will be autogenerated 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...

Print Areas

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
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

Decision Matrix


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



priced low enough to empower every team member



If your organization has not yet provided a license, you can download your free trial



menu bottom



Own All 150+ Templates for
Continuous Process Improvement






Your Systems2win templates come with free New User Training to quickly learn features that are common to all 150+ templates







Your Systems2win templates come with Training & Videos to help you get the most from your process improvement tools















Why are we spending
all that money to re-invent?

when we could be using
affordable professional tools

Download ROI Calculator