Results 1 to 2 of 2

Help setting up some formulas for a spreadsheet of daily data reports...

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    CT,USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Help setting up some formulas for a spreadsheet of daily data reports...

    Good Evening!

    I have a project where the main goal is to summarize / analyze certain characteristics of medication use within in a healthcare facility.

    For data, I have been given a number of individual daily medication use reports in Excel file format (e.g., 30 separate excel files for each day of a given month).

    So far, I have batch-combined these into one spreadsheet...I have uploaded a simplified mock version to represent what the dataset currently looks like (The "real" report has 15 columns of data).


    Now, I would like to determine the following from this database (in the most efficient way possible!):

    1-Determine the # of days of CONSECUTIVE use of the medication for each individual patient in the database (the “duration of treatment”). *Note that there will be many, many patients in the real database (100+)...each with a unique numerical identifier

    2-Determine the total number of patients who received the medication based on certain qualifiers (e.g., "in a certain location of the facility", "during a certain given week, month, etc."). *Note that there will be no more than 8 unique location options)

    3-Provide summary characteristics for the medication use in the facility, such as:
    --mean/median duration of treatment, etc.
    --the # of patients who received more than “x” consecutive days of therapy
    --the # of patients who received a certain dose (note that there will be a limited number (<5) of possible doses)


    I know from doing some quick searches of the forum so far that these types of things CAN be done fairly efficiently on a dataset like what I’m getting through use of some of the more complicated Excel formula functions...BUT many of these I’m not yet 100% comfortable developing/using yet...thus my post!

    So, I’d welcome any and all advice on how to sort my data, transform it [if needed], set up some formulas, etc to do my task without wasting huge amounts of time...

    Thanks in advance for all help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Loading data into master sheet using daily reports
    By KOneemen in forum Excel General
    Replies: 5
    Last Post: 10-01-2013, 12:33 AM
  2. Help with setting up formulas for spreadsheet
    By asoe209 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2013, 10:47 PM
  3. Turning Daily Reports into Monthly Reports
    By jambezi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2009, 05:31 PM
  4. [SOLVED] How to import data from daily reports (excel) into excel database
    By Import data from excel to excel in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 11:25 AM
  5. spreadsheet for tracking reports daily, monthly, yearly and graph
    By Kompare in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2006, 04:30 PM

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