ISO 9001 Internal Audit Compliance Scoring System

Crusader · Nov 3, 2006

Re: ISO 9001:2000 Internal Audit Compliance Scoring System

Here is some real data.....a worksheet has since been added to show each division and only their resulting audit score. Cell colors help show where the system needs improvement.

kuzak · Dec 9, 2006

Re: ISO 9001:2000 Internal Audit Compliance Scoring System

Crusader said:
I originally posted this ISO 9001 Internal Audit scoring file in the Customer Satisfaction threads. So I started this thread, which is more appropriately named. I have since revised this file and corrected many mistakes! I hope it is useful to someone else. I created it to help me determine my employer's compliance to ISO 9001:2000 since one of our objectives is to maintain 80% to 100% compliance.

Edit: I guess my intent here is to eventually "share" the compliance rating. Maybe we can benchmark our ratings?? Is this even necessary?

This is really good and I can definitely use it. I am also going to use it to score the quality of audit reports!

AS Nur · Dec 3, 2008

Re: ISO 9001:2000 Internal Audit Compliance Scoring System

may be ia m too late to post comment but thanks for the great excell crusader

darwinkinks · Oct 7, 2010

Re: ISO 9001:2000 Internal Audit Compliance Scoring System

This tools will be very useful to our audit team, indeed I'm looking this gauging materials long time ago to improve our internal control so as to evaluate the level of compliance with our policies.

Thank you very much for sharing.

devraj singh · Nov 15, 2010

It's Really a great job.

Can somebody explain me how to transfer the score from Audit Checklist to this spread sheet.

Crusader · Nov 15, 2010

devraj singh said:
It's Really a great job.

Can somebody explain me how to transfer the score from Audit Checklist to this spread sheet.

For my scoring:
In your audit you identified what was missing or lacking, use that info to put an "X" in the cell for the most applicable column and/or columns. That is what I do. I hope this helps you. :bigwave:

devraj singh · Nov 16, 2010

Hi Crusader,

Thanks a lot. This really helped me and I am using your spread sheet for my organization.

Thanks Again

Devraj

bflynn16 · Dec 13, 2010

Thank you so much for this great spreadsheet. We are going to use something similar to this to help track our scoring/results. Our company wants to see numbers and this is a great way to measure, analyze and show how we're doing on a scale. This is a very effective way to view results.

Crusader · Dec 13, 2010

bflynn16 said:
Thank you so much for this great spreadsheet. We are going to use something similar to this to help track our scoring/results. Our company wants to see numbers and this is a great way to measure, analyze and show how we're doing on a scale. This is a very effective way to view results.

Great! You should check the formulas and such when you adapt this to your org because I beleive there are some boo boos in there.

Chance · Jan 20, 2012

Crusader said:
Edit: I guess my intent here is to eventually "share" the compliance rating. Maybe we can benchmark our ratings?? Is this even necessary?

Crusader,

I wanted to evaluate only one section of QMS which is Measurement, Analysis and Improvement. Is it possible? If yes, can you help me how my table and formulas would be? I have 6 divisions in my company.
Also, can you tel me why you use -30, -20, -10 specifically?

Thanks.

ISO 9001 Internal Audit Compliance Scoring System

Crusader

Attachments

kuzak

AS Nur

darwinkinks

devraj singh

Crusader

devraj singh

bflynn16

Crusader

Chance

Similar threads