Voting Power Matters? 能量需要恢复满么？
cn
10 minutes read (About 1574 words)

Voting Power Matters? 能量需要恢复满么？


Image Credit: Pixabay.com

We all know that each 100% vote costs your 2% voting power, and every 24 hours, your voting power restores 20%. This means that you can vote 10 times at 100% one day and the voting power will remain the same the next day.

The question comes: Given a 30 days period, and approximately 60% voting power at the day 1, is there a much bigger gain to restore your voting power to 100% (wait 2 days) ?

I always thought there is not much difference in terms of total curation earnings until today.. I wrote a VBScript that reveals the truth.

The first strategy, just vote 10 times 100% per day every day in the 30 days’ period. Assume 10K SP 100% gives 1 SBD. And suppose the 10 votes are done in a row (the VP restored during upvotes can be ignored)

1
2
3
4
5
6
7
8
9
10
11
12
Function Strategy1(ByVal sp, ByVal vp, ByVal days)
	income = 0
	While days > 0
		For i = 1 To 10
			income = income + sp * vp / 10000
			vp = vp - 0.02
		Next	
		vp = vp + 0.2
		days = days - 1
	Wend 
	Strategy1 = income
End Function

The second strategy, let’s wait a few days before the VP is restored, adding a parameter rest in the unit of days.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Function Strategy2(ByVal sp, ByVal vp, ByVal days, ByVal rest)
	days = days - rest
	vp = vp + 0.2 * rest  ' 1 day restores 20%
	If vp > 1 Then
		vp = 1  ' voting power can only be maximum 100%
	End If 
	income = 0
	
	While days > 0
		For i = 1 To 10
			income = income + sp * vp / 10000
			vp = vp - 0.02
		Next	
		vp = vp + 0.2
		days = days - 1
	Wend 
	Strategy2 = income
End Function

In my case, I have 10K SP so let’s assume these values:

1
2
3
4
steempower = 10000
votingpower = 0.6
daysofcuration = 30
restoredays = 2

So the simulation gives:

1
2
3
4
5
6
WScript.Echo ("Strategy 1 Max Income = " & Strategy1(steempower, votingpower, daysofcuration))
WScript.Echo ("Strategy 2 Max Income = " & Strategy2(steempower, votingpower, daysofcuration, restoredays))


Strategy 1 Max Income = 152.999999999999
Strategy 2 Max Income = 254.799999999999

This is a BIGGGGGGGGG difference! The lower voting power, longer periods, the bigger difference! So…. you might consider letting your upvoting robot take a few days’ rest…

Correction @tumutanzi told me my understanding was not exactly right. The 2% loss is to the current VP, so instead of vp = vp - 0.02 the correct version is vp = vp * 0.98.

So the correct version to emulate steemit curator is (you can vote 11 times per day)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Function Strategy1(ByVal sp, ByVal vp, ByVal days)
	income = 0
	While days > 0
		For i = 1 To 11
			income = income + sp * vp / 10000
			vp = vp * 0.98
		Next	
		vp = vp + 0.2
		If (vp > 1) Then
			vp = 1
		End If 
		days = days - 1
	Wend 
	Strategy1 = income
End Function 

Function Strategy2(ByVal sp, ByVal vp, ByVal days, ByVal rest)
	days = days - rest
	vp = vp + 0.2 * rest
	If vp > 1 Then
		vp = 1
	End If 
	income = 0
	
	While days > 0
		For i = 1 To 11
			income = income + sp * vp / 10000
			vp = vp * 0.98
		Next	
		vp = vp + 0.2
		If (vp > 1) Then
			vp = 1
		End If 		
		days = days - 1
	Wend 
	Strategy2 = income
End Function

And this gives totally different results, 

1
2
3
4
5
6
7
steempower = 10000
votingpower = 0.6
daysofcuration = 30
restoredays = 2

WScript.Echo ("Strategy 1 Max Income = " & Strategy1(steempower, votingpower, daysofcuration))
WScript.Echo ("Strategy 2 Max Income = " & Strategy2(steempower, votingpower, daysofcuration, restoredays))

It indicates there is NOT much difference at all!

1
2
Strategy 1 Max Income = 279.67590316366
Strategy 2 Max Income = 278.976108950286

Image Credit: Pixabay.com

虽然说小鱼的点赞策略就是喜欢的点，因为SP少点赞收益没有多少区别，但是现在 @justyy 已经有超过1万的SP 了，所以今天想了一下这么一个问题。

我们都知道，一次100%点赞消耗能量 2%，一天恢复20%的能量相当于一天中你可以点满10次。那么问题就是，假设30天时间内，你一天点10次，最大收益是多少？

为了简化分析模型，我们假设1万SP能量全满点赞收益是1 SBD，那么如果初始能量只有60%，我们是不是需要等恢复了90%甚至是全满后再点这样效果会好一点呢？

我本来以为没啥区别，直到今天晚上无聊随便写了段VBScript代码来分析，结果让我很吃惊。

第一种策略，从第一天就开始点满10次，假设这10次都是一下子点完，两次点赞间的能量恢复可以忽略不计，那么我们可以用以下代码来模拟：

1
2
3
4
5
6
7
8
9
10
11
12
Function Strategy1(ByVal sp, ByVal vp, ByVal days)
	income = 0
	While days > 0
		For i = 1 To 10
			income = income + sp * vp / 10000
			vp = vp - 0.02
		Next	
		vp = vp + 0.2
		days = days - 1
	Wend 
	Strategy1 = income
End Function

第二种策略，多加了一个参数，先休息几天，恢复恢复能量，然后再点。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Function Strategy2(ByVal sp, ByVal vp, ByVal days, ByVal rest)
	days = days - rest
	vp = vp + 0.2 * rest  ' 每天恢复20%
	If vp > 1 Then
		vp = 1  ' 能量最多恢复到100%
	End If 
	income = 0
	
	While days > 0
		For i = 1 To 10
			income = income + sp * vp / 10000
			vp = vp - 0.02
		Next	
		vp = vp + 0.2
		days = days - 1
	Wend 
	Strategy2 = income
End Function

我有1万SP，那么假定这些值。

1
2
3
4
steempower = 10000
votingpower = 0.6
daysofcuration = 30
restoredays = 2

跑一下程序看看结果：

1
2
3
4
5
6
WScript.Echo ("Strategy 1 Max Income = " & Strategy1(steempower, votingpower, daysofcuration))
WScript.Echo ("Strategy 2 Max Income = " & Strategy2(steempower, votingpower, daysofcuration, restoredays))


Strategy 1 Max Income = 152.999999999999
Strategy 2 Max Income = 254.799999999999

太意外了，你的VP越低，统计时间越长，效果差别就越大，OMG，还是先让机器人缓几天吧，至少点赞比率先降一降，等恢复了差不多了这样每天保持10次点赞 点完能量保持在80%左右，这样是最优的。

错啦错啦 @tumutanzi 告诉我，我的理解有问题， 2%的损失不是 vp = vp - 0.02 而是针对当前VP能量，所以应该是vp = vp * 0.98.

程序更正一下，每天可以点11次，点10次能量满的话就会浪费：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Function Strategy1(ByVal sp, ByVal vp, ByVal days)
	income = 0
	While days > 0
		For i = 1 To 11
			income = income + sp * vp / 10000
			vp = vp * 0.98
		Next	
		vp = vp + 0.2
		If (vp > 1) Then
			vp = 1
		End If 
		days = days - 1
	Wend 
	Strategy1 = income
End Function 

Function Strategy2(ByVal sp, ByVal vp, ByVal days, ByVal rest)
	days = days - rest
	vp = vp + 0.2 * rest
	If vp > 1 Then
		vp = 1
	End If 
	income = 0
	
	While days > 0
		For i = 1 To 11
			income = income + sp * vp / 10000
			vp = vp * 0.98
		Next	
		vp = vp + 0.2
		If (vp > 1) Then
			vp = 1
		End If 		
		days = days - 1
	Wend 
	Strategy2 = income
End Function

假定以下值：

1
2
3
4
5
6
7
steempower = 10000
votingpower = 0.6
daysofcuration = 30
restoredays = 2

WScript.Echo ("Strategy 1 Max Income = " & Strategy1(steempower, votingpower, daysofcuration))
WScript.Echo ("Strategy 2 Max Income = " & Strategy2(steempower, votingpower, daysofcuration, restoredays))

这结果显示，没啥区别，不得不说，这系统设计的真巧妙。是我没弄清楚，丢人了（捂脸）

1
2
Strategy 1 Max Income = 279.67590316366
Strategy 2 Max Income = 278.976108950286

> @justyy 是 https://justyy.com 的博主，在 @tumutanzi 大哥 的介绍下加入 STEEMIT，写些帖子挣些小钱养家糊口。

@justyy 也是CN 区的点赞机器人，对优质内容点赞，只要代理给 @justyy 每天收利息（年化率14.6%）并能获得一次至少2倍(VP 200%+)的点赞，大鱼 @htliao 都加入了这个计划(530 SP)表示支持。

  1. cn区最低保障系统 上线了!
  2. cn区低保计划（鼓励新人）真的适合你么？

最佳点赞策略

Steemit Upvoting Strategy

SteemIt SP Delegation Tool 简易SP代理工具
Steemit 在线工具和API接口
SteemIt Tools and APIs

This page is synchronized from the post: Voting Power Matters? 能量需要恢复满么？

SteemIt SP Delegation Tool 简易SP代理工具
cn
4 minutes read (About 666 words)

SteemIt SP Delegation Tool 简易SP代理工具


Image Credit: Pixabay.com

Currently, around 40 Steemians in CN community delegate around 6400 SP to @justyy who will send daily interests (currently at 14.6% APR) and upvote the delegator’s content worth of 200% vote (at least once per day).

Many have trouble using steemconnect.com to fill the delegate request because they don’t know how to fill the URL according to requirement and it is obviously not user-friendly…

Therefore, here comes with this tiny tool

Tool URL: https://helloacm.com/tools/steemit/sp-delegate-form/

It allows you enter the delegator ID (optionally, means ‘you’ if left empty), delegatee ID and the amount of SP or VESTS to delegate.

Click the button will redirect you to steemconnect.com with correct URL parameters so it won’t go wrong!

当前，加入CN区低保银行的一共有40个人，一共代理给 @justyy 银行大约 6400 SP。 好处是每天能收利息 （14.6% 年化率） 并且能获得至少一次的双倍点赞。

代理的方式是通过 steemconnect.com 但是很多人都搞错，因为 steemconnect.com 并没有提供一个前端的界面可供填写。

所以，我又造了一个简单的轮子 。

工具地址: https://helloacm.com/tools/steemit/delegate-form/

这个在线工具可以让你填写被代理者

点击按钮将转到 steemconnect.com 进行代理前的确认，输入钥匙前请确保您访问的是 steemconnect.com！

> @justyy 是 https://justyy.com 的博主，在 @tumutanzi 大哥 的介绍下加入 STEEMIT，写些帖子挣些小钱养家糊口。

@justyy 也是CN 区的点赞机器人，对优质内容点赞，只要代理给 @justyy 每天收利息（年化率14.6%）并能获得一次至少2倍(VP 200%+)的点赞，大鱼 @htliao 都加入了这个计划(530 SP)表示支持。

  1. cn区最低保障系统 上线了!
  2. cn区低保计划（鼓励新人）真的适合你么？

STEEMIT 简易SP代理工具

The SteemIt SP Delegation Tool

Steemit 在线工具和API接口
SteemIt Tools and APIs

This page is synchronized from the post: SteemIt SP Delegation Tool 简易SP代理工具

Daily #CN Updates CN社区每日榜单【潜在收益排行榜】【优秀被错过的文章】【低保计划参与者】【优质内容点赞记录】(2017-10-17)
cn
10 minutes read (About 1464 words)

Daily #CN Updates CN社区每日榜单【潜在收益排行榜】【优秀被错过的文章】【低保计划参与者】【优质内容点赞记录】(2017-10-17)

数据来源: steemsql.com (Thank you @arcange !)
生成时间: 2017-10-17 11:11:13 (UTC)
报告时间: 2017-10-13 11:11:13 (UTC) - 2017-10-14 11:11:13 (UTC)

2017-10-17 那些优秀可能被错过的文章


Image Credit: pixabay.com
| | 作者 Author| 文章 Post|
|———-|:————-:|:——|
| 1 | @berlin1997 | 我的故乡在远方 月旦评征文 |
| 2 | @victory622 | 是真的喜欢，还是随波逐流的喜欢，亦或是为了彰显自我的喜欢 |
| 3 | @travelgirl | Landscape Photography Contest - Blackcomb Mountains @ Canada - 風景攝影比賽 - 黑梳山 @ 加拿大 |
| 4 | @sunnyjolly | 多彩古都–南京 Colorful Nanjing |
| 5 | @nationalpark | Stingray City, Grand Cayman 开曼群岛的鳐鱼城 |
| 6 | @liangfengyouren | 接近300粉丝，爆一下照 |
| 7 | @xiaoshancun | 由“天才在左疯子在右”想到的 |
| 8 | @kenchung | Steemit Photo Challenge - #59 Happiness |
| 9 | @yellowbird | 推广steemit的一些认识 |
| 10 | @guyverckw | Steemitphotochallenge - Entry 1 Happy face in kaleidoscope 作品1 - 萬花筒中的笑面 (by @guyverckw） |
| 12 | @bring | Steemit上一条两个半月大的小鱼 |
| 14 | @dancingapple | 【素舞手札】一开篇清谈 |
| 15 | @susanli3769 | Drawing challenge #7- Two wine glasses 两只红酒杯 |
| 17 | @drunkevil | 云南自由行 Part 3：美丽的泸沽湖 |
| 18 | @wangwenjing | 我的专属Steemit T-shirt设计 Design My Own Steemit T-Shirt |

本列表支持黑名单用于过滤经常发水文的ID，欢迎 report@justyy.com 举报。

2017-10-17 Daily Top Authors in [CN] (Last 7 Days) 每日cn社区之 过去7天潜在收益排行榜

The following is the list of top 30 daily authors in [CN] in the last 7 days sorted by potential payout. See the SQL for more details.
这是根据这篇的SQL - 经少量修改和调整统计出过去7天作者的潜在收益排行。
| 排名 Rank| 作者 Author| 发贴数 Posts| 点赞数 Votes| 潜在收益 Pending Payout| 平均每贴收益 Average Pending Payout Per Post|
|–:|–:|–:|–:|—:|—:|
| 1| @oflyhigh | 8 | 2346 | 1395.33 |174.42 |
| 2| @rivalhw | 7 | 1113 | 912.84 |130.41 |
| 3| @htliao | 7 | 1277 | 886.55 |126.65 |
| 4| @deanliu | 6 | 1338 | 841.76 |140.29 |
| 5| @sweetsssj | 2 | 2763 | 807.80 |403.90 |
| 6| @tumutanzi | 7 | 1171 | 770.84 |110.12 |
| 7| @someone | 6 | 961 | 755.95 |125.99 |
| 8| @linuslee0216 | 6 | 859 | 611.99 |102.00 |
| 9| @aaronli | 7 | 861 | 530.94 |75.85 |
| 10| @guyverckw | 12 | 1143 | 508.69 |42.39 |
| 11| @hannahwu | 6 | 625 | 499.21 |83.20 |
| 12| @blackbunny | 6 | 654 | 495.69 |82.62 |
| 13| @jubi | 7 | 537 | 459.91 |65.70 |
| 14| @justyy | 18 | 1213 | 448.09 |24.89 |
| 15| @chinadaily | 14 | 763 | 446.23 |31.87 |
| 16| @twinkledrop | 7 | 374 | 397.46 |56.78 |
| 17| @nicolemoker | 3 | 556 | 387.20 |129.07 |
| 18| @bxt | 8 | 408 | 380.50 |47.56 |
| 19| @rea | 1 | 851 | 376.21 |376.21 |
| 20| @joythewanderer | 6 | 695 | 357.34 |59.56 |
| 21| @ace108 | 26 | 1662 | 331.03 |12.73 |
| 22| @helene | 3 | 533 | 319.40 |106.47 |
| 23| @travelgirl | 14 | 793 | 310.62 |22.19 |
| 24| @susanli3769 | 8 | 321 | 305.00 |38.12 |
| 25| @dapeng | 18 | 601 | 301.60 |16.76 |
| 26| @goodboyphilip | 7 | 608 | 283.36 |40.48 |
| 27| @victorier | 5 | 486 | 271.83 |54.37 |
| 28| @coldhair | 6 | 479 | 254.38 |42.40 |
| 29| @czechglobalhosts | 7 | 353 | 231.22 |33.03 |
| 30| @tvb | 7 | 353 | 228.79 |32.68 |

以上收益包括75%的作者收益(Author Rewards)和25%的点赞收益(Curation Rewards)。
@dailystats 提供过去7天全网潜在收益前30名的排名
check @dailystats for top 30 daily authors in the last 7 days sorted by potential payout

CN 区优质内容点赞机器人每天会为这30名作者点赞！
CN Good-Content-Body will upvote these authors every day!

近期机器人点赞记录 Recent Quality-Content-Upvote-Bot Upvoting History

这个机器人很善良，只想激励CN社区产生更多的优质内容。当然别忘记了，我本人人工也是会对未上榜的优质作者进行点赞的哟~

时间 Time 作者 Author 文章 Post 权重 Weighting % VP %
2017-10-17 00:15:50 @nationalpark @nationalpark 25.63 58.94
2017-10-17 01:57:25 @victorier @victorier 26.96 57.03
2017-10-17 01:57:26 @victorier @victorier 26.96 57.03
2017-10-17 03:17:25 @ace108 @ace108 33.23 57.62
2017-10-17 03:17:44 @shenchensucc @shenchensucc 25.17 57.62
2017-10-17 03:56:28 @aaronli @aaronli 38.50 58.01
2017-10-17 06:06:19 @ace108 @ace108 34.18 59.56
2017-10-17 06:42:21 @hannahwu @hannahwu 39.22 59.26
2017-10-17 07:54:34 @guyverckw @guyverckw 40.33 59.37
2017-10-17 08:24:17 @travelgirl @travelgirl 27.86 59.37
2017-10-17 08:27:35 @czechglobalhosts @czechglobalhosts 25.78 59.37
2017-10-17 08:47:40 @ygern @ygern 25.71 59.17
2017-10-17 09:07:33 @deanliu @deanliu 40.18 59.13
2017-10-17 09:11:19 @oflyhigh @oflyhigh 31.90 59.13
2017-10-17 09:11:07 @oflyhigh @oflyhigh 31.90 59.13
2017-10-17 09:36:19 @czechglobalhosts @czechglobalhosts 25.51 58.59

这个报告的年龄为: 53天。
为什么要有这个报告？
欢迎 @justyy 如果您有好的建议或者想看哪些榜单却找不到。

@justyy 是 https://justyy.com 的博主，在大哥 @tumutanzi 的介绍下加入 STEEMIT，写些帖子挣些小钱养家糊口。@justyy 也是CN 区的点赞机器人，对优质内容进行点赞，只要代理给 @justyy 每天收利息(100 SP 每天0.04 SBD)并且能获得一次相应至少2倍的点赞，可以认为是VP 200%+。加入计划最低代理10SP。CN 区的大鱼 @htliao 也加入了计划（代理了 530 SP）。

  1. CN 区最低保障系统 上线了!
  2. CN 区低保计划（鼓励新人）真的适合你么？
  3. CN 区优质内容点赞机器人上线了!
  4. 点赞机器人每日点赞记录整合到每日报表中！
  5. 虽然不挣钱，但是CN区低保计划还会继续下去

CN 区低保计划当前39位参于者，感谢！

查询谁都参于了也可以用这个在线工具: Steemit 查看谁委派代理给你Steem Power？。
|Delegator| Steem Power| Vests| DateTime|
|–:|–:|–:|–:|
|@eduter|660.15|1357975.69|2017-10-12 21:10:21|
|@herlife|600.01|1234249.59|2017-10-17 05:18:24|
|@htliao|530.38|1091019.80|2017-10-03 12:00:48|
|@bobdos|500.06|1028645.75|2017-10-15 05:45:30|
|@sunnyjolly|400.56|823973.51|2017-09-20 09:40:21|
|@mrpointp|400.39|823619.84|2017-09-28 14:09:36|
|@zsilence|300.37|617872.78|2017-09-23 16:04:45|
|@mrspointm|300.29|617714.93|2017-09-28 14:07:18|
|@breathewind|300.01|617144.23|2017-10-16 14:32:00|
|@victory622|266.39|547985.69|2017-09-18 21:59:57|
|@coldhair|255.08|524713.00|2017-09-19 15:08:36|
|@luneknight|210.2|432399.70|2017-09-28 14:55:39|
|@berlin1997|200.21|411835.88|2017-09-27 08:55:06|
|@kangnajiang|117.05|240787.09|2017-10-08 10:12:12|
|@zhijun|100.56|206853.00|2017-09-19 03:18:57|
|@yellowbird|100.14|205996.48|2017-09-20 02:52:51|
|@jessicameng|100.14|205993.57|2017-09-20 09:14:24|
|@fr3eze|100.11|205931.08|2017-09-26 03:17:24|
|@karasui|100.11|205926.99|2017-09-26 12:31:09|
|@jiangchen|100.09|205895.44|2017-09-29 11:36:09|
|@drunkevil|100.09|205885.32|2017-09-30 10:23:51|
|@catwomanteresa|100.09|205883.35|2017-09-30 14:50:03|
|@joythewanderer|100.0|205714.60|2017-10-16 14:51:15|
|@mumingduozi|60.25|123928.00|2017-09-19 00:25:12|
|@towardsthesun|50.07|102993.29|2017-09-21 00:33:18|
|@liumei|50.06|102983.93|2017-09-22 17:35:12|
|@tvb|50.04|102943.21|2017-09-30 07:54:27|
|@veronicazhu|50.03|102913.15|2017-10-06 00:26:30|
|@syh7758520|30.04|61802.26|2017-09-19 02:37:42|
|@raywang|30.03|61779.27|2017-09-26 03:40:09|
|@feng1925|20.03|41198.84|2017-09-20 07:52:30|
|@liangfengyouren|20.03|41192.83|2017-09-23 01:40:00|
|@mangoanddaddy|20.02|41189.47|2017-09-24 14:37:42|
|@speeding|20.02|41182.20|2017-09-28 00:34:57|
|@susanli3769|20.02|41176.13|2017-09-30 20:51:39|
|@wangwenjing|10.01|20598.79|2017-09-20 21:35:18|
|@lixing|10.01|20596.48|2017-09-23 00:14:33|
|@willwangfeng|10.0|20576.13|2017-10-12 04:24:57|
|@keepup|6.0|12344.23|2017-10-14 11:06:12|

Steemit 在线工具和API接口
SteemIt Tools and APIs

This page is synchronized from the post: Daily #CN Updates CN社区每日榜单【潜在收益排行榜】【优秀被错过的文章】【低保计划参与者】【优质内容点赞记录】(2017-10-17)

R Tutorial - Knowing when a Steem Whale vote? R 教程之 STEEM大鲸啥时候点赞的？
cn
7 minutes read (About 1069 words)

R Tutorial - Knowing when a Steem Whale vote? R 教程之 STEEM大鲸啥时候点赞的？

It is useful to know when a whale votes normally during a day so that you could publish your post right at a time when the whale has a higher voting power. With @arcange ‘s STEEMSQL and R, this becomes so much easy.

For example, I want to know when my best friend @tumutanzi upvotes with his amazing steem power delegated from @ned , we need this STEEMSQL:

1
select DATEPART(hour, timestamp) "hour", count(1) "count" from TxVotes where voter='tumutanzi' and datediff(day, timestamp, GetUTCDate()) between 0 and 30 group by DATEPART(hour, timestamp)

between 0 and 30 means we are extracting data for the last 30 days. And we group the results by DATEPART(hour, timestamp) which is the hour in UTC time zone.

Now, we wrap this in the R function, like what we did before:

1
2
3
4
5
6
votes_hour = function(id) {
  conn <- odbcDriverConnect("Driver=SQL Server Native Client 11.0;Server=sql.steemsql.com;Database=DBSteem;Uid=steemit;Pwd=steemit")
  x <- sqlQuery(conn, str_c("select DATEPART(hour, timestamp) hour, count(1) count from TxVotes where voter='", id, "' and datediff(day, timestamp, GetUTCDate()) between 0 and 30 group by DATEPART(hour, timestamp)"))
  close(conn)
  return(x)
}

Here is how we use this function by passing the Steem ID.

1
2
id = "tumutanzi"
vote <- votes_hour(id)

Let’s examine the data:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
   hour count
1     1     1
2     2     5
3     3     4
4     4     7
5     5    50
6     6    74
7     7    37
8     8    77
9     9   237
10   10   136
11   11    71
12   12    53
13   13    96
14   14   223
15   15   177
16   16   220
17   17   276
18   18   297
19   19   240
20   20   494
21   21   207
22   22   176
23   23    41

OK, if we want to compute the percentage, we just need to sum up the total count and then divide each count:

1
2
total = sum(vote$count)
vote$count = vote$count / total * 100

We also need to use the plot_ly from plotly library if we want to visualize the result:

1
2
plot_ly(x=vote$hour, y=vote$count, type="bar") %>% 
  layout(autosize = F, xaxis=list(title="Hour"), yaxis=list(title="Percentage"), title=str_c("@", id))

Thanks @tumutanzi as he spends most of his afternoons and evenings upvoting good posts.


Image Credit: Pixabay.com

想知道你的贵人啥时候点的赞？我们可以通过 @arcange ‘s STEEMSQL 得到点赞的时间然后通过 R 语言很轻松的画出来。

比如，我的好基友 @tumutanzi 自从拿到 @ned 所代理的50万SP 后，是不是像他所说的，忙得连X生活都没有了呢？我们可以先用 STEEMSQL 取出数据来看看：

1
select DATEPART(hour, timestamp) "hour", count(1) "count" from TxVotes where voter='tumutanzi' and datediff(day, timestamp, GetUTCDate()) between 0 and 30 group by DATEPART(hour, timestamp)

between 0 and 30 是针对过去30天的数据，然后我们通过 DATEPART(hour, timestamp) 来分组（按UTC时区的小时）

接下来和我们以前做的一样，在R语言里封装一下。

1
2
3
4
5
6
votes_hour = function(id) {
  conn <- odbcDriverConnect("Driver=SQL Server Native Client 11.0;Server=sql.steemsql.com;Database=DBSteem;Uid=steemit;Pwd=steemit")
  x <- sqlQuery(conn, str_c("select DATEPART(hour, timestamp) hour, count(1) count from TxVotes where voter='", id, "' and datediff(day, timestamp, GetUTCDate()) between 0 and 30 group by DATEPART(hour, timestamp)"))
  close(conn)
  return(x)
}

我们需要传递 ID 给这个函数。

1
2
id = "tumutanzi"
vote <- votes_hour(id)

检查一下返回的数据：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
   hour count
1     1     1
2     2     5
3     3     4
4     4     7
5     5    50
6     6    74
7     7    37
8     8    77
9     9   237
10   10   136
11   11    71
12   12    53
13   13    96
14   14   223
15   15   177
16   16   220
17   17   276
18   18   297
19   19   240
20   20   494
21   21   207
22   22   176
23   23    41

如果我们想计算百分比，我们需要把每一个次数除于所有。

1
2
total = sum(vote$count)
vote$count = vote$count / total * 100

然后在R里通过plot_ly 来画出柱状图：

1
2
plot_ly(x=vote$hour, y=vote$count, type="bar") %>% 
  layout(autosize = F, xaxis=list(title="Hour"), yaxis=list(title="Percentage"), title=str_c("@", id))

看来， @tumutanzi 的确是连X生活都没有了呢，哈哈。

> @justyy 是 https://justyy.com 的博主，在 @tumutanzi 大哥 的介绍下加入 STEEMIT，写些帖子挣些小钱养家糊口。

@justyy 也是CN 区的点赞机器人，对优质内容点赞，只要代理给 @justyy 每天收利息（年化率14.6%）并能获得一次至少2倍(VP 200%+)的点赞，大鱼 @htliao 都加入了这个计划(530 SP)表示支持。

  1. cn区最低保障系统 上线了!
  2. cn区低保计划（鼓励新人）真的适合你么？

R 教程之 STEEMIT 大鲸啥时候点赞的？
R Tutorial – Knowing when a Steem Whale vote?
Steemit 在线工具和API接口
SteemIt Tools and APIs

This page is synchronized from the post: R Tutorial - Knowing when a Steem Whale vote? R 教程之 STEEM大鲸啥时候点赞的？

培养孩子画画好处多多 The Kid's Drawings
cn
6 minutes read (About 952 words)

培养孩子画画好处多多 The Kid's Drawings

英国的小学很宽松，每天3点就放学，没啥作业，孩子（5岁）回到家里一般不是吵着要看电视，就是觉得不知道要干啥。看电视对孩子 的成长是极为不利的，当我们意识到这点后，就不怎么给孩子看电视了。为了让孩子不那么无聊，就下意识的培养他看看书（杂志漫画），他有时候也会拿起白纸照着漫画书上的角色给画了起来。

这学期开始，周末我们带着孩子去学画画，孩子不排斥，因为他能静得下心来画画，看得出他很喜欢。 他总是把喜欢的卡通人物画下来，画画过程中很专注，画完很兴奋，总是拿着画给我们看。

我从小就没啥艺术细胞，哪怕给我一个物体对着临摹，我都画得四不像。即使脑袋中想要画的物体画面很清晰，但是当要画出来的时候，就总是无从下笔，也许我就不是这块料，也许下笔如有神得经过专业的训练。

说实话，我们并不指望孩子长大能成为画家，把画画当职业的路很辛苦，我们只希望画画是孩子的一兴趣就很好了。父母尽自己所能让孩子多一种选择，如果孩子有这天赋，我们再着重培养。

画画好处很多：画画能让孩子安静下来，让孩子注意力集中，培养他专注做事情。而且，画画能发展创造力思维，孩子的想像力丰富，经常把想到的画面给记录下来。

画得好，也是一技之长，以后混得最差就是在街边临摹画像，我知道的一朋友，画得好，在游戏公司里给游戏角色画画，年薪百万。

孩子三岁的时候画的妈妈

现在画的妈妈
mummy20171013_preview.jpeg

孩子上的画画课，老师的画。

老师在课上对孩子进行指导

可爱的卡通画，形象，画得真比我好。等他大了让他参加 @helene 姐的画画比赛！


> @justyy 是 https://justyy.com 的博主，在 @tumutanzi 大哥 的介绍下加入 STEEMIT，写些帖子挣些小钱养家糊口。

@justyy 也是CN 区的点赞机器人，对优质内容点赞，只要代理给 @justyy 每天收利息（年化率14.6%）并能获得一次至少2倍(VP 200%+)的点赞，大鱼 @htliao 都加入了这个计划(530 SP)表示支持。

  1. cn区最低保障系统 上线了!
  2. cn区低保计划（鼓励新人）真的适合你么？

培养孩子画画好处多多
Steemit 在线工具和API接口
SteemIt Tools and APIs

This page is synchronized from the post: 培养孩子画画好处多多 The Kid’’s Drawings

Daily #CN Updates CN社区每日榜单【潜在收益排行榜】【优秀被错过的文章】【低保计划参与者】【优质内容点赞记录】(2017-10-16)
cn
11 minutes read (About 1579 words)

Daily #CN Updates CN社区每日榜单【潜在收益排行榜】【优秀被错过的文章】【低保计划参与者】【优质内容点赞记录】(2017-10-16)

数据来源: steemsql.com (Thank you @arcange !)
生成时间: 2017-10-16 11:11:08 (UTC)
报告时间: 2017-10-12 11:11:08 (UTC) - 2017-10-13 11:11:08 (UTC)

2017-10-16 那些优秀可能被错过的文章


Image Credit: pixabay.com
| | 作者 Author| 文章 Post|
|———-|:————-:|:——|
| 1 | @fr3eze | 当初买到0.1元的比特币的话，你现在就暴富了吗？ Early adopters of Bitcoin will be rich by now, really |
| 2 | @aafeng | 带孩子做科学实验系列之 - 会跳舞的葡萄干 |
| 3 | @lymichale | My first trip to Phuket Island/有一种心情叫突然想去看海—记我的普吉之旅 |
| 4 | @mrspointm | 请回答1988 Reply1988 |
| 5 | @travelgirl | Street Photography Contest - Unique Red Sculptures @ Hakodate, Japan - 街頭攝影比賽 - 很特別的藝術品 @ 函館市， 日本 |
| 6 | @berlin1997 | 说说在steemit上的日常 |
| 7 | @susanli3769 | 戏如人生，人生如戏【霸王别姬】Farewell my concubine /谷歌点名之 角色 |
| 8 | @nationalpark | Don’t Worry, Be Happy, Jamaica 无忧无虑之牙买加 |
| 9 | @shieha | Steemit Photo Challenge - #58 【極簡主義：黃】得獎者! — 新比賽主題 |
| 10 | @renzhichu | 你是不是别人朋友圈里的伪朋友？ |
| 11 | @icedream | 角色扮演，浅谈娱乐圈的人设——谷歌点名#11 角色 |
| 12 | @mrpointp | Anime Character Drawing Challenge # 2 :My Steemit Cartoon Image / 动漫人物绘画比赛 #2 : 我的Steemit卡通形象 |
| 13 | @waiyee422 | 深圳兩日一夜遊 （美食篇） 深圳两日一夜游 （美食篇） ShenZhen 2-Day Trip (Foodie) |
| 15 | @shenchensucc | Tony’s (Daodao) Happy Growing #17 Tree house 刀刀开心成长 #17 |
| 16 | @tvb | 丢失了所有证件的心酸往事 |

本列表支持黑名单用于过滤经常发水文的ID，欢迎 report@justyy.com 举报。

2017-10-16 Daily Top Authors in [CN] (Last 7 Days) 每日cn社区之 过去7天潜在收益排行榜

The following is the list of top 30 daily authors in [CN] in the last 7 days sorted by potential payout. See the SQL for more details.
这是根据这篇的SQL - 经少量修改和调整统计出过去7天作者的潜在收益排行。
| 排名 Rank| 作者 Author| 发贴数 Posts| 点赞数 Votes| 潜在收益 Pending Payout| 平均每贴收益 Average Pending Payout Per Post|
|–:|–:|–:|–:|—:|—:|
| 1| @oflyhigh | 6 | 1903 | 1076.99 |179.50 |
| 2| @rivalhw | 7 | 1108 | 931.28 |133.04 |
| 3| @htliao | 6 | 1182 | 770.82 |128.47 |
| 4| @someone | 6 | 934 | 741.85 |123.64 |
| 5| @deanliu | 5 | 1307 | 732.45 |146.49 |
| 6| @tumutanzi | 7 | 1124 | 699.51 |99.93 |
| 7| @linuslee0216 | 6 | 890 | 620.00 |103.33 |
| 8| @blackbunny | 7 | 731 | 578.00 |82.57 |
| 9| @jubi | 8 | 618 | 546.18 |68.27 |
| 10| @aaronli | 6 | 727 | 505.12 |84.19 |
| 11| @guyverckw | 11 | 1048 | 481.57 |43.78 |
| 12| @hannahwu | 6 | 499 | 467.45 |77.91 |
| 13| @justyy | 17 | 1120 | 457.07 |26.89 |
| 14| @chinadaily | 13 | 700 | 404.03 |31.08 |
| 15| @bxt | 8 | 393 | 398.37 |49.80 |
| 16| @sweetsssj | 1 | 1568 | 391.01 |391.01 |
| 17| @rea | 1 | 846 | 369.51 |369.51 |
| 18| @joythewanderer | 5 | 653 | 354.01 |70.80 |
| 19| @ace108 | 24 | 1573 | 326.66 |13.61 |
| 20| @travelgirl | 13 | 741 | 288.80 |22.22 |
| 21| @goodboyphilip | 7 | 587 | 286.47 |40.92 |
| 22| @stacee | 4 | 366 | 265.93 |66.48 |
| 23| @susanli3769 | 8 | 287 | 252.92 |31.62 |
| 24| @btsabc | 6 | 294 | 251.66 |41.94 |
| 25| @nicolemoker | 2 | 404 | 248.99 |124.50 |
| 26| @krischy | 3 | 356 | 248.78 |82.93 |
| 27| @coldhair | 6 | 455 | 248.12 |41.35 |
| 28| @czechglobalhosts | 7 | 371 | 240.95 |34.42 |
| 29| @twinkledrop | 6 | 333 | 231.30 |38.55 |
| 30| @cryptogee | 2 | 213 | 224.08 |112.04 |

以上收益包括75%的作者收益(Author Rewards)和25%的点赞收益(Curation Rewards)。
@dailystats 提供过去7天全网潜在收益前30名的排名
check @dailystats for top 30 daily authors in the last 7 days sorted by potential payout

CN 区优质内容点赞机器人每天会为这30名作者点赞！
CN Good-Content-Body will upvote these authors every day!

近期机器人点赞记录 Recent Quality-Content-Upvote-Bot Upvoting History

这个机器人很善良，只想激励CN社区产生更多的优质内容。当然别忘记了，我本人人工也是会对未上榜的优质作者进行点赞的哟~

时间 Time 作者 Author 文章 Post 权重 Weighting % VP %
2017-10-16 00:52:33 @nationalpark @nationalpark 24.24 54.96
2017-10-16 02:05:23 @victorier @victorier 26.16 54.96
2017-10-16 02:24:44 @sweetsssj @sweetsssj 36.74 54.96
2017-10-16 02:25:42 @ace108 @ace108 31.93 54.96
2017-10-16 03:17:20 @aaronli @aaronli 37.70 54.96
2017-10-16 04:20:01 @blackbunny @blackbunny 37.70 54.96
2017-10-16 04:36:09 @nicolemoker @nicolemoker 26.16 54.96
2017-10-16 04:38:22 @nationalpark @nationalpark 24.24 54.96
2017-10-16 04:44:35 @guyverckw @guyverckw 37.70 54.96
2017-10-16 08:02:34 @czechglobalhosts @czechglobalhosts 24.24 54.96
2017-10-16 08:49:33 @travelgirl @travelgirl 31.93 54.96
2017-10-16 09:51:30 @czechglobalhosts @czechglobalhosts 24.24 54.96
2017-10-16 10:31:29 @joythewanderer @joythewanderer 31.93 54.96

这个报告的年龄为: 52天。
为什么要有这个报告？
欢迎 @justyy 如果您有好的建议或者想看哪些榜单却找不到。

@justyy 是 https://justyy.com 的博主，在大哥 @tumutanzi 的介绍下加入 STEEMIT，写些帖子挣些小钱养家糊口。@justyy 也是CN 区的点赞机器人，对优质内容进行点赞，只要代理给 @justyy 每天收利息(100 SP 每天0.04 SBD)并且能获得一次相应至少2倍的点赞，可以认为是VP 200%+。加入计划最低代理10SP。CN 区的大鱼 @htliao 也加入了计划（代理了 530 SP）。

  1. CN 区最低保障系统 上线了!
  2. CN 区低保计划（鼓励新人）真的适合你么？
  3. CN 区优质内容点赞机器人上线了!
  4. 点赞机器人每日点赞记录整合到每日报表中！
  5. 虽然不挣钱，但是CN区低保计划还会继续下去

CN 区低保计划当前39位参于者，感谢！

查询谁都参于了也可以用这个在线工具: Steemit 查看谁委派代理给你Steem Power？。
|Delegator| Steem Power| Vests| DateTime|
|–:|–:|–:|–:|
|@eduter|660.12|1357975.69|2017-10-12 21:10:21|
|@htliao|530.35|1091019.80|2017-10-03 12:00:48|
|@bobdos|500.03|1028645.75|2017-10-15 05:45:30|
|@sunnyjolly|400.54|823973.51|2017-09-20 09:40:21|
|@mrpointp|400.37|823619.84|2017-09-28 14:09:36|
|@herlife|300.42|618006.65|2017-09-19 14:18:12|
|@zsilence|300.35|617872.78|2017-09-23 16:04:45|
|@mrspointm|300.28|617714.93|2017-09-28 14:07:18|
|@victory622|266.38|547985.69|2017-09-18 21:59:57|
|@coldhair|255.07|524713.00|2017-09-19 15:08:36|
|@luneknight|210.19|432399.70|2017-09-28 14:55:39|
|@berlin1997|200.2|411835.88|2017-09-27 08:55:06|
|@kangnajiang|117.05|240787.09|2017-10-08 10:12:12|
|@zhijun|100.55|206853.00|2017-09-19 03:18:57|
|@icedream|100.14|205996.82|2017-09-20 02:08:24|
|@yellowbird|100.14|205996.48|2017-09-20 02:52:51|
|@jessicameng|100.13|205993.57|2017-09-20 09:14:24|
|@fr3eze|100.1|205931.08|2017-09-26 03:17:24|
|@karasui|100.1|205926.99|2017-09-26 12:31:09|
|@jiangchen|100.09|205895.44|2017-09-29 11:36:09|
|@drunkevil|100.08|205885.32|2017-09-30 10:23:51|
|@catwomanteresa|100.08|205883.35|2017-09-30 14:50:03|
|@mumingduozi|60.24|123928.00|2017-09-19 00:25:12|
|@towardsthesun|50.07|102993.29|2017-09-21 00:33:18|
|@liumei|50.06|102983.93|2017-09-22 17:35:12|
|@tvb|50.04|102943.21|2017-09-30 07:54:27|
|@veronicazhu|50.03|102913.15|2017-10-06 00:26:30|
|@syh7758520|30.04|61802.26|2017-09-19 02:37:42|
|@raywang|30.03|61779.27|2017-09-26 03:40:09|
|@feng1925|20.03|41198.84|2017-09-20 07:52:30|
|@liangfengyouren|20.02|41192.83|2017-09-23 01:40:00|
|@mangoanddaddy|20.02|41189.47|2017-09-24 14:37:42|
|@speeding|20.02|41182.20|2017-09-28 00:34:57|
|@susanli3769|20.02|41176.13|2017-09-30 20:51:39|
|@jiba|15.65|32203.21|2017-09-19 01:04:06|
|@wangwenjing|10.01|20598.79|2017-09-20 21:35:18|
|@lixing|10.01|20596.48|2017-09-23 00:14:33|
|@willwangfeng|10.0|20576.13|2017-10-12 04:24:57|
|@keepup|6.0|12344.23|2017-10-14 11:06:12|

Steemit 在线工具和API接口
SteemIt Tools and APIs

This page is synchronized from the post: Daily #CN Updates CN社区每日榜单【潜在收益排行榜】【优秀被错过的文章】【低保计划参与者】【优质内容点赞记录】(2017-10-16)

Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×