Looks like today is going to be a day of “Cool Sites” posts :). Here is a site maintained by Daniel Petri containing all sorts of MSFT articles. Daniel writes a lot of articles about issues that admins run into on a daily basis and he has some great practicle advice. Highly recommend visiting it regulary.
November 9, 2005
2005 Half Marathon
It’s been a while since I updated the site :). Wanted to give some updates on my running accomplishments for 2005. After finishing last years Lasalle Marathon, I thought that I could train on my own this year. BIG MISTAKE!! :). Unless you are really (and I mean REALLY) motivated, it is very difficult to train alone for a marathon. So my training was pretty bad this year. I did manage to finish the marathon though. Only 30 minutes longer than last year :).
Here is a picture from the 2005 Chicago Half Marathon, I ran as part of my training
Excel : Import tables from web pages
Ran into a bit of a tough nut the other day. One of my colleagues was trying to gather data from a HTML page and run some reports. He could scrape the page and copy the data into Excel, but any operations he tried on the data errored out. He tried every trick in the book (change format of columns etc) but it didn’t help.
A bit of googling and found this new cool function in Excel 2003.
Go to “Data –> Import External Data –> New Web Query” in Excel and you check on this new cool method.
“F1” in Excel rules :)..