Scaling the Utopian Bot : A Look Into Developments - Steemit Business Intelligence

This is the second installment for a proposed change in the Utopian bot. This is a multi-post project with the aim of analyzing each of the Utopian categories to support the suggestion to have multiple Utopian Bots - particularly one bot per category.

This also aims to get the current reward values of each category and compare them with external sources that offer the same service for a fee.

In the previous analysis, we've looked into translations because it received the highest total rewards. If we were to follow this order, the next analysis should be tutorials. However, since this author perceived that it would be difficult to get quotations for creating tutorials, he decided to skip that category and move to development.

So far, here were the sections covered:

1. Scaling the Utopian Bot - The Suggestion
2. A Look Into the Translations
3. A Look Into Developments - this post

Outline

1. Scope of Analysis
2. Utopian Growth Check
3. Total Rewards Per Category
4. A Look Into Developments
5. Comparing with Existing Services
6. Total Required Steem Power
7. Conclusion

1. Scope of Analysis

• Contributions were acquired on Dec. 16, 2017 0635H UTC.
• Data extracted was from 2017-09-28 1539H UTC to 2017-12-16 0047H UTC.
• Downvotes were excluded.
• Upvotes on comments were excluded.

2. Utopian Growth Check

The Utopian bot up-votes contributions almost everyday. As such, its statistics is dynamic. Let's check how it performed as of date:

As of December 16, it has now rewarded the most projects (718). Here's a table of the growth indicators.

The bot still needs to up-vote 15 more unique authors to meet the number of November. These are the active authors contributing to Utopian.

The projects increased by 27%, meaning more authors are contributing to other open-source projects.

The contributions (still 107 contributions behind November) is the number of contributions per month. Since we're still in mid-December, we can expect this number to increase.

Here's a look at the daily:

The graph doesn't show it, but there were 250 contributions up-voted in the last round. The 305 contributions displayed for December 15 was a combination of the previous two rounds.

So if we were to separate it per round:

• Dec. 15 2225H to Dec. 16 0047H: 250 contributions
• Dec. 15 0227H to Dec. 15 0401H: 142 contributions

3. Total Rewards Per Category

So far, development contributions have been rewarded a total of $20K. As mentioned in the introduction, let's look into this category.

4. A Look Into Developments

The maximum total rewards it had given was on November 13 with $ 1,365.97.

Contributions in this category were given an average of $43.30 per contribution, with a minimum vote of $0 and a maximum of $120.44.

Let's look at this based on frequency of votes per reward value.

We can see here that development contributions are usually rewarded $30.

Let's consider only the top 5 vote rewards for the Utopian-development bot's SP:

The maximum reward in this table is $70. Using steemnow's upvote calculator, the SP that will give us this vote value is around 435K SP.

5. Comparing with Existing Services

This author searched for "How much does a programmer cost per hour?".

Based on this site, it ranges from $18/hour to $70/hour. And from another source, it's $47/hour.

Does it cover the $ reward value calculated on the previous section? Yes. However, that's assuming it only took the developer one hour to do the task. And this does not consider the current price of STEEM and SBD.

6. Required Steem Power

So far, let's look at the required Steem Power to run the bots:

Bot	Proposed SP Delegation	Vote Value
Translation Category	332K	$50
Development	435K	$70
--	--	--
Total	767K	$120

7. Conclusion

This analysis aimed to identify the vote value of a theoretical Utopian Development bot. We've identified that developers usually charge $20 to $70 per hour. For the bot to be able to up-vote with this value, the bot needs a delegation of 435K SP.

On the next analysis, this author will tackle the graphics category. This will be helpful for the graphics designers.

Tools Used

• SteemSQL by @arcange
• Node.js and npm to extract the data
• Power BI and Excel to generate the charts

Source Code

Codes used to extract data for this analysis are available in Github:
https://github.com/eastmaels/biutopian

---

^{I am part of a Blockchain Business Intelligence community. We all post under the tags #BIsteemit and #BlockchainBI. If you have an analysis you would like carried out on blockchain data, please do contact me or any of the #blockchainbi team and we will do our best to help you...}

^{You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j}

---

Posted on Utopian.io - Rewarding Open Source Contributors

---