A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | Desc | Amount | Trans id | Notes | |||||||||||||||
2 | Payout amount outstanding | 0 | ||||||||||||||||||
3 | Mining Income | |||||||||||||||||||
4 | 1EN3EqqQfqq484WNATFAMA13VXpJuJNv5c | 924.2575649 | https://blockchain.info/address/1EN3EqqQfqq484WNATFAMA13VXpJuJNv5c | Eligius Mining Address | ||||||||||||||||
5 | 1MyLJvnuHxkXUp8CMPNwp1oKFz5fDsF14u | 574.0007734 | https://blockchain.info/address/1MyLJvnuHxkXUp8CMPNwp1oKFz5fDsF14u | Bitminter Mining Address | ||||||||||||||||
6 | as of 07/4 | Total Mining income Received | 1498.258338 | |||||||||||||||||
7 | ||||||||||||||||||||
8 | ||||||||||||||||||||
9 | Expenses | |||||||||||||||||||
10 | 7/8/2013 | Improper dividend payout to mining address | 0.00040041 | e0ed8497295732d75f47892e9402c8e998baddbf9cf290bb13b5ccdcb9f8a3b0 | *this amount was paid into the mining address, so it needs to be removed | |||||||||||||||
11 | 9/13/2013 | Repay Bitfunder loan to cover first hosting payment to KNC | 105.3 | 01143af796668f9b5039f5343dc39c8692be0b63499fbba7b80ac65d3b398cae | 3dbe97597f20a611f8cd4c092b048be7652d4e46901f0e5096e7481c50ae3404 | |||||||||||||||
12 | 9/13/2013 | Repay member loan to cover first hosting payment to KNC | 40.7 | https://blockchain.info/address/1NaE9oXe9ZkCUrhtEPTFGU4HbUqZXVanGw | *handled outside mining payouts. in another spreadsheet | |||||||||||||||
13 | 10/25/2013 | Improper dividend payout to mining address | 1.07494933 | ef13b0e1aae1d1fd8a6773a9f222ac5ae1d4122c839976d3dd8a434b1e350c5d | *this amount was paid into the mining address, so it needs to be removed | |||||||||||||||
14 | 10/28/2013 | Improper dividend payout to mining address | 0.00107603 | 2b43e9a81196fda1ccbbdae258a519c1dde535a86d3f03a2f45ca6bd68f1958d | *this amount was paid into the mining address, so it needs to be removed | |||||||||||||||
15 | 12/4/2013 | Hosting Payment to KNC | 16.206 | b0674a4a6e0582efa3cbf23980e316247c70489fad5e0ea41292449d0ab42aaa | ||||||||||||||||
16 | 1/31/2014 | Hosting Payment to KNC | 22.3666 | ef47941b789fb5d6dd1525f7365ead66869d344d919610fc07b0a133664030ae | ||||||||||||||||
17 | 7/4/2014 | Physical delivery of Jupiter devices to Larry | 7.2215 | e7c9757c6b3089714676958a544290b7376c966ebfd60ae30048c37f7ac0cd36 | ||||||||||||||||
18 | 7/24/2014 | Duty on Jupiters - 26* $49.75 each | 2.04 | rate: $634.068627451/BTC | Larry paid personally | |||||||||||||||
19 | Total Expenses | 194.9105258 | ||||||||||||||||||
20 | Net mining income | 1303.347813 | ||||||||||||||||||
21 | ||||||||||||||||||||
22 | ||||||||||||||||||||
23 | Mining Payouts | |||||||||||||||||||
24 | 7/8/2014 | Mining Payout - automated via silfax software | 0.10093136 | c9e20c34c711d3d3686b03f363c0f0635137cab3a26c33aa01d26469b9e3a85b | ||||||||||||||||
25 | 7/8/2014 | CHANGE | -0.0997 | c9e20c34c711d3d3686b03f363c0f0635137cab3a26c33aa01d26469b9e3a85b | ||||||||||||||||
26 | 7/8/2013 | Mining Payout - automated via silfax software | 0.1 | e0ed8497295732d75f47892e9402c8e998baddbf9cf290bb13b5ccdcb9f8a3b0 | ||||||||||||||||
27 | 7/8/2013 | CHANGE | -0.09799823 | e0ed8497295732d75f47892e9402c8e998baddbf9cf290bb13b5ccdcb9f8a3b0 | ||||||||||||||||
28 | 7/8/2013 | Mining Payout - automated via silfax software | 0.10240273 | 1f6969f620591b5d9f124ee45280d89df59ab0a5e05df77dde432f281ca20eca | ||||||||||||||||
29 | 7/8/2013 | CHANGE | -0.10093136 | 1f6969f620591b5d9f124ee45280d89df59ab0a5e05df77dde432f281ca20eca | ||||||||||||||||
30 | 10/14/2013 | Mining Payout - automated via silfax software | 27.36541882 | f5a4397cd8901c5d557c0fed71ccaa20141901f870a471b4332491df13cf7e60 | ||||||||||||||||
31 | 10/14/2013 | CHANGE | -0.1096 | f5a4397cd8901c5d557c0fed71ccaa20141901f870a471b4332491df13cf7e60 | ||||||||||||||||
32 | 10/25/2013 | Mining Payout - automated via silfax software | 136.9100849 | 8de92f29411b7420988b09c1da93ad7b5afade9bf96f43824df534717a29b8a4 | ||||||||||||||||
33 | 10/25/2013 | CHANGE | -40.30884792 | 8de92f29411b7420988b09c1da93ad7b5afade9bf96f43824df534717a29b8a4 | ||||||||||||||||
34 | 10/25/2013 | Mining Payout - automated via silfax software | 40.30874792 | 6c9c3acb50b1eae854b8ce5cfa65f98ea46d5aad1979df6936ff1f63d76f783e | ||||||||||||||||
35 | 10/25/2013 | CHANGE | -6.00645158 | 6c9c3acb50b1eae854b8ce5cfa65f98ea46d5aad1979df6936ff1f63d76f783e | ||||||||||||||||
36 | 10/25/2013 | Mining Payout - automated via silfax software | 208.2082998 | ef13b0e1aae1d1fd8a6773a9f222ac5ae1d4122c839976d3dd8a434b1e350c5d | this went first through trans: e9c953fa747649b43d7eed32a76e3d15e1dad9aa30136e6561f1d69668db5e02 | |||||||||||||||
37 | 10/25/2013 | CHANGE | -172.238878 | ef13b0e1aae1d1fd8a6773a9f222ac5ae1d4122c839976d3dd8a434b1e350c5d | ||||||||||||||||
38 | 10/25/2013 | Mining Payout - automated via silfax software | 172.238778 | 0544c0ec42f5a9c330f66645c3e6d719baffab311e13a2e2542821ea8f3edfc2 | ||||||||||||||||
39 | 10/25/2013 | CHANGE | -136.9101849 | 0544c0ec42f5a9c330f66645c3e6d719baffab311e13a2e2542821ea8f3edfc2 | ||||||||||||||||
40 | 10/28/2013 | Mining Payout - automated via silfax software | 0.20831 | 2b43e9a81196fda1ccbbdae258a519c1dde535a86d3f03a2f45ca6bd68f1958d | ||||||||||||||||
41 | 10/28/2013 | CHANGE | -0.17230457 | 2b43e9a81196fda1ccbbdae258a519c1dde535a86d3f03a2f45ca6bd68f1958d | ||||||||||||||||
42 | 11/2/2013 | Mining Payout - automated via silfax software | 71.74623485 | 8627410a10cd0aadbf69bfdb08bfe1fb0d8510129b025e8410be725108cb2095 | ||||||||||||||||
43 | 11/2/2013 | CHANGE | -46.10647956 | 8627410a10cd0aadbf69bfdb08bfe1fb0d8510129b025e8410be725108cb2095 | ||||||||||||||||
44 | 11/2/2013 | Mining Payout - automated via silfax software | 114.2455023 | 3d3e339a8e6310a28c22cfff40735a09033aea91fb2ced5ba011f83189ca59b5 | ||||||||||||||||
45 | 11/2/2013 | CHANGE | -71.74633485 | 3d3e339a8e6310a28c22cfff40735a09033aea91fb2ced5ba011f83189ca59b5 | ||||||||||||||||
46 | 11/2/2013 | Mining Payout - automated via silfax software | 46.10637956 | a1ed8d9ea2be710019aab65f91e22c73962d66949df8a196d5eadefba4d98dc3 | ||||||||||||||||
47 | 11/2/2013 | CHANGE | -28.25212819 | a1ed8d9ea2be710019aab65f91e22c73962d66949df8a196d5eadefba4d98dc3 | ||||||||||||||||
48 | 11/8/2013 | Mining Payout - automated via silfax software | 58.73228262 | 51f5fe4302a81512f0f32eb8b1f8fd5b7dba2f00a2731edb23a8ceb4eb2d0d4c | ||||||||||||||||
49 | 11/8/2013 | CHANGE | -34.38572252 | 51f5fe4302a81512f0f32eb8b1f8fd5b7dba2f00a2731edb23a8ceb4eb2d0d4c | ||||||||||||||||
50 | 11/8/2013 | Mining Payout - automated via silfax software | 143.3764907 | 595d29140aaf13f48790a9c41eb7ed388c7261df60777245daf0cec987e9ec2c | ||||||||||||||||
51 | 11/8/2013 | CHANGE | -123.5120251 | 595d29140aaf13f48790a9c41eb7ed388c7261df60777245daf0cec987e9ec2c | ||||||||||||||||
52 | 11/8/2013 | Mining Payout - automated via silfax software | 131.8994878 | 8d9acb40391c7e222e9263b0fe6b1470de227f69f9887b18cfb02f70f8ec0f26 | ||||||||||||||||
53 | 11/8/2013 | CHANGE | -58.73238262 | 8d9acb40391c7e222e9263b0fe6b1470de227f69f9887b18cfb02f70f8ec0f26 | ||||||||||||||||
54 | 11/8/2013 | Mining Payout - automated via silfax software | 28.25202819 | ec8f774aeb795800750aa09e3fe5d5d89dc0c72d2d5d2cc7337b24ddde1f24da | ||||||||||||||||
55 | 11/8/2013 | CHANGE | -8.38756264 | ec8f774aeb795800750aa09e3fe5d5d89dc0c72d2d5d2cc7337b24ddde1f24da | ||||||||||||||||
56 | 11/16/2013 | Mining Payout - automated via silfax software | 0.17220457 | 2ee21a21df99171f183fac215baf8d7b2f0cc8a82270c3482b9455bbed3cf059 | ||||||||||||||||
57 | 11/16/2013 | CHANGE | -0.1368406 | 2ee21a21df99171f183fac215baf8d7b2f0cc8a82270c3482b9455bbed3cf059 | ||||||||||||||||
58 | 11/17/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 134.1764355 | a218e3583f0571377ef29fded24d47147c6820c6040ec1f07b8c2dd91e96f6d5 | ||||||||||||||||
59 | 11/17/2013 | CHANGE | -0.01000089 | a218e3583f0571377ef29fded24d47147c6820c6040ec1f07b8c2dd91e96f6d5 | ||||||||||||||||
60 | 11/22/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 94.50297646 | 2aa34458daf0928789629d174424a8dd18e937550e0f49b18b958faeecf8f40e | ||||||||||||||||
61 | 11/22/2013 | CHANGE | -0.01000176 | 2aa34458daf0928789629d174424a8dd18e937550e0f49b18b958faeecf8f40e | ||||||||||||||||
62 | 12/1/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 91.51183177 | 9074bdc9df9a46ea7f5d296885f66847e0964c92dd4ab4fa3da14eb54dbf91ec | ||||||||||||||||
63 | 12/1/2013 | CHANGE | -0.01001101 | 9074bdc9df9a46ea7f5d296885f66847e0964c92dd4ab4fa3da14eb54dbf91ec | ||||||||||||||||
64 | 12/1/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 4.27179487 | ea726560e394bf9ede32689b6e33597888aad1ce7db4e0ed22a896761065873a | ||||||||||||||||
65 | 12/1/2013 | CHANGE | -0.01002612 | ea726560e394bf9ede32689b6e33597888aad1ce7db4e0ed22a896761065873a | ||||||||||||||||
66 | 12/8/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 0.1368406 | dc8b711020b614b35a2f3635b8fe469ab65cc1485d86e1b469c6af857b16969e | ||||||||||||||||
67 | 12/8/2013 | CHANGE | -0.04004267 | dc8b711020b614b35a2f3635b8fe469ab65cc1485d86e1b469c6af857b16969e | ||||||||||||||||
68 | 12/10/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 98.15313605 | 4d3ea5ba035605af59e2c2c57089a5f0b1f674e58306345b34d515d8b24ff247 | ||||||||||||||||
69 | 12/10/2013 | CHANGE | -0.0100003 | 4d3ea5ba035605af59e2c2c57089a5f0b1f674e58306345b34d515d8b24ff247 | ||||||||||||||||
70 | 12/29/2013 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 91.07346198 | 29b0b50d92b6bc240a62cccc804f0c40c08a235b27d1677bc5d8240b34ca19c5 | ||||||||||||||||
71 | 12/29/2013 | CHANGE - 1BakoktuVVd33A125eJthSoVGrF2ekhMLM | -0.0100211 | 29b0b50d92b6bc240a62cccc804f0c40c08a235b27d1677bc5d8240b34ca19c5 | ||||||||||||||||
72 | 1/20/2014 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 63.35176318 | 32279ab5df9fd2b327500949fd0b5bcadda47d6f36cbf3283dbb11519f506436 | ||||||||||||||||
73 | 1/20/2014 | CHANGE - 1A6tKucuzcruPxHxyD8CoJKrkM5FQhxtN6 | -0.01002627 | 32279ab5df9fd2b327500949fd0b5bcadda47d6f36cbf3283dbb11519f506436 | ||||||||||||||||
74 | 1/31/2014 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 81.72091114 | 10cce9db3715af6dbb84d7c7e776af40dd136270cdf6c6581be26b5b14674e45 | ||||||||||||||||
75 | 1/31/2014 | CHANGE - 16soGYEHDSiPNsKKGaBnZtnbitp2K8nf5q | -0.01000007 | 10cce9db3715af6dbb84d7c7e776af40dd136270cdf6c6581be26b5b14674e45 | ||||||||||||||||
76 | 2/27/2014 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 74.89726072 | 6f814b0112c5082da4cb8282fae5551d82ddb46910698ce14d13b95eb2057b2c | ||||||||||||||||
77 | 2/27/2014 | CHANGE - 14wEWzYHse1xvQcnAWBfV9jyk4bhmqDvpW | -0.01000729 | 6f814b0112c5082da4cb8282fae5551d82ddb46910698ce14d13b95eb2057b2c | ||||||||||||||||
78 | 3/21/2014 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 37.10956045 | eacaf9a99aaa8a51c10f4da7f99a58d0b8e435dde51400e44a9b6260744f85a0 | ||||||||||||||||
79 | 3/21/2014 | CHANGE - 14wEWzYHse1xvQcnAWBfV9jyk4bhmqDvpW | -0.01000516 | eacaf9a99aaa8a51c10f4da7f99a58d0b8e435dde51400e44a9b6260744f85a0 | ||||||||||||||||
80 | 5/13/2014 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 45.8982511 | 8d0c632ce56cdb39469e462b419464b604defaea43117c23ad2b3eb043068126 | ||||||||||||||||
81 | 5/13/2014 | CHANGE - 1KfjvP7traWxedMkPrQrAZuJ4KPmN1MrrF | -0.01000058 | 8d0c632ce56cdb39469e462b419464b604defaea43117c23ad2b3eb043068126 | ||||||||||||||||
82 | 8/4/2014 | Mining Payout - via espen software (sendmany from bitcoin-qt) | 33.92452063 | c9b91d7c69d86c80a29c4c5663d9d5972141ef19ed310c1a7e7e15bc00638ef1 | ||||||||||||||||
83 | ||||||||||||||||||||
84 | Total Mining Payouts | 1303.347813 | ||||||||||||||||||
85 | Larry fee | 26.06695625 | *management fees are 2% of BTC mined after expenses are deducted | |||||||||||||||||
86 | Split between members | 1277.280856 | *98% | |||||||||||||||||
87 | Total Mining Payouts | 1303.347813 | ||||||||||||||||||
88 | ||||||||||||||||||||
89 | ||||||||||||||||||||
90 | The following is math required to plugin appropriate payout amounts into to the payout software | |||||||||||||||||||
91 | KNC Compensation | -85 | *hardcoded into the payout software | |||||||||||||||||
92 | Initial mining income that needs to be prorated between GB1/2/3 members proportionally | -50 | *hardcoded into the payout software | |||||||||||||||||
93 | Desired next dividend payout | 33.924 | <-plug in value here to calculate amount below | |||||||||||||||||
94 | Difference between mining payouts and payout software requirement for next payout calculation event | 1202.271813 | -plug this in as the amount paid out | |||||||||||||||||
95 | ||||||||||||||||||||
96 | ||||||||||||||||||||
97 | ||||||||||||||||||||
98 | ||||||||||||||||||||
99 | ||||||||||||||||||||
100 |