Spreadsheet: 790086d1659533088-countifs-with-multiple-criteria-formula-mock-up
Sheet: Staffing Worksheet

Staffing Worksheet
Start Date | 2022-08-03 00:00:00 |  | Positions | Budget | FPA | Roster |  |  |  |  |  |  |  |  | Copyright 2015 [NAME]
 |  |  | RN | 42.9 | 42.9 | 29.4
[NAME] (%) | 0.1 |  | LNA
 |  |  | [NAME]
Category | Position | FTE | Name | Start Date | # Weeks | End Date
LOAs | RN | 0.9 | Lite Duty [NAME] | 2021-12-01 00:00:00 | 50 |  |  |  | Hires
LOAs |  |  |  |  |  |  |  |  | Hires
LOAs
LOAs
LOAs
LOAs
LOAs
LOAs
LOAs
LOAs
LOAs
LOAs
LOAs |  |  |  |  |  |  |  |  | Hires
Total LOAs |  |  | Subtotal
Hires & Orientation
Hires & Orientation | RN | 0.9 | [NAME] | 2022-07-11 00:00:00 | 12
Hires & Orientation | RN | 0.9 | [NAME] | 2022-07-18 00:00:00 | 10
Hires & Orientation | RN | 0.9 | [NAME] | 2022-07-18 00:00:00 | 10
Hires & Orientation | RN | 0.9 | Olivia | 2022-08-11 00:00:00 | 10
Hires & Orientation | RN | 0.9 | Grace | 2022-08-11 00:00:00 | 10
Hires & Orientation | RN | 0.9 | Alessia | 2022-08-07 00:00:00 | 12
Hires & Orientation | RN | 0.9 | Megan florida | 2022-08-11 00:00:00 | 10
Hires & Orientation | RN | 0.9 | victoria NRP | 2022-08-11 00:00:00 | 10
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Hires & Orientation
Total Hires & Orientation |  |  | Subtotal
Resignation
Resignation
Resignation
resignation
Resignation | RN | 0.45 | [NAME] to part time |  |  | 2022-07-25 00:00:00
Resignation | RN | 0.9 | [NAME] to per diem |  |  | 2022-08-01 00:00:00
Resignation
Resignation | RN | 0.9 | [NAME] to clinic |  |  | 2022-07-24 00:00:00
Resignation | RN | 0.9 | [NAME] to PACU |  |  | 2022-08-06 00:00:00
Resignation | RN | 0.9 | Rose to VA |  |  | 2022-08-03 00:00:00
Resignation
Resignation | RN | 0.9 | Bethany Sefakis to Mass |  |  | 2022-07-23 00:00:00
Resignation
Resignation
Resignation
Resignation
Total Resignation |  |  | Subtotal
Per Diem | RN | 0
Per Diem | LNA | 0
Per Diem | [NAME] | 0
Total Per Diem |  |  | Subtotal
Incentive | RN | 0.3 | [NAME] | 2022-08-04 00:00:00 | 4
Incentive | RN | 0.3 | [NAME] | 2022-08-06 00:00:00 | 5
Incentive | RN | 0.3 | Anissa Landry | 2022-08-07 00:00:00 | 4
Incentive | RN | 0.3 | emily [NAME] | 2022-08-06 00:00:00 | 4
Incentive
Incentive
Incentive
Incentive
Total Incentive |  |  | Subtotal
Traveler | RN | 0.9 | [NAME] | 2021-10-04 00:00:00 | 52
Traveler | RN | 1.2 | Wynn Cagas | 2021-12-27 00:00:00 | 41
Traveler | RN | 0.9 | Mones, Jordan | 2022-09-03 00:00:00 | 14
Traveler | RN | 0.9 | [NAME] PCU | 2022-01-12 00:00:00 | 39
Traveler | RN | 0.9 | Nicole Barrie Travel PCU | 2021-11-01 00:00:00 | 45
Traveler | RN | 0.9 | Shawna Gargon PCU | 2022-01-10 00:00:00 | 31
Traveler | RN | 0.9 | Blair Reily | 2022-01-13 00:00:00 | 38
Traveler | RN | 0.9 | [NAME] | 2022-05-30 00:00:00 | 21
Traveler | RN | 0.9 | [NAME] | 2022-05-16 00:00:00 | 13
Traveler | RN | 0.9 | [NAME]  nights | 2022-05-30 00:00:00 | 13
Traveler | RN | 0.9 | [NAME] | 2022-05-16 00:00:00 | 13
Traveler | RN | 0.9 | Shawna Gargon PCU 2 | 2022-09-17 00:00:00 | 13
Traveler | RN | 0.9 | [NAME] "[NAME]"  [NAME] | 2022-07-11 00:00:00 | 13
Traveler | RN | 0.9 | [NAME] | 2022-05-16 00:00:00 | 13
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Traveler
Total Traveler |  |  | Subtotal
Request | RN | 1.8 | request | 2022-08-28 00:00:00 | 13 | 2022-10-24 00:00:00
Request | RN | 2.7 | request | 2022-08-14 00:00:00 | 13
Request | RN | 3.6 | request | 2022-07-25 00:00:00 | 13
Request
Request
Request
Total Request |  |  | Subtotal