Archive

Archive for August, 2009

U of T Computer Science Events

August 14th, 2009

The Dept. of Computer Science at the University of Toronto now has an RSS feed for upcoming events.  If you want a less formal look at what the department’s doing, you can also subscribe to the Planet aggregator of departmental bloggers that Michalis Famelis runs.

Teaching

All I Want for Christmas…

August 7th, 2009

I’ve been telling my family I want a new bike (since I’ve been riding the one I bought from Jeff Balogh regularly since  May, and I’m still not dead), but maybe I want a Faradayed wallet:

To help prevent surreptitious readers from siphoning RFID data, a company named DIFRWear was doing brisk business at DefCon selling leather Faraday-shielded wallets and passport holders lined with material that prevents readers from sniffing RFID chips in proximity cards.

Via Nat Torkington.

Uncategorized

New Blog: Cross-Country Open Source Student Projects

August 6th, 2009
Comments Off

I’ve mentioned a couple of times that we’re running some capstone projects this fall with students from several universities across Canada.  The list of projects has grown, and we now have 21 students signed up, with more in the pipeline, so I’ve created a separate blog to keep track of it all.  I’ll be giving the students write access, and asking each team to post their thoughts and progress weekly; hope you’ll add it to your feeds.

Uncategorized

American Scientist Article on How Scientists Use Computers

August 6th, 2009

American Scientist has just published a short article summarizing I wrote summarizing the results from last year’s survey of how scientists actually use computers.

Research, Software Carpentry

Speaking at Stack Overflow DevDays in Toronto Oct 23

August 6th, 2009

I’ve been invited to talk at Stack Overflow DevDays at the St. Lawrence Centre for the Arts in Toronto on Friday, October 23.  I’m flattered to have been asked; now, what do you think I should talk about?

Announcements

Counting Combinations in Excel

August 6th, 2009

Dear LazyWeb,

I have a spreadsheet laid out as follows:

A B C
1 User First Second
2 turing red up
3 hopper blue down
4 zuse red up
5 knuth blue up

I’d like to generate another table counting choice pairs:

100 101 102
X red blue
Y up 2 1
Z down 0 1

There are going to be about eight values for ‘First’, and about a dozen for ‘Second’, so I don’t mind typing in the row/column headers for the second table. What I want is something like a double-barrelled COUNTIF(), but there doesn’t appear to be one. I’ve tried constructing an extra column joining the two choice values:

A B C D
1 User First Second _joined_
2 turing red up red:up
3 hopper blue down blue:down
4 zuse red up red:up
5 knuth blue up blue:up

and then doing COUNTIF(D2:D5,=CONCATENATE(something,’:',something)). However, I can’t put a CONCATENATE or any other function call in the second half of a COUNTIF (though you can compare to a cell value using something like “>=”&A5, and yes, the quotes are supposed to be where they are). I also can’t figure out what the something’s should be to look up the two items to concatenate.

So, how should I do this?  And please don’t say “use a relational database” — I’ve got some constraints here.

Uncategorized

It’s the Forwards, Stupid

August 3rd, 2009

Jason Cohen has a nice post about what “going viral” actually means.  Long story short, it’s not the number of people who read your post/tweet/whatever; it’s the number of people who forward it that matters.

Uncategorized

Rails Freelancing Handbook

August 3rd, 2009
Comments Off

Yet more evidence that Mike Gunderloy must have cloned himself several years ago—how else to explain how much he gets done, and how quickly?  His new Rails Freelancing Handbook is exactly what the title suggests: guidance from a successful freelancer for people who’d like to be one. Chapters include:

  1. Is Freelancing For You?
  2. Managing Your Business
  3. Managing Yourself
  4. Managing Clients
  5. Managing Your Software
  6. Managing Growth
  7. Managing Your Office

and an appendix titled “What If It Doesn’t Work Out?”.  Mike’s reputation and integrity are second to none, and his user guide for FogBugz is the best technical documentation I’ve ever read.  This new one’s going immediately to the top of my stack…

Books

Slides from Science 2.0

August 3rd, 2009
Comments Off

Slides from the Science 2.0 symposium held on July 29 as part of the Software Carpentry course are now available online.  Video of the lectures will follow soon.

Software Carpentry