module 4A

Documentation
        New Perspectives Excel 2019 | Modules 1-4: SAM Capstone Project 1a
        Tallridge Regional Medical Center
        FORMATTING, FORMULAS, AND CHARTS
    Author:    Shahmir Yahya
    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.
Departments
    Tallridge Regional Medical Center
    Staffing and Financial Summary by Department
            Staff
                        Total    Turnover    Turnover %    2021 Budget    % change from 2020        Department summary            Averages
    CCU    Coronary Care    5    8    15    28    4    0.143    $ 5,250,768    5.20%        Abbreviation    ICU
    EMR    Emergency    12    27    33    72    21    0.292    $ 18,782,039    9.30%        Department
    END    Endocrinology    3    6    4    13    0    0.000    $ 2,847,592    0.20%        MD
    ICU    Intensive Care    17    22    15    54    5    0.093    $ 9,282,172    2.30%        RN
    NEU    Neurology    6    15    8    29    1    0.034    $ 5,283,109    -1.50%        Support
    OBS    Obstetrics    9    17    17    43    3    0.070    $ 11,010,924    3.30%        Total
    ONC    Oncology    5    3    9    17    8    0.471    $ ...