If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Audits
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 |
#2
|
|||
|
|||
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. --------- Message sent via www.excelforums.com |
#3
|
|||
|
|||
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 "intelgio - ExcelForums.com" wrote in message ... 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. --------- Message sent via www.excelforums.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date function | Denise Ch'ng | Worksheet Functions | 1 | October 1st, 2003 02:07 AM |