patients

The heartrate of patients were measured at two different times. The healthy range let's say is 60-90, and some patients started with values higher, some started with lower ones. How / with which formula do I analyze how many percent of the patients have moved in a right (or wrong) direction...

Hi All, I am trying to calculate a count of the hours of the day patients are in our facility, So if a person is admitted at say: 04/01/2019 3:45:00 PM and discharged at 04/01/2019 5:30:00 PM, then that patient would be counted at the 3rd, 4th and 5th hour. I have created a spreadsheet that...

Hi All, I am trying to calculate a count of the hours of the day patients are in our facility, So if a person is admitted at say: 04/01/2019 3:45:00 PM and discharged at 04/01/2019 5:30:00 PM, then that patient would be counted at the 3rd, 4th and 5th hour. I have created a spreadsheet that...

Hi, I hope someone might be able to help me. I have a sheets named "Contact Details" and multiple sheets named "*** Patients" (Where *** could be any word or words). I need "Contact Details" to consolidate the data from the other sheets into one sheet based on the following criteria: IF sheet...

Hello all, I ll try to be concise; I have 2 sheets; one sheet have a table named BDc; this table have 3 fields [Nº], [Data da consulta], [Genótipo]; [Nº] have ID numbers of patients (there are duplicated ones); [Data da consulta] have dates of apointments; [Genótipo] have genotipic classes...

I have a list of patients, admit dates to our facility, and readmit dates to a different facility. Columns: Name/Date of Admit/Date of Transfer to another facility I can manually drag range - lets say A1 to A100 and Columns A to C but can't get pivot table to pick up an entire columns so...

Hey folks Are you able to customise or create your own icon sets in Excel 2013? Patients not assessed at baseline = 15 Patients not assessed at post intervention = 5 Need the 5 patients to have a green down arrow as in this case it is better. I've googled and searched the forum but can't...

Hello, I have a list of 5000 patients in column A. I have a form that i want the user to be able to enter patients name found in column A then in textbox 2 and 3 populate column B and C of that patient and also be able to add information on that current patient that he searched for Columns...

Hello, It is hard to explain, but I need to create a table, that says exact dates of some schecules. The patients that I discharged from hospital Needs to see me in 25 weeks later, but exactly that week's Tuesday. =Today()+175 this code not helps me because I discharge patient in different...

Hi, I'm helping a friend improve his patient list (He works for the National Health Service in the UK). He wants a 'view' of his patient list that only shows current patients (i.e. a second sheet with duplicate data, if the patient's discharge date is not set (blank)). The patient lists...

So here's my issue. I have a list of patients that have been admitted to a certain hospital unit over the last 6 months, and I have their admit date, as well as their total length of stay in hours. What I'd like to be able to do is create a pivot table where users can select a certain date to...

Hello everyone, I have a bit of a situation that I can't seem to be able to resolve. I'm currently using excel to keep track and sort 50 patients at the same time for research purposes. So in my main worksheet, A1:A50 are the patient's "station number" and B1:B50 are the patient's names. Columns...

Newbie question alert: I'm trying to do the following: I have a large set of patients and each one has a medical record (MR) number. At the end of every day I enter the names of the patients I saw that day into a spreadsheet, as well as their MR number. Each patient is entered on a new row every...

Hello, I have two worksheets in my workbook. The first sheet has a list of patients (all patients have unique identifiers i.e 123456 as their patient number) with all of their office visits listed. The second sheet is the same group of patients with all of their hospital discharge dates listed...