More big master review list numbers

12 Dec

Decided to do another comparison with the numbers from the big master review list. I also found a even older set of numbers for the comparison I did for the 10k milestone. So I’ll be putting those in at the bottom as well. As usual, when going through the big master review list for something like this, I’ve found places where I messed up and odd typos. Apparently there were two entries for One Man’s Ramblings and One Many’s Pony Ramblings. Plus, apparently, at some point it switched the type of apostrophe used for One Man’s Pony Ramblings and was sorting them as different entries. Which took a while for me to figure out what was going wrong when I was sorting that column.

This should show the overlap percentages between reviewers. How many of each person/group have reviewed stories that other people have reviewed. There is no simple way to determine which one reviewed it first. So the overlap does cover stories that a reviewer might have covered first, then others reviewed the same story. So I can’t really track who is getting story recommendations from whom. So if a reviewer has a low percentage it means one of two things. They review stories recommended by other authors, or conversely other reviewers read a lot of stories they review. Beating the bell curve is like that.

As usual, I come away wishing I knew how to do more with spreadsheets. I keep thinking up all sorts of cool comparisons and ideas for data to tease out of the big master review list, but then run into the hard fact that I have no idea how to do anything complex. Want to just click a few buttons and have the computer spit out the numbers I want. My lack of skill (and laziness) means I do everything by hand. Which means that a lot of the number crunching is out of my reach. At least for a hobby project anyway. Plenty of stuff I’d put time and effort into doing if I was getting paid, but that’s not going to happen anytime soon for a niche of a niche of a niche that is tracking pony fan fiction reviews.


Now for a updated re-compare of the numbers I had in the ten thousand reviews milestone post. The numbers from November 24, 2014 are from the post where I added the automatic tracking of number of reviews for each story and reviewer. So that was a pretty big update. It’s already such a solid part of the big master review list when I check it out that it kind of surprised me that it was something I added to the spreadsheet a while after the beginning. Still find it kind of weird that in that first check of number of reviews for stories, exactly six stories and seven stories had six reviews and seven reviews respectively.

Number of Reviews November 24th, 2014 July 5th, 2015 December 4th, 2015
1 1846 3,376 3,849
2 753 1,178 1,322
3 208 399 486
4 85 180 227
5 33 87 114
6 6 34 48
7 7 15 28
8 0 12 15
9 1 2 8
10 None 0 2
11 None 0 0
12 None 1 1
Total Reviews: 4,576 8,519 10137



Posted by on December 12, 2015 in Big Master Review List


10 responses to “More big master review list numbers

  1. Loganberry

    December 12, 2015 at 2:20 pm

    Quite a range of overlaps there. I was intrigued by InquisitorM’s one non-overlapping story… and found that it’s one I’ve recently read, and which I’ll be reviewing in due course – so absent any further reviews from Mr M, he’ll shortly be down at zero with the RCL!

    • Griffin

      December 12, 2015 at 3:05 pm

      Hee. Another fun fact is that the Louder Yay blog is the one review source that has an identical overlap percentage between the two sets of numbers. Which I noticed only because I went in and fixed that only one set of the numbers was showing on the page, at least for me.

  2. Present Perfect

    December 12, 2015 at 3:11 pm


    • Griffin

      December 12, 2015 at 4:48 pm

      Even moreso when you consider that my total for your reviews is a lot less than your total for reviews. Mostly because of the short story collection issue.

  3. Chris

    December 12, 2015 at 3:58 pm

    I was surprised my overlap percentage wasn’t higher, since I assume that basically none of the 6-star and Fandom Classics ones are those stories’ sole reviews; I guess I’m pretty good at picking obscure stories for mini-reviews, then!

    Also, sorry my blog name broke your list. Looks like I ruined everything, AGAIN.

    • Griffin

      December 12, 2015 at 4:47 pm

      A quick (relatively) analysis shows that the stories only you have reviewed breaks down thusly:
      Six Stars: 65, Fandom Classics: 28, Mini-Reviews: 94.

      So the mini-reviews are a big chunk, but the Six Star reviews aren’t a minor amount.

  4. Titanium Dragon

    December 15, 2015 at 12:51 am

    The number that surprises me the most is Rinnaul’s number; he reviews almost nothing that other folks review.

    Pleasant reviews having such a high percentage of one-offs isn’t that surprising; they review stories by request, which probably means a lot of relatively unknown folks get reviews from them.

    • Griffin

      December 15, 2015 at 10:55 am

      Rinnaul’s numbers are wonky because at one point he was reviewing all the stories like four people did for oneshotober one year. So like 80% of the reviews under his name on the list are just short reviews of throw-away short stories.

  5. Adrian “Adrenaline” Perry

    December 18, 2015 at 5:23 pm

    Oh yeah, I’ve been meaning to bring you up to speed on a lot of those typos. One I see all the time ( because of course I always go looking through my own stories for new reviews 😛 ) is Bad_Seed_71 instead of Bad_Seed_72. Did you get that one (or more)?

    • Griffin

      December 18, 2015 at 6:06 pm

      Thanks for pointing it out. Just the one, and it should be fixed now. Must have just been a slipped finger when I was typing it in.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.