excel projectt
adrian77
il_excel2013_ua_p1a_raulburgueno_11.xlsxDocumentation
| Illustrated Excel 2013 | |
| Unit A: SAM Project 1a | |
| Northwest Hospital | |
| CREATE AN ANALYSIS TABLE | |
| Author: | Raul Burgueno |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Admission Analysis
| Admissions 2010-2015 | |||||
| FY 2012 | FY 2013 | FY 2014 | FY 2015 | Total | |
| Emergency | 80886 | 85775 | 90885 | 100375 | 357921 |
| Surgery | 15738 | 16060 | 15695 | 19345 | |
| Pediatric | 5856 | 5475 | 6205 | 5840 | |
| Intensive Care | 8052 | 8395 | 7665 | 8030 | |
| Psychiatric | 3294 | 3650 | 4380 | 4015 | |
| Other | 24156 | 24455 | 25915 | ||
| Total | |||||
| Admissions 2016-2019 | |||||
| FY 2016 | FY 2017 | FY 2018 | FY 2019 | Total | |
| Emergency | 105394 | 110663 | 116197 | 122006 | 454260 |
| Surgery | 20312 | 21328 | 22394 | 23514 | |
| Pediatric | 6132 | 6439 | 6761 | 7099 | |
| Intensive Care | 8432 | 8853 | 9296 | 9761 | |
| Psychiatric | 4216 | 4427 | 4648 | 4880 | |
| Other | |||||
| Total |
