A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||
2 | ||||||||||||||||||||||||
3 | ||||||||||||||||||||||||
4 | Total Tokens for bounty campaign | 1019450 | ||||||||||||||||||||||
5 | Allocated for Facebook campaign (20%) | 203890 | ||||||||||||||||||||||
6 | ||||||||||||||||||||||||
7 | Total Stakes in Facebook bounty: | 6074 | ||||||||||||||||||||||
8 | Tokens per Stake: | 33.56766546 | ||||||||||||||||||||||
9 | ||||||||||||||||||||||||
10 | ||||||||||||||||||||||||
11 | Total Stakes per week | |||||||||||||||||||||||
12 | week 1 | 330 | ||||||||||||||||||||||
13 | week 2 | 421 | ||||||||||||||||||||||
14 | week 3 | 550 | ||||||||||||||||||||||
15 | week 4 | 584 | ||||||||||||||||||||||
16 | week 5 | 712 | ||||||||||||||||||||||
17 | week 6 | 815 | ||||||||||||||||||||||
18 | week 7 | 673 | Notes for the spreadsheet: | |||||||||||||||||||||
19 | week 8 | 698 | Google Docs: UNIQUE is case sensitive, SUMIF is not! | |||||||||||||||||||||
20 | week 9 | 675 | A work around is to use ArrayFormula with FIND instead of SUMIF | |||||||||||||||||||||
21 | week 10 | 616 | However, this requires leading and trailing spaces to be removed from the ETH Address: TRIM | |||||||||||||||||||||
22 | Total Stakes in Facebook bounty | 6074 | Easy solution: make all addresses lower case, Ethereum addresses are not case sensitive | |||||||||||||||||||||
23 | ||||||||||||||||||||||||
24 | Full list of addresses (made lower case), stakes and tokens from Week 1-10 | Full list of unique addresses, with the sum of their stakes and tokens | ||||||||||||||||||||||
25 | ETH Address | Stakes | Tokens | ETH Address | Stakes | Tokens | ||||||||||||||||||
26 | week 1 | 0xd77a4fbff64f158abc12dead6622574e77b56b13 | 1 | 33.56766546 | 0xd77a4fbff64f158abc12dead6622574e77b56b13 | 1 | 33.56766546 | |||||||||||||||||
27 | 0x3af379098907a9a61db7f97cbb777e6fb53ebb1f | 0 | 0x3af379098907a9a61db7f97cbb777e6fb53ebb1f | 1 | 33.56766546 | |||||||||||||||||||
28 | 0xffa31b81129d0d5d98cd016b6e3aa4f7437e79df | 1 | 33.56766546 | 0xffa31b81129d0d5d98cd016b6e3aa4f7437e79df | 4 | 134.2706618 | ||||||||||||||||||
29 | 0x346a87f77bedf4143e429ef0f77a8b1fdb74c8d1 | 0 | 0x346a87f77bedf4143e429ef0f77a8b1fdb74c8d1 | 4 | 134.2706618 | |||||||||||||||||||
30 | 0xe396146a7070472a544d5d71710be9e55e95e98a | 1 | 33.56766546 | 0xe396146a7070472a544d5d71710be9e55e95e98a | 1 | 33.56766546 | ||||||||||||||||||
31 | 0x70c0ad4cdee3fff66a417519732de20b462e6e73 | 1 | 33.56766546 | 0x70c0ad4cdee3fff66a417519732de20b462e6e73 | 1 | 33.56766546 | ||||||||||||||||||
32 | 0x3a98daa3daa51e3b2266a776a5a7e8dc8b735500 | 0 | 0x3a98daa3daa51e3b2266a776a5a7e8dc8b735500 | 0 | 0 | |||||||||||||||||||
33 | 0xf87e1f06097be4f5a426394b8bfd57d022d8e80a | 0 | 0xf87e1f06097be4f5a426394b8bfd57d022d8e80a | 0 | 0 | |||||||||||||||||||
34 | 0x69f7f3212ac4baffcadb62777ad4d9d8df35f256 | 1 | 33.56766546 | 0x69f7f3212ac4baffcadb62777ad4d9d8df35f256 | 1 | 33.56766546 | ||||||||||||||||||
35 | 0x6a3da4029b76778dc33b9492ac5d023e4702f5e6 | 1 | 33.56766546 | 0x6a3da4029b76778dc33b9492ac5d023e4702f5e6 | 1 | 33.56766546 | ||||||||||||||||||
36 | 0xe673efd9d4518a96a7bd734e8658eb44a0688ce2 | 1 | 33.56766546 | 0xe673efd9d4518a96a7bd734e8658eb44a0688ce2 | 5 | 167.8383273 | ||||||||||||||||||
37 | 0xdf362413e0125a93c57c31472f5cc02bebb99306 | 0 | 0xdf362413e0125a93c57c31472f5cc02bebb99306 | 3 | 100.7029964 | |||||||||||||||||||
38 | 0x34218baf88ea69136bbae587b0e58e31d47c11ac | 1 | 33.56766546 | 0x34218baf88ea69136bbae587b0e58e31d47c11ac | 1 | 33.56766546 | ||||||||||||||||||
39 | 0xb623472a00418b5beb57e3e662382acc75654fef | 1 | 33.56766546 | 0xb623472a00418b5beb57e3e662382acc75654fef | 5 | 167.8383273 | ||||||||||||||||||
40 | 0x36585cd03fea628ecdebb59188de95cc585742fa | 0 | 0x36585cd03fea628ecdebb59188de95cc585742fa | 7 | 234.9736582 | |||||||||||||||||||
41 | 0xcb045ca0121be769cf552b890f8be56129469edb | 1 | 33.56766546 | 0xcb045ca0121be769cf552b890f8be56129469edb | 1 | 33.56766546 | ||||||||||||||||||
42 | 0x931e9dd50640fc99bd715517c3b28d6190954262 | 1 | 33.56766546 | 0x931e9dd50640fc99bd715517c3b28d6190954262 | 10 | 335.6766546 | ||||||||||||||||||
43 | 0xb682eebddd59119b8f446787905303b3c0511478 | 1 | 33.56766546 | 0xb682eebddd59119b8f446787905303b3c0511478 | 9 | 302.1089891 | ||||||||||||||||||
44 | 0x3c982ffaa627ede3d539bbcb1f88758fa365a506 | 1 | 33.56766546 | 0x3c982ffaa627ede3d539bbcb1f88758fa365a506 | 2 | 67.13533092 | ||||||||||||||||||
45 | 0x775afd2f9babd405d087d7bc32ebffa477de3b9f | 1 | 33.56766546 | 0x775afd2f9babd405d087d7bc32ebffa477de3b9f | 10 | 335.6766546 | ||||||||||||||||||
46 | 0xe79c5b9eb5e0fdc872f9754d7ea838dcd933617b | 1 | 33.56766546 | 0xe79c5b9eb5e0fdc872f9754d7ea838dcd933617b | 2 | 67.13533092 | ||||||||||||||||||
47 | 0x9d0915e1e7371a0e1af32380ad2493f86c687725 | 0 | 0x9d0915e1e7371a0e1af32380ad2493f86c687725 | 0 | 0 | |||||||||||||||||||
48 | 0x304ea31797c54cb936fd5acb5f6340700791afe7 | 1 | 33.56766546 | 0x304ea31797c54cb936fd5acb5f6340700791afe7 | 3 | 100.7029964 | ||||||||||||||||||
49 | 0x3424bc356fd2d2d666c4a66df4e26970b5c030dd | 0 | 0x3424bc356fd2d2d666c4a66df4e26970b5c030dd | 0 | 0 | |||||||||||||||||||
50 | 0x54e394f94a1917463d77eccd446ff7a0b443e0b4 | 0 | 0x54e394f94a1917463d77eccd446ff7a0b443e0b4 | 0 | 0 | |||||||||||||||||||
51 | 0x9c1184394b7ff89374393dc54428086a15ce53ed | 1 | 33.56766546 | 0x9c1184394b7ff89374393dc54428086a15ce53ed | 1 | 33.56766546 | ||||||||||||||||||
52 | 0x3b1e89f91934c78772b9cbc486650681fc965394 | 1 | 33.56766546 | 0x3b1e89f91934c78772b9cbc486650681fc965394 | 9 | 302.1089891 | ||||||||||||||||||
53 | 0x4e11c0e0a6f200907e8d6b9904cba58304c9976e | 1 | 33.56766546 | 0x4e11c0e0a6f200907e8d6b9904cba58304c9976e | 2 | 67.13533092 | ||||||||||||||||||
54 | 0xb5deee5b4d72c8c8c6f5d013b266e7b0757edd89 | 1 | 33.56766546 | 0xb5deee5b4d72c8c8c6f5d013b266e7b0757edd89 | 1 | 33.56766546 | ||||||||||||||||||
55 | 0x51bff6f116cd1d9bffb0248a669bbd86635d92f8 | 1 | 33.56766546 | 0x51bff6f116cd1d9bffb0248a669bbd86635d92f8 | 1 | 33.56766546 | ||||||||||||||||||
56 | 0x2744e0ed95ee0e94ed6f941a8f3c64c7e1737816 | 1 | 33.56766546 | 0x2744e0ed95ee0e94ed6f941a8f3c64c7e1737816 | 1 | 33.56766546 | ||||||||||||||||||
57 | 0xc3ce837823dbc543303c88eac388ab9b345d3728 | 0 | 0xc3ce837823dbc543303c88eac388ab9b345d3728 | 0 | 0 | |||||||||||||||||||
58 | 0x9d0915e1e7371a0e1af32380ad2493f86c687725 | 0 | 0x3c52afcfb7d926759f11d613dbe67b695c024a95 | 5 | 167.8383273 | |||||||||||||||||||
59 | 0x3c52afcfb7d926759f11d613dbe67b695c024a95 | 1 | 33.56766546 | 0x3455b77c3961096fe77040adb35cd1207127710f | 5 | 167.8383273 | ||||||||||||||||||
60 | 0x3455b77c3961096fe77040adb35cd1207127710f | 1 | 33.56766546 | 0xe68fe6f54a7137e87694d377351cec1992aa8107 | 1 | 33.56766546 | ||||||||||||||||||
61 | 0xe68fe6f54a7137e87694d377351cec1992aa8107 | 1 | 33.56766546 | 0xc199050dde5b14c2781e90dcbae86a34f052a95b | 1 | 33.56766546 | ||||||||||||||||||
62 | 0xc199050dde5b14c2781e90dcbae86a34f052a95b | 1 | 33.56766546 | 0x199b9a9be3a8769625b59b6cda474d2a4954c61c | 8 | 268.5413237 | ||||||||||||||||||
63 | 0x199b9a9be3a8769625b59b6cda474d2a4954c61c | 1 | 33.56766546 | 0xc27ba127100ce61719352b8f95e568b3aa657441 | 6 | 201.4059928 | ||||||||||||||||||
64 | 0xc27ba127100ce61719352b8f95e568b3aa657441 | 1 | 33.56766546 | 0xc97078d9ecc953a8e263626892da1f17579fa6e6 | 10 | 335.6766546 | ||||||||||||||||||
65 | 0xc97078d9ecc953a8e263626892da1f17579fa6e6 | 1 | 33.56766546 | 0x1f19dc039fc70537bd4b6796fa3f05fd459ce750 | 10 | 335.6766546 | ||||||||||||||||||
66 | 0x1f19dc039fc70537bd4b6796fa3f05fd459ce750 | 1 | 33.56766546 | 0x3fea93d052df8f009811bf7c2ef34d9f8c01df0a | 3 | 100.7029964 | ||||||||||||||||||
67 | 0x3fea93d052df8f009811bf7c2ef34d9f8c01df0a | 0 | 0xb9220ea0fa893dfe15524730b7ab8aebce4ef3c7 | 7 | 234.9736582 | |||||||||||||||||||
68 | 0xb9220ea0fa893dfe15524730b7ab8aebce4ef3c7 | 1 | 33.56766546 | 0xeea5efcb5c021fcda01a8a2546badff5d637d1f8 | 0 | 0 | ||||||||||||||||||
69 | 0xeea5efcb5c021fcda01a8a2546badff5d637d1f8 | 0 | 0x4afe1b1857dd0ff16a4cc46f8be92ab1165e6458 | 1 | 33.56766546 | |||||||||||||||||||
70 | 0x4afe1b1857dd0ff16a4cc46f8be92ab1165e6458 | 1 | 33.56766546 | 0xdbc4f6a615508785098039e259bb7184351653e3 | 5 | 167.8383273 | ||||||||||||||||||
71 | 0xdbc4f6a615508785098039e259bb7184351653e3 | 1 | 33.56766546 | 0x9fbb333c00118948a70b491b23807bd6514ba875 | 7 | 234.9736582 | ||||||||||||||||||
72 | 0x9fbb333c00118948a70b491b23807bd6514ba875 | 1 | 33.56766546 | 0x44c0a9e2ab4429d0c2ead4ae5ea2cfab1649d248 | 7 | 234.9736582 | ||||||||||||||||||
73 | 0x44c0a9e2ab4429d0c2ead4ae5ea2cfab1649d248 | 1 | 33.56766546 | 0xa403b1b7ede70afe902ae6aaf213d8dd49615d58 | 9 | 302.1089891 | ||||||||||||||||||
74 | 0xa403b1b7ede70afe902ae6aaf213d8dd49615d58 | 1 | 33.56766546 | 0x3744baa47228b390c79a8a06df241e48308dd680 | 10 | 335.6766546 | ||||||||||||||||||
75 | 0x3744baa47228b390c79a8a06df241e48308dd680 | 1 | 33.56766546 | 0xa7802ba51ba87556263d84cfc235759b214ccf35 | 9 | 302.1089891 | ||||||||||||||||||
76 | 0xa7802ba51ba87556263d84cfc235759b214ccf35 | 1 | 33.56766546 | 0xe53723c804efda69632aeb53ec6c41ce7dbc8d2b | 6 | 201.4059928 | ||||||||||||||||||
77 | 0xe53723c804efda69632aeb53ec6c41ce7dbc8d2b | 1 | 33.56766546 | 0x1da530593efd8d57bda7c2a07d7aea09ff58be90 | 7 | 234.9736582 | ||||||||||||||||||
78 | 0x1da530593efd8d57bda7c2a07d7aea09ff58be90 | 0 | 0xecac9a0a90e09b4cd215406384fa5623be861165 | 1 | 33.56766546 | |||||||||||||||||||
79 | 0xecac9a0a90e09b4cd215406384fa5623be861165 | 1 | 33.56766546 | 0x18f03838261debae2ed9b4119a70f8ef0ace4a3d | 3 | 100.7029964 | ||||||||||||||||||
80 | 0x18f03838261debae2ed9b4119a70f8ef0ace4a3d | 1 | 33.56766546 | 0x405a8aee4a3f0b6daeabc70ac3c4947fe4d79da0 | 6 | 201.4059928 | ||||||||||||||||||
81 | 0x405a8aee4a3f0b6daeabc70ac3c4947fe4d79da0 | 1 | 33.56766546 | 0x78562b3ece11aced499b67ae779462a777c64240 | 9 | 302.1089891 | ||||||||||||||||||
82 | 0x78562b3ece11aced499b67ae779462a777c64240 | 1 | 33.56766546 | 0x62826b0b43de2ded13ad3b5f5dc9a31a6ba9e8ad | 10 | 335.6766546 | ||||||||||||||||||
83 | 0x62826b0b43de2ded13ad3b5f5dc9a31a6ba9e8ad | 1 | 33.56766546 | 0xd4b3241f32d94c0d2a0e121ab9287de6c593e66f | 1 | 33.56766546 | ||||||||||||||||||
84 | 0xd4b3241f32d94c0d2a0e121ab9287de6c593e66f | 1 | 33.56766546 | 0x507f5ae468e5753a10a6e8a3543493885e30fbd7 | 1 | 33.56766546 | ||||||||||||||||||
85 | 0x507f5ae468e5753a10a6e8a3543493885e30fbd7 | 1 | 33.56766546 | 0x480f32c25ece568136edf714c9f6aba206a09775 | 10 | 335.6766546 | ||||||||||||||||||
86 | 0x480f32c25ece568136edf714c9f6aba206a09775 | 1 | 33.56766546 | 0xe9d3d4e6977a3a901a91ac8648ea8a1e16e1829e | 1 | 33.56766546 | ||||||||||||||||||
87 | 0xe9d3d4e6977a3a901a91ac8648ea8a1e16e1829e | 1 | 33.56766546 | 0x1e738b24ddb9b78e285b87e951a8aef62957c552 | 0 | 0 | ||||||||||||||||||
88 | 0x1e738b24ddb9b78e285b87e951a8aef62957c552 | 0 | 0x9ad6a4d4655c393e592d5bb81ff0beab54ef74dd | 6 | 201.4059928 | |||||||||||||||||||
89 | 0x9ad6a4d4655c393e592d5bb81ff0beab54ef74dd | 1 | 33.56766546 | 0x04963113e06716f2338908e43412ca64c7fc395e | 6 | 201.4059928 | ||||||||||||||||||
90 | 0x04963113e06716f2338908e43412ca64c7fc395e | 1 | 33.56766546 | 0x7526857198e628147b967e992e08581a9ecabed9 | 2 | 67.13533092 | ||||||||||||||||||
91 | 0x7526857198e628147b967e992e08581a9ecabed9 | 1 | 33.56766546 | 0x336bbc17477f9e97c111dedb5398dce9bdfbcfd5 | 1 | 33.56766546 | ||||||||||||||||||
92 | 0x336bbc17477f9e97c111dedb5398dce9bdfbcfd5 | 0 | 0xae2f23c4a50181d1bc4e757ae66c5ec690ad5274 | 1 | 33.56766546 | |||||||||||||||||||
93 | 0xae2f23c4a50181d1bc4e757ae66c5ec690ad5274 | 1 | 33.56766546 | 0x164185944767db697aab5a55a7f087217039f6ec | 1 | 33.56766546 | ||||||||||||||||||
94 | 0x164185944767db697aab5a55a7f087217039f6ec | 1 | 33.56766546 | 0x43279d6e2d0f3b6e586ff51e47ceeffc590ac911 | 4 | 134.2706618 | ||||||||||||||||||
95 | 0x43279d6e2d0f3b6e586ff51e47ceeffc590ac911 | 1 | 33.56766546 | 0xd62b67749d3c200a142d243b60c08aff80456282 | 4 | 134.2706618 | ||||||||||||||||||
96 | 0xd62b67749d3c200a142d243b60c08aff80456282 | 1 | 33.56766546 | 0xf77351d5b0b5dafcd0fe2bc23b4ff9bed4d7c250 | 1 | 33.56766546 | ||||||||||||||||||
97 | 0xf77351d5b0b5dafcd0fe2bc23b4ff9bed4d7c250 | 1 | 33.56766546 | 0x18fbb41e8342bab9fc3e28a7ec2bde1c080c1ba9 | 1 | 33.56766546 | ||||||||||||||||||
98 | 0x18fbb41e8342bab9fc3e28a7ec2bde1c080c1ba9 | 1 | 33.56766546 | 0xc2ae9ec7ed950f854b6b38290207261040fe7fa1 | 9 | 302.1089891 | ||||||||||||||||||
99 | 0xc2ae9ec7ed950f854b6b38290207261040fe7fa1 | 1 | 33.56766546 | 0xb4aa0e74cada25d161ffdffc6932030ef3c95f65 | 7 | 234.9736582 | ||||||||||||||||||
100 | 0xb4aa0e74cada25d161ffdffc6932030ef3c95f65 | 1 | 33.56766546 | 0xcb4d48cb63627299940c230b9e17ed97d8b6a662 | 1 | 33.56766546 |