25 Years of Programming
An open source source for C, C++, OWL, BASIC, MDB, XLS, DOT, and more...
Home   Projects   Up   Sitemap   Search   Blog   Forum+Chat   About Us   Privacy   Terms of Use   Feedback   FAQ   Images   Services   Ads   Donate   Humor

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.

Screenshots:

The main game board (Excel 2003 version):

Screenshot of the Jeopardy.xls game board.

Your historical game log:

Screenshot of the Jeopardy.xls historical game log.

 

 

Valid HTML 4.01 Transitional Valid CSS
View content labeling at ICRA.
Copyright ©2007 Steven Whitney. Last modified 09/25/2007.