+ Reply to Thread
Results 1 to 4 of 4

Patient Tracking Spreadsheet

  1. #1
    Registered User
    Join Date
    07-25-2017
    Location
    Dhaka,Bangladesh
    MS-Off Ver
    2010
    Posts
    2

    Post Patient Tracking Spreadsheet

    Dear Concern,
    My brother Working in A village Located Rangpur,Bangladesh As Doctor.
    there some 9 village he give treatment for free.
    i need a help to create Spreadsheet where can track "Tika Dose Taken date" . Bellow information are:

    1. Every Dose have fixed day as (If someone birth Today he have to take 1st dose in 12 Days, 2nd dose maybe after 40 days, 3rd dose maybe after three months).
    Solution i need in Tika Spreadsheet tracking :
    1. date 27/07/2017 maybe birth 20 child, they have to give 1st dose in 12 Days, 2nd dose maybe after 40 days, 3rd dose maybe after three months.
    if Tika Dose taken by exact date the Patient name, id, will Indicate something as can blink, change the color. All data will track by Computer Real-time Date.
    2. If Dose given date over from , if DR. not write any status as YES/ NO, the Dose given date will change color

    Can you Please do the help to me, to Create the Patient Tracking Spreadsheet.
    I have attach a Sample Excel File

    Thanks
    S M Arif
    Attached Files Attached Files

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

    Re: Patient Tracking Spreadsheet

    It's not clear exactly what you expect.

    I changed the headings: E:G is Dose Scheduled Date, K:M is "Dose Given on"

    Dose Scheduled Date fills in automatically.
    E3 =IF(ISNUMBER(D3), DATE(YEAR(D3), MONTH(D3), DAY(D3)+11),"")
    F3 =IF(ISNUMBER(D3), DATE(YEAR(D3), MONTH(D3), DAY(D3)+39),"")
    G3 =IF(ISNUMBER(D3), DATE(YEAR(D3), MONTH(D3)+3, DAY(D3)),"")

    Dose Taken and Dose Given on cells are filled in Manually. You can modify H:J (Dose Taken) with Drop down menus (Yes/No) or even with a macro to double click to change to Yes or No.
    If you choose to use Macros, K:M can fill in automatically when you click "Yes" in Col H:J.

    Conditional Formatting to Change formatting in Dose Scheduled (Conditional Formatting >New Rule>Use Formula)
    Red w/ white font if dose is overdue
    =AND(ISNUMBER(E3), OR(H3=0,H3="No"), TODAY()>E3)

    Yellow background if dose was given but given late
    =AND(ISNUMBER(E3), H3="Yes", K3>E3)

    Green background if dose was given on time
    =AND(ISNUMBER(E3), H3="Yes", K3=E3)
    See attachment.
    Is that what you wanted?
    Attached Files Attached Files
    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

  3. #3
    Registered User
    Join Date
    07-25-2017
    Location
    Dhaka,Bangladesh
    MS-Off Ver
    2010
    Posts
    2
    Yes Thank you.
    But in the patient birth day cell, if 1st februaru birth 20 child, they all come together/ they have to take 1 dose. How do I manage those data. In this Execl I can manage 1 patient in 1 cell.how can manage those 1st February born 20 child in 1 cell?

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

    Re: Patient Tracking Spreadsheet

    Activate the filter on row 2.
    Select a cell in your data range, i.e. E16 and on the home tab of the ribbon find "Sort and Filter"
    Click on Filter on the dropdown and dropdown arrows will appear next to each item in row 2.
    Choose "Birth date" and un-select "Select All" and
    then drill down to whatever date you want. Only dates you select will appear in the table. Other rows will be hidden.
    In this attachment, I activated the filter for you.
    Attached Files Attached Files

+ 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. Stock Tracking Spreadsheet
    By LouisDel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2015, 04:21 AM
  2. Tracking changes in a spreadsheet
    By codigirl in forum Excel General
    Replies: 7
    Last Post: 06-26-2015, 08:31 AM
  3. Replies: 1
    Last Post: 04-30-2015, 12:19 AM
  4. Replies: 5
    Last Post: 04-28-2015, 10:38 PM
  5. Tracking review spreadsheet
    By tivory in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2013, 11:08 AM
  6. Tracking who accesses a spreadsheet
    By juamig in forum Excel General
    Replies: 1
    Last Post: 03-08-2006, 01:55 AM
  7. Tracking Spreadsheet
    By Tuttamay in forum Excel General
    Replies: 2
    Last Post: 01-21-2005, 10:36 AM

Tags for this Thread

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