# Lab Productivity

1. ## Lab Productivity

Here is some data I need help with (spreadsheet attached)

I have lab technicians working 24/7 and I am trying to see how best to display “lab technician Efficiency” in excel…….(Who is the most efficient of them all). I am looking for the creative mind

2. ## Re: Lab Productivity

Omer:
Place the technician's initials next to the number of samples analyzed (adding columns between shifts after row 31).
Create a list of technicians separate from your data fields.

Doing a countifs next to each name on your list of techies will give you the number of shifts the tech. worked.
Now do a sumif which will result in the number of samples analyzed by that technician.

Now divide the number of samples per tech by the number of shifts. Or, use averageif by tech by shift. Sort the table if you like by efficiency.

Simple.
Pete

3. ## Re: Lab Productivity

That assumes that there is always backlog to process, and that techs are not penalized for their having no work to do.

4. ## Re: Lab Productivity

Yes, SHG, But......then what about the 'goody, goody, two shoes' who is always sucking up to Omer and grabs more than everyone else :-)

I think you would possibly need a 'Difficulty' rating assigned to each sample analyzed then use countif unless of course all of the analysis procedures are exactly the same and take the same amount of time.

5. ## Re: Lab Productivity

@BlindAlley
You mean you want to penalize the employee who goes to work to actually work in favour of those who show up to do the minimum possible

I re-arranged the data to be 1 record per row and one field per column combining both of your charts.

6. ## Re: Lab Productivity

@ PeteABC Thx for the suggestion

7. ## Re: Lab Productivity

@ SHG Kinda true :-)

8. ## Re: Lab Productivity

@ new doverman Thx for the spreadsheet

9. ## Re: Lab Productivity

Originally Posted by newdoverman
@BlindAlley
You mean you want to penalize the employee who goes to work to actually work in favour of those who show up to do the minimum possible

I re-arranged the data to be 1 record per row and one field per column combining both of your charts.
Hi Doverman - How did you re-arrange data? Did you type it manually or ???

10. ## Re: Lab Productivity

I did it manually as it is a "one of" as an example of how to input data so that it is actually useful to create reports with. This was quickly done mostly with copy and paste.
If you want to quickly enter the dates so that you have 3 of the same date then increment by one day, this formula will do that. It assumes the dates to actually start in A3 and go down the column. A date preceding the actual start date by 1 day is entered in A2.
Enter this in A3 and fill down and format as a date.
Formula:
`Please Login or Register  to view this content.`

 A 2 31/12/2015 3 01/01/2016 4 01/01/2016 5 01/01/2016 6 02/01/2016 7 02/01/2016 8 02/01/2016 9 03/01/2016 10 03/01/2016 11 03/01/2016 12 04/01/2016 13 04/01/2016 14 04/01/2016 15 05/01/2016 16 05/01/2016 17 05/01/2016 18 06/01/2016 19 06/01/2016 20 06/01/2016 21 07/01/2016 22 07/01/2016 23 07/01/2016 24 08/01/2016 25 08/01/2016

11. ## Re: Lab Productivity

Please Delete - Post entered twice on save.

12. ## Re: Lab Productivity

Originally Posted by newdoverman
I did it manually as it is a "one of" as an example of how to input data so that it is actually useful to create reports with. This was quickly done mostly with copy and paste.
If you want to quickly enter the dates so that you have 3 of the same date then increment by one day, this formula will do that. It assumes the dates to actually start in A3 and go down the column. A date preceding the actual start date by 1 day is entered in A2.
Enter this in A3 and fill down and format as a date.
Formula:
`Please Login or Register  to view this content.`

 A 2 31/12/2015 3 01/01/2016 4 01/01/2016 5 01/01/2016 6 02/01/2016 7 02/01/2016 8 02/01/2016 9 03/01/2016 10 03/01/2016 11 03/01/2016 12 04/01/2016 13 04/01/2016 14 04/01/2016 15 05/01/2016 16 05/01/2016 17 05/01/2016 18 06/01/2016 19 06/01/2016 20 06/01/2016 21 07/01/2016 22 07/01/2016 23 07/01/2016 24 08/01/2016 25 08/01/2016
THX AGAIN newdoverman

13. ## Re: Lab Productivity

Originally Posted by newdoverman
I did it manually as it is a "one of" as an example of how to input data so that it is actually useful to create reports with. This was quickly done mostly with copy and paste.
If you want to quickly enter the dates so that you have 3 of the same date then increment by one day, this formula will do that. It assumes the dates to actually start in A3 and go down the column. A date preceding the actual start date by 1 day is entered in A2.
Enter this in A3 and fill down and format as a date.
Formula:
`Please Login or Register  to view this content.`

 A 2 31/12/2015 3 01/01/2016 4 01/01/2016 5 01/01/2016 6 02/01/2016 7 02/01/2016 8 02/01/2016 9 03/01/2016 10 03/01/2016 11 03/01/2016 12 04/01/2016 13 04/01/2016 14 04/01/2016 15 05/01/2016 16 05/01/2016 17 05/01/2016 18 06/01/2016 19 06/01/2016 20 06/01/2016 21 07/01/2016 22 07/01/2016 23 07/01/2016 24 08/01/2016 25 08/01/2016
THX AGAIN newdoverman

14. ## Re: Lab Productivity

omer,

I played with a summary in the attached. I won't elaborate. I just had some fun.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1