+ Reply to Thread
Results 1 to 2 of 2

formula for compliance

  1. #1
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    42

    formula for compliance

    I have a supervision tracker that I need help with please

    basics are that every month staff need a supervision appointment and this needs to be logged and each month we need to know what percentage of staff have had their supervision and also we need individual compliance percentages.

    I've attached an example of what I am talking about

    the formulas I am using are not sufficient as I need it to understand some certain things - for example if a staff member is off sick or on maternity leave so supervision is not possible or if they didn't start working for the company until part way through the year.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-04-2017
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    42

    Re: formula for compliance

    also forgot to add that even the simple staff I need help with the formula to see how they are getting on throughout the year - as I have put it to divide by 12 - ie 12 months in the year - but this obviously gives them a low score until the end of the 12 months - what is the formula to put - look at the date and divide by the number of months that have passed so far that year?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Time formula to calculate compliance
    By manito2000 in forum Excel General
    Replies: 9
    Last Post: 12-27-2017, 12:15 PM
  2. Formula to calculate service level compliance
    By ljerromes in forum Excel General
    Replies: 3
    Last Post: 04-10-2016, 06:12 PM
  3. Compliance
    By patfle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2014, 04:12 AM
  4. Formula to calculate compliance
    By patfle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-16-2013, 11:54 AM
  5. Formula to calculate compliance
    By patfle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2013, 11:41 AM
  6. [SOLVED] Help with Formula for % Compliance
    By Maeeday in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 08:01 PM
  7. driver hour compliance formula mto
    By hello? in forum Excel General
    Replies: 1
    Last Post: 02-11-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1