Question Full timeline and chronological order

At long last, I have put together a first draft of the full canon timeline and chronological order of all currently published stories. It's in OpenOffice spreadsheet format. There are mistakes, things I have gotten wrong, and things I didn't find enough information to nail down. Please tell me if you find anything that needs to be fixed, things I know need to be fixed are noted by question marks. If you do respond to correct an error, please also tell me which story has the information and give me an idea of where it is so I can confirm. Keep in mind that some stories may contradict each other, especially where days of the week are mentioned it seems.

Also as a bit of a pre-emptive 'just in case', should you discover these story contradictions keep in mind the etiquette policy. These things happen occasionally and are not a big deal. whateleyacademy.net/index.php/forum/the-...olicy-and-ettiquette

That's really cool... Thanks.

That was a pile of work! I would suggest on mine I locked the upper row of dates using the Window Freeze command so that it scrolls with the user. Still trying to figure out how to do the same the story title column.

But great job!

It would be better if you'd saved it in a format that was generally readable, however.
We arent all running open office or office 365

I tried exporting to Excel and it told me that there were too many rows and not all would be saved so I decided not to screw around with it. C'est la vie.

Astrodragon wrote: It would be better if you'd saved it in a format that was generally readable, however.
We arent all running open office or office 365

For spreadsheet-organized data, you're kidding yourself if you think there's a generally readable format for all software. CSV text, and HTML/XML come close, but you can count on losing any non-text formatting.

However, when someone does need a data set transmitted in a different file format they're normally able to name the non-proprietary formats that their software can import.

Updated version in xls format. Is anyone at all finding this useful? Also, I'm considering adding the WhatIF stories, would that be something anyone wants to see in the future?

Yes, this is very useful. Thank you for the work.

If you do do non-canon works, I suggest putting them on a second sheet, to avoid confusion.

I was considering putting them on the same sheet, but highlighting their rows in some color.

Is this Apache Open Office, or is it the older Open Office?

Neither, I think. It seems to me to be a .xls file, that is, an old-style (pre-2007) Microsoft Excel format.

As for the various OpenOffice/LibreOffice, I don't think the file formats have changed significantly in a long time, and anyway the newer versions should still be able to open the old ones. OpenOffice has been using OpenDocument files (.ods for spreadsheets) since version 2.0, back in 2005. OpenOffice 1.x spreadsheets used the .sxc file extension.