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

✎ 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½
2611 The nicest thing to sit on 542 Victoria Coren Mitchell 72 3   3 3 3 3 3      
2616 Strike Alex with a ball 543 Victoria Coren Mitchell 72 3   3 3 3 3 3      
2621 Paint a flattering picture of the Taskmaster in action 544 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2626 Pop the balloon 545 Victoria Coren Mitchell 72 4   4 2 4 4 4      
2631 Strike poses to represent a hobby, an animal, and a celebrity 546 Victoria Coren Mitchell 72 1   1 4= 2 1.5 1      
2636 The most awesome square 547 Victoria Coren Mitchell 72 3   3 3 3 3 3      
2641 Scale the mountain 548 Victoria Coren Mitchell 72 3   3 2=     2.14 3 2 2.5
2646 Work out the contents of the bags 549 Victoria Coren Mitchell 72 5   5 1 5 5 4.69      
2651 Paint the space hopper green 550 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2656 Put on the medallion 551 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2661 The most old-fashioned thing that you still use 552 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2666 Copy Alex 553 Victoria Coren Mitchell 72 5   5 1 5 5 5      
2671 Make a sand bridge across the river 554 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2676 Film a thrilling sequence with a welly-cam 555 Victoria Coren Mitchell 72 3   3 3= 3 2.5 2.65      
2681 Convey objects using shadows 556 Victoria Coren Mitchell 72 2   2 2=     1.88 3 2 2.5
2686 The best thing that has quite a few layers 557 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2691 Complete the course as slowly as possible 558 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2696 Spread jam on toast in a really cool way 559 Victoria Coren Mitchell 72 3   3 3 3 3 2.81      
2701 Solve the riddle 560 Victoria Coren Mitchell 72 5   5 1=     4.69 5 3 3.5
2706 Get the most forks in your bucket 561 Victoria Coren Mitchell 72 4   4 2 4 4 4      
2711 The most elegant thing beginning with 'G' 562 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2716 Sit on a cake 563 Victoria Coren Mitchell 72 5   5 1 5 5 5      
2721 Get the most balls in the net 564 Victoria Coren Mitchell 72 0   0              
2726 Prevent Alex from scoring a goal 565 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2731 Pop the most balloons 566 Victoria Coren Mitchell 72 1   1 5 1 1 0.5      
2736 The most desirable thing for another contestant 567 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2741 Land the iron on the ironing board 568 Victoria Coren Mitchell 72 3   3 3 3 3 3      
2746 Make a cute toy for a cute dog 569 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2751 Sit on the red chair in the secret tower 570 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2756 Make paper aeroplanes 571 Victoria Coren Mitchell 72 2   2 4 2 2 1.88      
2761 The most ridiculous thin thing 572 Victoria Coren Mitchell 72 5   5 1 5 5 5      
2766 Put up a shelf for the Taskmaster's snooker balls 573 Victoria Coren Mitchell 72 3   3 2= 4 2.5 2.81      
2771 Write and perform a 30-second jingle 574 Victoria Coren Mitchell 72 2   2 5 1 1 1.5      
2776 Pass everything through the pipe and the pipe through everything 575 Victoria Coren Mitchell 72 3   3 3 3 3 3      
2781 Direct drawings using limited keywords 576 Victoria Coren Mitchell 72 5   5 1= 5 4.5 5      
2786 The best thing you have repurposed 577 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2791 Make a popcorn necklace and do the right thing 578 Victoria Coren Mitchell 72 -5   -5              
2796 Play and commentate on a socially-distanced sport 579 Victoria Coren Mitchell 72 5   5 1=     3 5 3 3.5
2801 Make your face look like another face when it's upside-down 580 Victoria Coren Mitchell 72 5   5 1= 5 4.5 3.75      
2806 Pop up before the objects 581 Victoria Coren Mitchell 72 3   3 3= 3 2.5 2.65      
2813 The best 40 identical things on a towel 583 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2818 Have the longest telephone conversation 584 Victoria Coren Mitchell 72 4   4 2 4 4 4      
2823 Find the soldier with hindsight 585 Victoria Coren Mitchell 72 2   2 4 2 2 2      
2828 Get goosebumps 586 Victoria Coren Mitchell 72
DQ
   0              
2833 Duck-slide 587 Victoria Coren Mitchell 72 0   0              
2838 The most magnificent floppy thing 588 Victoria Coren Mitchell 72 1   1 5 1 1 0.938      
2843 Drink with your mouth open 589 Victoria Coren Mitchell 72 1   1 5 1 1 1      
2848 Describe the Taskmaster / Chocolate button / Guess the tasks 590 Victoria Coren Mitchell 72 5   5 1=     3.41 5 3 3.5
2853 Propose to Alex 591 Victoria Coren Mitchell 72 3   3 5 1 1 2.14      
2858 Make noises without being identified by the Taskmaster 592 Victoria Coren Mitchell 72 3   3 3= 3 2 2.37      

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