Posted by Amy with 196 Comments
I have something very different to share this morning. Since the season ended, I’ve had some time on my hands…well really I’ve been staying up past 1am a lot…and have created a One Tree Hill History spreadsheet.
I found myself wanting to get a good picture of the relationships in the show over time. Just to see what they went through and when but it is so tough wading through pages and pages of episode summaries. I needed a one-page guide. I also am always wanting to refer back to a point in an old episode and I just can’t recall the episode number. This spreadsheet sort of evolved into some sort of all-encompassing OTH history.
Let me give you a little tour. Here is a small screen cap of the file.
Down the left side are all the couples from all the seasons (I have NH, BL, LP highlighted). Across the top are all the seasons with each episode listed individually. What I’ve done for each is try to note where people were talking and/or interested in one another (denoted in blue), where people “hooked up” (could be just a kiss) (denoted in pink) and where they were considered exclusively dating or married.
If you notice the red triangle in several of the boxes, those are comments that you can mouse over and get a notation of any notes of interest for that couple and that episode. You might notice there are comments even if those two people weren’t necessarily interested in one another at all. I was trying to show the couple’s history even if their relationship wasn’t “active” at the moment.
And finally on the bottom of each episode, I’ve tried to create a summary for the episode. For example, there are certain episodes you can pinpoint in just a few words…like Dare Night. That’s what I’ve tried to put at the bottom. There were some episodes that just couldn’t be summarized like that so I left them out. I’ve also created a separate sheet in the spreadsheet that just has the episode summaries that can be printed out separately.
Now…it is not complete…I didn’t include Deb/Dan in the couples and I didn’t do a great job of capturing every single “hookup” and moment. Also, there were some “couples” like Mouth and Rachel I didn’t do a great job of notating throughout the seasons. There may be other episodes that could be summarized. If you’d like to add something, email me at amy AT onetreehillblog.com and I’ll try to update the main copy.
The other thing is I know Excel might not be a great format for everyone. I can try to put it into html but it won’t have the comments and episode summaries. Let me know if anyone is still interested in that and I can try to put it together.
And one more note, I have it currently set up to print on one Letter size paper. A legal size would be much better. And only choose to print 1 page because all the comments will print on about 15 pages after that if you don’t!
So, there it is…for everyone to enjoy. And please don’t tell me if someone else has already done this, I’ll start hitting my head against the wall And of course, please give credit where credit is due if you share this. I did put a link to our site at the top of the spreadsheet so if nothing else, please keep that in there.
I have the file on sendspace for now. If anyone has any suggestions on where to put it, let me know. Also, feel free to email me for it if the link doesn’t work and I can send it to you.
Wow, this got really long! Enjoy!
This entry was posted on Tuesday, June 3rd, 2008 at 9:33 am and is filed under One Tree Hill. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.