News    

TBQ Live Match Excel Scoring Sheet

February 2009

by Daniel Meddaugh

Description
Computer Score Sheet that runs in Microsoft Excel during live match quizzing. This programs tells you when the match is won and coaching tips during match play. I used it for the 2008 Missouri Classic and took first place in the Novice Division with this program. There is no cost to use this program. The score sheet is setup for TBQ with a 5 question quiz out bonus of 20 points. Your team goes on top. You can swap team colors with (Cell E2). Goto G44 for startup notes. There is a "Click to Clean Scores" button for new match. Introductory Remarks go in Row 5 and 6 for each question. Failed Contests in "O8" and "O19".

(New) I have updated the "TBQ computer Excel score sheet" with a place to put notes (or type the question) for each question in the match. You can enter Notes in E7 thru AA7.

(New) I added the percentage of questions answered right for each quizzer on the right (AG9 thru AG14 for top team quizzers and AG20 thru AG25 for bottom team quizzers.

(New) I have updated the "TBQ computer Excel score sheet" with a countdown timer. Goto the "Countdown Clock" spread sheet tab on the bottom and make sure you have the countdown time right in C2. Then click the "Start Clock" button. Go back to the "Score Sheet" Spread sheet tab on bottom and the counter on the top (T2) will countdown.

Coaches tips are as follows from N15.
If Top team does not answer any more questions in the match and still will win, then this box will say "Don't buzin to Win". If the Top team missed all remaining questions and the other team made all remaining questions (including any possible bonus from Quiz outs) and the Top team will still win the match, then this box will say "WON, Attack!!". This is time to use a time-out and tell your quizzers "The match is won, go get as many points as you can". If you are behind in the match the message "Must get all remaining" means that you should do a time-out and tell your quizzers that "you must get the remaining question to stay in the match".

(New) I have updated the “TBQ Live Match Excel Scoring Sheet” to include possible bonus points for up to 4 quizzers on each team. As I was waking up this morning I had the idea. Total possible points at the start of the match is now 430.

(Fix) The Round # field was being protected.

(NEW) I have added a alarm message to tell the coach when a quizzer is 1 question away from a fizz out.

TBQLiveMatchExcelScoringSheet.xls (Microsoft Excel) -- UPDATED 5/19/09

| RETURN |

Admin
©1996-2008 Assemblies of God