How to Develop Skill Matrix? (with Excel Template)

In today's post I will show you how to prepare skill matrix template in spreadsheet and quickly retrieve the data when you needed. You might already know what the skill matrix is. If you don't know - read this post.

Objectives of developing and maintaining operator skill matrix

Before you start developing database for operators’ skill matrix, you should be clear about the objective of developing skill matrix database. If you ask me what would be the object of developing skill matrix, I will tell you primary objectives are
  1. To check operators skills in running different machines (in efficiency percentage)
  2. To check operators capability of doing various operations (If you maintain operations wise record, you may skip recording machine record or keep both) and their performance level (efficiency %)
  3. To know list of operators who can do selected operations and their performance level 

Method of developing Skill Matrix

Read this to learn step by step how to develop template for skill matrix.

Step#1: Develop excel template for data recording:
We will be using excel sheet for developing skill matrix. (Reason, most of the garment factories doesn’t have software for keeping skill matrix records.)

To have all basic information in one table, you need to capture following data.
  • Date of data entry, 
  • Operator name and employee code, 
  • Operation name, 
  • Machine name and 
  • Operator efficiency on the operation
Minimum information you need to capture are in the following table (Table-1)
Operator skill matrix
Table-1: Data entry sheet

Sometimes you may be interested to have detailed analysis about operators’ performance, production quantity, style number on which operator has worked, number of hours she has worked etc. Capturing that much data manually and entering into computer is time consuming. Just for information one more data entry table is shown here (Table-2).
Operator skill matrix

Step#2. Capture data: 
Collect employee wise production information as shown in the Table-1. For individual operator efficiency data calculate it using this formula 

Operator efficiency = (Produced minutes*100/Total minutes worked)

You may capture all records of an operators but don't enter everything in the database. You will get lot of variation in her efficiency on different dates and different styles. This happens due to many reasons like having lost time, line setting, no feeding, working for few hours in a new operation, working on new style etc. Ignore abnormal data and only record best performance out of many different efficiency data against an operator.

Also Read: How to calculation efficiency of individual operator?

Step#3. Enter data in the excel template
Instead of updating this table daily, you can update weekly interval or update when you see an operator doing a new operation or having good performance. (Though operators performance is depend on various things). 

If an operator is doing multiple operations in a same day, enter data in two rows to have her performance in all operations she has done.

You can keep old record or replace old one with new record for an operator doing same operation.

Step#4. View skill history report as you needed 
I have made pivot table to fetch data from the table (database) where you will be entering data. 
In the following section I have explained how to use excel templates for data entry and reviewing reports.

How to use Excel Template to retrieve skill history of the employee/ operations

The objective of making database is to get information on
  • Employee performance analysis
  • Selecting right employee for selected operations when required (also at the time of line setting)
First download excel template using this link (This is free download).

In the file I have made two sheets – Data entry sheet and data retrieve sheet. I guess you can operate excel sheet very well. See Table-1 for data entry template

1. Data entry sheet 
In this sheet you will enter employee data with all required information. As said above you can modify earlier data of an employee by replacing it with new record. Or add a new record.

2. Refresh file
When you add new record to the data entry sheet, refresh the file (Click menu Data - refresh all). This is done to get updated data in the second sheet. See below screen (Figure-1)
Excel tips pivot table data refresh

3. Data retrieve
In the data retrieve sheet I have added two tables named
  • Operator wise data view
  • Operation wise data view
Operator wise data: Select operator number for the drop down menu (See figure-2). You get list of operations done by that selected operator, list of machine type she had operated before and date when you have last updated her record.
Figure-3: Operator wise skill history

Operation wise data: Select operation name for the drop down menu (See Figure. 3). You will get list of employees who all did the selected operation (in the example operation: Sleeve hem), list of machine type she had operated before and date when you have last updated her record.
Figure-3: Operation wise skill history 

Developing and maintaining skill matrix is a time consuming task. Still you have developed it once and update the same in weekly or monthly interval would be very helpful. Real time shop floor control systems have such feature to record operator skill history automatically.

You might be using a different format for recording and viewing operator skills in you factory. However do you like this method? If yes please write you feedback on the following comment box.

0/Post a Comment/Comments