There's now +4 hours of video content on!

ยซ   Previous Post Next Post   ยป
A spreadsheet to compare job offers


A few times in my career, I've been fortunate enough to decide on which job I want most upon receiving multiple job offers.

I made a reusable spreadsheet which you can apply to your own prospective jobs, instructions at the bottom. Here are my personal observations on the pros and cons of two jobs I was evaluating.

They both made offers, so to decide between the two, I tallied them up against the following criteria:

The actual spreadsheet I used for two jobs in particular

Area of focus Place 1 Place 2 Notes
๐Ÿ’ฐ๏ธ Salary 1 More than xx% increase with Place 1
๐Ÿฅ Support for volunteering 1 Place 1: 3 days paid + XX days unpaid. Place 2 supports flexible hours, so would need to finish off my hours in the evening or weekend
๐Ÿ‘ฅ Culture 1 Place 2 is prestigious and has stimulating work
๐Ÿ ๏ธ Working from home 1 Place 2 said infrequently is ok. Place 1 could be multiple days a week
๐Ÿง ๏ธ Side projects 1 Place 2 support consulting + working with lots of interesting organisations. Place 1 offer hackdays
๐Ÿ’† Relaxed atmosphere 1 Place 1 is a large department with opportunity to do things in a relaxed manner. Place 2 is a smaller team, so the atmosphere may change during deadlines
๐Ÿ‘ถ๏ธ Maternity/paternity support 1 1 Both have good support in different ways
โšก๏ธ Interesting projects 1 Lots of fascinating projects to work on at Place 2. Place 1 develops prison software + court software which is also interesting. Place 2 is more varied however
๐Ÿ‘Œ Quality of code 1 Judging from respective GitHub projects, Place 1 has an extremely high level of code quality along with tests. Place 2 codebase has some room for improvement
๐Ÿ Peers 1 Place 2 team are a nice group of likeminded people. I don't know much about Place 1 folk
๐ŸŒ Diversity 1 Place 2 team is all guys. Place 1 are much more diverse
๐Ÿ“ข OSS + Evangelism 1 Place 1 do blogging + OSS by default. Lots of writing to read online, documentation for their projects, retrospectives, interactive demos. Place 2 have some open source code, couldn't find much blogging/written experiences. Both will support my conference speaking
๐Ÿ“ˆ Career progression 1 More opportunity at Place 2. Place 1 seems to only lead onto managerial roles
๐Ÿ“ Technology architecture 1 Place 1 have established tools for CI/Testing/Deployments/Rollbacks/Code Review/Debugging/Development/Collaboration. Place 2 is smaller and appears to have less in place (based on GitHub)
๐Ÿ’ค Lack of politics 1 Both have some, but Place 2 better protects you from it
๐Ÿ’ป Technologies 1 Place 2 use very interesting + modern tech. Place 1 are starting to use modern tech, but also have some legacy code


To use this yourself, you can find the table on GitHub or use this Google Sheet

For more useful tips like this, follow me on twitter.

Update: Sonny raises an interesting point. They suggest adding two points:

Which I think are two very important points. Examples:


Hopefully this spreadsheet, or maybe my thought process can give you some tips when deciding for yourself.

Also as a reminder: The actual pros/cons shown above are my personal opinion, and are not representative for the organisations as a whole in question, since I only interviewed with a single team in both cases.

Let me know if you use any other criteria that could be helpful in the spreadsheet.

ยซ   Previous Post Next Post   ยป

Sign up to receive blog updates, tips, and find out more about what I'm working on