hell yeah, every time i even think abt tackling a long show or franchise it's time to cross reference every website under the sun to make the most comprehensive spreadsheet imaginable
My Doctor Who spreadsheet lists, from left to right... The Doctor's number -useful for sorting the rows how I want Classic -this get ticked if it's a classical Doctor Who episode... Episodes -how many episodes in the serial... only filled in for classic Who Last Played -the date I last watched it /10 -an attempt at rating it out of 10 with increments of 0.5... this is a score that tries not to be too subject to changes in opinion based on my last watch, so each time I watch, I'm only allowed to change this by 1. Episode -Each episode is numbered based on season and place in season... The Rescue is 0.023 (Classic stories are below zero, so 0.02 means Season 2, and the 2 on the end of that denotes its place in the season... Survival is 0.264, Spyfall Part 1 is 12.01, etc. This is an easy way for episodes to be sorted chronologically, which is how I usually have them sorted unless I'm analysing the data. Title -Self explanatory. I rename An Unearthly Child to The Tribe, and The Daleks to The Survivors... also in a separate app I rank every televised story based entirely on my experience watching it in my most recent watch of it, and if an episode gets into the top 10, it permanently gets a number at the end of the title saying how high it reached at its highest ever point. Plays -This is how many times I've chosen to watch something not out of obligation due to a watchthrough. If I start watching a story, I cannot abandon it unless it's very early on, or very late on, so that each watching can count as 1 each. Watchthrough -This is watchings of the story done because of a watchthrough. Tier -In my aforementioned recent ranking based on my most recent watch of an episode (done in a separate app), which tier did it end up in? Tiers are S, A, B, C, D and F. F is defined as a story I overall did not enjoy. It's the smallest of the tiers lol. Boom got put there yesterday. Fuck Boom, it sucks so bad. Tiers -This lists the highest and lowest tiers the story has been in. For example, The Mind Robber has S-F, whereas Timelash has S-A. Ah -In increments of 1, the story is rated between 0 and 10 how scary it is. Ha -In increments of 1, the story is rated between 0 and 10 how funny it is. No -In increments of 1, the story is rated between 0 and 10 how much I hate my most hated part of the episode. Yes -In increments of 1, the story is rated between 0 and 10 how much I love my most loved part of the episode. Cry -This says if I cried and how much I cried. I leave it blank if I didn't make me cry, and then the scale goes something like: nearly, Nearly, NEARLY, wet, Wet, WET, yes (tear has to travel away from eye to achieve yes), Yes, YES. Emo -This is my newest category and I haven't fully worked out what I mean by it, but it's basically about emotional investment... coz some episodes hit me intensely in ways that aren't entirely related to crying, and I want to recognise them. I'm still feeling my way around this tbh, and idk exactly what I mean by it. Maybe it'll evolve into something else. Past Tiers -Every time an episode gets ranked, I list which tier it was in. 73 Yards is ASS, lol. I only recently started doing this and I'm so so glad I came up with this coz it's a fair representation of how I feel about a story over time. Year -Year of broadcast Writers -The writer/s Showrunner -showrunner or classic equivalent. Director -The Director Notes -Random notes on an episode. If an episode ever gets No.1 in the rankings, it gets a note saying 'Has been no.1 ep.' It's also useful for noting where a watchthrough with a friend is at. Blink got an F one time, and my note for that is 'lol F'. If a story became my no.1 classic story, I make a note of that - in my first Classic watchthrough, Timelash became the first no.1 classic story lol. Ghostlight's note is 'Control is a trans icon.' These are the categories on the spreadsheet on my phone. On my PC, I transpose all that data, and also add in the data from the episodes being ranked, and it gives each episode a number based on where in the ranking they are, in addition to recording the highest and lowest they have ever ranked which i can tell by which row they are on. There's a bunch of other non spreadsheet notes I have, and rankings of stuff. I realised that young Lucy enjoyed ranking stuff a bunch, so I figured that she had tapped into autistic joy for it in a way that had since been clouded by age. -I recently made a ranking of every story without regard for the latest watch - attempting to right wrongs like The Mind Robber being listed as an F tier based on my latest watch when I know in my heart it's an S tier. -I numerically calculate the ranking of Seasons and Doctors based on which tier they are in based on my most recent watch. Each tier is assigned a number (S=1, A=2, B=3, C=4, D=5, F=7 coz to be in F is very bad), and an average for each story in a season/era is calculated and then they are ranked that way. -I rank so many things based on my feelings... companions, Doctors and so so much more.
It hurts how much I relate to this
hell yeah, every time i even think abt tackling a long show or franchise it's time to cross reference every website under the sun to make the most comprehensive spreadsheet imaginable
HELL YEAH SPREADSHEETS
My Doctor Who spreadsheet lists, from left to right...
The Doctor's number
-useful for sorting the rows how I want
Classic
-this get ticked if it's a classical Doctor Who episode...
Episodes
-how many episodes in the serial... only filled in for classic Who
Last Played
-the date I last watched it
/10
-an attempt at rating it out of 10 with increments of 0.5... this is a score that tries not to be too subject to changes in opinion based on my last watch, so each time I watch, I'm only allowed to change this by 1.
Episode
-Each episode is numbered based on season and place in season... The Rescue is 0.023 (Classic stories are below zero, so 0.02 means Season 2, and the 2 on the end of that denotes its place in the season... Survival is 0.264, Spyfall Part 1 is 12.01, etc. This is an easy way for episodes to be sorted chronologically, which is how I usually have them sorted unless I'm analysing the data.
Title
-Self explanatory. I rename An Unearthly Child to The Tribe, and The Daleks to The Survivors... also in a separate app I rank every televised story based entirely on my experience watching it in my most recent watch of it, and if an episode gets into the top 10, it permanently gets a number at the end of the title saying how high it reached at its highest ever point.
Plays
-This is how many times I've chosen to watch something not out of obligation due to a watchthrough. If I start watching a story, I cannot abandon it unless it's very early on, or very late on, so that each watching can count as 1 each.
Watchthrough
-This is watchings of the story done because of a watchthrough.
Tier
-In my aforementioned recent ranking based on my most recent watch of an episode (done in a separate app), which tier did it end up in? Tiers are S, A, B, C, D and F. F is defined as a story I overall did not enjoy. It's the smallest of the tiers lol. Boom got put there yesterday. Fuck Boom, it sucks so bad.
Tiers
-This lists the highest and lowest tiers the story has been in. For example, The Mind Robber has S-F, whereas Timelash has S-A.
Ah
-In increments of 1, the story is rated between 0 and 10 how scary it is.
Ha
-In increments of 1, the story is rated between 0 and 10 how funny it is.
No
-In increments of 1, the story is rated between 0 and 10 how much I hate my most hated part of the episode.
Yes
-In increments of 1, the story is rated between 0 and 10 how much I love my most loved part of the episode.
Cry
-This says if I cried and how much I cried. I leave it blank if I didn't make me cry, and then the scale goes something like: nearly, Nearly, NEARLY, wet, Wet, WET, yes (tear has to travel away from eye to achieve yes), Yes, YES.
Emo
-This is my newest category and I haven't fully worked out what I mean by it, but it's basically about emotional investment... coz some episodes hit me intensely in ways that aren't entirely related to crying, and I want to recognise them. I'm still feeling my way around this tbh, and idk exactly what I mean by it. Maybe it'll evolve into something else.
Past Tiers
-Every time an episode gets ranked, I list which tier it was in. 73 Yards is ASS, lol. I only recently started doing this and I'm so so glad I came up with this coz it's a fair representation of how I feel about a story over time.
Year
-Year of broadcast
Writers
-The writer/s
Showrunner
-showrunner or classic equivalent.
Director
-The Director
Notes
-Random notes on an episode. If an episode ever gets No.1 in the rankings, it gets a note saying 'Has been no.1 ep.' It's also useful for noting where a watchthrough with a friend is at. Blink got an F one time, and my note for that is 'lol F'. If a story became my no.1 classic story, I make a note of that - in my first Classic watchthrough, Timelash became the first no.1 classic story lol. Ghostlight's note is 'Control is a trans icon.'
These are the categories on the spreadsheet on my phone. On my PC, I transpose all that data, and also add in the data from the episodes being ranked, and it gives each episode a number based on where in the ranking they are, in addition to recording the highest and lowest they have ever ranked which i can tell by which row they are on.
There's a bunch of other non spreadsheet notes I have, and rankings of stuff. I realised that young Lucy enjoyed ranking stuff a bunch, so I figured that she had tapped into autistic joy for it in a way that had since been clouded by age.
-I recently made a ranking of every story without regard for the latest watch - attempting to right wrongs like The Mind Robber being listed as an F tier based on my latest watch when I know in my heart it's an S tier.
-I numerically calculate the ranking of Seasons and Doctors based on which tier they are in based on my most recent watch. Each tier is assigned a number (S=1, A=2, B=3, C=4, D=5, F=7 coz to be in F is very bad), and an average for each story in a season/era is calculated and then they are ranked that way.
-I rank so many things based on my feelings... companions, Doctors and so so much more.
You love spreadsheets, I love lists 😂
Yes, but it's much less common.
(Source: me, a neurodivergent person who loves spreadsheet)
Only place I get a =MATCH()
(Thought this was about watching the new series at midnight at first)
same lol
I feel so seen rn as someone with the dr who spreadsheet tism
The Third Doctor pfp is really tying this comment together
That's good! Next you should score them all to five decimal places, rank them from worst to best and make a series of videos explaining your scores.
Oh there's a page on this spreadsheet dedicated to that too for sure. Only to two decimal places, but effective nonetheless
I'm in the picture, and I probably shouldn't like it, but I don't mind.
Michael, love this, enjoy your day mate. No matter what insecurities you encounter, you're loved.