Hi Everyone, Does anyone have a spreadsheet (template) to record your environmental swabbing results such as Salmonella and Listeria? A document for tracking and trending purposes.
Regards,
Donnell
Posted 03 April 2017 - 06:25 PM
Hi Everyone, Does anyone have a spreadsheet (template) to record your environmental swabbing results such as Salmonella and Listeria? A document for tracking and trending purposes.
Regards,
Donnell
Posted 04 April 2017 - 05:57 PM
Hi Everyone, Does anyone have a spreadsheet (template) to record your environmental swabbing results such as Salmonella and Listeria? A document for tracking and trending purposes.
Regards,
Donnell
Any relevant template is likely to relate to yr product/process ?
Kind Regards,
Charles.C
Posted 05 April 2017 - 12:38 PM
You can make this easily in excel. Just make a table with on the horizontal access the following items:
Week: production date: Lot no. Type of product place:
Thanked by 1 Member:
|
|
Posted 05 April 2017 - 12:40 PM
You can make this easily in excel. Just make a table with on the horizontal access the following items:
Week: production date: Lot no. Type of product place:
TPC: Entero: E.coli Salmonella Listeria Etc.
Then you can fill the results in the horizontal lines. Using the option in Excel for graphs you can set up a trend analysis by selecting the right columns
Thanked by 1 Member:
|
|
Posted 13 April 2017 - 03:41 PM
There are many ways that you can track your samples. A simple and inexpensive option is to use an Excel file as was suggested. If you have sites that are regularly sampled then you could list them out in a file and then mark each time they are sampled. Use a 0 for a negative and a 1 if positive. The file would then be able to tell you how many times that site has been sampled through out a time frame and how many, if any times it was positive as well as a percentage. It is a simple way to track and trend. (I have attached a sample format.)
If you are having some issues with positive samples then suggest you map them. Get a diagram or a simple drawing of the layout of the area or plant and plot areas that showed positive and sometimes it is useful to plot the negatives too, but it can sometimes overwhelm your map so consider using transparencies to layer them over one another.
Thanked by 11 Members:
|
|
Posted 25 March 2020 - 11:31 PM
There are many ways that you can track your samples. A simple and inexpensive option is to use an Excel file as was suggested. If you have sites that are regularly sampled then you could list them out in a file and then mark each time they are sampled. Use a 0 for a negative and a 1 if positive. The file would then be able to tell you how many times that site has been sampled through out a time frame and how many, if any times it was positive as well as a percentage. It is a simple way to track and trend. (I have attached a sample format.)
If you are having some issues with positive samples then suggest you map them. Get a diagram or a simple drawing of the layout of the area or plant and plot areas that showed positive and sometimes it is useful to plot the negatives too, but it can sometimes overwhelm your map so consider using transparencies to layer them over one another.
That is a very simple and straightforward way to keep track of environmental monitoring program. Great idea. Thank you.
Thanked by 1 Member:
|
|
Global Food Safety Standards →
PrimusGFS →
Environmental Testing Limits For Dry Pulse Processing FacilityStarted by carlibboyle, 09 Apr 2024 ![]() |
|
![]() |
|
Global Food Safety Standards →
BRCGS - Food Safety →
Testing Plan Risk AssessmentStarted by Annguyen, 08 Mar 2024 ![]() |
|
![]() |
|
Food Safety Topics →
Food Microbiology →
Flour Mill Environmental MonitoringStarted by QCQAPROD, 20 Feb 2024 ![]() |
|
![]() |
|
Global Food Safety Standards →
BRCGS - Food Safety →
Environmental Monitoring in Food PackagingStarted by sprout.derek, 08 Dec 2023 ![]() |
|
![]() |
|
Global Food Safety Standards →
FSSC 22000 Food Manufacturing →
Regulations for Microbial Environmental Monitoring in South AfricaStarted by Twinkle, 18 Sep 2023 ![]() |
|
![]() |
0 members, 1 guests, 0 anonymous users