Results 1 to 2 of 2

Thread: RAG Status - how to calculate

  1. #1

    Unhappy RAG Status - how to calculate



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have to create a RAG status based upon the start date given in the file and by looking how many weeks in the process the task takes to get an answer as to whether the start date is feasible.

    The time frames to compare the tasks are as follows:

    Activity Weeks (from) Weeks (To)
    Planning 1 2
    Advertising 3 5
    Assessment 6 10
    Offered 11 16

    For example if I have a start date of a vacant position as 20th Oct and is in the Advertising stage, the process could take a further 2 weeks for advertising (at worst) or 1 week at best PLUS there would be another 4 weeks for the assessment process and 5 weeks for the offer to be made. Therefore, at worst would take (2+4+5 = 11 weeks at worst) or (1+4+1 = 6 weeks at best). Therefore a start date of 20th Oct is going to give a RAG status of Red.

    If the start date was in 12 weeks time, yes it would be 11 weeks at worst but there is a potential to claw back one week from the process to give an amber rating.

    Green would be when the start state is for example 12 weeks time.
    If on hod, then the RAG status would be green.

    i would need a formula to capture all the 4 activities based on the number of weeks it could take and compare this to the start date as to whether this is realistic.

    PLEASE HELP.
    Attached Files Attached Files
    Last edited by u65646; 2014-10-11 at 08:12 PM. Reason: forgot attachment to explain issue

  2. #2
    how do you attach files here? for some reason the forum is not allowing me to attach any excel files.

Posting Permissions

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