Jump to content

  • Quick Navigation
Photo
- - - - -

Environmental Monitoring Template

Environmental

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

#1 dsafforld

dsafforld

    Grade - Active

  • IFSQN Active
  • 10 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


  • 0

#2 Charles.C

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 12,462 posts
  • 3246 thanks
347
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 ?


  • 0

Kind Regards,

 

Charles.C


#3 rdeboer1986

rdeboer1986

    Grade - Active

  • IFSQN Active
  • 20 posts
  • 6 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:


  • 0

Thanked by 1 Member:

#4 rdeboer1986

rdeboer1986

    Grade - Active

  • IFSQN Active
  • 20 posts
  • 6 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


  • 0

Thanked by 1 Member:

#5 Mulan1010

Mulan1010

    Grade - MIFSQN

  • IFSQN Member
  • 105 posts
  • 49 thanks
16
Good

  • 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


  • 0

Thanked by 1 Member:




Also tagged with one or more of these keywords: Environmental

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users