... Use a Data Table

I used to know how to do this, but then forgot i) how to do it, and ii) what it was called.

You can fill a range of cells in Excel to the output from whatever arbitrary formula you would like, by making a list of input values, and the output formula at the top. This is useful because you can have the output being the result of some worksheet which is too complicated to manage in a single formula. The inputs can be applied to any cell you want.

So. 20 minutes of joy trying to navigate MS help and Google before I found what I needed.

Writing about: http://www.scottberkun.com/essays/essay51.htm

There isn’t a single great work in the history of civilization, no novel, symphony, film, or song that was completed as a 1/5th time-slice between e-mail, IM, cellphones and television.

(_via_ John Dale)

Well put, and so true. I know that when I want to really get on with the thesis, I quit the browsers, Set my messengers to Busy and actually really don’t talk to anyone who ignores that. Some things can be multitasked, most can’t. Or rather, can with a timeslice of > 1 h :-)