Thank for the review @crokkon! You always trough some challenge in the comment :) I'm trying to keep up with those.
I must say doing this analysis in excel was quite a challenge since at occasions there were more than a million rows and excel was slow and lagging. Especially on the post data. Maybe I need to look at some different tool. 

The number of comments went from around 300 daily average to a 700-800 in the end of the year. This increase happened on 21 and 22 second December. I really don't know what happened there. I double checked the data and it is accurate. Maybe the holidays made this happened, since this was the start of the weekend :). 

About the daily vote values and payouts, I assigned the SP of Dtube for each date, and then calculate the individual votes, according to the weight. I used the daily SP of Dtube, multiplied with 0,00756447%, and multiplied again with the weight of the vote. The percent I used theoretically is for 95% of the Dtube vote. I went with assumption since not all the time Dtube votes with 100% that is for sure.
After this I made the daily sums of the votes. It isn't an 100% accurate way, since not all the time Dtube votes with 95%, and the rewards isn't just in STEEM, but it is close enough I think. Also when I think about it now, I should of removed the 25% curators reward. If you prefer I will make the correction.