Solution Quality Index

I am trying to create a quality index to rate article submitted. I have the standard weighted sum formula currently in use, but the problem is an article can have multiple problems so the number of articles reviewed is not necessarily the number of problems found.

The worksheet should show 100% if no issues have been found. If someone has 5 things wrong and 2 articles submitted they shoudl have a lower score then someone with 10 things wrong but 10 articles submitted.

If more clarification is needed please let me know. I have attached an example sheet for reference.

Once everything works out I will put my final, completed worksheet for others to use.

Yeah, everytime an article has an issue listed in C:N then they have one mark. An article can both be 'Wordy' and have 'Broken Hyperlinks' so the author would receive an additional mark in each column. A zero would be a 100%. Off the top of my head, maybe if the number of articles and number of defects are the same it should be zero (i would have to play with the numbers)

As to why it does not add up to zero is because for the readers of the report it is easier for them to understand a relative weight like the weight listed in the document.

Brilliant, man you should have seen how complicated by attempts were (i was so over thinking it). Thank you again. As I promised here is the finished work, hopefully it will help someone trying to have a quality index for their knowledgebase.