Spreadsheet: 85192d1285243670-count-unique-phrase-example-spreadsheet
Sheet: Ark1

 |  |  |  |  | the number of times the phrase "device found" is found in each hour of each day
Radetiketter | Summer av CountUnique | Summer av Retry |  |  | Radetiketter | Summer av device found
00:03:81:bf:52:b9 | 1 | 4 |  |  | 2010.08.01 10 | 67
00:11:9f:03:1a:64 | 1 | 1 |  |  | 2010.08.01 11 | 109
00:12:40:53:99:07 | 1 | 0 |  |  | Totalsum | 176
00:12:47:00:00:01 | 1 | 4
00:12:d1:4a:ef:3a | 1 | 0
00:13:fd:75:05:fd | 1 | 0
00:19:4f:70:aa:29 | 1 | 0 |  |  | x number of 1 RETRY, y number of 2 RETRY, z numbers of RETRY etc etc
00:19:b7:85:9c:41 | 1 | 2 |  |  | Number of retries
00:1b:33:43:25:16 | 1 | 1 |  | 1
00:1b:33:71:56:41 | 1 | 1 |  | 2
00:1c:35:56:0d:4f | 1 | 5 |  | 3
00:1c:9a:ed:51:c1 | 1 | 1 |  | 4
00:1c:a4:69:15:f9 | 1 | 1 |  | 5
00:1c:d6:0c:b4:68 | 1 | 2 |  | 6
00:1d:3b:bc:36:fc | 1 | 1 |  | 7
00:1d:98:5b:d4:52 | 1 | 0 |  | 8
00:1d:e9:e9:3e:fe | 1 | 1 |  | 9
00:1d:f6:c9:c1:2f | 1 | 0 |  | 10
00:1e:3b:3b:4f:a4 | 1 | 0
00:1e:45:18:c0:7d | 1 | 0
00:1e:a3:04:3f:21 | 1 | 1
00:1e:e2:69:04:bd | 1 | 1
00:1f:00:2b:aa:54 | 1 | 1
00:1f:5c:90:80:3e | 1 | 1
00:21:08:06:09:fe | 1 | 1
00:21:08:1a:97:e2 | 1 | 1
00:21:09:d6:a6:5f | 1 | 6
00:21:d2:5f:6e:ff | 1 | 2
00:21:fb:ea:c9:5e | 1 | 0
00:21:fc:79:[NAME] | 1 | 0
00:21:fe:a6:b9:7e | 1 | 0
00:21:fe:be:5a:41 | 1 | 1
00:22:98:33:75:9c | 1 | 1
00:22:a9:4d:a4:90 | 1 | 2
00:22:a9:d8:98:0e | 1 | 3
00:22:fc:e3:[NAME] | 1 | 0
00:22:fd:14:0c:02 | 1 | 3
00:22:fd:98:46:58 | 1 | 0
00:23:3a:19:4e:90 | 1 | 0
00:23:3a:65:cb:13 | 1 | 1
00:23:3a:de:52:ee | 1 | 1
00:23:45:eb:a6:31 | 1 | 1
00:23:7a:7e:9e:68 | 1 | 0
00:23:d6:85:8a:d7 | 1 | 1
00:23:d6:b7:42:cd | 1 | 1
00:23:d6:c2:38:9e | 1 | 1
00:23:d7:0f:26:25 | 1 | 2
00:23:f1:d3:ed:[NAME] | 1 | 0
00:23:f1:e5:0d:53 | 1 | 1
00:24:03:1c:72:f4 | 1 | 0
00:24:03:57:fa:57 | 1 | 1
[NAME]:be:aa:0b | 1 | 1
00:24:03:c5:3b:7d | 1 | 0
00:24:04:9c:43:96 | 1 | 0
00:24:7c:fc:f9:7f | 1 | 0
00:24:7d:35:8a:cf | 1 | 1
00:24:7d:68:4f:63 | 1 | 0
00:24:83:1c:e0:0b | 1 | 1
00:24:83:bd:6b:6b | 1 | 1
00:24:83:cb:6a:b1 | 1 | 0
[NAME] | 1 | 1
00:24:90:7b:[NAME] | 1 | 2
00:24:90:a7:96:1a | 1 | 1
00:24:9f:38:4a:90 | 1 | 0
00:24:ef:03:93:a1 | 1 | 0
00:24:ef:48:10:71 | 1 | 2
00:25:47:32:b7:c7 | 1 | 5
[NAME]:[NAME] | 1 | 2
00:25:67:65:bd:93 | 1 | 1
00:25:67:[NAME] | 1 | 1
00:25:67:ed:a7:ea | 1 | 1
00:25:e5:1f:49:2b | 1 | 0
00:25:e7:0f:4e:15 | 1 | 0
00:26:5d:ba:93:a9 | 1 | 1
00:26:5d:d7:81:b0 | 1 | 1
00:26:5d:f3:53:d2 | 1 | 0
00:26:69:5b:a0:fa | 1 | 1
00:26:69:7f:42:43 | 1 | 0
00:26:e2:45:86:2e | 1 | 1
00:26:ff:c5:ea:4e | 1 | 0
18:86:ac:1d:41:71 | 1 | 1
18:86:ac:c4:27:23 | 1 | 1
24:21:ab:15:b1:77 | 1 | 1
24:21:ab:4f:62:fc | 1 | 1
24:21:ab:ad:a0:3e | 1 | 1
30:7c:30:df:84:70 | 1 | 2
34:c3:ac:bf:30:53 | 1 | 1
3c:f7:2a:77:e2:c8 | 1 | 1
3c:f7:2a:9b:5a:3d | 1 | 1
44:a4:2d:10:0a:a9 | 1 | 0
44:f4:59:52:b3:43 | 1 | 2
44:[NAME]:b9:[NAME] | 1 | 0
4c:54:99:0f:d8:02 | 1 | 0
54:92:be:0b:3c:89 | 1 | 1
54:92:be:77:e0:b3 | 1 | 1
68:eb:ae:e5:99:05 | 1 | 2
6c:0e:0d:0c:ac:2d | 1 | 3
6c:0e:0d:12:fa:aa | 1 | 5
80:50:1b:87:c6:ef | 1 | 0
9c:18:74:f1:9d:1a | 1 | 1
9c:18:74:f2:ee:58 | 1 | 1
a0:07:98:1c:70:3f | 1 | 1
a0:4e:04:17:3a:76 | 1 | 0
a8:7e:33:92:7d:a6 | 1 | 0
[NAME]:f2:74:0b:97:a1 | 1 | 1
c0:38:f9:[NAME] | 1 | 1
c0:38:f9:be:15:42 | 1 | 1
c0:38:f9:e0:6d:bf | 1 | 0
c8:7e:75:07:14:7a | 1 | 0
c8:7e:75:a3:a9:76 | 1 | 1
c8:7e:75:a8:4c:10 | 1 | 1
c8:7e:75:b6:88:df | 1 | 0
c8:7e:75:e4:[NAME] | 1 | 2
c8:7e:75:f3:75:d8 | 1 | 1
e8:e5:d6:41:54:5f | 1 | 0
ec:9b:5b:7f:5c:85 | 1 | 0
ec:9b:5b:b4:d7:4f | 1 | 1
f4:0b:93:e6:37:83 | 1 | 0
Totalsum | 118 | 118 | number of unique serial numbers within the document