ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This sheet will help you determine when your coins will stake and how many coins you've accumulated so far on inputs that haven't staked yet.
2
You use this sheet to figure out if it's better to combine smaller inputs of coins or just wait for them to fully stake.
3
When you combine coins that haven't staked, you will lose what has been accumulated so far.
4
NOTE: AVG DAYS LEFT AND AVG STAKE DAY ARE FOR ESTIMATION PURPOSES ONLY. It's random chance when you get your staking reward.
5
6
User-fillable cells are filled in yellow.
7
Please copy this worksheet to your own Google account to edit.
8
9
How to use this sheet:
10
Clear columns A and B so you can fill in your own values
11
Cell K2 should be filled with the current stake weight spent. This can be found by doing the following:
12
 * Go to http://www.presstab.pw/phpexplorer/EMB/index.php and look at the Stake Weight Spent graph.
13
 * Mouse over the red line at the right side for the most recent average of stake weight spent.
14
 * Input that number into cell K2
15
Cells in columns A and B are filled in manually by the user based on their coin inputs.
16
 * Turn on coin inputs in your wallet if you haven't already by going to Settings/Options/Display and check "Display coin control features"
17
 * To see your coin inputs:
18
 - Click on Send
19
 - Under Coin Control Features, click the button labeled "Inputs..."
20
 - Click "List Mode" radial button to see your inputs. You can click on the Date field to sort by date
21
Input each coin amount and date in columns A and B
22
23
Once your data has been entered, you can see how much "unrealized" staking has already accrued on each input. This, along with the expected number
24
of days before staking, will help you determinne whether it's worth combining inputs to stake faster.
25
26
Google sheet by jt42. Ember donation link: eBrKEwHXYP6TpsbgPRiSgENXc556fY4sUT
27
28
v1.9 2017-10-16: 1) Renamed Reward % to Annual stake rate for clarity and consistency in naming with daily stake rate.
2) Daily stake rate now reflects the quadratic easing calculation for future stake rate reductions.
3) Annual stake rate and Stake accum now updates based on the daily stake rate if it changes.
4) A list of annual stake rate percentages over time added, along with a stake rate graph.
5) Formula added to script editor in google sheet for quadratic stake rate calculation.
6) In the "Today's Date" field, you can enter a date in the future to see what the daily stake rate is for that date and how it affects your stake accum.
29
v1.8 2017-10-08: 1) Removed stake weight bug calculations due to updated wallet
2) Added more coin input rows
30
v1.7 2017-09-21: 1) Fixed formulas to calculate staking from the coin's start date instead of the coin's maturity date.
2) Removed "Start staking" column now that it's unnecessary. Thank you to jimmyjames for reporting this inaccuracy.
31
v1.6 2017-09-19: 1) Fixed error in Reward % when Stake Accum is blank.
2) Don't show negative number in Stake accum or Stake weight accum columns
3) Added staking chart tab so that people can see how many coins it takes to get a reward in a certain amount of days (on average) and days until stake bug
4) Staking chart tab also allows you to type a number of coins and see how many days it will take without needing to type a start date.
32
v1.5 2017-09-19: 1) Cells are labeled with notes to clarify purpose of columns
2) Dates now include times so that the stake weight bug can be identified with more precision
3) Stake accum now properly shows nothing when stake weight accum is between 38.81 and 77.62 mil, or between 116.43 to 155.24 mil to reflect the stake weight bug.
4) Stake accum now properly shows the correct reduced reward when stake weight accum is between 77.26 mil to 116.43 mil. I verified it with a blockchain transaction that got a reduced award.
5) New Reward % column to show reduced reward when applicable
6) Stake weight accum bug cheat sheet added for clarity
33
v1.4 2017-09-13: Added Stake Weight Accum column and note to explain the column
34
v1.3 2017-09-06: Fixed sum total cells, added URL for stake weight spent graph, and updated today's date from =TODAY() to =NOW() so it will auto update (thanks to kay-bear)
35
v1.2 2017-09-03: Updated Today's Date to be editable (for those in future time zones from me), will now affect calculations properly
36
v1.1 2017-09-03: fixed days left to stake and avg stake day
37
v1.0 2017-09-03: initial version
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100