Sheet#5, maybe you need to change the layout and make it pivot table to count the rescheduled due to code brown and the cancelled due to code brown + add the total and the percentage. May the table layout ready for the whole Oct. I need also a chart for

profileMichelle_Michy
attachment_23.xlsx
Home>Mathematics homework help>Statistics homework help>Sheet#5, maybe you need to change the layout and make it pivot table to count the rescheduled due to code brown and the cancelled due to code brown + add the total and the percentage. May the table layout ready for the whole Oct. I need also a chart for

Inpatient

Inpatient
Date Admissions Discharges Mortality LAMA Bed Occupancy Adj. Bed Occupancy
6-Oct 24 40 2 0 75% 82%
7-Oct 7 52 1 0 62% 69%
8-Oct 24 17 2 0 63% 69%
9-Oct 30 12 2 0 66% 73%
10-Oct 17 15 2 0 69% 76%
11-Oct 30 20 1 0 72% 79%
12-Oct
13-Oct
14-Oct
15-Oct
16-Oct
17-Oct
18-Oct
19-Oct
20-Oct
21-Oct
22-Oct
23-Oct
24-Oct
25-Oct
26-Oct
27-Oct
28-Oct
29-Oct
30-Oct
31-Oct
Total

OR

Operating Room Procedures
Date Done Cancelled
6-Oct 19 6
7-Oct 20 3
8-Oct 1 0
9-Oct 6 0
10-Oct 18 3
11-Oct 17 1
12-Oct
13-Oct
14-Oct
15-Oct
16-Oct
17-Oct
18-Oct
19-Oct
20-Oct
21-Oct
22-Oct
23-Oct
24-Oct
25-Oct
26-Oct
27-Oct
28-Oct
29-Oct
30-Oct
31-Oct
Total

OPD

Date Clinics Scheduled Seen Cancelled/No Show
6-Oct Adult Oncology Clinic 213 213
Transplant Clinic 313 313
Neuroscince Clinic 18 18
OPD 1 & 2 318 318
7-Oct Adult Oncology Clinic 193 193
Transplant Clinic 239 239
Neuroscince Clinic 22 22
OPD 1 & 2 277 277
8-Oct Adult Oncology Clinic
Transplant Clinic
Neuroscince Clinic
OPD 1 & 2
9-Oct Adult Oncology Clinic
Transplant Clinic
Neuroscince Clinic
OPD 1 & 2
10-Oct Adult Oncology Clinic 267 267
Transplant Clinic 414 414
Neuroscince Clinic 51 51
OPD 1 & 2 503 483 20
11-Oct Adult Oncology Clinic 234 234
Transplant Clinic 380 380
Neuroscince Clinic 44 44
OPD 1 & 2 538 528 10
12-Oct
13-Oct

DCD

Day Surgery Endoscopy Infusion
Date Done Cancelled No Show Date Done Cancelled No Show Date Done Cancelled No Show
6-Oct 12 0 0 6-Oct 19 0 0 6-Oct 22 0 0
7-Oct 12 0 1 7-Oct 11 0 0 7-Oct 23 0 0
8-Oct 0 0 0 8-Oct 2 0 0 8-Oct 14 0 0
9-Oct 3 0 0 9-Oct 0 0 0 9-Oct 11 0 0
10-Oct 6 1 0 10-Oct 8 2 4 10-Oct 20 0 2
11-Oct 6 0 0 11-Oct 16 0 0 11-Oct 22 1 2
12-Oct 12-Oct 12-Oct
13-Oct 13-Oct 13-Oct
14-Oct 14-Oct 14-Oct
15-Oct 15-Oct 15-Oct
16-Oct 16-Oct 16-Oct
17-Oct 17-Oct 17-Oct
18-Oct 18-Oct 18-Oct
19-Oct 19-Oct 19-Oct
20-Oct 20-Oct 20-Oct
21-Oct 21-Oct 21-Oct
22-Oct 22-Oct 22-Oct
23-Oct 23-Oct 23-Oct
24-Oct 24-Oct 24-Oct
25-Oct
26-Oct
27-Oct
28-Oct
29-Oct
30-Oct
31-Oct
Total

Allied Health (1)

Allied Health Services Radiology Respiratory Therapy Medical Nutrition Physical Therapy Cardica Lab Socail Work Radiation Therapy
Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show Date Schedulled Seen Cancelled Rescheduled No show
6-Oct 0 0 0 0 0 6-Oct 0 6-Oct 0 6-Oct 0 6-Oct 0 6-Oct 0 6-Oct 0 6-Oct 0
7-Oct 0 0 0 0 0 7-Oct 0 7-Oct 0 7-Oct 0 7-Oct 0 7-Oct 0 7-Oct 0 7-Oct 0
8-Oct 0 0 0 0 0 8-Oct 0 8-Oct 0 8-Oct 0 8-Oct 0 8-Oct 0 8-Oct 0 8-Oct 0
9-Oct 0 0 0 0 0 9-Oct 0 9-Oct 0 9-Oct 0 9-Oct 0 9-Oct 0 9-Oct 0 9-Oct 0
10-Oct 426 278 7 74 67 10-Oct 202 97 1 73 31 10-Oct 10 6 0 0 4 10-Oct 35 18 0 0 17 10-Oct 63 47 0 1 15 10-Oct 35 35 0 0 0 10-Oct 11 8 3 0 0 10-Oct 70 67 3 0 0
11-Oct 0 0 0 0 0 11-Oct 0 11-Oct 0 11-Oct 0 11-Oct 0 11-Oct 0 11-Oct 0 11-Oct 0
12-Oct 0 0 0 0 0 12-Oct 0 12-Oct 0 12-Oct 0 12-Oct 0 12-Oct 0 12-Oct 0 12-Oct 0
13-Oct 0 0 0 0 0 13-Oct 0 13-Oct 0 13-Oct 0 13-Oct 0 13-Oct 0 13-Oct 0 13-Oct 0
14-Oct 0 0 0 0 0 14-Oct 0 14-Oct 0 14-Oct 0 14-Oct 0 14-Oct 0 14-Oct 0 14-Oct 0
15-Oct 0 0 0 0 0 15-Oct 0 15-Oct 0 15-Oct 0 15-Oct 0 15-Oct 0 15-Oct 0 15-Oct 0
16-Oct 0 0 0 0 0 16-Oct 0 16-Oct 0 16-Oct 0 16-Oct 0 16-Oct 0 16-Oct 0 16-Oct 0
17-Oct 0 0 0 0 0 17-Oct 0 17-Oct 0 17-Oct 0 17-Oct 0 17-Oct 0 17-Oct 0 17-Oct 0
18-Oct 0 0 0 0 0 18-Oct 0 18-Oct 0 18-Oct 0 18-Oct 0 18-Oct 0 18-Oct 0 18-Oct 0
19-Oct 0 0 0 0 0 19-Oct 0 19-Oct 0 19-Oct 0 19-Oct 0 19-Oct 0 19-Oct 0 19-Oct 0
20-Oct 0 0 0 0 0 20-Oct 0 20-Oct 0 20-Oct 0 20-Oct 0 20-Oct 0 20-Oct 0 20-Oct 0
21-Oct 0 0 0 0 0 21-Oct 0 21-Oct 0 21-Oct 0 21-Oct 0 21-Oct 0 21-Oct 0 21-Oct 0
22-Oct 0 0 0 0 0 22-Oct 0 22-Oct 0 22-Oct 0 22-Oct 0 22-Oct 0 22-Oct 0 22-Oct 0
23-Oct 0 0 0 0 0 23-Oct 0 23-Oct 0 23-Oct 0 23-Oct 0 23-Oct 0 23-Oct 0 23-Oct 0
24-Oct 0 0 0 0 0 24-Oct 0 24-Oct 0 24-Oct 0 24-Oct 0 24-Oct 0 24-Oct 0 24-Oct 0
25-Oct 0 0 0 0 0 25-Oct 0 25-Oct 0 25-Oct 0 25-Oct 0 25-Oct 0 25-Oct 0 25-Oct 0
26-Oct 0 0 0 0 0 26-Oct 0 26-Oct 0 26-Oct 0 26-Oct 0 26-Oct 0 26-Oct 0 26-Oct 0
27-Oct 0 0 0 0 0 27-Oct 0 27-Oct 0 27-Oct 0 27-Oct 0 27-Oct 0 27-Oct 0 27-Oct 0
28-Oct 0 0 0 0 0 28-Oct 0 28-Oct 0 28-Oct 0 28-Oct 0 28-Oct 0 28-Oct 0 28-Oct 0

Allied Health

Allied Health Services
Date Department Scheduled Seen Rescheduled No show Cancelled Reason of Cancellation
10-Oct Radiology 202 97 73 31 1
CT 47 25 18 4 0
MRI 28 10 1 16 1
Fluoroscopy 4 2 1 1 0
X-Ray 31 31 0 0 0
US 41 9 32 0 0
NM 21 16 1 4 0
BIU 23 1 16 6 0
IR 7 3 4 0 0
Respiratory Therapy 10 6 0 4 0
PFT 5 3 0 2 0
Sleep Lab 3 1 0 2 0
Respiratory 2 2 0 0 0
Medical Nutrition 35 18 0 17 0
Physical Therapy 63 47 1 15 0
PT 48 35 0 13
OT 15 12 1 2
Cardiac Lab 35 35 0 0 0
Cath Lab 0 0 0 0 0
Adult Echo 23 23 0 0 0
Pediatric Echo 2 2 0 0 0
Device Clinic 0 0 0 0 0
ECG 6 6 0 0 0
BP 0 0 0 0 0
Holter 2 2 0 0 0
DSE 2 2 0 0 0
ESE 0 0 0 0 0
Social Work 11 8 0 0 3
Radiation Therapy 70 67 0 0 3
Emergency Technical Services 0 0 0 0 0
TOTAL 426 278 74 67 7
% 65% 17% 16% 2%
11-Oct Radiology 230 146 62 21 1
CT 53 32 16 5 0
MRI 21 14 4 3 0 Code brown
Fluoroscopy 4 1 2 0 1 Per patient request
X-Ray 36 36 0 0 0
US 54 20 24 10 0
NM 26 19 4 3 0 Not related to Code brown
BIU 27 15 12 0 0
IR 9 9 0 0 0
Respiratory Therapy 10 8 0 2 0
PFT 5 5 0 0 0
Sleep Lab 3 1 0 2 0
Respiratory 2 2 0 0 0
Medical Nutrition 28 16 0 12 0
Physical Therapy 76 53 0 18 5
PT 66 47 0 16 3 Per patient request
OT 10 6 0 2 2 Per patient request
Cardiac Lab 50 39 0 11 0
Cath Lab 2 2 0 0 0
Adult Echo 28 17 0 11 0
Pediatric Echo 1 1 0 0 0
Device Clinic 2 2 0 0 0
ECG 12 12 0 0 0
BP 2 2 0 0 0
Holter 2 2 0 0 0
DSE
ESE 1 1 0 0 0
Social Work 2 2 0 0 0
Radiation Therapy 57 55 0 0 2 Patient on break as doctor request for clinical condition and other one as per doctor plan needs time to be ready by next week.
Emergency Technical Services 11 9 0 0 2
TOTAL 464 328 62 64 10
% 71% 13% 14% 2%

ER

ER
Date Visits
6-Oct 75
7-Oct 72
8-Oct 84
9-Oct 100
10-Oct 82
11-Oct 92
12-Oct
13-Oct
14-Oct
15-Oct
16-Oct
17-Oct
18-Oct
19-Oct
20-Oct
21-Oct
22-Oct
23-Oct
24-Oct

All Data in one sheet

Date 10/6/21 10/7/21 10/8/21 10/9/21 10/10/21 10/11/21 10/12/21 10/13/21 10/14/21 10/15/21 10/16/21 10/17/21 10/18/21
Admissions 24 7 24 30 17 30
Discharges 40 52 17 12 15 20
Mortality 2 1 2 2 2 1
LAMA 0 0 0 0 0 0
Bed Occupancy 75% 62% 63% 66% 69% 72%
Adj. Bed Occupancy 82% 69% 69% 73% 76% 79%
Operating Room Procedures
Done 19 20 1 6 18 17
Cancelled 6 3 0 0 3 1
Day Surgery
Done 12 12 0 3 6 6
Cancelled 0 0 0 0 1 0
No Show 0 1 0 0 0 0
Endoscopy
Done 19 11 2 0 8 16
Cancelled 0 0 0 0 2 0
No Show 0 0 0 0 4 0
Infusion
Done 22 23 14 11 20 22
Cancelled 0 0 0 0 0 1
No Show 0 0 0 0 2 2

Sheet4

Row Labels Rescheduled Due to Code Brown Cancelled Due to Code Brown
10/10/21 222 15
% 0 0
Cardiac Lab 0 0
Emergency Technical Services 0 0
Medical Nutrition 0 0
Physical Therapy 1 0
Radiation Therapy 0 3
Radiology 73 1
Respiratory Therapy 0 0
Social Work 0 3
TOTAL 74 7
(blank) 74 1
10/11/21 124 16
Cardiac Lab 0 0
Emergency Technical Services 0 2
Medical Nutrition 0 0
Physical Therapy 0 5
Radiation Therapy 0 2
Radiology 62 1
Respiratory Therapy 0 0
Social Work 0 0
(blank) 62 6
(blank) 62 10
% 0 0
TOTAL 62 10
Grand Total 408 41

Sheet5

Date Department Rescheduled Due to Code Brown Cancelled Due to Code Brown
10/6/21 Radiology
10/6/21 CT
10/6/21 MRI
10/6/21 Fluoroscopy
10/6/21 X-Ray
10/6/21 US
10/6/21 NM
10/6/21 BIU
10/6/21 IR
10/6/21 Respiratory Therapy
10/6/21 PFT
10/6/21 Sleep Lab
10/6/21 Respiratory
10/6/21 Medical Nutrition
10/6/21 Physical Therapy
10/6/21 PT
10/6/21 OT
10/6/21 Cardiac Lab
10/6/21 Cath Lab
10/6/21 Adult Echo
10/6/21 Pediatric Echo
10/6/21 Device Clinic
10/6/21 ECG
10/6/21 BP
10/6/21 Holter
10/6/21 DSE
10/6/21 ESE
10/6/21 Social Work
10/6/21 Radiation Therapy
10/6/21 Emergency Technical Services
10/7/21 Radiology
10/7/21 CT
10/7/21 MRI
10/7/21 Fluoroscopy
10/7/21 X-Ray
10/7/21 US
10/7/21 NM
10/7/21 BIU
10/7/21 IR
10/7/21 Respiratory Therapy
10/7/21 PFT
10/7/21 Sleep Lab
10/7/21 Respiratory
10/7/21 Medical Nutrition
10/7/21 Physical Therapy
10/7/21 PT
10/7/21 OT
10/7/21 Cardiac Lab
10/7/21 Cath Lab
10/7/21 Adult Echo
10/7/21 Pediatric Echo
10/7/21 Device Clinic
10/7/21 ECG
10/7/21 BP
10/7/21 Holter
10/7/21 DSE
10/7/21 ESE
10/7/21 Social Work
10/7/21 Radiation Therapy
10/7/21 Emergency Technical Services
10/10/21 Radiology
10/10/21 CT
10/10/21 MRI
10/10/21 Fluoroscopy
10/10/21 X-Ray
10/10/21 US
10/10/21 NM
10/10/21 BIU
10/10/21 IR
10/10/21 Respiratory Therapy
10/10/21 PFT
10/10/21 Sleep Lab
10/10/21 Respiratory
10/10/21 Medical Nutrition
10/10/21 Physical Therapy
10/10/21 PT
10/10/21 OT
10/10/21 Cardiac Lab
10/10/21 Cath Lab
10/10/21 Adult Echo
10/10/21 Pediatric Echo
10/10/21 Device Clinic
10/10/21 ECG
10/10/21 BP
10/10/21 Holter
10/10/21 DSE
10/10/21 ESE
10/10/21 Social Work
10/10/21 Radiation Therapy
10/10/21 Emergency Technical Services
10/11/21 Radiology
10/11/21 CT
10/11/21 MRI
10/11/21 Fluoroscopy
10/11/21 X-Ray
10/11/21 US
10/11/21 NM
10/11/21 BIU
10/11/21 IR
10/11/21 Respiratory Therapy
10/11/21 PFT
10/11/21 Sleep Lab
10/11/21 Respiratory
10/11/21 Medical Nutrition
10/11/21 Physical Therapy
10/11/21 PT
10/11/21 OT
10/11/21 Cardiac Lab
10/11/21 Cath Lab
10/11/21 Adult Echo
10/11/21 Pediatric Echo
10/11/21 Device Clinic
10/11/21 ECG
10/11/21 BP
10/11/21 Holter
10/11/21 DSE
10/11/21 ESE
10/11/21 Social Work
10/11/21 Radiation Therapy
10/11/21 Emergency Technical Services
10/12/21 Radiology
10/12/21 CT
10/12/21 MRI
10/12/21 Fluoroscopy
10/12/21 X-Ray
10/12/21 US
10/12/21 NM
10/12/21 BIU
10/12/21 IR
10/12/21 Respiratory Therapy
10/12/21 PFT
10/12/21 Sleep Lab
10/12/21 Respiratory
10/12/21 Medical Nutrition
10/12/21 Physical Therapy
10/12/21 PT
10/12/21 OT
10/12/21 Cardiac Lab
10/12/21 Cath Lab
10/12/21 Adult Echo
10/12/21 Pediatric Echo
10/12/21 Device Clinic
10/12/21 ECG
10/12/21 BP
10/12/21 Holter
10/12/21 DSE
10/12/21 ESE
10/12/21 Social Work
10/12/21 Radiation Therapy
10/12/21 Emergency Technical Services