Check it off

As part of my quest to find ever duller subjects to blog about, I will now briefly discuss web-based task managers. These are bits of software (let's avoid that badly-abused term 'app', shall we?) designed to replace all the usefulness of a pen and pad of paper, at least when they're used for keeping track of lists. Electronic solutions offer benefits like sorting, accessibility, and categorization, all of which can be performed on paper with the right combination of tabs and color-coding. Even so, no notebook matches the Internet's ability to make the same bits of information available everywhere, all the time. The end goal is to decrease the amount of friction between conceptualizing a task and actually completing it.

So here's a bit of pro and con:

• Pen and paper. It's easy, requires no power or data connection and looks great in a Lisa Frank Trapper Keeper.* It also cannot exist in more than one place at once. That may be a feature rather than a bug if security is a concern.
• A text file. The digital equivalent of pen n' paper, this option is cheap and flexible. It does require access to wherever the file happens to be, though placing it in a Dropbox solves that issue handily. Even so, mobile devices find editing text files challenging. I'm not sure why. Text editors also aren't ideal environments for sorting tasks though they are great for searching, especially when regular expressions are involved.
• Remember The Milk.  I used this for a while last year after migrating from the maddeningly minimal Google Tasks. It's free-ish, plays well with Google Apps of various sorts, and parses natural language very smoothly (i.e., you can enter a task as "eat ham on Wednesday" and it will understand when the task should happen). The -ish is an issue as the web interface is free but the mobile version won't sync tasks more than once a day without a $25/year pro account. The interface used to be genuinely ugly on all platforms but appears to have improved recently. It has plenty of features and active support. That added cost is really the only downside but it's a notable one.
• Astrid. This isn't even a real option any longer as the Astrid team got bought out (read: consumed and digested) by Yahoo** a few months back. It's sad. Astrid ran smoothly on all kinds of platforms, looked great, and allowed for shared lists. Now it's all gone.
• Wunderlist. This option may, in fact, be on its second iteration (Wunderlist2) and is primarily a mobile application. At least, I had daily problems with its interface: tasks would disapper, buttons would become invisible, and most recently I couldn't even log in to my account. The entire project has a Web 2.5 sheen which is attractive until the point at which it works slowly. Even worse, there is no option to export tasks to anything other than a bloated, difficult-to-import-with-other-software JSON file. I used Wunderlist for about six months and just couldn't tolerate all the bugs.
• Toodledo. Just started using this one. It's rich in features but I'll have to use it a while to see if they're useful. The desktop web interface has some really basic usability issues, but hey, it's all free.

Next week, I plan to discuss the care and handling of airborne sawdust. Stay tuned, kids!

*I was blissfully immune from the Trapper Keeper trend when it was endemic. Have students ever been so excited about personal organization since that time?

**Or, more officially, YAHOO!

Yes, that is correct, more dumb Excel tricks

For personal future reference and otherwise: how to hide text in Excel but retain the formatting. Just change the Format to ;;;. That's all it takes.

See also: this blog post.

Learning to love mothballs

Today, I learned about the existence of a bacterial species named Polaromonas naphthalenivorans. This lil' guy* fits into the mysterious, often baffling category of extremophile bacteria - that is, species capable of living in environments we normally wouldn't consider habitable. Originally isolated from a coal-tar-contaminated aquifer somewhere in the northeastern US,** P. naphthalenivorans can grow using naphthalene as its only carbon source. It's not terribly surprising, as naphthalene is a major component of coal tar (and was originally isolated from coal tar, in fact), so this species is just working with what it has. It's still rather odd as naphthalene is toxic and a suspected carcinogen. Those kind of rules don't always apply to bacteria.

Dividing P. naphthalenivorans cells. Micrograph is from the Joint Genome Institute (JGI). See this page for more details.

Most people are familiar with naphthalene as a component of mothballs. This paper suggests that a whole metabolic community could subsist on naphthalene, or at least could adapt to its presence. Evolution is great that way!

*Literary anthropomorphism is a constant danger when discussing animals and especially when discussing microbes since it's difficult to understand why they do what they do. I will rarely, however, avoid an opportunity to make bacteria seem cute. They're already tiny, and tiny things are cute, right?

**A paper describing the aquifer describes it using little more detail than "A single truckload of coal tar was buried in a forested area in the northeastern United States." This MicrobeWiki page says it's in South Glens Falls, New York. There's a lab at Cornell that likes to work there. As far as they know, the local drinking water isn't contaminated with coal tar or anything like that.