TBQ Live Match Excel Scoring Sheet
TBQ Live Match Excel Scoring Sheet &
TBQ Live Tournament Scoring Sheet
Last updated
7/9/2011
By Daniel Meddaugh
Description
Computer Score Sheet that runs in Microsoft Excel during live match
quizzing. Will also run on a MAC with Microsoft Office. This
programs tells you when the match is won and coaching tips during
match play. This program was used by 15 percent of the teams at TBQ
National in Detroit 2010 (including the 4th place team
Bothel). 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".
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.
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/Stop" button back on the Score Sheet..
(Update)
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 take a time-out and tell your quizzers that
"you must get the remaining question to stay in the match".
NOTE: Only after you have entered the point value and the points
that a quizzers got for that question are the Coaches Messages (N17
and X17) valid.
(Updated)I
have updated the TBQ Live Match Excel Scoring Sheet to include
possible bonus points for up to 4 quizzers on each team. Total
possible points at the start of the match is now 430.
(updated) 11/10/09 I have added a TBQ Live Tournament scoring sheet
called (TBQLiveTournamentScoringSheet.xls). This sheet with tally
stats for you meet(up to 19 rounds). Stats are located on a sheet
after round 19. Make sure you keep your quizzers in the same seats
for the meet. Enter all quizzers names in Round 1 only.
(update rev28) 5/15/10 I have fixed the problems with the program
running on MACs. Programs still needs to run on Microsoft Office.
(update rev28) 5/15/10 Worked on the coaches messages
(New update rev29) 7/8/10 Fixed the coaches messages for all 19
rounds.)
(New update rev32) 3/6/11 Updated the stats page to include number
of answered per 10's, 20's and 30's.
(New update rev33) 4/27/11 Updated coaches messages for all 19
rounds).
Please download the latest version.
TBQLiveTournamentScoringSheet_V33.xls
