Jump to content

  • Quick Navigation
Photo

Nonconformance Tracker Template

nonconformances

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

#1 millie

millie

    Grade - AIFSQN

  • IFSQN Active
  • 25 posts
  • 4 thanks
1
Neutral

  • United States
    United States

Posted 08 November 2017 - 01:56 PM

Good Morning!

 

Can someone provide an excel spreadsheet template for tracking nonconformance. I need something that can quickly be modified. Thanks You!



#2 Peaches

Peaches

    Grade - MIFSQN

  • IFSQN Member
  • 122 posts
  • 98 thanks
5
Neutral

  • United States
    United States
  • Gender:Female

Posted 08 November 2017 - 02:31 PM

We have a simple format that we use to track our corrective actions which could be modifed to track holds.  The first tab is where we enter in the information and the second tab is where we trend/track reasons for our corrective actions/holds.  



Thanked by 2 Members:

#3 Peaches

Peaches

    Grade - MIFSQN

  • IFSQN Member
  • 122 posts
  • 98 thanks
5
Neutral

  • United States
    United States
  • Gender:Female

Posted 08 November 2017 - 02:32 PM

I forgot the attachment on the first try!  More coffee needed this morning!  Attached File  Template.xlsx   24.06KB   276 downloads



Thanked by 5 Members:

#4 millie

millie

    Grade - AIFSQN

  • IFSQN Active
  • 25 posts
  • 4 thanks
1
Neutral

  • United States
    United States

Posted 08 November 2017 - 02:48 PM

Thank You! This is something simple that I can modify and begin using right away.



#5 J0hn

J0hn

    Grade - AIFSQN

  • IFSQN Associate
  • 31 posts
  • 3 thanks
0
Neutral

  • United Kingdom
    United Kingdom

Posted 08 November 2017 - 03:18 PM

I forgot the attachment on the first try!  More coffee needed this morning!  attachicon.gifTemplate.xlsx

 this is a good template, I've been trying to create one for years but always seem to get stuck as it needs to be simply to interpret and trend but also detailed enough that partcular issues can be easily highlighted.



#6 3560lynne

3560lynne

    Grade - AIFSQN

  • IFSQN Associate
  • 48 posts
  • 22 thanks
13
Good

  • United States
    United States

Posted 02 November 2018 - 11:14 AM

This is a very nice template. Unfortunately, I spent more years on the processing floor than a computer and I struggle with excel. The only drop down box I am getting to show is the kind of the deficiency. I click on the others and I get a box that asks how to filter it - A - Z, Z - A, etc then says you must be in one cell. Can anyone guide me on how to bring up all the drop down boxes? I see a small black square on the right bottom corner of each cell thinking there is something there but when I click on it, it does nothing.

Thank you. 



#7 mgourley

mgourley

    Grade - FIFSQN

  • IFSQN Fellow
  • 1,101 posts
  • 825 thanks
138
Excellent

  • United States
    United States
  • Gender:Male
  • Location:Plant City, FL
  • Interests:Cooking, golf, firearms, food safety and sanitation.

Posted 02 November 2018 - 12:06 PM

The Type of Deficiency column is the only column that has any data to choose from (derived from the Revision Log tab).

 

All the rest of the cells are free form entry and do not require data validation.

 

Marshall



Thanked by 1 Member:

#8 3560lynne

3560lynne

    Grade - AIFSQN

  • IFSQN Associate
  • 48 posts
  • 22 thanks
13
Good

  • United States
    United States

Posted 02 November 2018 - 12:41 PM

Simple enough! 

Thanks!






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

EV SSL Certificate