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

3,975 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: base, adjustment, points, rank, rigid, spread, 5+3, 3+2, 3½+2½

id ▲ task contestant base ± points rank rigid spread scale 5+3 3+2 3½+2½
1 The most unusual item 1 Frank Skinner 3 4   4 2 4 4 4      
2 The most unusual item 1 Josh Widdicombe 4 1   1 5 1 1 1      
3 The most unusual item 1 Roisin Conaty 5 2   2 4 2 2 2      
4 The most unusual item 1 Romesh Ranganathan 6 3   3 3 3 3 3      
5 The most unusual item 1 Tim Key 7 5   5 1 5 5 5      
6 Eat as much watermelon as possible 2 Frank Skinner 3 2   2 4 2 2 2      
7 Eat as much watermelon as possible 2 Josh Widdicombe 4 3   3 3 3 3 3      
8 Eat as much watermelon as possible 2 Roisin Conaty 5 1   1 5 1 1 1      
9 Eat as much watermelon as possible 2 Romesh Ranganathan 6 5   5 1 5 5 5      
10 Eat as much watermelon as possible 2 Tim Key 7 4   4 2 4 4 4      
11 Paint a horse while riding a horse 3 Frank Skinner 3 5   5 1 5 5 5      
12 Paint a horse while riding a horse 3 Josh Widdicombe 4 3   3 3 3 3 3      
13 Paint a horse while riding a horse 3 Roisin Conaty 5 1   1 5 1 1 1      
14 Paint a horse while riding a horse 3 Romesh Ranganathan 6 4   4 2 4 4 4      
15 Paint a horse while riding a horse 3 Tim Key 7 2   2 4 2 2 2      
16 Empty the bathtub 4 Frank Skinner 3 4   4 2 4 4 4      
17 Empty the bathtub 4 Josh Widdicombe 4 3   3 3 3 3 3      
18 Empty the bathtub 4 Roisin Conaty 5 2   2 4 2 2 2      
19 Empty the bathtub 4 Romesh Ranganathan 6 5   5 1 5 5 5      
20 Empty the bathtub 4 Tim Key 7 1   1 5 1 1 1      
21 Pop up a tent and pop on a onesie 5 Frank Skinner 3 4   4 2 4 4 4      
22 Pop up a tent and pop on a onesie 5 Josh Widdicombe 4 3   3 3 3 3 3      
23 Pop up a tent and pop on a onesie 5 Roisin Conaty 5 1   1 5 1 1 1      
24 Pop up a tent and pop on a onesie 5 Romesh Ranganathan 6 2   2 4 2 2 2      
25 Pop up a tent and pop on a onesie 5 Tim Key 7 5   5 1 5 5 5      
26 Find Alex 6 Frank Skinner 3 0   0              
27 Find Alex 6 Romesh Ranganathan 6 0   0              
28 The most impressive item 7 Frank Skinner 3 4   4 2 4 4 4      
29 The most impressive item 7 Josh Widdicombe 4 2   2 4 2 2 2      
30 The most impressive item 7 Roisin Conaty 5 3   3 3 3 3 3      
31 The most impressive item 7 Romesh Ranganathan 6 1   1 5 1 1 1      
32 The most impressive item 7 Tim Key 7 5   5 1 5 5 5      
33 High-five a 55-year-old 8 Frank Skinner 3 2   2 4 2 2 2      
34 High-five a 55-year-old 8 Josh Widdicombe 4 5   5 1 5 5 5      
35 High-five a 55-year-old 8 Roisin Conaty 5 4   4 2 4 4 4      
36 High-five a 55-year-old 8 Romesh Ranganathan 6 1   1 5 1 1 1      
37 High-five a 55-year-old 8 Tim Key 7 3   3 3 3 3 3      
38 Identify the contents of the pies 9 Frank Skinner 3 1   1 5 1 1 1      
39 Identify the contents of the pies 9 Josh Widdicombe 4 2   2 4 2 2 2      
40 Identify the contents of the pies 9 Roisin Conaty 5 4   4 2 4 4 4      
41 Identify the contents of the pies 9 Romesh Ranganathan 6 3   3 3 3 3 3      
42 Identify the contents of the pies 9 Tim Key 7 5   5 1 5 5 5      
43 Do something that will look impressive in reverse 10 Frank Skinner 3 1   1 5 1 1 0.833      
44 Do something that will look impressive in reverse 10 Josh Widdicombe 4 4   4 3 3 3 3.33      
45 Do something that will look impressive in reverse 10 Roisin Conaty 5 5   5 1= 5 4.5 4.17      
46 Do something that will look impressive in reverse 10 Romesh Ranganathan 6 5   5 1= 5 4.5 4.17      
47 Do something that will look impressive in reverse 10 Tim Key 7 3   3 4 2 2 2.5      
48 Unshackle yourself and sprint one metre 11 Frank Skinner 3 1   1 5 1 1 1      
49 Unshackle yourself and sprint one metre 11 Josh Widdicombe 4 3   3 3 3 3 3      
50 Unshackle yourself and sprint one metre 11 Roisin Conaty 5 5   5 1 5 5 5      
51 Unshackle yourself and sprint one metre 11 Romesh Ranganathan 6 4   4 2 4 4 4      
52 Unshackle yourself and sprint one metre 11 Tim Key 7 2   2 4 2 2 2      
53 The most meaningful item 12 Frank Skinner 3 4   4 2 4 4 4      
54 The most meaningful item 12 Josh Widdicombe 4 2   2 4 2 2 2      
55 The most meaningful item 12 Roisin Conaty 5 1   1 5 1 1 1      
56 The most meaningful item 12 Romesh Ranganathan 6 5   5 1 5 5 5      
57 The most meaningful item 12 Tim Key 7 3   3 3 3 3 3      
58 Throw a teabag into a mug 13 Frank Skinner 3 4   4 2 4 4 4      
59 Throw a teabag into a mug 13 Josh Widdicombe 4
DQ
   0              
60 Throw a teabag into a mug 13 Roisin Conaty 5 2   2 4 2 2 2      
61 Throw a teabag into a mug 13 Romesh Ranganathan 6 3   3 3 3 3 3      
62 Throw a teabag into a mug 13 Tim Key 7 5   5 1 5 5 5      
63 Draw an image using a GPS device 14 Frank Skinner 3 2   2 4 2 2 2      
64 Draw an image using a GPS device 14 Josh Widdicombe 4 5   5 1 5 5 5      
65 Draw an image using a GPS device 14 Roisin Conaty 5 1   1 5 1 1 1      
66 Draw an image using a GPS device 14 Romesh Ranganathan 6 4   4 2 4 4 4      
67 Draw an image using a GPS device 14 Tim Key 7 3   3 3 3 3 3      
68 Buy a gift for the Taskmaster 15 Frank Skinner 3 3   3 3 3 3 3      
69 Buy a gift for the Taskmaster 15 Josh Widdicombe 4 5   5 1 5 5 5      
70 Buy a gift for the Taskmaster 15 Roisin Conaty 5 4   4 2 4 4 4      
71 Buy a gift for the Taskmaster 15 Romesh Ranganathan 6 2   2 4 2 2 2      
72 Buy a gift for the Taskmaster 15 Tim Key 7 1   1 5 1 1 1      
73 Get an egg as high as possible 16 Frank Skinner 3 0   0              
74 Get an egg as high as possible 16 Josh Widdicombe 4 5   5 1 5 5 5      
75 Get an egg as high as possible 16 Roisin Conaty 5 0   0              
76 Get an egg as high as possible 16 Romesh Ranganathan 6 4   4 2 4 4 4      
77 Get an egg as high as possible 16 Tim Key 7 0   0              
78 Stand up after 100 seconds 17 Frank Skinner 3 2   2 4 2 2 1.88      
79 Stand up after 100 seconds 17 Josh Widdicombe 4 5   5 1 5 5 4.69      
80 Stand up after 100 seconds 17 Roisin Conaty 5 1   1 5 1 1 0.938      
81 Stand up after 100 seconds 17 Romesh Ranganathan 6 4   4 2= 4 3.5 3.75      
82 Stand up after 100 seconds 17 Tim Key 7 4   4 2= 4 3.5 3.75      
83 Guess Frank’s age in minutes 18 Josh Widdicombe 4 0   0              
84 Guess Frank’s age in minutes 18 Romesh Ranganathan 6 0   0              
85 The most beautiful item 19 Frank Skinner 3 3   3 3 3 3 3      
86 The most beautiful item 19 Josh Widdicombe 4 4   4 2 4 4 4      
87 The most beautiful item 19 Roisin Conaty 5 2   2 4 2 2 2      
88 The most beautiful item 19 Romesh Ranganathan 6 1   1 5 1 1 1      
89 The most beautiful item 19 Tim Key 7 5   5 1 5 5 5      
90 Make a block of ice disappear 20 Frank Skinner 3 4   4 2 4 4 4      
91 Make a block of ice disappear 20 Josh Widdicombe 4 5   5 1 5 5 5      
92 Make a block of ice disappear 20 Roisin Conaty 5 3   3 3 3 3 3      
93 Make a block of ice disappear 20 Romesh Ranganathan 6 2   2 4 2 2 2      
94 Make a block of ice disappear 20 Tim Key 7 1   1 5 1 1 1      
95 Count the baked beans 21 Josh Widdicombe 4 0 1 1              
96 Count the spaghetti hoops 22 Josh Widdicombe 4 0   0              
97 Score 11 points 23 Frank Skinner 3 0 1 1              
98 Score 11 points 23 Josh Widdicombe 4 2   2 1=     5 5 3 3.5
99 Score 11 points 23 Roisin Conaty 5 2   2 1=     5 5 3 3.5
100 Score 11 points 23 Romesh Ranganathan 6 2   2 1=     5 5 3 3.5

Next page

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