An Excel-based Calculator for Measuring Bacterial Concentration

Törün B.

Yüzüncü Yıl Üniversitesi Fen Bilimleri Enstitüsü Dergisi, vol.28, no.1, pp.106-112, 2023 (Peer-Reviewed Journal)


It is essential to know the initial bacterial count in microbiological studies. The classical plate count method is one of the most reliable methods. However, it is time-consuming. This study offers a fast method based on turbidity. This study describes how to create a calculator to be used for calculation of the bacteria concentration with spectrophotometric data in Excel 2010. In the study, McFarland standard and spread plate methods were used as standards for the control of spectrophotometric measurements. Bacteria used in the experiment were grown in suitable media and spectrophotometric measurements were performed. Then, using the Excel application, a calculator was created with a bio analytical approach to determine the linear relationship between turbidity and bacterial count. Bacteria counts were calculated by entering the absorbance data into the calculator, and the results were verified using cultural methods. As a result, an Excel-based calculator was created that can be used to calculate the number of bacteria from broth media.