Are you having trouble picking a name for your new baby? If you and your spouse have different ideas for baby names, that can make it even harder. Believe it or not, there is a method for making group decisions that might help, and you can download a spreadsheet that will do the magic number crunching for you. The method is called "pairwise ranking" and it involves each person comparing just two names at a time, giving a weighted vote to each comparison.

Advertisement

Baby Name Picker

for Excel
Baby Name Picker Spreadsheet
Download
For: Excel 2007 or later & Excel for iPad/iPhone

Template Details

License: Private Use
View Agreement
(not for distribution or resale)

"No installation, no macros - just a simple spreadsheet" - by

Advertisement

Description

This tool can aid you and your spouse in deciding on a name for your new baby. It is based on the idea that it's easier to make a comparison between just two things at a time than trying to rank an entire list all at once (especially when more than one person is voicing an opinion).

The real power of this spreadsheet comes from being able to account for two different people's opinions. Having a second voter is not necessary, though.

How do we pick the 5 names? Come up with a list of names that you are both willing to consider. Narrow the list down to 5 names, or get creative and use the spreadsheet to help you narrow down the list, 5 at a time.

What if I have fewer than 5 names? Add other names until you have 5.

What about middle names? It's up to you whether to include middle names or not. If you come up with a tie (or close call) between two first names, you could repeat the process by listing 5 first+middle name combinations.

How does it work?

If it helps, you can think of the approach as a round-robin tournament in which the names represent teams. The final ranking accounts for the scores, not just the number of wins. So, in a close race, the individual scores can make a big difference. For example, if two teams (A and B) have the same win/loss record, but team A beat a team that team B lost to (and really thrashed them good), that could make team A the better team.

Is this for real?

Yes, the principle of pairwise comparison is a real statistical approach. It might seem a bit geeky to use it to help name a child, but you might change your mind when you end up needing it.

After my wife and I first used this technique, it became kind of an inside joke about how we really DO use Excel for everything. The conversation would usually go something like "Yes, I use Excel a lot. I've even used Excel to help name our kids." It wasn't until other people started asking us for a copy of the spreadsheet that I decided to turn it into a template.

I first came across this approach when I participated in a movie ranking survey back in college, where the ranking of movies was determined from the votes of many participants making pairwise comparisons between movies.

The next time I saw this method in use was in a department meeting in which we were trying to rank a set of problems based on the subjective opinions of multiple experts.

Note: What I've done in this spreadsheet is based on pairwise comparison and pairwise ranking, but I used no references in the development of the algorithm for this spreadsheet.

 

LIKE THIS TEMPLATE?

Follow Us On ...

       
Master Excel - Spreadsheet Tips Workbook

Related Templates