qwizzie
Well-known member
Last updated : 1st of December 2024
Instructrions : either copy and paste column A and column B into a Google Sheets tab, verify if the cell numbers [xx] match with your own Google sheet tab and then remove the [xx] cell numbers or just copy per cell right after each [xx] and paste it in the relevant cell. Set cell B21 and B26 to percentage. If at some point the payment interval on L1 get shorter then 4.5 days, just adjust the formula in B37 from *4.5 to *x
With regard to calculating Number of Enabled Evonodes specifically on Platform 1.5.x & 1.6.x on mnowatch you can delete rows in a specific way by clicking on the incorrect parts ; first click on Platform proposed blocks in the red header, then click on empty row to delete empty row, click on dash-1 to remove rows with dash-1, click on 1.2.x & 1.3.x & 1.4.x to remove rows with older versions, click on row with 4 N/A in them to remove those rows. That will leave you with a more accurate Number of Enabled Evonodes specifically on Platform 1.5.x & 1.6.1 on mnowatch at the bottom (table row count). If you see three Evonodes with 0 proposed blocks due to Tenderdash isssue (N/A) then subtract 3 from table row count manually.
Column A (A1 to A37)
| [A1] Number of Enabled Masternodes |
| [A2] Number of Enabled Evonodes specifically on Platform 1.5.x & 1.6.x |
| [A3] Number of Enabled Evonodes |
| [A4] Number of Evonodes not getting rewarded from Platform |
| [A5] |
| [A6] Block Gen + Fees (80%) |
| [A7] Block Gen + Fees (100%) |
| [A8] |
| [A9] 60% of blockrewards to Masternodes |
| [A10] 62.5% of above masternode rewards --> MNO |
| [A11] 37.5% of above masternode rewards --> Credit Pool |
| [A12] |
| [A13] Blocks per year |
| [A14] Number of Enabled Masternodes + Enabled Evonodes on 1.5.x & 1.6.x |
| [A15] |
| [A16] Annual |
| [A17] |
| [A18] Masternodes collateral (DASH) |
| [A19] Masternode rewards (DASH) |
| [A20] Masternode collateral + rewards (DASH) |
| [A21] Masternode APY |
| [A22] |
| [A23] Evonode collateral (DASH) |
| [A24] Evonode rewards (DASH) |
| [A25] Evonode collateral + rewards (DASH) |
| [A26] Evonode APY |
| [A27] |
| [A28] Monthly |
| [A29] |
| [A30] Evonode rewards (100% DASH) |
| [A31] Evonode rewards (75% CREDITS) |
| [A32] Evonode rewards (25% DASH) |
| [A33] |
| [A34] L2 (9.125 days / epoch) & L1 (5 days) |
| [A35] |
| [A36] Evonode rewards (CREDITS) every epoch (9.125 days) |
| [A37] Evonode rewards (DASH) every 5 days |
Column B (B1 to B37)
| [B1] Manually fetch from Dash Core wallet / Dashmate / DMT |
| [B2] Manually fetch from Mnowatch (https://mnowatch.org/evonodes/ see below how to exclude lines) |
| [B3] Manually fetch from Dash Core wallet / Dashmate / DMT |
| [B4] =B3-B2 |
| [B5] |
| [B6] 1.906 |
| [B7] =B6+(20/100*B6) |
| [B8] |
| [B9] =(B7/100)*60 |
| [B10] =(B9/100)*62.5 |
| [B11] =(B9/100)*37.5 |
| [B12] |
| [B13] 209664 |
| [B14] =B1+B2 |
| [B15] |
| [B16] |
| [B17] |
| [B18] 1000 |
| [B19] =B10*B13/B14 |
| [B20] =B18+B19 |
| [B21] =((B20-B18)/B18) |
| [B22] |
| [B23] 4000 |
| [B24] =B11*B13/B2+B19 |
| [B25] =B23+B24 |
| [B26] =((B25-B23)/B23) |
| [B27] |
| [B28] |
| [B29] |
| [B30] =B24/12 |
| [B31] =IF((B24/12)*0.75*100000000000 >= 1000000000000, TEXT((B24/12)*0.75*100000000000/1000000000000, "0.000") & " trillion", (B24/12)*0.75*100000000000) |
| [B32] =B19/12 |
| [B33] |
| [B34] |
| [B35] |
| [B36] =IF((B24/40)*0.75*100000000000 >= 1000000000000, TEXT((B24/40)*0.75*100000000000/1000000000000, "0.000") & " trillion", (B24/40)*0.75*100000000000) |
| [B37] =B19/365*5 |
Last updated : 1st of December 2024
Credits xkAI for providing the calculations for annual APY previously in here : https://www.dash.org/forum/index.ph...masternodes-would-get-paid.54137/#post-236537
Also i finally managed to fix my previously incorrect Masternode APY calculations, should be correct now.
Last edited: