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

✎ 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½
2888 The most exciting thing to be found in a skip 598 Sophie Duker 82 3   3 3 3 3 3      
2893 Find all ten ducks in the lab 599 Sophie Duker 82 3   3 3= 3 2.5 2.81      
2898 Create a lipstick portrait of the Taskmaster 600 Sophie Duker 82 3   3 3= 3 2.5 2.81      
2903 Duel with Alex 601 Sophie Duker 82 5   5 1 5 5 5      
2908 Count to 13 602 Sophie Duker 82 4   4 2 4 4 4      
2913 The object you would most like to show to an alien 603 Sophie Duker 82 2   2 2= 4 2.5 2      
2918 Tie a ribbon round the maypole or hit it with a ping pong ball 604 Sophie Duker 82 5   5 1 5 5 5      
2923 Recreate the coolest photo from your phone 605 Sophie Duker 82 2   2 4 2 2 2      
2928 Score an exercise ball hat-trick using a buggy 606 Sophie Duker 82 3   3 2=     2.37 3 2 2.5
2933 Draw and describe the object under your table 607 Sophie Duker 82 1   1 4= 2 1.5 1      
2938 The item that sounds funniest when you say its name over and over again 608 Sophie Duker 82 2   2 5 1 1 1.76      
2943 Recreate a historical moment using traffic cones 609 Sophie Duker 82 3   3 3 3 3 3      
2948 Make all the things happen at the same time 610 Sophie Duker 82 0   0              
2953 Enable Alex to bite his duck 611 Sophie Duker 82 4 1 5 2 4 4 4      
2958 Face leg or other leg? 612 Sophie Duker 82 6   6 1=     4.09 5 3 3.5
2963 The best night-time thing 613 Sophie Duker 82 3   3 3 3 3 3      
2968 Guess Shoe 614 Sophie Duker 82 3   3 3 3 3 3      
2973 Give Alex the best stag minute 615 Sophie Duker 82 4   4 2=     2.73 3 2 2.5
2978 Make a stirring speech out of the bunting 616 Sophie Duker 82 3   3 3 3 3 3      
2983 Knock over your opponents' dolls with a tyre 617 Sophie Duker 82 3   3 3 3 3 3      
2990 The most surprising thing from your wardrobe 619 Sophie Duker 82 2   2 4 2 2 2      
2995 Make a key difficult to retrieve 620 Sophie Duker 82 0   0              
3000 High-five Alex 621 Sophie Duker 82 5   5 1 5 5 5      
3005 Raise the water level to the top of the fish tank 622 Sophie Duker 82
DQ
   0              
3010 Answer Alex's phone call 623 Sophie Duker 82 2   2 4 2 2 2      
3015 Pop balls out of your hole 624 Sophie Duker 82 4   4 2 4 4 4      
3020 The most calming item 625 Sophie Duker 82 3   3 3 3 3 3      
3025 Use a cement mixer 626 Sophie Duker 82 1   1 4= 2 1.5 1      
3030 Record a high number on a pedometer 627 Sophie Duker 82 3   3 3 3 3 3      
3035 Hold a meeting with yourselves 628 Sophie Duker 82 3   3 3 3 3 3      
3040 Correctly guess the person's first name 629 Sophie Duker 82 5   5 1 5 5 5      
3042 Display your vocal range 630 Sophie Duker 82 0   0              
3047 The nicest thing to put your finger in 631 Sophie Duker 82 4   4 2 4 4 3.33      
3052 Show off 632 Sophie Duker 82 5   5 1= 5 4.5 3.95      
3057 Deliver a cocktail to Greg 633 Sophie Duker 82 5   5 1=     3.95 5 3 3.5
3062 Create an edible sculpture 634 Sophie Duker 82 5   5 1= 5 4 3.26      
3067 Eat your beautiful sculpture 635 Sophie Duker 82 4   4 2 4 4 4      
3072 Build the tallest tower of toilet rolls 636 Sophie Duker 82 5   5 1 5 5 4.69      
3077 The loveliest thing to hold above your head 637 Sophie Duker 82 5   5 1= 5 4.5 4.69      
3082 Learn Swedish 638 Sophie Duker 82 3   3 3 3 3 3      
3087 Poke your tongue out for the longest time 639 Sophie Duker 82 5   5 1 5 5 5      
3092 Walk through the door wearing the longest shoes and biggest hat 640 Sophie Duker 82 3   3 3 3 3 3      
3097 Write down things that fit the category 641 Sophie Duker 82 3   3 2=     2.37 3 2 2.5
3102 The best object with a handle 642 Sophie Duker 82 3   3 3 3 3 3      
3107 Get the most surprising thing delivered 643 Sophie Duker 82 2   2 4= 2 1.5 1.76      
3112 Make the longest cup snake 644 Sophie Duker 82 3   3 3 3 3 3      
3117 Poke a body part out of the shower curtain 645 Sophie Duker 82 5   5 1= 5 4.5 5      
3122 Predict how many cans you can fit in a bag 646 Sophie Duker 82
DQ
   0              
3127 The finest family heirloom 647 Sophie Duker 82 4   4 2= 4 3 3.16      
3132 Identify the liquids 648 Sophie Duker 82 5   5 1 5 5 3.75      
3137 Get the most ducks in Alex's basket 649 Sophie Duker 82 4   4 2 4 4 4      
3142 Record a multi-track song about your team 650 Sophie Duker 82 5   5 1=     3.57 5 3 3.5
3147 Draw a life-size self portrait with your nose in the canvas 651 Sophie Duker 82 4   4 3 3 3 3.53      

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