Bo102010 comments on Research methods - Less Wrong

13 Post author: Swimmer963 22 February 2011 06:10AM

You are viewing a comment permalink. View the original post to see all comments and the full post content.

Comments (41)

You are viewing a single comment's thread. Show more comments above.

Comment author: Nic_Smith 22 February 2011 07:19:54AM *  7 points [-]

A few thoughts:

  • I am continually amazed at the amount of data that should be put and manipulated in a proper database that's mucked about in spreadsheets instead.
  • Gene Callahan at ThinkMarkets recently had a post on how health care is especially bad when it comes to technology.
  • Eric Falkenstein says there are a lot of "skilled" jobs that could be replaced by computers too.
Comment author: Bo102010 24 February 2011 05:24:21AM 2 points [-]

I agree in some sense, but disagree in another. I am fast at Excel. I don't need to use to mouse, look at the menus, or pause to find anything I'm looking for, because I've internalized the keyboard shortcuts and created quick macros for the things I need to do. People get a little flustered when they see me work in Excel because it looks like it's magically doing stuff, but it just comes from lots and lots of repetition.

Contrast this with a proper database, where I need to figure out some way to load the data in, make sure my query accounts for every place there might be a null value, then make some change that might break my previous queries if I need to add or change a column or something. And then if I need to take a slice of data and present it, I have to load it into Excel anyway.

For very large datasets with fairly static requirements, I use a database as is proper. But for anything less than 100K rows, give me a spreadsheet any day.