Spreadsheet: 875671d1722282005-complex-let-vstack-filter-sort-choosecols-formula-example-004
Sheet: ActualDays

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calcs  >>
Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change of Days Worked Calc
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |  | Change to Days Worked | Old Days Worked | New Days Worked | Date of Change |  | Fractional Month? | Fractional Months | Rate | RVU Threshold | Adj. [NAME] | Total Adj. Days Worked | Changed days worked ratio | Adj. [NAME] | Period RVU less Adj. [NAME] | Adj. Bonus
Cortes, Frances | NP | Active | 2 | 8 | 20 | Yes | CA | No |  | 2024-04-11 00:00:00 |  | ActualDays | 250 | 79.10000000000004 | 0
[NAME], [NAME] | NP | Active | 1 | 18 | 20 | No | FL | No |  | 2023-10-01 00:00:00 |  | ActualDays | 562.5 | 204.6799999999997 | 0
Gallaway, Rebecca | NP | Active | 2 | 6 | 20 | Yes | WA | No |  | 2024-02-22 00:00:00 |  | ActualDays | 187.5 | 65.02 | 0
Gilliver, [NAME] | PA | Active | 2 | 6 | 20 | Yes | WA | No |  | 2024-02-08 00:00:00 |  | ActualDays | 187.5 | 75.43999999999994 | 0
[NAME], Grayce | NP | Active | 2 | 8 | 20 | Yes | WA | No |  | 2024-02-29 00:00:00 |  | ActualDays | 250 | 100.6 | 0
Ivy, Mellissa | NP | Active | 1 | 8 | 20 | Yes | WA | No |  | 2024-02-08 00:00:00 |  | ActualDays | 250 | 97.84000000000003 | 0
Jelks, [NAME] | NP | Active | 2 | 8 | 20 | Yes | FL | No |  | 2024-02-08 00:00:00 |  | ActualDays | 250 | 171.2000000000002 | 0
[NAME], [NAME] | NP | Active | 2 | 3 | 20 | Yes | CA | No |  | 2024-06-06 00:00:00 |  | ActualDays | 93.75 | 30.16000000000001 | 0
Juestel-Ochs, [NAME] | NP | Active | 0 | 3 | 20 | Yes | IN | Yes |  | 2024-01-26 00:00:00 |  | ActualDays | 93.75 | 21 | 0
[NAME], Gibril | NP | Active | 3 | 12 | 20 | Yes | WA | No |  | 2022-10-01 00:00:00 |  | ActualDays | 375 | 446.9400000000008 | 1079.1
Kaur, Ramandeep | NP | Active | 3 | 14 | 20 | Yes | WA | No |  | 2024-02-29 00:00:00 |  | ActualDays | 437.5 | 263.8599999999998 | 0
Kaur, Sarabjit | NP | Active | 2 | 8 | 20 | Yes | CA | No |  | 2024-05-09 00:00:00 |  | ActualDays | 250 | 250.0199999999996 | 0.3
Keya, Dominic | NP | Active | 3 | 6 | 20 | Yes | WA | No |  | 2023-07-24 00:00:00 |  | ActualDays | 187.5 | 98.06 | 0
Kwon, [NAME] | NP | Active | 3 | 11 | 20 | Yes | IL | No |  | 2024-03-28 00:00:00 |  | ActualDays | 343.75 | 116.2 | 0
McKenzie, [NAME] | NP | Active | 2 | 8 | 20 | Yes | FL | No |  | 2024-03-20 00:00:00 |  | ActualDays | 250 | 146.94 | 0
Medina, [NAME] | NP | Active | 0 | 17 | 20 | Yes | WA | Yes |  | 2024-01-26 00:00:00 |  | ActualDays | 531.25 | 151.5 | 0
[NAME], [NAME] | NP | Active | 3 | 12 | 20 | Yes | FL | No |  | 2024-05-09 00:00:00 |  | ActualDays | 375 | 234.7699999999996 | 0
Oliveira, Adrienne | NP | Active | 3 | 12 | 20 | Yes | WA | No |  | 2021-10-01 00:00:00 |  | ActualDays | 375 | 572.7900000000008 | 2966.85
Saint-Amand, Beverly | NP | Active | 2 | 5 | 20 | Yes | FL | No |  | 2024-05-23 00:00:00 |  | ActualDays | 156.25 | 129.72 | 0
Sanders, Heather | NP | Active | 0 | 14 | 20 | Yes | WA | Yes |  | 2024-04-25 00:00:00 |  | ActualDays | 437.5 | 202.5 | 0
Sharma, Aishwarya | MD | Active | 2 | 4 | 20 | Yes | CA | No |  | 2023-09-02 00:00:00 |  | ActualDays | 210 | 151.25 | 0
Trino, [NAME] | NP | Active | 0 | 4 | 20 | Yes | CA | Yes |  | 2024-03-14 00:00:00 |  | ActualDays | 125 | 30 | 0
[NAME], Donis | NP | Active | 3 | 12 | 20 | Yes | FL | No |  | 2024-02-08 00:00:00 |  | ActualDays | 375 | 475.750000000001 | 1511.25
Wamukoya, [NAME] | NP | Active | 2 | 10 | 20 | Yes | WA | No |  | 2024-04-25 00:00:00 |  | ActualDays | 312.5 | 79.40000000000002 | 0
Youngs, Valrie | NP | Active | 1 | 1 | 20 | Yes | WA | No |  | 2024-05-30 00:00:00 |  | ActualDays | 31.25 | 1.92 | 0