normalized_scores

Table actions
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

11 rows where contestant = 29

✎ View and edit SQL

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½
913 The most embarrassing item 195 Josh Widdicombe 29 5   5 1 5 5 5      
918 Throw an exercise ball into a bath or put the coconuts in a trolley 196 Josh Widdicombe 29 1   1 5 1 1 1      
923 Blow something substantial off a table 197 Josh Widdicombe 29 4   4 2= 4 3.5 3.75      
928 Perform a miracle 198 Josh Widdicombe 29 5   5 1= 5 4.5 3.57      
933 The second longest T-word 199 Josh Widdicombe 29 4   4 2= 4 3 3.33      
937 Sing along to the Taskmaster theme tune 200 Josh Widdicombe 29 0   0              
939 The best thing 201 Josh Widdicombe 29 3   3 3= 3 2.5 2.81      
944 Find out what’s in the briefcase 202 Josh Widdicombe 29 4   4 2 4 4 4      
949 Make a delicious mask 203 Josh Widdicombe 29 4   4 2 4 4 3.75      
954 Make a mess and then clean it up 204 Josh Widdicombe 29 3   3 4 2 2 2.65      
959 Record the most steps on your pedometers 205 Josh Widdicombe 29 4   4 2 4 4 4      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);