Posts Tagged ‘Ethnic’

Albuquerque Historical Timeline – Spreadsheet Now On-Line

Sunday, August 23rd, 2009

For over three years folks have asked if I could put the original Albuquerque Historical Timeline spreadsheet on-line, and I believe I found a solution.

There are a few caveats.

1. With all large spreadsheets, and this one is 96 pages large, it’s impossible to have everything appear on one screen and still have the font size readable. That means you will have to scroll left/right through time, and up/down through geography and ethnic/cultural events. It took me a while to get used to all the scrolling when building the spreadsheet, but there wasn’t any good alternative. There have been many suggestions and ideas about interactive, hyperlinked formats, but none have panned out as yet.

2. You will need to zoom in to the spreadsheet 3-4-5 times until you can comfortably read the text. When I do that, the text at the top of the page kind of ‘disappears,’ but using the up-down scroll bar can bring it back into view quickly.

3. I believe the spreadsheet is ‘read only’ protected, so information can’t be added or changed, which may well be a source of some consternation to revisionist-oriented historians.  It is possible, however, to copy and paste from the timeline cells. The timeline is copyrighted with the U.S. Copyright Office (VAu674-484) so thanks in advance for asking permission via a comment before you copy/paste any content from the timeline.

4. In the original Excel spreadsheet on my hard-drive, all of the dates neatly lined up at the left of each cell for ease of reading (and yes, lining up 740+ dated events in 341 separate cells was a goodly chore). Uploading caused some events to shift within the cell so their dates follow the text of previous events rather than lining up neatly on the left on their own separate line. Tweaking that may take place at some future time when (a) I can take the time to figure out how to do that, and (b) I have the time to really dive in and actually clean each of them up.

So, with that as preface, I heartily invite you to click this link to browse: The Albuquerque History and Cultural Timeline. I would enjoy hearing your thoughts in a comment to this post.