Here is what I am trying to do, I have a list of employees, grouped into teams, each team between 10- 25 employee. Each team member have to achieve certain goals and he/she will be ranked accordingly, the ranking assumed as percentage between -100% to 100%. There are 9 goals each employee have to achieve. There are 4 monitoring supervisors which each monitor certain aspect of the performance and submit a daily report with the assigned ranking. For example Supervisor #1 is responsible to submit a report contain Ranking 1, Ranking 2 and Ranking 3 in workbook 1 for the whole building which have around 100 employee doing the same job. Supervisor #2 is responsible to submit a daily report contains Ranking 4 and 5, in workbook 2. Supervisor #3 brings Ranking 6 and 7 in the same way. And finally Supervisor #4 create the report for ranking 8 and 9 for the entire building.
What I am trying to do is to take each of the reports from all supervisors, extract just the data that is assigned to specific employee and combine all the reports in one unified work book. After that I need to create an average to produce weekly and a monthly reports include charts.
I wish I can attach an excel file of raw data to help explain what I want to achieve
What I am trying to do is to take each of the reports from all supervisors, extract just the data that is assigned to specific employee and combine all the reports in one unified work book. After that I need to create an average to produce weekly and a monthly reports include charts.
I wish I can attach an excel file of raw data to help explain what I want to achieve