Corrective and Preventive Action Tracker

Template for logging nonconformance (NCs) and Corrective and Preventive Actions (CAPAs) for effective tracking purposes

by SHEQXEL
HSE Dashboards ~ Excel ApplicationsFollow 39

315 views|2 comments|Bookmark Add to cart - $19.97

Description
To ensure continuous improvement of the health and safety management system, identifying nonconformance and analyzing their root causes for corrective and preventive actions (CAPA) play pivotal role. Nonconformance are usually identified through Safety Monitoring or Assurance Activities such safety audits, workplace inspections and the like.

SHEQXEL Corrective and Preventive Action Tracker provides the best template for logging all Nonconformance and Corrective and Preventive Actions (CAPAs) for effective tracking purposes.

The tool has 4 main features;

The Approved List is the setting section where Safety Assurance activities and Corrective Action Rate targets usually 100%, are set. A list of safety assurance activities such as internal audits, external audits, workplace inspections, environmental inspections, chemical inspections, safety walkthroughs, hazard hunts etc. have been provided for users to use or update with their own to reflect in source data sheet.

The Source Data features all safety assurance activities, details, location or equipment, nonconformance, roots causes, corrective/preventive actions, responsible person, progress updates, deadlines, deadline status which is dynamically set to show “Not Yet Due”, “Deadline Due Soon”, “Overdue” or “Deadline Met”. The source data dynamically tracks due days, duration used to close action once the user updates action status as closed and provided the closing date.

The Dashboard is dynamically designed with stacked bar charts, clattered column charts and a speedometer chart to visualize all open and closed actions, and progress towards the Overall Corrective Action Rate target.

The rest of the sheets are pivot tables and graphs to show total nonconformance, CAPA (Action) status from Safety Assurance Activities, days CAPA is Due or Overdue; duration Used to Close CAPA and finally the CAPA Register showing all closed vs Open actions & Persons Responsible.

This is a Microsoft excel file hence no installation is required and can run on both Windows and Mac with Microsoft Excel 2013 (+ Later Versions)

This Best Practice includes
1 excel file, 3 pdfs