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

51 rows where contestant = 102

✎ 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½
3472 The most dependable thing that weighs about 1kg 716 Mae Martin 102 5   5 1 5 5 5      
3477 Have the best first wedding dance with Alex 717 Mae Martin 102 4   4 2 4 4 4      
3482 Put a ball of string on the cushion 718 Mae Martin 102 5   5 1 5 5 5      
3487 Get all the rubber rings on your bargepole 719 Mae Martin 102 5   5 1 5 5 4.69      
3492 Throw your items into your bucket 720 Mae Martin 102
DQ
   0              
3497 The object which makes you feel weirdest when you look at it 721 Mae Martin 102 1   1 4= 2 1.5 1      
3502 Compose and perform a musical solo 722 Mae Martin 102 4   4 4= 2 1.5 2.61      
3507 Build a bridge over the red green for this potato 723 Mae Martin 102 3   3 2=     2.37 3 2 2.5
3512 Achieve an impressive effect with a single breath 724 Mae Martin 102 4   4 1 5 5 5      
3517 Create a picture of an animal on the back of your T-shirt 725 Mae Martin 102 4   4 2 4 4 4      
3522 The most heroic thing 726 Mae Martin 102 2   2 4 2 2 2      
3527 Exit the caravan after exactly 20 minutes 727 Mae Martin 102
DQ
   0              
3532 Catch the potatoes in the potato hat 728 Mae Martin 102 5   5 1 5 5 5      
3537 Perform a slow-motion fight scene 729 Mae Martin 102 4   4 2=     2.73 3 2 2.5
3542 Know the most facts about sausages 730 Mae Martin 102 3   3 3= 3 2.5 2.81      
3547 The most fun non-headwear to wear on your head 731 Mae Martin 102 2   2 4 2 2 2      
3552 Strike the most drums with a bouncy ball 732 Mae Martin 102 5   5 1 5 5 5      
3557 Make the fastest egg boat 733 Mae Martin 102 2   2 4 2 2 2      
3562 Task bingo 734 Mae Martin 102 1   1 5 1 1 1      
3567 Pour your sand into the other bottle 735 Mae Martin 102
DQ
   0              
3572 The luckiest thing 736 Mae Martin 102 4   4 2 4 4 3.53      
3577 Fake something 737 Mae Martin 102 4   4 2= 4 3.5 3.53      
3582 Musical Simon Says 738 Mae Martin 102 5   5 1= 5 4.5 4.41      
3587 Salvage the most spoons 739 Mae Martin 102 5   5 1=     5 5 3 3.5
3592 Stuff your team-mate's waders 740 Mae Martin 102 10   10 1=     5 5 3 3.5
3597 The best thing to play about with in your bathroom 741 Mae Martin 102 2   2 4 2 2 2      
3602 Perform a poignant domestic scene with an imaginary companion 742 Mae Martin 102 4   4 2= 4 3.5 3.33      
3607 Efficiently shell an egg 743 Mae Martin 102 5   5 1 5 5 5      
3612 Bash the big bell with the bowling ball 744 Mae Martin 102 5   5 1 5 5 5      
3617 Story-time chairs 745 Mae Martin 102 5   5 1 5 5 5      
3622 The most brilliant thing that pops up 746 Mae Martin 102 1   1 5 1 1 1      
3627 Rotate the pulper wheel without pulping the egg 747 Mae Martin 102
DQ
   0              
3632 Free yourselves and have a team hug 748 Mae Martin 102 5   5 1=     3.95 5 3 3.5
3637 Set the parameters for your own task 749 Mae Martin 102 4   4 2 4 4 4      
3642 Imitate accents/walks 750 Mae Martin 102 5   5 1= 5 4 3.95      
3647 The thing you take everywhere with you, but struggle to fit in your bag 751 Mae Martin 102 4   4 2= 4 2.5 2.86      
3652 Pile the pineapples on the path 752 Mae Martin 102 5   5 1 5 5 5      
3657 Repurpose an umbrella 753 Mae Martin 102 4   4 2 4 4 4      
3662 Put the most stuff on top of a jelly 754 Mae Martin 102
DQ
   0              
3667 Use the scratching post to remove balls from your suit 755 Mae Martin 102 5   5 1=     3.57 5 3 3.5
3672 The sneakiest thing 756 Mae Martin 102 4   4 2= 4 3 3.16      
3677 Make these things the same colour 757 Mae Martin 102 5   5 1=     3 5 3 3.5
3682 Deliver a one-minute history lecture 758 Mae Martin 102 3   3 3 3 3 2.81      
3687 Make exactly 99 holes in the piece of paper 759 Mae Martin 102
DQ
   0              
3692 Estimate the heights of things 760 Mae Martin 102 3   3 3 3 3 3      
3697 The best Greg Davies merchandise 761 Mae Martin 102 5   5 1 5 5 5      
3702 Fill the glass up to the line 762 Mae Martin 102 5   5 1 5 5 5      
3707 Do what Alex does 763 Mae Martin 102 3   3 3 3 3 3      
3712 Perform a lullaby for a profession 764 Mae Martin 102 5   5 1=     3.26 5 3 3.5
3717 Standing in ice, or not standing in ice? 765 Mae Martin 102
DQ
   0              
3719 Scream with your mouth closed 766 Mae Martin 102 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
);