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 = 507
This data as json, CSV (advanced)
Suggested facets: points
| id ▲ | task | contestant | base | ± | points | rank | rigid | spread | scale | 5+3 | 3+2 | 3½+2½ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2439 | Put the bag of salt onto that table 507 | Charlotte Ritchie 63 | 5 | 5 | 1= | 5 | 5 | 3 | 3.5 | |||
| 2440 | Put the bag of salt onto that table 507 | Jamali Maddix 64 | 5 | 5 | 1= | 5 | 5 | 3 | 3.5 | |||
| 2441 | Put the bag of salt onto that table 507 | Lee Mack 65 | 0 | |||||||||
| 2442 | Put the bag of salt onto that table 507 | Mike Wozniak 66 | 0 | |||||||||
| 2443 | Put the bag of salt onto that table 507 | Sarah Kendall 67 | 5 | 5 | 1= | 5 | 5 | 3 | 3.5 |
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 );