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

57 rows where contestant = 37

✎ 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½
967 The best liquid 206 Tim Vine 37 5   5 1 5 5 5      
972 Perform the best wheelbarrow stunt 207 Tim Vine 37 2   2 4 2 2 2      
977 Make the tallest lemon tower 208 Tim Vine 37 2   2 4 2 2 2      
982 Return to the house wearing a hat 209 Tim Vine 37 2   2 4 2 2 2      
987 Sort the objects by size using your feet 210 Tim Vine 37
DQ
   0              
994 The best non-living hairy thing 212 Tim Vine 37 5   5 1 5 5 5      
999 Get the highest darts score 213 Tim Vine 37 4   4 2 4 4 4      
1004 Keep Alex dry 214 Tim Vine 37 1   1 2=     1.25 3 2 2.5
1009 Take a picture of people holding eggs 215 Tim Vine 37 1   1 5 1 1 1      
1014 Take the wind-up man on an adventure 216 Tim Vine 37 3   3 3= 3 2 2.5      
1019 Conceal grapes in your mouth or hand 217 Tim Vine 37 0   0              
1024 The most magnificent day trip 218 Tim Vine 37 5   5 1 5 5 5      
1029 Write a grown-up bedtime story 219 Tim Vine 37 2   2 4 2 2 2      
1034 Make something spin for the longest 220 Tim Vine 37 3   3 3 3 3 3      
1039 Identify the baby food flavours 221 Tim Vine 37 1   1 5 1 1 1      
1044 Catch the most socks 222 Tim Vine 37 4   4 2= 4 3 3.33      
1049 The most thought-provoking thing 223 Tim Vine 37 4   4 2 4 4 4      
1054 Do something manly with a cardboard box 224 Tim Vine 37 4   4 2= 4 2.5 2.86      
1059 Have the most fun in 3 minutes 225 Tim Vine 37 3   3 1=     3.46 5 3 3.5
1064 Exactly recreate your 3 minutes of fun 226 Tim Vine 37 5   5 1=     3 5 3 3.5
1069 Make the best squirty cream art 227 Tim Vine 37 2   2 4 2 2 2      
1074 Remove the banknote from under the glass 228 Tim Vine 37 3   3 3 3 3 3      
1079 Shake hands with the Taskmaster without revealing your identity 229 Tim Vine 37 0   0              
1084 The sturdiest thing 230 Tim Vine 37 2   2 4 2 2 2      
1089 Work out the length of a piece of string 231 Tim Vine 37 5   5 1 5 5 5      
1094 Remove the tablecloth from underneath the eggs 232 Tim Vine 37 5   5 1= 5 3 3      
1099 Identify the link and do it 100 times 233 Tim Vine 37 5   5 1=     3.57 5 3 3.5
1104 Pull off an elaborate snooker trick shot 234 Tim Vine 37 5   5 1 5 5 5      
1109 Throw eggs onto a shelf 235 Tim Vine 37 4   4 2= 4 3.5 3.75      
1114 The best invention 236 Tim Vine 37 5   5 1 5 5 5      
1119 Make the best snow globe 237 Tim Vine 37 3   3 3= 3 2.5 2.81      
1124 Knock over the ducks without leaving the carpet 238 Tim Vine 37 5   5 1=     5 5 3 3.5
1129 Make the best announcement 239 Tim Vine 37 4   4 2 4 4 4      
1134 Make a parachute for a wooden spoon 240 Tim Vine 37 3   3 3 3 3 3      
1139 Predict how many words you can list for a category 241 Tim Vine 37 3   3 3= 3 2.5 2.81      
1144 The scariest thing from the kitchen 242 Tim Vine 37 1   1 5 1 1 1      
1149 Knock the bails off the stumps 243 Tim Vine 37 4   4 2 4 4 4      
1154 Draw the contents of the box 244 Tim Vine 37 3 1 4 3 3 3 3      
1159 List and then mime obscure animals 245 Tim Vine 37 2   2 2=     2.5 3 2 2.5
1164 Make and eat a pancake with objects tucked into your sweatband 246 Tim Vine 37 5   5 1= 5 4 3.75      
1169 Roll eggs to the centre of the target 247 Tim Vine 37 4   4 2 4 4 4      
1174 The most interesting footwear 248 Tim Vine 37 4   4 2 4 4 4      
1179 Put something surprising inside a chocolate egg 249 Tim Vine 37 4   4 2 4 4 3.33      
1184 Find out what you have in common with a stranger 250 Tim Vine 37 2   2 4= 2 1.5 1.88      
1189 Make a join-the-dots image using stiletto heels 251 Tim Vine 37 5   5 1 5 5 5      
1194 Stick plasters to the correct body parts 252 Tim Vine 37 1   1 5 1 1 1      
1201 The most pleasing cat-sized thing 254 Tim Vine 37 5   5 1 5 5 5      
1206 Make the biggest bubble and burst it with your nose 255 Tim Vine 37 2   2 4 2 2 2      
1211 Perform a number from the Taskmaster musical 256 Tim Vine 37 2   2 2=     2.5 3 2 2.5
1216 Make an outfit with stationery / Guess what pun Tim will make 257 Tim Vine 37 2   2 1 5 5 5      
1221 Make a plastic bag as heavy as possible 258 Tim Vine 37 1   1 5 1 1 1      
1226 Hold the most points above the ground 259 Tim Vine 37 4   4 2= 4 3.5 3.75      
1231 The least appropriate wedding accessory 260 Tim Vine 37 2   2 4 2 2 2      
1236 Knock over the fewest bowling pins 261 Tim Vine 37 1   1 5 1 1 0.938      
1241 Blow out a candle from a distance 262 Tim Vine 37 4   4 2 4 4 4      
1246 Declare your love for the Taskmaster 263 Tim Vine 37 3   3 3 3 3 2.81      
1251 Pick numbers higher and lower than the people next to you 264 Tim Vine 37 3   3 3 3 3 3      

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