Skip to main content

Excel Templates, Training, and Coaching

Values List

Forced choice paired comparison values ranking worksheet

When to use your

Values List worksheet


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.

Excel Ribbon bar > Systems2win menu

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)

Systems2win menu > Open a BlankSheet

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

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.

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.

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

Print Areas

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

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

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.


testimonial quote

Values Ranking Worksheet

with many other useful Continuous Improvement Leadership Tools

 

to empower every team member

 


 

 

 

150+ Templates
Try Some Own Them All

 

 

Download Free Trial

Download a dozen trial templates now

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

 

 

 
 

 

 

 

 

Training and Coaching

Consider Training and Coaching to support your teams to succeed

 

two bikers

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

 

 

 

 

 

 

Kaizen templates

Similar, familiar tools for
Continuous Improvement

 

 

Tell a Colleague
share

 

 

Own Yours Now

Own your own professional tools
that you can take with you for the rest of your career