Jeopardy.xls - keeps score for you

Playing along with the Jeopardy game show on TV is fun, but the game is so fast paced that it's almost impossible to calculate your own score and still keep up with the game.

This Microsoft Excel worksheet keeps score for you. When a contestant chooses a question, click the corresponding dollar amount button. (See screenshot below.) Answer the question before the contestant does. Then click the RIGHT or WRONG button, depending on how you did (or neither, if you didn't answer). The worksheet does all the math. It also handles Daily Double and Final Jeopardy.

After the game, press the Archive Score button, and the ending data is transferred to the MyScores worksheet.

By showing how your answers affect your real score, this worksheet can help with strategy. One tip: If you don't know, don't guess!

The worksheet uses macros for its calculations. In the Excel 2003 version, they are signed with my personal code-signing certificate, which your computer will not recognize. Before you run the macros, you'll need to review them and then sign them with your own local certificate. See the note about that here.

Download:

jeopardy.zip (about 35 KB)

The zip file contains the Excel 5.0 and Excel 2003 versions. The two are identical. Rename the one you want to JEOPARDY.XLS after download.