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?

Lee-Good file, you did a great jod developing this rating score matrix.:yes:
Thanks for sharing

Lee-Good file, you did a great job developing this rating score matrix.:yes:
Thanks for sharing

Thanks! I have really only begun to enter the audits that have taken place this year so far...and I am unsure my rating system is "good". Might be too generous! :D

I like what you have done and is certainyl something I may look at adopting for the company I work for as we have more sites becoming certified.

One question though. Why is full compliance given a score of 100 yet everything else is given a negative value. I am certainly not an expert in statistics but I would have thought this could skew the results. Wouldn't a score of 0 for full compliance be better?

Thanks Crusader,

Seems like a good approach on seeing it right now.

Infact, I myself was thinking on how to measure the compliance of the QMS. With all the parameters defined and score points allocated, this seems to be a right approach.

I like what you have done and is certainyl something I may look at adopting for the company I work for as we have more sites becoming certified.

One question though. Why is full compliance given a score of 100 yet everything else is given a negative value. I am certainly not an expert in statistics but I would have thought this could skew the results. Wouldn't a score of 0 for full compliance be better?

Please look into the formulas.
It is 100 minus the indicated " negative value ".

Good tool to make the gap analysis a measurable item.
Thanks a lot for sharing.

Best regards,

Antoine

Thanks for that, guess I should look at the detail before typing.

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.

Crusader, this spreadsheet is wonderful. I myself have been doing audits for so long time, but I could never think that the audits could be quantified as this one.

Kudos :applause:

Thanks everyone for the kudos! :bigwave: Please, please provide feedback regarding improvements, corrections, etc.

The reason I created it in the first place was only for my use - my own personal interpretation of how well we are maintaining our registration and to create a visual target of the areas needing improvement. Then we added this compliance system score to our company objectives: "ISO 9001 QMS Compliance Score". Now this score is posted for everyone to see. I am starting to trend the score on an added worksheet in that file.

I also think this is a very good looking scoring tool. :applause: It can provide some pretty meaningful metrics for management reviews.

I can imagine it is adaptable for corrective action assessment too.

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.

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!