| To open the Total-Trivia Excel Score Sheet for MACs, click HERE |
| To open the Total-Trivia Manual Score Grid, click HERE |
| To open the Total-Trivia Excel Score Sheet click HERE |
To score, there are several options.
You can score on paper using tick marks
or use the spreadsheet provided on this page.
If you wish to use the spreadsheet, follow these instructions:
I. Open the spreadsheet with Microsoft Excel.
at the top of the spreadsheet, then select it and enable at the top of the spreadsheet, then select it and
enable content. The macros are not required, but they do make things easier. (see below)
things easier. (see below)
II. Note that you can size the window so you can see both the trivia window and the
spreadsheet. Alt-Tab can be used to go back and forth between the windows.
Be careful to return to the trivia window or your answers will be typed in the spreadsheet, and you will
not get any credit for them!
III. Enter the names of the people in Column B under Names. After you enter the names, you can
click on control and 'n' to sort by name. If you haven’t enabled macros, this is the same as selecting the
entire sheet and sorting on column B.
IV. Enter scores for each question under the appropriate column. If scoring is 1-1-1, for
instance, enter 1’s in column D for the first question for the people the host points out. If the scoring is
3-2-1, you enter 3, 2 and 1 in the appropriate cells.
V. Note that you can move the bottom scroll bar over to make the current column that you are
scoring for nearer the names. The names and totals will not scroll.
VI. Do not enter anything in column C. These are formulas that automatically total the scores.
You can use these to see who is ahead during a game
VII. When the game is over, hit control and 't' to sort the list by total (column c). if you do not
have macros enabled, then this is the same as selecting the sheet and sorting by column c.
VIII. Select or highlight the player column down to the last player. Copy the cells using the pull
down menu command 'copy' or use ctrl-c. Alternately, you can select B1 through C-x if you do not want to
include the rank.
IX. Paste into your total trivia chat window by typing 'control' and 'v' . NOTE: practice this before
you actually score. If you have any problems, you can ask BobC or someone to help you cut and paste.
That’s it! Feel free to ask questions.
You can score on paper using tick marks
or use the spreadsheet provided on this page.
If you wish to use the spreadsheet, follow these instructions:
I. Open the spreadsheet with Microsoft Excel.
at the top of the spreadsheet, then select it and enable at the top of the spreadsheet, then select it and
enable content. The macros are not required, but they do make things easier. (see below)
things easier. (see below)
II. Note that you can size the window so you can see both the trivia window and the
spreadsheet. Alt-Tab can be used to go back and forth between the windows.
Be careful to return to the trivia window or your answers will be typed in the spreadsheet, and you will
not get any credit for them!
III. Enter the names of the people in Column B under Names. After you enter the names, you can
click on control and 'n' to sort by name. If you haven’t enabled macros, this is the same as selecting the
entire sheet and sorting on column B.
IV. Enter scores for each question under the appropriate column. If scoring is 1-1-1, for
instance, enter 1’s in column D for the first question for the people the host points out. If the scoring is
3-2-1, you enter 3, 2 and 1 in the appropriate cells.
V. Note that you can move the bottom scroll bar over to make the current column that you are
scoring for nearer the names. The names and totals will not scroll.
VI. Do not enter anything in column C. These are formulas that automatically total the scores.
You can use these to see who is ahead during a game
VII. When the game is over, hit control and 't' to sort the list by total (column c). if you do not
have macros enabled, then this is the same as selecting the sheet and sorting by column c.
VIII. Select or highlight the player column down to the last player. Copy the cells using the pull
down menu command 'copy' or use ctrl-c. Alternately, you can select B1 through C-x if you do not want to
include the rank.
IX. Paste into your total trivia chat window by typing 'control' and 'v' . NOTE: practice this before
you actually score. If you have any problems, you can ask BobC or someone to help you cut and paste.
That’s it! Feel free to ask questions.
'HOW TO KEEP SCORE' by BOBC |
HOME