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

53 rows where contestant = 57

✎ 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½
2072 The nicest thing to put in your mouth 431 Richard Herring 57 4   4 2 4 4 4      
2077 Fell the coconut, then move the drinks 432 Richard Herring 57
DQ
   0              
2082 Make a large object vanish 433 Richard Herring 57 3   3 3= 3 2.5 2.81      
2087 Get the most eggs in the pan 434 Richard Herring 57 0   0              
2092 Get the most balls of the same colour in your bucket using litter pickers 435 Richard Herring 57 5   5 1 5 5 5      
2097 The best thing with loads of holes in it 436 Richard Herring 57 3   3 3 3 3 3      
2102 Find the treasure / Make different, increasingly loud noises 437 Richard Herring 57 4   4 2=     2.73 3 2 2.5
2107 Make a portrait of the Taskmaster and his toy using balloons, pegs, and clothing 438 Richard Herring 57 2   2 3= 3 2.5 2      
2112 Get all the exercise balls in the hoops while in a boat 439 Richard Herring 57 4   4 2 4 4 4      
2117 Guess what is making the noises 440 Richard Herring 57 6   6 1= 5 4.5 4.09      
2119 Select a wind-up dinosaur 441 Richard Herring 57 0   0              
2124 The best thing that probably has a spring 442 Richard Herring 57 3   3 3 3 3 3      
2129 Make the best upside-down film 443 Richard Herring 57 1   1 5 1 1 1      
2134 Put the most spaghetti in a grapefruit 444 Richard Herring 57 2   2 4 2 2 2      
2139 Catapult a shoe into a bathtub 445 Richard Herring 57 3   3 3 3 3 3      
2144 Draw an object on a rotating canvas 446 Richard Herring 57 6   6 1=     5 5 3 3.5
2149 The cheekiest food 447 Richard Herring 57 3   3 3 3 3 3      
2154 Make the phone ring 448 Richard Herring 57 5   5 1 5 5 5      
2159 Persuade the security guard to look in your bag 449 Richard Herring 57 0   0              
2164 Drop a water balloon as far as possible without it bursting 450 Richard Herring 57 4   4 4 2 2 2.73      
2169 Roll an edible sphere across a line as slowly as possible 451 Richard Herring 57 1   1 5 1 1 1      
2174 The best pointy thing 452 Richard Herring 57 5   5 1 5 5 5      
2179 Bag the heaviest thing from the greatest distance 453 Richard Herring 57 4   4 2 4 4 4      
2184 Paint a howling wolf on a rotating teapot 454 Richard Herring 57 5   5 1= 5 4.5 4.69      
2189 Do something out of character with £20 455 Richard Herring 57 4   4 3= 3 2.5 2.86      
2194 Feed your team-mate(s) the most watermelon 456 Richard Herring 57 5   5 1=     3.95 5 3 3.5
2199 List words of a certain length without hesitating 457 Richard Herring 57 3   3 3= 3 2.5 2.81      
2204 The most narcissistic thing 458 Richard Herring 57 2   2 4= 2 1.5 1.88      
2209 Quietly make a cocktail 459 Richard Herring 57 3   3 3 3 3 3      
2214 Draw the animal watching you from the mirror 460 Richard Herring 57 2   2 4 2 2 2      
2219 Transfer the water from one barrel to another 461 Richard Herring 57 3   3 3 3 3 3      
2224 Draw animals using straight lines 462 Richard Herring 57 2   2 2=     1.88 3 2 2.5
2229 The best thing that’s bigger at the top than the bottom 463 Richard Herring 57 1   1 5 1 1 1      
2234 Move two chickens around a course using a remote-control car and a mobility scooter 464 Richard Herring 57 3   3 3 3 3 3      
2239 Communicate the safe contents via reversed audio 465 Richard Herring 57 0   0              
2244 Make the best and longest-lasting marble run 466 Richard Herring 57 3   3 3 3 3 3      
2249 Communicate things to the Taskmaster using only sounds 467 Richard Herring 57 2   2 4 2 2 2      
2256 The best thing with wings 469 Richard Herring 57 5   5 1 5 5 5      
2261 Fill the cup to overflowing without touching the red green 470 Richard Herring 57
DQ
   0              
2266 Learn your lines and perform a scene 471 Richard Herring 57 5   5 1 5 5 4.69      
2271 Extract water from a coconut 472 Richard Herring 57 4   4 2 4 4 4      
2276 Do not blink while staring at your opponent with a selected expression 473 Richard Herring 57 4   4 1=     3.75 5 3 3.5
2281 The best bedding 474 Richard Herring 57 5   5 1 5 5 4.69      
2286 Make the largest beer mat house while ringing the doorbell with increasing frequency 475 Richard Herring 57 3   3 3 3 3 3      
2291 Complete the most tasks behind the five motorised doors 476 Richard Herring 57 4   4 2 4 4 4      
2296 Work out how many balls are in the basket 477 Richard Herring 57 4   4 2 4 4 4      
2301 Draw the monster described by the Taskmaster 478 Richard Herring 57 5   5 1 5 5 3.95      
2306 The greatest collection 479 Richard Herring 57 1   1 5 1 1 1      
2311 Put the wellies on the spider’s feet 480 Richard Herring 57 3   3 3 3 3 3      
2316 Complete the best performance of a specific song 481 Richard Herring 57 5   5 1=     4.69 5 3 3.5
2321 Neatly hang all the clothes on a rail without stepping over the line 482 Richard Herring 57 3   3 3 3 3 3      
2326 Balance all the mints or biscuits on a spaghetti bridge 483 Richard Herring 57 5   5 1 5 5 5      
2328 Guess how many green eggs are under the Taskmaster’s chair 484 Richard Herring 57 0   0              

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