• 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...

  • 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

Alphonso Smith

New Member
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
 

Alphonso Smith

New Member
Alphonso

Firstly, Welcome to the Chandoo.org Forums

Your basic data is
View attachment 57488

That lends itself to using Conditional formatting
View attachment 57489

or equivalent

Another method is to display it like:
View attachment 57490
see attached file:
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
 

Hui

Excel Ninja
Staff member
Can you please attach a sample file with 20ish rows of data

Please also sketch what you mean by Graphically ?
 

Hui

Excel Ninja
Staff member
The File I uploaded had a Formula in to select Random Data
That is probably why it was changing
 
Top