This spreadsheet was created in Excel 2007 to illustrate a simple way of showing how compliant an organisation is with the clauses of ISO 9001.
It uses the icon sets in Microsoft Excel and the MIN function to map compliance across each clause and subclause of ISO 9001.
Each subclause is scored 1 for non-compliant resulting in a red button, 2 for partially compliant resulting in yellow button and 3 for fully compliant resulting in a green button.
For each grouping of subclauses, the minimum score for each subclause determines the overall score. For example, subclauses 5.5.1 and 5.5.3 are fully compliant but 5.5.2 is only partially complaint so 5.5 is partially compliant.
This works up all the way to the main clauses – 4, 5, 6, 7 and 8.
Clause 5 is non-compliant because 5.3 is non-compliant even though all the other subclauses are either fully compliant or partially compliant. For example, subclause 5.5.1 is partially compliant but 5.5.3 is fully compliant.
The Microsoft Excel 2007 file used to create the above diagram will be sent to you if you provide your email address in a comment below. The spreadsheet does not work with earlier versions of Excel as they do not have the icon set that is used in this example.