Araştırma Makalesi

An Excel-based Calculator for Measuring Bacterial Concentration

Cilt: 28 Sayı: 1 30 Nisan 2023
Bahadır Törün *
PDF İndir
Yüzüncü Yıl Üniversitesi Fen Bilimleri Enstitüsü Dergisi Kapak Yüzüncü Yıl Üniversitesi Fen Bilimleri Enstitüsü Dergisi
TR EN

An Excel-based Calculator for Measuring Bacterial Concentration

Abstract

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.

Keywords

Bacterial calculation , Calibration curve , McFarland calculator , McFarland standards

Kaynakça

  1. Almeida, A. M., Castel-Branco, M. M., & Falcão, A. C. (2002). Linear regression for calibration lines revisited: Weighting schemes for bio analytical methods. Journal of Chromatography. B., 774(2), 215–222. doi:10.1016/S1570-0232(02)00244-1
  2. Bressolle, F., Bromet-Petit, M., & Audran, M. (1996). Validation of liquid chromatographic and gas chromatographic methods. Applications to pharmacokinetics. Journal of Chromatography B: Biomedical Sciences and Applications. 686(1), 3–10. doi:10.1016/S0378-4347(96)00088-6
  3. Cuadros-Rodríguez, L., García-Campaña, A. M., & Bosque-Sendra, J. M. (1996). Statistical estimation of linear calibration range. Analytical Letters, 29(7), 1231-1239. doi:10.1080/00032719608001471
  4. Edwards, A. (2019). How to do a linear calibration curve in excel. https://www.howtogeek.com/399883/how-to-do-a-linear-calibration-curve-in-excel/ Last accessed on 20.06.2020.
  5. Escher, B. I., Neale, P. A., & Villeneuve, D. L. (2018). The advantages of linear concentration–response curves for in vitro bioassays with environmental samples. Environmental Toxicology and Chemistry, 37(9), 2273-2280. doi:10.1002/etc.4178
  6. Farhat, N., Hammes, F., Prest, E., & Vrouwenvelder, J. (2018). A uniform bacterial growth potential assay for different water types. Water Research, 142, 227-235. doi:10.1016/j.watres.2018.06.010
  7. Gu, H., Liu, G., Wang, J., Aubry, A. F., & Arnold, M. E. (2014). Selecting the correct weighting factors for linear and quadratic calibration curves with least-squares regression algorithm in bio analytical LC-MS/MS assays and impacts of using incorrect weighting factors on curve stability, data quality, and assay performance. Analytical Chemistry, 86(18), 8959–8966. doi:10.1021/ac5018265
  8. Hayashi, Y., Matsuda, R., Ito, K., Nishimura, W., Imai, K., & Maeda, M. (2005). Detection limit estimated from slope of calibration curve: an application to competitive ELISA. Analytical Sciences, 21(2), 167-169. doi:10.2116/analsci.21.167
  9. Isenberg, H. D. (2004). McFarland Standards. Clinical Microbiology Procedures Handbook, vol 2. DC, USA: ASM Press.
  10. McFarland, J. (1907). The Nephelometer: An instrument for estimating the number of bacteria in suspensions used for calculating the opsonic index and for vaccines. Journal of the American Medical Association, 49(14), 1176–1178. doi:10.1001/jama.1907.25320140022001f

Ayrıntılar

Birincil Dil

İngilizce

Konular

-

Bölüm

Araştırma Makalesi

Yazarlar

Erken Görünüm Tarihi

29 Nisan 2023

Yayımlanma Tarihi

30 Nisan 2023

Gönderilme Tarihi

20 Haziran 2022

Kabul Tarihi

28 Eylül 2022

Yayımlandığı Sayı

Yıl 2023 Cilt: 28 Sayı: 1

DOI

https://doi.org/10.53433/yyufbed.1133323

IZ

https://izlik.org/JA77MC39XP

Kaynak Göster

RIS / Bibtex
APA
Törün, B. (2023). An Excel-based Calculator for Measuring Bacterial Concentration. Yüzüncü Yıl Üniversitesi Fen Bilimleri Enstitüsü Dergisi, 28(1), 106-112. https://doi.org/10.53433/yyufbed.1133323