Spreadsheet: 731030d1620132623-countifs-across-columns-and-dependient-on-criteria-040521
Sheet: HR 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only |  |  |  |  |  |  |  |  |  |  | Accruals only
Vetter ID | Vetter Name | Month | Holiday Payment | Total | Holiday + Total | Paid last month | HR to pay? | Total to pay | Notes | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | Total to pay | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | What to do? | Notes | Holiday Payment | Total | Holiday + Total | Month | Holiday Payment | Total | Holiday + Total | Paid last month? | HR to pay? | What to do? | Notes | Holiday Payment | Total | Holiday + Total
625 | Test | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  | Month 1 | 2019-07-01 00:00:00 |  |  |  |  | No |  | June + July | 2019-08-01 00:00:00 |  |  |  |  |  |  | June - August |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2019-10-01 00:00:00 | #N/A |  |  |  |  |  | Month 2 |  |  |  | 2019-11-01 00:00:00 |  |  |  |  | Yes |  | Sep-Nov |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | Yes |  | Dec-Feb |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-05-01 00:00:00 |  |  |  |  | Yes |  | Month 3 |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-08-01 00:00:00 |  |  |  |  | Yes | Month 3 | Month 3 |  |  |  | 2020-09-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2021-04-01 00:00:00 | 11.55019338 | 95.6934 | 107.24359338 |  |  | Month 2 | March + April |  |  |  | 2021-05-01 00:00:00
796 | Tst | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  | 481.36 | £10 jan translation |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69.78510693 | 578.1699 | 647.95500693
840 | [NAME] | 2019-05-01 00:00:00 |  |  |  | N/A | No |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  | Month 2 | 2019-07-01 00:00:00 |  |  |  |  | Yes |  | May-July | 2019-08-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2019-10-01 00:00:00 |  |  |  |  | Yes | 46.09674447 | Aug - Oct |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-01-01 00:00:00 |  |  |  |  | Yes | 42.50837514 | Nov-Jan |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | Yes |  | Month 3 |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-07-01 00:00:00 |  |  |  |  | Yes | Month 3 | Month 3 |  |  |  |  |  |  |  |  |  |  | Month 1 |  |  |  |  |  |  |  |  |  |  | Month 2 |  |  |  |  | 46.6739658 | 396.694 | 443.3679658 |  | Yes | Month 6 | Nov to April |  |  |  |  |  |  |  |  |  | Month 1 | Month 1
901 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59.9018409 | 496.287 | 556.1888409 |  |  |  |  |  |  |  |  |  |  |  | No |  | Month 1 | Month 1
397 | Test | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19.98161946 | 165.5478 | 185.52941946 |  |  |  | Month 1
732 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29.07663 | 240.9 | 269.97663 | 10.11 |  | Month 1 | Month 1 |  |  |  |  |  |  |  |  |  | Month 2 | Month 2
899 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.78741516 | 130.7988 | 146.58621516
671 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-07-01 00:00:00 |  |  |  |  | Yes | Month 3 | Month 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45.46947635999999 | 376.7148 | 422.18427636
556 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  |  |  |  |  |  | Yes | 141.97061221 | Aug - Oct |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-03-01 00:00:00 |  |  |  |  | Yes |  | Jan-Feb |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | Yes |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  |  |  |  |  |  |  |  | Month 2 |  |  |  |  |  |  |  |  |  | Month 3 | Month 3 |  |  |  |  | 0.2903679900000001 | 2.4057 | 2.69606799
817 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 | 55.66149299000001 | 461.1557 | 516.8171929900001 | Yes |  |  |  |  |  |  | 2020-06-01 00:00:00 | 55.66149299000001 | 461.1557 | 516.8171929900001 | Yes |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  | Yes |  |  | Was paid June Amount! |  |  |  |  | 0 | 0 | 116.21 | Yes |  |  |  |  |  |  |  | 12.76543719 | 125.8117 | 138.57713719
897 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91.68100424999999 | 769.5774999999999 | 861.2585042499999 |  |  | Month 2 | Month 2 |  |  |  |  |  |  |  |  | Yes | Month 3 | Month 3
753 | [NAME] | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  | Month 1 | 2019-07-01 00:00:00 |  |  |  |  |  |  | June + July | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | Yes |  | Dec-Feb |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-05-01 00:00:00 |  |  |  |  | Yes |  | Month 3 |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  |  |  |  |  |  | No |  | Month 3 - pay next month |  |  |  |  |  |  |  |  | Yes | Month 4 | Month 4 |  |  |  |  | 124.38504342 | 1030.5306 | 1154.91564342 |  | Yes |  |  |  |  |  |  |  |  |  |  |  | Month 1 | Month 1
900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76.38829010999999 | 632.8772999999999 | 709.2655901099998 |  |  |  |  |  |  |  |  |  |  |  | No
717 | [NAME] | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-04-01 00:00:00 |  |  |  |  | Yes |  | Month 3 |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month 1 |  |  |  |  |  |  |  |  |  |  | Month 2 |  |  |  |  |  |  |  |  |  | Month 2 | March + April |  |  |  |  |  |  |  |  |  | Month 1 | Month 1
780 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
895 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Month 3 | Feb + March + April |  |  |  |  |  |  |  |  |  | Month 1 | Month 1
718 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
862 |  | 2019-05-01 00:00:00 |  |  |  | N/A | Yes |  |  | 2019-06-01 00:00:00 |  |  |  |  |  |  | Month 1 | 2019-07-01 00:00:00 |  |  |  |  |  |  | June + July | 2019-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-10-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-11-01 00:00:00 |  |  |  |  |  |  | N/A |  |  |  | 2019-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-02-01 00:00:00 |  |  |  |  | Yes |  | Jan-Feb |  |  |  | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  | Month 1 |  |  |  | 2020-06-01 00:00:00 |  |  |  |  |  |  | Month 2 |  |  |  | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay
 |  | 2019-05-01 00:00:00 | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  | 2019-06-01 00:00:00 | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  | 2019-07-01 00:00:00 | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total |  |  | Total to pay | Final pay
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Payment | Total | Holiday + Total | Accruals only |  | Total to pay |  |  |  |  |  | Holiday Payment | Total | Holiday + Total | Accruals only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total to pay
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55.66149299000001 | 461.1557 | 516.8171929900001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual pay:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August (for July work)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32.39607312 | 278.4016 | 310.79767312
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September (for August work)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.6275028 | 278.604 | 312.2315028