Numbers for the upcoming Hardfork

As you probably noticed, @HiveIO very recently published a new announcement about the "airdrop" exclusion list, in which they published a list of accounts which were excluded due to an error in the script which created the list of accounts to be excluded. I recommend reading this announcement prior to reading my post. The published list includes the following accounts:

@akiroq
@balticbadger
@dailychina
@dailystats
@dftba
@double-u
@edgarare1
@electrodo
@fadetoblack
@freedompoint
@friendlystranger
@john371911
@juancar347
@kdtkaren
@lichtblick
@lifeskills-tv
@lotusfleur
@ricko66
@rynow
@scottcbusiness
@seo-boss
@sgbonus
@spoke
@steemchiller
@steemflower
@stimp1024
@travelnepal
@truce
@tuckerjtruman
@wisdomandjustice
@yanirauseche

These accounts all had a stake of >= 1000 SP before the hardfork. In the block the hardfork happened, the block #41818752, those accounts, and all other accounts that were excluded got their liquid funds were directly transferred to @steem.dao, and their vests (=the "backend" value for HP/SP) were converted to Steem and sent to @steem.dao in liquid form as well. Soon, there will be a hardfork which will revert the error, and give the aforementioned users their funds back. Following is a table of those users and the amount of funds they had at the time of the Hardfork. In the rightmost column is the amount of Steem their vests were converted to:

I also made some barcharts in which you can compare those numbers visually:

As you can see, there's always just a few accounts which notably stand out. I will let those charts speak for themselves though.
As you probably know, you get a bit of staking rewards for having your steem powered up. This is just a small amount, but it is very important here. Since the vests in those accounts were converted to steem at the last hardfork, those steem did not create any staking rewards, as they are liquid, and will not create any until the next hardfork. It isn't entirely clear how the accounts will receive their SP/HP back, but @pharesim ensured me that no new coins would be minted. That results in the accounts receiving a smaller vests amount than they had before the hardfork, should they receive them in the form of vests. The discrepancy between them only grows bigger with time. At the moment it is around 1000 Hive worth of vests which are "gone". I tried to graph the discrepancy over time as well, but I could not find any exact formula for the staking rewards at a given time - all I could find was an approximation.

Something that interested me, was how much of the stake that will be given to the accounts was powered up before the hardfork. For this I made yet another visualization, which has all 3 "currencies" converted to Steem for higher comparability. Please pay close attention to the logarithmic scale of the second chart. That makes the chart a bit more complex to read, but without that it was very long and the smaller parts still were too tiny to have proper size. Every major number on the left side means 10x more, so the uppermost part is much bigger than it might seem on first sight.

I think that this graphic shows very well how tiny the amount of liquid funds were. Note that this is only the accounts which will get removed from the blacklist soon.
While diving into this topic I wondered how big the total blacklisted stake was, and where it came from. So we have a last barchart, again having all assets converted to Steem for comparability. Also, we have both a linear scale on the left and a logarithmic one on the right again.

In total the following amounts were moved to @steem.dao at the hardfork:

@redpalestino gave me the following list of Steemit Inc. accounts that I used as well. Thanks a lot!

@ben
@bitdev100
@geos
@goku1
@hkdev404
@imadev
@joe767676
@misterdelegation
@steem
@steemit
@steemit2
@steemitadmin
@timothy2020
@steemitblog

Also, I added Justin Sun's witness puppets to that list.

I hope you have learned a bit about the upcoming hardfork and have a better understanding of the scale of the things that are happening.
Last but not least I want to send @holger80 a huge thanks. I used beem for all Steem/Hive related tasks. I used matplotlib for the visualizations. I used the current HBD/HIVE price for conversion between those.

Edit: I uploaded my code on Github. It is very ugly, but it works. I guess...