Audits

[LMB]

Hi Everyone,

I am using Excel 2000 and am a beginner. We are going to be doing some QI testing for our department in our hospital. We will be looking at tracking a few things. The most important is to track which therapists take the most time to start treatments and also get a general idea of how long it takes to start treatments once they are ordered in general. Another thing I can see from this is we could also track which floors are taking too much time from the time the order was written to the time it was received on our fax machine. Additional questions are in parentheses.

Here are the column headers except for the items in quotes.

"Type of Therapy"

Time Order Written
Time Fax Received
Time therapy Instructed/Started
Therapist Name

(What is the best way to format the time cells so we can calculate in minutes and/or hours the difference?)

"Order Types"

Aerosol Treatment
Order Set
MDI Instruction

(I think I need to make a yes no field for these items and a patient can be on more than one but I'm not quite sure how this works or how to set it up)

Thanks,
Linda

 

[intelgio - ExcelForums.com]

I know that you are posting this question in an Excel Forum. Have yo
considered using Access as an alternative. The reason I am askin
this is because I have come across some great Excel spreadsheets bu
the moment you would like to have something more come out of th
information that has been captured, it can be VERY time consuming

An Access Database will supply you with the ability to run various
queries against your data that you can export to Excel and do furthe
analysis

 

[LMB]

I could make a database but this would be quicker and we are only keeping track for a very short time. I kind of wanted to learn a few of features excel had to offer in data collection. Also, Access has a huge learning curve for others that will be using it.

Linda

I know that you are posting this question in an Excel Forum. Have you
considered using Access as an alternative. The reason I am asking
this is because I have come across some great Excel spreadsheets but
the moment you would like to have something more come out of the
information that has been captured, it can be VERY time consuming!

An Access Database will supply you with the ability to run variouse
queries against your data that you can export to Excel and do further
analysis.