#spread sheets

[wandanatsbee]

What are my plans today you may ask? Am I writing? Nope 🙂‍↔️ I am continuing with my spreadsheet to organise all my fanfics and I’m so excited!!

[dullestofcrayons]

The most cursed thing I've ever done is make a spreadsheet of every (main) Harry potter character and try to find ship art for everyone possible combination

OK WAIT I JUST WENT TO GET A SCREENSHOT AND I FORGOT I RENAMED IT

[shiftythrifting]

[poussacha]

My 2022 Fanfiction Breakdown

Many of you may or may not know this about me, but I am a lover of spreadsheets and numbers.

So, every year, I track my reading. For fanfictions and books alike, but the book tracking is done by my beloved Storygraph, so I don't have to get too in-depth there.

However, I go all out for my fanfiction tracking.

First, it all starts in airtable. If you're not familiar with airtable, it is a very pretty collaborative spreadsheet that a lot of people use for book tracking, work projects, or comic guides.

My fanfiction airtable from 2022 looks like this:

I track things like fandom, ship, author name, and month read. (This year in 2023, I'm doing something a little more involved, but that's a story for another time).

I also track word count and number of fics read. So I can track my reading habits over the course of the year.

Then I take my raw data from my airtable and put it in a Google sheet to create graphs. Because of course i have graphs.

Last year I read roughly 14,259,415 words.

My goal was 15 million. And I got pretty close..

Here's my breakdown:

Monthly word count breakdown by # and graph

As you can see, my busiest month for reading was August with nearly 4 million words read.

I had a major uptick in reading fanfiction July-November with each month hitting at least 1 million words.

Weekly word count breakdown by #s and graph

Please note, I didn't start tracking weekly count until August. And prior to that, my data wasn't clear enough. So this isn't a full year collection.

As you can see, my busiest week was September 26-30 with just over 1 million words. I'm still not sure how that happened.

Fics read by # (count and graph)

As you can see, the most fics I read was in August with 103.

I read 487 fanfictions in 2022.

Now, while this data is certainly interesting. I did also breakdown my Ships, Fandoms, and Authors. Though, the authors read is less interesting since it just looks like a mess. So I'll only share Ships and fandom breakdown.

Ships Breakdown Graph

As you can see, my most read ship last year was Steve Harrington/Eddie Munson, taking up 77.8% of my reading maerial.

The next closest is Derek Venturi/Casey McDonald with 3.1%.

Fandom Breakdown Graph

To the surprise of absolutely no one, my biggest fandom last year was Stranger Things taking up 79.8% of my readership.

The next highest was Life With Derek with 3.1%.

I went in HARD on the Steddie hyperfocus for a large chunk of 2022.

I'm working on a Steddie Gudie. It's sort of long, but I hope to have it out in the next few months.

If y'all found this interesting, I can and will show you how to create your own. It's VERY easy to do, but you have to set up your raw data correctly to be able to run these numbers.

[bobdylanslesbianlover]

in celebration of actually managing to take my meds 3 times a day for a whole week, please admire my tracker sheet

[dime-smothied]

I started playing Cookie Run today

[dungeons-draugrs-17]

At lit rpg con in a panel about spreadsheets

[frickyoumarrieofficial]

ABOUT YOU!

about you!

dear official verse, i love writing. And, remembering people! so, if you have extra time, or would like to write on this, then i would enjoy you filling a collumn out on this paper. (use size 8, on ur fav font, you also may change the colour of ur collumn)