Jump to content

  • Quick Navigation
Photo

Environmental Monitoring Template

Share this

  • You cannot start a new topic
  • Please log in to reply
5 replies to this topic

dsafforld

    Grade - Active

  • IFSQN Active
  • 16 posts
  • 1 thanks
0
Neutral

  • United States
    United States

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



Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 20,542 posts
  • 5662 thanks
1,544
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

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


rdeboer1986

    Grade - AIFSQN

  • IFSQN Associate
  • 33 posts
  • 14 thanks
1
Neutral

  • Norway
    Norway

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:

rdeboer1986

    Grade - AIFSQN

  • IFSQN Associate
  • 33 posts
  • 14 thanks
1
Neutral

  • Norway
    Norway

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:

Mulan1010

    Grade - MIFSQN

  • IFSQN Member
  • 249 posts
  • 139 thanks
78
Excellent

  • United States
    United States

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.

Attached Files



Quality@BLDG

    Grade - Active

  • IFSQN Active
  • 3 posts
  • 1 thanks
1
Neutral

  • Australia
    Australia

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:


Share this


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users