Readjust weighting based on non compliance

[fmluder93]

Hi there,

I have an audit tool that is set up to weight results based on what level of compliance is obtained. The tool now needs to include an additional weighting for when people get a 1 in the score (which is not meeting compliance). This is only for those that are highlighted in red cells (there are about 11 in total). These are rows 14,19,25,33,36,39,44,46,53,54 and 60 in the Main Audit tab.

At the moment auditees can get a leadership or advanced score even if they have 4 or 5 non compliance results (ie score 1 in the red cells as in column F). Im not sure how to do this.

The way i want the tool to work is the grading to be readjusted to the following:

1) If they get up to 3 non conformances they go straight to transition result
2) If they get 4 plus non conformances they go straight to critical result

I have attached the tool that is used. Im working off the Main Audit tab and Audit Summary tab. Im not too concerned with amending the actual weight as yet - as that is something i will work on next. Or if anyone has any ideas about how to go about that - that would be appreciated.

Many thanks in advanced.