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

52 rows where contestant = 49

✎ 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½
1812 The most stressful thing 379 Ed Gamble 49 2   2 4= 2 1.5 1.88      
1817 Hide three aubergines from Alex 380 Ed Gamble 49 5   5 1 5 5 5      
1822 Arrange the lollies in rainbow order 381 Ed Gamble 49 5   5 1= 5 4.5 4.41      
1827 Make the most dramatic entrance 382 Ed Gamble 49 4   4 2= 4 3.5 3.53      
1832 Draw the second longest snake 383 Ed Gamble 49 0   0              
1837 The best bag 384 Ed Gamble 49 2   2 4 2 2 2      
1842 Identify which bin Alex is in 385 Ed Gamble 49 5   5 1 5 5 5      
1847 Draw a portrait of the Taskmaster across a flipchart 386 Ed Gamble 49 3   3 3= 3 2.5 2.81      
1852 Say the word ‘demeaning’ 387 Ed Gamble 49 5   5 1=     3.57 5 3 3.5
1857 Arrange the playdough balls / Do the correct things with the balls 388 Ed Gamble 49 4   4 2= 4 3.5 3.75      
1862 The weirdest wooden thing 389 Ed Gamble 49 3   3 3 3 3 3      
1867 Surprise memory test 390 Ed Gamble 49 3   3 3 3 3 3      
1872 Build a robust statue of a delicate thing 391 Ed Gamble 49 2   2 4= 2 1.5 1.88      
1877 Score a goal with a steamroller 392 Ed Gamble 49 3   3 3 3 3 3      
1882 Break something and put it back together 393 Ed Gamble 49 1   1 5 1 1 1      
1887 Fill a glass with water 394 Ed Gamble 49 5   5 1 5 5 4.69      
1892 The best thing to celebrate with on stage 395 Ed Gamble 49 5   5 1 5 5 4.69      
1897 Make the most striking water feature 396 Ed Gamble 49 5   5 1 5 5 5      
1902 Bring a classic board game to life 397 Ed Gamble 49 3   3 1=     3 5 3 3.5
1907 Fill a tray with things beginning with a letter you chose 398 Ed Gamble 49 2   2 4 2 2 2      
1912 Throw objects, but not too far 399 Ed Gamble 49 1   1 3= 3 2 1      
1917 The best defunct thing 400 Ed Gamble 49 2   2 4 2 2 2      
1922 Lasso Alex 401 Ed Gamble 49 2   2 4 2 2 2      
1927 Make an accurate and inventive egg timer 402 Ed Gamble 49 1   1 5 1 1 1      
1932 Get to know a person who alternately tells the truth, lies, and brags 403 Ed Gamble 49 4   4 1=     3.75 5 3 3.5
1937 Build a tower behind you using a mirror and litter pickers 404 Ed Gamble 49 5   5 1= 5 4.5 4.41      
1942 The thing you’d be most pleased to find in a field 405 Ed Gamble 49 5   5 1 5 5 5      
1947 Make a body part abnormally long 406 Ed Gamble 49 3   3 3= 3 2.5 2.81      
1952 Push a watermelon up a slide using breadsticks 407 Ed Gamble 49 5   5 1 5 5 5      
1957 Serenade yourself 408 Ed Gamble 49 5   5 1= 5 4 3.75      
1962 Slide drinks to the Taskmaster 409 Ed Gamble 49 1   1 5 1 1 1      
1967 The best thing taken from someone else’s house 410 Ed Gamble 49 3   3 3 3 3 3      
1972 Throw eggs into metal receptacles 411 Ed Gamble 49 4   4 2 4 4 4      
1977 Build the best Mount Rushmore 412 Ed Gamble 49 4   4 3= 3 2.5 2.86      
1982 Find and put the gold rings on the stick 413 Ed Gamble 49 5   5 1= 5 4.5 4.41      
1987 Horse or laminator? 414 Ed Gamble 49 1   1 3= 3 2.5 0.385      
1992 The best thing from a shed 415 Ed Gamble 49 4   4 2 4 4 4      
1997 Throw something into a pedal bin 416 Ed Gamble 49 5   5 1 5 5 5      
2002 Write and perform lyrics for the Taskmaster theme tune 417 Ed Gamble 49 4   4 2 4 4 4      
2007 Supply a soundtrack for a film 418 Ed Gamble 49 3   3 1=     3.46 5 3 3.5
2012 Draw your own face on a face shield 419 Ed Gamble 49 4   4 2= 4 3.5 3.16      
2017 The most desirable smooth thing 420 Ed Gamble 49 4   4 2= 4 2.5 2.86      
2022 Subtly deliver a five word instruction to Alex 421 Ed Gamble 49 2   2 4= 2 1.5 1.88      
2027 Inflate, tie, and pop the most balloons 422 Ed Gamble 49 5   5 1 5 5 5      
2032 Make a famous couple using knees and/or elbows 423 Ed Gamble 49 3   3 2= 4 3.5 3      
2037 Communicate pictures by drawing on your team-mate’s back 424 Ed Gamble 49 3   3 2=     2.14 3 2 2.5
2042 The best thing that is very long and thin 425 Ed Gamble 49 2   2 4 2 2 2      
2047 Do the most preposterous thing with a chickpea 426 Ed Gamble 49 4   4 2 4 4 4      
2052 Make a cup of tea 427 Ed Gamble 49 1   1 2=     1 3 2 2.5
2057 Complete the seven tasks in any order 428 Ed Gamble 49 5   5 1 5 5 5      
2062 Select the shortest breadstick 429 Ed Gamble 49 0   0              
2066 Use a spread to delay a pop-up toy 430 Ed Gamble 49 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
);