How Else to Best Showcase Reddit Data?
Since the inception of my Reddit account, I’ve been logging my comments as a way of tracking my Karma.
Don’t ask why - I have nothing else going in my life! I don’t particularly do posts and 95% of my karma is derived from silly, witty comments. I’ve just been rather fortunate for some of them to just blow up in terms of upvote count.
I only count comments with upvotes of 2 or more and naturally, there is a disparity between my Reddit upvotes and my Excel sheet as Reddit also takes into account downvotes - I’m not really concerned about this.
I capture the following information on a weekly basis: (Year, Month, Sub, Upvote & Comment).
I’m currently using a Pivot Table to summarise this information by month & sub. and another table which mirrors the raw data except it’s SORTed by upvote count so I can see the comments by upvotes. This sheet also has conditional formatting based on the year so I can see which year I was most “productive”!
With the above information, how else can I best use Excel to showcase this data?
I was thinking of implementing VBA, but I wouldn’t know where to apply this!
[link] [comments]
Want to read more?
Check out the full article on the original site