PROJECT: Episode Information Table

The place for general chat about the television series and its characters, from the ABC years through to The New Avengers.
Post Reply
User avatar
Allard
The Ministry
Posts: 2291
Joined: Mon Sep 01, 2008 2:10 pm
Location: The Netherlands
Has thanked: 184 times
Been thanked: 78 times

PROJECT: Episode Information Table

Post by Allard »

Something which I have been contemplating for some time now is making a comprehensive Avengers Episode Information Table, based on my personal episodes list where I (used to record which episodes I owned on home video) and when I watched them.


The idea is to create a crowd sourced (and checked) table among Avengers fans.
The main spreadsheet (pictured) would have transmission order, production order, director, writers.
The second spreadsheet is the episodes in alphabetical order (already finished)
The third would be a listing by episode of all home video releases.


Any thoughts on what is missing and whether you would like to help.


Image

p.s. I am not going to include actors, too much date to show with any surveyability, too laborious and pointless to since there is IMBD, but if anyone would want to make this they are welcome.
Top
User avatar
Allard
The Ministry
Posts: 2291
Joined: Mon Sep 01, 2008 2:10 pm
Location: The Netherlands
Has thanked: 184 times
Been thanked: 78 times

Post by Allard »

At the start of this, I don't know where this is going, but I'd love to expand this into more documents that can be easily stored and spread. There is so much information online (this forum and websites) and data online has a tendency to get lost over time.
Top
User avatar
dissolute
The Ministry
Posts: 3119
Joined: Thu Sep 04, 2008 10:03 pm
Location: Sydney, Australia
Has thanked: 196 times
Been thanked: 209 times
Contact:
Contact dissolute

Post by dissolute »

I have a spreadsheet of some of the same information, I'll upload it.
Mrs Peel, you're needed!
http://www.dissolute.com.au/the-avengers-tv-series/
Every episode from 1961 to 1977 plus more trivia than you can shake a brolly at.
Top
User avatar
Allard
The Ministry
Posts: 2291
Joined: Mon Sep 01, 2008 2:10 pm
Location: The Netherlands
Has thanked: 184 times
Been thanked: 78 times

Post by Allard »

dissolute wrote:I have a spreadsheet of some of the same information, I'll upload it.
should have guessed....
Top
User avatar
Allard
The Ministry
Posts: 2291
Joined: Mon Sep 01, 2008 2:10 pm
Location: The Netherlands
Has thanked: 184 times
Been thanked: 78 times

Post by Allard »

https://ufile.io/bjnjkwl9

here is my alphabetical list, remove the top and right column to make it sortable.

This one is unchecked, any suggestions for improvements are welcome.
Top
User avatar
Allard
The Ministry
Posts: 2291
Joined: Mon Sep 01, 2008 2:10 pm
Location: The Netherlands
Has thanked: 184 times
Been thanked: 78 times

Post by Allard »

Image

I have made a start of the home video release spreadsheet so that I can decide on a layout. Based on this example I'd welcome any hints or suggestions to improve this before doing the work of adding all the data.
Top
mousemeat
They Keep Posting about Steed
Posts: 7119
Joined: Thu Sep 04, 2008 11:26 am
Location: Elvis Central, U.S.A.
Has thanked: 96 times
Been thanked: 100 times

Post by mousemeat »

Allard wrote:Image

I have made a start of the home video release spreadsheet so that I can decide on a layout. Based on this example I'd welcome any hints or suggestions to improve this before doing the work of adding all the data.

looks great....and there's a wealth of info..to be posted...So far, I like the lay out...in tracking releases etc
Top
User avatar
dissolute
The Ministry
Posts: 3119
Joined: Thu Sep 04, 2008 10:03 pm
Location: Sydney, Australia
Has thanked: 196 times
Been thanked: 209 times
Contact:
Contact dissolute

Post by dissolute »

I've forgotten which thread I originally posted my spreadsheet but here is just as good a location to announce that I've updated it with all the research I've been collating for the last 2 years...

It's a bit messy and the colour coding only means anything to me... if indeed it still does at all...

Please enjoy:

https://www.dissolute.com.au/the-avenge ... dates.xlsx
Mrs Peel, you're needed!
http://www.dissolute.com.au/the-avengers-tv-series/
Every episode from 1961 to 1977 plus more trivia than you can shake a brolly at.
Top
User avatar
Frankymole
You Have Just Been Posting (a lot)
Posts: 6568
Joined: Mon Sep 01, 2008 9:33 am
Location: Carmadoc Research Establishment
Has thanked: 345 times
Been thanked: 270 times

Post by Frankymole »

I'm a sucker for a colour-coded spreadsheet! Must be an occupational hazard. I have spreadsheets for chronology research for everything from The Avengers to Sherlock Holmes, Blakes 7 and Doctor Who. (Though I did the Prisoner and Robin of Sherwood on bits of paper and in Word!). Also one that converts star positions to galactic coordinates for a 3D star map I was drawing. Wonder why I'm an accountant!!!

It doesn't open in Excel for me, is it possible to put it on Google Drive?
Last watched: "The Outside-In Man"
Top
mousemeat
They Keep Posting about Steed
Posts: 7119
Joined: Thu Sep 04, 2008 11:26 am
Location: Elvis Central, U.S.A.
Has thanked: 96 times
Been thanked: 100 times

Post by mousemeat »

dissolute wrote:I've forgotten which thread I originally posted my spreadsheet but here is just as good a location to announce that I've updated it with all the research I've been collating for the last 2 years...

It's a bit messy and the colour coding only means anything to me... if indeed it still does at all...

Please enjoy:

https://www.dissolute.com.au/the-avenge ... dates.xlsx
nice....great work.....mind boggling good...thanks for your devotion
Top
Post Reply

Return to “The Avengers on Television”