normalized_scores
- rigid
- the simplest possible normalization: 5 points for 1st (equal), 4 for 2nd (equal), etc.; null for team tasks (only two ranks)
- spread
- Distribute points from a pool of {5, 4, 3, 2, 1}, with rank ties between N people sharing the next N available point values. (〃)
- scale
- Multiply every score by some common factor to achieve a sum of 15 for the task; where this causes any individual score to exceed 5, regrettably abandon the 15-point target and scale down to ensure a maximum of 5. Note that this value does exist for team tasks due to being point- rather than rank-based.
- 5+3, 3+2, 3½+2½
- various ways to normalize team tasks based on rank
6 rows where contestant = 85
This data as json, CSV (advanced)
Suggested facets: base, points, rank, rigid, spread, scale
| id ▲ | task | contestant | base | ± | points | rank | rigid | spread | scale | 5+3 | 3+2 | 3½+2½ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3150 | Look the most like a champion in the Taskmaster titles 652 | Liza Tarbuck 85 | 0 | 0 | ||||||||
| 3155 | The thing that makes everyone go, "Wow, that really is the greatest thing." 653 | Liza Tarbuck 85 | 3 | 3 | 3 | 3 | 3 | 3 | ||||
| 3160 | Feed yourself a grape in the most elaborate way 654 | Liza Tarbuck 85 | 3 | 3 | 3 | 3 | 3 | 2.81 | ||||
| 3165 | Create a wonderful seaside photo cut-out board 655 | Liza Tarbuck 85 | 5 | 5 | 1 | 5 | 5 | 5 | ||||
| 3170 | Get the duck into the pond 656 | Liza Tarbuck 85 | 3 | 3 | 3 | 3 | 3 | 3 | ||||
| 3175 | Suitcase full of bricks, or suitcase full of balloons? 657 | Liza Tarbuck 85 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE normalized_scores ( id INTEGER PRIMARY KEY, task INTEGER REFERENCES tasks(id), contestant INTEGER REFERENCES people(id), base INTEGER, adjustment INTEGER, points INTEGER, rank TEXT, rigid REAL, spread REAL, scale REAL, '5+3' REAL, '3+2' REAL, '3½+2½' REAL );