First, I love all your reviews and recommendations but now my list of watched shows is getting too long and I need to organise them. Can you please give me more information on how you set up your spreadsheet. I have name, country, year, number of episodes, run time, my rating, what else should I include? Please help me organise this BL list nightmare.
OMG you're so cute. And I am SO SORRY.Ā
The spreadsheet of doom has columns for the following:
code - thatās a short search code for me personally so I can find screen caps stored on my hd, but also the one you see @heretherebedork and I (in particular) using as shorthand when we chat, e.g. UWMA & FUTS.
MDLĀ - whether the show is on My Drama List or not (Y, N, na, and R) na = Vietnam & Cambodia, R = I reviewed it. (I also use MDL as a kind of back up and because I track all the other Asian dramas I watch there, although I donāt rate the het stuff) - you probubly donāt need this one if you donāt watch VBL or use MDL. Iām considering deleting this column since itās redundant.Ā
year - generally the year the show is given on MDL (release year, rather than completed year), which conflicts with when I post and talk about shows - i.e. Bad Buddy I consider a 2022 show (when it ended), MDL lists it as 2021 (when it started)Ā
titleĀ - generally the one we talk about it here (as opposed to whatever MDL or Viki decides on)
subtitle (or alternate title) - the other oneĀ
origin - who produced it, I pick the dominant language for those co-produced, so Korea got Peach of Time, Taiwan got Because of You, Thailand got Present PerfectĀ (there are so few of these I keep track of them in a post rather then on the spreadsheet)Ā
rating - in my case, out of 10, i dislike an out of 5 rating system
apx hrs - so this is my best guess at the finished hour total FRESH content for each series, since (for me) length of treatment is important to track when answering wave data and exponential growth questionsĀ
length - this is the column needed to calculate the previous one, so itās: number of episodes X length of episode - average % of credits/recaps/stingers sponsors (usually around 22%)Ā Ā
main trope - so like the major romance trope foundation of the story, enemies to lovers etc...Ā
sub trope - cohabitation, paranormal, etc...Ā
setting - home, office, r&b (restaurant & beverage), university, high school, historicalĀ
pair tone - pining, crush, soft, hard, etc...Ā
main pair - grumpy/sunshine, sunshine/tsundere etc... AKA archetypes in playĀ
couple - the names of the two lead charactersĀ
sub paring - side dishesĀ
sub pairing couple - names of the side dishesĀ
kiss - the side coupleās ratingĀ
source - which platform is hosting the show
link - to that show at itās current source (that I know of)Ā
MDL - a link to the show on My Drama ListĀ
R - whether I personally have digital hard copy or not, and whether I want toĀ
trigger - any notes I have about traumatic elementsĀ
pitch - my short paragraph summation, if I wrote oneĀ
review link - a link to my review on tumblrĀ
more - anything I donāt have a column forĀ
Things I wish I included from the start!
DATE I FINISHED WATCHING IT - because I didn't track this I failed to track my own taste and journey through the genre (MDL tracks this for me, now, but I didnāt have an MDL account at the start)Ā
actor couple/ship name - like OffGun etc... only recently has become necessary since prior to this they had maxed out at 3Ā
language or caption/translation notes/links etc... - this would mostly be for the Thai stuff for me, but like thereās a great convo about the language used in DNA on one of my blog posts right now and I wish I had a place to store that infoĀ
directors - specifically because of Vietnamese BL, otherwise MDL mostly tracks this so not necessarily except for sorting reasonsĀ
native language title - as in, in the script of the country of origin, or in the case of Japan YET ANOTHER title (I could also use this column to track things like MAMEverse, or Japanās linked movies) - again MDL has this infoĀ
adaptation - if it was from a manga, manwha, or y-novel and who wrote it - MDL has this info thoĀ
OTS - not me, but you might want to consider this since itās a popular topic, if you happen to be into the audio side of BL tracking the MV of the theme songs might be usefulĀ Ā
Production house/studio - used to be there were so few it didnāt matter what their records was, now it doesĀ
My memory is SO SO bad yaāll. Now the spreadsheet acts as a brain back up devise too.Ā
blue for ones I am going to try to get hold of hc,
red for ones in progress (currently airing),
grey for short works (anything thatās fh total is under 45min).
pink for ones I just can not find
So my spreadsheet was designed originally for tracking wave data, hence my prioritized intersted in calculating length and run times of fresh content, then I evolved it to be a review tracking system. But that wasnāt how it started. So itās messier and less comprehensive than Iād like for its current use. (But honestly, thatās the nature of ALL long running data sets.)Ā
But at 400+ is now too large for me to modify from memory, and 80% of BL I never want to watch again, so it takes a lot to add a new column now.Ā
I also have a tab where I track my rating system.Ā
And a tab where I track my tumblr posts and reviews and such. I started doing that because I am terrible at tagging (and tumblr keeps shadow banning tags and I can never remember which ones areĀ āsafeā) so I just could never find anything in my own blog. I needed to do this because people would ask the same question here.Ā
Speaking of which, Iāve actually answered this question before. But I didnāt track it, to my shame.Ā
at the bottom of a post it means I am tracking that post for reuse/update.Ā
Other tabs that might have been useful
A tracking tab for announced/never made BLs with notes and sources of information. Or for theĀ ācoming next yearā BLs.Ā
Currently I keep this info as part of my big end of year summation post as a draft here on this platform, but Iām petrified Tumblr will delete that or otherwise crash. Itās a MONSTER post while itās in progress.Ā