G
Guest
Data on sheet 1:
Column A is a list of employees by initials: AA, BB, CC, DD, etc.
Column B is the type of project the employee was assigned: L, M, N, O, R, S,
T, U, V, etc.
Column C is the number of days it takes the employee to complete the
assignment: 7, 5, 11, etc.
Each time a new assignment is given it is logged on a row in the spreadsheet
by the employee's initials in Column A and the type of assignment in Column B
of the same row. When the assignment is completed, I note the number of days
it took to complete the assignment in Column C.
Data on sheet 2:
This is the monthly production report. Each employee is listed on a separate
row. Assignments have been graded by management as easy, medium, and
difficult.
Column A is for "easy" assignments: types L, U, S
Column B is for "medium" assignments: types M, N, R
Column C is for "difficult" assignments: types O, T
What I need to extract from sheet 1 is the average number of days it take
each employee to complete his assignments for the month separated by easy,
medium and difficult. Also, since not all assignments will be completed by
the end of the month, some cells in Column c on Sheet 1 will be blank.
Thanks for your help!
Column A is a list of employees by initials: AA, BB, CC, DD, etc.
Column B is the type of project the employee was assigned: L, M, N, O, R, S,
T, U, V, etc.
Column C is the number of days it takes the employee to complete the
assignment: 7, 5, 11, etc.
Each time a new assignment is given it is logged on a row in the spreadsheet
by the employee's initials in Column A and the type of assignment in Column B
of the same row. When the assignment is completed, I note the number of days
it took to complete the assignment in Column C.
Data on sheet 2:
This is the monthly production report. Each employee is listed on a separate
row. Assignments have been graded by management as easy, medium, and
difficult.
Column A is for "easy" assignments: types L, U, S
Column B is for "medium" assignments: types M, N, R
Column C is for "difficult" assignments: types O, T
What I need to extract from sheet 1 is the average number of days it take
each employee to complete his assignments for the month separated by easy,
medium and difficult. Also, since not all assignments will be completed by
the end of the month, some cells in Column c on Sheet 1 will be blank.
Thanks for your help!