Probably worth having a thread in the Off Topic section anyway, so more people see it and can discuss their Olympic adventures.
I live here, but am too just going to try and soak up the atmosphere as much as possible. Only have tickets for Russia Vs Latvia.
Some links:
http://www.livecityvancouver.ca/
FREE! great concerts, big screens to watch ceremonies etc. These 2 spots will likely be great for just hanging out and enjoying being out at the games.
http://www.vancouver2010.com/olympic-schedule-results/
Schedule of sports events and results
http://yougottabehere.ca/
Info on other non sports things going on like the zip-trek downtown