ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sheet NameDescription
2
words
Full count of occurances of synonyms for "said" for the three main characters, as either "Harry said" or "said Harry", sorted alphabetically
3
words_sorted
Same counts, sorted by number of occurances per character
4
words_normalized
Same counts, normalized to account for the fact that Harry speaks about twice as much as Hermione or Ron
5
most_common
Filtered list showing counts for words spoken more often by one character than by either of the other two (using normalized counts), sorted alphabetically, by count, and by percentage of occurances by that character
6
unique
Filtered list showing counts for words spoken only by one character, sorted alphabetically and by count
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100