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

✎ 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½
1256 The thing most people want to touch 265 Rhod Gilbert 42 4   4 2 4 4 4      
1261 Make the best quick-change outfit 266 Rhod Gilbert 42 3   3 3 3 3 3      
1266 Build the tallest cardboard box tower 267 Rhod Gilbert 42 5   5 1 5 5 5      
1271 Work out the perimeter of the caravan in beans 268 Rhod Gilbert 42 2   2 4 2 2 2      
1276 Make the most exotic fruit hat 269 Rhod Gilbert 42 5   5 1 5 5 4.17      
1281 The boldest belt 270 Rhod Gilbert 42 5   5 1 5 5 5      
1286 Write a ten word story while running 271 Rhod Gilbert 42 1   1 5 1 1 1      
1291 Paint a blindfolded still life 272 Rhod Gilbert 42 3   3 1=     3.46 5 3 3.5
1296 Predict what another contestant will do with an object 273 Rhod Gilbert 42 5   5 2= 4 2.5 2.5      
1301 Draw the biggest and best circle 274 Rhod Gilbert 42 4   4 2 4 4 4      
1306 Build a tower of cans within a hoop 275 Rhod Gilbert 42 4   4 2 4 4 4      
1313 The best thing from the 90s 277 Rhod Gilbert 42
DQ
   0              
1318 Raise Alex’s heart rate 278 Rhod Gilbert 42 2   2 4 2 2 2      
1323 Make the best noise 279 Rhod Gilbert 42 1   1 5 1 1 1      
1328 Get the ball into the hole by striking it 280 Rhod Gilbert 42 5   5 1 5 5 5      
1333 Silently mouth a ten word fact to Greg 281 Rhod Gilbert 42 1   1 5 1 1 0.938      
1338 The most confusing thing 282 Rhod Gilbert 42 3   3 3 3 3 3      
1343 Work out what the switch does 283 Rhod Gilbert 42 1   1 5 1 1 1      
1348 Change your appearance in a lift 284 Rhod Gilbert 42 5   5 1 5 5 5      
1353 Make the scales read exactly 31.770kg 285 Rhod Gilbert 42 4   4 2 4 4 4      
1358 Get dressed while wearing handcuffs 286 Rhod Gilbert 42 4   4 2= 4 3 3.33      
1360 Make the best toilet paper plane 287 Rhod Gilbert 42 0   0              
1365 The worst gift from a relative 288 Rhod Gilbert 42 4   4 2 4 4 4      
1370 Spectacularly deliver the task to Alex 289 Rhod Gilbert 42 4   4 2 4 4 4      
1375 Make the most white circles on the target 290 Rhod Gilbert 42 5   5 1= 5 3.5 3.75      
1380 Cheer up the traffic warden 291 Rhod Gilbert 42 2   2 4 2 2 1.88      
1385 Make yourselves appear as large or small as possible 292 Rhod Gilbert 42 3   3 1=     3.46 5 3 3.5
1390 Place objects on the hanger without it falling 293 Rhod Gilbert 42 0   0              
1395 The best key 294 Rhod Gilbert 42 3   3 3 3 3 3      
1400 Put 50 different things in the bin 295 Rhod Gilbert 42 3   3 3 3 3 3      
1405 Make a portrait of the Taskmaster using your 50 items 296 Rhod Gilbert 42 4   4 2 4 4 4      
1410 Make a soap opera cliffhanger 297 Rhod Gilbert 42 3   3 1=     3.46 5 3 3.5
1415 Place 10 pairs of glasses into the smallest box 298 Rhod Gilbert 42
DQ
   0              
1420 Get your inflatable ring as high as possible 299 Rhod Gilbert 42 5   5 1 5 5 5      
1425 The most exciting thing beginning with 'G' 300 Rhod Gilbert 42 2   2 1= 5 4.5 4.29      
1430 Throw something into the bin behind the fence 301 Rhod Gilbert 42 5   5 1 5 5 5      
1435 Don’t blink 302 Rhod Gilbert 42 5   5 1 5 5 5      
1440 Build an extension to the Taskmaster house 303 Rhod Gilbert 42 1   1 2=     1.25 3 2 2.5
1445 Make the best Christmas cracker 304 Rhod Gilbert 42 3   3 2= 4 2.5 2.65      
1450 Beat on the drum after exactly 9.58 seconds 305 Rhod Gilbert 42 5   5 1 5 5 5      
1455 The creepiest thing 306 Rhod Gilbert 42 5   5 1= 5 4.5 4.41      
1460 Poke something unexpected through the hole 307 Rhod Gilbert 42 5   5 1 5 5 5      
1465 Follow the clues and then do what they spell 308 Rhod Gilbert 42 1   1 5 1 1 1      
1470 Compose a 30 second piece of music 309 Rhod Gilbert 42 4   4 2= 4 3.5 3.33      
1475 Bob, pat, kneel, stew, or wane 310 Rhod Gilbert 42 5   5 1 5 5 5      
1480 The most surprisingly beautiful thing 311 Rhod Gilbert 42 1   1 5 1 1 1      
1485 Put the largest numeric value of money in the floating bowl 312 Rhod Gilbert 42
DQ
   0              
1490 Take a photo of yourself in a fez / Improve your hula-hooping 313 Rhod Gilbert 42 1   1 4= 2 1.5 1.67      
1495 Find the satsuma in a sock 314 Rhod Gilbert 42 4   4 1= 5 4.5 4.62      
1500 Complete a 24-shot rally 315 Rhod Gilbert 42
DQ
 1 1              
1505 Draw a happy horse upside-down 316 Rhod Gilbert 42 2   2 5 1 1 1.67      
1510 The most magnificent stationery 317 Rhod Gilbert 42 1   1 5 1 1 1      
1515 Put on overalls and lie on the ground when the siren sounds 318 Rhod Gilbert 42 4   4 2 4 4 4      
1520 Find the hard-boiled egg 319 Rhod Gilbert 42
DQ
   0              
1525 Recreate a classic video game 320 Rhod Gilbert 42 4   4 2 4 4 3.53      
1530 Tie yourself up as securely as possible 321 Rhod Gilbert 42 5   5 1 5 5 5      
1535 Sausage or finger? 322 Rhod Gilbert 42 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
);