Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Loungers,

    I have been given a spreadsheet used for auditing proposes. Is it broken up into different sections and each section needs a % compliance score. There are different compliance option contained in each relevant cell in colum D these are Compliant, Non-Compliant, Partially Compliant, Not-Applicable.

    Anyone have any suggestions as to how to calculate % compliance based on the options described above?

    I hope that makes sense.

    Regards

    Dean

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Here is one methodology"
    1) You could as total count use everything but the "not-applicable"
    2) The compliant are the count of the "compliant"
    3) The partially compliant (count of the "Partially compliant) could be multiplied by a factor (0.5 perhaps - "Half compliant" or some other factor).
    4) then (#2 + #3) / (#1) would be % compliant.

    You could also include an intermediate column of individual "%compliant" and use 1 of "Compliant" 0 for "non-compliant", "N/A" for "Not applicable" and even include a value from 0 to 1 as "% compliant" for the "Partially compliant". Then you just have to average this column column for % compliant. [If all the partials are 50% you get the methodology from the initial but could use an IF to calculate this column]

    Steve

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks for the quick reply - will give is a go.

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •