RE: HashKings: The Water Tower Considerations + My Game Activity / La Water Tower + La Mia Attività di Gioco (ENG/ITA)

avatar

You are viewing a single comment's thread:

Hey libertycrypto I was just wondering what is the formula you use to get the ROI on water towers? I can't figure out how you did it.

oneup
0
0
0.000
6 comments
avatar

Hi @shaddrak
Value of annual production ((numero di HKWATER per day * 365) * value in SWAP.HIVE di 1 HKWATER)/Purchase Cost of Water Tower ;)
!BEER

0
0
0.000
Reply
avatar

I tried it and it didn't work. 302*365=110,230 * .00003 Hive = 3.3069 / 11.7376 = 0.2817

0
0
0.000
Reply
avatar

Hi @shaddrak obviously in the formula I gave you I forgot to tell you that you have to multiply the result by 100.
To you it comes out 28.17% because you took the values in the table that are correct values but automatically rounded by the spreadsheet.
In fact the calculation in my spreadsheet is correct and I explain why.
In the cell of table 1 HKWATER = 0.00003 but this is a rounding because the spreadsheet rounds up the displayed number but in the cell and in the calculation is used the number with all decimal places.
The value of 1 HKWATER when I did the calculation was lower than 0.00003 (number displayed and rounded to 5 decimal places) while in calculations the precise value with all decimal places is used.
Now I'm not at home and I don't have the file I used but if you want this afternoon I can show you the exact values with all the decimal places I used ;)
In my next post I will increase the display of all the decimal places ;)

!BEER

0
0
0.000
Reply
avatar

Thank you for the response, I was just wondering what I was missing. Sorry I'm not good at math lol

0
0
0.000
Reply