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

51 rows where contestant = 50

✎ 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½
1813 The most stressful thing 379 Jo Brand 50 3   3 3 3 3 2.81      
1818 Hide three aubergines from Alex 380 Jo Brand 50 2   2 4 2 2 2      
1823 Arrange the lollies in rainbow order 381 Jo Brand 50 3   3 3= 3 2.5 2.65      
1828 Make the most dramatic entrance 382 Jo Brand 50 4   4 2= 4 3.5 3.53      
1833 Draw the second longest snake 383 Jo Brand 50 0   0              
1838 The best bag 384 Jo Brand 50 3   3 3 3 3 3      
1843 Identify which bin Alex is in 385 Jo Brand 50 0   0              
1848 Draw a portrait of the Taskmaster across a flipchart 386 Jo Brand 50 4   4 2 4 4 3.75      
1853 Say the word ‘demeaning’ 387 Jo Brand 50 3   3 2=     2.14 3 2 2.5
1858 Arrange the playdough balls / Do the correct things with the balls 388 Jo Brand 50 5   5 1 5 5 4.69      
1863 The weirdest wooden thing 389 Jo Brand 50 1   1 5 1 1 1      
1868 Surprise memory test 390 Jo Brand 50 1   1 5 1 1 1      
1873 Build a robust statue of a delicate thing 391 Jo Brand 50 3   3 3 3 3 2.81      
1878 Score a goal with a steamroller 392 Jo Brand 50 4   4 2 4 4 4      
1883 Break something and put it back together 393 Jo Brand 50 5   5 1 5 5 5      
1888 Fill a glass with water 394 Jo Brand 50 1   1 5 1 1 0.938      
1893 The best thing to celebrate with on stage 395 Jo Brand 50 4   4 2 4 4 3.75      
1898 Make the most striking water feature 396 Jo Brand 50 2   2 4 2 2 2      
1903 Bring a classic board game to life 397 Jo Brand 50 3   3 1=     3 5 3 3.5
1908 Fill a tray with things beginning with a letter you chose 398 Jo Brand 50 3   3 3 3 3 3      
1913 Throw objects, but not too far 399 Jo Brand 50 4   4 2 4 4 4      
1918 The best defunct thing 400 Jo Brand 50 3   3 3 3 3 3      
1923 Lasso Alex 401 Jo Brand 50 5   5 1 5 5 5      
1928 Make an accurate and inventive egg timer 402 Jo Brand 50 5   5 1 5 5 5      
1933 Get to know a person who alternately tells the truth, lies, and brags 403 Jo Brand 50 2 1 3 2=     1.88 3 2 2.5
1938 Build a tower behind you using a mirror and litter pickers 404 Jo Brand 50 3   3 3 3 3 2.65      
1943 The thing you’d be most pleased to find in a field 405 Jo Brand 50 4   4 2 4 4 4      
1948 Make a body part abnormally long 406 Jo Brand 50 5   5 1 5 5 4.69      
1953 Push a watermelon up a slide using breadsticks 407 Jo Brand 50
DQ
   0              
1958 Serenade yourself 408 Jo Brand 50 5   5 1= 5 4 3.75      
1963 Slide drinks to the Taskmaster 409 Jo Brand 50 2   2 4 2 2 2      
1968 The best thing taken from someone else’s house 410 Jo Brand 50 1   1 5 1 1 1      
1973 Throw eggs into metal receptacles 411 Jo Brand 50 2   2 4 2 2 2      
1978 Build the best Mount Rushmore 412 Jo Brand 50 3   3 5 1 1 2.14      
1983 Find and put the gold rings on the stick 413 Jo Brand 50 3   3 3= 3 2.5 2.65      
1988 Horse or laminator? 414 Jo Brand 50 13   13 1 5 5 5      
1993 The best thing from a shed 415 Jo Brand 50 5   5 1 5 5 5      
1998 Throw something into a pedal bin 416 Jo Brand 50 4   4 2 4 4 4      
2003 Write and perform lyrics for the Taskmaster theme tune 417 Jo Brand 50 1   1 5 1 1 1      
2008 Supply a soundtrack for a film 418 Jo Brand 50 2   2 2=     2.31 3 2 2.5
2013 Draw your own face on a face shield 419 Jo Brand 50 3   3 4= 2 1.5 2.37      
2018 The most desirable smooth thing 420 Jo Brand 50 4   4 2= 4 2.5 2.86      
2023 Subtly deliver a five word instruction to Alex 421 Jo Brand 50 4   4 2 4 4 3.75      
2028 Inflate, tie, and pop the most balloons 422 Jo Brand 50
DQ
   0              
2033 Make a famous couple using knees and/or elbows 423 Jo Brand 50 1   1 5 1 1 1      
2038 Communicate pictures by drawing on your team-mate’s back 424 Jo Brand 50 5   5 1=     3.57 5 3 3.5
2043 The best thing that is very long and thin 425 Jo Brand 50 4   4 2 4 4 4      
2048 Do the most preposterous thing with a chickpea 426 Jo Brand 50 1   1 5 1 1 1      
2053 Make a cup of tea 427 Jo Brand 50 5   5 1=     5 5 3 3.5
2058 Complete the seven tasks in any order 428 Jo Brand 50
DQ
   0              
2063 Select the shortest breadstick 429 Jo Brand 50 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
);