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
5 rows where task = 232
This data as json, CSV (advanced)
| id ▲ | task | contestant | base | ± | points | rank | rigid | spread | scale | 5+3 | 3+2 | 3½+2½ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1090 | Remove the tablecloth from underneath the eggs 232 | Alice Levine 33 | 5 | 5 | 1= | 5 | 3 | 3 | ||||
| 1091 | Remove the tablecloth from underneath the eggs 232 | Asim Chaudhry 34 | 5 | 5 | 1= | 5 | 3 | 3 | ||||
| 1092 | Remove the tablecloth from underneath the eggs 232 | Liza Tarbuck 35 | 5 | 5 | 1= | 5 | 3 | 3 | ||||
| 1093 | Remove the tablecloth from underneath the eggs 232 | Russell Howard 36 | 5 | 5 | 1= | 5 | 3 | 3 | ||||
| 1094 | Remove the tablecloth from underneath the eggs 232 | Tim Vine 37 | 5 | 5 | 1= | 5 | 3 | 3 |
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 );