Question: Electronic Medical Records Specialist The Computer Is Down, And The LOS Summary Spreadsheet Must Be Completed Manually In Time For The 2 P.m. Hospital Administrators’ Meeting. Using The Information From The Following Partial Discharge List And The Partial LOS Summary Spreadsheet, Complete The Calculations For All The Incomplete Columns On The Spreadsheet …

Electronic Medical Records Specialist The computer is down, and the LOS Summary spreadsheet must be completed manually in time for the 2 p.m. hospital administrators’ meeting. Using the information from the following partial Discharge List and the partial LOS Summary spreadsheet, complete the calculations for all the incomplete columns on the spreadsheet to answer as directed. LOS Patient Name Adamson, baby boy Asimov, Samuel Clancey, Meridith Hamilton, Tammy Hardy, Tom Jzo, Cho Lee Thornton, Jon Westerson, Bart Age NB 34 23 44 68 72 29 50 Peaceful Valley Hospital Discharge List January 14, 20XX PCU Date Admitted NB 1-12 Surgery 1-4 Medicine 1-13 Medicine 1-7 Surgery 1-9 Oncology 1-10 Surgery 1-11 Oncology 1-3 2 10 1 7 5 66 3 53 Total No. Disch Pts Days Date 1 Jan 2 Jan 3 Jan 4 Jan 5 Jan 6 Jan 7 Jan 8 Jan 9 Jan 10 Jan 11 Jan 12 Jan 13 Jan 14 Jan Med No. Disch Pts Days 3 17 5 16 3 15 8 24 9 36 4 29 4 25 8 33 2 14 3 15 4 19 9 20 8 13 2. 8 Peaceful Valley Hospital LOS Summary January, 20XX Oncol Surg Subtotal No. Disch No. Disch No. Disch Pts Days Pts Days Pts Days 5 138 2. 23 6 123 10 74 8 148 9 109 8 123 8 93 8 234 10 112 9 256 7 81 7 188 11 7 137 12 189 6 132 2. 15 6 135 8 61 6 177 4 72 7 342 11 99 8 156 7 49 2. 119 3 18 Newborn No. Disch Pts Days 5 15 9 31 3 8 7 17 1 3 4 28 3 12 8 22 4 21 5 16 3 29 7 19 2 1 2. 132 16. What is the ALOS for the Medicine PCU? days. 17. What is the ALOS for the Oncology PCU? days. 18. What is the ALOS for the Surgery PCU? days. 19. What is the ALOS for the Newborn PCU? days. 20. Calculate the total ALOS for Peaceful Valley Hospital for January 1-14. ___ days.