I'm thoroughly enjoying the tutorials as I prepare for the coming audits. I'm having one slight challenge though, I decided to create 1 document for the whole department and the department has different jobs (packers and operators) so I listed all the skills required. The problem is that other jobs are not assessed (not applicable) on certain skills e.g. a packer is not assessed on machine-setting so I left this blank... In the end, it reflects as though packers are performing poorly on this. Any suggestions? I'm trying to keep it as simple as possible. Thank you :)
Hi, I think I answered this one in the “sequel”: ua-cam.com/video/m5_FSx2LQB8/v-deo.html It looks at how to separate cohorts of different teams/roles. You can create charts that just look at the packers with charts customised to their skills. Give it a try, let me know if you have problems and if so I’m happy to have a call to talk you through it. 👍
Thank you so much, you have really made this complex system understandable! (Though I have to follow along again each time I try a new one). One question - when I add the "Teams" column, that messes up the original INDIVIDUAL skills columns, putting them all off by one (because in between the name and the first skill, the team column now shows up as column 2, where the first skill was column 2 in the first video). All the team stats work, since we're putting in new formulas and now the first skill is column 3, but when I look at the sheet for individual stats, the first skill has become a team name and all the skill numbers are off by one column. Do I have to reformat the individual sheet if I add the team column later? (To make it start with column 3 instead of column 2, and then readjust all the lines below). Or have I left off a $ from somewhere? It's all still sequential, just off by one. Am I making any sense?
Hi, I think I understand what you’re experiencing-but it’s not something I’ve seen before. When you added the Teams column, did you use “Insert Column”? Usually Excel can see that has happened and adjusts the formula in impacted cells.
@@InfluentialPMO Thanks for getting back to me! I did "Insert Column" - I have tried to follow your clear instructions exactly, no improvising! For all I know, I probably have an old version of excel. I'll either fiddle a little more, or maybe once I know exactly what I'm going to do I'll watch again and just make a template in advance with all the columns so I don't need to change anything. It's the team info that I need anyway. Again, thank you so much for your step-by-step instructions and your notes on possible complications and where to look to fix them. I just happened to need a group skills assessment (actually a before and after), so your video has opened up a whole new world for me!
Scoring effectiveness is probably going to be reliant on key performance indicators rather than a skills matrix. If you intend show the department skills score as a single value, I think you may need to determine a target score to compare against. Eg in overall skills we are 80% towards the target score. That’s if I understood the question! 😊
This is just perfect, thanks a lot. If you coming to Switzerland let us know. Cheers!
Thanks Oscar - will do 👍
Thank you so so much. You really changed my life! Thanks a lot for the wonderful tutorial!
You’re welcome - and thank you for taking the time to leave such kind feedback. I appreciate it.
Superb ! You have helped me to know better on making the skills matrix.
Glad I could help 👍
Thanks for nice tutorial!
Thank you, glad it was helpful 👍
I'm thoroughly enjoying the tutorials as I prepare for the coming audits.
I'm having one slight challenge though, I decided to create 1 document for the whole department and the department has different jobs (packers and operators) so I listed all the skills required. The problem is that other jobs are not assessed (not applicable) on certain skills e.g. a packer is not assessed on machine-setting so I left this blank... In the end, it reflects as though packers are performing poorly on this. Any suggestions? I'm trying to keep it as simple as possible.
Thank you :)
Hi, I think I answered this one in the “sequel”: ua-cam.com/video/m5_FSx2LQB8/v-deo.html
It looks at how to separate cohorts of different teams/roles. You can create charts that just look at the packers with charts customised to their skills. Give it a try, let me know if you have problems and if so I’m happy to have a call to talk you through it. 👍
Thank you so much, you have really made this complex system understandable! (Though I have to follow along again each time I try a new one). One question - when I add the "Teams" column, that messes up the original INDIVIDUAL skills columns, putting them all off by one (because in between the name and the first skill, the team column now shows up as column 2, where the first skill was column 2 in the first video). All the team stats work, since we're putting in new formulas and now the first skill is column 3, but when I look at the sheet for individual stats, the first skill has become a team name and all the skill numbers are off by one column. Do I have to reformat the individual sheet if I add the team column later? (To make it start with column 3 instead of column 2, and then readjust all the lines below). Or have I left off a $ from somewhere? It's all still sequential, just off by one. Am I making any sense?
Hi, I think I understand what you’re experiencing-but it’s not something I’ve seen before. When you added the Teams column, did you use “Insert Column”? Usually Excel can see that has happened and adjusts the formula in impacted cells.
@@InfluentialPMO Thanks for getting back to me! I did "Insert Column" - I have tried to follow your clear instructions exactly, no improvising! For all I know, I probably have an old version of excel. I'll either fiddle a little more, or maybe once I know exactly what I'm going to do I'll watch again and just make a template in advance with all the columns so I don't need to change anything. It's the team info that I need anyway. Again, thank you so much for your step-by-step instructions and your notes on possible complications and where to look to fix them. I just happened to need a group skills assessment (actually a before and after), so your video has opened up a whole new world for me!
Do you think there's a way in which I could represent the overall effectiveness of the department?
Scoring effectiveness is probably going to be reliant on key performance indicators rather than a skills matrix.
If you intend show the department skills score as a single value, I think you may need to determine a target score to compare against. Eg in overall skills we are 80% towards the target score.
That’s if I understood the question! 😊
For some reason it is populating in all but one column and is entirely blank. Any ideas?
Do the populated columns all match up to what you’d expect based on the data, or are they seem to be in the wrong columns?