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

28 rows where contestant = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: base, points, rank, rigid, spread, scale, 5+3, 3+2, 3½+2½

id ▲ task contestant base ± points rank rigid spread scale 5+3 3+2 3½+2½
172 The most important document 38 Richard Osman 12 2   2 4= 2 1.5 1.88      
177 Place the exercise balls on the yoga mat 39 Richard Osman 12 5   5 1 5 5 5      
182 Get the potato into the hole 40 Richard Osman 12 4   4 2 4 4 4      
187 Find out about the Swedish person 41 Richard Osman 12 4   4 2 4 4 4      
192 Pack a suitcase 42 Richard Osman 12 5   5 1 5 5 5      
197 The trendiest item of clothing 43 Richard Osman 12 1   1 5 1 1 1      
202 Quickly eat an egg 44 Richard Osman 12 5   5 1 5 5 5      
207 Create a nursery rhyme video 45 Richard Osman 12 3   3 4 2 2 2.37      
212 A photo of an object that looks like you 46 Richard Osman 12 5   5 1 5 5 5      
217 Order a pizza without using certain words 47 Richard Osman 12 1   1 5 1 1 1      
222 Put potatoes in a basket 48 Richard Osman 12
DQ
   0              
227 The best dinner party guest 49 Richard Osman 12 2   2 4 2 2 2      
232 Impress the Mayor 50 Richard Osman 12 4   4 2 4 4 4      
237 Make an unexpected silhouette 51 Richard Osman 12 4   4 2 4 4 4      
242 Buy a gift for the Taskmaster 52 Richard Osman 12 5   5 1 5 5 5      
247 See no potato, hear no potato, speak no potato 53 Richard Osman 12 5   5 1=     5 5 3 3.5
252 Throw rabbits into a hat 54 Richard Osman 12 7   7 4 2 2 2.1      
257 The coolest blue item 55 Richard Osman 12 1   1 5 1 1 1      
262 Rescue Patatas from the tree 56 Richard Osman 12 0   0              
267 Conceal a pineapple on your person 57 Richard Osman 12 3   3 3 3 3 3      
272 Set a task / Guess who set the tasks 58 Richard Osman 12 0   0              
277 Construct something for the Taskmaster 59 Richard Osman 12 1   1 2=     1.07 3 2 2.5
282 Build the tallest tower using potato products 60 Richard Osman 12 0   0              
287 The best piece of memorabilia 61 Richard Osman 12 5   5 1 5 5 5      
292 Move items across a stream 62 Richard Osman 12 4   4 2 4 4 4      
297 Create a stop-motion film starring a potato 63 Richard Osman 12 3   3 1=     3.75 5 3 3.5
302 Build a bridge for the potato 64 Richard Osman 12 2   2 4 2 2 2      
307 Put on gloves, eat a banana, put on a tie, and clap 65 Richard Osman 12 5   5 1 5 5 5      

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