ABCDEFGHIJKLMNOPQRSTUVWX
1
2
3
4
Total Tokens for bounty campaign1019450
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 1330
13
week 2421
14
week 3550
15
week 4584
16
week 5712
17
week 6815
18
week 7673Notes for the spreadsheet:
19
week 8698Google Docs: UNIQUE is case sensitive, SUMIF is not!
20
week 9675
A work around is to use ArrayFormula with FIND instead of SUMIF
21
week 10616
However, this requires leading and trailing spaces to be removed from the ETH Address: TRIM
22
Total Stakes in Facebook bounty6074
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 AddressStakesTokensETH AddressStakesTokens
26
week 10xd77a4fbff64f158abc12dead6622574e77b56b13133.567665460xd77a4fbff64f158abc12dead6622574e77b56b13133.56766546
27
0x3af379098907a9a61db7f97cbb777e6fb53ebb1f00x3af379098907a9a61db7f97cbb777e6fb53ebb1f133.56766546
28
0xffa31b81129d0d5d98cd016b6e3aa4f7437e79df133.567665460xffa31b81129d0d5d98cd016b6e3aa4f7437e79df4134.2706618
29
0x346a87f77bedf4143e429ef0f77a8b1fdb74c8d100x346a87f77bedf4143e429ef0f77a8b1fdb74c8d14134.2706618
30
0xe396146a7070472a544d5d71710be9e55e95e98a133.567665460xe396146a7070472a544d5d71710be9e55e95e98a133.56766546
31
0x70c0ad4cdee3fff66a417519732de20b462e6e73133.567665460x70c0ad4cdee3fff66a417519732de20b462e6e73133.56766546
32
0x3a98daa3daa51e3b2266a776a5a7e8dc8b73550000x3a98daa3daa51e3b2266a776a5a7e8dc8b73550000
33
0xf87e1f06097be4f5a426394b8bfd57d022d8e80a00xf87e1f06097be4f5a426394b8bfd57d022d8e80a00
34
0x69f7f3212ac4baffcadb62777ad4d9d8df35f256133.567665460x69f7f3212ac4baffcadb62777ad4d9d8df35f256133.56766546
35
0x6a3da4029b76778dc33b9492ac5d023e4702f5e6133.567665460x6a3da4029b76778dc33b9492ac5d023e4702f5e6133.56766546
36
0xe673efd9d4518a96a7bd734e8658eb44a0688ce2133.567665460xe673efd9d4518a96a7bd734e8658eb44a0688ce25167.8383273
37
0xdf362413e0125a93c57c31472f5cc02bebb9930600xdf362413e0125a93c57c31472f5cc02bebb993063100.7029964
38
0x34218baf88ea69136bbae587b0e58e31d47c11ac133.567665460x34218baf88ea69136bbae587b0e58e31d47c11ac133.56766546
39
0xb623472a00418b5beb57e3e662382acc75654fef133.567665460xb623472a00418b5beb57e3e662382acc75654fef5167.8383273
40
0x36585cd03fea628ecdebb59188de95cc585742fa00x36585cd03fea628ecdebb59188de95cc585742fa7234.9736582
41
0xcb045ca0121be769cf552b890f8be56129469edb133.567665460xcb045ca0121be769cf552b890f8be56129469edb133.56766546
42
0x931e9dd50640fc99bd715517c3b28d6190954262133.567665460x931e9dd50640fc99bd715517c3b28d619095426210335.6766546
43
0xb682eebddd59119b8f446787905303b3c0511478133.567665460xb682eebddd59119b8f446787905303b3c05114789302.1089891
44
0x3c982ffaa627ede3d539bbcb1f88758fa365a506133.567665460x3c982ffaa627ede3d539bbcb1f88758fa365a506267.13533092
45
0x775afd2f9babd405d087d7bc32ebffa477de3b9f133.567665460x775afd2f9babd405d087d7bc32ebffa477de3b9f10335.6766546
46
0xe79c5b9eb5e0fdc872f9754d7ea838dcd933617b133.567665460xe79c5b9eb5e0fdc872f9754d7ea838dcd933617b267.13533092
47
0x9d0915e1e7371a0e1af32380ad2493f86c68772500x9d0915e1e7371a0e1af32380ad2493f86c68772500
48
0x304ea31797c54cb936fd5acb5f6340700791afe7133.567665460x304ea31797c54cb936fd5acb5f6340700791afe73100.7029964
49
0x3424bc356fd2d2d666c4a66df4e26970b5c030dd00x3424bc356fd2d2d666c4a66df4e26970b5c030dd00
50
0x54e394f94a1917463d77eccd446ff7a0b443e0b400x54e394f94a1917463d77eccd446ff7a0b443e0b400
51
0x9c1184394b7ff89374393dc54428086a15ce53ed133.567665460x9c1184394b7ff89374393dc54428086a15ce53ed133.56766546
52
0x3b1e89f91934c78772b9cbc486650681fc965394133.567665460x3b1e89f91934c78772b9cbc486650681fc9653949302.1089891
53
0x4e11c0e0a6f200907e8d6b9904cba58304c9976e133.567665460x4e11c0e0a6f200907e8d6b9904cba58304c9976e267.13533092
54
0xb5deee5b4d72c8c8c6f5d013b266e7b0757edd89133.567665460xb5deee5b4d72c8c8c6f5d013b266e7b0757edd89133.56766546
55
0x51bff6f116cd1d9bffb0248a669bbd86635d92f8133.567665460x51bff6f116cd1d9bffb0248a669bbd86635d92f8133.56766546
56
0x2744e0ed95ee0e94ed6f941a8f3c64c7e1737816133.567665460x2744e0ed95ee0e94ed6f941a8f3c64c7e1737816133.56766546
57
0xc3ce837823dbc543303c88eac388ab9b345d372800xc3ce837823dbc543303c88eac388ab9b345d372800
58
0x9d0915e1e7371a0e1af32380ad2493f86c68772500x3c52afcfb7d926759f11d613dbe67b695c024a955167.8383273
59
0x3c52afcfb7d926759f11d613dbe67b695c024a95133.567665460x3455b77c3961096fe77040adb35cd1207127710f5167.8383273
60
0x3455b77c3961096fe77040adb35cd1207127710f133.567665460xe68fe6f54a7137e87694d377351cec1992aa8107133.56766546
61
0xe68fe6f54a7137e87694d377351cec1992aa8107133.567665460xc199050dde5b14c2781e90dcbae86a34f052a95b133.56766546
62
0xc199050dde5b14c2781e90dcbae86a34f052a95b133.567665460x199b9a9be3a8769625b59b6cda474d2a4954c61c8268.5413237
63
0x199b9a9be3a8769625b59b6cda474d2a4954c61c133.567665460xc27ba127100ce61719352b8f95e568b3aa6574416201.4059928
64
0xc27ba127100ce61719352b8f95e568b3aa657441133.567665460xc97078d9ecc953a8e263626892da1f17579fa6e610335.6766546
65
0xc97078d9ecc953a8e263626892da1f17579fa6e6133.567665460x1f19dc039fc70537bd4b6796fa3f05fd459ce75010335.6766546
66
0x1f19dc039fc70537bd4b6796fa3f05fd459ce750133.567665460x3fea93d052df8f009811bf7c2ef34d9f8c01df0a3100.7029964
67
0x3fea93d052df8f009811bf7c2ef34d9f8c01df0a00xb9220ea0fa893dfe15524730b7ab8aebce4ef3c77234.9736582
68
0xb9220ea0fa893dfe15524730b7ab8aebce4ef3c7133.567665460xeea5efcb5c021fcda01a8a2546badff5d637d1f800
69
0xeea5efcb5c021fcda01a8a2546badff5d637d1f800x4afe1b1857dd0ff16a4cc46f8be92ab1165e6458133.56766546
70
0x4afe1b1857dd0ff16a4cc46f8be92ab1165e6458133.567665460xdbc4f6a615508785098039e259bb7184351653e35167.8383273
71
0xdbc4f6a615508785098039e259bb7184351653e3133.567665460x9fbb333c00118948a70b491b23807bd6514ba8757234.9736582
72
0x9fbb333c00118948a70b491b23807bd6514ba875133.567665460x44c0a9e2ab4429d0c2ead4ae5ea2cfab1649d2487234.9736582
73
0x44c0a9e2ab4429d0c2ead4ae5ea2cfab1649d248133.567665460xa403b1b7ede70afe902ae6aaf213d8dd49615d589302.1089891
74
0xa403b1b7ede70afe902ae6aaf213d8dd49615d58133.567665460x3744baa47228b390c79a8a06df241e48308dd68010335.6766546
75
0x3744baa47228b390c79a8a06df241e48308dd680133.567665460xa7802ba51ba87556263d84cfc235759b214ccf359302.1089891
76
0xa7802ba51ba87556263d84cfc235759b214ccf35133.567665460xe53723c804efda69632aeb53ec6c41ce7dbc8d2b6201.4059928
77
0xe53723c804efda69632aeb53ec6c41ce7dbc8d2b133.567665460x1da530593efd8d57bda7c2a07d7aea09ff58be907234.9736582
78
0x1da530593efd8d57bda7c2a07d7aea09ff58be9000xecac9a0a90e09b4cd215406384fa5623be861165133.56766546
79
0xecac9a0a90e09b4cd215406384fa5623be861165133.567665460x18f03838261debae2ed9b4119a70f8ef0ace4a3d3100.7029964
80
0x18f03838261debae2ed9b4119a70f8ef0ace4a3d133.567665460x405a8aee4a3f0b6daeabc70ac3c4947fe4d79da06201.4059928
81
0x405a8aee4a3f0b6daeabc70ac3c4947fe4d79da0133.567665460x78562b3ece11aced499b67ae779462a777c642409302.1089891
82
0x78562b3ece11aced499b67ae779462a777c64240133.567665460x62826b0b43de2ded13ad3b5f5dc9a31a6ba9e8ad10335.6766546
83
0x62826b0b43de2ded13ad3b5f5dc9a31a6ba9e8ad133.567665460xd4b3241f32d94c0d2a0e121ab9287de6c593e66f133.56766546
84
0xd4b3241f32d94c0d2a0e121ab9287de6c593e66f133.567665460x507f5ae468e5753a10a6e8a3543493885e30fbd7133.56766546
85
0x507f5ae468e5753a10a6e8a3543493885e30fbd7133.567665460x480f32c25ece568136edf714c9f6aba206a0977510335.6766546
86
0x480f32c25ece568136edf714c9f6aba206a09775133.567665460xe9d3d4e6977a3a901a91ac8648ea8a1e16e1829e133.56766546
87
0xe9d3d4e6977a3a901a91ac8648ea8a1e16e1829e133.567665460x1e738b24ddb9b78e285b87e951a8aef62957c55200
88
0x1e738b24ddb9b78e285b87e951a8aef62957c55200x9ad6a4d4655c393e592d5bb81ff0beab54ef74dd6201.4059928
89
0x9ad6a4d4655c393e592d5bb81ff0beab54ef74dd133.567665460x04963113e06716f2338908e43412ca64c7fc395e6201.4059928
90
0x04963113e06716f2338908e43412ca64c7fc395e133.567665460x7526857198e628147b967e992e08581a9ecabed9267.13533092
91
0x7526857198e628147b967e992e08581a9ecabed9133.567665460x336bbc17477f9e97c111dedb5398dce9bdfbcfd5133.56766546
92
0x336bbc17477f9e97c111dedb5398dce9bdfbcfd500xae2f23c4a50181d1bc4e757ae66c5ec690ad5274133.56766546
93
0xae2f23c4a50181d1bc4e757ae66c5ec690ad5274133.567665460x164185944767db697aab5a55a7f087217039f6ec133.56766546
94
0x164185944767db697aab5a55a7f087217039f6ec133.567665460x43279d6e2d0f3b6e586ff51e47ceeffc590ac9114134.2706618
95
0x43279d6e2d0f3b6e586ff51e47ceeffc590ac911133.567665460xd62b67749d3c200a142d243b60c08aff804562824134.2706618
96
0xd62b67749d3c200a142d243b60c08aff80456282133.567665460xf77351d5b0b5dafcd0fe2bc23b4ff9bed4d7c250133.56766546
97
0xf77351d5b0b5dafcd0fe2bc23b4ff9bed4d7c250133.567665460x18fbb41e8342bab9fc3e28a7ec2bde1c080c1ba9133.56766546
98
0x18fbb41e8342bab9fc3e28a7ec2bde1c080c1ba9133.567665460xc2ae9ec7ed950f854b6b38290207261040fe7fa19302.1089891
99
0xc2ae9ec7ed950f854b6b38290207261040fe7fa1133.567665460xb4aa0e74cada25d161ffdffc6932030ef3c95f657234.9736582
100
0xb4aa0e74cada25d161ffdffc6932030ef3c95f65133.567665460xcb4d48cb63627299940c230b9e17ed97d8b6a662133.56766546