Fluent Essays

helloI need comments on each clinic in each sheet in 2019 Report. Then I need comparison between 2018 & 2019 for each clinic and the overall at the end by graphs. In 2019 you will find KPI#6 blank, kindly make summary from the Average Calorie Intake excel file; the target is 85\%. I need to show the average calorie intake for each patient monthly.NOTE: for KPI#1&2 the target is 30 minutes and for KPI#3 the target is 60 days. mnt_kpis_report_2019.xlsx mnt_kpis_report_2018.xlsx average_calorie_intake_in_picu_audit.xlsx Unformatted Attachment Preview 1. Patient Waiting Time to be Seen by Clinical Dietitian in the Specialized Nutrition Clinics AVG of Wait Time (time b/w arrival & Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total visit start in minutes) 6.67 -9 10.1 11.21 9.07 4.2 30.88 -5.85 11.89 9.16 40.6635 7.833 visit start in minutes) 44.14 45.47 35.38 44.33 47.31 28.27 47.56 48.36 28.67 43.53 34.26 59.24 visit start in minutes) 21.63 25.32 30.32 42.79 30.78 54.1 46.59 34.56 26.81 43.81 34.5 42.61 45 42.08 40 30.8831.71 26.7 30 20 11.21 10.1 6.67 10 30.21 11.89 9.07 9.16 4.2 0 -10 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT -5.85 -9 NOV AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) DEC General Nutriton Clinic Mon. a.m. AVG of Late Time (time b/w appt time & visit start in minutes) 23.73 12.42 4.57 -0.14 18.75 29.18 16 21.78 5.13 -18 0.73 15.44 40.2 35.9 32.5 59.24 60 50 44.14 45.47 44.33 40 30 47.56 47.31 48.36 43.53 35.38 34.26 29.18 28.27 28.67 23.73 21.78 18.75 20 16 12.42 10 15.44 5.13 4.57 0.73 0 JAN FEB MAR APR MAY -0.14 -10 JUN JUL AUG SEP OCT NOV -18 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) 9.78 15.09 13.22 24.67 2.11 -1.7 9.54 1.78 -0.375 18.42 10.42 15.3 General Nutriton Clinic Tues. a.m. 60 54.1 50 40 30 20 46.59 42.79 21.63 25.32 30.32 15.09 9.78 43.81 34.56 30.78 24.67 2.11 26.81 13.22 10.42 18.42 10 (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) JAN FEB MAR APR MAY JUN -1.7JUL AUG 1.78 -0.375 SEP OCT AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) General Nutriton Clinic Wed. p.m. 40 15.3 9.54 0 -10 42.61 34.5 36.151667 9.854583 AVG of Wait Time Month 50.625 50 -20 (time b/w arrival & Total AVG 60 42.21 10.79917 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 71.71 70 45 50.625 26.7 32.5 42.08 35.9 71.71 31.71 30.21 40.2 (time b/w arrival & Total AVG (time b/w appt time & visit start in minutes) 80 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Nutriton Clinic Sun. p.m AVG of Late Time 39.04 37.91 NOV DEC DEC 39.04 40 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total AVG 14.36 20.89 19.95 19.14 19.82 28.58 39.04 22.33 26.88 37.91 30.47 16.95 -13 -6.38 -14.75 -12.09 -17.47 8.67 -10.75 -27.89 -1.25 -11.5 -23.57 -8.48 24.693333 -11.5383 AVG of Wait Time (time b/w arrival & Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total AVG visit start in minutes) 61.83 62.75 47.16 95.64 35.09 75.13 32.33 40.4 28.25 54.41 20.11 61.82 51.243333 (time b/w arrival & Total AVG visit start in minutes) 36 44.18 46.4 44.75 6.13 49.57 24.42 34.4 13.06 20.36 45.31 19 -10.34 -11 -15.16 -8.5 8.81 -19.25 -30.76 -42.67 -14.82 -32.54 -49.84 -26.71 -21.065 19.14 19.82 16.95 8.67 10 0 JAN FEB MAR -10 -20 APR -6.38 MAY JUN JUL AUG SEP -1.25 OCT -10.75 -12.09 -14.75 -13 NOV (time b/w appt time & visit start in minutes) 8.8 23.27 11.067 -6.31 12.875 -3 14.67 -30 2 0.09 4.15 187 (time b/w arrival & visit start in minutes) -8.48 -11.5 -17.47 -23.57 AVG of Wait Time -27.89 (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Adult Transplant Nutriton Clinic 95.64 100 75.13 80 61.83 62.75 61.82 54.41 60 47.16 40.4 35.09 40 32.33 28.25 20.11 20 8.81 0 -20 JAN FEB MAR APR MAY -8.5 -10.34 -11 -15.16 JUN JUL AUG SEP OCT NOV 53.67 72.06 71.04 78.92 35.86 58.3 71.95 79.35 -10.67 15.52 -11.5 14.83 40.28 -15.1 -4.28 1.82 DEC -14.82 -19.25 -30.76 -40 -26.71 -32.54 -49.84 -60 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Pediatric Transplant Nutriton Clinic 200 187 150 100 50 46.4 44.18 36 8.8 23.27 0 JAN FEB MAR 49.57 44.75 11.067 6.13 APR 45.31 24.42 14.67 34.4 13.06 12.875 MAY -6.31 JUN -3 20.36 19 0.09 4.15 2 JUL -50 AUG SEP OCT NOV DEC -30 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Oncology Nutriton Clinic Sun.a.m. AVG of Late Time (time b/w appt time & visit start in minutes) DEC -30 AVG of Late Time 31.965 18.71767 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug 19.95 -42.67 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 20.89 26.88 22.33 14.36 AVG of Late Time (time b/w appt time & visit start in minutes) 30.47 28.58 30 20 37.91 79.35 78.92 80 72.06 71.95 71.04 70 60 60.44 58.3 53.67 52.88 50 40.28 35.86 40 37.53 39.67 30 20 15.52 14.83 17.11 Sep Oct Nov Dec Total AVG 37.53 52.88 39.67 60.44 59.305833 3.461667 visit start in minutes) 42.538333 26.32 JAN FEB MAR APR MAY JUN JUL -4.28 1.82 SEP AUG OCT NOV DEC -2 -12.15 -11.5 -15.1 -20 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Oncology Nutriton Clinic Mon. a.m. 60 50 45.67 43.22 40 31.43 32.32 30.3 27.34 30 20 20.59 18.95 30.83 26.86 20.15 11.78 7.83 10 0 visit start in minutes) 16.2 13.15 13.09 6.64 9.6 3.4 13.4 5.3 4.7 13.13 9.67 12.83 JAN FEB MAR APR 0.8 -0.69 25.81 9 -4.3 -1 -6.4 -18.6 -0.3 -9.4 21.2 8.67 JUN JUL AUG SEP OCT NOV (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) DEC Ketogenic Diet Clinic Mon. AVG of Late Time (time b/w appt time & visit start in minutes) MAY AVG of Wait Time 30 25.81 25 20 21.2 16.2 13.15 15 5 13.4 13.09 9 10 13.13 6.64 3.4 JAN -0.69 FEB MAR APR -5 MAY JUN-1 -4.3 JUL 8.67 4.7 5.3 0.8 0 12.83 9.67 9.6 AUG SEP -0.3 OCT NOV DEC -6.4 -10 -9.4 -15 10.0925 2.065833 AVG of Wait Time (time b/w arrival & Month Jan Feb Mar Apr May (time b/w appt time & visit start in minutes) 18.95 43.22 20.59 20.15 30.3 45.67 27.34 11.78 26.86 32.32 30.83 7.83 (time b/w arrival & Total AVG 7.68 0 AVG of Late Time 31.43 35.59 45.64 33.63 45.54 58.28 41.63 46.86 33.62 53.4 48.67 36.17 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 17.11 14.83 10 -10.67 (time b/w arrival & Total AVG 15.52 20 -10 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec -12.15 -2 17.11 7.68 visit start in minutes) 17.47 24.61 24.6 17.925 14.36 -20 -18.6 5.61 1.33 5.22 9.875 7.21 (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) General Pediatrics Nutrition Clinic AVG of Late Time (time b/w appt time & visit start in minutes) AVG of Wait Time 30 28.08 24.61 25 20 15 17.47 25.77 24.6 23.28 17.925 23.34 22.1 20.78 17.17 14.36 14.36 15 Jun Jul Aug Sep Oct Nov Dec Total AVG 23.28 28.08 22.1 17.17 25.77 20.78 23.34 21.62375 3.640167 AVG of Wait Time (time b/w arrival & Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total AVG visit start in minutes) 15.94 15.67 9.28 14 10.33 17.8 29.75 18 21.33 19.25 14.11 26.9 (time b/w arrival & Total AVG visit start in minutes) 34 25.8 28.625 21.83 26.42 32 13.9 18.14 43.22 23.33 26.375 17.33 25.914167 9.875 (time b/w appt time & visit start in minutes) 9.83 7.53 67.13 53.19 0.11 27 24.43 6.9 -14.78 0.83 5 25.3 7.21 5.61 -12.67 8.4 -53.375 -44.67 -59.71 -40 -95 -109.43 -56.89 -93.67 -4.5 -69.78 -52.6079 6.22 5.22 5 1.57 1.33 1.017 1.67 0 JAN FEB MAR APR MAY JUN JUL AUG -1.39 SEP OCT NOV DEC -3.28 -5 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Pediatrics Diabetic Nutrition Clinic 67.13 70 60 53.19 50 40 29.7527 24.43 30 20 15.94 15.67 14.11 14 10.33 6.9 7.53 9.28 0 JAN FEB 26.9 25.3 19.25 21.33 18 17.8 9.83 10 MAR 5 0.83 0.11 APR MAY JUN JUL AUG SEP OCT NOV DEC -10 -14.78 -20 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Pediatrics Oncology Nutrition Clinic AVG of Late Time (time b/w appt time & visit start in minutes) 8.63 10 AVG of Late Time 17.696667 17.70583 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1.57 6.22 -1.39 -3.28 1.017 1.67 8.63 60 43.22 40 34 28.625 25.8 20 21.83 32 26.42 13.9 8.4 23.33 26.375 18.14 17.33 0 JAN -20 FEB MAR APR MAY JUN JUL AUG SEP OCT NOV -4.5 DEC -12.67 -40 -40 -44.67 -60 -53.375 -56.89 -59.71 -69.78 -80 -100 -93.67 -95 -109.43 -120 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) AVG of Wait Time (time b/w arrival & Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total AVG visit start in minutes) -5.5 38.6 6.25 38.6 40 35 30 25 20 15 10 6.25 5 0 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC -5 41.3 (time b/w arrival & Total AVG 44 45 (time b/w appt time & visit start in minutes) 44 AVG of Wait Time Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cardiac Rehab Nutrition Clinic AVG of Late Time visit start in minutes) 32.5 10.5 16.5 19.4 21.75 20.25 29 6.67 8.8 18.67 32.67 13.56 -5.5 -10 0.375 -10.25 -11.5 -2 2.6 18.5 -9 2.67 5.67 4.4 4.67 0.5 6.11 (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) Body Composition Analysis Clinic AVG of Late Time (time b/w appt time & visit start in minutes) AVG of Wait Time 35 32.67 32.5 29 30 25 21.75 20 19.4 20.25 18.67 18.5 16.5 13.56 15 10.5 8.8 10 6.67 5.67 5 4.4 6.11 4.67 2.67 2.6 0.5 19.189167 1.030833 0 JAN FEB MAR -2 APR MAY JUN JUL AUG SEP OCT NOV DEC -5 -10 -10.25 -9 -11.5 -15 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec AVG of Wait AVG of Late Time in Time in Nutriton Nutriton Clinics Clinics 31.36 3.61 34.18 8.79 35.63 4.83 38.15 6.76 25.6 6.28 40.96 3.68 37.97 2.6 35.18 -9.11 28.25 -0.21 35.011 -2.75 29.16 1.96 37.85 9.04 AVG of Wait Time (time b/w arrival & visit start in minutes) AVG of Late Time (time b/w appt time & visit start in minutes) AVG of Wait time & Late Time in Nutrition Clinics 2019 50 40.96 38.15 40 34.18 37.97 35.63 37.85 35.18 35.011 31.36 28.25 30 29.16 25.6 20 10 8.79 9.04 Total AVG 9.04 8.79 10 34.108417 2.956667 4.83 3.61 6.76 6.28 3.68 1.96 2.6 0 JAN FEB MAR APR MAY -10 JUN JUL AUG SEP NOV -0.21 OCT -2.75 -9.11 AVG of Wait Time in Nutriton Clinics AVG of Late Time in Nutriton Clinics DEC 2. Out-patient No Show Rate in the Specialized Nutrition Clinics 60\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL General Nutriton Clinic, Sun. p.m. No Show General Nutriton Clinic, Mon.a.m. 0\% 43\% 25\% 46\% 44\% 47\% 54\% 59\% 39\% 32\% 39\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL General Nutriton Clinic, Mon.p.m No Show 32\% 44\% 39\% 53\% 38\% General Nutriton 48\% Clinic, Mon.a.m. 23\% 46\% 51\% 51\% 43\% 48\% 43\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL General Nutriton Clinic, Wed.a.m. No Show 47\% 34\% 38\% 38\% 53\% General Nutriton 31\% Clinic, Tues. a.m. 42\% 50\% 38\% 28\% 38\% 36\% 39\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL General Nutriton Clinic, Wed.p.m. No Show 44\% 40\% 45\% 38\% 30\% General Nutriton 33\% Clinic, Wed.p.m. 44\% 57\% 50\% 33\% 41\% 39\% 41\% 50\% 40\% No Show 30\% 54\% 46\% 44\% 47\% 43\% 20\% 59\% General Nutriton Clinic, Sun. p.m. 39\% 32\% 25\% 10\% 0\% 0\% 60\% 50\% 40\% No Show 30\% 53\% 44\% 20\% 39\% 48\% 46\% 51\% 51\% 43\% 38\% 32\% 48\% General Nutriton Clinic, Mon.p.m 23\% 10\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 60\% 50\% 40\% No Show 30\% 53\% 47\% 20\% 34\% 50\% 42\% 38\% 38\% 38\% 31\% 38\% 36\% General Nutriton Clinic, Wed.a.m. 28\% 10\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 60\% 50\% 40\% No Show 30\% 20\% 57\% 44\% 40\% 45\% 44\% 38\% 30\% 33\% 50\% 33\% 41\% 39\% 10\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Nutriton Clinic, Wed.p.m. Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Ketogenic Diet Clinic, Mon Ketogenic Diet Clinic, Mon No Show 44\% 8\% 21\% 13\% 9\% 17\% 21\% 23\% 9\% 12\% 13\% 8\% 16\% 40\% No Show 30\% 47\% 20\% 50\% 49\% 52\% 46\% 45\% 44\% 38\% 35\% Oncology Nutrition Clinic, Sun. 35\% 23\% 10\% Dec Oct Nov Sep Jul Aug Jun Apr May Feb 0\% 50\% 45\% 40\% 35\% 30\% 25\% 20\% 15\% 34\% 35\% 39\% No Show 48\% 45\% 40\% 38\% 36\% 24\% 23\% 10\% Oncology Nutrition Clinic, Mon 28\% 29\% 5\% Dec Nov Oct Sep Aug Jul Jun May Mar Apr 0\% 45\% 40\% 35\% 30\% 25\% No Show 44\% 20\% Ketogenic Diet Clinic, Mon 15\% 21\% 10\% 13\% 5\% 8\% 17\% 21\% 23\% 9\% 9\% 12\% 13\% 8\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 50\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL General Pediatric Nutrition Clinic, Sun No Show 39\% 31\% 48\% 28\% 45\% General Pediatric 43\% Nutrition Clinic, 33\% Sun 39\% 35\% 19\% 38\% 43\% 37\% 50\% Month Jan General Pediatric Nutrition Clinic, Wed. No Show 37\% General Pediatric Nutrition Clinic, Tues. 52\% Mar Oncology Nutrition Clinic, Mon No Show 34\% 35\% 39\% 23\% 45\% Oncology Nutrition 38\% Clinic, Wed. 36\% 48\% 24\% 28\% 29\% 40\% 35\% 50\% Feb Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL 60\% Jan Oncology Nutrition Clinic, Sun. No Show 47\% 52\% 38\% 35\% 50\% Oncology Nutrition 23\% Clinic, Sun. 44\% 35\% 49\% 52\% 46\% 45\% 43\% Jan Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL 45\% 40\% 35\% No Show 30\% 25\% 20\% 15\% 10\% 48\% 45\% 43\% 39\% 31\% 28\% 39\% 33\% 38\% 35\% 43\% 19\% 5\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 45\% 40\% 35\% General Pediatric Nutrition Clinic, Sun Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL General Pediatric Nutrition Clinic, Tues. 25\% 29\% 39\% 47\% 4\% 26\% 39\% 37\% 14\% 43\% 34\% 31\% 35\% No Show 30\% 25\% 20\% 15\% 47\% 39\% 37\% 25\% 29\% 0\% 34\% 26\% 10\% 5\% 43\% 39\% 37\% 14\% 4\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec General Pediatric Nutrition Clinic, Wed. Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Oncology Pediatric Nutrition Clinic, Mon. No Show 36\% 0\% 22\% 20\% 30\% Oncology Pediatric 37\% Nutrition Clinic, 0\% Mon. 25\% 27\% 22\% 31\% 36\% 24\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Pediatric Diabetic Nutrition Clinic, Thur. No Show 29\% 16\% 28\% 26\% 37\% Pediatric Diabetic 44\% Nutrition Clinic, 22\% Thur. 45\% 27\% 33\% 17\% 41\% 30\% 35\% 30\% 25\% 20\% No Show 37\% 36\% 36\% 30\% 15\% 25\% 27\% 22\% 20\% 10\% 31\% Oncology Pediatric Nutrition Clinic, Mon. 22\% 5\% 0\% 0\% 0\% 45\% 40\% 35\% 30\% No Show 25\% 20\% 15\% 45\% 44\% 41\% 37\% 29\% 10\% 28\% 26\% 33\% 22\% 27\% Pediatric Diabetic Nutrition Clinic, Thur. 17\% 16\% 5\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 100\% No Show 50\% 100\% 75\% 90\% 80\% 70\% 60\% No Show 100\% 50\% Cardiac Rehab Nutrition Clinic, Tues. 40\% 30\% 20\% Cardiac Rehab Nutrition Clinic, Wed. 75\% 50\% 10\% 75\% Dec Oct Nov Sep Jul Aug Jun Apr May Feb Mar 0\% Jan Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Cardiac Rehab Nutrition Clinic, Wed. 40\% Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Body Analysis Clinic,Sun. Body Analysis Clinic,Sun. 30\% 36\% 39\% 37\% 20\% 29\% No Show 54\% 48\% 47\% 37\% Transplant Nutrition Clinic, Sun. 44\% 42\% 43\% 23\% 10\% Dec Oct Nov Sep Jul Aug Jun Apr May Feb Mar Jan 0\% 50\% No Show 0\% 25\% 43\% 38\% 25\% 20\% 55\% 67\% 50\% 14\% 33\% 36\% 34\% 45\% 40\% 35\% 30\% No Show 50\% 25\% 20\% 15\% 10\% 38\% 38\% 32\% 24\% 31\% 35\% Transplant Nutrition Clinic,Wed. 40\% 24\% 21\% 21\% 14\% 5\% Dec Nov Oct Sep Aug Jul Jun 0\% Apr No Show 24\% 21\% 21\% 32\% 50\% 24\% 38\% 38\% 31\% 35\% 40\% 14\% 31\% May Transplant Nutrition Clinic,Wed. 40\% Mar Transplant Nutrition Clinic,Wed. 50\% Feb Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Transplant Nutrition Clinic, Sun. 60\% No Show 29\% 47\% 36\% 39\% 37\% 48\% 37\% 44\% 42\% 43\% 54\% 23\% 40\% Jan Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTAL Transplant Nutrition Clinic, Sun. 70\% 60\% 50\% 40\% No Show 67\% 30\% 55\% 43\% 20\% 10\% 0\% 25\% Body Analysis Clinic,Sun. 50\% 38\% 33\% 36\% 25\% 20\% 14\% 0\% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Adult AdultGeneral Nutriton,80\% Sun 39\% General Nutriton, Mon 43\% Adult General 70\% Nutrition clinic, Tues. a.m. 39\% Adult General 60\% Nutrition, Wed.p.m. Adult Oncology Nutrition 50\% Clinic, Sun. Adult Oncology Nutrition Clinic, Mon. 40\% Ketogenic Diet Clinic, Mon. Pediatric General Nutriton 30\% Clinic, Sun. Pediatric General Pediatric20\% Nutriton Clinic, Wed. Pediatric Oncology10\% Nutriton Clinic Pediatric Diabetic Nutrition Clinic 0\% Cardiac Rehab Nutrition Clinic Adult Transplant Nutrition Clinic, Sun. No Show Patients In Nutrition Clinics for the Year of 2019 75\% 41\% 43\% 43\% 35\% 39\% 43\% 41\% 40\% 39\% 37\% 35\% 16\% 34\% 31\% 30\% 37\% 24\% 16\% 31\% 24\% 30\% 75\% 40\% Pediatric Transplant Nutrition Clinic, Wed. 31\% Body Analysis Clinic, Sun. 34\% No Show Patients in Nutriton Clinics in 2019 Clinic Name AdultGeneral Nutrition clinic, Sun. p.m. Adult General Nutriton Clinic, Mon. AdultGeneral Nutrition clinic, Tues. Audlt General Nutrition clinic, Wed.p.m. Adult Oncology Nutrition Clinic, Sun. Adult Oncology Nutrition Clinic, Mon Ketogenic Diet Clinic, Mon. Pediatric General Nutriton Clinic, Sun. Pediatric General Nutriton Clinic, Wed. Pediatric Oncology Nutriton Clinic Pediatric Diabetic Nutrition Clinic Cardiac Rehab Nutrition Clinic Adult Transplant Nutrition Clinic, Sun. Pediatric Transplant Nutrition Clinic, Wed. Body Analysis Clinic, Sun. TOTAL OF NO SHOW \% \% 39\% 43\% 39\% 41\% 43\% 35\% 16\% 37\% 31\% 24\% 30\% 75\% 40\% 31\% 34\% 37\% 2018 44\% 47\% 42\% 48\% 43\% 20\% 38\% 32\% 27\% 33\% 47\% 44\% 33\% 17\% 37\% Note: With considration that there is one more clinic in 2019, the number of the no show patient has improved 31\% 3. Third Next Availabe Appointment in Specialized Nutrition Clinics Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 3rd Next Availabe Appointment for New Pt. (days) 3rd Next Availabe Appointment for Follow up Pt. (days) Adult General Nutrition Clinic Sun. p.m. 99 100 76 80 55 66 99 28 62 57 59 76 63 6 31 6 13 27 22 30 20 28 AVG 62.77777778 20.33333333 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 3rd Next Availabe Appointment for New Pt. (days) 78 71 170 147 156 126 134 112 113 104 119 113 3rd Next Availabe Appointment for Follow up Pt. (days) 78 64 44 112 94 105 113 91 72 76 84 64 AVG 120.25 83.08333333 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 3rd Next Availabe Appointment for New Pt. (days) 44 65 10 8 19 9 14 7 9 20 7 30 3rd Next Availabe Appointment for Follow up Pt. (days) 79 58 38 15 12 92 65 14 66 65 15 21 AVG 20.16666667 45 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 3rd Next Availabe Appointment for New Pt. (days) 80 94 123 128 118 107 108 93 67 90 58 3rd Next Availabe Appointment for Follow up Pt. (days) 80 66 18 16 104 86 80 86 60 80 44 66 62 55 60 31 40 20 28 6 59 57 27 30 22 20 13 6 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 3rd Next Availabe Appointment for New Pt. (days) 3rd Next Availabe Appointment for Follow up Pt. (days) Adult General Nutrition Clinic Mon.p.m. 200 170 156 147 150 100 112 94 78 78 71 64 134 126 119 113 112 113 113 105 104 91 84 76 72 44 50 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov 3rd Next Availabe Appointment for New Pt. (days) 3rd Next Availabe Appointm ... Purchase answer to see full attachment