FluentExcel project · Healthcare
Hospital Administration
8 steps · 120 rows of data · 380 formulas
Hospital Administration.xlsx
H2fx=C2-B2
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Patient | Admitted | Discharged | Department | Age | Cost | Insured | Stay (days) | Age group | Admit day |
| 2 | PT-5017 | 1/2/2026 | 1/7/2026 | Orthopedics | 39 | $6,735 | Yes | 5 | Adult | Weekday |
| 3 | PT-5035 | 1/2/2026 | 1/14/2026 | Oncology | 22 | $30,965 | Yes | 12 | Adult | Weekday |
| 4 | PT-5052 | 1/2/2026 | 1/10/2026 | Orthopedics | 28 | $10,498 | Yes | 8 | Adult | Weekday |
| 5 | PT-5099 | 1/3/2026 | 1/6/2026 | Cardiology | 35 | $7,902 | Yes | 3 | Adult | Weekend |
| 6 | PT-5107 | 1/3/2026 | 1/8/2026 | General | 58 | $8,386 | Yes | 5 | Adult | Weekend |
| 7 | PT-5106 | 1/4/2026 | 1/6/2026 | General | 68 | $2,491 | Yes | 2 | Senior | Weekend |
| 8 | PT-5110 | 1/4/2026 | 1/10/2026 | Oncology | 54 | $13,138 | Yes | 6 | Adult | Weekend |
| 9 | PT-5031 | 1/5/2026 | 1/10/2026 | Orthopedics | 58 | $8,380 | Yes | 5 | Adult | Weekday |
| 10 | PT-5008 | 1/6/2026 | 1/18/2026 | Oncology | 37 | $31,105 | No | 12 | Adult | Weekday |
| 11 | PT-5023 | 1/6/2026 | 1/10/2026 | Pediatrics | 17 | $4,176 | Yes | 4 | Child | Weekday |
Patients by department
Healthcare
Hospital Administration
You work in the operations office of a mid-size hospital. The board meets on Friday and wants a Q1 picture of 120 admissions: how…
Premium 8 steps 3 hView