Spreadsheet: 859375d1707776183-averageifs-by-date-range-averageifs-tms
Sheet: Plan Year Percentages

RC# | Employee | Total Guaranteed | Bridge Start Date | Bridge End Date | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00 | 2014-01-10 00:00:00 | 2014-01-11 00:00:00 | 2014-01-12 00:00:00 | 2015-01-01 00:00:00 | 2015-01-02 00:00:00 | 2015-01-03 00:00:00 | 2015-01-04 00:00:00 | 2015-01-05 00:00:00 | 2015-01-06 00:00:00 | 2015-01-07 00:00:00 | 2015-01-08 00:00:00 | 2015-01-09 00:00:00 | 2015-01-10 00:00:00 | 2015-01-11 00:00:00 | 2015-01-12 00:00:00 | 2016-01-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-03 00:00:00 | 2016-01-04 00:00:00 | 2016-01-05 00:00:00 | 2016-01-06 00:00:00 | 2016-01-07 00:00:00 | 2016-01-08 00:00:00 | 2016-01-09 00:00:00 | 2016-01-10 00:00:00 | 2016-01-11 00:00:00 | 2016-01-12 00:00:00 | 2017-01-01 00:00:00 | 2017-01-02 00:00:00 | 2017-01-03 00:00:00 | 2017-01-04 00:00:00 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 2017-01-07 00:00:00 | 2017-01-08 00:00:00 | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 2017-01-11 00:00:00 | 2017-01-12 00:00:00 | 2018-01-01 00:00:00 | 2018-01-02 00:00:00 | 2018-01-03 00:00:00 | 2018-01-04 00:00:00 | 2018-01-05 00:00:00 | 2018-01-06 00:00:00 | 2018-01-07 00:00:00 | 2018-01-08 00:00:00 | 2018-01-09 00:00:00 | 2018-01-10 00:00:00 | 2018-01-11 00:00:00 | 2018-01-12 00:00:00 | 2019-01-01 00:00:00 | 2019-01-02 00:00:00 | 2019-01-03 00:00:00 | 2019-01-04 00:00:00 | 2019-01-05 00:00:00 | 2019-01-06 00:00:00 | 2019-01-07 00:00:00 | 2019-01-08 00:00:00 | 2019-01-09 00:00:00 | 2019-01-10 00:00:00 | 2019-01-11 00:00:00 | 2019-01-12 00:00:00 | 2020-01-01 00:00:00 | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 | 2020-01-04 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | 2020-01-12 00:00:00 | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | Plan Year 1 Start Month | Plan Year 1 End Month | Plan Year Complete? | Plan Year 1 Average | Plan Year 2 Start Month | Plan Year 2 End Month | Plan Year Complete? | Plan Year 2 Average | Plan Year 3 Start Month | Plan Year 3 End Month | Plan Year Complete? | Plan Year 3 Average | Plan Year 4 Start Month | Plan Year 4 End Month | Plan Year Complete? | Plan Year 4 Average | Plan Year 5 Start Month | Plan Year 5 End Month | Plan Year Complete? | Plan Year 5 Average
1 | A | 830000 | 2019-12-01 00:00:00 | 2023-11-30 00:00:00
2 | B | 300000 | 2022-01-01 00:00:00 | 2024-12-31 00:00:00
3 | C | 30000 | 2022-10-01 00:00:00 | 2024-09-30 00:00:00
4 | D | 80000 | 2023-01-01 00:00:00 | 2024-12-31 00:00:00
5 | E | 580000 | 2023-09-01 00:00:00 | 2025-08-31 00:00:00
6 | F | 109686 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
7 | G | 120000 | 2023-08-01 00:00:00 | 2025-07-31 00:00:00
8 | H | 750000 | 2023-07-01 00:00:00 | 2026-06-30 00:00:00
9 | I | 372063 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
10 | J | N/A | 2007-10-01 00:00:00 | N/A
11 | K | 90000 | 2023-09-01 00:00:00 | 2025-08-31 00:00:00
12 | L | 218000 | 2023-09-01 00:00:00 | 2025-08-31 00:00:00
13 | M | 97500 | 2022-09-01 00:00:00 | 2024-08-31 00:00:00
14 | N | N/A | 2018-07-01 00:00:00 | N/A
15 | O | 60000 | 2022-12-01 00:00:00 | 2025-11-30 00:00:00
16 | P | 10000 | 2023-12-01 00:00:00 | 2024-10-31 00:00:00
17 | Q | 50000 | 2023-07-01 00:00:00 | 2025-06-30 00:00:00
18 | R | 300000 | 2022-01-01 00:00:00 | 2024-12-31 00:00:00
19 | S | 520527 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
20 | T | 181500 | 2022-12-01 00:00:00 | 2025-11-30 00:00:00
21 | U | N/A | 2015-01-01 00:00:00 | N/A
22 | V | N/A | 2023-04-01 00:00:00 | N/A
23 | W | 600000 | 2021-12-01 00:00:00 | 2024-11-30 00:00:00
24 | X | 250000 | 2023-01-01 00:00:00 | 2024-12-31 00:00:00
25 | Y | 900000 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
26 | Z | 330000 | 2020-12-01 00:00:00 | 2023-11-30 00:00:00
27 | AA | 250000 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
28 | BB | 5525000 | 2020-12-01 00:00:00 | 2025-11-30 00:00:00
29 | CC | 4260000 | 2020-10-01 00:00:00 | 2025-12-31 00:00:00
30 | DD | 351474 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
31 | EE | 300000 | 2023-12-01 00:00:00 | 2026-11-30 00:00:00
32 | FF | 480000 | 2022-10-01 00:00:00 | 2024-09-30 00:00:00
33 | GG | N/A | 2016-05-01 00:00:00 | N/A
34 | HH | N/A | 2018-04-01 00:00:00 | N/A
35 | II | 75000 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
36 | JJ | 333000 | 2023-11-01 00:00:00 | 2026-10-31 00:00:00
37 | KK | 1500000 | 2022-01-01 00:00:00 | 2024-12-31 00:00:00
38 | LL | 125000 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
39 | MM | 1560000 | 2023-11-01 00:00:00 | 2026-10-31 00:00:00
40 | NN | 20000 | 2023-07-01 00:00:00 | 2025-06-30 00:00:00
41 | OO | 163038 | 2023-01-01 00:00:00 | 2026-03-31 00:00:00
42 | PP | 380646 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
43 | QQ | 651234 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
44 | RR | 20000 | 2022-11-01 00:00:00 | 2024-12-31 00:00:00
45 | SS | 300000 | 2022-09-01 00:00:00 | 2025-08-31 00:00:00
46 | TT | 600000 | 2021-07-01 00:00:00 | 2024-06-30 00:00:00
47 | UU | 210000 | 2022-01-01 00:00:00 | 2024-12-31 00:00:00
48 | VV | 2474166.666666667 | 2018-12-01 00:00:00 | 2024-06-30 00:00:00
49 | WW | 37500 | 2022-12-01 00:00:00 | 2025-11-30 00:00:00
50 | XX | 927450 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
51 | YY | 110610 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
52 | ZZ | 1050000 | 2022-04-01 00:00:00 | 2025-03-31 00:00:00
53 | AAA | 200000 | 2022-01-01 00:00:00 | 2025-12-31 00:00:00
54 | BBB | 195000 | 2022-01-01 00:00:00 | 2024-12-31 00:00:00
55 | CCC | 309000 | 2023-11-01 00:00:00 | 2026-10-31 00:00:00
56 | DDD | 42972 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
57 | EEE | 294000 | 2023-11-01 00:00:00 | 2026-10-31 00:00:00
58 | FFF | 385000 | 2021-05-01 00:00:00 | 2024-04-30 00:00:00
59 | GGG | 213093 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
60 | HHH | 290000 | 2020-12-01 00:00:00 | 2024-11-30 00:00:00
61 | III | 200000 | 2022-07-01 00:00:00 | 2024-06-30 00:00:00
62 | JJJ | 1260000 | 2021-02-01 00:00:00 | 2024-01-31 00:00:00
63 | KKK | 150000 | 2023-11-01 00:00:00 | 2026-10-31 00:00:00
64 | LLL | 140000 | 2023-09-01 00:00:00 | 2025-08-31 00:00:00
65 | MMM | 300000 | 2023-11-01 00:00:00 | 2025-10-31 00:00:00
66 | NNN | 465000 | 2021-05-01 00:00:00 | 2024-04-30 00:00:00
67 | OOO | 240000 | 2023-02-01 00:00:00 | 2026-01-31 00:00:00
68 | PPP | 580000 | 2023-09-01 00:00:00 | 2025-08-31 00:00:00
69 | QQQ | N/A | 2015-01-01 00:00:00 | N/A
70 | RRR | 165000 | 2022-10-01 00:00:00 | 2025-09-30 00:00:00
71 | SSS | 675000 | 2023-06-01 00:00:00 | 2026-05-31 00:00:00
72 | TTT | 840000 | 2024-01-01 00:00:00 | 2025-12-31 00:00:00
73 | UUU |  | 2019-01-01 00:00:00 | 2021-12-31 00:00:00
74 | VVV | 225000 | 2023-01-01 00:00:00 | 2025-12-31 00:00:00
75 | WWW | 30000 | 2021-09-01 00:00:00 | 2024-08-31 00:00:00
76 | [NAME] | 607500 | 2021-08-01 00:00:00 | 2024-07-31 00:00:00
77 | YYY | 2449000 | 2019-01-01 00:00:00 | 2029-11-30 00:00:00
78 | ZZZ | 450000 | 2022-10-01 00:00:00 | 2025-09-30 00:00:00
79 | AAAA | 44000 | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
80 | BBBB | 102950 | 2022-08-01 00:00:00 | 2024-07-31 00:00:00
81 | CCCC | 400000 | 2022-09-01 00:00:00 | 2026-08-31 00:00:00
82 | DDDD | 660000 | 2024-01-01 00:00:00 | 2026-12-31 00:00:00