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

45 rows where contestant = 24

✎ 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½
685 The most excellent noise 146 Bob Mortimer 24 2   2 4 2 2 2      
690 Give Alex a special cuddle 147 Bob Mortimer 24 5   5 1 5 5 4.69      
695 Get Alex to dry land 148 Bob Mortimer 24 2   2 4 2 2 2      
700 Score a basket without your hands 149 Bob Mortimer 24 5   5 1 5 5 5      
705 Get some fruit into the bowl 150 Bob Mortimer 24 4   4 2 4 4 4      
710 The hippest headwear 151 Bob Mortimer 24 4   4 2 4 4 4      
715 Make a coconut-flinging machine 152 Bob Mortimer 24 5   5 1 5 5 4.69      
720 Paint a rainbow in the dark 153 Bob Mortimer 24 1   1 5 1 1 1      
725 Slice bread using something from the caravan 154 Bob Mortimer 24
DQ
   0              
730 Create the greatest splat 155 Bob Mortimer 24 2   2 2=     2.5 3 2 2.5
735 Paint your own canvas 156 Bob Mortimer 24 4   4 5 1 1 2.5      
740 The proudest item 157 Bob Mortimer 24 5   5 1 5 5 5      
745 Retrieve the table tennis ball from the tube 158 Bob Mortimer 24 5   5 1 5 5 5      
750 Make a coconut businessman 159 Bob Mortimer 24 1   1 5 1 1 1      
755 Eat one item, balance one item, throw one item 160 Bob Mortimer 24 4   4 2 4 4 4      
760 Word table tennis 161 Bob Mortimer 24 2   2 4 2 2 2      
765 The most extraordinary souvenir 162 Bob Mortimer 24 1   1 5 1 1 1      
770 Make marmite 163 Bob Mortimer 24 5   5 1 5 5 5      
775 Do something remarkable synchronised 164 Bob Mortimer 24 3   3 1=     3.46 5 3 3.5
780 Blow up a balloon to the size of a cucumber 165 Bob Mortimer 24 4   4 2 4 4 4      
785 Spot the difference 166 Bob Mortimer 24 2   2 4= 2 1.5 2      
790 Sneeze the fastest 167 Bob Mortimer 24 5   5 1 5 5 5      
795 Greg says... 168 Bob Mortimer 24 1   1 5 1 1 1      
802 The most high-octane item 170 Bob Mortimer 24 4   4 2 4 4 4      
807 Put the largest thing inside a balloon 171 Bob Mortimer 24 0   0              
812 Create a remarkable water cooler moment 172 Bob Mortimer 24 3   3 3 3 3 3      
818 Build a can tower & greet Alex from different countries 174 Bob Mortimer 24 5   5 1= 5 4.5 4.69      
823 Identify the Finns 175 Bob Mortimer 24 2   2 4= 2 1.5 1.76      
828 The best home-made item 176 Bob Mortimer 24 5   5 1 5 5 5      
833 Balance Alex on a see-saw 177 Bob Mortimer 24 2   2 4 2 2 2      
838 Record the most incredible PoV footage 178 Bob Mortimer 24 4   4 2= 4 3 3.33      
844 Light a candle using a cupcake 180 Bob Mortimer 24 5   5 1 5 5 5      
849 Make yourself monotone 181 Bob Mortimer 24 2   2 4 2 2 2      
853 Kick yoghurt at a target 182 Bob Mortimer 24 0   0              
856 The most surprisingly expensive item 183 Bob Mortimer 24 3   3 3= 3 2.5 2.81      
861 Travel blindfolded for three minutes and retrace your steps 184 Bob Mortimer 24 5   5 1 5 5 5      
866 Coconut bobsleigh 185 Bob Mortimer 24
DQ
   0              
871 Vote for who should receive five points 186 Bob Mortimer 24 0   0              
876 Make a funny flick book 187 Bob Mortimer 24 5   5 1= 5 4.5 3.95      
881 Zipwire items to the Taskmaster 188 Bob Mortimer 24 5   5 1 5 5 5      
886 The most awkward item to take home 189 Bob Mortimer 24 1   1 5 1 1 1      
891 Transport a coconut as far as possible 190 Bob Mortimer 24 4   4 2 4 4 4      
896 Create the best graph 191 Bob Mortimer 24 4   4 2 4 4 3.33      
903 Write and perform a song about a stranger 193 Bob Mortimer 24 2   2 2=     2.5 3 2 2.5
908 Throw an egg through a basketball hoop 194 Bob Mortimer 24 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
);