December 16, 2005

Tech support tricks of the trade. This one is very true. And I used to think computers just started working better when I was around…

Hilarious anecdotes from an American teacher in Japan. Comments Anonymous 22 Dec 2005 8:51 am: Good stuff Anand - and great placement of the link on Anecdotes - needed it after the example on leasing !!

Google Music Search and the Home Page API. With the home page API, Google Base, and Blogger, looks like Google has bypassed conventional web hosting and become a Web 2.0 host.

A corollary of Rule 3: Never type the same formula twice. Design the formula so that if you cut and paste it elsewhere, it works correctly. The $ symbol and the F4 key for cell references help in 90% of the cases. For complex requirements and large data, 5 functions come in handy: INDIRECT, OFFSET, ADDRESS, ROW and COLUMN. I once did a survey, and had data spread across 300 sheets (same format on all sheets). I needed cell D3 across all sheets in a column, to summarise the results. The image explains what I did. ...

10 most puzzling artefacts.