Quote from: BenTuras on January 09, 2014, 10:43:09 AM

Quote from: soniq on January 08, 2014, 07:04:38 PM

As far as members looking for current spreadsheet it has been posted in several threads in this forum, in the members area, sent out in emails and shared in Skype chat http://ec2-54-229-231-38.eu-west-1.compute.amazonaws.com/groupbuy/ it includes all payments but last one which was sent manually.

Since you asked me to come up with a solution, I had a good look at the Excel sheet you mention. (I should have done this earlier in the GB, but I start by trusting people and give them the benefit of the doubt that they can handle the task they took upon themselves).

The sheet is not only missing the last payment, but also missing the payment of December 02nd.

Let me try to understand an early dividend payment calculation:
GB1: 0.98 * 50 BTC mined * 15/17 / 45000 mined * (169) shares
0.98 - is probably the factor to take 2% management fee into account
50BTC mined is clear
15/17 - is this because GB1 had 15 of the 17 operational machines at that time ? This is not mentioned anywhere in the sheet.
45000 mined ? Probably in total 45000 shares, which is correct given the 450 shares for GB1 x 100 for the move to Bitfunder.
169 - number of shares this participant holds in this GB1

similar for GB2/3: 0.98 * 50 * 2/17 / 33000 mined * (500) shares
2/17 - see explanation for GB1.

The sheet is missing dates on all events, they can be found by looking at the blockchain transaction, but still.
- You should have made a separate sheet for all special events, like the intake of BTC for the GBs, the purchase of the machines, the refunding because of price adjustments, loans, hosting, management fee, share buying/selling between participants. Now part of it is all mixed in one big sheet, totally unclear what's going on, and a lot of information is missing.
- You should have made a new sheet for every dividend payment
- You should have made a sheet for the merge of GB1 and GB2/3, explaining all multiplication factors that are to be used for dividend payment.

I found the following Jupiter group buys in your name:
Jupiter #1-#15, 15 Jupiters: https://bitcointalk.org/index.php?topic=226319.0 - 450 shares, x100 when going to Bitfunder
Jupiter #16-#21, 6 Jupiters: https://bitcointalk.org/index.php?topic=242878.0 - 180 shares \
Jupiter #22-#26, 5 Jupiters: https://bitcointalk.org/index.php?topic=259660.0 - 150 shares / x 100 when going to Bitfunder

I created an Excel sheet that can pay all future dividends for both GB1 and GB2/GB3 with two transactions using bitcoind. I strongly suggest to copy this sheet for every new dividend payment you want to do.
This is the sheet I created: https://dl.dropboxusercontent.com/u/425227/SoniqDividendPaymentCalculation.xls
I have left the old sheet in it, I suggest to remove it before using it.

How to use it:
1. Check the green fields on the dividend payment tab.
2. Check the number of shares of each member on GB1 and GB2GB3 tab and modify them according to the share buy/sell between members that you received. (Warning! This sheet doesn't take the moment of share buy/sell into account. The number of shares someone owns at the moment the sheet is used determines the dividend. It's the participants responsibility to buy/sell at the 'right' moment). It's Soniqs responsibility to do the dividend payment on predetermined and public known moments.
3. Fill in the yellow fields on the tab "dividend payment" and provide proof of this by copying the blockchain.info link and a link to a screenshot of the pool withdraw page
4. Go to the GB1 tab and check the red value at the bottom of the list; it should be zero, or else something is wrong. It's a check that the dividend amount available is completely split between the participants. Note! A participant can occur more than once on this list!
5. Select all the lines in column E, copy them, open a new text file and paste the lines. Save this file as a batch file/shell script. Go to the directory containing bitcoind and execute the script. Dividend payments for GB1 are now done. (The funny character at the end of a line is the line continuation character).
5. Repeat steps 4&5 for GB2.
6. Post the two log files created in this thread and post a link to the saved Excel sheet.

Dividend payments are done and participants can validate what you did.

I urge all the participants to have a look at my Excel sheet and report anything wrong in it and also check the number of shares they see on their BTC address and report any problem to Soniq in a PM.

I haven't talked to Soniq about this sheet, he is free to use it or not.
If it has value to him, he can decide if he wants to reward me for it.

WARNING: Obviously I can not test the scripts that the Excel sheets creates. Soniq should copy the Excel sheet and do a trial with only a few addresses of his own to validate the correct working of the formulas used.

Afaik, the maximum line length of a line in a Windows batch file is 8191. GB1 has the largest line, 5247 characters, so well within the limit.

Comments on this are more than welcome, I am only human!

In GB1 and GB2GB3 worksheets in the first line the line continuation character is different then the "same" character on all the other lines:

bitcoind sendmany 18kUSwbSdDRxNowaaPXarZxHDtc1KrLUTt 16LncFsFAApVyur7cBbvViHxRj2ujcq1q8:1.15384615,\
12AkFwCRYdHVasmgmBVe9Q4EuYZ67UYoAx:1.25641026,^
...