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

34 rows where contestant = 6

✎ 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½
4 The most unusual item 1 Romesh Ranganathan 6 3   3 3 3 3 3      
9 Eat as much watermelon as possible 2 Romesh Ranganathan 6 5   5 1 5 5 5      
14 Paint a horse while riding a horse 3 Romesh Ranganathan 6 4   4 2 4 4 4      
19 Empty the bathtub 4 Romesh Ranganathan 6 5   5 1 5 5 5      
24 Pop up a tent and pop on a onesie 5 Romesh Ranganathan 6 2   2 4 2 2 2      
27 Find Alex 6 Romesh Ranganathan 6 0   0              
31 The most impressive item 7 Romesh Ranganathan 6 1   1 5 1 1 1      
36 High-five a 55-year-old 8 Romesh Ranganathan 6 1   1 5 1 1 1      
41 Identify the contents of the pies 9 Romesh Ranganathan 6 3   3 3 3 3 3      
46 Do something that will look impressive in reverse 10 Romesh Ranganathan 6 5   5 1= 5 4.5 4.17      
51 Unshackle yourself and sprint one metre 11 Romesh Ranganathan 6 4   4 2 4 4 4      
56 The most meaningful item 12 Romesh Ranganathan 6 5   5 1 5 5 5      
61 Throw a teabag into a mug 13 Romesh Ranganathan 6 3   3 3 3 3 3      
66 Draw an image using a GPS device 14 Romesh Ranganathan 6 4   4 2 4 4 4      
71 Buy a gift for the Taskmaster 15 Romesh Ranganathan 6 2   2 4 2 2 2      
76 Get an egg as high as possible 16 Romesh Ranganathan 6 4   4 2 4 4 4      
81 Stand up after 100 seconds 17 Romesh Ranganathan 6 4   4 2= 4 3.5 3.75      
84 Guess Frank’s age in minutes 18 Romesh Ranganathan 6 0   0              
88 The most beautiful item 19 Romesh Ranganathan 6 1   1 5 1 1 1      
93 Make a block of ice disappear 20 Romesh Ranganathan 6 2   2 4 2 2 2      
100 Score 11 points 23 Romesh Ranganathan 6 2   2 1=     5 5 3 3.5
105 Fill an eggcup with tears 24 Romesh Ranganathan 6 4   4 2 4 4 4      
111 Memorise an Australian Rules Football team 26 Romesh Ranganathan 6 1   1 1= 5 3 3      
116 The most valuable item 27 Romesh Ranganathan 6 3   3 3 3 3 3      
121 Move the boulder as far as possible 28 Romesh Ranganathan 6 2   2 4 2 2 2      
126 Grow the longest nail 29 Romesh Ranganathan 6 4   4 2 4 4 4      
131 Make a bed while holding hands 30 Romesh Ranganathan 6 0   0              
136 Make a Swedish person blush 31 Romesh Ranganathan 6 4   4 2 4 4 4      
141 Inflate the largest balloon while blindfolded 32 Romesh Ranganathan 6 3   3 3 3 3 3      
146 The most satisfying item 33 Romesh Ranganathan 6 3   3 3 3 3 3      
151 Play mini golf with eggs 34 Romesh Ranganathan 6 1   1 5 1 1 1      
156 Stage a realistic home movie blooper 35 Romesh Ranganathan 6 0   0              
161 Make an alphabet meal 36 Romesh Ranganathan 6 4   4 2 4 4 4      
166 Separate the blue sweets 37 Romesh Ranganathan 6 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
);