Bwa Ha HA! · 3:02am Mar 4th, 2016
I finally found the formula/function in google spreadsheets that does what I need it to do! So here is more numbers for you.
Here is the breakdown for authors by total number of reviews.
Full list here.
Not a single author has the same slot on both lists. Only four authors even have a slot one off from the other list. Cold in Gardez, for example, has the #3 slot sorted by reviews but only the #11 slot for number of stories.
Five authors appear on one list but not the other:
Cerulean Voice -- Number 23 sorted by number of reviews total, but does not show up in the list sorted by stories reviewed.
GaPJaxie -- Number 22 sorted by number of reviews total, but does not show up in the list sorted by stories reviewed.
GrassAndClouds2 -- Number 21 sorted by number of stories reviewed, but does not show up in the list sorted by total reviews.
horizon -- Number 20 sorted by number of reviews total, but does not show up in the list sorted by stories reviewed.
Regidar -- Number 16 sorted by number of stories reviewed, but does not show up in the list sorted by total reviews.
Are these numbers useful? Heck if I know. Just excited that I finally figured out how to put total number of reviews for each author on the list. Plus fun with trivial statistics!
Trivial or not, they save us authors a lot of pains in the neck. For example, on one of your sheets I just found out that the Royal Guard ran one of my stories a few weeks ago. I didn't notice at the time because I was having a crazy month. Otherwise, it might have been literal years before I noticed it, if ever.
When Pony authors wake up in a cold sweat, it's because they dreamed that you quit the fandom.
3790385
Glad it is useful! Certainly keeps me off the streets.
The two TDs stand side by side on the number of reviews received list.
Juuuuuuuuuuuust scraping in equal 23rd there. Noice. Not for long though, I'll bet.
Also, I love ordered lists. This is great.
edit: also noticed I have the highest review:story ratio at 3.69 reviews per story. Second highest are Skywriter and Cold in Gardez at 3.43 each, though Skywriter's is rounded up to two .places.
Finally, I beat him at something!
( What? Don't give me that look; let me have this! )
Pointless observation: in terms of number of stories reviewed, I come in equal 61st (with 24). I wondered whether I'd reviewed at least one story by everyone above me. As it turns out, the only gaps are Sharp Spark and GrassAndClouds2, both of whom have stories I have read and that are in the review queue. I don't think Baal Bunny really counts, given that I have reviewed an AugieDog story. The first proper gaps are NightWolf289 and RainbowDoubleDash, both of whom are level with me on 24 stories reviewed.
I did warn you it was pointless!
3791167
Pointless statistics is what upgrades to the Big Master Review List are all about!