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

✎ 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½
3178 The most jaw-dropping item 658 Dara Ó Briain 88 4   4 2= 4 3.5 3.75      
3183 What ten films are you in? 659 Dara Ó Briain 88 1   1 5 1 1 1      
3188 Land loo roll in the toilet 660 Dara Ó Briain 88 5   5 1 5 5 5      
3193 Create the best picture of a bird 661 Dara Ó Briain 88 2   2 2=     1.88 3 2 2.5
3198 Don't pop the balloon 662 Dara Ó Briain 88 5   5 1= 5 4.5 5      
3203 The best thing you can't throw away 663 Dara Ó Briain 88 5   5 1 5 5 4.69      
3208 Print, laminate, and distribute the most signs 664 Dara Ó Briain 88 5   5 1 5 5 5      
3213 Obey all your signs 665 Dara Ó Briain 88 5   5 1= 5 4.5 4.69      
3218 Put five grapes in the little bowl 666 Dara Ó Briain 88 5   5 1 5 5 5      
3223 Sort the ducks and the socks 667 Dara Ó Briain 88 5 2 7 1 5 5 5      
3228 Make the Taskmaster say your words 668 Dara Ó Briain 88 3   3 1=     3.46 5 3 3.5
3233 The thing you most want on a Sunday morning 669 Dara Ó Briain 88 4   4 2 4 4 4      
3238 Put the most sand in the shopping trolley 670 Dara Ó Briain 88 0   0              
3243 Identify the ice cream flavours 671 Dara Ó Briain 88 5   5 1 5 5 4.69      
3248 Catch something 672 Dara Ó Briain 88 5   5 1 5 5 5      
3253 Play your sounds right 673 Dara Ó Briain 88 3   3 3= 3 2 2.5      
3258 The greatest addition to a garden 674 Dara Ó Briain 88 4   4 2 4 4 4      
3263 Turn on the bubble machine 675 Dara Ó Briain 88 4   4 2 4 4 4      
3268 Get the tarpaulin into one of the containers 676 Dara Ó Briain 88 4   4 2 4 4 4      
3273 Write a classic song incorporating five wonderful words 677 Dara Ó Briain 88 2   2 4= 2 1.5 1.76      
3278 Egg and spoon throw 678 Dara Ó Briain 88 5   5 1 5 5 5      
3283 The most useless thing that cost over £20 679 Dara Ó Briain 88 4   4 2 4 4 3.53      
3288 Get the most pleasure from these rubber chutes 680 Dara Ó Briain 88 2   2 5 1 1 1.67      
3293 Perform the best routine to this music 681 Dara Ó Briain 88 5   5 1=     3.26 5 3 3.5
3298 Luggage trolley bowling 682 Dara Ó Briain 88 3   3 3 3 3 3      
3303 Communicate animals by saying letters and doing impressions 683 Dara Ó Briain 88 5   5 1=     3 5 3 3.5
3308 The best thing you've ever received in the post 684 Dara Ó Briain 88 2   2 4 2 2 2      
3313 Hold the milk bottles above the microwaves 685 Dara Ó Briain 88 1   1 5 1 1 1      
3318 Reach the end of two lanes in the same amount of time 686 Dara Ó Briain 88 2   2 4 2 2 2      
3323 Strike the bullseye with your paint 687 Dara Ó Briain 88
DQ
   0              
3328 Paint a unicorn using your head brush 688 Dara Ó Briain 88 5   5 1 5 5 5      
3333 The thing you'd most like to have on a car journey 689 Dara Ó Briain 88 3   3 3 3 3 3      
3338 Pop 99 red balloons 690 Dara Ó Briain 88 4   4 2 4 4 4      
3343 Get this feather into the bath 691 Dara Ó Briain 88 5   5 1=     3.95 5 3 3.5
3348 Hit Bernard with an exercise ball 692 Dara Ó Briain 88 4   4 2 4 4 4      
3353 Blow an item onto The Knappett 693 Dara Ó Briain 88 5   5 1= 5 3.5 3.57      
3358 The best fancy dress 694 Dara Ó Briain 88 3   3 2= 4 3.5 3      
3363 Communicate an instruction in a secret language 695 Dara Ó Briain 88 0   0              
3368 Pin an alluring tail on the alluring animal 696 Dara Ó Briain 88 4   4 2 4 4 4      
3373 Find the back of your hand 697 Dara Ó Briain 88 0   0              
3378 Guess the length of the extendible item 698 Dara Ó Briain 88 2   2 2=     2.5 3 2 2.5
3383 The most underestimated item 699 Dara Ó Briain 88 3   3 1= 5 4 3.75      
3388 Snort, raspberry, whistle 700 Dara Ó Briain 88 3   3 3 3 3 2.81      
3393 Write a one-minute, one-person play 701 Dara Ó Briain 88 4   4 4 2 2 3      
3398 Perform a one-minute, one-person play 702 Dara Ó Briain 88 5   5 1= 5 4.5 3.95      
3403 Paint a self portrait with a selected brush on a selected canvas 703 Dara Ó Briain 88 2   2 4 2 2 2      
3408 Get your towel in your bucket 704 Dara Ó Briain 88 5   5 1 5 5 4.69      
3413 The thing the Taskmaster would most like to own 705 Dara Ó Briain 88 2   2 2 4 4 3.33      
3418 Order three things for your final task 706 Dara Ó Briain 88 0   0              
3423 Eat the grape 707 Dara Ó Briain 88 5   5 1 5 5 5      
3428 Sculpt your team 708 Dara Ó Briain 88 3   3 2=     2.37 3 2 2.5
3433 Throw an object, hide an object, and place it on the barrel 709 Dara Ó Briain 88 5   5 1 5 5 5      
3438 Land a balloon near the Taskmaster 710 Dara Ó Briain 88 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
);