Hi all. I know that I have been very quiet over the last weekend. This is because I have had a new tool brewing and spent a lot of time improving its algorithm. So, let me introduce the new feature on Scribe called the AverageDelegation.

Problem:

Communities are thriving here on Steem lately. The encouragement given to have a community curator has been very high. So, pretty much most of the communities now have their own community curators which are accounts used by the admins and moderators of a community to curate users.

Most of the community curators also share a common delegation reward model. Every day/week/month, these community curators calculate the curation earnings and distribute them to their delegators(The % of distribution might vary).

This is great as this would motivate the people of the community to support a community curator. This would allow them to receive frequent voting support and the added delegation rewards give any investor an unbeatable ROI on investment.

^{These are the communities that I already reached out to}

While the model works well, it is a lot of work for the admins and moderators who would need to manually calculate the average delegation of every single delegator. I recently reached out to a few communities and these BOI and Srilankan communities are currently doing this manually. This is a time-consuming task, requiring the user to manually look into the history and calculate the average for the delegation period.

This is where AverageDelegation comes in very handy.

Introducing AverageDelegation:

^{The landing page of Average Delegation}

As I mentioned above, currently, community leaders are calculating the average delegation of every user manually. I have now automated it on the Average Delegation tool. You can access the tool by going to the link https://scribe.steemcryptic.me/delegationaverage .

So, this tool basically checks the delegation history of every user for every second during the requested period and then calculates their average. Yes! The delegation average is accurate up to a second! It was only fair to make it that accurate because a user might delegate towards the end of a day and might end up sharing the delegation rewards for the entire day. Additionally, I have used Unix timestamps to make it that accurate> So, it was easier for me to implement as well.

^{The delegation average of BOI for July}

Once the calculation is complete, the tool spits out the average SP delegated to a particular community curator account in the form of a table.

How to use the Average Delegation tool?

It is pretty straightforward to use the tool.
1- You need to first specify the account name of the community delegator in the first text box and then from date and to date in the next two fields.
2- The from date always takes UTC 00:00 as the time and the to-date takes UTC 23:59:59 as the time. So, if your delegation distribution period is 31 days, the start date needs to be the 1st of the month and the to-date needs to be the last date of the same month.

For Example: In the case of BOI, we do monthly delegation. So, the start date would be the first date of the month and the end date would be the last day of the same month.

In the case of Srilanka, they do weekly distribution. So, the start date would be the first day of the week(Sunday) and the end date would be the last day of the week(Saturday).

For communities that do daily delegations, the start and the end date need to be the same.

3- Once these fields are filled, hit the calculate button and let the calculations complete. This might take a few seconds depending on the number of delegations that the community curator received.

Things to remember: The calculation happens with vests and not SP. So, the current vests to stem rate is considered. This is the right way to go about as SP is nothing but vests in the actual backend.

Update on TagSearcher:

The fromdate and todate in tag searcher have also been updated with this release. Previously, the from date would have 00:00 as the time and the same goes to todate. This has now been changed.

Now, fromdate would have the time 00:00 UTC, and todate would have 23:59:59 UTC as its time. So, the professors can now search for the academy posts more accurately based on time.

Tech and API:

The Average Delegation tool makes use of @steeemchiller's SDS API. A big thank you to him as his API's have allowed me to concentrate more on the calculation logic and worry less about traversing the entire blockchain.

The entire code is written in C#. TPL Multi-threading has been employed to make the calculations faster. However, it might still take some time depending on the number of delegations that you received over the given period.

The entire application is still hosted on Heroku. I have already bought a new server that is a lot faster. It currently hosts some of my bots. However, I'm having trouble opening up ports on it. Once resolved, I will be moving it over to the new server.

Conclusion:

All my tools/bots have been tested by me(dev). So, when released in the wild, there have been bugs identified. If you find any bugs, you can contact me on the BOI's discord channel or just leave a comment down below explaining the issue. This would help me fix it ASAP. Additionally, if you have a feature request or any other suggestion, please let me know below. I would be happy to build it(Provided that it's feasible).

Lastly, I would like to thank the BOI's team and the Steem Srilankan community for helping me understand how they calculate the average delegations. I have already reached out to a few other communities as well. However, I haven't heard back from them. So, if you feel this tool would help any other community, please spread the word about it.

If you like the work that I do here, do support me by voting me as a witness:
You can do that by going to https://steemitwallet.com/~witnesses and vote starlord28(Currently ranked 62) or
Vote starlord28 as Witness: https://steemyy.com/witness-voting/?witness=starlord28&action=approve

CC:
@steemcurator01
@steemitblog
@sapwood
@randulakoralage