employees production and productivity calculation

Hi Team,

I have attached the file which contains sheet 1 - task counts done by each employees per day and sheet - 2 template (what exactly I need).

Please find the time consuming on each task below.

Task 1 - employee can done 6 counts per hour
Task 2 - employee can done 12 counts per hour
Task 3 - employee can done 10 counts per hour
Task 4 - employee can done 15 counts per hour
Task 5 - employee can done 15 counts per hour


on sheet 2 when I filter the date and employee, all the data to be populate on the given table with the calculation(eg: time taken & productivity).

Please let us know if you need further details.

Regards,
Girish

hello...

your problem a bit challenging ..
but I have solved it...
change the employees.. and result will automatically change...

just check the attachment...



click * to appreciate..

Did that help...?
Waiting for your reply..