The figure above shows the schedule of four employees - Abani, Bahni, Danni, and Tinni - whom Dhoni supervised in 2020. Altogether there were five projects which started and concluded in 2020 in which they were involved. For each of these projects and for each employee, the starting day was at the beginning of a month and the concluding day was the end of a month, and these are indicated by the left and right end points of the corresponding horizontal bars. The number within each bar indicates the percentage of assigned work completed by the employee for that project, as assessed by Dhoni.
For each employee, his/her total project-month (in 2020) is the sum of the number of months (s)he worked across the five projects, while his/her annual completion index is the weightage average of the completion percentage assigned from the different projects, with the weights being the corresponding number of months (s)he worked in these projects. For each project, the total employee-month is the sum of the number of months four employees worked in this project, while its completion index is the weightage average of the completion percentage assigned for the employees who worked in this project, with the weights being the corresponding number of months they worked in this project.
Which employees did not work in multiple projects for any of the months in 2020?
Abani, Banni, and Danni did not work on multiple projects simultaneously in a month
Tinni was the only person who worked on multiple projects which are project 4 and project 5 in the month of september.
CAT DI Data Change Over Period
CAT Tables With Missing Values
CAT LR Selections With Conditions
CAT Averages, Ratios & Proportions
CAT Logarithms, Surds & Indices
CAT Functions, Graphs & Statistics