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

56 rows where contestant = 41

✎ 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½
1255 The thing most people want to touch 265 Phil Wang 41 5   5 1 5 5 5      
1260 Make the best quick-change outfit 266 Phil Wang 41 1   1 5 1 1 1      
1265 Build the tallest cardboard box tower 267 Phil Wang 41 2   2 4 2 2 2      
1270 Work out the perimeter of the caravan in beans 268 Phil Wang 41 1   1 5 1 1 1      
1275 Make the most exotic fruit hat 269 Phil Wang 41 4   4 2= 4 3.5 3.33      
1280 The boldest belt 270 Phil Wang 41 4   4 2 4 4 4      
1285 Write a ten word story while running 271 Phil Wang 41 2   2 4 2 2 2      
1290 Paint a blindfolded still life 272 Phil Wang 41 3   3 1=     3.46 5 3 3.5
1295 Predict what another contestant will do with an object 273 Phil Wang 41 5   5 2= 4 2.5 2.5      
1300 Draw the biggest and best circle 274 Phil Wang 41 2   2 4 2 2 2      
1305 Build a tower of cans within a hoop 275 Phil Wang 41 3   3 3 3 3 3      
1312 The best thing from the 90s 277 Phil Wang 41 3   3 3 3 3 3      
1317 Raise Alex’s heart rate 278 Phil Wang 41 1   1 5 1 1 1      
1322 Make the best noise 279 Phil Wang 41 5   5 1 5 5 5      
1327 Get the ball into the hole by striking it 280 Phil Wang 41 4   4 2 4 4 4      
1332 Silently mouth a ten word fact to Greg 281 Phil Wang 41 2   2 4 2 2 1.88      
1337 The most confusing thing 282 Phil Wang 41 4   4 2 4 4 4      
1342 Work out what the switch does 283 Phil Wang 41 3   3 3 3 3 3      
1347 Change your appearance in a lift 284 Phil Wang 41 2   2 4 2 2 2      
1352 Make the scales read exactly 31.770kg 285 Phil Wang 41 2   2 4 2 2 2      
1357 Get dressed while wearing handcuffs 286 Phil Wang 41 1   1 5 1 1 0.833      
1364 The worst gift from a relative 288 Phil Wang 41 1   1 5 1 1 1      
1369 Spectacularly deliver the task to Alex 289 Phil Wang 41 2   2 4 2 2 2      
1374 Make the most white circles on the target 290 Phil Wang 41 0   0              
1379 Cheer up the traffic warden 291 Phil Wang 41 3   3 3 3 3 2.81      
1384 Make yourselves appear as large or small as possible 292 Phil Wang 41 3   3 1=     3.46 5 3 3.5
1389 Place objects on the hanger without it falling 293 Phil Wang 41 0   0              
1394 The best key 294 Phil Wang 41 2   2 4 2 2 2      
1399 Put 50 different things in the bin 295 Phil Wang 41 1 1 2 5 1 1 1      
1404 Make a portrait of the Taskmaster using your 50 items 296 Phil Wang 41 1   1 5 1 1 1      
1409 Make a soap opera cliffhanger 297 Phil Wang 41 3   3 1=     3.46 5 3 3.5
1414 Place 10 pairs of glasses into the smallest box 298 Phil Wang 41 5   5 1 5 5 5      
1419 Get your inflatable ring as high as possible 299 Phil Wang 41 4   4 2 4 4 4      
1424 The most exciting thing beginning with 'G' 300 Phil Wang 41 1   1 3= 3 2 2.14      
1429 Throw something into the bin behind the fence 301 Phil Wang 41 4   4 2 4 4 4      
1434 Don’t blink 302 Phil Wang 41 2   2 4 2 2 2      
1439 Build an extension to the Taskmaster house 303 Phil Wang 41 1   1 2=     1.25 3 2 2.5
1444 Make the best Christmas cracker 304 Phil Wang 41 5   5 1 5 5 4.41      
1449 Beat on the drum after exactly 9.58 seconds 305 Phil Wang 41 2   2 4 2 2 2      
1454 The creepiest thing 306 Phil Wang 41 1   1 5 1 1 0.882      
1459 Poke something unexpected through the hole 307 Phil Wang 41 2   2 3= 3 2 2      
1464 Follow the clues and then do what they spell 308 Phil Wang 41 2   2 4 2 2 2      
1469 Compose a 30 second piece of music 309 Phil Wang 41 2   2 5 1 1 1.67      
1474 Bob, pat, kneel, stew, or wane 310 Phil Wang 41 2   2 4 2 2 2      
1479 The most surprisingly beautiful thing 311 Phil Wang 41 5   5 1 5 5 5      
1484 Put the largest numeric value of money in the floating bowl 312 Phil Wang 41
DQ
   0              
1489 Take a photo of yourself in a fez / Improve your hula-hooping 313 Phil Wang 41 1   1 4= 2 1.5 1.67      
1494 Find the satsuma in a sock 314 Phil Wang 41 0   0              
1499 Complete a 24-shot rally 315 Phil Wang 41
DQ
 1 1              
1504 Draw a happy horse upside-down 316 Phil Wang 41 4   4 2= 4 3.5 3.33      
1509 The most magnificent stationery 317 Phil Wang 41 4   4 2 4 4 4      
1514 Put on overalls and lie on the ground when the siren sounds 318 Phil Wang 41 5   5 1 5 5 5      
1519 Find the hard-boiled egg 319 Phil Wang 41
DQ
   0              
1524 Recreate a classic video game 320 Phil Wang 41 3   3 3= 3 2.5 2.65      
1529 Tie yourself up as securely as possible 321 Phil Wang 41 1   1 5 1 1 1      
1534 Sausage or finger? 322 Phil Wang 41 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
);