I am working on calculating efficiency of class utilization. There are two tables and one go the details of the students who have participated for classes and the other got the respective week's class schedules.
My intention is to calculate the efficiency of the class utilization.
Please fin the attached excel sheet for the details.
I want to calculate the utilization percentage of classes based on the number of students participated for a respective class for a week out of total available capacity for the respective class for the week. Thus, I am looking at the class room utilization on a weekly basis..
I gave a thought of grouping the student's actual participation in to weeks and divide it by the total number of available capacity for the respective week. However, still I do not have a clear idea of implementing the solution.
Appreciate, if someone could help me with this issue. Hope there can be surely a better way of doing this which does not strike in my head at the moment.