Leave of Absence Days Last month, Community Hospital compiled the discharge statistics shown in the following table. Notice that the last three days are missing. Prepare a spreadsheet on a software orogram and enter the information from the chart. Then use the discharge lists for July 29, 30, and 31 to enter the missing data into the appropriate columns for medicine, surgery obstetrics, and newborn discharged patients and their corresponding discharge days. Finally, compute the ALOS for medicine service, surgery service, obstetrics service and newborn service and then compute the ALOS for adults and children (medicine, surgery, and obstetrics). Community Hospital Discharge List July 29,20XX Admission Patient Name Andres, Michael Barty, Stephen Christenson, Andrea Christenson, Baby Boy Denison, William Henry, Christopher Jackson, Michelle Katon, Marie Williamson, Baby Boy Age 47 Medicine 34 Surgery 17 OB NB NB 15 Surgery 67 Surgery 39 OB 41 OB NB NB Service Date 7/21 7/21 7/27 7/27 7/19 LOS 10 12 7/25 7/25 Community Hospital Discharge List July 30, 20xX Admission LOS Patient Name Adams, Paul Butler, Thomas Carson, Johnnie Daniels, George Finley, Joyce Date 7/23 7/24 7/24 7/22 7/28 Age Service 34 Medicine 65 Medicine 67 Surgery 45 Medicine 24 OB (continued on next page 04 Community Hospital Admissios Date 7/28 7/21 7/27 Service LOs Age Finley, Baby Gitl Georpe, 32 Surgery NB NB Jacquinta, Baby Boy Katosh, Joseph Kettison, Jack Kettison, Mary Laytham, Clint Matson, Dorianne Nettleson, Andy Pierce, Otto Ransom, Jackson Springer, Mary Tatum, Neal Wallace, Mattie Zininsky, Mauroen 82 Medicine 78 Medicine 76 Surgery 0 Surgery 76 Medicine 43 Surgery 2 Medicine 54 Medicine 2 Surgery 76 Surgery 19 OB 32 OB 7/24 7/24 7/19 7/28 7/28 7/28 Commanity Hospital Discharge List July 31, 20XX Patient Name Allan, Randy Banta, Janet Cox, David Dunning, Stephen ge 52 Medicine 76 Medicine 56 Sur Admission Date 7/23 7/25 7/27 7/26 7/26 Service LOS rgery Epp, Melvin 65 Medicine (continued on next page) Leawe of Absence Days 65 85 Community Hospital Discharge List July 31, 20xx Admission Patient Name Farmer, Jaimie Finley, Baby Girl Finney, G. W Fry, Benedict Girard, Katherine Halford, Harold Kilpatrick, Susan Kilpatrick, Baby Boy Martindale, Amanda Martindale, Baby Boy Martindale, Baby Boy Age 19 OB NB NB 54 Surgery 83 Surgery 73 Medicine 65 Surgery 19 OB NB NB Service Date 7/29 7/28 7/23 7/24 7/25 7/26 7/25 7/26 7/28 7/28 7/28 7/23 7/25 7/25 7/23 LOS 18 NB NB NB NIB OB Nachtigl, Brian22 Medicine723 Niazi, Baby Boy Poepperling, Wanda Trotman, Baby Girl NB NB 56 Medicine NB NIB Community Hospital Student Name July 20xX Medicine Surgery Obstetrics Subtotal Newborn Total No. Dis No. Dis No. Dis No. Dis No. Dis No. Di Date Pts. DaysPts DaysPt Days Pts. Days Pts. Days Pts. Days -July40 225516 2-July 6 36 8803 10 3-July 4 21 2314 4-July 11 47 3 424 10 S-July 157523 3 6-July 6 527 56 25 6 23 3 10 4 10 (continued on next page)
