#these are all in spreadsheets every year i'm just posting them this year
Text
January in Review
Reading
388 pages of original fiction in 5 hours, 9 minutes
>>388 pages of Worth Any Price by Lisa Kleypas
137,416 words in 33 fanfictions from 23 authors in 10 fandoms
>>14 (38,853 words) in the Glee fandom (Blaine/Sebastian)
>>3 (10,395 words) in the Harry Potter fandom (Hermione/Ron, Draco/Harry, Remus/Sirius)
>>3 (12,565 words) in the Hunger Games fandom (Katniss/Peeta, Gale/Katniss/Peeta)
>>2 (9,860 words) in the Life With Derek fandom (Casey/Derek)
>>2 (10,810 words) in the MCU fandom (Bucky/Steve)
>>1 (2,635 words) in the Once Upon a Time fandom (Emma/Neal)
>>2 (31,012 words) in the Star Wars fandom (Cassian/Jyn, Ben/Rey & Finn/Poe)
>>3 (8,501 words) in the Stranger Things fandom (Chrissy/Eddie, Billy/Steve, Jonathan/Nancy/Steve)
>>2 (9,037 words) in the Toy Story fandom (Andy/Sid)
>>1 (3,748 words) in the X-Men fandom (Charles/Erik)
>>>>30 were new to my memory, 3 were ones I'd read in recent history
Writing
19,765 words written in 13 days
>>17,548 words of fanfiction
>>>>11,164 words of Seblaine
>>>>882 words of Reylo
>>>>540 words of Drarry
>>>>164 words of Joel/Rose (Smile 2022)
>>>>4,798 words of Dead Dove content (Blaine/Cooper, Blaine/other, HP Chan Fest)
>>2,217 words of original fiction
6,912 words published on ao3
>>6,912 words of Seblaine
>>>>5,375 of I Didn't Know What I Was After
>>>>1,537 of Sweeter With Time
Other Online
Changed my tumblr skin
>>Changed my about page
>>Added a wip page that I will be finishing next month
Added several fics to my fic rec page
Personal
Worked 100 hours and 39 minutes in 14 days.
Slept 264 hours, averaging 8 hours and 27 minutes a night.
Drove 46 hours and 21 minutes, including 22 hours and 20 minutes driving from Washington to Arizona.
Got diagnosed with strep throat that I'd been nursing for a week+ and took antibiotics.
Moved home to Arizona after spending 7 weeks in Washington state.
Spent 4 hours and 35 minutes at my little sister's high school watching her perform as ensemble in Matilda twice. She was one of three sophomores chosen to perform in the upper-class play.
February Goals
Read 2 novels
Write more original fiction
Finish my wips page
Edit at least 5 old one-shots
#month in review#let's hold myself a bit accountable this year#also i read almost all that fanfiction in 2 days as i desperately completed my comment_bingo#and you know what i did it lmao#also when i say i have ocd i actually have ocd#these are all in spreadsheets every year i'm just posting them this year#i keep track of everything i read#libby keeps track of my reading time and i use timers#i am compulsive at keeping up with my word count spreadsheet and what i've written#and my life cycle app keeps track of everything else
0 notes
Note
About your tags: is there more that you can share about the OW fandom and fics? This was a phenomenon I wonder about too. It was one of the most popular fandoms around 2017-2018, but the way the fandom stopped on its tracks around 2019 was hard not to notice. Especially from people who didn't play the game but were aware of it's fandom.
oh! overwatch is one of about 50-ish fandoms i track for this one spreadsheet project i do as a hobby (which i Technically blog about @fandom-data-scientist, but i've been too lazy to do a proper writeup to explain what the hell it is i do), wherein i try to answer the age-old question: when did the weebs move to ao3?
(the answer is late 2015/early 2016. most likely this was in large part a result of undertale and sports anime, but that's currently just my own conjecture)
According To My Research(tm), the overwatch fandom peaked in late 2016/early 2017 when it comes to the number of new fics posted per month. after this, it declined quite rapidly, as it didn't even get to enjoy a plateau period.
(there's a reason why the plots are really wonky towards the end of this graph-- it's bc i found the past dates for number of fics archived to a particular site via the wayback machine. since those snapshots are typically bot crawls, the number of fics shown on the fandoms listings will not include fics that have been archive-locked. although i technically started this project in august 2022, i did not add overwatch to my tracking list until this june/july or so. my current guess for the small uptick in the rate of ow fics published to ao3 in october 2022 is that the sequel came out? and then the rate plunged for january 2023 bc of the ai scraping scare that happened at around that time-- nearly every single fandom i track had a significant drop right then bc everyone was archive-locking their fics. the rate shooting up in like july 2023 on this chart is bc like i said, that's when i added ow to my list of tracked fandoms; because i'm logged into my own ao3 acct when checking these numbers live, i get access to the archive-locked fics and so the display number goes up.)
in my experience, fandoms will generally kind of plateau in their fic production after their peak, which will ofc normally gradually taper off. games that receive regular lore or story updates probably have fairly long or stable plateaus, although i haven't made scatterplots or made any comparing analyses to prove this rigorously. this plateau period generally represents a time of fandom stability as the fair-weather, casual, or migratory slash fans run off to the next big thing.
if we ignore the fact the plague and quarantine happened, we can see a nice, steady, and very consistent plateau period for the danganronpa fandom from about 2018-2020!
let's look at an older fandom, like my archnemesis final fantasy:
granted, the ao3 numbers are kind of all over the place these days, but you kind of get my point by now, right? that healthy fandoms tend to plateau as the wind carries away the faintly-interested and leaves the long-haulers behind to form their communities.
overwatch struck me as unusual when i was on one of my long wayback machine trips because of the way there was a net increase of only two fics published from 1 july 2021 to 1 october 2021, when before then it had usually been in the hundreds or so. i then went on a work tangent n googled around n more or less concluded it had Something to do with some kind of scandal with the development company, but otherwise i don't really have any more comments on it hahaha.
#asks#Anonymous#long post#i was too lazy to open my other spreadsheets in the project but i probably could've gotten clearer/longer plateaus#out of some of the western tv shows i've been tracking. like glee. or spn.#glee is INCREDIBLY funny to me bc of the way it just DIES right after the finale. like a bubble POPPING#although frankly maybe naruto would've been a better example for a peak n a plateau bc of how steady its fandom is#anyway this felt kind of like an odd ask to answer on this blog bc i keep it Very Separate from my fandom blog(s) hahaha#anyway i also looked at the rate of fic postage for the kingdom hearts fandom n although i didn't talk abt it here in this reply#i thought it interesting how it seemed to plummet on ffn around when ao3 n tumblr started getting a foothold#and then after the weebs moved to ao3 post-undertale/sports anime boom it had a nice steady 300-ish fics/month there#ANYWAY the reason final fantasy is my archnemesis for this project is bc ffn has each game split into its own category#and so i have to count them all up every single time n when doing that for every single fucking date i have marked in the wbm#for 20 YEARS' WORTH OF DATES. well. it upsets a man just a little bit.#BUT I'M DONE I DID MY TIME ON THE FINAL FANTASY BACKLOG I'M FREE NOW I JUST HAVE TO DO IT EVERY THREE MONTHS WHEN I RECORD LIVE DATA#i talk abt this shit at parties btw. people love to hear me talk abt my fandom spreadsheets at parties.
2 notes
·
View notes
Text
on ao3's current fundraiser
apparently it’s time for ao3’s biannual donation drive, which means it’s time for me to remind you all, that regardless of how much you love ao3, you shouldn’t donate to them because they HAVE TOO MUCH MONEY AND NO IDEA WHAT TO DO WITH IT.
we’ve known for years that ao3 – or, more specifically, the organization for transformative works (@transformativeworks on tumblr), or otw, who runs ao3 and other fandom projects – has a lot of money in their “reserves” that they had no plans for. but in 2023, @manogirl and i did some research on this, and now, after looking at their more recent financial statements, i’ve determined that at the beginning of 2024, they had almost $2.8 MILLION US DOLLARS IN SURPLUS.
our full post last year goes over the principles of how we determined this, even though the numbers are for 2023, but the key points still stand (with the updated numbers):
when we say “surplus”, we are not including money that they estimate they need to spend in 2024 for their regular expenses. just the extra that they have no plan for
yes, nonprofits do need to keep some money in reserves for emergencies; typically, nonprofits registered in the u.s. tend to keep enough to cover between six months and two years of their regular operating expenses (meaning, the rough amount they need each month to keep their services going). $2.8 million USD is enough to keep otw running for almost FIVE YEARS WITHOUT NEW DONATIONS
they always overshoot their fundraisers: as i’m posting this, they’ve already raised $104,751.62 USD from their current donation drive, which is over double what they’ve asked for! on day two of the fundraiser!!
no, we are not trying to claim they are embezzling this money or that it is a scam. we believe they are just super incompetent with their money. case in point: that surplus that they have? only earned them $146 USD in interest in 2022, because only about $10,000 USD of their money invested in an interest-bearing account. that’s the interest they earn off of MILLIONS. at the very least they should be using this extra money to generate new revenue – which would also help with their long-term financial security – but they can’t even do that
no, they do not need this money to use if they are sued. you can read more about this in the full post, but essentially, they get most of their legal services donated, and they have not, themselves, said this money is for that purpose
i'm not going to go through my process for determining the updated 2024 numbers because i want to get this post out quickly, and otw actually had not updated the sources i needed to get these numbers until the last couple days (seriously, i've been checking), but you can easily recreate the process that @manogirl and i outlined last year with these documents:
otw’s 2022 audited financial statement, to determine how much money they had at the end of 2022
otw’s 2024 budget spreadsheet, to determine their net income in 2023 and how much they transferred to and from reserves at the beginning of 2024
otw’s 2022 form 990 (also available on propublica), which is a tax document, and shows how much interest they earned in 2022 (search “interest” and you’ll find it in several places)
also, otw has not been accountable to answering questions about their surplus. typically, they hold a public meeting with their finance committee every year in september or october so people can ask questions directly to their treasurer and other committee members; as you can imagine, after doing this deep dive last summer, i was looking forward to getting some answers at that meeting!
but they cancelled that meeting in 2023, and instead asked people to write to the finance committee through their contact us form online. fun fact: i wrote a one-line message to the finance committee on may 11, 2023 through that form, when @manogirl and i were doing this research, asking them for clarification on how much they have in their reserves. i have still not received a response.
so yeah. please spend your money on people who actually need it, like on mutual aid requests! anyone who wants to share their mutual aid requests, please do so in the replies and i’ll share them out – i didn’t want to link directly to individual requests without permission in case this leads to anyone getting harassed, but i would love to share your requests. to start with, here's operation olive branch and their ongoing spreadsheet sharing palestinian folks who need money to escape genocide.
oh, and if you want to write to otw and tell them why you are not donating, i'm not sure it’ll get any results, but it can’t hurt lol. here's their contact us form – just don’t expect a response! ¯\_(ツ)_/¯
#ao3#otw#archive of our own#organization for transformative works#ao3 is not your savior#and they don't need your money#otw finances
3K notes
·
View notes
Note
Hello, Mr. Badge, I seem to remember that you once posted about your processes and systems for staying organized in life with Excel spreadsheets etc. I’ve been struggling a lot with depression and executive dysfunction issues and don’t want it to impact my work.
Do you use the same processes at work? I get overwhelmed with the amount of documentation we have and the exceptions to the rules in our processes.
I'm so sorry you're struggling! It's really rough, and the more complicated the task feels, the more fraught it seems, the harder it is to even get a start. I feel that hard.
As for organizing work like my home life....well, it's sort of the same. I don't make a strong distinction between life and work simply because a lot of what needs organizing in my life IS my work, so it's tough to talk about them separately.
For example, I use Google Tasks to build a to-do list each day, but that to-do list starts with "stuff I'll do before work" then "shower" then all my work stuff, then "evening" and then all the stuff to do after work, ending with "7pm chores" (because I have a lot of stuff to do right around 7pm, which I need to post about elsewhere). Then the stuff I've pushed off to next day is below that, and that just bumps up the next morning. What's important isn't really how I keep the list, but that I keep it in a way that is constantly accessible, and I've trained myself to 1. put everything on it, even stuff like "grocery shop" and 2. check it whenever I feel lost. I don't find google calendars very helpful, however, so while work makes me use one for meetings, everything else goes on a calendar I made in Google Sheets that I'm just super used to by now.
It sounds like you're having a fairly specific issue, which may not even be related to your mental health (though assuredly the mental health issues aren't helping). If you have a lot of confusing documentation and exceptions in the stuff you do at work, that can be legit stressful even for someone who isn't dealing with other stuff, so I just want you to know that this may not only be a You Problem. My problem is usually the opposite, in that I'm often the first person doing something, or the only person who's done it in a while, so there's no documentation at all. But when I do have documentation I often will simply rewrite it.
After all, just because you have a handbook doesn't mean you have to use it. You can copy it over into another document and make yourself a step-by-step guide and/or a checklist. Like, I do our holiday cards every year, and my "HOLIDAY CARDS" document says "Here's the first thing you do, here's the second, do this before going past that, check this before asking for that". Literally at one point the document says "Stop. Before you go any further, do this step. Even if you don't understand why, do this step" because in the past I've disregarded that instruction ("Why on earth would I do it this way?") and lived to regret it.
Making the guide really, really sucks. Often it will take me four or five passes at a project before my guide is comprehensive (this is my fifth year doing the holiday card project and the document still has some steps missing at the end). But once you have it, it's invaluable, and often in the past I've found other people want my guides because they're fairly clear and precise about what needs doing when. For example, you might say, "Open the file and move column B to in front of column A. NOTE: THERE IS ONE EXCEPTION, THIS IS THE EXCEPTION." Or "Once you've saved the file, save a second copy to your backup folder so you can go back to it if you delete something you shouldn't. Stop and check: is this file from before or after October? If after, remember, you have to also rename it." If you find that there's a mistake you make frequently, figure out what would stop you from making it and add that in.
(We had a guy at work whose last name was VERY long and Italian, and so when I was working phones he got a special entry in the directory document I made -- the first line was all his directory info and the second line was just the phonetic pronunciation of his last name. He found out, which I had never intended him to do, and lost his shit laughing. "No wonder you're the only one who gets it right!")
So my recommendation to you is to create your own handbook, your own templates, and your own way of doing things and just slip that back into the system you have at work. Draw a diagram by hand if you need a flow chart. My approach to all my organizational issues has always been "What would make me do this correctly / prevent me from doing that thing wrong / remind me what to do / make it easier for me to start".
I think of this nowadays as the "Take the cupboard doors off" school of organizing, because to really make full use of my kitchen in a way that I liked, I had to take some of the cupboard doors off. It looks messier and kind of cheap, but it's actually a much more organized system now, and who's in my kitchen other than me?
208 notes
·
View notes
Note
Seeing all posts about so and so merging with AO3 or this fandom archive moving over ...how does the process work? Like how do you avoid story duplicates or even authors? What happens when one author posts the same story under different names on AO3 and whatever old archive you're merging with? Can you filter that out? Easy of course if stories are only posted on the smaller archive and being moved to AO3 but authors post on different platforms all the time so I'm curious how the process actually works on your end.
This is such a great question! I didn't know so I went and asked the people who are in charge of moving archives onto AO3.
Eskici here! I’m one of the chairs of the Open Doors committee, which is responsible for all of the imports of offline and at-risk archives to AO3.
Before each import is announced, we compile a spreadsheet with a row for every fanwork from that archive. (If the archive is backed by a database, we can often export this spreadsheet manually, but for hand-coded archives, we often do this manually.) Creators frequently email us shortly after we announce an upcoming import to let us know that their works from the archive are already on AO3 (or if they don’t want their works imported for any other reason), and we track those requests in the spreadsheet as they come in so that we don’t import duplicates.
Then, as close to right before the import as we can, we manually search AO3 for every fanwork from the archive whose creator hasn’t already contacted us. Usually, we start by entering just the title of the work and a keyword or two from the name of its fandom. We try to cast as wide a net as possible so that we don’t accidentally filter out results from anyone who didn’t tag their work with the canonical fandom tag, with tags for characters/relationships in the work, etc.
If we don’t turn up any results, we mark the work not found, but if we do find a matching work, we check to make sure the content is the same and then mark on our spreadsheet not to import it and instead invite that work to the AO3 collection that the imported archive will feed into. On the other hand, if we find too many matches to check all of them, we add keywords to the search to try to make it more manageable for our searchers.
As you can imagine, this is a lot of manual work for us to do on top of the imports themselves, which are sometimes manual as well. Open Doors recruited for import assistants earlier this year to help with tasks exactly like these ones, and we hope to do so regularly in the coming years!
If you ever have an offline or at-risk archive you’d like us to look into importing (with moderator permission), you can always reach us at [email protected]. And if you’re interested in volunteering for the project, keep an eye out for recruitment. We usually recruit for our different roles at least once or twice a year. Thanks for your interest in fanwork preservation!
465 notes
·
View notes
Text
//IMPORTANT PLEASE READ//
Heyo, I just wanted to make a little post in regards to updates and the future of this blog. It's already pretty obvious that I'm not as in to Hazbin anymore. I still adore the au that I and all of you created. However, as time has passed, the issues I have with the show and fandom have only just continued to sour things. It's also just a general loss of hyperfixation. I've been a fan of hazbin and helluva for years now. The same goes for pretty much most of vivs work. But the fandom (and ngl Viv herself) is just getting so toxic, and to put it simply, I just don't enjoy the shows anymore. (I could go on a whole rant about all of that, but I would rather not. I'm definitely in the middle as far as the fandom goes. I'm not complaining and being nit-picky about every little detail, but I'm also not going out of my way to harass anyone who dares say they dont like the shows. Cause that's dumb)
I also want to add that my cancer does play a part in all of this. There was a lot more I wanted to do with The Hart Hotel, but I couldn't. And by the time my energy came back, the hyperfixation had started to fade. And I'd much rather spend what little of it I have left on stuff I do like.
I'm truly sorry if this has disappointed anyone. I know what it's like to follow someone and watch them move onto different things before you do. I also want to make it clear that the bit of the fandom I have directly interacted with per The Hart Hotel has been absolutely wonderful, and the main reason I didn't drop the whole thing months ago.
I'm still leaving all of the stuff up! And I highly recommend checking out the spreadsheet linked in the masterpost. The guy who made it is very cool. I don't want to say the Au will be stopped cold turkey. Who knows, I might still make occasional drawings in the future. But I'm definitely moving on to different things. Like I said before, I just don't enjoy the HH universe anymore. Easier to create stuff for things you actually like, y'know.
Anyways, ty for coming to my Ted talk, I really do appreciate it if you've gotten this far. Even with this sad end, I still very much enjoyed everything that came from this silly AU.
63 notes
·
View notes
Text
Happy Birthday, Aeor is For Reccing!
One year ago today (give or take a couple hours), we published our first rec list. To celebrate, I (Opera) have prepared some stats. A little bit like a reccing wrapped, only with a smaller budget and being less creepy about your data.
But thank you to everyone who has recced, every one who has read the reclist, everyone who has reblogged, everyone who has kudosed, to @professor-rye and @theusualjasper, and everyone who helped along the way.
I'm glad we've gotten this far!
To start: We've had 685 recs, 478 fics, 210 Authors, 53 reclists and 43 themes.
Most Recced Authors:
(1) Mousecookie - 25 recs
(1) royalgreen - 25 recs
(3) SaltCore - 21 recs
(4) hanap - 15 recs
(5) kmackatie - 14 recs
(5) Chrome - 14 recs
(5) Firefright - 14 recs
(8) Mlle Kurtz - 12 recs
(9) road_rhythm - 11 recs
(9) MinnesotaBruja - 11 recs
(9) LuckyOwlsFoot - 11 recs
(9) MarsBar2019 - 11recs
Authors with the most fics recced:
(1) royalgreen - 18 fics
(2) SaltCore - 13 fics
(2) hanap - 13 fics
(4) Mousecookie - 12 fics
(5) kmackatie - 10 fics
(5) LuckyOwlsFoot - 10 fics
(7) Firefright - 9 fics
(7) Jakia - 9 fics
(9) Professor_Rye - 8 fics
(9) Mlle Kurtz - 8 fics
Fics recced the highest number of times:
Hard Mouth and The Hole in the Stone, both recced 8 times
Fic recced the most number of times for a single theme:
In the Closet of Our Discretion, by Firefright for Cultural Differences (recced 4 times)
Longest fic recced: Dappled Shadow and Penumbral Light by Professor_Rye (463,977)
Shortest fic recced: Of Constellations and Freckles, also by Professor_Rye (100 words)
First fic Recced: Stay for a Spell by Palebluedot
Latest fic Recced: Uncharted Waters by EmpressofWizards
Word Cloud based on what people like about the fics:
Most common content note: Choose Not To Warn
Number of Series recced: 16
Percentage of Hidden Gems that are No Longer eligible (have over 150 kudos): 48% (check them out!)
Number of Images Rai has Used: 27
So what's next?
Well, the absolute next thing is that sometime this week I'm going to post the reccing spreadsheet for everyone to see - if people want to look through old recs, they should feel free to!
Then there's the ideas I had from the survey a few months ago - chief among them was making it easier to import information from AO3 (you'd still be able to rec fics that can't be imported or on tumblr, I'm just trying to remove some of the hassle) I'm still doing research on the best way to make that happen, and kind of selfishly want to do it myself - but it's been a busy couple of months for me.
Speaking of which - I'm having surgery in a month! A double masectomy and reconstruction on February 19 (roughly equivalent to top surgery (masculinizing)) and February 20th (roughly equivalent to top surgery (femininzing- fat grafting)). Kind of like they're turning my chest on and off again - a ctrl-alt-deteat, if you will. Anyway, I don't want cancer, but everyone I've talked to about this has said the stomach incision is worse than the chest incision, and nobody's ever described top surgery as a walk in the park. I'm planning on doing absolutely nothing for six weeks, and @theusualjasper will be taking over during that time.
Anyway, here's to another year! Thanks to everyone who has participated or helped along the way, you're all great. Even you <3
110 notes
·
View notes
Text
every once in a while i like to poke my head into "anti [x]" tags just to see what the other side thinks. recently i was looking through "anti ao3" and found a really funny post claiming that ao3 is not anticapitalist, but actually the Definition Of Capitalism, bc it relies on volunteer labor while supposedly having the money to pay a staff.
oh, honey.
but i am not going to make unsubstantiated claims on the internet, no, and this gives me an excuse to look at ao3's whole budget myself, which i've been meaning to do for a while. these numbers are taken from the 2022 budget post and budget spreadsheet.
ao3's total income for 2022, from the two donation drives, regular donations, donation matching programs, interest, and royalties was $1,012,543.42. less than $300 of that was from interest and royalties, so it's almost all donations. and that's a lot, right? surely an organization making a million dollars a year can afford to pay some staff, right?
well, let's look at expenses. first of all, they lose almost $37,000 to transaction fees right away. ao3 and fanlore (~$341k and ~$18k, respectively) take up the biggest chunks of the budget by far. that money pays for, to quote the 2022 budget post, "server expenses—both new purchases and ongoing colocation and maintenance—website performance monitoring tools, and various systems-related licenses."
in some years, otw also pays external contractors to perform audits for security issues, and for more servers to handle the growing userbase. servers are expensive as hell, guys. in 2022, new server costs alone were $203k.
each of their other programs only cost around $3,000 or less, and otw paid around $78k for fundraising and development. wait, how do you lose so much money on your fundraising?? from the 2022 budget post: "Our fundraising and development expenses consist of transaction fees charged by our third-party payment processors for each donation, thank-you gift purchases and shipping, and the tools used to host the OTW’s membership database and track communications with donors and potential donors."
then the otw paid an additional $74k in administration expenses, which covers "hosting for our website, trademarks, domains, insurance, tax filing, and annual financial statement audits, as well as communication, management, and accounting tools."
in case you weren't following all of that math, the total expenses for 2022 come out to $518,978.48. woah! that's a lot! but it's still only a little over half of their net revenue. weird. i wonder what they do with that extra $494k?
well, $400k of it goes to the reserves, which i'll get to in a second. the last $93k, near as i can tell, gets rolled over to the next year. i'll admit this part i'm a little unsure about, as it's not clear on the spreadsheet, but that's the only thing that makes sense.
the reserves, though are clear. the most recent post i could find on the otw site about it were in the board meeting minutes from april 2, 2022: "We’re holding about $1million in operating cash that is about twice the amount of our annual operating costs. There is another $1million in reserves due to highly successful fundraisers in the past. The current plan for the reserves is to hold the money for paid staff in the future. It’s been talked about before in the past and we’re still working out the details, but it’s a rather expensive undertaking that will result in large annual expenses in addition to the initial cost of implementation."
woah....they're PLANNING to have paid staff eventually! wild!
so let's assume, for easy numbers, that the otw currently has $1.5 million in reserves. before we even get to how to use that money, let's look at the issues with implementing paid staff:
deciding which positions are going to be paid, because it can't be all of them
deciding how much to pay them, bc minimum wage sure as hell isn't enough, and cost of living is different everywhere, and volunteers come from all over the world
hiring staff and implementing new systems/tools to handle things like payroll and accounting
making sure you continue to earn enough money both to pay all of the staff and have some in reserves for emergencies or leaner donation drives
probably even more stuff than that! i don't run a nonprofit, that's just what i can think of off the top of my head.
okay, okay, okay. for the sake of argument, let's assume there is a best-case scenario where the otw starts paying some staff tomorrow. how much should they be paid? i'm picking $15 an hour, since that's what we fought for the minimum wage to be. by now, it should be closer to $20 or $25, but i'm trying to give "ao3 is capitalism" the fairest shot it can get here, okay?
ideally, if someone is being paid to help run ao3, they shouldn't need a second job. every job should pay enough to live off of. and running a nonprofit is hard work that leads to a lot of burnout--two board members JUST resigned before their terms were up. what i'm saying is, i'm going to assume a paid otw staff is getting paid for 40 hours of work a week, minimum. that's $31,200.
at $400,000 per year, the otw can afford to pay 12 people. that's WITHOUT taking into account the new systems, tools, software, etc they would have to pay for, any kind of fees, etc, etc.
oh, and btw, if you're an american you're still making barely enough to survive in most places, AND you don't have universal healthcare, vision, or dental. want otw to give people insurance, too? the number of people they can pay goes down.
it's. not. possible.
a million dollars is a lot of money on the face of it, but once you realize how MUCH goes into running something like the otw, it goes away fast.
just for reference, wikipedia also has donation drives every year. wikipedia, as of 2021, has $86.8 million in cash reserves and $137.4 million in investments. sure, wikipedia and ao3 are very different entities, but that disparity is massive. and i should note that if you give $10 to wikipedia they don't give you voting rights, i'm just saying.
by the way, you may have noticed that i didn't mention legal costs at all here. isn't one of otw's big Things about how they do legal advocacy?
yes, it is. they have a whole page about that work. and i can't for the life of me find a source on otw's website (and i'm running out of time to write this post, i'll look harder later), but i am 90% sure i learned before that most, if not all, of otw's legal work/advice/etc is done pro bono. i've also seen an anti-ao3 person claim their legal budget is only $5k or so, but they didn't have a source. but keep in mind that if they don't have a legal budget, all the numbers above stay the same, and if they do, there is even less money available for paid staff.
you can criticize ao3 and the otw all you want! there are many valid reasons to criticize them, and i do not think they're perfect either. but if you're going to do so, you should at least make sure you can back up your claims, bc otherwise you just look silly.
#ao3#otw#anti ao3#bc i want them to see this#otw board#ao3 discourse#ao3 donations#wren wrambles#that post was so unserious i died#if it was more recent (its from mid-july) i wouldve replied directly maybe#but i didnt want to drag the body of a 6-note post into the light OR attack the op directly so#also! if i misunderstood something pls let me know im doing my best
174 notes
·
View notes
Text
welcome to birds daily!!
this is my blog where i draw a bird every single day! the idea was completely ripped off from one of my best friends of all time, @fish-daily !! please go check him out :0)
my name is sunny and i'm a wildlife biology major and art minor from the eastern united states. i'm 21 years old and i use they/them pronouns!
i'm here because i love birds so much, and i'm assuming if you're following then you do too!!
IMPORTANT INFO BELOW!!
what to know before you request
please check if i've drawn a bird before you request it! if you don't want to scroll through everything, all my birds are tagged by order. don't know the order of your bird? look it up! the IOC world bird list has a great resource for this.
i tag them by name, but some birds have multiple common names.
i also have a spreadsheet of every bird i've done so far! but i can definitely see myself forgetting to update this, so it's best to double check.
any avian dinosaur archaeopteryx-and-beyond can be requested! many ornithologists consider avialae to be the cutoff for "modern" birds.
i can't guarantee full-accuracy of prehistoric birds as i'm not very well-versed in paleontology.
please keep asks to only one bird! feel free to send multiple asks though. if you include multiple birds in an ask i'll just pick one. when i answer the ask to post it, the other birds will be gone forever...
i will prioritize requests in the order i received them in, but a couple times a week i might draw a personal pick instead.
not accepting duplicate birds doesn't mean you can't request a different version of the same bird, which leads me to…
sexual dimorphism and seasonal plumage!
yes! you can request different plumages and sexes of a bird i've already done! want to see a female ruddy duck? of course! want the breeding plumage of the willow ptarmigan? absolutely!
i have sex, maturity, and plumage recorded on my spreadsheet, but i'm bound to make some mistakes on there. once again, double-checking my blog is your best bet to getting accurate bird info!
if you don't specify anything, i'm going to assume the basic mature male with breeding plumage that you come to expect from a bird.
breeding and non-breeding plumage can also be called summer and winter plumage. some birds also have special names for their plumage forms. just to keep things consistent i'll be referring to it as breeding and non-breeding!
final notes
my main blog is @eggpathy if you're interested in any of my other art! i forget to post there a lot. most of my art is on my twitter under the same name (trying to move here though)
i'm a full-time college student with a job, so some days i won't be able to get a bird out. sometimes i might even have to take a few days to a week off just to keep my sanity. this doesn't mean i'm not having fun and enjoying drawing birds! it just means i'm busy and maybe need time for other things
i'm also still human. this means i WILL MAKE MISTAKES! i have not finished my degree yet and i'm still learning! one of the big reasons i made this account was to help myself learn my birds! i take extra time out of my day to find facts to post with my birds, and sometimes those are wrong. if you see me post misinfo, please kindly correct me with a comment, dm, or tag!
any post that isn't a daily bird will be tagged #not birds. any post that is a daily bird will be tagged #birds.
please feel free to add extra fun facts, info, and generally any other silly comment in the tags. i love reading them and they make my day!
asks don't have to be request-related! feel free to ask me anything :0)
thanks for reading! peent!
60 notes
·
View notes
Text
The F@tT Fic Marathon: Catching up finally.
🎉I have officially read the full Friends at the Table AO3 tag!🎉
My very silly quest has reached its technical end point after EXACTLY 10 months of intensive reading! It has been sometimes grueling, often delightful, and led to me developing intense opinions in directions i never thought possible to myself. But I have done it, and I am extremely pleased with myself.
To get some housekeeping out the way, I usually give recs upon a writeup, but since there were only three fics left for me to read i'm just gonna shout them out generally.
Fics 1981-1983
check out i'm too scared to say half of the things i do (when i picture you) by waltztangocache for partizan era Kal'mera Broun fantasizing about Valence and trying to keep from letting that slip through their telepathic bond
and if you like Christmas fic, fangirl_squee has got you covered with Fero "not liking Christmas" but being roped into it anyway, and the Bluff City Masks crew hunting down some Christmas mini-miracles
and like, if you're looking for something to read, remember every single writeup has come with at least one personal recommendation. it's all under the tag #fatt fic marathon (also a caveat that these recommendations come from my personal tastes, i might not have mentioned a fic during the marathon that's a favorite of yours and i hope you continue to deeply enjoy what you love even when it might not have hit where I would have liked)
if you would like to take a look at the massive spreadsheet I used to keep track of which fics I was set to read together, as well as other info like what season it was for, and word count, here is a link to it!
What next?
First of all, I'm gonna spend a good long time reading other things. I've accumulated a great big To-Be-Read pile of pleasure reading consisting of both real-ass books and other fanfic that have been put at a lower priority while I powered through this project. I have had fun, but it is high time for a Break to read and do other stuff for a bit. (*glances nervously at my unstarted secsam project*)
If you happen to like my thoughts about what I'm reading, this past year I tried to keep track with reading log posts. They got stripped down to the basics over the course of the year and Finals Season sorta took it out of me so there's nothing for the past couple weeks BUT. i like reading a lot and i like talking about it a lot. so that's all tagged as #cal reading log if you want to keep up with me and my reading
and, what shall happen to these writeups! I'm not interested in continuing these in perpetuity, but I may give a final send off one when the tag hits 2000 (i'm still deciding). otherwise, this is likely the end of them. I might still shout out inidivudual cool fics that get published as I read them, but that's just like, good fandom practice to spread around cool fanworks tbh, rather than this weird thing I've done. nonetheless, i hope y'all had fun watching this journey
and a final thank you to all of the lovely authors who have made fanfic writing their hobby and have chosen to share what they write with others. Thank you! it is extremely obvious that I could not have done this if they never put pen to page or fingertip to keyboard and did the dang thing in the first place. you've made some cool stuff and i like reading it.
Happy New Year Everyone!
59 notes
·
View notes
Text
I listened to the final ep of @anotherkindofmindpod's Fine Tuning, yesterday. I'm so sad it's ended. I loved every.single.second. I don't think I've posted about it at all, but it's only because everyone was already saying it better, and my posts end up in drafts half finished and confused and full of runaway sentences of little import.
I'm really grateful for the whole thing. Grateful the way I was when I watched Understanding Lennon McCartney the first time, like being given a genuine gift of fandom making sense of itself. I don't know. It's just lovely to have. And it's done so well.
When, in the first ep, they casually mentioned that there were going to be ELEVEN episodes I knew it was going to be amazing. Proper genuine "we have a lot to say and we're going to say it all so you don't think we didn't think it through" you know? I love that they didn't start making eleven episodes and then decide that was too many and cut 40% of it out, it's more like they wanted to make twenty episodes and then cut out about 40% of that. Making eleven episodes and then being like 'we didn't even have time to talk about anything that we LIKED about this book' is a real move. A perfect shiny move.
The fact they made a spreadsheet sends me into fits. I love it.
Cards on the table I have not read Tune In properly, I have skimmed and picked at it, and obviously I've seen loads of it quoted on tumblr, but EVERY quote you read from it (and everything he says in interviews) makes it so fucking OBVIOUS that he doesn't understand basic things, I've never been able to face it full on. And the frustration that people (men) can't see how bad it is. So having it put out there like this, bit by bit, oh the joy of it.
And then it's also so much worse than I knew, because I'd never really worked out that he was just MAKING UP QUOTES and mushing them together to say new things, and oh my god the stuff that's NOT in there, is insane. The bit in episode 3 where AKOM quickly list off about five or six really interesting things about Paul's art in his schooldays and then you find out that Tune In didn't even MENTION that he liked to paintklsjdofihoijsodijfohwoisjdf OH MY GOD.
I'm blown away by the work of it, and the scale of it, and how well put together it was. I love the *feel* of it. I love its tone when they let the sarcasm ride high. The voices of "sincere surprise" are just my favourite thing. "Oh, so he mentions that Paul did x and y right?" "Actually, weirdly he doesn't!" "Oh, HOW STRANGE. But does he say he was interested in z???" "Oddly no." I love the sense of giddy anticipation in the intro ep, it must have been killing them to have made so much of it and not be able to talk about it.
I'm so fully aware that all of what they're saying will move into other podcasts, and become things that men sort of talk about as if obviously everyone kind of sees the bias in Tune In, even though they've always talked about it as if it's a great work of truth until now. It kills me softly. And they'll claim it's only POSSIBLE to see that now, ten years later when it's spelled out to them, as if it's aged badly or something, when actually female fandom has been fucked off with Tune In for fucking years. But that's FINE. WHATEVER.
Also glorious have been all the posts people posted around it, and how the conversation grew, and especially the fact that @mythserene had clearly been doing a lot of the same work. Her posts in tandem with the show are so wonderful, and make it even more special, the depth of fandom for the love of fandom <3333333
63 notes
·
View notes
Text
So, it's October -- crazy, right? About three months ago, I got waaay too emotionally invested in Din Djarin and baby Grogu and the Razor Crest and, well, here we are. This blog served as a way to unleash the infectious brainrot of Pedro back into the ecosystem, hopefully finding another victim. What I got back, is community. I've been in fandom for over ten years and I can honestly say I've never seen a fandom that is so kind, so supportive, so eager to share and talk and engage with others.
So, in the three months since this blog was created, you lovely people continue to show up and everyday I am gobsmacked at the growth and support. I genuinely don't know how I would have survived these last few months had I not met some of you, so as the (shoddily made) gif says: thank you.
I've just now wrapped up my 100 Followers Event Challenge (y'all sent me so many fantastic prompts I had SO much fun!). If you're interested, they're on my masterlist or you can find them all here on this post. I'm taking an itty bitty break from writing for just a bit (might be getting a new job too) but when i come back, i can't wait to share what comes next for all our pedro blorbos!)
Now that I'm a bit more settled and have had the chance to meet some of these fantastic creators, I'd love to share them out with you:
My Favorite Places to Make PPCU Friends (Discord Servers):
Pedro Pascal Cinematic Universe (I got invited by @jupiter-soups)
Space Sisters - give @psychedelic-ink a shout if you'd like to join!
My Favorite Compilations for Fics:
Favourite Fanfic Stories (managed by @morallyinept)
Sanctuary Database (managed by @pascalsanctuary)
Spreadsheet Digest (managed by @wannab-urs)
(these folks are also some of the nicest people you'll ever meet so please do yourself a favor and go follow them)
My Favorite Creators:
@perotovar is a next level gifmaker
@trulybetty has some of the best designs i've ever seen
@daddy-dins-girl has some of the best pedro character alignment charts -- it makes me laugh every time!
@iamdesibell has my entire heart and soul with all her fanart
@saradika keeps us fed with gorgeous moodboards and dividers
Fandom lives and dies by its community so please reblog, tag, or comment if you like a piece of fanart, fanfic, or anything else someone has created that vibes with you! If you'd like to rec something or someone, please let me know -- as you can see, i love holding up other writers and creators and i always wanna hear about your fave!
My ask box is always open for requests, questions, comments, or if you wanna just bitch about how your stupid old car failed you again, I wanna hear about that too 🤍thank you all for accepting me and my silly little stories!
74 notes
·
View notes
Text
hi anon <333 okay so uhhhh listen when i got this ask which i think was... a month ago? a couple months ago? i did not have a dick & tim reading guide
BUT i read this ask and i thought WOW WHAT A GOOD IDEA, a dick & tim reading guide, i wish i'd had one of those when i started reading!! and also i had a lot of work that i didn't want to do so i needed a project to procrastinate on dsfdsfs
so i have been working on a reading guide spreadsheet and it is ALMOST DONE so i will post it soon-ish. <3 if anyone wants to check out the unfinished version and tell me if it's readable dm me <3
also below i have rambled a lot about the makings of the spreadsheet if you also like spreadsheets a lot
this is only sort of tangentially related to the reading guide but it is the SECRET ORIGIN of the reading guide. i think many comic fans eventually end up with a spreadsheet story because comics are bonkers and difficult to keep track of, so either you sensibly engage with your hobby in a reasonable fashion or you slowly go bonkers yourself and end up with a spreadsheet story. this one is mine.
so a year or two ago, when i got first got deeply deeply obsessed with dick & tim, i was desperate for content and i wasn't able to find much on tumblr
so out of a combination of deep affection for the boys and also an extremely strong desire to procrastinate the things i was supposed to be doing, i went through dc.fandom's list of dick's appearances and of tim's appearances.
and i cross-referenced them all to find the comics they both appeared in, and then i started kinda randomly reading through those comics looking for good art/panels that they both appeared in and taking notes on whether they appeared in the same panel or not:
and then as i became even more obsessive i started adding in a bunch of their solo appearances so i'd know the context of their team-ups, and i started color-coding blue-for-nightwing, red-for-robin, purple-for-both-of-them:
and then i started trying to make lists of Significant Events so that i'd know e.g. when characters died or got married or broke up:
and then i got tired of having to search for dc.fandom pages every time i wanted to check something in a comic, so i started adding links to dc.fandom and to dc universe:
and then i thought, you know, it'd be nice to have comic titles and to know if it's part of an ongoing story:
and sometimes when i was reading, i started taking notes on quotes or whatever was going on:
and that's about when i got this ask, and i thought, you know, i really should make a reading guide.
and i started thinking, okay, is there any way to take my spreadsheet and make it slightly less convoluted and a bit more like a reading guide?
and the answer was, probably not!!! but that did not stop me from trying sdfdsfds
so right now i have a spreadsheet called "Dick & Tim Reading List" and it's got a section that looks like this which has about 200 recommended-read comics:
but ALSO there's a tab that's really really long that has all of dick's solo comics and also all of tim's solo comics (from 1987-2011, not of all time, but still):
and also you can just get a list of all (post-crisis) comics dick&tim have appeared in together:
and also as i was working on this i discovered FILTER VIEWS and simultaneously got curious about all the quotes in grayson 12, which taunted me with the possibility of getting post-crisis continuity back before not giving it to me >:(((((( but anyway they're still good quotes so i made a list of all of them
anyway then i looked at all of that and thought ehhhhh okay but that's very complicated!! maybe i need some shorter reading recommendations. so then i started making a list of those:
basically you should picture the spreadsheet journey like this puppy:
anyway i'm still kinda distracted but i do intend to clean it up a bit more and then post a link, so that will happen soon-ish hopefully <3
#ask tag#also when i was trying to save this post it gave me an error message saying there was a processing error#which is probably karmic punishment for not answering your ask sooner i am so sorry sdfsfsdfs#anyway if you are still interested in a reading list i am also interested in a reading list it will definitely probably happen#it's just that y'know the ball-leaf-ball-no-wait-a-LEAF excitement over here has been very intense
142 notes
·
View notes
Note
How do u make your yearly budget ? I remember you posting about your budget spreadsheet once. Pls I am v interested on how you set it up
I simply must ask if you're the FBI agent in my phone, because I genuinely just sent a message to a friend saying how excited I was it's the end of the month, meaning tomorrow I get to start with a fresh new slate in my budget hahaha
alright let's talk:
I don't do a yearly budget, technically! I budget month-per-month. There are lots of styles of budgets—some allowing for a yearly/more Long Term view—but what worked for my income level was a month-based system.
I lurked on r/personalfinance on reddit for a long while and actually pilfered my budget template from there!
I use this one, which I like both because I've used it for five years and because it's just plain ol' simple. I don't need charts to automatically populate and I don't want to categorize every purchase I make. I just want to see how much money I have per month and how much I'm spending.
That's also crucial to how I personally do budgeting. I don't set aside $X for food and $X for activities and $X for going out or whatever every month. That isn't productive to me; my life looks different every month depending on what's going on. I don't use my budget to be prescriptive; outside of my fixed expenses (rent, utilities, etc.) I just use my budget to track 1. where my money is going and 2. how much of it I have left.
If you want something with a bit more frills, there are lots of other options (one, two, three) on reddit, but I've [personally] found all their bells and whistles overwhelming. If they have useful features you want to use (like, some will have tabs for you to track debt and payments toward it), you can experiment with them, but I don't recommend them for someone new to budgeting.
...I also don't inherently recommend my preferred spreadsheet, either. It doesn't work for everyone. I've shown it to some friends and they almost immediately knew it wouldn't work for them. The reason it works for me is because I am kind of neurotic about budgeting.
To me, "peace of mind" is maintained by having a really close eye on my finances. That means that I track what I spend daily. I manually input every purchase into the spreadsheet. I manually put every paycheck into the spreadsheet. I keep the Google Sheets app on my phone for this very purpose.
That isn't something everyone's willing to do, and there's no shame in that—we all find the different tools that work best for us! But if you don't think you're able to keep up with manually tracking every cent you make and spend, I don't think that this method will be good for you.
If you need more automation in your budgeting, where you can get things autofilled and so on and so forth, I would have pointed you towards Mint, which I've heard good things about, but it's sadly shutting down this March. The article I linked provided an alternate recommendation, but I can't personally vouch for any of those services.
I've been tempted by YNAB a time or two — I like the idea that they intentionally work you towards living off of old paychecks instead of the money you earn month-of [which is a financial goal we should ALL strive for, even though it can be very hard], and I like that they encourage giving every dollar a "job", but you don't NEED their service to do either of those things. I don't like paying money to save money, you know? lol
I keep a secondary, simple spreadsheet with my "rolling funds" in it — money I set aside every month (which I input as a monthly "expense" in my normal spreadsheet) which I allocate to specific funds, like car funds, travel funds... I even had a "hockey game fund" for a few years, haha.
I prefer that method to paying for a service to do it for me. I'm sure YNAB has some nice bells and whistles, and it's clear MANY people love being integrated into their system, which has some automated bits that definitely make budgeting "easier," but I like Ye Olde Spreadsheet. Having to input every purchase keeps me accountable, I feel. Also it sometimes discourages me from spending money, haha, which is probably a good thing in the long run.
idk. I'm a huge advocate for budgeting. I know it can be really hard for some people, but I sincerely think there's some budgeting method out there that will work for you, you know? I credit my budget spreadsheets for keeping my head above water during the many times where money was/is tight. Knowledge is power and all that.
Not to sound like a #girlboss shilling my financial advice on tiktok (of which there are too many), but being aware of where your money is going is sincerely the biggest, most important step you can take towards building financial safety for yourself. My budget saved my ass this last year.
If you have any other questions, shoot them my way. I know it can seem daunting, but I totally think it's worth it! <3
27 notes
·
View notes
Text
Hate of all kind will be deleted, antisemitism and islamophobia are not tolerated here
Written on 2/14/24
I do not normally post "political" content. Political being in quotations because I do not consider this a political issue but the world does.
The genocide of the people in Gaza has been going on for 130 days (+75 years). It is estimated that 20,000+ Palestinian civilians have been killed with presumed thousands unaccounted for buried under the rubble.
This is collective punishment and it is a war crime. Collective punishment is a war crime.
I waited so long to speak on this here because I wasn't really sure how to. Before Oct 7th, had no clue of what was happening between Israel and Palestine through every fault of my own. I have been reposting from creators on other social media platforms but I was unsure how to do so here.
That being said, this is my most followed platform by hundreds of people. I will continue to post my usual content, but you will also more than likely be seeing more of this.
People To Follow:
All of these are on Instagram but many (such as Bisan, Mansour, Hind, Motaz, and Plestia) have accounts on FB, TikTok, and Twitter.
@ dr.haya.gaza
@ hindkhoudary
@ alijadallah66
@ byplestia
@ saleh_aljafarawi
@ dr.ghassan.as
@ wizard_bisan1
@ motaz_azaiza
@ hatem.h.rawaghone01
@ lama_jamous9 (the youngest journalist in Gaza, a 9 year old girl)
@ wael_eldahdouh
@ dahman.eyad
@ nouralsaqa
@ youmna_elsid
@ alhelou.y
@ chalanhamza
@ mansourshouman7
If you have other people to follow please let me know, these are just the people I could think of at the moment who I am following. There are I'm sure hundreds more that I'm unaware of and would love to know them.
For boycotts:
BDS Movement Official Website
"BDS aims to end international support for Israeli violations of international law by forcing companies, institutions and governments to change their policies. As Israeli companies and institutions become isolated, Israel will find it more difficult to oppress Palestinians." - BDS website
Another company to boycott is Starbucks, they are not on the BDS list but a grassroots boycott has been started. This is because the company filed a lawsuit against a union of Starbucks workers who posted pro-Palestinian content. They are also very well known for mistreating their employees so it's really worth not going for multiple reasons. Support local coffee shops, they taste better and cost less money :)
I would like to finish this off by saying again that hate of any kind is not tolerated on my platform, it will be deleted and you will be blocked.
Operation Olive Branch
They are an account on TikTok who has created a spreadsheet with the GoFundMe's of Palestinian trying to leave Gaza. On the spreadsheet you can see how much progress the family has made with their fundraising, why they need help, and can allow you to connect with that family or their representative via their social media. You can find Operation Olive Branch on TikTok with the handle @ operationolivebranch or on IG with the same handle. (Forgive my poor explanation, there's a lot more too it that is better explained on their page.)
22 notes
·
View notes
Text
How I would do 2023 ship stats
You know, normally, I don't bother to do much with top AO3 ships stats. That's partly because someone already does it and partly because I think they're stupid stats that just lead to people gloating about their blorbos "winning". But I do routinely have a look at what's new and popular when I'm doing things like making a dance party playlist for Escapade Con, just so I know what fans might be getting into lately. I have to say, collecting these is not hard. It's not even particularly time consuming.
Doing it super efficiently would be easier with a script, yes, but most fandom stats aren't actually collected with scripts, and if you're only looking for the top 100 ships, you can more or less do that by hand.
How I would set about it for you, the random fan who's curious but not curious enough to learn to code, would be to log into AO3 and then find tags where you can see the sidebar. They should be tags that encompass the whole archive and that are mandatory and unique… in other words, ratings.
Since every AO3 work must have one and only one rating, you can just check these five and get a good sense of what's on there. There are some minor wrinkles to iron out, but it's a good preliminary research step.
The way you want to do it is to start with a spreadsheet. Open up your ratings URLs (and also paste them in the spreadsheet for convenience—google sheets will make clickable links). Copy all the sidebar top ships into a list. Filter out all of these ships. Copy the next set, etc. After a while, you'll have a good list that's longer than 100 ships but that most likely contains everything really popular. (Filter for things posted/updated/whatever in the past year if that's the data you're after. Filter for f/f or whatever topic you're interested in if that's the question you're asking instead.)
Use your spreadsheet to generate the actual links for each of these ships. AO3 URLs are predictable: you can generate them from knowing the exact spelling of the tag and the normal format of this type of URL. (There are a bunch of standard spreadsheet functions that can be used to get rid of the work count numbers you've copied from AO3 to get just the pure ship tags. I'd use things like =right() and =left().)
Open the links. Copy the work totals back to your spreadsheet. Voilà!
One drawback of this method is, obviously, that it's boring and tedious, but if you didn't like boring and tedious, why were you collecting fandom stats anyway?
A more important drawback is that in using exclude filters, it's possible you could miss a ship. If the posting patterns are just right, there might be something that has its numbers reduced by excluding other ships that should be on your list. You could have a similar issue if the ships on your list are mostly one rating (so higher in those searches) and some other slightly larger overall ship is spread more evenly. I would try to ameliorate this problem by looking at the sizes of the smallest ships you're covering. They will likely be bigger than the entire fandom section for most fandoms. Taking another look at the bigger fandoms that could be hiding a small-end-of-big ship can help double-check that you haven't missed anything. Grabbing the top 130 or 150 ships in some search while only looking for the top 100 will likely find most of the edge stuff too.
Add any ships that look like they should be double checked to your spreadsheet. Add their work totals. Re-sort your list.
Another thing to consider is that AO3 keeps track of the most recent update date on fics. That's what's easy to search by. If you're only interested in when a work was first posted, easy manual filtering isn't the way to go… However, if the objective is to see which ship tags were active in a given year, most recent update date is the relevant piece of data anyway.
You're not going to recreate centreoftheselights' exact analysis unless you collect data year to year, but you can come up with something pretty similar that answers a similar question, and you don't need to be a programmer to do it.
In the end, accept that some data require hard collection methods that a site doesn't easily offer you and you might have to scrape multiple times a year with a script if you want to know that particular thing… or you might have to randomly sample and hand-count as with FFN shipping stats. (Yes, I've done it. It can be done. It's just annoying.)
So when you're setting out to look at some stats question, the big first step is to decide what you're even asking and why and whether you're just wimping out and going with what's easy to collect instead of what you actually want to know.
...now I'm kind of curious. Maybe I'll go pull some 2023 numbers.
41 notes
·
View notes
Last Seen Blogs
togata87
Small World Hockey
mediumhope221
The Best Free Software
caven1259
Caven
megaelectronicanchorstudent-blog
Untitled
sspaceway
Spaceway♥︎