Archive for March 2008

Google Spreadsheets and the Long Tail

I’ve been using Google Spreadsheets more recently to all the little one-pager list type spreadsheets that I make. When I noticed that they had added a notifications system, so that you can get an email when a collaborator updates a spreadsheet, or even a particular cell in the sheet, it sparked an idea. What if a cell could contain a short script, or a URL that points to a script on another server, that returned a number. The sheet could the update dynamically based on the result of the script.

This could be integrated with AdWords or Google Analytics, to return data from there that could feed custom analysis spreadsheets or could point to an internal database to use proprietary business data. I could also see data providers, e.g. the National Weather Service or Digg, providing statistics feeds that folks could slice and dice for their own purposes.

In a sense, this could be part of the long tail of the “super-cruncher”” phenomenon. Its hard to get good data to play with right now. A standard platform, or at least a standard access protocol, for raw numbers would open up opportunities to crowdsource data analysis.

Late afternoon haiku, on returning from work

Garden potential
Fingers buried in the dirt
Ah, simple pleasures!

Digging holes

Last year, I decided to plant fruit trees. Most folks would have chosen a nice dwarf apple and called that done. I wanted something a little bit different. After all, there are a ton of apple orchards in the area and we’re no strangers to them. One of the most delightful fruits that I’ve ever encountered happens to be one that is native to this area - the pawpaw. They’re like a tropical fruit that grows in a temperate climate. The better ones are large, custardy, and delicious, while the wild ones are highly variant in quality. None of them survive handling very well, which is why its next to impossible to find them commercially, unless you happen to be lucky enough to live near a farmers market graced by someone with a few pawpaw trees. The pawpaw is enjoying something of a renaissance, with a research program active at Kentucky State and several growers associations. After reading up on the fruit, I decided to try growing them.

Continue reading ‘Digging holes’ »

Things I dug out of my backyard today

I’ve started digging the holes for my pawpaw trees. On the first hole, I got down maybe 4-5 inches before I hit asphalt. Yes, asphalt. I continued to dig, and eventually excavated an asphalt covered block of concrete and brick about 12″ x 8″ x 6″. My only guess is that it was a fragment of the house’s old driveway, before they upgraded the sewer line. I also dug out corroborating evidence in the form of about 3 linear feet of terra cotta pipe, in pieces. I also dug out the better part of a piece of automotive glass that was amazingly whole - at least until I hit it with the mattock - and several old shingles. Apparently, the previous owners of the house used the the back corner of the lot as a junkpile. Fabulous.

Review and commentary on “Super Crunchers” by Ian Ayres

I recently read Ian Ayres’ excellent book, Super Crunchers. For folks who read and enjoyed Freakonomics, this book is a must-read, covering more cases where clever statistical analyses have uncovered interesting and useful results. The goal in writing the book, according to Ayres, was to encourage people to learn to think statistically. On the other side of the link is a discussion of some errors in experimental design, why their treatment in Ayres’ book frustrates me and why the average person should care.

Continue reading ‘Review and commentary on “Super Crunchers” by Ian Ayres’ »

More on the biofuel controversy

I posted an article earlier critiquing the media reaction to the recent reports on biofuels and land use management. Worldchanging has just posted a similar, fairly in-depth, critique as well. Their analysis goes more in depth into the specifics of each report, so I highly recommend it. What they do point out is that the Science articles are nuanced and that it was clear that the media in general either missed the nuance or ignored it.

Craig Venter wants to save the world

No one grandstands quite like Craig Venter. Whether its leading a team racing the government to the first human genome sequenced, succeeding, or admitting that his team beat the government by sequencing his own genome, this guy has style like few others in science. And while physicists at least have the reputation of having large egos installed as part of their graduate training, Venter’s ego is apparently physicist-sized, at least according to Wired and Forbes.

That being said, there is something phenomenally inspiring about the folks who have no shame about tackling the really big problems. This is a constructive sort of hubris, the kind that Larry Wall correctly identified as a virtue. Venter’s glorious hubris was on display this week at the TED conference, where he announced that he was working on a project to engineer a bacteria that turns carbon dioxide into methane and octane and that he expects results within 18 months on these fourth generation fuels.

Technorati Tags: , ,


Continue reading ‘Craig Venter wants to save the world’ »