Archive for the ‘Uncategorized’ Category

Doubling-Time Calculator

Wednesday, September 23rd, 2009

Folks in the lab have recently been calculating doubling times of strains.  I found doing the calculations one at a time tedious, so I put together a spreadsheet to automatically handle the data from the Biotek plate reader in batch.

I probably spent a totally unreasonable amount of time putting this together, but hopefully someone will find it useful.  It is particularly optimized to work with the raw data as it is spit out into Excel by the KC4 program.  It is optimized to work with the scales of data that I get out (48 hour growth, final OD ~0.8), but you should be able to easily modify the settings to work better for your data.

To start, you simply copy the raw data from your Excel worksheet to the worksheet in the calculator helpfully named “Raw Data”.

There’s a lot going on in there, so if you need something and can’t find it, then track me down, because it is probably hidden somewhere in there.  Alternatively, you can start unhiding rows and try to disentangle the works yourself…

Good luck!


Get Doubling Time Calculator