create your own 2025 ao3 wrapped: fanfiction log template!!
The only tab you have to update manually is the Log itself with the info about your fics. Everything else is automatic!
Click here for the template!
NOTE: Above is a sample dashboard output generated using a random selection of the most kudo'd fics on ao3. Please don't take this as an endorsement or reflection of myself lol.
In order to use it for yourself, open the sheet and click File > Make a Copy
The Google Sheet is annotated (with notes) that will help you find your way around, but if you have any other questions, let me know! I will do my best to help.
Features:
A year-end dashboard that generates your "dream" fic! (New!)
Columns and functionality for characters, relationships, and additional tags (New!)
Automatically calculates monthly and yearly statistics (word count per month, running word count total, fic count, average fic lengths
Automatically tallies the number of fics you read per category/rating/warning/fandom
Find out who's your favorite: Automatically calculates the number of fics and total words you have read from each author
Provides space for a notes column to record your thoughts on any fic you read
New and improved visual appearance!!!!!
Sheet is set up with ao3 in mind, but can be reworked for other fanfic sites :D
Okay, so we know that Charles' polo goes red>burgundy>black and back by the end of the season.
Because there's so much going on, I always missed the exact transitions. This time I specifically tracked them down. (Apologies if this has already been done.)
Charles shirt is bright red through the majority of the Devlin House, even in Hope's Diary scene, when he opens up to Crystal.
Even when he first swings at Mr. Devlin and gets knocked back, his shirt is red.
The very subtle shift to burgundy is after he disappears and first reappears in the loop.
It remains burgundy throughout the entire lighthouse leapers episode and beginning of the two dead dragons.
I finally realized the very last moment we see of Charles in the burgundy is with Crystal. She tells him after the confusing makeout night, "But I think we should be friends," and kind-hearted Charles, of course, respects that and puts on a friendly smile.
It's difficult to see in the next scene with him because of his jacket, the angle he sits at on the ladder, and the lighting, but it's immediately after that when we first see him in the black polo.
My brother in death, you are NOT doing well.
here's another song from Jayden Revri's official Charles playlist, that I think is about this conflict with Crystal:
His shirt is still black during the "I don't wanna be a bad guy" scene.
After Edwin's affirmation of Charles' inherent goodness, it is directly after this scene that the shirt goes back to burgundy!!!
He's still wearing the burgundy during the confession:
BUT IT GOES BACK TO BRIGHT RED LITERALLY RIGHT AFTER EDWIN'S CONFESSION AND THEY ESCAPE HELL TOGETHER!
Yo I equally love Cryland and Payneland but the show canonly said "Crystal hit him in the loneliness and Edwin hit him in the loved"
A guide written for @wren-of-the-woods who asked for advice about how to start vidding! This is far from comprehensive and I tried not to make it too dense because it's a big subject. I still wanted to share a variety of topics about getting into vidding because it's a hobby and art that is near and dear to my heart.
First Piece of Advice
watch a lot of vids and rewatch vids multiple times. Seek out vids on YouTube, AO3, Watch the TikTok and Twitter/X vids that show up on tumblr or wherever you’re browsing. They all have distinct styles and tools/techniques they use to make their vids and edits. Rewatch the vids and ask yourself what you like or dislike about them. The song, the editing, the source. That can give you a good starting point about how you might want to approach making your own fanvids.
The TikTok style of 30 and 40 second edits are very different what you find on YouTube. YouTube editors tend to use a full song and a lot more effects and a lot more overlapping dialogue. Whereas the fanvids - Vids - from people who came into vidding in the mid 2000s/2010s have their own culture, different ways they approach song choice, clip choices and narrative.
I also suggest watching vids for shows/films you’re not familiar with as well as your fandom favorites. You can learn a lot about how vidders try to tell a story even when you might not grasp the context behind certain scenes but you can still follow along with the emotional arc of the vid.
Second Piece of Advice
Have fun and enjoy yourself. Everyone starts a new hobby as a newbie. It can be a lot of effort to make 30 seconds or a 3 minute vid, but it’s such a unique type of fanwork that is fun to watch and fun to make. It can also be migraine inducing because of all the learning and technical issues along the way. But!! omg when you make a clip fall on the perfect beat with your blorbo crying that perfect tear or you find an idea and sources for the bestest perfect lyrics of the song, it’s a magnificent high. It can make you feel like a god. At least that’s how I feel a lot of times!
There are about 10 steps* to creating** a fanvid/edit:
• select your platform and software (phone/computer video editors)
• gather your video and audio files
• create a new project in your video editor
• import audio into the editor
• import the video into the software and mute audio tracks that contain your video’s audio
• review, label and cut up the video into shorter clips - this step is known as ‘clipping’ in vidding parlance, but it’s also optional. Some people pull in movies and scrub through the whole film and just pull it directly onto the timeline
• move the various video clips around on the timeline to match the audio track you’ve chosen for your project, add video effects and additional dialogue if you like
• export the finished timeline
• upload the video to a streaming platform and/or downloadable service
• share your project!!! posting to ao3 and/or social media or share on discord, etc
* there are a lot more steps involved with each of these steps. What what software to use, where to find video, how to deal with copyright blocks on Youtube, etc. Some of that will be covered in the links below but is not comprehensive. That would require separate posts and links and I don’t want to drop an encyclopedia on you right now! I’m happy to provide more resources that I can curate if you want more direction and pointers to resources and amazing vidders.
** like any hobby, there can and will be a learning curve and frustrations. Blank page for a writer, blank timeline for a vidder. Is anything you put down is any good, self esteem and confusion about what actually makes sense is part and parcel for any creative work. Once you're in the vidding process and committed, as long as you're enjoying yourself you gotta just keep going to get it done.
Getting Started Vidding
My knowledge and background and learning how to vid from people on livejournal and dreamwidth from 2007. I don’t have any experience in editing with a phone but if that’s something you’re interested in, YouTube will be a place for you to start finding tutorials for various apps and tools. Probably discord communities, too.
Vidding Workshop - a great how-to/guide when you're starting out. This is on dreamwidth from the WisCon vidparty in 2014. Some of the tech discussions might be a little outdated but there’s a ton of relevant information. It covers technical subjects as well as developing vid ideas and actually getting started. If you have any questions about what you’re reading you can leave an anonymous comment and ask - some of these vidders responding inthe threads are still active. You can find them on AO3/YouTube, tumblr, discord and actually leave them questions about their vids. Many vidders are more than thrilled to talk about their vids and answer questions.
Vexcercises - this is a dreamwidth community for short-form vid excercises. This is a very structured way of introducing vid concepts and constraints so that you can produce a vidlet. I highly recommend you check this out and participate! There’s even an AO3 collection so you can check out how people have done the different exercises, too.
The Process of Vidding
Watch Me Edit - @limblogs put together a fantastic playlist of YouTube editors who will show you beginning to end how they made their vid. A lot of these editors appear to be using Sony Vegas but the general process of vidding end-to-end will be similar with other nonlinear editors like DaVinci Resolve, Premiere, etc. It’s a great way to actually see the vid come together if you don’t know what that even looks like. Every vidder will develop their own workflow and approach (which might even change from vid to vid), but it’s useful to see in video how people actually DO the thing.
@limblogs also created a handy YouTube playlist some vidders from Bradcpu’s Vidder Profiles (Fanlore page). These profiles are basically like a director’s DVD commentary on their vidding process, featuring the vidders talking over their own vids! So cool. Phenomnal insights from these vidders about how they choose song, use effects, think about their narratives.
Self Rec: I recently did a vidding textpost series called: do it for the process - a naked vid draft: What (Yennefer of Vengerberg).
How I Edit by @vimesbootstheory is another textpost about their vidding process.
Self rec: Here’s my text interview: Vidder Profile - Kuwdora 2011.
I talk about my process with a lot of specific examples from my previous work and lots of screenshots. This profile is over a decade old but a lot of this still holds true for me today!
videlicet - this is an incredible vidding zine that @limblogs put togegther with a lot of amazing contributors. These articles and discuss about specific vids and aspects of vidding. It’s really detailed and a fantastic piece of vidding culture. I highly reading recommend the Demystifying Vidding article by lim and the A History of Vidding by @meeedeee and…pretty much every article in the zine!
Doing the vidding!
I recommend joining exchanges and watching vids that come out of exchanges and checking out fannish cons that have vidshows and discords to get more exposure to vidders and vids.
Many people have joined @festivids (AO3 collection here) and made their very first vid, it's a very fun and great way to get into vidding. It’s not quite festivids season right now but time flies and it will be time to nominate sources and do sign-ups in the blink of an eye. Follow @festivids and check out the AO3 collection and see what people are making.
Join the Vexcercises community and make some short vids and share them on your tumblr or on discord or somewhere and bask in the thrill of making your first fanvids.
Check out who reblogged the vidder ask game - go and read other vidders responses and ask some new-to-you vidders questions. Everyone has their own take on process and tech and everything. It's great to hear and see what a lot people are doing and making.
Final Advice - talking about vids and doing the vidding
• watch vids
• rewatch vids
• leave a comment and ask a question about something you saw in their vid!
• Again: find someone’s AO3 page of fanvids and ask them something about their vid in a comment or send them asks on tumblr (people usually have the same alias or link to their tumblr or dreamwidth pages somewhere.)
• YouTube can be a valuable resource for tutorials so if you don't know something, there is likely someone who has made a tutorial about how to use a cross dissolve transition or anything else you might want to replicate in a video that you've seen in a vid.
• start making a vid, scream and cry, ask for help, and keep going until you get it done. Celebrate and bask in your completed vid and share it with everyone!
• Follow vidders on tumblr that you find from the vidder ask game
• Check out the vidding discord for community and questions and vid recs and news about vidding exchanges and cons.
• Have fun!
Hope this helps you get started! Thank you so much for the ask! Let me know if you have more questions and I can help you out or send you to cool vidders who have great advice and suggestions. And please send me your vid if you make one!
Have you ever wished you could have the easy organization of the AO3 site with fanfiction you have downloaded? I've been working on a project that makes setting this up really easy, even for people with little technical experience.
You can access the library files and instructions on this Codeberg page.
The Easy Fanfic Library enables users to easily download works from AO3 and other fanfiction sites into a library in Calibre, a free e-book management software. The library will keep all the metadata (title, author, series, ratings, characters, additional tags, date posted, etc.) intact and in separate fields. This way you will be able to quickly download fanfiction and sort/filter downloaded works similarly to how you would filter on AO3 itself (including by your personal bookmark data and tags).
The library uses the FanFicFare plugin for Calibre, which enables you to download fanfiction and metadata directly into Calibre from URLs. FanFicFare can download works from a multitude of sites, including many with no built-in download option on the sites themselves.
Calibre comes with many useful features as well, such as easily sending your library to an e-reader or mobile device.
I hope this makes downloading fanfiction easy for you all! Enjoy!
I created a spreadsheet correlating every Berry in Pokemon to the real-life food it is based on, along with notes related to the idea behind the Berry and notes about the real-life foods that writers might find interesting. I figured other Pokemon writers who refuse to accept our fruits in the Pokemon world might find it useful, so here is a link to another post where you can get the PDF!
Some Miami Vice-related links from Tubi (free, no login req, works best on desktop) that y'all might find interesting!
The child of a junkie aristocrat and a schizophrenic showgirl recounts his half-century journey in entertainment with help from his famous f
^ At the 53:20 mark is a segment specifically about Don Johnson and Miami Vice, including old photos of DJ and an interview. Apparently in the early '80s a diverse group of actors and rockstars used to get together every weekend to play Trivial Pursuit!
The rest of the doc is very good too btw, and DJ is in more than just that segment.
(more links below cut)
Johnny Carson Show Interviews
Tubi lacks a comprehensive or even complete listing of episodes for this show, so these actually took a while to find. imo, JCS is cringe and so are these interviews, but they are historically fascinating
Don Johnson - aired 9/25/87, 17:03; one of two appearances
Saundra Santiago - aired 9/17/86, 28:35; one of seven appearances (JC liked teasing ditzy women)
Philip Michael Thomas - aired 4/25/86, 24:25
You can probably find these and the missing ones on YouTube as well.
MV Actors Other Films
Currently on Tubi (Aug '23), which also hosts the entire series of Miami Vice (sans "Evan") for free. I didn't look up the smaller actors.
