A Excel for calculate your Self-Voting return

[原創分享]一個計算大家的自我Voting的回報的Excel表格

---

From @jerrybanfield's post about upvoting ourselves and get double steem power every 181 days. (https://steemit.com/hf20/@jerrybanfield/we-double-our-steem-power-upvoting-ourselves-every-181-days) He said that after Hf19, your SP will double in 181 days if you just vote yourself 10 times a day. However, we can notice that the payout keeping drop everyday, due to the decline of the Rewards Pool. **You may notice that your $200 post is became $180 or even less in this morning.** @elyaque had did a chart for that (https://steemit.com/steemit/@elyaque/daily-steem-report-june-29th-steem-1-81usd-2631-new-accounts)

在@jerrybanfield 老兄的文章中，我們知道靠著每天自我Voting十次的話，181天後你的steem power就會翻倍。 (https://steemit.com/hf20/@jerrybanfield/we-double-our-steem-power-upvoting-ourselves-every-181-days) 但是！我們細心觀察的話，可以發現我們的收入一天比一天少。因為 Rewards Pool 減少的關系。 **你可能會發現昨天還值$200的帖子，今天已經變成了$180或是更少…** @elyaque 老兄就做了一個相關圖表 (https://steemit.com/steemit/@elyaque/daily-steem-report-june-29th-steem-1-81usd-2631-new-accounts)

***

So, what is the actual return in this moment?

所以要怎樣計算準確的回報？

In order to solve this question, I have done a Excel for it. Base on the condition that you self-voting you comment everyday 10 times. You may download it in here :

為了解決這個問題，我製作了一個Excel表格。以每天自我Voting十次自己的comment作為條件。你可以在這裡下載我的Excel表格：

---

Excel Download :

Excel下載:

https://drive.google.com/file/d/0B8NqIyR0viPJUm1tYXJ3Z2ZCLVE/view?usp=sharing

---

How to self-Voting? Upvote your comment with only one vote from you, then you can get all the payout from that vote, no need to pay the Curators.

怎樣自我Voting? Upvote 自己的comment，盡量就只有自己的一vote，這樣就得取全取的vote的回報，不用分給Curators。

---

How to use?
怎樣使用？

1. Input the variable in the yellow field
2. 輸入資料在黃色的格子上

Steem power = Your steem power / your existing steem power + the steem power you want to invest (你現有的 steem power / 你現有的 steem power 加上你打等投資的 steem power )
SBD/USD = https://coinmarketcap.com/currencies/steem-dollars/
Steem/USD = https://coinmarketcap.com/currencies/steem/
USD/HKD = https://www.google.com.hk/webhp#safe=off&q=USD/HKD
USD/RMB = https://www.google.com.hk/webhp#safe=off&q=USD/RMB

SP/Vote Value Ratio = SP / "100%upvote worth" * "voting power"
You can get the data from https://steemnow.com/"@yourusername"
(可由 https://steemnow.com/"@你的使用者名稱" 獲得資料)

E.g. for my ac now, it is 351.913/0.17 * 93.71% = 2001 (Yesterday was ~18xx)
(例如我的戶口是351.913/0.17 * 93.71% = 2001 (昨天是約 18xx))

This is important to update the ratio everyday, as it depend on the Rewards Pool.
每天update很重要，因為每天Rewards Pool都會變，這個比例受Rewards Pool影響

1. Get the result
2. 得到資料
   

---

Please upvote and follow me if you like it!
如喜歡的話，請upvote和follow我!

---