I was playing around with excel today trying to figure out a formula for calculating the SP and SBD rewards given here on the site. I thought why don't I make calculator to see the "close to" reward will be, since the reward curve is very math intensive. So there is no real way to be 100% accurate. So playing with the numbers I made an excel GUI you can download and use:
Google Drive:
https://drive.google.com/open?id=1Xv0uKNZmGeNHLBy8MPNMrPOi1pHjdOdE
Works best with Microsoft Excel, but you can use Google Sheets. The only thing with Google Sheets is you will need to manually input the current price of STEEM and SBD for it to work. The Excel version has the API embedded so all you need to do is "Refresh" the "Data" tab.
Let me know what you think! As a bonus it has a @dtube calculator (-25% Author Rewards)
How to use:
Just input your reward amount into the "REWARD" box and press "ENTER"
In EXCEL just "Refresh" the Data to get an up to the minute STEEM / SBD Price
Please RESTEEM and UPVOTE if this helped you!
If any of you awesome dudes can try this out! Let me know! @brianphobos @rulesforrebels @papa-pepper @jerrybanfield @cryplectibles @jza @joeparys @exyle @davidpakman @dollarvigilante @acidyo
If you join please sign up with my affiliate link here:
Wow.. This is very very helpful, thank you
@jogrin Please RESTEEM if you think your followers will use this! Thank you.
I have just done that ,you are welcome
Great tool, I was looking for something like this. Thanks for sharing. #resteeming
Awesome, glad it works on your end! I appreciate your RS!
Its awesome. Very useful, please add for power-up post also.
You're welcome! What do you mean by Power-Up? Thanks.
@dhaneshpk Ah! I never use that. I can try to figure that out.
Nice, will check it out just for the fun of it!
Please do and report back. I played with the math on a few of my rewards to "try" to lock down a calculation that is close to what you will actually receive.
Your math is very good. But how can we double it. and is coming in the enjoy game
Hello, double what? I'm confused!
The Google spreadsheet is one of my very favorite programs except for excel thanks for the help
Simple enough, but what is the "reward"? Where do you find that number?
If you mean the "payout" listed at the bottom of your post, then why does Steemit put a DOLLAR sign in front of it, instead of having it just be a number of Steem?
Should also add a section for those choosing "100% Power-up"
Thank you. I was in dire need of this calculator.
How nice it would help me thank you very much @reseller
Keep steeming, keep smiling, be happy!
Thanks for sharing!
WTH man, it's a like chain of events, your steem followers video on youtube, led to your steemit account, which led me to your videos on D.tube, which Actually led me here to your calculator here 🌟 ✌
https://steemit.com/introduceyourself/@cyrexxlm/introduceyourself
https://steemfollower.com/?r=9710
this is actually amazing mate, re-discovered thank you so much for creating this I've been trying to figure this out for about a week now and its creative buggers like you that further us all, BIG LOVE
This was so helpful!! Thank you very much.
This is so lovely abd helpful thanks