create account

GRC Staking Calculator Spreadsheet by alanman

View this thread on: hive.blogpeakd.comecency.com
· @alanman · (edited)
$48.84
GRC Staking Calculator Spreadsheet
(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.
![display](https://steemitimages.com/DQmQW9vWyELJa3dAxyjLNrjvo45tWHH99Ez5wqEYF8LqxJa/image.png)

On this page is all the math behind the scenes.
![math bits](https://steemitimages.com/DQmR5Prx5o1VX5LGkaD5bBD8VeZk8UrxhihrcPmd7N7KnBR/image.png)

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.
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authoralanman
permlinkgrc-staking-calculator-spreadsheet
categorygridcoin
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"}
created2017-12-30 07:49:48
last_update2018-01-04 07:03:21
depth0
children7
last_payout2018-01-06 07:49:48
cashout_time1969-12-31 23:59:59
total_payout_value36.718 HBD
curator_payout_value12.124 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,998
author_reputation3,889,830,558,864
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,008,752
net_rshares3,676,393,052,605
author_curate_reward""
vote details (31)
@masterroshi ·
$1.18
Love the way Gridcoin grows so organically through the decentralized inputs of people like you @alanman
👍  ,
properties (23)
authormasterroshi
permlinkre-alanman-grc-staking-calculator-spreadsheet-20171230t231849834z
categorygridcoin
json_metadata{"tags":["gridcoin"],"users":["alanman"],"app":"steemit/0.1"}
created2017-12-30 23:18:48
last_update2017-12-30 23:18:48
depth1
children0
last_payout2018-01-06 23:18:48
cashout_time1969-12-31 23:59:59
total_payout_value0.890 HBD
curator_payout_value0.285 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length103
author_reputation3,720,114,262,202
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,123,029
net_rshares92,316,347,452
author_curate_reward""
vote details (2)
@slapbox ·
$0.11
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.
👍  , , , , , , , , , , , , ,
properties (23)
authorslapbox
permlinkre-alanman-grc-staking-calculator-spreadsheet-20171230t182631090z
categorygridcoin
json_metadata{"tags":["gridcoin"],"app":"steemit/0.1"}
created2017-12-30 18:26:33
last_update2017-12-30 18:26:33
depth1
children1
last_payout2018-01-06 18:26:33
cashout_time1969-12-31 23:59:59
total_payout_value0.087 HBD
curator_payout_value0.020 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length126
author_reputation1,128,811,501,071
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,090,558
net_rshares8,337,274,588
author_curate_reward""
vote details (14)
@alanman · (edited)
$0.14
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!
👍  
properties (23)
authoralanman
permlinkre-slapbox-re-alanman-grc-staking-calculator-spreadsheet-20171231t054525080z
categorygridcoin
json_metadata{"tags":["gridcoin"],"app":"steemit/0.1","links":["https://docs.google.com/spreadsheets/d/1UD-tB3uaq3gj2sxK7fVYvxhtiatbOdaan-vGM07WA9E/edit?usp=sharing"]}
created2017-12-31 05:44:27
last_update2017-12-31 06:10:54
depth2
children0
last_payout2018-01-07 05:44:27
cashout_time1969-12-31 23:59:59
total_payout_value0.110 HBD
curator_payout_value0.032 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length185
author_reputation3,889,830,558,864
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,162,767
net_rshares11,821,952,691
author_curate_reward""
vote details (1)
@steemitboard ·
$0.11
Congratulations @alanman! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/votes.png)](http://steemitboard.com/@alanman) Award for the number of upvotes
[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png)](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)!
👍  ,
properties (23)
authorsteemitboard
permlinksteemitboard-notify-alanman-20171231t090915000z
categorygridcoin
json_metadata{"image":["https://steemitboard.com/img/notifications.png"]}
created2017-12-31 09:09:15
last_update2017-12-31 09:09:15
depth1
children0
last_payout2018-01-07 09:09:15
cashout_time1969-12-31 23:59:59
total_payout_value0.090 HBD
curator_payout_value0.019 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length846
author_reputation38,975,615,169,260
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,183,755
net_rshares8,985,078,876
author_curate_reward""
vote details (2)
@vortac · (edited)
$0.12
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"
👍  , ,
properties (23)
authorvortac
permlinkre-alanman-grc-staking-calculator-spreadsheet-20171230t223913985z
categorygridcoin
json_metadata{"tags":["gridcoin"],"links":["https://www.reddit.com/r/gridcoin"],"app":"steemit/0.1"}
created2017-12-30 22:39:15
last_update2017-12-30 22:40:06
depth1
children2
last_payout2018-01-06 22:39:15
cashout_time1969-12-31 23:59:59
total_payout_value0.099 HBD
curator_payout_value0.019 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length165
author_reputation8,395,136,954,900
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,118,987
net_rshares9,755,004,147
author_curate_reward""
vote details (3)
@alanman ·
$2.95
Great idea! I'll take Slapbox's advice and make it a google doc, then I'll drop it over on reddit.  Thanks.
👍  
properties (23)
authoralanman
permlinkre-vortac-re-alanman-grc-staking-calculator-spreadsheet-20171231t054725074z
categorygridcoin
json_metadata{"tags":["gridcoin"],"app":"steemit/0.1"}
created2017-12-31 05:46:27
last_update2017-12-31 05:46:27
depth2
children0
last_payout2018-01-07 05:46:27
cashout_time1969-12-31 23:59:59
total_payout_value2.214 HBD
curator_payout_value0.736 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length107
author_reputation3,889,830,558,864
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,162,957
net_rshares234,563,560,430
author_curate_reward""
vote details (1)
@alanman ·
$1.02
Posted!

https://www.reddit.com/r/gridcoin/comments/7nl16l/grc_v8_stake_calculator/
👍  
properties (23)
authoralanman
permlinkre-vortac-re-alanman-grc-staking-calculator-spreadsheet-20180102t074633758z
categorygridcoin
json_metadata{"tags":["gridcoin"],"links":["https://www.reddit.com/r/gridcoin/comments/7nl16l/grc_v8_stake_calculator/"],"app":"steemit/0.1"}
created2018-01-02 07:46:36
last_update2018-01-02 07:46:36
depth2
children0
last_payout2018-01-09 07:46:36
cashout_time1969-12-31 23:59:59
total_payout_value0.768 HBD
curator_payout_value0.254 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length83
author_reputation3,889,830,558,864
root_title"GRC Staking Calculator Spreadsheet"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,510,478
net_rshares85,329,483,810
author_curate_reward""
vote details (1)