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:

Account	SBD	Steem	Vests	Vests (in Steem)
@akiroq	0.004	0.0	5222981.280165	2666.921
@balticbadger	0.223	3.011	9862512.194754	5035.925
@dailychina	0.0	0.0	2287357.385165	1167.954
@dailystats	0.0	0.0	3603646.587813	1840.068
@dftba	5.602	863.869	4338257.333969	2215.163
@double-u	0.058	3.674	212718890.306873	108616.998
@edgarare1	7.461	18.909	16042156.595896	8191.331
@electrodo	0.0	475.786	21991505.214316	11229.145
@fadetoblack	0.065	0.044	2122918.450392	1083.989
@freedompoint	0.0	15.135	15903691.521191	8120.629
@friendlystranger	2.539	0.01	421669701.652096	215309.96
@john371911	118.93	0.0	55920030.732881	28553.486
@juancar347	65.614	349.169	15741601.749441	8037.864
@kdtkaren	0.006	0.011	5087676.727333	2597.833
@lichtblick	27.416	3649.512	86182609.783795	44005.948
@lifeskills-tv	0.076	4.553	2989637.291461	1526.547
@lotusfleur	2.382	377.493	3392176.44533	1732.088
@ricko66	0.024	0.01	3954082.224076	2019.005
@rynow	19.271	32.387	20343780.919587	10387.795
@scottcbusiness	0.0	55.305	3875676.053492	1978.97
@seo-boss	0.053	15.916	50151173.717076	25607.833
@sgbonus	128.478	315.035	4685876.864464	2392.668
@spoke	0.031	0.0	29245675.434318	14933.217
@steemchiller	0.549	231.884	3545034.994359	1810.14
@steemflower	0.0	1841.223	8190586.565291	4182.177
@stimp1024	0.0	0.0	99408662.973654	50759.34
@travelnepal	0.0	0.0	5211178.805193	2660.894
@truce	63.124	7076.771	98440810.85398	50265.143
@tuckerjtruman	0.0	0.0	3014518.806936	1539.252
@wisdomandjustice	0.29	0.022	375663318.81511	191818.518
@yanirauseche	0.607	22.201	2826858.052705	1443.43
Totals	442.803	15351.930	1593634586.333112	813730.231

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...