Compare multiple job opportunities

Overview

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

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

FAQs

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.

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 update the total formula at the top to account for those changes.

How do the ratings work?

I'm using 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%.

Why are there two files?

One file is an Excel spreadsheet. The other is a Numbers spreadsheet, for those on Mac OS X who may not have Excel.

Helping good people reinvent their careers 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 forge an invincible career so that you get to call the shots in your work and life!

I'm Dr. Larry Cornett, a 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.