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 = 56

✎ 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½
2071 The nicest thing to put in your mouth 431 Mawaan Rizwan 56 1   1 5 1 1 1      
2076 Fell the coconut, then move the drinks 432 Mawaan Rizwan 56
DQ
   0              
2081 Make a large object vanish 433 Mawaan Rizwan 56 5   5 1 5 5 4.69      
2086 Get the most eggs in the pan 434 Mawaan Rizwan 56 0   0              
2091 Get the most balls of the same colour in your bucket using litter pickers 435 Mawaan Rizwan 56 2   2 4 2 2 2      
2096 The best thing with loads of holes in it 436 Mawaan Rizwan 56 5   5 1 5 5 5      
2101 Find the treasure / Make different, increasingly loud noises 437 Mawaan Rizwan 56 5   5 1=     3.41 5 3 3.5
2106 Make a portrait of the Taskmaster and his toy using balloons, pegs, and clothing 438 Mawaan Rizwan 56 2   2 3= 3 2.5 2      
2111 Get all the exercise balls in the hoops while in a boat 439 Mawaan Rizwan 56
DQ
   0              
2116 Guess what is making the noises 440 Mawaan Rizwan 56 4   4 3 3 3 2.73      
2123 The best thing that probably has a spring 442 Mawaan Rizwan 56 4   4 2 4 4 4      
2128 Make the best upside-down film 443 Mawaan Rizwan 56 4   4 2 4 4 4      
2133 Put the most spaghetti in a grapefruit 444 Mawaan Rizwan 56 4   4 2 4 4 4      
2138 Catapult a shoe into a bathtub 445 Mawaan Rizwan 56 2   2 4 2 2 2      
2143 Draw an object on a rotating canvas 446 Mawaan Rizwan 56 0   0              
2148 The cheekiest food 447 Mawaan Rizwan 56 5   5 1 5 5 5      
2153 Make the phone ring 448 Mawaan Rizwan 56 3   3 3 3 3 3      
2158 Persuade the security guard to look in your bag 449 Mawaan Rizwan 56 0   0              
2163 Drop a water balloon as far as possible without it bursting 450 Mawaan Rizwan 56 3   3 5 1 1 2.05      
2168 Roll an edible sphere across a line as slowly as possible 451 Mawaan Rizwan 56 2   2 4 2 2 2      
2173 The best pointy thing 452 Mawaan Rizwan 56 1   1 5 1 1 1      
2178 Bag the heaviest thing from the greatest distance 453 Mawaan Rizwan 56 3   3 3 3 3 3      
2183 Paint a howling wolf on a rotating teapot 454 Mawaan Rizwan 56 2   2 4 2 2 1.88      
2188 Do something out of character with £20 455 Mawaan Rizwan 56 5   5 1= 5 4.5 3.57      
2193 Feed your team-mate(s) the most watermelon 456 Mawaan Rizwan 56 3   3 2=     2.37 3 2 2.5
2198 List words of a certain length without hesitating 457 Mawaan Rizwan 56 3   3 3= 3 2.5 2.81      
2203 The most narcissistic thing 458 Mawaan Rizwan 56 5   5 1 5 5 4.69      
2208 Quietly make a cocktail 459 Mawaan Rizwan 56 5   5 1 5 5 5      
2213 Draw the animal watching you from the mirror 460 Mawaan Rizwan 56 3   3 3 3 3 3      
2218 Transfer the water from one barrel to another 461 Mawaan Rizwan 56 5   5 1 5 5 5      
2223 Draw animals using straight lines 462 Mawaan Rizwan 56 4   4 1=     3.75 5 3 3.5
2228 The best thing that’s bigger at the top than the bottom 463 Mawaan Rizwan 56 5   5 1 5 5 5      
2233 Move two chickens around a course using a remote-control car and a mobility scooter 464 Mawaan Rizwan 56 5   5 1 5 5 5      
2238 Communicate the safe contents via reversed audio 465 Mawaan Rizwan 56 3   3 1=     5 5 3 3.5
2243 Make the best and longest-lasting marble run 466 Mawaan Rizwan 56
DQ
   0              
2248 Communicate things to the Taskmaster using only sounds 467 Mawaan Rizwan 56 3   3 3 3 3 3      
2251 Work out how many sheets are on a toilet roll 468 Mawaan Rizwan 56 0   0              
2255 The best thing with wings 469 Mawaan Rizwan 56 4   4 2 4 4 4      
2260 Fill the cup to overflowing without touching the red green 470 Mawaan Rizwan 56
DQ
   0              
2265 Learn your lines and perform a scene 471 Mawaan Rizwan 56 2   2 4= 2 1.5 1.88      
2270 Extract water from a coconut 472 Mawaan Rizwan 56
DQ
   0              
2275 Do not blink while staring at your opponent with a selected expression 473 Mawaan Rizwan 56 4   4 1=     3.75 5 3 3.5
2280 The best bedding 474 Mawaan Rizwan 56 4   4 2 4 4 3.75      
2285 Make the largest beer mat house while ringing the doorbell with increasing frequency 475 Mawaan Rizwan 56 5   5 1 5 5 5      
2290 Complete the most tasks behind the five motorised doors 476 Mawaan Rizwan 56 2   2 4 2 2 2      
2295 Work out how many balls are in the basket 477 Mawaan Rizwan 56 3   3 3 3 3 3      
2300 Draw the monster described by the Taskmaster 478 Mawaan Rizwan 56 4   4 2= 4 3.5 3.16      
2305 The greatest collection 479 Mawaan Rizwan 56 5   5 1 5 5 5      
2310 Put the wellies on the spider’s feet 480 Mawaan Rizwan 56 4   4 2 4 4 4      
2315 Complete the best performance of a specific song 481 Mawaan Rizwan 56 2   2 2=     1.88 3 2 2.5
2320 Neatly hang all the clothes on a rail without stepping over the line 482 Mawaan Rizwan 56 2   2 4 2 2 2      
2325 Balance all the mints or biscuits on a spaghetti bridge 483 Mawaan Rizwan 56 4   4 2 4 4 4      
2327 Guess how many green eggs are under the Taskmaster’s chair 484 Mawaan Rizwan 56 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
);