Spreadsheet: 876872d1723585952-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-reports-test-caylatreese-
Sheet: Jun 24

2024 WORKSHEET
Source: |  |  | Daily Sheets |  |  | ABC |  |  |  |  |  |  |  | MONTH |  |  |  |  |  | 2024-06-01 00:00:00
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY |  | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 22 | 6 | 0 | 1 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | 5 | 0 | 2 | 0 | 2 | 0 | 22
2024-06-02 00:00:00 | 21 | 5 | 0 | 1 | 0 | 2 | 0 |  |  |  |  |  |  |  |  | 6 | 0 | 3 | 0 | 1 | 0 | 20
2024-06-03 00:00:00 | 21 | 6 | 0 | 2 | 1 | 2 | 0
2024-06-04 00:00:00 | 26 | 6 | 0 | 1 | 1 | 2 | 0
2024-06-05 00:00:00 | 23 | 6 | 0 | 1 | 0 | 2 | 0
2024-06-06 00:00:00 | 22 | 6 | 0 | 1 | 1 | 2 | 0
2024-06-07 00:00:00 | 22 | 6 | 1 | 1 | 0 | 2 | 0
2024-06-08 00:00:00 | 24 | 5 | 0 | 0 | 0 | 2 | 0
2024-06-09 00:00:00 | 22 | 5 | 0 | 1 | 0 | 2 | 0
2024-06-10 00:00:00 | 20 | 5 | 0 | 1 | 1 | 2 | 0
2024-06-11 00:00:00 | 20 | 6 | 1 | 0 | 0 | 2 | 0
2024-06-12 00:00:00 | 18 | 6 | 0 | 1 | 0 | 2 | 0
2024-06-13 00:00:00 | 16 | 3 | 0 | 1 | 0 | 2 | 0
2024-06-14 00:00:00 | 13 | 4 | 0 | 1 | 1 | 2 | 0
2024-06-15 00:00:00 | 14 | 4 | 1 | 0 | 0 | 2 | 0
2024-06-16 00:00:00 | 15 | 4 | 0 | 0 | 0 | 2 | 0
2024-06-17 00:00:00 | 16 | 4 | 0 | 1 | 0 | 2 | 0.5
2024-06-18 00:00:00 | 16 | 5 | 1 | 1 | 0 | 2 | 0
2024-06-19 00:00:00 | 12 | 4 | 0 | 0 | 0 | 2 | 0
2024-06-20 00:00:00 | 17 | 5 | 0 | 1 | 0 | 2 | 0
2024-06-21 00:00:00 | 15 | 5 | 0 | 2 | 0 | 1 | 0
2024-06-22 00:00:00 | 19 | 5 | 2 | 0 | 0 | 2 | 0
2024-06-23 00:00:00 | 23 | 6 | 0 | 1 | 0 | 2 | 0
2024-06-24 00:00:00 | 21 | 5 | 1 | 0 | 0 | 3 | 0
2024-06-25 00:00:00 | 20 | 5 | 0 | 2 | 0 | 3 | 0
2024-06-26 00:00:00 | 23 | 6 | 1 | 1 | 0 | 2 | 0
2024-06-27 00:00:00 | 25 | 6 | 1 | 0 | 0 | 3 | 0
2024-06-28 00:00:00 | 21 | 6 | 1 | 1 | 0 | 3 | 0
2024-06-29 00:00:00 | 18 | 4 | 1 | 1 | 0 | 2.5 | 0
2024-06-30 00:00:00 | 18 | 5 | 0 | 1 | 0 | 2 | 0
Total | 583 | 154 | 11 | 25 | 5 | 62.5 | 0.5 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 11 | 0 | 5 | 0 | 3 | 0 | 42
avg | 19.43333333333333 | 5.133333333333334 |  |  |  | 2.083333333333333 | 0.01666666666666667 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 5.5 |  |  |  | 1.5 | 0 | 21
 |  |  |  |  |  | 4TH FL |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 22 | 4 | 1 | 1 | 0 | 2 | 0 |  |  |  |  |  |  |  |  | 4 | 0 | 1 | 0 | 1 | 0 | 21
2024-06-02 00:00:00 | 24 | 4 | 0 | 0 | 0 | 2 | 0 |  |  |  |  |  |  |  |  | 4 | 0 | 2 | 0 | 2 | 0 | 25
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 46 | 8 | 1 | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 3 | 0 | 3 | 0 | 46
avg | 23 | 4 |  |  |  | 2 | 0 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 4 |  |  |  | 1.5 | 0 | 23
Source: |  |  | Daily Sheets |  |  | 5TH FL |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 20 | 4 | 0 | 0 | 1 | 2 | 0 |  |  |  |  |  |  |  |  | 3 | 1 | 0 | 0 | 2 | 0 | 19
2024-06-02 00:00:00 | 18 | 3 | 0 | 0 | 0 | 2 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 1 | 0 | 2 | 0 | 18
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 38 | 7 | 0 | 0 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 0 | 4 | 0 | 37
avg | 19 | 3.5 |  |  |  | 2 | 0 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 3 |  |  |  | 2 | 0 | 18.5
 |  |  |  |  |  | 6TH FL |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | NICU Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00
2024-06-02 00:00:00
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
avg | #[NAME]! | #[NAME]! |  |  |  | #[NAME]! | #[NAME]! |  |  |  |  |  | #[NAME]! | #[NAME]! |  | #[NAME]! |  |  |  | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  |  |  |  | DEF |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | MCH Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 3 | 1 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 1 | 0 | 0 | 3
2024-06-02 00:00:00 | 3 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 2
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 6 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 5
avg | 3 | 1 |  |  |  | 0 | 0 | #[NAME]! |  |  |  |  | #[NAME]! | #[NAME]! |  | 1 |  |  |  | 0 | 0 | 2.5
 |  |  |  |  |  | GHI |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | MCH Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 0 | 3 | 1 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 1 | 1 | 1 | 0 | 1
2024-06-02 00:00:00 | 2 | 2 | 0 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 1 | 0 | 1 | 0 | 2
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 2 | 5 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 2 | 1 | 2 | 0 | 3
avg | 1 | 2.5 |  |  |  | 1 | 0 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 3 |  |  |  | 1 | 0 | 1.5
 |  |  |  |  |  | JKL |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | MCH Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 3 | 1 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 3
2024-06-02 00:00:00 | 3 | 1 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 6 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 4
avg | 3 | 1 |  |  |  | 0 | 0 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 1 |  |  |  | 0 | 0 | 2
 |  |  |  |  |  | MNO |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 6 | 3 | 0 | 0 | 1 | 1 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 1 | 0 | 5
2024-06-02 00:00:00 | 6 | 3 | 0 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 1 | 0 | 6
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 12 | 6 | 0 | 0 | 1 | 2 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 6 | 0 | 0 | 0 | 2 | 0 | 11
avg | 6 | 3 |  |  |  | 1 | 0 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 3 |  |  |  | 1 | 0 | 5.5
 |  |  |  |  |  | 3RD FL |  |  |  |  |  |  |  | MONTH: |  |  |  |  |  | 2024-06-01 00:00:00
Source: |  |  | Daily Sheets
 | DAY | DAY | DAY | DAY | DAY | DAY | DAY | 0 | EVE | EVE | EVE | EVE | EVE | EVE |  | NGT | NGT | NGT | NGT | NGT | NGT | NGT
Date | Census | RN | RN PD | TRVL | RN OT | Tech | NA | 0 | RN | RN PD | TRVL | RN OT | Tech | NA |  | RN | RN PD | TRVL | RN OT | Tech | NA | Census
2024-06-01 00:00:00 | 10 | 2 | 1 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | 2 | 2 | 0 | 0 | 1 | 0 | 10
2024-06-02 00:00:00 | 10 | 2 | 1 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | 7
2024-06-03 00:00:00
2024-06-04 00:00:00
2024-06-05 00:00:00
2024-06-06 00:00:00
2024-06-07 00:00:00
2024-06-08 00:00:00
2024-06-09 00:00:00
2024-06-10 00:00:00
2024-06-11 00:00:00
2024-06-12 00:00:00
2024-06-13 00:00:00
2024-06-14 00:00:00
2024-06-15 00:00:00
2024-06-16 00:00:00
2024-06-17 00:00:00
2024-06-18 00:00:00
2024-06-19 00:00:00
2024-06-20 00:00:00
2024-06-21 00:00:00
2024-06-22 00:00:00
2024-06-23 00:00:00
2024-06-24 00:00:00
2024-06-25 00:00:00
2024-06-26 00:00:00
2024-06-27 00:00:00
2024-06-28 00:00:00
2024-06-29 00:00:00
2024-06-30 00:00:00
Total | 20 | 4 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 3 | 2 | 0 | 0 | 2 | 0 | 17
avg | 10 | 2 |  |  |  | 1 | 0 |  |  |  |  |  | #[NAME]! | #[NAME]! |  | 1.5 |  |  |  | 1 | 0 | 8.5