rfmartinez
New Member
- Joined
- Sep 29, 2010
- Messages
- 3
Hi all.
I teach curriculum at work. My goal is to run a consistent completion rate for each material of curriculum. For instance each month there is new training. I want to be able to calculate the percentage of completion. When it is completed at the end of each week, I update it by placing an x in the material's column and to the right of the employee name.
My problem is that I also have terminated employees that I do not want removed from the sheet. I already have it filtered that if I have an x in the "Separated" column, I want it hidden. The only problem is that depending on if that person completed a standard task/curriculum it upticks my percentage. If the person separated, it skews it lower.
How can I solve this? All help is appreciated.
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
I teach curriculum at work. My goal is to run a consistent completion rate for each material of curriculum. For instance each month there is new training. I want to be able to calculate the percentage of completion. When it is completed at the end of each week, I update it by placing an x in the material's column and to the right of the employee name.
My problem is that I also have terminated employees that I do not want removed from the sheet. I already have it filtered that if I have an x in the "Separated" column, I want it hidden. The only problem is that depending on if that person completed a standard task/curriculum it upticks my percentage. If the person separated, it skews it lower.
How can I solve this? All help is appreciated.
Total Employees (Excluding Seperated): | 6 | |||||
Employee ID# | Seperated | Lesson 1 | Lesson 2 | Lesson 3 | ||
1234 | x | |||||
2345 | x | x | ||||
3456 | x | x | ||||
4567 | x | x | ||||
5678 | x | x | ||||
6789 | x | |||||
7890 | x | x | x | |||
8901 | x | x | ||||
9012 | x | x | x | |||
1123 | x | |||||
Count: | 10 | 4 | 3 | 6 | 6 | |
Completion % | 50% | 100% | 100% | |||
Termination Value: | -100% | 200% | 200% | |||
Actual Completion: | 17% | 33% | 33% |
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>