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 ;)
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
View more
View or trade
BEER
.Hey @shaddrak, here is a little bit of
BEER
from @libertycrypto27 for you. Enjoy it!Learn how to earn FREE BEER each day by staking your
BEER
.