S Anand

Top 10 IT Google Videos.

Why spaghetti does not break in half. It usually breaks into three or more pieces. Audoly and Neukirch show several videos of this phenomenon. The also show that dry spaghetti breaks even if you just bend it, and release it suddenly. This is because the waves of curvature propogate through the spaghetti, and sometimes the curvature becomes too high. When you break spaghetti, it first breaks into two, and then the remaining halves behave as if they were released suddenly, splitting into further pieces.

Rule #4: Make your model visually obvious. After years of creating Excel models with lots of inputs and lots of outputs, I’ve learnt two things. Usually, only ONE input parameter matters. Think of this as being the constraint in the Theory of Constraints, or the principal component in factor analysis. You want your model to communicate the impact of the ONE parameter, and get a decision based on that. Keep the rest at their best default value. ...

Debugging in Excel is another time consuming task. 80% of the trouble is identifying the problem (Error? What error? Where?) as opposed to fixing it (Why’s THAT cell showing THAT?). Most of my time is spent chasing three kinds of errors: wrong reference (leading to a #N/A or #REF!), wrong data input, or wrong formula. Wrong references are easy to spot. You’ll see a #N/A or a #REF! sticking out. But on large sheets, even that’s tough to spot. I always have a SUM (or some kind of total) function that covers EVERY cell in EVERY table, even if I don’t need that information. If ther SUM shows a #N/A or #REF!, I can use Trace Error (Alt-T-U-E) to see where the problem is coming from. ...

A few tips, without getting into the details. Array formulas let you perform any calculation on an entire list, and get the result in a single formula. Database functions like DSUM can manipulate tables of data very flexibly. Using these and Pivot tables, you can do anything with any tabular data. Comments Ananth 22 Dec 2005 6:32 am: I needed your feedback on www.doondo.org. Give it a spin let me know. I wanted to avoid positng here but never got any replies for the mails sent at root_node at yahoo.com Ananth 22 Dec 2005 6:33 am: www.doondo.org is a hobby project I’ve been working on. The beta is just out. Ananth 22 Dec 2005 6:35 am: Looking forward for your views and feedback ritzkini 22 Dec 2005 10:01 am: great concept ananth..shld be a hit considering the great response to a similar funda used in IIM-I’s Klueless S Anand 22 Dec 2005 12:31 pm: I liked the concept and interface, Ananth. Will mail you in detail. Quick question… how do I find out what the right keywords are? ritzkini 23 Dec 2005 2:19 am: hehehe…hey anand,saw the visitor stats thing for the first time today ! awesomely cool ,kudos! u did it yourself ?? Dhar 23 Dec 2005 3:26 am: Ananth, does your game support advanced Google operators? Ananth 23 Dec 2005 4:11 am: Thanks for feedback folks. doondo needs additional features, like game summary with right keywords. Right now only basic operators are supported. Even such a simple concept requires complex coding skills! I would love if you can post the suggestion at [email protected]. Great if you can join the group. Anand wouldn’t like spamming his comments section with doondo. S Anand 24 Dec 2005 1:42 am: Yeah ritzkini, spent a week coding the visitor stats. What else do you think would be useful to see? ritzkini 26 Dec 2005 7:22 am: :) i dont think it could have been any more comprehensive than it already is ! :) harish 11 Jan 2006 3:50 am: great work mate…

Are the free Mac Minis for real? Hardy tries to get one – and succeeds. But… is it worth it? Pretty good economic analysis.

Most blogged books of 2005.

Paris by night. A panorama of Paris.

Site Helper: simple instructions on how to get a web site up and running.

Convert PDF to HTML via Gmail. This is the only way I know of converting something from PDF into another format. Unfortunately, it doesn’t work for GoogleMail in the UK.

Powers of Ten, a video for IBM zooming 10 times every 10 seconds through the universe.

So I have a blog is Sir Tim Berners-Lee’s blog. The comments on the first post pay homage to the father of the WWW. via LazyGeek

10 most puzzling artefacts.

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. ...

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.

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 !!

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…

All Apple advertisements

Da Vinci Code trailers. Comments Sai 15 Dec 2005 9:56 pm: Anand, tell us a bit about Infosys consulting. They seem to be on a big expansion drive. Hows it out there? S Anand 16 Dec 2005 7:32 am: I can mail you, Sai. What’s your e-mail ID? S Anand 16 Dec 2005 9:39 am: BTW, the del.icio.us tag on “The Da Vinci Code” is an anagram: c i con thee david. Sai 16 Dec 2005 7:42 pm: Anand it is [email protected] Sai 16 Dec 2005 7:46 pm: Thanks!

Quote by Herbert Simon on Information: What information consumes is rather obvious: it consumes the attention of its recipients. Hence a wealth of information creates a poverty of attention, and a need to allocate that attention efficiently among the overabundance of information sources that might consume it. It sounds quite like the Scientific American article The Tyranny of Choice which says that after a point, more choice causes unhappiness. The satisfaction of picking the best choice is less, because the second best is almost as good. And you’re more likely to not pick the best – because there are so many choices – and will regret it more often. ...