+ Reply to Thread
Results 1 to 9 of 9

Breakdown and Computation of lab time

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Richmond, Va
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    137

    Breakdown and Computation of lab time

    Hi,

    I know this may not be the best place, but I figured I ask for advice, since I am not sure how to capture this in Exell, maybe someone else has run into this problem and can guide me


    My lab runs 24/7 - 3 people working 8 hr shift…..If they are running 2 different test

    1) Total testing time – 60 minutes (Labor time – 20 minutes, Machine time – 40 minutes) Machine calibration time – 10 minutes
    2) Total Testing time – 20 minutes (Labor time – 10 minutes, Machine time – 10 minutes) Machine calibration time is 2 minutes

    How many test can the lab techs run in a day?
    How busy are the machines? (How many test can a machine process)
    How efficient are the techs on any given shift (7a-3p, 3p-11p, 11p-7a)?


    Thx
    Omer

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: Breakdown and Computation of lab time

    Can you clarify: "3 people working 8 hr shift…..If they are running 2 different tests" How many hours do they work if they DO NOT run 2 different tests ?

    In the 8hrs do they have Breaks & Lunch ?

    Clarify: You say total testing time = 60 or 20 minutes but your sub totals add up to 70 mins and 22 mins respectively !
    Last edited by BlindAlley; 12-28-2015 at 02:39 PM.

  3. #3
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Richmond, Va
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    137

    Re: Breakdown and Computation of lab time

    Quote Originally Posted by BlindAlley View Post
    Can you clarify: "3 people working 8 hr shift…..If they are running 2 different tests" How many hours do they work if they DO NOT run 2 different tests ?

    In the 8hrs do they have Breaks & Lunch ?

    Clarify: You say total testing time = 60 or 20 minutes but your sub totals add up to 70 mins and 22 mins respectively !

    So Lunch Break is 1/2 hr. Yes, they run this these 2 test all day long, (Samples are always there, they don't stop :-)). ..... OK you are right in the sense that I didn't count calibration time as part of testing time because calibration is a necessity and if you like you can add it to machine time.

    Thx for the suggestion

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Breakdown and Computation of lab time

    If I had to guess I would go with machine calibration not being a necessity on each test, therefore not included in the total time.

    If this is the case then we would need to know how often calibration is required in order to allow for that in the relevant calculations.

    In addition, are all 3 techs required to run each test?

    Are the test run on 2 different machines, or alternating on the same machine?

    Can machines be left working unattended? If not how many techs must remain with the machine to observe?

    We seem to have an overwhelming absence of relevant data.

  5. #5
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Richmond, Va
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    137

    Re: Breakdown and Computation of lab time

    Quote Originally Posted by jason.b75 View Post
    If I had to guess I would go with machine calibration not being a necessity on each test, therefore not included in the total time.

    If this is the case then we would need to know how often calibration is required in order to allow for that in the relevant calculations........Machine calibration is required every 4 hrs, Testing cant proceed until machine is calibrated.

    In addition, are all 3 techs required to run each test?..........Yes all 3 techs run these 2 test over and over again, Samples are always there, they don't stop. :-)

    Are the test run on 2 different machines, or alternating on the same machine?We have 2 machines and either machine can run the test. ( 2 machines and 3 Techs)

    Can machines be left working unattended? If not how many techs must remain with the machine to observe?Machine can be left unattended, while testing is in progress, Tech either completes paperwork in that time or prepares the next sample for the machine.

    We seem to have an overwhelming absence of relevant data.
    I have tried to give as much info Please feel free to ask, as I develop this spreadsheet with Formaulas


    THX for your help

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Breakdown and Computation of lab time

    This depends on so much. Do the machines have auto-samplers and automated data collection like an HPLC or GC or are they semi automatic maybe like a Karl Fisher assay or are they completely manual like a pH test?

    Also don't forget to include documentation time in all of this. How thorough are your lab notebooks? Let's say that the instrument time is 4 minutes (per sample) and it takes 2.5 minutes to prep the next sample. Would you expect them to leave the instrument and try to do something else for the 1.5 minutes time difference?

    If it's not clear yet, I hate lab metrics. While they could be used to make a lab better, more often they end up just being manipulated (either by management or the analysts).

    In any case, I would divide it up like this
    Sample Prep: Hand on time (including writing stuff down), total time
    Instrument prep: hands on time (how long to set up the instrument)
    Assay time: hands on time, total time
    Calculations/documentation: hands on time

    Hope that helps.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  7. #7
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Richmond, Va
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    137

    Re: Breakdown and Computation of lab time

    Quote Originally Posted by ChemistB View Post
    This depends on so much. Do the machines have auto-samplers and automated data collection like an HPLC or GC or are they semi automatic maybe like a Karl Fisher assay or are they completely manual like a pH test?These are GC, so once sample is loaded the tech can walk away and prepare next sample or complete paperwork.

    Also don't forget to include documentation time in all of this. How thorough are your lab notebooks? Let's say that the instrument time is 4 minutes (per sample) and it takes 2.5 minutes to prep the next sample. Would you expect them to leave the instrument and try to do something else for the 1.5 minutes time difference?Reasonably thorough, yes you are right, 1.5 min can be used for other things like housekeeping, documentation, ordering supplies, etc

    If it's not clear yet, I hate lab metrics. While they could be used to make a lab better, more often they end up just being manipulated (either by management or the analysts).Mgmt mostly, but I gotta have some metrics.

    In any case, I would divide it up like this
    Sample Prep: Hand on time (including writing stuff down), total time
    Instrument prep: hands on time (how long to set up the instrument)
    Assay time: hands on time, total time
    Calculations/documentation: hands on time

    Hope that helps.
    Can you throw a quick spreadsheet to show calcs? THX in ADVANCE

  8. #8
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Breakdown and Computation of lab time

    Here's something.
    Methods N Tasks would be filled in by you with expected times to complete certain methods or tasks. I would suggest getting your best analyst to fill this in (or maybe your slowest analyst or average the two).
    The Log sheet would be where people enter their hands on time and their start and finish times. There's also a drop down for what sort of assay type it is.

    From those two sheets, you should be able to calculate Percent differences by analyst, how much time is spent on sample prep, clean up, etc.. These calcs, will be presented on the Metrics sheet. How much time is spent on stability samples, reinjections, reassays, routine samples, etc.

    So, if you can show 20% of time is spent on clean up, maybe you can justify getting a lab aide.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Richmond, Va
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO
    Posts
    137

    Re: Breakdown and Computation of lab time

    Thanks for a good start ChemistB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. hours breakdown, Ordinary, O/time 1.5 and O/Time 2.0
    By stax290 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-07-2022, 01:42 AM
  2. [SOLVED] Help with Time computation with condition
    By yrneh in forum Excel General
    Replies: 5
    Last Post: 10-01-2015, 02:38 AM
  3. Time Computation for Late
    By johnnyocaya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2014, 05:26 AM
  4. Hours Breakdown to Normal Time, T5 & DT
    By Rallie1982 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2012, 04:39 AM
  5. Time Computation Error
    By j0x in forum Excel General
    Replies: 6
    Last Post: 07-03-2011, 06:14 PM
  6. Time breakdown function in Excel
    By tonycm1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2007, 08:14 AM

Bookmarks

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