Calvin and Hobbes animated

A Calvin and Hobbes cartoon, drawn by Dadomani. Comments kasi 28 May 2007 1:31 pm: Hi Anand, U must check this http://david-heron.me.uk/blog/2007/04/08/virtual-barbershop with ur headphone vol high.. wid 3d music, its really kewl :) n chk the more links given there Docsound 29 May 2009 8:45 pm: Calvin and Hobbes cartoon is not drawned by dadomani!

Dilbert Browser

Al Donovan has created a Dilbert repository by crawling United Media’s site every day since 1996. I’ve made them a little easier to navigate. Click here to see the Dilbert Browser. Use the left and right arrow keys to see the next comic. Comments anonymous 22 May 2007 11:26 am: Awesome. How did you do this? Amit 17 Dec 2014 7:30 am: Hey Anand, The link doesnt seem to be working anymore (or, at least, its point to C&H, which I just don’t mind, but remembered your Dilbert browser but could not find it anymore).

Calvin and Hobbes Tracer Bullet 1

My all-time favourite series from Calvin and Hobbes. ...

Calvin and Hobbes Dad explains science

My second most favourite series from Calvin and Hobbes, where Dad teaches Calvin the wonders of science. ...

Web lookup using Excel

Take a look at the Excel screenshot below. Yes, that’s right. I have a user-defined function called AMAZONPRICE. And it returns these cameras’ prices directly from Amazon.com. (Given the category and some keywords, it returns the price of the bestselling item on Amazon.com.) Here’s the code behind the function. Function AmazonPrice(index As String, keywords As String) As String Dim xDoc As MSXML2.DOMDocument30 Set xDoc = New MSXML2.DOMDocument30 xDoc.async = False If xDoc.Load("http://ecs.amazonaws.com/onca/xml?Service=AWSECommerceService" _ "&Version=2005-03-23&Operation=ItemSearch&SubscriptionId=03SDGQDFEB455W53SB82" _ "&AssociateTag=sanand-20&MinimumPrice=10000&ResponseGroup=OfferSummary,Small" _ "&Sort=salesrank&SearchIndex=" & index & "&Keywords=" & keywords) Then xDoc.setProperty "SelectionLanguage", "XPath" xDoc.setProperty "SelectionNamespaces", _ "xmlns:a=""http://webservices.amazon.com/AWSECommerceService/2005-03-23""" AmazonPrice = xDoc.selectSingleNode("/a:ItemSearchResponse//a:Amount").Text End If End Function This is how it all started… ...

RSS feeds in Excel

The technique of Web lookups in Excel I described yesterday is very versatile. I will be running through some of the practical uses it can be put to over the next few days TO generalise things beyond just getting the Amazon price, I created a user-defined function called XPATH. It takes two parameters: URL of the XML feed to read Search XPath list string (separated by spaces) This function can be used to extract information out of any XML file on the Web and get it out as a table. For example, if you wanted to watch the Top 10 movies on the IMDb Top 250, and were looking for torrents, an RSS feed is available from mininova. The URL http://www.mininova.org/rss/movie_name/4 gives you an RSS file matching all movies with “movie_name”. From this, we need to extract the and <item><link> elements. That’s represented by “//item title link” on my search string. ...

Science Fiction awards

Now that I'm well on my way to watching the Top 250 movies on IMDb, I'm slowly turned my attention to fiction. My interest is mainly in the Fantasy & Science Fiction area. Unfortunately, I don't know of any list like the IMDb Top 250, but there are a few awards that could take the place of the Oscars for books. That's probably a good place to start. The most popular awards in Science Fiction are the Hugo award and Nebula award, followed by the Philip K Dick award, John W. Campbell award, Arthur C Clarke award and other awards. I collated a list of all the awards (from LocusMag) into the spreadsheet below ...

Tamil spelling corrector

The Internet has a lot of tamil song lyrics in English. Finding them is not easy, though. Two problems. The lyrics are fragmented: there's no one site to search them. And Google doesn't help. It doesn't know that alaipaayudhe, alaipaayuthe and alaipayuthey are the same word. This is similar to the problem I faced with tamil audio. The solution, as before, is to make an index, and provide a search interface that is tolerant of English spellings of Tamil words. But I want to go a step further. Is it possible to display these lyrics in Tamil? ...