Managing and Reporting Audits with an Excel .xls spreadsheet

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#1
I've reviewed software for managing audits and found them wanting. This business of reporting "Number of audits performed" seems worthless to me--where's the data showing how the system is actually performing?

When Crusader provided us with a spreadsheet for objectively reporting audit results, I jumped right on it because I've been wishing for a better tool for recordig results than percent pass/fail based on counts of questions asked. I figure it's better to monitor against elements covered, believing it would better reflect systemic conformance.

I've attached the tool that Crusader invited me to alter, and a little paper describing its use.
 

Attachments

Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#3
Re: Managing and Reporting Audits with Excel .xls

It took a few days. It was worth the time invested, though I could have saved myself some time if I had moved the banks of accruing weighted scores earlier. I fooled around with formulas for awhile before giving up the fight and separating out those lines. Keeping them was important to me though, so I could compare the year-to-date performance in all the audits.
 

Crusader

Trusted Information Resource
#4
Re: Managing and Reporting Audits with Excel .xls

I've reviewed software for managing audits and found them wanting. This business of reporting "Number of audits performed" seems worthless to me--where's the data showing how the system is actually performing?

When Crusader provided us with a spreadsheet for objectively reporting audit results, I jumped right on it because I've been wishing for a better tool for recordig results than percent pass/fail based on counts of questions asked. I figure it's better to monitor against elements covered, believing it would better reflect systemic conformance.

I've attached the tool that Crusader invited me to alter, and a little paper describing its use.
Have you made any more changes? Modifications, etc?
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#5
Re: Managing and Reporting Audits with Excel .xls

This version allows us to enter the number of times an element has been audited versus only counting each element once.

Reporting is by dicrepancy only, for those of whom "No news is good news" is the preferred reporting method.

There are spreadsheets for 2007 and 2008. If you want to use the spreadsheet tool past that point, two methods work:

1. Copy and paste the "Original" into a new workbook. Change the names on the tabs, then save the new workbook with a new name. Caution!!! In the new worksheets, the graphs' source data fields must be updated to draw from the proper workbook. This has already been done in this version's 2008 workbook.

2. Save the entire spreadsheet under a new name, then change the workbook tabs' titles. This might be the simplest (therefore best) approach. I haven't tried it.
 

Attachments

Last edited:
S

stephen pearce - 2008

#6
Re: Managing and Reporting Audits with Excel .xls

Wow :thanx:

Thank you for your contribution here it will make life easier for me. :)
 
F

Frank T.

#7
Re: Managing and Reporting Audits with Excel .xls

Much Thanks to Jennifer and Crusader......:applause:
 

antoine.dias

Quite Involved in Discussions
#8
Re: Managing and Reporting Audits with Excel .xls

I had missed that last one a couple of months ago.

Thanks Jennifer and best regards,

Antoine
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#9
Re: Managing and Reporting Audits with Excel .xls

You're all welcome. I find it a rare privilege to offer something so useful. I've been using it in my position and am finding it very satisfying.

For many long years there has been no such place to share these things with a community, and I have felt--on the fringe--for a very long time. That's no fault to anyone but myself, as I don't regularly go to my local ASQ chapter meetings, and simple geography.

As for the first part, ASQ chapters would do well to develop the community that this forum has brought to all of us globally. But, when there is one why would a person want dozens? So I decided the matter is one of geography and I'm just happy to be able to be a part of something larger than my day-to-day matters.

Thanks goes also to my boss, who has agreed for me to share these things although they are worked on with company time (He's aware I got the earlier version from the Cove anyway, seems fair to give back to the community) as long as I remove any intimate reference to our business.

I hope to continue to contribute cool stuff, though it will probably slow down somewhat. Still, watch closely and you will see the progress a certain QA department is making in its reformation from a police department to a service environment.
 
Thread starter Similar threads Forum Replies Date
M Clinical Benefit of device that only aids in a process for managing or treating disease EU Medical Device Regulations 2
S Thoughts on managing ISO 9001, 13485, IATF 16949 and 17025 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 33
P Managing How PPAP Requirements are Communicated in the Manufacturing Process and to Suppliers APQP and PPAP 5
qualprod Managing a "special" customer into the QMS? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
D Recent changes to ISO 14971 - SOP required for managing standard revisions ISO 13485:2016 - Medical Device Quality Management Systems 1
A Managing overseas travel risks to food handlers Food Safety - ISO 22000, HACCP (21 CFR 120) 3
S Managing specification changes on standard parts purchased through trading companies Document Control Systems, Procedures, Forms and Templates 2
L Managing design projects: New Medical Device Project or Change Design and Development of Products and Processes 1
M Medical Device News DHS – Health Industry Cybersecurity Practices: Managing Threats and Protecting Patients Medical Device and FDA Regulations and Standards News 0
F Device Standards - Managing Changes to existing standards that apply to our devices Other Medical Device Related Standards 1
J Design Verification - Managing Changes Design and Development of Products and Processes 4
Jane's You may or may not have the same person managing Operations and QA ISO 13485:2016 - Medical Device Quality Management Systems 18
Q Managing Internal/External RNC and Complaints in same Format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
L Managing Finance Processes - Identification of Sub Processes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
J Microbiology Testing - Managing a Microbiology Process Hospitals, Clinics & other Health Care Providers 2
R Managing Level 3 Production Documents - Document Control System Help Document Control Systems, Procedures, Forms and Templates 6
G Managing Ongoing Compliance to Standards when they are Changed Misc. Quality Assurance and Business Systems Related Topics 3
R Managing Employee Training Files - 21 CFR Part 820.25 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
P Need ideas on managing Shelf Life Studies within an organization ISO 13485:2016 - Medical Device Quality Management Systems 1
I Any recommendations on software for managing the APQP, PPAP, PFMEA, Control Plan etc? Quality Assurance and Compliance Software Tools and Solutions 2
R Managing Tooling Condition at Suppliers Supplier Quality Assurance and other Supplier Issues 6
B Subsidiary - No Managing Director - Is ISO 9001 Certification Possible? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
R Looking for Practical Advice in Managing Measurement Uncertainties Measurement Uncertainty (MU) 3
L Managing ITP with an ERP system Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Q Form for Managing Coating Process Parameter Changes during Production Document Control Systems, Procedures, Forms and Templates 2
S Managing a Significant Number of Outstanding Non-Conformities Nonconformance and Corrective Action 6
A Software Tools for managing a QMS (Quality Management System) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Managing Inspection Records with a Database and Destroying Paper Records Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
D Process for Managing Documents which are Overdue for Review Document Control Systems, Procedures, Forms and Templates 17
S Q1 Manufacturing Site Assessment - Managing Post-Job 1 Changes Procedure Manufacturing and Related Processes 1
B Are there any Standards related to Managing an Airport Various Other Specifications, Standards, and related Requirements 3
Q Managing Internal and Client Complaints ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
S Industry Best Practices for managing outside Engineering Consultants Design and Development of Products and Processes 3
Q Process or Departments - Document Content and Managing the Process Approach ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
Q Filtering ECR/ECO by quality management? Managing Engineering Changes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Managing the Unexpected - Book Recommendation Book, Video, Blog and Web Site Reviews and Recommendations 1
T Internal Conflict of Interest in Managing Suppliers Supplier Quality Assurance and other Supplier Issues 2
L Managing Certificates of Analysis or Conformance for Products Quality Assurance and Compliance Software Tools and Solutions 4
T Managing Audit Reports and Schedules General Auditing Discussions 3
M Managing Changes to an SFDA Registered Device China Medical Device Regulations 6
F Who manages QI projects? Quality or PMO? Managing Six Sigma and Lean Projects Six Sigma 2
Hami812 Attribute Data Gage R&R - Managing Data Sets - Minitab Using Minitab Software 2
E Nonconformity on managing documents for Electric Arc Furnace Manufacturing and Related Processes 4
D Managing an Employee Suggestion Program Quality Manager and Management Related Issues 4
K Managing Prerequisite Programme Activities Food Safety - ISO 22000, HACCP (21 CFR 120) 2
M Non Normal Data Managing - Clements Method to get Process Characteristics Statistical Analysis Tools, Techniques and SPC 8
J Managing New and Revised Electronic Documents (Procedures) - Share Point Document Control Systems, Procedures, Forms and Templates 8
N Managing Subcontracting Process - Material Traceability from Warehouse to Processing ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
G Should ISO/QMS policy be signed by the Managing Director or anyone from Top Mgt? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
M Managing Quality Risks in Construction Quality Manager and Management Related Issues 14

Similar threads

Top Bottom