1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Capturing Maturity Index of the team

Discussion in 'Excel Dashboards' started by Alphonso Smith, Jan 10, 2019.

  1. Alphonso Smith

    Alphonso Smith New Member

    Messages:
    2
    Hello all,
    New member here.
    I have a team of 54 FTE's and would want to create a rating mechanism for them. The rating would be based on 4 categories (Functional, Innovation, Compliance and Knowledge/Skills). These would further have sub categories within each. Each FTE would be rated on a scale of 0-4 (4 being the highest). Seeking your help/advise as to what is the best way to showcase this data. Would appreciate if anyone could share a template in case anyone has a similar rating system in their org.
    Regards,
    Alphonso Smith
  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    12,258
    Alphonso

    Firstly, Welcome to the Chandoo.org Forums

    Your basic data is
    upload_2019-1-11_9-14-34.png

    That lends itself to using Conditional formatting
    upload_2019-1-11_9-15-18.png

    or equivalent

    Another method is to display it like:
    upload_2019-1-11_9-23-16.png
    see attached file:

    Attached Files:

  3. Alphonso Smith

    Alphonso Smith New Member

    Messages:
    2
    Thanks Hui (for the Welcome and the file :))

    Though the provided is simplistic and serves the purpose to a large extent; would it be possible to show the same graphically? Also the FTE data is not inter-related, however in the file, if i change the value of any parameter for any FTE the representation for all other FTE changes in the table too.

    Regards,
    Alphonso Smith
  4. Hui

    Hui Excel Ninja Staff Member

    Messages:
    12,258
    Can you please attach a sample file with 20ish rows of data

    Please also sketch what you mean by Graphically ?
  5. Hui

    Hui Excel Ninja Staff Member

    Messages:
    12,258
    The File I uploaded had a Formula in to select Random Data
    That is probably why it was changing

Share This Page