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](https://utopian.io/utopian-io/@eastmael/scaling-the-utopian-bot-feasibility-study-steemit-business-intelligence), 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](https://utopian.io/utopian-io/@eastmael/scaling-the-utopian-bot)
1. [A Look Into the Translations](https://utopian.io/utopian-io/@eastmael/scaling-the-utopian-bot-feasibility-study-steemit-business-intelligence)
1. **A Look Into Developments** - this post

## Outline

1. Scope of Analysis
1. Utopian Growth Check
1. Total Rewards Per Category
1. A Look Into Developments
1. Comparing with Existing Services
1. Total Required Steem Power
1. 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:

<center>![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513407939/w9kq3tkixgvrynybmfg1.png)</center>

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

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513416417/ke7kfb6w8y6tpotwnxsu.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513417104/rzhijfn3emssdxui1gyl.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513417662/laky5dj08bigt2k1ouzc.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513418139/xpcmfpb2ecdqcf2uqrdb.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513418893/jtwsyuhs3jsegdonacmp.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](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513419328/qopjbms7um0kyyliojtv.png)

The maximum reward in this table is **$70.** Using [steemnow's upvote calculator](https://steemnow.com/upvotecalc.html), the SP that will give us this vote value is around **435K SP.**

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1513419532/mphylnnjlaebzkrstqjh.png)

## 5. Comparing with Existing Services

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

Based on [this site](https://www.upwork.com/cat/developers/), it ranges from **$18/hour** to **$70/hour.** And from [another source](https://www.quora.com/What-is-the-hourly-rate-for-a-programmer-1), 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](http://www.steemsql.com/) 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

***
<sup>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... </sup>

<sup>You can find #blockchainbi on discord https://discordapp.com/invite/JN7Yv7j</sup>


<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@eastmael/scaling-the-utopian-bot-a-look-into-developments-steemit-business-intelligence">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>