Quiz Team Results and Scores Log

Who this is for

A season of quiz nights, scored. Each week records the venue, who turned up, your team's score, the winning score and where you finished. The sheet works out the gap to the winners each week and the season's average score, best finish and wins.

Regular pub and club quiz teams who want to know whether they are improving, which line-ups do best and how often they have taken the prize.

What this helps you track

• Every quiz night with the date and venue
• Who played each week
• Your score, the winning score and the gap between them
• Your finishing position and any prize
• Quizzes played, average score, best finish and wins

How to use it

1. Write the team name and the season at the top.
2. After each quiz, add a line with the date, venue and the players who turned up.
3. Enter your score, the winning score, your position and any prize, and tick won if you came first.
4. The gap to the winners, the totals and the season figures are worked out in the browser and the workbook; on paper, subtract your score from the winning one.
5. Use the notes column for the rounds that went well or badly, and look back at it before the next quiz.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What if quizzes are scored out of different totals?

The gap column still works, as it compares your score with the winner's on the same night. The average score is only meaningful if the quizzes are marked the same way, so keep one log per regular quiz if they differ.

Why tick won as well as writing the position?

The tick lets the sheet count wins directly. Position still matters for the best finish figure and for seeing how often you come close.

How do I record a cash prize or a voucher?

Put a cash figure or the value of a bar tab in the prize column, and describe other prizes in the notes. The prize column is totalled for the season.

Can I see which line-up does best?

The players column records who came each week. Sort by it in the workbook or the browser version and compare scores for the weeks each person was there.