So, if we look at the total investment of
A total of 28.95 BTC invested
A total of 157k NRB invested
A total of 165k NRS invested
There is a BTC short fall of 4.0155 BTC
So since the BTC is not enough, we add the NRB
Which was valued at 1.831395349 BTC
leaving us with a short fall of 2.1842 BTC
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