Took me some time to read the accounting through, but one thing I can say: The accounting of 28.95 BTC totally invested is wrong. I have been looking at the Excelsheet, and see this sum: =SUM(H4:H42). In colum H only 0.15 BTC is stated for my account. But in column L you see I gave another 0.11 BTC on April 11th. That one was not counted in the total in colum H and you are referring to cell H47 for the total, but that is not the total total of BTC that has been given. My guess is that cell I47 to O47 also must be counted. Likewise I guess for PTS, NRS and NRB.
So there was more than you say there was.
You are right, it gives us a total of 29.05000255 BTC , sorry the NRB and NRS remain unchanged. And i forgot about the PTS.
So that means i need to add an additional 0.2 BTC and 3.67 BTC (for the PTS ) to what i have to account for.
I'll add that now.
I did this =SUM(E47:AH47) that gave me 49.81 BTC invested (total value of PTS, BTC, NRS and NRB that were donated)
If I am wrong, tell me what I did wrong, but for me you got 49.81 BTC!!!!
Your math gives total shares, but like i pointed out, It was a declaration on my part that 10000 NRS == 1 BTC == 1 Share, but that was not the price on the market was it? So we cannot assume that there is investment worth 50 BTC. The investment total was worth
29 BTC + 157 k NRB and 167k NRS +447 PTS (corrected)
Which at market price then was 29 BTC + 1.8 BTC + ~ 8 BTC and 4 BTC.
The SHARES are 50 but the VALUE is much less that your proposed 49 BTC
barwizi is right
https://drive.google.com/file/d/0B0ENIPCOaLvNdXZvbHA5OFpTQlk/edit?usp=sharing
You are using an outdated GF ledger.
LOL , its out of date by two or three entries, and it has a simple lay out that details who invested what , EVERYONE THAT INVESTED KNOWS THAT IS THE ORIGINAL DOCUMENT SO STOP MISDIRECTING
https://drive.google.com/file/d/0BxCtiOzdwvPya2ZZY1RzeUlzWlk/edit?usp=sharing
has a few small changes to it but it's lay out is complicated, don't try to use that as a way of getting your point across.