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

in #utopian-io6 years ago (edited)

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:

image.png

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

image.png

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:

image.png

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

image.png

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

image.png

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.

image.png

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:

image.png

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.

image.png

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:

BotProposed SP DelegationVote Value
Translation Category332K$50
Development435K$70
------
Total767K$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

Sort:  

this is awesome work. Looks like you are enjoying Power bi

Looks like you are enjoying Power bi

Yes I am. Thank you for introducing it to us. I never would have studied this if it weren't for you.

There was just this table that I couldn't find a way to generate.

So I had to do it manually in excel.

I tried manually creating data for it in the format:

| Month | Category | Value |
| -- | -- |
| November | Authors | 464 |

But didn't give me the table I wanted (the columns were alphabetically sorted and I couldn't find a way to place them in the way I wanted)

Hey @eastmael I am @utopian-io. I have just upvoted you!

Achievements

  • You have less than 500 followers. Just gave you a gift to help you succeed!
  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Thank you for the contribution. It has been approved.

This is the 3rd in a collection of stand-out posts in my humble opinion - great stuff @eastmael!

You can contact us on Discord.
[utopian-moderator]

I lack the words to express my appreciation. So I'll go with the best I can muster - Thank you Asher.

 6 years ago (edited) Reveal Comment

You're very much welcome. :) Welcome to Steemit. :)

Good day @eastmael

No time to take it on for review just yet but i think the github needs changing to utopian.io/api.utopian.io

good luck! :)

Thanks. Okay will update the github repo.