Compare multiple job opportunities by Dr. Larry Cornett

Compare multiple job opportunities

Spreadsheets that help you quantitatively compare multiple job offers

Overview

It's easy to get excited about a job offer and make a decision based on emotions, only to regret it later. These spreadsheets allows you to quantitatively compare up to 2 job offers relative to your current job on 38 different factors. The score is totaled out of 100 at the top. 

Each spreadsheet has placeholder information and data to show you how it works. Feel free to rename any of the factors that you want. Obviously, put the appropriate company names, job offer titles, compensation numbers, and ratings in for your situation.

What's included?

File Icon 3 files

Contents

Introduction
How to use the spreadsheet.rtf
6.44 KB
Leadership Jobs
Evaluating Job Opportunities for Leaders 2019.xlsx
14.4 KB
Independent Contributor Jobs
Evaluating Job Opportunities for Independent Contributors 2019.xlsx
14.4 KB

Are you ready to get the spreadsheets?

Get Them Now

FAQ

Why did I create these spreadsheets?

It is often overwhelming to compare job offers. People tend to focus on only a few factors like title, salary, stock, or total compensation. While these factors do matter, they do not paint the full picture of a new job opportunity. 

There are so many other factors that will impact your decision and affect your happiness and satisfaction with a new job. For example, one job may give you a much higher total compensation right now, but not set you up for greater success later. Or, you may take a role that seems great now, but a really long commute makes you miserable six months later. 

It helps to consider all of these other factors when comparing opportunities. The quantitative score out of 100% tries to make it a little less emotional and easier to compare the job offers too. Of course, your gut feel is important and will play a role. But, it’s helpful to have objective data as a “gut check.”

Who is this spreadsheet for?

This spreadsheet is for anyone faced with the challenge of comparing multiple job offers. It can feel overwhelming. There are often factors that are really important for you, but they might get overlooked in the heat of the moment. This spreadsheet lets you slow down and seriously compare the offers on the factors that matter the most to you.

How do the ratings work?

I use a Likert scale of 1 to 5. A score of 5 is the best, and 1 is the worst for each factor. You can roughly think of the ratings like this:
  • 5 = Great!
  • 4 = Good
  • 3 = OK or Neutral
  • 2 = Bad
  • 1 = Terrible!

Note: if you don't enter a number between 1-5, the total at the top will be off from the max of 100%. Simply enter a score of 3 to treat a factor as neutral.

Can I modify the spreadsheet?

Yes, absolutely! It is easy to enter your own information for the company names and compensation numbers. Just overwrite the placeholders that I have.

Also, you'll obviously want to score the factors (1-5) with your own ratings. Note: if you don't use a number between 1-5, the total at the top will be off from the max of 100%.

You can also overwrite any of the Factors with some that are more important for you. For example, you might want to change the "Coffee" factor to "Allows dogs at the office."

If you are comfortable with creating and editing formulas in spreadsheets, you can play around with adding more rows and factors. You will have to modify the "Total score" formula to account for those changes (e.g., if you add a factor in a new row).

Why are there two spreadsheets?

There are two different Excel spreadsheets that you can choose to download and use:

  1. Evaluating Job Opportunities for Independent Contributors
  2. Evaluating Job Opportunities for Leaders

Note: The Numbers app on Mac OS X can open spreadsheet files in this .xlsx format. You don’t need an Excel application.

The Leaders spreadsheet is intended for people who will be comparing senior-level roles that include managing and leading teams. The Independent Contributors spreadsheet is for people who will not be managing others. 

How about now?

Yes, I'm ready!

Helping good people forge an Invincible Career to land great jobs

Do you feel stuck in your job? Passed over for a promotion? Maybe you're ready for a serious career change? I will help you create an Invincible Career® so that you get to call the shots in your work and life!

I'm Dr. Larry Cornett, a Leadership Coach and Career Advisor focused on career transformation, leadership development, and organizational excellence. I work with ambitious people to help them get promoted, do more of the work that they love, find better opportunities, or even start their own business.