Estimating microbial population counts by 'most probable number' using Microsoft Excel.

A computer-assisted method for determining population counts using the 'most probable number' (MPN) was developed. The Microsoft Excel spreadsheet and its Solver tool were used to generate MPNs, error estimates and confidence limits. Our method was flexible, allowing the use of unbalanced replication schemes and varying replication numbers and inoculation volumes. Furthermore, it required no programming skills and generated fast results, which were comparable to those of standard MPN tables and MPN software.