This is great stuff! I'll look at it at work and plug in some data.
Whoever gets the supervisor's job will benefit from this. Thanks!
John Gentile MS M(ASCP) john.gentile at med.va.gov
Laboratory Information, QA Manager
VA Medical Center
The contents of this message are mine personally and do not reflect any
position of the Government or VA.
> From: Glenn Montis <hmhgmontis at yahoo.com>
> Date: Wed, 13 Mar 2002 05:40:25 -0800 (PST)
> To: John Gentile <yjgent at cox.net>, microbio at hgmp.mrc.ac.uk> Subject: Re: Blood culture contam rate
>> If you are familiar with the program "Microsoft Excel"
> I have created a spreadsheet in that program to
> simplify the task of keeping track of blood culture
> stats (the file is attached to this email). In this
> spread sheet there is a "tab" for each month of the
> year. On each month, all you have to enter is: the
> total number of cultures performed, total positive
> cultures and total contaminants. The spreadsheet does
> the calculations, creates running totals for the year,
> adds the data to charts and more. It also allows
> tracking of individuals who perform blood culture
> draws and the percentage they contaminate. Hope this
> helps. If it works out for you, I have a few more
> spreadsheets designed for keeping other lab stats that
> you can give a try.
>> Glenn Montis
> Microbiology supervisor
> Hardin Memorial Hospital
>>> --- John Gentile <yjgent at cox.net> wrote:
>> I'm a little embarrassed to post this, but since
>> I've been out of the micro
>> lab for just about 2 years now I am realizing that
>> I'm losing my expertise
>> in the lab. :(
>>>> Our micro supervisor just retired and I've been
>> given the technical
>> oversight for the lab. I need to report to the IC
>> committee on the blood
>> culture contamination rate. I've collected the data
>> of which ones seem to be
>> contaminants, but I can't locate the formula to
>> calculate the rate.
>>>> I want to separate the numbers into total number of
>> cultures, total number
>> of true pos cultures and total number of
>> contaminated cultures. Is the
>> contam rate then the #of contam cult / # of total
>> cultures? Or is it the
>> number of contam cult / number of true pos?
>>>> Thanks for your help - I couldn't find it in the ASM
>> manual. I know I have
>> read about it recently, but just can't locate the
>> John Gentile President,
>> Rhode Island Apple Group
>>yjgent at cox.net RIAG Web page:
>> "I never make mistakes, I only have unexpected
>> learning opportunities!"
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!