(Updated with google docs link toward the bottom) A few months ago, @skcin wrote up a pretty amazing post about calculating your stake probability under the new version. https://steemit.com/gridcoin/@skcin/gridcoin-v8-difficulty-and-what-it-tells-you Being a math nut, I immediately dug into it to see how long it would take me to stake back when I had 200 GRC. Now that I have 1000, I looked at it again, and I took all the math and put it into a spreadsheet. It appears that the only items from skcin's list that are subject to change are the difficulty and the stake weight, so these are the only two fields I have set up for user input. Here's a screenshot of the main page. Enter in the difficulty and how many coins you have, and it'll do all the work for you.  On this page is all the math behind the scenes.  As you can see here, I have a pretty good chance of staking in a month and should definitely stake after about 2.6 months. I think I'll stay pool mining for a little while longer then. You can check out the spreadsheet here: * EDIT: Here it is on Google Docs: [GRC v8 Stake Calculator](https://docs.google.com/spreadsheets/d/1UD-tB3uaq3gj2sxK7fVYvxhtiatbOdaan-vGM07WA9E/edit?usp=sharing) * Open Office .ods version: [GRC stake math.ods](https://www.dropbox.com/s/pz226k2o4ong5pf/GRC%20stake%20math.ods?dl=0) * Microsoft Office .xls version: [GRC stake math.xls](https://www.dropbox.com/s/j1luc9awp5ert34/GRC%20stake%20math.xls?dl=0) My only concern is how drastically different it is from the info given within the wallet. On the day that I wrote up this spreadsheet, my wallet said I should stake within 11 days instead of the 1-2 months that the spreadsheet stated. Not sure why there is such big discrepancy though. Anyway, give it a look and let me know what you think.
author | alanman |
---|---|
permlink | grc-staking-calculator-spreadsheet |
category | gridcoin |
json_metadata | {"tags":["gridcoin","math","beyondbitcoin","help","spreadsheets"],"users":["skcin"],"image":["https://steemitimages.com/DQmQW9vWyELJa3dAxyjLNrjvo45tWHH99Ez5wqEYF8LqxJa/image.png","https://steemitimages.com/DQmR5Prx5o1VX5LGkaD5bBD8VeZk8UrxhihrcPmd7N7KnBR/image.png"],"links":["https://steemit.com/gridcoin/@skcin/gridcoin-v8-difficulty-and-what-it-tells-you","https://docs.google.com/spreadsheets/d/1UD-tB3uaq3gj2sxK7fVYvxhtiatbOdaan-vGM07WA9E/edit?usp=sharing","https://www.dropbox.com/s/pz226k2o4ong5pf/GRC%20stake%20math.ods?dl=0","https://www.dropbox.com/s/j1luc9awp5ert34/GRC%20stake%20math.xls?dl=0"],"app":"steemit/0.1","format":"markdown"} |
created | 2017-12-30 07:49:48 |
last_update | 2018-01-04 07:03:21 |
depth | 0 |
children | 7 |
last_payout | 2018-01-06 07:49:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 36.718 HBD |
curator_payout_value | 12.124 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,998 |
author_reputation | 3,889,830,558,864 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,008,752 |
net_rshares | 3,676,393,052,605 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
cm-steem | 0 | 100,491,867,791 | 23% | ||
vortac | 0 | 3,454,481,526,335 | 100% | ||
barton26 | 0 | 5,175,518,378 | 100% | ||
sodom | 0 | 2,195,846,205 | 100% | ||
nuad01 | 0 | 1,042,056,823 | 100% | ||
outerground | 0 | 27,230,669,093 | 100% | ||
grider123 | 0 | 9,422,300,594 | 100% | ||
carlosimf | 0 | 586,459,054 | 100% | ||
s4mmy | 0 | 2,721,925,958 | 100% | ||
king-crypto | 0 | 10,089,024,018 | 100% | ||
slapbox | 0 | 3,318,439,581 | 29% | ||
agentjuno | 0 | 603,918,373 | 100% | ||
dysprosium | 0 | 5,221,826,580 | 100% | ||
throny | 0 | 619,520,000 | 100% | ||
parejan | 0 | 9,823,283,478 | 100% | ||
alanman | 0 | 6,865,998,843 | 100% | ||
gregan | 0 | 6,232,263,124 | 100% | ||
hotbit | 0 | 11,105,104,660 | 47% | ||
caleb23 | 0 | 4,968,626,413 | 100% | ||
delta1512 | 0 | 2,678,498,393 | 100% | ||
rufusfirefly | 0 | 589,783,010 | 100% | ||
donkeykong9000 | 0 | 4,902,601,758 | 100% | ||
jamescowens | 0 | 615,320,000 | 100% | ||
wisecracka | 0 | 781,809,240 | 100% | ||
artba07965 | 0 | 289,853,129 | 100% | ||
h202 | 0 | 2,893,941,270 | 100% | ||
alexmaksto | 0 | 536,149,029 | 100% | ||
agar | 0 | 294,061,475 | 1% | ||
unoplank | 0 | 614,860,000 | 100% | ||
skyluis2000 | 0 | 0 | 100% | ||
chucklehead | 0 | 0 | 100% |
Love the way Gridcoin grows so organically through the decentralized inputs of people like you @alanman
author | masterroshi |
---|---|
permlink | re-alanman-grc-staking-calculator-spreadsheet-20171230t231849834z |
category | gridcoin |
json_metadata | {"tags":["gridcoin"],"users":["alanman"],"app":"steemit/0.1"} |
created | 2017-12-30 23:18:48 |
last_update | 2017-12-30 23:18:48 |
depth | 1 |
children | 0 |
last_payout | 2018-01-06 23:18:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.890 HBD |
curator_payout_value | 0.285 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 103 |
author_reputation | 3,720,114,262,202 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,123,029 |
net_rshares | 92,316,347,452 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
vortac | 0 | 85,318,310,170 | 2% | ||
alanman | 0 | 6,998,037,282 | 100% |
Very cool, but it would be great to have a Google Drive spreadsheet instead. Much easier to use in a one-off sort of way then.
author | slapbox |
---|---|
permlink | re-alanman-grc-staking-calculator-spreadsheet-20171230t182631090z |
category | gridcoin |
json_metadata | {"tags":["gridcoin"],"app":"steemit/0.1"} |
created | 2017-12-30 18:26:33 |
last_update | 2017-12-30 18:26:33 |
depth | 1 |
children | 1 |
last_payout | 2018-01-06 18:26:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.087 HBD |
curator_payout_value | 0.020 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 126 |
author_reputation | 1,128,811,501,071 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,090,558 |
net_rshares | 8,337,274,588 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
berniesanders | 0 | 0 | 0% | ||
nextgencrypto | 0 | 0 | 0% | ||
danknugs | 0 | 0 | 0% | ||
the.bot | 0 | 0 | 0% | ||
ozchartart | 0 | 0 | 0% | ||
thecyclist | 0 | 0 | 0% | ||
engagement | 0 | 0 | 0% | ||
theyeti | 0 | 0 | 0% | ||
randomthoughts | 0 | 0 | 0% | ||
dwolfe | 0 | 1,075,160,427 | 100% | ||
thedelegator | 0 | 0 | 0% | ||
thesloth | 0 | 0 | 0% | ||
alanman | 0 | 7,262,114,161 | 100% | ||
ngc | 0 | 0 | 0% |
Great idea! Will do! Edit: Done! Here's a link: https://docs.google.com/spreadsheets/d/1UD-tB3uaq3gj2sxK7fVYvxhtiatbOdaan-vGM07WA9E/edit?usp=sharing I'll update the post with it too!
author | alanman |
---|---|
permlink | re-slapbox-re-alanman-grc-staking-calculator-spreadsheet-20171231t054525080z |
category | gridcoin |
json_metadata | {"tags":["gridcoin"],"app":"steemit/0.1","links":["https://docs.google.com/spreadsheets/d/1UD-tB3uaq3gj2sxK7fVYvxhtiatbOdaan-vGM07WA9E/edit?usp=sharing"]} |
created | 2017-12-31 05:44:27 |
last_update | 2017-12-31 06:10:54 |
depth | 2 |
children | 0 |
last_payout | 2018-01-07 05:44:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.110 HBD |
curator_payout_value | 0.032 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 185 |
author_reputation | 3,889,830,558,864 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,162,767 |
net_rshares | 11,821,952,691 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
slapbox | 0 | 11,821,952,691 | 100% |
Congratulations @alanman! You have completed some achievement on Steemit and have been rewarded with new badge(s) : [](http://steemitboard.com/@alanman) Award for the number of upvotes [](http://steemitboard.com/@alanman) Award for the number of upvotes received Click on any badge to view your own Board of Honor on SteemitBoard. For more information about SteemitBoard, click [here](https://steemit.com/@steemitboard) If you no longer want to receive notifications, reply to this comment with the word `STOP` > By upvoting this notification, you can help all Steemit users. Learn how [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!
author | steemitboard |
---|---|
permlink | steemitboard-notify-alanman-20171231t090915000z |
category | gridcoin |
json_metadata | {"image":["https://steemitboard.com/img/notifications.png"]} |
created | 2017-12-31 09:09:15 |
last_update | 2017-12-31 09:09:15 |
depth | 1 |
children | 0 |
last_payout | 2018-01-07 09:09:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.090 HBD |
curator_payout_value | 0.019 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 846 |
author_reputation | 38,975,615,169,260 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,183,755 |
net_rshares | 8,985,078,876 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
alanman | 0 | 8,407,778,046 | 100% | ||
rufusfirefly | 0 | 577,300,830 | 100% |
Great stuff! You should announce it on our [Reddit](https://www.reddit.com/r/gridcoin), where we always have plenty of newbs asking "how many GRC do I need to stake"
author | vortac |
---|---|
permlink | re-alanman-grc-staking-calculator-spreadsheet-20171230t223913985z |
category | gridcoin |
json_metadata | {"tags":["gridcoin"],"links":["https://www.reddit.com/r/gridcoin"],"app":"steemit/0.1"} |
created | 2017-12-30 22:39:15 |
last_update | 2017-12-30 22:40:06 |
depth | 1 |
children | 2 |
last_payout | 2018-01-06 22:39:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.099 HBD |
curator_payout_value | 0.019 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 165 |
author_reputation | 8,395,136,954,900 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,118,987 |
net_rshares | 9,755,004,147 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
alanman | 0 | 7,130,075,722 | 100% | ||
delta1512 | 0 | 2,624,928,425 | 100% | ||
chucklehead | 0 | 0 | 100% |
Great idea! I'll take Slapbox's advice and make it a google doc, then I'll drop it over on reddit. Thanks.
author | alanman |
---|---|
permlink | re-vortac-re-alanman-grc-staking-calculator-spreadsheet-20171231t054725074z |
category | gridcoin |
json_metadata | {"tags":["gridcoin"],"app":"steemit/0.1"} |
created | 2017-12-31 05:46:27 |
last_update | 2017-12-31 05:46:27 |
depth | 2 |
children | 0 |
last_payout | 2018-01-07 05:46:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 2.214 HBD |
curator_payout_value | 0.736 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 107 |
author_reputation | 3,889,830,558,864 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,162,957 |
net_rshares | 234,563,560,430 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
vortac | 0 | 234,563,560,430 | 6% |
Posted! https://www.reddit.com/r/gridcoin/comments/7nl16l/grc_v8_stake_calculator/
author | alanman |
---|---|
permlink | re-vortac-re-alanman-grc-staking-calculator-spreadsheet-20180102t074633758z |
category | gridcoin |
json_metadata | {"tags":["gridcoin"],"links":["https://www.reddit.com/r/gridcoin/comments/7nl16l/grc_v8_stake_calculator/"],"app":"steemit/0.1"} |
created | 2018-01-02 07:46:36 |
last_update | 2018-01-02 07:46:36 |
depth | 2 |
children | 0 |
last_payout | 2018-01-09 07:46:36 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.768 HBD |
curator_payout_value | 0.254 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 83 |
author_reputation | 3,889,830,558,864 |
root_title | "GRC Staking Calculator Spreadsheet" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,510,478 |
net_rshares | 85,329,483,810 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
vortac | 0 | 85,329,483,810 | 2% |