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

50 rows where contestant = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: base, adjustment, 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½
447 The most interesting vegetable autograph 94 Mel Giedroyc 21 4   4 2 4 4 4      
452 Beautifully destroy a cake 95 Mel Giedroyc 21 3   3 3 3 3 3      
457 Draw a blind portrait 96 Mel Giedroyc 21 2 1 3 4 2 2 2      
462 Fell all the ducks 97 Mel Giedroyc 21 1   1 5 1 1 1      
467 Make the most fruit juice 98 Mel Giedroyc 21 5   5 1 5 5 5      
472 The most boastful item 99 Mel Giedroyc 21 3   3 3 3 3 3      
477 Keep the basketball on the treadmill 100 Mel Giedroyc 21 3   3 3 3 3 3      
482 Paint a portrait of the Taskmaster without touching the red mat 101 Mel Giedroyc 21 3   3 3 3 3 3      
487 Get the flour onto the target 102 Mel Giedroyc 21 5   5 1=     5 5 3 3.5
492 Put an egg in an egg cup without touching either 103 Mel Giedroyc 21 1   1 5 1 1 1      
497 Make the longest balloon chain 104 Mel Giedroyc 21 5   5 1 5 5 4.41      
502 The best subscription 105 Mel Giedroyc 21 2   2 4 2 2 2      
507 Camouflage yourself 106 Mel Giedroyc 21 1   1 5 1 1 0.938      
512 Make a Taskmaster movie trailer 107 Mel Giedroyc 21 3   3 1=     3.75 5 3 3.5
517 Persuade three animals to stand on the mat 108 Mel Giedroyc 21 1   1 5 1 1 1      
522 Transfer water from one fishbowl to another 109 Mel Giedroyc 21 1 -5 -4 4 2 2 1      
527 Musical words 110 Mel Giedroyc 21 0   0              
534 The most surprising picture of yourself 112 Mel Giedroyc 21 3   3 3 3 3 3      
539 Make the highest splash 113 Mel Giedroyc 21 4   4 2 4 4 4      
544 Ringtone choreography 114 Mel Giedroyc 21 5   5 1= 5 4.5 4.69      
549 Make the best toilet paper celebrity portrait 115 Mel Giedroyc 21 2   2 4= 2 1.5 1.88      
554 Do something incredible with a pommel horse 116 Mel Giedroyc 21 5   5 1= 5 4.5 4.41      
559 Make the tallest tube tower 117 Mel Giedroyc 21 5   5 1= 5 4.5 3.95      
564 The cutest thing 118 Mel Giedroyc 21 2   2 4 2 2 2      
569 Slide as far as possible 119 Mel Giedroyc 21 5   5 1 5 5 5      
574 Don the diving gear while maintaining eye contact and small talk 120 Mel Giedroyc 21 2   2 4 2 2 2      
579 Do incompatible things with the bathtub 121 Mel Giedroyc 21 5   5 1=     5 5 3 3.5
584 Throw something into something 122 Mel Giedroyc 21 5   5 1 5 5 5      
589 Make the longest continuous noise 123 Mel Giedroyc 21 2   2 4 2 2 2      
592 Eat as many peas as possible 124 Mel Giedroyc 21 0   0              
596 The best sheep-related item 125 Mel Giedroyc 21 1   1 5 1 1 1      
601 Pass a camel through a small gap 126 Mel Giedroyc 21 5   5 1 5 5 5      
606 Score a goal with a shopping bag 127 Mel Giedroyc 21 4   4 2 4 4 4      
608 Hide the giant beach ball 128 Mel Giedroyc 21 0   0              
609 Fill the giant beach ball 129 Mel Giedroyc 21 0   0              
610 Score a goal with the giant beach ball 130 Mel Giedroyc 21 0   0              
614 Identify the contents of the sleeping bag 131 Mel Giedroyc 21 2   2 4 2 2 1.76      
619 Prepare the items / Lift all the items in one hand 132 Mel Giedroyc 21 4   4 2 4 4 4      
624 The best chair 133 Mel Giedroyc 21 1   1 5 1 1 1      
629 Cross the bunting to give Alex his lunch 134 Mel Giedroyc 21 2   2 4 2 2 2      
634 Hide from Alex 135 Mel Giedroyc 21 4   4 2 4 4 3.75      
639 Wheelie bin obstacle course 136 Mel Giedroyc 21 2   2 2=     2.31 3 2 2.5
644 Invent a new handshake 137 Mel Giedroyc 21 3   3 3= 3 2 2.5      
649 Make the biggest and best banana 138 Mel Giedroyc 21 1   1 5 1 1 1      
657 The most cash 140 Mel Giedroyc 21 2   2 4 2 2 2      
662 Create an exotic sandwich 141 Mel Giedroyc 21 2   2 4 2 2 2      
667 Eat your exotic sandwich 142 Mel Giedroyc 21 4 1 5 2 4 4 4      
672 Strike an item the farthest 143 Mel Giedroyc 21 2   2 4 2 2 2      
677 Do something surprising with a duck 144 Mel Giedroyc 21 5   5 1 5 5 5      
682 Draw the median duck 145 Mel Giedroyc 21 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
);