For all of the games tracked in the file, this page displays the tournament average and scores per game for the individuals and teams you specify. Names entered here will automatically populate the “Details” and “Dashboard” tabs.
The table for the individuals now displays the average for all of the quizzers in all of the games at the bottom of the Average column. Keep in mind that your quizzers influence about half of that number since they are represented in every game in the file.
With your team in the first row, the “Estimated Win %” value for each team predicts that team’s win percentage for the tournament using a probability distribution based solely on how your team performs against them compared to the other teams you play.
The “Win Probability” value is the probability that your team will win your next game against that team based on your prior performance against that team.
Below the Team Scores table are the overall Average Points per Game and your Opponents’ Average Points per Game (assuming your team is in the first row). There is also a calculation of the Estimated and Actual Points per Win (PPW) for all of the matches. This is the score necessary to have a greater than 50% chance of winning a game.
“DETAILS” TAB (NO CHANGES)
No changes were made to this table. It continues to show the total number of correct Toss-Ups for each type of question for each of the players.
“SUMMARY” TAB (NO CHANGES)
No changes were made to this table, either. It shows the number of correct Toss-Ups for each type of question in each match. It also provides a bar chart summarizing the Toss-Up accuracy of each question type for all of the games in the file.
This is the big one. All of it is new. Let’s break it down column-by-column:
WARP100 – This is a new statistic. Wins Above Replacement Player (WARP) attempts to calculate a player’s contribution to their team's wins above a typical bench (replacement) player extrapolated over 100 games. Since this stat looks at a player's Net Points game-by-game, consistency matters. For example, say Calvin and Hobbs both finish a 5-game tournament with a 20 average. However, Calvin got all 100 of his points in the first two games while Hobbs scored 20 in every game. According to WARP, Hobbs contributed more wins to the team than Calvin.
Ignoring all other considerations, putting those with the highest WARP factor (can I call it that?) on the same team should win the most games. The caveat here is that you know the strengths of the students better than the spreadsheet. For example, if the quizzers with the best WARP factors are all Memory Verse specialists, you might not want to put them all on the same team.
AQR (Advanced Quizzer Rating) – The next two columns calculate each quizzer’s Advanced Quizzer Rating (AQR). The AQR is a composite statistic that takes into account five variables: Correct per Attempt (toss-ups and bonuses), Points Gained per Attempt (toss-ups and bonuses), Points Lost per Toss-Up Attempt, Quiz Outs per Toss-Up Attempt, and Net Points per Game. The AQR in the first column is calculated using the tournament’s average for each of those five variables. To use your own averages (your season-to-date stats, for example), enter those values in the designated row below the table to calculate the Custom AQR shown in the next column. To understand how this math works, check out the previous blog post.
Correct per Attempt (Intellect) – The total number of correct Toss-Ups and Bonuses divided by the total number of Toss-Ups and Bonuses attempted. This is simply the percent of all questions the quizzer answers correctly.
Points Gained per Attempt (Impact) – Total points gained from Toss-Ups, Bonuses, perfect game bonuses, and the player's share when contributing to 3rd-, 4th-, and 5th-person bonuses. For example, if Quizzers A, B, and C correctly answer the Toss-Up to questions 2, 5, and 10 respectively, then all three quizzers earn 3.33 points (10 pts/3 quizzers) for the 3rd quizzer bonus that was awarded on question 10. If Quizzer D answers the Toss-Up on question 13, then all four quizzers earn 2.5 points (10 pts/4 quizzers) for the 4th quizzer bonus.
Points Lost per Toss-Up Attempt (Discipline) – Total points lost from error-out penalties, errors on questions 16-20, errors when the team has accumulated 5 or more errors before question 16, and points gained by the other team resulting from the player’s error. As in game situations, error points are not cumulative for certain situations (an error-out on question 17, for example). However, any opposing team’s points from answering a Bonus does get included with any point deduction (if there is one) on that question.
Quiz Outs per Toss-Up Attempt (Glory) – Total number of Quiz Outs divided by the total number of Toss-Up attempts (jumps).
Net Points per Game (Valor) – Points Gained minus Points Lost per game. This stat provides a lot of insight when compared to the quizzer’s average points per game. If it is significantly lower than the student's average points per game, that implies they either made a lot of errors that resulted in Bonus points for the opposing team and/or they made errors late in the game that resulted in a loss of team points.
Net Points per Toss-Up Attempt – Points Gained minus Points Lost per Toss-Up attempt (jump).
Toss-Up Accuracy – Total number of correct Toss-Ups divided by the total number of Toss-Ups attempted (jumps). A lower than average number here could indicate the quizzer is jumping quicker or more often than they should given their grasp of the material at this event. Doing so is taking opportunities away from their teammates and gifting the other team with Bonus questions.
Bonus Accuracy – Total number of correct Bonuses divided by the total number of Bonuses attempted.
If a chart is not displaying data, be sure all of the names you select participated in at least 1 quiz match.
Naz Quiz Scoresheet for iOS Numbers (2-team quizzing)
Naz Quiz Scoresheet for iOS Numbers (3-team quizzing)
On an iPad, after the link opens choose the export button (the button to the right of the address bar) and select "Copy to Numbers". If you have trouble, try the Excel link below and export that to Numbers.)
Naz Quiz Scoresheet for MS Excel (2-team quizzing)
Naz Quiz Scoresheet for MS Excel (3-team quizzing)