Useful Numbers For Cell Culture

Spreadsheets That Actually Help In The Lab

I spent three years working in a cell culture lab where we lost more cultures to bad math than to contamination. My mentor built a reference document that became the only thing I trusted, and honestly it saved us from wasting thousands of dollars in reagents and weeks of work. The spreadsheet was just a simple Google Sheets doc. Not fancy. It covered media formulations with their component concentrations, standard dilution factors, passage calculations based on confluency targets, and conversion factors for things like TCA and MTT assays. We called it Useful Numbers For Cell Culture and it lived at the front of every notebook on the bench. What made it useful wasn't the data itself. It was that it was centralized, version-controlled, and updated whenever someone found a discrepancy in the literature. If you see a recipe online that says 1x pen-strep at 100 units/mL and your vendor's datasheet says something different, the sheet gets corrected. That's the whole point.

Useful Numbers For Cell Culture

The core sections break down into four categories. First is media composition, where every common base medium is listed alongside its standard supplement volumes. DMEM high glucose, RPMI 1640, F12, and the hybrids all have their recommended FBS percentages, L-glutamine concentrations, and antibiotic ratios. Some labs use 10% FBS as a default. Others need 15% for tricky lines. The sheet tracks what works for each protocol. Second is the passage and seeding table. This is where most mistakes happen. You calculate your desired cell density, account for the split ratio, and adjust for the fact that your flask has been sitting overnight and some cells already detached. The formula in the spreadsheet takes your current confluency estimate, the vessel surface area, and the target passages per day, then outputs exactly how much to seed per well. I've seen people skip this and just eyeball it. Don't. Third covers stock solution preparation. This is the part people get wrong most often. If you're making a 100x pen-strep stock from a powder, you need the molecular weight, the solubility limit in DMSO versus water, and the working concentration. The sheet pulls these from vendor datasheets. It also tracks expiry dates because antibiotics degrade and nobody wants to find out when their treated cells start dying.

The fourth section is assay conversion factors. If you're running CCK-8 or WST-1, the absorbance-to-cell-number conversion isn't universal. It depends on your cell type, your incubation time, and your plate reader settings. The sheet contains typical ranges for common lines like HeLa, HEK293, and MCF-7, but I learned the hard way that those numbers are starting points, not gospel. Here's something nobody tells beginners. Confluency estimates from eye are wildly inconsistent between people. One person sees 60% confluent. Another looks at the same dish and calls it 40%. I started using hemocytometer counts for the first two weeks after passaging, then fell back on confluency once the cells stabilized. The spreadsheet has a column where you can input actual counts alongside your visual estimate so you can calibrate your own eyes over time. After about twenty passages, my estimates were within 10% of the actual count. That's as good as it gets. I also learned that temperature matters more than most protocols acknowledge. When I measured cell growth rates at 37°C versus 36.5°C, the doubling time shifted by nearly 12%. Most incubators drift by that amount around door openings. I added a temperature correction column to the sheet and started logging it daily. It took five minutes and cut our variability in half.

Another counter-intuitive thing. Serum batches aren't interchangeable without checking. A lot of labs use one batch of FBS for months because it worked initially. I switched batches once and every line lost viability within three passages. The spreadsheet now has a field for each FBS batch number with notes on performance. If you're switching batches, run a side-by-side test with your hardest line first. The download link lives on our department's shared drive. It's a Google Sheets file with protected cells where only updates are allowed. No one edits the raw data. New entries go through review. I've seen colleagues copy it and open it in Excel, which broke some of the conditional formatting, but the calculations still work. Just don't rename columns. There are limitations. This isn't a substitute for reading the literature for novel cell lines. If you're working with primary neurons or organoid cultures, the numbers in this sheet won't apply. It's built for standard adherent lines used in most academic and industry labs. For suspension cultures, the seeding calculations need manual adjustment because the dynamics are completely different.

Also, the assay conversion factors are averages. If you need precise quantification, you should run a standard curve for every new cell line and every new reagent lot. The sheet tells you this in the header comments. People skip reading headers sometimes. If you're starting a new lab or taking over someone else's bench work, copy this file, customize it for your lines, and lock the formulas. It will save you from repeating the same math mistakes three times a week.