A user friendly spreadsheet (Excel interface), designated MoS (Micro-Olive-Spreadsheet), is proposed in this paper as a tool to point out spoiling phenomena in Bella di Cerignola olive brines. The spreadsheet was designed as a protected Excel worksheet, where users input values for the microbiological criteria and pH of brines, and the output is a visual code, much like a traffic light: three red cells indicate a spoiling event, while two red cells indicate the possibility of a spoiling event. The input values are: (a) Total Aerobic Count (TAC); (b) Lactic Acid Bacteria (LAB); (c) yeasts; (d) staphylococci; (e) pH. TAC, LAB, yeasts, and pH are the input values for the first section (quality), while staphylococci count is the input for the second section (technological history). The worksheet can bemodified by adding other indices or by setting different breakpoints; however, it is a simple tool for an effective application of hazard analysis and predictive microbiology in table olive production.

A preliminary report for the design of mos (micro-olive-spreadsheet), a user-friendly spreadsheet for the evaluation of the microbiological quality of spanish-style bella di cerignola olives from apulia (Southern Italy)

Bevilacqua A.;Speranza B.;Campaniello D.;Sinigaglia M.;Corbo M. R.
2020-01-01

Abstract

A user friendly spreadsheet (Excel interface), designated MoS (Micro-Olive-Spreadsheet), is proposed in this paper as a tool to point out spoiling phenomena in Bella di Cerignola olive brines. The spreadsheet was designed as a protected Excel worksheet, where users input values for the microbiological criteria and pH of brines, and the output is a visual code, much like a traffic light: three red cells indicate a spoiling event, while two red cells indicate the possibility of a spoiling event. The input values are: (a) Total Aerobic Count (TAC); (b) Lactic Acid Bacteria (LAB); (c) yeasts; (d) staphylococci; (e) pH. TAC, LAB, yeasts, and pH are the input values for the first section (quality), while staphylococci count is the input for the second section (technological history). The worksheet can bemodified by adding other indices or by setting different breakpoints; however, it is a simple tool for an effective application of hazard analysis and predictive microbiology in table olive production.
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11369/396596
Citazioni
  • ???jsp.display-item.citation.pmc??? 1
  • Scopus 1
  • ???jsp.display-item.citation.isi??? 1
social impact