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

✎ 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½
3722 The most wonderful wooden thing you’ve owned for a while 767 Sam Campbell 105 3   3 3 3 3 3      
3727 Build a tower of cans in the lab 768 Sam Campbell 105 5   5 1 5 5 5      
3732 Cross the finish line while connected to your team 769 Sam Campbell 105 5   5 1=     3.95 5 3 3.5
3737 Get the duck into the lake 770 Sam Campbell 105 3   3 3 3 3 3      
3742 Heavier or lighter? 771 Sam Campbell 105 5   5 1= 5 4 3.95      
3747 The best sign 772 Sam Campbell 105 3   3 3 3 3 3      
3752 Pull the sword from the stone 773 Sam Campbell 105 2   2 4 2 2 2      
3757 Make a cheeky picture using nails and wire 774 Sam Campbell 105 5   5 1= 5 4.5 4.69      
3762 Make mischief 775 Sam Campbell 105 1   1 5 1 1 1      
3767 Draw something you like and something you dislike 776 Sam Campbell 105 1   1 5 1 1 1      
3774 The present that raises the most questions 778 Sam Campbell 105 5   5 1 5 5 5      
3779 Get the ball in the hole without touching it 779 Sam Campbell 105 4   4 2 4 4 4      
3784 Get underneath the most unique things 780 Sam Campbell 105 5   5 1 5 5 4.69      
3789 Choose a new nickname 781 Sam Campbell 105 5   5 1 5 5 5      
3794 Human war boats 782 Sam Campbell 105 5   5 1=     5 5 3 3.5
3799 The best thing for a grown-up that is meant for a child 783 Sam Campbell 105 1   1 5 1 1 1      
3804 Make a surprisingly pleasant sausage 784 Sam Campbell 105 1   1 5 1 1 1      
3809 Complete all the tasks as a team 785 Sam Campbell 105 5   5 1=     3.95 5 3 3.5
3814 Recreate a well-known piece of art on 100 memo squares 786 Sam Campbell 105 5   5 1= 5 4.5 4.41      
3819 Roll your animal die 787 Sam Campbell 105 5   5 1 5 5 5      
3826 The best thing that has five things on it 789 Sam Campbell 105 1   1 5 1 1 1      
3831 Burst the balloon without looking at it 790 Sam Campbell 105 4   4 2 4 4 4      
3836 Make a cool but scary googly-eyed gang 791 Sam Campbell 105 5   5 1 5 5 5      
3841 Get all of the water into the vase 792 Sam Campbell 105
DQ
   0              
3846 Retrieve and sip your drink 793 Sam Campbell 105 4   4 2 4 4 3.75      
3851 The greatest thing that makes quite a loud noise when you shake it 794 Sam Campbell 105 5   5 1 5 5 5      
3856 Avoid the rubbish robots 795 Sam Campbell 105 2   2 4 2 2 2      
3861 Recreate the garage scene in the lab 796 Sam Campbell 105 3   3 1=     3 5 3 3.5
3866 Present a powerful piece called "Heads, Shoulders, Knees and Toes" 797 Sam Campbell 105 5   5 1= 5 4.5 3.75      
3871 Pineapple bluff 798 Sam Campbell 105 3   3 3= 3 2.5 2.81      
3876 The thing most guaranteed to make you groan 799 Sam Campbell 105 2   2 4= 2 1.5 1.88      
3881 Play with these switches / Balance the most golf tees 800 Sam Campbell 105
DQ
   0              
3886 Pie the air dancer in the face 801 Sam Campbell 105 3   3 3 3 3 3      
3891 Place your cardboard replica within the boundary 802 Sam Campbell 105 5   5 1 5 5 5      
3896 Get three balls on your hat using litter-pickers 803 Sam Campbell 105 4   4 2 4 4 4      
3900 Pop your party popper the furthest 804 Sam Campbell 105 0   0              
3903 The best single-word object you own and love that gets the best reaction when introduced following a drum roll 805 Sam Campbell 105 2   2 5 1 1 1.67      
3908 Find the secret task 806 Sam Campbell 105 1   1 1 5 5        
3913 Complete the fortune trail 807 Sam Campbell 105 4   4 2 4 4 4      
3918 Convince a child that you're asleep 808 Sam Campbell 105 5   5 1= 5 4.5 4.69      
3923 Mime proverbs to your team 809 Sam Campbell 105 3   3 2=     2.37 3 2 2.5
3928 The bit of old crap that Greg likes the best 810 Sam Campbell 105 4   4 2 4 4 4      
3933 Obey all of the traffic signals 811 Sam Campbell 105 2   2 4 2 2 2      
3938 Make the best gift for Greg 812 Sam Campbell 105 2   2 5 1 1 1.67      
3943 Feed the clown the most cards 813 Sam Campbell 105
DQ
   0              
3948 Pass the parade exam 814 Sam Campbell 105 2   2 4 2 2 1.88      
3953 The thing that, when you turn it round, gives you the biggest shock 815 Sam Campbell 105 2   2 4 2          
3958 Do something shocking but family-friendly with this doughnut 816 Sam Campbell 105 3   3 4 2          
3963 Demonstrate the most effective high-intensity four-part exercise routine 817 Sam Campbell 105 4   4 2 4          
3968 Give your guest the best service 818 Sam Campbell 105 2   2 3=            
3973 Throw a ball into the bathtub 819 Sam Campbell 105 5   5 1 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
);